{"header":{"message":"* In the job status and error pages, show when the status of a job","description":" last changed.","timestamp":"2009-07-09T14:48:15Z","authors":[{"email":"e.dolstra@tudelft.nl","name":"Eelco Dolstra"}]},"hash":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC","authors":[],"deps":{"hashes":[["RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC","* In the job status and error pages, show when the status of a job"],["AA",null],["TCHEWSZLG3PX7JFBLYO5ASBYAGZU4TWUYZQGNXPHQ3J7DILQPYGAC","* The \"latest\" channel shouldn't contain inactive jobs."],["K4C6DNSM7ARO6I24TEXIAHJ4XM7P3MXTXEPXKGDEAKALBL4RJQVAC","changed queries for compatibility with postgresql"],["7ZSVXUGFXOI3BOJE37SXIT6MDN6AJRBCCJNEICYDMBJF5QOEY6BAC","sequence fix for postgresql"],["OG7BEM57MXPCG56IT5GODPFG77KZXWPXZ7OVZPWQQ56CRJ7KUE2QC",""],["UWVMQIAC2HQNSG2JQOPZGUOCQ5V2JFP2F7RCTF3WJLK7NHSD5PAAC","* Refactoring."],["SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC","* Big speed-up of the job status page and the channel generation (such"],["7PYQLDQLHIFHIAZZKBEQ36QMRNZFDWCAVCIHYO3V7JRV36AG5SBAC","Added sequences for auto increment primary key columns (for PostgreSQL)"],["YTSIRIMKV2EN6CMO6LFX5J3NBJJYWBJKYDU3Z53CGXCIWP3FYI2QC","* Separate job status and all builds pages."],["2AIIYGI54TEFYBCGWMUA7JG2DMJXBKMYUZ7CG6ETIXF4ENNP74CQC","* Show job status and all builds for a project."],["FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC","* Put the project-related actions in a separate controller. Put the"],["7Z3YOKCVJE242IDO4HQVOBBLHFOXXCQIBIKDIUXQLTU5LY5QAORQC","* PROCESS -> INCLUDE in most cases. INCLUDE does proper scoping of"],["EJFVQ33SDMTAQ7HIRGIX5NPPXKZJ3KCB7LFSPLQ5KRMDMK6XLE2QC","* In the job status page and the channels, pick the build with the"],["T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC","* Add some DB indices to make the /releases page much faster."],["FHF6IZJQPUQHY5QWQYRPZVDBRLHREWRHGNKVQDT7F3GQKKLZXJKQC","* Basic release management: releases are now dynamically computed as"],["75XUS62YF7OK4S45RCZ5OOASXEBIEDNDBYEEMOCBDHVXV4GA3NLQC","* Added a page to quickly see all failed builds and failed evaluations"],["DEMSSSB22UI2ZN26C56UYO4NZWMDCRYKLAQARGOTSORSDXX3ZNNQC","* Controller for jobs which inherits all actions in ListBuilds. So"],["ZD5AEKWMW6IFFW46BJEFRPXRWMXTKCM4CSES6YTUOY7DEUX3E7JQC","* Job status / error pages: show only active jobs."],["UUGBVEGYV3FUNL7D3ECA2DIMFHE2S5UQF4ACSLESX3M3NRYYE57AC","* Development notes."],["J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC","* Start of a basic Catalyst web interface."],["IK53RV4VGOHLCZGQCCIKPB45M3C7M7YMNBOJFBGZJ4LWIZNU4QNQC",""],["JLDUSNUOOQNL63BOPXIWZOWFRQ5X35RWG33PJB3J3KMR6QR7TN7QC","* Unify rendering of finished and scheduled builds."],["N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC","* Put info about logs / build products in the DB."]],"deps":["TCHEWSZLG3PX7JFBLYO5ASBYAGZU4TWUYZQGNXPHQ3J7DILQPYGAC","K4C6DNSM7ARO6I24TEXIAHJ4XM7P3MXTXEPXKGDEAKALBL4RJQVAC","7ZSVXUGFXOI3BOJE37SXIT6MDN6AJRBCCJNEICYDMBJF5QOEY6BAC","OG7BEM57MXPCG56IT5GODPFG77KZXWPXZ7OVZPWQQ56CRJ7KUE2QC"],"known":["YTSIRIMKV2EN6CMO6LFX5J3NBJJYWBJKYDU3Z53CGXCIWP3FYI2QC","2AIIYGI54TEFYBCGWMUA7JG2DMJXBKMYUZ7CG6ETIXF4ENNP74CQC","FHF6IZJQPUQHY5QWQYRPZVDBRLHREWRHGNKVQDT7F3GQKKLZXJKQC","FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC","DEMSSSB22UI2ZN26C56UYO4NZWMDCRYKLAQARGOTSORSDXX3ZNNQC","UWVMQIAC2HQNSG2JQOPZGUOCQ5V2JFP2F7RCTF3WJLK7NHSD5PAAC","7Z3YOKCVJE242IDO4HQVOBBLHFOXXCQIBIKDIUXQLTU5LY5QAORQC","T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC","SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC","75XUS62YF7OK4S45RCZ5OOASXEBIEDNDBYEEMOCBDHVXV4GA3NLQC","ZD5AEKWMW6IFFW46BJEFRPXRWMXTKCM4CSES6YTUOY7DEUX3E7JQC","EJFVQ33SDMTAQ7HIRGIX5NPPXKZJ3KCB7LFSPLQ5KRMDMK6XLE2QC","7PYQLDQLHIFHIAZZKBEQ36QMRNZFDWCAVCIHYO3V7JRV36AG5SBAC"]},"hunks":[{"Edit":{"inode":{"change":20,"pos":1},"path":"doc/dev-notes.txt","line":132,"atom":{"NewVertex":{"up_context":[{"change":5,"pos":275}],"down_context":[],"flag":"BLOCK","start":0,"end":558,"inode":{"change":20,"pos":1}}},"contents":[{"Add":{"text":"","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:0"}},{"Add":{"text":"* select x.project, x.jobset, x.job, x.system, x.id, x.timestamp, r.buildstatus, b.id, b.timestamp","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:99"}},{"Add":{"text":" from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 group by project, jobset, job, system) as a_","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:234"}},{"Add":{"text":" natural join Builds x","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:258"}},{"Add":{"text":" natural join BuildResultInfo r","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:291"}},{"Add":{"text":" left join Builds b on b.id =","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:322"}},{"Add":{"text":" (select max(id) from builds c","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:356"}},{"Add":{"text":" natural join buildresultinfo r2","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:393"}},{"Add":{"text":" where x.project = c.project and x.jobset = c.jobset and x.job = c.job and x.system = c.system","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:492"}},{"Add":{"text":" and x.id > c.id and r.buildstatus != r2.buildstatus);","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:557"}}]}},{"Replacement":{"inode":{"change":6,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":17,"ins":{"up_context":[{"change":6,"pos":261}],"down_context":[{"change":2,"pos":75}],"flag":"BLOCK","start":559,"end":571,"inode":{"change":6,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":6,"pos":261},"to":{"change":6,"start":261,"end":272},"introduced_by":6}],"inode":{"change":6,"pos":1}},"ins_contents":[{"Add":{"text":" });","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:570"}}],"del_contents":[{"Del":{"text":" })","pos":"ZD5AEKWMW6IFFW46BJEFRPXRWMXTKCM4CSES6YTUOY7DEUX3E7JQC:271"}}]}},{"Edit":{"inode":{"change":6,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":29,"atom":{"NewVertex":{"up_context":[{"change":6,"pos":166}],"down_context":[{"change":6,"pos":327}],"flag":"BLOCK","start":572,"end":800,"inode":{"change":6,"pos":1}}},"contents":[{"Add":{"text":" $latest = $latest->search(","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:602"}},{"Add":{"text":" {},","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:614"}},{"Add":{"text":" { '+select' => [\"me.statusChangeId\", \"me.statusChangeTime\"]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:682"}},{"Add":{"text":" , '+as' => [\"statusChangeId\", \"statusChangeTime\"]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:740"}},{"Add":{"text":" , order_by => \"statusChangeTime DESC\"","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:786"}},{"Add":{"text":" });","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:798"}},{"Add":{"text":"","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:799"}}]}},{"Replacement":{"inode":{"change":6,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":59,"ins":{"up_context":[{"change":6,"pos":534}],"down_context":[{"change":6,"pos":330}],"flag":"BLOCK","start":801,"end":879,"inode":{"change":6,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":6,"pos":534},"to":{"change":6,"start":417,"end":490},"introduced_by":6}],"inode":{"change":6,"pos":1}},"ins_contents":[{"Add":{"text":" [getJobStatus($self, $c)->search({'me.buildstatus' => {'!=' => 0}})];","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:878"}}],"del_contents":[{"Del":{"text":" [getJobStatus($self, $c)->search({buildstatus => {'!=' => 0}})];","pos":"ZD5AEKWMW6IFFW46BJEFRPXRWMXTKCM4CSES6YTUOY7DEUX3E7JQC:489"}}]}},{"Replacement":{"inode":{"change":21,"pos":5202},"path":"src/lib/Hydra/Schema/Builds.pm","line":196,"ins":{"up_context":[{"change":4,"pos":171}],"down_context":[{"change":6,"pos":165}],"flag":"BLOCK","start":880,"end":1004,"inode":{"change":21,"pos":5202}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":171},"to":{"change":4,"start":171,"end":290},"introduced_by":4}],"inode":{"change":21,"pos":5202}},"ins_contents":[{"Add":{"text":" my $hydradbi = getHydraDBPath;","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:914"}},{"Add":{"text":" if ($hydradbi =~ m/^dbi:Pg/) {","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:949"}},{"Add":{"text":" __PACKAGE__->sequence('builds_id_seq');","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:997"}},{"Add":{"text":" }","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1003"}}],"del_contents":[{"Del":{"text":" my $hydradbi = getHydraDBPath ;","pos":"7ZSVXUGFXOI3BOJE37SXIT6MDN6AJRBCCJNEICYDMBJF5QOEY6BAC:205"}},{"Del":{"text":" if ($hydradbi =~ m/^dbi:Pg/) {","pos":"7ZSVXUGFXOI3BOJE37SXIT6MDN6AJRBCCJNEICYDMBJF5QOEY6BAC:239"}},{"Del":{"text":" __PACKAGE__->sequence('builds_id_seq');","pos":"7ZSVXUGFXOI3BOJE37SXIT6MDN6AJRBCCJNEICYDMBJF5QOEY6BAC:285"}},{"Del":{"text":" }","pos":"7ZSVXUGFXOI3BOJE37SXIT6MDN6AJRBCCJNEICYDMBJF5QOEY6BAC:289"}}]}},{"Replacement":{"inode":{"change":21,"pos":5202},"path":"src/lib/Hydra/Schema/Builds.pm","line":213,"ins":{"up_context":[{"change":6,"pos":2536}],"down_context":[{"change":6,"pos":3029}],"flag":"BLOCK","start":1005,"end":1964,"inode":{"change":21,"pos":5202}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":6,"pos":2536},"to":{"change":3,"start":0,"end":481},"introduced_by":3}],"inode":{"change":21,"pos":5202}},"ins_contents":[{"Add":{"text":" my $joinWithStatusChange =","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1035"}},{"Add":{"text":" \"natural join BuildResultInfo r \" .","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1079"}},{"Add":{"text":" \"left join Builds b on b.id = \" .","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1121"}},{"Add":{"text":" \"(select max(id) from builds c natural join buildresultinfo r2 \" .","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1196"}},{"Add":{"text":" \" where x.project = c.project and x.jobset = c.jobset and x.job = c.job and x.system = c.system and \" .","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1309"}},{"Add":{"text":" \" x.id > c.id and r.buildstatus != r2.buildstatus)\";","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1373"}},{"Add":{"text":" makeSource('JobStatus' . $name, \"select *, b.id statusChangeId, b.timestamp statusChangeTime from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 $constraint group by project, jobset, job, system) as latest natural join Builds x $joinWithStatusChange\");","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1666"}},{"Add":{"text":" makeSource('LatestSucceeded' . $name, \"select * from (select project, jobset, job, system, max(id) as id from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) as latest natural join Builds x $joinWithStatusChange\");","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1963"}}],"del_contents":[{"Del":{"text":" makeSource('JobStatus' . $name, \"select * from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 $constraint group by project, jobset, job, system) as a natural join Builds\");","pos":"K4C6DNSM7ARO6I24TEXIAHJ4XM7P3MXTXEPXKGDEAKALBL4RJQVAC:212"}},{"Del":{"text":" makeSource('LatestSucceeded' . $name, \"select * from (select project, jobset, job, system, max(id) as id from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) as a natural join Builds\");","pos":"K4C6DNSM7ARO6I24TEXIAHJ4XM7P3MXTXEPXKGDEAKALBL4RJQVAC:480"}}]}},{"Edit":{"inode":{"change":22,"pos":2803},"path":"src/root/common.tt","line":76,"atom":{"NewVertex":{"up_context":[{"change":23,"pos":1059}],"down_context":[{"change":23,"pos":1059}],"flag":"BLOCK","start":1965,"end":2076,"inode":{"change":22,"pos":2803}}},"contents":[{"Add":{"text":" [% IF showStatusChange %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:1998"}},{"Add":{"text":" Last status change","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2057"}},{"Add":{"text":" [% END %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2075"}}]}},{"Edit":{"inode":{"change":22,"pos":2803},"path":"src/root/common.tt","line":111,"atom":{"NewVertex":{"up_context":[{"change":23,"pos":2103}],"down_context":[{"change":23,"pos":2103}],"flag":"BLOCK","start":2077,"end":2494,"inode":{"change":22,"pos":2803}}},"contents":[{"Add":{"text":" [% IF showStatusChange %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2112"}},{"Add":{"text":" ","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2127"}},{"Add":{"text":" [% IF build.get_column('statusChangeTime') %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2185"}},{"Add":{"text":" ","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2271"}},{"Add":{"text":" [% date.format(build.get_column('statusChangeTime'), '%Y-%m-%d %H:%M:%S') %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2364"}},{"Add":{"text":" ","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2383"}},{"Add":{"text":" [% ELSE %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2406"}},{"Add":{"text":" never","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2435"}},{"Add":{"text":" [% END %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2457"}},{"Add":{"text":" ","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2473"}},{"Add":{"text":" [% END %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2493"}}]}},{"Replacement":{"inode":{"change":6,"pos":1442},"path":"src/root/errors.tt","line":70,"ins":{"up_context":[{"change":6,"pos":2872}],"down_context":[{"change":6,"pos":2922}],"flag":"BLOCK","start":2495,"end":2564,"inode":{"change":6,"pos":1442}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":6,"pos":2872},"to":{"change":6,"start":2872,"end":2922},"introduced_by":6}],"inode":{"change":6,"pos":1442}},"ins_contents":[{"Add":{"text":"[% INCLUDE renderBuildList builds=brokenBuilds showStatusChange=1 %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2563"}}],"del_contents":[{"Del":{"text":"[% INCLUDE renderBuildList builds=brokenBuilds %]","pos":"75XUS62YF7OK4S45RCZ5OOASXEBIEDNDBYEEMOCBDHVXV4GA3NLQC:2921"}}]}},{"Replacement":{"inode":{"change":6,"pos":1907},"path":"src/root/jobstatus.tt","line":6,"ins":{"up_context":[{"change":6,"pos":1997}],"down_context":[{"change":6,"pos":2046}],"flag":"BLOCK","start":2565,"end":2833,"inode":{"change":6,"pos":1907}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":6,"pos":1997},"to":{"change":6,"start":1997,"end":2046},"introduced_by":6}],"inode":{"change":6,"pos":1907}},"ins_contents":[{"Add":{"text":"

Below are the latest builds for each job. It is ordered by the status","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2638"}},{"Add":{"text":"change time (the timestamp of the last build that had a different","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2704"}},{"Add":{"text":"build result status). That is, it shows the jobs that most recently","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2773"}},{"Add":{"text":"changed from failed to successful or vice versa first.

","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2832"}}],"del_contents":[{"Del":{"text":"

Below are the latest builds for each job.

","pos":"YTSIRIMKV2EN6CMO6LFX5J3NBJJYWBJKYDU3Z53CGXCIWP3FYI2QC:2045"}}]}},{"Replacement":{"inode":{"change":6,"pos":1907},"path":"src/root/jobstatus.tt","line":11,"ins":{"up_context":[{"change":6,"pos":2047}],"down_context":[{"change":6,"pos":2097}],"flag":"BLOCK","start":2834,"end":2903,"inode":{"change":6,"pos":1907}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":6,"pos":2047},"to":{"change":6,"start":1401,"end":1451},"introduced_by":6}],"inode":{"change":6,"pos":1907}},"ins_contents":[{"Add":{"text":"[% INCLUDE renderBuildList builds=latestBuilds showStatusChange=1 %]","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2902"}}],"del_contents":[{"Del":{"text":"[% INCLUDE renderBuildList builds=latestBuilds %]","pos":"7Z3YOKCVJE242IDO4HQVOBBLHFOXXCQIBIKDIUXQLTU5LY5QAORQC:1450"}}]}},{"Replacement":{"inode":{"change":24,"pos":1},"path":"src/sql/hydra.sql","line":410,"ins":{"up_context":[{"change":6,"pos":3395}],"down_context":[],"flag":"BLOCK","start":2904,"end":3104,"inode":{"change":24,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":6,"pos":3395},"to":{"change":6,"start":3395,"end":3477},"introduced_by":6}],"inode":{"change":24,"pos":1}},"ins_contents":[{"Add":{"text":"create index IndexBuildsByJobAndSystem on Builds(project, jobset, job, system);","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:2983"}},{"Add":{"text":"create index IndexBuildResultInfo on BuildResultInfo(id); -- primary key index, not created automatically by PostgreSQL","pos":"RAKTHYAIX757GPYWCHOE5H5RD3QYKQW3QKLWUIUKPHQ5QGWQXWQQC:3103"}}],"del_contents":[{"Del":{"text":"--create index IndexBuildsByJobAndSystem on Builds(project, jobset, job, system);","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3476"}}]}}],"owner":"grahamc","repo":"hydra2","token":"98IUrGvpIEPyf9k/6w7VTHSw0/V3maySee8/MdmhaOo=","login":null}

…

Dependencies

Change contents

Review