grahamc/hydra - Change NZXX6PLDWEDQHXFF5JCZWGB22VA3WSDYLX65K6BQ5GNWPOE43N7QC

Remove the Jobs table

This table has been superfluous for a long time.

Created by Eelco Dolstra on May 27, 2020

NZXX6PLDWEDQHXFF5JCZWGB22VA3WSDYLX65K6BQ5GNWPOE43N7QC

Dependencies

In channels

upstream

main

Change contents

Replacement in src/lib/Hydra/Controller/Build.pm at line 89 [18.1]
B:BD[17.153] → [17.153:197]
```
            , job => $c->stash->{job}->name
```
[17.153]
[19.361]
```
            , job => $c->stash->{job}
```

Replacement in src/lib/Hydra/Controller/Job.pm at line 27 [20.46]

B:BD[5.598] → [5.598:675]

∅:D[5.675] → [21.176:311]

∅:D[22.803] → [21.176:311]

B:BD[21.176] → [21.176:311]

    $c->stash->{job} = $c->stash->{jobset}->jobs->find({ name => $jobName })
        or notFound($c, "Job $projectName:$jobsetName:$jobName doesn't exist.");
    $c->stash->{project} = $c->stash->{job}->project;

[5.598]

[20.427]

    $c->stash->{job} = $jobName;
    $c->stash->{project} = $c->stash->{jobset}->project;

Deletion in src/lib/Hydra/Controller/Job.pm at line 33 [20.46]
B:BD[23.112] → [23.112:144]
```
    my $job = $c->stash->{job};
```

Replacement in src/lib/Hydra/Controller/Job.pm at line 35 [20.46]

