Select Builder Example

The Class ID

public class SimpleID {

@Column(name = "idbuilder")
private Integer key;

@Column(name = "indexbuilder")
private Integer index;

//getter and setter
}

The Class

@Entity(name = "simplequerybuilder")
public class SimpleQueryBuilder {

@EmbeddedId
private SimpleID id = new SimpleID();

@Index
@Column(name = "namebuilder")
private String name;

@Column(name = "valuebuilder")
private Double value;

//getter and setter
}

Call method

You can create the SelectBuider using CassandraTemplate or Persistence

Using org.easycassandra.persistence.cassandra.Persistence

Persistence = //inject
SelectBuilder<YourClass> select = persistence.selectBuilder(Class<YourClass>);

Using org.easycassandra.persistence.cassandra.spring.CassandraTemplate

CassandraTemplate template = //inject
SelectBuilder<YourClass> select = template .selectBuilder(Class<YourClass>);

Running samples

Select All

    SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
    select.eq("name", "name");
    select.eq(INDEX, Integer.valueOf(TWO));
    List<SimpleQueryBuilder> result = select.execute();


   SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
    List<SimpleQueryBuilder> result = select.eq("name", "name").eq(INDEX, Integer.valueOf(TWO)).execute();

Select Equals

 SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
 select.eq("name", "nameValue");
 select.eq(INDEX, Integer.valueOf(TWO));
 List<SimpleQueryBuilder> result = select.execute();

 SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
 List<SimpleQueryBuilder> result = select.eq("name", "nameValue").eq(INDEX,     Integer.valueOf(TWO)).execute();

Select IN

  SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
  select.eq("name", "name");
  select.in("index", ONE, TWO, THREE);
  List<SimpleQueryBuilder> result = select.execute();

  SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
        List<SimpleQueryBuilder> result = select.eq("name", "name").in("index", ONE, TWO, THREE).execute();

Lesser than or Lesser Equals

SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
SelectBuilder<SimpleQueryBuilder> select2 = persistence.selectBuilder(SimpleQueryBuilder.class);
List<SimpleQueryBuilder> result = select.eq(NAME, NAME).lt("index", THREE).execute();
List<SimpleQueryBuilder> result2 = select2.eq(NAME, NAME).lte("index", THREE).execute();

Greater than or Greater Equals

SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
SelectBuilder<SimpleQueryBuilder> select2 = persistence.selectBuilder(SimpleQueryBuilder.class);
List<SimpleQueryBuilder> result = select.eq(NAME, NAME).gt("index", THREE).execute();
List<SimpleQueryBuilder> result2 = select2.eq(NAME, NAME).gte("index", THREE).execute();

Order ascing or Descending

SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
SelectBuilder<SimpleQueryBuilder> select2 = persistence.selectBuilder(SimpleQueryBuilder.class);
List<SimpleQueryBuilder> result = select.eq(NAME, NAME).gt("index", THREE).asc(INDEX).execute();
List<SimpleQueryBuilder> result2 = select2.eq(NAME, NAME).gte("index", THREE).desc(INDEX).execute();

Async process

SelectBuilder<SimpleQueryBuilder> select = persistence.selectBuilder(SimpleQueryBuilder.class);
select.executeAsync(new ResultAsyncCallBack<List<SimpleBean>>() {

        @Override
        public void result(List<SimpleBean> beans) {
          // do some thing
        }
    });