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