public void testTableExistsNullConnection() throws Exception { try { DatabaseUtil.tableExists(null, "table1"); fail("Expected: NullPointerException"); } catch (NullPointerException e) { } }
public void testConfigure() throws Exception { Database db1 = DatabaseFactory.getDatabase("db.unittest"); Database db2 = DatabaseFactory.getDatabase("db.unittest"); // These should be exactly the same object assertTrue(db1 == db2); }
public void testConfigure() throws Exception { Database db = new Database(); db.configure(props); assertTrue(db.getDataSource() != null); assertTrue(db.getDataSource() instanceof PGPoolingDataSource); assertEquals("PostgreSQL", db.getPlatform()); assertEquals("dbserver.mydomain.org", ((PGPoolingDataSource) db.getDataSource()).getServerName()); assertEquals("test", ((PGPoolingDataSource) db.getDataSource()).getDatabaseName()); assertEquals(10, ((PGPoolingDataSource) db.getDataSource()).getMaxConnections()); }
public void testTableExists() throws Exception { synchronized (con) { createTable(); assertTrue(DatabaseUtil.tableExists(con, "table1")); dropTable("table1", false); } }
protected Database getDatabase() throws Exception { if (database == null) { database = DatabaseFactory.getDatabase("db.unittest"); } return database; }
public void testNullName() throws Exception { try { DatabaseFactory.getDatabase(null); fail("Expected: NullPointerException"); } catch (NullPointerException e) { } }
public void testURL() throws Exception { Database db = new Database(props); assertEquals("jdbc:postgresql://dbserver.mydomain.org/test", db.getURL()); }
public void testPassword() throws Exception { Database db = new Database(props); assertEquals("secret", db.getPassword()); }
public void testUser() throws Exception { Database db = new Database(props); assertEquals("auser", db.getUser()); }
public void testGenerateSqlCompatibleName() throws Exception { assertEquals("intermine_end", DatabaseUtil.generateSqlCompatibleName("end")); assertEquals("intermine_intermine_end", DatabaseUtil.generateSqlCompatibleName("intermine_end")); assertEquals("id", DatabaseUtil.generateSqlCompatibleName("id")); assertEquals("index", DatabaseUtil.generateSqlCompatibleName("index")); assertEquals("intermine_order", DatabaseUtil.generateSqlCompatibleName("order")); assertEquals("intermine_full", DatabaseUtil.generateSqlCompatibleName("full")); assertEquals("intermine_offset", DatabaseUtil.generateSqlCompatibleName("offset")); assertEquals("some_string", DatabaseUtil.generateSqlCompatibleName("some_string")); try { DatabaseUtil.generateSqlCompatibleName(null); fail("Expected NullPointerException"); } catch (NullPointerException e) { } }
public void testColumnNameLegality() { assertFalse(DatabaseUtil.isLegalColumnName(null)); assertFalse(DatabaseUtil.isLegalColumnName("")); assertFalse(DatabaseUtil.isLegalColumnName("FOO")); assertFalse(DatabaseUtil.isLegalColumnName("foo!")); assertFalse(DatabaseUtil.isLegalColumnName("foo; drop table userprofile;")); assertTrue(DatabaseUtil.isLegalColumnName("foo")); assertTrue(DatabaseUtil.isLegalColumnName("foo123")); assertTrue(DatabaseUtil.isLegalColumnName("foo_bar")); assertTrue(DatabaseUtil.isLegalColumnName("foo_bar_123")); }
public void testEqualsSingleRowDifferentColumns() throws Exception { try { assertEquals(mrs1, mrs4); failed = true; } catch (AssertionFailedError e) { } finally { if (failed) { fail("mrs1 and mrs4 should not be equal"); } } }
/** * Asserts that two ResultSets are equal * * @param rs1 the first ResultSet * @param rs2 the second ResultSet */ protected void assertEquals(ResultSet rs1, ResultSet rs2) { assertEquals(null, rs1, rs2); }
public PrecomputedTableTest(String arg1) { super(arg1); try { database = DatabaseFactory.getDatabase("db.unittest"); } catch (Exception e) { } }
public void testTableExistsNullTable() throws Exception { try { DatabaseUtil.tableExists(con, null); fail("Expected: NullPointerException"); } catch (NullPointerException e) { } }
public void testInvalidDataSourceClass() throws Exception { Properties invalidProps = new Properties(); invalidProps.put("datasource.class", "org.class.that.cannot.be.Found"); try { Database db = new Database(invalidProps); fail("Expected: ClassNotFoundException"); } catch (ClassNotFoundException e) { } }
public void testEqualsMultiRowDifferentData() throws Exception { try { assertEquals(mrs11, mrs13); failed=true; } catch (AssertionFailedError e) { } finally { if (failed) { fail("mrs11 and mrs13 should not be equal"); } } }
public QueryOptimiserTest(String arg1) { super(arg1); try { database = DatabaseFactory.getDatabase("db.unittest"); } catch (Exception e) { } }
@Override public void setUp() throws Exception { db = DatabaseFactory.getDatabase("db.unittest"); }