@Test public void selectStar() { /* When */ select() .from("my_table") .executeOn(getStatementExecutor()); /* Then */ verifySelectStatementExecuted("SELECT * FROM my_table"); }
@Test public void selectColumns() { /* When */ select("a", "b") .from("my_table") .executeOn(getStatementExecutor()); /* Then */ verifySelectStatementExecuted("SELECT a,b FROM my_table"); }
@Test public void selectFromWhereGroupByOrderByLimit() { /* When */ select("a", "b") .from("my_table") .where("a=? AND b=?", 1, 2) .groupBy("a") .orderBy("a", "b") .limit(5) .executeOn(getStatementExecutor()); /* Then */ verifySelectStatementExecuted("SELECT a,b FROM my_table WHERE a=? AND b=? GROUP BY a ORDER BY a,b LIMIT 5", 1, 2); } }