Copy the flake migration from the flake branch

[?]

Feb 9, 2020, 8:17 PM

MWXDVTS3V6SLJ27SJUVN3LT34H3ZMLHPYQCDV7C6KPLHV2QTEF7QC

Dependencies

[2] VCG6KNUX Remove the "clone build" feature
[3] IGR322YP sql: Generate models from postgresql
[4] X27GNHDV * Basic job info in the database.
[5] K3HODXGH Check all inputs for blame but only email selected inputs
[6] W5OAZWPD Drop the errorMsg column in the Jobs table
[7] T5BIOVJE Add support for tracking custom metrics
[8] H7CNGK4O * Log evaluation errors etc. in the DB.
[9] BSOLESYK * hydra: project members can do stuff that the owner can do
[10] SB2V735V Keep track of the database schema version
[11] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
[12] L2E6EVE2 * Merged the Build and Job tables.
[13] GEADFVZ5 hydra-queue-runner: Improved scheduling
[14] SS4TZXNU Distinguish between permanent evaluation errors and transient input errors
[15] KSBB33RE Add a dashboard
[16] KPZNJ33U * In views, support selecting a job that doesn't depend on the
[17] PCD3ZH6Z Partially revert 1c20cfdf2403feb78cef515faf15c04d5c9f17bd
[18] LZVO64YG Merge in the first bits of the API work
[19] KQAQ4FIF Update Schema classes
[20] Y6AHH4TH Remove the logfile and logSize columns from the database
[21] KN3VYE5P * Cleaned up the foreign key constraints.
[22] G2T4WAHI Store the inputs of each evaluation in the database
[23] CCIORPJ5 When manually scheduling an eval, force re-instantiation of store derivations
[24] QNDXPVCI * Store the jobset's nixExprPath and nixExprInput fields in a build to
[25] AZCCANUB Missing part of aaacf9eda36f5cdcc77cec20d6f49fbb6f925105
[26] PCKLFRT5 Support push notification of repository changes
[27] DH3KNBAV Merge remote-tracking branch 'upstream/who-broke-builds' into upstream-master
[28] W4G5MZZS hydra-evaluator improvements
[29] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
[30] QMW24O5S Add support for Guile & Guix.
[31] AHTEIK7G * Added a maintainers field to the Builds table.
[32] QLOLZHRX Allow a per-jobset check interval
[*] 5SHCWE7X * Prevent repeated evaluation of a jobset with the same inputs. This
[*] FGQPXZIX hydra: make nr of build to keep configurable per jobset
[*] N22GPKYT * Put info about logs / build products in the DB.
[*] LLAJKVGI Fix syntax error
[*] RFE6T5LG * Store jobset evaluations in the database explicitly. This includes
[*] D5QIOJGP * Move everything up one directory.

Change contents

edit in src/lib/Hydra/Schema/JobsetEvals.pm at line 90

[4.614]

[4.614]

is_nullable: 1

=head2 flake

data_type: 'text'
edit in src/lib/Hydra/Schema/JobsetEvals.pm at line 125

[4.759]

[34.867]

"flake",
{ data_type => "text", is_nullable => 1 },
replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 204

[4.18354]→[3.4690:4832](∅→∅)

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4ZaT8Z1tmCCt6k4ein0MNg

[4.18354]

[4.1674]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:21:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ar6GRni8AcAQmuZyg6tFKw
replacement in src/lib/Hydra/Schema/Jobsets.pm at line 57

[4.18314]→[4.18314:18331](∅→∅)

is_nullable: 0

[4.20586]

[4.18345]

is_nullable: 1
replacement in src/lib/Hydra/Schema/Jobsets.pm at line 62

[4.20607]→[4.18407:18424](∅→∅),[4.18407]→[4.18407:18424](∅→∅)

is_nullable: 0

[4.20607]

[4.18438]

is_nullable: 1
edit in src/lib/Hydra/Schema/Jobsets.pm at line 139

[4.148]

[35.287]

=head2 type

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

[35.288]

[4.18998]

=head2 flake

data_type: 'text'
is_nullable: 1
replacement in src/lib/Hydra/Schema/Jobsets.pm at line 161

[4.2387]→[3.5578:5623](∅→∅)

{ data_type => "text", is_nullable => 0 },

[4.2387]

[4.2447]

{ data_type => "text", is_nullable => 1 },
replacement in src/lib/Hydra/Schema/Jobsets.pm at line 163

[4.2464]→[4.21041:21086](∅→∅)

{ data_type => "text", is_nullable => 0 },

[4.2464]

[4.1457]

{ data_type => "text", is_nullable => 1 },
edit in src/lib/Hydra/Schema/Jobsets.pm at line 192

[4.4341]

[4.2524]

"type",
{ data_type => "integer", default_value => 0, is_nullable => 0 },
"flake",
{ data_type => "text", is_nullable => 1 },
replacement in src/lib/Hydra/Schema/Jobsets.pm at line 353

[4.22628]→[3.5624:5766](∅→∅)

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fYKx6VRlNG5XiDZ73Qr6Rw

[4.22628]

[4.217]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:21:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FVP1/AWjdKTlY6djrG592A
replacement in src/sql/hydra.sql at line 57

[4.5039]→[4.11667:11845](∅→∅)

nixExprInput text not null, -- name of the jobsetInput containing the Nix or Guix expression
nixExprPath text not null, -- relative path of the Nix or Guix expression

[4.5039]

[4.5201]

nixExprInput text, -- name of the jobsetInput containing the Nix or Guix expression
nixExprPath text, -- relative path of the Nix or Guix expression
edit in src/sql/hydra.sql at line 73

[4.4843]

[37.0]

type integer not null default 0, -- 0 == legacy, 1 == flake
flake text,
edit in src/sql/hydra.sql at line 76

[37.34]

[4.5479]

check ((type = 0) = (nixExprInput is not null and nixExprPath is not null)),
check ((type = 1) = (flake is not null)),
replacement in src/sql/hydra.sql at line 188

[2.69]→[4.729:743](∅→∅),[4.729]→[4.729:743](∅→∅)

-- build.

[2.69]

[4.743]

-- build. FIXME: this should be stored in JobsetEvals, storing it
-- here is denormal.
edit in src/sql/hydra.sql at line 530

[38.7668]

[34.3340]

flake text, -- immutable flake reference
file addition: upgrade-58.sql (----------)

[39.3004]

alter table Jobsets alter column nixExprInput drop not null;
alter table Jobsets alter column nixExprPath drop not null;
alter table Jobsets add column type integer default 0;
alter table Jobsets add column flake text;
alter table Jobsets add check ((type = 0) = (nixExprInput is not null and nixExprPath is not null));
alter table Jobsets add check ((type = 1) = (flake is not null));
alter table JobsetEvals add column flake text;