$c->model('DB::Builds')->search({project => $projectName}, {join => 'resultInfo', select => {sum => 'starttime'}});
    
    $c->stash->{finishedBuilds} = $c->model('DB::Builds')->search(
        {project => $projectName, finished => 1});
        
    $c->stash->{succeededBuilds} = $c->model('DB::Builds')->search(
        {project => $projectName, finished => 1, buildStatus => 0},
        {join => 'resultInfo'});
        
    $c->stash->{scheduledBuilds} = $c->model('DB::Builds')->search(
        {project => $projectName, finished => 0});
        
    $c->stash->{busyBuilds} = $c->model('DB::Builds')->search(
        {project => $projectName, finished => 0, busy => 1},
        {join => 'schedulingInfo'});
        
    $c->stash->{totalBuildTime} = $c->model('DB::Builds')->search(
        {project => $projectName},
        {join => 'resultInfo', select => {sum => 'stoptime - starttime'}, as => ['sum']})
        ->first->get_column('sum');
    

    $c->stash->{curTime} = time;

    <tr><th>Nr</th><th>What</th><th>Status</th></tr>

    <tr><th>Nr</th><th>What</th><th>Duration</th><th>Status</th></tr>

          [% IF step.busy == 0 %]
            [% step.stoptime - step.starttime %]s
          [% ELSE %]
            [% curTime - step.starttime %]s
          [% END %]
        </td>
        <td>

[% IF build.buildlogs %]

[% END %]

<table>
  <tr><th></th><th>Id</th><th>Project</th><th>Job</th><th>System</th><th>Timestamp</th><th>Description</th></tr>
  [% FOREACH build IN builds -%]
    [% INCLUDE "short-build-info.tt" %]
  [% END -%]

<table class="tablesorter">
  <thead>
    <tr><th></th><th>Id</th><th>Project</th><th>Job</th><th>System</th><th>Timestamp</th><th>Description</th></tr>
  </thead>
  <tbody>
    [% FOREACH build IN builds -%]
      [% INCLUDE "short-build-info.tt" %]
    [% END -%]
  </tbody>

  <p>
    Description: [% jobset.description %]
    <br />
    Nix expression: <tt>[% jobset.nixexprpath %]</tt> in input <tt>[% jobset.nixexprinput %]</tt>
  </p>

  <h4>Information</h4>
  <table>
    <tr>
      <th>Description:</th>
      <td>[% jobset.description %]</td>
    </tr>
    <tr>
      <th>Nix expression:</th>
      <td><tt>[% jobset.nixexprpath %]</tt> in input <tt>[% jobset.nixexprinput %]</tt></td>
    </tr>
  </table>
  <h4>Inputs</h4>

<h2>Statistics</h2>

<table>
  <tr>
    <th>Finished builds:</th>
    <td>[% finishedBuilds %]</td>
  </tr>
  <tr>
    <th><img src="/static/images/success.gif" /> Succeeded builds:</th>
    <td>[% succeededBuilds %]</td>
  </tr>
  <tr>
    <th><img src="/static/images/failure.gif" /> Failed builds:</th>
    <td>[% finishedBuilds - succeededBuilds %]</td>
  </tr>
  <tr>
    <th>Total build time:</th>
    <td>[% totalBuildTime %]s</td>
  </tr>
  <tr>
    <th>Scheduled builds:</th>
    <td>[% scheduledBuilds %]</td>
  </tr>
  <tr>
    <th>Currently executing builds:</th>
    <td>[% busyBuilds %]</td>
  </tr>
</table>

                        , starttime => time

                    $step->stoptime(time);

                    die unless $step;
                    $step->busy(0);
                    $step->status(1);
                    $step->errormsg($4);
                    $step->update;

                    if ($step) {
                        die unless $step;
                        $step->busy(0);
                        $step->status(1);
                        $step->errormsg($4);
                        $step->stoptime(time);
                        $step->update;
                    } else {
                        $db->resultset('Buildsteps')->create(
                            { id => $build->id
                            , stepnr => $buildStepNr++
                            , type => 0 # = build
                            , drvpath => $drvPath
                            , outpath => $2
                            , logfile => $4
                            , busy => 0
                            , status => 1
                            , starttime => time
                            , stoptime => time
                            , errormsg => $4
                            });
                    }

    sleep(10);

    sleep(5);