Builds: add a nullable jobset_id foreign key to Jobsets.

Dependencies

• [2] B7ENVLRS hydra-queue-runner: Make build notification more reliable
• [3] SIDK2E7V Jobs: add a nullable jobset_id foreign key to Jobsets.
• [4] ITJWNQEZ Update Hydra schema, otherwise hydra-notify will not work.
• [5] TWVSALRL * Allow the maximum number of concurrent builds per platform to be
• [6] B72GLND4
• [7] 4CELXP7P Remove the longDescription field
• [8] D3DIBMOK * For products that are directories (like manuals), allow a default
• [9] BD3GRK4B * Get rid of "positive failures" and separate log phases.
• [10] LCKWLQW3 * In Sqlite "release" is now a keyword, so use "release_" instead.
• [11] GEADFVZ5 hydra-queue-runner: Improved scheduling
• [12] 4S5JF5JP Use latest DBIx::Class::Schema::Loader
• [13] FTPCV25M Store aggregate members in the database
• [14] TPNHTE5V Remove obsolete Builds columns and provide accurate "Running builds"
• [15] SB2V735V Keep track of the database schema version
• [16] CCIORPJ5 When manually scheduling an eval, force re-instantiation of store derivations
• [17] W4G5MZZS hydra-evaluator improvements
• [18] IGR322YP sql: Generate models from postgresql
• [19] 53IMJNBB Add isChannel column and meta attribute.
• [20] S66BOMVU * Added authentication.
• [21] 3E6IP3R3 * Add the name of the jobset to ReleaseSetJobs, otherwise we can't
• [22] JTHWA6AM Rename aggregate members to constituents
• [23] L2E6EVE2 * Merged the Build and Job tables.
• [24] AHTEIK7G * Added a maintainers field to the Builds table.
• [25] S5PV6IIM * Represent jobs explicitly in the DB.
• [26] Y6AHH4TH Remove the logfile and logSize columns from the database
• [27] BHZXGT2H * Channels: provide an index page that lists all the packages in the
• [28] YTZOC7C5 * Editing of jobset inputs.
• [29] GNIEG2GC * Disambiguate jobs by jobset name. I.e. jobs with the same name in
• [30] QLOLZHRX Allow a per-jobset check interval
• [31] YTIDBFGU Drop unused "disabled" columns
• [32] CMU3YKOU * Store the release name.
• [33] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
• [34] G2T4WAHI Store the inputs of each evaluation in the database
• [35] KSBB33RE Add a dashboard
• [36] FYO6NECE hydra
• [37] EYNG4EL4 * Regenerate the bindings from a clean sqlite database.
• [38] R5D7DZPE
• [39] RU7AQO7U * Role-based access control. Only admins can create projects. Only
• [40] T5BIOVJE Add support for tracking custom metrics
• [41] WE5Q2NVI Allow build to be bumped to the front of the queue via the web interface
• [42] ZI535LI6 * hydra: 'new' UI for project/jobset/job/build
• [43] PCD3ZH6Z Partially revert 1c20cfdf2403feb78cef515faf15c04d5c9f17bd
• [44] DH3KNBAV Merge remote-tracking branch 'upstream/who-broke-builds' into upstream-master
• [45] MWXDVTS3 Copy the flake migration from the flake branch
• [46] 3ZCEPLNO
• [47] SJLEZFC4 check getHydraPath in stead of Envvar HYDRA_DBI directly
• [48] TQKGQ5R3
• [49] IK53RV4V
• [50] TLZ2SPBR
• [51] KQAQ4FIF Update Schema classes
• [52] PMNWRTGJ Add multiple output support
• [53] X27GNHDV * Basic job info in the database.
• [54] W5OAZWPD Drop the errorMsg column in the Jobs table
• [55] YAPITGB3 * Boolean inputs.
• [56] PCKLFRT5 Support push notification of repository changes
• [57] FZR7ET5D Jobsets: add a SERIAL, unique, non-null id column
• [58] ZVTSOVHN * Support Subversion checkouts.
• [59] ECBA3GQO * Make the schema class names match the case of the SQL table names.
• [60] VJHIHMEH * Store the meta.longDescription and meta.license attributes in the
• [61] 37R34XJO * Negative caching: don't perform a build if a dependency already
• [62] KOTB7BKV
• [63] SHBLLAVH * More global substitution.
• [64] H7CNGK4O * Log evaluation errors etc. in the DB.
• [65] K3HODXGH Check all inputs for blame but only email selected inputs
• [66] FHF6IZJQ * Basic release management: releases are now dynamically computed as
• [67] SS4TZXNU Distinguish between permanent evaluation errors and transient input errors
• [68] V4RNHJNR * Add a link to each project's homepage. Suggested by karltk.
• [69] LZVO64YG Merge in the first bits of the API work
• [70] 6BLUKEQ2 * Caching of "path" inputs, and fake a revision number for those.
• [71] CLJQCY2X * Store info about all the build actions and allow them to be
• [72] 26PYNDXV Remove the errorMsg column from the Builds table
• [*] J5UVLXOK * Start of a basic Catalyst web interface.
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] TM6C352U Ensure that stoptime and starttime are set for finished builds
• [*] D5QIOJGP * Move everything up one directory.

