grahamc/hydra2 - Change 7ZVZJK54M4UA2PKHGJT572PKDBAEAYS5JWSBOOEY7XEB3YX3RCDAC

Re-enable the "Related Builds" tab

However, there is a "limit 1" on the JobsetEval search to prevent a sequential scan of the Builds table.

Created by Eelco Dolstra on March 12, 2012

7ZVZJK54M4UA2PKHGJT572PKDBAEAYS5JWSBOOEY7XEB3YX3RCDAC

Dependencies

In channels

main

Change contents

Replacement in src/lib/Hydra/Controller/Build.pm at line 83 [4.1]

B:BD[3.250] → [2.1074:1432]

    #my $r = joinWithResultInfo( $c, $c->model('DB::Builds'))->search(
    #    { eval => { -in => $build->jobsetevalmembers->all->get_column('eval')->as_query } }
    #  , { join => 'jobsetevalmembers', order_by => [ 'project', 'jobset', 'job'], distinct => 1 }
    #  );
    #if ($r->count <= 100) {
    #    $c->stash->{relatedbuilds} = [$r->all];
    #}

[3.250]

[4.1111]

    my $maxRelated = 100;
    my $r = $c->model('DB::Builds')->search(
        { eval => { -in => $build->jobsetevalmembers->search({}, {rows => 1})->get_column('eval')->as_query } },
        { join => 'jobsetevalmembers', order_by => [ 'project', 'jobset', 'job'], distinct => 1, rows => $maxRelated + 1 }
    );
    $c->stash->{relatedbuilds} = [$r->all];
    delete $c->stash->{relatedbuilds} if scalar(@{$c->stash->{relatedbuilds}}) > $maxRelated;