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(); }
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()); } }
@Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); setUpViews(); // get the note DAO DaoSession daoSession = ((App) getApplication()).getDaoSession(); noteDao = daoSession.getNoteDao(); // query all notes, sorted a-z by their text notesQuery = noteDao.queryBuilder().orderAsc(NoteDao.Properties.Text).build(); updateNotes(); }
@Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); setUpViews(); // get the Rx variant of the note DAO DaoSession daoSession = ((App) getApplication()).getDaoSession(); noteDao = daoSession.getNoteDao().rx(); // query all notes, sorted a-z by their text notesQuery = daoSession.getNoteDao().queryBuilder().orderAsc(NoteDao.Properties.Text).rx(); updateNotes(); }
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 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 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 testQueryBuilderOffsetWithoutLimit() { try{ dao.queryBuilder().offset(7).orderAsc(Properties.SimpleInt).build(); fail("Offset may not be set alone"); } catch(RuntimeException expected) { //OK } }
public void testSublist() { ArrayList<TestEntity> list = insert(10); LazyList<TestEntity> listLazy = dao.queryBuilder().orderAsc(Properties.SimpleInteger).build().listLazy(); assertIds(list.subList(2, 7), listLazy.subList(2, 7)); }
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 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 testSublistUncached() { ArrayList<TestEntity> list = insert(10); LazyList<TestEntity> listLazy = dao.queryBuilder().orderAsc(Properties.SimpleInteger).build().listLazyUncached(); try { assertIds(list.subList(2,7), listLazy.subList(2,7)); } catch (DaoException e) { assertEquals("This operation only works with cached lazy lists", e.getMessage()); } }
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 testGetAll100() { ArrayList<TestEntity> list = insert(100); LazyList<TestEntity> listLazy = dao.queryBuilder().orderAsc(Properties.SimpleInteger).build().listLazy(); assertIds(list, listLazy); assertTrue(listLazy.isClosed()); }
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 testIterator() { ArrayList<TestEntity> list = insert(100); LazyList<TestEntity> listLazy = dao.queryBuilder().orderAsc(Properties.SimpleInteger).build().listLazy(); testIterator(list, listLazy, false); assertTrue(listLazy.isClosed()); }
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 testGetAll100Uncached() { ArrayList<TestEntity> list = insert(100); LazyList<TestEntity> listLazy = dao.queryBuilder().orderAsc(Properties.SimpleInteger).build() .listLazyUncached(); assertIds(list, listLazy); assertFalse(listLazy.isClosed()); listLazy.close(); }
public void testIteratorUncached() { ArrayList<TestEntity> list = insert(100); LazyList<TestEntity> listLazy = dao.queryBuilder().orderAsc(Properties.SimpleInteger).build() .listLazyUncached(); testIterator(list, listLazy, true); assertFalse(listLazy.isClosed()); listLazy.close(); }