sql: Generate models from postgresql

Dependencies

• [2] RUTFLXFQ Drop unused BuildProducts.description column
• [3] 6WRGCITD Enable declarative projects.
• [4] BKMQXGBO Allow public dashboards
• [5] EPWEMRI2 Allow determinism checking for entire jobsets
• [6] W4G5MZZS hydra-evaluator improvements
• [7] ITJWNQEZ Update Hydra schema, otherwise hydra-notify will not work.
• [8] YU6CND7C Remove support for views
• [9] KQAQ4FIF Update Schema classes
• [10] ZIIXICG7 Make the outputs' outpaths available via the Build JSON API
• [11] RU7AQO7U * Role-based access control. Only admins can create projects. Only
• [12] JTHWA6AM Rename aggregate members to constituents
• [13] WE5Q2NVI Allow build to be bumped to the front of the queue via the web interface
• [14] FTPCV25M Store aggregate members in the database
• [15] P73KM42L Update the list of SQL files to be installed.
• [16] EYNG4EL4 * Regenerate the bindings from a clean sqlite database.
• [17] 7YBYT2LQ
• [18] S6OISBQ3 * Mark the "current" builds in a jobset, i.e. those corresponding to
• [19] K3HODXGH Check all inputs for blame but only email selected inputs
• [20] TQKGQ5R3
• [21] YTZOC7C5 * Editing of jobset inputs.
• [22] SB2V735V Keep track of the database schema version
• [23] PHX2HIVG * Store info about the build inputs in the build record.
• [24] QLOLZHRX Allow a per-jobset check interval
• [25] CMU3YKOU * Store the release name.
• [26] KXGOUX7P * Creating releases.
• [27] 53IMJNBB Add isChannel column and meta attribute.
• [28] KSBB33RE Add a dashboard
• [29] 6BLUKEQ2 * Caching of "path" inputs, and fake a revision number for those.
• [30] FANTYCR7 Materialize the number of finished builds
• [31] BHZXGT2H * Channels: provide an index page that lists all the packages in the
• [32] S66BOMVU * Added authentication.
• [33] PCD3ZH6Z Partially revert 1c20cfdf2403feb78cef515faf15c04d5c9f17bd
• [34] FGQPXZIX hydra: make nr of build to keep configurable per jobset
• [35] J5UVLXOK * Start of a basic Catalyst web interface.
• [36] BK24VA6Q * for git inputs, check latest revision of branch (defaults to master for now), if there is change, only use input if last checkout was > hour ago.
• [37] 4VYSDP4I Add eager fetching of relations and enable that for jobset->jobsetinputs
• [38] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
• [39] DHMTPGST * Ran update-dbix.
• [40] D44B24QC Store the account type ("hydra" or "persona") explicitly in the database
• [41] FHF6IZJQ * Basic release management: releases are now dynamically computed as
• [42] LZVO64YG Merge in the first bits of the API work
• [43] GWCV3TQV * BuildInputs table: link to dependencies, include store paths.
• [44] VJHIHMEH * Store the meta.longDescription and meta.license attributes in the
• [45] JTRG7RDQ add support for git as jobinput
• [46] 4HPT4SDD Revert "Remove now-unused SystemTypes table"
• [47] BVOPAMLS
• [48] EHEJZ6YV Actually add SQL files to the distribution.
• [49] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
• [50] SYLVCTT6 Start api cleanup with the User model
• [51] 3ZCEPLNO
• [52] TWVSALRL * Allow the maximum number of concurrent builds per platform to be
• [53] 7ZSVXUGF sequence fix for postgresql
• [54] JJT5QG3K remove revision from cached cvs inputs, and added missing files
• [55] SHBLLAVH * More global substitution.
• [56] 4CELXP7P Remove the longDescription field
• [57] GEADFVZ5 hydra-queue-runner: Improved scheduling
• [58] H7CNGK4O * Log evaluation errors etc. in the DB.
• [59] R5D7DZPE
• [60] 3HCBU2FA
• [61] SJLEZFC4 check getHydraPath in stead of Envvar HYDRA_DBI directly
• [62] 3E6IP3R3 * Add the name of the jobset to ReleaseSetJobs, otherwise we can't
• [63] QQ4STW3S missing file
• [64] 4D4U5IPY * Allow jobsets to be disabled.
• [65] DH3KNBAV Merge remote-tracking branch 'upstream/who-broke-builds' into upstream-master
• [66] DVNWJXWW * Generic declaration of build products.
• [67] NABL63FI * hydra: project members can do stuff that the owner can do
• [68] Q5HZWFCY Add support for darcs repositories.
• [69] L2E6EVE2 * Merged the Build and Job tables.
• [70] BXHG3HYL When renaming a jobset, add a redirect from the old name
• [71] PMNWRTGJ Add multiple output support
• [72] W5OAZWPD Drop the errorMsg column in the Jobs table
• [73] CLJQCY2X * Store info about all the build actions and allow them to be
• [74] TPNHTE5V Remove obsolete Builds columns and provide accurate "Running builds"
• [75] OKLEIKBG Add missing upgrade-*.sql files
• [76] V4RNHJNR * Add a link to each project's homepage. Suggested by karltk.
• [77] M552HLIA * Support variant builds.
• [78] D3DIBMOK * For products that are directories (like manuals), allow a default
• [79] P5X4P6VK * Renaming "release sets" to "views" (not finished yet). Having
• [80] RFE6T5LG * Store jobset evaluations in the database explicitly. This includes
• [81] ZI535LI6 * hydra: 'new' UI for project/jobset/job/build
• [82] AZCCANUB Missing part of aaacf9eda36f5cdcc77cec20d6f49fbb6f925105
• [83] FITVNQ2S Keep track of the time we spend copying to/from build machines
• [84] ZWCTAZGL added newsitems, added some admin options to clear various caches.
• [85] RBNQKATL * Adding persistant releases. A release is a named set of builds.
• [86] ZVTSOVHN * Support Subversion checkouts.
• [87] FYO6NECE hydra
• [88] T5BIOVJE Add support for tracking custom metrics
• [89] CCIORPJ5 When manually scheduling an eval, force re-instantiation of store derivations
• [90] KPZNJ33U * In views, support selecting a job that doesn't depend on the
• [91] G2T4WAHI Store the inputs of each evaluation in the database
• [92] ECBA3GQO * Make the schema class names match the case of the SQL table names.
• [93] GNIEG2GC * Disambiguate jobs by jobset name. I.e. jobs with the same name in
• [94] MQYHIUEE Cleanup eval serialization
• [95] 4S5JF5JP Use latest DBIx::Class::Schema::Loader
• [96] 26PYNDXV Remove the errorMsg column from the Builds table
• [97] TLZ2SPBR
• [98] 5SHCWE7X * Prevent repeated evaluation of a jobset with the same inputs. This
• [99] YAPITGB3 * Boolean inputs.
• [100] FD76WVTQ missing file
• [101] PCKLFRT5 Support push notification of repository changes
• [102] 37R34XJO * Negative caching: don't perform a build if a dependency already
• [103] KN3VYE5P * Cleaned up the foreign key constraints.
• [104] SS4TZXNU Distinguish between permanent evaluation errors and transient input errors
• [105] BD3GRK4B * Get rid of "positive failures" and separate log phases.
• [106] AHTEIK7G * Added a maintainers field to the Builds table.
• [107] B72GLND4
• [108] 2NGV7NYN Drop unused "tag" column
• [109] IK53RV4V
• [110] LCKWLQW3 * In Sqlite "release" is now a keyword, so use "release_" instead.
• [111] KOTB7BKV
• [112] Y6AHH4TH Remove the logfile and logSize columns from the database
• [113] YTIDBFGU Drop unused "disabled" columns
• [114] 7ECJWNVX Cleanup Project model
• [115] ZEHSSVFG
• [116] X27GNHDV * Basic job info in the database.
• [117] RYTQLATY Keep track of failed paths in the Hydra database
• [118] UJOSXBZI Record which build a failed build step was propagated from
• [119] 67P45PY4
• [120] WYN733ST * Store build duration, handle cached builds.
• [121] S5PV6IIM * Represent jobs explicitly in the DB.
• [122] PHJF4FUT Add missing files
• [*] D5QIOJGP * Move everything up one directory.

