@Test public void columnLookup(final TestContext testContext, final Connection connection) throws Exception { final SchemaCrawlerOptions schemaCrawlerOptions = SchemaCrawlerOptionsBuilder .newSchemaCrawlerOptions(); final Catalog catalog = getCatalog(connection, schemaCrawlerOptions); assertThat(catalog, notNullValue()); final Schema schema = catalog.lookupSchema("PUBLIC.BOOKS").get(); assertThat(schema, notNullValue()); final Table table = catalog.lookupTable(schema, "AUTHORS").get(); assertThat(table, notNullValue()); assertThat(table.lookupColumn(null), is(emptyOptional())); assertThat(table.lookupColumn(""), is(emptyOptional())); assertThat(table.lookupColumn("NO_COLUMN"), is(emptyOptional())); assertThat(table.lookupColumn("ID"), is(not(emptyOptional()))); }
private void assertReferencedColumnExists(final Catalog catalog, final Column column) { assertThat(column, notNullValue()); final Table table = column.getParent(); assertThat("Table references do not match - " + table.getName(), table == catalog.lookupTable(table.getSchema(), table.getName()) .get()); assertThat("Column references do not match", column == table.lookupColumn(column.getName()).get()); }
.lookupColumn(columnName); if (columnOptional.isPresent())
.lookupColumn(columnName); if (columnOptional.isPresent())
emptyOptional()); assertThat("Column references do not match", column == table.lookupColumn(column.getName()).get(), is(true));
.lookupColumn(columnName); if (columnOptional.isPresent())
.lookupColumn(columnName); if (columnOptional.isPresent())