@NotNull @Override public SelectWhere where(@NotNull final String expression, @NotNull final Object... arguments) { return new SelectWhereImpl(expression, arguments, this); }
@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 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 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=?")); }