How to use

CreateTableImpl

in

com.nhaarman.sqlitebuilder.impl

@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);
}