public void testDeleteQueryOr() { ArrayList<TestEntity> inserted = insert(3); QueryBuilder<TestEntity> queryBuilder = dao.queryBuilder(); Integer value1 = inserted.get(0).getSimpleInteger(); Integer value2 = inserted.get(2).getSimpleInteger(); queryBuilder.whereOr(Properties.SimpleInteger.eq(value1), Properties.SimpleInteger.eq(value2)); DeleteQuery<TestEntity> deleteQuery = queryBuilder.buildDelete(); deleteQuery.executeDeleteWithoutDetachingEntities(); List<TestEntity> allAfterDelete = dao.loadAll(); assertEquals(1, allAfterDelete.size()); assertEquals(inserted.get(1).getSimpleInteger(), allAfterDelete.get(0).getSimpleInteger()); }
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 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 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 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(); }
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 void testCountQueryTwoParametersOr() { int value = getSimpleInteger(1); String valueString = getSimpleString(2); QueryBuilder<TestEntity> queryBuilder = dao.queryBuilder(); queryBuilder.whereOr(Properties.SimpleInteger.eq(value), Properties.SimpleString.eq(valueString)); CountQuery<TestEntity> query = queryBuilder.buildCount(); assertEquals(0, query.count()); ArrayList<TestEntity> inserted = insert(3); assertEquals(2, query.count()); inserted.get(1).setSimpleInteger(getSimpleInteger(2)); dao.update(inserted.get(1)); assertEquals(1, query.count()); inserted.get(2).setSimpleString(getSimpleString(3)); dao.update(inserted.get(2)); assertEquals(0, query.count()); }
public static List<CNCityList.CNCity> fuzzySearchCNCity(SQLiteDatabase database, String name) { if (TextUtils.isEmpty(name)) { return null; } CNCityEntityDao dao = new DaoMaster(database) .newSession() .getCNCityEntityDao(); QueryBuilder<CNCityEntity> builder = dao.queryBuilder(); builder.whereOr( CNCityEntityDao.Properties.District.like("%" + name + "%"), CNCityEntityDao.Properties.City.like("%" + name + "%"), CNCityEntityDao.Properties.Province.like("%" + name + "%")); List<CNCityList.CNCity> cityList = new ArrayList<>(); List<CNCityEntity> entityList = builder.list(); if (entityList != null && entityList.size() > 0) { for (int i = 0; i < entityList.size(); i ++) { cityList.add(CNCityList.CNCity.buildCNCity(entityList.get(i))); } } return cityList; }
@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()])); }
private void searchFriend(String friend) { ContactDao contactDao = GreenDAOUtils.getInstance(FriendSearchActivity.this).getContactDao(); List<Contact> contacts = contactDao.queryBuilder() .whereOr(ContactDao.Properties.UserId.eq(friend), ContactDao.Properties.Name.eq(friend), ContactDao.Properties.Name.like("%" + friend + "%")) .build() .list(); if (contacts.size() == 0) { ToastUtils.showShort(FriendSearchActivity.this, "本地无好友,去网络搜索"); } else { RecyclerView recyclerView = (RecyclerView) findViewById(R.id.recyclerView); ArrayList<Contact> listData = new ArrayList<>(); listData.addAll(contacts); ContactAdapter contactAdapter = new ContactAdapter(FriendSearchActivity.this, listData); recyclerView.setLayoutManager(new LinearLayoutManager(FriendSearchActivity.this)); recyclerView.setAdapter(contactAdapter); contactAdapter.notifyDataSetChanged(); layout_points.setVisibility(View.GONE); } } }
public static CNCityList.CNCity searchCNCity(SQLiteDatabase database, String name) { if (TextUtils.isEmpty(name)) { return null; } CNCityEntityDao dao = new DaoMaster(database) .newSession() .getCNCityEntityDao(); QueryBuilder<CNCityEntity> builder = dao.queryBuilder(); builder.whereOr( CNCityEntityDao.Properties.District.eq(name), CNCityEntityDao.Properties.City.eq(name)); List<CNCityEntity> entityList = builder.list(); if (entityList == null || entityList.size() <= 0) { return null; } else { return CNCityList.CNCity.buildCNCity(entityList.get(0)); } }
qb.whereOr(ArticleDao.Properties.Title.like("%" + searchQuery + "%"), ArticleDao.Properties.Content.like("%" + searchQuery + "%"));
chats = chatDao.queryBuilder() .where(ChatDao.Properties.ChatType.eq(chatType), ChatDao.Properties.Id.lt(latestId)) .whereOr(ChatDao.Properties.FromId.eq(chatId), ChatDao.Properties.ToId.eq(chatId)) .limit(10) .orderDesc(ChatDao.Properties.Time)
chats = chatDao.queryBuilder() .where(ChatDao.Properties.ChatType.eq(chatType)) .whereOr(ChatDao.Properties.FromId.eq(chatId), ChatDao.Properties.ToId.eq(chatId)) .limit(5) .orderDesc(ChatDao.Properties.Time)