@Test public void triggers(final TestContext testContext, final Connection connection) throws Exception { final Config config = loadHsqldbConfig(); final SchemaRetrievalOptions schemaRetrievalOptions = SchemaRetrievalOptionsBuilder .newSchemaRetrievalOptions(config); final SchemaCrawlerOptions schemaCrawlerOptions = DatabaseTestUtility.schemaCrawlerOptionsWithMaximumSchemaInfoLevel; final Catalog catalog = getCatalog(connection, schemaRetrievalOptions, schemaCrawlerOptions); final Schema schema = new SchemaReference("PUBLIC", "BOOKS"); final Table[] tables = catalog.getTables(schema).toArray(new Table[0]); boolean foundTrigger = false; for (final Table table: tables) { for (final Trigger trigger: table.getTriggers()) { foundTrigger = true; assertThat("Triggers full name does not match", trigger.getFullName(), is("PUBLIC.BOOKS.AUTHORS.TRG_AUTHORS")); assertThat("Trigger EventManipulationType does not match", trigger.getEventManipulationType(), is(EventManipulationType.delete)); } } assertThat("No triggers found", foundTrigger, is(true)); }
table2.addForeignKey((MutableForeignKey) fk); for (final Trigger trigger: table0.getTriggers())
for (final Trigger trigger: table.getTriggers())
for (final Trigger trigger: table.getTriggers())
jsonTable.put("triggers", handleTriggers(table.getTriggers()));
printTriggers(table.getTriggers()); printTableConstraints(table.getTableConstraints());
printTriggers(table.getTriggers()); printTableConstraints(table.getTableConstraints()); if (isVerbose)
for (final Trigger trigger: table.getTriggers())
for (final Trigger trigger: table.getTriggers())
for (final Trigger trigger: table.getTriggers())
jsonTable.put("triggers", handleTriggers(table.getTriggers()));
jsonTable.put("triggers", handleTriggers(table.getTriggers()));
jsonTable.put("triggers", handleTriggers(table.getTriggers()));
printTriggers(table.getTriggers()); printTableConstraints(table.getTableConstraints());
printTriggers(table.getTriggers()); printTableConstraints(table.getTableConstraints());