* PostgreSQL compatibility.

Dependencies

• [2] RAKTHYAI * In the job status and error pages, show when the status of a job
• [3] FPK5LF53 * Put the project-related actions in a separate controller. Put the
• [4] 75XUS62Y * Added a page to quickly see all failed builds and failed evaluations
• [5] SJN2QPWH * Big speed-up of the job status page and the channel generation (such
• [6] DEMSSSB2 * Controller for jobs which inherits all actions in ListBuilds. So
• [7] ZD5AEKWM * Job status / error pages: show only active jobs.
• [*] J5UVLXOK * Start of a basic Catalyst web interface.

Change contents

• replacement in src/lib/Hydra/Base/Controller/ListBuilds.pm at line 59
  [3.534]→[2.801:879](∅→∅)
  − [getJobStatus($self, $c)->search({'me.buildstatus' => {'!=' => 0}})];
  [3.534]

  [3.330]
  + [getJobStatus($self, $c)->search({'resultInfo.buildstatus' => {'!=' => 0}})];
• replacement in src/lib/Hydra/Schema/Builds.pm at line 219
  [2.1374]→[2.1374:1964](∅→∅)
  − makeSource('JobStatus' . $name, "select *, b.id statusChangeId, b.timestamp statusChangeTime from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 $constraint group by project, jobset, job, system) as latest natural join Builds x $joinWithStatusChange");

  − makeSource('LatestSucceeded' . $name, "select * from (select project, jobset, job, system, max(id) as id from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) as latest natural join Builds x $joinWithStatusChange");
  [2.1374]

  [3.3029]
  + # Urgh, can't use "*" in the "select" here because of the status change join.

  + makeSource('JobStatus' . $name, "select x.id, x.finished, x.timestamp, x.project, x.jobset, x.job, x.nixname, x.description, x.drvpath, x.outpath, x.system, x.longdescription, x.license, x.homepage, x.maintainers, b.id as statusChangeId, b.timestamp as statusChangeTime from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 $constraint group by project, jobset, job, system) as latest natural join Builds x $joinWithStatusChange");

  + makeSource('LatestSucceeded' . $name, "select * from (select project, jobset, job, system, max(id) as id from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) as latest natural join Builds x");