jobset overview: join jobsets to builds by jobset id

Dependencies

• [2] RBHHV7P7 * Read logs using logContents function in stead of handling it everywhere separately.
• [3] HPEG2RHV Merge the BuildResultInfo table into the Builds table
• [4] NP6QUCL7 * Fix indentation.
• [5] VU722JBC jobsets: put hidden and enabled jobsets at the end
• [6] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
• [*] 2GK5DOU7 * Downloading closures.

Change contents

• replacement in src/lib/Hydra/Helper/Nix.pm at line 118
  [2.440]→[3.3312:3452](∅→∅),[3.172]→[3.3312:3452](∅→∅),[3.3452]→[3.5275:5596](∅→∅),[3.5596]→[3.3803:3924](∅→∅),[3.3803]→[3.3803:3924](∅→∅)
  − [ "(select count(*) from Builds as a where a.finished = 0 and me.project = a.project and me.name = a.jobset and a.isCurrent = 1)"

  − , "(select count(*) from Builds as a where a.finished = 1 and me.project = a.project and me.name = a.jobset and buildstatus <> 0 and a.isCurrent = 1)"

  − , "(select count(*) from Builds as a where a.finished = 1 and me.project = a.project and me.name = a.jobset and buildstatus = 0 and a.isCurrent = 1)"

  − , "(select count(*) from Builds as a where me.project = a.project and me.name = a.jobset and a.isCurrent = 1)"
  [2.440]

  [3.788]
  + [ "(select count(*) from Builds as a where me.id = a.jobset_id and a.finished = 0 and a.isCurrent = 1)"

  + , "(select count(*) from Builds as a where me.id = a.jobset_id and a.finished = 1 and buildstatus <> 0 and a.isCurrent = 1)"

  + , "(select count(*) from Builds as a where me.id = a.jobset_id and a.finished = 1 and buildstatus = 0 and a.isCurrent = 1)"

  + , "(select count(*) from Builds as a where me.id = a.jobset_id and a.isCurrent = 1)"