grahamc/hydra2 - Change LCKWLQW3TCEGY4E7FRZYWYSP7SHRA5LNJ2A7TWU4LVIRZTF7K7ZQC

* In Sqlite "release" is now a keyword, so use "release_" instead.

Note: to upgrade old databases, do a dump with an old Sqlite first; dumping with a new Sqlite will silently discard (!) the contents of the ReleaseSetJobs table.

Created by Eelco Dolstra on March 12, 2009

LCKWLQW3TCEGY4E7FRZYWYSP7SHRA5LNJ2A7TWU4LVIRZTF7K7ZQC

Dependencies

In channels

main

Change contents

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 39 [4.1]

B:BD[4.782] → [3.0:142]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L6NP/+9zhMg4TRw3w911rg

[4.782]

[4.924]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:11XN47b5bRrRKiWtzLO+Pw

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 38 [5.4268]

B:BD[5.4922] → [3.143:285]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yTJRsclWIpHApRSLqyR06Q

[5.4922]

[5.5064]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gUnxXuaqq40KFRIUSBmVuA

Replacement in src/lib/Hydra/Schema/BuildResultInfo.pm at line 38 [6.1594]

B:BD[6.2382] → [3.454:596]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o1XAUgKd15pN76Rs8aX+IA

[6.2382]

[6.2524]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xvSDu+FkyKp5wTAEGmiKOw

Replacement in src/lib/Hydra/Schema/BuildSchedulingInfo.pm at line 30 [6.3773]

B:BD[6.4473] → [3.731:873]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MeS9DLCs3kuhS4pTqfl4Lg

[6.4473]

[6.4615]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xv5P0Erv5oEy4r3c9RuV0w

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 38 [7.1675]

B:BD[7.2959] → [3.874:1016]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nFSksz60oxcM1+nYqAdjzw

[7.2959]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ne+uSrfxnk+wK60IrVoTww

Replacement in src/lib/Hydra/Schema/Builds.pm at line 79 [5.5202]

B:BD[5.6194] → [3.1017:1159]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p9SIzdyW9p4+eqwKwXzAdQ

[5.6194]

[6.3377]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iwt05CKHqfd33lW+wAC2mw

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 25 [8.859]

B:BD[8.1497] → [3.1160:1302]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zvTGb3qhlacSWzc0H+7dfg

[8.1497]

[8.1639]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hjklk18AGqKd7dDPUlqS9A

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 23 [8.1780]

B:BD[8.2342] → [3.1303:1445]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TY8SHfWiBibwiG3WPkP8Mg

[8.2342]

[8.2484]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OMt7YCEd4Vc3edHp2fxcrw

Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 34 [9.825]

B:BD[9.1831] → [3.1446:1588]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4iKXGIdrm56xZeHFxa/K4A

[9.1831]

[9.1973]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gQOuvSuoR2kczD57yaVSwQ

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 46 [10.590]

B:BD[10.1681] → [3.1589:1731]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rh03/olFXpMiTA+zhRYltg

[10.1681]

[10.1823]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GpIp3ENzylBZ9HQUNhO17Q

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 53 [10.1960]

B:BD[10.2992] → [3.1732:1874]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IfDpZfiD9haRHLXGdkapGg

[10.2992]

[10.3134]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BcAloJiRDPMvL/+GqsPiTw

Replacement in src/lib/Hydra/Schema/Projects.pm at line 48 [10.3266]

B:BD[10.3685] → [3.1875:2017]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7VRmssxrhgzfySJ6OGuhGg

[10.3685]

[10.3827]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TTHljyVTOMxXzNATXkltNg

Replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 13 [11.5076]
B:BD[11.5344] → [11.5344:5357]
```
  "release",
```
[11.5344]
[11.5357]
```
  "release_",
```

Replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 26 [11.5076]

B:BD[11.5791] → [11.5791:5859]

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

[11.5791]

[11.5859]

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

Replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 31 [11.5076]
∅:D[12.3315] → [11.6018:6065]
B:BD[11.6018] → [11.6018:6065]
```
  { name => "release", project => "project" },
```
[12.3315]
[11.6065]
```
  { name => "release_", project => "project" },
```

Replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 35 [11.5076]

B:BD[11.6070] → [3.2018:2160]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GdOtS3nLs7dwpArSdGob0w

[11.6070]

[11.6212]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YC+cgQcuvO4TxC5UpU7u4A

Replacement in src/lib/Hydra/Schema/ReleaseSets.pm at line 26 [11.6351]

B:BD[11.7053] → [11.7053:7132]

    "foreign.project" => "self.project",
    "foreign.release" => "self.name",

[11.7053]

[11.7132]

    "foreign.project"  => "self.project",
    "foreign.release_" => "self.name",

Replacement in src/lib/Hydra/Schema/ReleaseSets.pm at line 32 [11.6351]

B:BD[11.7142] → [3.2161:2303]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lQymTkBv/Av2y6iYjvP5PQ

[11.7142]

[11.7284]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Sv+5cdtqHDjWM0Zmmu0PSg

Replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 19 [13.1717]

B:BD[13.2105] → [3.2304:2446]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KZzTedcMG8IxkLgEEkdn9A

[13.2105]

[13.2247]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RLOKTpEzFYJMyzgMCg7zSg

Replacement in src/lib/Hydra/Schema/UserRoles.pm at line 20 [14.3263]

B:BD[14.3736] → [3.2447:2589]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9YGxnZD9hLoJJ8b1aejBuA

[14.3736]

[14.3878]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QTXCy6SeSRYYXW3odCVLiQ

Replacement in src/lib/Hydra/Schema/Users.pm at line 33 [15.3258]

B:BD[15.3782] → [3.2590:2732]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HwKK4N8V5fzvR3XrKnrDEA

[15.3782]

[15.3924]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eQFOcWRNwb7IE1ifGrw4rQ

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

B:BD[5.6498] → [3.2733:2875]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-09 18:05:06
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DQAmauNODAxmM2mF/AE2aQ

[5.6498]

[5.6640]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bK7m5SJjCnJKOckiufcb9w

Replacement in src/sql/hydra.sql at line 340 [16.1]

B:BD[11.12577] → [2.0:83]

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

[11.12577]

[11.12663]

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

Replacement in src/sql/hydra.sql at line 347 [16.1]

B:BD[17.3101] → [17.3101:3202]

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

[17.3101]

[17.3202]

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

Replacement in src/sql/hydra.sql at line 353 [16.1]

B:BD[11.12735] → [18.1546:1615]

∅:D[18.1615] → [11.12735:12768]

B:BD[11.12735] → [11.12735:12768]

    -- !!! urgh: "release" is a reserved keyword in sqlite >= 3.6.8!
    release       text not null,

[11.12735]

[11.12768]

    -- `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,

Replacement in src/sql/hydra.sql at line 373 [16.1]

B:BD[11.13252] → [11.13252:13302]

    primary key   (project, release, job, attrs),

[11.13252]

[11.13302]

    primary key   (project, release_, job, attrs),

Replacement in src/sql/hydra.sql at line 375 [16.1]

B:BD[11.13396] → [11.13396:13510]

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

[11.13396]

[11.13510]

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