public void testIn() {
ArrayList<TestEntity> inserted = insert(10);
String value1 = getSimpleString(2);
String value2 = getSimpleString(8);
String value3 = getSimpleString(9);
List<TestEntity> result =
dao.queryBuilder()
.where(Properties.SimpleString.in(value1, value2, value3))
.orderAsc(Properties.SimpleString)
.list();
assertEquals(3, result.size());
TestEntity resultEntity1 = result.get(0);
assertEquals(value1, resultEntity1.getSimpleString());
assertEquals(inserted.get(2).getId(), resultEntity1.getId());
TestEntity resultEntity2 = result.get(1);
assertEquals(value2, resultEntity2.getSimpleString());
assertEquals(inserted.get(8).getId(), resultEntity2.getId());
TestEntity resultEntity3 = result.get(2);
assertEquals(value3, resultEntity3.getSimpleString());
assertEquals(inserted.get(9).getId(), resultEntity3.getId());
}
public void testEqString() {
ArrayList<TestEntity> inserted = insert(3);
String value = getSimpleString(1);
List<TestEntity> result = dao.queryBuilder().where(Properties.SimpleString.eq(value)).list();
assertEquals(1, result.size());
TestEntity resultEntity = result.get(0);
assertEquals(value, resultEntity.getSimpleString());
assertEquals(inserted.get(1).getId(), resultEntity.getId());
}
public void testBuildTwice() {
insert(3);
String value = getSimpleString(1);
QueryBuilder<TestEntity> builder = dao.queryBuilder().where(Properties.SimpleString.eq(value));
Query<TestEntity> query1 = builder.build();
Query<TestEntity> query2 = builder.build();
List<TestEntity> list1 = query1.list();
List<TestEntity> list2 = query2.list();
assertEquals(1, list1.size());
assertEquals(1, list2.size());
assertEquals(list1.get(0).getId(), list2.get(0).getId());
}
public void testNotEqString() {
ArrayList<TestEntity> inserted = insert(3);
String value = getSimpleString(1);
List<TestEntity> result = dao.queryBuilder().where(Properties.SimpleString.notEq(value)).list();
assertEquals(2, result.size());
TestEntity resultEntity1 = result.get(0);
TestEntity resultEntity2 = result.get(1);
long loId = Math.min(resultEntity1.getId(), resultEntity2.getId());
long hiId = Math.max(resultEntity1.getId(), resultEntity2.getId());
assertEquals((long) inserted.get(0).getId(), loId);
assertEquals((long) inserted.get(2).getId(), hiId);
}