B:BD[24.2] → [23.188:255]

    my $lastBuild = $job->builds->find(
        { finished => 1 },

[24.2]

[23.255]

    my $lastBuild = $c->stash->{jobset}->builds->find(
        { job => $c->stash->{job}, finished => 1 },

Replacement in src/lib/Hydra/Controller/Job.pm at line 47 [20.46]
B:BD[23.618] → [23.618:650]
```
        $c->stash->{job}->name,
```
[23.618]
[23.679]
```
        $c->stash->{job},
```
Replacement in src/lib/Hydra/Controller/Job.pm at line 57 [20.46]
B:BD[23.1013] → [23.1013:1045]
```
        $c->stash->{job}->name,
```
[23.1013]
[10.0]
```
        $c->stash->{job},
```
Deletion in src/lib/Hydra/Controller/Job.pm at line 66 [20.46]
B:BD[24.80] → [25.0:32]
```
    my $job = $c->stash->{job};
```

Replacement in src/lib/Hydra/Controller/Job.pm at line 70 [20.46]

B:BD[26.1827] → [25.33:83]

        [ $job->builds->search({ finished => 1 },

[26.1827]

[27.832]

        [ $c->stash->{jobset}->builds->search({ job => $c->stash->{job}, finished => 1 },

Replacement in src/lib/Hydra/Controller/Job.pm at line 74 [20.46]

B:BD[28.34] → [25.84:114]

∅:D[25.114] → [28.35:66]

B:BD[29.1930] → [28.35:66]

        $job->builds->search(
            { finished => 0 },

[28.34]

[30.0]

        $c->stash->{jobset}->builds->search(
            { job => $c->stash->{job}, finished => 0 },

Replacement in src/lib/Hydra/Controller/Job.pm at line 81 [20.46]

B:BD[25.234] → [31.0:130]

        { aggregate => { -in => $job->builds->search({}, { columns => ["id"], order_by => "id desc", rows => 15 })->as_query } },

[25.234]

[32.0]

        { aggregate => { -in => $c->stash->{jobset}->builds->search({ job => $c->stash->{job} }, { columns => ["id"], order_by => "id desc", rows => 15 })->as_query } },

Replacement in src/lib/Hydra/Controller/Job.pm at line 91 [20.46]

B:BD[25.643] → [31.365:491]

        my $jobName = $b->get_column('job');
        $aggregates->{$b->get_column('aggregate')}->{constituents}->{$jobName} =

[25.643]

[31.491]

        $aggregates->{$b->get_column('aggregate')}->{constituents}->{$b->job} =

Replacement in src/lib/Hydra/Controller/Job.pm at line 93 [20.46]
B:BD[31.579] → [31.579:619]
```
        $constituentJobs{$jobName} = 1;
```
[31.579]
[33.199]
```
        $constituentJobs{$b->job} = 1;
```
Replacement in src/lib/Hydra/Controller/Job.pm at line 108 [20.46]
B:BD[34.145] → [34.145:185]
```
        , job => $c->stash->{job}->name
```
[34.145]
[34.185]
```
        , job => $c->stash->{job}
```
Deletion in src/lib/Hydra/Controller/Job.pm at line 115 [20.46]
B:BD[35.96] → [35.96:128]
```
    my $job = $c->stash->{job};
```

Replacement in src/lib/Hydra/Controller/Job.pm at line 116 [20.46]

∅:D[35.178] → [36.2570:2627]

B:BD[36.2570] → [36.2570:2627]

B:BD[36.2627] → [8.0:77]

    $c->stash->{metrics} = [ $job->buildmetrics->search(
        { }, { select => ["name"], distinct => 1, order_by => "name",  }) ];

[35.178]

[37.0]

    $c->stash->{metrics} = [ $c->stash->{jobset}->buildmetrics->search(
        { job => $c->stash->{job} }, { select => ["name"], distinct => 1, order_by => "name",  }) ];

Replacement in src/lib/Hydra/Controller/Job.pm at line 123 [20.46]

B:BD[37.96] → [37.96:217]

    my @res = $c->stash->{job}->builds->search(
        { finished => 1, buildstatus => 0, closuresize => { '!=', 0 } },

[37.96]

[37.217]

    my @res = $c->stash->{jobset}->builds->search(
        { job => $c->stash->{job}, finished => 1, buildstatus => 0, closuresize => { '!=', 0 } },

Replacement in src/lib/Hydra/Controller/Job.pm at line 135 [20.46]

B:BD[38.96] → [38.96:217]

    my @res = $c->stash->{job}->builds->search(
        { finished => 1, buildstatus => 0, closuresize => { '!=', 0 } },

[38.96]

[38.217]

    my @res = $c->stash->{jobset}->builds->search(
        { job => $c->stash->{job}, finished => 1, buildstatus => 0, closuresize => { '!=', 0 } },

Replacement in src/lib/Hydra/Controller/Job.pm at line 144 [20.46]

B:BD[39.94] → [39.94:208]

    my @res = $c->stash->{job}->builds->search(
        { finished => 1, buildstatus => 0, size => { '!=', 0 } },

[39.94]

[39.208]

    my @res = $c->stash->{jobset}->builds->search(
        { job => $c->stash->{job}, finished => 1, buildstatus => 0, size => { '!=', 0 } },

Replacement in src/lib/Hydra/Controller/Job.pm at line 157 [20.46]

B:BD[36.2896] → [36.2896:2983]

    my @res = $c->stash->{job}->buildmetrics->search(
        { name => $metricName },

[36.2896]

[36.2983]

    my @res = $c->stash->{jobset}->buildmetrics->search(
        { job => $c->stash->{job}, name => $metricName },

Replacement in src/lib/Hydra/Controller/Job.pm at line 168 [20.46]

∅:D[40.56] → [21.364:419]

B:BD[20.685] → [21.364:419]

    $c->stash->{allBuilds} = $c->stash->{job}->builds;

[20.685]

[41.578]

    $c->stash->{allBuilds} = $c->stash->{jobset}->builds->search({ job => $c->stash->{job} });

Replacement in src/lib/Hydra/Controller/Job.pm at line 170 [20.46]

B:BD[41.665] → [16.0:83]

        ->search({}, {bind => [$c->stash->{jobset}->id, $c->stash->{job}->name]});

[41.665]

[20.799]

        ->search({}, {bind => [$c->stash->{jobset}->id, $c->stash->{job}]});

Replacement in src/lib/Hydra/Controller/Job.pm at line 172 [20.46]

B:BD[20.834] → [21.420:521]

        $c->stash->{project}->name . "-" . $c->stash->{jobset}->name . "-" . $c->stash->{job}->name;

[20.834]

[34.229]

        $c->stash->{project}->name . "-" . $c->stash->{jobset}->name . "-" . $c->stash->{job};

Replacement in src/lib/Hydra/Controller/Job.pm at line 183 [20.46]
B:BD[34.462] → [34.462:502]
```
        , job => $c->stash->{job}->name
```
[34.462]
[34.502]
```
        , job => $c->stash->{job}
```

Replacement in src/lib/Hydra/Controller/Root.pm at line 462 [43.804]

B:BD[42.744] → [42.744:801]

B:BD[42.801] → [44.498:545]

    $c->stash->{jobs} = [ $c->model('DB::Jobs')->search(
        { "me.name" => { ilike => "%$query%" }

[42.744]

[44.545]

    $c->stash->{jobs} = [ $c->model('DB::Builds')->search(
        { "job" => { ilike => "%$query%" }

Insertion in src/lib/Hydra/Controller/Root.pm at line 466 [43.804]
[44.608]
[44.608]
```
        , iscurrent => 1
```

Replacement in src/lib/Hydra/Controller/Root.pm at line 468 [43.804]

B:BD[44.619] → [45.0:100]

B:BD[45.100] → [2.0:210]

∅:D[2.210] → [45.307:338]

B:BD[45.307] → [45.307:338]

        { order_by => ["enabled_ desc", "project", "jobset", "name"], join => ["project", "jobset"]
        , "+select" => [\ "(project.enabled = 1 and jobset.enabled = 1 and exists (select 1 from Builds where project = project.name and jobset = jobset.name and job = me.name and iscurrent = 1)) as enabled_"]
        , "+as" => ["enabled"]

[44.619]

[46.32]

        { order_by => ["project", "jobset", "job"], join => ["project", "jobset"]

Replacement in src/lib/Hydra/Controller/Root.pm at line 470 [43.804]
∅:D[46.73] → [45.338:353]
B:BD[45.338] → [45.338:353]
```
        } ) ];
```
[46.73]
[47.50]
```
        } )
    ];
```

Replacement in src/lib/Hydra/Controller/User.pm at line 342 [48.252]

B:BD[34.1046] → [34.1046:1109]

        my @builds = $j->job->builds->search(
            { },

[34.1046]

[34.1109]

        my @builds = $j->jobset->builds->search(
            { job => $j->job },

Replacement in src/lib/Hydra/Controller/User.pm at line 345 [48.252]

B:BD[34.1161] → [7.0:83]

        push @{$c->stash->{starredJobs}}, { job => $j->job, builds => [@builds] };

[34.1161]

[34.1241]

        push @{$c->stash->{starredJobs}}, { job => $j, builds => [@builds] };

Replacement in src/lib/Hydra/Helper/CatalystUtils.pm at line 49 [18.3469]
B:BD[49.37] → [50.168:208]
```
    return $build->job->builds->search(
```
[49.37]
[51.376]
```
    return $build->jobset->builds->search(
```
File deletion: Jobs.pm
BF:BFD[52.477] → [53.2851:2882]
BF:BFD[53.2882] → [53.1454:1454]
B:BD[53.1454] → [54.15122:15132]
∅:D[54.15132] → [53.1455:1484]
B:BD[53.1454] → [53.1455:1484]
B:BD[53.1484] → [55.1978:2064]
∅:D[55.2064] → [53.1484:1485]
B:BD[53.1484] → [53.1484:1485]
B:BD[53.1485] → [54.15133:15173]
∅:D[54.15173] → [53.1485:1511]
B:BD[53.1485] → [53.1485:1511]
B:BD[53.1511] → [56.13542:13573]
B:BD[56.13573] → [57.30004:30149]
∅:D[56.13587] → [53.1536:1537]
∅:D[57.30149] → [53.1536:1537]
B:BD[53.1536] → [53.1536:1537]
B:BD[53.1537] → [58.3806:3828]
∅:D[58.3828] → [56.13608:13615]
∅:D[54.15196] → [56.13608:13615]
B:BD[56.13608] → [56.13608:13615]
B:BD[56.13615] → [58.3829:3857]
∅:D[58.3857] → [56.13616:13651]
B:BD[53.1603] → [56.13616:13651]
B:BD[56.13651] → [54.15197:15217]
∅:D[54.15217] → [56.13692:13729]
B:BD[56.13692] → [56.13692:13729]
B:BD[56.13743] → [56.13743:13759]
B:BD[56.13759] → [54.15218:15238]
∅:D[54.15238] → [56.13800:13837]
B:BD[56.13800] → [56.13800:13837]
B:BD[56.13837] → [59.0:62]
B:BD[59.62] → [60.0:17]
∅:D[60.17] → [56.13851:13865]
∅:D[59.79] → [56.13851:13865]
B:BD[56.13851] → [56.13851:13865]
B:BD[56.13865] → [54.15239:15259]
∅:D[54.15259] → [56.13906:13923]
B:BD[56.13906] → [56.13906:13923]
B:BD[56.14398] → [56.14398:14405]
∅:D[56.14405] → [53.1603:1642]
B:BD[53.1603] → [53.1603:1642]
B:BD[53.1642] → [54.15377:15443]
∅:D[61.10637] → [53.1702:1714]
∅:D[54.15443] → [53.1702:1714]
B:BD[53.1702] → [53.1702:1714]
B:BD[53.1714] → [54.15444:15510]
B:BD[54.15510] → [59.80:95]
B:BD[59.95] → [60.18:87]
∅:D[60.87] → [53.1774:1784]
∅:D[59.164] → [53.1774:1784]
∅:D[61.10766] → [53.1774:1784]
∅:D[54.15510] → [53.1774:1784]
B:BD[53.1774] → [53.1774:1784]
B:BD[53.1784] → [54.15511:15556]
∅:D[61.11369] → [53.2156:2159]
∅:D[54.15838] → [53.2156:2159]
B:BD[53.2156] → [53.2156:2159]
B:BD[53.2159] → [54.15839:15941]
∅:D[54.15941] → [53.2159:2218]
B:BD[53.2159] → [53.2159:2218]
B:BD[53.2218] → [56.14406:14424]
∅:D[36.6759] → [56.14424:14425]
B:BD[56.14424] → [56.14424:14425]
∅:D[36.6975] → [54.15942:15956]
B:BD[56.14425] → [54.15942:15956]
∅:D[54.15956] → [56.14440:14441]
B:BD[56.14440] → [56.14440:14441]
B:BD[56.14441] → [54.15957:15972]
∅:D[54.15972] → [56.14458:14459]
B:BD[56.14458] → [56.14458:14459]
B:BD[56.14459] → [54.15973:16014]
∅:D[54.16014] → [56.14502:14509]
B:BD[56.14502] → [56.14502:14509]
B:BD[56.14509] → [54.16015:16205]
B:BD[54.16205] → [62.3576:3585]
∅:D[62.3585] → [54.16211:16214]
B:BD[54.16211] → [54.16211:16214]
∅:D[54.16214] → [56.14599:14682]
B:BD[56.14599] → [56.14599:14682]
∅:D[56.14682] → [63.1315:1352]
B:BD[63.1315] → [63.1315:1352]
∅:D[59.499] → [63.1352:1426]
B:BD[63.1352] → [63.1352:1426]
B:BD[63.1426] → [62.3586:3660]
∅:D[62.3660] → [63.1426:1429]
∅:D[56.14689] → [63.1426:1429]
B:BD[63.1426] → [63.1426:1429]
B:BD[63.1429] → [56.14690:14691]
B:BD[56.14691] → [54.16215:16230]
∅:D[54.16230] → [56.14705:14706]
B:BD[56.14705] → [56.14705:14706]
B:BD[56.14706] → [54.16231:16248]
∅:D[54.16248] → [56.14721:14722]
B:BD[56.14721] → [56.14721:14722]
B:BD[56.14722] → [54.16249:16292]
∅:D[54.16292] → [56.14763:14770]
B:BD[56.14763] → [56.14763:14770]
B:BD[56.14770] → [62.3661:3830]
B:BD[62.3830] → [34.1252:1335]
∅:D[34.1335] → [53.2611:2612]
∅:D[62.3830] → [53.2611:2612]
∅:D[54.16383] → [53.2611:2612]
B:BD[53.2611] → [53.2611:2612]
∅:D[34.1341] → [53.2612:2613]
B:BD[53.2612] → [53.2612:2613]
B:BD[53.2613] → [34.1342:1556]
B:BD[34.1556] → [60.165:307]
B:BD[60.307] → [12.0:248]
∅:D[64.142] → [53.2756:2757]
∅:D[65.142] → [53.2756:2757]
∅:D[12.248] → [53.2756:2757]
∅:D[66.285] → [53.2756:2757]
∅:D[60.307] → [53.2756:2757]
∅:D[59.642] → [53.2756:2757]
∅:D[34.1698] → [53.2756:2757]
∅:D[62.3973] → [53.2756:2757]
∅:D[58.4000] → [53.2756:2757]
∅:D[36.7118] → [53.2756:2757]
∅:D[56.14913] → [53.2756:2757]
∅:D[54.16526] → [53.2756:2757]
∅:D[57.30292] → [53.2756:2757]
B:BD[53.2756] → [53.2756:2757]
B:BD[53.2847] → [53.2847:2850]
B:BD[53.2612] → [34.1336:1341]
B:BD[63.1352] → [59.165:218]
B:BD[59.218] → [60.88:164]
∅:D[60.164] → [59.346:499]
B:BD[59.346] → [59.346:499]
B:BD[56.14425] → [36.6760:6975]
B:BD[56.14424] → [36.6668:6759]
```
use utf8;
package Hydra::Schema::Jobs;
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
=head1 NAME
Hydra::Schema::Jobs
=cut
use strict;
use warnings;
use base 'DBIx::Class::Core';
=head1 COMPONENTS LOADED
=over 4
=item * L<Hydra::Component::ToJSON>
=back
=cut
__PACKAGE__->load_components("+Hydra::Component::ToJSON");
=head1 TABLE: C<jobs>
=cut
__PACKAGE__->table("jobs");
=head1 ACCESSORS
=head2 project
  data_type: 'text'
  is_foreign_key: 1
  is_nullable: 0
=head2 jobset
  data_type: 'text'
  is_foreign_key: 1
  is_nullable: 0
=head2 jobset_id
  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0
=head2 name
  data_type: 'text'
  is_nullable: 0
=cut
__PACKAGE__->add_columns(
  "project",
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
  "jobset",
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
  "jobset_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "name",
  { data_type => "text", is_nullable => 0 },
);
=head1 PRIMARY KEY
=over 4
=item * L</project>
=item * L</jobset>
=item * L</name>
=back
=cut
__PACKAGE__->set_primary_key("project", "jobset", "name");
=head1 RELATIONS
=head2 builds
Type: has_many
Related object: L<Hydra::Schema::Builds>
=cut
__PACKAGE__->has_many(
  "builds",
  "Hydra::Schema::Builds",
  {
    "foreign.job"     => "self.name",
    "foreign.jobset"  => "self.jobset",
    "foreign.project" => "self.project",
  },
  undef,
);
=head2 jobset
Type: belongs_to
Related object: L<Hydra::Schema::Jobsets>
=cut
__PACKAGE__->belongs_to(
  "jobset",
  "Hydra::Schema::Jobsets",
  { name => "jobset", project => "project" },
  { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 project
Type: belongs_to
Related object: L<Hydra::Schema::Projects>
=cut
__PACKAGE__->belongs_to(
  "project",
  "Hydra::Schema::Projects",
  { name => "project" },
  { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 starredjobs
Type: has_many
Related object: L<Hydra::Schema::StarredJobs>
__PACKAGE__->has_many(
  "starredjobs",
  "Hydra::Schema::StarredJobs",
  {
    "foreign.job"     => "self.name",
    "foreign.jobset"  => "self.jobset",
    "foreign.project" => "self.project",
  },
  undef,
);
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:33:28
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:C5Tyh8Ke4yC6q7KIFVOHcQ
=head2 builds
Type: has_many
Related object: L<Hydra::Sc2hema::Builds>
=cut
__PACKAGE__->has_many(
  "builds",
  "Hydra::Schema::Builds",
  {
    "foreign.job"     => "self.name",
    "foreign.jobset_id"  => "self.jobset_id",
  },
  undef,
);
1;
=cut
  "Hydra::Schema::Jobsets",
  { id => "jobset_id" },
  { is_deferrable => 0, 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",
__PACKAGE__->has_many(
  "buildmetrics",
  "Hydra::Schema::BuildMetrics",
  {
    "foreign.job"     => "self.name",
    "foreign.jobset"  => "self.jobset",
    "foreign.project" => "self.project",
  },
  undef,
);
=head2 buildmetrics
Type: has_many
Related object: L<Hydra::Schema::BuildMetrics>
=cut
```
Deletion in src/lib/Hydra/Schema/BuildMetrics.pm at line 74 [36.3245]
B:BD[36.4143] → [36.4143:4163]
```
  is_foreign_key: 1
```
Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 97 [36.3245]
B:BD[36.4696] → [36.4696:4762]
```
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
```
[36.4696]
[36.4762]
```
  { data_type => "text", is_nullable => 0 },
```

Deletion in src/lib/Hydra/Schema/BuildMetrics.pm at line 131 [36.3245]

B:BD[36.5214] → [36.5214:5492]

);
=head2 job
Type: belongs_to
Related object: L<Hydra::Schema::Jobs>
=cut
__PACKAGE__->belongs_to(
  "job",
  "Hydra::Schema::Jobs",
  { jobset => "jobset", name => "job", project => "project" },
  { is_deferrable => 0, on_delete => "NO ACTION", on_update => "CASCADE" },

Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 164 [36.3245]

B:BD[36.6026] → [58.689:831]

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

[36.6026]

[36.6168]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-27 17:40:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AYUVs6RdefFKw+g9Yxcu/A

Deletion in src/lib/Hydra/Schema/Builds.pm at line 76 [43.5202]
∅:D[54.7727] → [56.7654:7674]
B:BD[56.7654] → [56.7654:7674]
```
  is_foreign_key: 1
```
Replacement in src/lib/Hydra/Schema/Builds.pm at line 226 [43.5202]
B:BD[67.1340] → [54.8336:8402]
```
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
```
[67.1340]
[68.721]
```
  { data_type => "text", is_nullable => 0 },
```
Deletion in src/lib/Hydra/Schema/Builds.pm at line 439 [43.5202]
B:BD[69.244] → [69.244:248]
∅:D[69.248] → [54.10124:10135]
B:BD[56.9476] → [54.10124:10135]
∅:D[54.10135] → [56.9502:9503]
B:BD[56.9502] → [56.9502:9503]
B:BD[56.9503] → [54.10136:10153]
∅:D[54.10153] → [56.9518:9519]
B:BD[56.9518] → [56.9518:9519]
B:BD[56.9519] → [54.10154:10193]
∅:D[54.10193] → [56.9565:9572]
B:BD[56.9565] → [56.9565:9572]
B:BD[56.9572] → [54.10194:10316]
B:BD[54.10316] → [62.3077:3153]
```
);
=head2 job
Type: belongs_to
Related object: L<Hydra::Schema::Jobs>
=cut
__PACKAGE__->belongs_to(
  "job",
  "Hydra::Schema::Jobs",
  { jobset => "jobset", name => "job", project => "project" },
  { is_deferrable => 0, on_delete => "NO ACTION", on_update => "CASCADE" },
```

Replacement in src/lib/Hydra/Schema/Builds.pm at line 545 [43.5202]

B:BD[70.3378] → [15.20:162]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-06 12:32:57
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3IyFj/9Zf/hvmhBY4U/IBQ

[70.3378]

[71.4481]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-27 17:40:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RIKKFfcKXFWIUeM8ma++iw

Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 204 [73.65]

B:BD[54.18354] → [72.110:252]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:21:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ar6GRni8AcAQmuZyg6tFKw

[54.18354]

[74.1674]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-27 17:40:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M61ikfnjORU7jDAH8P/j7w

Deletion in src/lib/Hydra/Schema/Jobsets.pm at line 292 [76.1960]
B:BD[75.2717] → [59.643:683]
∅:D[59.683] → [56.19391:19392]
B:BD[75.2717] → [56.19391:19392]
B:BD[56.19392] → [59.684:723]
```
=head2 jobs_jobset_ids
Type: has_many
Related object: L<Hydra::Schema::Jobs>
```
Deletion in src/lib/Hydra/Schema/Jobsets.pm at line 293 [76.1960]
B:BD[59.724] → [59.724:880]
∅:D[59.880] → [56.19404:19467]
B:BD[56.19404] → [56.19404:19467]
∅:D[56.19467] → [75.2717:2740]
B:BD[75.2717] → [75.2717:2740]
B:BD[75.2740] → [59.881:907]
∅:D[59.907] → [75.2750:2863]
B:BD[75.2750] → [75.2750:2863]
B:BD[75.2863] → [62.5763:5772]
∅:D[62.5772] → [75.2863:2866]
∅:D[54.21807] → [75.2863:2866]
B:BD[75.2863] → [75.2863:2866]
B:BD[75.2866] → [56.19468:19469]
```
=cut
__PACKAGE__->has_many(
  "jobs_jobset_ids",
  "Hydra::Schema::Jobs",
  { "foreign.jobset_id" => "self.id" },
  undef,
);
=head2 jobs_project_jobsets
Type: has_many
Related object: L<Hydra::Schema::Jobs>
=cut
__PACKAGE__->has_many(
  "jobs_project_jobsets",
  "Hydra::Schema::Jobs",
  {
    "foreign.jobset"  => "self.name",
    "foreign.project" => "self.project",
  },
  undef,
);
```

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 378 [76.1960]

B:BD[54.22628] → [77.920:1062]

# 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

[54.22628]

[77.1062]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-27 17:40:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aDW78MCelU/ma953aTcHvA

Deletion in src/lib/Hydra/Schema/Projects.pm at line 159 [76.3266]
∅:D[78.4371] → [56.20640:20641]
B:BD[56.20640] → [56.20640:20641]
B:BD[56.20641] → [54.24583:24595]
∅:D[54.24595] → [56.20656:20673]
B:BD[56.20656] → [56.20656:20673]
B:BD[56.20673] → [54.24596:24635]
```
=head2 jobs
Type: has_many
Related object: L<Hydra::Schema::Jobs>
```
Deletion in src/lib/Hydra/Schema/Projects.pm at line 160 [76.3266]
B:BD[56.20716] → [56.20716:20722]
∅:D[79.2395] → [80.2317:2340]
∅:D[56.20722] → [80.2317:2340]
B:BD[80.2317] → [80.2317:2340]
B:BD[80.2340] → [54.24636:24671]
∅:D[54.24671] → [81.4695:4735]
B:BD[82.3585] → [81.4695:4735]
B:BD[81.4735] → [62.6895:6904]
∅:D[62.6904] → [81.4735:4738]
∅:D[54.24678] → [81.4735:4738]
B:BD[81.4735] → [81.4735:4738]
B:BD[81.4738] → [56.20723:20724]
```
=cut
__PACKAGE__->has_many(
  "jobs",
  "Hydra::Schema::Jobs",
  { "foreign.project" => "self.name" },
  undef,
);
```

Replacement in src/lib/Hydra/Schema/Projects.pm at line 261 [76.3266]

B:BD[62.7308] → [15.163:305]

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

[62.7308]

[83.171]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-27 17:40:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iBGJjFWiI9Wy9zwT7xGOEA

Deletion in src/lib/Hydra/Schema/StarredJobs.pm at line 59 [34.2467]
B:BD[34.3195] → [34.3195:3215]
```
  is_foreign_key: 1
```
Replacement in src/lib/Hydra/Schema/StarredJobs.pm at line 71 [34.2467]
B:BD[34.3511] → [34.3511:3577]
```
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
```
[34.3511]
[34.3577]
```
  { data_type => "text", is_nullable => 0 },
```
Deletion in src/lib/Hydra/Schema/StarredJobs.pm at line 93 [34.2467]
B:BD[34.3791] → [34.3791:3867]
```
=head2 job
Type: belongs_to
Related object: L<Hydra::Schema::Jobs>
=cut
```

Deletion in src/lib/Hydra/Schema/StarredJobs.pm at line 94 [34.2467]

B:BD[34.3868] → [34.3868:4068]

__PACKAGE__->belongs_to(
  "job",
  "Hydra::Schema::Jobs",
  { jobset => "jobset", name => "job", project => "project" },
  { is_deferrable => 0, on_delete => "CASCADE", on_update => "CASCADE" },
);

Replacement in src/lib/Hydra/Schema/StarredJobs.pm at line 140 [34.2467]

B:BD[34.4849] → [58.7469:7611]

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

[34.4849]

[34.4991]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-05-27 17:36:07
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RRDQ6UQL/bjXPD+HO1s5ug

Replacement in src/lib/Hydra/View/TT.pm at line 40 [43.6789]

B:BD[84.173] → [84.173:476]

    my ($self, $c, $job) = @_;
    my $latestEval = $job->jobset->jobsetevals->search(
        { hasnewbuilds => 1},
        { rows => 1, order_by => ["id desc"] })->single;
    return 0 if !defined $latestEval; # can't happen
    return scalar($latestEval->builds->search({ job => $job->name })) != 0;

[84.173]

[84.476]

    my ($self, $c, $jobset, $jobName) = @_;
    return defined $jobset->builds->search({ job => $jobName, iscurrent => 1 })->single;

Replacement in src/root/all.tt at line 2 [87.1038]
∅:D[85.45] → [86.90:151]
∅:D[88.733] → [86.90:151]
B:BD[86.90] → [86.90:151]
```
    (job ? " for job $project.name:$jobset.name:$job.name" :
```
[85.45]
[86.151]
```
    (job ? " for job $project.name:$jobset.name:$job" :
```

Replacement in src/root/build.tt at line 1 [43.7350]

B:BD[43.7350] → [86.262:348]

[% WRAPPER layout.tt title="Build $id of job $project.name:$jobset.name:$job.name" %]

[43.7350]

[89.2280]

[% WRAPPER layout.tt title="Build $id of job $project.name:$jobset.name:$job" %]

Replacement in src/root/build.tt at line 261 [43.7350]

B:BD[26.10210] → [90.4812:4931]

      [% INCLUDE renderProductList latestRoot=['/job' build.project.name build.jobset.name build.job.name 'latest'] %]

[26.10210]

[26.10347]

      [% INCLUDE renderProductList latestRoot=['/job' build.project.name build.jobset.name build.job 'latest'] %]

Replacement in src/root/build.tt at line 387 [43.7350]

B:BD[90.9528] → [6.0:111]

      [% chartsURL = c.uri_for('/job' build.project.name build.jobset.name build.job.name) _ "#tabs-charts" %]

[90.9528]

[6.111]

      [% chartsURL = c.uri_for('/job' build.project.name build.jobset.name build.job) _ "#tabs-charts" %]

Replacement in src/root/build.tt at line 428 [43.7350]

B:BD[36.8216] → [9.0:190]

              <td><tt><a class="row-link" [% HTML.attributes(href => c.uri_for('/job' project.name jobset.name job.name 'metric' metric.name)) %]">[%HTML.escape(metric.name)%]</a></tt></td>

[36.8216]

[91.57]

              <td><tt><a class="row-link" [% HTML.attributes(href => c.uri_for('/job' project.name jobset.name job 'metric' metric.name)) %]">[%HTML.escape(metric.name)%]</a></tt></td>

Replacement in src/root/build.tt at line 510 [43.7350]

B:BD[92.261] → [13.0:114]

<span class="shell-prompt"># </span>nix build [% HTML.escape(eval.flake) %]#hydraJobs.[% HTML.escape(job.name) %]

[92.261]

[92.375]

<span class="shell-prompt"># </span>nix build [% HTML.escape(eval.flake) %]#hydraJobs.[% HTML.escape(job) %]

Replacement in src/root/dashboard.tt at line 25 [34.5624]

B:BD[34.6220] → [84.480:689]

              <td><span class="[% IF !jobExists(j.job) %]disabled-job[% END %]">[% INCLUDE renderFullJobName project=j.job.get_column('project') jobset=j.job.get_column('jobset') job=j.job.name %]</span></td>

[34.6220]

[34.6360]

              <td><span class="[% IF !jobExists(j.job.jobset j.job.job) %]disabled-job[% END %]">[% INCLUDE renderFullJobName project=j.job.get_column('project') jobset=j.job.get_column('jobset') job=j.job.job %]</span></td>

Replacement in src/root/job-metrics-tab.tt at line 7 [35.180]

B:BD[35.283] → [35.283:414]

  [% INCLUDE createChart id="build-times" yaxis="sec" dataUrl=c.uri_for('/job' project.name jobset.name job.name 'build-times') %]

[35.283]

[35.414]

  [% INCLUDE createChart id="build-times" yaxis="sec" dataUrl=c.uri_for('/job' project.name jobset.name job 'build-times') %]

Replacement in src/root/job-metrics-tab.tt at line 11 [35.180]

B:BD[35.449] → [35.449:583]

  [% INCLUDE createChart id="closure-size" yaxis="mib" dataUrl=c.uri_for('/job' project.name jobset.name job.name 'closure-sizes') %]

[35.449]

[35.583]

  [% INCLUDE createChart id="closure-size" yaxis="mib" dataUrl=c.uri_for('/job' project.name jobset.name job 'closure-sizes') %]

Replacement in src/root/job-metrics-tab.tt at line 15 [35.180]

B:BD[35.617] → [35.617:749]

  [% INCLUDE createChart id="output-size" yaxis="mib" dataUrl=c.uri_for('/job' project.name jobset.name job.name 'output-sizes') %]

[35.617]

[35.749]

  [% INCLUDE createChart id="output-size" yaxis="mib" dataUrl=c.uri_for('/job' project.name jobset.name job 'output-sizes') %]

Replacement in src/root/job-metrics-tab.tt at line 19 [35.180]

B:BD[35.785] → [9.191:361]

    <h3>Metric: <a [% HTML.attributes(href => c.uri_for('/job' project.name jobset.name job.name 'metric' metric.name)) %]><tt>[%HTML.escape(metric.name)%]</tt></a></h3>

[35.785]

[35.844]

    <h3>Metric: <a [% HTML.attributes(href => c.uri_for('/job' project.name jobset.name job 'metric' metric.name)) %]><tt>[%HTML.escape(metric.name)%]</tt></a></h3>

Replacement in src/root/job-metrics-tab.tt at line 23 [35.180]

B:BD[35.917] → [35.917:1029]

       INCLUDE createChart dataUrl=c.uri_for('/job' project.name jobset.name job.name 'metric' metric.name); %]

[35.917]

[35.1029]

       INCLUDE createChart dataUrl=c.uri_for('/job' project.name jobset.name job 'metric' metric.name); %]

Replacement in src/root/job.tt at line 2 [24.7675]

B:BD[34.6880] → [34.6880:6933]

    title="Job $project.name:$jobset.name:$job.name"

[34.6880]

[34.6933]

    title="Job $project.name:$jobset.name:$job"

Replacement in src/root/job.tt at line 10 [24.7675]
B:BD[93.1] → [84.690:715]
```
[% IF !jobExists(job) %]
```
[93.1]
[84.715]
```
[% IF !jobExists(jobset, job) %]
```

Replacement in src/root/job.tt at line 32 [24.7675]

∅:D[4.51] → [94.422:503]

∅:D[95.52] → [94.422:503]

B:BD[94.422] → [94.422:503]

          linkToAll=c.uri_for('/job' project.name jobset.name job.name 'all') %]

[4.51]

[94.503]

          linkToAll=c.uri_for('/job' project.name jobset.name job 'all') %]

Replacement in src/root/job.tt at line 87 [24.7675]

B:BD[36.8814] → [35.1094:1214]

  [% INCLUDE makeLazyTab tabName="tabs-charts" uri=c.uri_for('/job' project.name jobset.name job.name 'metrics-tab') %]

[36.8814]

[36.8850]

  [% INCLUDE makeLazyTab tabName="tabs-charts" uri=c.uri_for('/job' project.name jobset.name job 'metrics-tab') %]

Replacement in src/root/job.tt at line 91 [24.7675]

B:BD[93.1226] → [96.74:194]

B:BD[96.194] → [3.820:976]

      <li><a href="[% c.uri_for('/job' project.name jobset.name job.name 'latest') %]">Latest successful build</a></li>
      <li><a href="[% c.uri_for('/job' project.name jobset.name job.name 'latest-finished') %]">Latest successful build from a finished evaluation</a></li>

[93.1226]

[93.1594]

      <li><a href="[% c.uri_for('/job' project.name jobset.name job 'latest') %]">Latest successful build</a></li>
      <li><a href="[% c.uri_for('/job' project.name jobset.name job 'latest-finished') %]">Latest successful build from a finished evaluation</a></li>

Replacement in src/root/search.tt at line 70 [42.1084]

B:BD[42.2365] → [97.891:1099]

          <td><span class="[% IF !j.get_column('enabled') %]disabled-job[% END %]">[% INCLUDE renderFullJobName project=j.get_column('project') jobset=j.get_column('jobset') job=j.name inRow=1 %]</span></td>

[42.2365]

[42.2489]

          <td><span>[% INCLUDE renderFullJobName project=j.get_column('project') jobset=j.get_column('jobset') job=j.job inRow=1 %]</span></td>

Replacement in src/root/topbar.tt at line 68 [99.6671]

B:BD[98.331] → [98.331:393]

      <li class="nav-header">[% HTML.escape(job.name) %]</li>

[98.331]

[98.393]

      <li class="nav-header">[% HTML.escape(job) %]</li>

Replacement in src/root/topbar.tt at line 71 [99.6671]

∅:D[100.286] → [101.13582:13689]

B:BD[101.13582] → [101.13582:13689]

        uri = c.uri_for(c.controller('Job').action_for('overview'), [project.name, jobset.name, job.name])

[100.286]

[101.13689]

        uri = c.uri_for(c.controller('Job').action_for('overview'), [project.name, jobset.name, job])

Replacement in src/root/topbar.tt at line 74 [99.6671]

∅:D[100.313] → [101.13745:13847]

B:BD[101.13745] → [101.13745:13847]

        uri = c.uri_for(c.controller('Job').action_for('all'), [project.name, jobset.name, job.name])

[100.313]

[85.246]

        uri = c.uri_for(c.controller('Job').action_for('all'), [project.name, jobset.name, job])

Replacement in src/root/topbar.tt at line 76 [99.6671]

B:BD[96.401] → [96.401:525]

      [% INCLUDE menuItem uri = c.uri_for('/job' project.name jobset.name job.name 'channel' 'latest') title = "Channel" %]

[85.281]

[101.14414]

      [% INCLUDE menuItem uri = c.uri_for('/job' project.name jobset.name job 'channel' 'latest') title = "Channel" %]

Deletion in src/script/hydra-eval-jobset at line 350 [103.1319]
B:BD[102.768] → [14.365:365]

Deletion in src/script/hydra-eval-jobset at line 405 [103.1319]

∅:D[104.1110] → [105.0:210]

B:BD[106.13396] → [105.0:210]

∅:D[105.210] → [106.13469:13470]

B:BD[106.13469] → [106.13469:13470]

        my $job = $jobset->jobs->update_or_create({
            name => $jobName,
            jobset_id => $jobset->id,
            project => $jobset->project,
            jobset => $jobset->name,
        });

Replacement in src/script/hydra-eval-jobset at line 448 [103.1319]
B:BD[106.15673] → [106.15673:15712]
```
        $build = $job->builds->create(
```
[106.15673]
[106.15712]
```
        $build = $jobset->builds->create(
```
Insertion in src/script/hydra-eval-jobset at line 453 [103.1319]
[11.119]
[106.15745]
```
            , job => $jobName
```

Deletion in src/sql/hydra.sql at line 134 [103.1]

B:BD[63.6811] → [63.6811:6902]

B:BD[63.6902] → [60.308:344]

∅:D[60.344] → [63.6902:6935]

∅:D[59.1317] → [63.6902:6935]

B:BD[63.6902] → [63.6902:6935]

B:BD[63.7063] → [63.7063:7064]

B:BD[63.7273] → [63.7273:7316]

B:BD[63.7316] → [59.1318:1390]

∅:D[59.1390] → [63.7316:7513]

B:BD[63.7316] → [63.7316:7513]

);
create table Jobs (
    project       text not null,
    jobset        text not null,
    jobset_id     integer not null,
    name          text not null,
    primary key   (project, jobset, name),
    foreign key   (jobset_id) references Jobsets(id) on delete cascade,
    foreign key   (project) references Projects(name) on delete cascade on update cascade,
    foreign key   (project, jobset) references Jobsets(project, name) on delete cascade on update cascade

Replacement in src/sql/hydra.sql at line 216 [103.1]

B:BD[107.1602] → [107.1602:1785]

    foreign key (project, jobset) references Jobsets(project, name) on update cascade,
    foreign key (project, jobset, job) references Jobs(project, jobset, name) on update cascade

[107.1602]

[108.2526]

    foreign key (project, jobset) references Jobsets(project, name) on update cascade

Replacement in src/sql/hydra.sql at line 360 [103.1]

B:BD[36.9910] → [36.9910:10097]

    foreign key   (project, jobset) references Jobsets(project, name) on update cascade,
    foreign key   (project, jobset, job) references Jobs(project, jobset, name) on update cascade

[36.9910]

[36.10097]

    foreign key   (project, jobset) references Jobsets(project, name) on update cascade

Replacement in src/sql/hydra.sql at line 533 [103.1]

B:BD[34.8275] → [34.8275:8498]

    foreign key   (project, jobset) references Jobsets(project, name) on update cascade on delete cascade,
    foreign key   (project, jobset, job) references Jobs(project, jobset, name) on update cascade on delete cascade

[34.8275]

[109.4069]

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

Deletion in src/sql/update-dbix.pl at line 25 [69.1755]
B:BD[58.10537] → [58.10537:10567]
```
            "jobs" => "Jobs",
```

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

[52.3004]

alter table Builds drop constraint builds_project_fkey2;
alter table BuildMetrics drop constraint buildmetrics_project_fkey2;
alter table StarredJobs drop constraint starredjobs_project_fkey2;
drop table Jobs;

Replacement in tests/evaluation-tests.pl at line 28 [112.804]

B:BD[110.906] → [111.0:103]

    ok(runBuild($build), "Build '".$build->job->name."' from jobs/basic.nix should exit with code 0");

[110.906]

[111.103]

    ok(runBuild($build), "Build '".$build->job."' from jobs/basic.nix should exit with code 0");

Replacement in tests/evaluation-tests.pl at line 30 [112.804]

B:BD[111.166] → [113.1859:1957]

∅:D[113.1957] → [111.223:383]

B:BD[111.223] → [111.223:383]

    my $expected = $build->job->name eq "fails" ? 1 : $build->job->name =~ /with_failed/ ? 6 : 0;
    ok($newbuild->finished == 1 && $newbuild->buildstatus == $expected, "Build '".$build->job->name."' from jobs/basic.nix should have buildstatus $expected");

[111.166]

[110.1270]

    my $expected = $build->job eq "fails" ? 1 : $build->job =~ /with_failed/ ? 6 : 0;
    ok($newbuild->finished == 1 && $newbuild->buildstatus == $expected, "Build '".$build->job."' from jobs/basic.nix should have buildstatus $expected");

Replacement in tests/evaluation-tests.pl at line 40 [112.804]

B:BD[114.245] → [111.384:487]

    ok(runBuild($build), "Build '".$build->job->name."' from jobs/basic.nix should exit with code 0");

[114.245]

[111.487]

    ok(runBuild($build), "Build '".$build->job."' from jobs/basic.nix should exit with code 0");

Replacement in tests/evaluation-tests.pl at line 42 [112.804]

B:BD[111.550] → [111.550:694]

    ok($newbuild->finished == 1 && $newbuild->buildstatus == 0, "Build '".$build->job->name."' from jobs/basic.nix should have buildstatus 0");

[111.550]

[114.538]

    ok($newbuild->finished == 1 && $newbuild->buildstatus == 0, "Build '".$build->job."' from jobs/basic.nix should have buildstatus 0");

Replacement in tests/evaluation-tests.pl at line 48 [112.804]

B:BD[114.887] → [111.695:798]

    ok(runBuild($build), "Build '".$build->job->name."' from jobs/basic.nix should exit with code 0");

[114.887]

[111.798]

    ok(runBuild($build), "Build '".$build->job."' from jobs/basic.nix should exit with code 0");

Replacement in tests/evaluation-tests.pl at line 50 [112.804]

B:BD[111.861] → [111.861:1005]

    ok($newbuild->finished == 1 && $newbuild->buildstatus == 0, "Build '".$build->job->name."' from jobs/basic.nix should have buildstatus 0");

[111.861]

[114.1180]

    ok($newbuild->finished == 1 && $newbuild->buildstatus == 0, "Build '".$build->job."' from jobs/basic.nix should have buildstatus 0");

Replacement in tests/evaluation-tests.pl at line 161 [112.804]

B:BD[115.584] → [115.584:696]

    ok(runBuild($build), "Build '".$build->job->name."' from jobs/build-products.nix should exit with code 0");

[115.584]

[115.696]

    ok(runBuild($build), "Build '".$build->job."' from jobs/build-products.nix should exit with code 0");

Replacement in tests/evaluation-tests.pl at line 163 [112.804]

B:BD[115.759] → [115.759:917]

    ok($newbuild->finished == 1 && $newbuild->buildstatus == 0, "Build '".$build->job->name."' from jobs/build-products.nix should have buildstatus 0");

[115.759]

[115.917]

    ok($newbuild->finished == 1 && $newbuild->buildstatus == 0, "Build '".$build->job."' from jobs/build-products.nix should have buildstatus 0");

Replacement in tests/evaluation-tests.pl at line 167 [112.804]
B:BD[115.1052] → [115.1052:1097]
```
    
    if($build->job->name eq "simple") {
```
[115.1052]
[115.1097]
```
    if($build->job eq "simple") {
```
Replacement in tests/evaluation-tests.pl at line 170 [112.804]
B:BD[115.1209] → [115.1209:1260]
```
    } elsif ($build->job->name eq "with_spaces") {
```
[115.1209]
[115.1260]
```
    } elsif ($build->job eq "with_spaces") {
```

Remove the Jobs table

Dependencies

In channels

Change contents

Replacement in src/lib/Hydra/Controller/Build.pm at line 89 [18.1]

Replacement in src/lib/Hydra/Controller/Job.pm at line 27 [20.46]

Deletion in src/lib/Hydra/Controller/Job.pm at line 33 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 35 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 47 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 57 [20.46]

Deletion in src/lib/Hydra/Controller/Job.pm at line 66 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 70 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 74 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 81 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 91 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 93 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 108 [20.46]

Deletion in src/lib/Hydra/Controller/Job.pm at line 115 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 116 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 123 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 135 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 144 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 157 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 168 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 170 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 172 [20.46]

Replacement in src/lib/Hydra/Controller/Job.pm at line 183 [20.46]

Replacement in src/lib/Hydra/Controller/Root.pm at line 462 [43.804]

Insertion in src/lib/Hydra/Controller/Root.pm at line 466 [43.804]

Replacement in src/lib/Hydra/Controller/Root.pm at line 468 [43.804]

Replacement in src/lib/Hydra/Controller/Root.pm at line 470 [43.804]

Replacement in src/lib/Hydra/Controller/User.pm at line 342 [48.252]

Replacement in src/lib/Hydra/Controller/User.pm at line 345 [48.252]

Replacement in src/lib/Hydra/Helper/CatalystUtils.pm at line 49 [18.3469]

File deletion: Jobs.pm

Deletion in src/lib/Hydra/Schema/BuildMetrics.pm at line 74 [36.3245]

Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 97 [36.3245]

Deletion in src/lib/Hydra/Schema/BuildMetrics.pm at line 131 [36.3245]

Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 164 [36.3245]

Deletion in src/lib/Hydra/Schema/Builds.pm at line 76 [43.5202]

Replacement in src/lib/Hydra/Schema/Builds.pm at line 226 [43.5202]

Deletion in src/lib/Hydra/Schema/Builds.pm at line 439 [43.5202]