org.greenrobot.greendao.query.QueryBuilder.orderAsc()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(8.5k)|赞(0)|评价(0)|浏览(150)

本文整理了Java中org.greenrobot.greendao.query.QueryBuilder.orderAsc方法的一些代码示例,展示了QueryBuilder.orderAsc的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。QueryBuilder.orderAsc方法的具体详情如下:
包路径:org.greenrobot.greendao.query.QueryBuilder
类名称:QueryBuilder
方法名:orderAsc

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

相关文章