* PostgreSQL compatibility.

Dependencies

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