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

Dependencies

• [2] TCXFZZFN * hydra: make chart zoomable and clickable
• [3] E2TOU3L6 * More indices.
• [4] NZI7E2E3 * hydra: handle case where logfile is empty
• [5] 2R7GHSA4 * hydra: added initial version of build graph
• [*] LBNVQXUB * Build the /build stuff in a separate controller.
• [*] J5UVLXOK * Start of a basic Catalyst web interface.
• [*] L2E6EVE2 * Merged the Build and Job tables.
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] 6QRHXIM3 * Speed up the jobset index page. Especially the query to get the

Change contents

• edit in src/lib/Hydra/Controller/Build.pm at line 61
  [4.607]

  [4.607]
  + , 'me.id' => { '<=' => $build->id }
• replacement in src/lib/Hydra/Controller/Build.pm at line 63
  [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

  + }
• edit in src/lib/Hydra/Schema/Builds.pm at line 218
  [9.3767]

  [9.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
  [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') %]]);
• edit in src/sql/hydra.sql at line 434
  [3.158]

  [11.2524]
  + create index IndexBuildStepsOnOutpathBuild on BuildSteps (outpath, build);