grahamc/hydra2 - Change P5X4P6VKS5CJOOLJRVL66GRJLDLVC3EKAVAHP2RJOXQJ7WTYAUBQC

* Renaming "release sets" to "views" (not finished yet). Having

releases as a dynamic view on the database was misguided, since doing thing like adding a new job to a release set will invalidate all old releases. So we rename release sets to views, and we'll reintroduce releases as separate, static entities in the database.

Created by Eelco Dolstra on October 15, 2009

P5X4P6VKS5CJOOLJRVL66GRJLDLVC3EKAVAHP2RJOXQJ7WTYAUBQC

Dependencies

In channels

main

Change contents

Insertion in doc/dev-notes.txt at line 99 [7.1]

[5.71]

[7.4494]

  # Releases -> Views.
  alter table ReleaseSets rename to Views;
  alter table Views rename column name to view_;
  alter table ReleaseSetJobs rename to ViewJobs;
  alter table ViewJobs rename column release_ to view_;
  alter table ViewJobs drop column mayFail;
  alter table ViewJobs add column autorelease integer not null default 0;

Replacement in src/lib/Hydra/Controller/Project.pm at line 27 [9.1245]

B:BD[8.4557] → [8.4557:4630]

    $c->stash->{releaseSets} = [$c->stash->{project}->releasesets->all];

[8.4557]

[9.1942]

    $c->stash->{views} = [$c->stash->{project}->views->all];

Deletion in src/lib/Hydra/Controller/Root.pm at line 63 [12.804]

B:BD[10.821] → [11.53:57]

B:BD[11.540] → [13.0:20]

B:BD[13.20] → [14.0:49]

∅:D[14.49] → [13.66:71]

B:BD[13.66] → [13.66:71]

∅:D[13.71] → [11.540:605]

B:BD[11.540] → [11.540:605]

B:BD[11.605] → [15.465:543]

∅:D[15.543] → [16.1136:1173]

B:BD[13.140] → [16.1136:1173]

∅:D[16.1173] → [11.727:728]

B:BD[11.727] → [11.727:728]

B:BD[11.728] → [17.0:90]

B:BD[17.90] → [15.544:632]

∅:D[13.216] → [11.904:1026]

∅:D[14.218] → [11.904:1026]

∅:D[15.632] → [11.904:1026]

B:BD[11.904] → [11.904:1026]

B:BD[11.1026] → [18.0:92]

∅:D[18.92] → [13.305:306]

∅:D[14.310] → [13.305:306]

B:BD[13.305] → [13.305:306]

B:BD[13.306] → [19.0:56]

∅:D[19.56] → [13.371:431]

B:BD[13.371] → [13.371:431]

B:BD[13.484] → [13.484:485]

B:BD[13.485] → [19.57:88]

∅:D[19.88] → [20.0:1]

B:BD[13.589] → [20.0:1]

B:BD[20.1] → [19.89:145]

∅:D[19.145] → [13.1798:1802]

B:BD[13.1798] → [13.1798:1802]

B:BD[13.1802] → [14.311:429]

B:BD[14.429] → [15.633:750]

∅:D[21.102] → [14.527:532]

∅:D[15.750] → [14.527:532]

B:BD[14.527] → [14.527:532]

B:BD[14.532] → [22.314:442]

∅:D[22.442] → [18.93:495]

B:BD[14.668] → [18.93:495]

B:BD[18.495] → [23.0:1]

B:BD[23.1] → [21.103:185]

∅:D[21.185] → [23.75:130]

B:BD[23.75] → [23.75:130]

∅:D[23.130] → [18.495:496]

B:BD[18.495] → [18.495:496]

B:BD[18.496] → [23.131:427]

∅:D[23.427] → [24.63:72]

B:BD[24.63] → [24.63:72]

∅:D[24.72] → [18.496:541]

B:BD[18.496] → [18.496:541]

B:BD[18.541] → [23.428:494]

∅:D[23.494] → [18.568:640]

B:BD[18.568] → [18.568:640]

B:BD[18.640] → [2.0:81]

∅:D[2.81] → [18.713:736]

B:BD[18.713] → [18.713:736]

B:BD[18.736] → [15.751:877]

∅:D[15.877] → [25.0:4]

B:BD[18.847] → [25.0:4]

∅:D[14.676] → [13.1802:1824]

B:BD[13.1802] → [13.1802:1824]

B:BD[13.1824] → [14.677:746]

∅:D[14.746] → [13.1920:1921]

B:BD[13.1920] → [13.1920:1921]

B:BD[13.1921] → [19.146:249]

∅:D[19.249] → [14.843:844]

B:BD[14.843] → [14.843:844]

B:BD[14.844] → [6.0:200]

∅:D[6.200] → [14.927:928]

B:BD[14.927] → [14.927:928]

B:BD[14.928] → [26.917:960]

∅:D[27.101] → [14.1119:1245]

∅:D[26.960] → [14.1119:1245]

B:BD[14.1119] → [14.1119:1245]

∅:D[14.1245] → [28.653:654]

∅:D[13.2014] → [28.653:654]

B:BD[11.1228] → [28.653:654]

B:BD[28.654] → [14.1246:1288]

B:BD[14.1288] → [29.387:437]

∅:D[29.437] → [14.1338:1513]

B:BD[14.1338] → [14.1338:1513]

B:BD[14.1513] → [30.0:42]

B:BD[30.42] → [29.438:488]

∅:D[29.488] → [30.92:145]

B:BD[30.92] → [30.92:145]

B:BD[30.145] → [4.0:116]

∅:D[4.116] → [30.226:237]

B:BD[30.226] → [30.226:237]

B:BD[30.237] → [31.2089:2140]

∅:D[31.2140] → [14.1571:1625]

B:BD[14.1571] → [14.1571:1625]

∅:D[28.865] → [11.1472:1496]

B:BD[11.1472] → [11.1472:1496]

B:BD[11.1496] → [6.201:432]

∅:D[19.354] → [13.2079:2120]

∅:D[6.432] → [13.2079:2120]

∅:D[25.523] → [13.2079:2120]

B:BD[11.1497] → [13.2079:2120]

