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 testTableExists() throws Exception { synchronized (con) { createTable(); assertTrue(DatabaseUtil.tableExists(con, "table1")); dropTable("table1", false); } }
public void testAddColumn() throws Exception { createTable(); fail("An exception should have been thrown"); } catch (IllegalArgumentException e) { fail("An exception should have been thrown"); } catch (IllegalArgumentException e) { assertTrue(DatabaseUtil.columnExists(con, "table1", "col1")); assertFalse(DatabaseUtil.columnExists(con, "table1", "col2")); DatabaseUtil.addColumn(con, "table1", "col2", DatabaseUtil.Type.integer); assertTrue(DatabaseUtil.columnExists(con, "table1", "col2")); DatabaseUtil.updateColumnValue(db, "table1", "col2", 2); DatabaseUtil.updateColumnValue(db, "table1", "col3", "bar"); dropTable("table1", false);
dropTable(tableName, true); expected.add(new Integer(10000)); assertEquals(expected, result); expected.add(new Long(10000)); assertEquals(expected, result); expected.add(new Integer((short) 10000)); assertEquals(expected, result); assertEquals(expected, result); assertEquals(expected, result); assertEquals(expected, result); assertEquals(expected, result); assertEquals(expected, result); assertEquals(expected, result); assertEquals(expected, result);
public void testGetTableNameTwo() throws Exception { ClassDescriptor cld = new ClassDescriptor("package.name.Array", null, false, new HashSet(), new HashSet(), new HashSet()); assertEquals("intermine_Array", DatabaseUtil.getTableName(cld)); }
public void testTableExistsNullConnection() throws Exception { try { DatabaseUtil.tableExists(null, "table1"); fail("Expected: NullPointerException"); } catch (NullPointerException e) { } }
protected void createTable() throws Exception { try { dropTable("table1", false); } catch (SQLException e) { } con.createStatement().execute("CREATE TABLE table1(col1 int)"); }
public void testGetIndirectionTableNameNull() throws Exception { CollectionDescriptor col1 = new CollectionDescriptor("col1", "package.name.Class2", null); Set cols = new HashSet(Arrays.asList(new Object[] {col1})); ClassDescriptor cld1 = new ClassDescriptor("package.name.Class1", null, false, new HashSet(), new HashSet(), cols); ClassDescriptor cld2 = new ClassDescriptor("package.name.Class2", null, false, new HashSet(), new HashSet(), new HashSet()); Set clds = new HashSet(Arrays.asList(new Object[] {cld1, cld2})); new Model("test", "package.name", clds); assertEquals("Class1Col1", DatabaseUtil.getIndirectionTableName(col1)); assertEquals("Col1", DatabaseUtil.getInwardIndirectionColumnName(col1, 0)); assertEquals("Class1", DatabaseUtil.getOutwardIndirectionColumnName(col1, 0)); assertEquals("Class1", DatabaseUtil.getInwardIndirectionColumnName(col1, 1)); assertEquals("Col1", DatabaseUtil.getOutwardIndirectionColumnName(col1, 1)); }
public void testTableExistsNullTable() throws Exception { try { DatabaseUtil.tableExists(con, null); fail("Expected: NullPointerException"); } catch (NullPointerException e) { } }
public void testTableNotExists() throws Exception { synchronized (con) { try { con.createStatement().execute("DROP TABLE table2"); } catch (SQLException e) { } createTable(); assertTrue(!(DatabaseUtil.tableExists(con, "table2"))); dropTable("table1", false); } }
public void testGetTableNameOne() throws Exception { ClassDescriptor cld = new ClassDescriptor("package.name.Class1", null, false, new HashSet(), new HashSet(), new HashSet()); assertEquals("Class1", DatabaseUtil.getTableName(cld)); }
public void testGetIndirectionTableNameRef() throws Exception { CollectionDescriptor col1 = new CollectionDescriptor("col1", "package.name.Class2", "ref1"); Set cols = new HashSet(Arrays.asList(new Object[] {col1})); ClassDescriptor cld1 = new ClassDescriptor("package.name.Class1", null, false, new HashSet(), new HashSet(), cols); ReferenceDescriptor ref1 = new ReferenceDescriptor("ref1", "package.name.Class1", null); Set refs = new HashSet(Arrays.asList(new Object[] {ref1})); ClassDescriptor cld2 = new ClassDescriptor("package.name.Class2", null, false, new HashSet(), refs, new HashSet()); Set clds = new HashSet(Arrays.asList(new Object[] {cld1, cld2})); new Model("test", "package.name", clds); try { DatabaseUtil.getIndirectionTableName(col1); fail("Expected IllegalArgumentException"); } catch (IllegalArgumentException e) { } }
public void testGetIndirectionTableNameCol() throws Exception { CollectionDescriptor col1 = new CollectionDescriptor("col1", "package.name.Class2", "col2"); Set cols = new HashSet(Arrays.asList(new Object[] {col1})); ClassDescriptor cld1 = new ClassDescriptor("package.name.Class1", null, false, new HashSet(), new HashSet(), cols); CollectionDescriptor col2 = new CollectionDescriptor("col2", "package.name.Class1", "col1"); cols = new HashSet(Arrays.asList(new Object[] {col2})); ClassDescriptor cld2 = new ClassDescriptor("package.name.Class2", null, false, new HashSet(), new HashSet(), cols); Set clds = new HashSet(Arrays.asList(new Object[] {cld1, cld2})); new Model("test", "package.name", clds); assertEquals("Col1Col2", DatabaseUtil.getIndirectionTableName(col1)); assertEquals("Col1", DatabaseUtil.getInwardIndirectionColumnName(col1, 0)); assertEquals("Col2", DatabaseUtil.getOutwardIndirectionColumnName(col1, 0)); assertEquals("Col2", DatabaseUtil.getInwardIndirectionColumnName(col1, 1)); assertEquals("Col1", DatabaseUtil.getOutwardIndirectionColumnName(col1, 1)); }
public void testGetColumnName() throws Exception { FieldDescriptor attr = new AttributeDescriptor("attr1", "int"); assertEquals(DatabaseUtil.generateSqlCompatibleName("attr1"), DatabaseUtil.getColumnName(attr)); }