grahamc/hydra2 - Change RBNQKATLSAKTGW2IRNB5CRV3SEH5F6E4BPVWX4BII7MH5TCIPINQC

* Adding persistant releases. A release is a named set of builds.

Created by Eelco Dolstra on October 21, 2009

RBNQKATLSAKTGW2IRNB5CRV3SEH5F6E4BPVWX4BII7MH5TCIPINQC

Dependencies

In channels

main

Change contents

Deletion in doc/dev-notes.txt at line 98 [5.1]
B:BD[4.66] → [4.66:115]
```
  alter table Views rename column name to view_;
```

Deletion in doc/dev-notes.txt at line 131 [5.1]

B:BD[5.5711] → [5.5711:5900]

* nix-env -f . -u --leq sqlite perl-Catalyst-Engine-HTTP-Prefork perl-Catalyst-View-Download perl-DBD-SQLite perl-IO-Compress-Bzip2 perl-IPC-Run perl-Task-Catalyst-Tutorial perl-XML-Simple

Deletion in doc/dev-notes.txt at line 132 [5.1]
B:BD[5.5901] → [5.5901:5902]

Insertion in src/lib/Hydra/Controller/Project.pm at line 213 [6.1245]

[2.902]

[6.9373]

sub releases : Chained('project') PathPart('releases') Args(0) {
    my ($self, $c) = @_;
    $c->stash->{template} = 'releases.tt';
    $c->stash->{releases} = [$c->stash->{project}->releases->all];
}
sub create_release : Chained('project') PathPart('releases/create') {
    my ($self, $c) = @_;
    $c->stash->{template} = 'create-release.tt';
}

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

B:BD[7.25] → [3.61:206]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7blxTiVkvfdukDiXCoD+Lw

[7.25]

[8.781]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IrEeOAeGZJUN3/kCMRNy5g

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

B:BD[9.4922] → [3.207:352]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8wtm75jCRmcyWInKMO826g

[9.4922]

[9.5064]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uVdvtQkCkZXqjpLhIB6OjQ

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

B:BD[10.2382] → [3.353:498]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3P0UuNHhdA8VfALMfwssTA

[10.2382]

[10.2524]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HbQGfeYtXVLhEofMmXgq9A

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

B:BD[10.4473] → [3.499:644]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e4O2JqrJN8coHmRdjbbxHg

[10.4473]

[10.4615]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GoOrRB+LCSskU+/lEmhtGw

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

B:BD[11.2959] → [3.645:790]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/Qdb8Y3Tqw7AOM5ique5Nw

[11.2959]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:USyzZLDTSJrN+FJg29e/vA

Insertion in src/lib/Hydra/Schema/Builds.pm at line 164 [9.5202]

[12.1152]

[9.6192]

__PACKAGE__->has_many(
  "releasemembers",
  "Hydra::Schema::ReleaseMembers",
  { "foreign.build" => "self.id" },
);

Replacement in src/lib/Hydra/Schema/Builds.pm at line 171 [9.5202]

B:BD[9.6194] → [3.791:936]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eJS7WCbSjwylQuAbQtB24w

[9.6194]

[7.62]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:otgQGRHBbSwp3Tb2UBW1Xg

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

B:BD[13.1497] → [3.937:1082]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FcLeNgdEr13JAYZLxF4/tw

[13.1497]

[13.1639]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:avORhqvcxFi5m+j9g9NYGg

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

B:BD[13.2342] → [3.1083:1228]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:y14yX+UAP03N7VGrgehcLw

[13.2342]

[13.2484]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g3iZG160pb+oYl3LeM0duA

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

B:BD[14.2613] → [3.1430:1575]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AjrYM1rAdgYy3j0+IFFUEw

[14.2613]

[14.2755]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SS2bc4Erxn0xyxeEndq88Q

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

B:BD[15.1831] → [3.1576:1721]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o5NC1PPpGrzOZZcumFoudg

[15.1831]

[15.1973]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ID6qQsHY59pmsJjfQKO07g

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

B:BD[16.1681] → [3.1722:1867]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7A5UkNWAqy0XuhlKvOgr6Q

[16.1681]

[16.1823]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TwiOYM2FLwu6Vo45BLPRAA

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

B:BD[16.2992] → [3.2022:2167]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vaCDa6WBFdcLMG23Nlr27g

