@Before
public void setupAvailableDatabases() throws Exception {
for (Database database : TestContext.getInstance().getAvailableDatabases()) {
if (generateTestStatement().supportsDatabase(database)) {
if (database.supportsSchemas()) {
database.dropDatabaseObjects(TestContext.ALT_SCHEMA);
}
database.dropDatabaseObjects(null);
setupDatabase(database);
}
}
}
@Test
public void testAlterSequenceDatabase() throws Exception {
for (Database database : TestContext.getInstance().getAllDatabases()) {
if (database instanceof OracleDatabase) {
AlterSequenceStatement statement =
new AlterSequenceStatement(CATALOG_NAME, SCHEMA_NAME, SEQUENCE_NAME);
statement.setCacheSize(BigInteger.valueOf(3000L));
Sql[] generatedSql = this.generatorUnderTest.generateSql(statement, database, null);
assertEquals(
"ALTER SEQUENCE CATALOG_NAME.SEQUENCE_NAME CACHE 3000", generatedSql[0].toSql());
}
}
}