my $jobs = $c->stash->{allJobs};

        getLatestBuilds($c, ref $jobs eq "ARRAY" ? $jobs : scalar $jobs->search({active => 1}), {});

        [joinWithResultInfo($c, $c->stash->{jobStatus})->all];

    $c->stash->{builds} = [$c->stash->{allBuilds}->search(

    $c->stash->{builds} = [joinWithResultInfo($c, $c->stash->{allBuilds})->search(

        { join => 'resultInfo'
        , '+select' => ["resultInfo.buildstatus", "resultInfo.releasename"]
        , '+as' => ["buildstatus", "releasename"]
        , order_by => "timestamp DESC"

        { order_by => "timestamp DESC"

            getChannelData($c, getLatestBuilds($c, scalar $c->stash->{allJobs}->search({active => 1}), {buildStatus => 0}));

            getChannelData($c, scalar($c->stash->{latestSucceeded}));

            getChannelData($c, [$c->stash->{allBuilds}->all]);

            getChannelData($c, scalar($c->stash->{allBuilds}));

    return $build->resultInfo->releasename || $build->nixname;

    return $build->get_column('releasename') || $build->nixname;

    #$c->stash->{allJobs} = # !!! horribly hacky
    #    $c->stash->{job}->jobset->jobs->search({name => $c->stash->{job}->name});
    $c->stash->{allJobs} = [$c->stash->{job}];

    $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForJob')
        ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name, $c->stash->{job}->name]});
    $c->stash->{latestSucceeded} = $c->model('DB')->resultset('LatestSucceededForJob')
        ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name, $c->stash->{job}->name]});

    $c->stash->{allJobs} = $c->stash->{jobset}->jobs;

    $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForJobset')
        ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name]});
    $c->stash->{latestSucceeded} = $c->model('DB')->resultset('LatestSucceededForJobset')
        ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name]});

    $c->stash->{allJobs} = $c->stash->{project}->jobs;

    $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForProject')
        ->search({}, {bind => [$c->stash->{project}->name]});
    $c->stash->{latestSucceeded} = $c->model('DB')->resultset('LatestSucceededForProject')
        ->search({}, {bind => [$c->stash->{project}->name]});

    $c->stash->{allJobs} = $c->model('DB::Jobs');

    $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatus');
    $c->stash->{latestSucceeded} = $c->model('DB')->resultset('LatestSucceeded');

    getBuild getBuildStats getLatestBuilds getChannelData

    getBuild getBuildStats joinWithResultInfo getChannelData

# Return the latest build for each job.
sub getLatestBuilds {
    my ($c, $jobs, $extraAttrs) = @_;

    my @res = ();

    # !!! this could be done more efficiently.

# Add the releaseName and buildStatus attributes from the
# BuildResultInfo table for each build.
sub joinWithResultInfo {
    my ($c, $source) = @_;

    foreach my $job (ref $jobs eq "ARRAY" ? @{$jobs} : $jobs->all) {
        foreach my $system ($job->builds->search({}, {select => ['system'], distinct => 1})) {
            my ($build) = $job->builds->search(
                { finished => 1, system => $system->system, %$extraAttrs },
                { join => 'resultInfo', order_by => 'timestamp DESC', rows => 1
                , '+select' => ["resultInfo.releasename", "resultInfo.buildstatus"]
                , '+as' => ["releasename", "buildstatus"]
                });
            push @res, $build if defined $build;
        }
    }
    return [@res];

    return $source->search(
        { },
        { join => 'resultInfo'
        , '+select' => ["resultInfo.releasename", "resultInfo.buildstatus"]
        , '+as' => ["releasename", "buildstatus"]
        });

    my @builds2 = joinWithResultInfo($c, $builds)
        ->search_literal("exists (select 1 from buildproducts where build = me.id and type = 'nix-build')");

    foreach my $build (@{$builds}) {
        # !!! better do this in getLatestBuilds with a join.
        next unless $build->buildproducts->find({type => "nix-build"});

    foreach my $build (@builds2) {

sub makeSource {
    my ($name, $query) = @_;
    my $source = __PACKAGE__->result_source_instance();
    my $new_source = $source->new($source);
    $new_source->source_name($name);
    $new_source->name(\ "($query)");
    Hydra::Schema->register_extra_source($name => $new_source);
}
sub makeQueries {
    my ($name, $constraint) = @_;
    makeSource('JobStatus' . $name, "select * from (select project, jobset, job, system, max(timestamp) timestamp from Builds where finished = 1 $constraint group by project, jobset, job, system) natural join Builds");
    makeSource('LatestSucceeded' . $name, "select * from (select project, jobset, job, system, max(timestamp) timestamp from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) natural join Builds");
}

makeQueries('', "");
makeQueries('ForProject', "and project = ?");
makeQueries('ForJobset', "and project = ? and jobset = ?");
makeQueries('ForJob', "and project = ? and jobset = ? and job = ?");

        <td><a href="[% uri %]"><tt>[% build.resultInfo.releasename || build.nixname %]</tt></a></td>

        <td><a href="[% uri %]"><tt>[% build.get_column('releasename') || build.nixname %]</tt></a></td>

create index IndexBuildsByTimestamp on Builds(timestamp);
--create index IndexBuildsByJobAndSystem on Builds(project, jobset, job, system);