hydra: moves jobsetOverview sub

Dependencies

• [2] XBU2ODSP * More renaming.
• [3] UC3YQDZF * Don't access /nix/var/nix/db directly but use the Nix Perl bindings.
• [4] BKOIYITR added some json responses
• [5] UWVMQIAC * Refactoring.
• [6] AKAXJDMW * Disable the statistics on the project, jobset and job pages for now
• [7] 5QE3TIHP hydra: add status icon per jobset on project page
• [8] A63IHCMX * Register GC roots properly.
• [9] 2GK5DOU7 * Downloading closures.
• [10] GNIEG2GC * Disambiguate jobs by jobset name. I.e. jobs with the same name in
• [11] FPK5LF53 * Put the project-related actions in a separate controller. Put the
• [12] HEZ2V5NU order jobset in project view
• [13] ODNCGFQ5 * Improved the navigation bar: don't include all projects (since that
• [14] PPJN6SDP * paging for releases page
• [*] AFTXA575 * $HYDRA_DATA environment variable.

Change contents

• edit in src/lib/Hydra/Controller/Project.pm at line 9
  [5.1457]→[4.6174:6233](∅→∅),[4.6233]→[5.1457:1458](∅→∅),[5.1457]→[5.1457:1458](∅→∅)
  − our @ISA = qw(Exporter);

  − our @EXPORT = qw(jobsetOverview);

  −
• edit in src/lib/Hydra/Controller/Project.pm at line 19
  [5.1756]→[4.6234:7135](∅→∅),[4.7135]→[5.1756:1757](∅→∅),[5.1756]→[5.1756:1757](∅→∅)
  − sub jobsetOverview {

  − my ($c, $project) = @_;

  − return $project->jobsets->search( isProjectOwner($c, $project->name) ? {} : { hidden => 0 },

  − { order_by => "name"

  − , "+select" => [

  − "(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildSchedulingInfo WHERE me.project = a.project AND me.name = a.jobset AND a.isCurrent = 1 )"

  − , "(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildResultInfo WHERE me.project = a.project AND me.name = a.jobset AND buildstatus <> 0 AND a.isCurrent = 1 )"

  − , "(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildResultInfo WHERE 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 )"

  − ]

  − , "+as" => ["nrscheduled", "nrfailed", "nrsucceeded", "nrtotal"]

  − });

  − }

  −
• edit in src/lib/Hydra/Helper/Nix.pm at line 8
  [3.9]

  [16.127]
  + use Hydra::Helper::CatalystUtils;
• replacement in src/lib/Hydra/Helper/Nix.pm at line 17
  [5.654]→[2.324:375](∅→∅)
  − getViewResult getLatestSuccessfulViewResult );
  [5.654]

  [5.486]
  + getViewResult getLatestSuccessfulViewResult jobsetOverview);
• edit in src/lib/Hydra/Helper/Nix.pm at line 200
  [5.2925]

  [2.1051]
  + sub jobsetOverview {

  + my ($c, $project) = @_;

  + return $project->jobsets->search( isProjectOwner($c, $project->name) ? {} : { hidden => 0 },

  + { order_by => "name"

  + , "+select" => [

  + "(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildSchedulingInfo WHERE me.project = a.project AND me.name = a.jobset AND a.isCurrent = 1 )"

  + , "(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildResultInfo WHERE me.project = a.project AND me.name = a.jobset AND buildstatus <> 0 AND a.isCurrent = 1 )"

  + , "(SELECT COUNT(*) FROM Builds AS a NATURAL JOIN BuildResultInfo WHERE 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 )"

  + ]

  + , "+as" => ["nrscheduled", "nrfailed", "nrsucceeded", "nrtotal"]

  + });

  + }