Upgrading

{"header":{"message":"Provide a command ‘hydra-init’ to initialise/upgrade the database","description":"For schema upgrades, hydra-init executes the files\nsrc/sql/upgrade-.sql, each of which upgrades the schema from\nversion N-1 to N. The upgrades are wrapped in a transaction.","timestamp":"2012-02-28T19:16:16Z","authors":[{"email":"e.dolstra@tudelft.nl","name":"Eelco Dolstra"}]},"hash":"AMFMXR52JXHUOWWG4VZ5DHQGLF4F7H7XSJRLX5XNEXOCCWYLDQOAC","authors":[],"deps":{"hashes":[["AMFMXR52JXHUOWWG4VZ5DHQGLF4F7H7XSJRLX5XNEXOCCWYLDQOAC","Provide a command ‘hydra-init’ to initialise/upgrade the database"],["AA",null],["AIEKRM6TQFURIZESUF57IQYO5RXFRBL7SOFSCX72CVKUN3UKK3DAC","* Add DBD::SQLite to the list of dependencies."],["CFZ6WDUZK3WTKJJLLXVS5MATNP7WCMKHAXKBCTO6OM6CDTQBKBTQC",""],["TH674WKJECNZ4K22DZ2N4SF53UGKG2BQRGBSNESRPDRSRND6TZHAC","add log diff to compare logs to previous builds"],["46Z25UHSGPWEF7QSXODHKNGRHWEYX5JOCCZYI67S2NJTWY5JDN4AC","Use CatalystX::Script::Server::Starman"],["DXBTGOA4JXRSEZBDKGVJ4QDXCSQZWI5DHTSULWG4APNPOSLF3CDAC","Print out an Apache-style access log"],["7DWCXNC72OO3M4YGNVV4KM775CUSPBHEFFNMRIA2XAZTQCXYHBRQC","Use the new Nix Perl bindings"],["SB2V735VJ2CDHGCXRUA5FOYHDRXQFVOZ3KXC3YKXWRNW6DIX7RXQC","Keep track of the database schema version"],["GYPHTT4MZS75JYMQES2DZPV2D47EJW5HTQWYWDYXE7YJ6FFHPAYAC","Manual: Remove tabs, indent consistently"],["J5YZVALJZSMZ6TYL27Y34OML6YVZGI62TDON44PM3SNRNMB4QIZQC","Remove duplicate dependency."],["N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC","* Put info about logs / build products in the DB."],["YT25ZGSZFSW67CNCT5WXQQV3DX4CPMHFECWHCGAYJNFVZSNFCEJAC",""],["BQYE6R7YVBXS72FXT4WJFXJ2KARTW2V65TVSTFGCE5TK2BL3ZQVAC",""],["FV2M6MOTAP4BJMEKU5XUDVEACWEJGEIRCCE2MRY3F6SF2SFOE3MQC","hydra: use autoconf/-make"],["HSVVEKTY2U5XJ4ZDHF43YEQXRPRWNZLZDDD4W7JFJ55UWD7CEFBQC","* Start of a JSON API to get information about a specific build."],["W5GW4E225F3CYJQXFPKJ5W5O2E73U6ZGWFL2N3GS2LKJX2RTGYDQC","Don't install hydra-create"],["TNLAFBN7CL7OZPYYKWCQ2HTTXJHEOJBLVOOLM6YCQEST4PGCPPTQC","Add missing dependency on Catalyst::Plugin::Session::State::Cookie."],["6US6LEC7V7LUTMPXOWGU7D4PQAFOG2AKNW4VBPSENNBEDMTBJCVQC","* Add a NarSize field to Hydra manifests. This allows nix-env"],["KBW3FDZ2PK7YCH3ICSHFWP22CWXYAXIPULP6LEN3S3K22UT4WSVQC","Merge remote branch 'remotes/origin/master'"],["A63IHCMXH3F4V56HDXJLJVVHKXRSJCJMT2PWXXI2IW3J734J6SGQC","* Register GC roots properly."],["DO432JDJH2NWZC6AMN7PG6WYD2Y26U6O54GDMBEVBQTZEVNKBN5QC","* Build Hydra with the Nix Perl bindings."],["OG7BEM57MXPCG56IT5GODPFG77KZXWPXZ7OVZPWQQ56CRJ7KUE2QC",""],["RBGYFVWXQNXAZ57534WQQJH6PYW7PU6YZLSCLXDZYXACXDA2D3NQC","use HYDRA_DATA/hydra.conf as default location for hydra.conf"],["IN272KZWHENW2TCR3LWQ6OZAEESJL5S7AEL3GYLJTWHJUDE6HADAC","* Automatically keep all builds in the latest successful release in"],["HN7JDKV3DG4KYJHD6YWWRWGCNLUJQFI7EHRQBXZXWOM4QFGH275AC","doc: Mention SQLite."],["6XJH4OFLFN6PC5FXKMHSPQQVT5DKWFUWO43HMQ7BDM454ZDMD5VQC","add datetime to deps"],["BKOIYITRBRVU4D7XFAZPV5QHAPCBMIO3SBNHYJ6TVT43WR32CTHQC","added some json responses"],["VOBFCHIXMHWXLRA2EBJVKGIIYDGMVYOVQAUTKCHWRSUHV34XS57AC","use top_srcdir in stead of srcdir"],["A6EKITA6BJRM4PDOT5GDTN6EKVFFD2S4AFJWKMIKEB7NKN52ZJ2AC","Update the docs to reflect the renaming"],["SAFVRDTKKD25U6VW5IVNUILLLXNQXFU72XARYC6NRVXU6MJEW2WAC","* Put Hydra's dependencies so that they can easily be installed in a"],["YFPZ46YK4BOI6VH2H3F757UEGEYONURUAEDAYEIBLRY33PLSSO4AC"," * hydra: added variant of build input type, 'build output (same system)' to allow better continous integration in one jobset for multiple system. it makes sure that the system of the build that is passed as input for a job has the same system as the job."],["EKNK5AHQNJDKGLFPEX6CQXNPVIOWX3JXEP2H5YUZ4UFWCZ3HEJLQC","doc: Augment the \"Installation\" section with material by Visser & Dolstra."],["KN3VYE5P2RJB3KZ355LA5C2T2D5S2IR3QZFE53AJIWUVMETEEYDAC","* Cleaned up the foreign key constraints."],["IJWKUOG4QFFSLJS3L6RMHSWU6BDAVC25P3KRYKVRCT5LEKQRZ2OQC","emailsimplecreator was removed"],["G2ZB6464XGPBIMSZIPSB24EIXSCCGV4XWC3IWPS2CXYPDSUZSU5QC","first test, not yet in buildprocess"],["CXRCPDSQEWHSZNCJIORUAINH5I2FFFQ7AVUQOB62REGROLROPE7QC"," * added support for twitter notification"],["EDDTVGB47XYPTKJ3P4XAQ4MZ2NFKAMK2JE6GSEMWAO4EJVGPYHPQC","set BZR_HOME env var so bzr won't fail"],["3YSK5YXGW3JKJUPYNHDQSB4ZCUMBSFKHCGWI4IIXJ277OBYRSU2AC","* Update to Catalyst 5.9."],["SZYDW2DG5Z7BR3ICKWDXVUNSMCDSXMYZUB6FQ4W2B2FVZJD6PULQC","hydra: added some user admin"],["RBZRCTALK2SLKX6HDMBS25BRNYPK3GK364MGAVCXP3MW5CEW5TKQC","hydra: fixed and re-enabled evaluation tests"],["LZO3C2KIACZ3HN72RBGWWIT5ED4RJMYKI3SAHXT6RIUPHDFL3STQC","* Hack around those SQLite timeouts: just retry the transaction."],["QUTWJR7PQZ3DBPC4G2AFXOKPPGFZQLE5RLXHAOFTLMXIT2QPF4TQC","* Include more info in notification emails."],["2GK5DOU7ODF4WBSN3QTD3WIO52VTL2LOAXKGCDEMMAQPTEO4A4HAC","* Downloading closures."],["D5QIOJGPKQJIYBUCSC3MFJ3TXLPNZ2XMI37GXMFRVRFWWR2VMTFAC","* Move everything up one directory."]],"deps":["AIEKRM6TQFURIZESUF57IQYO5RXFRBL7SOFSCX72CVKUN3UKK3DAC","CFZ6WDUZK3WTKJJLLXVS5MATNP7WCMKHAXKBCTO6OM6CDTQBKBTQC","TH674WKJECNZ4K22DZ2N4SF53UGKG2BQRGBSNESRPDRSRND6TZHAC","46Z25UHSGPWEF7QSXODHKNGRHWEYX5JOCCZYI67S2NJTWY5JDN4AC","DXBTGOA4JXRSEZBDKGVJ4QDXCSQZWI5DHTSULWG4APNPOSLF3CDAC","7DWCXNC72OO3M4YGNVV4KM775CUSPBHEFFNMRIA2XAZTQCXYHBRQC","SB2V735VJ2CDHGCXRUA5FOYHDRXQFVOZ3KXC3YKXWRNW6DIX7RXQC","GYPHTT4MZS75JYMQES2DZPV2D47EJW5HTQWYWDYXE7YJ6FFHPAYAC"],"known":["N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC","IN272KZWHENW2TCR3LWQ6OZAEESJL5S7AEL3GYLJTWHJUDE6HADAC","A63IHCMXH3F4V56HDXJLJVVHKXRSJCJMT2PWXXI2IW3J734J6SGQC","LZO3C2KIACZ3HN72RBGWWIT5ED4RJMYKI3SAHXT6RIUPHDFL3STQC","SAFVRDTKKD25U6VW5IVNUILLLXNQXFU72XARYC6NRVXU6MJEW2WAC","OG7BEM57MXPCG56IT5GODPFG77KZXWPXZ7OVZPWQQ56CRJ7KUE2QC","QUTWJR7PQZ3DBPC4G2AFXOKPPGFZQLE5RLXHAOFTLMXIT2QPF4TQC","CXRCPDSQEWHSZNCJIORUAINH5I2FFFQ7AVUQOB62REGROLROPE7QC","KN3VYE5P2RJB3KZ355LA5C2T2D5S2IR3QZFE53AJIWUVMETEEYDAC","YFPZ46YK4BOI6VH2H3F757UEGEYONURUAEDAYEIBLRY33PLSSO4AC","IJWKUOG4QFFSLJS3L6RMHSWU6BDAVC25P3KRYKVRCT5LEKQRZ2OQC","DO432JDJH2NWZC6AMN7PG6WYD2Y26U6O54GDMBEVBQTZEVNKBN5QC","KBW3FDZ2PK7YCH3ICSHFWP22CWXYAXIPULP6LEN3S3K22UT4WSVQC","BKOIYITRBRVU4D7XFAZPV5QHAPCBMIO3SBNHYJ6TVT43WR32CTHQC","6XJH4OFLFN6PC5FXKMHSPQQVT5DKWFUWO43HMQ7BDM454ZDMD5VQC","FV2M6MOTAP4BJMEKU5XUDVEACWEJGEIRCCE2MRY3F6SF2SFOE3MQC","YT25ZGSZFSW67CNCT5WXQQV3DX4CPMHFECWHCGAYJNFVZSNFCEJAC","6US6LEC7V7LUTMPXOWGU7D4PQAFOG2AKNW4VBPSENNBEDMTBJCVQC","SZYDW2DG5Z7BR3ICKWDXVUNSMCDSXMYZUB6FQ4W2B2FVZJD6PULQC","RBGYFVWXQNXAZ57534WQQJH6PYW7PU6YZLSCLXDZYXACXDA2D3NQC","HN7JDKV3DG4KYJHD6YWWRWGCNLUJQFI7EHRQBXZXWOM4QFGH275AC","EKNK5AHQNJDKGLFPEX6CQXNPVIOWX3JXEP2H5YUZ4UFWCZ3HEJLQC","G2ZB6464XGPBIMSZIPSB24EIXSCCGV4XWC3IWPS2CXYPDSUZSU5QC","VOBFCHIXMHWXLRA2EBJVKGIIYDGMVYOVQAUTKCHWRSUHV34XS57AC","EDDTVGB47XYPTKJ3P4XAQ4MZ2NFKAMK2JE6GSEMWAO4EJVGPYHPQC","RBZRCTALK2SLKX6HDMBS25BRNYPK3GK364MGAVCXP3MW5CEW5TKQC","BQYE6R7YVBXS72FXT4WJFXJ2KARTW2V65TVSTFGCE5TK2BL3ZQVAC","HSVVEKTY2U5XJ4ZDHF43YEQXRPRWNZLZDDD4W7JFJ55UWD7CEFBQC","TNLAFBN7CL7OZPYYKWCQ2HTTXJHEOJBLVOOLM6YCQEST4PGCPPTQC","J5YZVALJZSMZ6TYL27Y34OML6YVZGI62TDON44PM3SNRNMB4QIZQC","3YSK5YXGW3JKJUPYNHDQSB4ZCUMBSFKHCGWI4IIXJ277OBYRSU2AC","A6EKITA6BJRM4PDOT5GDTN6EKVFFD2S4AFJWKMIKEB7NKN52ZJ2AC","W5GW4E225F3CYJQXFPKJ5W5O2E73U6ZGWFL2N3GS2LKJX2RTGYDQC"]},"hunks":[{"Replacement":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":1,"ins":{"up_context":[{"change":10,"pos":1}],"down_context":[{"change":10,"pos":10}],"flag":"BLOCK","start":0,"end":10,"inode":{"change":10,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":1},"to":{"change":10,"start":2,"end":10},"introduced_by":10}],"inode":{"change":10,"pos":1}},"ins_contents":[{"Add":"{ pkgs }:"}],"del_contents":[{"Del":"{pkgs}:\n"}]}},{"Replacement":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":5,"ins":{"up_context":[{"change":10,"pos":23}],"down_context":[{"change":10,"pos":52}],"flag":"BLOCK","start":11,"end":198,"inode":{"change":10,"pos":1}},"del":{"edges":[{"previous":"","flag":"DELETED","from":{"change":10,"pos":326},"to":{"change":10,"start":23,"end":52},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":23},"to":{"change":10,"start":23,"end":52},"introduced_by":10}],"inode":{"change":10,"pos":1}},"ins_contents":[{"Add":"[ perlPackages.CatalystAuthenticationStoreDBIxClass"},{"Add":" perlPackages.CatalystPluginAccessLog"},{"Add":" perlPackages.CatalystPluginAuthorizationRoles"},{"Add":" perlPackages.CatalystPluginSessionStateCookie"}],"del_contents":[{"Del":"[ perlPackages.CatalystDevel\n"}]}},{"Edit":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":11,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":142},"to":{"change":10,"start":142,"end":190},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":190},"to":{"change":10,"start":0,"end":48},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":48},"to":{"change":6,"start":0,"end":39},"introduced_by":6},{"previous":"","flag":"DELETED","from":{"change":6,"pos":39},"to":{"change":10,"start":190,"end":272},"introduced_by":6},{"previous":"","flag":"DELETED","from":{"change":10,"pos":48},"to":{"change":10,"start":190,"end":272},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":190},"to":{"change":10,"start":190,"end":272},"introduced_by":10}],"inode":{"change":10,"pos":1}}},"contents":[{"Del":" perlPackages.CatalystPluginAuthorizationRoles\n"},{"Del":" perlPackages.CatalystPluginSessionStateCookie\n"},{"Del":" perlPackages.CatalystPluginAccessLog\n"},{"Del":" perlPackages.CatalystAuthenticationStoreDBIxClass\n perlPackages.CatalystViewTT\n"}]}},{"Edit":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":13,"atom":{"NewVertex":{"up_context":[{"change":10,"pos":32}],"down_context":[{"change":5,"pos":0}],"flag":"BLOCK","start":199,"end":229,"inode":{"change":10,"pos":1}}},"contents":[{"Add":" perlPackages.CatalystViewTT"}]}},{"Replacement":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":15,"ins":{"up_context":[{"change":5,"pos":44}],"down_context":[{"change":10,"pos":451}],"flag":"BLOCK","start":230,"end":261,"inode":{"change":10,"pos":1}},"del":{"edges":[{"previous":"","flag":"DELETED","from":{"change":10,"pos":32},"to":{"change":10,"start":349,"end":396},"introduced_by":10},{"previous":"","flag":"DELETED","from":{"change":5,"pos":44},"to":{"change":10,"start":349,"end":396},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":349},"to":{"change":10,"start":349,"end":396},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":396},"to":{"change":3,"start":0,"end":26},"introduced_by":3},{"previous":"","flag":"DELETED","from":{"change":3,"pos":26},"to":{"change":10,"start":427,"end":451},"introduced_by":3},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":427},"to":{"change":10,"start":427,"end":451},"introduced_by":10}],"inode":{"change":10,"pos":1}},"ins_contents":[{"Add":" perlPackages.CryptRandPasswd"}],"del_contents":[{"Del":" perlPackages.XMLSimple\n perlPackages.IPCRun\n"},{"Del":" perlPackages.IOCompress\n"},{"Del":" perlPackages.Readonly\n"}]}},{"Edit":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":18,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":25}],"down_context":[{"change":10,"pos":0}],"flag":"BLOCK","start":262,"end":336,"inode":{"change":10,"pos":1}}},"contents":[{"Add":" perlPackages.DataDump"},{"Add":" perlPackages.DateTime"},{"Add":" perlPackages.DigestSHA1"}]}},{"Edit":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":22,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":61},"to":{"change":10,"start":0,"end":25},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":25},"to":{"change":4,"start":0,"end":24},"introduced_by":4}],"inode":{"change":10,"pos":1}}},"contents":[{"Del":" perlPackages.TextTable\n"},{"Del":" perlPackages.TextDiff\n"}]}},{"Edit":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":23,"atom":{"NewVertex":{"up_context":[{"change":4,"pos":49}],"down_context":[{"change":10,"pos":0}],"flag":"BLOCK","start":337,"end":407,"inode":{"change":10,"pos":1}}},"contents":[{"Add":" perlPackages.IOCompress"},{"Add":" perlPackages.IPCRun"},{"Add":" perlPackages.JSONXS"}]}},{"Replacement":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":28,"ins":{"up_context":[{"change":10,"pos":25}],"down_context":[{"change":10,"pos":0}],"flag":"BLOCK","start":408,"end":494,"inode":{"change":10,"pos":1}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":25},"to":{"change":10,"start":25,"end":49},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":49},"to":{"change":10,"start":0,"end":22},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":22},"to":{"change":10,"start":0,"end":24},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":24},"to":{"change":10,"start":0,"end":57},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":57},"to":{"change":10,"start":47,"end":71},"introduced_by":10},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":71},"to":{"change":10,"start":49,"end":80},"introduced_by":10}],"inode":{"change":10,"pos":1}},"ins_contents":[{"Add":" perlPackages.CatalystDevel"},{"Add":" perlPackages.Readonly"},{"Add":" perlPackages.SQLSplitStatement"}],"del_contents":[{"Del":" perlPackages.DataDump\n"},{"Del":" perlPackages.JSONXS\n"},{"Del":" perlPackages.DateTime\n"},{"Del":" perlPackages.DigestSHA1\n perlPackages.CryptRandPasswd\n"},{"Del":" perlPackages.TestMore\n"},{"Del":" perlPackages.SysHostnameLong\n"}]}},{"Edit":{"inode":{"change":10,"pos":1},"path":"deps.nix","line":32,"atom":{"NewVertex":{"up_context":[{"change":10,"pos":23}],"down_context":[{"change":7,"pos":0}],"flag":"BLOCK","start":495,"end":624,"inode":{"change":10,"pos":1}}},"contents":[{"Add":" perlPackages.SysHostnameLong"},{"Add":" perlPackages.TestMore"},{"Add":" perlPackages.TextDiff"},{"Add":" perlPackages.TextTable"},{"Add":" perlPackages.XMLSimple"}]}},{"Edit":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":76,"atom":{"NewVertex":{"up_context":[{"change":10,"pos":2349}],"down_context":[{"change":9,"pos":2697}],"flag":"BLOCK","start":625,"end":630,"inode":{"change":10,"pos":238}}},"contents":[{"Add":""}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":89,"ins":{"up_context":[{"change":9,"pos":2963}],"down_context":[{"change":9,"pos":3033}],"flag":"BLOCK","start":684,"end":748,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":9,"pos":2963},"to":{"change":9,"start":2963,"end":3033},"introduced_by":9}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":" The latest development snapshot of Hydra can be installed"}],"del_contents":[{"Del":" Alternatively, the latest development snapshot can be installed\n"}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":92,"ins":{"up_context":[{"change":9,"pos":3196}],"down_context":[{"change":9,"pos":3262}],"flag":"BLOCK","start":749,"end":817,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":9,"pos":3196},"to":{"change":9,"start":3196,"end":3262},"introduced_by":9}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":" and using the one-click install available at one of the build"}],"del_contents":[{"Del":" and use the one-click install available at one of the build\n"}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":106,"ins":{"up_context":[{"change":9,"pos":3493}],"down_context":[{"change":9,"pos":3494}],"flag":"BLOCK","start":818,"end":955,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"","flag":"DELETED","from":{"change":9,"pos":3493},"to":{"change":10,"start":0,"end":118},"introduced_by":9},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":3048},"to":{"change":10,"start":0,"end":118},"introduced_by":10}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":"hydra-build hydra-init hydra-update-gc-roots"},{"Add":"hydra-eval-jobs hydra-queue-runner "},{"Add":"hydra-evaluator hydra-server"},{"Add":""}],"del_contents":[{"Del":"hydra-build hydra-evaluator hydra-server\nhydra-eval-jobs hydra-queue-runner hydra-update-gc-roots\n"}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":123,"ins":{"up_context":[{"change":9,"pos":3843}],"down_context":[{"change":10,"pos":232}],"flag":"BLOCK","start":956,"end":1055,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":9,"pos":3843},"to":{"change":9,"start":3843,"end":3911},"introduced_by":9}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":" as database name and user name, issue the following commands on"},{"Add":" the PostgreSQL server:"}],"del_contents":[{"Del":" as database name and user name, issue the following commands:\n"}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":127,"ins":{"up_context":[{"change":9,"pos":3927}],"down_context":[{"change":9,"pos":3928}],"flag":"BLOCK","start":1056,"end":1118,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"","flag":"DELETED","from":{"change":9,"pos":3927},"to":{"change":10,"start":1698,"end":1920},"introduced_by":9},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":1698},"to":{"change":10,"start":1698,"end":1920},"introduced_by":10}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":"createuser -S -D -R -P hydra"},{"Add":"createdb -O hydra hydra"}],"del_contents":[{"Del":"createdb hydra\necho \"CREATE USER hydra WITH PASSWORD '<your-password>' ;\" | psql hydra\ncat $prefix/share/hydra/sql/hydra-postgresql.sql | psql hydra\necho \"GRANT ALL ON DATABASE hydra TO hydra;\" | psql hydra\n"}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":135,"ins":{"up_context":[{"change":9,"pos":4047}],"down_context":[{"change":10,"pos":591}],"flag":"BLOCK","start":1119,"end":1439,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":9,"pos":4047},"to":{"change":9,"start":4047,"end":4133},"introduced_by":9}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":" Hydra uses an environment variable to know which database should"},{"Add":" be used, and a variable which point to a location that holds"},{"Add":" some state. To set these variables for a PostgreSQL database,"},{"Add":" add the following to the file ~/.profile of"},{"Add":" the user running the Hydra services."}],"del_contents":[{"Del":" For SQLite, the following command is all it takes to create the\n database:\n"}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":142,"ins":{"up_context":[{"change":9,"pos":4149}],"down_context":[{"change":9,"pos":4235}],"flag":"BLOCK","start":1440,"end":2036,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":9,"pos":4149},"to":{"change":9,"start":4149,"end":4235},"introduced_by":9}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":"export HYDRA_DBI=\"dbi:Pg:dbname=hydra;host=dbserver.example.org;user=hydra;\""},{"Add":"export HYDRA_DATA=/var/lib/hydra"},{"Add":""},{"Add":" You can provide the username and password in the file"},{"Add":" ~/.pgpass, e.g."},{"Add":""},{"Add":" "},{"Add":"dbserver.example.org:*:hydra:hydra:password"},{"Add":""},{"Add":" Make sure that the HYDRA_DATA directory"},{"Add":" exists and is writable for the user which will run the Hydra"},{"Add":" services. For a SQLite database, the"},{"Add":" HYDRA_DBI should be set to something like"},{"Add":" dbi:SQLite:/path/to/hydra.sqlite"}],"del_contents":[{"Del":"cat $prefix/share/hydra/sql/hydra-sqlite.sql | sqlite3 /path/to/hydra.sqlite\n"}]}},{"Edit":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":159,"atom":{"NewVertex":{"up_context":[{"change":9,"pos":4259}],"down_context":[{"change":9,"pos":4259}],"flag":"BLOCK","start":2037,"end":2194,"inode":{"change":10,"pos":238}}},"contents":[{"Add":" Having set these environment variables, you can now initialise"},{"Add":" the database by doing:"},{"Add":" "},{"Add":"hydra-init"},{"Add":" "},{"Add":""},{"Add":" "}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":177,"ins":{"up_context":[{"change":10,"pos":2434}],"down_context":[{"change":10,"pos":1333}],"flag":"BLOCK","start":2195,"end":2250,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":2434},"to":{"change":9,"start":4643,"end":4967},"introduced_by":9}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":" "},{"Add":""},{"Add":"

"},{"Add":" Upgrading"}],"del_contents":[{"Del":" \n Hydra uses an environment variable to know which database should\n be used, and a variable which point to a location that holds\n some state. To set these variables for a PostgreSQL database,\n add the following to the .profile of the\n user running the Hydra services.\n"}]}},{"Edit":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":182,"atom":{"NewVertex":{"up_context":[{"change":10,"pos":1334}],"down_context":[{"change":9,"pos":4968}],"flag":"BLOCK","start":2251,"end":2397,"inode":{"change":10,"pos":238}}},"contents":[{"Add":" If you're upgrading Hydra from a previous version, you"},{"Add":" should do the following to perform any necessary database schema migrations:"}]}},{"Replacement":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":185,"ins":{"up_context":[{"change":9,"pos":4983}],"down_context":[{"change":10,"pos":2835}],"flag":"BLOCK","start":2398,"end":2430,"inode":{"change":10,"pos":238}},"del":{"edges":[{"previous":"","flag":"DELETED","from":{"change":9,"pos":4983},"to":{"change":10,"start":2737,"end":2835},"introduced_by":9},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":2737},"to":{"change":10,"start":2737,"end":2835},"introduced_by":10}],"inode":{"change":10,"pos":238}},"ins_contents":[{"Add":"hydra-init"},{"Add":" "}],"del_contents":[{"Del":"export HYDRA_DBI=\"dbi:Pg:dbname=hydra;host=localhost;\"\nexport HYDRA_DATA=/var/lib/hydra \n"}]}},{"Edit":{"inode":{"change":10,"pos":238},"path":"doc/manual/installation.xml","line":188,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":2836},"to":{"change":9,"start":4984,"end":5299},"introduced_by":9}],"inode":{"change":10,"pos":238}}},"contents":[{"Del":" Make sure that the HYDRA_DATA directory\n exists and is writable for the user which will run the Hydra\n services. For a SQLite database, the\n HYDRA_DBI should be set to something like\n dbi:SQLite:/path/to/hydra.sqlite\n \n"}]}},{"Replacement":{"inode":{"change":44,"pos":436},"path":"src/lib/Hydra/Helper/Nix.pm","line":11,"ins":{"up_context":[{"change":10,"pos":619}],"down_context":[{"change":10,"pos":665}],"flag":"BLOCK","start":2431,"end":2508,"inode":{"change":44,"pos":436}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":107},"to":{"change":10,"start":0,"end":64},"introduced_by":10}],"inode":{"change":44,"pos":436}},"ins_contents":[{"Add":" getHydraPath getHydraHome getHydraDBPath openHydraDB getHydraConf txn_do"}],"del_contents":[{"Del":" getHydraPath getHydraDBPath openHydraDB getHydraConf txn_do\n"}]}},{"Edit":{"inode":{"change":44,"pos":436},"path":"src/lib/Hydra/Helper/Nix.pm","line":24,"atom":{"NewVertex":{"up_context":[{"change":10,"pos":145}],"down_context":[{"change":10,"pos":145}],"flag":"BLOCK","start":2509,"end":2636,"inode":{"change":44,"pos":436}}},"contents":[{"Add":""},{"Add":"sub getHydraHome {"},{"Add":" my $dir = $ENV{\"HYDRA_HOME\"} or die \"The HYDRA_HOME directory does not exist!\\n\";"},{"Add":" return $dir;"},{"Add":"}"},{"Add":""},{"Add":""}]}},{"FileAdd":{"meta":{"basename":"hydra-init","metadata":64},"context":[{"change":45,"pos":2543}],"contents":[{"Add":"#! /var/run/current-system/sw/bin/perl -w"},{"Add":""},{"Add":"use strict;"},{"Add":"use Hydra::Schema;"},{"Add":"use Hydra::Helper::Nix;"},{"Add":"use File::Slurp;"},{"Add":"use SQL::SplitStatement;"},{"Add":"use List::Util qw(max);"},{"Add":""},{"Add":"my $db = openHydraDB;"},{"Add":"my $dbh = $db->storage->dbh;"},{"Add":"$dbh->{RaiseError} = 1;"},{"Add":""},{"Add":"my $home = getHydraHome;"},{"Add":""},{"Add":"my $sql_splitter = SQL::SplitStatement->new;"},{"Add":""},{"Add":"# Figure out the target schema version."},{"Add":"my $maxSchemaVersion = max (map { /.*\\/upgrade-(\\d.*)\\.sql/; $1 } (glob \"$home/sql/upgrade-[0-9]*.sql\")) || 1;"},{"Add":""},{"Add":"# Check whether the database has been initialised. If not, load the"},{"Add":"# schema."},{"Add":"my @tables = $dbh->tables;"},{"Add":"if (! grep { /SchemaVersion/i } @tables) {"},{"Add":" print STDERR \"initialising the Hydra database schema...\\n\";"},{"Add":" my $schema = read_file("},{"Add":"\t$dbh->{Driver}->{Name} eq 'SQLite' ? \"$home/sql/hydra-sqlite.sql\" :"},{"Add":"\t$dbh->{Driver}->{Name} eq 'Pg' ? \"$home/sql/hydra-postgresql.sql\" :"},{"Add":"\tdie \"unsupported database type\\n\");"},{"Add":" my @statements = $sql_splitter->split($schema);"},{"Add":" eval {"},{"Add":"\t$dbh->begin_work;"},{"Add":"\t$dbh->do($_) foreach @statements;"},{"Add":"\t$db->resultset('SchemaVersion')->create({version => $maxSchemaVersion});"},{"Add":"\t$dbh->commit;"},{"Add":" };"},{"Add":" die \"schema initialisation failed: $@\\n\" if $@;"},{"Add":" exit 0;"},{"Add":"}"},{"Add":""},{"Add":"# Get the current schema version."},{"Add":"my @versions = $db->resultset('SchemaVersion')->all;"},{"Add":"die \"couldn't get Hydra schema version!\" if scalar @versions != 1;"},{"Add":"my $schemaVersion = $versions[0]->version;"},{"Add":""},{"Add":"for (my $n = $schemaVersion; $n < $maxSchemaVersion; $n++) {"},{"Add":" my $m = $n + 1;"},{"Add":" print STDERR \"upgrading Hydra schema from version $n to $m\\n\";"},{"Add":" my $schema = read_file(\"$home/sql/upgrade-$m.sql\");"},{"Add":" my @statements = $sql_splitter->split($schema);"},{"Add":" eval {"},{"Add":"\t$dbh->begin_work;"},{"Add":"\t$dbh->do($_) foreach @statements;"},{"Add":"\t$db->resultset('SchemaVersion')->update({version => $m});"},{"Add":"\t$dbh->commit;"},{"Add":" };"},{"Add":" die \"schema upgrade failed: $@\\n\" if $@;"},{"Add":"}"}]}},{"Replacement":{"inode":{"change":10,"pos":3409},"path":"src/sql/Makefile.am","line":3,"ins":{"up_context":[{"change":10,"pos":2199458}],"down_context":[{"change":10,"pos":2199488}],"flag":"BLOCK","start":4483,"end":4516,"inode":{"change":10,"pos":3409}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":2199458},"to":{"change":10,"start":2199458,"end":2199488},"introduced_by":10}],"inode":{"change":10,"pos":3409}},"ins_contents":[{"Add":"sqldir = $(libexecdir)/hydra/sql"}],"del_contents":[{"Del":"sqldir = $(datadir)/hydra/sql\n"}]}},{"Edit":{"inode":{"change":10,"pos":1},"path":"src/sql/hydra.sql","line":5,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":8,"pos":32788},"to":{"change":8,"start":32788,"end":32837},"introduced_by":8}],"inode":{"change":10,"pos":1}}},"contents":[{"Del":"\ninsert into SchemaVersion (version) values (1);\n"}]}},{"Replacement":{"inode":{"change":10,"pos":92},"path":"tests/Makefile.am","line":34,"ins":{"up_context":[{"change":10,"pos":51}],"down_context":[{"change":10,"pos":0}],"flag":"BLOCK","start":4517,"end":4559,"inode":{"change":10,"pos":92}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":10,"pos":51},"to":{"change":10,"start":51,"end":112},"introduced_by":10}],"inode":{"change":10,"pos":92}},"ins_contents":[{"Add":"\tperl $(top_srcdir)/src/script/hydra-init"}],"del_contents":[{"Del":"\tsqlite3 db.sqlite < $(top_srcdir)/src/sql/hydra-sqlite.sql\n"}]}}],"owner":"grahamc","repo":"hydra2","token":"fNMHexdnVr7ynRzQgpMUN4z/qUDK+dwRTTFFWGB/+uw=","login":null}

…

Dependencies

Change contents