@Override public void getData(boolean isRefresh) { mView.updateCount((int) mDbDao.queryBuilder().where(BeautyPhotoInfoDao.Properties.IsLove.eq(true)).count()); }
@Override public void getData(boolean isRefresh) { mView.updateLovedCount((int) mDbDao.queryBuilder().where(VideoInfoDao.Properties.IsCollect.eq(true)).count()); mView.updateDownloadCount((int) mDbDao.queryBuilder() .where(VideoInfoDao.Properties.DownloadStatus.notIn(DownloadStatus.NORMAL, DownloadStatus.COMPLETE)).count()); }
public void testJoinCount() { prepareData(); QueryBuilder<RelationEntity> queryBuilder = relationEntityDao.queryBuilder(); Join<RelationEntity, TestEntity> join = queryBuilder.join(RelationEntityDao.Properties.TestIdNotNull, TestEntity.class); join.where(Properties.SimpleInt.gt(6)); queryBuilder.count(); assertEquals(4, queryBuilder.count()); }
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 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(); }
@Override public void delete(VideoInfo data) { data.setCollect(false); if (!data.isCollect() && data.getDownloadStatus() == DownloadStatus.NORMAL) { mDbDao.delete(data); } else { mDbDao.update(data); } if (mDbDao.queryBuilder().where(VideoInfoDao.Properties.IsCollect.eq(true)).count() == 0) { // 如果收藏为0则显示无收藏 mView.noData(); } mRxBus.post(new VideoEvent()); }
public void testOrNested() { insert(10); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(101), // Properties.B.eq(302), Properties.C.eq(603)); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(3, result.size()); assertEquals(3, queryBuilder.count()); assertEquals(101, (int) result.get(0).getA()); assertEquals(301, (int) result.get(1).getA()); assertEquals(601, (int) result.get(2).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
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 testOrAnd() { insert(10); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(201), // queryBuilder.and(Properties.B.gt(402), Properties.C.lt(703))); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(3, result.size()); assertEquals(3, queryBuilder.count()); assertEquals(201, (int) result.get(0).getA()); assertEquals(501, (int) result.get(1).getA()); assertEquals(601, (int) result.get(2).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
@Override public void delete(BeautyPhotoInfo data) { data.setLove(false); if (!data.isLove() && !data.isDownload() && !data.isPraise()) { mDbDao.delete(data); } else { mDbDao.update(data); } if (mDbDao.queryBuilder().where(BeautyPhotoInfoDao.Properties.IsLove.eq(true)).count() == 0) { // 如果收藏为0则显示无收藏 mView.noData(); } mRxBus.post(new LoveEvent()); }
public void testOrNestedNested() { insert(10); QueryBuilder<AbcdefEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.A.eq(101), // queryBuilder.or(Properties.B.eq(302), // queryBuilder.or(Properties.C.eq(503), Properties.D.eq(804)))); List<AbcdefEntity> result = queryBuilder.orderAsc(Properties.A).list(); assertEquals(4, result.size()); assertEquals(4, queryBuilder.count()); assertEquals(101, (int) result.get(0).getA()); assertEquals(301, (int) result.get(1).getA()); assertEquals(501, (int) result.get(2).getA()); assertEquals(801, (int) result.get(3).getA()); queryBuilder.buildDelete().executeDeleteWithoutDetachingEntities(); }
public long getQueueLength() { return queueItemDao.queryBuilder().count(); }
public boolean addLink(String link) { Log.d(TAG, String.format("addLink(\"%s\") started", link)); boolean cancel = queueItemDao.queryBuilder() .where(QueueItemDao.Properties.Action.eq(Action.ADD_LINK.getId()), QueueItemDao.Properties.Extra.eq(link)).count() != 0; if(!cancel) { enqueueAddLink(link); } else { Log.d(TAG, "addLink() the link is already in queue"); } Log.d(TAG, "addLink() finished"); return !cancel; }
@Override public void initData() { long count = MyApplication.getDaoSession().getMusicBeanDao() .queryBuilder() .whereOr(MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_WEST)), MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_INLAND)), MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_HONGKANG)), MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_KOREA)), MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_JAPAN)), MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_VOLKSLIED)), MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_ROCK)), MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_SALES)), MusicBeanDao.Properties.Type.eq(Integer.valueOf(Constant.MUSIC_HOT))).count(); JLog.e(TAG,"count:" + count); mRequestMusicUtil = new RequestMusicUtil(); Observable.interval(1000, 1500, TimeUnit.MILLISECONDS).limit(9) .subscribe(aLong -> mRequestMusicUtil.requestMusic(topics[aLong.intValue()])); }
/** * 将数据保存到数据库 * @param topic * @param list */ private static void parseData(String topic, List<MusicBean> list) { if (null != topic && null != list) { for (int i = 0; i < list.size(); i++) { list.get(i).setType(Integer.parseInt(topic)); if (0 == MyApplication.getDaoSession().getMusicBeanDao().queryBuilder().where(MusicBeanDao.Properties.Songid.eq(list.get(i).getSongid())).count()) { MyApplication.getDaoSession().getMusicBeanDao().insertOrReplace(list.get(i)); } } } }
@Override public void initView() { mCursor = getContentResolver().query(MediaStore.Audio.Media.EXTERNAL_CONTENT_URI, null, null, null, MediaStore.Audio.Media.DEFAULT_SORT_ORDER); if (null != mCursor)mLocalMusicCount.setText("本地歌曲("+mCursor.getCount()+"首)"); mCountLike = MyApplication.getDaoSession().getMusicBeanDao().queryBuilder().where(MusicBeanDao.Properties.IsCollected.eq(true)).count(); if (0 != mCountLike){ mLikeMusic.setText("收藏歌曲("+mCountLike+"首)"); } //揭露动画 mRootLayout.post(new Runnable() { @Override public void run() { mRootLayout.setVisibility(View.VISIBLE); enterX = getIntent().getIntExtra("x",0); enterY = getIntent().getIntExtra("y",0); if (0 != enterX && 0 != enterY){ Animator animator = createRevealAnimator(false,enterX,enterY); animator.start(); } } }); }
/** * 是否添加过这个人 * * @param name * @return true 说明添加过了 */ private boolean hasAdd(String name) { return getWxFrendDao() .queryBuilder() .where(WechatFriendModelDao.Properties.Name.eq(name)) .count() != 0; } }
public static int searchDownloadingEntityCount(SQLiteDatabase database, String photoId) { return (int) new DaoMaster(database) .newSession() .getDownloadMissionEntityDao() .queryBuilder() .where( DownloadMissionEntityDao.Properties.Title.eq(photoId), DownloadMissionEntityDao.Properties.Result.eq(DownloaderService.RESULT_DOWNLOADING)) .count(); }
public static int readDownloadEntityCount(SQLiteDatabase database, @DownloaderService.DownloadTypeRule int result) { return (int) new DaoMaster(database) .newSession() .getDownloadMissionEntityDao() .queryBuilder() .where(DownloadMissionEntityDao.Properties.Result.eq(result)) .count(); }