How to use

com.nhaarman.sqlitebuilder.impl.SelectImpl

constructor

@NotNull
public static Select select(@NotNull final String... columns) {
 return new SelectImpl(columns);
}

@Test
public void previous_returnsNull() {
 /* Given */
 SelectImpl select = new SelectImpl();
 /* When */
 SqlPart result = select.previous();
 /* Then */
 assertThat(result, is(nullValue()));
}

 @Test
 public void from_returnsNotNullValue() {
  /* Given */
  SelectImpl select = new SelectImpl();

  /* When */
  SelectFrom result = select.from("my_table");

  /* Then */
  assertThat(result, is(notNullValue()));
 }
}

@Test
public void prependTo_withMultipleColumns_prependsProperSql() {
 /* Given */
 String[] columns = {"a", "b", "c"};
 SelectImpl select = new SelectImpl(columns);
 RawSqlBuilder builder = new RawSqlBuilderImpl();
 /* When */
 select.prependTo(builder);
 /* Then */
 assertThat(builder.toString(), is("SELECT a,b,c"));
}

@Test
public void prependTo_withoutColumns_prependsProperSql() {
 /* Given */
 SelectImpl select = new SelectImpl();
 RawSqlBuilder builder = new RawSqlBuilderImpl();
 /* When */
 select.prependTo(builder);
 /* Then */
 assertThat(builder.toString(), is("SELECT *"));
}

@Test
public void prependTo_withOneColumn_prependsProperSql() {
 /* Given */
 String[] columns = {"a"};
 SelectImpl select = new SelectImpl(columns);
 RawSqlBuilder builder = new RawSqlBuilderImpl();
 /* When */
 select.prependTo(builder);
 /* Then */
 assertThat(builder.toString(), is("SELECT a"));
}