本文整理了Java中org.greenrobot.greendao.query.QueryBuilder.orderDesc
方法的一些代码示例,展示了QueryBuilder.orderDesc
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。QueryBuilder.orderDesc
方法的具体详情如下:
包路径:org.greenrobot.greendao.query.QueryBuilder
类名称:QueryBuilder
方法名:orderDesc
[英]Adds the given properties to the ORDER BY section using descending order.
[中]使用降序将给定的属性按节顺序添加到中。
代码示例来源:origin: greenrobot/greenDAO
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());
}
代码示例来源:origin: chat-sdk/chat-sdk-android
public static <T extends CoreEntity> List<T> fetchEntitiesWithPropertiesAndOrder(Class<T> c, Property whereOrder, int order, Property properties[], Object... values){
if (values == null || properties == null)
throw new NullPointerException("You must have at least one value and one property");
if (values.length != properties.length)
throw new IllegalArgumentException("Values size should match properties size");
QueryBuilder<T> qb = daoSession.queryBuilder(c);
qb.where(properties[0].eq(values[0]));
for (int i = 0 ; i < values.length ; i++)
qb.where(properties[i].eq(values[i]));
if (whereOrder != null && order != -1)
switch (order)
{
case ORDER_ASC:
qb.orderAsc(whereOrder);
break;
case ORDER_DESC:
qb.orderDesc(whereOrder);
break;
}
return qb.list();
}
代码示例来源:origin: chat-sdk/chat-sdk-android
public static <T extends CoreEntity> List<T> fetchEntitiesWithPropertiesAndOrderAndLimit(Class<T> c, int limit, Property whereOrder, int order, Property properties[], Object... values){
if (values == null || properties == null)
throw new NullPointerException("You must have at least one value and one property");
if (values.length != properties.length)
throw new IllegalArgumentException("Values size should match properties size");
QueryBuilder<T> qb = daoSession.queryBuilder(c);
qb.where(properties[0].eq(values[0]));
if (values.length > 1)
for (int i = 0 ; i < values.length ; i++)
qb.where(properties[i].eq(values[i]));
if (whereOrder != null && order != -1)
switch (order)
{
case ORDER_ASC:
qb.orderAsc(whereOrder);
break;
case ORDER_DESC:
qb.orderDesc(whereOrder);
break;
}
if (limit != -1)
qb.limit(limit);
return qb.listLazy();
}
代码示例来源:origin: chat-sdk/chat-sdk-android
public List<Message> fetchMessagesForThreadWithID (long threadID, int limit, Date olderThan) {
List<Message> list ;
QueryBuilder<Message> qb = daoSession.queryBuilder(Message.class);
qb.where(MessageDao.Properties.ThreadId.eq(threadID));
// Making sure no null messages infected the sort.
qb.where(MessageDao.Properties.Date.isNotNull());
qb.where(MessageDao.Properties.SenderId.isNotNull());
if(olderThan != null) {
qb.where(MessageDao.Properties.Date.lt(olderThan.getTime()));
}
qb.orderDesc(MessageDao.Properties.Date);
if (limit != -1)
qb.limit(limit);
list = qb.list();
return list;
}
代码示例来源:origin: chat-sdk/chat-sdk-android
/** Fetch messages list from the db for current thread, Messages will be order Desc/Asc on demand.*/
@Keep
public List<Message> getMessagesWithOrder(int order, int limit) {
QueryBuilder<Message> qb = daoSession.queryBuilder(Message.class);
qb.where(MessageDao.Properties.ThreadId.eq(getId()));
if(order == DaoCore.ORDER_ASC) {
qb.orderAsc(MessageDao.Properties.Date);
}
else if(order == DaoCore.ORDER_DESC) {
qb.orderDesc(MessageDao.Properties.Date);
}
// Making sure no null messages infected the sort.
qb.where(MessageDao.Properties.Date.isNotNull());
if (limit > 0) {
qb.limit(limit);
}
Query<Message> query = qb.build().forCurrentThread();
return query.list();
}
代码示例来源:origin: wallabag/android-app
private long getNewQueueNumber() {
List<QueueItem> items = queueItemDao.queryBuilder()
.orderDesc(QueueItemDao.Properties.QueueNumber)
.limit(1)
.list();
if(items.isEmpty()) return 1;
return items.get(0).getQueueNumber() + 1;
}
代码示例来源:origin: JingYeoh/SupportFragment
@Override
public void getLastStatus(LoadDataCallBack<Status> callBack) {
StatusDao statusDao = daoSession.getStatusDao();
QueryBuilder<Status> qb = statusDao.queryBuilder();
QueryBuilder<Status> builder = qb.orderDesc(StatusDao.Properties.Create_time);
List<Status> list = builder.list();
if (list == null || list.size() == 0) {
callBack.onDataNotAvailable("status table is empty");
} else {
callBack.onDataLoaded(list.get(0));
}
}
}
代码示例来源:origin: wallabag/android-app
private QueryBuilder<Tag> getQueryBuilder() {
QueryBuilder<Tag> qb = tagDao.queryBuilder();
if(!TextUtils.isEmpty(searchQuery)) {
qb.where(TagDao.Properties.Label.like("%" + searchQuery + "%"));
}
switch(sortOrder) {
case ASC:
qb.orderAsc(TagDao.Properties.Label);
break;
case DESC:
qb.orderDesc(TagDao.Properties.Label);
break;
default:
throw new IllegalStateException("Sort order not implemented: " + sortOrder);
}
return qb;
}
代码示例来源:origin: wallabag/android-app
@Override
protected void resetContent() {
if(tagLabel != null) {
List<Tag> tags = tagDao.queryBuilder()
.where(TagDao.Properties.Label.eq(tagLabel))
.orderDesc(TagDao.Properties.Label)
.list();
tagIDs = new ArrayList<>(tags.size());
for(Tag t: tags) {
tagIDs.add(t.getId());
}
} else {
tagIDs = null;
}
super.resetContent();
forceContentUpdate = false;
}
代码示例来源:origin: wallabag/android-app
.orderDesc(ArticleDao.Properties.ArticleId).limit(dbQuerySize);
代码示例来源:origin: CooLoongWu/CoolChat
.whereOr(ChatDao.Properties.FromId.eq(chatId), ChatDao.Properties.ToId.eq(chatId))
.limit(5)
.orderDesc(ChatDao.Properties.Time)
.build()
.list();
.where(ChatDao.Properties.ChatType.eq(chatType), ChatDao.Properties.ToId.eq(chatId))
.limit(5)
.orderDesc(ChatDao.Properties.Time)
.build()
.list();
代码示例来源:origin: CooLoongWu/CoolChat
.whereOr(ChatDao.Properties.FromId.eq(chatId), ChatDao.Properties.ToId.eq(chatId))
.limit(10)
.orderDesc(ChatDao.Properties.Time)
.build()
.list();
.where(ChatDao.Properties.ChatType.eq(chatType), ChatDao.Properties.Id.lt(latestId), ChatDao.Properties.ToId.eq(chatId))
.limit(10)
.orderDesc(ChatDao.Properties.Time)
.build()
.list();
代码示例来源:origin: wallabag/android-app
private Long getAdjacentArticle(boolean previous) {
QueryBuilder<Article> qb = articleDao.queryBuilder();
if(previous) qb.where(ArticleDao.Properties.ArticleId.gt(article.getArticleId()));
else qb.where(ArticleDao.Properties.ArticleId.lt(article.getArticleId()));
if(contextFavorites != null) qb.where(ArticleDao.Properties.Favorite.eq(contextFavorites));
if(contextArchived != null) qb.where(ArticleDao.Properties.Archive.eq(contextArchived));
if(previous) qb.orderAsc(ArticleDao.Properties.ArticleId);
else qb.orderDesc(ArticleDao.Properties.ArticleId);
List<Article> l = qb.limit(1).list();
if(!l.isEmpty()) {
return l.get(0).getId();
}
return null;
}
代码示例来源:origin: wallabag/android-app
qb.orderDesc(ArticleDao.Properties.ArticleId);
break;
代码示例来源:origin: zas023/CocoBill
public Observable<List<BBill>> getBBillByUserIdWithYM(String id, String year, String month) {
String startStr = year + "-" + month + "-00 00:00:00";
Date date = DateUtils.str2Date(startStr);
Date endDate = DateUtils.addMonth(date, 1);
QueryBuilder<BBill> queryBuilder = mSession.getBBillDao()
.queryBuilder()
.where(BBillDao.Properties.Crdate.between(DateUtils.getMillis(date), DateUtils.getMillis(endDate)))
.where(BBillDao.Properties.Version.ge(0))
.orderDesc(BBillDao.Properties.Crdate);
return queryListToRx(queryBuilder);
}
代码示例来源:origin: MuShare/Httper-Android
if (savedInstanceState == null) {
ArrayList<IItem> dataSet = new ArrayList<>();
List<RequestRecord> requestRecordList = requestRecordDao.queryBuilder().orderDesc
(RequestRecordDao.Properties.CreateAt).build().list();
String lastDate = null;
内容来源于网络,如有侵权,请联系作者删除!