{"header":{"message":"the store table has addresses parsed by google. for the unique constraint to work on insert, parsed addresses are required. the store scraper naively attempts to insert every store. this works, but is expensive(~10usd). introduce store_temp table which contains the raw addresses from the previous scrape to insert only new stores and show removed stores. should probably truncate store_temp once a month to update longitude, latitude and open times\n","description":null,"timestamp":"2020-08-25T02:38:21Z","authors":[{"email":"boogerlad@gmail.com","name":"boogerlad"}]},"hash":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC","authors":[],"deps":{"hashes":[["XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC","the store table has addresses parsed by google. for the unique constraint to work on insert, parsed addresses are required. the store scraper naively attempts to insert every store. this works, but is expensive(~10usd). introduce store_temp table which contains the raw addresses from the previous scrape to insert only new stores and show removed stores. should probably truncate store_temp once a month to update longitude, latitude and open times\n"],["AA",null],["XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC","constraint for store times to be minutes within a week\nstore_open_exception table for things like holidays\ncommonize store name sanitization and geocoding/timezone/osrm hints\nrebrand summit cannabis dc properly\nupdate create_store to work with commonized functions, new times table\nremove duplicated `require`s\n"],["PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC","store scraper canada wide\njoined_name and name for stores. name is intended to be editable, while joined_name is used as the unique key / what the scraper outputs\nconstraints for longitude latitude\nphone number extension field\ndenormalize store times since updating an individual entry doesn't make sense. need to consider all store times to prevent overlap\nget rid of upi_store_6 in favor of empty string for address2 instead of null since upsert can only have one conflict target\nfix fetching of products - wrong data type in function signature. since data gets serialized to json, decimal(5,2) will potentially have rounding issues due to float\n"],["NHVZFKZDPQGCZ6UOVQU5U3Q3SOAKGOGZNFIE7C6IB6YP3ZS4VVDAC","there's a difference between null \"open\"(unknown) and empty array \"open\"(never open)\nget rid of idk trigger since constraint has been relaxed and doesn't really save any code and not worth performance hit\n"],["E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC","sql schema\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"],["SE6MCCXTIXSGMAH5EL7EPDXIQKV6THCCY2H4OQJJQOHCUQAWE5VQC","ocs.ca scraper\n"]],"deps":["XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC"],"known":["PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC","NHVZFKZDPQGCZ6UOVQU5U3Q3SOAKGOGZNFIE7C6IB6YP3ZS4VVDAC"]},"hunks":[{"Edit":{"inode":{"change":6,"pos":17},"path":"initialize.sql","line":48,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":209}],"down_context":[{"change":7,"pos":146}],"flag":"BLOCK","start":0,"end":161,"inode":{"change":6,"pos":17}}},"contents":[{"Add":{"text":"create table store_temp (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:26"}},{"Add":{"text":"\tjoined_name citext,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:48"}},{"Add":{"text":"\taddress citext,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:66"}},{"Add":{"text":"\taddress2 citext,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:85"}},{"Add":{"text":"\tcity citext,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:100"}},{"Add":{"text":"\tregion citext,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:117"}},{"Add":{"text":"\tcountry citext,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:135"}},{"Add":{"text":"\tpostal_code citext\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:156"}},{"Add":{"text":");\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:160"}}]}},{"Edit":{"inode":{"change":8,"pos":4897},"path":"scrape/common.js","line":104,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":5072}],"down_context":[{"change":2,"pos":5072}],"flag":"BLOCK","start":162,"end":272,"inode":{"change":8,"pos":4897}}},"contents":[{"Add":{"text":"\t\t\tlocation.lng = (new Big(location.lng)).toFixed(7);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:216"}},{"Add":{"text":"\t\t\tlocation.lat = (new Big(location.lat)).toFixed(7);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:271"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":13,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":7664}],"down_context":[{"change":3,"pos":7664}],"flag":"BLOCK","start":273,"end":289,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:288"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":16,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":7702},"to":{"change":3,"start":7702,"end":7723},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\tlet address2 = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7722"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":17,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":7740}],"down_context":[{"change":3,"pos":7740}],"flag":"BLOCK","start":290,"end":1273,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet postal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:313"}},{"Add":{"text":"\tfor(let i = 0; i < ab.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:352"}},{"Add":{"text":"\t\tab[i] = ab[i].split('\\t');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:382"}},{"Add":{"text":"\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:398"}},{"Add":{"text":"\t\tnames.push(ab[i][1] = sanitize_name(ab[i][1]));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:449"}},{"Add":{"text":"\t\taddress.push(ab[i][2]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:476"}},{"Add":{"text":"\t\tpostal_code.push(ab[i][3]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:507"}},{"Add":{"text":"\t\tcity.push(ab[i][0]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:531"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:535"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:559"}},{"Add":{"text":"\t\t`create temporary table alberta as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:598"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:610"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:627"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:647"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:665"}},{"Add":{"text":"\t\t\t$3::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:683"}},{"Add":{"text":"\t\t\t$4::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:701"}},{"Add":{"text":"\t\t\t$5::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:718"}},{"Add":{"text":"\t\t) as t(idx, joined_name, address, city, postal_code)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:776"}},{"Add":{"text":"\t\t[idx, names, address, city, postal_code]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:820"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:825"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:857"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:871"}},{"Add":{"text":"\t\tfrom alberta\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:887"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:909"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:920"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:940"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:950"}},{"Add":{"text":"\t\t\t\tjoined_name = alberta.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:993"}},{"Add":{"text":"\t\t\t\taddress = alberta.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1028"}},{"Add":{"text":"\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1051"}},{"Add":{"text":"\t\t\t\tcity = alberta.city and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1080"}},{"Add":{"text":"\t\t\t\tregion = 'alberta' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1108"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1136"}},{"Add":{"text":"\t\t\t\tpostal_code = alberta.postal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1175"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1180"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1208"}},{"Add":{"text":"\tnames = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1222"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1238"}},{"Add":{"text":"\tlet address2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1259"}},{"Add":{"text":"\tcity = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1272"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":60,"ins":{"up_context":[{"change":3,"pos":7779}],"down_context":[{"change":3,"pos":7803}],"flag":"BLOCK","start":1274,"end":1294,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":7779},"to":{"change":3,"start":7779,"end":7803},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tpostal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1293"}}],"del_contents":[{"Del":{"text":"\tlet postal_code = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7802"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":67,"ins":{"up_context":[{"change":3,"pos":7938}],"down_context":[{"change":3,"pos":8007}],"flag":"BLOCK","start":1295,"end":1358,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":7938},"to":{"change":3,"start":7938,"end":8007},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tfor(let i = 0; i < idx.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1334"}},{"Add":{"text":"\t\tlet t = ab[idx[i]];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1357"}}],"del_contents":[{"Del":{"text":"\tfor(let i = 0; i < ab.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7976"}},{"Del":{"text":"\t\tlet t = ab[i].split('\\t');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:8006"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":74,"ins":{"up_context":[{"change":3,"pos":8123}],"down_context":[{"change":3,"pos":8146}],"flag":"BLOCK","start":1359,"end":1379,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":8123},"to":{"change":3,"start":8123,"end":8146},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tconsole.log(t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1378"}}],"del_contents":[{"Del":{"text":"\t\t\tconsole.log(t[1]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:8145"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":86,"ins":{"up_context":[{"change":3,"pos":8416}],"down_context":[{"change":3,"pos":8452}],"flag":"BLOCK","start":1380,"end":1401,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":8416},"to":{"change":3,"start":8416,"end":8452},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\tnames.push(t[1]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1400"}}],"del_contents":[{"Del":{"text":"\t\tnames.push(sanitize_name(t[1]));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:8451"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":206,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":11748}],"down_context":[{"change":3,"pos":11748}],"flag":"BLOCK","start":1402,"end":1436,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1418"}},{"Add":{"text":"\t\tlet jdx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1435"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":210,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":11788},"to":{"change":3,"start":11788,"end":11810},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\t\tlet address2 = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:11809"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":211,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":11828}],"down_context":[{"change":3,"pos":11828}],"flag":"BLOCK","start":1437,"end":2504,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\tfor(let i = 0; i < idk.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1477"}},{"Add":{"text":"\t\t\tfor(let j = 0; j < results[i].length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1526"}},{"Add":{"text":"\t\t\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1544"}},{"Add":{"text":"\t\t\t\tjdx.push(j);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1562"}},{"Add":{"text":"\t\t\t\tnames.push(results[i][j][0] = sanitize_name(results[i][j][0]));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1631"}},{"Add":{"text":"\t\t\t\taddress.push(results[i][j][1]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1668"}},{"Add":{"text":"\t\t\t\tcity.push(idk[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1692"}},{"Add":{"text":"\t\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1698"}},{"Add":{"text":"\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1703"}},{"Add":{"text":"\t\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1728"}},{"Add":{"text":"\t\t\t`create temporary table manitoba as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1769"}},{"Add":{"text":"\t\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1782"}},{"Add":{"text":"\t\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1800"}},{"Add":{"text":"\t\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1821"}},{"Add":{"text":"\t\t\t\t$2::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1842"}},{"Add":{"text":"\t\t\t\t$3::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1861"}},{"Add":{"text":"\t\t\t\t$4::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1880"}},{"Add":{"text":"\t\t\t\t$5::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1898"}},{"Add":{"text":"\t\t\t) as t(idx, jdx, joined_name, address, city)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1949"}},{"Add":{"text":"\t\t\t[idx, jdx, names, address, city]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1986"}},{"Add":{"text":"\t\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:1992"}},{"Add":{"text":"\t\tlet temp = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2030"}},{"Add":{"text":"\t\t\tselect idx, jdx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2050"}},{"Add":{"text":"\t\t\tfrom manitoba\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2068"}},{"Add":{"text":"\t\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2091"}},{"Add":{"text":"\t\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2103"}},{"Add":{"text":"\t\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2124"}},{"Add":{"text":"\t\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2135"}},{"Add":{"text":"\t\t\t\t\tjoined_name = manitoba.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2180"}},{"Add":{"text":"\t\t\t\t\taddress = manitoba.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2217"}},{"Add":{"text":"\t\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2241"}},{"Add":{"text":"\t\t\t\t\tcity = manitoba.city and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2272"}},{"Add":{"text":"\t\t\t\t\tregion = 'manitoba' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2302"}},{"Add":{"text":"\t\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2331"}},{"Add":{"text":"\t\t\t\t\tpostal_code = ''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2354"}},{"Add":{"text":"\t\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2360"}},{"Add":{"text":"\t\t`)).rows;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2373"}},{"Add":{"text":"\t\tidx = temp.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2404"}},{"Add":{"text":"\t\tjdx = temp.map(x => x.jdx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2435"}},{"Add":{"text":"\t\tnames = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2450"}},{"Add":{"text":"\t\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2467"}},{"Add":{"text":"\t\tlet address2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2489"}},{"Add":{"text":"\t\tcity = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2503"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":262,"ins":{"up_context":[{"change":3,"pos":12016}],"down_context":[{"change":3,"pos":13061}],"flag":"BLOCK","start":2505,"end":3743,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":12016},"to":{"change":3,"start":12016,"end":13061},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\tfor(let k = 0; k < idx.length; ++k) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2545"}},{"Add":{"text":"\t\t\tconst i = idx[k];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2567"}},{"Add":{"text":"\t\t\tconst j = jdx[k];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2589"}},{"Add":{"text":"\t\t\tif(results[i][j][1] === 'Otineka Mall' && results[i][j][0] === 'Meta') {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2666"}},{"Add":{"text":"\t\t\t\tnames.push(results[i][j][0]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2701"}},{"Add":{"text":"\t\t\t\taddress.push('Otineka Mall Highway 10 North');//gmaps ok\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2763"}},{"Add":{"text":"\t\t\t\taddress2.push('Unit 128');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2795"}},{"Add":{"text":"\t\t\t\tcity.push('Opaskwayak');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2825"}},{"Add":{"text":"\t\t\t\tregion.push('Manitoba');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2855"}},{"Add":{"text":"\t\t\t\tcountry.push('Canada');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2884"}},{"Add":{"text":"\t\t\t\tpostal_code.push('R0B2J0');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2917"}},{"Add":{"text":"\t\t\t\tlongitude.push('-101.261585');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2953"}},{"Add":{"text":"\t\t\t\tlatitude.push('53.834096');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:2986"}},{"Add":{"text":"\t\t\t\tosrm_hint_foot.push(await request(`http://127.0.0.1:5000/nearest/v1/fuck/-101.261585,53.834096`).then(x => JSON.parse(x).waypoints[0].hint));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3133"}},{"Add":{"text":"\t\t\t\tosrm_hint_car.push(await request(`http://127.0.0.1:5001/nearest/v1/fuck/-101.261585,53.834096`).then(x => JSON.parse(x).waypoints[0].hint));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3279"}},{"Add":{"text":"\t\t\t\ttimezone.push('America/Winnipeg');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3319"}},{"Add":{"text":"\t\t\t} else {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3332"}},{"Add":{"text":"\t\t\t\tlet r;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3344"}},{"Add":{"text":"\t\t\t\ttry {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3355"}},{"Add":{"text":"\t\t\t\t\tr = await g(`${results[i][j][1]} ${idk[i]} manitoba canada`);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3423"}},{"Add":{"text":"\t\t\t\t} catch(e) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3441"}},{"Add":{"text":"\t\t\t\t\tconsole.error(e);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3465"}},{"Add":{"text":"\t\t\t\t\tconsole.log(results[i][j]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3499"}},{"Add":{"text":"\t\t\t\t\tcontinue;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3515"}},{"Add":{"text":"\t\t\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3522"}},{"Add":{"text":"\t\t\t\tif(!pc.test(r[0].postal_code)) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3560"}},{"Add":{"text":"\t\t\t\t\tif(results[i][j][1] === '300A North Railway Street') {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3621"}},{"Add":{"text":"\t\t\t\t\t\tr[0].postal_code = 'R6M1S7';\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3657"}},{"Add":{"text":"\t\t\t\t\t} else {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3672"}},{"Add":{"text":"\t\t\t\t\t\tconsole.error('postal_code goofup', r, results[i][j], idk[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3742"}}],"del_contents":[{"Del":{"text":"\t\tfor(let i = 0; i < idk.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12056"}},{"Del":{"text":"\t\t\tfor(let j = 0; j < results[i].length; ++j) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12105"}},{"Del":{"text":"\t\t\t\tlet lol = sanitize_name(results[i][j][0]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12153"}},{"Del":{"text":"\t\t\t\tif(results[i][j][1] === 'Otineka Mall' && lol === 'Meta') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12218"}},{"Del":{"text":"\t\t\t\t\tnames.push(lol);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12241"}},{"Del":{"text":"\t\t\t\t\taddress.push('Otineka Mall Highway 10 North');//gmaps ok\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12304"}},{"Del":{"text":"\t\t\t\t\taddress2.push('Unit 128');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12337"}},{"Del":{"text":"\t\t\t\t\tcity.push('Opaskwayak');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12368"}},{"Del":{"text":"\t\t\t\t\tregion.push('Manitoba');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12399"}},{"Del":{"text":"\t\t\t\t\tcountry.push('Canada');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12429"}},{"Del":{"text":"\t\t\t\t\tpostal_code.push('R0B2J0');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12463"}},{"Del":{"text":"\t\t\t\t\tlongitude.push('-101.261585');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12500"}},{"Del":{"text":"\t\t\t\t\tlatitude.push('53.834096');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12534"}},{"Del":{"text":"\t\t\t\t\tosrm_hint_foot.push(await request(`http://127.0.0.1:5000/nearest/v1/fuck/-101.261585,53.834096`).then(x => JSON.parse(x).waypoints[0].hint));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12682"}},{"Del":{"text":"\t\t\t\t\tosrm_hint_car.push(await request(`http://127.0.0.1:5001/nearest/v1/fuck/-101.261585,53.834096`).then(x => JSON.parse(x).waypoints[0].hint));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12829"}},{"Del":{"text":"\t\t\t\t\ttimezone.push('America/Winnipeg');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12870"}},{"Del":{"text":"\t\t\t\t} else {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12884"}},{"Del":{"text":"\t\t\t\t\tlet r;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12897"}},{"Del":{"text":"\t\t\t\t\ttry {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12909"}},{"Del":{"text":"\t\t\t\t\t\tr = await g(`${results[i][j][1]} ${idk[i]} manitoba canada`);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12978"}},{"Del":{"text":"\t\t\t\t\t} catch(e) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:12997"}},{"Del":{"text":"\t\t\t\t\t\tconsole.error(e);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13022"}},{"Del":{"text":"\t\t\t\t\t\tconsole.log(results[i][j][0]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13060"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":293,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":13078},"to":{"change":3,"start":13078,"end":13338},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\t\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13085"}},{"Del":{"text":"\t\t\t\t\tif(!pc.test(r[0].postal_code)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13124"}},{"Del":{"text":"\t\t\t\t\t\tif(results[i][j][1] === '300A North Railway Street') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13186"}},{"Del":{"text":"\t\t\t\t\t\t\tr[0].postal_code = 'R6M1S7';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13223"}},{"Del":{"text":"\t\t\t\t\t\t} else {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13239"}},{"Del":{"text":"\t\t\t\t\t\t\tconsole.error('postal_code goofup', r, results[i][j], idk[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13310"}},{"Del":{"text":"\t\t\t\t\t\t\tcontinue;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13328"}},{"Del":{"text":"\t\t\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13337"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":294,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":13346},"to":{"change":3,"start":13346,"end":13787},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\t\t\t\t\tnames.push(lol);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13368"}},{"Del":{"text":"\t\t\t\t\taddress.push(r[0].address);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13402"}},{"Del":{"text":"\t\t\t\t\taddress2.push(results[i][j][1] === '300A North Railway Street' ? 'A' : r[0].address2);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13495"}},{"Del":{"text":"\t\t\t\t\tcity.push(r[0].city);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13523"}},{"Del":{"text":"\t\t\t\t\tregion.push(r[0].region);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13555"}},{"Del":{"text":"\t\t\t\t\tcountry.push(r[0].country);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13589"}},{"Del":{"text":"\t\t\t\t\tpostal_code.push(r[0].postal_code);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13631"}},{"Del":{"text":"\t\t\t\t\tlongitude.push(r[1].lng);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13663"}},{"Del":{"text":"\t\t\t\t\tlatitude.push(r[1].lat);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13694"}},{"Del":{"text":"\t\t\t\t\tosrm_hint_foot.push(r[3]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13727"}},{"Del":{"text":"\t\t\t\t\tosrm_hint_car.push(r[4]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13759"}},{"Del":{"text":"\t\t\t\t\ttimezone.push(r[2]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:13786"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":295,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":13794}],"down_context":[{"change":3,"pos":13794}],"flag":"BLOCK","start":3744,"end":4186,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\t\t\tnames.push(results[i][j][0]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3778"}},{"Add":{"text":"\t\t\t\taddress.push(r[0].address);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3811"}},{"Add":{"text":"\t\t\t\taddress2.push(results[i][j][1] === '300A North Railway Street' ? 'A' : r[0].address2);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3903"}},{"Add":{"text":"\t\t\t\tcity.push(r[0].city);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3930"}},{"Add":{"text":"\t\t\t\tregion.push(r[0].region);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3961"}},{"Add":{"text":"\t\t\t\tcountry.push(r[0].country);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:3994"}},{"Add":{"text":"\t\t\t\tpostal_code.push(r[0].postal_code);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4035"}},{"Add":{"text":"\t\t\t\tlongitude.push(r[1].lng);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4066"}},{"Add":{"text":"\t\t\t\tlatitude.push(r[1].lat);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4096"}},{"Add":{"text":"\t\t\t\tosrm_hint_foot.push(r[3]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4128"}},{"Add":{"text":"\t\t\t\tosrm_hint_car.push(r[4]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4159"}},{"Add":{"text":"\t\t\t\ttimezone.push(r[2]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4185"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":406,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":16631}],"down_context":[{"change":3,"pos":16631}],"flag":"BLOCK","start":4187,"end":4203,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4202"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":409,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":16669},"to":{"change":3,"start":16669,"end":16690},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\tlet address2 = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:16689"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":410,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":16707}],"down_context":[{"change":3,"pos":16707}],"flag":"BLOCK","start":4204,"end":5096,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tfor(let i = 0; i < results.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4247"}},{"Add":{"text":"\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4263"}},{"Add":{"text":"\t\tnames.push(results[i][0] = sanitize_name(results[i][0]));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4324"}},{"Add":{"text":"\t\taddress.push(results[i][1]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4356"}},{"Add":{"text":"\t\tcity.push(results[i][2]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4385"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4389"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4413"}},{"Add":{"text":"\t\t`create temporary table saskatchewan as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4457"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4469"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4486"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4506"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4524"}},{"Add":{"text":"\t\t\t$3::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4542"}},{"Add":{"text":"\t\t\t$4::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4559"}},{"Add":{"text":"\t\t) as t(idx, joined_name, address, city)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4604"}},{"Add":{"text":"\t\t[idx, names, address, city]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4635"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4640"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4672"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4686"}},{"Add":{"text":"\t\tfrom saskatchewan\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4707"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4729"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4740"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4760"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4770"}},{"Add":{"text":"\t\t\t\tjoined_name = saskatchewan.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4818"}},{"Add":{"text":"\t\t\t\taddress = saskatchewan.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4858"}},{"Add":{"text":"\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4881"}},{"Add":{"text":"\t\t\t\tcity = saskatchewan.city and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4915"}},{"Add":{"text":"\t\t\t\tregion = 'saskatchewan' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4948"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4976"}},{"Add":{"text":"\t\t\t\tpostal_code = ''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:4998"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5003"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5031"}},{"Add":{"text":"\tnames = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5045"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5061"}},{"Add":{"text":"\tlet address2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5082"}},{"Add":{"text":"\tcity = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5095"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":456,"ins":{"up_context":[{"change":3,"pos":16903}],"down_context":[{"change":3,"pos":16947}],"flag":"BLOCK","start":5097,"end":5158,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":16903},"to":{"change":3,"start":16903,"end":16947},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5136"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5157"}}],"del_contents":[{"Del":{"text":"\tfor(let i = 0; i < results.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:16946"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":472,"ins":{"up_context":[{"change":3,"pos":17763}],"down_context":[{"change":3,"pos":17818}],"flag":"BLOCK","start":5159,"end":5201,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":17763},"to":{"change":3,"start":17763,"end":17818},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t} else if(results[i][0] === 'Vatic') {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5200"}}],"del_contents":[{"Del":{"text":"\t\t} else if(results[i][0] === 'Vatic Cannabis Co.') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:17817"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":496,"ins":{"up_context":[{"change":3,"pos":18815}],"down_context":[{"change":3,"pos":18848}],"flag":"BLOCK","start":5202,"end":5232,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":18815},"to":{"change":3,"start":18815,"end":18848},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\t\tconsole.log(results[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5231"}}],"del_contents":[{"Del":{"text":"\t\t\t\tconsole.log(results[i][0]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:18847"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":503,"ins":{"up_context":[{"change":3,"pos":18984}],"down_context":[{"change":3,"pos":19030}],"flag":"BLOCK","start":5233,"end":5264,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":18984},"to":{"change":3,"start":18984,"end":19030},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tnames.push(results[i][0]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5263"}}],"del_contents":[{"Del":{"text":"\t\t\tnames.push(sanitize_name(results[i][0]));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:19029"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":645,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":22892}],"down_context":[{"change":3,"pos":22892}],"flag":"BLOCK","start":5265,"end":5281,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5280"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":647,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":22912}],"down_context":[{"change":3,"pos":22912}],"flag":"BLOCK","start":5282,"end":5931,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tfor(let i = 0; i < results.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5325"}},{"Add":{"text":"\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5341"}},{"Add":{"text":"\t\taddress.push(results[i][1]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5373"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5377"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5401"}},{"Add":{"text":"\t\t`create temporary table newbrunswick as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5445"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5457"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5474"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5494"}},{"Add":{"text":"\t\t\t$2::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5511"}},{"Add":{"text":"\t\t) as t(idx, address)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5537"}},{"Add":{"text":"\t\t[idx, address]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5555"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5560"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5592"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5606"}},{"Add":{"text":"\t\tfrom newbrunswick\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5627"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5649"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5660"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5680"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5690"}},{"Add":{"text":"\t\t\t\tjoined_name = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5716"}},{"Add":{"text":"\t\t\t\taddress = newbrunswick.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5756"}},{"Add":{"text":"\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5779"}},{"Add":{"text":"\t\t\t\tcity = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5798"}},{"Add":{"text":"\t\t\t\tregion = 'newbrunswick' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5831"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5859"}},{"Add":{"text":"\t\t\t\tpostal_code = ''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5881"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5886"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5914"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5930"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":688,"ins":{"up_context":[{"change":3,"pos":23147}],"down_context":[{"change":3,"pos":23191}],"flag":"BLOCK","start":5932,"end":5993,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":23147},"to":{"change":3,"start":23147,"end":23191},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5971"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:5992"}}],"del_contents":[{"Del":{"text":"\tfor(let i = 0; i < results.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:23190"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":718,"ins":{"up_context":[{"change":3,"pos":24654}],"down_context":[{"change":3,"pos":24687}],"flag":"BLOCK","start":5994,"end":6027,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":24654},"to":{"change":3,"start":24654,"end":24687},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\t\tconsole.log(results[i][1]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6026"}}],"del_contents":[{"Del":{"text":"\t\t\t\tconsole.log(results[i][0]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:24686"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":722,"ins":{"up_context":[{"change":3,"pos":24745}],"down_context":[{"change":3,"pos":24802}],"flag":"BLOCK","start":6028,"end":6088,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":24745},"to":{"change":3,"start":24745,"end":24802},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\t\tconsole.error('postal_code goofup', r, results[i][1]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6087"}}],"del_contents":[{"Del":{"text":"\t\t\t\tconsole.error('postal_code goofup', r, results[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:24801"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":842,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":28268}],"down_context":[{"change":3,"pos":28268}],"flag":"BLOCK","start":6089,"end":6105,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6104"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":845,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":28306}],"down_context":[{"change":3,"pos":28306}],"flag":"BLOCK","start":6106,"end":7156,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet city = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6122"}},{"Add":{"text":"\tlet postal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6146"}},{"Add":{"text":"\tfor(let i = 0; i < bc.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6185"}},{"Add":{"text":"\t\tif(bc[i].Status === 'Open') {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6218"}},{"Add":{"text":"\t\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6235"}},{"Add":{"text":"\t\t\tnames.push(bc[i].Name = sanitize_name(bc[i].Name));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6291"}},{"Add":{"text":"\t\t\taddress.push(bc[i].Address);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6324"}},{"Add":{"text":"\t\t\tcity.push(bc[i].City);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6351"}},{"Add":{"text":"\t\t\tpostal_code.push(bc[i].Postal);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6387"}},{"Add":{"text":"\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6392"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6396"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6420"}},{"Add":{"text":"\t\t`create temporary table britishcolumbia as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6467"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6479"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6496"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6516"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6534"}},{"Add":{"text":"\t\t\t$3::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6552"}},{"Add":{"text":"\t\t\t$4::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6570"}},{"Add":{"text":"\t\t\t$5::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6587"}},{"Add":{"text":"\t\t) as t(idx, joined_name, address, city, postal_code)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6645"}},{"Add":{"text":"\t\t[idx, names, address, city, postal_code]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6689"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6694"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6726"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6740"}},{"Add":{"text":"\t\tfrom britishcolumbia\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6764"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6786"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6797"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6817"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6827"}},{"Add":{"text":"\t\t\t\tjoined_name = britishcolumbia.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6878"}},{"Add":{"text":"\t\t\t\taddress = britishcolumbia.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6921"}},{"Add":{"text":"\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6944"}},{"Add":{"text":"\t\t\t\tcity = britishcolumbia.city and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:6981"}},{"Add":{"text":"\t\t\t\tregion = 'britishcolumbia' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7017"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7045"}},{"Add":{"text":"\t\t\t\tpostal_code = britishcolumbia.postal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7092"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7097"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7125"}},{"Add":{"text":"\tnames = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7139"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7155"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":887,"ins":{"up_context":[{"change":3,"pos":28327}],"down_context":[{"change":3,"pos":28344}],"flag":"BLOCK","start":7157,"end":7170,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":28327},"to":{"change":3,"start":28327,"end":28344},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tcity = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7169"}}],"del_contents":[{"Del":{"text":"\tlet city = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28343"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":890,"ins":{"up_context":[{"change":3,"pos":28383}],"down_context":[{"change":3,"pos":28407}],"flag":"BLOCK","start":7171,"end":7191,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":28383},"to":{"change":3,"start":28383,"end":28407},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tpostal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7190"}}],"del_contents":[{"Del":{"text":"\tlet postal_code = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28406"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":897,"ins":{"up_context":[{"change":3,"pos":28542}],"down_context":[{"change":3,"pos":28797}],"flag":"BLOCK","start":7192,"end":7704,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":28542},"to":{"change":3,"start":28542,"end":28797},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7231"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7252"}},{"Add":{"text":"\t\tlet r;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7262"}},{"Add":{"text":"\t\ttry {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7271"}},{"Add":{"text":"\t\t\tr = await g(`${bc[i].Address} ${bc[i].City} british columbia ${bc[i].Postal} canada`);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7362"}},{"Add":{"text":"\t\t} catch(e) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7378"}},{"Add":{"text":"\t\t\tconsole.error(e);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7400"}},{"Add":{"text":"\t\t\tconsole.log(bc[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7424"}},{"Add":{"text":"\t\t\tcontinue;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7438"}},{"Add":{"text":"\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7443"}},{"Add":{"text":"\t\tif(!pc.test(r[0].postal_code)) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7479"}},{"Add":{"text":"\t\t\tbc[i].Postal = bc[i].Postal.replace(/\\s+/g, '');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7532"}},{"Add":{"text":"\t\t\tif(r[0].postal_code.length === 3 && bc[i].Postal.length === 6) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7601"}},{"Add":{"text":"\t\t\t\tr[0].postal_code = bc[i].Postal\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7638"}},{"Add":{"text":"\t\t\t} else {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7651"}},{"Add":{"text":"\t\t\t\tconsole.error('postal_code goofup', r, bc[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7703"}}],"del_contents":[{"Del":{"text":"\tfor(let i = 0; i < bc.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28580"}},{"Del":{"text":"\t\tif(bc[i].Status === 'Open') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28613"}},{"Del":{"text":"\t\t\tlet r;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28624"}},{"Del":{"text":"\t\t\ttry {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28634"}},{"Del":{"text":"\t\t\t\tr = await g(`${bc[i].Address} ${bc[i].City} british columbia ${bc[i].Postal} canada`);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28726"}},{"Del":{"text":"\t\t\t} catch(e) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28743"}},{"Del":{"text":"\t\t\t\tconsole.error(e);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28766"}},{"Del":{"text":"\t\t\t\tconsole.log(bc[i].Name);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28796"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":915,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":28818},"to":{"change":3,"start":28818,"end":29524},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\t\t\tif(!pc.test(r[0].postal_code)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28854"}},{"Del":{"text":"\t\t\t\tbc[i].Postal = bc[i].Postal.replace(/\\s+/g, '');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28908"}},{"Del":{"text":"\t\t\t\tif(r[0].postal_code.length === 3 && bc[i].Postal.length === 6) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:28978"}},{"Del":{"text":"\t\t\t\t\tr[0].postal_code = bc[i].Postal\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29016"}},{"Del":{"text":"\t\t\t\t} else {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29030"}},{"Del":{"text":"\t\t\t\t\tconsole.error('postal_code goofup', r, bc[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29083"}},{"Del":{"text":"\t\t\t\t\tcontinue;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29099"}},{"Del":{"text":"\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29106"}},{"Del":{"text":"\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29112"}},{"Del":{"text":"\t\t\tnames.push(sanitize_name(bc[i].Name));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29155"}},{"Del":{"text":"\t\t\taddress.push(r[0].address);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29187"}},{"Del":{"text":"\t\t\taddress2.push(r[0].address2);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29221"}},{"Del":{"text":"\t\t\tcity.push(r[0].city);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29247"}},{"Del":{"text":"\t\t\tregion.push(r[0].region);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29277"}},{"Del":{"text":"\t\t\tcountry.push(r[0].country);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29309"}},{"Del":{"text":"\t\t\tpostal_code.push(r[0].postal_code);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29349"}},{"Del":{"text":"\t\t\tlongitude.push(r[1].lng);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29379"}},{"Del":{"text":"\t\t\tlatitude.push(r[1].lat);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29408"}},{"Del":{"text":"\t\t\tosrm_hint_foot.push(r[3]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29439"}},{"Del":{"text":"\t\t\tosrm_hint_car.push(r[4]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29469"}},{"Del":{"text":"\t\t\ttimezone.push(r[2]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29494"}},{"Del":{"text":"\t\t\tphone.push(bc[i].Phone);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:29523"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":916,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":29529}],"down_context":[{"change":3,"pos":29529}],"flag":"BLOCK","start":7705,"end":8088,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\tnames.push(bc[i].Name);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7731"}},{"Add":{"text":"\t\taddress.push(r[0].address);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7762"}},{"Add":{"text":"\t\taddress2.push(r[0].address2);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7795"}},{"Add":{"text":"\t\tcity.push(r[0].city);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7820"}},{"Add":{"text":"\t\tregion.push(r[0].region);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7849"}},{"Add":{"text":"\t\tcountry.push(r[0].country);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7880"}},{"Add":{"text":"\t\tpostal_code.push(r[0].postal_code);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7919"}},{"Add":{"text":"\t\tlongitude.push(r[1].lng);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7948"}},{"Add":{"text":"\t\tlatitude.push(r[1].lat);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:7976"}},{"Add":{"text":"\t\tosrm_hint_foot.push(r[3]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8006"}},{"Add":{"text":"\t\tosrm_hint_car.push(r[4]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8035"}},{"Add":{"text":"\t\ttimezone.push(r[2]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8059"}},{"Add":{"text":"\t\tphone.push(bc[i].Phone);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8087"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1014,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":31878}],"down_context":[{"change":3,"pos":31878}],"flag":"BLOCK","start":8089,"end":8105,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8104"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1019,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":31954}],"down_context":[{"change":3,"pos":31954}],"flag":"BLOCK","start":8106,"end":9200,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet postal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8129"}},{"Add":{"text":"\tfor(let i = 0; i < nl.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8168"}},{"Add":{"text":"\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8184"}},{"Add":{"text":"\t\tnames.push(nl[i].name = sanitize_name(nl[i].name));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8239"}},{"Add":{"text":"\t\taddress.push(nl[i].address);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8271"}},{"Add":{"text":"\t\taddress2.push(nl[i].address2);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8305"}},{"Add":{"text":"\t\tcity.push(nl[i].city);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8331"}},{"Add":{"text":"\t\tpostal_code.push(nl[i].postal_zip);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8370"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8374"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8398"}},{"Add":{"text":"\t\t`create temporary table newfoundland as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8442"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8454"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8471"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8491"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8509"}},{"Add":{"text":"\t\t\t$3::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8527"}},{"Add":{"text":"\t\t\t$4::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8545"}},{"Add":{"text":"\t\t\t$5::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8563"}},{"Add":{"text":"\t\t\t$6::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8580"}},{"Add":{"text":"\t\t) as t(idx, joined_name, address, address2, city, postal_code)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8648"}},{"Add":{"text":"\t\t[idx, names, address, address2, city, postal_code]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8702"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8707"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8739"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8753"}},{"Add":{"text":"\t\tfrom newfoundland\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8774"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8796"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8807"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8827"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8837"}},{"Add":{"text":"\t\t\t\tjoined_name = newfoundland.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8885"}},{"Add":{"text":"\t\t\t\taddress = newfoundland.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8925"}},{"Add":{"text":"\t\t\t\taddress2 = newfoundland.address2 and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:8967"}},{"Add":{"text":"\t\t\t\tcity = newfoundland.city and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9001"}},{"Add":{"text":"\t\t\t\tregion = 'newfoundland' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9034"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9062"}},{"Add":{"text":"\t\t\t\tpostal_code = newfoundland.postal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9106"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9111"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9139"}},{"Add":{"text":"\tnames = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9153"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9169"}},{"Add":{"text":"\taddress2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9186"}},{"Add":{"text":"\tcity = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9199"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1063,"ins":{"up_context":[{"change":3,"pos":31993}],"down_context":[{"change":3,"pos":32017}],"flag":"BLOCK","start":9201,"end":9221,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":31993},"to":{"change":3,"start":31993,"end":32017},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tpostal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9220"}}],"del_contents":[{"Del":{"text":"\tlet postal_code = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:32016"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1071,"ins":{"up_context":[{"change":3,"pos":32174}],"down_context":[{"change":3,"pos":32213}],"flag":"BLOCK","start":9222,"end":9283,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":32174},"to":{"change":3,"start":32174,"end":32213},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9261"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9282"}}],"del_contents":[{"Del":{"text":"\tfor(let i = 0; i < nl.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:32212"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1078,"ins":{"up_context":[{"change":3,"pos":32379}],"down_context":[{"change":3,"pos":32408}],"flag":"BLOCK","start":9284,"end":9308,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":32379},"to":{"change":3,"start":32379,"end":32408},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tconsole.log(nl[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9307"}}],"del_contents":[{"Del":{"text":"\t\t\tconsole.log(nl[i].name);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:32407"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1091,"ins":{"up_context":[{"change":3,"pos":33152}],"down_context":[{"change":3,"pos":33194}],"flag":"BLOCK","start":9309,"end":9336,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":33152},"to":{"change":3,"start":33152,"end":33194},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\tnames.push(nl[i].name);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9335"}}],"del_contents":[{"Del":{"text":"\t\tnames.push(sanitize_name(nl[i].name));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:33193"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1194,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":36003}],"down_context":[{"change":3,"pos":36003}],"flag":"BLOCK","start":9337,"end":9353,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9352"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1198,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":36061}],"down_context":[{"change":3,"pos":36061}],"flag":"BLOCK","start":9354,"end":10481,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet postal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9377"}},{"Add":{"text":"\tfor(let i = 0; i < x.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9415"}},{"Add":{"text":"\t\tfor(let j = 0; j < x[i].features.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9466"}},{"Add":{"text":"\t\t\tif(x[i].features[j].featureId === 'CP') {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9512"}},{"Add":{"text":"\t\t\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9530"}},{"Add":{"text":"\t\t\t\taddress.push(x[i].addressInfo.address1);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9576"}},{"Add":{"text":"\t\t\t\taddress2.push(x[i].addressInfo.address2 ?? '');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9629"}},{"Add":{"text":"\t\t\t\tcity.push(x[i].addressInfo.city);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9668"}},{"Add":{"text":"\t\t\t\tpostal_code.push(x[i].addressInfo.postal);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9716"}},{"Add":{"text":"\t\t\t\tbreak;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9728"}},{"Add":{"text":"\t\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9734"}},{"Add":{"text":"\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9739"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9743"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9767"}},{"Add":{"text":"\t\t`create temporary table novascotia as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9809"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9821"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9838"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9858"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9876"}},{"Add":{"text":"\t\t\t$3::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9894"}},{"Add":{"text":"\t\t\t$4::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9912"}},{"Add":{"text":"\t\t\t$5::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9929"}},{"Add":{"text":"\t\t) as t(idx, address, address2, city, postal_code)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:9984"}},{"Add":{"text":"\t\t[idx, address, address2, city, postal_code]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10031"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10036"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10068"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10082"}},{"Add":{"text":"\t\tfrom novascotia\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10101"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10123"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10134"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10154"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10164"}},{"Add":{"text":"\t\t\t\tjoined_name = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10190"}},{"Add":{"text":"\t\t\t\taddress = novascotia.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10228"}},{"Add":{"text":"\t\t\t\taddress2 = novascotia.address2 and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10268"}},{"Add":{"text":"\t\t\t\tcity = novascotia.city and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10300"}},{"Add":{"text":"\t\t\t\tregion = 'novascotia' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10331"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10359"}},{"Add":{"text":"\t\t\t\tpostal_code = novascotia.postal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10401"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10406"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10434"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10450"}},{"Add":{"text":"\taddress2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10467"}},{"Add":{"text":"\tcity = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10480"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1244,"ins":{"up_context":[{"change":3,"pos":36100}],"down_context":[{"change":3,"pos":36124}],"flag":"BLOCK","start":10482,"end":10502,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":36100},"to":{"change":3,"start":36100,"end":36124},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tpostal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10501"}}],"del_contents":[{"Del":{"text":"\tlet postal_code = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36123"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1252,"ins":{"up_context":[{"change":3,"pos":36276}],"down_context":[{"change":3,"pos":36679}],"flag":"BLOCK","start":10503,"end":12208,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":36276},"to":{"change":3,"start":36276,"end":36679},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10542"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10563"}},{"Add":{"text":"\t\tlet r;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10573"}},{"Add":{"text":"\t\ttry {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10582"}},{"Add":{"text":"\t\t\tr = await g(`${x[i].addressInfo.address1} ${x[i].addressInfo.address2 ?? ''} ${x[i].addressInfo.city} nova scotia ${x[i].addressInfo.postal} canada`);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10737"}},{"Add":{"text":"\t\t} catch(e) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10753"}},{"Add":{"text":"\t\t\tconsole.error(e);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10775"}},{"Add":{"text":"\t\t\tconsole.log(x[i].name);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10803"}},{"Add":{"text":"\t\t\tcontinue;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10817"}},{"Add":{"text":"\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10822"}},{"Add":{"text":"\t\tif(!pc.test(r[0].postal_code)) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10858"}},{"Add":{"text":"\t\t\tx[i].postal = x[i].postal.replace(/\\s+/g, '');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10909"}},{"Add":{"text":"\t\t\tif(r[0].postal_code.length === 3 && x[i].postal.length === 6) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:10977"}},{"Add":{"text":"\t\t\t\tr[0].postal_code = x[i].postal\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11013"}},{"Add":{"text":"\t\t\t} else {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11026"}},{"Add":{"text":"\t\t\t\tconsole.error('postal_code goofup', r, x[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11077"}},{"Add":{"text":"\t\t\t\tcontinue;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11092"}},{"Add":{"text":"\t\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11098"}},{"Add":{"text":"\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11103"}},{"Add":{"text":"\t\taddress.push(r[0].address);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11134"}},{"Add":{"text":"\t\taddress2.push(r[0].address2);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11167"}},{"Add":{"text":"\t\tcity.push(r[0].city);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11192"}},{"Add":{"text":"\t\tregion.push(r[0].region);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11221"}},{"Add":{"text":"\t\tcountry.push(r[0].country);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11252"}},{"Add":{"text":"\t\tpostal_code.push(r[0].postal_code);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11291"}},{"Add":{"text":"\t\tlongitude.push(r[1].lng);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11320"}},{"Add":{"text":"\t\tlatitude.push(r[1].lat);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11348"}},{"Add":{"text":"\t\tosrm_hint_foot.push(r[3]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11378"}},{"Add":{"text":"\t\tosrm_hint_car.push(r[4]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11407"}},{"Add":{"text":"\t\ttimezone.push(r[2]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11431"}},{"Add":{"text":"\t\tphone.push(x[i].phone);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11458"}},{"Add":{"text":"\t\tlet tim = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11475"}},{"Add":{"text":"\t\tfor(let k = 0; k < x[i].openingHours.length; ++k) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11530"}},{"Add":{"text":"\t\t\tlet d = 0;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11545"}},{"Add":{"text":"\t\t\tswitch(x[i].openingHours[k].dayOfWeek) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11590"}},{"Add":{"text":"\t\t\t\tcase 'Tuesday': d = 1440; break;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11628"}},{"Add":{"text":"\t\t\t\tcase 'Wednesday': d = 2880; break;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11668"}},{"Add":{"text":"\t\t\t\tcase 'Thursday': d = 4320; break;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11707"}},{"Add":{"text":"\t\t\t\tcase 'Friday': d = 5760; break;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11744"}},{"Add":{"text":"\t\t\t\tcase 'Saturday': d = 7200; break;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11783"}},{"Add":{"text":"\t\t\t\tcase 'Sunday': d = 8640; break; \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11821"}},{"Add":{"text":"\t\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11827"}},{"Add":{"text":"\t\t\tlet beg = x[i].openingHours[k].opens.split(':').map(Number);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11892"}},{"Add":{"text":"\t\t\tbeg = beg[0] * 60 + beg[1];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11924"}},{"Add":{"text":"\t\t\tlet end = x[i].openingHours[k].closes.split(':').map(Number);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:11990"}},{"Add":{"text":"\t\t\tend = end[0] * 60 + end[1];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12022"}},{"Add":{"text":"\t\t\tlet rtn = [d + beg, d + end];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12056"}},{"Add":{"text":"\t\t\tif(end < beg) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12076"}},{"Add":{"text":"\t\t\t\tif(d === 8640) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12098"}},{"Add":{"text":"\t\t\t\t\ttim.push([rtn[0], 10080]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12131"}},{"Add":{"text":"\t\t\t\t\trtn[0] = 0;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12149"}},{"Add":{"text":"\t\t\t\t\trtn[1] -= 8640;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12171"}},{"Add":{"text":"\t\t\t\t} else {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12185"}},{"Add":{"text":"\t\t\t\t\trtn[1] += 1440;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12207"}}],"del_contents":[{"Del":{"text":"\tfor(let i = 0; i < x.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36313"}},{"Del":{"text":"\t\tfor(let j = 0; j < x[i].features.length; ++j) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36364"}},{"Del":{"text":"\t\t\tif(x[i].features[j].featureId === 'CP') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36410"}},{"Del":{"text":"\t\t\t\tlet r;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36422"}},{"Del":{"text":"\t\t\t\ttry {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36433"}},{"Del":{"text":"\t\t\t\t\tr = await g(`${x[i].addressInfo.address1} ${x[i].addressInfo.address2 ?? ''} ${x[i].addressInfo.city} nova scotia ${x[i].addressInfo.postal} canada`);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36590"}},{"Del":{"text":"\t\t\t\t} catch(e) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36608"}},{"Del":{"text":"\t\t\t\t\tconsole.error(e);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36632"}},{"Del":{"text":"\t\t\t\t\tconsole.log(x[i].name);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36662"}},{"Del":{"text":"\t\t\t\t\tcontinue;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36678"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1307,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":36686},"to":{"change":3,"start":36686,"end":38253},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\t\t\t\tif(!pc.test(r[0].postal_code)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36723"}},{"Del":{"text":"\t\t\t\t\tx[i].postal = x[i].postal.replace(/\\s+/g, '');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36776"}},{"Del":{"text":"\t\t\t\t\tif(r[0].postal_code.length === 3 && x[i].postal.length === 6) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36846"}},{"Del":{"text":"\t\t\t\t\t\tr[0].postal_code = x[i].postal\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36884"}},{"Del":{"text":"\t\t\t\t\t} else {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36899"}},{"Del":{"text":"\t\t\t\t\t\tconsole.error('postal_code goofup', r, x[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36952"}},{"Del":{"text":"\t\t\t\t\t\tcontinue;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36969"}},{"Del":{"text":"\t\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36977"}},{"Del":{"text":"\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:36984"}},{"Del":{"text":"\t\t\t\taddress.push(r[0].address);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37017"}},{"Del":{"text":"\t\t\t\taddress2.push(r[0].address2);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37052"}},{"Del":{"text":"\t\t\t\tcity.push(r[0].city);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37079"}},{"Del":{"text":"\t\t\t\tregion.push(r[0].region);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37110"}},{"Del":{"text":"\t\t\t\tcountry.push(r[0].country);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37143"}},{"Del":{"text":"\t\t\t\tpostal_code.push(r[0].postal_code);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37184"}},{"Del":{"text":"\t\t\t\tlongitude.push(r[1].lng);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37215"}},{"Del":{"text":"\t\t\t\tlatitude.push(r[1].lat);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37245"}},{"Del":{"text":"\t\t\t\tosrm_hint_foot.push(r[3]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37277"}},{"Del":{"text":"\t\t\t\tosrm_hint_car.push(r[4]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37308"}},{"Del":{"text":"\t\t\t\ttimezone.push(r[2]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37334"}},{"Del":{"text":"\t\t\t\tphone.push(x[i].phone);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37363"}},{"Del":{"text":"\t\t\t\tlet tim = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37382"}},{"Del":{"text":"\t\t\t\tfor(let k = 0; k < x[i].openingHours.length; ++k) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37439"}},{"Del":{"text":"\t\t\t\t\tlet d = 0;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37456"}},{"Del":{"text":"\t\t\t\t\tswitch(x[i].openingHours[k].dayOfWeek) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37503"}},{"Del":{"text":"\t\t\t\t\t\tcase 'Tuesday': d = 1440; break;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37543"}},{"Del":{"text":"\t\t\t\t\t\tcase 'Wednesday': d = 2880; break;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37585"}},{"Del":{"text":"\t\t\t\t\t\tcase 'Thursday': d = 4320; break;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37626"}},{"Del":{"text":"\t\t\t\t\t\tcase 'Friday': d = 5760; break;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37665"}},{"Del":{"text":"\t\t\t\t\t\tcase 'Saturday': d = 7200; break;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37706"}},{"Del":{"text":"\t\t\t\t\t\tcase 'Sunday': d = 8640; break; \r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37746"}},{"Del":{"text":"\t\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37754"}},{"Del":{"text":"\t\t\t\t\tlet beg = x[i].openingHours[k].opens.split(':').map(Number);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37821"}},{"Del":{"text":"\t\t\t\t\tbeg = beg[0] * 60 + beg[1];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37855"}},{"Del":{"text":"\t\t\t\t\tlet end = x[i].openingHours[k].closes.split(':').map(Number);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37923"}},{"Del":{"text":"\t\t\t\t\tend = end[0] * 60 + end[1];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37957"}},{"Del":{"text":"\t\t\t\t\tlet rtn = [d + beg, d + end];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:37993"}},{"Del":{"text":"\t\t\t\t\tif(end < beg) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38015"}},{"Del":{"text":"\t\t\t\t\t\tif(d === 8640) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38039"}},{"Del":{"text":"\t\t\t\t\t\t\ttim.push([rtn[0], 10080]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38074"}},{"Del":{"text":"\t\t\t\t\t\t\trtn[0] = 0;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38094"}},{"Del":{"text":"\t\t\t\t\t\t\trtn[1] -= 8640;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38118"}},{"Del":{"text":"\t\t\t\t\t\t} else {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38134"}},{"Del":{"text":"\t\t\t\t\t\t\trtn[1] += 1440;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38158"}},{"Del":{"text":"\t\t\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38167"}},{"Del":{"text":"\t\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38175"}},{"Del":{"text":"\t\t\t\t\ttim.push(rtn);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38196"}},{"Del":{"text":"\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38203"}},{"Del":{"text":"\t\t\t\topen.push(JSON.stringify(tim));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38240"}},{"Del":{"text":"\t\t\t\tbreak;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:38252"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1308,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":38259}],"down_context":[{"change":3,"pos":38259}],"flag":"BLOCK","start":12209,"end":12228,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\t\ttim.push(rtn);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12227"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1310,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":38264}],"down_context":[{"change":3,"pos":38264}],"flag":"BLOCK","start":12229,"end":12264,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\topen.push(JSON.stringify(tim));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12263"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1425,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":41085}],"down_context":[{"change":3,"pos":41085}],"flag":"BLOCK","start":12265,"end":12281,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12280"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1427,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":41105},"to":{"change":3,"start":41105,"end":41358},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\tlet address2 = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41125"}},{"Del":{"text":"\tlet city = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41142"}},{"Del":{"text":"\tlet region = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41161"}},{"Del":{"text":"\tlet country = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41181"}},{"Del":{"text":"\tlet postal_code = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41205"}},{"Del":{"text":"\tlet longitude = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41227"}},{"Del":{"text":"\tlet latitude = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41248"}},{"Del":{"text":"\tlet osrm_hint_foot = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41275"}},{"Del":{"text":"\tlet osrm_hint_car = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41301"}},{"Del":{"text":"\tlet timezone = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41322"}},{"Del":{"text":"\tlet open = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41339"}},{"Del":{"text":"\tlet phone = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41357"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1429,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":41458},"to":{"change":3,"start":41458,"end":41468},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\t\tlet r;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41467"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1430,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":41485}],"down_context":[{"change":3,"pos":41485}],"flag":"BLOCK","start":12282,"end":12296,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\tlet phone;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12295"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1438,"ins":{"up_context":[{"change":3,"pos":41692}],"down_context":[{"change":3,"pos":41748}],"flag":"BLOCK","start":12297,"end":12349,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":41692},"to":{"change":3,"start":41692,"end":41748},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\tphone = results[i][j].replace('Phone:', '');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12348"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\tphone.push(results[i][j].replace('Phone:', ''));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:41747"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1519,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":44098}],"down_context":[{"change":3,"pos":44098}],"flag":"BLOCK","start":12350,"end":13257,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\tresults[i] = {adr, tim, phone};\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12384"}},{"Add":{"text":"\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12400"}},{"Add":{"text":"\t\taddress.push(adr);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12422"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12426"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12450"}},{"Add":{"text":"\t\t`create temporary table pei as\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12484"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12496"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12513"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12533"}},{"Add":{"text":"\t\t\t$2::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12550"}},{"Add":{"text":"\t\t) as t(idx, address)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12576"}},{"Add":{"text":"\t\t[idx, address]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12594"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12599"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12631"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12645"}},{"Add":{"text":"\t\tfrom pei\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12657"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12679"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12690"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12710"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12720"}},{"Add":{"text":"\t\t\t\tjoined_name = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12746"}},{"Add":{"text":"\t\t\t\taddress = pei.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12777"}},{"Add":{"text":"\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12800"}},{"Add":{"text":"\t\t\t\tcity = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12819"}},{"Add":{"text":"\t\t\t\tregion = 'pei' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12843"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12871"}},{"Add":{"text":"\t\t\t\tpostal_code = ''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12893"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12898"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12926"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12942"}},{"Add":{"text":"\tlet address2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12963"}},{"Add":{"text":"\tlet city = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12980"}},{"Add":{"text":"\tlet region = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:12999"}},{"Add":{"text":"\tlet country = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13019"}},{"Add":{"text":"\tlet postal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13043"}},{"Add":{"text":"\tlet longitude = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13065"}},{"Add":{"text":"\tlet latitude = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13086"}},{"Add":{"text":"\tlet osrm_hint_foot = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13113"}},{"Add":{"text":"\tlet osrm_hint_car = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13139"}},{"Add":{"text":"\tlet timezone = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13160"}},{"Add":{"text":"\tlet open = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13177"}},{"Add":{"text":"\tlet phone = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13195"}},{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13235"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13256"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1564,"ins":{"up_context":[{"change":3,"pos":44107}],"down_context":[{"change":3,"pos":44141}],"flag":"BLOCK","start":13258,"end":13303,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":44107},"to":{"change":3,"start":44107,"end":44141},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tr = await g(`${results[i].adr} canada`);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13302"}}],"del_contents":[{"Del":{"text":"\t\t\tr = await g(`${adr} canada`);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:44140"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1567,"ins":{"up_context":[{"change":3,"pos":44179}],"down_context":[{"change":3,"pos":44208}],"flag":"BLOCK","start":13304,"end":13337,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":44179},"to":{"change":3,"start":44179,"end":44208},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tconsole.log(results[i].adr);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13336"}}],"del_contents":[{"Del":{"text":"\t\t\tconsole.log(results[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:44207"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1571,"ins":{"up_context":[{"change":3,"pos":44263}],"down_context":[{"change":3,"pos":44319}],"flag":"BLOCK","start":13338,"end":13398,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":44263},"to":{"change":3,"start":44263,"end":44319},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tconsole.error('postal_code goofup', r, results[i].adr);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13397"}}],"del_contents":[{"Del":{"text":"\t\t\tconsole.error('postal_code goofup', r, results[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:44318"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1585,"ins":{"up_context":[{"change":3,"pos":44666}],"down_context":[{"change":3,"pos":44701}],"flag":"BLOCK","start":13399,"end":13478,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":44666},"to":{"change":3,"start":44666,"end":44701},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\topen.push(JSON.stringify(results[i].tim));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13444"}},{"Add":{"text":"\t\tphone.push(results[i].phone);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13477"}}],"del_contents":[{"Del":{"text":"\t\topen.push(JSON.stringify(tim));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:44700"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1699,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":47392}],"down_context":[{"change":3,"pos":47392}],"flag":"BLOCK","start":13479,"end":13495,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13494"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1701,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":47517}],"down_context":[{"change":3,"pos":47517}],"flag":"BLOCK","start":13496,"end":14344,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet address = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13515"}},{"Add":{"text":"\tlet results = await page.$$eval('.component-store-location__address', x => x.map(y => Array.from(y.querySelectorAll('p')).map(z => z.textContent.trim())));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13673"}},{"Add":{"text":"\tpage.close();\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13689"}},{"Add":{"text":"\tfor(let i = 0; i < results.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13733"}},{"Add":{"text":"\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13749"}},{"Add":{"text":"\t\taddress.push(results[i][0]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13781"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13785"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13809"}},{"Add":{"text":"\t\t`create temporary table yukon as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13846"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13858"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13875"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13895"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13913"}},{"Add":{"text":"\t\t\t$3::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13930"}},{"Add":{"text":"\t\t) as t(idx, joined_name, address)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13969"}},{"Add":{"text":"\t\t[idx, n, address]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13990"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:13995"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14027"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14041"}},{"Add":{"text":"\t\tfrom yukon\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14055"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14077"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14088"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14108"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14118"}},{"Add":{"text":"\t\t\t\tjoined_name = yukon.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14159"}},{"Add":{"text":"\t\t\t\taddress = yukon.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14192"}},{"Add":{"text":"\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14215"}},{"Add":{"text":"\t\t\t\tcity = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14234"}},{"Add":{"text":"\t\t\t\tregion = 'yukon' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14260"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14288"}},{"Add":{"text":"\t\t\t\tpostal_code = ''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14310"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14315"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14343"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1735,"ins":{"up_context":[{"change":3,"pos":47535}],"down_context":[{"change":3,"pos":47555}],"flag":"BLOCK","start":14345,"end":14361,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":47535},"to":{"change":3,"start":47535,"end":47555},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14360"}}],"del_contents":[{"Del":{"text":"\tlet address = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:47554"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1748,"ins":{"up_context":[{"change":3,"pos":47807}],"down_context":[{"change":3,"pos":48025}],"flag":"BLOCK","start":14362,"end":14423,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":47807},"to":{"change":3,"start":47807,"end":48025},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14401"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14422"}}],"del_contents":[{"Del":{"text":"\tlet results = await page.$$eval('.component-store-location__address', x => x.map(y => Array.from(y.querySelectorAll('p')).map(z => z.textContent.trim())));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:47964"}},{"Del":{"text":"\tpage.close();\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:47980"}},{"Del":{"text":"\tfor(let i = 0; i < results.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:48024"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1755,"ins":{"up_context":[{"change":3,"pos":48145}],"down_context":[{"change":3,"pos":48172}],"flag":"BLOCK","start":14424,"end":14459,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":48145},"to":{"change":3,"start":48145,"end":48172},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tconsole.log(n[i], results[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14458"}}],"del_contents":[{"Del":{"text":"\t\t\tconsole.log(names[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:48171"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1759,"ins":{"up_context":[{"change":3,"pos":48227}],"down_context":[{"change":3,"pos":48293}],"flag":"BLOCK","start":14460,"end":14522,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":48227},"to":{"change":3,"start":48227,"end":48293},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tconsole.error('postal_code goofup', r, n[i], results[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14521"}}],"del_contents":[{"Del":{"text":"\t\t\tconsole.error('postal_code goofup', r, names[i], results[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:48292"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1776,"ins":{"up_context":[{"change":3,"pos":48681}],"down_context":[{"change":3,"pos":48883}],"flag":"BLOCK","start":14523,"end":14726,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":48681},"to":{"change":3,"start":48681,"end":48883},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\tfor(let k = 1; k < results[i].length; ++k) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14570"}},{"Add":{"text":"\t\t\tif(results[i][k].startsWith('http')) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14613"}},{"Add":{"text":"\t\t\t\tu = results[i][k];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14637"}},{"Add":{"text":"\t\t\t} else if(results[i][k].replace(/\\D/g, '').length === 10) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14701"}},{"Add":{"text":"\t\t\t\tp = results[i][k];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14725"}}],"del_contents":[{"Del":{"text":"\t\tfor(let j = 0; j < results[i].length; ++j) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:48728"}},{"Del":{"text":"\t\t\tif(results[i][j].startsWith('http')) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:48771"}},{"Del":{"text":"\t\t\t\tu = results[i][j];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:48795"}},{"Del":{"text":"\t\t\t} else if(results[i][j].replace(/\\D/g, '').length >= 10) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:48858"}},{"Del":{"text":"\t\t\t\tp = results[i][j];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:48882"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1881,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":51337},"to":{"change":3,"start":51337,"end":51611},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\tlet names = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51354"}},{"Del":{"text":"\tlet address = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51374"}},{"Del":{"text":"\tlet address2 = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51395"}},{"Del":{"text":"\tlet city = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51412"}},{"Del":{"text":"\tlet region = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51431"}},{"Del":{"text":"\tlet country = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51451"}},{"Del":{"text":"\tlet postal_code = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51475"}},{"Del":{"text":"\tlet longitude = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51497"}},{"Del":{"text":"\tlet latitude = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51518"}},{"Del":{"text":"\tlet osrm_hint_foot = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51545"}},{"Del":{"text":"\tlet osrm_hint_car = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51571"}},{"Del":{"text":"\tlet timezone = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51592"}},{"Del":{"text":"\tlet phone = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51610"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1886,"ins":{"up_context":[{"change":3,"pos":51799}],"down_context":[{"change":3,"pos":51846}],"flag":"BLOCK","start":14727,"end":14770,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":51799},"to":{"change":3,"start":51799,"end":51846},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\t\tstuff = 'Norman Wells Liquor Agency';\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14769"}}],"del_contents":[{"Del":{"text":"\t\t\t\tstuff = 'Norman Wells Liquor Agency Ltd';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:51845"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1893,"ins":{"up_context":[{"change":3,"pos":52027}],"down_context":[{"change":3,"pos":52111}],"flag":"BLOCK","start":14771,"end":14851,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":52027},"to":{"change":3,"start":52027,"end":52111},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tif(stuff === 'Norman Wells Liquor Agency' && store[1] === 'Franklin Ave') {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14850"}}],"del_contents":[{"Del":{"text":"\t\t\tif(stuff === 'Norman Wells Liquor Agency Ltd' && store[1] === 'Franklin Ave') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:52110"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1901,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":52215}],"down_context":[{"change":3,"pos":52215}],"flag":"BLOCK","start":14852,"end":14906,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14867"}},{"Add":{"text":"\tlet names = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14885"}},{"Add":{"text":"\tlet address = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14905"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1905,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":52259}],"down_context":[{"change":3,"pos":52259}],"flag":"BLOCK","start":14907,"end":15899,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14922"}},{"Add":{"text":"\t\tnames.push(results[i][0] = sanitize_name(results[i][0]));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:14983"}},{"Add":{"text":"\t\taddress.push(results[i][1]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15015"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15019"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15043"}},{"Add":{"text":"\t\t`create temporary table nwt as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15078"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15090"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15107"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15127"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15145"}},{"Add":{"text":"\t\t\t$3::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15162"}},{"Add":{"text":"\t\t) as t(idx, joined_name, address)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15201"}},{"Add":{"text":"\t\t[idx, names, address]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15226"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15231"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15263"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15277"}},{"Add":{"text":"\t\tfrom nwt\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15289"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15311"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15322"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15342"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15352"}},{"Add":{"text":"\t\t\t\tjoined_name = nwt.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15391"}},{"Add":{"text":"\t\t\t\taddress = nwt.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15422"}},{"Add":{"text":"\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15445"}},{"Add":{"text":"\t\t\t\tcity = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15464"}},{"Add":{"text":"\t\t\t\tregion = 'nwt' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15488"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15516"}},{"Add":{"text":"\t\t\t\tpostal_code = ''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15538"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15543"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15571"}},{"Add":{"text":"\tnames = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15585"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15601"}},{"Add":{"text":"\tlet address2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15622"}},{"Add":{"text":"\tlet city = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15639"}},{"Add":{"text":"\tlet region = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15658"}},{"Add":{"text":"\tlet country = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15678"}},{"Add":{"text":"\tlet postal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15702"}},{"Add":{"text":"\tlet longitude = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15724"}},{"Add":{"text":"\tlet latitude = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15745"}},{"Add":{"text":"\tlet osrm_hint_foot = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15772"}},{"Add":{"text":"\tlet osrm_hint_car = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15798"}},{"Add":{"text":"\tlet timezone = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15819"}},{"Add":{"text":"\tlet phone = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15837"}},{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15877"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15898"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1953,"ins":{"up_context":[{"change":3,"pos":52293}],"down_context":[{"change":3,"pos":52353}],"flag":"BLOCK","start":15900,"end":15946,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":52293},"to":{"change":3,"start":52293,"end":52353},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\tif(results[i][0] === 'Hay River Liquor') {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15945"}}],"del_contents":[{"Del":{"text":"\t\tif(results[i][0] === 'Hay River Liquor Retailers Ltd') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:52352"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":1974,"ins":{"up_context":[{"change":3,"pos":52846}],"down_context":[{"change":3,"pos":52891}],"flag":"BLOCK","start":15947,"end":15977,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":52846},"to":{"change":3,"start":52846,"end":52891},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\tnames.push(results[i][0]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15976"}}],"del_contents":[{"Del":{"text":"\t\tnames.push(sanitize_name(results[i][0]));\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:52890"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2072,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":55570}],"down_context":[{"change":3,"pos":55570}],"flag":"BLOCK","start":15978,"end":15994,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:15993"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2075,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":55608},"to":{"change":3,"start":55608,"end":55826},"introduced_by":3}],"inode":{"change":3,"pos":2622}}},"contents":[{"Del":{"text":"\tlet address2 = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55628"}},{"Del":{"text":"\tlet city = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55645"}},{"Del":{"text":"\tlet region = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55664"}},{"Del":{"text":"\tlet country = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55684"}},{"Del":{"text":"\tlet postal_code = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55708"}},{"Del":{"text":"\tlet longitude = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55730"}},{"Del":{"text":"\tlet latitude = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55751"}},{"Del":{"text":"\tlet osrm_hint_foot = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55778"}},{"Del":{"text":"\tlet osrm_hint_car = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55804"}},{"Del":{"text":"\tlet timezone = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55825"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2077,"ins":{"up_context":[{"change":3,"pos":55908}],"down_context":[{"change":3,"pos":56369}],"flag":"BLOCK","start":15995,"end":16062,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":55908},"to":{"change":3,"start":55908,"end":56369},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16011"}},{"Add":{"text":"\t\t\tnames.push(on[i][6] = sanitize_name(on[i][6])\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16061"}}],"del_contents":[{"Del":{"text":"\t\t\tlet r;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55918"}},{"Del":{"text":"\t\t\ttry {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55928"}},{"Del":{"text":"\t\t\t\tr = await g(on[i][11]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55957"}},{"Del":{"text":"\t\t\t} catch(e) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55974"}},{"Del":{"text":"\t\t\t\tconsole.error(e);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:55997"}},{"Del":{"text":"\t\t\t\tconsole.log(on[i][6]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56025"}},{"Del":{"text":"\t\t\t\tcontinue;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56040"}},{"Del":{"text":"\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56046"}},{"Del":{"text":"\t\t\tif(!pc.test(r[0].postal_code)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56083"}},{"Del":{"text":"\t\t\t\ton[i][10] = on[i][10].replace(/\\s+/g, '');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56131"}},{"Del":{"text":"\t\t\t\tif(r[0].postal_code.length === 3 && on[i][10].length === 6) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56198"}},{"Del":{"text":"\t\t\t\t\tr[0].postal_code = on[i][10]\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56233"}},{"Del":{"text":"\t\t\t\t} else {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56247"}},{"Del":{"text":"\t\t\t\t\tconsole.error('postal_code goofup', r, on[i]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56300"}},{"Del":{"text":"\t\t\t\t\tcontinue;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56316"}},{"Del":{"text":"\t\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56323"}},{"Del":{"text":"\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56329"}},{"Del":{"text":"\t\t\tnames.push(sanitize_name(on[i][6])\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56368"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2094,"ins":{"up_context":[{"change":3,"pos":56896}],"down_context":[{"change":3,"pos":57235}],"flag":"BLOCK","start":16063,"end":17426,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":56896},"to":{"change":3,"start":56896,"end":57235},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\t\t\taddress.push(on[i][11]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16091"}},{"Add":{"text":"\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16096"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16100"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16124"}},{"Add":{"text":"\t\t`create temporary table ontario as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16163"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16175"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16192"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16212"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16230"}},{"Add":{"text":"\t\t\t$3::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16247"}},{"Add":{"text":"\t\t) as t(idx, joined_name, address)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16286"}},{"Add":{"text":"\t\t[idx, names, address]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16311"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16316"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16348"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16362"}},{"Add":{"text":"\t\tfrom ontario\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16378"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16400"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16411"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16431"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16441"}},{"Add":{"text":"\t\t\t\tjoined_name = ontario.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16484"}},{"Add":{"text":"\t\t\t\taddress = ontario.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16519"}},{"Add":{"text":"\t\t\t\taddress2 = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16542"}},{"Add":{"text":"\t\t\t\tcity = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16561"}},{"Add":{"text":"\t\t\t\tregion = 'ontario' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16589"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16617"}},{"Add":{"text":"\t\t\t\tpostal_code = ''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16639"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16644"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16672"}},{"Add":{"text":"\tnames = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16686"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16702"}},{"Add":{"text":"\tlet address2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16723"}},{"Add":{"text":"\tlet city = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16740"}},{"Add":{"text":"\tlet region = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16759"}},{"Add":{"text":"\tlet country = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16779"}},{"Add":{"text":"\tlet postal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16803"}},{"Add":{"text":"\tlet longitude = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16825"}},{"Add":{"text":"\tlet latitude = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16846"}},{"Add":{"text":"\tlet osrm_hint_foot = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16873"}},{"Add":{"text":"\tlet osrm_hint_car = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16899"}},{"Add":{"text":"\tlet timezone = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16920"}},{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16960"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16981"}},{"Add":{"text":"\t\tlet r;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:16991"}},{"Add":{"text":"\t\ttry {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17000"}},{"Add":{"text":"\t\t\tr = await g(on[i][11].replace(/OSPREY MIIKAN RD/i, 'OSPREY MIIKAN'));\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17074"}},{"Add":{"text":"\t\t} catch(e) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17090"}},{"Add":{"text":"\t\t\tconsole.error(e);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17112"}},{"Add":{"text":"\t\t\tconsole.log(on[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17136"}},{"Add":{"text":"\t\t\tcontinue;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17150"}},{"Add":{"text":"\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17155"}},{"Add":{"text":"\t\tif(!pc.test(r[0].postal_code)) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17191"}},{"Add":{"text":"\t\t\ton[i][10] = on[i][10].replace(/\\s+/g, '');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17238"}},{"Add":{"text":"\t\t\tif(r[0].postal_code.length === 3 && on[i][10].length === 6) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17304"}},{"Add":{"text":"\t\t\t\tr[0].postal_code = on[i][10];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17339"}},{"Add":{"text":"\t\t\t} else {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17352"}},{"Add":{"text":"\t\t\t\tconsole.error('postal_code goofup', r, on[i]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17404"}},{"Add":{"text":"\t\t\t\tcontinue;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17419"}},{"Add":{"text":"\t\t\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17425"}}],"del_contents":[{"Del":{"text":"\t\t\taddress.push(r[0].address);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56927"}},{"Del":{"text":"\t\t\taddress2.push(r[0].address2);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56961"}},{"Del":{"text":"\t\t\tcity.push(r[0].city);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:56987"}},{"Del":{"text":"\t\t\tregion.push(r[0].region);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:57017"}},{"Del":{"text":"\t\t\tcountry.push(r[0].country);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:57049"}},{"Del":{"text":"\t\t\tpostal_code.push(r[0].postal_code);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:57089"}},{"Del":{"text":"\t\t\tlongitude.push(r[1].lng);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:57119"}},{"Del":{"text":"\t\t\tlatitude.push(r[1].lat);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:57148"}},{"Del":{"text":"\t\t\tosrm_hint_foot.push(r[3]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:57179"}},{"Del":{"text":"\t\t\tosrm_hint_car.push(r[4]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:57209"}},{"Del":{"text":"\t\t\ttimezone.push(r[2]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:57234"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2154,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":57240}],"down_context":[{"change":3,"pos":57240}],"flag":"BLOCK","start":17427,"end":17780,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\t\tnames.push(on[i][6]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17451"}},{"Add":{"text":"\t\taddress.push(r[0].address);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17482"}},{"Add":{"text":"\t\taddress2.push(r[0].address2);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17515"}},{"Add":{"text":"\t\tcity.push(r[0].city);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17540"}},{"Add":{"text":"\t\tregion.push(r[0].region);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17569"}},{"Add":{"text":"\t\tcountry.push(r[0].country);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17600"}},{"Add":{"text":"\t\tpostal_code.push(r[0].postal_code);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17639"}},{"Add":{"text":"\t\tlongitude.push(r[1].lng);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17668"}},{"Add":{"text":"\t\tlatitude.push(r[1].lat);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17696"}},{"Add":{"text":"\t\tosrm_hint_foot.push(r[3]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17726"}},{"Add":{"text":"\t\tosrm_hint_car.push(r[4]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17755"}},{"Add":{"text":"\t\ttimezone.push(r[2]);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17779"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2251,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":59634}],"down_context":[{"change":3,"pos":59634}],"flag":"BLOCK","start":17781,"end":17797,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet idx = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17796"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2255,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":59692}],"down_context":[{"change":3,"pos":59692}],"flag":"BLOCK","start":17798,"end":18779,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tlet postal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17821"}},{"Add":{"text":"\tfor(let i = 0; i < results.length; ++i) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17865"}},{"Add":{"text":"\t\tidx.push(i);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17881"}},{"Add":{"text":"\t\taddress.push(results[i].Address.Line1);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17924"}},{"Add":{"text":"\t\taddress2.push(results[i].Address.Line2 ?? '');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:17974"}},{"Add":{"text":"\t\tcity.push(results[i].Address.City);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18013"}},{"Add":{"text":"\t\tpostal_code.push(results[i].Address.PostalCode);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18065"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18069"}},{"Add":{"text":"\tawait postgres.query(\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18093"}},{"Add":{"text":"\t\t`create temporary table quebec as \r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18131"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18143"}},{"Add":{"text":"\t\tfrom unnest (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18160"}},{"Add":{"text":"\t\t\t$1::smallint[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18180"}},{"Add":{"text":"\t\t\t$2::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18198"}},{"Add":{"text":"\t\t\t$3::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18216"}},{"Add":{"text":"\t\t\t$4::citext[],\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18234"}},{"Add":{"text":"\t\t\t$5::citext[]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18251"}},{"Add":{"text":"\t\t) as t(idx, address, address2, city, postal_code)`,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18306"}},{"Add":{"text":"\t\t[idx, address, address2, city, postal_code]\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18353"}},{"Add":{"text":"\t);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18358"}},{"Add":{"text":"\tidx = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18390"}},{"Add":{"text":"\t\tselect idx\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18404"}},{"Add":{"text":"\t\tfrom quebec\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18419"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18441"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18452"}},{"Add":{"text":"\t\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18472"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18482"}},{"Add":{"text":"\t\t\t\tjoined_name = '' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18508"}},{"Add":{"text":"\t\t\t\taddress = quebec.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18542"}},{"Add":{"text":"\t\t\t\taddress2 = quebec.address2 and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18578"}},{"Add":{"text":"\t\t\t\tcity = quebec.city and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18606"}},{"Add":{"text":"\t\t\t\tregion = 'quebec' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18633"}},{"Add":{"text":"\t\t\t\tcountry = 'canada' and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18661"}},{"Add":{"text":"\t\t\t\tpostal_code = quebec.postal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18699"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18704"}},{"Add":{"text":"\t`)).rows.map(x => x.idx);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18732"}},{"Add":{"text":"\taddress = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18748"}},{"Add":{"text":"\taddress2 = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18765"}},{"Add":{"text":"\tcity = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18778"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2296,"ins":{"up_context":[{"change":3,"pos":59733}],"down_context":[{"change":3,"pos":59757}],"flag":"BLOCK","start":18780,"end":18800,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":59733},"to":{"change":3,"start":59733,"end":59757},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tpostal_code = [];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18799"}}],"del_contents":[{"Del":{"text":"\tlet postal_code = [];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:59756"}}]}},{"Replacement":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2304,"ins":{"up_context":[{"change":3,"pos":59909}],"down_context":[{"change":3,"pos":59953}],"flag":"BLOCK","start":18801,"end":18862,"inode":{"change":3,"pos":2622}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":59909},"to":{"change":3,"start":59909,"end":59953},"introduced_by":3}],"inode":{"change":3,"pos":2622}},"ins_contents":[{"Add":{"text":"\tfor(let j = 0; j < idx.length; ++j) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18840"}},{"Add":{"text":"\t\tconst i = idx[j];\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18861"}}],"del_contents":[{"Del":{"text":"\tfor(let i = 0; i < results.length; ++i) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:59952"}}]}},{"Edit":{"inode":{"change":3,"pos":2622},"path":"scrape/stores.js","line":2493,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":65406}],"down_context":[{"change":3,"pos":65406}],"flag":"BLOCK","start":18863,"end":21126,"inode":{"change":3,"pos":2622}}},"contents":[{"Add":{"text":"\tawait postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18887"}},{"Add":{"text":"\t\tcreate temporary table store_temp_temp as\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18932"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18942"}},{"Add":{"text":"\t\t\tjoined_name,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18959"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18972"}},{"Add":{"text":"\t\t\t'' as address2,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:18992"}},{"Add":{"text":"\t\t\tcity,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19002"}},{"Add":{"text":"\t\t\t'alberta' as region,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19027"}},{"Add":{"text":"\t\t\t'canada' as country,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19052"}},{"Add":{"text":"\t\t\tpostal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19068"}},{"Add":{"text":"\t\tfrom alberta\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19084"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19097"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19107"}},{"Add":{"text":"\t\t\tjoined_name,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19124"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19137"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19145"}},{"Add":{"text":"\t\t\tcity,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19155"}},{"Add":{"text":"\t\t\t'manitoba',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19171"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19185"}},{"Add":{"text":"\t\t\t''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19192"}},{"Add":{"text":"\t\tfrom manitoba\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19209"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19222"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19232"}},{"Add":{"text":"\t\t\tjoined_name,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19249"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19262"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19270"}},{"Add":{"text":"\t\t\tcity,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19280"}},{"Add":{"text":"\t\t\t'saskatchewan',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19300"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19314"}},{"Add":{"text":"\t\t\t''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19321"}},{"Add":{"text":"\t\tfrom saskatchewan\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19342"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19355"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19365"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19373"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19386"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19394"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19402"}},{"Add":{"text":"\t\t\t'newbrunswick',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19422"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19436"}},{"Add":{"text":"\t\t\t''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19443"}},{"Add":{"text":"\t\tfrom newbrunswick\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19464"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19477"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19487"}},{"Add":{"text":"\t\t\tjoined_name,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19504"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19517"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19525"}},{"Add":{"text":"\t\t\tcity,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19535"}},{"Add":{"text":"\t\t\t'britishcolumbia',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19558"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19572"}},{"Add":{"text":"\t\t\tpostal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19588"}},{"Add":{"text":"\t\tfrom britishcolumbia\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19612"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19625"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19635"}},{"Add":{"text":"\t\t\tjoined_name,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19652"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19665"}},{"Add":{"text":"\t\t\taddress2,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19679"}},{"Add":{"text":"\t\t\tcity,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19689"}},{"Add":{"text":"\t\t\t'newfoundland',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19709"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19723"}},{"Add":{"text":"\t\t\tpostal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19739"}},{"Add":{"text":"\t\tfrom newfoundland\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19760"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19773"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19783"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19791"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19804"}},{"Add":{"text":"\t\t\taddress2,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19818"}},{"Add":{"text":"\t\t\tcity,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19828"}},{"Add":{"text":"\t\t\t'novascotia',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19846"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19860"}},{"Add":{"text":"\t\t\tpostal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19876"}},{"Add":{"text":"\t\tfrom novascotia\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19895"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19908"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19918"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19926"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19939"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19947"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19955"}},{"Add":{"text":"\t\t\t'pei',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19966"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19980"}},{"Add":{"text":"\t\t\t''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19987"}},{"Add":{"text":"\t\tfrom pei\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:19999"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20012"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20022"}},{"Add":{"text":"\t\t\tjoined_name,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20039"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20052"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20060"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20068"}},{"Add":{"text":"\t\t\t'yukon',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20081"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20095"}},{"Add":{"text":"\t\t\t''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20102"}},{"Add":{"text":"\t\tfrom yukon\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20116"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20129"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20139"}},{"Add":{"text":"\t\t\tjoined_name,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20156"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20169"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20177"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20185"}},{"Add":{"text":"\t\t\t'nwt',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20196"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20210"}},{"Add":{"text":"\t\t\t''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20217"}},{"Add":{"text":"\t\tfrom nwt\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20229"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20242"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20252"}},{"Add":{"text":"\t\t\tjoined_name,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20269"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20282"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20290"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20298"}},{"Add":{"text":"\t\t\t'ontario',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20313"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20327"}},{"Add":{"text":"\t\t\t''\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20334"}},{"Add":{"text":"\t\tfrom ontario\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20350"}},{"Add":{"text":"\t\tunion all\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20363"}},{"Add":{"text":"\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20373"}},{"Add":{"text":"\t\t\t'',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20381"}},{"Add":{"text":"\t\t\taddress,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20394"}},{"Add":{"text":"\t\t\taddress2,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20408"}},{"Add":{"text":"\t\t\tcity,\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20418"}},{"Add":{"text":"\t\t\t'quebec',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20432"}},{"Add":{"text":"\t\t\t'canada',\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20446"}},{"Add":{"text":"\t\t\tpostal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20462"}},{"Add":{"text":"\t\tfrom quebec\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20477"}},{"Add":{"text":"\t`);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20483"}},{"Add":{"text":"\tlet removeQ = (await postgres.query(`\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20523"}},{"Add":{"text":"\t\tselect *\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20535"}},{"Add":{"text":"\t\tfrom store_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20554"}},{"Add":{"text":"\t\twhere not exists (\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20576"}},{"Add":{"text":"\t\t\tselect\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20587"}},{"Add":{"text":"\t\t\tfrom store_temp_temp\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20612"}},{"Add":{"text":"\t\t\twhere\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20622"}},{"Add":{"text":"\t\t\t\tjoined_name = store_temp.joined_name and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20668"}},{"Add":{"text":"\t\t\t\taddress = store_temp.address and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20706"}},{"Add":{"text":"\t\t\t\taddress2 = store_temp.address2 and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20746"}},{"Add":{"text":"\t\t\t\tcity = store_temp.city and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20778"}},{"Add":{"text":"\t\t\t\tregion = store_temp.region and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20814"}},{"Add":{"text":"\t\t\t\tcountry = store_temp.country and\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20852"}},{"Add":{"text":"\t\t\t\tpostal_code = store_temp.postal_code\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20894"}},{"Add":{"text":"\t\t)\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20899"}},{"Add":{"text":"\t`)).rows;\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20911"}},{"Add":{"text":"\tif(removeQ.length) {\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20934"}},{"Add":{"text":"\t\tconsole.log('human, should these be removed?', removeQ);\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20994"}},{"Add":{"text":"\t}\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:20998"}},{"Add":{"text":"\tawait postgres.query('truncate store_temp');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:21045"}},{"Add":{"text":"\tawait postgres.query('insert into store_temp select * from store_temp_temp');\r","pos":"XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC:21125"}}]}}],"owner":"boogerlad","repo":"mj","token":"jCsRWE63MTnVaz3jJnmgxBGqsBViXrxcVDMNTEZAIXc=","login":null}

…

Dependencies

Change contents

Review