schema/Builds: use jobset_id instead of jobset name matches

Dependencies

• [2] MMBKNEQB LatestSucceededForJob{,set}: Filter with jobset_id
• [3] 3HZY24CX * Make jobsets viewable under
• [4] RI4S7SYT * Job status: show the active jobs.
• [5] DEMSSSB2 * Controller for jobs which inherits all actions in ListBuilds. So
• [6] UWVMQIAC * Refactoring.
• [7] SJN2QPWH * Big speed-up of the job status page and the channel generation (such
• [8] 7ZSVXUGF sequence fix for postgresql
• [9] 75XUS62Y * Added a page to quickly see all failed builds and failed evaluations
• [10] L2E6EVE2 * Merged the Build and Job tables.
• [*] J5UVLXOK * Start of a basic Catalyst web interface.

Change contents

• replacement in src/lib/Hydra/Controller/Job.pm at line 175
  [3.665]→[2.97:182](∅→∅)
  − ->search({}, {bind => [$c->stash->{jobset}->name, $c->stash->{job}->name]});
  [3.665]

  [3.799]
  + ->search({}, {bind => [$c->stash->{jobset}->id, $c->stash->{job}->name]});
• replacement in src/lib/Hydra/Controller/Jobset.pm at line 165
  [3.1036]→[2.183:244](∅→∅)
  − ->search({}, {bind => [$c->stash->{jobset}->name]});
  [3.1036]

  [3.1029]
  + ->search({}, {bind => [$c->stash->{jobset}->id]});
• replacement in src/lib/Hydra/Schema/Builds.pm at line 625
  [3.3099]→[2.245:432](∅→∅)
  − makeQueries('ForJobset', "and jobset_id = (select id from jobsets j where j.name = ?)");

  − makeQueries('ForJob', "and jobset_id = (select id from jobsets j where j.name = ?) and job = ?");
  [3.3099]

  [3.3228]
  + makeQueries('ForJobset', "and jobset_id = ?");

  + makeQueries('ForJob', "and jobset_id = ? and job = ?");