How to use

com.nhaarman.sqlitebuilder.impl.AsImpl

constructor

 @NotNull
 @Override
 public As as(@NotNull final FinishedSelectStatement select) {
  return new AsImpl(select, this);
 }
}

 @Test
 public void previous_returnsProperItem() {
  /* Given */
  SqlPart sqlPart = mock(SqlPart.class);
  AsImpl as = new AsImpl(mock(FinishedSelectStatement.class), sqlPart);

  /* When */
  SqlPart result = as.previous();

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

@Test
public void prependTo_prependsProperSql() {
 /* Given */
 AsImpl as = new AsImpl(select().from("my_table"), mock(SqlPart.class));
 RawSqlBuilder builder = new RawSqlBuilderImpl();
 /* When */
 as.prependTo(builder);
 /* Then */
 assertThat(builder.toString(), is("AS SELECT * FROM my_table"));
}