@Test public void prependToWithMultipleColumns_prependsProperSql() { /* Given */ Column[] cs = {column("a"), column("b"), column("c")}; ColumnsImpl columns = new ColumnsImpl(cs, mock(SqlPart.class)); RawSqlBuilder builder = new RawSqlBuilderImpl(); /* When */ columns.prependTo(builder); /* Then */ assertThat(builder.toString(), is("(a,b,c)")); }
@Test public void createTableIfNotExistsWithThreeColumnsWithoutRowId() { /* When */ create() .tableIfNotExists("my_table") .columns( column("a"), column("b"), column("c") ) .withoutRowId() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TABLE IF NOT EXISTS my_table (a,b,c) WITHOUT ROWID"); }
@Test public void createTempTableWithThreeColumnsWithoutRowId() { /* When */ create() .temp() .table("my_table") .columns( column("a"), column("b"), column("c") ) .withoutRowId() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TEMPORARY TABLE my_table (a,b,c) WITHOUT ROWID"); }
@Test public void createTempTableIfNotExistsWithThreeColumnsWithoutRowId() { /* When */ create() .temp() .tableIfNotExists("my_table") .columns( column("a"), column("b"), column("c") ) .withoutRowId() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TEMPORARY TABLE IF NOT EXISTS my_table (a,b,c) WITHOUT ROWID"); }
@Test public void alterAddColumn() { /* When */ alter() .table("database", "table") .add( column("new_column") ) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("ALTER TABLE database.table ADD COLUMN new_column"); } }