{"header":{"message":"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","description":null,"timestamp":"2020-08-10T20:32:34Z","authors":[{"email":"boogerlad@gmail.com","name":"boogerlad"}]},"hash":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC","authors":[],"deps":{"hashes":[["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"],["AA",null],["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"],["RAN5QU4U2OVNLDGZVVTJNCXDN5GNAVPXGKHADZO2ML3Y5KLU4QPQC","replace blake2 with blake3. I think node being a wrapper around openSSL makes it slow. 481,000ops/s vs 1,970,000ops/s\ndecrease token length and hash length to 128bits(argon2 waiting for pr to land: https://github.com/ranisalt/node-argon2/pull/266)\nhttps://security.stackexchange.com/questions/102157/do-you-need-more-than-128-bit-entropy \"128 bits of entropy are enough. if you generate a 256-bit AES key from a 128-bit seed and a strong PRNG, then you do not really have a 256-bit key.\"\nhttps://crypto.stackexchange.com/a/29618 \"if you had random binary tokens, a token longer than [hash function digest length]bits would be useless.\"\nhex encode instead of base64\nthere exists a timing attack via dictionary reduction on hash prefix discovery\ntherefore, not applicable to lobomj. password hashes are salted(if the salt is known, so is the hash) and tokens are of sufficient entropy to make brute force/dictionary infeasible.\nhttps://github.com/codahale/bcrypt-ruby/pull/43#issuecomment-15797932\nhttps://github.com/aj-code/TimingIntrusionTool5000/blob/master/TimingAttackPresentation2012.pdf slide 21\nhttps://crypto.stackexchange.com/questions/25607\nhttps://security.stackexchange.com/questions/9192\nhttps://crypto.stackexchange.com/questions/40433 \"If \"honey7dew\" is replaced by something with high entropy (hopeless to guess), there demonstrably is no attack enabled by timing of the comparison: if there was one, it would break the first preimage resistance of the hash.\"\n"],["QFATAUXF3SMSTZULKPCK4W3AZ4NEO3VFZE7SWIBDBXGC7JU5L6TAC","Update Summit script to fetch new Dawson Creek store (brand change)\n"],["2FPZGFF5PCGNV45HOB6TROMJFPURHPXM7YSPWNXCHFJS7EICVKQAC","authenticated and user count, remember me expiry, actually follow format, some pubsub fun, unregister, disallow multiple sockets with same credentials\n"],["2ZHTBPOJQI4FS3OQJXUDBD62HVFPGSKI633IXXKAGPGQLURMKVPAC","more constraints, upgrade google maps, share normalize function from scrape, create store validation, error handling, insertion of images, store times minute of week range, dynamic query creation, combine multiple queries to one cte because lazy to figure out transaction and network latency :(\n"],["4WREYORZT3SWUXADWHSS6B4PQSP3QSLH77CGNKRH6IRKUMX4TARAC","create store WIP\n"],["Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC","lift stores dump and summit greenline\n"],["I4MTA4E4GTMWJ4NC42QRWV55JRZ2K2W7SDSH5GAW2N4MIAQWS3DQC","strain family, brand, producer normalization\n"],["7XVW32MMBBIGWQZ3QRD365TBIJU4DYN6T4VO2E46WFDCFHGO2BMAC","\"update profile\" endpoint. so far just email and password, but trivial to add more fields. admin edit user not done yet\nallow login via magic link\n"],["JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC","update dependencies\ndeduplicate imports and stop reading the wrong .env\ndon't upgrade the connection to a websocket if wrong origin\nswitch from user type enum to god boolean + acl. this way, a user can be a(n) worker / owner of multiple stores\ndon't bother caching the user type in ws anymore. always get the truth from database\nskip stock check if just changing cart's user\nimplement otp login on connection as fallback to remember me token\non connection login event instead of firth\nreturn minimum number of fields from user\non unauthorized due to not >= store (owner || worker), update user acl event\nonly publish number of authenticated / connected on change\nregister logs in as well\nmerge cart (associate anonymous cart to user on login / register, transfer line item from anonymous cart to authenticated cart, add quantities of line items with same menu item together from anonymous to authenticated cart)\nend connection on logout and old connection if exists if login elsewhere\ntaxes for types (bc 20% vapes) + include tax in price when viewing products\nstock level now takes into account # of reserved\ntrigger for stock decrement on ready -> paid\nmin / max quantity filter for products\nwhen user / store deleted and last status of cart is 'placed' or 'ready', add fake final store / user cancelled event\nif god, created product will be visible for menu_item_loader. if store owner, not visible so that lobo can review\nimplement roles so that a store owner / worker can only access their stores defined by the acl for menu items, reservations\nimplement god see users' reservations and cancel\nimplement the rest of the reservation flow notifications (store status update, user cancel)\nimplement store add event\n\nsadly, lots of copy and paste. if the pattern is good, let's clean this up. I estimate 500 lines of code to be shaven off\n"],["63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC","rename strain_family to strain, strain to species\nsupport new schema\nmove queries to postgres function\n"],["VO5G3FF3NDOKCIF2OU7G257R3XIPTFDCAMDTOVKHKOB5Z3I55KDQC","dependencies\n"],["CLMZIURF2TXSMQ6YZYXR5CHGMRW6V64YFQLRCP3H3I3XB2KKOJ6AC","might as well upgrade every other dependency too\n"],["CMOE5TZ3HY6BG6KB56HMIJ6BU5J6D3NE7VFK2NSAX2XEXAPEKJQQC","automatically merge adjacent and overlapping ranges for store times instead of erroring out on exclude constraint thanks to range_agg\nalso if close time is less than or equal to open time, don't error out!! that just means loops through to next week, or means always open\nconsider sunday 5pm to monday 12am or 2am\n6 * 24 * 60 + 17 * 60 = 9660 to 0 or 120 should be valid!\nalso remove first_last_agg polyfill. if you can't install extensions, you're fucked anyways\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"],["MPLKJQVEPZB7GEWAKZOOIKBKWHTNQX3LLESCQEG4PE3CUHQEYUBAC","scraper stub of albertcannabis.org\n"],["BEPIROVOYHYS77KH7GAHNWZRIWLPN5IV2BYG372YG4R75UHYH7AQC","forgot to uncomment puppeteer dependency\n"],["Z7XOXXDJ7T6E4ZCP2AK5YSXWE6TCDCLZEXAZPZZVLOY4WCFVZPHAC","store creation new fields, osrm_hints, store distance. Still undecided as to what to return for \"stores\" though...\n"],["XQA3IQXSGAO2FST3F64WLVZ7JNLMQYKT3LO4SHHKYR2D765OPGHQC","update store table\n"],["SE6MCCXTIXSGMAH5EL7EPDXIQKV6THCCY2H4OQJJQOHCUQAWE5VQC","ocs.ca scraper\n"],["E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC","sql schema\n"],["QQAJ5O5EW6ASWLXQ627Y2F6YGMYKCM4WS37LTZYOMNPPFDPMNBUAC","cleanup modifycart, anonymous carts, current and historic reservations for user and stores, proof of concept notification from user to store on reserve, user_cancel, store_cancel, paid, no_show status set\ntodo: store owner role, merge/promote guest cart to authenticated, stock reduction on paid trigger, set status to cancel on store / user deletion testing, ws notification for other flows, cleanup\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"],["NDMM44EV2XD5RP7J4Q25ZX52LUP7WOMTKO3C2PDXW7IWFEVWUW6QC","revamp table structure in preparation for scraped data. also change open hours and added many constraints. normalize strain family names\n"],["Y4W4MACPKH3IVO6JIQYGN4V5LR6EM6RPZEJ4RHH6ZBZUDA63AGRQC","dependencies and instructions and permission and newline\n"],["WYTMZJFYVKHR4QH7AV5JUNWXT6NAC5NNQNPZCQSDI6LGI7DVXFYAC","user create, login, remember me. todo: logout, list all users, update profile, update user\n"]],"deps":["NHVZFKZDPQGCZ6UOVQU5U3Q3SOAKGOGZNFIE7C6IB6YP3ZS4VVDAC","RAN5QU4U2OVNLDGZVVTJNCXDN5GNAVPXGKHADZO2ML3Y5KLU4QPQC","QFATAUXF3SMSTZULKPCK4W3AZ4NEO3VFZE7SWIBDBXGC7JU5L6TAC"],"known":["VO5G3FF3NDOKCIF2OU7G257R3XIPTFDCAMDTOVKHKOB5Z3I55KDQC","2FPZGFF5PCGNV45HOB6TROMJFPURHPXM7YSPWNXCHFJS7EICVKQAC","4WREYORZT3SWUXADWHSS6B4PQSP3QSLH77CGNKRH6IRKUMX4TARAC","SE6MCCXTIXSGMAH5EL7EPDXIQKV6THCCY2H4OQJJQOHCUQAWE5VQC","2ZHTBPOJQI4FS3OQJXUDBD62HVFPGSKI633IXXKAGPGQLURMKVPAC","MPLKJQVEPZB7GEWAKZOOIKBKWHTNQX3LLESCQEG4PE3CUHQEYUBAC","BEPIROVOYHYS77KH7GAHNWZRIWLPN5IV2BYG372YG4R75UHYH7AQC","I4MTA4E4GTMWJ4NC42QRWV55JRZ2K2W7SDSH5GAW2N4MIAQWS3DQC","63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC","CLMZIURF2TXSMQ6YZYXR5CHGMRW6V64YFQLRCP3H3I3XB2KKOJ6AC","XQA3IQXSGAO2FST3F64WLVZ7JNLMQYKT3LO4SHHKYR2D765OPGHQC","Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC","Z7XOXXDJ7T6E4ZCP2AK5YSXWE6TCDCLZEXAZPZZVLOY4WCFVZPHAC","CMOE5TZ3HY6BG6KB56HMIJ6BU5J6D3NE7VFK2NSAX2XEXAPEKJQQC","7XVW32MMBBIGWQZ3QRD365TBIJU4DYN6T4VO2E46WFDCFHGO2BMAC","JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC","PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC"]},"hunks":[{"Edit":{"inode":{"change":23,"pos":17},"path":"initialize.sql","line":45,"atom":{"NewVertex":{"up_context":[{"change":24,"pos":894}],"down_context":[{"change":25,"pos":146}],"flag":"BLOCK","start":0,"end":209,"inode":{"change":23,"pos":17}}},"contents":[{"Add":{"text":"create or replace function minute_in_range_week(int4range[]) returns boolean as $$\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:83"}},{"Add":{"text":"\tselect every(wow is not null and wow <@ int4range(0, 10080)) from unnest($1) as t(wow);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:173"}},{"Add":{"text":"$$ language sql immutable strict;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:208"}}]}},{"Replacement":{"inode":{"change":23,"pos":17},"path":"initialize.sql","line":73,"ins":{"up_context":[{"change":5,"pos":355}],"down_context":[{"change":5,"pos":431}],"flag":"BLOCK","start":210,"end":291,"inode":{"change":23,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":355},"to":{"change":2,"start":0,"end":50},"introduced_by":2}],"inode":{"change":23,"pos":17}},"ins_contents":[{"Add":{"text":"\topen int4range[] check (array_ndims(open) = 1 and minute_in_range_week(open)),\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:290"}}],"del_contents":[{"Del":{"text":"\topen int4range[] check (array_ndims(open) = 1),\r","pos":"NHVZFKZDPQGCZ6UOVQU5U3Q3SOAKGOGZNFIE7C6IB6YP3ZS4VVDAC:49"}}]}},{"Edit":{"inode":{"change":23,"pos":17},"path":"initialize.sql","line":105,"atom":{"NewVertex":{"up_context":[{"change":5,"pos":1405}],"down_context":[{"change":26,"pos":5750}],"flag":"BLOCK","start":292,"end":550,"inode":{"change":23,"pos":17}}},"contents":[{"Add":{"text":"create table store_open_exception (\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:328"}},{"Add":{"text":"\tstore_open_exception_id serial primary key,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:374"}},{"Add":{"text":"\tstore_id integer not null references store on delete cascade,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:438"}},{"Add":{"text":"\tduring tsrange not null,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:465"}},{"Add":{"text":"\topen int4range[] check (array_ndims(open) = 1 and minute_in_range_week(open))\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:545"}},{"Add":{"text":");\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:549"}}]}},{"Edit":{"inode":{"change":23,"pos":17},"path":"initialize.sql","line":268,"atom":{"NewVertex":{"up_context":[{"change":26,"pos":8751}],"down_context":[{"change":26,"pos":8846}],"flag":"BLOCK","start":551,"end":666,"inode":{"change":23,"pos":17}}},"contents":[{"Add":{"text":"\tperiods.add_system_time_period('store_open_exception'),\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:608"}},{"Add":{"text":"\tperiods.add_system_versioning('store_open_exception'),\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:665"}}]}},{"Edit":{"inode":{"change":23,"pos":17},"path":"initialize.sql","line":484,"atom":{"NewVertex":{"up_context":[{"change":5,"pos":733}],"down_context":[{"change":5,"pos":733}],"flag":"BLOCK","start":667,"end":695,"inode":{"change":23,"pos":17}}},"contents":[{"Add":{"text":"\t_extension citext = null,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:694"}}]}},{"Edit":{"inode":{"change":23,"pos":17},"path":"initialize.sql","line":521,"atom":{"NewVertex":{"up_context":[{"change":5,"pos":1250}],"down_context":[{"change":5,"pos":1250}],"flag":"BLOCK","start":696,"end":711,"inode":{"change":23,"pos":17}}},"contents":[{"Add":{"text":"\t\t\textension,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:710"}}]}},{"Edit":{"inode":{"change":23,"pos":17},"path":"initialize.sql","line":542,"atom":{"NewVertex":{"up_context":[{"change":5,"pos":1472}],"down_context":[{"change":5,"pos":1472}],"flag":"BLOCK","start":712,"end":728,"inode":{"change":23,"pos":17}}},"contents":[{"Add":{"text":"\t\t\t_extension,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:727"}}]}},{"Edit":{"inode":{"change":5,"pos":145},"path":"package-lock.json","line":403,"atom":{"NewVertex":{"up_context":[{"change":27,"pos":3350}],"down_context":[{"change":27,"pos":3350}],"flag":"BLOCK","start":729,"end":985,"inode":{"change":5,"pos":145}}},"contents":[{"Add":{"text":" \"csv-parse\": {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:748"}},{"Add":{"text":" \"version\": \"4.12.0\",\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:776"}},{"Add":{"text":" \"resolved\": \"https://registry.npmjs.org/csv-parse/-/csv-parse-4.12.0.tgz\",\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:858"}},{"Add":{"text":" \"integrity\": \"sha512-wPQl3H79vWLPI8cgKFcQXl0NBgYYEqVnT1i6/So7OjMpsI540oD7p93r3w6fDSyPvwkTepG05F69/7AViX2lXg==\"\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:976"}},{"Add":{"text":" },\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:984"}}]}},{"Replacement":{"inode":{"change":5,"pos":29376},"path":"package.json","line":16,"ins":{"up_context":[{"change":5,"pos":19056}],"down_context":[{"change":5,"pos":29598}],"flag":"BLOCK","start":986,"end":1015,"inode":{"change":5,"pos":29376}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":19056},"to":{"change":5,"start":2009,"end":2038},"introduced_by":5}],"inode":{"change":5,"pos":29376}},"ins_contents":[{"Add":{"text":" \"csv-parse\": \"^4.12.0\",\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1014"}}],"del_contents":[{"Del":{"text":" \"csv-parse\": \"^4.10.1\",\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:2037"}}]}},{"Replacement":{"inode":{"change":5,"pos":4897},"path":"scrape/common.js","line":10,"ins":{"up_context":[{"change":5,"pos":5322}],"down_context":[{"change":5,"pos":5354}],"flag":"BLOCK","start":1016,"end":1437,"inode":{"change":5,"pos":4897}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5322},"to":{"change":5,"start":19258,"end":19306},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":19306},"to":{"change":5,"start":5352,"end":5354},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5352},"to":{"change":5,"start":5352,"end":5354},"introduced_by":5}],"inode":{"change":5,"pos":4897}},"ins_contents":[{"Add":{"text":"const pg = require('pg');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1042"}},{"Add":{"text":"const postgres = new pg.Client();\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1077"}},{"Add":{"text":"const googleMapsClient = new (require(\"@googlemaps/google-maps-services-js\").Client)({});\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1168"}},{"Add":{"text":"const gay = /^Friendly Stranger/i;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1204"}},{"Add":{"text":"const gay2 = /^stash\\s+(and|&)\\s+co/i;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1244"}},{"Add":{"text":"const gay8 = /^fire\\s+(and|&)\\s+flower/i;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1287"}},{"Add":{"text":"const gay3 = /^tokyo\\s+smoke/i;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1320"}},{"Add":{"text":"const gay4 = /^spiritleaf/i;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1350"}},{"Add":{"text":"const gay5 = /^CANNACO/i;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1377"}},{"Add":{"text":"const gay6 = /^one\\s+plant/i;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1408"}},{"Add":{"text":"const gay7 = /^sessions/i;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1436"}}],"del_contents":[{"Del":{"text":"const postgres = new (require('pg').Client)();\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:19305"}},{"Del":{"text":"\r","pos":"SE6MCCXTIXSGMAH5EL7EPDXIQKV6THCCY2H4OQJJQOHCUQAWE5VQC:5353"}}]}},{"Edit":{"inode":{"change":5,"pos":4897},"path":"scrape/common.js","line":22,"atom":{"NewVertex":{"up_context":[{"change":5,"pos":5374}],"down_context":[{"change":5,"pos":5374}],"flag":"BLOCK","start":1438,"end":5647,"inode":{"change":5,"pos":4897}}},"contents":[{"Add":{"text":"\tsanitize_name: function (n) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1469"}},{"Add":{"text":"\t\tif(n === 'Cannabis Boutique Inc.') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1509"}},{"Add":{"text":"\t\t\tn = 'Cannabis Boutique';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1538"}},{"Add":{"text":"\t\t} else if(n === 'MARY JANE RIGS & CANNABIS') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1588"}},{"Add":{"text":"\t\t\tn = 'Mary Jane Rigs & Cannabis';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1625"}},{"Add":{"text":"\t\t} else if(n === 'HELLO CANNABIS SSM') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1668"}},{"Add":{"text":"\t\t\tn = 'HELLO CANNABIS'\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1693"}},{"Add":{"text":"\t\t} else if(gay2.test(n)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1722"}},{"Add":{"text":"\t\t\tn = 'Stash & Co.';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1745"}},{"Add":{"text":"\t\t} else if(gay3.test(n)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1774"}},{"Add":{"text":"\t\t\tn = 'Tokyo Smoke';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1797"}},{"Add":{"text":"\t\t} else if(gay4.test(n)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1826"}},{"Add":{"text":"\t\t\tn = 'SPIRITLEAF';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1848"}},{"Add":{"text":"\t\t} else if(gay5.test(n)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1877"}},{"Add":{"text":"\t\t\tn = 'CANNACO';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1896"}},{"Add":{"text":"\t\t} else if(gay6.test(n)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1925"}},{"Add":{"text":"\t\t\tn = 'One Plant';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1946"}},{"Add":{"text":"\t\t} else if(gay7.test(n)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1975"}},{"Add":{"text":"\t\t\tn = 'Sessions';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:1995"}},{"Add":{"text":"\t\t} else if(gay8.test(n)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2024"}},{"Add":{"text":"\t\t\tn = 'Fire & Flower';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2049"}},{"Add":{"text":"\t\t} else if(n.toLowerCase().trim() === 'rainbow thunder bay cannabis accessories') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2135"}},{"Add":{"text":"\t\t\tn = 'Rainbow';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2154"}},{"Add":{"text":"\t\t} else if(n !== 'Made In Cannabis' && n !== 'Mary Jane on Penny Lane' && n !== 'This Is Cannabis' && n !== 'BURNSIDE BUDS.CA' && n !== 'The Cannabis Guys') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2315"}},{"Add":{"text":"\t\t\tn = n.replace(/\\./g, '');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2345"}},{"Add":{"text":"\t\t\tlet first = n.split(/\\s+/);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2377"}},{"Add":{"text":"\t\t\t//if(first.length > 2) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2406"}},{"Add":{"text":"\t\t\t\t[first, ...n] = first;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2434"}},{"Add":{"text":"\t\t\t\tn = n.join(' ');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2456"}},{"Add":{"text":"\t\t\t\t//todo: replace if not prefixed by \"of\", \"the\", etc. what are those words called?\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2543"}},{"Add":{"text":"\t\t\t\tn = n.split('-')[0].split(/\\bat\\b/i)[0].split(/\\bon\\b/i)[0].replace(/\\b(sale(s?)|shop|retail|boutique|market|premium|cannabis|store(s?)|corp(orat(ed|ion))?|inc(orporat(ed|ion))?|co(mpany)?|supply|retailer(s?)|limited|ltd|calgary|bridgeland|downtown|kensington|barrhaven|recreational|dispensary)\\b|\$.+\$/gi,'').trim();\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2867"}},{"Add":{"text":"\t\t\t\tn = (first + ' ' + n).trim().replace(/\\s+/g, ' ');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2923"}},{"Add":{"text":"\t\t\t\tif(n === '420') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2946"}},{"Add":{"text":"\t\t\t\t\t//console.log('dumbass');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2978"}},{"Add":{"text":"\t\t\t\t\tn = 'FOUR20';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:2998"}},{"Add":{"text":"\t\t\t\t} else if(n === 'HOBO') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3029"}},{"Add":{"text":"\t\t\t\t\tn = 'Hobo';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3047"}},{"Add":{"text":"\t\t\t\t} else if(n === 'NUMO') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3078"}},{"Add":{"text":"\t\t\t\t\tn = 'Numo';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3096"}},{"Add":{"text":"\t\t\t\t} else if(gay.test(n)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3126"}},{"Add":{"text":"\t\t\t\t\tn = \"Friendly Stranger\";\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3157"}},{"Add":{"text":"\t\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3164"}},{"Add":{"text":"\t\t\t//}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3172"}},{"Add":{"text":"\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3177"}},{"Add":{"text":"\t\tif(n.toUpperCase() === n) {//todo: check how many are title cased, all caps, all lower.\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3268"}},{"Add":{"text":"\t\t\t//console.log(`don't yell at me :( ${n}`);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3315"}},{"Add":{"text":"\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3320"}},{"Add":{"text":"\t\treturn n;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3333"}},{"Add":{"text":"\t},\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3338"}},{"Add":{"text":"\tg: async function (address) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3370"}},{"Add":{"text":"\t\tlet addr = {address: '', address2: ''};\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3413"}},{"Add":{"text":"\t\tlet location = (await googleMapsClient.geocode({params: {address, key: process.env.GAPI}})).data;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3514"}},{"Add":{"text":"\t\tif(location.status === 'OK') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3548"}},{"Add":{"text":"\t\t\tlet wow = 0;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3565"}},{"Add":{"text":"\t\t\tfor(let j = 0; j < location.results[0].address_components.length; ++j) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3642"}},{"Add":{"text":"\t\t\t\tif(location.results[0].address_components[j].types.includes('administrative_area_level_1')) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3741"}},{"Add":{"text":"\t\t\t\t\taddr.region = location.results[0].address_components[j].long_name;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3814"}},{"Add":{"text":"\t\t\t\t\t++wow;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3827"}},{"Add":{"text":"\t\t\t\t} else if(location.results[0].address_components[j].types.includes('country')) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3913"}},{"Add":{"text":"\t\t\t\t\taddr.country = location.results[0].address_components[j].long_name;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:3987"}},{"Add":{"text":"\t\t\t\t\t++wow;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4000"}},{"Add":{"text":"\t\t\t\t} else if(location.results[0].address_components[j].types.includes('locality')) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4087"}},{"Add":{"text":"\t\t\t\t\taddr.city = location.results[0].address_components[j].long_name;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4158"}},{"Add":{"text":"\t\t\t\t\t++wow;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4171"}},{"Add":{"text":"\t\t\t\t} else if(location.results[0].address_components[j].types.includes('postal_code')) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4261"}},{"Add":{"text":"\t\t\t\t\taddr.postal_code = location.results[0].address_components[j].long_name.replace(/\\s+/, '');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4358"}},{"Add":{"text":"\t\t\t\t\t++wow;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4371"}},{"Add":{"text":"\t\t\t\t} else if(location.results[0].address_components[j].types.includes('route')) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4455"}},{"Add":{"text":"\t\t\t\t\taddr.address += ' ' + location.results[0].address_components[j].long_name;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4536"}},{"Add":{"text":"\t\t\t\t\t++wow;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4549"}},{"Add":{"text":"\t\t\t\t} else if(location.results[0].address_components[j].types.includes('street_number')) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4641"}},{"Add":{"text":"\t\t\t\t\taddr.address += location.results[0].address_components[j].long_name;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4716"}},{"Add":{"text":"\t\t\t\t\t++wow;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4729"}},{"Add":{"text":"\t\t\t\t} else if(location.results[0].address_components[j].types.includes('subpremise')) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4818"}},{"Add":{"text":"\t\t\t\t\taddr.address2 = location.results[0].address_components[j].long_name;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4893"}},{"Add":{"text":"\t\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4900"}},{"Add":{"text":"\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4906"}},{"Add":{"text":"\t\t\tif(wow < 6) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4924"}},{"Add":{"text":"\t\t\t\tconsole.log('hardcode me', address, location);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:4976"}},{"Add":{"text":"\t\t\t\tthrow('unparseable address');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5011"}},{"Add":{"text":"\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5017"}},{"Add":{"text":"\t\t\tlocation = location.results[0].geometry.location;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5071"}},{"Add":{"text":"\t\t\tlet [tz, foot, car] = await Promise.all([\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5117"}},{"Add":{"text":"\t\t\t\tgoogleMapsClient.timezone({params: {location, timestamp: 0, key: process.env.GAPI}}),\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5208"}},{"Add":{"text":"\t\t\t\trequest(`http://127.0.0.1:5000/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint),\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5338"}},{"Add":{"text":"\t\t\t\trequest(`http://127.0.0.1:5001/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint)\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5467"}},{"Add":{"text":"\t\t\t]);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5475"}},{"Add":{"text":"\t\t\tif(tz.data.status === 'OK') {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5509"}},{"Add":{"text":"\t\t\t\treturn [addr, location, tz.data.timeZoneId, foot, car];\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5570"}},{"Add":{"text":"\t\t\t} else {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5583"}},{"Add":{"text":"\t\t\t\tthrow tz;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5598"}},{"Add":{"text":"\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5604"}},{"Add":{"text":"\t\t} else {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5616"}},{"Add":{"text":"\t\t\tthrow location;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5636"}},{"Add":{"text":"\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5641"}},{"Add":{"text":"\t},\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5646"}}]}},{"Replacement":{"inode":{"change":5,"pos":4897},"path":"scrape/common.js","line":144,"ins":{"up_context":[{"change":5,"pos":5866}],"down_context":[{"change":5,"pos":5888}],"flag":"BLOCK","start":5648,"end":5666,"inode":{"change":5,"pos":4897}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5866},"to":{"change":5,"start":5866,"end":5888},"introduced_by":5}],"inode":{"change":5,"pos":4897}},"ins_contents":[{"Add":{"text":"\tpg,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5653"}},{"Add":{"text":"\tpostgres,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5665"}}],"del_contents":[{"Del":{"text":"\tpostgres: postgres,\r","pos":"SE6MCCXTIXSGMAH5EL7EPDXIQKV6THCCY2H4OQJJQOHCUQAWE5VQC:5887"}}]}},{"FileMove":{"meta":{"basename":"dc.js","metadata":511},"old":[{"basename":"summit.js","metadata":511}],"up":[{"change":5,"pos":4884}],"down":[{"change":5,"pos":2476587}],"show_perms":false}},{"Replacement":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":1,"ins":{"up_context":[{"change":5,"pos":2476587}],"down_context":[{"change":5,"pos":2476751}],"flag":"BLOCK","start":5675,"end":5771,"inode":{"change":5,"pos":2476587}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2476587},"to":{"change":5,"start":2476588,"end":2476751},"introduced_by":5}],"inode":{"change":5,"pos":2476587}},"ins_contents":[{"Add":{"text":"Object.entries(require('./common.js')).forEach(([name, exported]) => global[name] = exported);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5770"}}],"del_contents":[{"Del":{"text":"const request = require('request-promise-native');\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2476639"}},{"Del":{"text":"require('dotenv').config({path: '../.env'});\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2476685"}},{"Del":{"text":"const { Client } = require('pg');\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2476720"}},{"Del":{"text":"let postgres = new Client();\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2476750"}}]}},{"Edit":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":41,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478051},"to":{"change":5,"start":2478051,"end":2478428},"introduced_by":5}],"inode":{"change":5,"pos":2476587}}},"contents":[{"Del":{"text":"let hints = Promise.all([\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478077"}},{"Del":{"text":"\trequest('http://127.0.0.1:5000/nearest/v1/fuck/-120.2209884,55.7501513').then(x => JSON.parse(x).waypoints[0].hint),\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478196"}},{"Del":{"text":"\trequest('http://127.0.0.1:5001/nearest/v1/fuck/-120.2209884,55.7501513').then(x => JSON.parse(x).waypoints[0].hint),\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478315"}},{"Del":{"text":"\t'https://images.squarespace-cdn.com/content/5d2516d4eafe0d00016d4f52/1563851764355-Z79A7Y9YMODUHQ06GDR2'\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478422"}},{"Del":{"text":"]);\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478427"}}]}},{"Replacement":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":43,"ins":{"up_context":[{"change":5,"pos":2478501}],"down_context":[{"change":5,"pos":2478680}],"flag":"BLOCK","start":5772,"end":5939,"inode":{"change":5,"pos":2476587}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478501},"to":{"change":5,"start":2478501,"end":2478584},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478584},"to":{"change":4,"start":0,"end":34},"introduced_by":4},{"previous":"","flag":"DELETED","from":{"change":4,"pos":34},"to":{"change":5,"start":2478599,"end":2478680},"introduced_by":4},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478599},"to":{"change":5,"start":2478599,"end":2478680},"introduced_by":5}],"inode":{"change":5,"pos":2476587}},"ins_contents":[{"Add":{"text":"\t.then(async () => {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5793"}},{"Add":{"text":"\t\tlet r = await g(\"UNIT 19 - 11000 8 St, Dawson Creek, V1G 4K6, british columbia, canada\");\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5886"}},{"Add":{"text":"\t\treturn postgres.query(\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5912"}},{"Add":{"text":"\t\t\t`select ios_store_id(\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5938"}}],"del_contents":[{"Del":{"text":"\t.then(async () => postgres.query(\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478536"}},{"Del":{"text":"\t\t`with storeid as (\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478558"}},{"Del":{"text":"\t\t\tselect ios_store_id(\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478583"}},{"Del":{"text":"\t\t\t\t'Dawson Creek Cannabis Co.',\r","pos":"QFATAUXF3SMSTZULKPCK4W3AZ4NEO3VFZE7SWIBDBXGC7JU5L6TAC:33"}},{"Del":{"text":"\t\t\t\t'british columbia',\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478623"}},{"Del":{"text":"\t\t\t\t'canada',\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478638"}},{"Del":{"text":"\t\t\t\t'11000 8th Street',\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478663"}},{"Del":{"text":"\t\t\t\t'Unit 19',\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478679"}}]}},{"Edit":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":48,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478701},"to":{"change":5,"start":2478701,"end":2478716},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478716},"to":{"change":4,"start":35,"end":78},"introduced_by":4},{"previous":"","flag":"DELETED","from":{"change":4,"pos":78},"to":{"change":5,"start":2478756,"end":2478792},"introduced_by":4},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478756},"to":{"change":5,"start":2478756,"end":2478792},"introduced_by":5}],"inode":{"change":5,"pos":2476587}}},"contents":[{"Del":{"text":"\t\t\t\t'V1G4K6',\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478715"}},{"Del":{"text":"\t\t\t\t'https://www.dawsoncreekcannabis.co',\r","pos":"QFATAUXF3SMSTZULKPCK4W3AZ4NEO3VFZE7SWIBDBXGC7JU5L6TAC:77"}},{"Del":{"text":"\t\t\t\t-120.2209884,\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478774"}},{"Del":{"text":"\t\t\t\t55.7501513,\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478791"}}]}},{"Replacement":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":50,"ins":{"up_context":[{"change":5,"pos":2478810}],"down_context":[{"change":5,"pos":2478839}],"flag":"BLOCK","start":5940,"end":6066,"inode":{"change":5,"pos":2476587}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478810},"to":{"change":5,"start":2478810,"end":2478839},"introduced_by":5}],"inode":{"change":5,"pos":2476587}},"ins_contents":[{"Add":{"text":"\t\t\t\t$3,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5948"}},{"Add":{"text":"\t\t\t\t$4,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5957"}},{"Add":{"text":"\t\t\t\t$5,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5966"}},{"Add":{"text":"\t\t\t\t$6,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:5975"}},{"Add":{"text":"\t\t\t\t'https://www.dawsoncreekcannabis.co',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6018"}},{"Add":{"text":"\t\t\t\t$7,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6027"}},{"Add":{"text":"\t\t\t\t$8,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6036"}},{"Add":{"text":"\t\t\t\t$9,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6045"}},{"Add":{"text":"\t\t\t\t$10,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6055"}},{"Add":{"text":"\t\t\t\t$11,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6065"}}],"del_contents":[{"Del":{"text":"\t\t\t\t'America/Dawson_Creek',\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478838"}}]}},{"Edit":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":61,"atom":{"NewVertex":{"up_context":[{"change":5,"pos":2478858}],"down_context":[{"change":5,"pos":2478858}],"flag":"BLOCK","start":6067,"end":6078,"inode":{"change":5,"pos":2476587}}},"contents":[{"Add":{"text":"\t\t\t\tnull,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6077"}}]}},{"Replacement":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":63,"ins":{"up_context":[{"change":5,"pos":2478868}],"down_context":[{"change":5,"pos":2479068}],"flag":"BLOCK","start":6079,"end":6227,"inode":{"change":5,"pos":2476587}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2478868},"to":{"change":5,"start":2478868,"end":2479068},"introduced_by":5}],"inode":{"change":5,"pos":2476587}},"ins_contents":[{"Add":{"text":"\t\t\t)`,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6086"}},{"Add":{"text":"\t\t\t[r[0].region, r[0].country, r[0].address, r[0].address2, r[0].city, r[0].postal_code, r[1].lng, r[1].lat, r[3], r[4], r[2]]\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6214"}},{"Add":{"text":"\t\t);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6220"}},{"Add":{"text":"\t});\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6226"}}],"del_contents":[{"Del":{"text":"\t\t\t)\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478873"}},{"Del":{"text":"\t\t),\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478879"}},{"Del":{"text":"\t\tins as (\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478891"}},{"Del":{"text":"\t\t\tinsert into store_image (store_id, url)\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478935"}},{"Del":{"text":"\t\t\tselect ios_store_id, $3 from storeid\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2478976"}},{"Del":{"text":"\t\t\ton conflict do nothing\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2479003"}},{"Del":{"text":"\t\t)\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2479008"}},{"Del":{"text":"\t\tselect ios_store_id from storeid`,\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2479046"}},{"Del":{"text":"\t\tawait hints\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2479061"}},{"Del":{"text":"\t));\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2479067"}}]}},{"Replacement":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":81,"ins":{"up_context":[{"change":5,"pos":2479720}],"down_context":[{"change":5,"pos":2479818}],"flag":"BLOCK","start":6228,"end":6393,"inode":{"change":5,"pos":2476587}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2479720},"to":{"change":5,"start":2479720,"end":2479818},"introduced_by":5}],"inode":{"change":5,"pos":2476587}},"ins_contents":[{"Add":{"text":"\t\t//todo: other official government online stores\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6278"}},{"Add":{"text":"\t\t//default concentrations from online stores with fixed prescedence. OCS seems to have the highest quality data\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6392"}}],"del_contents":[{"Del":{"text":"\t\t//todo: other official government online stores, prescedence to be deterministic, canada only?\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2479817"}}]}},{"Edit":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":98,"atom":{"NewVertex":{"up_context":[{"change":5,"pos":2480137}],"down_context":[{"change":5,"pos":2480137}],"flag":"BLOCK","start":6394,"end":6547,"inode":{"change":5,"pos":2476587}}},"contents":[{"Add":{"text":"\t\t\t\taddress is null and address2 is null and city is null and postal_code is null and longitude is null and latitude is null and country = 'canada' and\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6546"}}]}},{"Replacement":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":100,"ins":{"up_context":[{"change":5,"pos":2480144}],"down_context":[{"change":5,"pos":2480320}],"flag":"BLOCK","start":6548,"end":6713,"inode":{"change":5,"pos":2476587}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2480144},"to":{"change":5,"start":2480144,"end":2480320},"introduced_by":5}],"inode":{"change":5,"pos":2476587}},"ins_contents":[{"Add":{"text":"\t\t\t\t\tjoined_name = 'ocs' and region = 'ontario' or\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6599"}},{"Add":{"text":"\t\t\t\t\tjoined_name = 'bc' and region = 'british columbia' or\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6659"}},{"Add":{"text":"\t\t\t\t\tjoined_name = 'alberta' and region = 'alberta'\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6712"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\tname = 'Ontario Cannabis Store' and region = 'ontario' and country = 'canada' or\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2480230"}},{"Del":{"text":"\t\t\t\t\tname = 'BC Cannabis Stores' and region = 'british columbia' and country = 'canada'\r","pos":"Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC:2480319"}}]}},{"Replacement":{"inode":{"change":5,"pos":2476587},"path":"scrape/dc.js","line":121,"ins":{"up_context":[{"change":5,"pos":2480843}],"down_context":[],"flag":"BLOCK","start":6714,"end":6719,"inode":{"change":5,"pos":2476587}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2480843},"to":{"change":4,"start":79,"end":86},"introduced_by":4}],"inode":{"change":5,"pos":2476587}},"ins_contents":[{"Add":{"text":"})();","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6719"}}],"del_contents":[{"Del":{"text":"})();\r","pos":"QFATAUXF3SMSTZULKPCK4W3AZ4NEO3VFZE7SWIBDBXGC7JU5L6TAC:85"}}]}},{"Edit":{"inode":{"change":5,"pos":2622},"path":"scrape/stores.js","line":2,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2719},"to":{"change":5,"start":2719,"end":2810},"introduced_by":5}],"inode":{"change":5,"pos":2622}}},"contents":[{"Del":{"text":"const googleMapsClient = new (require(\"@googlemaps/google-maps-services-js\").Client)({});\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:2809"}}]}},{"Edit":{"inode":{"change":5,"pos":2622},"path":"scrape/stores.js","line":3,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":2856},"to":{"change":5,"start":2856,"end":3124},"introduced_by":5}],"inode":{"change":5,"pos":2622}}},"contents":[{"Del":{"text":"const gay = /^Friendly Stranger/i;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:2891"}},{"Del":{"text":"const gay2 = /^stash\\s+(and|&)\\s+co/i;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:2931"}},{"Del":{"text":"const gay8 = /^fire\\s+(and|&)\\s+flower/i;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:2974"}},{"Del":{"text":"const gay3 = /^tokyo\\s+smoke/i;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3007"}},{"Del":{"text":"const gay4 = /^spiritleaf/i;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3037"}},{"Del":{"text":"const gay5 = /^CANNACO/i;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3064"}},{"Del":{"text":"const gay6 = /^one\\s+plant/i;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3095"}},{"Del":{"text":"const gay7 = /^sessions/i;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3123"}}]}},{"Edit":{"inode":{"change":5,"pos":2622},"path":"scrape/stores.js","line":5,"atom":{"EdgeMap":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":3211},"to":{"change":5,"start":3211,"end":7318},"introduced_by":5}],"inode":{"change":5,"pos":2622}}},"contents":[{"Del":{"text":"function sanitize_name(n) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3239"}},{"Del":{"text":"\tif(n === 'Cannabis Boutique Inc.') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3278"}},{"Del":{"text":"\t\tn = 'Cannabis Boutique';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3306"}},{"Del":{"text":"\t} else if(n === 'MARY JANE RIGS & CANNABIS') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3355"}},{"Del":{"text":"\t\tn = 'Mary Jane Rigs & Cannabis';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3391"}},{"Del":{"text":"\t} else if(n === 'HELLO CANNABIS SSM') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3433"}},{"Del":{"text":"\t\tn = 'HELLO CANNABIS'\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3457"}},{"Del":{"text":"\t} else if(gay2.test(n)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3485"}},{"Del":{"text":"\t\tn = 'Stash & Co.';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3507"}},{"Del":{"text":"\t} else if(gay3.test(n)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3535"}},{"Del":{"text":"\t\tn = 'Tokyo Smoke';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3557"}},{"Del":{"text":"\t} else if(gay4.test(n)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3585"}},{"Del":{"text":"\t\tn = 'SPIRITLEAF';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3606"}},{"Del":{"text":"\t} else if(gay5.test(n)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3634"}},{"Del":{"text":"\t\tn = 'CANNACO';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3652"}},{"Del":{"text":"\t} else if(gay6.test(n)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3680"}},{"Del":{"text":"\t\tn = 'One Plant';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3700"}},{"Del":{"text":"\t} else if(gay7.test(n)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3728"}},{"Del":{"text":"\t\tn = 'Sessions';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3747"}},{"Del":{"text":"\t} else if(gay8.test(n)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3775"}},{"Del":{"text":"\t\tn = 'Fire & Flower';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3799"}},{"Del":{"text":"\t} else if(n.toLowerCase().trim() === 'rainbow thunder bay cannabis accessories') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3884"}},{"Del":{"text":"\t\tn = 'Rainbow';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:3902"}},{"Del":{"text":"\t} else if(n !== 'Made In Cannabis' && n !== 'Mary Jane on Penny Lane' && n !== 'This Is Cannabis' && n !== 'BURNSIDE BUDS.CA' && n !== 'The Cannabis Guys') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4062"}},{"Del":{"text":"\t\tn = n.replace(/\\./g, '');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4091"}},{"Del":{"text":"\t\tlet first = n.split(/\\s+/);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4122"}},{"Del":{"text":"\t\t//if(first.length > 2) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4150"}},{"Del":{"text":"\t\t\t[first, ...n] = first;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4177"}},{"Del":{"text":"\t\t\tn = n.join(' ');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4198"}},{"Del":{"text":"\t\t\t//todo: replace if not prefixed by \"of\", \"the\", etc. what are those words called?\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4284"}},{"Del":{"text":"\t\t\tn = n.split('-')[0].split(/\\bat\\b/i)[0].split(/\\bon\\b/i)[0].replace(/\\b(sale(s?)|shop|retail|boutique|market|premium|cannabis|store(s?)|corp(orat(ed|ion))?|inc(orporat(ed|ion))?|co(mpany)?|supply|retailer(s?)|limited|ltd|calgary|bridgeland|downtown|kensington|barrhaven|recreational|dispensary)\\b|\$.+\$/gi,'').trim();\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4607"}},{"Del":{"text":"\t\t\tn = (first + ' ' + n).trim().replace(/\\s+/g, ' ');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4662"}},{"Del":{"text":"\t\t\tif(n === '420') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4684"}},{"Del":{"text":"\t\t\t\t//console.log('dumbass');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4715"}},{"Del":{"text":"\t\t\t\tn = 'FOUR20';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4734"}},{"Del":{"text":"\t\t\t} else if(n === 'HOBO') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4764"}},{"Del":{"text":"\t\t\t\tn = 'Hobo';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4781"}},{"Del":{"text":"\t\t\t} else if(n === 'NUMO') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4811"}},{"Del":{"text":"\t\t\t\tn = 'Numo';\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4828"}},{"Del":{"text":"\t\t\t} else if(gay.test(n)) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4857"}},{"Del":{"text":"\t\t\t\tn = \"Friendly Stranger\";\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4887"}},{"Del":{"text":"\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4893"}},{"Del":{"text":"\t\t//}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4900"}},{"Del":{"text":"\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4904"}},{"Del":{"text":"\tif(n.toUpperCase() === n) {//todo: check how many are title cased, all caps, all lower.\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:4994"}},{"Del":{"text":"\t\t//console.log(`don't yell at me :( ${n}`);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5040"}},{"Del":{"text":"\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5044"}},{"Del":{"text":"\treturn n;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5056"}},{"Del":{"text":"}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5059"}},{"Del":{"text":"async function g(address) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5088"}},{"Del":{"text":"\tlet addr = {address: '', address2: ''};\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5130"}},{"Del":{"text":"\tlet location = (await googleMapsClient.geocode({params: {address, key: process.env.GAPI}})).data;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5230"}},{"Del":{"text":"\tif(location.status === 'OK') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5263"}},{"Del":{"text":"\t\tlet wow = 0;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5279"}},{"Del":{"text":"\t\tfor(let j = 0; j < location.results[0].address_components.length; ++j) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5355"}},{"Del":{"text":"\t\t\tif(location.results[0].address_components[j].types.includes('administrative_area_level_1')) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5453"}},{"Del":{"text":"\t\t\t\taddr.region = location.results[0].address_components[j].long_name;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5525"}},{"Del":{"text":"\t\t\t\t++wow;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5537"}},{"Del":{"text":"\t\t\t} else if(location.results[0].address_components[j].types.includes('country')) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5622"}},{"Del":{"text":"\t\t\t\taddr.country = location.results[0].address_components[j].long_name;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5695"}},{"Del":{"text":"\t\t\t\t++wow;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5707"}},{"Del":{"text":"\t\t\t} else if(location.results[0].address_components[j].types.includes('locality')) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5793"}},{"Del":{"text":"\t\t\t\taddr.city = location.results[0].address_components[j].long_name;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5863"}},{"Del":{"text":"\t\t\t\t++wow;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5875"}},{"Del":{"text":"\t\t\t} else if(location.results[0].address_components[j].types.includes('postal_code')) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:5964"}},{"Del":{"text":"\t\t\t\taddr.postal_code = location.results[0].address_components[j].long_name.replace(/\\s+/, '');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6060"}},{"Del":{"text":"\t\t\t\t++wow;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6072"}},{"Del":{"text":"\t\t\t} else if(location.results[0].address_components[j].types.includes('route')) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6155"}},{"Del":{"text":"\t\t\t\taddr.address += ' ' + location.results[0].address_components[j].long_name;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6235"}},{"Del":{"text":"\t\t\t\t++wow;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6247"}},{"Del":{"text":"\t\t\t} else if(location.results[0].address_components[j].types.includes('street_number')) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6338"}},{"Del":{"text":"\t\t\t\taddr.address += location.results[0].address_components[j].long_name;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6412"}},{"Del":{"text":"\t\t\t\t++wow;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6424"}},{"Del":{"text":"\t\t\t} else if(location.results[0].address_components[j].types.includes('subpremise')) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6512"}},{"Del":{"text":"\t\t\t\taddr.address2 = location.results[0].address_components[j].long_name;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6586"}},{"Del":{"text":"\t\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6592"}},{"Del":{"text":"\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6597"}},{"Del":{"text":"\t\tif(wow < 6) {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6614"}},{"Del":{"text":"\t\t\tconsole.log('hardcode me', address, location);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6665"}},{"Del":{"text":"\t\t\tthrow('unparseable address');\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6699"}},{"Del":{"text":"\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6704"}},{"Del":{"text":"\t\tlocation = location.results[0].geometry.location;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6757"}},{"Del":{"text":"\t\tlet [tz, foot, car] = await Promise.all([\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6802"}},{"Del":{"text":"\t\t\tgoogleMapsClient.timezone({params: {location, timestamp: 0, key: process.env.GAPI}}),\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:6892"}},{"Del":{"text":"\t\t\trequest(`http://127.0.0.1:5000/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint),\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7021"}},{"Del":{"text":"\t\t\trequest(`http://127.0.0.1:5001/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint)\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7149"}},{"Del":{"text":"\t\t]);\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7156"}},{"Del":{"text":"\t\tif(tz.data.status === 'OK') {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7189"}},{"Del":{"text":"\t\t\treturn [addr, location, tz.data.timeZoneId, foot, car];\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7249"}},{"Del":{"text":"\t\t} else {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7261"}},{"Del":{"text":"\t\t\tthrow tz;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7275"}},{"Del":{"text":"\t\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7280"}},{"Del":{"text":"\t} else {\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7291"}},{"Del":{"text":"\t\tthrow location;\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7310"}},{"Del":{"text":"\t}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7314"}},{"Del":{"text":"}\r","pos":"PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC:7317"}}]}},{"Replacement":{"inode":{"change":28,"pos":590},"path":"server.js","line":8,"ins":{"up_context":[{"change":5,"pos":271}],"down_context":[{"change":3,"pos":395}],"flag":"BLOCK","start":6720,"end":6749,"inode":{"change":28,"pos":590}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":271},"to":{"change":5,"start":19382,"end":19515},"introduced_by":5}],"inode":{"change":28,"pos":590}},"ins_contents":[{"Add":{"text":"const pool = new pg.Pool();\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6748"}}],"del_contents":[{"Del":{"text":"const pool = new (require('pg').Pool)();\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:19423"}},{"Del":{"text":"const googleMapsClient = new (require(\"@googlemaps/google-maps-services-js\").Client)({});\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:19514"}}]}},{"Replacement":{"inode":{"change":28,"pos":590},"path":"server.js","line":812,"ins":{"up_context":[{"change":5,"pos":40938}],"down_context":[{"change":5,"pos":42121}],"flag":"BLOCK","start":6750,"end":7119,"inode":{"change":28,"pos":590}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":40938},"to":{"change":5,"start":40938,"end":42121},"introduced_by":5}],"inode":{"change":28,"pos":590}},"ins_contents":[{"Add":{"text":"\t\t\t\t\tlet addr, location, tz, foot, car;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6790"}},{"Add":{"text":"\t\t\t\t\ttry {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6802"}},{"Add":{"text":"\t\t\t\t\t\t[addr, location, tz, foot, car] = await g(`${parameters.address}, ${parameters.address2}, ${parameters.city}, ${parameters.region}, ${parameters.country}, ${parameters.postal_code}`);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:6993"}},{"Add":{"text":"\t\t\t\t\t} catch(e) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7012"}},{"Add":{"text":"\t\t\t\t\t\tif(e.response) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7036"}},{"Add":{"text":"\t\t\t\t\t\t\tconsole.error(e.response.data);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7076"}},{"Add":{"text":"\t\t\t\t\t\t} else {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7092"}},{"Add":{"text":"\t\t\t\t\t\t\tconsole.error(e);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7118"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\tif(notmissing(parameters, ['name', 'address', 'city', 'region', 'country', 'postal_code'], ws, request_ID)) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41053"}},{"Del":{"text":"\t\t\t\t\t\tlet params = [\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41075"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.name,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41100"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.URL,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41124"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.address,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41152"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.address2 ? parameters.address2 : null,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41210"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.city,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41235"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.region,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41262"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.country,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41290"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.postal_code,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41322"}},{"Del":{"text":"\t\t\t\t\t\t\tBoolean(parameters.delivery),\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41360"}},{"Del":{"text":"\t\t\t\t\t\t\tBoolean(parameters.pickup),\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41396"}},{"Del":{"text":"\t\t\t\t\t\t\tBoolean(parameters.prepayment),\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41436"}},{"Del":{"text":"\t\t\t\t\t\t\tparameters.phone ? parameters.phone : null\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41487"}},{"Del":{"text":"\t\t\t\t\t\t];\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41497"}},{"Del":{"text":"\t\t\t\t\t\t//I went through the effort of delaying gapi as long as I could and folding three inserts into one transaction, only for the unique constraint to goof me up. Likely won't happen often though, so accept the tradeoff.\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41720"}},{"Del":{"text":"\t\t\t\t\t\tlet q = 1;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41738"}},{"Del":{"text":"\t\t\t\t\t\tlet query = '';\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41761"}},{"Del":{"text":"\t\t\t\t\t\tif(Array.isArray(parameters.taxes) && parameters.taxes.length) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41833"}},{"Del":{"text":"\t\t\t\t\t\t\tquery += `, insert${++q} as (\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41871"}},{"Del":{"text":"\t\t\t\t\t\t\t\tinsert into store_tax (store_id, name, rate, types)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:41932"}},{"Del":{"text":"\t\t\t\t\t\t\t\tvalues ${parameters.taxes.map(tax => `((select store_id from insert1), $${params.push(tax.name)}, $${params.push(tax.rate)}, $${params.push(tax.types)})`).join(', ')}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42108"}},{"Del":{"text":"\t\t\t\t\t\t\t)`;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42120"}}]}},{"Replacement":{"inode":{"change":28,"pos":590},"path":"server.js","line":821,"ins":{"up_context":[{"change":5,"pos":42130}],"down_context":[{"change":5,"pos":43153}],"flag":"BLOCK","start":7120,"end":8008,"inode":{"change":28,"pos":590}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":42130},"to":{"change":5,"start":42130,"end":42950},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":42950},"to":{"change":5,"start":5866,"end":5905},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5866},"to":{"change":5,"start":5866,"end":5905},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5905},"to":{"change":5,"start":42951,"end":43152},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":43152},"to":{"change":5,"start":6100,"end":6123},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":6616},"to":{"change":5,"start":6100,"end":6123},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":6100},"to":{"change":5,"start":6100,"end":6123},"introduced_by":5}],"inode":{"change":28,"pos":590}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\tws.send(JSON.stringify({\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7151"}},{"Add":{"text":"\t\t\t\t\t\t\tresponse_ID: request_ID,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7184"}},{"Add":{"text":"\t\t\t\t\t\t\tdata: 'geocode failure'\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7216"}},{"Add":{"text":"\t\t\t\t\t\t}));\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7228"}},{"Add":{"text":"\t\t\t\t\t\tbreak;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7242"}},{"Add":{"text":"\t\t\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7250"}},{"Add":{"text":"\t\t\t\t\tlet fuck = [];\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7271"}},{"Add":{"text":"\t\t\t\t\tif(Array.isArray(parameters.times)) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7315"}},{"Add":{"text":"\t\t\t\t\t\tfor(let i = 0; i < parameters.times.length; ++i) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7373"}},{"Add":{"text":"\t\t\t\t\t\t\ttry {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7387"}},{"Add":{"text":"\t\t\t\t\t\t\t\tlet ts = parameters.times[i].time_start.split(':');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7448"}},{"Add":{"text":"\t\t\t\t\t\t\t\tts = Number(parameters.times[i].day_start) * 1440 + Number(ts[0]) * 60 + Number(ts[1]);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7545"}},{"Add":{"text":"\t\t\t\t\t\t\t\tlet te = parameters.times[i].time_end.split(':');\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7604"}},{"Add":{"text":"\t\t\t\t\t\t\t\tte = Number(parameters.times[i].day_end) * 1440 + Number(te[0]) * 60 + Number(te[1]);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7699"}},{"Add":{"text":"\t\t\t\t\t\t\t\tif(ts < 0 || ts >= 10080 || te < 0 || te >= 10080) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7761"}},{"Add":{"text":"\t\t\t\t\t\t\t\t\tcontinue;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7781"}},{"Add":{"text":"\t\t\t\t\t\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7792"}},{"Add":{"text":"\t\t\t\t\t\t\t\tif(te <= ts) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7816"}},{"Add":{"text":"\t\t\t\t\t\t\t\t\tfuck.push([ts, 10080], [0, te]);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7859"}},{"Add":{"text":"\t\t\t\t\t\t\t\t\t//oops possibly 0,0 empty range. nvm good job range_agg\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7925"}},{"Add":{"text":"\t\t\t\t\t\t\t\t} else {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7943"}},{"Add":{"text":"\t\t\t\t\t\t\t\t\tfuck.push([ts, te]);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7974"}},{"Add":{"text":"\t\t\t\t\t\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:7985"}},{"Add":{"text":"\t\t\t\t\t\t\t} catch(e) {}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8007"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\tif(Array.isArray(parameters.times)) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42174"}},{"Del":{"text":"\t\t\t\t\t\t\tlet fuck = [];\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42197"}},{"Del":{"text":"\t\t\t\t\t\t\tfor(let i = 0; i < parameters.times.length; ++i) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42256"}},{"Del":{"text":"\t\t\t\t\t\t\t\ttry {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42271"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tlet ts = parameters.times[i].time_start.split(':');\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42333"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tts = Number(parameters.times[i].day_start) * 1440 + Number(ts[0]) * 60 + Number(ts[1]);\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42431"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tlet te = parameters.times[i].time_end.split(':');\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42491"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tte = Number(parameters.times[i].day_end) * 1440 + Number(te[0]) * 60 + Number(te[1]);\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42587"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tif(te <= ts) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42612"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t\tfuck.push(`(int4range($${params.push(ts)}, 10080)),(int4range(0, $${params.push(te)}))`);\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42713"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t\t//oops possibly 0,0 empty range. nvm good job range_agg\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42780"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t} else {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42799"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t\tfuck.push(`(int4range($${params.push(ts)}, $${params.push(te)}))`);\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42878"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42890"}},{"Del":{"text":"\t\t\t\t\t\t\t\t} catch(e) {}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42913"}},{"Del":{"text":"\t\t\t\t\t\t\t}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42923"}},{"Del":{"text":"\t\t\t\t\t\t\tif(fuck.length) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:42949"}},{"Del":{"text":"\t\t\t\t\t\t\t\tquery += `, insert${++q} as (\r","pos":"2ZHTBPOJQI4FS3OQJXUDBD62HVFPGSKI633IXXKAGPGQLURMKVPAC:5904"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tinsert into store_time (store_id, open)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43000"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tselect store_id, unnest from insert1 cross join (select unnest(range_agg(column1, true, true)) from (values ${fuck.join(',')}) as ex) as idc\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43151"}},{"Del":{"text":"\t\t\t\t\t\t\t\t)`;\r","pos":"2ZHTBPOJQI4FS3OQJXUDBD62HVFPGSKI633IXXKAGPGQLURMKVPAC:6112"}},{"Del":{"text":"\t\t\t\t\t\t\t}\r","pos":"2ZHTBPOJQI4FS3OQJXUDBD62HVFPGSKI633IXXKAGPGQLURMKVPAC:6122"}}]}},{"Replacement":{"inode":{"change":28,"pos":590},"path":"server.js","line":846,"ins":{"up_context":[{"change":5,"pos":43162}],"down_context":[{"change":5,"pos":43801}],"flag":"BLOCK","start":8009,"end":11526,"inode":{"change":28,"pos":590}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":43162},"to":{"change":5,"start":43162,"end":43801},"introduced_by":5}],"inode":{"change":28,"pos":590}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8016"}},{"Add":{"text":"\t\t\t\t\tlet jn = sanitize_name(parameters.name)\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8062"}},{"Add":{"text":"\t\t\t\t\tlet params = [\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8083"}},{"Add":{"text":"\t\t\t\t\t\tjn,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8094"}},{"Add":{"text":"\t\t\t\t\t\tjn,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8105"}},{"Add":{"text":"\t\t\t\t\t\tparameters.URL,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8128"}},{"Add":{"text":"\t\t\t\t\t\taddr.address,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8149"}},{"Add":{"text":"\t\t\t\t\t\taddr.address2,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8171"}},{"Add":{"text":"\t\t\t\t\t\taddr.city,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8189"}},{"Add":{"text":"\t\t\t\t\t\taddr.region,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8209"}},{"Add":{"text":"\t\t\t\t\t\taddr.country,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8230"}},{"Add":{"text":"\t\t\t\t\t\taddr.postal_code,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8255"}},{"Add":{"text":"\t\t\t\t\t\tlocation.lng,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8276"}},{"Add":{"text":"\t\t\t\t\t\tlocation.lat,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8297"}},{"Add":{"text":"\t\t\t\t\t\tfoot,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8310"}},{"Add":{"text":"\t\t\t\t\t\tcar,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8322"}},{"Add":{"text":"\t\t\t\t\t\ttz,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8333"}},{"Add":{"text":"\t\t\t\t\t\tparameters.phone ? parameters.phone : null,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8384"}},{"Add":{"text":"\t\t\t\t\t\tparameters.phone && parameters.extension ? parameters.extension : null,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8463"}},{"Add":{"text":"\t\t\t\t\t\tBoolean(parameters.delivery),\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8500"}},{"Add":{"text":"\t\t\t\t\t\tBoolean(parameters.pickup),\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8535"}},{"Add":{"text":"\t\t\t\t\t\tBoolean(parameters.prepayment),\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8574"}},{"Add":{"text":"\t\t\t\t\t\tJSON.stringify(fuck)\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8602"}},{"Add":{"text":"\t\t\t\t\t];\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8611"}},{"Add":{"text":"\t\t\t\t\tlet q = 1;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8628"}},{"Add":{"text":"\t\t\t\t\tlet query = '';\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8650"}},{"Add":{"text":"\t\t\t\t\tif(Array.isArray(parameters.taxes) && parameters.taxes.length) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8721"}},{"Add":{"text":"\t\t\t\t\t\tquery += `, insert${++q} as (\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8758"}},{"Add":{"text":"\t\t\t\t\t\t\tinsert into store_tax (store_id, name, rate, types)\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8818"}},{"Add":{"text":"\t\t\t\t\t\t\tvalues ${parameters.taxes.map(tax => `((select store_id from insert1), $${params.push(tax.name)}, $${params.push(tax.rate)}, $${params.push(tax.types)})`).join(', ')}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:8993"}},{"Add":{"text":"\t\t\t\t\t\t)`;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9004"}},{"Add":{"text":"\t\t\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9012"}},{"Add":{"text":"\t\t\t\t\tif(Array.isArray(parameters.images) && parameters.images.length) {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9085"}},{"Add":{"text":"\t\t\t\t\t\tquery += `, insert${++q} as (\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9122"}},{"Add":{"text":"\t\t\t\t\t\t\tinsert into store_image (store_id, URL)\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9170"}},{"Add":{"text":"\t\t\t\t\t\t\tvalues ${parameters.images.map(image => `((select store_id from insert1), $${params.push(image)})`).join(', ')}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9290"}},{"Add":{"text":"\t\t\t\t\t\t)`;\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9301"}},{"Add":{"text":"\t\t\t\t\t}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9309"}},{"Add":{"text":"\t\t\t\t\tpool.query(\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9327"}},{"Add":{"text":"\t\t\t\t\t\t`with insert1 as (\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9353"}},{"Add":{"text":"\t\t\t\t\t\t\tinsert into store (\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9381"}},{"Add":{"text":"\t\t\t\t\t\t\t\tjoined_name,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9403"}},{"Add":{"text":"\t\t\t\t\t\t\t\tname,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9418"}},{"Add":{"text":"\t\t\t\t\t\t\t\turl,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9432"}},{"Add":{"text":"\t\t\t\t\t\t\t\taddress,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9450"}},{"Add":{"text":"\t\t\t\t\t\t\t\taddress2,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9469"}},{"Add":{"text":"\t\t\t\t\t\t\t\tcity,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9484"}},{"Add":{"text":"\t\t\t\t\t\t\t\tregion,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9501"}},{"Add":{"text":"\t\t\t\t\t\t\t\tcountry,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9519"}},{"Add":{"text":"\t\t\t\t\t\t\t\tpostal_code,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9541"}},{"Add":{"text":"\t\t\t\t\t\t\t\tlongitude,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9561"}},{"Add":{"text":"\t\t\t\t\t\t\t\tlatitude,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9580"}},{"Add":{"text":"\t\t\t\t\t\t\t\tosrm_hint_foot,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9605"}},{"Add":{"text":"\t\t\t\t\t\t\t\tosrm_hint_car,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9629"}},{"Add":{"text":"\t\t\t\t\t\t\t\ttimezone,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9648"}},{"Add":{"text":"\t\t\t\t\t\t\t\tphone,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9664"}},{"Add":{"text":"\t\t\t\t\t\t\t\textension,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9684"}},{"Add":{"text":"\t\t\t\t\t\t\t\tdelivery,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9703"}},{"Add":{"text":"\t\t\t\t\t\t\t\tpickup,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9720"}},{"Add":{"text":"\t\t\t\t\t\t\t\tprepayment,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9741"}},{"Add":{"text":"\t\t\t\t\t\t\t\topen\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9755"}},{"Add":{"text":"\t\t\t\t\t\t\t) select\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9772"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$1,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9785"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$2,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9798"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$3,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9811"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$4,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9824"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$5,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9837"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$6,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9850"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$7,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9863"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$8,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9876"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$9,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9889"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$10,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9903"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$11,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9917"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$12,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9931"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$13,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9945"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$14,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9959"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$15,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9973"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$16,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:9987"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$17,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10001"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$18,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10015"}},{"Add":{"text":"\t\t\t\t\t\t\t\t$19,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10029"}},{"Add":{"text":"\t\t\t\t\t\t\t\t(select range_agg(int4range((x->>0)::int, (x->>1)::int), true, true) from json_array_elements($20) as t(x))\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10146"}},{"Add":{"text":"\t\t\t\t\t\t\treturning store_id\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10173"}},{"Add":{"text":"\t\t\t\t\t\t)${query}\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10190"}},{"Add":{"text":"\t\t\t\t\t\tselect * from get_stores((select store_id from insert1))`,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10256"}},{"Add":{"text":"\t\t\t\t\t\tparams\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10270"}},{"Add":{"text":"\t\t\t\t\t).then(r => {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10290"}},{"Add":{"text":"\t\t\t\t\t\tws.publish('store', JSON.stringify({\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10334"}},{"Add":{"text":"\t\t\t\t\t\t\twhat: 'store',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10357"}},{"Add":{"text":"\t\t\t\t\t\t\thow: 'add',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10377"}},{"Add":{"text":"\t\t\t\t\t\t\tdata: r.rows[0]\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10401"}},{"Add":{"text":"\t\t\t\t\t\t}));\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10413"}},{"Add":{"text":"\t\t\t\t\t\tws.send(JSON.stringify({\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10445"}},{"Add":{"text":"\t\t\t\t\t\t\tresponse_ID: request_ID\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10477"}},{"Add":{"text":"\t\t\t\t\t\t}));\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10489"}},{"Add":{"text":"\t\t\t\t\t}).catch(e => {\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10511"}},{"Add":{"text":"\t\t\t\t\t\t/* todo\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10526"}},{"Add":{"text":"\t\t\t\t\t\tClass 23 https://www.postgresql.org/docs/current/errcodes-appendix.html with e.code\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10617"}},{"Add":{"text":"\t\t\t\t\t\te.table\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10632"}},{"Add":{"text":"\t\t\t\t\t\thttps://stackoverflow.com/a/4108266\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10675"}},{"Add":{"text":"\t\t\t\t\t\tuse implicit names in initialize.sql. then, can use e.constraint, remove e.table + _ from beginning, remove suffix to see which columns are affected\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:10831"}},{"Add":{"text":"\t\t\t\t\t\te.detail is fine for 23505, but 23514 just complains about the row as a whole. how can we get the specific details? https://stackoverflow.com/a/47972916 for python...\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11005"}},{"Add":{"text":"\t\t\t\t\t\tuseful\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11019"}},{"Add":{"text":"\t\t\t\t\t\t code: '23505',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11043"}},{"Add":{"text":"\t\t\t\t\t\t detail: 'Key (store, name)=(21, hst) already exists.',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11107"}},{"Add":{"text":"\t\t\t\t\t\tuseless\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11122"}},{"Add":{"text":"\t\t\t\t\t\t [message]: 'new row for relation \"store_tax\" violates check constraint \"store_tax_rate_check\"',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11227"}},{"Add":{"text":"\t\t\t\t\t\t name: 'error',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11251"}},{"Add":{"text":"\t\t\t\t\t\t length: 266,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11273"}},{"Add":{"text":"\t\t\t\t\t\t severity: 'ERROR',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11301"}},{"Add":{"text":"\t\t\t\t\t\t code: '23514',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11325"}},{"Add":{"text":"\t\t\t\t\t\t detail: 'Failing row contains (15, 28, hst, 2, 2020-02-11 20:20:54.923496-05, infinity).',\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11425"}},{"Add":{"text":"\t\t\t\t\t\twhat I want: rate > 0 and rate < 1\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11467"}},{"Add":{"text":"\t\t\t\t\t\t2 > 0 and 2 < 1\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11490"}},{"Add":{"text":"\t\t\t\t\t\ttrue and false\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11512"}},{"Add":{"text":"\t\t\t\t\t\tfalse\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11525"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\tif(Array.isArray(parameters.images) && parameters.images.length) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43235"}},{"Del":{"text":"\t\t\t\t\t\t\tquery += `, insert${++q} as (\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43273"}},{"Del":{"text":"\t\t\t\t\t\t\t\tinsert into store_image (store_id, URL)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43322"}},{"Del":{"text":"\t\t\t\t\t\t\t\tvalues ${parameters.images.map(image => `((select store_id from insert1), $${params.push(image)})`).join(', ')}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43443"}},{"Del":{"text":"\t\t\t\t\t\t\t)`;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43455"}},{"Del":{"text":"\t\t\t\t\t\t}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43464"}},{"Del":{"text":"\t\t\t\t\t\t/*\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43474"}},{"Del":{"text":"\t\t\t\t\t\ttwo google maps api error handlers because their api is inconsistent as fuck\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43558"}},{"Del":{"text":"\t\t\t\t\t\tmissing api key will return 'REQUEST_DENIED', but 200, so (2)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43627"}},{"Del":{"text":"\t\t\t\t\t\twrong parameters will return 'INVALID_REQUEST', so 400 (1) for geocode\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43705"}},{"Del":{"text":"\t\t\t\t\t\tbut 200 (2) for timezone!! 400 throws automatically, but 200 need to be thrown manually\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43800"}}]}},{"Replacement":{"inode":{"change":28,"pos":590},"path":"server.js","line":963,"ins":{"up_context":[{"change":5,"pos":43811}],"down_context":[{"change":5,"pos":48004}],"flag":"BLOCK","start":11527,"end":11663,"inode":{"change":28,"pos":590}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":43811},"to":{"change":5,"start":43811,"end":44228},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":1230},"to":{"change":5,"start":7264,"end":7274},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":44228},"to":{"change":5,"start":7264,"end":7274},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":7264},"to":{"change":5,"start":7264,"end":7274},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":7274},"to":{"change":5,"start":44229,"end":44335},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":44335},"to":{"change":5,"start":7564,"end":7574},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":7564},"to":{"change":5,"start":7564,"end":7574},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":7574},"to":{"change":5,"start":44336,"end":44411},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":8736},"to":{"change":5,"start":5582,"end":5592},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":44411},"to":{"change":5,"start":5582,"end":5592},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5582},"to":{"change":5,"start":5582,"end":5592},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5592},"to":{"change":5,"start":44412,"end":45157},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":9342},"to":{"change":5,"start":5756,"end":5766},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":45157},"to":{"change":5,"start":5756,"end":5766},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5756},"to":{"change":5,"start":5756,"end":5766},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5766},"to":{"change":5,"start":45158,"end":45495},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":11131},"to":{"change":5,"start":5867,"end":5876},"introduced_by":5},{"previous":"","flag":"DELETED","from":{"change":5,"pos":45495},"to":{"change":5,"start":5867,"end":5876},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5867},"to":{"change":5,"start":5867,"end":5876},"introduced_by":5},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":5,"pos":5876},"to":{"change":5,"start":45496,"end":48004},"introduced_by":5}],"inode":{"change":28,"pos":590}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\tconsole.log(e);\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11549"}},{"Add":{"text":"\t\t\t\t\t\tws.send(JSON.stringify({\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11581"}},{"Add":{"text":"\t\t\t\t\t\t\tresponse_ID: request_ID,\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11614"}},{"Add":{"text":"\t\t\t\t\t\t\tdata: 'db fuckup'\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11640"}},{"Add":{"text":"\t\t\t\t\t\t}));\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11652"}},{"Add":{"text":"\t\t\t\t\t});\r","pos":"XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC:11662"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\tlet location;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43831"}},{"Del":{"text":"\t\t\t\t\t\ttry {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:43844"}},{"Del":{"text":"\t\t\t\t\t\t\tlocation = (await googleMapsClient.geocode({params: {address: `${parameters.address}, ${parameters.address2}, ${parameters.city}, ${parameters.region}, ${parameters.country}, ${parameters.postal_code}`, key: process.env.GAPI}})).data;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44087"}},{"Del":{"text":"\t\t\t\t\t\t\tif(location.status === 'OK') {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44126"}},{"Del":{"text":"\t\t\t\t\t\t\t\tlocation = location.results[0].geometry.location;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44185"}},{"Del":{"text":"\t\t\t\t\t\t\t} else {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44202"}},{"Del":{"text":"\t\t\t\t\t\t\t\tthrow location;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44227"}},{"Del":{"text":"\t\t\t\t\t\t\t}\r","pos":"2ZHTBPOJQI4FS3OQJXUDBD62HVFPGSKI633IXXKAGPGQLURMKVPAC:7273"}},{"Del":{"text":"\t\t\t\t\t\t} catch(e) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44248"}},{"Del":{"text":"\t\t\t\t\t\t\tif(e.response) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44273"}},{"Del":{"text":"\t\t\t\t\t\t\t\tconsole.error(e.response.data);//google maps api(1)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44334"}},{"Del":{"text":"\t\t\t\t\t\t\t}\r","pos":"2ZHTBPOJQI4FS3OQJXUDBD62HVFPGSKI633IXXKAGPGQLURMKVPAC:7573"}},{"Del":{"text":"\t\t\t\t\t\t\telse if(e.status) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44363"}},{"Del":{"text":"\t\t\t\t\t\t\t\tconsole.error(e);//google maps api(2)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44410"}},{"Del":{"text":"\t\t\t\t\t\t\t}\r","pos":"4WREYORZT3SWUXADWHSS6B4PQSP3QSLH77CGNKRH6IRKUMX4TARAC:5591"}},{"Del":{"text":"\t\t\t\t\t\t\tws.send(JSON.stringify({\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44444"}},{"Del":{"text":"\t\t\t\t\t\t\t\tresponse_ID: request_ID,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44478"}},{"Del":{"text":"\t\t\t\t\t\t\t\tdata: 'google geocode failure'\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44518"}},{"Del":{"text":"\t\t\t\t\t\t\t}));//todo: status: 'ZERO_RESULTS' => \"invalid address :(\"\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44585"}},{"Del":{"text":"\t\t\t\t\t\t\tbreak;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44600"}},{"Del":{"text":"\t\t\t\t\t\t}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44609"}},{"Del":{"text":"\t\t\t\t\t\tlet hints = Promise.all([\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44642"}},{"Del":{"text":"\t\t\t\t\t\t\trequest(`http://127.0.0.1:5000/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint),\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44775"}},{"Del":{"text":"\t\t\t\t\t\t\trequest(`http://127.0.0.1:5001/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44907"}},{"Del":{"text":"\t\t\t\t\t\t]);\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44918"}},{"Del":{"text":"\t\t\t\t\t\tlet tz;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44933"}},{"Del":{"text":"\t\t\t\t\t\ttry {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:44946"}},{"Del":{"text":"\t\t\t\t\t\t\ttz = (await googleMapsClient.timezone({params: {location, timestamp: 0, key: process.env.GAPI}})).data;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45058"}},{"Del":{"text":"\t\t\t\t\t\t\tif(tz.status === 'OK') {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45091"}},{"Del":{"text":"\t\t\t\t\t\t\t\ttz = tz.timeZoneId;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45120"}},{"Del":{"text":"\t\t\t\t\t\t\t} else {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45137"}},{"Del":{"text":"\t\t\t\t\t\t\t\tthrow tz;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45156"}},{"Del":{"text":"\t\t\t\t\t\t\t}\r","pos":"4WREYORZT3SWUXADWHSS6B4PQSP3QSLH77CGNKRH6IRKUMX4TARAC:5765"}},{"Del":{"text":"\t\t\t\t\t\t} catch(e) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45177"}},{"Del":{"text":"\t\t\t\t\t\t\tif(e.response) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45202"}},{"Del":{"text":"\t\t\t\t\t\t\t\tconsole.error(e.response.data);//google maps api(1)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45263"}},{"Del":{"text":"\t\t\t\t\t\t\t}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45273"}},{"Del":{"text":"\t\t\t\t\t\t\telse if(e.status) {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45301"}},{"Del":{"text":"\t\t\t\t\t\t\t\tconsole.error(e);//google maps api(2)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45348"}},{"Del":{"text":"\t\t\t\t\t\t\t}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45358"}},{"Del":{"text":"\t\t\t\t\t\t\tws.send(JSON.stringify({\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45391"}},{"Del":{"text":"\t\t\t\t\t\t\t\tresponse_ID: request_ID,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45425"}},{"Del":{"text":"\t\t\t\t\t\t\t\tdata: 'google timezone failure'\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45466"}},{"Del":{"text":"\t\t\t\t\t\t\t}));\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45479"}},{"Del":{"text":"\t\t\t\t\t\t\tbreak;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45494"}},{"Del":{"text":"\t\t\t\t\t\t}\r","pos":"4WREYORZT3SWUXADWHSS6B4PQSP3QSLH77CGNKRH6IRKUMX4TARAC:5875"}},{"Del":{"text":"\t\t\t\t\t\thints = await hints;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45523"}},{"Del":{"text":"\t\t\t\t\t\t//promise then catch is fine since this is the last thing to do this function. don't need to break;\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45630"}},{"Del":{"text":"\t\t\t\t\t\tpool.query(\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45649"}},{"Del":{"text":"\t\t\t\t\t\t\t`with insert1 as (\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45676"}},{"Del":{"text":"\t\t\t\t\t\t\t\tinsert into store (\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45705"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tname,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45721"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\turl,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45736"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\taddress,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45755"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\taddress2,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45775"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tcity,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45791"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tregion,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45809"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tcountry,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45828"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tpostal_code,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45851"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tdelivery,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45871"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tpickup,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45889"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tprepayment,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45911"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tphone,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45928"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tlongitude,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45949"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tlatitude,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45969"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tosrm_hint_foot,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:45995"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\tosrm_hint_car,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46020"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\ttimezone\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46039"}},{"Del":{"text":"\t\t\t\t\t\t\t\t) values (\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46059"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$1,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46073"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$2,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46087"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$3,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46101"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$4,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46115"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$5,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46129"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$6,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46143"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$7,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46157"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$8,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46171"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$9,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46185"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$10,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46200"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$11,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46215"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$12,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46230"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$${params.push(location.lng)},\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46271"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$${params.push(location.lat)},\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46312"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$${params.push(hints[0])},\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46349"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$${params.push(hints[1])},\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46386"}},{"Del":{"text":"\t\t\t\t\t\t\t\t\t$${params.push(tz)}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46416"}},{"Del":{"text":"\t\t\t\t\t\t\t\t)\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46427"}},{"Del":{"text":"\t\t\t\t\t\t\t\treturning store_id\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46455"}},{"Del":{"text":"\t\t\t\t\t\t\t)${query}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46473"}},{"Del":{"text":"\t\t\t\t\t\t\tselect * from get_stores((select store_id from insert1))`,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46540"}},{"Del":{"text":"\t\t\t\t\t\t\tparams\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46555"}},{"Del":{"text":"\t\t\t\t\t\t).then(r => {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46576"}},{"Del":{"text":"\t\t\t\t\t\t\tws.publish('store', JSON.stringify({\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46621"}},{"Del":{"text":"\t\t\t\t\t\t\t\twhat: 'store',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46645"}},{"Del":{"text":"\t\t\t\t\t\t\t\thow: 'add',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46666"}},{"Del":{"text":"\t\t\t\t\t\t\t\tdata: r.rows[0]\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46691"}},{"Del":{"text":"\t\t\t\t\t\t\t}));\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46704"}},{"Del":{"text":"\t\t\t\t\t\t\tws.send(JSON.stringify({\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46737"}},{"Del":{"text":"\t\t\t\t\t\t\t\tresponse_ID: request_ID\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46770"}},{"Del":{"text":"\t\t\t\t\t\t\t}));\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46783"}},{"Del":{"text":"\t\t\t\t\t\t}).catch(e => {\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46806"}},{"Del":{"text":"\t\t\t\t\t\t\t/* todo\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46822"}},{"Del":{"text":"\t\t\t\t\t\t\tClass 23 https://www.postgresql.org/docs/current/errcodes-appendix.html with e.code\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46914"}},{"Del":{"text":"\t\t\t\t\t\t\te.table\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46930"}},{"Del":{"text":"\t\t\t\t\t\t\thttps://stackoverflow.com/a/4108266\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:46974"}},{"Del":{"text":"\t\t\t\t\t\t\tuse implicit names in initialize.sql. then, can use e.constraint, remove e.table + _ from beginning, remove suffix to see which columns are affected\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47131"}},{"Del":{"text":"\t\t\t\t\t\t\te.detail is fine for 23505, but 23514 just complains about the row as a whole. how can we get the specific details? https://stackoverflow.com/a/47972916 for python...\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47306"}},{"Del":{"text":"\t\t\t\t\t\t\tuseful\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47321"}},{"Del":{"text":"\t\t\t\t\t\t\t code: '23505',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47346"}},{"Del":{"text":"\t\t\t\t\t\t\t detail: 'Key (store, name)=(21, hst) already exists.',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47411"}},{"Del":{"text":"\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47413"}},{"Del":{"text":"\t\t\t\t\t\t\tuseless\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47429"}},{"Del":{"text":"\t\t\t\t\t\t\t [message]: 'new row for relation \"store_tax\" violates check constraint \"store_tax_rate_check\"',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47535"}},{"Del":{"text":"\t\t\t\t\t\t\t name: 'error',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47560"}},{"Del":{"text":"\t\t\t\t\t\t\t length: 266,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47583"}},{"Del":{"text":"\t\t\t\t\t\t\t severity: 'ERROR',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47612"}},{"Del":{"text":"\t\t\t\t\t\t\t code: '23514',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47637"}},{"Del":{"text":"\t\t\t\t\t\t\t detail: 'Failing row contains (15, 28, hst, 2, 2020-02-11 20:20:54.923496-05, infinity).',\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47738"}},{"Del":{"text":"\t\t\t\t\t\t\twhat I want: rate > 0 and rate < 1\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47781"}},{"Del":{"text":"\t\t\t\t\t\t\t2 > 0 and 2 < 1\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47805"}},{"Del":{"text":"\t\t\t\t\t\t\ttrue and false\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47828"}},{"Del":{"text":"\t\t\t\t\t\t\tfalse\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47842"}},{"Del":{"text":"\t\t\t\t\t\t\t*/\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47853"}},{"Del":{"text":"\t\t\t\t\t\t\tconsole.log(e);\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47877"}},{"Del":{"text":"\t\t\t\t\t\t\tws.send(JSON.stringify({\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47910"}},{"Del":{"text":"\t\t\t\t\t\t\t\tresponse_ID: request_ID,\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47944"}},{"Del":{"text":"\t\t\t\t\t\t\t\tdata: 'db fuckup'\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47971"}},{"Del":{"text":"\t\t\t\t\t\t\t}));\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47984"}},{"Del":{"text":"\t\t\t\t\t\t});\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:47995"}},{"Del":{"text":"\t\t\t\t\t}\r","pos":"JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC:48003"}}]}}],"owner":"boogerlad","repo":"mj","token":"UoINI2Q6l66cvKgOsQRnd97hKAnSuD1PDOWChl5COvA=","login":null}

…

Dependencies

Change contents

Review