Remove obsolete JobStatus source

[?]

Oct 3, 2013, 1:05 PM

MESO2HDVD2JAL7S2YTKTO5LOCW6LNJY5PCIBRJVUSMZ6RL5LLZBAC

Dependencies

[2] 2FT4LEIP Remove unused ActiveJobs source
[3] L7RW467Z Add a test for darcs inputs.
[4] 2JQ7WEFM
[5] ZI535LI6 * hydra: 'new' UI for project/jobset/job/build
[6] R2PON6R7 Allow non-admin users to see the machine status page
[7] SZYY2EQQ * Make the queries more readable.
[8] 3PNG7NIB Remove trailing whitespace
[9] 3HEMN2Q2 * Speed up the jobstatus query a little bit.
[10] HPEG2RHV Merge the BuildResultInfo table into the Builds table
[11] C5XKS77N hydra: added missing fields to query
[12] FPK5LF53 * Put the project-related actions in a separate controller. Put the
[13] 6FRLEP4P first try for timeline of last 24 hours in hydra
[14] AK66K4KY Fix the test
[15] YDW2NUIW Fix "make check"
[16] P43FHUUV there are 43 tests
[17] E7FID72S Remove the BuildMachines and BuildMachinesSystemTypes tables
[18] VVOAXWH4 fix wrong dbix:class:loader generation
[19] WZ7PXAIT Doh
[20] RI4S7SYT * Job status: show the active jobs.
[21] EFWN7JBV * Added a status page that shows all the currently executing build steps.
[22] Z4KRJX4Q * In the last succeeded / job status queries, use the Builds.isCurrent
[23] JSG5QEZJ * Only show status changes from successful to failed and failed to
[24] 3HZY24CX * Make jobsets viewable under
[25] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
[26] 5SMQ2PLK Fix tests
[27] 4HPT4SDD Revert "Remove now-unused SystemTypes table"
[28] SJN2QPWH * Big speed-up of the job status page and the channel generation (such
[29] JD7AWXQG Remove now-unused SystemTypes table
[30] G2WXEQHE Remove the Errors page
[31] FANTYCR7 Materialize the number of finished builds
[32] OZ5UBJEK
[33] Q5HZWFCY Add support for darcs repositories.
[34] 75XUS62Y * Added a page to quickly see all failed builds and failed evaluations
[35] 3XM2QEGW Fix query-all-tables test count, there are more tables now
[36] G2ZB6464 first test, not yet in buildprocess
[37] S5NPXZG3 Fix indentation
[38] DES4PSRL add basic query tests for JobStatus/LatestSucceeded/ActiveJobs
[39] D6EL7KR6 Fix broken test
[40] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
[41] UWVMQIAC * Refactoring.
[42] FDHQ2OLB Forgot to commit
[43] DEMSSSB2 * Controller for jobs which inherits all actions in ListBuilds. So
[44] AKAZKCR6 * At top-level and for each project, provide two channels: "latest"
[*] J5UVLXOK * Start of a basic Catalyst web interface.

Change contents

edit in src/lib/Hydra/Controller/Job.pm at line 74

[4.419]→[4.390:578](∅→∅)

$c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForJob')
->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name, $c->stash->{job}->name]});
edit in src/lib/Hydra/Controller/Jobset.pm at line 186

[4.535]→[4.779:946](∅→∅)

$c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForJobset')
->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name]});
edit in src/lib/Hydra/Controller/Project.pm at line 205

[4.1034]→[4.1126:1267](∅→∅)

$c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForProject')
->search({}, {bind => [$c->stash->{project}->name]});
edit in src/lib/Hydra/Controller/Root.pm at line 153

[4.9650]→[4.1421:1491](∅→∅)

$c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatus');
edit in src/lib/Hydra/Schema/Builds.pm at line 578

[4.732]→[4.408:553](∅→∅),[4.408]→[4.408:553](∅→∅),[4.553]→[4.6863:6941](∅→∅),[4.6941]→[4.862:877](∅→∅),[4.862]→[4.862:877](∅→∅),[4.877]→[4.2619:2639](∅→∅),[4.2639]→[4.6942:6989](∅→∅),[4.323]→[4.6942:6989](∅→∅),[4.6989]→[4.2640:2814](∅→∅),[4.2814]→[4.545:603](∅→∅),[4.545]→[4.545:603](∅→∅),[4.302]→[4.733:777](∅→∅),[4.603]→[4.733:777](∅→∅),[4.10076]→[4.733:777](∅→∅),[4.941]→[4.733:777](∅→∅),[4.777]→[4.604:663](∅→∅),[4.663]→[4.6990:7417](∅→∅),[4.7417]→[4.1122:1135](∅→∅),[4.1122]→[4.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

[4.497]→[3.1185:1215](∅→∅)

use Test::Simple tests => 42;

[4.497]

[4.527]

use Test::Simple tests => 38;
replacement in tests/query-all-tables.pl at line 16

[4.2376]→[2.0:59](∅→∅)

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

[4.2376]

[4.2446]

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