Drop unused "disabled" columns

[?]

May 3, 2013, 2:39 PM

YTIDBFGUR65L6D6OKGQWTKHJJQK3NCC6WDNQFTA7E6EATVOX4Y5AC

Dependencies

[2] PMNWRTGJ Add multiple output support
[3] YEXD7CBK Fix findBuildDependencyInQueue
[4] Y6AHH4TH Remove the logfile and logSize columns from the database
[5] SB2V735V Keep track of the database schema version
[6] LFZOBIYZ Update how to restart builds
[7] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
[8] DQD7JMSU * Fix the terminology.
[9] L2E6EVE2 * Merged the Build and Job tables.
[10] UUGBVEGY * Development notes.
[11] A5V7HLIQ * Shut up DBIx::Class.
[12] RFE6T5LG * Store jobset evaluations in the database explicitly. This includes
[13] LZO3C2KI * Hack around those SQLite timeouts: just retry the transaction.
[14] SJLEZFC4 check getHydraPath in stead of Envvar HYDRA_DBI directly
[15] JTRG7RDQ add support for git as jobinput
[16] Z4KRJX4Q * In the last succeeded / job status queries, use the Builds.isCurrent
[17] 3HCBU2FA
[18] 7YBYT2LQ
[19] HPEG2RHV Merge the BuildResultInfo table into the Builds table
[20] QNDXPVCI * Store the jobset's nixExprPath and nixExprInput fields in a build to
[21] P5X4P6VK * Renaming "release sets" to "views" (not finished yet). Having
[22] ZTQEU5QS Hydra: Add support for maxSilent meta attribute (also already added timeout, but not implemented the actual timeout for the build yet)
[23] 5O6E5SU5 hydra: store logfile/output path/closure size
[24] NREF6YOA * Don't start more builds concurrently than allowed for each system
[25] R5D7DZPE
[26] T7CCJQOF * Revert for now due to Postgres breakage.
[27] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
[28] G2T4WAHI Store the inputs of each evaluation in the database
[29] 4D4U5IPY * Allow jobsets to be disabled.
[30] 3ZCEPLNO
[31] E6IC7YIK * Release sets: need to include the jobset name to disambiguate
[32] 3PNG7NIB Remove trailing whitespace
[33] QZLMDKMU * Queue runner: don't start scheduled builds builds if they belong to
[34] KN3VYE5P * Cleaned up the foreign key constraints.
[35] RBNQKATL * Adding persistant releases. A release is a named set of builds.
[36] AHTEIK7G * Added a maintainers field to the Builds table.
[37] S6OISBQ3 * Mark the "current" builds in a jobset, i.e. those corresponding to
[38] CVDK3XJK * In the scheduler, don't check if we've already done a build (except
[39] 2YXO5ZGQ Hydra/28: Rename "scheduler" to "evaluator"
[40] OV7F5M3E Merge branch 'queue-17'
[41] S5PV6IIM * Represent jobs explicitly in the DB.
[*] J5UVLXOK * Start of a basic Catalyst web interface.
[*] N22GPKYT * Put info about logs / build products in the DB.
[*] D5QIOJGP * Move everything up one directory.

Change contents

edit in doc/dev-notes.txt at line 71

[4.49]→[4.3550:4491](∅→∅),[4.3550]→[4.3550:4491](∅→∅),[4.4491]→[4.0:118](∅→∅),[4.118]→[4.0:1](∅→∅),[4.1]→[4.0:87](∅→∅),[4.87]→[4.1:62](∅→∅),[4.1]→[4.1:62](∅→∅),[4.62]→[4.88:420](∅→∅)

* Upgrade notes:

alter table builds add column longDescription text;
alter table builds add column license text;
alter table projects add column homepage text;
alter table builds add column homepage text;
alter table BuildProducts add column defaultPath text;
alter table BuildResultInfo add column failedDepBuild integer;
alter table BuildResultInfo add column failedDepStepNr integer;
alter table ReleaseSetJobs add column jobset text not null default "trunk";
=== (DB dump/load needed after Sqlite upgrade) ===
insert into jobs(project, jobset, name, active) select distinct project, jobset, job, 0 from builds b where not exists (select 1 from jobs where project = b.project and jobset = b.jobset and name = b.job);

create index IndexBuildInputsByBuild on BuildInputs(build);
create index IndexBuildInputsByDependency on BuildInputs(dependency);

create index IndexBuildsByTimestamp on Builds(timestamp);

alter table jobs add column disabled integer not null default 0;
alter table builds add column maintainers text;

# Add the isCurrent column to Builds and use the obsolete Jobs.active to fill it in.
alter table builds add column isCurrent integer default 0;
update builds set isCurrent = 1 where id in (select max(id) from builds natural join (select distinct b.project, b.jobset, b.job, b.system from builds b join (select project, jobset, name from jobs where active = 1) j on b.project = j.project and b.jobset = j.jobset and b.job = j.name) b2 group by project, jobset, job, system);
edit in doc/dev-notes.txt at line 72

[4.1]→[4.1:70](∅→∅)

alter table Jobsets add column enabled integer not null default 1;
edit in doc/dev-notes.txt at line 73

[4.71]→[4.0:66](∅→∅),[4.115]→[4.115:339](∅→∅),[4.339]→[4.0:101](∅→∅),[4.101]→[4.203:299](∅→∅),[4.101]→[4.339:340](∅→∅),[4.299]→[4.339:340](∅→∅),[4.339]→[4.339:340](∅→∅),[4.71]→[4.4494:4497](∅→∅),[4.340]→[4.4494:4497](∅→∅),[4.4494]→[4.4494:4497](∅→∅)

# Releases -> Views.
alter table ReleaseSets rename to Views;
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;

alter table Builds add column nixExprInput text;
alter table Builds add column nixExprPath text;

# Adding JobsetEvals.
drop table JobsetInputHashes;
(add JobsetEvals, JobsetEvalMembers)
edit in src/lib/Hydra/Schema/Builds.pm at line 149

[4.8785]→[4.4476:4493](∅→∅),[4.4493]→[4.8799:8800](∅→∅),[4.8799]→[4.8799:8800](∅→∅),[4.8800]→[4.4494:4553](∅→∅)

=head2 disabled

data_type: 'integer'
default_value: 0
is_nullable: 0
edit in src/lib/Hydra/Schema/Builds.pm at line 245

[4.4890]→[4.4890:4972](∅→∅)

"disabled",
{ data_type => "integer", default_value => 0, is_nullable => 0 },
replacement in src/lib/Hydra/Schema/Builds.pm at line 460

[4.1182]→[2.10567:10709](∅→∅)

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-30 16:22:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YBdqPWScG4dtGx+U3dJcwA

[4.1182]

[4.3377]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-05-03 14:35:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aYVEk+AeDsgTRi5GAqOhEw
edit in src/lib/Hydra/Schema/Jobs.pm at line 63

[4.14309]→[4.14309:14327](∅→∅),[4.14327]→[4.15353:15376](∅→∅),[4.15376]→[4.14348:14384](∅→∅),[4.14348]→[4.14348:14384](∅→∅)

=head2 disabled

data_type: 'integer'
default_value: 0
is_nullable: 0
edit in src/lib/Hydra/Schema/Jobs.pm at line 81

[4.15769]→[4.11272:11286](∅→∅),[4.11272]→[4.11272:11286](∅→∅),[4.11286]→[4.15770:15838](∅→∅)

"disabled",
{ data_type => "integer", default_value => 0, is_nullable => 0 },
replacement in src/lib/Hydra/Schema/Jobs.pm at line 151

[4.2613]→[4.3831:3973](∅→∅)

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-22 13:29:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vfl4QtuyeKeEk9+Ap7FP2A

[4.2613]

[4.2756]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-05-03 14:35:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uZ27Dcbywi99pCW7Ml4j3A
replacement in src/script/hydra-queue-runner at line 58

[3.296]→[3.296:374](∅→∅)

{ drvpath => [ @deps ], finished => 0, enabled => 1, disabled => 0 },

[3.296]

[3.374]

{ drvpath => [ @deps ], finished => 0, enabled => 1 },
replacement in src/script/hydra-queue-runner at line 82

[4.139]→[4.419:490](∅→∅)

{ finished => 0, busy => 0, enabled => 1, disabled => 0 },

[4.139]

[4.7034]

{ finished => 0, busy => 0, enabled => 1 },
replacement in src/script/hydra-queue-runner at line 102

[4.625]→[4.601:703](∅→∅)

{ finished => 0, busy => 0, system => $system->system, enabled => 1, disabled => 0 },

[4.625]

[4.7208]

{ finished => 0, busy => 0, system => $system->system, enabled => 1 },
edit in src/sql/hydra.sql at line 109

[4.608]→[4.7199:7272](∅→∅),[4.7199]→[4.7199:7272](∅→∅)

disabled integer not null default 0, -- !!! not currently used
edit in src/sql/hydra.sql at line 160

[4.9768]→[4.2311:2312](∅→∅),[4.2312]→[4.7820:7881](∅→∅)

disabled integer not null default 0, -- !!! boolean
file addition: upgrade-14.sql (----------)

[45.3004]

alter table Jobs drop column disabled;
alter table Builds drop column disabled;