@Test public void insertOrAbortIntoValues() { /* When */ insertOrAbort() .into("my_database", "my_table") .values(1, 2, 3) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("INSERT OR ABORT INTO my_database.my_table VALUES (?,?,?)", 1, 2, 3); }
@Test public void insertOrFailIntoValues() { /* When */ insertOrFail() .into("my_table") .values(1, 2, 3) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("INSERT OR FAIL INTO my_table VALUES (?,?,?)", 1, 2, 3); }
@Test public void insertIntoColumnsValues() { /* When */ insert() .into("my_table") .columns("a", "b", "c") .values(1, 2, 3) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("INSERT INTO my_table (a,b,c) VALUES (?,?,?)", 1, 2, 3); }
@Test public void insertOrRollbackIntoColumnsValues() { /* When */ insertOrRollback() .into("my_table") .columns("a", "b", "c") .values(1, 2, 3) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("INSERT OR ROLLBACK INTO my_table (a,b,c) VALUES (?,?,?)", 1, 2, 3); }
@Test public void insertOrIgnoreIntoColumnsValues() { /* When */ insertOrIgnore() .into("my_table") .columns("a", "b", "c") .values(1, 2, 3) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("INSERT OR IGNORE INTO my_table (a,b,c) VALUES (?,?,?)", 1, 2, 3); }
@Test public void insertOrReplaceIntoColumnsValues() { /* When */ insertOrReplace() .into("my_table") .columns("a", "b", "c") .values(1, 2, 3) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("INSERT OR REPLACE INTO my_table (a,b,c) VALUES (?,?,?)", 1, 2, 3); }
@Test public void replaceIntoDatabaseTable() { /* When */ replace() .into("my_database", "my_table") .columns("a", "b") .values(1, "test") .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("REPLACE INTO my_database.my_table (a,b) VALUES (?,?)", 1, "test"); } }