B:BD[13.2120] → [6.433:593]

}
sub getReleaseSet {
    my ($c, $projectName, $releaseSetName) = @_;
    
    my $project = $c->model('DB::Projects')->find($projectName);
    notFound($c, "Project $projectName doesn't exist.") if !defined $project;
    $c->stash->{project} = $project;
    (my $releaseSet) = $c->model('DB::ReleaseSets')->find($projectName, $releaseSetName);
    notFound($c, "Release set $releaseSetName doesn't exist.") if !defined $releaseSet;
    $c->stash->{releaseSet} = $releaseSet;
    (my $primaryJob) = $releaseSet->releasesetjobs->search({isprimary => 1});
    #die "Release set $releaseSetName doesn't have a primary job." if !defined $primaryJob;
    my $jobs = [$releaseSet->releasesetjobs->search({},
        {order_by => ["isprimary DESC", "job", "attrs"]})];
    $c->stash->{jobs} = $jobs;
    return ($project, $releaseSet, $primaryJob, $jobs);
}
sub updateReleaseSet {
    my ($c, $releaseSet) = @_;
    
    my $releaseSetName = trim $c->request->params->{name};
    error($c, "Invalid release set name: $releaseSetName")
        unless $releaseSetName =~ /^[[:alpha:]][\w\-]*$/;
    
    $releaseSet->update(
        { name => $releaseSetName
        , description => trim $c->request->params->{description} });
    $releaseSet->releasesetjobs->delete_all;
    foreach my $param (keys %{$c->request->params}) {
        next unless $param =~ /^job-(\d+)-name$/;
        my $baseName = $1;
        my $name = trim $c->request->params->{"job-$baseName-name"};
        my $description = trim $c->request->params->{"job-$baseName-description"};
        my $attrs = trim $c->request->params->{"job-$baseName-attrs"};
        $name =~ /^([\w\-]+):([\w\-]+)$/ or error($c, "Invalid job name: $name");
        my $jobsetName = $1;
        my $jobName = $2;
        error($c, "Jobset `$jobsetName' doesn't exist.")
            unless $releaseSet->project->jobsets->find({name => $jobsetName});
        # !!! We could check whether the job exists, but that would
        # require the scheduler to have seen the job, which may not be
        # the case.
        
        $releaseSet->releasesetjobs->create(
            { jobset => $jobsetName
            , job => $jobName
            , description => $description
            , attrs => $attrs
            , isprimary => $c->request->params->{"primary"} eq $baseName ? 1 : 0
            });
    }
    error($c, "There must be one primary job.")
        if $releaseSet->releasesetjobs->search({isprimary => 1})->count != 1;
}
sub releases :Local {
    my ($self, $c, $projectName, $releaseSetName, $subcommand) = @_;
    my ($project, $releaseSet, $primaryJob, $jobs) = getReleaseSet($c, $projectName, $releaseSetName);
    my $resultsPerPage = 10;
    my $page = 1;
    if (defined $subcommand && $subcommand =~ /^\d+$/ ) {
      $page = int($subcommand) 
    } 
    elsif (defined $subcommand && $subcommand ne "") {
        requireProjectOwner($c, $project);
        if ($subcommand eq "edit") {
            $c->stash->{template} = 'edit-releaseset.tt';
            return;
        }
        elsif ($subcommand eq "submit") {
            txn_do($c->model('DB')->schema, sub {
                updateReleaseSet($c, $releaseSet);
            });
            return $c->res->redirect($c->uri_for("/releases", $projectName, $releaseSet->name));
        }
        elsif ($subcommand eq "delete") {
            txn_do($c->model('DB')->schema, sub {
                $releaseSet->delete;
            });
            return $c->res->redirect($c->uri_for($c->controller('Project')->action_for('view'), [$project->name]));
        }
        else { error($c, "Unknown subcommand."); }
    }
    
    $c->stash->{template} = 'releases.tt';
    my @releases = ();
    push @releases, getRelease($_, $jobs) foreach getPrimaryBuildsForReleaseSet($project, $primaryJob, $page, $resultsPerPage);
    $c->stash->{baseUri} = $c->uri_for($self->action_for("releases"), $projectName, $releaseSetName);
    $c->stash->{releases} = [@releases];
    $c->stash->{page} = $page;
    $c->stash->{totalReleases} = getPrimaryBuildTotal($project, $primaryJob);
    $c->stash->{resultsPerPage} = $resultsPerPage;

Deletion in src/lib/Hydra/Controller/Root.pm at line 64 [12.804]
∅:D[13.2122] → [11.1568:1569]
B:BD[11.1568] → [11.1568:1569]
B:BD[11.2289] → [11.2289:2290]
B:BD[11.2290] → [30.238:387]
B:BD[30.387] → [15.878:953]
∅:D[15.953] → [16.1174:1211]
B:BD[30.455] → [16.1174:1211]
```
sub create_releaseset :Local {
    my ($self, $c, $projectName, $subcommand) = @_;
    my $project = $c->model('DB::Projects')->find($projectName);
    error($c, "Project $projectName doesn't exist.") if !defined $project;
    $c->stash->{project} = $project;
```
Deletion in src/lib/Hydra/Controller/Root.pm at line 65 [12.804]
B:BD[30.546] → [26.961:1000]
```
    requireProjectOwner($c, $project);
```

Deletion in src/lib/Hydra/Controller/Root.pm at line 66 [12.804]

B:BD[30.730] → [30.730:788]

B:BD[30.788] → [31.2231:2289]

B:BD[31.2289] → [29.489:535]

∅:D[29.535] → [31.2335:2731]

B:BD[31.2335] → [31.2335:2731]

∅:D[31.2731] → [30.1412:1506]

B:BD[30.1412] → [30.1412:1506]

∅:D[30.1506] → [13.2123:2144]

B:BD[11.2290] → [13.2123:2144]

B:BD[13.2144] → [3.0:75]

∅:D[3.75] → [13.2209:2252]

∅:D[14.1694] → [13.2209:2252]

B:BD[13.2209] → [13.2209:2252]

B:BD[13.2252] → [19.355:458]

∅:D[19.458] → [25.524:612]

B:BD[14.1791] → [25.524:612]

B:BD[25.612] → [19.459:538]

B:BD[19.538] → [31.2732:2823]

B:BD[31.2823] → [3.76:186]

∅:D[3.186] → [25.1061:1067]

B:BD[25.1061] → [25.1061:1067]

B:BD[25.1067] → [3.187:188]

∅:D[3.188] → [13.2346:2500]

∅:D[25.1072] → [13.2346:2500]

B:BD[11.2877] → [13.2346:2500]

B:BD[13.2500] → [15.954:1174]

∅:D[15.1174] → [32.89:90]

B:BD[31.2902] → [32.89:90]

∅:D[32.90] → [19.539:600]

B:BD[13.2692] → [19.539:600]

B:BD[19.600] → [3.189:1023]

∅:D[19.600] → [10.821:823]

∅:D[3.1023] → [10.821:823]

∅:D[13.2750] → [10.821:823]

∅:D[11.2918] → [10.821:823]

B:BD[10.821] → [10.821:823]

B:BD[33.96] → [34.2159:2160]

B:BD[34.2372] → [34.2372:2373]

    if (defined $subcommand && $subcommand eq "submit") {
        my $releaseSetName = $c->request->params->{name};
        txn_do($c->model('DB')->schema, sub {
            # Note: $releaseSetName is validated in updateProject,
            # which will abort the transaction if the name isn't
            # valid.
            my $releaseSet = $project->releasesets->create({name => $releaseSetName});
            updateReleaseSet($c, $releaseSet);
            return $c->res->redirect($c->uri_for("/releases", $projectName, $releaseSet->name));
        });
    }
    
    $c->stash->{template} = 'edit-releaseset.tt';
    $c->stash->{create} = 1;
}
sub release :Local {
    my ($self, $c, $projectName, $releaseSetName, $releaseId, @args) = @_;
    $c->stash->{template} = 'release.tt';
    my ($project, $releaseSet, $primaryJob, $jobs) = getReleaseSet($c, $projectName, $releaseSetName);
    if ($releaseId eq "latest") {
        # Redirect to the latest successful release.
        my $latest = getLatestSuccessfulRelease($project, $primaryJob, $jobs);
        error($c, "This release set has no successful releases yet.") if !defined $latest;
        return $c->res->redirect($c->uri_for("/release", $projectName, $releaseSetName, $latest->id, @args));
    }
    # Note: we don't actually check whether $releaseId is a primary
    # build, but who cares?
    my $primaryBuild = $project->builds->find($releaseId,
        { join => 'resultInfo',
        , '+select' => ["resultInfo.releasename", "resultInfo.buildstatus"]
        , '+as' => ["releasename", "buildstatus"] })
        or error($c, "Release $releaseId doesn't exist.");
    $c->stash->{release} = getRelease($primaryBuild, $jobs);
    # Provide a redirect to the specified job of this release.  !!!
    # This isn't uniquely defined if there are multiple jobs with the
    # same name (e.g. builds for different platforms).  However, this
    # mechanism is primarily to allow linking to resources of which
    # there is only one build, such as the manual of the latest
    # release.
    if (scalar @args != 0) {
        my $jobName = shift @args;
        (my $build, my @others) = grep { $_->{job}->job eq $jobName } @{$c->stash->{release}->{jobs}};
        notFound($c, "Release doesn't have a job named `$jobName'")
            unless defined $build;
        error($c, "Job `$jobName' isn't unique.") if @others;
        return $c->res->redirect($c->uri_for($c->controller('Build')->action_for('view_build'),
            [$build->{build}->id], @args));
    }
}

