Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<Crag> getAllCragsWithLocation() {
- QueryBuilder<Crag, Integer> cragQueryBuilder = _helper.getCragDao().queryBuilder();
- QueryBuilder<CragLocation, Integer> cragLocationQueryBuilder = _helper.getCragLocationDao().queryBuilder();
- try {
- cragLocationQueryBuilder.where().eq("locationType", 0);
- cragQueryBuilder.where().exists(cragLocationQueryBuilder);
- return cragQueryBuilder.query();
- } catch (Exception e) {
- Log.e(TAG,e.toString());
- return new ArrayList<Crag>();
- }
- }
- QueryBuilder<Visit, Integer> visitQb = visitDao.queryBuilder();
- visitQb.where().eq(Visit.CLIENT_ID_FIELD, client.getId());
- QueryBuilder<Client, Integer> clientQb = clientDao.queryBuilder();
- clientQb.where().exists(visitQb);
- List<Client> results = clientQb.query();
- select * from client c
- where EXISTS (select * from visit v where c._id = v.client_id)
- select * from Crag c
- where EXISTS (select * from CragLocation cl where c.id = cl.crag_id)
- select * from Crag c
- where EXISTS (select * from CragLocation cl where c.id = cl.crag_id and cl.location_type = 0)
- cragLocationQueryBuilder.where().eq("locationType", 0);
- cragQueryBuilder.where().exists(cragLocationQueryBuilder);
- cragLocationQueryBuilder.selectColumns("crag_id).where().eq("locationType", 0);
- cragQueryBuilder.where().in("id", cragLocationQueryBuilder);
- select * from Crag
- where id IN (select crag_id from CragLocation cl.location_type = 0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement