grahamc/hydra2 - Change MESO2HDVD2JAL7S2YTKTO5LOCW6LNJY5PCIBRJVUSMZ6RL5LLZBAC

Remove obsolete JobStatus source

Created by Eelco Dolstra on October 3, 2013

MESO2HDVD2JAL7S2YTKTO5LOCW6LNJY5PCIBRJVUSMZ6RL5LLZBAC

Dependencies

In channels

main

Change contents

Deletion in src/lib/Hydra/Controller/Job.pm at line 74 [6.46]

B:BD[4.419] → [5.390:578]

    $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForJob')
        ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name, $c->stash->{job}->name]});

Deletion in src/lib/Hydra/Controller/Jobset.pm at line 186 [8.104]

B:BD[7.535] → [5.779:946]

    $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForJobset')
        ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name]});

Deletion in src/lib/Hydra/Controller/Project.pm at line 205 [9.1245]

B:BD[4.1034] → [5.1126:1267]

    $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForProject')
        ->search({}, {bind => [$c->stash->{project}->name]});

Deletion in src/lib/Hydra/Controller/Root.pm at line 153 [10.804]
B:BD[9.9650] → [5.1421:1491]
```
    $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatus');
```

Deletion in src/lib/Hydra/Schema/Builds.pm at line 578 [10.5202]

∅:D[11.732] → [12.408:553]

B:BD[12.408] → [12.408:553]

B:BD[12.553] → [13.6863:6941]

∅:D[13.6941] → [12.862:877]

B:BD[12.862] → [12.862:877]

B:BD[12.877] → [14.2619:2639]

∅:D[14.2639] → [13.6942:6989]

B:BD[15.323] → [13.6942:6989]

B:BD[13.6989] → [14.2640:2814]

∅:D[14.2814] → [15.545:603]

B:BD[15.545] → [15.545:603]

∅:D[16.302] → [11.733:777]

∅:D[15.603] → [11.733:777]

∅:D[17.10076] → [11.733:777]

B:BD[12.941] → [11.733:777]

B:BD[11.777] → [15.604:663]

B:BD[15.663] → [13.6990:7417]

∅:D[13.7417] → [12.1122:1135]

B:BD[12.1122] → [12.1122:1135]


    makeSource(
        "JobStatus$name",
        # Urgh, can't use "*" in the "select" here because of the status change join.
        <<QUERY
          select x.*, b.id as statusChangeId, b.timestamp as statusChangeTime
          from
            (select
               (select max(b.id) from Builds b
                where
                  project = activeJobs.project and jobset = activeJobs.jobset
                  and job = activeJobs.job and system = activeJobs.system
                  and finished = 1
               ) as id
             from $activeJobs as activeJobs
            ) as latest
          join Builds x using (id)
          left join Builds b on
            b.id =
              (select max(c.id) from Builds c
               where
                 c.finished = 1 and
                 x.project = c.project and x.jobset = c.jobset and x.job = c.job and x.system = c.system and
                 x.id > c.id and
                   ((x.buildStatus = 0 and c.buildStatus != 0) or
                    (x.buildStatus != 0 and c.buildStatus = 0)))
QUERY
    );

Replacement in tests/query-all-tables.pl at line 10 [18.291]
B:BD[18.497] → [3.1185:1215]
```
use Test::Simple tests => 42;
```
[18.497]
[18.527]
```
use Test::Simple tests => 38;
```

Replacement in tests/query-all-tables.pl at line 16 [18.291]

B:BD[19.2376] → [2.0:59]

    } elsif( $source !~ m/^(LatestSucceeded|JobStatus)/) {

[19.2376]

[19.2446]

    } elsif( $source !~ m/^LatestSucceeded/) {