@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 createTableWithThreeColumns() { /* When */ create() .table("my_table") .columns( column("a"), column("b"), column("c") ) .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TABLE my_table (a,b,c)"); }
@Test public void createTableWithThreeColumnsWithoutRowId() { /* When */ create() .table("my_table") .columns( column("a"), column("b"), column("c") ) .withoutRowId() .executeOn(getStatementExecutor()); /* Then */ verifyStatementExecuted("CREATE TABLE my_table (a,b,c) WITHOUT ROWID"); }
@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"); }