{"header":{"message":"* Store build duration, handle cached builds.","description":null,"timestamp":"2008-10-28T17:08:29Z","authors":[{"email":"e.dolstra@tudelft.nl","name":"Eelco Dolstra"}]},"hash":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC","authors":[],"deps":{"hashes":[["WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC","* Store build duration, handle cached builds."],["AA",null],["N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC","* Put info about logs / build products in the DB."],["UVMFS73TI6RARMAAGY2UVS5LCPZUKLQECXQQVER4F7S4BNUXQQ3AC","* Some jQuery / CSS hackery."],["J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC","* Start of a basic Catalyst web interface."],["ELCI5T2ALF37VXYM5POHPO3CAMMPRB65BXGDRVUAZG53NKKLGIEAC","* Show the latest build for each job."]],"deps":["N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC","UVMFS73TI6RARMAAGY2UVS5LCPZUKLQECXQQVER4F7S4BNUXQQ3AC"],"known":["J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC","ELCI5T2ALF37VXYM5POHPO3CAMMPRB65BXGDRVUAZG53NKKLGIEAC"]},"hunks":[{"Replacement":{"inode":{"change":4,"pos":804},"path":"src/HydraFrontend/lib/HydraFrontend/Controller/Root.pm","line":34,"ins":{"up_context":[{"change":4,"pos":109}],"down_context":[{"change":3,"pos":0}],"flag":"BLOCK","start":0,"end":303,"inode":{"change":4,"pos":804}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":109},"to":{"change":4,"start":109,"end":397},"introduced_by":4}],"inode":{"change":4,"pos":804}},"ins_contents":[{"Add":{"text":" # select * from builds as x where timestamp == (select max(timestamp) from builds where jobName == x.jobName);","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:114"}},{"Add":{"text":" $c->stash->{latestBuilds} = [$c->model('DB::Builds')->search(undef, {order_by => \"jobName\", where => \"timestamp == (select max(timestamp) from builds where jobName == me.jobName)\"})];","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:302"}}],"del_contents":[{"Del":{"text":" # select * from builds as x where timestamp == (select max(timestamp) from builds where name == x.name);","pos":"ELCI5T2ALF37VXYM5POHPO3CAMMPRB65BXGDRVUAZG53NKKLGIEAC:217"}},{"Del":{"text":" $c->stash->{latestBuilds} = [$c->model('DB::Builds')->search(undef, {order_by => \"name\", where => \"timestamp == (select max(timestamp) from builds where name == me.name)\"})];","pos":"ELCI5T2ALF37VXYM5POHPO3CAMMPRB65BXGDRVUAZG53NKKLGIEAC:396"}}]}},{"Replacement":{"inode":{"change":4,"pos":804},"path":"src/HydraFrontend/lib/HydraFrontend/Controller/Root.pm","line":43,"ins":{"up_context":[{"change":3,"pos":133}],"down_context":[{"change":4,"pos":1507}],"flag":"BLOCK","start":304,"end":420,"inode":{"change":4,"pos":804}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":133},"to":{"change":3,"start":133,"end":246},"introduced_by":3}],"inode":{"change":4,"pos":804}},"ins_contents":[{"Add":{"text":" $c->stash->{builds} = [$c->model('DB::Builds')->search({jobName => $jobName}, {order_by => \"timestamp DESC\"})];","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:419"}}],"del_contents":[{"Del":{"text":" $c->stash->{builds} = [$c->model('DB::Builds')->search({name => $jobName}, {order_by => \"timestamp DESC\"})];","pos":"UVMFS73TI6RARMAAGY2UVS5LCPZUKLQECXQQVER4F7S4BNUXQQ3AC:245"}}]}},{"Replacement":{"inode":{"change":4,"pos":3352},"path":"src/HydraFrontend/lib/HydraFrontend/Schema/Buildlogs.pm","line":28,"ins":{"up_context":[{"change":4,"pos":3992}],"down_context":[{"change":4,"pos":4134}],"flag":"BLOCK","start":421,"end":563,"inode":{"change":4,"pos":3352}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":3992},"to":{"change":4,"start":3992,"end":4134},"introduced_by":4}],"inode":{"change":4,"pos":3352}},"ins_contents":[{"Add":{"text":"# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-28 17:59:29","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:492"}},{"Add":{"text":"# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xXiHLBKW5fHl7ukdYeIsTw","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:562"}}],"del_contents":[{"Del":{"text":"# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-25 22:23:27","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:4063"}},{"Del":{"text":"# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:01Br5qFsV84USpzqnjk7cw","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:4133"}}]}},{"Replacement":{"inode":{"change":4,"pos":4268},"path":"src/HydraFrontend/lib/HydraFrontend/Schema/Buildproducts.pm","line":28,"ins":{"up_context":[{"change":4,"pos":4922}],"down_context":[{"change":4,"pos":5064}],"flag":"BLOCK","start":564,"end":706,"inode":{"change":4,"pos":4268}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":4922},"to":{"change":4,"start":4922,"end":5064},"introduced_by":4}],"inode":{"change":4,"pos":4268}},"ins_contents":[{"Add":{"text":"# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-28 17:59:29","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:635"}},{"Add":{"text":"# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5SPq4at2/NRvbax49TwfDw","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:705"}}],"del_contents":[{"Del":{"text":"# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-25 22:23:27","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:4993"}},{"Del":{"text":"# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jYe9p4xG2Ujnf6TsfeE7tA","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:5063"}}]}},{"Replacement":{"inode":{"change":4,"pos":5202},"path":"src/HydraFrontend/lib/HydraFrontend/Schema/Builds.pm","line":15,"ins":{"up_context":[{"change":4,"pos":5538}],"down_context":[{"change":4,"pos":5548}],"flag":"BLOCK","start":707,"end":720,"inode":{"change":4,"pos":5202}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":5538},"to":{"change":4,"start":5538,"end":5548},"introduced_by":4}],"inode":{"change":4,"pos":5202}},"ins_contents":[{"Add":{"text":" \"jobname\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:719"}}],"del_contents":[{"Del":{"text":" \"name\",","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:5547"}}]}},{"Edit":{"inode":{"change":4,"pos":5202},"path":"src/HydraFrontend/lib/HydraFrontend/Schema/Builds.pm","line":23,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":5831}],"down_context":[{"change":4,"pos":5831}],"flag":"BLOCK","start":721,"end":803,"inode":{"change":4,"pos":5202}}},"contents":[{"Add":{"text":" \"iscachedbuild\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:739"}},{"Add":{"text":" { data_type => \"integer\", is_nullable => 0, size => undef },","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:802"}}]}},{"Edit":{"inode":{"change":4,"pos":5202},"path":"src/HydraFrontend/lib/HydraFrontend/Schema/Builds.pm","line":27,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":5911}],"down_context":[{"change":4,"pos":5911}],"flag":"BLOCK","start":804,"end":1033,"inode":{"change":4,"pos":5202}}},"contents":[{"Add":{"text":" \"errormsg\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:817"}},{"Add":{"text":" { data_type => \"text\", is_nullable => 0, size => undef },","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:877"}},{"Add":{"text":" \"starttime\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:892"}},{"Add":{"text":" { data_type => \"integer\", is_nullable => 0, size => undef },","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:955"}},{"Add":{"text":" \"stoptime\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:969"}},{"Add":{"text":" { data_type => \"integer\", is_nullable => 0, size => undef },","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1032"}}]}},{"Replacement":{"inode":{"change":4,"pos":5202},"path":"src/HydraFrontend/lib/HydraFrontend/Schema/Builds.pm","line":36,"ins":{"up_context":[{"change":4,"pos":5973}],"down_context":[{"change":4,"pos":6026}],"flag":"BLOCK","start":1034,"end":1095,"inode":{"change":4,"pos":5202}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":5973},"to":{"change":4,"start":5973,"end":6026},"introduced_by":4}],"inode":{"change":4,"pos":5202}},"ins_contents":[{"Add":{"text":" \"buildproducts\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1052"}},{"Add":{"text":" \"HydraFrontend::Schema::Buildproducts\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1094"}}],"del_contents":[{"Del":{"text":" \"buildlogs\",","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:5987"}},{"Del":{"text":" \"HydraFrontend::Schema::Buildlogs\",","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:6025"}}]}},{"Replacement":{"inode":{"change":4,"pos":5202},"path":"src/HydraFrontend/lib/HydraFrontend/Schema/Builds.pm","line":41,"ins":{"up_context":[{"change":4,"pos":6090}],"down_context":[{"change":4,"pos":6151}],"flag":"BLOCK","start":1096,"end":1149,"inode":{"change":4,"pos":5202}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":6090},"to":{"change":4,"start":6090,"end":6151},"introduced_by":4}],"inode":{"change":4,"pos":5202}},"ins_contents":[{"Add":{"text":" \"buildlogs\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1110"}},{"Add":{"text":" \"HydraFrontend::Schema::Buildlogs\",","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1148"}}],"del_contents":[{"Del":{"text":" \"buildproducts\",","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:6108"}},{"Del":{"text":" \"HydraFrontend::Schema::Buildproducts\",","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:6150"}}]}},{"Replacement":{"inode":{"change":4,"pos":5202},"path":"src/HydraFrontend/lib/HydraFrontend/Schema/Builds.pm","line":47,"ins":{"up_context":[{"change":4,"pos":6194}],"down_context":[{"change":4,"pos":6336}],"flag":"BLOCK","start":1150,"end":1292,"inode":{"change":4,"pos":5202}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":6194},"to":{"change":4,"start":6194,"end":6336},"introduced_by":4}],"inode":{"change":4,"pos":5202}},"ins_contents":[{"Add":{"text":"# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-28 17:59:29","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1221"}},{"Add":{"text":"# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gp6ZZpDA2VzgnNE9NX99dA","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1291"}}],"del_contents":[{"Del":{"text":"# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-25 22:23:27","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:6265"}},{"Del":{"text":"# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gxVH+2KWcgU41JOl9BbHFA","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:6335"}}]}},{"Replacement":{"inode":{"change":4,"pos":6376},"path":"src/HydraFrontend/lib/HydraFrontend/Schema.pm","line":11,"ins":{"up_context":[{"change":4,"pos":6498}],"down_context":[{"change":4,"pos":6640}],"flag":"BLOCK","start":1293,"end":1435,"inode":{"change":4,"pos":6376}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":6498},"to":{"change":4,"start":6498,"end":6640},"introduced_by":4}],"inode":{"change":4,"pos":6376}},"ins_contents":[{"Add":{"text":"# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-28 17:59:29","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1364"}},{"Add":{"text":"# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Fayli8dtSdcAYhfKSZnJwg","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1434"}}],"del_contents":[{"Del":{"text":"# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-25 22:23:27","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:6569"}},{"Del":{"text":"# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iW1lrJQVyiDiAYhJBy9/iQ","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:6639"}}]}},{"Replacement":{"inode":{"change":4,"pos":7350},"path":"src/HydraFrontend/root/build.tt","line":15,"ins":{"up_context":[{"change":4,"pos":7565}],"down_context":[{"change":4,"pos":7595}],"flag":"BLOCK","start":1436,"end":1469,"inode":{"change":4,"pos":7350}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":7565},"to":{"change":4,"start":7565,"end":7595},"introduced_by":4}],"inode":{"change":4,"pos":7350}},"ins_contents":[{"Add":{"text":" [% build.jobname %]","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1468"}}],"del_contents":[{"Del":{"text":" [% build.name %]","pos":"J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC:7594"}}]}},{"Edit":{"inode":{"change":4,"pos":7350},"path":"src/HydraFrontend/root/build.tt","line":24,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":7782}],"down_context":[{"change":4,"pos":7782}],"flag":"BLOCK","start":1470,"end":1684,"inode":{"change":4,"pos":7350}}},"contents":[{"Add":{"text":" ","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1477"}},{"Add":{"text":" ","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1484"}},{"Add":{"text":" Duration (seconds):","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1517"}},{"Add":{"text":" ","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1526"}},{"Add":{"text":" [% IF build.iscachedbuild %]","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1561"}},{"Add":{"text":" (cached build)","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1593"}},{"Add":{"text":" [% ELSE %]","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1610"}},{"Add":{"text":" [% build.stoptime - build.starttime %]","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1657"}},{"Add":{"text":" [% END %]","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1673"}},{"Add":{"text":" ","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1683"}}]}},{"Edit":{"inode":{"change":4,"pos":10713},"path":"src/HydraFrontend/root/index.tt","line":4,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":421}],"down_context":[{"change":4,"pos":421}],"flag":"BLOCK","start":1685,"end":1735,"inode":{"change":4,"pos":10713}}},"contents":[{"Add":{"text":"","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1685"}},{"Add":{"text":"

Below are the latest builds for each job.

","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1734"}}]}},{"Replacement":{"inode":{"change":3,"pos":2074},"path":"src/HydraFrontend/root/short-build-info.tt","line":12,"ins":{"up_context":[{"change":3,"pos":2345}],"down_context":[{"change":3,"pos":2431}],"flag":"BLOCK","start":1736,"end":1828,"inode":{"change":3,"pos":2074}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":2345},"to":{"change":3,"start":2345,"end":2431},"introduced_by":3}],"inode":{"change":3,"pos":2074}},"ins_contents":[{"Add":{"text":" [% build.jobname %]","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1827"}}],"del_contents":[{"Del":{"text":" [% build.name %]","pos":"UVMFS73TI6RARMAAGY2UVS5LCPZUKLQECXQQVER4F7S4BNUXQQ3AC:2430"}}]}},{"Replacement":{"inode":{"change":2,"pos":1},"path":"src/hydra.schema","line":4,"ins":{"up_context":[{"change":2,"pos":176}],"down_context":[{"change":2,"pos":209}],"flag":"BLOCK","start":1829,"end":1862,"inode":{"change":2,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":176},"to":{"change":2,"start":176,"end":209},"introduced_by":2}],"inode":{"change":2,"pos":1}},"ins_contents":[{"Add":{"text":" jobName text not null,","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1861"}}],"del_contents":[{"Del":{"text":" name text not null,","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:208"}}]}},{"Replacement":{"inode":{"change":2,"pos":1},"path":"src/hydra.schema","line":8,"ins":{"up_context":[{"change":2,"pos":299}],"down_context":[{"change":2,"pos":360}],"flag":"BLOCK","start":1863,"end":2170,"inode":{"change":2,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":299},"to":{"change":2,"start":299,"end":360},"introduced_by":2}],"inode":{"change":2,"pos":1}},"ins_contents":[{"Add":{"text":" isCachedBuild integer not null, -- boolean","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:1909"}},{"Add":{"text":" buildStatus integer, -- 0 = succeeded, 1 = Nix build failure, 2 = positive build failure","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2004"}},{"Add":{"text":" errorMsg text, -- error message in case of a Nix failure","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2070"}},{"Add":{"text":" startTime integer, -- in Unix time, 0 = used cached build result","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2143"}},{"Add":{"text":" stopTime integer","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2169"}}],"del_contents":[{"Del":{"text":" buildStatus integer -- 0 = succeeded, 1 = failure, ...","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:359"}}]}},{"Replacement":{"inode":{"change":2,"pos":1319},"path":"src/scheduler.pl","line":33,"ins":{"up_context":[{"change":2,"pos":2133}],"down_context":[{"change":2,"pos":2263}],"flag":"BLOCK","start":2171,"end":2304,"inode":{"change":2,"pos":1319}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":2133},"to":{"change":2,"start":2133,"end":2263},"introduced_by":2}],"inode":{"change":2,"pos":1319}},"ins_contents":[{"Add":{"text":" if (scalar(@{$dbh->selectall_arrayref(\"select * from builds where jobName = ? and outPath = ?\", {}, $jobName, $outPath)}) > 0) {","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2303"}}],"del_contents":[{"Del":{"text":" if (scalar(@{$dbh->selectall_arrayref(\"select * from builds where name = ? and outPath = ?\", {}, $jobName, $outPath)}) > 0) {","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:2262"}}]}},{"Edit":{"inode":{"change":2,"pos":1319},"path":"src/scheduler.pl","line":37,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":2317}],"down_context":[{"change":2,"pos":2317}],"flag":"BLOCK","start":2305,"end":2511,"inode":{"change":2,"pos":1319}}},"contents":[{"Add":{"text":"","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2305"}},{"Add":{"text":" my $isCachedBuild = 1;","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2332"}},{"Add":{"text":" my $buildStatus = 0;","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2357"}},{"Add":{"text":" my $startTime = 0;","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2380"}},{"Add":{"text":" my $stopTime = 0;","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2402"}},{"Add":{"text":" ","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2407"}},{"Add":{"text":" if (system(\"nix-store --check-validity $outPath 2> /dev/null\") != 0) {","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2482"}},{"Add":{"text":" $isCachedBuild = 0;","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2510"}}]}},{"Replacement":{"inode":{"change":2,"pos":1319},"path":"src/scheduler.pl","line":46,"ins":{"up_context":[{"change":2,"pos":2318}],"down_context":[{"change":2,"pos":2379}],"flag":"BLOCK","start":2512,"end":2636,"inode":{"change":2,"pos":1319}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":2318},"to":{"change":2,"start":2318,"end":2379},"introduced_by":2}],"inode":{"change":2,"pos":1319}},"ins_contents":[{"Add":{"text":" $startTime = time();","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2540"}},{"Add":{"text":"","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2541"}},{"Add":{"text":" my $res = system(\"nix-build $jobsFile --attr $jobName\");","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2606"}},{"Add":{"text":"","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2607"}},{"Add":{"text":" $stopTime = time();","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2635"}}],"del_contents":[{"Del":{"text":" my $res = system(\"nix-build $jobsFile --attr $jobName\");","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:2378"}}]}},{"Replacement":{"inode":{"change":2,"pos":1319},"path":"src/scheduler.pl","line":52,"ins":{"up_context":[{"change":2,"pos":2380}],"down_context":[{"change":2,"pos":2421}],"flag":"BLOCK","start":2637,"end":2685,"inode":{"change":2,"pos":1319}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":2380},"to":{"change":2,"start":2380,"end":2421},"introduced_by":2}],"inode":{"change":2,"pos":1319}},"ins_contents":[{"Add":{"text":" $buildStatus = $res == 0 ? 0 : 1;","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2678"}},{"Add":{"text":" }","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2684"}}],"del_contents":[{"Del":{"text":" my $buildStatus = $res == 0 ? 0 : 1;","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:2420"}}]}},{"Replacement":{"inode":{"change":2,"pos":1319},"path":"src/scheduler.pl","line":57,"ins":{"up_context":[{"change":2,"pos":2445}],"down_context":[{"change":2,"pos":2656}],"flag":"BLOCK","start":2686,"end":3001,"inode":{"change":2,"pos":1319}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":2445},"to":{"change":2,"start":2445,"end":2656},"introduced_by":2}],"inode":{"change":2,"pos":1319}},"ins_contents":[{"Add":{"text":" $dbh->prepare(\"insert into builds(timestamp, jobName, description, drvPath, outPath, isCachedBuild, buildStatus, errorMsg, startTime, stopTime) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\")","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:2872"}},{"Add":{"text":" ->execute(time(), $jobName, $description, $drvPath, $outPath, $isCachedBuild, $buildStatus, \"\", $startTime, $stopTime);","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:3000"}}],"del_contents":[{"Del":{"text":" $dbh->prepare(\"insert into builds(timestamp, name, description, drvPath, outPath, buildStatus) values(?, ?, ?, ?, ?, ?)\")","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:2570"}},{"Del":{"text":" ->execute(time(), $jobName, $description, $drvPath, $outPath, $buildStatus);","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:2655"}}]}},{"Edit":{"inode":{"change":2,"pos":1319},"path":"src/scheduler.pl","line":62,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":2763}],"down_context":[{"change":2,"pos":2763}],"flag":"BLOCK","start":3002,"end":3285,"inode":{"change":2,"pos":1319}}},"contents":[{"Add":{"text":"","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:3002"}},{"Add":{"text":" my $logPath = \"/nix/var/log/nix/drvs/\" . basename $drvPath;","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:3066"}},{"Add":{"text":" if (-e $logPath) {","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:3089"}},{"Add":{"text":" print \" LOG $logPath\\n\";","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:3123"}},{"Add":{"text":" $dbh->prepare(\"insert into buildLogs(buildId, logPhase, path, type) values(?, ?, ?, ?)\")","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:3220"}},{"Add":{"text":" ->execute($buildId, \"full\", $logPath, \"raw\");","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:3278"}},{"Add":{"text":" }","pos":"WYN733STK5DUQSWHSS6EYZK32KPZII64HLX4NS7TYUSFZ6AAFLGAC:3284"}}]}},{"Edit":{"inode":{"change":2,"pos":1319},"path":"src/scheduler.pl","line":75,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":2963},"to":{"change":2,"start":2963,"end":3270},"introduced_by":2}],"inode":{"change":2,"pos":1319}}},"contents":[{"Del":{"text":" my $logPath = \"/nix/var/log/nix/drvs/\" . basename $drvPath;","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:3030"}},{"Del":{"text":" if (-e $logPath) {","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:3057"}},{"Del":{"text":" print \" LOG $logPath\\n\";","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:3095"}},{"Del":{"text":" $dbh->prepare(\"insert into buildLogs(buildId, logPhase, path, type) values(?, ?, ?, ?)\")","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:3196"}},{"Del":{"text":" ->execute($buildId, \"full\", $logPath, \"raw\");","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:3258"}},{"Del":{"text":" }","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:3268"}},{"Del":{"text":"","pos":"N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC:3269"}}]}}],"owner":"grahamc","repo":"hydra2","login":null}

…

Dependencies

Change contents

Review