{"header":{"message":"get products from within a list of stores(for geolocation query)\nthc:tc range filter\nsort price, concentration, producer, brand, name (only 1!!! lazy 2 drag and drop and think of good ux) through backend query generation\nrecommend specific variant since different capsule concentrations are now variants instead of distinct products, and edibles grouping by concentration per pack\nterpenes json array instead of postgres array\ncompute per pack in db instead of client side for edibles. also use for thresholds in recommendation\nnew thresholds from roz specific for each product type\nfix text search. I got the parameter order backwards. oops :)\n","description":null,"timestamp":"2020-04-07T09:46:44Z","authors":[{"email":"boogerlad@gmail.com","name":"boogerlad"}]},"hash":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC","authors":[],"deps":{"hashes":[["GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC","get products from within a list of stores(for geolocation query)\nthc:tc range filter\nsort price, concentration, producer, brand, name (only 1!!! lazy 2 drag and drop and think of good ux) through backend query generation\nrecommend specific variant since different capsule concentrations are now variants instead of distinct products, and edibles grouping by concentration per pack\nterpenes json array instead of postgres array\ncompute per pack in db instead of client side for edibles. also use for thresholds in recommendation\nnew thresholds from roz specific for each product type\nfix text search. I got the parameter order backwards. oops :)\n"],["AA",null],["72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC","when producer is the brand, brand should be '' instead of null(which means unknown). makes filtering easier\nplay with volatile / stable / immutable function labels\nfilter by multiple species, effects, strains, types, producers, brands simultaneously\nfilter by genetics, frequency of use\nfix text search order backwards\nsort by genetics, \"top\" effects. todo: sort by frequency of use. propose beginners thc2tc asc, avg(thc) asc\noops duplicate: replace canopy producer with canopy growth\n"],["NAAQ2HMF7NXGJDRPXATVAGGZWL5MAIQWF4K5S23VFYBPOPZUXJZAC","in stock or out of stock filter, similar products query\n"],["PEVQ4WY77RA6HMHM2C4HLJ5YKRLHYCAD7MDIWD6POZTJZMMMBVGAC","products filter by type, strain\nshow description in product_static\nanother endpoint to get a list of strains\n"],["47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC","rename _in_stock to in_stock\nfuzzy searching products across producer, brand and name\nfilter by species\norder by price\nadd endpoint to get valid enum values for product search\n"],["63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC","rename strain_family to strain, strain to species\nsupport new schema\nmove queries to postgres function\n"],["X4XDT5S7ISHUZAJ4TK2FBEV55NY6CCUVZL2LN7DTBQ7AJCP5P3QAC","parameters may be undefined, so unsafe to get type. fix that.\n"],["E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC","sql schema\n"],["WYTMZJFYVKHR4QH7AV5JUNWXT6NAC5NNQNPZCQSDI6LGI7DVXFYAC","user create, login, remember me. todo: logout, list all users, update profile, update user\n"]],"deps":["72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC"],"known":["63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC","PEVQ4WY77RA6HMHM2C4HLJ5YKRLHYCAD7MDIWD6POZTJZMMMBVGAC","X4XDT5S7ISHUZAJ4TK2FBEV55NY6CCUVZL2LN7DTBQ7AJCP5P3QAC","NAAQ2HMF7NXGJDRPXATVAGGZWL5MAIQWF4K5S23VFYBPOPZUXJZAC","47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC"]},"hunks":[{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":579,"ins":{"up_context":[{"change":3,"pos":1765}],"down_context":[{"change":2,"pos":1304}],"flag":"BLOCK","start":0,"end":60,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":1765},"to":{"change":2,"start":1172,"end":1304},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t_store_ids integer[] = null,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:30"}},{"Add":{"text":"\t_species species[] = null,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:59"}}],"del_contents":[{"Del":{"text":"\t_store_id integer = null,--soon to be array? for geolocation sort\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:1239"}},{"Del":{"text":"\t_species species[] = null,--how about default to empty array?\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:1303"}}]}},{"Edit":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":586,"atom":{"EdgeMap":{"edges":[{"previous":"","flag":"DELETED","from":{"change":2,"pos":1504},"to":{"change":3,"start":168,"end":242},"introduced_by":2},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":168},"to":{"change":3,"start":168,"end":242},"introduced_by":3},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":242},"to":{"change":2,"start":1505,"end":1732},"introduced_by":2},{"previous":"","flag":"DELETED","from":{"change":2,"pos":1732},"to":{"change":3,"start":330,"end":381},"introduced_by":2},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":330},"to":{"change":3,"start":330,"end":381},"introduced_by":3}],"inode":{"change":9,"pos":17}}},"contents":[{"Del":{"text":"\tsort_price boolean = null,--true asc, false desc, null don't sort by it\r","pos":"47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC:241"}},{"Del":{"text":"\tsort_thc boolean = null,--in frontend, warn user that the sort does not make sense if types from more than one method of consumption(inhalation, sublingual, ingestion) are included in filter\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:1697"}},{"Del":{"text":"\tsort_cbd boolean = null,--ditto\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:1731"}},{"Del":{"text":"\tsort_rank boolean = null,--contingent on ranking\r","pos":"47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC:380"}}]}},{"Edit":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":587,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":1755}],"down_context":[{"change":2,"pos":1755}],"flag":"BLOCK","start":61,"end":119,"inode":{"change":9,"pos":17}}},"contents":[{"Add":{"text":"\tmin_thc2tc decimal = null,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:89"}},{"Add":{"text":"\tmax_thc2tc decimal = null,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:118"}}]}},{"Edit":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":592,"atom":{"NewVertex":{"up_context":[{"change":2,"pos":1904}],"down_context":[{"change":2,"pos":1904}],"flag":"BLOCK","start":120,"end":144,"inode":{"change":9,"pos":17}}},"contents":[{"Add":{"text":"\tcyp2c9 cyp2c9 = null,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:143"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":595,"ins":{"up_context":[{"change":2,"pos":1964}],"down_context":[{"change":3,"pos":1819}],"flag":"BLOCK","start":145,"end":176,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":1964},"to":{"change":2,"start":1964,"end":2019},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\tcyp2c19_17 cyp2c19_17 = null\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:175"}}],"del_contents":[{"Del":{"text":"\tcyp2c19_17 cyp2c19_17 = null,\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:1995"}},{"Del":{"text":"\tcyp2c9 cyp2c9 = null\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2018"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":597,"ins":{"up_context":[{"change":3,"pos":1837}],"down_context":[{"change":3,"pos":1851}],"flag":"BLOCK","start":177,"end":255,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":1837},"to":{"change":3,"start":1837,"end":1851},"introduced_by":3}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\tproduct_id integer,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:198"}},{"Add":{"text":"\tvariant_id integer,--null means recommend any variant\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:254"}}],"del_contents":[{"Del":{"text":"\tid integer,\r","pos":"63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC:1850"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":605,"ins":{"up_context":[{"change":3,"pos":1950}],"down_context":[{"change":3,"pos":1971}],"flag":"BLOCK","start":256,"end":273,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":1950},"to":{"change":3,"start":1950,"end":1971},"introduced_by":3}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\tterpenes json,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:272"}}],"del_contents":[{"Del":{"text":"\tterpenes citext[],\r","pos":"63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC:1970"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":610,"ins":{"up_context":[{"change":3,"pos":2044}],"down_context":[{"change":3,"pos":2063}],"flag":"BLOCK","start":274,"end":657,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":2044},"to":{"change":3,"start":2044,"end":2063},"introduced_by":3}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\tquantity decimal,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:293"}},{"Add":{"text":"\tthc_per_pack decimal,--this is a hack for edibles. since grouping by concentration per pack, it is constant regardless of per piece concentration. concentration * quantity * portion yields wrong result because range * first() is wrong! range * both would yield same number, but no way for frontend to know unless more data is sent\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:626"}},{"Add":{"text":"\tcbd_per_pack decimal--ditto\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:656"}}],"del_contents":[{"Del":{"text":"\tquantity decimal\r","pos":"63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC:2062"}}]}},{"Edit":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":616,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":2096}],"down_context":[{"change":3,"pos":2096}],"flag":"BLOCK","start":658,"end":664,"inode":{"change":9,"pos":17}}},"contents":[{"Add":{"text":"\t\tv,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:663"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":623,"ins":{"up_context":[{"change":3,"pos":2189}],"down_context":[{"change":3,"pos":2202}],"flag":"BLOCK","start":665,"end":693,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":2189},"to":{"change":3,"start":2189,"end":2202},"introduced_by":3}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\tarray_to_json(terpenes),\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:692"}}],"del_contents":[{"Del":{"text":"\t\tterpenes,\r","pos":"63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC:2201"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":628,"ins":{"up_context":[{"change":3,"pos":2242}],"down_context":[{"change":3,"pos":2251}],"flag":"BLOCK","start":694,"end":711,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":2242},"to":{"change":3,"start":2242,"end":2251},"introduced_by":3}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\tq,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:699"}},{"Add":{"text":"\t\tt,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:705"}},{"Add":{"text":"\t\tc\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:710"}}],"del_contents":[{"Del":{"text":"\t\tfirst\r","pos":"63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC:2250"}}]}},{"Edit":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":645,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":2747}],"down_context":[{"change":3,"pos":2747}],"flag":"BLOCK","start":712,"end":860,"inode":{"change":9,"pos":17}}},"contents":[{"Add":{"text":"\t\t\t\tcase\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:721"}},{"Add":{"text":"\t\t\t\t\twhen first(type) in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then first(variant_id)\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:828"}},{"Add":{"text":"\t\t\t\t\telse null\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:844"}},{"Add":{"text":"\t\t\t\tend as v,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:859"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":652,"ins":{"up_context":[{"change":3,"pos":2824}],"down_context":[{"change":3,"pos":2903}],"flag":"BLOCK","start":861,"end":1321,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":2824},"to":{"change":3,"start":2824,"end":2903},"introduced_by":3}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\tcase\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:870"}},{"Add":{"text":"\t\t\t\t\twhen first(type) in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then first(quantity)\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:964"}},{"Add":{"text":"\t\t\t\t\telse null\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:980"}},{"Add":{"text":"\t\t\t\tend as q,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:995"}},{"Add":{"text":"\t\t\t\tcase\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1005"}},{"Add":{"text":"\t\t\t\t\twhen first(type) in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then first(portions * quantity * avg_range(thc))\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1127"}},{"Add":{"text":"\t\t\t\t\telse null\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1143"}},{"Add":{"text":"\t\t\t\tend as t,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1158"}},{"Add":{"text":"\t\t\t\tcase\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1168"}},{"Add":{"text":"\t\t\t\t\twhen first(type) in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then first(portions * quantity * avg_range(cbd))\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1290"}},{"Add":{"text":"\t\t\t\t\telse null\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1306"}},{"Add":{"text":"\t\t\t\tend as c\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1320"}}],"del_contents":[{"Del":{"text":"\t\t\t\tfirst(quantity)--this is used to convert mg / g to mg / piece for edibles\r","pos":"63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC:2902"}}]}},{"Edit":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":667,"atom":{"NewVertex":{"up_context":[{"change":3,"pos":2970}],"down_context":[{"change":3,"pos":2970}],"flag":"BLOCK","start":1322,"end":1365,"inode":{"change":9,"pos":17}}},"contents":[{"Add":{"text":"\t\t\t\tinner join product using (product_id)\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1364"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":669,"ins":{"up_context":[{"change":3,"pos":2980}],"down_context":[{"change":3,"pos":373}],"flag":"BLOCK","start":1366,"end":1426,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":2980},"to":{"change":3,"start":320,"end":373},"introduced_by":3}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t(store_id = any(_store_ids) or _store_ids is null) and\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1425"}}],"del_contents":[{"Del":{"text":"\t\t\t\t(store_id = _store_id or _store_id is null) and\r","pos":"NAAQ2HMF7NXGJDRPXATVAGGZWL5MAIQWF4K5S23VFYBPOPZUXJZAC:372"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":676,"ins":{"up_context":[{"change":3,"pos":3040}],"down_context":[{"change":3,"pos":3056}],"flag":"BLOCK","start":1427,"end":1731,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":3040},"to":{"change":3,"start":3040,"end":3056},"introduced_by":3}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\tproduct_id,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1443"}},{"Add":{"text":"\t\t\t\tcase\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1453"}},{"Add":{"text":"\t\t\t\t\twhen type = 'capsule' then quantity\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1495"}},{"Add":{"text":"\t\t\t\t\twhen type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then portions * quantity * (avg_range(thc) + avg_range(cbd))--group by concentration per pack. change once we recommend by concentration per piece\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1708"}},{"Add":{"text":"\t\t\t\t\telse 0\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1721"}},{"Add":{"text":"\t\t\t\tend\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1730"}}],"del_contents":[{"Del":{"text":"\t\t\t\tproduct_id\r","pos":"63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC:3055"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":687,"ins":{"up_context":[{"change":2,"pos":2127}],"down_context":[{"change":2,"pos":2185}],"flag":"BLOCK","start":1732,"end":1894,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":2127},"to":{"change":2,"start":2127,"end":2185},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t(species = any(_species) or _species is null) and\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1784"}},{"Add":{"text":"\t\t(min_thc2tc is null or max_thc2tc is null or thc2tc(thc, cbd) between min_thc2tc and max_thc2tc) and case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1893"}}],"del_contents":[{"Del":{"text":"\t\t(species = any(_species) or _species is null) and case\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2184"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":702,"ins":{"up_context":[{"change":2,"pos":2637}],"down_context":[{"change":2,"pos":2942}],"flag":"BLOCK","start":1895,"end":2170,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":2637},"to":{"change":2,"start":2637,"end":2942},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t(type in ('flower', 'preroll', 'cartridge', 'disposable', 'spray') or\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1969"}},{"Add":{"text":"\t\t\t\tcase\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:1979"}},{"Add":{"text":"\t\t\t\t\twhen type = 'oil' then avg_range(cbd) < 76\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2028"}},{"Add":{"text":"\t\t\t\t\twhen type = 'capsule' then avg_range(cbd) < 20\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2081"}},{"Add":{"text":"\t\t\t\t\twhen type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then c < 20\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2159"}},{"Add":{"text":"\t\t\t\tend)\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2169"}}],"del_contents":[{"Del":{"text":"\t\t\t\ttype in ('flower', 'preroll', 'cartridge', 'disposable') or\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2701"}},{"Del":{"text":"\t\t\t\tthc2tc(thc, cbd) > .3 or\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2731"}},{"Del":{"text":"\t\t\t\tavg_range(thc) < case--76. need to fix\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2775"}},{"Del":{"text":"\t\t\t\t\twhen type = 'oil' then 20\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2807"}},{"Del":{"text":"\t\t\t\t\twhen type = 'spray' then 2\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2840"}},{"Del":{"text":"\t\t\t\t\twhen type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 5 / first\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2932"}},{"Del":{"text":"\t\t\t\tend\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:2941"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":715,"ins":{"up_context":[{"change":2,"pos":3166}],"down_context":[{"change":2,"pos":3471}],"flag":"BLOCK","start":2171,"end":2446,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":3166},"to":{"change":2,"start":3166,"end":3471},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t(type in ('flower', 'preroll', 'cartridge', 'disposable', 'spray') or\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2245"}},{"Add":{"text":"\t\t\t\tcase\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2255"}},{"Add":{"text":"\t\t\t\t\twhen type = 'oil' then avg_range(cbd) < 20\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2304"}},{"Add":{"text":"\t\t\t\t\twhen type = 'capsule' then avg_range(cbd) < 10\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2357"}},{"Add":{"text":"\t\t\t\t\twhen type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then c < 10\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2435"}},{"Add":{"text":"\t\t\t\tend)\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2445"}}],"del_contents":[{"Del":{"text":"\t\t\t\ttype in ('flower', 'preroll', 'cartridge', 'disposable') or\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3230"}},{"Del":{"text":"\t\t\t\tthc2tc(thc, cbd) > .3 or\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3260"}},{"Del":{"text":"\t\t\t\tavg_range(thc) < case--20. need to fix\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3304"}},{"Del":{"text":"\t\t\t\t\twhen type = 'oil' then 20\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3336"}},{"Del":{"text":"\t\t\t\t\twhen type = 'spray' then 2\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3369"}},{"Del":{"text":"\t\t\t\t\twhen type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 5 / first\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3461"}},{"Del":{"text":"\t\t\t\tend\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3470"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":724,"ins":{"up_context":[{"change":2,"pos":3630}],"down_context":[{"change":2,"pos":3711}],"flag":"BLOCK","start":2447,"end":2528,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":3630},"to":{"change":2,"start":3630,"end":3711},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\telse case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2460"}},{"Add":{"text":"\t\t\t\twhen type in ('flower', 'preroll') then avg_range(thc) < case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2527"}}],"del_contents":[{"Del":{"text":"\t\t\telse avg_range(thc) < case\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3660"}},{"Del":{"text":"\t\t\t\twhen type in ('flower', 'preroll') then case\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3710"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":727,"ins":{"up_context":[{"change":2,"pos":3752}],"down_context":[{"change":2,"pos":3828}],"flag":"BLOCK","start":2529,"end":2605,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":3752},"to":{"change":2,"start":3752,"end":3828},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 180\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2566"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 150\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2604"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 240\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3789"}},{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 200\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3827"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":731,"ins":{"up_context":[{"change":2,"pos":3880}],"down_context":[{"change":2,"pos":3972}],"flag":"BLOCK","start":2606,"end":2698,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":3880},"to":{"change":2,"start":3880,"end":3972},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 130\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2643"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 100\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2681"}},{"Add":{"text":"\t\t\t\t\t\telse 220\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2697"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 215\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3917"}},{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 165\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3955"}},{"Del":{"text":"\t\t\t\t\t\telse 365\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:3971"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":746,"ins":{"up_context":[{"change":2,"pos":4260}],"down_context":[{"change":2,"pos":4316}],"flag":"BLOCK","start":2699,"end":3391,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":4260},"to":{"change":2,"start":4260,"end":4316},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\twhen type in ('cartridge', 'disposable') then avg_range(thc) < case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2771"}},{"Add":{"text":"\t\t\t\t\twhen frequency = 'daily' then case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2812"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 490.9\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2852"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 409.1\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2892"}},{"Add":{"text":"\t\t\t\t\tend\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2902"}},{"Add":{"text":"\t\t\t\t\twhen frequency = 'weekly' then case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2944"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 441.8\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:2984"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 339.1\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3024"}},{"Add":{"text":"\t\t\t\t\t\telse 750\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3040"}},{"Add":{"text":"\t\t\t\t\tend\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3050"}},{"Add":{"text":"\t\t\t\t\twhen frequency = 'monthly' then case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3093"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 353.1\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3133"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 184.6\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3173"}},{"Add":{"text":"\t\t\t\t\t\telse 600\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3189"}},{"Add":{"text":"\t\t\t\t\tend\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3199"}},{"Add":{"text":"\t\t\t\t\telse case--'rarely'\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3225"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 200\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3263"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 100\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3301"}},{"Add":{"text":"\t\t\t\t\t\telse 400\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3317"}},{"Add":{"text":"\t\t\t\t\tend\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3327"}},{"Add":{"text":"\t\t\t\tend\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3336"}},{"Add":{"text":"\t\t\t\twhen type = 'capsule' then avg_range(thc) < case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3390"}}],"del_contents":[{"Del":{"text":"\t\t\t\twhen type in ('cartridge', 'disposable') then case\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4315"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":769,"ins":{"up_context":[{"change":2,"pos":4357}],"down_context":[{"change":2,"pos":4447}],"flag":"BLOCK","start":3392,"end":3466,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":4357},"to":{"change":2,"start":4357,"end":4447},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 7.5\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3429"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 5\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3465"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 240--fixme\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4401"}},{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 200--fixme\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4446"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":773,"ins":{"up_context":[{"change":2,"pos":4499}],"down_context":[{"change":2,"pos":4605}],"flag":"BLOCK","start":3467,"end":3555,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":4499},"to":{"change":2,"start":4499,"end":4605},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 5\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3502"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 3\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3538"}},{"Add":{"text":"\t\t\t\t\t\telse 7.5\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3554"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 215--fixme\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4543"}},{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 165--fixme\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4588"}},{"Del":{"text":"\t\t\t\t\t\telse 365\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4604"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":778,"ins":{"up_context":[{"change":2,"pos":4658}],"down_context":[{"change":2,"pos":4762}],"flag":"BLOCK","start":3556,"end":3642,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":4658},"to":{"change":2,"start":4658,"end":4762},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 3\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3591"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 2\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3627"}},{"Add":{"text":"\t\t\t\t\t\telse 5\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3641"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 70--fixme\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4701"}},{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 40--fixme\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4745"}},{"Del":{"text":"\t\t\t\t\t\telse 130\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4761"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":783,"ins":{"up_context":[{"change":2,"pos":4798}],"down_context":[{"change":2,"pos":4902}],"flag":"BLOCK","start":3643,"end":3733,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":4798},"to":{"change":2,"start":4798,"end":4902},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 2.4\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3680"}},{"Add":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 1.2\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3718"}},{"Add":{"text":"\t\t\t\t\t\telse 3\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3732"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*1/*3' then 50--fixme\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4841"}},{"Del":{"text":"\t\t\t\t\t\twhen cyp2c9 = '*3/*3' then 25--fixme\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4885"}},{"Del":{"text":"\t\t\t\t\t\telse 100\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:4901"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":788,"ins":{"up_context":[{"change":2,"pos":4921}],"down_context":[{"change":2,"pos":5099}],"flag":"BLOCK","start":3734,"end":3854,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":4921},"to":{"change":2,"start":4921,"end":5099},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\t\twhen type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then t < case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3812"}},{"Add":{"text":"\t\t\t\t\twhen frequency = 'daily' then case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3853"}}],"del_contents":[{"Del":{"text":"\t\t\t\twhen type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then case\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:5006"}},{"Del":{"text":"\t\t\t\t\twhen frequency = 'daily' then case--need to divide by first, but capsule breaks it...\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:5098"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":817,"ins":{"up_context":[{"change":2,"pos":6045}],"down_context":[{"change":2,"pos":6439}],"flag":"BLOCK","start":3855,"end":4326,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":6045},"to":{"change":2,"start":6045,"end":6439},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t\twhen x = 'focused' then species = 'hybrid' and thc2tc(thc, cbd) between .25 and .7 or species = 'sativa' and case\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:3972"}},{"Add":{"text":"\t\t\t\twhen type in ('flower', 'preroll') then avg_range(thc) <= 100\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4039"}},{"Add":{"text":"\t\t\t\twhen type in ('disposable', 'cartridge') then avg_range(thc) <= 400\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4112"}},{"Add":{"text":"\t\t\t\twhen type = 'oil' then avg_range(thc) <= 20\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4161"}},{"Add":{"text":"\t\t\t\twhen type = 'spray' then true\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4196"}},{"Add":{"text":"\t\t\t\twhen type = 'capsule' then avg_range(thc) <= 5\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4248"}},{"Add":{"text":"\t\t\t\twhen type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then t <= 5\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4325"}}],"del_contents":[{"Del":{"text":"\t\t\twhen x = 'focused' then species = 'hybrid' and thc2tc(thc, cbd) between .25 and .7 or species = 'sativa' and avg_range(thc) <= case\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6180"}},{"Del":{"text":"\t\t\t\twhen type in ('flower', 'preroll') then 100\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6229"}},{"Del":{"text":"\t\t\t\twhen type in ('disposable', 'cartridge') then 550\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6284"}},{"Del":{"text":"\t\t\t\twhen type = 'oil' then 20\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6315"}},{"Del":{"text":"\t\t\t\twhen type = 'spray' then 2\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6347"}},{"Del":{"text":"\t\t\t\twhen type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 5 / first\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6438"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":825,"ins":{"up_context":[{"change":2,"pos":6447}],"down_context":[{"change":3,"pos":561}],"flag":"BLOCK","start":4327,"end":4464,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":6447},"to":{"change":2,"start":6447,"end":6668},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\tend) from unnest(_effects) as t(x)), true) and\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4376"}},{"Add":{"text":"\t\t(search is null or search <% concat_ws(' ', producer, brand, product.display_name))\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4463"}}],"del_contents":[{"Del":{"text":"\t\tend) from unnest(_effects) as t(x)), true)-- and\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6498"}},{"Del":{"text":"\t\t--(search is null or word_similarity(concat_ws(' ', producer, brand, product.display_name), lower(search)) > 0.5)--0.5 is too high... maybe limit instead if present?\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6667"}}]}},{"Replacement":{"inode":{"change":9,"pos":17},"path":"initialize.sql","line":828,"ins":{"up_context":[{"change":3,"pos":572}],"down_context":[{"change":2,"pos":6861}],"flag":"BLOCK","start":4465,"end":4624,"inode":{"change":9,"pos":17}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":572},"to":{"change":2,"start":6669,"end":6813},"introduced_by":2},{"previous":"","flag":"DELETED","from":{"change":2,"pos":6813},"to":{"change":3,"start":662,"end":704},"introduced_by":2},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":662},"to":{"change":3,"start":662,"end":704},"introduced_by":3},{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":704},"to":{"change":2,"start":6814,"end":6861},"introduced_by":2}],"inode":{"change":9,"pos":17}},"ins_contents":[{"Add":{"text":"\t\t--ranking whenever that lands\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4497"}},{"Add":{"text":"\t\tcase when search is not null then word_similarity(search, concat_ws(' ', producer, brand, product.display_name)) end desc,\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4623"}}],"del_contents":[{"Del":{"text":"\t\tcase when search is not null then word_similarity(concat_ws(' ', producer, brand, product.display_name), lower(search)) end desc nulls last,\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6812"}},{"Del":{"text":"\t\tcase when sort_price then min end asc,\r","pos":"47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC:703"}},{"Del":{"text":"\t\tcase when not sort_price then min end desc,\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:6860"}}]}},{"Replacement":{"inode":{"change":10,"pos":590},"path":"server.js","line":571,"ins":{"up_context":[{"change":3,"pos":22}],"down_context":[{"change":3,"pos":143}],"flag":"BLOCK","start":4625,"end":4815,"inode":{"change":10,"pos":590}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":22},"to":{"change":2,"start":9650,"end":9810},"introduced_by":2}],"inode":{"change":10,"pos":590}},"ins_contents":[{"Add":{"text":"\t\t\t\t\tif(Array.isArray(parameters.stores) && (parameters.stores = parameters.stores.map(Number)).every(Number.isInteger)) {\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4748"}},{"Add":{"text":"\t\t\t\t\t\tqs += `_store_ids => $${params.push(parameters.stores)},`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4814"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\tif((parameters.store = Number(parameters.store)) && Number.isInteger(parameters.store)) {\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:9745"}},{"Del":{"text":"\t\t\t\t\t\tqs += `_store_id => $${params.push(parameters.store)},`;\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:9809"}}]}},{"Replacement":{"inode":{"change":10,"pos":590},"path":"server.js","line":613,"ins":{"up_context":[{"change":3,"pos":2071}],"down_context":[{"change":2,"pos":11326}],"flag":"BLOCK","start":4816,"end":5053,"inode":{"change":10,"pos":590}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":3,"pos":2071},"to":{"change":3,"start":2071,"end":2196},"introduced_by":3}],"inode":{"change":10,"pos":590}},"ins_contents":[{"Add":{"text":"\t\t\t\t\tif(Array.isArray(parameters.thc2tc) && parameters.thc2tc.every(isFinite) && parameters.thc2tc.length === 2) {\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:4931"}},{"Add":{"text":"\t\t\t\t\t\tqs += `min_thc2tc => $${params.push(parameters.thc2tc[0])},max_thc2tc => $${params.push(parameters.thc2tc[1])},`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:5052"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\tif(typeof parameters.sort_price === 'boolean') {\r","pos":"47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC:2125"}},{"Del":{"text":"\t\t\t\t\t\tqs += `sort_price => $${params.push(parameters.sort_price)},`;\r","pos":"47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC:2195"}}]}},{"Replacement":{"inode":{"change":10,"pos":590},"path":"server.js","line":617,"ins":{"up_context":[{"change":2,"pos":11529}],"down_context":[{"change":3,"pos":395}],"flag":"BLOCK","start":5054,"end":6550,"inode":{"change":10,"pos":590}},"del":{"edges":[{"previous":"BLOCK","flag":"BLOCK | DELETED","from":{"change":2,"pos":11529},"to":{"change":2,"start":11529,"end":11719},"introduced_by":2}],"inode":{"change":10,"pos":590}},"ins_contents":[{"Add":{"text":"\t\t\t\t\t\twack += ` where ${parameters.producers.map(p => `producer = $${params.push(p.producer)}${Array.isArray(p.brands) ? ` and brand = any($${params.push(p.brands)})`: ''}`).join(' or ')}`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:5244"}},{"Add":{"text":"\t\t\t\t\t}\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:5252"}},{"Add":{"text":"\t\t\t\t\tif(typeof parameters.price === 'boolean') {\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:5302"}},{"Add":{"text":"\t\t\t\t\t\twack += ` order by min_price ${parameters.price ? 'a' : 'de'}sc`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:5375"}},{"Add":{"text":"\t\t\t\t\t} else if(typeof parameters.THC === 'boolean') {\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:5430"}},{"Add":{"text":"\t\t\t\t\t\twack += ` order by case when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then thc_per_pack else avg_range(thc) end ${parameters.THC ? 'a' : 'de'}sc, case when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then avg_range(thc) * quantity else null end ${parameters.THC ? 'a' : 'de'}sc`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:5742"}},{"Add":{"text":"\t\t\t\t\t} else if(typeof parameters.CBD === 'boolean') {\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:5797"}},{"Add":{"text":"\t\t\t\t\t\twack += ` order by case when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then cbd_per_pack else avg_range(cbd) end ${parameters.CBD ? 'a' : 'de'}sc, case when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then avg_range(cbd) * quantity else null end ${parameters.CBD ? 'a' : 'de'}sc`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:6109"}},{"Add":{"text":"\t\t\t\t\t} else if(typeof parameters.producer === 'boolean') {//lower bad for performance. index?\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:6204"}},{"Add":{"text":"\t\t\t\t\t\twack += ` order by lower(producer) ${parameters.producer ? 'a' : 'de'}sc`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:6286"}},{"Add":{"text":"\t\t\t\t\t} else if(typeof parameters.brand === 'boolean') {\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:6343"}},{"Add":{"text":"\t\t\t\t\t\twack += ` order by lower(brand) ${parameters.brand ? 'a' : 'de'}sc`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:6419"}},{"Add":{"text":"\t\t\t\t\t} else if(typeof parameters.name === 'boolean') {\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:6475"}},{"Add":{"text":"\t\t\t\t\t\twack += ` order by lower(name) ${parameters.name ? 'a' : 'de'}sc`;\r","pos":"GQ2TJSGOGNH4PKDNN5ZWITLOE6YNAWO6TCBCQV4SN7ZRWEB6IZ5AC:6549"}}],"del_contents":[{"Del":{"text":"\t\t\t\t\t\twack = ` where ${parameters.producers.map(p => `producer = $${params.push(p.producer)}${Array.isArray(p.brands) ? ` and brand = any($${params.push(p.brands)})`: ''}`).join(' or ')}`;\r","pos":"72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC:11718"}}]}}],"owner":"boogerlad","repo":"mj","token":"PXExDUTJosW1syXXlpo7/RWC7gjBHzuLPFixAA2+9Qs=","login":null}

…

Dependencies

Change contents

Review