public void testOrderAscString() { // SQLCipher 3.5.0 does not understand "COLLATE LOCALIZED ASC" and crashed here initially List<SimpleEntity> result = dao.queryBuilder().orderAsc(Properties.SimpleString).list(); assertEquals(0, result.size()); } }
public void testOrderRaw() { ArrayList<TestEntity> inserted = insert(2); List<TestEntity> result = dao.queryBuilder().orderRaw(Properties.SimpleInteger.columnName + " ASC").list(); assertEquals(2, result.size()); assertEquals(inserted.get(0).getId(), result.get(0).getId()); result = dao.queryBuilder().orderRaw(Properties.SimpleInteger.columnName + " DESC").list(); assertEquals(2, result.size()); assertEquals(inserted.get(1).getId(), result.get(0).getId()); }
public void testOrderAsc() { ArrayList<TestEntity> inserted = insert(2); TestEntity entity = inserted.get(0); List<TestEntity> result = dao.queryBuilder().orderAsc(Properties.SimpleInteger).list(); assertEquals(2, result.size()); assertEquals(entity.getId(), result.get(0).getId()); result = dao.queryBuilder().orderAsc(Properties.SimpleInteger, Properties.SimpleString).list(); assertEquals(2, result.size()); assertEquals(entity.getId(), result.get(0).getId()); }
public void testOrderDesc() { ArrayList<TestEntity> inserted = insert(2); TestEntity entity = inserted.get(1); List<TestEntity> result = dao.queryBuilder().orderDesc(Properties.SimpleInteger).list(); assertEquals(2, result.size()); assertEquals(entity.getId(), result.get(0).getId()); result = dao.queryBuilder().orderDesc(Properties.SimpleInteger, Properties.SimpleString).list(); assertEquals(2, result.size()); assertEquals(entity.getId(), result.get(0).getId()); }
public void testQueryBuilderLimit() { insert(10); List<TestEntity> result = dao.queryBuilder().limit(3).orderAsc(Properties.SimpleInt).list(); assertEquals(3, result.size()); assertEquals(getSimpleInteger(0), result.get(0).getSimpleInteger().intValue()); assertEquals(getSimpleInteger(1), result.get(1).getSimpleInteger().intValue()); assertEquals(getSimpleInteger(2), result.get(2).getSimpleInteger().intValue()); }
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); }
public void testQueryBuilderOffsetAndLimit() { insert(10); List<TestEntity> result = dao.queryBuilder().offset(3).limit(3).orderAsc(Properties.SimpleInt).list(); assertEquals(3, result.size()); assertEquals(getSimpleInteger(3), result.get(0).getSimpleInteger().intValue()); assertEquals(getSimpleInteger(4), result.get(1).getSimpleInteger().intValue()); assertEquals(getSimpleInteger(5), result.get(2).getSimpleInteger().intValue()); }
public void testOrderCustom() { List<TestEntity> list = new ArrayList<TestEntity>(); TestEntity entityAA = addEntity(list, "Aa"); TestEntity entityAB = addEntity(list, "ab"); TestEntity entityAC = addEntity(list, "Ac"); dao.insertInTx(list); List<TestEntity> result = dao.queryBuilder().orderCustom(Properties.SimpleString, "ASC").list(); assertEquals(list.size(), result.size()); assertEquals(entityAA.getId(), result.get(0).getId()); assertEquals(entityAC.getId(), result.get(1).getId()); assertEquals(entityAB.getId(), result.get(2).getId()); }
public void testQueryBuilderOffsetAndLimitWithWhere() { insert(10); List<TestEntity> result = dao.queryBuilder().where(Properties.SimpleInteger.gt(getSimpleInteger(1))).offset(2) .limit(3).orderAsc(Properties.SimpleInt).list(); assertEquals(3, result.size()); assertEquals(getSimpleInteger(4), result.get(0).getSimpleInteger().intValue()); assertEquals(getSimpleInteger(5), result.get(1).getSimpleInteger().intValue()); assertEquals(getSimpleInteger(6), result.get(2).getSimpleInteger().intValue()); }
public void testEqInteger() { ArrayList<TestEntity> inserted = insert(3); int value = getSimpleInteger(1); List<TestEntity> result = dao.queryBuilder().where(Properties.SimpleInteger.eq(value)).list(); assertEquals(1, result.size()); TestEntity resultEntity = result.get(0); assertEquals(value, (int) resultEntity.getSimpleInteger()); assertEquals(inserted.get(1).getId(), resultEntity.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 testEqStringAndInteger() { ArrayList<TestEntity> inserted = insert(3); String valueStr = getSimpleString(1); int valueInt = getSimpleInteger(1); List<TestEntity> result = dao.queryBuilder() .where(Properties.SimpleString.eq(valueStr), Properties.SimpleInteger.eq(valueInt)).list(); assertEquals(1, result.size()); TestEntity resultEntity = result.get(0); assertEquals(inserted.get(1).getId(), resultEntity.getId()); }
public void testNotIn() { ArrayList<TestEntity> inserted = insert(5); String value1 = getSimpleString(0); String value2 = getSimpleString(2); String value3 = getSimpleString(4); List<TestEntity> result = dao.queryBuilder().where(Properties.SimpleString.notIn(value1, value2, value3)) .orderAsc(Properties.SimpleString).list(); assertEquals(2, result.size()); TestEntity resultEntity1 = result.get(0); assertEquals(inserted.get(1).getId(), resultEntity1.getId()); TestEntity resultEntity2 = result.get(1); assertEquals(inserted.get(3).getId(), resultEntity2.getId()); }
public void testSimpleQuery() { insert(3); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder().where(Properties.A.eq(1)).orderAsc(Properties.A); List<AbcdefEntity> result = queryBuilder.list(); assertEquals(1, result.size()); assertEquals(1, queryBuilder.count()); AbcdefEntity resultEntity = result.get(0); assertEquals(1, (int) resultEntity.getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testOr3() { insert(5); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(1), Properties.A.eq(101), Properties.B.eq(302)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(3, result.size()); assertEquals(3, queryBuilder.count()); assertEquals(1, (int) result.get(0).getA()); assertEquals(101, (int) result.get(1).getA()); assertEquals(301, (int) result.get(2).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testOr() { insert(3); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(1), Properties.A.eq(101)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(2, result.size()); assertEquals(2, queryBuilder.count()); assertEquals(1, (int) result.get(0).getA()); assertEquals(101, (int) result.get(1).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testOrNested() { insert(10); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(101), // Properties.B.eq(302), Properties.C.eq(603)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(3, result.size()); assertEquals(3, queryBuilder.count()); assertEquals(101, (int) result.get(0).getA()); assertEquals(301, (int) result.get(1).getA()); assertEquals(601, (int) result.get(2).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testAnd() { insert(5); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.where(Properties.A.eq(201), Properties.B.eq(202)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(1, result.size()); assertEquals(1, queryBuilder.count()); assertEquals(201, (int) result.get(0).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testOrAnd() { insert(10); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(201), // queryBuilder.and(Properties.B.gt(402), Properties.C.lt(703))); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(3, result.size()); assertEquals(3, queryBuilder.count()); assertEquals(201, (int) result.get(0).getA()); assertEquals(501, (int) result.get(1).getA()); assertEquals(601, (int) result.get(2).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public void testOrderWithSpecialNames() { QueryBuilder<SpecialNamesEntity> queryBuilder = dao.queryBuilder(); queryBuilder.orderAsc(Properties.Avg); queryBuilder.orderAsc(Properties.Count); queryBuilder.orderAsc(Properties.Distinct); queryBuilder.orderAsc(Properties.Index); queryBuilder.orderAsc(Properties.Join); queryBuilder.orderAsc(Properties.On); queryBuilder.orderAsc(Properties.Select); queryBuilder.orderAsc(Properties.Sum); queryBuilder.orderAsc(Properties.Order); queryBuilder.list(); }