perl: jobsetevals -> jobset via by jobset_id

Dependencies

• [2] J6T5EF5N Fix cancelling non-current builds
• [3] VU2OLHD2 Move most of AddBuilds to hydra-eval-jobset
• [4] U4TD3AIQ Add support for viewing jobset evaluations
• [5] DETQRBBR clear_queue_non_current: Don't use isCurrent
• [6] OS2MRE4J Restore build and eval IDs.
• [7] LPPZS34Y Merge remote-tracking branch 'origin/master' into flake
• [8] KEBKLMYZ clear-queue-non-current: Work around PostgreSQL query optimizer stupidity
• [9] BIVZGPUT Optimise clickable rows
• [10] 2VBQRQ2Q Fix some XML well-formedness problems
• [11] 6GEU36HW Remove obsolete CSS classes
• [12] QFI54DW2 Fix duplicate row-link
• [13] CQTN62OH Die tabs die
• [14] UEMB7PTH Add option eval_substituter
• [15] 4WZQW2N6 Fix indentation and get rid of some unnecessary whitespace in the output
• [16] UOINKJ2J Add an action to cancel all builds in a jobset eval
• [17] VH5ZABDR Add a page to show the latest evaluations for the entire server
• [18] WT3RUYHS Likewise remove eval IDs from eval lists
• [19] 67NFGL7D add links in admin page to clear queue (all non-running builds, and all non-running old (non-current) builds)
• [20] Q6VFUIC6 Remove hydra-eval-guile-jobs
• [21] U5ZWDBW3 Ensure that each eval is compared to the previous one from the same jobset
• [22] ND75XNSQ Allow showing all evaluations that contain a given build
• [23] QGLBQ5IO Remove hydra-eval-guile-jobs
• [24] 6S3ZLOZL Return JSON for /eval
• [*] ZWCTAZGL added newsitems, added some admin options to clear various caches.
• [*] 2GK5DOU7 * Downloading closures.
• [*] IK53RV4V
• [*] N22GPKYT * Put info about logs / build products in the DB.

Change contents

• replacement in src/lib/Hydra/Controller/Admin.pm at line 37
  [4.50]→[2.0:251](∅→∅)
  − { id => { -in => \ "select id from Builds where id in ((select id from Builds where finished = 0) except (select build from JobsetEvalMembers where eval in (select max(id) from JobsetEvals where hasNewBuilds = 1 group by project, jobset)))" }
  [4.50]

  [4.51]
  + { id => { -in => \ "select id from Builds where id in ((select id from Builds where finished = 0) except (select build from JobsetEvalMembers where eval in (select max(id) from JobsetEvals where hasNewBuilds = 1 group by jobset_id)))" }
• edit in src/lib/Hydra/Controller/JobsetEval.pm at line 19
  [4.1705]→[4.1705:1748](∅→∅)
  − $c->stash->{project} = $eval->project;
• edit in src/lib/Hydra/Controller/JobsetEval.pm at line 20
  [4.1789]

  [4.1789]
  + $c->stash->{project} = $eval->jobset->project;
• replacement in src/lib/Hydra/Helper/Nix.pm at line 222
  [4.1465]→[4.1465:1564](∅→∅)
  − { project => $curEval->get_column('project'), jobset => $curEval->get_column('jobset')
  [4.1465]

  [4.1564]
  + { jobset_id => $curEval->get_column('jobset_id')
• replacement in src/root/common.tt at line 466
  [4.800]→[4.3203:3327](∅→∅),[4.3203]→[4.3203:3327](∅→∅)
  − <td>[% INCLUDE renderFullJobsetName project=eval.get_column('project') jobset=eval.get_column('jobset') %]</td>
  [4.800]

  [4.3327]
  + <td>[% INCLUDE renderFullJobsetName project=eval.jobset.project.name jobset=eval.jobset.name %]</td>
• edit in src/script/hydra-eval-jobset at line 194
  [3.5007]

  [3.5007]
  + my $jobset = $db->resultset('Jobsets')->find({ project => $1, name => $2 });

  + die "jobset ‘$1:$2’ does not exist\n" unless defined $jobset;

  +
• replacement in src/script/hydra-eval-jobset at line 198
  [3.5060]→[3.5060:5124](∅→∅)
  − { project => $1, jobset => $2, hasnewbuilds => 1 },
  [3.5060]

  [3.5124]
  + { jobset_id => $jobset->id, hasnewbuilds => 1 },