本文整理了Java中org.greenrobot.greendao.query.QueryBuilder.orderAsc
方法的一些代码示例,展示了QueryBuilder.orderAsc
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。QueryBuilder.orderAsc
方法的具体详情如下:
包路径:org.greenrobot.greendao.query.QueryBuilder
类名称:QueryBuilder
方法名:orderAsc
[英]Adds the given properties to the ORDER BY section using ascending order.
[中]使用升序将给定属性按节添加到ORDER中。
代码示例来源:origin: greenrobot/greenDAO
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();
}
代码示例来源:origin: greenrobot/greenDAO
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());
}
}
代码示例来源:origin: greenrobot/greenDAO
@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();
}
代码示例来源:origin: greenrobot/greenDAO
@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();
}
代码示例来源:origin: greenrobot/greenDAO
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());
}
代码示例来源:origin: greenrobot/greenDAO
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());
}
代码示例来源:origin: greenrobot/greenDAO
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());
}
代码示例来源:origin: greenrobot/greenDAO
public void testQueryBuilderOffsetWithoutLimit() {
try{
dao.queryBuilder().offset(7).orderAsc(Properties.SimpleInt).build();
fail("Offset may not be set alone");
} catch(RuntimeException expected) {
//OK
}
}
代码示例来源:origin: greenrobot/greenDAO
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));
}
代码示例来源:origin: greenrobot/greenDAO
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());
}
代码示例来源:origin: greenrobot/greenDAO
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());
}
代码示例来源:origin: greenrobot/greenDAO
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());
}
}
代码示例来源:origin: greenrobot/greenDAO
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();
}
代码示例来源:origin: greenrobot/greenDAO
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();
}
代码示例来源:origin: greenrobot/greenDAO
public void testGetAll100() {
ArrayList<TestEntity> list = insert(100);
LazyList<TestEntity> listLazy = dao.queryBuilder().orderAsc(Properties.SimpleInteger).build().listLazy();
assertIds(list, listLazy);
assertTrue(listLazy.isClosed());
}
代码示例来源:origin: greenrobot/greenDAO
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();
}
代码示例来源:origin: greenrobot/greenDAO
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());
}
代码示例来源:origin: greenrobot/greenDAO
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();
}
代码示例来源:origin: greenrobot/greenDAO
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();
}
代码示例来源:origin: greenrobot/greenDAO
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();
}
内容来源于网络,如有侵权,请联系作者删除!