grahamc/hydra2 - Change SJPEC375K7K4PJRGHLFKAOXX5FFAJCGNVIARROGOR3RISTZBYBDAC

Builds: add a nullable jobset_id foreign key to Jobsets.

Also, adds an explicitly named "builds" accessor to the Jobsets Schema object, which uses the project/jobset name.

Created by Graham Christensen on February 5, 2020

SJPEC375K7K4PJRGHLFKAOXX5FFAJCGNVIARROGOR3RISTZBYBDAC

Dependencies

In channels

main

Change contents

Insertion in src/lib/Hydra/Schema/Builds.pm at line 66 [5.5202]

[4.7586]

[4.7600]


=head2 jobset_id
  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

Insertion in src/lib/Hydra/Schema/Builds.pm at line 224 [5.5202]

[6.8335]

[7.1331]

  "jobset_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },

Insertion in src/lib/Hydra/Schema/Builds.pm at line 467 [5.5202]

[6.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 [5.5202]

B:BD[8.3378] → [9.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

[8.3378]

[10.4481]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:32:28
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RvrINOAowDcde8Nd9VD6rQ

Insertion in src/lib/Hydra/Schema/Jobsets.pm at line 259 [12.1960]
[11.7385]
[4.19217]
```
=head2 builds_jobset_ids
Type: has_many
```

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 264 [12.1960]

B:BD[4.19218] → [6.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 [12.1960]
B:BD[13.2575] → [6.21754:21766]
```
  "builds",
```
[13.2575]
[6.21766]
```
  "builds_project_jobsets",
```

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 411 [12.1960]

B:BD[6.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

[6.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

Insertion in src/lib/Hydra/Schema/Jobsets.pm at line 417 [12.1960]

[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,
);

Insertion in src/sql/hydra.sql at line 173 [14.1]
[7.5820]
[7.5820]
```
    jobset_id     integer null,
```

Insertion in src/sql/hydra.sql at line 240 [14.1]

[15.143]

[2.1531]

    foreign key (jobset_id) references Jobsets(id) on delete cascade,

File addition: upgrade-61.sql (----------)

[16.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;