The Nest
Explore
0
typo
Created by  boogerlad  on December 16, 2020
FFK6NMBEFKKR5MV3HO7V3XVKK5WXKUW4WTO4XZJTUMHP5ARDD5IQC
pnpm
Created by  boogerlad  on December 16, 2020
CEKQYVIO7VHFWTOFSCSPWB523S66TQ4QGZMEQFINIVMOHNITXHMAC
don't need /
Created by  boogerlad  on December 16, 2020
26JXN2RF5GSDVMVKT6KR2JMGSDGSN6LHI3RJWCQW4P6F5V6WWTCAC
frontend
Created by  boogerlad  on December 16, 2020
SK7NYDH7U526K2MATUOA3BSQMANYSZLGMBUUDVLG37XJJ3YIEE7QC
todo and comment re: price history
Created by  boogerlad  on December 16, 2020
4XIO43KQHW4K2UDUX52TM3U5KR3CK42MA2V5Z6ZBQHCJUQPZO4QAC
.ignore should be in root
Created by  boogerlad  on December 16, 2020
AF6VCAQZN7TPLP7TE7CTUUV6B4NV3OWGYE3Q2H7ZQ2WKLSDNJBZQC
apparently misunderstood what pigul remove does. rm works fine. still pijul git shouldnt have imported this file
Created by  boogerlad  on December 16, 2020
UDIBKULRPNWBJTKBJ4R6B4S65K2XUF6QUKBNCJOZPX6XWAKT2QOQC
pijul bug, can edit file but can't remove
Created by  boogerlad  on December 16, 2020
NVU4HKPUWNGHYFSXCNGGV6BX6K4AP7C25U7NTTG4W2RNOYT7GBOQC
move to pijul, monorepo
Created by  boogerlad  on December 16, 2020
WGE7FMGRBT4AVRXKKJ4LZWQGTD6QL2INWXSBCQOMEP2Z7R33TA2QC
newly registered user is logged in
Created by  boogerlad  on December 15, 2020
VR3F4DHVLL7ZRXFQNR2245D7V5GHZ6V7MIL4ZC27O2LJ7622JM7QC
fix remember me due to typo
Created by  boogerlad  on December 15, 2020
W2OWXGNK7XO5KWNCS6MJX6R77LW7Y6JI2G5CBAHT4PN4GOC4WR5AC
who logged in / signed out event
Created by  boogerlad  on December 14, 2020
C7R375ELQMSUTNZW42IWBN7GOMU57SSBAS7VFRA7LI57D7U7BFZQC
+- instead of actual values since initial value is sent on subscribe. not sure if this is "better"
Created by  boogerlad  on December 14, 2020
A4HLZ3RSXBECKCLTHPLPXUUL33GY74MH2CMMNRM2NK5NFJLR6UBQC
send initial values for count and authenticated. previously, needed to wait for event
Created by  boogerlad  on December 14, 2020
7CPQVPRYILSXGTEHQWUCVNSUNWX7M5SZOQW2HDC7SU3QLSKNJ2YAC
variable name already in use. really should refactor gigantic switch statement...
Created by  boogerlad  on November 26, 2020
I2YRQJLSS4PVF77V2IB3ZZP54FNTLUQJE3FTB5GPNU4L2JCH66KQC
ocs continues to surprise with stupid non ascii in url
Created by  boogerlad  on November 26, 2020
EALAUEWMX2GWUZLZ664KDEX47CR6T5RNZJODPZDFX4ZZEG2HIKKAC
oops
Created by  boogerlad  on November 26, 2020
6ECWDY3RFVJIDJ335BWXNB7G3X7H27V6JK75WHJO33GBS2CORT2QC
update dependencies
Created by  boogerlad  on November 26, 2020
UA6FUQRQUU3NCWZ24GDWCF5VRD4F6ATYSJKPVMUVGE2JOYG7WSEQC
fuck roz
Created by  boogerlad  on November 25, 2020
Y5J5F72VRDZQYJJPD4UPS4I4VHWBXN22FATHE5EZNN5Q7Q4NBLUAC
don't attempt to insert into db if stock < 0
Created by  boogerlad  on September 28, 2020
LFTHO4ISUTY4UCBHBZTFWO73EEXQUZIMIBMGWYOU5NEW2VXJD4YQC
join_name and name mix up oops
Created by  boogerlad  on September 28, 2020
CSZD6XINVOSPH5N2E66H7LITXK53CTGKFPLUEDA3S3ZEN2VOLGPAC
fill in the alberta cannabis stub
Created by  boogerlad  on September 28, 2020
KW6P3EDCU2KVV3KAGBL2WZ72367NOLLJC42WDBP53XQ3WNH63OBQC
puppeteer can complain about zero width screenshots
Created by  boogerlad  on September 29, 2020
6J7T3WGAFRA54WV4Z3IU4V2KUGXTMRKGE5673HF573LCDHTI4F7AC
oops forgot to encrypt cart_id for authenticated
Created by  boogerlad  on September 23, 2020
H2SZHZTNZTB5ZVWSHUA3UASEDSIQ67UBHAYW33NP7KNPYMZUOXRAC
base58(FF1 encrypted(sequential integer cart id)) ^ ^ frontend database anonymous reservation(status can be checked with the 'reservation' endpoint by anyone, unless it has been 'claim'ed by someone logged in) relax constraints to allow multiple (placed or ready) reservations per store for each user modifycart deal only with partnered stores + cleanup(on race condition / conflict, just fail instead of trying to have custom error message(which is now out of date)) return only relevant taxes given the product types in the cart mergecart and login cleanup use bluebird so that on promise rejection, line number is printed combine 'user_cancel_reservation' and 'reserve' into 'user_update_reservation' cleanup 'store_update_reservation'
Created by  boogerlad  on September 23, 2020
AMKB7ZH5QDLTGTGJ63BXZKPVYZN7VWUDBRTOBJ2ZE4TS5QOWCGUQC
actually fix the order of join_name and name
Created by  boogerlad  on September 2, 2020
WXBWPWVX3WBPXP2QRUXSYNKNNAXO6QITKEE5JNYJCU6VQWFFPQ6QC
Revert "mixed up join_name and display_name oops" This reverts commit 933cbfefbab79a424d1901233fd82624863f3d3c.
Created by  boogerlad  on September 2, 2020
5RPACEZ43EAONV7XXUYFVMANDGJNAD7GQ3N7ESYITZI5UM7PGOVAC
fuck
Created by  boogerlad  on September 2, 2020
GCUNCRERAZAWTZ6D7FZYI4SRT5B7ZW5DI25PE25NEP4WZ55ZFYVAC
Change incorrect strain types for select products
Created by  David Ramsaran  on June 20, 2020
YNCCENQM2WU6OBTWDLWWEEQIHANLGXTI4DKZ3OJAROWPWNKVUVUAC
to compute taxes client side, what types of product the tax applies to is required
Created by  boogerlad  on September 2, 2020
U7BZVX5VS4IIY7CH6HFIYXK7UQBYYUN5VYVO45LVESF2PMW7A5VAC
fix bug where (user || store)_cancelled event would erroneously always appear due to node-postgres not converting postgres infinity to js number infinity. Instead, it's converted to the string 'infinity'
Created by  boogerlad  on September 1, 2020
376FAPWKGZ4NT47ODONG6VIVEISEKNRHI6AC5AFS4VRJDYQHPEFQC
fix constraint: anonymous cart can only be active, but carts associated to a user can be any state
Created by  boogerlad  on September 1, 2020
O6OZUOIH5U2SE3FS4ZUHM755FNYXEDXSRXREAEFZ36VNII4CPRJAC
change default database name
Created by  boogerlad  on September 1, 2020
OOJIMOOI3HGQK53CGYMWBTJC35MBYA4SSEV2DCCCLIRCDPHLSNWQC
mixed up join_name and display_name oops
Created by  boogerlad  on August 31, 2020
XLH7ZHUY4ZZWH43V2OIFXSHVK7LSUFO2NPYS2OML2LDDWQVK7JSAC
bccannabisstores scraper. needs to be cleaned up and tested further
Created by  boogerlad  on August 27, 2020
ND2EUAENR3TOEUMKLDAVAWAEW2XEIOHK4S4B2X6SIWFOOIAGZIEQC
the store table has addresses parsed by google. for the unique constraint to work on insert, parsed addresses are required. the store scraper naively attempts to insert every store. this works, but is expensive(~10usd). introduce store_temp table which contains the raw addresses from the previous scrape to insert only new stores and show removed stores. should probably truncate store_temp once a month to update longitude, latitude and open times
Created by  boogerlad  on August 24, 2020
XMKLB6DI3SLWQ6DKAAL47VNZQGER5NRJKCPLMVZO4PYHGM3NQJAQC
details re automatic backup
Created by  yoajay  on August 24, 2020
AT3FNCTHLBL4N4AFEESCKU7ZO4JOMGODP2MAHWI2JTO3KPJXPSWQC
update readme dependencies due to use of nullish coalesing operator and optional chaining
Created by  boogerlad  on August 24, 2020
X3PVMJ2LCWFE2GQ3MABPPH7HRSAWF6R2DT6WQ5I6Q4IXQ5NLKL3QC
buildfix and fix potential runtime error in ios_product_id where species is defined twice
Created by  boogerlad  on August 23, 2020
VKFRSWSYYX7JNFGTWLWYTIALQJTOWKEDUISIJY4VLYOHHAE3EWCAC
"blend" is not a species. It is a boolean. If strain is known, use that species instead. Does not make sense to have two species fields, so new conditional null constraint Relax menu_item check constraint for potential division by zero in thc2tc
Created by  boogerlad  on August 22, 2020
5CESNJJQPZDHWDKA2C46FZO5VYDDHTC2ENZS6ZSIZM767IQPZ52AC
instructions for range_agg postgres extension
Created by  yoajay  on August 19, 2020
THN4FNGXV7M5WVT6XF2QSMCUBNSMKYVRRTJ3NFPYDNZRRMLTFRLQC
oops. thanks e2e
Created by  boogerlad  on August 20, 2020
EAYCOESFDIPTAXN22QYTAFGISP6GFBGPGBX4WILGYJH7D3FK3TEAC
while auto logouts are annoying, it's important to let user know the connection is closed explicitly as soon as possible instead of on their next action in that session for security reasons. "oh shit someone else must have my credentials since I didn't initiate it!" or "I've left that session unattended and now whoever is snooping by can see whatever I was seeing at that time". Sadly on frontend they'll lose whatever state they were using but its not like they're typing a document right...?
Created by  boogerlad  on August 16, 2020
HVE3ANDORAJ5EX3I3GMSWT3INIKS6QRWPWGA6V6WY3NRCGVRFSRAC
fix updating product_image dimensions. counted parameters incorrectly :( if it's time to update the images on cloudinary, the images on cloudinary should be updated if it does exist(200) or created if does not exist(404)
Created by  boogerlad  on August 13, 2020
OHHBNG6ZBEKY7P4O77X4WDCJQXRVQ2OQBJQWEESPKCTMQBSMDMYAC
oops
Created by  boogerlad  on August 10, 2020
4VMZHHOOTDVK4RLXZ32VLLAA5SCL424MOVBPN7F6RT63A7YOTRVAC
constraint for store times to be minutes within a week store_open_exception table for things like holidays commonize store name sanitization and geocoding/timezone/osrm hints rebrand summit cannabis dc properly update create_store to work with commonized functions, new times table remove duplicated `require`s
Created by  boogerlad  on August 10, 2020
XBHLXAKNBJNWSXZMHVKDMDVI7CUF5MN22FFS3XQIOLFDJHDCLTVAC
Update Summit script to fetch new Dawson Creek store (brand change)
Created by  David Ramsaran  on August 5, 2020
QFATAUXF3SMSTZULKPCK4W3AZ4NEO3VFZE7SWIBDBXGC7JU5L6TAC
replace blake2 with blake3. I think node being a wrapper around openSSL makes it slow. 481,000ops/s vs 1,970,000ops/s decrease token length and hash length to 128bits(argon2 waiting for pr to land: https://github.com/ranisalt/node-argon2/pull/266) https://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." https://crypto.stackexchange.com/a/29618 "if you had random binary tokens, a token longer than [hash function digest length]bits would be useless." hex encode instead of base64 there exists a timing attack via dictionary reduction on hash prefix discovery therefore, 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. https://github.com/codahale/bcrypt-ruby/pull/43#issuecomment-15797932 https://github.com/aj-code/TimingIntrusionTool5000/blob/master/TimingAttackPresentation2012.pdf slide 21 https://crypto.stackexchange.com/questions/25607 https://security.stackexchange.com/questions/9192 https://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."
Created by  boogerlad  on July 30, 2020
RAN5QU4U2OVNLDGZVVTJNCXDN5GNAVPXGKHADZO2ML3Y5KLU4QPQC
make `register` conform to response/request model. `data: token.toString('base64')` would imply error. put in a object to imply success
Created by  boogerlad  on July 22, 2020
P7WD6WSAMHM2UEDTWZW4WPHIFKJHOEELCHSBJ7YB5D57C7YEOVFQC
fix login_otp. postgres group by column inference doesn't work since cte doesn't have original table's primary key https://stackoverflow.com/a/50606823/ https://dba.stackexchange.com/a/195105
Created by  boogerlad  on July 22, 2020
X3DVBHKNONHWE7NRRQ6FXXA6GRJ3P4NHROO547IEGSBJAA5CM5UAC
colon is unnecessary to truncate file
Created by  boogerlad  on July 22, 2020
SHFBK6NF35A232HV7O46EPU5P73IUEAXQ4GGDUE34EANKTGISALAC
there's a difference between null "open"(unknown) and empty array "open"(never open) get rid of idk trigger since constraint has been relaxed and doesn't really save any code and not worth performance hit
Created by  boogerlad  on July 22, 2020
NHVZFKZDPQGCZ6UOVQU5U3Q3SOAKGOGZNFIE7C6IB6YP3ZS4VVDAC
store scraper canada wide joined_name and name for stores. name is intended to be editable, while joined_name is used as the unique key / what the scraper outputs constraints for longitude latitude phone number extension field denormalize store times since updating an individual entry doesn't make sense. need to consider all store times to prevent overlap get rid of upi_store_6 in favor of empty string for address2 instead of null since upsert can only have one conflict target fix 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
Created by  boogerlad  on July 22, 2020
PMEQGKI5R3WTMDKH4B2PN67XDRMYZFULPKPSDTOGF5BPDGYNO2KQC
oops. update event for user acl needs key
Created by  boogerlad  on July 7, 2020
O33HFPFV4JJLC3MDGZRQ4OE6XTMG22YH75CVILMWV35YPI7MQE5QC
cloudinary will cry if CLOUDINARY_URL does not start with 'cloudinary://', so replace 'fake' with a dummy.
Created by  boogerlad  on July 6, 2020
UEM2RPSZTVWBR22Q76RY3ZN6YKUAL4MTSNRC56CGPVBNRSHMTZSQC
round price per gram to two decimal places. text prevents json fuckups
Created by  boogerlad  on July 6, 2020
PYMF3UUYKEDPFQGAJVMHHIM4YDYGC5XRIXWVUB63T5JW4MGVKGDAC
constraint: anonymous cart can only be active
Created by  boogerlad  on July 6, 2020
LUE57OK3OFZYP7GW4FL6SBV2MCBBEKQ2OFGKZSZ77AOBI6OKGDYQC
when stock less than zero, change to zero for ocs scrape
Created by  boogerlad  on July 6, 2020
TY6NASIOI6HMCD5WRABI36ZWGZDHU4WIFFBHHHIKNLQAUDJ7FVGAC
update dependencies deduplicate imports and stop reading the wrong .env don't upgrade the connection to a websocket if wrong origin switch from user type enum to god boolean + acl. this way, a user can be a(n) worker / owner of multiple stores don't bother caching the user type in ws anymore. always get the truth from database skip stock check if just changing cart's user implement otp login on connection as fallback to remember me token on connection login event instead of firth return minimum number of fields from user on unauthorized due to not >= store (owner || worker), update user acl event only publish number of authenticated / connected on change register logs in as well merge 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) end connection on logout and old connection if exists if login elsewhere taxes for types (bc 20% vapes) + include tax in price when viewing products stock level now takes into account # of reserved trigger for stock decrement on ready -> paid min / max quantity filter for products when user / store deleted and last status of cart is 'placed' or 'ready', add fake final store / user cancelled event if god, created product will be visible for menu_item_loader. if store owner, not visible so that lobo can review implement roles so that a store owner / worker can only access their stores defined by the acl for menu items, reservations implement god see users' reservations and cancel implement the rest of the reservation flow notifications (store status update, user cancel) implement store add event sadly, 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
Created by  boogerlad  on July 6, 2020
JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC
note
Created by  boogerlad  on June 23, 2020
BXGNP4GARIQA5LT3AN2F22HHGJHLUOL3YKBWWJ6LQQKUWLPYB7OAC
"update profile" endpoint. so far just email and password, but trivial to add more fields. admin edit user not done yet allow login via magic link
Created by  boogerlad  on June 23, 2020
7XVW32MMBBIGWQZ3QRD365TBIJU4DYN6T4VO2E46WFDCFHGO2BMAC
relax filters for womyn and age
Created by  boogerlad  on June 22, 2020
5DG6KB27COILJJLJCUYQUJZHLW6IOARHCGKAAD6YFYC6OWRVWXKQC
age & sex
Created by  boogerlad  on June 19, 2020
RAUIRF46MUMMASOW444FBI3VZC24HIJUPRQA7LT4E3HMQI3HDDGAC
return an array of length 7 for store times instead of object with keys as days. also fix monday 8pm to monday 12pm case over sunday midnight boundary mistakenly being bounded to sunday instead of the day of the beginning of the range that ends at the boundary
Created by  boogerlad  on June 9, 2020
SUT4U63YUU3T5KTJP3SQW73VODBN6L67356ULGKMCAHR6OH3LIFQC
oops
Created by  boogerlad  on June 8, 2020
52U5IXSQECUL4VET7VOW4DBAHKM3EWZAAIMQK2PY7XSWEA55QMJAC
buildfix
Created by  boogerlad  on June 8, 2020
VRBT2IMFSXBOI6BBX3TOZEK4R3L7SU6VEZ75ENAEGGM7DXNUVB2AC
group store times by weekday, with special case of sunday evening to monday
Created by  boogerlad  on June 8, 2020
T4XGM2U2W7W3SM424W6JNEIJWOJQ5ILZWU45JPZUKTZMK77ZARKQC
since client side stores, don't need to return name for active carts(anonymous, authenticated). do need to return for user_reservations though, since temporal (as_of)
Created by  boogerlad  on June 8, 2020
2Y4DI4H5EZOGS2ZUL7SXQHYUYFWWJOJPRAF4MI2RFI6YCLAJVFJAC
don't show formatted address string for stores like ocs, bccannabis, etc to be linked to google maps. need to show something if name is not obvious enough to show region (province / state) and country... future problem though
Created by  boogerlad  on June 7, 2020
THLWHHEQ2F5SFTHE4FE2PVSYNYRLP7QN6J3O6S3RXQX3KZYYWVYAC
oops forgot to remove endpoint after 1ff92aa99443b7f00c423a3f280fe7e2741f3d4b
Created by  boogerlad  on June 7, 2020
CD3LB4V4JMJH26X2PL2FTM2ETTYDVL3QC2E5N3O4U4JDDWIJZPIQC
automatically merge adjacent and overlapping ranges for store times instead of erroring out on exclude constraint thanks to range_agg also 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 consider sunday 5pm to monday 12am or 2am 6 * 24 * 60 + 17 * 60 = 9660 to 0 or 120 should be valid! also remove first_last_agg polyfill. if you can't install extensions, you're fucked anyways
Created by  boogerlad  on June 7, 2020
CMOE5TZ3HY6BG6KB56HMIJ6BU5J6D3NE7VFK2NSAX2XEXAPEKJQQC
send stores on connection. will be needed most of the time anyways. since not request response model anymore, it's an event. buuut it doesn't fit into add / remove / update, so introduce replace
Created by  boogerlad  on June 7, 2020
TZJ5KFZ6XNQJFNDDMYGPURKC7JIC4E3DDB64T7D6PPC6YQRIJ6SQC
typo
Created by  boogerlad  on June 7, 2020
BZUGIKIQSVUH7WZF4MQMPGP5E6WLTCRARMEG3HOT644W5BKOW7IQC
documentation: the two osrm services can't be bound to the same port...
Created by  boogerlad  on June 7, 2020
AFM7YF55TQPZS6MTNJALHSWX4IRXBEDCXHV7HTRQXKE6SPSOXBAAC
ocs can go kill themselves
Created by  boogerlad  on June 7, 2020
5NR7QBMVZ3NT3LRUTJDSRJVWC7A5UPVUK723N4MDPTHCWBEZWU7AC
fuck it client side stores since shimple enough
Created by  boogerlad  on June 4, 2020
NBNPI4ATCXHIMKSXW5VRS3KM4WJZZMOPD7H4QTDNOQFRSQYFSIBAC
store creation new fields, osrm_hints, store distance. Still undecided as to what to return for "stores" though...
Created by  boogerlad  on June 4, 2020
Z7XOXXDJ7T6E4ZCP2AK5YSXWE6TCDCLZEXAZPZZVLOY4WCFVZPHAC
more robust notmissing function. allows false as a valid value
Created by  boogerlad  on June 4, 2020
WY7P255VIAXUFUCYAE6INQHZLHHJYUUNWAWVTO2S6YIAWZBUERWQC
lift stores dump and summit greenline
Created by  boogerlad  on June 4, 2020
Y6DVC22CQACFO75XTUE4BZQXCVJAYOECY2F7M2IYV7AWFGOF5G3QC
update store table
Created by  boogerlad  on June 4, 2020
XQA3IQXSGAO2FST3F64WLVZ7JNLMQYKT3LO4SHHKYR2D765OPGHQC
fix ios_product/variant_id potentially returning wrong id. old behavior is if input is null, don't filter on that field at all, which is wrong. New behavior is if input is null, field should be null as well. For example, if _quantity is null and _flavor is null, it's possible to return a variant where quantity and / or flavor is not null
Created by  boogerlad  on June 4, 2020
KP6SOABNHAFFYDJNC6BS4TPU624OMWH2UDQCRYDEYJIATNJ6TWCQC
consistent casing
Created by  boogerlad  on June 4, 2020
OTHS63V6453CI7UUKD64D672VVP7ETWYO2WIH6I46545LYDQSKGQC
fix invalid password error message not showing up due to webportal_hash being falsy
Created by  boogerlad  on May 26, 2020
DSVZLJ3ULDNYRUVWRIHGQSPZYXQ26UGXPPNIIQGKVSKOPWTPZCLQC
now that sharedworker is done, tabs can detect logout. in that case, send a "logout" event to the socket when another socket is logged in with the same credentials.
Created by  boogerlad  on May 26, 2020
HFOZWZPGUIVA7QUO7VTPZ2R5ADEDGG7EGL3E5TFUUYRNAOVMHIDQC
save and serve product image dimensions to "improve lazy loading performance" and prevent reflow after the image is loaded. Before you think this is dumb, see https://youtu.be/4-d_SoCHeWE The browser can use the computed aspect ratio(therefor, scaled variants of the image will work the same! dimensions in db(x, y) don't have to match actual dimension at `destination`) and the css rules to figure out the dimensions of the containing element before the image is downloaded. also, seems cloudinary image uploads can fail with 500 'General Error'. pretty stupid description if you ask me, but that shouldn't fail a scrape.
Created by  boogerlad  on May 19, 2020
BNLZWPJDKWXBK5KQXKQALAL4WOLOHLM4ZWLORKDPKC7EBYRY23VAC
when connecting via http instead of ws, fix default websocket constructed for playing around with to use ssl if necessary
Created by  boogerlad  on May 18, 2020
G2ULKN4AA66PYPRK24JBAD4SDGIHUAK5RX4A4ZMJUI6XLYXSBWGAC
auto_login on open instead of separate message. token now in querystring instead of separate message after open. lowers latency and less boilerplate for auto reconnect.
Created by  boogerlad  on May 18, 2020
5SAL2YA2IIYRBZSNM6SBKHSD6UFP67GDOR5J6W2WXREYLJZEFJ6AC
for events, object for "add" and "update" look very similar, but that's ok! still able to differentiate(update can have less fields than object)
Created by  boogerlad  on May 18, 2020
H5KWPMZSXYCQQNSUHPJNVTL3TJDTFT27NRELYQDHD2LJ7K2QLAXAC
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 todo: 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
Created by  boogerlad  on May 11, 2020
QQAJ5O5EW6ASWLXQ627Y2F6YGMYKCM4WS37LTZYOMNPPFDPMNBUAC
clarify updating a production database
Created by  boogerlad  on May 5, 2020
XHKWEFUGJ43XCMHZ7WZWI5DF52Y4L7T43GEZRLLLVMKOCKUIV5PQC
ssh -i ~/lobogene-dev.pem ubuntu@www.lobogene.com "PGPASSWORD=5vfKQhVfCc psql -t -AF $'\t' --no-align -h 10.122.64.2 -U postgres -d webportal -c \"select email, encrypted_password, array_agg(result) from users inner join user_test_results on users.id = user_test_results.user_id inner join test_results on user_test_results.test_result_id = test_results.id group by users.id;\"" | node gene2jane.js
Created by  boogerlad  on May 5, 2020
7RKEQK2KPXJ2MEHPVSY7ROMHW6FTTKCXSMZV5MEXPFZKESZQYUUAC
might as well upgrade every other dependency too
Created by  boogerlad  on May 5, 2020
CLMZIURF2TXSMQ6YZYXR5CHGMRW6V64YFQLRCP3H3I3XB2KKOJ6AC
node 14 dependency upgrade
Created by  boogerlad  on May 5, 2020
S7XXN4JDMHFSWRHFEFK6VZ6N5UAXNA2R3BYPLQYAF5NZR3HVMOAQC
fix potential infinite loop, since select may never resolve due to nullable quantity
Created by  boogerlad  on April 30, 2020
QEACJZMASEPS7E5IGIQSWSCOERTH5WMT3EJGSZZNLGWNKH6ZAS3AC
Create production.md
Created by  boogerlad  on May 4, 2020
UQH4JUNNLJ764QF5TLFJUB24Q7R2LZVQZTY7ITB2AC55CEU2KDIAC
update uws to work on nodejs 14. Conditional SSL support
Created by  boogerlad  on April 24, 2020
UC5U5CJBD5NP545XAXEIODLEEUSRIFUVTG5NO55SNMTAGV7ZOCMAC
allow sort by and show minimum price per gram for inhalation products for (all and similar) products.
Created by  boogerlad  on April 21, 2020
AYQJCODFIHXK2UNLA55D3Y2IDJDP5BMQHUA7UNGDHBZUPDBCY74QC
oops: don't need to coalesce null to empty array, frontend already deals with that fix dynamic expiry returning the latest of all carts instead of the specific cart fix call to ios_variant_id: need to provide argument names
Created by  boogerlad  on April 17, 2020
JHV7AJ6BMRS43WQ6O5KJH2IGW73XJBHCCMHRABCWLD4AWCRUTZCAC
invalidate stale carts, releasing the inventory. Set to 5 minutes dynamic, 30 minutes static. Seems 1ms per cart to delete assuming basket size of 1 and no changes after initial, which is fine. setInterval is worse for average and best case compared to setTimeout to when a cart is expected to expire, but worst case is better for setInterval. Consider multiple carts created within a second. With setTimeout, the query would be ran multiple times a second, compounding on the already heavy load.
Created by  boogerlad  on April 17, 2020
X2VJ3NUGYJVYW3QCHNX6HX2M4QTV6TPKRVHVTYH6FPXMN2DDTLMAC
implement cart with stock level and possession limit checking
Created by  boogerlad  on April 16, 2020
76HUJPOPXCN2NMOWLI6JOY7HR35EL4IBHMES3DBJVCFZRKKPGQSAC
oops
Created by  boogerlad  on April 15, 2020
XLCCD2M74PXBCAR7SHZ5SQTLSATKRQBZRB36TBM27DJO63KFECVAC
according to https://www.justice.gc.ca/eng/cj-jp/cannabis/ looks like there is a standardized way to calculate gram equivalency except for oils, sprays, capsules (need info from lp) For all other types, gram equivalency should be null and be computed dynamically also, use insert select syntax with cross join so that subsequent dependent inserts don't happen if first one fails (due to unique constraint violation, for example) now it's possible to detect duplicate products and return an error message instead of relying on try catch
Created by  boogerlad  on April 15, 2020
PQTLWOFEMHL6BXIVUAYBHF5Z4F4CK7AD2QS4NOWGAFGV63EWKJNAC
fix product_dynamic returning wrong store image due to name aliasing issue
Created by  boogerlad  on April 15, 2020
R5FH2FKM3UQ4ICTTHXUVTSHJ6QEBRCP6FZ3PNLHUHCDLR6436IAAC
for matching concentration / piece, divide by average of portions doesn't make sense. only one of the variants can be a better match. also, who cares about showing the same product twice. they are pretty different...
Created by  boogerlad  on April 13, 2020
WSAK3COFTCT3VMN7UKLQNE46ACT66QYWV2LWCKSII3OFTUTUEJHAC
https://wiki.postgresql.org/wiki/Set_equality so that if all variants are "recommended", then none are share query between get_products and similar_products similar_products takes in variant now(mostly for capsules and edibles, but can be even more dynamic now :)) remove terpenes and description from menu_item_loader
Created by  boogerlad  on April 13, 2020
OJD2AWBJJRUXYVF5BBYWSRRIE5A7LKJDL6YQCQZ3APEBIB6GATFAC
sort by producer or brand or name, nested level unknown producer last fix sorting for when producer is the brand
Created by  boogerlad  on April 13, 2020
OIJ2CWOJTUKWCO22US3RG2NW7OXIWCLDP3Y72GY55BXYON3BR6ZQC
product_static return flavor for vapes
Created by  boogerlad  on April 11, 2020
3ZEX2CF5H5CYWMMGBQZTC7X2TUKX7WR2RNEXMBQZCXHOVMEDYMPQC
oops duplicate variant ids in get_products because possibly more than one menu_item with that variant_id! (duh)
Created by  boogerlad  on April 11, 2020
D367PKGCUNOUEO7QBPFSP3L2XOYXTRALYL7RMPY7XFO6UHQNFPCAC
fix searching for products with unknown producer
Created by  boogerlad  on April 11, 2020
6LLLHD2T6WZHLCEDV6RGXJHEPPF5EVJNUAPWYEEE3OXXZ6ZG3VWQC
get_products returns array of ids now. on product page, can show "safe" recommendations differently finalize concentration storage: flower, preroll, vape: 0-100% by mass oil: mg / ml spray: mg / spray(.1ml) edibles: mg / pack can calculate mg / piece || bag range with smallest # of portions and largest # of portions on client side menu_item_loader: sorted alphabetically to make human searching easier as they go through their list. also provide default concentrations from all online stores for shitty stores that don't keep track of the concentrations upgrade dependencies add another brand fix store creation. url is unnecessary and column name "coordinate" has changed product creation terpenes and flavors for vapes. also, automatically calculate gram equivalency for flowers and prerolls, handle capsules better
Created by  boogerlad  on April 11, 2020
JAAJEH57DRFXCZGAPOQLI4MN7N57OG52E7TQCC4FFJSOPDX4M65QC
support updating of menu items. also fix deletion(renamed id)
Created by  boogerlad  on April 9, 2020
INVJWVQDQWH57ORSOR72VWASSMDHCXD35QJQ5H7XN67PSERNUIUAC
store and stores boolean for type = 'physical'
Created by  boogerlad  on April 7, 2020
TQZJC7K5WOURWCLEFW3OP2SBWE3IGMCXBBLNVDKAPQS7NEHSLRJAC
get products from within a list of stores(for geolocation query) thc:tc range filter sort price, concentration, producer, brand, name (only 1!!! lazy 2 drag and drop and think of good ux) through backend query generation recommend specific variant since different capsule concentrations are now variants instead of distinct products, and edibles grouping by concentration per pack terpenes json array instead of postgres array compute per pack in db instead of client side for edibles. also use for thresholds in recommendation new thresholds from roz specific for each product type fix text search. I got the parameter order backwards. oops :)
Created by  boogerlad  on April 7, 2020
GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC
support another brand
Created by  boogerlad  on April 7, 2020
HHYWR3CRPHX5HLM4EX6PIKMMRCFPUOBYLO5TVWNNIF2B4EZXPI6AC
oops forgot constraint for nullable quantity (capsules)
Created by  boogerlad  on April 7, 2020
VWBNZRKY3BWQZ2LVNWDIKQFPW2K6VO2F3QUGZEE6J4UHGRXMWVRQC
assume stores differentiate different concentration capsules using the name and return concentration to use as quantity. otherwise, it's unknown(null)
Created by  boogerlad  on April 7, 2020
PU76FWDLTKUB75NYYLLB5VG2L4O4YBZTSXE3TZ5NSCCIINKOYAHQC
ocs logo. thanks TilmannR: https://commons.wikimedia.org/wiki/File:Ontario_Cannabis_Store_logo.svg but next time pls use <circle>
Created by  boogerlad  on April 7, 2020
IB3VZPSI6CXVMW44UUNOFLQGUO2EVHDDHKQISOJJC4VFQZBI5TIAC
better default display_name in regards to punctuation and casing by using original name matched with stripped name
Created by  boogerlad  on April 6, 2020
4FPV4JX2TKYDNV7XJPT36N5TRLVKNMEL4EDAUIRKUG3SOBJ3FHSQC
higher precision and accuracy for coordinates. nullable osrm_hint to amortize spatial lookup
Created by  boogerlad  on April 6, 2020
5Y72WB5QDDV3MJ3FC2TODMYYLZ47CLIRAS6WTNYBFVO5KNOGJIHQC
apparently ocs can have more than 32767 of something in stock
Created by  boogerlad  on April 6, 2020
ISAJPUA6C5CV7MWAAV2UO76Q5ZUDA2DV7KZSNCHA6VZQFD663JAAC
reorder product_type enum so that they are naturally grouped by consumption method
Created by  boogerlad  on April 6, 2020
UT6G4EVANUMS7LLFOS5FTYL4SG4UMQG67ORLV4EDMKGNT3TC2E3QC
Revert "Add Server ping" This reverts commit d2516565638c8221c6e79ba84c0c44862bf4bd06.
Created by  boogerlad  on April 3, 2020
GTLHSXOI2SWVOL5H4URY6AHE76FJPF7NP5QPZFTPEYXLXLULB3DAC
Add Server ping
Created by  David Ramsaran  on April 1, 2020
2NYE6VAHRM77GYXTYR6KC4NMZPCNNV3ISYP5UPFFPSXGUWRTH7IQC
when producer is the brand, brand should be '' instead of null(which means unknown). makes filtering easier play with volatile / stable / immutable function labels filter by multiple species, effects, strains, types, producers, brands simultaneously filter by genetics, frequency of use fix text search order backwards sort by genetics, "top" effects. todo: sort by frequency of use. propose beginners thc2tc asc, avg(thc) asc oops duplicate: replace canopy producer with canopy growth
Created by  boogerlad  on March 31, 2020
72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC
support yet another brand
Created by  boogerlad  on March 30, 2020
EL4GGLHFEBQZVJPQLL622XGW3EVMLKOSULFDOGURVID7IQ4K4TTQC
buildfix and avoid name conflict
Created by  boogerlad  on March 29, 2020
Y4CGGXO7OJRSU36XZRIUVTGX73BXSKUY566ZWXIFO3UP7Y6JXXUQC
Add species to strain table and its values. Return species for "strains" endpoint
Created by  boogerlad  on March 29, 2020
Y6HOXJX6YHDL2Y3L53QZFA4LHKXXS6WAG4TZGBKQGMT35VQLAN3QC
oops mixed up description and strain
Created by  boogerlad  on March 26, 2020
HVXAGQL3ODR3M46AQSASGGNFWSLYUNAHDIBN5DS4IGC4FHTT5JMAC
rename _in_stock to in_stock fuzzy searching products across producer, brand and name filter by species order by price add endpoint to get valid enum values for product search
Created by  boogerlad  on March 26, 2020
47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC
in stock or out of stock filter, similar products query
Created by  boogerlad  on March 26, 2020
NAAQ2HMF7NXGJDRPXATVAGGZWL5MAIQWF4K5S23VFYBPOPZUXJZAC
parameters may be undefined, so unsafe to get type. fix that.
Created by  boogerlad  on March 26, 2020
X4XDT5S7ISHUZAJ4TK2FBEV55NY6CCUVZL2LN7DTBQ7AJCP5P3QAC
remove sleep. it has served its purpose(testing suspense on frontend)
Created by  boogerlad  on March 26, 2020
OLD4IWLIOAF2YM75DMVN6TW6CR3A6PLPBLDN6UJKFRQNGV35OILQC
products filter by type, strain show description in product_static another endpoint to get a list of strains
Created by  boogerlad  on March 24, 2020
PEVQ4WY77RA6HMHM2C4HLJ5YKRLHYCAD7MDIWD6POZTJZMMMBVGAC
wildcard origin accept all, fix image persistence (connection closed unexpectedly)
Created by  kevin  on March 23, 2020
LWG4EVVTDO3IO46PTT5LGO7A2KSFPGZXSRNI7G3ZMXIAZACBB4IQC
move product_dynamic and menu_item_loader sql out of server.js and update query to work with new schema. also, for store specific page product dynamic, the joins don't make sense, so make another function specifically for that
Created by  boogerlad  on March 23, 2020
NF2TA3BN5FXWG6LFHHI3IDBVRPMLVRNUUZBE3NWIBASMSKEQPC4QC
rename strain_family to strain, strain to species support new schema move queries to postgres function
Created by  boogerlad  on March 21, 2020
63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC
tweed is not twd. plain packaging has rebranded to twd. fuck marketing
Created by  boogerlad  on March 20, 2020
SD7HZAYZQ3QHYEMP75PXWK33RLCRYJDZUHONXZJLPLX5IWG6KHKQC
add another brand
Created by  boogerlad  on March 20, 2020
AQLHZKORY2MIWVVXDEGJL2QBDKX4RVRGNJ6TI76GY2DYGEK5JHJAC
sheeeeeit a and b or c and d = (a and b) or (c and d) (used in recommendation algorithm) but a or b and c or d != (a or b) and (c or d)
Created by  boogerlad  on March 20, 2020
X723YRMNH2CY3RKNFZPOP5JG2DOLVIW3WVELT2ZTEXU7MRVI7Y2AC
idk why joined_name was assumed to be nullable in the ios_product_id query... also, according to https://www.postgresql.org/message-id/flat/6FC83909-5DB1-420F-9191-DBE533A3CEDE%40excoventures.com is not distinct from does not use an index
Created by  boogerlad  on March 20, 2020
H7WIMUC46JPR6FJ7JGTLDWLJ3JZH53UH6QCECYOGL3YIOL57JGOAC
simplify unique partial index on cart
Created by  boogerlad  on March 18, 2020
PUUFKW5ZJIJBWTMNX46PW4APAYBAYOAKXHSNGBIGRXCD5Z2FBM2QC
go with default naming for constraints / indicies except for unique partial indicies. also, store_time replace partial index with full index, but constraint not empty on the field instead
Created by  boogerlad  on March 18, 2020
5RSETDN4QCQLU7Z55EFXSW27CBEW6HD2MVD2MKB6WDBXIKXFHKNQC
swallow errors on ocs with min concentration > max concentration
Created by  boogerlad  on March 18, 2020
5IGJZG3VTZ3S5WFBPKQZVO3PNEVHB22KLQNGHXPE6TNIH6GD5YCAC
update to reflect new foreign key naming convention
Created by  boogerlad  on March 18, 2020
AHSZHZ73D7ZYAHFII7WDQHCE45C4UVUGIFWYOR3VYCHOOAYLADTAC
multiple out parameters are returned as a composite value: https://www.postgresql.org/docs/current/rowtypes.html#id-1.5.7.24.6 so ignore the open bracket prefix and the close bracket suffix, and then split by comma to get the variant id and the gram equivalency for freshly inserted, g will be '', so no equality check will happen. otherwise compare previous(selected) and current(from scrape)
Created by  boogerlad  on March 18, 2020
OLMU4W2JCB5WXCGSS4ZD4LPLXVLFX3KCTOCI4VLNF765ZXHOGPDQC
match params to table definition. oops
Created by  boogerlad  on March 18, 2020
QSEGNTGEAE4GCH6VRPHJL2JJI3WFXBDO4VJ2LTEFYHYK4576ZEHAC
clean up gram_equivalency since the fail condition doesn't happen
Created by  boogerlad  on March 18, 2020
BGFJK74YUJLEGVJMDJ77J24BTCO2DEJSKZIP57HTL4CUFIZ2B2QQC
show that it's possible for the same product to have multiple handles instead of relying on db unique constraint and the commented out console.log(removed from past couple commits)
Created by  boogerlad  on March 18, 2020
HTDKGL7WF3ESALRVW2MK64X6MUC6NMIBCQLQDY7P6DZDYCSA5DQQC
fuckboi ocs fixed concentrations, so some hacks are no longer needed
Created by  boogerlad  on March 18, 2020
EM4IBXC54LPHEZHGW7BXJQ2B7E276KOQX4A5JCCF7F2S4LAZMOEQC
support more brands
Created by  boogerlad  on March 18, 2020
CPA3Q5AQOEU4RWB3F3ZILCYTCHWSEOYXEWBL467UBWUOLGHFZTMAC
move image persistance to common.js. move insert or select thing returning id into plpgsql function and loop as per https://dba.stackexchange.com/a/213625/ all that's left to do is variant identifier and menu_item and test. seems there are new ocs inconsistencies to fix too...
Created by  kevin  on March 17, 2020
ZBUC3VBT42SDAG42OCUX7MTT6GNPX2GEGWU2QIUYAY4NMX33IGLAC
compute origins once instead of once per websocket open
Created by  kevin  on March 17, 2020
UXLEHDHRPKDY6DXD2Q64ULMVTPOPMQW6VAOPHG5K5HX24YPGG3MQC
lower case unquoted identifiers to reduce confusion(postgres doesn't differentiate) store online / physical explicit prefix all id columns with TABLENAME_ to make foreign keys in queries more intuitive for new devs and `using` keyword fix a bug where show is nullable(three valued logic is not applicable here!) portions default to 1 instead of null(no such thing as "unknown" number of portions) rename user_account to usr finally figure out a name ('active') for the initial state of a cart instead of null todo: update all the queries... In doing so, might as well move all queries out of js. regarding the highly debated `insert on conflict do nothing returning id`, fuck it. why is doing it in one statement so important? > You could check the row count of the output and repeat the statement if it does not match the row count of the input. May be good enough for the rare case. The point is to start a new query (can be in the same transaction), which will then see the newly committed rows. Or check for missing result rows within the same query and overwrite those with the brute force trick demonstrated in Alextoni's answer. can't emphasize, but instead of doing what "Or" suggests, just do another query. it's not like I've implemented the necessary locks to benefit from a single query anyways. I probably wouldn't want to, since scraping is a long operation and I don't want to ever force update (which will hit triggers). I guess the one benefit of one query method is can be pure sql? but now that I'm embracing plpgsql that's a moot point https://stackoverflow.com/a/42217872 https://dba.stackexchange.com/q/212580/
Created by  boogerlad  on March 16, 2020
5XHBBUBSPTNNPEZZVELCS5AEAKQVHEMLAI2URKBMMBUGWTPARFVQC
allow multiple origins. useful for developing more than one frontend
Created by  kevin  on March 16, 2020
6QCQLOKDENPPQQ4ZIWHSZSBUCO7TDYPMUE4JPIVF7AYQXGL5QRTQC
return inserted menu items' ids so that diffing can track on client side
Created by  boogerlad  on March 11, 2020
OGAHYK56XUYXXLLBRO5BPMBURNE673CQYGX4LBGLF5VWDY572B2AC
when loading menu_items, sort variants from smallest to biggest
Created by  boogerlad  on March 11, 2020
445Y34GSMQIF44IXOLYUL2AYYLVBHVGRP2QO7AJW3S4BP7H4UXDAC
more safe
Created by  boogerlad  on March 9, 2020
WBTHWJJ22XN2QPKFZVIBBQE2QMIHCQFYPBV4QWT7W6JEOU6XAVJAC
hardcode portions and quantity for some edibles that the dumbfucks at ocs mislabeled. also, forgot constrain for upsert
Created by  boogerlad  on March 9, 2020
Y2ZGX4FCDVEXTYPOQNAZ5GKM2GBSF6B6EFN4EAP2V5XGHKFNCMSQC
first_last_agg polyfill comment out by default
Created by  boogerlad  on March 9, 2020
KFNXH4HCDG4NXN7MZDKOBAHH6EB2JVZCQMBAEEG6G3TENFXNUTWQC
add first_last_agg back since we need it to get the first quantity (don't care which one)
Created by  kevin  on March 9, 2020
R3NNNQ3C6ITL5FMPMEUNRXQIZX2K2LBHWB762N6TBYQVZQAUFR5QC
look mah no units
Created by  kevin  on March 9, 2020
A3FTXJ6OBPF426MSYBNR7IPLUOZFWQ5PMKOIGXM7TV4SX6GJ7T2QC
updating is an important feature duh
Created by  kevin  on March 9, 2020
DESZS4X2JKQ2TKJNTQFT7WTDHQN5SRIJW7U32EKHWXVYGYV73YEQC
dosage should be in g, not mg oops
Created by  boogerlad  on March 9, 2020
IBEKBCAZIEVRFQIMTLM2O7TUULNEEAFH6O7OYWEL6BWGRBJL3CRAC
edible portion quantity label on ocs is imprecise, so compute instead for all the products with missing concentrations, use alternative path / hardcode it fix no vs unknown terpenes finally the nightmare is over
Created by  boogerlad  on March 9, 2020
CHOON7UFJCWBEFPYPXHT2PPBSF6MPSZPWELPH2HRCJ6ZKQBDWKYAC
normalize variable producers and persist if recognized, and silence brackets. we know that ocs uses brackets to indicate quantities. dumbfucks.
Created by  boogerlad  on March 9, 2020
CR5BDCVFO3MGUKRUYUOYPH3G54AUEJK3TXYSDVFT5E7LVU2C4ZBAC
add dosage field for product to override default dosage multiplier in recommendation algorithm. also add a note on stupid bc vape tax
Created by  boogerlad  on March 9, 2020
JQCVFJKLLXVEUEJ72U5MLVC4BIHNMMYI6DT2ZECXDO5XCPHORWDQC
fuck these imbeciles! what's the point of storing the measurement unit if no one is going to do it properly?? might as well hardcode it for each type of product
Created by  boogerlad  on March 7, 2020
ZN27IXLPAE5AN4NSA6UTXVLRYG7JDZGRNIZQJEHAF55C2T73UXLAC
apparently aphria partnered with dosist for canada
Created by  boogerlad  on March 7, 2020
ITFQ3GLUAQ7I2FRUNIA4MIPNKMIN5YCPUY3IHQCISI57T72KXKAQC
goodbye concentration unit. everything can be represented as mg / ml, mg / g, and mg / capsule(which can be used as is, since that's the serving size). mg / ml and mg / g need to be converted to a serving size(flower => user preference for roll, preroll / vape => each variant quantity, oil => drop, spray => spray press, gummy / mint / chocolate / baked per piece, tea => per bag?)
Created by  kevin  on March 5, 2020
XI5YHH3OET44A76EOAQF46LIPAPWIRVKTQLYZTLSF6CHLX7KKGMAC
don't do anything with websocket after closed due to origin mismatch. replace display_brand with brand
Created by  kevin  on March 4, 2020
P7PFZMZQ5S7GZRJVYE6ACAIDKVTD6YHOOGBHZ52MBSGAIDDGJTBQC
check name as well as brand for keyword
Created by  kevin  on March 4, 2020
F4SCI3XNC3BZB2V27UYMV2Z6C6IGGEL7IMEKB5MX2UUZSGAIA2LAC
typos and force capsule concentration in name to be one word
Created by  kevin  on March 4, 2020
WUYZYVZXH2IPB3NSMEUWKP7A6PHOWECLGBHGOAN5FFMXPLWIDYNQC
fallback brand parsing, and replace on canonical form - not just original.
Created by  boogerlad  on March 4, 2020
NPLF22U6DFRBKB5LINVRLZTSSY3MMHCLYSLR5WMDSKGNCHPNAEIQC
default name of database was mistakenly robomj. oops if strain_family is a falsy value, convert to null. need to verify not found strain family is null though... use producer from scrapped data for "products" from trec(fucking rebranders) clean up display name a bit generalize cookie to baked update ocs to use new normalizer and strain family
Created by  boogerlad  on March 4, 2020
ER4O22CFHMFRSJRCDYNJVT3U7Y3LMTP3SY5TEASJI5H6WLSV6K6QC
fuckoff
Created by  boogerlad  on March 4, 2020
ZQ7H4A4SN2OB6ADCZW7JMVIBDTS3AT4SQ2XXQ7I4C43V2JKH6NKAC
kill dead code
Created by  boogerlad  on March 4, 2020
66OZ7Y2BPT5LO56D6M6GVSJMOIGVVTZJMJWAOH7SQWFCBTLC3TQAC
now that we lookup producer and brand through a list we maintain ourselves, update unique indicies to reflect that
Created by  boogerlad  on March 3, 2020
NJ233BBUD2WBHKNEWPO5JWQTECTGR5F43NYTSNOZ5J3K22U5C47QC
new strain families and fix a typo
Created by  boogerlad  on March 3, 2020
SOWY545GNK34CPNCPETJOTSVHIJ42JHGITWSTDINO6EZILHYTWUQC
rename and remove unnecessary file
Created by  boogerlad  on March 3, 2020
OE75DBM36Z3EXJ7XPQVSSBEIT4UR275RP43URXF4OOFSXKEYTA4AC
strain family, brand, producer normalization
Created by  boogerlad  on March 3, 2020
I4MTA4E4GTMWJ4NC42QRWV55JRZ2K2W7SDSH5GAW2N4MIAQWS3DQC
Revert "Add new normalization data points to scraper". more data needed(scrape other provinces first) This reverts commit ac2516fa68cb9288e10167ba9fc3cacde9a01287.
Created by  boogerlad  on February 29, 2020
MVOZW3BZR7N5OIYNDZ2F7EQEOJSNJZDWYETC5U4K3TNRD2U3I7TQC
Merge branch 'master' of github.com:boogerlad/lobomj
Created by  kevin  on February 28, 2020
ONZ35S7Q2TZCKB22ZFKJUQIKQUXWY2MIZQAOSC455T3X3ZWQF2DAC
template strings and change single to double quotes for windoze
Created by  kevin  on February 27, 2020
4EEXXPTDSSQXWWMULUFVC4AQB53DSDGJEIZJAUKX3243FCBQA5TQC
forgot to uncomment puppeteer dependency
Created by  kevin  on February 27, 2020
BEPIROVOYHYS77KH7GAHNWZRIWLPN5IV2BYG372YG4R75UHYH7AQC
scraper stub of albertcannabis.org
Created by  kevin  on February 27, 2020
MPLKJQVEPZB7GEWAKZOOIKBKWHTNQX3LLESCQEG4PE3CUHQEYUBAC
capsule is a measurement unit too, oops. refetch image when older than 30 days and reupload if different, skip image scrape if no cloudinary url env, fake image scrape if cloudinary url is fuck(obviously, refetch is skipped if fuck). new portion / quantity parser. determine spray earlier, but need to rethink concentrations...
Created by  kevin  on February 28, 2020
PK7ZUXD7ELS4V6SNYYFWP45JKWKJOVWBGFDRSFY3LP47IU2M55BAC
recommendation algorithm prevent divide by zero. remove nonsense measurement units
Created by  kevin  on February 25, 2020
YUWSM4FCXGL5DRWUGCN26ADHV27THP74V6HFUR4CDUICVPIGX3QAC
protect against CSWSH
Created by  kevin  on February 25, 2020
SRIPJD5O5RNXAH2EOCTVJRGFSNNC4LDPBB44AE7FPEXGTC66NYTAC
db upgrade strategy
Created by  kevin  on February 25, 2020
5M2F2XVOCKZQGXRZC3AQ5NDFJDZZPU3X6B7ENHHYRPHPNUNBOOOQC
Add new normalization data points to scraper
Created by  David Ramsaran  on February 24, 2020
ATYY4F6DCGJMRQAHBEWP3TU2UNHASO5IW2GFAU6UUQLQGFTNNGRAC
cart WIP
Created by  boogerlad  on February 29, 2020
CPNWTEF4ZZHBAB565BALMX5QO2CR3Q32YUHE3FMWJO3O25DZNU5AC
allow deletion of menu items. new update path WIP to save bandwidth
Created by  boogerlad  on February 26, 2020
WZKS2NSIL7VST55EQ7QEF2YG2X3L2Y6W54AIG463ZRH462QR2NWQC
Update README.md
Created by  boogerlad  on February 21, 2020
GS52J542QU5MGFB2ZMJSQMSD7W4WRGBSX3ZDD4C6EFVUPYGSQ36QC
store description, phone number, tags. null means terpenes unknown, and {} is terpenes removed. store endpoint does not return products anymore, since I don't know how to reuse components with router... at least it's complete now, with images and hours. revamp all products query to show terpenes, concentrations, images, "starting from $..." price. don't need to get variants in this query either. aggregate first, and then join :) to kill distinct and group by. revamp menu_item_loader so join doesn't happen on client side. u
Created by  boogerlad  on February 21, 2020
BPHFBV52V4OA6WLKXGFK7Q4IM5EUS2SKAW5ZGSA6K3NJFJJVATIAC
some links on range aggregation. rename password to passphrase. play around with artificial delay
Created by  boogerlad  on February 16, 2020
MM3HQWNEUZVOGQ3WWBTECBY6F47SN4U43I5UNDOAFWO3R7U5XPBAC
nullable user_account for cart, split product query to static and dynamic components since picking by store instead of variant is useless... just use the store specific page
Created by  kevin  on February 14, 2020
ONTV36PSUYFGQS4OJVRW4JO3SA6XMTUN3G4HIO6YVCOLUV5DXXPAC
postgis notes. stores show real but random image. fix product_select showing all menu items, but at the very least it should be limited to current product. get urls too. null means physical store, not null means online store. client side only checks first anyways if store is part of the search. add2cart returns url of menu_item if not null, so on client side can open new tab instead of actually adding to cart, which wouldn't make sense
Created by  boogerlad  on February 12, 2020
Q3A33UTWKXZATZKX3LQ42MUAWFTWDZDMNVMLKWGC3QF6L6HBLUQAC
"bag in Bag in BAG IN BAG!!!" lmao always good to test before commit. don't need to put data in useless object when endpoint name is so similar
Created by  boogerlad  on February 12, 2020
SNP2LVW26GG6H6BDZ5S5UWPWHKSYID4WTXDL47I2KLQDLG6CW7CQC
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 :(
Created by  boogerlad  on February 12, 2020
2ZHTBPOJQI4FS3OQJXUDBD62HVFPGSKI633IXXKAGPGQLURMKVPAC
cloudinary preset endpoint, fix store creation(params should not be order dependent(new schema), open times) todo: image, cte, empty string, unique constraint got renamed
Created by  kevin  on February 10, 2020
RGMMX4YQP6NPCPFAGZ5SRITSPJQW4F77S6RJLYJMS3D732LUGDPQC
typo
Created by  kevin  on February 10, 2020
SRZ5TOOVHZKN3F2QM2IZHGYMZQW2TEXUUJFOCNPHPISJL7QSEPDAC
another heading
Created by  kevin  on February 10, 2020
Q6SGY4V3UZ4POWFMWTZMNEWMLTWBJTSRAZEMKW5UEKEPZINS5ASAC
dependencies and instructions and permission and newline
Created by  kevin  on February 10, 2020
Y4W4MACPKH3IVO6JIQYGN4V5LR6EM6RPZEJ4RHH6ZBZUDA63AGRQC
update queries to work with new schema and real data
Created by  boogerlad  on February 10, 2020
KRP35NGEHSKKLQP522S7LNZN37U7Z23Q7CDTWQMRKS2NHSA6CKXQC
ocs.ca scraper
Created by  boogerlad  on February 10, 2020
SE6MCCXTIXSGMAH5EL7EPDXIQKV6THCCY2H4OQJJQOHCUQAWE5VQC
url cannot be null for online store
Created by  boogerlad  on February 9, 2020
ZQXOYD7OCQ5DOM7TSCGCJ4RSSREE2XOINAYVJBP37NJKVRAYJZNAC
update schema to be compatible with scraped data
Created by  boogerlad  on February 8, 2020
NBGKNI25T2AKNWDH5Z6U6JDUHLQPNRL6GQFF5VS37OOHONSP4CKQC
revamp constraints for stores(online and physical)
Created by  boogerlad  on February 8, 2020
WA2FN2YR2TDCOLDWCZPYHRHPKJXE7KUB7AFERUCEB3KODVBNCUVQC
revamp table structure in preparation for scraped data. also change open hours and added many constraints. normalize strain family names
Created by  boogerlad  on February 7, 2020
NDMM44EV2XD5RP7J4Q25ZX52LUP7WOMTKO3C2PDXW7IWFEVWUW6QC
add menu_item quantity constraint. instead of allowing just one cart with status null, restrict further and say only one cart with status null, placed, or ready. forgot about stock for menu_item_builder oops. multicart(different stores) add(moar checks) and show(joins are done :D to show relevant product data). reserve check stock, cart belongs to user, and 30g limit. need to implement for other types, but ??? to roz.
Created by  boogerlad  on February 6, 2020
VIGS24FLOPPTBLIBZIB2LFMYCDZ3AO4FBXYADAKQMJFNPM4JHAGQC
add some constraints, remove decimal coercion for tax rate and quantity. change concentration min / max to range. learn how to coalesce lol. individual product query fixed. it now returns product info, aggregated ranges for its price and concentration depending on variant and / or store, a list of all variants associated with the product, and all stores that carry this product. product_select(variant) => menu_items to determine valid stores to pick. product_select(store) => menu_items to determine valid variants to pick. product_select(variant, store) => 0 or 1 menu_item(not used by frontend yet)
Created by  boogerlad  on February 5, 2020
BUCBGGRUTH7HNAADSU24U4BPHPUY7QYB3KRZPIIDUERZTL3YNTZQC
oops forgot distinct
Created by  boogerlad  on February 4, 2020
G3LGBTOCLCCN43LO5UQ6EZB6W673RRKL5FMRJUV7BQHQCP7DNZRQC
oops comma. also, fix "store not found" when store doesn't have any menu items
Created by  boogerlad  on February 4, 2020
Y2A2HVX75TL34PXDCUDRCYBAFD6ZI75WB64VYSCTX3KQWQRDBKBQC
https://stackoverflow.com/questions/41482441 don't update if nothing changed
Created by  kevin  on February 3, 2020
2WDAUGOPI2S5H2B6VA3NHUICB4JUJGVD6L5O7VXNXD45SSRDCSFQC
finally finish editing menu_items
Created by  kevin  on February 3, 2020
EDVJECDIUUOSU4TS2DCL25MJDR5RQG7PQVTYEM6R3B4SFGKSX6MAC
persist images for product
Created by  kevin  on February 3, 2020
CFWRFX3QZSXT5VAUZQ6R344R4OAZBPL6VTQACDNOYMHJICP4QALAC
cloudinary upload preset return, periods, schema cleanup, return options for create product, get rid of first_last_agg(still need to tweak another query)
Created by  boogerlad  on February 3, 2020
ZI2RJOZ2HXBHX7L54BTSDKESY6NG5KBJLVHCNY7K7ZLGIUOIHQUQC
poop. add2cart, fullfillment, store shows products through menu_items => variant => products, product shows its variants and menu_items, store onboarding load state
Created by  kevin  on January 31, 2020
UCY5PVFCT2QIOGR47KFS4KBF2ZPHRBOAIOH6PJEVWCHLMBRBLOMQC
actually persist menu_items
Created by  Kevin Hua  on January 19, 2020
5FCMFAPUTCCO2JILRWLC4PHOSHYFCQNH3D7PKLA267MHVZADOX2AC
send proper data for create_menu_items
Created by  kevin  on January 17, 2020
UCWCMBNLNMCMNJ2QRKZSFABEHKSOO7BWVLLEJCOPJPZ7QZCECQUAC
store hours and tax
Created by  kevin  on January 17, 2020
TBTYGTE3JUKOX6GDBR7AMMMV4RYCUFAK5N3ATSVCLCGESBSMJUHQC
Update README.md
Created by  boogerlad  on January 17, 2020
NMMR2KTK6PLGLUPKJQUUIA4KKMTKBOPNHPYD3HRHIGUV6ZYANYWQC
Add files via upload
Created by  boogerlad  on January 17, 2020
I5DBT6B7XMIWREH2MI6MTUTYZUJ27R4FJKAZGJGDRX66AA46GVPAC
Update README.md
Created by  boogerlad  on January 17, 2020
YHCZCZJ2VJPIBOSIHZIBRHITOU47MOA52LYIIFGV7YIPP7ZC4XCQC
Update README.md
Created by  boogerlad  on January 17, 2020
QHLBAGVYOB6KEAHAJMUTN236VSPFNOYAIKAPQJPF75YBBUXLU5PQC
Create README.md
Created by  boogerlad  on January 17, 2020
T2BEPW7GP45VJBMXIPJ2RX6W2FNULCLZWLSRW2LFF43WWGUM24DQC
menu items and join agg for products and variants
Created by  kevin  on January 17, 2020
7CC5KHF4RWFFO4DG2DLKPIQDTOBODUPKQ4KZZDRAQQUFVDNC5MRQC
variant
Created by  kevin  on January 17, 2020
54TMOAIBD5UBRSWPGW45YZO4VMVKSP7YYKIQ7H4LWSVCN2E3QA4QC
move gapi key to dotenv. add strain_family lookup table. create product
Created by  kevin  on January 16, 2020
EGNRBQUMOZHAF5B7KCMTAPMB4H3USK4MK33Q6T5V26D6HOJNW6LQC
stub out list all stores and list a specific store
Created by  kevin  on January 16, 2020
DCYC55MAVFDM43TEEUMAHLPOHNQ3EJ5PEVCA7H6ZTKNQHJZK7XJAC
get rid of currency code, since it should be same as country. if not, we'll deal with it later. finish create store, but change to dynamic hours for lunch breaks and easier to find stores that are open. dynamic hours to be implemented
Created by  kevin  on January 15, 2020
4ADMC3SGJNATDR6D7WXHNZ6RD5F5BUPLPRMCEUERWRWKVZQVAO3AC
create store WIP
Created by  kevin  on January 15, 2020
4WREYORZT3SWUXADWHSS6B4PQSP3QSLH77CGNKRH6IRKUMX4TARAC
comment and publish new user TEST
Created by  kevin  on January 14, 2020
OQJOHZCSRMKF26K3QJPBDH4BH26GW2NIYJARTTMGLJ3WJWWUQVRAC
comment on multi login
Created by  kevin  on January 13, 2020
Q4J4JHWWARLZQBYRRR33FRSFZK5BQMWGBGYQ22MLLVUELI7FYHRQC
user type needs to make it to the frontend. templates are leakable, but data is not. justify specific login error messages. can't use a closing ws, so use global
Created by  kevin  on January 13, 2020
63GH25LD577JGWRSSH4PBCVGBPEWPS7H76PRPCJDMU7PYNK7PADQC
some comments
Created by  kevin  on January 13, 2020
WYEWZOEIGDF3SIG6LHQVOKHI6MTDEYMRWZFGDFCEH27EDL2H4BVQC
authenticated and user count, remember me expiry, actually follow format, some pubsub fun, unregister, disallow multiple sockets with same credentials
Created by  kevin  on January 11, 2020
2FPZGFF5PCGNV45HOB6TROMJFPURHPXM7YSPWNXCHFJS7EICVKQAC
user create, login, remember me. todo: logout, list all users, update profile, update user
Created by  kevin  on January 10, 2020
WYTMZJFYVKHR4QH7AV5JUNWXT6NAC5NNQNPZCQSDI6LGI7DVXFYAC
dependencies
Created by  kevin  on January 9, 2020
VO5G3FF3NDOKCIF2OU7G257R3XIPTFDCAMDTOVKHKOB5Z3I55KDQC
sql schema
Created by  kevin  on January 9, 2020
E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC