How to use

SelectWhereImpl

in

com.nhaarman.sqlitebuilder.impl

@NotNull
@Override
public SelectWhere where(@NotNull final String expression, @NotNull final Object... arguments) {
 return new SelectWhereImpl(expression, arguments, this);
}

@Test
public void previous_returnsProperItem() {
 /* Given */
 SqlPart sqlPart = mock(SqlPart.class);
 SelectWhereImpl where = new SelectWhereImpl("a=?", new Object[] {1}, sqlPart);
 /* When */
 SqlPart result = where.previous();
 /* Then */
 assertThat(result, is(sqlPart));
}

@Test
public void orderBy_returnsNotNullValue() {
 /* Given */
 SelectWhereImpl where = new SelectWhereImpl("a=?", new Object[] {1}, mock(SqlPart.class));
 /* When */
 OrderBy result = where.orderBy("a");
 /* Then */
 assertThat(result, is(notNullValue()));
}

 @Test
 public void limit_returnsNotNullValue() {
  /* Given */
  SelectWhereImpl where = new SelectWhereImpl("a=?", new Object[] {1}, mock(SqlPart.class));

  /* When */
  Limit result = where.limit(5);

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

@Test
public void groupBy_returnsNotNullValue() {
 /* Given */
 SelectWhereImpl where = new SelectWhereImpl("a=?", new Object[] {1}, mock(SqlPart.class));
 /* When */
 GroupBy result = where.groupBy("a");
 /* Then */
 assertThat(result, is(notNullValue()));
}

@Test
public void getArguments_returnsProperArguments() {
 /* Given */
 SelectWhereImpl where = new SelectWhereImpl("a=?", new Object[] {1}, mock(SqlPart.class));
 /* When */
 Object[] arguments = where.getArguments();
 /* Then */
 assertThat(arguments, is(arrayContaining((Object) 1)));
}

@Test
public void prependTo_prependsProperSql() {
 /* Given */
 SelectWhereImpl where = new SelectWhereImpl("a=?", new Object[] {1}, mock(SqlPart.class));
 RawSqlBuilder builder = new RawSqlBuilderImpl();
 /* When */
 where.prependTo(builder);
 /* Then */
 assertThat(builder.toString(), is("WHERE a=?"));
}