@NotNull @Override public CreateTable table(@Nullable final String databaseName, @NotNull final String tableName) { return new CreateTableImpl(databaseName, tableName, this); }
@Test public void prependTo_withDatabaseAndTableName_prependsProperSql() { /* Given */ CreateTableImpl createTable = new CreateTableImpl("database", "table", mock(SqlPart.class)); RawSqlBuilder builder = new RawSqlBuilderImpl(); /* When */ createTable.prependTo(builder); /* Then */ assertThat(builder.toString(), is("TABLE database.table")); }
@Test public void previous_returnsProperItem() { /* Given */ SqlPart sqlPart = mock(SqlPart.class); CreateTableImpl createTable = new CreateTableImpl(null, "table", sqlPart); /* When */ SqlPart result = createTable.previous(); /* Then */ assertThat(result, is(sqlPart)); }
@Test public void columns_returnsNotNullValue() { /* Given */ CreateTableImpl createTable = new CreateTableImpl(null, "table", mock(SqlPart.class)); /* When */ CreateColumns result = createTable.columns(); /* Then */ assertThat(result, is(notNullValue())); }
@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_withOnlyTableName_prependsProperSql() { /* Given */ CreateTableImpl createTable = new CreateTableImpl(null, "table", mock(SqlPart.class)); RawSqlBuilder builder = new RawSqlBuilderImpl(); /* When */ createTable.prependTo(builder); /* Then */ assertThat(builder.toString(), is("TABLE table")); }
@NotNull @Override public CreateTable table(@Nullable final String databaseName, @NotNull final String tableName) { return new CreateTableImpl(databaseName, tableName, this); }