@Test public void analyzeDatabaseAndTable() { /* When */ analyze() .databaseAndTableOrIndex("database", "table") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("ANALYZE database.table"); } }
@Test public void endTransaction() { /* When */ end().transaction() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("END TRANSACTION"); } }
@Test public void commitTransaction() { /* When */ commit().transaction().executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("COMMIT TRANSACTION"); } }
@Test public void beginTransaction() { /* When */ begin().transaction().executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("BEGIN TRANSACTION"); }
@Test public void beginExclusiveTransaction() { /* When */ begin().exclusive().transaction().executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("BEGIN EXCLUSIVE TRANSACTION"); }
@Test public void beginImmediateTransaction() { /* When */ begin().immediate().transaction().executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("BEGIN IMMEDIATE TRANSACTION"); } }
@Test public void beginDeferredTransaction() { /* When */ begin().deferred().transaction().executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("BEGIN DEFERRED TRANSACTION"); }
@Test public void rollbackToSavepoint() { /* When */ rollback().to().savePoint("savepointname") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("ROLLBACK TO SAVEPOINT savepointname"); }
@Test public void alterRenameTo() { /* When */ alter() .table("database", "table") .renameTo("newTableName") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("ALTER TABLE database.table RENAME TO newTableName"); }
@Test public void rollbackTransactionToSavepoint() { /* When */ rollback().transaction().to().savePoint("savepointname") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("ROLLBACK TRANSACTION TO SAVEPOINT savepointname"); } }
@Test public void alterAddColumn() { /* When */ alter() .table("database", "table") .add( column("new_column") ) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("ALTER TABLE database.table ADD COLUMN new_column"); } }
@Test public void createTableWithThreeColumnsWithoutRowId() { /* When */ create() .table("my_table") .columns( column("a"), column("b"), column("c") ) .withoutRowId() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TABLE my_table (a,b,c) WITHOUT ROWID"); }
@Test public void createTableIfNotExistsWithThreeColumnsWithoutRowId() { /* When */ create() .tableIfNotExists("my_table") .columns( column("a"), column("b"), column("c") ) .withoutRowId() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TABLE IF NOT EXISTS my_table (a,b,c) WITHOUT ROWID"); }
@Test public void createTempTableWithThreeColumnsWithoutRowId() { /* When */ create() .temp() .table("my_table") .columns( column("a"), column("b"), column("c") ) .withoutRowId() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TEMPORARY TABLE my_table (a,b,c) WITHOUT ROWID"); }
@Test public void createTempTableIfNotExistsWithThreeColumnsWithoutRowId() { /* When */ create() .temp() .tableIfNotExists("my_table") .columns( column("a"), column("b"), column("c") ) .withoutRowId() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TEMPORARY TABLE IF NOT EXISTS my_table (a,b,c) WITHOUT ROWID"); }