File addition: View.pm (----------)

[35.188]

package Hydra::Controller::View;
use strict;
use warnings;
use base 'Catalyst::Controller';
use Hydra::Helper::Nix;
use Hydra::Helper::CatalystUtils;
sub getView {
    my ($c, $projectName, $viewName) = @_;
    
    my $project = $c->model('DB::Projects')->find($projectName);
    notFound($c, "Project $projectName doesn't exist.") if !defined $project;
    $c->stash->{project} = $project;
    (my $view) = $c->model('DB::Views')->find($projectName, $viewName);
    notFound($c, "View $viewName doesn't exist.") if !defined $view;
    $c->stash->{view} = $view;
    (my $primaryJob) = $view->viewjobs->search({isprimary => 1});
    #die "View $viewName doesn't have a primary job." if !defined $primaryJob;
    my $jobs = [$view->viewjobs->search({},
        {order_by => ["isprimary DESC", "job", "attrs"]})];
    $c->stash->{jobs} = $jobs;
    return ($project, $view, $primaryJob, $jobs);
}
sub updateReleaseSet {
    my ($c, $releaseSet) = @_;
    
    my $releaseSetName = trim $c->request->params->{name};
    error($c, "Invalid release set name: $releaseSetName")
        unless $releaseSetName =~ /^[[:alpha:]][\w\-]*$/;
    
    $releaseSet->update(
        { name => $releaseSetName
        , description => trim $c->request->params->{description} });
    $releaseSet->releasesetjobs->delete_all;
    foreach my $param (keys %{$c->request->params}) {
        next unless $param =~ /^job-(\d+)-name$/;
        my $baseName = $1;
        my $name = trim $c->request->params->{"job-$baseName-name"};
        my $description = trim $c->request->params->{"job-$baseName-description"};
        my $attrs = trim $c->request->params->{"job-$baseName-attrs"};
        $name =~ /^([\w\-]+):([\w\-]+)$/ or error($c, "Invalid job name: $name");
        my $jobsetName = $1;
        my $jobName = $2;
        error($c, "Jobset `$jobsetName' doesn't exist.")
            unless $releaseSet->project->jobsets->find({name => $jobsetName});
        # !!! We could check whether the job exists, but that would
        # require the scheduler to have seen the job, which may not be
        # the case.
        
        $releaseSet->releasesetjobs->create(
            { jobset => $jobsetName
            , job => $jobName
            , description => $description
            , attrs => $attrs
            , isprimary => $c->request->params->{"primary"} eq $baseName ? 1 : 0
            });
    }
    error($c, "There must be one primary job.")
        if $releaseSet->releasesetjobs->search({isprimary => 1})->count != 1;
}
sub view : Chained('/') PathPart('view') CaptureArgs(2) {
    my ($self, $c, $projectName, $viewName) = @_;
    my ($project, $view, $primaryJob, $jobs) = getView($c, $projectName, $viewName);
    $c->stash->{project} = $project;
    $c->stash->{view} = $view;
    $c->stash->{primaryJob} = $primaryJob;
    $c->stash->{jobs} = $jobs;
}
sub view_view : Chained('view') PathPart('') Args(0) {
    my ($self, $c) = @_;
    $c->stash->{template} = 'view.tt';
    my $resultsPerPage = 10;
    my $page = int($c->req->param('page')) || 1;
    my @results = ();
    push @results, getRelease($_, $c->stash->{jobs}) foreach
        getPrimaryBuildsForReleaseSet($c->stash->{project}, $c->stash->{primaryJob}, $page, $resultsPerPage);
    $c->stash->{baseUri} = $c->uri_for($self->action_for("view"), $c->stash->{project}->name, $c->stash->{view}->name);
    $c->stash->{results} = [@results];
    $c->stash->{page} = $page;
    $c->stash->{totalResults} = getPrimaryBuildTotal($c->stash->{project}, $c->stash->{primaryJob});
    $c->stash->{resultsPerPage} = $resultsPerPage;
}
sub edit : Chained('view') PathPart('edit') Args(0) {
    my ($self, $c) = @_;
    requireProjectOwner($c, $c->stash->{project});
    $c->stash->{template} = 'edit-view.tt';
}
    
