grahamc/hydra - Change SIDK2E7VTH36ETTT7VQWKUXIJE3GQCH4EA33TJG3S4ZTOPTKYCNAC

Jobs: add a nullable jobset_id foreign key to Jobsets.

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

Created by Graham Christensen on February 5, 2020

SIDK2E7VTH36ETTT7VQWKUXIJE3GQCH4EA33TJG3S4ZTOPTKYCNAC

Dependencies

In channels

main

upstream

Change contents

Insertion in src/lib/Hydra/Schema/Jobs.pm at line 49 [4.1454]

[3.13837]

[3.13851]


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

Insertion in src/lib/Hydra/Schema/Jobs.pm at line 68 [4.1454]

[5.15510]

[4.1774]

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

Insertion in src/lib/Hydra/Schema/Jobs.pm at line 140 [4.1454]

[6.1352]

  "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/Jobs.pm at line 200 [4.1454]

B:BD[7.1556] → [8.3858:4000]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sYa6dZNK+stMAnTH0Tmn8A

[7.1556]

[4.2756]

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

Insertion in src/lib/Hydra/Schema/Jobsets.pm at line 277 [10.1960]
[9.2717]
[3.19391]
```
=head2 jobs_jobset_ids
Type: has_many
```

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 282 [10.1960]

B:BD[3.19392] → [3.19392:19404]

=head2 jobs

[3.19392]

[3.19404]

Related object: L<Hydra::Schema::Jobs>
=cut
__PACKAGE__->has_many(
  "jobs_jobset_ids",
  "Hydra::Schema::Jobs",
  { "foreign.jobset_id" => "self.id" },
  undef,
);
=head2 jobs_project_jobsets

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 302 [10.1960]
B:BD[9.2740] → [9.2740:2750]
```
  "jobs",
```
[9.2740]
[9.2750]
```
  "jobs_project_jobsets",
```

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 396 [10.1960]

B:BD[5.22628] → [2.420:562]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:25:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1CMOaLf9fYRdJBlYiivmxA

[5.22628]

[2.562]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:26:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DH1jX0smo2rFvyr4V+qJcw
=head2 jobs
Type: has_many
Related object: L<Hydra::Schema::Jobs>
=cut
__PACKAGE__->has_many(
  "jobs",
  "Hydra::Schema::Jobs",
  {
    "foreign.jobset"  => "self.name",
    "foreign.project" => "self.project",
  },
  undef,
);

Insertion in src/sql/hydra.sql at line 149 [11.1]
[6.6902]
[6.6902]
```
    jobset_id     integer null,
```

Insertion in src/sql/hydra.sql at line 153 [11.1]

[6.7316]

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

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

[12.3004]

-- Add the jobset_id columns to the Jobs 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 Jobs
  ADD COLUMN jobset_id integer NULL,
  ADD FOREIGN KEY (jobset_id)
      REFERENCES Jobsets(id)
      ON DELETE CASCADE;