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 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(); }
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(); }
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; }
/** 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(); }
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; }
@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)); } } }
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; }
@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; }
.orderDesc(ArticleDao.Properties.ArticleId).limit(dbQuerySize);
.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();
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; }
qb.orderDesc(ArticleDao.Properties.ArticleId); break;
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); }
if (savedInstanceState == null) { ArrayList<IItem> dataSet = new ArrayList<>(); List<RequestRecord> requestRecordList = requestRecordDao.queryBuilder().orderDesc (RequestRecordDao.Properties.CreateAt).build().list(); String lastDate = null;