@Test public void alter_returnsAlter() { assertThat(Statements.alter(), is(notNullValue())); } }
TestStatementExecutor(@NotNull final DummyDatabase database) { mDatabase = database; mStatementConverter = Statements.converter(); }
@Test public void beginTransaction() { /* When */ begin().transaction().executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("BEGIN TRANSACTION"); }
@Test public void deleteFromTable() { /* When */ delete() .from("my_table") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("DELETE FROM my_table"); }
@Test public void dropTable() { /* When */ drop() .table("my_table") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("DROP TABLE my_table"); }
@Test public void prependToWithMultipleColumns_prependsProperSql() { /* Given */ Column[] cs = {column("a"), column("b"), column("c")}; ColumnsImpl columns = new ColumnsImpl(cs, mock(SqlPart.class)); RawSqlBuilder builder = new RawSqlBuilderImpl(); /* When */ columns.prependTo(builder); /* Then */ assertThat(builder.toString(), is("(a,b,c)")); }
@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 analyzeDatabaseAndTable() { /* When */ analyze() .databaseAndTableOrIndex("database", "table") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("ANALYZE database.table"); } }
@Test public void beginExclusiveTransaction() { /* When */ begin().exclusive().transaction().executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("BEGIN EXCLUSIVE TRANSACTION"); }
@Test public void deleteFromDatabaseTable() { /* When */ delete() .from("my_database", "my_table") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("DELETE FROM my_database.my_table"); }
@Test public void dropTableIfExists() { /* When */ drop() .tableIfExists("my_database", "my_table") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("DROP TABLE IF EXISTS my_database.my_table"); } }
@Test public void beginImmediateTransaction() { /* When */ begin().immediate().transaction().executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("BEGIN IMMEDIATE TRANSACTION"); } }
@Test public void deleteFromTableWhere() { /* When */ delete() .from("my_table") .where("a=? AND b=?", 1, 2) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("DELETE FROM my_table WHERE a=? AND b=?", 1, 2); } }
@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 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"); }