grahamc/hydra2 - Change 2QA4Y4G3VK3CGBMWET2LROJTZRFVR5G2Y6GXUCIOCGZB7YQ3L7FAC

* hydra: added index, actual build time (buildstep with same outpath, so without deps) of the build

Created by Rob Vermaas on February 11, 2010

2QA4Y4G3VK3CGBMWET2LROJTZRFVR5G2Y6GXUCIOCGZB7YQ3L7FAC

Dependencies

In channels

main

Change contents

Insertion in src/lib/Hydra/Controller/Build.pm at line 61 [5.1]
[4.607]
[4.607]
```
            , 'me.id' =>  { '<=' => $build->id }
```

Replacement in src/lib/Hydra/Controller/Build.pm at line 63 [5.1]

B:BD[4.621] → [2.0:51]

          , { order_by => "id DESC", rows => 100 }

[4.621]

[4.671]

          , { join => "actualBuildStep"
            , "+select" => ["actualBuildStep.stoptime - actualBuildStep.starttime"]
            , "+as" => ["actualBuildTime"]
            , order_by => "id DESC"
            , rows => 50
            }

Insertion in src/lib/Hydra/Schema/Builds.pm at line 218 [7.5202]

[6.3767]

);
__PACKAGE__->has_one(
  "actualBuildStep",
  "Hydra::Schema::BuildSteps",
  { 'foreign.outpath' => 'self.outpath' 
  , 'foreign.build' => 'self.id'
  },

Replacement in src/root/build.tt at line 433 [7.7350]

B:BD[2.485] → [2.485:615]

      d.push([[% prevbuild.resultInfo.starttime * 1000 %],[% prevbuild.resultInfo.stoptime - prevbuild.resultInfo.starttime %]]);

[2.485]

[2.615]

      d.push([[% prevbuild.resultInfo.starttime * 1000 %],[% prevbuild.get_column('actualBuildTime') %]]);

Insertion in src/sql/hydra.sql at line 434 [9.1]

[3.158]

[8.2524]

create index IndexBuildStepsOnOutpathBuild on BuildSteps (outpath, build);