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