{"header":{"message":"* Big speed-up of the job status page and the channel generation (such","description":" as the manifest). The builds are now determined in one SQL query\n rather than a zillion ones.","timestamp":"2009-04-03T15:37:21Z","authors":[{"email":"e.dolstra@tudelft.nl","name":"Eelco Dolstra"}]},"hash":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC","authors":[],"deps":{"hashes":[["SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC","* Big speed-up of the job status page and the channel generation (such"],["AA",null],["U7G4EEQCKLDY5BKJ6KA5U5S5LOOEX53ESDHVAIDJUA2OBAX7T2UQC",""],["T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC","* Add some DB indices to make the /releases page much faster."],["CS7T2XFIISZ7TPQ6FFRIDYPR6BDCQHURP4JE4YKLI4OYSNWKZCHAC",""],["AKAZKCR6GFCZQBR2ZJSZEI3SXW4S25V7X7JGHUYNUITQQSAVAF5AC","* At top-level and for each project, provide two channels: \"latest\""],["ZRBXLKFOKTP3S3OABM2BRPAHS2RFLYZSEFCLGCAQ47WSFMWWPGJQC",""],["JLDUSNUOOQNL63BOPXIWZOWFRQ5X35RWG33PJB3J3KMR6QR7TN7QC","* Unify rendering of finished and scheduled builds."],["3HZY24CX4U2TO74HOY4YX3LBJIYF4DLXHCIY7J2RASAC4COMSMZAC","* Make jobsets viewable under"],["DEMSSSB22UI2ZN26C56UYO4NZWMDCRYKLAQARGOTSORSDXX3ZNNQC","* Controller for jobs which inherits all actions in ListBuilds. So"],["UWVMQIAC2HQNSG2JQOPZGUOCQ5V2JFP2F7RCTF3WJLK7NHSD5PAAC","* Refactoring."],["2AUODJBTW2UJ47UB3SREZ7O7UTTJDQ4AGUQMPZAI4F3Y6BUF6LUQC",""],["7UJ5YV4VUSXMKB57KKXDG6KLIXMQXO45VO5UTOT46BHQJBFZ7XKQC","* Provide a channel for each project containing all the latest"],["LBNVQXUBEZ45SOTGVXK5UEZXIAIZTJLWZNUYFI4JZ6J65N3KPDVQC","* Build the /build stuff in a separate controller."],["BHZXGT2HWAMFNVBUDG7VR5HNA2SUJBUSMWB7EHTECB4QJ5HVYANAC","* Channels: provide an index page that lists all the packages in the"],["3E6IP3R3JGH76PNGG7RCADV65KOV24HQXPXNLVVYIQ46AVYJRG3AC","* Add the name of the jobset to ReleaseSetJobs, otherwise we can't"],["FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC","* Put the project-related actions in a separate controller. Put the"],["2JQ7WEFMU5IPCUKLGRLVVT4MYMKVHJDZVMOOOPL6K5RLEZ532LGQC",""],["LVJKRTIK5WOWWAZ454B4DCCGETOIQJK5TLOWMZVNY2B4AEGF2GMAC","* Generate a Nix expression for the channel."],["RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC","* Job status: show the active jobs."],["JRU2LRPZ7PB2GHIY5FY2YW7KGFWPOMPGS6QGK7TE5HFHQQQ4YQIAC",""],["5NO7NCKTMM5ZW7JYOETUFOSWK2ACTXWDZGJAFXZN6L3OF6BFTNOQC","* Refactoring."],["J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC","* Start of a basic Catalyst web interface."],["L2E6EVE2RVFVDCUNRJ4CZYSQNS2DZUA5DTBETHBDUQUV2KQQRAOQC","* Merged the Build and Job tables."],["N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC","* Put info about logs / build products in the DB."]],"deps":["U7G4EEQCKLDY5BKJ6KA5U5S5LOOEX53ESDHVAIDJUA2OBAX7T2UQC","T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC"],"known":["2AUODJBTW2UJ47UB3SREZ7O7UTTJDQ4AGUQMPZAI4F3Y6BUF6LUQC","JLDUSNUOOQNL63BOPXIWZOWFRQ5X35RWG33PJB3J3KMR6QR7TN7QC","LBNVQXUBEZ45SOTGVXK5UEZXIAIZTJLWZNUYFI4JZ6J65N3KPDVQC","ZRBXLKFOKTP3S3OABM2BRPAHS2RFLYZSEFCLGCAQ47WSFMWWPGJQC","2JQ7WEFMU5IPCUKLGRLVVT4MYMKVHJDZVMOOOPL6K5RLEZ532LGQC","CS7T2XFIISZ7TPQ6FFRIDYPR6BDCQHURP4JE4YKLI4OYSNWKZCHAC","LVJKRTIK5WOWWAZ454B4DCCGETOIQJK5TLOWMZVNY2B4AEGF2GMAC","FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC","7UJ5YV4VUSXMKB57KKXDG6KLIXMQXO45VO5UTOT46BHQJBFZ7XKQC","BHZXGT2HWAMFNVBUDG7VR5HNA2SUJBUSMWB7EHTECB4QJ5HVYANAC","JRU2LRPZ7PB2GHIY5FY2YW7KGFWPOMPGS6QGK7TE5HFHQQQ4YQIAC","AKAZKCR6GFCZQBR2ZJSZEI3SXW4S25V7X7JGHUYNUITQQSAVAF5AC","DEMSSSB22UI2ZN26C56UYO4NZWMDCRYKLAQARGOTSORSDXX3ZNNQC","3E6IP3R3JGH76PNGG7RCADV65KOV24HQXPXNLVVYIQ46AVYJRG3AC","3HZY24CX4U2TO74HOY4YX3LBJIYF4DLXHCIY7J2RASAC4COMSMZAC","UWVMQIAC2HQNSG2JQOPZGUOCQ5V2JFP2F7RCTF3WJLK7NHSD5PAAC","RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC"]},"hunks":[{"Edit":{"inode":{"change":4,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":13,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":44},"to":{"change":4,"start":0,"end":37},"introduced_by":4}],"inode":{"change":4,"pos":1}}},"contents":[{"Del":{"text":" my $jobs = $c->stash->{allJobs};","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:36"}}]}},{"Replacement":{"inode":{"change":4,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":14,"ins":{"up_context":[{"change":4,"pos":69}],"down_context":[{"change":4,"pos":330}],"flag":"BLOCK","start":0,"end":63,"inode":{"change":4,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":69},"to":{"change":4,"start":69,"end":170},"introduced_by":4}],"inode":{"change":4,"pos":1}},"ins_contents":[{"Add":{"text":" [joinWithResultInfo($c, $c->stash->{jobStatus})->all];","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:62"}}],"del_contents":[{"Del":{"text":" getLatestBuilds($c, ref $jobs eq \"ARRAY\" ? $jobs : scalar $jobs->search({active => 1}), {});","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:169"}}]}},{"Replacement":{"inode":{"change":4,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":35,"ins":{"up_context":[{"change":4,"pos":823}],"down_context":[{"change":3,"pos":114}],"flag":"BLOCK","start":64,"end":147,"inode":{"change":4,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":823},"to":{"change":4,"start":823,"end":882},"introduced_by":4}],"inode":{"change":4,"pos":1}},"ins_contents":[{"Add":{"text":" $c->stash->{builds} = [joinWithResultInfo($c, $c->stash->{allBuilds})->search(","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:146"}}],"del_contents":[{"Del":{"text":" $c->stash->{builds} = [$c->stash->{allBuilds}->search(","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:881"}}]}},{"Replacement":{"inode":{"change":4,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":37,"ins":{"up_context":[{"change":3,"pos":141}],"down_context":[{"change":3,"pos":337}],"flag":"BLOCK","start":148,"end":187,"inode":{"change":4,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":141},"to":{"change":3,"start":141,"end":337},"introduced_by":3}],"inode":{"change":4,"pos":1}},"ins_contents":[{"Add":{"text":" { order_by => \"timestamp DESC\"","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:186"}}],"del_contents":[{"Del":{"text":" { join => 'resultInfo'","pos":"T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC:171"}},{"Del":{"text":" , '+select' => [\"resultInfo.buildstatus\", \"resultInfo.releasename\"]","pos":"T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC:247"}},{"Del":{"text":" , '+as' => [\"buildstatus\", \"releasename\"]","pos":"T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC:297"}},{"Del":{"text":" , order_by => \"timestamp DESC\"","pos":"T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC:336"}}]}},{"Replacement":{"inode":{"change":4,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":48,"ins":{"up_context":[{"change":4,"pos":289}],"down_context":[{"change":4,"pos":386}],"flag":"BLOCK","start":188,"end":258,"inode":{"change":4,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":289},"to":{"change":4,"start":171,"end":296},"introduced_by":4}],"inode":{"change":4,"pos":1}},"ins_contents":[{"Add":{"text":" getChannelData($c, scalar($c->stash->{latestSucceeded}));","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:257"}}],"del_contents":[{"Del":{"text":" getChannelData($c, getLatestBuilds($c, scalar $c->stash->{allJobs}->search({active => 1}), {buildStatus => 0}));","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:295"}}]}},{"Replacement":{"inode":{"change":4,"pos":1},"path":"src/lib/Hydra/Base/Controller/ListBuilds.pm","line":52,"ins":{"up_context":[{"change":4,"pos":514}],"down_context":[{"change":4,"pos":577}],"flag":"BLOCK","start":259,"end":323,"inode":{"change":4,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":514},"to":{"change":4,"start":514,"end":577},"introduced_by":4}],"inode":{"change":4,"pos":1}},"ins_contents":[{"Add":{"text":" getChannelData($c, scalar($c->stash->{allBuilds}));","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:322"}}],"del_contents":[{"Del":{"text":" getChannelData($c, [$c->stash->{allBuilds}->all]);","pos":"AKAZKCR6GFCZQBR2ZJSZEI3SXW4S25V7X7JGHUYNUITQQSAVAF5AC:576"}}]}},{"Replacement":{"inode":{"change":22,"pos":43},"path":"src/lib/Hydra/Base/Controller/NixChannel.pm","line":68,"ins":{"up_context":[{"change":4,"pos":78}],"down_context":[{"change":2,"pos":0}],"flag":"BLOCK","start":324,"end":389,"inode":{"change":22,"pos":43}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":78},"to":{"change":4,"start":78,"end":141},"introduced_by":4}],"inode":{"change":22,"pos":43}},"ins_contents":[{"Add":{"text":" return $build->get_column('releasename') || $build->nixname;","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:388"}}],"del_contents":[{"Del":{"text":" return $build->resultInfo->releasename || $build->nixname;","pos":"BHZXGT2HWAMFNVBUDG7VR5HNA2SUJBUSMWB7EHTECB4QJ5HVYANAC:140"}}]}},{"Replacement":{"inode":{"change":4,"pos":46},"path":"src/lib/Hydra/Controller/Job.pm","line":33,"ins":{"up_context":[{"change":4,"pos":419}],"down_context":[{"change":4,"pos":799}],"flag":"BLOCK","start":390,"end":778,"inode":{"change":4,"pos":46}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":419},"to":{"change":4,"start":297,"end":476},"introduced_by":4}],"inode":{"change":4,"pos":46}},"ins_contents":[{"Add":{"text":" $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForJob')","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:464"}},{"Add":{"text":" ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name, $c->stash->{job}->name]});","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:577"}},{"Add":{"text":" $c->stash->{latestSucceeded} = $c->model('DB')->resultset('LatestSucceededForJob')","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:664"}},{"Add":{"text":" ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name, $c->stash->{job}->name]});","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:777"}}],"del_contents":[{"Del":{"text":" #$c->stash->{allJobs} = # !!! horribly hacky","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:345"}},{"Del":{"text":" # $c->stash->{job}->jobset->jobs->search({name => $c->stash->{job}->name});","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:428"}},{"Del":{"text":" $c->stash->{allJobs} = [$c->stash->{job}];","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:475"}}]}},{"Replacement":{"inode":{"change":4,"pos":104},"path":"src/lib/Hydra/Controller/Jobset.pm","line":39,"ins":{"up_context":[{"change":4,"pos":535}],"down_context":[{"change":4,"pos":1029}],"flag":"BLOCK","start":779,"end":1125,"inode":{"change":4,"pos":104}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":535},"to":{"change":4,"start":535,"end":589},"introduced_by":4}],"inode":{"change":4,"pos":104}},"ins_contents":[{"Add":{"text":" $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForJobset')","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:856"}},{"Add":{"text":" ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name]});","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:945"}},{"Add":{"text":" $c->stash->{latestSucceeded} = $c->model('DB')->resultset('LatestSucceededForJobset')","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1035"}},{"Add":{"text":" ->search({}, {bind => [$c->stash->{project}->name, $c->stash->{jobset}->name]});","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1124"}}],"del_contents":[{"Del":{"text":" $c->stash->{allJobs} = $c->stash->{jobset}->jobs;","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:588"}}]}},{"Replacement":{"inode":{"change":4,"pos":1245},"path":"src/lib/Hydra/Controller/Project.pm","line":173,"ins":{"up_context":[{"change":4,"pos":1034}],"down_context":[{"change":4,"pos":1034}],"flag":"BLOCK","start":1126,"end":1420,"inode":{"change":4,"pos":1245}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":1034},"to":{"change":4,"start":590,"end":645},"introduced_by":4}],"inode":{"change":4,"pos":1245}},"ins_contents":[{"Add":{"text":" $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatusForProject')","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1204"}},{"Add":{"text":" ->search({}, {bind => [$c->stash->{project}->name]});","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1266"}},{"Add":{"text":" $c->stash->{latestSucceeded} = $c->model('DB')->resultset('LatestSucceededForProject')","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1357"}},{"Add":{"text":" ->search({}, {bind => [$c->stash->{project}->name]});","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1419"}}],"del_contents":[{"Del":{"text":" $c->stash->{allJobs} = $c->stash->{project}->jobs;","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:644"}}]}},{"Replacement":{"inode":{"change":23,"pos":804},"path":"src/lib/Hydra/Controller/Root.pm","line":228,"ins":{"up_context":[{"change":4,"pos":9650}],"down_context":[{"change":4,"pos":774}],"flag":"BLOCK","start":1421,"end":1573,"inode":{"change":23,"pos":804}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":9650},"to":{"change":4,"start":646,"end":696},"introduced_by":4}],"inode":{"change":23,"pos":804}},"ins_contents":[{"Add":{"text":" $c->stash->{jobStatus} = $c->model('DB')->resultset('JobStatus');","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1490"}},{"Add":{"text":" $c->stash->{latestSucceeded} = $c->model('DB')->resultset('LatestSucceeded');","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1572"}}],"del_contents":[{"Del":{"text":" $c->stash->{allJobs} = $c->model('DB::Jobs');","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:695"}}]}},{"Replacement":{"inode":{"change":4,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":10,"ins":{"up_context":[{"change":4,"pos":125}],"down_context":[{"change":4,"pos":9702}],"flag":"BLOCK","start":1574,"end":1635,"inode":{"change":4,"pos":3469}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":125},"to":{"change":4,"start":562,"end":620},"introduced_by":4}],"inode":{"change":4,"pos":3469}},"ins_contents":[{"Add":{"text":" getBuild getBuildStats joinWithResultInfo getChannelData","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1634"}}],"del_contents":[{"Del":{"text":" getBuild getBuildStats getLatestBuilds getChannelData","pos":"7UJ5YV4VUSXMKB57KKXDG6KLIXMQXO45VO5UTOT46BHQJBFZ7XKQC:619"}}]}},{"Edit":{"inode":{"change":4,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":44,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":10461},"to":{"change":4,"start":10461,"end":10525},"introduced_by":4},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":10525},"to":{"change":4,"start":697,"end":735},"introduced_by":4}],"inode":{"change":4,"pos":3469}}},"contents":[{"Del":{"text":"","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:10461"}},{"Del":{"text":"","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:10462"}},{"Del":{"text":"# Return the latest build for each job.","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:10502"}},{"Del":{"text":"sub getLatestBuilds {","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:10524"}},{"Del":{"text":" my ($c, $jobs, $extraAttrs) = @_;","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:734"}}]}},{"Edit":{"inode":{"change":4,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":45,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":10566},"to":{"change":4,"start":10566,"end":10584},"introduced_by":4}],"inode":{"change":4,"pos":3469}}},"contents":[{"Del":{"text":" my @res = ();","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:10583"}}]}},{"Replacement":{"inode":{"change":4,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":46,"ins":{"up_context":[{"change":4,"pos":10585}],"down_context":[{"change":4,"pos":783}],"flag":"BLOCK","start":1636,"end":1786,"inode":{"change":4,"pos":3469}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":10585},"to":{"change":4,"start":736,"end":783},"introduced_by":4}],"inode":{"change":4,"pos":3469}},"ins_contents":[{"Add":{"text":"# Add the releaseName and buildStatus attributes from the","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1693"}},{"Add":{"text":"# BuildResultInfo table for each build.","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1733"}},{"Add":{"text":"sub joinWithResultInfo {","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1758"}},{"Add":{"text":" my ($c, $source) = @_;","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1785"}}],"del_contents":[{"Del":{"text":" # !!! this could be done more efficiently.","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:782"}}]}},{"Replacement":{"inode":{"change":4,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":51,"ins":{"up_context":[{"change":4,"pos":784}],"down_context":[{"change":4,"pos":621}],"flag":"BLOCK","start":1787,"end":1997,"inode":{"change":4,"pos":3469}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":784},"to":{"change":4,"start":784,"end":1072},"introduced_by":4},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":1072},"to":{"change":3,"start":1175,"end":1417},"introduced_by":3},{"previous":"","flag":"DELETED","from":{"change":3,"pos":1417},"to":{"change":4,"start":1156,"end":1215},"introduced_by":3},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":1156},"to":{"change":4,"start":1156,"end":1215},"introduced_by":4},{"previous":"","flag":"DELETED","from":{"change":4,"pos":1215},"to":{"change":4,"start":11075,"end":11101},"introduced_by":4},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":11075},"to":{"change":4,"start":11075,"end":11101},"introduced_by":4}],"inode":{"change":4,"pos":3469}},"ins_contents":[{"Add":{"text":" return $source->search(","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1814"}},{"Add":{"text":" { },","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1827"}},{"Add":{"text":" { join => 'resultInfo'","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1858"}},{"Add":{"text":" , '+select' => [\"resultInfo.releasename\", \"resultInfo.buildstatus\"]","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1934"}},{"Add":{"text":" , '+as' => [\"releasename\", \"buildstatus\"]","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1984"}},{"Add":{"text":" });","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1996"}}],"del_contents":[{"Del":{"text":" foreach my $job (ref $jobs eq \"ARRAY\" ? @{$jobs} : $jobs->all) {","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:852"}},{"Del":{"text":" foreach my $system ($job->builds->search({}, {select => ['system'], distinct => 1})) {","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:947"}},{"Del":{"text":" my ($build) = $job->builds->search(","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:995"}},{"Del":{"text":" { finished => 1, system => $system->system, %$extraAttrs },","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:1071"}},{"Del":{"text":" { join => 'resultInfo', order_by => 'timestamp DESC', rows => 1","pos":"T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC:1254"}},{"Del":{"text":" , '+select' => [\"resultInfo.releasename\", \"resultInfo.buildstatus\"]","pos":"T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC:1338"}},{"Del":{"text":" , '+as' => [\"releasename\", \"buildstatus\"]","pos":"T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC:1396"}},{"Del":{"text":" });","pos":"T2232OBSNVDGHY46RY5BBB2IET5LV5OLKSSBDYUF7KAEDBUOTC7QC:1416"}},{"Del":{"text":" push @res, $build if defined $build;","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:1204"}},{"Del":{"text":" }","pos":"RI4S7SYT3QKWCR2OBQ3RGVHWHRBGB6PKIEVGZYITV3FF6PF3CT6QC:1214"}},{"Del":{"text":" }","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:11080"}},{"Del":{"text":"","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:11081"}},{"Del":{"text":" return [@res];","pos":"FPK5LF53CFUEKFYJ3IYXT4UTVC6IITWJOCFATMC4PLHEUP5SIEAAC:11100"}}]}},{"Edit":{"inode":{"change":4,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":62,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":673}],"down_context":[{"change":4,"pos":673}],"flag":"BLOCK","start":1998,"end":2158,"inode":{"change":4,"pos":3469}}},"contents":[{"Add":{"text":"","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:1998"}},{"Add":{"text":" my @builds2 = joinWithResultInfo($c, $builds)","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2048"}},{"Add":{"text":" ->search_literal(\"exists (select 1 from buildproducts where build = me.id and type = 'nix-build')\");","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2157"}}]}},{"Replacement":{"inode":{"change":4,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":67,"ins":{"up_context":[{"change":4,"pos":774}],"down_context":[{"change":4,"pos":941}],"flag":"BLOCK","start":2159,"end":2194,"inode":{"change":4,"pos":3469}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":774},"to":{"change":4,"start":824,"end":861},"introduced_by":4},{"previous":"","flag":"DELETED","from":{"change":4,"pos":861},"to":{"change":4,"start":808,"end":941},"introduced_by":4},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":808},"to":{"change":4,"start":808,"end":941},"introduced_by":4}],"inode":{"change":4,"pos":3469}},"ins_contents":[{"Add":{"text":" foreach my $build (@builds2) {","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2193"}}],"del_contents":[{"Del":{"text":" foreach my $build (@{$builds}) {","pos":"AKAZKCR6GFCZQBR2ZJSZEI3SXW4S25V7X7JGHUYNUITQQSAVAF5AC:860"}},{"Del":{"text":" # !!! better do this in getLatestBuilds with a join.","pos":"7UJ5YV4VUSXMKB57KKXDG6KLIXMQXO45VO5UTOT46BHQJBFZ7XKQC:868"}},{"Del":{"text":" next unless $build->buildproducts->find({type => \"nix-build\"});","pos":"7UJ5YV4VUSXMKB57KKXDG6KLIXMQXO45VO5UTOT46BHQJBFZ7XKQC:940"}}]}},{"Edit":{"inode":{"change":23,"pos":5202},"path":"src/lib/Hydra/Schema/Builds.pm","line":104,"atom":{"NewVertex":{"up_context":[{"change":24,"pos":3770}],"down_context":[{"change":24,"pos":3770}],"flag":"BLOCK","start":2195,"end":3031,"inode":{"change":23,"pos":5202}}},"contents":[{"Add":{"text":"","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2195"}},{"Add":{"text":"","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2196"}},{"Add":{"text":"sub makeSource {","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2213"}},{"Add":{"text":" my ($name, $query) = @_;","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2242"}},{"Add":{"text":" my $source = __PACKAGE__->result_source_instance();","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2298"}},{"Add":{"text":" my $new_source = $source->new($source);","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2342"}},{"Add":{"text":" $new_source->source_name($name);","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2379"}},{"Add":{"text":" $new_source->name(\\ \"($query)\");","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2416"}},{"Add":{"text":" Hydra::Schema->register_extra_source($name => $new_source);","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2480"}},{"Add":{"text":"}","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2482"}},{"Add":{"text":"","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2483"}},{"Add":{"text":"sub makeQueries {","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2501"}},{"Add":{"text":" my ($name, $constraint) = @_;","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2535"}},{"Add":{"text":" makeSource('JobStatus' . $name, \"select * from (select project, jobset, job, system, max(timestamp) timestamp from Builds where finished = 1 $constraint group by project, jobset, job, system) natural join Builds\");","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:2754"}},{"Add":{"text":" makeSource('LatestSucceeded' . $name, \"select * from (select project, jobset, job, system, max(timestamp) timestamp from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) natural join Builds\");","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3028"}},{"Add":{"text":"}","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3030"}}]}},{"Edit":{"inode":{"change":23,"pos":5202},"path":"src/lib/Hydra/Schema/Builds.pm","line":121,"atom":{"NewVertex":{"up_context":[{"change":24,"pos":3771}],"down_context":[{"change":23,"pos":6337}],"flag":"BLOCK","start":3032,"end":3230,"inode":{"change":23,"pos":5202}}},"contents":[{"Add":{"text":"makeQueries('', \"\");","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3052"}},{"Add":{"text":"makeQueries('ForProject', \"and project = ?\");","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3098"}},{"Add":{"text":"makeQueries('ForJobset', \"and project = ? and jobset = ?\");","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3158"}},{"Add":{"text":"makeQueries('ForJob', \"and project = ? and jobset = ? and job = ?\");","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3227"}},{"Add":{"text":"","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3228"}},{"Add":{"text":"","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3229"}}]}},{"Replacement":{"inode":{"change":4,"pos":3375},"path":"src/root/channel-contents.tt","line":59,"ins":{"up_context":[{"change":4,"pos":4127}],"down_context":[{"change":4,"pos":4229}],"flag":"BLOCK","start":3231,"end":3336,"inode":{"change":4,"pos":3375}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":4127},"to":{"change":4,"start":4127,"end":4229},"introduced_by":4}],"inode":{"change":4,"pos":3375}},"ins_contents":[{"Add":{"text":" [% build.get_column('releasename') || build.nixname %]","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3335"}}],"del_contents":[{"Del":{"text":" [% build.resultInfo.releasename || build.nixname %]","pos":"BHZXGT2HWAMFNVBUDG7VR5HNA2SUJBUSMWB7EHTECB4QJ5HVYANAC:4228"}}]}},{"Edit":{"inode":{"change":25,"pos":1},"path":"src/sql/hydra.sql","line":408,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":2358}],"down_context":[],"flag":"BLOCK","start":3337,"end":3477,"inode":{"change":25,"pos":1}}},"contents":[{"Add":{"text":"create index IndexBuildsByTimestamp on Builds(timestamp);","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3394"}},{"Add":{"text":"--create index IndexBuildsByJobAndSystem on Builds(project, jobset, job, system);","pos":"SJN2QPWHFYKX7CJMW4XZHI2P2THH7MECZZIHQMCH6EKBZ45G3DOAC:3476"}}]}}],"owner":"grahamc","repo":"hydra2","token":"4CC/uWj1Q1GA+PShLmKnvcssiYEJxbVqDhUkkNexwRA=","login":null}

…

Dependencies

Change contents

Review