grahamc/hydra2 - Change KJWLTWD3HSM72JMJJBGG6SCPSN5TBEB7ZWWVYQ6MXVAJZ4PJDATAC

builds: drop project, jobset columns

Indexes were haphazardly dropped.

Created by Graham Christensen on January 8, 2022

KJWLTWD3HSM72JMJJBGG6SCPSN5TBEB7ZWWVYQ6MXVAJZ4PJDATAC

Dependencies

In channels

main

Change contents

Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 54 [6.5202]
B:BD[5.7383] → [5.7383:7399]
```
=head2 project
```
Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 55 [6.5202]
B:BD[5.7400] → [7.7665:7685]
∅:D[7.7685] → [5.7441:7478]
B:BD[5.7441] → [5.7441:7478]
B:BD[5.7492] → [5.7492:7508]
B:BD[5.7508] → [7.7686:7706]
∅:D[7.7706] → [5.7549:7586]
B:BD[5.7549] → [5.7549:7586]
B:BD[5.7586] → [8.0:1]
```
  data_type: 'text'
  is_foreign_key: 1
  is_nullable: 0
=head2 jobset
  data_type: 'text'
  is_foreign_key: 1
  is_nullable: 0
```
Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 197 [6.5202]
∅:D[9.7465] → [10.286:299]
∅:D[7.8201] → [10.286:299]
B:BD[6.5538] → [10.286:299]
B:BD[10.299] → [7.8202:8268]
∅:D[9.7594] → [10.359:371]
∅:D[7.8268] → [10.359:371]
B:BD[10.359] → [10.359:371]
B:BD[10.371] → [7.8269:8335]
```
  "project",
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
  "jobset",
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
```
Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 424 [6.5202]
∅:D[11.164] → [8.346:398]
B:BD[8.346] → [8.346:398]
B:BD[8.398] → [12.4352:4402]
∅:D[12.4402] → [8.440:499]
B:BD[8.440] → [8.440:499]
B:BD[8.499] → [12.4403:4439]
∅:D[12.4439] → [7.10464:10510]
B:BD[7.10464] → [7.10464:10510]
B:BD[7.10510] → [13.3154:3230]
```
);
=head2 jobset_project_jobset
Type: belongs_to
Related object: L<Hydra::Schema::Result::Jobsets>
=cut
__PACKAGE__->belongs_to(
  "jobset_project_jobset",
  "Hydra::Schema::Result::Jobsets",
  { name => "jobset", project => "project" },
  { is_deferrable => 0, on_delete => "NO ACTION", on_update => "CASCADE" },
```
Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 456 [6.5202]
B:BD[5.9773] → [7.10665:10680]
∅:D[7.10680] → [5.9795:9796]
B:BD[5.9795] → [5.9795:9796]
B:BD[5.9796] → [7.10681:10698]
∅:D[7.10698] → [5.9811:9812]
B:BD[5.9811] → [5.9811:9812]
B:BD[5.9812] → [12.4654:4705]
∅:D[12.4705] → [5.9861:9868]
∅:D[7.10742] → [5.9861:9868]
B:BD[5.9861] → [5.9861:9868]
B:BD[5.9868] → [13.3251:3289]
B:BD[13.3289] → [12.4706:4743]
∅:D[12.4743] → [13.3318:3422]
B:BD[13.3318] → [13.3318:3422]
B:BD[13.3422] → [4.0:1]
```
=head2 project
Type: belongs_to
Related object: L<Hydra::Schema::Result::Projects>
=cut
__PACKAGE__->belongs_to(
  "project",
  "Hydra::Schema::Result::Projects",
  { name => "project" },
  { is_deferrable => 0, on_delete => "NO ACTION", on_update => "CASCADE" },
);
```

Replacement in src/lib/Hydra/Schema/Result/Builds.pm at line 500 [6.5202]

B:BD[14.3378] → [4.243:385]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-11-17 12:42:34
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ylttv/NTMDcSZumBXRCOCw

[14.3378]

[15.4481]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-01-10 09:43:38
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DQF8KRinnf0imJOP+lvH9Q

Replacement in src/lib/Hydra/Schema/Result/Jobsets.pm at line 260 [10.1960]
B:BD[8.644] → [8.644:669]
```
=head2 builds_jobset_ids
```
[8.644]
[8.669]
```
=head2 builds
```
Replacement in src/lib/Hydra/Schema/Result/Jobsets.pm at line 269 [10.1960]
B:BD[8.757] → [8.757:780]
```
  "builds_jobset_ids",
```
[8.757]
[12.10766]
```
  "builds",
```
Deletion in src/lib/Hydra/Schema/Result/Jobsets.pm at line 272 [10.1960]
B:BD[8.847] → [8.847:890]
∅:D[8.890] → [5.19235:19236]
∅:D[7.21711] → [5.19235:19236]
B:BD[5.19235] → [5.19235:19236]
B:BD[5.19320] → [5.19320:19336]
B:BD[5.19336] → [12.10802:10851]
∅:D[12.10851] → [5.19383:19390]
∅:D[7.21753] → [5.19383:19390]
B:BD[5.19383] → [5.19383:19390]
∅:D[5.19390] → [16.2552:2575]
B:BD[16.2552] → [16.2552:2575]
B:BD[16.2575] → [8.891:919]
B:BD[8.919] → [12.10852:10887]
∅:D[12.10887] → [16.2626:2714]
∅:D[7.21793] → [16.2626:2714]
B:BD[16.2626] → [16.2626:2714]
```
  undef,
);
=head2 builds_project_jobsets
Type: has_many
Related object: L<Hydra::Schema::Result::Builds>
=cut
__PACKAGE__->has_many(
  "builds_project_jobsets",
  "Hydra::Schema::Result::Builds",
  {
    "foreign.jobset"  => "self.name",
    "foreign.project" => "self.project",
  },
```

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