sub latest : Chained('view') PathPart('latest') {
    my ($self, $c, @args) = @_;
    
    # Redirect to the latest result in the view in which every build
    # is successful.
    my $latest = getLatestSuccessfulRelease(
        $c->stash->{project}, $c->stash->{primaryJob}, $c->stash->{jobs});
    error($c, "This view set has no successful results yet.") if !defined $latest;
    return $c->res->redirect($c->uri_for("/view", $c->stash->{project}->name, $c->stash->{view}->name, $latest->id, @args));
}
sub result : Chained('view') PathPart('') {
    my ($self, $c, $id, @args) = @_;
    
    $c->stash->{template} = 'release.tt';
    # Note: we don't actually check whether $id is a primary build,
    # but who cares?
    my $primaryBuild = $c->stash->{project}->builds->find($id,
        { join => 'resultInfo',
        , '+select' => ["resultInfo.releasename", "resultInfo.buildstatus"]
        , '+as' => ["releasename", "buildstatus"] })
        or error($c, "Build $id doesn't exist.");
    $c->stash->{release} = getRelease($primaryBuild, $c->stash->{jobs});
    # Provide a redirect to the specified job of this release.  !!!
    # This isn't uniquely defined if there are multiple jobs with the
    # same name (e.g. builds for different platforms).  However, this
    # mechanism is primarily to allow linking to resources of which
    # there is only one build, such as the manual of the latest
    # release.
    if (scalar @args != 0) {
        my $jobName = shift @args;
        (my $build, my @others) = grep { $_->{job}->job eq $jobName } @{$c->stash->{release}->{jobs}};
        notFound($c, "Release doesn't have a job named `$jobName'")
            unless defined $build;
        error($c, "Job `$jobName' isn't unique.") if @others;
        return $c->res->redirect($c->uri_for($c->controller('Build')->action_for('view_build'),
            [$build->{build}->id], @args));
    }
}
1;

Replacement in src/lib/Hydra/Helper/Nix.pm at line 242 [36.436]

B:BD[19.2741] → [19.2741:2874]

B:BD[19.2874] → [15.1793:1860]

∅:D[15.1860] → [19.2939:2993]

