Revision 50947
Added by Argiro Kokogiannaki about 6 years ago
| QueryGenerator.java | ||
|---|---|---|
| 652 | 652 |
} |
| 653 | 653 |
public String generateCountByContext(String contextId ,String keyword, List<String> types, ArrayList<Object> params) {
|
| 654 | 654 |
if((keyword == null || keyword.equals(""))&&types.isEmpty()){
|
| 655 |
params.add(contextId); |
|
| 656 |
return " select count(*) from claim where "+" claim.source_id =?";
|
|
| 655 |
params.add(contextId+"%");
|
|
| 656 |
return " select count(*) from claim where "+" claim.source_id like ?";
|
|
| 657 | 657 |
} |
| 658 | 658 |
return " select count(*) from claim where claim.id in ( select claim.id from ("+generateFetchClaimsByContext(contextId, null,null,keyword,null,false, types, params)+")as claim )";
|
| 659 | 659 |
|
| ... | ... | |
| 749 | 749 |
} |
| 750 | 750 |
|
| 751 | 751 |
public String generateFetchClaimsByContext(String contextId, Integer limit, Integer offset,String keyword, String orderBy, boolean desc, List<String> types, ArrayList<Object> params) {
|
| 752 |
String clause= "claim.source_id =?";
|
|
| 752 |
String clause= "claim.source_id like ?";
|
|
| 753 | 753 |
ArrayList<Object> clauseParams = new ArrayList<>(); |
| 754 |
clauseParams.add(contextId); |
|
| 754 |
clauseParams.add(contextId+'%');
|
|
| 755 | 755 |
String query = " select * from ("+" ( " +generateSelectclaimQuery(ClaimUtils.CONTEXT,ClaimUtils.PUBLICATION,limit, offset, orderBy,desc,clause,clauseParams, keyword, params)+")"+
|
| 756 | 756 |
") as claim "; |
| 757 | 757 |
String filterByType = addFilterByType(types, params); |
Also available in: Unified diff
close the db connection per request, in fetch claims by context id use like and wild character in order to get all claims of a community