[16.2992]

[16.3134]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EmQCVkqwPcbXYQg9g7vWpQ

Insertion in src/lib/Hydra/Schema/Projects.pm at line 75 [16.3266]

[4.8176]

[17.2341]

  { "foreign.project" => "self.name" },
);
__PACKAGE__->has_many(
  "releases",
  "Hydra::Schema::Releases",
  { "foreign.project" => "self.name" },
);
__PACKAGE__->has_many(
  "releasemembers",
  "Hydra::Schema::ReleaseMembers",

Replacement in src/lib/Hydra/Schema/Projects.pm at line 89 [16.3266]

B:BD[16.3685] → [3.2274:2419]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XcrLhOH+WuO24UFulGft1w

[16.3685]

[16.3827]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XnlHCaAVSobU9lrUhuViXQ

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

B:BD[18.2105] → [3.2420:2565]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X1voxjTNUQrn04o0zyVZ+w

[18.2105]

[18.2247]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qb9hjYs3pwR/hv9ds0lbuQ

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

B:BD[19.3736] → [3.2566:2711]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hbm45HCbdLU4emCiCC5gyA

[19.3736]

[19.3878]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Jte1GUXzt62VhfWrdefJow

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

B:BD[20.3782] → [3.2824:2969]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4Lj9iNcQhOG5VzUXkQFzkg

[20.3782]

[20.3924]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lcMVy+i3xmpHO4TYQYXG4Q

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

B:BD[21.6070] → [3.2970:3115]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:63nUKTtC6XdTSawDvU+oFg

[21.6070]

[21.6212]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:new5Scb0JMcSyamjKPL2BA

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

B:BD[21.7142] → [3.3116:3261]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+x+gzFpHSZzVMlsjMn47UA

[21.7142]

[21.7284]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HzIM+PxhyBLfCX6N5zFEIw

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

B:BD[9.6498] → [3.3262:3407]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 14:17:55
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Fs+amiko3zHOhK97IatSgQ

[9.6498]

[9.6640]

# Created by DBIx::Class::Schema::Loader v0.04999_06 @ 2009-10-21 17:40:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yd1F1Xb8MbehV6bTP6wEGQ

Insertion in src/root/navbar.tt at line 52 [22.15137]

[22.16591]

        uri = c.uri_for(c.controller('Project').action_for('releases'), [project.name])
         title = "Releases" %]
      [% INCLUDE makeLink

Deletion in src/root/project.tt at line 101 [24.1667]
∅:D[23.4594] → [24.2672:2673]
B:BD[24.2672] → [24.2672:2673]

File addition: releases.tt (----------)

[25.1486]

[% WRAPPER layout.tt title="Releases for Project ‘$project.name’" %]
[% PROCESS common.tt %]
[% USE HTML %]
<h1>Releases for Project <tt>[% project.name %]</tt></h1>
[% IF c.user_exists %]
<p>
[<a href="[% c.uri_for('/project' project.name 'releases' 'create') %]">Create a release</a>]
</p>
[% END %]
[% IF releases.size == 0 %]
<p><em>This project has no releases yet.</em></p>
[% ELSE %]
<ul>
  [% FOREACH release IN releases %]
    <li><tt>[% release.name %]</tt></li>
  [% END %]
</ul>
[% END %]
[% END %]

Insertion in src/sql/hydra.sql at line 345 [27.1]

[21.13513]

[26.2209]


-- A release is a named set of builds.  The ReleaseMembers table lists
-- the builds that constitute each release.
create table Releases (
    project       text not null,
    name          text not null,

Insertion in src/sql/hydra.sql at line 353 [27.1]
[26.2210]
[26.2210]
```
    timestamp     integer not null,
```

Insertion in src/sql/hydra.sql at line 355 [27.1]

[26.2211]

    description   text,
    primary key   (project, name),
    foreign key   (project) references Projects(name) on delete cascade
);
create table ReleaseMembers (
    project       text not null,
    release_      text not null,
    build         integer not null,
    description   text,
    primary key   (project, release_, build),
    foreign key   (project) references Projects(name) on delete cascade on update cascade,
    foreign key   (project, release_) references Releases(project, name) on delete cascade on update cascade,
    foreign key   (build) references Builds(id)
);