B:BD[19.2939] → [19.2939:2993]

        if ($job->mayfail != 1) {
            if (!defined $thisBuild) {
                $status = 2 if $status == 0; # = unfinished
            } elsif ($thisBuild->get_column('buildstatus') != 0) {
                $status = 1; # = failed
            }

[19.2741]

[19.2993]

        if (!defined $thisBuild) {
            $status = 2 if $status == 0; # = unfinished
        } elsif ($thisBuild->get_column('buildstatus') != 0) {
            $status = 1; # = failed

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 106 [38.1]

B:BD[37.25] → [5.146:291]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yodYRloko+NdaEVy+IL5JA

[37.25]

[38.781]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gtA3wQA2CLsXs4X95PfX9A

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 94 [12.4268]

B:BD[12.4922] → [5.292:437]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GdjLBqXz+LK4ewxnpIs9eQ

[12.4922]

[12.5064]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ii6N3v4M1fX1tQ3YmJNFWw

Replacement in src/lib/Hydra/Schema/BuildResultInfo.pm at line 89 [39.1594]

B:BD[39.2382] → [5.438:583]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KTPvLaqbXGpynWt107ISew

[39.2382]

[39.2524]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EMvF2g+MDIE84yjnJOs7og

Replacement in src/lib/Hydra/Schema/BuildSchedulingInfo.pm at line 46 [39.3773]

B:BD[39.4473] → [5.584:729]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:thMie1PGP25FGbo5qypE/w

[39.4473]

[39.4615]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RcdX5dHefBQnxQYbMxNF/w

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 94 [40.1675]

B:BD[40.2959] → [5.730:875]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ua+P31BMRmMKP6QFOdA89A

[40.2959]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1AQCHpuv8Lqk/FYdU8JYFA

Replacement in src/lib/Hydra/Schema/Builds.pm at line 166 [12.5202]

B:BD[12.6194] → [5.876:1021]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:luxYxoOAtLoCgl5iFTYdJA

[12.6194]

[37.62]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CcYlMej7OPRUJn6375Qlqw

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 50 [41.859]

B:BD[41.1497] → [5.1022:1167]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DeoyeS42ddQ2FXa+8n31OQ

[41.1497]

[41.1639]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mYBdemei1tFuK8Ll6eMLfQ

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 43 [41.1780]

B:BD[41.2342] → [5.1168:1313]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CaFTGQtLjPwCISqk5W4fag

[41.2342]

[41.2484]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bE+w54cACUS2L0PJ9gPjtw

Replacement in src/lib/Hydra/Schema/Jobs.pm at line 78 [42.1454]

B:BD[42.2613] → [5.1314:1459]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+Cb0mIbX8ddDbZY39u9feA

[42.2613]

[42.2755]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c0OEe2zPd/E4vh0PRXm4Ag

Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 72 [43.825]

B:BD[43.1831] → [5.1460:1605]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:m3a1Q6c2FePidqbqYhz5dg

[43.1831]

[43.1973]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jS8pitmHFnplE8WcK0OyMQ

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 68 [44.590]

B:BD[44.1681] → [5.1606:1751]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QSYSg5xsN292LnfvbAG0Vw

[44.1681]

[44.1823]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W0rhMTOzLBZNsVShQHg5+A

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 106 [44.1960]

B:BD[44.2992] → [5.1849:1994]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:85FwtlvNxjGix7PUCJTMqA

[44.2992]

[44.3134]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CB5lPsrozpvO8gLXHTyMrQ

Replacement in src/lib/Hydra/Schema/Projects.pm at line 68 [44.3266]
∅:D[42.3563] → [11.4761:4778]
B:BD[11.4761] → [11.4761:4778]
B:BD[11.4778] → [17.2990:3022]
```
  "releasesets",
  "Hydra::Schema::ReleaseSets",
```
[42.3563]
[11.4810]
```
  "views",
  "Hydra::Schema::Views",
```
Replacement in src/lib/Hydra/Schema/Projects.pm at line 73 [44.3266]
B:BD[11.4876] → [11.4876:4896]
B:BD[11.4896] → [17.3023:3058]
```
  "releasesetjobs",
  "Hydra::Schema::ReleaseSetJobs",
```
[11.4876]
[45.2341]
```
  "viewjobs",
  "Hydra::Schema::ViewJobs",
```

Replacement in src/lib/Hydra/Schema/Projects.pm at line 79 [44.3266]

B:BD[44.3685] → [5.1995:2140]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Dru36PNUe9iYHEwhhHKJ3A

[44.3685]

[44.3827]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:N6NPLJfc1gKM4zz6dS5PJw

Replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 24 [46.1717]

B:BD[46.2105] → [5.2433:2578]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mfZTzyri5eSRhfmBmwyuFQ

[46.2105]

[46.2247]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EkpopxgwlZf8Du3EmWzTKQ

Replacement in src/lib/Hydra/Schema/UserRoles.pm at line 31 [47.3263]

B:BD[47.3736] → [5.2579:2724]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6RgJY04rmD+PumWXz5KGoQ

[47.3736]

[47.3878]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W2Q6219GlZl2IqQkBoFmFA

Replacement in src/lib/Hydra/Schema/Users.pm at line 53 [48.3258]

B:BD[48.3782] → [5.2725:2870]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZWzljXMF0IbU12wNUn+djg

[48.3782]

[48.3924]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qH+qBI3xxQgTNf3v7E3sDw

File move: ReleaseSetJobs.pm → ViewJobs.pm
BF:BFD[35.477] → [35.974:1015]
BF:BF[35.1015] → [11.5076:5076]
[35.477]
[11.5076]
Replacement in src/lib/Hydra/Schema/ViewJobs.pm at line 1 [11.5076]
B:BD[11.5076] → [17.3243:3282]
```
package Hydra::Schema::ReleaseSetJobs;
```
[11.5076]
[11.5116]
```
package Hydra::Schema::ViewJobs;
```
Replacement in src/lib/Hydra/Schema/ViewJobs.pm at line 9 [11.5076]
B:BD[11.5207] → [11.5207:5245]
```
__PACKAGE__->table("ReleaseSetJobs");
```
[11.5207]
[11.5245]
```
__PACKAGE__->table("ViewJobs");
```
Replacement in src/lib/Hydra/Schema/ViewJobs.pm at line 19 [11.5076]
∅:D[49.15045] → [50.1716:1730]
B:BD[11.5344] → [50.1716:1730]
```
  "release_",
```
[49.15045]
[49.15046]
```
  "view_",
```
Deletion in src/lib/Hydra/Schema/ViewJobs.pm at line 43 [11.5076]
∅:D[49.15466] → [11.5635:5648]
B:BD[11.5635] → [11.5635:5648]
B:BD[11.5648] → [49.15467:15550]
```
  "mayfail",
  { data_type => "integer", default_value => 0, is_nullable => 0, size => undef },
```

Insertion in src/lib/Hydra/Schema/ViewJobs.pm at line 57 [11.5076]

[49.15758]

[11.5788]

  "autorelease",
  { data_type => "integer", default_value => 0, is_nullable => 0, size => undef },

Replacement in src/lib/Hydra/Schema/ViewJobs.pm at line 60 [11.5076]

B:BD[11.5791] → [50.1731:1800]

__PACKAGE__->set_primary_key("project", "release_", "job", "attrs");

[11.5791]

[11.5859]

__PACKAGE__->set_primary_key("project", "view_", "job", "attrs");

Replacement in src/lib/Hydra/Schema/ViewJobs.pm at line 63 [11.5076]

B:BD[11.5970] → [11.5970:5986]

B:BD[11.5986] → [17.3283:3315]

B:BD[17.3315] → [50.1801:1849]

  "releaseset",
  "Hydra::Schema::ReleaseSets",
  { name => "release_", project => "project" },

[11.5970]

[11.6065]

  "view",
  "Hydra::Schema::Views",
  { name => "view_", project => "project" },

Replacement in src/lib/Hydra/Schema/ViewJobs.pm at line 69 [11.5076]

B:BD[11.6070] → [5.2141:2286]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qSQjyHzxQp0qO3CbRdcXmw

[11.6070]

[11.6212]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LkiGAkZOiLNJk6oDY0+zNw

File move: ReleaseSets.pm → Views.pm
BF:BFD[35.477] → [35.1015:1053]
BF:BF[35.1053] → [11.6351:6351]
[35.477]
[11.6351]
Replacement in src/lib/Hydra/Schema/Views.pm at line 1 [11.6351]
B:BD[11.6351] → [17.3497:3533]
```
package Hydra::Schema::ReleaseSets;
```
[11.6351]
[11.6388]
```
package Hydra::Schema::Views;
```
Replacement in src/lib/Hydra/Schema/Views.pm at line 9 [11.6351]
B:BD[11.6479] → [11.6479:6514]
```
__PACKAGE__->table("ReleaseSets");
```
[11.6479]
[11.6514]
```
__PACKAGE__->table("Views");
```
Replacement in src/lib/Hydra/Schema/Views.pm at line 39 [11.6351]
B:BD[11.6994] → [11.6994:7014]
B:BD[11.7014] → [17.3534:3569]
∅:D[17.3569] → [11.7049:7053]
B:BD[11.7049] → [11.7049:7053]
B:BD[11.7053] → [50.1993:2074]
∅:D[50.2074] → [11.7132:7137]
B:BD[11.7132] → [11.7132:7137]
```
  "releasesetjobs",
  "Hydra::Schema::ReleaseSetJobs",
  {
    "foreign.project"  => "self.project",
    "foreign.release_" => "self.name",
  },
```
[11.6994]
[11.7137]
```
  "viewjobs",
  "Hydra::Schema::ViewJobs",
  { "foreign.project" => "self.project", "foreign.view_" => "self.name" },
```

Replacement in src/lib/Hydra/Schema/Views.pm at line 45 [11.6351]

B:BD[11.7142] → [5.2287:2432]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pEjxqTAwP4ZmP/s6F4VOsg

[11.7142]

[11.7284]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hV+xzi564rgcYeDvz75zCA

Replacement in src/lib/Hydra/Schema.pm at line 11 [12.6376]

B:BD[12.6498] → [5.2871:3016]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-08 13:25:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vdr83mcEie4i5Fn/Uj17Vg

[12.6498]

[12.6640]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-15 23:14:39
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ODLRc6VfDQpb8MyXPKmqtg

File move: edit-releaseset.tt → edit-view.tt
BF:BFD[35.1486] → [35.1641:1683]
BF:BF[35.1683] → [14.1873:1873]
[35.1486]
[14.1873]

Replacement in src/root/edit-view.tt at line 1 [14.1873]

B:BD[14.1873] → [16.1431:1543]

[% WRAPPER layout.tt title=(create ? "New Release Set" : "Release Set ‘$project.name:$releaseSet.name’") %]

[14.1873]

[14.1959]

[% WRAPPER layout.tt title=(create ? "New View" : "View ‘$project.name:$view.name’") %]

Replacement in src/root/edit-view.tt at line 5 [14.1873]

B:BD[14.1999] → [16.1544:1664]

<h1>[% IF create %]New Release Set[% ELSE %]Release Set <tt>[% project.name %]:[% releaseSet.name %]</tt>[% END %]</h1>

[14.1999]

[24.73]

<h1>[% IF create %]New View[% ELSE %]View <tt>[% project.name %]:[% view.name %]</tt>[% END %]</h1>

Replacement in src/root/edit-view.tt at line 24 [14.1873]

B:BD[24.940] → [16.1665:1855]

<form action="[% IF create %][% c.uri_for('/create_releaseset' project.name 'submit') %][% ELSE %][% c.uri_for('/releases' project.name releaseSet.name 'submit') %][% END %]" method="post">

[24.940]

[14.2208]

<form action="[% IF create %][% c.uri_for('/create-view' project.name 'submit') %][% ELSE %][% c.uri_for('/view' project.name view.name 'submit') %][% END %]" method="post">

Replacement in src/root/edit-view.tt at line 29 [14.1873]

B:BD[14.2275] → [14.2275:2387]

      <td><input type="text" class="string" name="name" [% HTML.attributes(value => releaseSet.name) %] /></td>

[14.2275]

[14.2387]

      <td><input type="text" class="string" name="name" [% HTML.attributes(value => view.name) %] /></td>

Replacement in src/root/edit-view.tt at line 33 [14.1873]

B:BD[14.2434] → [14.2434:2560]

      <td><input type="text" class="string" name="description" [% HTML.attributes(value => releaseSet.description) %] /></td>

[14.2434]

[14.2560]

      <td><input type="text" class="string" name="description" [% HTML.attributes(value => view.description) %] /></td>

Replacement in src/root/edit-view.tt at line 89 [14.1873]

B:BD[30.1962] → [16.1856:1955]

∅:D[16.1955] → [30.2064:2190]

B:BD[30.2064] → [30.2064:2190]

  <form action="[% c.uri_for('/releases' project.name releaseSet.name 'delete') %]" method="post">
    <p><button id="delete-project" type="submit"><img src="/static/images/failure.gif" />Delete this release set</button></p>

[30.1962]

[30.2190]

  <form action="[% c.uri_for('/view' project.name view.name 'delete') %]" method="post">
    <p><button id="delete-project" type="submit"><img src="/static/images/failure.gif" />Delete this view</button></p>

Replacement in src/root/edit-view.tt at line 95 [14.1873]

B:BD[30.2256] → [30.2256:2331]

      return confirm("Are you sure you want to delete this release set?");

[30.2256]

[30.2331]

      return confirm("Are you sure you want to delete this view?");

Replacement in src/root/project.tt at line 102 [51.1667]
B:BD[51.2673] → [8.21572:21590]
```
<h2>Releases</h2>
```
[51.2673]
[8.21590]
```
<h2>Views</h2>
```
Replacement in src/root/project.tt at line 104 [51.1667]
B:BD[8.21591] → [8.21591:21621]
```
[% IF releaseSets.size > 0 %]
```
[8.21591]
[8.21621]
```
[% IF views.size > 0 %]
```

Replacement in src/root/project.tt at line 106 [51.1667]

B:BD[8.21622] → [8.21622:21697]

<p>Project <tt>[% project.name %]</tt> has the following release sets:</p>

[8.21622]

[8.21697]

<p>Project <tt>[% project.name %]</tt> has the following views:</p>

Replacement in src/root/project.tt at line 109 [51.1667]
B:BD[8.21703] → [8.21703:21745]
```
  [% FOREACH releaseSet IN releaseSets %]
```
[8.21703]
[8.21745]
```
  [% FOREACH view IN views %]
```

Replacement in src/root/project.tt at line 111 [51.1667]

B:BD[8.21754] → [8.21754:21955]

      <a href="[% c.uri_for('/releases' project.name releaseSet.name) %]"><tt>[% releaseSet.name %]</tt></a>
      [<a href="[% c.uri_for('/releases' project.name releaseSet.name "edit") %]">Edit</a>]

[8.21754]

[8.21955]

      <a href="[% c.uri_for('/view' project.name view.name) %]"><tt>[% view.name %]</tt></a>
      [<a href="[% c.uri_for('/view' project.name view.name "edit") %]">Edit</a>]

Replacement in src/root/project.tt at line 119 [51.1667]

B:BD[51.2674] → [8.21984:22048]

<p>Project <tt>[% project.name %]</tt> has no release sets.</p>

[51.2674]

[52.1515]

<p>Project <tt>[% project.name %]</tt> has no views.</p>

Replacement in src/root/project.tt at line 123 [51.1667]

B:BD[8.22050] → [8.22050:22149]

<p><a href="[% c.uri_for('/create_releaseset' project.name) %]">[Create a new release set]</a></p>

[8.22050]

[52.1527]

<p><a href="[% c.uri_for('/project' project.name 'create-view') %]">[Create a new view]</a></p>

File move: releases.tt → view.tt
BF:BFD[35.1486] → [35.2017:2052]
BF:BF[35.2052] → [11.8435:8435]
[35.1486]
[11.8435]

Replacement in src/root/view.tt at line 1 [11.8435]

B:BD[11.8435] → [28.1023:1115]

[% WRAPPER layout.tt title="Release Set ‘$releaseSet.project.name:$releaseSet.name’" %]

[11.8435]

[11.8477]

[% WRAPPER layout.tt title="View ‘$view.project.name:$view.name’" %]

Replacement in src/root/view.tt at line 5 [11.8435]

B:BD[11.8536] → [28.1116:1198]

<h1>Release Set <tt>[% releaseSet.project.name %]:[% releaseSet.name %]</tt></h1>

[11.8536]

[53.747]

<h1>View <tt>[% view.project.name %]:[% view.name %]</tt></h1>

Replacement in src/root/view.tt at line 8 [11.8435]

B:BD[25.1077] → [16.3651:3826]

[<a href="[% c.uri_for('/releases' project.name releaseSet.name "edit") %]">Edit</a>]
[<a href="[% c.uri_for('/release' project.name releaseSet.name "latest") %]">Latest</a>]

[25.1077]

[25.1258]

[<a href="[% c.uri_for('/view' project.name view.name "edit") %]">Edit</a>]
[<a href="[% c.uri_for('/view' project.name view.name "latest") %]">Latest</a>]

Replacement in src/root/view.tt at line 12 [11.8435]

B:BD[6.3003] → [6.3003:3145]

<p>Showing releases [% (page - 1) * resultsPerPage + 1 %] - [% (page - 1) * resultsPerPage + releases.size %] out of [% totalReleases %].</p>

[6.3003]

[11.8594]

<p>Showing results [% (page - 1) * resultsPerPage + 1 %] - [% (page - 1) * resultsPerPage + results.size %] out of [% totalResults %].</p>

Replacement in src/root/view.tt at line 19 [11.8435]
B:BD[11.8675] → [11.8675:8698]
```
      <th>Release</th>
```
[11.8675]
[20.272]
```
      <th>Name</th>
```

Replacement in src/root/view.tt at line 28 [11.8435]

B:BD[11.8907] → [13.8408:8538]

    [% FOREACH release IN releases %]
      [% link = c.uri_for('/release' releaseSet.project.name releaseSet.name release.id) %]

[11.8907]

[13.8538]

    [% FOREACH result IN results %]
      [% link = c.uri_for('/view' project.name view.name result.id) %]

Replacement in src/root/view.tt at line 32 [11.8435]
B:BD[11.8970] → [11.8970:9009]
```
          [% IF release.status == 0 %]
```
[11.8970]
[11.9009]
```
          [% IF result.status == 0 %]
```

Replacement in src/root/view.tt at line 34 [11.8435]

B:BD[11.9062] → [11.9062:9104]

          [% ELSIF release.status == 1 %]

[11.9062]

[11.9104]

          [% ELSIF result.status == 1 %]

Replacement in src/root/view.tt at line 36 [11.8435]

B:BD[11.9157] → [11.9157:9199]

          [% ELSIF release.status == 2 %]

[11.9157]

[11.9199]

          [% ELSIF result.status == 2 %]

Replacement in src/root/view.tt at line 40 [11.8435]

B:BD[11.9292] → [13.8609:8668]

        <td><a href="[% link %]">[% release.id %]</a></td>

[11.9292]

[11.9326]

        <td><a href="[% link %]">[% result.id %]</a></td>

Replacement in src/root/view.tt at line 42 [11.8435]

B:BD[11.9339] → [11.9339:9425]

          [% IF release.releasename %]
            <tt>[% release.releasename %]</tt>

[11.9339]

[11.9425]

          [% IF result.releasename %]
            <tt>[% result.releasename %]</tt>

Replacement in src/root/view.tt at line 48 [11.8435]

B:BD[11.9509] → [20.293:367]

B:BD[20.367] → [8.23137:23177]

        <td>[% INCLUDE renderDateTime timestamp=release.timestamp %]</td>
        [% FOREACH j IN release.jobs %]

[11.9509]

[13.8669]

        <td>[% INCLUDE renderDateTime timestamp=result.timestamp %]</td>
        [% FOREACH j IN result.jobs %]

Insertion in src/root/view.tt at line 67 [11.8435]
[6.3147]
[6.3147]
```
[<a href="[% "$baseUri?page=1" %]">First</a>]
```

Replacement in src/root/view.tt at line 69 [11.8435]

B:BD[6.3165] → [6.3165:3218]

  [<a href="[% "$baseUri/"; (page - 1) %]">Prev</a>]

[6.3165]

[6.3218]

  [<a href="[% "$baseUri?page="; (page - 1) %]">Prev</a>]

Replacement in src/root/view.tt at line 71 [11.8435]

B:BD[6.3228] → [6.3228:3328]

[% IF page * resultsPerPage < totalReleases %]
  [<a href="[% "$baseUri/"; (page + 1) %]">Next</a>]

[6.3228]

[6.3328]

[% IF page * resultsPerPage < totalResults %]
  [<a href="[% "$baseUri?page="; (page + 1) %]">Next</a>]

Replacement in src/root/view.tt at line 74 [11.8435]

B:BD[6.3338] → [6.3338:3421]

[<a href="[% "$baseUri/"; (totalReleases - 1) div resultsPerPage + 1 %]">Last</a>]

[6.3338]

[11.10051]

[<a href="[% "$baseUri?page="; (totalResults - 1) div resultsPerPage + 1 %]">Last</a>]

Replacement in src/sql/hydra.sql at line 187 [55.1]

B:BD[54.878] → [11.11126:11273]

    update ReleaseSets set project = new.name where project = old.name;
    update ReleaseSetJobs set project = new.name where project = old.name;

[54.878]

    update Views set project = new.name where project = old.name;
    update ViewJobs set project = new.name where project = old.name;

Replacement in src/sql/hydra.sql at line 332 [55.1]

B:BD[11.11276] → [11.11276:11598]

B:BD[11.11598] → [20.368:652]

∅:D[20.652] → [11.11909:12110]

B:BD[11.11909] → [11.11909:12110]

-- Release sets are a mechanism to automatically group related builds
-- together.  A release set defines what an individual release
-- consists of, namely: a release consists of a build of some
-- "primary" job, plus all builds of the other jobs named in
-- ReleaseSetJobs that have that build as an input.  If there are
-- multiple builds matching a ReleaseSetJob, then we take the oldest
-- successful build, or the oldest unsuccessful build if there is no
-- successful build.  A release is itself considered successful if all
-- builds (except those for jobs that have mayFail set) are
-- successful.
--
-- Note that individual releases aren't separately stored in the
-- database, so they're really just a dynamic view on the universe of
-- builds, defined by a ReleaseSet.
create table ReleaseSets (

[11.11276]

[11.12110]

-- Views are a mechanism to automatically group related builds
-- together.  A view definition consists of a build of some "primary"
-- job, plus all builds of the other jobs named in ViewJobs that have
-- that build as an input.  If there are multiple builds matching a
-- ViewJob, then we take the oldest successful build, or the oldest
-- unsuccessful build if there is no successful build.
create table Views (

Replacement in src/sql/hydra.sql at line 344 [55.1]

B:BD[11.12206] → [11.12206:12305]

    -- If true, don't garbage-collect builds belonging to the releases
    -- defined by this row.

[11.12206]

[11.12305]

    -- If true, don't garbage-collect builds included in this view.

Replacement in src/sql/hydra.sql at line 352 [55.1]

B:BD[11.12486] → [11.12486:12556]

create trigger cascadeReleaseSetDelete
  before delete on ReleaseSets

[11.12486]

[11.12556]

create trigger cascadeViewDelete
  before delete on Views

Replacement in src/sql/hydra.sql at line 355 [55.1]

B:BD[11.12577] → [50.2790:2874]

    delete from ReleaseSetJobs where project = old.project and release_ = old.name;

[11.12577]

[11.12663]

    delete from ViewJobs where project = old.project and view_ = old.name;

Replacement in src/sql/hydra.sql at line 359 [55.1]

B:BD[11.12672] → [14.3009:3080]

create trigger cascadeReleaseSetUpdate
  update of name on ReleaseSets

[11.12672]

[14.3080]

create trigger cascadeViewUpdate
  update of name on Views

Replacement in src/sql/hydra.sql at line 362 [55.1]

B:BD[14.3101] → [50.2875:2978]

    update ReleaseSetJobs set release_ = new.name where project = old.project and release_ = old.name;

[14.3101]

[14.3202]

    update ViewJobs set view_ = new.name where project = old.project and view_ = old.name;

Replacement in src/sql/hydra.sql at line 366 [55.1]
∅:D[14.3211] → [11.12672:12702]
B:BD[11.12672] → [11.12672:12702]
```
create table ReleaseSetJobs (
```
[14.3211]
[11.12702]
```
create table ViewJobs (
```

Replacement in src/sql/hydra.sql at line 368 [55.1]

B:BD[11.12735] → [50.2979:3218]

    -- `release' is a reserved keyword in sqlite >= 3.6.8.  We could
    -- quote them ("release") here, but since the Perl bindings don't
    -- do that it still wouldn't work.  So use `release_' instead.
    release_      text not null,

[11.12735]

[11.12768]

    view_         text not null,

Replacement in src/sql/hydra.sql at line 377 [55.1]

B:BD[11.13012] → [11.13012:13125]

    -- If set, this is the primary job for the release.  There can be
    -- onlyt one such job per release set.

[11.13012]

[11.13125]

    -- If set, this is the primary job for the view.  There can be
    -- only one such job per view.

Deletion in src/sql/hydra.sql at line 381 [55.1]
B:BD[11.13176] → [11.13176:13223]
```
    mayFail       integer not null default 0,
```

Insertion in src/sql/hydra.sql at line 384 [55.1]

[56.6047]


    -- If set, once there is a successful build for every job
    -- associated with a build of the view's primary job, that set of
    -- builds is automatically added as a release to the Releases
    -- table.
    autoRelease   integer not null default 0,

Replacement in src/sql/hydra.sql at line 391 [55.1]
∅:D[56.6052] → [50.3219:3270]
B:BD[11.13252] → [50.3219:3270]
```
    primary key   (project, release_, job, attrs),
```
[56.6052]
[11.13302]
```
    primary key   (project, view_, job, attrs),
```

Replacement in src/sql/hydra.sql at line 393 [55.1]

B:BD[11.13396] → [50.3271:3386]

    foreign key   (project, release_) references ReleaseSets(project, name) on delete cascade -- ignored by sqlite

[11.13396]

[56.6053]

    foreign key   (project, view_) references Views(project, name) on delete cascade -- ignored by sqlite