Change contents

• edit in src/lib/Hydra/Schema/Builds.pm at line 66
  [4.7586]

  [4.7600]
  +

  + =head2 jobset_id

  +

  + data_type: 'integer'

  + is_foreign_key: 1

  + is_nullable: 1
• edit in src/lib/Hydra/Schema/Builds.pm at line 224
  [4.8335]

  [4.1331]
  + "jobset_id",

  + { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
• edit in src/lib/Hydra/Schema/Builds.pm at line 467
  [4.10436]

  [4.10436]
  + "Hydra::Schema::Jobsets",

  + { id => "jobset_id" },

  + {

  + is_deferrable => 0,

  + join_type => "LEFT",

  + on_delete => "CASCADE",

  + on_update => "NO ACTION",

  + },

  + );

  +

  + =head2 jobset_project_jobset

  +

  + Type: belongs_to

  +

  + Related object: L<Hydra::Schema::Jobsets>

  +

  + =cut

  +

  + __PACKAGE__->belongs_to(

  + "jobset_project_jobset",
• replacement in src/lib/Hydra/Schema/Builds.pm at line 581
  [4.3378]→[4.1911:2053](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H3hs+zEywsUmwTWKfSE8wQ
  [4.3378]

  [4.4481]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:32:28

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RvrINOAowDcde8Nd9VD6rQ
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 259
  [4.7385]

  [4.19217]
  +

  + =head2 builds_jobset_ids

  +

  + Type: has_many
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 264
  [4.19218]→[4.21697:21711](∅→∅)
  − =head2 builds
  [4.19218]

  [4.19235]
  + Related object: L<Hydra::Schema::Builds>

  +

  + =cut

  +

  + __PACKAGE__->has_many(

  + "builds_jobset_ids",

  + "Hydra::Schema::Builds",

  + { "foreign.jobset_id" => "self.id" },

  + undef,

  + );

  +

  + =head2 builds_project_jobsets
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 284
  [4.2575]→[4.21754:21766](∅→∅)
  − "builds",
  [4.2575]

  [4.21766]
  + "builds_project_jobsets",
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 411
  [4.22628]→[3.908:1050](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:26:15

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DH1jX0smo2rFvyr4V+qJcw
  [4.22628]

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

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:P8+t7rgpOqkGwRdM2b+3Bw

  +

  +

  + =head2 builds
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 417
  [3.1051]

  [3.1051]
  + Type: has_many

  +

  + Related object: L<Hydra::Schema::Builds>

  +

  + =cut

  +

  + __PACKAGE__->has_many(

  + "builds",

  + "Hydra::Schema::Builds",

  + {

  + "foreign.jobset" => "self.name",

  + "foreign.project" => "self.project",

  + },

  + undef,

  + );

  +
• edit in src/sql/hydra.sql at line 173
  [4.5820]

  [4.5820]
  + jobset_id integer null,
• edit in src/sql/hydra.sql at line 240
  [76.143]

  [2.1531]
  + foreign key (jobset_id) references Jobsets(id) on delete cascade,
• file addition: upgrade-61.sql (----------)
  [77.3004]
  + -- Add the jobset_id columns to the Builds table. This will go

  + -- quickly, since the field is nullable. Note this is just part one of

  + -- this migration. Future steps involve a piecemeal backfilling, and

  + -- then making the column non-null.

  +

  + ALTER TABLE Builds

  + ADD COLUMN jobset_id integer NULL,

  + ADD FOREIGN KEY (jobset_id)

  + REFERENCES Jobsets(id)

  + ON DELETE CASCADE;