@Test(expected = IllegalArgumentException.class) public void insertIntoColumnsValues_withDifferentNumberOfValues_throwsException() { insert() .into("my_table") .columns("a", "b", "c") .values(1, 2); } }
@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"); } }