{"header":{"message":"Add page showing latest build steps","description":null,"timestamp":"2015-07-10T13:08:34Z","authors":[{"email":"eelco.dolstra@logicblox.com","name":"Eelco Dolstra"}]},"hash":"TX7Q4RASUYPTHIHZFACQ227BIZYLNJGRA5HHIAFQWCL4FHEHVGPQC","authors":[],"deps":{"hashes":[["TX7Q4RASUYPTHIHZFACQ227BIZYLNJGRA5HHIAFQWCL4FHEHVGPQC","Add page showing latest build steps"],["AA",null],["FHOH54HQJOWN2HGIKLVADURVYYHIIORLKEFI4NVKE4K457GLG6CAC","When searching a path / drv path, use separate queries for both options to prevent seq. scan."],["6GZZDDQBAIAZJAESJDIT5JKVY6F7IQTJHG6QT2HHBMK2EWE2MHCQC","Move the store path size chart to the job page"],["AFNDUSGDI2LSRZICZNFXTCFNIVG6IZCKYR7V3KOTHXYUFUU6AYCAC","Set Expires headers for Hydra's binary cache"],["PH3DFCNU2W73FSDAQHS3VXPA474NBQFH2MGL5U6V5VC6CHMQI43AC","Render machine correctly if it doesn't contain @"],["KDBWLKRPZS2XQNS4IXBYJGRZ7OO7OQSC2MRUQDTY2M55G55CTQRAC","Index BuildSteps on propagatedFrom"],["24BMQDZAWDQ7VNIA7TIROXSOYLOJBNZ2E4264WHWNJAEN6ZB3UOAC","Start of single-process hydra-queue-runner"],["YM27DTVTXF3T7OTEK36JZNOP7SIHMPSZMF4LDZYVA3PQKXGYLPFQC","Remove superfluous HYDRA_LOGO environment variable"],["HRAFVVOEGQJQS4XQNZSMNYN2SUZGKEGPSJUDZUBMI2IN32WFNQ4QC","make logo configurable via HYDRA_LOGO env var"],["VH5ZABDRP565VZIG55YHNYYPST53NQ2J6YM362NSLXCAHI5WPH4AC","Add a page to show the latest evaluations for the entire server"],["GK326R5NJYVROQQUOBQT26P3OV6OZLMLTZRU6VIDR2HEOOTRAGAQC","Search: Don't return hidden projects/jobsets"],["EJ7C77C3QLT7JPRHFTDIOY4WAXPXAXMAPWJYWEPKGPO5CCGD3SZAC","Allow searching for store and drv paths. Only does a complete match to reduce load on database."],["UICHT2PSN2QOCHP6MGY5QQJUDU4IF6FBIOJLBA55QBJDK6ST566AC","Add a search feature"],["LCLXI7PTVYQLR2SGXVIAJCLKW3H2TTM3UVJSZHAO7VMISNIHTXOQC","Search: Mark disabled projects/jobsets/jobs"],["2GUAKGTBTNFFER343SQWSLFYIXXHJLDSGH5JHF7QMC3AVZB7Q3TQC","Fix indentation of build.tt"],["WUCOEIFANBM3WXZ2IWEITZ6FKBKXASVWH2LCYRXB4C22H5ADLWVAC","Search: Limit the number of results"],["WXV6M6XNOKHBGKDFUBKQ5FJTLO6PLZHXHJW44O6BVVIHER2FIQWAC","Add a convenient way to get logs of a path/drv. Requested by phreedom."],["R6APT7HGJLNLS4RZRBQHVO2EVZSXNPPNEJPZ3WQNH2DM3YII6LTQC","Fix hydra_logo setting"],["J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC","* Start of a basic Catalyst web interface."],["LBNVQXUBEZ45SOTGVXK5UEZXIAIZTJLWZNUYFI4JZ6J65N3KPDVQC","* Build the /build stuff in a separate controller."],["CS7T2XFIISZ7TPQ6FFRIDYPR6BDCQHURP4JE4YKLI4OYSNWKZCHAC",""],["IK53RV4VGOHLCZGQCCIKPB45M3C7M7YMNBOJFBGZJ4LWIZNU4QNQC",""],["QCGCX2BRDJ3MECT45M6KUQDSTVXWRHGLD4KKNG5UOCOTNAW7L3TQC","Generalize lazy tabs"],["D5QIOJGPKQJIYBUCSC3MFJ3TXLPNZ2XMI37GXMFRVRFWWR2VMTFAC","* Move everything up one directory."],["QL55ECJ6KMMBUOWQ6LKSOVN7L43CH4S6SPE2AQ3VX3KSGC32RP4AC","- adapted ui for hydra, more in line with nixos.org website"],["4JS4DWHDRVNPIV3QCHLVJP6ZEAO5FHOK7NQ5FGO2JVZE6BZDZAIAC","All/recent builds -> Latest builds"],["JZVRK5QJGPDT7HNQLC2UOJRG6V6QO4NJJ5V5QEMQ6VUTUIQWHG5AC","Group some menu items together under a \"Status\" menu"],["N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC","* Put info about logs / build products in the DB."],["PMNWRTGJ4GVSMSSAWSUD57B26PCRAHMZIQ5SIWJIK7A74ENKEQLAC","Add multiple output support"]],"deps":["FHOH54HQJOWN2HGIKLVADURVYYHIIORLKEFI4NVKE4K457GLG6CAC","6GZZDDQBAIAZJAESJDIT5JKVY6F7IQTJHG6QT2HHBMK2EWE2MHCQC","AFNDUSGDI2LSRZICZNFXTCFNIVG6IZCKYR7V3KOTHXYUFUU6AYCAC","PH3DFCNU2W73FSDAQHS3VXPA474NBQFH2MGL5U6V5VC6CHMQI43AC","KDBWLKRPZS2XQNS4IXBYJGRZ7OO7OQSC2MRUQDTY2M55G55CTQRAC"],"known":["HRAFVVOEGQJQS4XQNZSMNYN2SUZGKEGPSJUDZUBMI2IN32WFNQ4QC","2GUAKGTBTNFFER343SQWSLFYIXXHJLDSGH5JHF7QMC3AVZB7Q3TQC","VH5ZABDRP565VZIG55YHNYYPST53NQ2J6YM362NSLXCAHI5WPH4AC","UICHT2PSN2QOCHP6MGY5QQJUDU4IF6FBIOJLBA55QBJDK6ST566AC","GK326R5NJYVROQQUOBQT26P3OV6OZLMLTZRU6VIDR2HEOOTRAGAQC","LCLXI7PTVYQLR2SGXVIAJCLKW3H2TTM3UVJSZHAO7VMISNIHTXOQC","WUCOEIFANBM3WXZ2IWEITZ6FKBKXASVWH2LCYRXB4C22H5ADLWVAC","EJ7C77C3QLT7JPRHFTDIOY4WAXPXAXMAPWJYWEPKGPO5CCGD3SZAC","R6APT7HGJLNLS4RZRBQHVO2EVZSXNPPNEJPZ3WQNH2DM3YII6LTQC","WXV6M6XNOKHBGKDFUBKQ5FJTLO6PLZHXHJW44O6BVVIHER2FIQWAC","24BMQDZAWDQ7VNIA7TIROXSOYLOJBNZ2E4264WHWNJAEN6ZB3UOAC","YM27DTVTXF3T7OTEK36JZNOP7SIHMPSZMF4LDZYVA3PQKXGYLPFQC"]},"hunks":[{"Edit":{"inode":{"change":20,"pos":804},"path":"src/lib/Hydra/Controller/Root.pm","line":293,"atom":{"NewVertex":{"up_context":[{"change":7,"pos":843}],"down_context":[{"change":7,"pos":0}],"flag":"BLOCK","start":0,"end":638,"inode":{"change":20,"pos":804}}},"contents":[{"Add":"}"},{"Add":""},{"Add":""},{"Add":"sub steps :Local Args(0) {"},{"Add":" my ($self, $c) = @_;"},{"Add":""},{"Add":" $c->stash->{template} = 'steps.tt';"},{"Add":""},{"Add":" my $page = int($c->req->param('page') || \"1\") || 1;"},{"Add":""},{"Add":" my $resultsPerPage = 20;"},{"Add":""},{"Add":" $c->stash->{page} = $page;"},{"Add":" $c->stash->{resultsPerPage} = $resultsPerPage;"},{"Add":" $c->stash->{steps} = [ $c->model('DB::BuildSteps')->search("},{"Add":" { starttime => { '!=', undef },"},{"Add":" stoptime => { '!=', undef }"},{"Add":" },"},{"Add":" { order_by => [ \"stoptime desc\" ],"},{"Add":" rows => $resultsPerPage,"},{"Add":" offset => ($page - 1) * $resultsPerPage"},{"Add":" }) ];"},{"Add":""},{"Add":" $c->stash->{total} = approxTableSize($c, \"IndexBuildStepsOnStopTime\");"}]}},{"Edit":{"inode":{"change":20,"pos":804},"path":"src/lib/Hydra/Controller/Root.pm","line":367,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":285}],"down_context":[{"change":2,"pos":285}],"flag":"BLOCK","start":639,"end":641,"inode":{"change":20,"pos":804}}},"contents":[{"Add":"}"}]}},{"Edit":{"inode":{"change":20,"pos":804},"path":"src/lib/Hydra/Controller/Root.pm","line":369,"atom":{"EdgeMap":{"edges":[{"previous":"","flag":"DELETED","from":{"change":7,"pos":266},"to":{"change":7,"start":416,"end":418},"introduced_by":7},{"previous":"","flag":"DELETED","from":{"change":2,"pos":286},"to":{"change":7,"start":416,"end":418},"introduced_by":2},{"previous":"","flag":"DELETED","from":{"change":7,"pos":353},"to":{"change":7,"start":416,"end":418},"introduced_by":7},{"previous":"","flag":"DELETED","from":{"change":7,"pos":709},"to":{"change":7,"start":416,"end":418},"introduced_by":7},{"previous":"","flag":"DELETED","from":{"change":7,"pos":843},"to":{"change":7,"start":416,"end":418},"introduced_by":7},{"previous":"","flag":"DELETED","from":{"change":7,"pos":905},"to":{"change":7,"start":416,"end":418},"introduced_by":7},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":416},"to":{"change":7,"start":416,"end":418},"introduced_by":7}],"inode":{"change":20,"pos":804}}},"contents":[{"Del":"}\n"}]}},{"Edit":{"inode":{"change":21,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":26,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":105}],"down_context":[{"change":22,"pos":180}],"flag":"BLOCK","start":642,"end":662,"inode":{"change":21,"pos":3469}}},"contents":[{"Add":" approxTableSize"}]}},{"Edit":{"inode":{"change":21,"pos":3469},"path":"src/lib/Hydra/Helper/CatalystUtils.pm","line":297,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":311}],"down_context":[{"change":4,"pos":311}],"flag":"BLOCK","start":663,"end":883,"inode":{"change":21,"pos":3469}}},"contents":[{"Add":"}"},{"Add":""},{"Add":""},{"Add":"sub approxTableSize {"},{"Add":" my ($c, $name) = @_;"},{"Add":" return $c->model('DB')->schema->storage->dbh->selectrow_hashref("},{"Add":" \"select reltuples::int from pg_class where relname = lower(?)\", { }, $name)->{\"reltuples\"};"}]}},{"Replacement":{"inode":{"change":20,"pos":7350},"path":"src/root/build.tt","line":48,"ins":{"up_context":[{"change":7,"pos":932}],"down_context":[{"change":7,"pos":985}],"flag":"BLOCK","start":884,"end":958,"inode":{"change":20,"pos":7350}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":7,"pos":932},"to":{"change":5,"start":0,"end":69},"introduced_by":5}],"inode":{"change":20,"pos":7350}},"ins_contents":[{"Add":" [% INCLUDE renderMachineName machine=step.machine %]"}],"del_contents":[{"Del":" [% step.machine.split('@').1 || step.machine %]\n"}]}},{"Edit":{"inode":{"change":23,"pos":2803},"path":"src/root/common.tt","line":646,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":2905}],"down_context":[{"change":24,"pos":679}],"flag":"BLOCK","start":959,"end":1059,"inode":{"change":23,"pos":2803}}},"contents":[{"Add":"BLOCK renderMachineName;"},{"Add":"machine ? stripSSHUser(machine).match('^([^\\.]*)').0 : \"localhost\";"},{"Add":"END;"},{"Add":""},{"Add":""}]}},{"FileAdd":{"meta":{"basename":"steps.tt","metadata":0},"context":[{"change":25,"pos":1486}],"contents":[{"Add":"[% WRAPPER layout.tt title=\"Latest steps\" %]"},{"Add":"[% PROCESS common.tt %]"},{"Add":""},{"Add":"

Showing steps [% (page - 1) * resultsPerPage + 1 %] - [% (page - 1)"},{"Add":"* resultsPerPage + steps.size %] of about [% total %] in"},{"Add":"order of descending finish time.

"},{"Add":""},{"Add":""},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" [% FOREACH step IN steps %]"},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" [% END %]"},{"Add":" "},{"Add":"

	What	Job	Build	Step	When	Duration	Machine
[% INCLUDE renderBuildStatusIcon buildstatus=step.status size=16 %]	`[% step.drvpath.match('-(.*).drv').0 %]`	`[% INCLUDE renderFullJobNameOfBuild build=step.build %]`	[% step.build.id %]	[% step.stepnr %]	[% INCLUDE renderRelativeDate timestamp=step.stoptime %]	[% INCLUDE renderDuration duration = step.stoptime - step.starttime %]	`[% INCLUDE renderMachineName machine=step.machine %]`

"},{"Add":""},{"Add":"[% INCLUDE renderPager %]"},{"Add":""},{"Add":"[% END %]"}]}},{"Edit":{"inode":{"change":26,"pos":6671},"path":"src/root/topbar.tt","line":34,"atom":{"NewVertex":{"up_context":[{"change":27,"pos":80}],"down_context":[{"change":28,"pos":577}],"flag":"BLOCK","start":2464,"end":2586,"inode":{"change":26,"pos":6671}}},"contents":[{"Add":" [% INCLUDE menuItem"},{"Add":" uri = c.uri_for(c.controller('Root').action_for('steps'))"},{"Add":" title = \"Latest steps\" %]"}]}},{"Edit":{"inode":{"change":29,"pos":1},"path":"src/sql/hydra.sql","line":598,"atom":{"NewVertex":{"up_context":[{"change":6,"pos":109}],"down_context":[{"change":30,"pos":20632}],"flag":"BLOCK","start":2587,"end":2709,"inode":{"change":29,"pos":1}}},"contents":[{"Add":"create index IndexBuildStepsOnStopTime on BuildSteps(stopTime desc) where startTime is not null and stopTime is not null;"}]}},{"FileAdd":{"meta":{"basename":"upgrade-37.sql","metadata":0},"context":[{"change":25,"pos":3004}],"contents":[{"Add":"create index IndexBuildStepsOnStopTime on BuildSteps(stopTime desc) where startTime is not null and stopTime is not null;"}]}}],"owner":"grahamc","repo":"hydra2","token":"Nzg1kZ+I1kLgpXoZ7QOAAPLUJS08IMnj3Q+XW27SwQo=","login":null}

…

Dependencies

Change contents