Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. public List<Crag> getAllCragsWithLocation() {
  2. QueryBuilder<Crag, Integer> cragQueryBuilder = _helper.getCragDao().queryBuilder();
  3. QueryBuilder<CragLocation, Integer> cragLocationQueryBuilder = _helper.getCragLocationDao().queryBuilder();
  4. try {
  5. cragLocationQueryBuilder.where().eq("locationType", 0);
  6. cragQueryBuilder.where().exists(cragLocationQueryBuilder);
  7. return cragQueryBuilder.query();
  8. } catch (Exception e) {
  9. Log.e(TAG,e.toString());
  10. return new ArrayList<Crag>();
  11. }
  12. }
  13.  
  14. QueryBuilder<Visit, Integer> visitQb = visitDao.queryBuilder();
  15. visitQb.where().eq(Visit.CLIENT_ID_FIELD, client.getId());
  16. QueryBuilder<Client, Integer> clientQb = clientDao.queryBuilder();
  17. clientQb.where().exists(visitQb);
  18. List<Client> results = clientQb.query();
  19.  
  20. select * from client c
  21. where EXISTS (select * from visit v where c._id = v.client_id)
  22.  
  23. select * from Crag c
  24. where EXISTS (select * from CragLocation cl where c.id = cl.crag_id)
  25.  
  26. select * from Crag c
  27. where EXISTS (select * from CragLocation cl where c.id = cl.crag_id and cl.location_type = 0)
  28.  
  29. cragLocationQueryBuilder.where().eq("locationType", 0);
  30. cragQueryBuilder.where().exists(cragLocationQueryBuilder);
  31.  
  32. cragLocationQueryBuilder.selectColumns("crag_id).where().eq("locationType", 0);
  33. cragQueryBuilder.where().in("id", cragLocationQueryBuilder);
  34.  
  35. select * from Crag
  36. where id IN (select crag_id from CragLocation cl.location_type = 0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement