{"header":{"message":"db upgrade strategy\n","description":null,"timestamp":"2020-02-25T22:18:46Z","authors":[{"email":"boogerlad@gmail.com","name":"kevin"}]},"hash":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC","authors":[],"deps":{"hashes":[["5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC","db upgrade strategy\n"],["AA",null],["NDMM44EV2XD5RP7J4Q25ZX52LUP7WOMTKO3C2PDXW7IWFEVWUW6QC","revamp table structure in preparation for scraped data. also change open hours and added many constraints. normalize strain family names\n"],["GS52J542QU5MGFB2ZMJSQMSD7W4WRGBSX3ZDD4C6EFVUPYGSQ36QC","Update README.md"],["E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC","sql schema\n"],["SRZ5TOOVHZKN3F2QM2IZHGYMZQW2TEXUUJFOCNPHPISJL7QSEPDAC","typo\n"],["ZI2RJOZ2HXBHX7L54BTSDKESY6NG5KBJLVHCNY7K7ZLGIUOIHQUQC","cloudinary upload preset return, periods, schema cleanup, return options for create product, get rid of first_last_agg(still need to tweak another query)\n"],["Y4W4MACPKH3IVO6JIQYGN4V5LR6EM6RPZEJ4RHH6ZBZUDA63AGRQC","dependencies and instructions and permission and newline\n"],["YHCZCZJ2VJPIBOSIHZIBRHITOU47MOA52LYIIFGV7YIPP7ZC4XCQC","Update README.md"],["QHLBAGVYOB6KEAHAJMUTN236VSPFNOYAIKAPQJPF75YBBUXLU5PQC","Update README.md"],["T2BEPW7GP45VJBMXIPJ2RX6W2FNULCLZWLSRW2LFF43WWGUM24DQC","Create README.md"]],"deps":["NDMM44EV2XD5RP7J4Q25ZX52LUP7WOMTKO3C2PDXW7IWFEVWUW6QC","GS52J542QU5MGFB2ZMJSQMSD7W4WRGBSX3ZDD4C6EFVUPYGSQ36QC"],"known":["E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC","QHLBAGVYOB6KEAHAJMUTN236VSPFNOYAIKAPQJPF75YBBUXLU5PQC","YHCZCZJ2VJPIBOSIHZIBRHITOU47MOA52LYIIFGV7YIPP7ZC4XCQC","ZI2RJOZ2HXBHX7L54BTSDKESY6NG5KBJLVHCNY7K7ZLGIUOIHQUQC","Y4W4MACPKH3IVO6JIQYGN4V5LR6EM6RPZEJ4RHH6ZBZUDA63AGRQC","SRZ5TOOVHZKN3F2QM2IZHGYMZQW2TEXUUJFOCNPHPISJL7QSEPDAC"]},"hunks":[{"Edit":{"inode":{"change":11,"pos":12},"path":"README.md","line":51,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":505},"to":{"change":4,"start":0,"end":2},"introduced_by":4}],"inode":{"change":11,"pos":12}}},"contents":[{"Del":{"text":"\r","pos":"YHCZCZJ2VJPIBOSIHZIBRHITOU47MOA52LYIIFGV7YIPP7ZC4XCQC:1"}}]}},{"Edit":{"inode":{"change":11,"pos":12},"path":"README.md","line":56,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":559}],"down_context":[],"flag":"BLOCK","start":0,"end":1068,"inode":{"change":11,"pos":12}}},"contents":[{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1"}},{"Add":{"text":"# updating a database\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:24"}},{"Add":{"text":"```\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:29"}},{"Add":{"text":"#for dev databases\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:49"}},{"Add":{"text":"psql -U postgres -c \"create database clone with template lobomj\"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:115"}},{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:117"}},{"Add":{"text":"#todo: https://serverfault.com/q/627169\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:158"}},{"Add":{"text":"#OR from production to local https://dba.stackexchange.com/q/82161\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:226"}},{"Add":{"text":"dropdb -U postgres clone\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:252"}},{"Add":{"text":"createdb -U postgres clone\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:280"}},{"Add":{"text":"pg_dump \"port= host= user= dbname= sslcert= sslkey= sslrootcert= sslmode=verify-full\" -d lobomj -Fc | pg_restore -U postgres -d clone\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:456"}},{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:458"}},{"Add":{"text":"psql -U postgres -f initialize.sql -v name=diffme\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:509"}},{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:511"}},{"Add":{"text":"pg_dump -U postgres clone --schema-only -f clone.sql\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:565"}},{"Add":{"text":"pg_dump -U postgres diffme --schema-only -f diffme.sql\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:621"}},{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:623"}},{"Add":{"text":"#diff with your favourite tool\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:655"}},{"Add":{"text":"#write queries to alter database to update.sql\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:703"}},{"Add":{"text":"psql -U postgres -d clone -f update.sql\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:744"}},{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:746"}},{"Add":{"text":"#run tests\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:758"}},{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:760"}},{"Add":{"text":"#update dev\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:773"}},{"Add":{"text":"psql -U postgres -d lobomj -f update.sql\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:815"}},{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:817"}},{"Add":{"text":"#OR propagate local changes to production\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:860"}},{"Add":{"text":"psql \"port= host= user= dbname= sslcert= sslkey= sslrootcert= sslmode=verify-full\" -d lobomj -f update.sql\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1009"}},{"Add":{"text":"\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1011"}},{"Add":{"text":"dropdb -U postgres clone\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1037"}},{"Add":{"text":"dropdb -U postgres diffme\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1064"}},{"Add":{"text":"```","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1068"}}]}},{"Replacement":{"inode":{"change":4,"pos":17},"path":"initialize.sql","line":1,"ins":{"up_context":[{"change":4,"pos":17}],"down_context":[{"change":2,"pos":4355}],"flag":"BLOCK","start":1069,"end":1271,"inode":{"change":4,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":17},"to":{"change":4,"start":19,"end":42},"introduced_by":4},{"previous":"","flag":"DELETED","from":{"change":4,"pos":42},"to":{"change":4,"start":18,"end":54},"introduced_by":4},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":4,"pos":17},"to":{"change":4,"start":18,"end":54},"introduced_by":4}],"inode":{"change":4,"pos":17}},"ins_contents":[{"Add":{"text":"--https://stackoverflow.com/q/32582600/\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1109"}},{"Add":{"text":"\\set name :name\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1126"}},{"Add":{"text":"select case\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1139"}},{"Add":{"text":"\twhen :'name' = ':name' then 'robomj'\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1178"}},{"Add":{"text":"\telse :'name'\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1193"}},{"Add":{"text":"end as \"name\" \\gset\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1214"}},{"Add":{"text":"drop database :name;\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1236"}},{"Add":{"text":"create database :name;\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1260"}},{"Add":{"text":"\\c :name\r","pos":"5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC:1270"}}],"del_contents":[{"Del":{"text":"drop database lobomj;\r","pos":"ZI2RJOZ2HXBHX7L54BTSDKESY6NG5KBJLVHCNY7K7ZLGIUOIHQUQC:41"}},{"Del":{"text":"create database lobomj;\r","pos":"E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC:42"}},{"Del":{"text":"\\c lobomj\r","pos":"E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC:53"}}]}}],"owner":"boogerlad","repo":"mj","token":"zJI/m0pc0lKBrzeePxTbEowjTxeCM/JhYOZDWq0tVwg=","login":null}

…

Dependencies

Change contents

Review