Revision 57532
Added by Ioannis Diplas over 4 years ago
JobsDAOImpl.java | ||
---|---|---|
986 | 986 |
Map<Integer, List<JobResultEntry>> results = new HashMap<>(); |
987 | 987 |
try { |
988 | 988 |
con = getConnection(); |
989 |
String query="select rules.name, rules.description, rules.weight, rules.mandatory, total, successes, rules.id, rules.job_type, job_results.job_id from job_results join rules on job_results.rule_id = rules.id join jobs on jobs.id = job_results.job_id where jobs.repo in ("+ builder.deleteCharAt( builder.length() -1 ).toString() +") order by job_results.job_id limit " + size;
|
|
989 |
String query="select rules.name, rules.description, rules.weight, rules.mandatory, total, successes, rules.id, rules.job_type, job_results.job_id from job_results join rules on job_results.rule_id = rules.id join (SELECT * FROM jobs WHERE jobs.repo in ("+ builder.deleteCharAt( builder.length() -1 ).toString() +") LIMIT "+size+ " ) as foo on foo.id = job_results.job_id order by job_results.job_id ";
|
|
990 | 990 |
stmt = con.prepareStatement(query); |
991 | 991 |
int index = 1; |
992 | 992 |
for( String o : baseUrls) { |
Also available in: Unified diff
Bug fix for validation summary