Jobsets: add a SERIAL, unique, non-null id column

Dependencies

• [2] MWXDVTS3 Copy the flake migration from the flake branch
• [3] FYO6NECE hydra
• [4] PCKLFRT5 Support push notification of repository changes
• [5] LZVO64YG Merge in the first bits of the API work
• [6] KQAQ4FIF Update Schema classes
• [7] SS4TZXNU Distinguish between permanent evaluation errors and transient input errors
• [8] W5OAZWPD Drop the errorMsg column in the Jobs table
• [9] W4G5MZZS hydra-evaluator improvements
• [10] PCD3ZH6Z Partially revert 1c20cfdf2403feb78cef515faf15c04d5c9f17bd
• [11] KSBB33RE Add a dashboard
• [12] ACBS7C6Q hydra-queue-runner: Detect changes to the scheduling shares
• [13] CCIORPJ5 When manually scheduling an eval, force re-instantiation of store derivations
• [14] FGQPXZIX hydra: make nr of build to keep configurable per jobset
• [15] SB2V735V Keep track of the database schema version
• [16] X27GNHDV * Basic job info in the database.
• [17] QLOLZHRX Allow a per-jobset check interval
• [18] KN3VYE5P * Cleaned up the foreign key constraints.
• [19] DH3KNBAV Merge remote-tracking branch 'upstream/who-broke-builds' into upstream-master
• [20] GEADFVZ5 hydra-queue-runner: Improved scheduling
• [21] BXHG3HYL When renaming a jobset, add a redirect from the old name
• [22] T5BIOVJE Add support for tracking custom metrics
• [23] K3HODXGH Check all inputs for blame but only email selected inputs
• [24] IGR322YP sql: Generate models from postgresql
• [25] Y6AHH4TH Remove the logfile and logSize columns from the database
• [26] LLAJKVGI Fix syntax error
• [*] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] D5QIOJGP * Move everything up one directory.

Change contents

• edit in src/lib/Hydra/Schema/Jobsets.pm at line 42
  [28.18015]

  [28.18029]
  +

  + =head2 id
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 45
  [28.18030]

  [28.18030]
  + data_type: 'integer'

  + is_auto_increment: 1

  + is_nullable: 0

  + sequence: 'jobsets_id_seq'

  +
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 163
  [3.5577]

  [3.2219]
  + "id",

  + {

  + data_type => "integer",

  + is_auto_increment => 1,

  + is_nullable => 0,

  + sequence => "jobsets_id_seq",

  + },
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 225
  [3.21678]

  [3.1044]
  +

  + =head1 UNIQUE CONSTRAINTS

  +

  + =head2 C<jobsets_id_unique>

  +

  + =over 4

  +

  + =item * L</id>

  +

  + =back

  +

  + =cut

  +

  + __PACKAGE__->add_unique_constraint("jobsets_id_unique", ["id"]);
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 381
  [3.22628]→[2.643:785](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:21:11

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FVP1/AWjdKTlY6djrG592A
  [3.22628]

  [3.217]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:25:17

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1CMOaLf9fYRdJBlYiivmxA

  +

  + __PACKAGE__->add_column(

  + "+id" => { retrieve_on_insert => 1 }

  + );
• edit in src/sql/hydra.sql at line 55
  [3.4982]

  [3.4982]
  + id serial not null,
• replacement in src/sql/hydra.sql at line 80
  [3.5514]→[3.5514:5604](∅→∅)
  − foreign key (project) references Projects(name) on delete cascade on update cascade
  [3.5514]

  [3.5604]
  + foreign key (project) references Projects(name) on delete cascade on update cascade,

  + constraint Jobsets_id_unique UNIQUE(id)
• file addition: upgrade-59.sql (----------)
  [30.3004]
  + -- will automatically add unique IDs to Jobsets.

  + ALTER TABLE Jobsets

  + ADD COLUMN id SERIAL NOT NULL,

  + ADD CONSTRAINT Jobsets_id_unique UNIQUE (id);