sequence fix for postgresql

Dependencies

• [2] SJLEZFC4 check getHydraPath in stead of Envvar HYDRA_DBI directly
• [3] L2E6EVE2 * Merged the Build and Job tables.
• [4] SJN2QPWH * Big speed-up of the job status page and the channel generation (such
• [5] 7PYQLDQL Added sequences for auto increment primary key columns (for PostgreSQL)
• [6] PHX2HIVG * Store info about the build inputs in the build record.
• [*] J5UVLXOK * Start of a basic Catalyst web interface.

Change contents

• edit in src/lib/Hydra/Schema/BuildInputs.pm at line 40
  [2.25]→[2.25:61](∅→∅),[2.61]→[3.39:83](∅→∅),[3.39]→[3.39:83](∅→∅)
  − if (getHydraDBPath =~ m/^dbi:Pg/) {

  − __PACKAGE__->sequence('builds_id_seq');

  − }
• edit in src/lib/Hydra/Schema/BuildInputs.pm at line 44
  [3.925]

  [3.925]
  + sub addSequence {

  + my $hydradbi = getHydraDBPath ;

  + if ($hydradbi =~ m/^dbi:Pg/) {

  + __PACKAGE__->sequence('builds_id_seq');

  + }

  + }
• edit in src/lib/Hydra/Schema/BuildInputs.pm at line 51
  [3.926]

  [3.1144]
  + addSequence ;

  +
• replacement in src/lib/Hydra/Schema/Builds.pm at line 107
  [3.2196]→[2.88:123](∅→∅),[2.123]→[3.123:165](∅→∅),[3.123]→[3.123:165](∅→∅)
  − if (getHydraPath =~ m/^dbi:Pg/) {

  − __PACKAGE__->sequence('builds_id_seq');
  [3.2196]

  [3.165]
  + sub addSequence {

  + my $hydradbi = getHydraDBPath ;

  + if ($hydradbi =~ m/^dbi:Pg/) {

  + __PACKAGE__->sequence('builds_id_seq');

  + }
• edit in src/lib/Hydra/Schema/Builds.pm at line 128
  [3.3031]

  [3.3770]
  +

  + addSequence;