@Test(expected = IllegalArgumentException.class) public void updateSetWhereMultiple_missingValues_throwsException() { /* When */ update("my_table") .set("a", "b") .values(1) .where("c=? OR c=?", 3, 4); } }
@Test public void updateSetWhere() { /* When */ update("my_table") .set("a") .values(1) .where("b=?", 2) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("UPDATE my_table SET a=? WHERE b=?", 1, 2); }
@Test public void updateSetWhereMultiple() { /* When */ update("my_table") .set("a", "b") .values(1, 2) .where("c=? OR c=?", 3, 4) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("UPDATE my_table SET a=?,b=? WHERE c=? OR c=?", 1, 2, 3, 4); }