hydra: make nr of build to keep configurable per jobset

Dependencies

• [2] HLYVEJX7 * Keep the 3 most recent builds for every platform for every job.
• [3] QTFVCDIF added hide feature for project/jobset
• [4] E2TOU3L6 * More indices.
• [5] JTRG7RDQ add support for git as jobinput
• [6] 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.
• [7] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
• [8] O25D52TA initial support for mercurial
• [9] 2I2ZX6JB * Make the "latest succeeded" query (used by the "latest" channel)
• [10] X27GNHDV * Basic job info in the database.
• [11] RSEGBU6C Hydra/20: Jobset clone feature
• [12] NEWDDAOF * Allow users to change the value of a build's "keep" flag, which
• [13] RFE6T5LG * Store jobset evaluations in the database explicitly. This includes
• [14] 34DPX2OR * Create some more indices on tables that have a foreign key reference
• [15] JJT5QG3K remove revision from cached cvs inputs, and added missing files
• [16] ODNCGFQ5 * Improved the navigation bar: don't include all projects (since that
• [17] ZI535LI6 * hydra: 'new' UI for project/jobset/job/build
• [18] FYO6NECE hydra
• [19] 6QRHXIM3 * Speed up the jobset index page. Especially the query to get the
• [20] IN272KZW * Automatically keep all builds in the latest successful release in
• [*] 3HZY24CX * Make jobsets viewable under
• [*] WZ3AEJ67 * hydra_update_gc_roots.pl registers build outputs that should be kept
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] KN3VYE5P * Cleaned up the foreign key constraints.

Change contents

• edit in src/lib/Hydra/Controller/Jobset.pm at line 234
  [4.151]

  [4.2272]
  + , keepnr => trim($c->request->params->{keepnr})
• edit in src/lib/Hydra/Schema/CachedGitInputs.pm at line 39
  [4.11632]→[4.11632:11819](∅→∅)
  − default_value: undef

  − is_nullable: 0

  − size: undef

  −

  − =head2 timestamp

  −

  − data_type: integer

  − default_value: undef

  − is_nullable: 0

  − size: undef

  −

  − =head2 lastseen

  −

  − data_type: integer
• edit in src/lib/Hydra/Schema/CachedGitInputs.pm at line 77
  [4.1661]→[4.1661:1902](∅→∅)
  − default_value => undef,

  − is_nullable => 0,

  − size => undef,

  − },

  − "timestamp",

  − {

  − data_type => "integer",

  − default_value => undef,

  − is_nullable => 0,

  − size => undef,

  − },

  − "lastseen",

  − {

  − data_type => "integer",
• replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 99
  [4.2415]→[4.12064:12206](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.05003 @ 2010-02-25 10:29:41

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CoeyzZHUEPo7/VpIpLD+Pw
  [4.2415]

  [4.2415]
  + # Created by DBIx::Class::Schema::Loader v0.05000 @ 2010-08-10 08:24:15

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4eYbLtiy5X3yegndBRFtSg
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 108
  [4.18997]

  [4.18997]
  +

  + =head2 keepnr
• edit in src/lib/Hydra/Schema/Jobsets.pm at line 111
  [4.18998]

  [4.18998]
  + data_type: integer

  + default_value: 3

  + is_nullable: 0

  + size: undef

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

  [4.2524]
  + "keepnr",

  + { data_type => "integer", default_value => 3, is_nullable => 0, size => undef },
• replacement in src/lib/Hydra/Schema/Jobsets.pm at line 292
  [4.3196]→[3.2313:2455](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.05000 @ 2010-06-04 16:32:43

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aQ+7TLIXnNDjjulPNqLq7A
  [4.3196]

  [4.3135]
  + # Created by DBIx::Class::Schema::Loader v0.05000 @ 2010-08-10 08:24:15

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:b/GSJQxUcjCP4fn3peJVMg
• replacement in src/root/jobset.tt at line 192
  [4.23395]→[4.23395:23561](∅→∅)
  − <tr>

  − <th>Email override:</th>

  − <td>

  − [% INCLUDE maybeEditString param="emailoverride" value=jobset.emailoverride %]

  − </td>

  − </tr>
  [4.23395]

  [4.23561]
  + <tr>

  + <th>Email override:</th>

  + <td>

  + [% INCLUDE maybeEditString param="emailoverride" value=jobset.emailoverride %]

  + </td>

  + </tr>

  + <tr>

  + <th>Number of builds to keep:</th>

  + <td>

  + [% INCLUDE maybeEditString param="keepnr" value=jobset.keepnr %]

  + </td>

  + </tr>
• replacement in src/script/hydra_update_gc_roots.pl at line 50
  [2.195]→[2.195:196](∅→∅)
  −
  [2.195]

  [2.196]
  + my $keepnr = $job->jobset->keepnr ;
• replacement in src/script/hydra_update_gc_roots.pl at line 59
  [2.490]→[2.490:554](∅→∅)
  − , rows => 3 # !!! should make this configurable
  [2.490]

  [2.554]
  + , rows => $keepnr
• edit in src/sql/hydra.sql at line 54
  [4.5168]

  [25.5479]
  + keepnr integer not null default 3,
• edit in src/sql/hydra.sql at line 508
  [4.244]→[4.244:331](∅→∅)
  − create index IndexCachedGitInputsOnLastSeen on CachedGitInputs(uri, branch, lastSeen);