Builds: LatestSucceeded*: remove project, jobset references

Dependencies

• [2] VGUFW62F schema/Builds: use jobset_id instead of jobset name matches
• [3] L2E6EVE2 * Merged the Build and Job tables.
• [4] SZYY2EQQ * Make the queries more readable.
• [5] HPEG2RHV Merge the BuildResultInfo table into the Builds table
• [6] MESO2HDV Remove obsolete JobStatus source
• [7] 7ZSVXUGF sequence fix for postgresql
• [8] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
• [9] MMBKNEQB LatestSucceededForJob{,set}: Filter with jobset_id
• [10] Z4KRJX4Q * In the last succeeded / job status queries, use the Builds.isCurrent
• [11] SJN2QPWH * Big speed-up of the job status page and the channel generation (such
• [12] 3PNG7NIB Remove trailing whitespace
• [*] J5UVLXOK * Start of a basic Catalyst web interface.

Change contents

• replacement in src/lib/Hydra/Schema/Result/Builds.pm at line 541
  [3.2618]→[3.617:732](∅→∅),[3.617]→[3.617:732](∅→∅)
  − my $activeJobs = "(select distinct project, jobset, job, system from Builds where isCurrent = 1 $constraint)";
  [3.2618]

  [3.2815]
  + my $activeJobs = "(select distinct jobset_id, job, system from Builds where isCurrent = 1 $constraint)";
• replacement in src/lib/Hydra/Schema/Result/Builds.pm at line 551
  [3.2860]→[3.2860:2938](∅→∅)
  − project = activeJobs.project and jobset = activeJobs.jobset
  [3.2860]

  [3.2938]
  + jobset_id = activeJobs.jobset_id
• replacement in src/lib/Hydra/Schema/Result/Builds.pm at line 563
  [3.3053]→[3.3053:3099](∅→∅)
  − makeQueries('ForProject', "and project = ?");
  [3.3053]

  [2.144]
  + makeQueries('ForProject', "and jobset_id in (select id from jobsets j where j.project = ?)");