Change contents

• replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 30
  [8.2063]→[8.463:502](∅→∅)
  − =head1 TABLE: C<AggregateConstituents>
  [8.2063]

  [8.2097]
  + =head1 TABLE: C<aggregateconstituents>
• replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 34
  [8.2104]→[8.503:548](∅→∅)
  − __PACKAGE__->table("AggregateConstituents");
  [8.2104]

  [8.2144]
  + __PACKAGE__->table("aggregateconstituents");
• replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 106
  [8.3180]→[8.737:879](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-08-15 00:20:01

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TLNenyPLIWw2gWsOVhplZw
  [8.3180]

  [8.3322]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bQfQoSstlaFy7zw8i1R+ow
• replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 30
  [8.32]→[8.59:88](∅→∅)
  − =head1 TABLE: C<BuildInputs>
  [8.32]

  [8.32]
  + =head1 TABLE: C<buildinputs>
• replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 34
  [8.137]→[8.859:894](∅→∅)
  − __PACKAGE__->table("BuildInputs");
  [8.99]

  [8.80]
  + __PACKAGE__->table("buildinputs");
• edit in src/lib/Hydra/Schema/BuildInputs.pm at line 43
  [8.194]

  [8.208]
  + sequence: 'buildinputs_id_seq'
• replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 102
  [8.1143]→[8.329:401](∅→∅)
  − { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  [8.1143]

  [8.1206]
  + {

  + data_type => "integer",

  + is_auto_increment => 1,

  + is_nullable => 0,

  + sequence => "buildinputs_id_seq",

  + },
• replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 185
  [8.25]→[8.815:957](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-10-08 13:08:15

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OaJPzRM+8XGsu3eIkqeYEw
  [8.25]

  [8.151]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/Fwb8emBsvwrZlEab2X+gQ
• replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 30
  [8.3631]→[8.3631:3661](∅→∅)
  − =head1 TABLE: C<BuildMetrics>
  [8.3631]

  [8.3661]
  + =head1 TABLE: C<buildmetrics>
• replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 34
  [8.3668]→[8.3668:3704](∅→∅)
  − __PACKAGE__->table("BuildMetrics");
  [8.3668]

  [8.3704]
  + __PACKAGE__->table("buildmetrics");
• replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 180
  [8.6026]→[8.6026:6168](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-07-30 16:52:20

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qoPm5/le+sVHigW4Dmum2Q
  [8.6026]

  [8.6168]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Roy7h/K9u7DQOzet4B1sbA
• replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 30
  [8.242]→[8.242:272](∅→∅)
  − =head1 TABLE: C<BuildOutputs>
  [8.242]

  [8.272]
  + =head1 TABLE: C<buildoutputs>
• replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 34
  [8.279]→[8.279:315](∅→∅)
  − __PACKAGE__->table("BuildOutputs");
  [8.279]

  [8.315]
  + __PACKAGE__->table("buildoutputs");
• replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 97
  [8.1127]→[8.26971:27113](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V8MbzKvZNEaeHBJV67+ZMQ
  [8.1127]

  [8.0]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:71R9clwAP6vzDh10EukTaw
• replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 30
  [8.1500]→[8.2687:2718](∅→∅)
  − =head1 TABLE: C<BuildProducts>
  [8.1500]

  [8.4342]
  + =head1 TABLE: C<buildproducts>
• replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 34
  [8.1550]→[8.1412:1449](∅→∅),[8.4406]→[8.1412:1449](∅→∅)
  − __PACKAGE__->table("BuildProducts");
  [8.1550]

  [8.1551]
  + __PACKAGE__->table("buildproducts");
• replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 146
  [8.5065]→[2.0:142](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-04-13 14:49:33

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kONECZn56f7sqfrLviiUOQ
  [8.5065]

  [8.5065]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iI0gmKqQxiPBTy5QsM6tpQ
• replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 30
  [8.1664]→[8.1664:1698](∅→∅)
  − =head1 TABLE: C<BuildStepOutputs>
  [8.1664]

  [8.1698]
  + =head1 TABLE: C<buildstepoutputs>
• replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 34
  [8.1705]→[8.1705:1745](∅→∅)
  − __PACKAGE__->table("BuildStepOutputs");
  [8.1705]

  [8.1745]
  + __PACKAGE__->table("buildstepoutputs");
• replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 122
  [8.3027]→[8.27549:27691](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A/4v3ugXYbuYoKPlOvC6mg
  [8.3027]

  [8.3169]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Y6DpbTM6z4cOGoYIhD3i1A
• replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 30
  [8.5579]→[8.6272:6300](∅→∅)
  − =head1 TABLE: C<BuildSteps>
  [8.5579]

  [8.5619]
  + =head1 TABLE: C<buildsteps>
• replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 34
  [8.5626]→[8.1810:1844](∅→∅),[8.1810]→[8.1810:1844](∅→∅)
  − __PACKAGE__->table("BuildSteps");
  [8.5626]

  [8.5627]
  + __PACKAGE__->table("buildsteps");
• replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 218
  [8.499]→[5.3113:3255](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-12-07 13:48:19

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3FYkqSUfgWmiqZzmX8J4TA
  [8.499]

  [8.10118]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AMjHq4g/fSUv/lZuZOljYg
• replacement in src/lib/Hydra/Schema/Builds.pm at line 30
  [8.7038]→[8.7568:7592](∅→∅)
  − =head1 TABLE: C<Builds>
  [8.7038]

  [8.5294]
  + =head1 TABLE: C<builds>
• replacement in src/lib/Hydra/Schema/Builds.pm at line 34
  [8.7067]→[8.2663:2693](∅→∅),[8.5333]→[8.2663:2693](∅→∅)
  − __PACKAGE__->table("Builds");
  [8.7067]

  [8.7068]
  + __PACKAGE__->table("builds");
• edit in src/lib/Hydra/Schema/Builds.pm at line 43
  [8.7182]

  [8.7196]
  + sequence: 'builds_id_seq'
• replacement in src/lib/Hydra/Schema/Builds.pm at line 204
  [8.5397]→[8.8031:8103](∅→∅)
  − { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  [8.5397]

  [8.2757]
  + {

  + data_type => "integer",

  + is_auto_increment => 1,

  + is_nullable => 0,

  + sequence => "builds_id_seq",

  + },
• replacement in src/lib/Hydra/Schema/Builds.pm at line 553
  [8.3378]→[7.154:296](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07049 @ 2019-08-19 16:12:37

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VjYbAQwv4THW2VfWQ5ajYQ
  [8.3378]

  [8.4481]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H3hs+zEywsUmwTWKfSE8wQ
• replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 30
  [8.645]→[8.11179:11215](∅→∅)
  − =head1 TABLE: C<CachedBazaarInputs>
  [8.645]

  [8.645]
  + =head1 TABLE: C<cachedbazaarinputs>
• replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 34
  [8.700]→[8.700:742](∅→∅)
  − __PACKAGE__->table("CachedBazaarInputs");
  [8.700]

  [8.742]
  + __PACKAGE__->table("cachedbazaarinputs");
• replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 86
  [8.1677]→[8.28416:28558](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zvun8uhxwrr7B8EsqBoCjA
  [8.1677]

  [8.1819]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X8L4C57lMOctdqOKSmfA/g
• replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 30
  [8.181]→[8.11780:11813](∅→∅)
  − =head1 TABLE: C<CachedCVSInputs>
  [8.181]

  [8.10600]
  + =head1 TABLE: C<cachedcvsinputs>
• replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 34
  [8.10607]→[8.219:258](∅→∅),[8.219]→[8.219:258](∅→∅)
  − __PACKAGE__->table("CachedCVSInputs");
  [8.10607]

  [8.10608]
  + __PACKAGE__->table("cachedcvsinputs");
• replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 102
  [8.1055]→[8.28705:28847](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vi1qzjW52Lnsl0JSmGzy0w
  [8.1055]

  [8.1200]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6eQ+i/th+oVZNRiDPd2luA
• replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 30
  [8.1477]→[8.3894:3929](∅→∅),[8.3894]→[8.3894:3929](∅→∅)
  − =head1 TABLE: C<CachedDarcsInputs>
  [8.1477]

  [8.3929]
  + =head1 TABLE: C<cacheddarcsinputs>
• replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 34
  [8.3936]→[8.3936:3977](∅→∅)
  − __PACKAGE__->table("CachedDarcsInputs");
  [8.3936]

  [8.3977]
  + __PACKAGE__->table("cacheddarcsinputs");
• replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 93
  [8.4751]→[8.1601:1743](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-09-20 11:08:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Yl1slt3SAizijgu0KUTn0A
  [8.4751]

  [8.1743]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Buwq42sBXQVfYUy01WMyYw
• replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 30
  [8.1495]→[8.12540:12573](∅→∅)
  − =head1 TABLE: C<CachedGitInputs>
  [8.1495]

  [8.1519]
  + =head1 TABLE: C<cachedgitinputs>
• replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 34
  [8.11404]→[8.1558:1597](∅→∅),[8.1558]→[8.1558:1597](∅→∅)
  − __PACKAGE__->table("CachedGitInputs");
  [8.11404]

  [8.11405]
  + __PACKAGE__->table("cachedgitinputs");
• replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 95
  [8.2415]→[8.28994:29136](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I4hI02FKRMkw76WV/KBocA
  [8.2415]

  [8.2415]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0sdK9uQZpx869oqS5thRLw
• replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 30
  [8.186]→[8.13218:13250](∅→∅)
  − =head1 TABLE: C<CachedHgInputs>
  [8.186]

  [8.230]
  + =head1 TABLE: C<cachedhginputs>
• replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 34
  [8.237]→[8.237:275](∅→∅)
  − __PACKAGE__->table("CachedHgInputs");
  [8.237]

  [8.275]
  + __PACKAGE__->table("cachedhginputs");
• replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 95
  [8.1417]→[8.29283:29425](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qS/eiiZXmpc7KpTHdtaT7g
  [8.1417]

  [8.1559]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dYfjQ0SJG/mBrsZemAW3zw
• replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 30
  [8.12239]→[8.13897:13931](∅→∅)
  − =head1 TABLE: C<CachedPathInputs>
  [8.12239]

  [8.928]
  + =head1 TABLE: C<cachedpathinputs>
• replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 34
  [8.12292]→[8.992:1032](∅→∅),[8.992]→[8.992:1032](∅→∅)
  − __PACKAGE__->table("CachedPathInputs");
  [8.12292]

  [8.12293]
  + __PACKAGE__->table("cachedpathinputs");
• replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 93
  [8.1497]→[8.29572:29714](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:28rja0vR1glJJ15hzVfjsQ
  [8.1497]

  [8.1639]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oV7tbWLNEMC8byKf9UnAlw
• replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 30
  [8.12953]→[8.14581:14621](∅→∅)
  − =head1 TABLE: C<CachedSubversionInputs>
  [8.12953]

  [8.1855]
  + =head1 TABLE: C<cachedsubversioninputs>
• replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 34
  [8.1919]→[8.1919:1965](∅→∅)
  − __PACKAGE__->table("CachedSubversionInputs");
  [8.1881]

  [8.13012]
  + __PACKAGE__->table("cachedsubversioninputs");
• replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 86
  [8.2485]→[8.29861:30003](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3qXfnvkOVj25W94bfhQ65w
  [8.2485]

  [8.2485]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VGt/0HG84eNZr9OIA8jzow
• replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 30
  [8.3458]→[8.3458:3487](∅→∅)
  − =head1 TABLE: C<FailedPaths>
  [8.3458]

  [8.3487]
  + =head1 TABLE: C<failedpaths>
• replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 34
  [8.3494]→[8.3494:3529](∅→∅)
  − __PACKAGE__->table("FailedPaths");
  [8.3494]

  [8.3529]
  + __PACKAGE__->table("failedpaths");
• replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 60
  [8.3783]→[8.3783:3925](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2015-06-10 14:48:16

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WFgjfjH+szE6Ntcicmaflw
  [8.3783]

  [8.3925]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jr3XiGO4lWAzqfATbsMwFw
• replacement in src/lib/Hydra/Schema/Jobs.pm at line 30
  [8.1537]→[8.15174:15196](∅→∅)
  − =head1 TABLE: C<Jobs>
  [8.1537]

  [8.13608]
  + =head1 TABLE: C<jobs>
• replacement in src/lib/Hydra/Schema/Jobs.pm at line 34
  [8.13615]→[8.1575:1603](∅→∅),[8.1575]→[8.1575:1603](∅→∅)
  − __PACKAGE__->table("Jobs");
  [8.13615]

  [8.13616]
  + __PACKAGE__->table("jobs");
• replacement in src/lib/Hydra/Schema/Jobs.pm at line 172
  [8.1556]→[8.6976:7118](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-07-30 16:52:20

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vDAo9bzLca+QWfhOb9OLMg
  [8.1556]

  [8.2756]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sYa6dZNK+stMAnTH0Tmn8A
• replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 30
  [8.627]→[8.627:661](∅→∅)
  − =head1 TABLE: C<JobsetEvalInputs>
  [8.627]

  [8.661]
  + =head1 TABLE: C<jobsetevalinputs>
• replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 34
  [8.668]→[8.668:708](∅→∅)
  − __PACKAGE__->table("JobsetEvalInputs");
  [8.668]

  [8.708]
  + __PACKAGE__->table("jobsetevalinputs");
• replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 169
  [8.2509]→[8.30439:30581](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1Dp8B58leBLh4GK0GPw2zg
  [8.2509]

  [8.38]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/cFQGBLhvpmBO1UJztgIAg
• replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 30
  [8.1515]→[8.16592:16627](∅→∅)
  − =head1 TABLE: C<JobsetEvalMembers>
  [8.1515]

  [8.1515]
  + =head1 TABLE: C<jobsetevalmembers>
• replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 34
  [8.1569]→[8.1569:1610](∅→∅)
  − __PACKAGE__->table("JobsetEvalMembers");
  [8.1569]

  [8.1610]
  + __PACKAGE__->table("jobsetevalmembers");
• replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 113
  [8.17200]→[8.30728:30870](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ccPNQe/QnSjTAC3uGWe8Ng
  [8.17200]

  [8.2915]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T+dJFh/sDO8WsasqYVLRSQ
• replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 30
  [8.222]→[8.17402:17431](∅→∅)
  − =head1 TABLE: C<JobsetEvals>
  [8.222]

  [8.246]
  + =head1 TABLE: C<jobsetevals>
• replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 34
  [8.16047]→[8.3159:3194](∅→∅)
  − __PACKAGE__->table("JobsetEvals");
  [8.16047]

  [8.16048]
  + __PACKAGE__->table("jobsetevals");
• edit in src/lib/Hydra/Schema/JobsetEvals.pm at line 43
  [8.3291]

  [8.3305]
  + sequence: 'jobsetevals_id_seq'
• replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 96
  [8.3653]→[8.17615:17687](∅→∅)
  − { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  [8.3653]

  [8.352]
  + {

  + data_type => "integer",

  + is_auto_increment => 1,

  + is_nullable => 0,

  + sequence => "jobsetevals_id_seq",

  + },
• replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 197
  [8.18354]→[8.31017:31159](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SlEiF8oN6FBK262uSiMKiw
  [8.18354]

  [8.1674]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4ZaT8Z1tmCCt6k4ein0MNg
• replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 30
  [8.14946]→[8.18560:18593](∅→∅)
  − =head1 TABLE: C<JobsetInputAlts>
  [8.14946]

  [8.14946]
  + =head1 TABLE: C<jobsetinputalts>
• replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 34
  [8.965]→[8.4758:4797](∅→∅)
  − __PACKAGE__->table("JobsetInputAlts");
  [8.927]

  [8.14998]
  + __PACKAGE__->table("jobsetinputalts");
• replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 124
  [8.1974]→[8.31306:31448](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UUO37lIuEYm0GiR92m/fyA
  [8.1974]

  [8.1974]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nh8dQDL9FtgzXcwjDufDMQ
• replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 30
  [8.16931]→[8.19458:19488](∅→∅)
  − =head1 TABLE: C<JobsetInputs>
  [8.16931]

  [8.663]
  + =head1 TABLE: C<jobsetinputs>
• replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 34
  [8.727]→[8.4941:4977](∅→∅)
  − __PACKAGE__->table("JobsetInputs");
  [8.689]

  [8.16979]
  + __PACKAGE__->table("jobsetinputs");
• edit in src/lib/Hydra/Schema/JobsetInputs.pm at line 132
  [8.1680]→[8.1680:1681](∅→∅),[8.1681]→[8.19979:19994](∅→∅),[8.861]→[8.1823:1824](∅→∅),[8.991]→[8.1823:1824](∅→∅),[8.1108]→[8.1823:1824](∅→∅),[8.1143]→[8.1823:1824](∅→∅),[8.1161]→[8.1823:1824](∅→∅),[8.1221]→[8.1823:1824](∅→∅),[8.1366]→[8.1823:1824](∅→∅),[8.1385]→[8.1823:1824](∅→∅),[8.1396]→[8.1823:1824](∅→∅),[8.1429]→[8.1823:1824](∅→∅),[8.1429]→[8.1823:1824](∅→∅),[8.1492]→[8.1823:1824](∅→∅),[8.1506]→[8.1823:1824](∅→∅),[8.1508]→[8.1823:1824](∅→∅),[8.1584]→[8.1823:1824](∅→∅),[8.1612]→[8.1823:1824](∅→∅),[8.1680]→[8.1823:1824](∅→∅),[8.1731]→[8.1823:1824](∅→∅),[8.1731]→[8.1823:1824](∅→∅),[8.1751]→[8.1823:1824](∅→∅),[8.1752]→[8.1823:1824](∅→∅),[8.1773]→[8.1823:1824](∅→∅),[8.1794]→[8.1823:1824](∅→∅),[8.1802]→[8.1823:1824](∅→∅),[8.1867]→[8.1823:1824](∅→∅),[8.1987]→[8.1823:1824](∅→∅),[8.2076]→[8.1823:1824](∅→∅),[8.2092]→[8.1823:1824](∅→∅),[8.2158]→[8.1823:1824](∅→∅),[8.2168]→[8.1823:1824](∅→∅),[8.2229]→[8.1823:1824](∅→∅),[8.2309]→[8.1823:1824](∅→∅),[8.2593]→[8.1823:1824](∅→∅),[8.2676]→[8.1823:1824](∅→∅),[8.2760]→[8.1823:1824](∅→∅),[8.2778]→[8.1823:1824](∅→∅),[8.2827]→[8.1823:1824](∅→∅),[8.2915]→[8.1823:1824](∅→∅),[8.3135]→[8.1823:1824](∅→∅),[8.3168]→[8.1823:1824](∅→∅),[8.3261]→[8.1823:1824](∅→∅),[8.3273]→[8.1823:1824](∅→∅),[8.3377]→[8.1823:1824](∅→∅),[8.4424]→[8.1823:1824](∅→∅),[8.4551]→[8.1823:1824](∅→∅),[8.5120]→[8.1823:1824](∅→∅),[8.7948]→[8.1823:1824](∅→∅),[8.13082]→[8.1823:1824](∅→∅),[8.19994]→[8.1823:1824](∅→∅),[8.1823]→[8.1823:1824](∅→∅),[8.1824]→[8.19995:20010](∅→∅)
  −

  − =head2 jobsets

  −

  − Type: has_many
• edit in src/lib/Hydra/Schema/JobsetInputs.pm at line 133
  [8.20011]→[8.20011:20053](∅→∅)
  − Related object: L<Hydra::Schema::Jobsets>
• replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 134
  [8.20054]→[8.20054:20059](∅→∅)
  − =cut
  [8.20054]

  [8.20059]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5uKwEhDXso4IR1TFmwRxiA
• edit in src/lib/Hydra/Schema/JobsetInputs.pm at line 137
  [8.20060]→[8.20060:20267](∅→∅),[8.20267]→[8.5600:5609](∅→∅),[8.5609]→[8.20273:20277](∅→∅),[8.20273]→[8.20273:20277](∅→∅),[8.17827]→[8.1824:1825](∅→∅),[8.20277]→[8.1824:1825](∅→∅),[8.1824]→[8.1824:1825](∅→∅),[8.1825]→[8.1006:1148](∅→∅),[8.1148]→[8.211:212](∅→∅)
  − __PACKAGE__->has_many(

  − "jobsets",

  − "Hydra::Schema::Jobsets",

  − {

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

  − "foreign.nixexprinput" => "self.name",

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

  − },

  − undef,

  − );

  −

  −

  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-10-08 13:06:15

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+mZZqLjQNwblb/EWW1alLQ

  −
• replacement in src/lib/Hydra/Schema/JobsetRenames.pm at line 30
  [8.1097]→[8.1097:1128](∅→∅)
  − =head1 TABLE: C<JobsetRenames>
  [8.1097]

  [8.1128]
  + =head1 TABLE: C<jobsetrenames>
• replacement in src/lib/Hydra/Schema/JobsetRenames.pm at line 34
  [8.1135]→[8.1135:1172](∅→∅)
  − __PACKAGE__->table("JobsetRenames");
  [8.1135]

  [8.1172]
  + __PACKAGE__->table("jobsetrenames");
• replacement in src/lib/Hydra/Schema/JobsetRenames.pm at line 113
  [8.2307]→[8.2307:2449](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2014-04-23 23:13:51

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SBpKWF9swFc9T1Uc0VFlgA
  [8.2307]

  [8.2449]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eOQbJ2O/p0G1317m3IC/KA
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 30
  [8.17861]→[8.20477:20502](∅→∅)
  − =head1 TABLE: C<Jobsets>
  [8.17861]

  [8.17873]
  + =head1 TABLE: C<jobsets>
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 34
  [8.17904]→[8.5121:5152](∅→∅),[8.2092]→[8.5121:5152](∅→∅)
  − __PACKAGE__->table("Jobsets");
  [8.17904]

  [8.17905]
  + __PACKAGE__->table("jobsets");
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 41
  [8.20523]→[8.17978:17998](∅→∅),[8.17978]→[8.17978:17998](∅→∅)
  − is_foreign_key: 1
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 57
  [8.20586]→[8.18294:18314](∅→∅),[8.18294]→[8.18294:18314](∅→∅)
  − is_foreign_key: 1
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 144
  [8.2159]→[8.20794:20860](∅→∅)
  − { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
  [8.2159]

  [8.2219]
  + { data_type => "text", is_nullable => 0 },
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 150
  [8.2387]→[8.20974:21040](∅→∅)
  − { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
  [8.2387]

  [8.2447]
  + { data_type => "text", is_nullable => 0 },
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 270
  [8.3019]→[8.21932:21952](∅→∅)
  −

  − =head2 jobsetinput
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 271
  [8.19550]→[8.21953:22170](∅→∅),[8.22170]→[8.5783:5861](∅→∅),[8.5861]→[8.22176:22179](∅→∅),[8.22176]→[8.22176:22179](∅→∅),[8.4899]→[8.19575:19576](∅→∅),[8.22179]→[8.19575:19576](∅→∅),[8.19575]→[8.19575:19576](∅→∅)
  − Type: belongs_to

  −

  − Related object: L<Hydra::Schema::JobsetInputs>

  −

  − =cut

  −

  − __PACKAGE__->belongs_to(

  − "jobsetinput",

  − "Hydra::Schema::JobsetInputs",

  − { jobset => "name", name => "nixexprinput", project => "project" },

  − { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },

  − );

  −
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 338
  [8.22628]→[6.4342:4484](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07045 @ 2017-03-09 13:03:05

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ivYvsUyhEeaeI4EmRQ0/QQ
  [8.22628]

  [8.217]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fYKx6VRlNG5XiDZ73Qr6Rw
• replacement in src/lib/Hydra/Schema/NewsItems.pm at line 30
  [8.2517]→[8.22686:22713](∅→∅)
  − =head1 TABLE: C<NewsItems>
  [8.2517]

  [8.2517]
  + =head1 TABLE: C<newsitems>
• replacement in src/lib/Hydra/Schema/NewsItems.pm at line 34
  [8.2563]→[8.2563:2596](∅→∅)
  − __PACKAGE__->table("NewsItems");
  [8.2563]

  [8.2596]
  + __PACKAGE__->table("newsitems");
• edit in src/lib/Hydra/Schema/NewsItems.pm at line 43
  [8.2710]

  [8.2724]
  + sequence: 'newsitems_id_seq'
• replacement in src/lib/Hydra/Schema/NewsItems.pm at line 65
  [8.3058]→[8.22804:22876](∅→∅)
  − { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  [8.3058]

  [8.3192]
  + {

  + data_type => "integer",

  + is_auto_increment => 1,

  + is_nullable => 0,

  + sequence => "newsitems_id_seq",

  + },
• replacement in src/lib/Hydra/Schema/NewsItems.pm at line 109
  [8.3800]→[8.32173:32315](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3CRNsvd+YnZp9c80tuZREQ
  [8.3800]

  [8.4112]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r6vX8VG/+NQraIVKFgHzxQ
• replacement in src/lib/Hydra/Schema/NrBuilds.pm at line 30
  [8.581]→[8.581:607](∅→∅)
  − =head1 TABLE: C<NrBuilds>
  [8.581]

  [8.607]
  + =head1 TABLE: C<nrbuilds>
• replacement in src/lib/Hydra/Schema/NrBuilds.pm at line 34
  [8.614]→[8.614:646](∅→∅)
  − __PACKAGE__->table("NrBuilds");
  [8.614]

  [8.646]
  + __PACKAGE__->table("nrbuilds");
• replacement in src/lib/Hydra/Schema/NrBuilds.pm at line 70
  [8.1021]→[8.1021:1163](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-08-12 17:59:18

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CK8eJGC803nGj0wnete9xg
  [8.1021]

  [8.1163]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qv1I8Wu7KXHAs+pyBn2ofA
• replacement in src/lib/Hydra/Schema/ProjectMembers.pm at line 30
  [8.480]→[8.23304:23336](∅→∅)
  − =head1 TABLE: C<ProjectMembers>
  [8.480]

  [8.492]
  + =head1 TABLE: C<projectmembers>
• replacement in src/lib/Hydra/Schema/ProjectMembers.pm at line 34
  [8.530]→[8.530:568](∅→∅)
  − __PACKAGE__->table("ProjectMembers");
  [8.530]

  [8.568]
  + __PACKAGE__->table("projectmembers");
• replacement in src/lib/Hydra/Schema/ProjectMembers.pm at line 106
  [8.1559]→[8.32462:32604](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:imPoiaitrTbX0vVNlF6dPA
  [8.1559]

  [8.1701]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e/hYmoNmcEUoGhRqtwdyQw
• replacement in src/lib/Hydra/Schema/Projects.pm at line 30
  [8.19840]→[8.23799:23825](∅→∅)
  − =head1 TABLE: C<Projects>
  [8.19840]

  [8.19864]
  + =head1 TABLE: C<projects>
• replacement in src/lib/Hydra/Schema/Projects.pm at line 34
  [8.19871]→[8.5296:5328](∅→∅),[8.3399]→[8.5296:5328](∅→∅)
  − __PACKAGE__->table("Projects");
  [8.19871]

  [8.19872]
  + __PACKAGE__->table("projects");
• replacement in src/lib/Hydra/Schema/Projects.pm at line 306
  [8.7308]→[3.3333:3475](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-03-11 10:39:17

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1ats3brIVhRTWLToIYSoaQ
  [8.7308]

  [8.171]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pcF/8351zyo9VL6N5eimdQ
• replacement in src/lib/Hydra/Schema/ReleaseMembers.pm at line 30
  [8.21505]→[8.25775:25807](∅→∅)
  − =head1 TABLE: C<ReleaseMembers>
  [8.21505]

  [8.21549]
  + =head1 TABLE: C<releasemembers>
• replacement in src/lib/Hydra/Schema/ReleaseMembers.pm at line 34
  [8.1978]→[8.1978:2016](∅→∅)
  − __PACKAGE__->table("ReleaseMembers");
  [8.1940]

  [8.21556]
  + __PACKAGE__->table("releasemembers");
• replacement in src/lib/Hydra/Schema/ReleaseMembers.pm at line 138
  [8.3083]→[8.33040:33182](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7M7WPlGQT6rNHKJ+82/KSA
  [8.3083]

  [8.22596]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k4z2YeB4gRAeAP6hmR93sQ
• replacement in src/lib/Hydra/Schema/Releases.pm at line 30
  [8.3282]→[8.26614:26640](∅→∅)
  − =head1 TABLE: C<Releases>
  [8.3282]

  [8.22630]
  + =head1 TABLE: C<releases>
• replacement in src/lib/Hydra/Schema/Releases.pm at line 34
  [8.22675]→[8.3345:3377](∅→∅),[8.3345]→[8.3345:3377](∅→∅)
  − __PACKAGE__->table("Releases");
  [8.22675]

  [8.22676]
  + __PACKAGE__->table("releases");
• replacement in src/lib/Hydra/Schema/Releases.pm at line 122
  [8.4209]→[8.33329:33471](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qISBiwvboB8dIdinaE45mg
  [8.4209]

  [8.4355]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:b4M/tHOhsy234tgTf+wqjQ
• replacement in src/lib/Hydra/Schema/SchemaVersion.pm at line 30
  [8.27413]→[8.27413:27444](∅→∅)
  − =head1 TABLE: C<SchemaVersion>
  [8.27413]

  [8.27444]
  + =head1 TABLE: C<schemaversion>
• replacement in src/lib/Hydra/Schema/SchemaVersion.pm at line 34
  [8.27451]→[8.27451:27488](∅→∅)
  − __PACKAGE__->table("SchemaVersion");
  [8.27451]

  [8.27488]
  + __PACKAGE__->table("schemaversion");
• replacement in src/lib/Hydra/Schema/SchemaVersion.pm at line 48
  [8.27814]→[8.33618:33760](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:08/7gbEQp1TqBiWFJXVY0w
  [8.27814]

  [8.27956]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2wy4FsRYVVo2RTCWXcmgvg
• replacement in src/lib/Hydra/Schema/StarredJobs.pm at line 30
  [8.2851]→[8.2851:2880](∅→∅)
  − =head1 TABLE: C<StarredJobs>
  [8.2851]

  [8.2880]
  + =head1 TABLE: C<starredjobs>
• replacement in src/lib/Hydra/Schema/StarredJobs.pm at line 34
  [8.2887]→[8.2887:2922](∅→∅)
  − __PACKAGE__->table("StarredJobs");
  [8.2887]

  [8.2922]
  + __PACKAGE__->table("starredjobs");
• replacement in src/lib/Hydra/Schema/StarredJobs.pm at line 156
  [8.4849]→[8.4849:4991](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-10-14 15:46:29

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:naj5aKWuw8hLE6klmvW9Eg
  [8.4849]

  [8.4991]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fw4FfzmOhzDk0ZoSuNr2ww
• replacement in src/lib/Hydra/Schema/SystemStatus.pm at line 30
  [8.887]→[8.887:917](∅→∅)
  − =head1 TABLE: C<SystemStatus>
  [8.887]

  [8.917]
  + =head1 TABLE: C<systemstatus>
• replacement in src/lib/Hydra/Schema/SystemStatus.pm at line 34
  [8.924]→[8.924:960](∅→∅)
  − __PACKAGE__->table("SystemStatus");
  [8.924]

  [8.960]
  + __PACKAGE__->table("systemstatus");
• replacement in src/lib/Hydra/Schema/SystemStatus.pm at line 70
  [8.1331]→[8.1331:1473](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-07-30 16:01:22

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JCYi4+HwM22iucdFkhBjMg
  [8.1331]

  [8.1473]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GeXpTVktMXjHENa/P3qOxw
• replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 30
  [8.409]→[8.409:438](∅→∅)
  − =head1 TABLE: C<SystemTypes>
  [8.409]

  [8.438]
  + =head1 TABLE: C<systemtypes>
• replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 34
  [8.445]→[8.445:480](∅→∅)
  − __PACKAGE__->table("SystemTypes");
  [8.445]

  [8.480]
  + __PACKAGE__->table("systemtypes");
• replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 71
  [8.918]→[8.33907:34049](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8cC34cEw9T3+x+7uRs4KHQ
  [8.918]

  [8.1060]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fYeKQQSS5J8rjO3t+Hbz0g
• replacement in src/lib/Hydra/Schema/UriRevMapper.pm at line 30
  [8.184]→[8.28620:28650](∅→∅)
  − =head1 TABLE: C<UriRevMapper>
  [8.184]

  [8.226]
  + =head1 TABLE: C<urirevmapper>
• replacement in src/lib/Hydra/Schema/UriRevMapper.pm at line 34
  [8.233]→[8.233:269](∅→∅)
  − __PACKAGE__->table("UriRevMapper");
  [8.233]

  [8.269]
  + __PACKAGE__->table("urirevmapper");
• replacement in src/lib/Hydra/Schema/UriRevMapper.pm at line 70
  [8.768]→[8.34196:34338](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G2GAF/Rb7cRkRegH94LwIA
  [8.768]

  [8.910]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FOg2/BVJK3yg8MAYMrqZOQ
• replacement in src/lib/Hydra/Schema/UserRoles.pm at line 30
  [8.23981]→[8.29051:29078](∅→∅)
  − =head1 TABLE: C<UserRoles>
  [8.23981]

  [8.24020]
  + =head1 TABLE: C<userroles>
• replacement in src/lib/Hydra/Schema/UserRoles.pm at line 34
  [8.3389]→[8.3389:3422](∅→∅)
  − __PACKAGE__->table("UserRoles");
  [8.3351]

  [8.24027]
  + __PACKAGE__->table("userroles");
• replacement in src/lib/Hydra/Schema/UserRoles.pm at line 90
  [8.24455]→[8.34485:34627](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aS+ivlFpndqIv8U578zz9A
  [8.24455]

  [8.24597]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LUw2PDFvUHs0E0UZ3oHFxw
• replacement in src/lib/Hydra/Schema/Users.pm at line 30
  [8.5185]→[8.29514:29537](∅→∅)
  − =head1 TABLE: C<Users>
  [8.5185]

  [8.5185]
  + =head1 TABLE: C<users>
• replacement in src/lib/Hydra/Schema/Users.pm at line 34
  [8.5227]→[8.5227:5256](∅→∅)
  − __PACKAGE__->table("Users");
  [8.5227]

  [8.5256]
  + __PACKAGE__->table("users");
• replacement in src/lib/Hydra/Schema/Users.pm at line 195
  [8.8787]→[4.1130:1272](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-05-27 11:32:14

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Az1+V+ztJoWUt50NLQR3xg
  [8.8787]

  [8.1838]
  + # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4/WZ95asbnGmK+nEHb4sLQ
• edit in src/sql/Makefile.am at line 5
  [8.69]→[8.69:93](∅→∅)
  − hydra-sqlite.sql \
• replacement in src/sql/Makefile.am at line 12
  [8.3555]→[8.3555:3735](∅→∅),[8.3735]→[8.1658:1753](∅→∅)
  − hydra-sqlite.sql: hydra.sql

  − cpp -P -E -traditional-cpp -DSQLITE hydra.sql > $@ || rm -f $@

  −

  − update-dbix: hydra-sqlite.sql

  − rm -f tmp.sqlite

  − sqlite3 tmp.sqlite < hydra-sqlite.sql

  − perl -I ../lib -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:../lib update-dbix.pl
  [8.3555]
  + update-dbix: hydra-postgresql.sql

  + ./update-dbix-harness.sh
• file addition: update-dbix-harness.sh (---r------)
  [124.3004]
  + #!/usr/bin/env bash

  +

  + readonly scratch=$(mktemp -d -t tmp.XXXXXXXXXX)

  +

  + readonly socket=$scratch/socket

  + readonly data=$scratch/data

  + readonly dbname=hydra-update-dbix

  +

  + function finish {

  + set +e

  + pg_ctl -D "$data" \

  + -o "-F -h '' -k \"$socket\"" \

  + -w stop -m immediate

  +

  + if [ -f "$data/postmaster.pid" ]; then

  + pg_ctl -D "$data" \

  + -o "-F -h '' -k \"$socket\"" \

  + -w kill TERM "$(cat "$data/postmaster.pid")"

  + fi

  +

  + rm -rf "$scratch"

  + }

  + trap finish EXIT

  +

  + set -e

  +

  + mkdir -p "$socket"

  + initdb -D "$data"

  +

  + pg_ctl -D "$data" \

  + -o "-F -h '' -k \"${socket}\"" \

  + -w start

  +

  + createdb -h "$socket" "$dbname"

  +

  + psql -h "$socket" "$dbname" -f ./hydra-postgresql.sql

  +

  + perl -I ../lib \

  + -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:../lib \

  + update-dbix.pl "dbi:Pg:dbname=$dbname;host=$socket"
• edit in src/sql/update-dbix.pl at line 1
  [8.1755]

  [8.1756]
  + use Cwd;

  +

  + die "$0: dbi connection string required \n" if scalar @ARGV != 1;

  +
• replacement in src/sql/update-dbix.pl at line 8
  [8.1845]→[8.1845:1886](∅→∅)
  − moniker_map => sub { return "$_"; },
  [8.1845]

  [8.1886]
  + moniker_map => {

  + "aggregateconstituents" => "AggregateConstituents",

  + "buildinputs" => "BuildInputs",

  + "buildmetrics" => "BuildMetrics",

  + "buildoutputs" => "BuildOutputs",

  + "buildproducts" => "BuildProducts",

  + "builds" => "Builds",

  + "buildstepoutputs" => "BuildStepOutputs",

  + "buildsteps" => "BuildSteps",

  + "cachedbazaarinputs" => "CachedBazaarInputs",

  + "cachedcvsinputs" => "CachedCVSInputs",

  + "cacheddarcsinputs" => "CachedDarcsInputs",

  + "cachedgitinputs" => "CachedGitInputs",

  + "cachedhginputs" => "CachedHgInputs",

  + "cachedpathinputs" => "CachedPathInputs",

  + "cachedsubversioninputs" => "CachedSubversionInputs",

  + "failedpaths" => "FailedPaths",

  + "jobs" => "Jobs",

  + "jobsetevalinputs" => "JobsetEvalInputs",

  + "jobsetevalmembers" => "JobsetEvalMembers",

  + "jobsetevals" => "JobsetEvals",

  + "jobsetinputalts" => "JobsetInputAlts",

  + "jobsetinputs" => "JobsetInputs",

  + "jobsetrenames" => "JobsetRenames",

  + "jobsets" => "Jobsets",

  + "newsitems" => "NewsItems",

  + "nrbuilds" => "NrBuilds",

  + "projectmembers" => "ProjectMembers",

  + "projects" => "Projects",

  + "releasemembers" => "ReleaseMembers",

  + "releases" => "Releases",

  + "schemaversion" => "SchemaVersion",

  + "starredjobs" => "StarredJobs",

  + "systemstatus" => "SystemStatus",

  + "systemtypes" => "SystemTypes",

  + "urirevmapper" => "UriRevMapper",

  + "userroles" => "UserRoles",

  + "users" => "Users",

  + } , #sub { return "$_"; },
• replacement in src/sql/update-dbix.pl at line 49
  [8.1995]→[8.1995:2027](∅→∅)
  − }, ["dbi:SQLite:tmp.sqlite"]);

  −
  [8.1995]
  + }, [$ARGV[0]]);