grahamc/hydra2 - Change T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC

* Add some DB indices to make the /releases page much faster.

Reduce the number of DB queries for the /all and /jobstatus pages.
Show the Hydra version number.

Created by Eelco Dolstra on March 23, 2009

T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC

Dependencies

In channels

main

Change contents

Replacement in release.nix at line 108 [7.1]

∅:D[6.76] → [7.1744:1798]

∅:D[8.381] → [7.1744:1798]

B:BD[7.1744] → [7.1744:1798]

                  --set HYDRA_HOME $out/libexec/hydra

[8.381]

[7.1798]

                  --set HYDRA_HOME $out/libexec/hydra \
                  --set HYDRA_RELEASE ${tarball.version}

Replacement in src/lib/Hydra/Base/Controller/ListBuilds.pm at line 37 [9.1]

B:BD[9.882] → [9.882:981]

        {finished => 1}, {order_by => "timestamp DESC", rows => $resultsPerPage, page => $page})];

[9.882]

[9.981]

        { finished => 1 },
        { join => 'resultInfo'
        , '+select' => ["resultInfo.buildstatus", "resultInfo.releasename"]
        , '+as' => ["buildstatus", "releasename"]
        , order_by => "timestamp DESC"
        , rows => $resultsPerPage
        , page => $page })];

Insertion in src/lib/Hydra/Controller/Root.pm at line 18 [11.804]
[10.44]
[11.1351]
```
    $c->stash->{version} = $ENV{"HYDRA_RELEASE"} || "<devel>";
```

Replacement in src/lib/Hydra/Controller/Root.pm at line 82 [11.804]

B:BD[12.605] → [13.72:140]

    die "Project $projectName doesn't exist." if !defined $project;

[12.605]

[14.1136]

    notFound($c, "Project $projectName doesn't exist.") if !defined $project;

Replacement in src/lib/Hydra/Controller/Root.pm at line 86 [11.804]

∅:D[15.90] → [16.140:218]

B:BD[16.140] → [16.140:218]

    die "Release set $releaseSetName doesn't exist." if !defined $releaseSet;

[15.90]

[12.904]

    notFound($c, "Release set $releaseSetName doesn't exist.") if !defined $releaseSet;

Replacement in src/lib/Hydra/Controller/Root.pm at line 105 [11.804]

B:BD[16.429] → [5.0:102]

    die "Invalid release set name: $releaseSetName" unless $releaseSetName =~ /^[[:alpha:]][\w\-]*$/;

[16.429]

[16.527]

    error($c, "Invalid release set name: $releaseSetName")
        unless $releaseSetName =~ /^[[:alpha:]][\w\-]*$/;

Replacement in src/lib/Hydra/Controller/Root.pm at line 142 [11.804]

B:BD[17.736] → [17.736:847]

    die "There must be one primary job." if $releaseSet->releasesetjobs->search({isprimary => 1})->count != 1;

[17.736]

[18.0]

    error($c, "There must be one primary job.")
        if $releaseSet->releasesetjobs->search({isprimary => 1})->count != 1;

Replacement in src/lib/Hydra/Controller/Root.pm at line 190 [11.804]

B:BD[19.387] → [19.387:455]

    die "Project $projectName doesn't exist." if !defined $project;

[19.387]

[14.1174]

    error($c, "Project $projectName doesn't exist.") if !defined $project;

Replacement in src/lib/Hydra/Controller/Root.pm at line 228 [11.804]

B:BD[13.2500] → [13.2500:2602]

B:BD[13.2602] → [20.2824:2902]

        { join => 'resultInfo', '+select' => ["resultInfo.releasename"], '+as' => ["releasename"] });
    error($c, "Release $releaseId doesn't exist.") if !defined $primaryBuild;

[13.2500]

[4.89]

        { join => 'resultInfo',
        , '+select' => ["resultInfo.releasename", "resultInfo.buildstatus"]
        , '+as' => ["releasename", "buildstatus"] })
        or error($c, "Release $releaseId doesn't exist.");

Replacement in src/lib/Hydra/Helper/CatalystUtils.pm at line 58 [21.3469]

B:BD[3.1072] → [3.1072:1156]

                { join => 'resultInfo', order_by => 'timestamp DESC', rows => 1 });

[3.1072]

[3.1156]

                { join => 'resultInfo', order_by => 'timestamp DESC', rows => 1
                , '+select' => ["resultInfo.releasename", "resultInfo.buildstatus"]
                , '+as' => ["releasename", "buildstatus"]
                });

Replacement in src/lib/Hydra/Helper/Nix.pm at line 133 [23.436]

B:BD[22.1648] → [22.1648:1724]

        , '+select' => ["resultInfo.releasename"], '+as' => ["releasename"]

[22.1648]

[22.1724]

        , '+select' => ["resultInfo.releasename", "resultInfo.buildstatus"]
        , '+as' => ["releasename", "buildstatus"]

Replacement in src/lib/Hydra/Helper/Nix.pm at line 162 [23.436]

B:BD[22.2478] → [24.607:712]

                { jobset => $job->get_column('jobset'), job => $job->get_column('job'), finished => 1 },

[22.2478]

[22.2536]

                { project => $job->get_column('project'), jobset => $job->get_column('jobset')
                , job => $job->get_column('job'), finished => 1 },

Insertion in src/lib/Hydra/Helper/Nix.pm at line 167 [23.436]

[22.2710]

                , '+select' => ["resultInfo.buildstatus"], '+as' => ["buildstatus"]

Replacement in src/lib/Hydra/Helper/Nix.pm at line 174 [23.436]

B:BD[22.2874] → [22.2874:2939]

            } elsif ($thisBuild->resultInfo->buildstatus != 0) {

[22.2874]

[22.2939]

            } elsif ($thisBuild->get_column('buildstatus') != 0) {

Replacement in src/root/common.tt at line 83 [26.2803]

B:BD[25.1290] → [25.1290:1347]

              [% IF build.resultInfo.buildstatus == 0 %]

[25.1290]

[27.1015]

              [% IF build.get_column('buildstatus') == 0 %]

Replacement in src/root/common.tt at line 97 [26.2803]

∅:D[28.1159] → [29.307:408]

∅:D[30.1383] → [29.307:408]

∅:D[31.4114] → [29.307:408]

∅:D[32.4688] → [29.307:408]

B:BD[25.1981] → [29.307:408]

          <td>[% build.resultInfo.releasename ? build.resultInfo.releasename : build.nixname %]</td>

[32.4688]

[25.1981]

          <td>[% build.get_column('releasename') ? build.get_column('releasename') : build.nixname %]</td>

Replacement in src/root/layout.tt at line 149 [11.11219]

B:BD[33.4834] → [2.1452:1505]

          Generated on [% INCLUDE renderDateTime %].

[33.4834]

[34.4708]

          <em>Hydra [% HTML.escape(version) %].</em>
          Page generated on [% INCLUDE renderDateTime %].

Replacement in src/root/releases.tt at line 51 [12.8435]

B:BD[12.9661] → [12.9661:9724]

                [% IF job.build.resultInfo.buildstatus == 0 %]

[12.9661]

[12.9724]

                [% IF job.build.get_column('buildstatus') == 0 %]

Insertion in src/sql/hydra.sql at line 404 [35.1]

[12.13513]


-- Some indices.
create index IndexBuildInputsByBuild on BuildInputs(build);
create index IndexBuildInputsByDependency on BuildInputs(dependency);