@Test
public void testGetTables_SingleTableAliased() throws SqlResourceException {
final SqlResource sqlResource = Factory.getSqlResource("SingleTableAliased");
assertEquals(1, sqlResource.getTables().size());
final TableMetaData table = sqlResource.getTables().get(getQualifiedTableName("film"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("film", table.getTableName());
assertEquals("movie", table.getTableAlias());
// Pks
assertEquals(1, table.getPrimaryKeys().size());
assertEquals("film_id", table.getPrimaryKeys().get(0).getColumnName());
// Columns
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 1, true, "sakila", "film", "film_id", "id", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 2, false, "sakila", "film", "title", "title", Types.VARCHAR);
AssertionHelper.assertColumnMetaData(
table.getColumns(),
3,
false,
"sakila",
"film",
"release_year",
"year",
(getDatabaseType() == DatabaseType.PostgreSql) ? Types.INTEGER : Types.DATE);
}
@Test
public void testGetTables_SingleTable() throws SqlResourceException {
final SqlResource sqlResource = Factory.getSqlResource("SingleTable");
assertEquals(1, sqlResource.getTables().size());
final TableMetaData table = sqlResource.getTables().get(getQualifiedTableName("actor"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("actor", table.getTableName());
// Pks
assertEquals(1, table.getPrimaryKeys().size());
AssertionHelper.assertColumnMetaData(
table.getPrimaryKeys().get(0),
1,
true,
"sakila",
"actor",
"actor_id",
"id",
Types.SMALLINT);
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 1, true, "sakila", "actor", "actor_id", "id", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 2, false, "sakila", "actor", "first_name", "first_name", Types.VARCHAR);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 3, false, "sakila", "actor", "last_name", "surname", Types.VARCHAR);
}
@Test
public void testGetTables_MultiPK() throws SqlResourceException {
final SqlResource sqlResource = Factory.getSqlResource("SingleTable_MultiPK");
assertEquals(1, sqlResource.getTables().size());
final TableMetaData table = sqlResource.getTables().get(getQualifiedTableName("film_actor"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("film_actor", table.getTableName());
// Pks
assertEquals(2, table.getPrimaryKeys().size());
assertEquals("actor_id", table.getPrimaryKeys().get(0).getColumnName());
assertEquals("film_id", table.getPrimaryKeys().get(1).getColumnName());
// Columns
assertEquals(2, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 1, true, "sakila", "film_actor", "actor_id", "actorId", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 2, true, "sakila", "film_actor", "film_id", "film_id", Types.SMALLINT);
}
@Test
public void testGetTables_SingleTableSub() throws SqlResourceException {
SqlResource sqlResource = Factory.getSqlResource("sub.SingleTable");
assertEquals(1, sqlResource.getTables().size());
TableMetaData table = sqlResource.getTables().get(getQualifiedTableName("film"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("film", table.getTableName());
assertEquals("pelicula", table.getTableAlias());
sqlResource = Factory.getSqlResource("sub.sub.SingleTable");
assertEquals(1, sqlResource.getTables().size());
table = sqlResource.getTables().get(getQualifiedTableName("language"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("language", table.getTableName());
assertEquals("language", table.getTableAlias());
}
@Test
public void testGetTables_HierManyToManyExt() throws SqlResourceException {
final SqlResource sqlResource = Factory.getSqlResource("HierManyToManyExt");
SqlResourceMetaData metaData = ((SqlResourceImpl) sqlResource).getMetaData();
assertTrue(sqlResource.isHierarchical());
assertEquals(5, sqlResource.getTables().size());
// Parent table
TableMetaData table = sqlResource.getParentTable();
assertNotNull(table);
assertNotNull(sqlResource.getTables().get(getQualifiedTableName("actor")));
assertEquals(getQualifiedTableName("actor"), table.getQualifiedTableName());
assertEquals(TableRole.Parent, table.getTableRole());
// Parent primary keys
assertEquals(1, table.getPrimaryKeys().size());
AssertionHelper.assertColumnMetaData(
table.getPrimaryKeys().get(0),
1,
true,
"sakila",
"actor",
"actor_id",
"actor_id",
Types.SMALLINT);
// Parent columns
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 1, true, "sakila", "actor", "actor_id", "actor_id", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 2, false, "sakila", "actor", "first_name", "first_name", Types.VARCHAR);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 3, false, "sakila", "actor", "last_name", "last_name", Types.VARCHAR);
// Parent extension
table = sqlResource.getTables().get(getQualifiedTableName("actor_genre"));
assertNotNull(table);
assertEquals(TableRole.ParentExtension, table.getTableRole());
// Parent extension primary keys
assertEquals(0, table.getPrimaryKeys().size());
// Parent extension columns
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(),
4,
false,
"sakila",
"actor_genre",
"actor_genre_id",
"actor_genre_id",
Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(),
0,
false,
"sakila",
"actor_genre",
"actor_id",
"actor_id",
Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 5, false, "sakila", "actor_genre", "name", "name", Types.VARCHAR);
// Child table
table = sqlResource.getChildTable();
assertNotNull(table);
assertNotNull(sqlResource.getTables().get(getQualifiedTableName("film")));
assertEquals(getQualifiedTableName("film"), table.getQualifiedTableName());
assertEquals(TableRole.Child, table.getTableRole());
// Child primary keys
AssertionHelper.assertColumnMetaData(
table.getPrimaryKeys().get(0),
6,
true,
"sakila",
"film",
"film_id",
"film_id",
Types.SMALLINT);
// Child columns
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 6, true, "sakila", "film", "film_id", "film_id", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 7, false, "sakila", "film", "title", "title", Types.VARCHAR);
AssertionHelper.assertColumnMetaData(
table.getColumns(),
8,
false,
"sakila",
"film",
"release_year",
"year",
(getDatabaseType() == DatabaseType.PostgreSql) ? Types.INTEGER : Types.DATE);
// Child extension
table = sqlResource.getTables().get(getQualifiedTableName("film_rating"));
assertNotNull(table);
assertEquals(TableRole.ChildExtension, table.getTableRole());
// Child extension primary keys
assertEquals(1, table.getPrimaryKeys().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(),
9,
true,
"sakila",
"film_rating",
"film_rating_id",
"film_rating_id",
Types.SMALLINT);
// Child extension columns
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(),
9,
true,
"sakila",
"film_rating",
"film_rating_id",
"film_rating_id",
Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(),
0,
false,
"sakila",
"film_rating",
"film_id",
"film_id",
Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 10, false, "sakila", "film_rating", "stars", "stars", Types.SMALLINT);
// Join table
table = metaData.getJoin();
assertNotNull(table);
assertNotNull(sqlResource.getTables().get(getQualifiedTableName("film_actor")));
assertEquals(getQualifiedTableName("film_actor"), table.getQualifiedTableName());
assertEquals(TableRole.Join, table.getTableRole());
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 0, false, "sakila", "film_actor", "film_id", "film_id", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(),
0,
false,
"sakila",
"film_actor",
"actor_id",
"actor_id",
Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(),
0,
false,
"sakila",
"film_actor",
"last_update",
"last_update",
(getDatabaseType() == DatabaseType.PostgreSql) ? Types.NULL : Types.TIMESTAMP);
// Special read column lists
assertEquals(10, metaData.getAllReadColumns().size());
assertEquals("actor_id", metaData.getAllReadColumns().get(0).getColumnLabel());
assertEquals("first_name", metaData.getAllReadColumns().get(1).getColumnLabel());
assertEquals("last_name", metaData.getAllReadColumns().get(2).getColumnLabel());
assertEquals("actor_genre_id", metaData.getAllReadColumns().get(3).getColumnLabel());
assertEquals("name", metaData.getAllReadColumns().get(4).getColumnLabel());
assertEquals("film_id", metaData.getAllReadColumns().get(5).getColumnLabel());
assertEquals("title", metaData.getAllReadColumns().get(6).getColumnLabel());
assertEquals("year", metaData.getAllReadColumns().get(7).getColumnLabel());
assertEquals("film_rating_id", metaData.getAllReadColumns().get(8).getColumnLabel());
assertEquals("stars", metaData.getAllReadColumns().get(9).getColumnLabel());
assertEquals(5, metaData.getParentReadColumns().size());
assertEquals("actor_id", metaData.getParentReadColumns().get(0).getColumnLabel());
assertEquals("first_name", metaData.getParentReadColumns().get(1).getColumnLabel());
assertEquals("last_name", metaData.getParentReadColumns().get(2).getColumnLabel());
assertEquals("actor_genre_id", metaData.getParentReadColumns().get(3).getColumnLabel());
assertEquals("name", metaData.getParentReadColumns().get(4).getColumnLabel());
assertEquals(5, metaData.getChildReadColumns().size());
assertEquals("film_id", metaData.getChildReadColumns().get(0).getColumnLabel());
assertEquals("title", metaData.getChildReadColumns().get(1).getColumnLabel());
assertEquals("year", metaData.getChildReadColumns().get(2).getColumnLabel());
assertEquals("film_rating_id", metaData.getChildReadColumns().get(3).getColumnLabel());
assertEquals("stars", metaData.getChildReadColumns().get(4).getColumnLabel());
}
@Test
public void testGetTables_HierManyToMany() throws SqlResourceException {
final SqlResource sqlResource = Factory.getSqlResource("HierManyToMany");
assertEquals(3, sqlResource.getTables().size());
TableMetaData table = sqlResource.getTables().get(getQualifiedTableName("actor"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("actor", table.getTableName());
// Pks
assertEquals(1, table.getPrimaryKeys().size());
assertEquals("actor_id", table.getPrimaryKeys().get(0).getColumnName());
// Columns
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 1, true, "sakila", "actor", "actor_id", "actor_id", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 2, false, "sakila", "actor", "first_name", "first_name", Types.VARCHAR);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 3, false, "sakila", "actor", "last_name", "last_name", Types.VARCHAR);
// Child table
table = sqlResource.getTables().get(getQualifiedTableName("film"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("film", table.getTableName());
// Pks
assertEquals(1, table.getPrimaryKeys().size());
assertEquals("film_id", table.getPrimaryKeys().get(0).getColumnName());
// Columns
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 4, true, "sakila", "film", "film_id", "film_id", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 5, false, "sakila", "film", "title", "title", Types.VARCHAR);
AssertionHelper.assertColumnMetaData(
table.getColumns(),
6,
false,
"sakila",
"film",
"release_year",
"year",
(getDatabaseType() == DatabaseType.PostgreSql) ? Types.INTEGER : Types.DATE);
// // Join table
// table = sqlResource.getTables().get(getQualifiedTableName("film_actor"));
// assertNotNull(table);
// assertEquals("sakila", table.getDatabaseName());
// assertEquals("film_actor", table.getTableName());
//
// // Pks
// assertEquals(2, table.getPrimaryKeys().size());
// assertEquals("actor_id", table.getPrimaryKeys().get(0).getColumnName());
// assertEquals("film_id", table.getPrimaryKeys().get(1).getColumnName());
//
// // Columns
// assertEquals(2, table.getColumns().size());
// AssertionHelper.assertColumnMetaData(table.getColumns(), 7, true, "sakila", "film_actor",
// "film_id",
// "film_id", Types.SMALLINT);
// AssertionHelper.assertColumnMetaData(table.getColumns(), 0, true, "sakila", "film_actor",
// "actor_id",
// "actor_id", "smallint(5) unsigned");
// assertTrue(table.getColumns().get("actor_id").isNonqueriedForeignKey());
}
@Test
public void testGetTables_FlatManyToOne() throws SqlResourceException {
final SqlResource sqlResource = Factory.getSqlResource("FlatManyToOne");
// Parent table
assertEquals(2, sqlResource.getTables().size());
TableMetaData table = sqlResource.getTables().get(getQualifiedTableName("film"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("film", table.getTableName());
assertEquals(1, table.getPrimaryKeys().size());
// Primary keys
AssertionHelper.assertColumnMetaData(
table.getPrimaryKeys().get(0),
1,
true,
"sakila",
"film",
"film_id",
"film_id",
Types.SMALLINT);
// Columns
assertEquals(3, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(), 1, true, "sakila", "film", "film_id", "film_id", Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 2, false, "sakila", "film", "title", "title", Types.VARCHAR);
AssertionHelper.assertColumnMetaData(
table.getColumns(),
3,
false,
"sakila",
"film",
"release_year",
"year",
(getDatabaseType() == DatabaseType.PostgreSql) ? Types.INTEGER : Types.DATE);
// Child table
table = sqlResource.getTables().get(getQualifiedTableName("language"));
assertNotNull(table);
assertEquals("sakila", table.getDatabaseName());
assertEquals("language", table.getTableName());
// Pks
assertEquals(1, table.getPrimaryKeys().size());
AssertionHelper.assertColumnMetaData(
table.getPrimaryKeys().get(0),
4,
true,
"sakila",
"language",
"language_id",
"language_id",
Types.SMALLINT);
// Columns
assertEquals(2, table.getColumns().size());
AssertionHelper.assertColumnMetaData(
table.getColumns(),
4,
true,
"sakila",
"language",
"language_id",
"language_id",
Types.SMALLINT);
AssertionHelper.assertColumnMetaData(
table.getColumns(), 5, false, "sakila", "language", "name", "name", Types.VARCHAR);
}