@Test public void as_returnsNotNullValue() { /* Given */ CreateTableImpl createTable = new CreateTableImpl(null, "table", mock(SqlPart.class)); /* When */ As result = createTable.as(select("a", "b").from("my_other_table")); /* Then */ assertThat(result, is(notNullValue())); } }
@Test public void prependTo_prependsProperSql() { /* Given */ AsImpl as = new AsImpl(select().from("my_table"), mock(SqlPart.class)); RawSqlBuilder builder = new RawSqlBuilderImpl(); /* When */ as.prependTo(builder); /* Then */ assertThat(builder.toString(), is("AS SELECT * FROM my_table")); }
@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 createTableAs() { /* When */ create() .table("my_table") .as( select("a", "b") .from("my_other_table") ) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TABLE my_table AS SELECT a,b FROM my_other_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); } }