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

[?]

Mar 12, 2009, 1:42 PM

LCKWLQW3TCEGY4E7FRZYWYSP7SHRA5LNJ2A7TWU4LVIRZTF7K7ZQC

Dependencies

[2] 5ZHSCNLJ
[3] 37R34XJO * Negative caching: don't perform a build if a dependency already
[4] G6HJY2V4
[5] H7CNGK4O * Log evaluation errors etc. in the DB.
[6] ZEHSSVFG
[7] R5D7DZPE
[8] 3ZCEPLNO
[9] ECBA3GQO * Make the schema class names match the case of the SQL table names.
[10] X27GNHDV * Basic job info in the database.
[11] DVNWJXWW * Generic declaration of build products.
[12] KOTB7BKV
[13] GWCV3TQV * BuildInputs table: link to dependencies, include store paths.
[14] TWVSALRL * Allow the maximum number of concurrent builds per platform to be
[15] 7YBYT2LQ
[16] J5UVLXOK * Start of a basic Catalyst web interface.
[17] M552HLIA * Support variant builds.
[18] CLJQCY2X * Store info about all the build actions and allow them to be
[19] S66BOMVU * Added authentication.
[20] D3DIBMOK * For products that are directories (like manuals), allow a default
[21] BVOPAMLS
[22] B72GLND4
[23] 6BLUKEQ2 * Caching of "path" inputs, and fake a revision number for those.
[24] IK53RV4V
[25] TQKGQ5R3
[26] L2E6EVE2 * Merged the Build and Job tables.
[27] YTZOC7C5 * Editing of jobset inputs.
[28] BD3GRK4B * Get rid of "positive failures" and separate log phases.
[29] ZVTSOVHN * Support Subversion checkouts.
[30] YAPITGB3 * Boolean inputs.
[31] FHF6IZJQ * Basic release management: releases are now dynamically computed as
[32] 67P45PY4
[33] VJHIHMEH * Store the meta.longDescription and meta.license attributes in the
[34] OIUIYIV2 * Give releases a timestamp.
[35] EYNG4EL4 * Regenerate the bindings from a clean sqlite database.
[36] WYN733ST * Store build duration, handle cached builds.
[37] BHZXGT2H * Channels: provide an index page that lists all the packages in the
[38] PHX2HIVG * Store info about the build inputs in the build record.
[39] V4RNHJNR * Add a link to each project's homepage. Suggested by karltk.
[40] SHBLLAVH * More global substitution.
[41] RU7AQO7U * Role-based access control. Only admins can create projects. Only
[42] VCOSLZRP
[43] TLZ2SPBR
[44] CMU3YKOU * Store the release name.
[45] 4X6NS66Q * Keep the most recent builds for each job.
[*] N22GPKYT * Put info about logs / build products in the DB.

Change contents

replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 39

[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

[4.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

[4.4922]

[4.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

[4.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

[4.2382]

[4.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

[4.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

[4.4473]

[4.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

[4.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

[4.2959]

[4.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

[4.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

[4.6194]

[4.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

[4.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

[4.1497]

[4.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

[4.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

[4.2342]

[4.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

[4.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

[4.1831]

[4.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

[4.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

[4.1681]

[4.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

[4.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

[4.2992]

[4.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

[4.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

[4.3685]

[4.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

[4.5344]→[4.5344:5357](∅→∅)

"release",

[4.5344]

[4.5357]

"release_",
replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 26

[4.5791]→[4.5791:5859](∅→∅)

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

[4.5791]

[4.5859]

__PACKAGE__->set_primary_key("project", "release_", "job", "attrs");
replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 31

[4.3315]→[4.6018:6065](∅→∅),[4.6018]→[4.6018:6065](∅→∅)

{ name => "release", project => "project" },

[4.3315]

[4.6065]

{ name => "release_", project => "project" },
replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 35

[4.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

[4.6070]

[4.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

[4.7053]→[4.7053:7132](∅→∅)

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

[4.7053]

[4.7132]

"foreign.project" => "self.project",
"foreign.release_" => "self.name",
replacement in src/lib/Hydra/Schema/ReleaseSets.pm at line 32

[4.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

[4.7142]

[4.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

[4.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

[4.2105]

[4.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

[4.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

[4.3736]

[4.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

[4.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

[4.3782]

[4.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

[4.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

[4.6498]

[4.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

[4.12577]→[2.0:83](∅→∅)

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

[4.12577]

[4.12663]

delete from ReleaseSetJobs where project = old.project and release_ = old.name;
replacement in src/sql/hydra.sql at line 347

[4.3101]→[4.3101:3202](∅→∅)

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

[4.3101]

[4.3202]

update ReleaseSetJobs set release_ = new.name where project = old.project and release_ = old.name;
replacement in src/sql/hydra.sql at line 353

[4.12735]→[4.1546:1615](∅→∅),[4.1615]→[4.12735:12768](∅→∅),[4.12735]→[4.12735:12768](∅→∅)

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

[4.12735]

[4.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

[4.13252]→[4.13252:13302](∅→∅)

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

[4.13252]

[4.13302]

primary key (project, release_, job, attrs),
replacement in src/sql/hydra.sql at line 375

[4.13396]→[4.13396:13510](∅→∅)

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

[4.13396]

[4.13510]

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