B:BD[7.22628] → [12.11368:11510]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-08-26 12:02:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iI44C3BFTo6IsS1tBwWYsg

[7.22628]

[8.1062]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-01-08 22:24:10
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cQOnMitrWGMoJX6kZGNW+w

Deletion in src/lib/Hydra/Schema/Result/Projects.pm at line 144 [10.3266]
B:BD[17.7747] → [17.7747:7748]
∅:D[17.7748] → [7.24479:24493]
B:BD[18.4155] → [7.24479:24493]
∅:D[7.24493] → [18.4177:4194]
B:BD[18.4177] → [18.4177:4194]
B:BD[18.4194] → [12.12843:12892]
```
=head2 builds
Type: has_many
Related object: L<Hydra::Schema::Result::Builds>
```
Deletion in src/lib/Hydra/Schema/Result/Projects.pm at line 145 [10.3266]
B:BD[18.4244] → [18.4244:4273]
B:BD[18.4273] → [7.24536:24548]
B:BD[7.24548] → [12.12893:12928]
∅:D[12.12928] → [18.4328:4368]
∅:D[7.24575] → [18.4328:4368]
B:BD[18.4328] → [18.4328:4368]
B:BD[18.4368] → [13.6885:6894]
∅:D[13.6894] → [18.4368:4371]
∅:D[7.24582] → [18.4368:4371]
B:BD[18.4368] → [18.4368:4371]
∅:D[7.24745] → [5.20792:20793]
B:BD[5.20792] → [5.20792:20793]
```
=cut
__PACKAGE__->has_many(
  "builds",
  "Hydra::Schema::Result::Builds",
  { "foreign.project" => "self.name" },
  undef,
);
```

Replacement in src/lib/Hydra/Schema/Result/Projects.pm at line 231 [10.3266]

B:BD[13.7308] → [12.13399:13541]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-08-26 12:02:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nKVZ8ZNCZQQ52zbpDAaoQQ

[13.7308]

[19.0]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-01-08 22:24:10
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r/wbX3FAm5/OFrrwOQL5fA

Deletion in src/sql/hydra.sql at line 165 [21.1]
B:BD[10.4250] → [20.5754:5820]
```
    project       text not null,
    jobset        text not null,
```

Replacement in src/sql/hydra.sql at line 225 [21.1]

B:BD[22.143] → [8.1340:1410]

∅:D[8.1410] → [23.1531:1602]

B:BD[22.143] → [23.1531:1602]

B:BD[23.1602] → [24.6100:6186]

    foreign key (jobset_id) references Jobsets(id) on delete cascade,
    foreign key (project) references Projects(name) on update cascade,
    foreign key (project, jobset) references Jobsets(project, name) on update cascade

[22.143]

[25.2526]

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

Deletion in src/sql/hydra.sql at line 671 [21.1]

B:BD[26.372] → [26.372:576]

create index IndexBuildsOnJobsetIsCurrent on Builds(project, jobset, isCurrent) where isCurrent = 1;
create index IndexBuildsOnJobIsCurrent on Builds(project, jobset, job, isCurrent) where isCurrent = 1;

Deletion in src/sql/hydra.sql at line 674 [21.1]
∅:D[3.317] → [27.2867:2982]
∅:D[26.576] → [27.2867:2982]
B:BD[27.2867] → [27.2867:2982]
```
create index IndexBuildsOnJobset on Builds(project, jobset);
create index IndexBuildsOnProject on Builds(project);
```

Deletion in src/sql/hydra.sql at line 676 [21.1]

B:BD[28.79] → [2.0:100]

create index IndexBuildsOnJobFinishedId on builds(project, jobset, job, system, finished, id DESC);

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

[29.3004]

drop index IndexBuildsOnJobsetIsCurrent;
drop index IndexBuildsOnJobIsCurrent;
drop index IndexBuildsOnJobset;
drop index IndexBuildsOnProject;
drop index IndexBuildsOnJobFinishedId;
alter table Builds
    drop column project,
    drop column jobset;

builds: drop project, jobset columns

Dependencies

In channels

Change contents

Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 54 [6.5202]

Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 55 [6.5202]

Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 197 [6.5202]

Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 424 [6.5202]

Deletion in src/lib/Hydra/Schema/Result/Builds.pm at line 456 [6.5202]

Replacement in src/lib/Hydra/Schema/Result/Builds.pm at line 500 [6.5202]

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

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

Deletion in src/lib/Hydra/Schema/Result/Jobsets.pm at line 272 [10.1960]

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

Deletion in src/lib/Hydra/Schema/Result/Projects.pm at line 144 [10.3266]

Deletion in src/lib/Hydra/Schema/Result/Projects.pm at line 145 [10.3266]

Replacement in src/lib/Hydra/Schema/Result/Projects.pm at line 231 [10.3266]

Deletion in src/sql/hydra.sql at line 165 [21.1]

Replacement in src/sql/hydra.sql at line 225 [21.1]

Deletion in src/sql/hydra.sql at line 671 [21.1]

Deletion in src/sql/hydra.sql at line 674 [21.1]

Deletion in src/sql/hydra.sql at line 676 [21.1]

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