SqlRealmTest.java

/***************************************************************************
   Copyright 2015 Emily Estes

   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
***************************************************************************/
package net.metanotion.sqlauthident;


import java.sql.Connection;
import java.sql.DriverManager;
import javax.sql.DataSource;

import net.metanotion.authident.ApiTest;
import net.metanotion.sql.DbUtil;
import net.metanotion.sql.SchemaPoolSwitcher;

public final class SqlRealmTest {
	public static final int ARGS_URL = 0;
	public static final int ARGS_DBNAME = 1;
	public static final int ARGS_USER = 2;
	public static final int ARGS_PASS = 3;

	public static final String TEST_DB1 = "sqlrealm_test1";
	public static final String TEST_DB2 = "sqlrealm_test2";

	public static void main(final String[] args) throws Exception {
		final String url = args[ARGS_URL];
		final String dbName = args[ARGS_DBNAME];
		final String user = args[ARGS_USER];
		final String pass = args[ARGS_PASS];
		try (final Connection conn = DriverManager.getConnection(url, user, pass)) {
			DbUtil.createDatabase(conn, dbName, user, true);
		}

		final DataSource ds = DbUtil.startDBConnectionPool(url + dbName, user, pass);

		final DataSource ds1 = new SchemaPoolSwitcher(ds, TEST_DB1);
		try (final Connection conn = ds.getConnection()) {
			DbUtil.createSchema(conn, TEST_DB1, true);
			DbUtil.setSearchPath(conn, TEST_DB1);
			DbUtil.runSchema(conn, SQLRealm.schemaFactory());
		}

		final DataSource ds2 = new SchemaPoolSwitcher(ds, TEST_DB2);
		try (final Connection conn = ds.getConnection()) {
			DbUtil.createSchema(conn, TEST_DB2, true);
			DbUtil.setSearchPath(conn, TEST_DB2);
			DbUtil.runSchema(conn, SQLRealm.schemaFactory());
		}

		final SQLRealm realm = new SQLRealm(ds1);
		ApiTest.testRealm(realm);

		final SQLRealm pw = new SQLRealm(ds2);
		ApiTest.testAuthPassword(pw, pw.getAuthPassword());
	}
}