boogerlad/mj - Change JAAJEH57DRFXCZGAPOQLI4MN7N57OG52E7TQCC4FFJSOPDX4M65QC

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

Dependencies

In channels

main

Change contents

Insertion in initialize.sql at line 89 [6.17]

[5.889]

	--when editing: https://stackoverflow.com/a/18146482 beware of canonical form! or force?

Replacement in initialize.sql at line 600 [6.17]
B:BD[4.199] → [4.199:255]
```
	variant_id integer,--null means recommend any variant
```
[4.199]
[7.1851]
```
	variant_ids json,
```

Replacement in initialize.sql at line 612 [6.17]

B:BD[7.2044] → [4.274:657]

	quantity decimal,
	thc_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
	cbd_per_pack decimal--ditto

[7.2044]

[7.2063]

	min_portions smallint,
	max_portions smallint

Replacement in initialize.sql at line 629 [6.17]
B:BD[7.2242] → [4.694:711]
```
		q,
		t,
		c
```
[7.2242]
[7.2251]
```
		min_p,
		max_p
```

Replacement in initialize.sql at line 646 [6.17]

B:BD[4.722] → [4.722:829]

					when first(type) in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then first(variant_id)

[4.722]

[4.829]

					when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then json_agg(variant_id)

Replacement in initialize.sql at line 649 [6.17]

∅:D[4.860] → [7.2747:2807]

B:BD[7.2747] → [7.2747:2807]

				range_merge(cbd) as cbd,
				range_merge(thc) as thc,

[4.860]

[7.2807]

				range_merge(cbd) as cbd,--change to conditional: if edible, divide by portions in future
				range_merge(thc) as thc,--ditto

Insertion in initialize.sql at line 652 [6.17]

[7.2824]

[4.861]

				--to construct ranges of concentrations per piece on client side, `${concentration / min_p} to ${concentation / max_p}`. in future, ranges of concentrations per pack on client side multiply instead of divide.

Replacement in initialize.sql at line 654 [6.17]

B:BD[4.871] → [4.871:965]

					when first(type) in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then first(quantity)

[4.871]

[4.965]

					when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then min(portions)

Replacement in initialize.sql at line 656 [6.17]
B:BD[4.981] → [4.981:996]
```
				end as q,
```
[4.981]
[4.996]
```
				end as min_p,
```

Replacement in initialize.sql at line 658 [6.17]

B:BD[4.1006] → [4.1006:1128]

					when first(type) in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then first(portions * quantity * avg_range(thc))

[4.1006]

[4.1128]

					when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then max(portions)

Replacement in initialize.sql at line 660 [6.17]

B:BD[4.1144] → [4.1144:1321]

				end as t,
				case
					when first(type) in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then first(portions * quantity * avg_range(cbd))
					else null
				end as c

[4.1144]

[7.2903]

				end as max_p

Insertion in initialize.sql at line 674 [6.17]
[4.1444]
[4.1444]
```
				type,
```

Replacement in initialize.sql at line 677 [6.17]

B:BD[4.1496] → [4.1496:1709]

					when 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

[4.1496]

[4.1709]

					when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then avg_range(thc) + avg_range(cbd)--group by concentration per pack. divide sum by portions once we recommend by concentration per piece in future

Replacement in initialize.sql at line 701 [6.17]

B:BD[4.1970] → [4.1970:2160]

				case
					when type = 'oil' then avg_range(cbd) < 76
					when type = 'capsule' then avg_range(cbd) < 20
					when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then c < 20

[4.1970]

[4.2160]

				avg_range(cbd) < case
					when type = 'oil' then 76
					when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 20

Replacement in initialize.sql at line 713 [6.17]

B:BD[4.2246] → [4.2246:2436]

				case
					when type = 'oil' then avg_range(cbd) < 20
					when type = 'capsule' then avg_range(cbd) < 10
					when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then c < 10

[4.2246]

[4.2436]

				avg_range(cbd) < case
					when type = 'oil' then 20
					when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 10

Replacement in initialize.sql at line 720 [6.17]

B:BD[8.3630] → [4.2447:2528]

∅:D[4.2528] → [8.3711:3752]

B:BD[8.3711] → [8.3711:3752]

B:BD[8.3752] → [4.2529:2605]

∅:D[4.2605] → [8.3828:3880]

B:BD[8.3828] → [8.3828:3880]

B:BD[8.3880] → [4.2606:2698]

∅:D[4.2698] → [8.3972:4260]

B:BD[8.3972] → [8.3972:4260]

B:BD[8.4260] → [4.2699:2772]

			else case
				when type in ('flower', 'preroll') then avg_range(thc) < case
					when frequency = 'daily' then case
						when cyp2c9 = '*1/*3' then 180
						when cyp2c9 = '*3/*3' then 150
					end
					when frequency = 'weekly' then case
						when cyp2c9 = '*1/*3' then 130
						when cyp2c9 = '*3/*3' then 100
						else 220
					end
					when frequency = 'monthly' then case
						when cyp2c9 = '*1/*3' then 70
						when cyp2c9 = '*3/*3' then 40
						else 130
					end
					else case--'rarely'
						when cyp2c9 = '*1/*3' then 50
						when cyp2c9 = '*3/*3' then 25
						else 100
					end
				end
				when type in ('cartridge', 'disposable') then avg_range(thc) < case

[8.3630]

[4.2772]

			else avg_range(thc) < case
				when type in ('flower', 'preroll') then case

Replacement in initialize.sql at line 723 [6.17]

B:BD[4.2813] → [4.2813:2893]

						when cyp2c9 = '*1/*3' then 490.9
						when cyp2c9 = '*3/*3' then 409.1

[4.2813]

[4.2893]

						when cyp2c9 = '*1/*3' then 18
						when cyp2c9 = '*3/*3' then 15

Replacement in initialize.sql at line 727 [6.17]

B:BD[4.2945] → [4.2945:3041]

						when cyp2c9 = '*1/*3' then 441.8
						when cyp2c9 = '*3/*3' then 339.1
						else 750

[4.2945]

[4.3041]

						when cyp2c9 = '*1/*3' then 13
						when cyp2c9 = '*3/*3' then 10
						else 22

Replacement in initialize.sql at line 732 [6.17]

B:BD[4.3094] → [4.3094:3190]

						when cyp2c9 = '*1/*3' then 353.1
						when cyp2c9 = '*3/*3' then 184.6
						else 600

[4.3094]

[4.3190]

						when cyp2c9 = '*1/*3' then 7
						when cyp2c9 = '*3/*3' then 4
						else 13

Replacement in initialize.sql at line 737 [6.17]

B:BD[4.3226] → [4.3226:3318]

						when cyp2c9 = '*1/*3' then 200
						when cyp2c9 = '*3/*3' then 100
						else 400

[4.3226]

[4.3318]

						when cyp2c9 = '*1/*3' then 5
						when cyp2c9 = '*3/*3' then 2
						else 10

Replacement in initialize.sql at line 742 [6.17]

B:BD[4.3337] → [4.3337:3391]

				when type = 'capsule' then avg_range(thc) < case

[4.3337]

[8.4316]

				when type in ('cartridge', 'disposable') then case

Replacement in initialize.sql at line 744 [6.17]

B:BD[8.4357] → [4.3392:3466]

						when cyp2c9 = '*1/*3' then 7.5
						when cyp2c9 = '*3/*3' then 5

[8.4357]

[8.4447]

						when cyp2c9 = '*1/*3' then 49.09
						when cyp2c9 = '*3/*3' then 40.91

Replacement in initialize.sql at line 748 [6.17]

B:BD[8.4499] → [4.3467:3555]

						when cyp2c9 = '*1/*3' then 5
						when cyp2c9 = '*3/*3' then 3
						else 7.5

[8.4499]

[8.4605]

						when cyp2c9 = '*1/*3' then 44.18
						when cyp2c9 = '*3/*3' then 33.91
						else 75

Replacement in initialize.sql at line 753 [6.17]

B:BD[8.4658] → [4.3556:3642]

						when cyp2c9 = '*1/*3' then 3
						when cyp2c9 = '*3/*3' then 2
						else 5

[8.4658]

[8.4762]

						when cyp2c9 = '*1/*3' then 35.31
						when cyp2c9 = '*3/*3' then 18.46
						else 60

Replacement in initialize.sql at line 758 [6.17]

B:BD[8.4798] → [4.3643:3733]

						when cyp2c9 = '*1/*3' then 2.4
						when cyp2c9 = '*3/*3' then 1.2
						else 3

[8.4798]

[8.4902]

						when cyp2c9 = '*1/*3' then 20
						when cyp2c9 = '*3/*3' then 10
						else 40

Replacement in initialize.sql at line 763 [6.17]

B:BD[8.4921] → [4.3734:3813]

				when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then t < case

[8.4921]

[4.3813]

				when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then case

Replacement in initialize.sql at line 793 [6.17]

B:BD[4.3973] → [4.3973:4113]

				when type in ('flower', 'preroll') then avg_range(thc) <= 100
				when type in ('disposable', 'cartridge') then avg_range(thc) <= 400

[4.3973]

[4.4113]

				when type in ('flower', 'preroll') then avg_range(thc) <= 10
				when type in ('disposable', 'cartridge') then avg_range(thc) <= 40

Replacement in initialize.sql at line 797 [6.17]

B:BD[4.4197] → [4.4197:4326]

				when type = 'capsule' then avg_range(thc) <= 5
				when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then t <= 5

[4.4197]

[8.6439]

				when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then avg_range(thc) <= 5

Replacement in initialize.sql at line 1077 [6.17]

B:BD[9.2384] → [9.2384:2411]

					'featured', featured

[9.2384]

[9.2411]

					'featured', featured,
					'default_concentrations', (select json_agg(json_build_object('name', store.name, 'min_thc', lower(thc), 'max_thc', upper(thc), 'min_cbd',lower(cbd), 'max_cbd', upper(cbd))) from menu_item inner join store using (store_id) where store.type = 'online' and variant_id = v.variant_id)

Replacement in initialize.sql at line 1081 [6.17]
B:BD[9.2457] → [9.2457:2470]
```
				variant
```
[9.2457]
[9.2470]
```
				variant as v
```

Insertion in initialize.sql at line 1097 [6.17]

[9.2784]

[8.8714]

	order by
		case
			when brand = '' then lower(producer)
			else lower(brand)
		end asc,
		lower(product.display_name) asc

Replacement in package-lock.json at line 8 [11.145]

B:BD[10.182] → [10.182:449]

      "version": "2.0.2",
      "resolved": "https://registry.npmjs.org/@googlemaps/google-maps-services-js/-/google-maps-services-js-2.0.2.tgz",
      "integrity": "sha512-AzhUckl3X9QmopPxx/QKUwoUenvnkhTAP6811siaociclxS3vf4GHGVIMAEHVcvjt+2cWeq+603gLBVciS5TKg==",

[10.182]

[12.957]

      "version": "2.4.3",
      "resolved": "https://registry.npmjs.org/@googlemaps/google-maps-services-js/-/google-maps-services-js-2.4.3.tgz",
      "integrity": "sha512-8ADmWVMW8FpjtanyD2Bv4rUyRz2ha5RSu5ZR6HYrCJ8s8CULmeaH2SIQzscbrvwCZzzLaeuqXKAUKSltYYp0sg==",

Replacement in package-lock.json at line 14 [11.145]

B:BD[10.516] → [10.516:614]

        "query-string": "github:jpoehnelt/query-string#e22cdb49ef848efaed4fe60d63d2504b496027c1"

[10.516]

[12.1045]

        "query-string": "^6.11.0",
        "retry-axios": "^2.1.2"

Deletion in package-lock.json at line 49 [11.145]

B:BD[10.966] → [10.966:1329]

      },
      "dependencies": {
        "debug": {
          "version": "4.1.1",
          "resolved": "https://registry.npmjs.org/debug/-/debug-4.1.1.tgz",
          "integrity": "sha512-pYAIzeRo8J6KPEaJ0VWOh5Pzkbw/RetuzehGM7QRRX5he4fPHx2rdKMB256ehJCkX+XRQm16eZLqLNS8RSZXZw==",
          "requires": {
            "ms": "^2.1.1"
          }
        }

Replacement in package-lock.json at line 52 [11.145]

B:BD[13.1024] → [13.1024:1241]

      "version": "6.11.0",
      "resolved": "https://registry.npmjs.org/ajv/-/ajv-6.11.0.tgz",
      "integrity": "sha512-nCprB/0syFYy9fVYU1ox1l2KN8S9I+tziH8D4zdZuLT3N6RMlGSGt5FSTpAiHB/Whv8Qs1cWHma1aMKZyaHRKA==",

[13.1024]

[13.1241]

      "version": "6.12.0",
      "resolved": "https://registry.npmjs.org/ajv/-/ajv-6.12.0.tgz",
      "integrity": "sha512-D6gFiFA0RRLyUbvijN74DWAjXSFxWKaWP7mldxkVhyhAV3+SWA9HEJPHQ2c9soIeTFJqcSdFDGFgdqs1iUU2Hw==",

Replacement in package-lock.json at line 174 [11.145]

B:BD[11.3365] → [11.3365:3585]

      "version": "1.1.3",
      "resolved": "https://registry.npmjs.org/chownr/-/chownr-1.1.3.tgz",
      "integrity": "sha512-i70fVHhmV3DtTl6nqvZOnIjbY0Pe4kAUjwHj8z0zAdgBtYrJyYwLKCCuRBQ5ppkyL0AkN7HKRnETdmdp1zqNXw=="

[11.3365]

[11.3585]

      "version": "1.1.4",
      "resolved": "https://registry.npmjs.org/chownr/-/chownr-1.1.4.tgz",
      "integrity": "sha512-jJ0bqzaylmJtVnNgzTeSOs8DPavpbYgEr/b0YL8/2GO3xJEhInFmhKMUnEJQjZumK7KXGFhUy89PrsJWlakBVg=="

Replacement in package-lock.json at line 179 [11.145]

B:BD[14.94] → [14.94:327]

      "version": "3.6.0",
      "resolved": "https://registry.npmjs.org/cli-progress/-/cli-progress-3.6.0.tgz",
      "integrity": "sha512-elg6jkiDedYrvwqWSae2FGvtbMo37Lo04oI9jJ5cI43Ge3jrDPWzeL3axv7MgBLYHDY/kGio/CXa49m4MWMrNw==",

[14.94]

[14.327]

      "version": "3.7.0",
      "resolved": "https://registry.npmjs.org/cli-progress/-/cli-progress-3.7.0.tgz",
      "integrity": "sha512-xo2HeQ3vNyAO2oYF5xfrk5YM6jzaDNEbeJRLAQir6QlH54g4f6AXW+fLyJ/f12gcTaCbJznsOdQcr/yusp/Kjg==",

Replacement in package-lock.json at line 184 [11.145]
B:BD[14.377] → [14.377:411]
```
        "string-width": "^2.1.1"
```
[14.377]
[14.411]
```
        "string-width": "^4.2.0"
```

Replacement in package-lock.json at line 188 [11.145]

B:BD[14.471] → [14.471:649]

          "version": "3.0.0",
          "resolved": "https://registry.npmjs.org/ansi-regex/-/ansi-regex-3.0.0.tgz",
          "integrity": "sha1-7QMXwyIGT3lGbAKWa922Bas32Zg="

[14.471]

[14.649]

          "version": "5.0.0",
          "resolved": "https://registry.npmjs.org/ansi-regex/-/ansi-regex-5.0.0.tgz",
          "integrity": "sha512-bY6fj56OUQ0hU1KjFNDQuJFezqKdrAyFdIevADiqrWHwSlbmBNMHp5ak2f40Pm8JTFyM2mqxkG6ngkHO11f/lg=="

Replacement in package-lock.json at line 193 [11.145]

B:BD[14.699] → [14.699:903]

          "version": "2.0.0",
          "resolved": "https://registry.npmjs.org/is-fullwidth-code-point/-/is-fullwidth-code-point-2.0.0.tgz",
          "integrity": "sha1-o7MKXE8ZkYMWeqq5O+764937ZU8="

[14.699]

[14.903]

          "version": "3.0.0",
          "resolved": "https://registry.npmjs.org/is-fullwidth-code-point/-/is-fullwidth-code-point-3.0.0.tgz",
          "integrity": "sha512-zymm5+u+sCsSWyD9qNaejV3DFvhCKclKdizYaJUuHA83RLjb7nSuGnddCHGv0hk+KY7BMAlsWeK4Ueg6EV6XQg=="

Replacement in package-lock.json at line 198 [11.145]

B:BD[14.942] → [14.942:1187]

          "version": "2.1.1",
          "resolved": "https://registry.npmjs.org/string-width/-/string-width-2.1.1.tgz",
          "integrity": "sha512-nOqH59deCq9SRHlxq1Aw85Jnt4w6KvLKqWVik6oA9ZklXLNIOlqg4F2yrT1MVaTjAqvVwdfeZ7w7aCvJD7ugkw==",

[14.942]

[14.1187]

          "version": "4.2.0",
          "resolved": "https://registry.npmjs.org/string-width/-/string-width-4.2.0.tgz",
          "integrity": "sha512-zUz5JD+tgqtuDjMhwIg5uFVV3dtqZ9yQJlZVfq4I01/K5Paj5UHj7VyrQOJvzawSVlKpObApbfD0Ed6yJc+1eg==",

Replacement in package-lock.json at line 202 [11.145]

B:BD[14.1212] → [14.1212:1298]

            "is-fullwidth-code-point": "^2.0.0",
            "strip-ansi": "^4.0.0"

[14.1212]

[14.1298]

            "emoji-regex": "^8.0.0",
            "is-fullwidth-code-point": "^3.0.0",
            "strip-ansi": "^6.0.0"

Replacement in package-lock.json at line 208 [11.145]

B:BD[14.1348] → [14.1348:1527]

          "version": "4.0.0",
          "resolved": "https://registry.npmjs.org/strip-ansi/-/strip-ansi-4.0.0.tgz",
          "integrity": "sha1-qEeQIusaw2iocTibY1JixQXuNo8=",

[14.1348]

[14.1527]

          "version": "6.0.0",
          "resolved": "https://registry.npmjs.org/strip-ansi/-/strip-ansi-6.0.0.tgz",
          "integrity": "sha512-AuvKTrTfQNYNIctbR1K/YGTR1756GycPsg7b9bdV9Duqur4gv6aKqHXah67Z8ImS7WEz5QVcOtlfW2rZEugt6w==",

Replacement in package-lock.json at line 212 [11.145]
B:BD[14.1552] → [14.1552:1588]
```
            "ansi-regex": "^3.0.0"
```
[14.1552]
[14.1588]
```
            "ansi-regex": "^5.0.0"
```

Replacement in package-lock.json at line 218 [11.145]

B:BD[14.1650] → [14.1650:1881]

      "version": "1.19.0",
      "resolved": "https://registry.npmjs.org/cloudinary/-/cloudinary-1.19.0.tgz",
      "integrity": "sha512-oEz4Fsqshd9SI7UAvF1CCyAmt3wgsv8tK1eRY0900gQaq+wP8TAzpruxpbQCmxvF6gL9Po7OpO0m0Jefx6uK8w==",

[14.1650]

[14.1881]

      "version": "1.21.0",
      "resolved": "https://registry.npmjs.org/cloudinary/-/cloudinary-1.21.0.tgz",
      "integrity": "sha512-am8wpHbHl8bcpy9oGSlWrpWLNQ9szkW/jmhcJdEpMjaL23BYt05V1frWyrXDlo8Jt7aCo5NE6EO0CM9Zaynd5g==",

Replacement in package-lock.json at line 223 [11.145]
B:BD[14.1933] → [14.1933:1989]
```
        "q": "^1.5.1",
        "typescript": "^2.9.2"
```
[14.1933]
[14.1989]
```
        "q": "^1.5.1"
```

Replacement in package-lock.json at line 279 [11.145]

B:BD[11.4443] → [11.4443:4662]

      "version": "3.2.6",
      "resolved": "https://registry.npmjs.org/debug/-/debug-3.2.6.tgz",
      "integrity": "sha512-mel+jf7nrtEl5Pn1Qx46zARXKDpBbvzezse7p7LqINmdoIk8PYP5SySaxEmYv6TZ0JyEKA1hsCId6DIhgITtWQ==",

[11.4443]

[11.4662]

      "version": "4.1.1",
      "resolved": "https://registry.npmjs.org/debug/-/debug-4.1.1.tgz",
      "integrity": "sha512-pYAIzeRo8J6KPEaJ0VWOh5Pzkbw/RetuzehGM7QRRX5he4fPHx2rdKMB256ehJCkX+XRQm16eZLqLNS8RSZXZw==",

Insertion in package-lock.json at line 329 [11.145]

[12.1908]

[13.4088]

    },
    "emoji-regex": {
      "version": "8.0.0",
      "resolved": "https://registry.npmjs.org/emoji-regex/-/emoji-regex-8.0.0.tgz",
      "integrity": "sha512-MSjYzcWNOA0ewAHpz0MxpYFvwg6yjy1NG3xteoqz644VCo/RPgnr1/GGt+ic3iJTzQ8Eu3TdM14SawnVUmGE6A=="

Replacement in package-lock.json at line 688 [11.145]

B:BD[11.11682] → [11.11682:11903]

      "version": "2.4.0",
      "resolved": "https://registry.npmjs.org/needle/-/needle-2.4.0.tgz",
      "integrity": "sha512-4Hnwzr3mi5L97hMYeNl8wRW/Onhy4nUKR/lVemJ8gJedxxUyBLm9kkrDColJvoSfwi0jCNhD+xCdOtiGDQiRZg==",

[11.11682]

[11.11903]

      "version": "2.4.1",
      "resolved": "https://registry.npmjs.org/needle/-/needle-2.4.1.tgz",
      "integrity": "sha512-x/gi6ijr4B7fwl6WYL9FwlCvRQKGlUNvnceho8wxkwXqN8jvVmmmATTmZPRRG7b/yC1eode26C2HO9jl78Du9g==",

Insertion in package-lock.json at line 695 [11.145]

[11.12010]

      },
      "dependencies": {
        "debug": {
          "version": "3.2.6",
          "resolved": "https://registry.npmjs.org/debug/-/debug-3.2.6.tgz",
          "integrity": "sha512-mel+jf7nrtEl5Pn1Qx46zARXKDpBbvzezse7p7LqINmdoIk8PYP5SySaxEmYv6TZ0JyEKA1hsCId6DIhgITtWQ==",
          "requires": {
            "ms": "^2.1.1"
          }
        }

Replacement in package-lock.json at line 730 [11.145]

B:BD[11.12898] → [11.12898:13053]

      "version": "4.0.1",
      "resolved": "https://registry.npmjs.org/nopt/-/nopt-4.0.1.tgz",
      "integrity": "sha1-0NRoWv1UFRk8jHUFYC0NF81kR00=",

[11.12898]

[11.13053]

      "version": "4.0.3",
      "resolved": "https://registry.npmjs.org/nopt/-/nopt-4.0.3.tgz",
      "integrity": "sha512-CvaGwVMztSMJLOeXPrez7fyfObdZqNUK1cPAEzLHrTybIua9pMdmmPR5YwtfNftIOMv3DPUhFaxsZMNTQO20Kg==",

Replacement in package-lock.json at line 752 [11.145]

B:BD[11.13805] → [11.13805:14038]

      "version": "1.4.7",
      "resolved": "https://registry.npmjs.org/npm-packlist/-/npm-packlist-1.4.7.tgz",
      "integrity": "sha512-vAj7dIkp5NhieaGZxBJB8fF4R0078rqsmhJcAfXZ6O7JJhjhPK96n5Ry1oZcfLXgfun0GWTZPOxaEyqv8GBykQ==",

[11.13805]

[11.14038]

      "version": "1.4.8",
      "resolved": "https://registry.npmjs.org/npm-packlist/-/npm-packlist-1.4.8.tgz",
      "integrity": "sha512-5+AZgwru5IevF5ZdnFglB5wNlHG1AOOuw28WhUq8/8emhBmLv6jX5by4WJCh7lW0uSYZYS6DXqIsyZVIXRZU9A==",

Replacement in package-lock.json at line 757 [11.145]

B:BD[11.14093] → [11.14093:14126]

        "npm-bundled": "^1.0.1"

[11.14093]

[11.14126]

        "npm-bundled": "^1.0.1",
        "npm-normalize-package-bin": "^1.0.1"

Replacement in package-lock.json at line 835 [11.145]

B:BD[11.16421] → [10.3154:3369]

      "version": "7.18.1",
      "resolved": "https://registry.npmjs.org/pg/-/pg-7.18.1.tgz",
      "integrity": "sha512-1KtKBKg/zWrjEEv//klBbVOPGucuc7HHeJf6OEMueVcUeyF3yueHf+DvhVwBjIAe9/97RAydO/lWjkcMwssuEw==",

[11.16421]

[11.16636]

      "version": "8.0.0",
      "resolved": "https://registry.npmjs.org/pg/-/pg-8.0.0.tgz",
      "integrity": "sha512-jinx9Xcmkeh7Y7gatu2EJiXr37mcDeF0G5X14MjqPMwYjoZMk7PMMSTTXQQl03GRp2IICxo/zyybqfv2RNgXsg==",

Replacement in package-lock.json at line 843 [11.145]
B:BD[11.16808] → [10.3370:3401]
```
        "pg-pool": "^2.0.10",
```
[11.16808]
[11.16838]
```
        "pg-pool": "^3.0.0",
```

Replacement in package-lock.json at line 872 [11.145]

B:BD[11.20013] → [10.3402:3626]

      "version": "2.0.10",
      "resolved": "https://registry.npmjs.org/pg-pool/-/pg-pool-2.0.10.tgz",
      "integrity": "sha512-qdwzY92bHf3nwzIUcj+zJ0Qo5lpG/YxchahxIN8+ZVmXqkahKXsnl2aiJPHLYN9o5mB/leG+Xh6XKxtP7e0sjg=="

[11.20013]

[11.20235]

      "version": "3.0.0",
      "resolved": "https://registry.npmjs.org/pg-pool/-/pg-pool-3.0.0.tgz",
      "integrity": "sha512-AJWVHFre7CjOtu4D/PQjX+U9uhNKGRFSO9xQAzB7cn1Xu1vmhyo8s8eg9cw6kf2m2/+TYuvMH8i5jeFPSdllPw=="

Replacement in package-lock.json at line 982 [11.145]

B:BD[10.3650] → [10.3650:3831]

      "version": "github:jpoehnelt/query-string#e22cdb49ef848efaed4fe60d63d2504b496027c1",
      "from": "github:jpoehnelt/query-string#e22cdb49ef848efaed4fe60d63d2504b496027c1",

[10.3650]

[10.3831]

      "version": "6.12.0",
      "resolved": "https://registry.npmjs.org/query-string/-/query-string-6.12.0.tgz",
      "integrity": "sha512-aoiFW9ZU7jP8Itjqfpw80Qe7RoyCIhFrW522sdsp9LG92pat6CCG3d8qNZBaUi71FsEjIfLjx9Ky347FtVoqXA==",

Replacement in package-lock.json at line 1003 [11.145]

B:BD[11.22746] → [11.22746:22920]

          "version": "1.2.0",
          "resolved": "https://registry.npmjs.org/minimist/-/minimist-1.2.0.tgz",
          "integrity": "sha1-o1AIsg9BOD7sH7kU9M1d95omQoQ="

[11.22746]

[11.22920]

          "version": "1.2.5",
          "resolved": "https://registry.npmjs.org/minimist/-/minimist-1.2.5.tgz",
          "integrity": "sha512-FM9nNUYrRBAELZQT3xeZQ7fmMOBg6nWNmJKTcgsJeaLstP/UODVpGsr5OhXhhXg6f+qtJ8uiZ+PUxkDWcgIXLw=="

Replacement in package-lock.json at line 1031 [11.145]

B:BD[13.9768] → [13.9768:9993]

      "version": "2.88.0",
      "resolved": "https://registry.npmjs.org/request/-/request-2.88.0.tgz",
      "integrity": "sha512-NAqBSrijGLZdM0WZNsInLJpkJokL72XYjUpnB0iwsRgxh7dB6COrHnTBNwN0E+lHDAJzu7kLAkDeY08z2/A0hg==",

[13.9768]

[13.9993]

      "version": "2.88.2",
      "resolved": "https://registry.npmjs.org/request/-/request-2.88.2.tgz",
      "integrity": "sha512-MsvtOrfG9ZcrOwAW+Qi+F6HbD0CWXEh9ou77uOb7FM2WPhwT7smM833PzanhJLsgXjN89Ir6V2PczXNnMpwKhw==",

Replacement in package-lock.json at line 1042 [11.145]
B:BD[13.10240] → [13.10240:10276]
```
        "har-validator": "~5.1.0",
```
[13.10240]
[13.10276]
```
        "har-validator": "~5.1.3",
```
Replacement in package-lock.json at line 1052 [11.145]
B:BD[13.10586] → [13.10586:10621]
```
        "tough-cookie": "~2.4.3",
```
[13.10586]
[13.10621]
```
        "tough-cookie": "~2.5.0",
```

Deletion in package-lock.json at line 1055 [11.145]

B:BD[13.10682] → [13.10682:11301]

∅:D[13.11301] → [11.23783:23794]

B:BD[11.23783] → [11.23783:23794]

      },
      "dependencies": {
        "punycode": {
          "version": "1.4.1",
          "resolved": "https://registry.npmjs.org/punycode/-/punycode-1.4.1.tgz",
          "integrity": "sha1-wNWmOycYgArY4esPpSachN1BhF4="
        },
        "tough-cookie": {
          "version": "2.4.3",
          "resolved": "https://registry.npmjs.org/tough-cookie/-/tough-cookie-2.4.3.tgz",
          "integrity": "sha512-Q5srk/4vDM54WJsJio3XNn6K2sCG+CQ8G5Wz6bZhRZoAe/+TxjWB/GlFAnYEbkYVlON9FMk/fE3h2RLpPXo4lQ==",
          "requires": {
            "psl": "^1.1.24",
            "punycode": "^1.4.1"
          }
        }

Insertion in package-lock.json at line 1075 [11.145]

[14.3947]

[11.23811]

    "retry-axios": {
      "version": "2.1.2",
      "resolved": "https://registry.npmjs.org/retry-axios/-/retry-axios-2.1.2.tgz",
      "integrity": "sha512-MVNOizOgcM+dXK/kJCMnHPCGjp2Z0o3Ngznh7SfJkIVrqemHmDcgUEAbEHs3RyR3lbJtSyamq9k3gmgGSaow1g=="
    },

Replacement in package-lock.json at line 1114 [11.145]

B:BD[11.25340] → [11.25340:25508]

      "version": "3.0.2",
      "resolved": "https://registry.npmjs.org/signal-exit/-/signal-exit-3.0.2.tgz",
      "integrity": "sha1-tf3AjxKH6hF4Yo5BXiUTK3NkbG0="

[11.25340]

[11.25508]

      "version": "3.0.3",
      "resolved": "https://registry.npmjs.org/signal-exit/-/signal-exit-3.0.3.tgz",
      "integrity": "sha512-VUJ49FC8U1OxwZLxIbTTrDvLnf/6TDgxZcK8wxR8zs13xpx7xbG60ndBlhNrFi2EMuFRoeDoJO7wthSLq42EjA=="

Deletion in package-lock.json at line 1240 [11.145]

∅:D[13.12320] → [14.4505:4762]

∅:D[15.5459] → [14.4505:4762]

B:BD[14.4505] → [14.4505:4762]

    },
    "typescript": {
      "version": "2.9.2",
      "resolved": "https://registry.npmjs.org/typescript/-/typescript-2.9.2.tgz",
      "integrity": "sha512-Gr4p6nFNaoufRIY4NMdpQRNmgxVIGMs4Fcu/ujdYk3nAZqk7supzBE9idmvfZIlH/Cuj//dvi+019qEue9lV0w=="

Replacement in package-lock.json at line 1242 [11.145]

B:BD[11.27983] → [11.27983:28138]

      "version": "github:uNetworking/uWebSockets.js#69026e121ae4a8d4f285c68b565710ef697b5dac",
      "from": "github:uNetworking/uWebSockets.js#v16.5.0"

[11.27983]

[13.12321]

      "version": "github:uNetworking/uWebSockets.js#f54d0b45d1d9924d2562fd8f6f59cbca2bcbcc2c",
      "from": "github:uNetworking/uWebSockets.js#v17.3.0"

Replacement in package-lock.json at line 1259 [11.145]

B:BD[12.2302] → [12.2302:2518]

      "version": "3.3.3",
      "resolved": "https://registry.npmjs.org/uuid/-/uuid-3.3.3.tgz",
      "integrity": "sha512-pW0No1RGHgzlpHJO1nsVrHKpOEIxkGg1xB+v0ZmdNH5OAeAwzAVrCnI2/6Mtx+Uys6iaylxa+D3g4j63IKKjSQ=="

[12.2302]

[12.2518]

      "version": "3.4.0",
      "resolved": "https://registry.npmjs.org/uuid/-/uuid-3.4.0.tgz",
      "integrity": "sha512-HjSDRw6gZE5JMggctHBcjVak08+KEVhSIiDzFnT9S9aegmp85S/bReBVTb4QTFaRNptJ9kuYaNhnbNEOkbKb/A=="

Replacement in package.json at line 8 [11.29376]

B:BD[11.29526] → [10.4476:4530]

    "@googlemaps/google-maps-services-js": "^2.0.2",

[11.29526]

    "@googlemaps/google-maps-services-js": "^2.4.3",

Replacement in package.json at line 11 [11.29376]

B:BD[11.29598] → [14.4771:4832]

    "cli-progress": "^3.6.0",
    "cloudinary": "^1.19.0",

[11.29598]

    "cli-progress": "^3.7.0",
    "cloudinary": "^1.21.0",

Replacement in package.json at line 14 [11.29376]
B:BD[11.29623] → [10.4531:4553]
```
    "pg": "^7.18.1",
```
[11.29623]
[15.6003]
```
    "pg": "^8",
```
Replacement in package.json at line 16 [11.29376]
∅:D[10.4553] → [13.12945:12972]
∅:D[15.6031] → [13.12945:12972]
B:BD[11.29645] → [13.12945:12972]
```
    "request": "^2.88.0",
```
[15.6031]
[14.4833]
```
    "request": "^2.88.2",
```

Replacement in package.json at line 18 [11.29376]

∅:D[14.4874] → [11.29673:29740]

B:BD[11.29673] → [11.29673:29740]

    "uWebSockets.js": "github:uNetworking/uWebSockets.js#v16.5.0"

[14.4874]

[11.29740]

    "uWebSockets.js": "github:uNetworking/uWebSockets.js#v17.3.0"

Insertion in scrape/common.js at line 237 [14.4897]

[16.258]

[17.3128]

			} else if(brand.includes('palmetto')) {
				producer = 'SUNDIAL';
				brand = 'PALMETTO';

Replacement in scrape/ocs.ca.js at line 99 [14.11674]

B:BD[14.14612] → [18.1120:2680]

∅:D[18.3812] → [19.1306:1312]

B:BD[19.1306] → [19.1306:1312]

B:BD[19.1312] → [18.3813:4058]

B:BD[18.4058] → [3.260:286]

∅:D[3.286] → [18.4087:4141]

B:BD[18.4087] → [18.4087:4141]

∅:D[18.4141] → [14.15599:15606]

∅:D[19.1471] → [14.15599:15606]

B:BD[14.15599] → [14.15599:15606]

B:BD[14.15606] → [18.4142:4330]

			let minTHC = e[i][0].meta.variant.thc_min_per === undefined || e[i][0].meta.variant.thc_min_per === null ? null : new Big(e[i][0].meta.variant.thc_min_per);
			let maxTHC = e[i][0].meta.variant.thc_max_per === undefined || e[i][0].meta.variant.thc_max_per === null ? null : new Big(e[i][0].meta.variant.thc_max_per);
			let minCBD = e[i][0].meta.variant.cbd_min_per === undefined || e[i][0].meta.variant.cbd_min_per === null ? null : new Big(e[i][0].meta.variant.cbd_min_per);
			let maxCBD = e[i][0].meta.variant.cbd_max_per === undefined || e[i][0].meta.variant.cbd_max_per === null ? null : new Big(e[i][0].meta.variant.cbd_max_per);
			if(e[i][0].handle === 'rest-cove-pink-kush' || e[i][0].handle === 'thc-indica-aces-pre-roll-aurora') {//high I'm a dumbfuck that works at ocs and I don't know how to multiply by 10 :)
				minTHC = e[i][0].meta.product.thc_content_min === undefined || e[i][0].meta.product.thc_content_min === null ? null : (new Big(e[i][0].meta.product.thc_content_min)).times(10);
				maxTHC = e[i][0].meta.product.thc_content_max === undefined || e[i][0].meta.product.thc_content_max === null ? null : (new Big(e[i][0].meta.product.thc_content_max)).times(10);
				minCBD = e[i][0].meta.product.cbd_content_min === undefined || e[i][0].meta.product.cbd_content_min === null ? null : (new Big(e[i][0].meta.product.cbd_content_min)).times(10);
				maxCBD = e[i][0].meta.product.cbd_content_max === undefined || e[i][0].meta.product.cbd_content_max === null ? null : (new Big(e[i][0].meta.product.cbd_content_max)).times(10);
			}
			if(e[i][0].type === 'tea' || e[i][0].type === 'gummy' || e[i][0].type === 'mint' || e[i][0].type === 'chocolate' || e[i][0].type === 'baked' && ok(minTHC, maxTHC, minCBD, maxCBD)) {
				let [portions, quantity] = pq(e[i][0], e[i][0].type);
				if(portions !== 1) {
					quantity = (new Big(quantity)).times(portions);
				}
				minTHC = (new Big(minTHC)).div(quantity);
				maxTHC = (new Big(maxTHC)).div(quantity);
				minCBD = (new Big(minCBD)).div(quantity);
				maxCBD = (new Big(maxCBD)).div(quantity);

[14.14612]

[14.16144]

			let minTHC, maxTHC, minCBD, maxCBD;
			if(e[i][0].type === 'flower' || e[i][0].type === 'preroll' || e[i][0].type === 'cartridge' || e[i][0].type === 'disposable') {
				minTHC = new Big(e[i][0].meta.product.thc_content_min);
				maxTHC = new Big(e[i][0].meta.product.thc_content_max);
				minCBD = new Big(e[i][0].meta.product.cbd_content_min);
				maxCBD = new Big(e[i][0].meta.product.cbd_content_max);
			} else {
				minTHC = new Big(e[i][0].meta.variant.thc_min_per);
				maxTHC = new Big(e[i][0].meta.variant.thc_max_per);
				minCBD = new Big(e[i][0].meta.variant.cbd_min_per);
				maxCBD = new Big(e[i][0].meta.variant.cbd_max_per);

Replacement in scrape/ocs.ca.js at line 125 [14.11674]

B:BD[18.4504] → [18.4504:4610]

				} else if(e[i][0].tags[j] === 'subsubcategory--Oral Sprays' && ok(minTHC, maxTHC, minCBD, maxCBD)) {

[18.4504]

[18.4610]

				} else if(e[i][0].tags[j] === 'subsubcategory--Oral Sprays') {

Replacement in scrape/ocs.ca.js at line 127 [14.11674]

B:BD[18.4694] → [18.4694:4918]

					minTHC = (new Big(minTHC)).div(10).div(quantity);
					maxTHC = (new Big(maxTHC)).div(10).div(quantity);
					minCBD = (new Big(minCBD)).div(10).div(quantity);
					maxCBD = (new Big(maxCBD)).div(10).div(quantity);

[18.4694]

[18.4918]

					minTHC = minTHC.div(10).div(quantity);
					maxTHC = maxTHC.div(10).div(quantity);
					minCBD = minCBD.div(10).div(quantity);
					maxCBD = maxCBD.div(10).div(quantity);

Replacement in scrape/ocs.ca.js at line 252 [14.11674]

B:BD[14.23255] → [18.6133:6288]

				if(ok(minCBD, maxCBD, minTHC, maxTHC, e[i][j].price, e[i][j].inventory_quantity) && (minCBD.gt(0) || maxCBD.gt(0) || minTHC.gt(0) || maxTHC.gt(0))) {

[14.23255]

[2.0]

				if(minCBD.gt(0) || maxCBD.gt(0) || minTHC.gt(0) || maxTHC.gt(0)) {

Replacement in server.js at line 25 [21.590]

B:BD[20.6294] → [10.4646:4700]

const { normalize } = require('./scrape/common.js');

[20.6294]

const { normalize, Big } = require('./scrape/common.js');

Replacement in server.js at line 264 [21.590]

B:BD[12.3177] → [10.5114:5238]

						if(notmissing(parameters, ['name', 'URL', 'address', 'city', 'region', 'country', 'postal_code'], ws, request_ID)) {

[12.3177]

[10.5238]

						if(notmissing(parameters, ['name', 'address', 'city', 'region', 'country', 'postal_code'], ws, request_ID)) {

Replacement in server.js at line 365 [21.590]

B:BD[10.9499] → [10.9499:9756]

									insert into store (name, URL, address, address2, city, region, country, postal_code, coordinate, timezone)
									values ($1, $2, $3, $4, $5, $6, $7, $8, point($${params.push(location.lat)}, $${params.push(location.lng)}), $${params.push(tz)})

[10.9499]

[7.6930]

									insert into store (name, URL, address, address2, city, region, country, postal_code, longitude, latitude, timezone)
									values ($1, $2, $3, $4, $5, $6, $7, $8, $${params.push(location.lng)}, $${params.push(location.lat)}, $${params.push(tz)})

Replacement in server.js at line 499 [21.590]

B:BD[7.7710] → [7.7710:8171]

							let params = [...normalize(parameters.brand, parameters.name, parameters.type), parameters.type, parameters.species, parameters.strain === "" ? undefined : Number(parameters.strain), parameters.description];
							let query = `with insert1 as (insert into product (producer, brand, display_name, joined_name, type, species, strain_id, description) values ($1, $2, $3, $4, $5, $6, $7, $8) on conflict do nothing returning product_id)`;//todo: terpenes

[7.7710]

[22.171]

							let [producer, brand, joined_name, display_name] = normalize(parameters.brand, parameters.name, parameters.type);
							let params = [
								producer,
								brand,
								joined_name,
								display_name,
								parameters.type,
								parameters.species,
								parameters.strain,
								parameters.description,
								parameters.terpenes
							];
							let query = `with insert1 as (insert into product (producer, brand, display_name, joined_name, type, species, strain_id, description, terpenes, show) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, true) on conflict do nothing returning product_id)`;

Replacement in server.js at line 513 [21.590]

B:BD[22.250] → [7.8172:8628]

∅:D[7.8628] → [22.783:795]

∅:D[23.251] → [22.783:795]

∅:D[24.169] → [22.783:795]

B:BD[22.783] → [22.783:795]

B:BD[22.795] → [7.8629:8668]

								let values = parameters.variants.reduce((acc, v) => {
									if(v.quantity && v.gram_equivalency) {//todo: "SELECT instead of VALUES makes sure nothing is inserted in subsidiary tables if no row is returned from a previous INSERT" since on conflict do nothing
										acc.push(`((select product_id from insert1), ${v.portions ? '$' + params.push(v.portions) : 'default'}, $${params.push(v.quantity)}, $${params.push(v.gram_equivalency)})`);
									}
									return acc;
								}, []);

[22.250]

[7.8668]

								let values;
								if(parameters.type === 'flower') {
									//default portions. gram equivalency = quantity
									values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.quantity)) {
											let pNum = params.push(v.quantity);
											acc.push(`((select product_id from insert1), default, $${pNum}, $${pNum})`);
										}
										return acc;
									}, []);
								} else if(parameters.type === 'preroll') {
									//gram equivalency = portions * quantity
									values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.quantity) && Number.isInteger(Number(v.portions))) {
											acc.push(`((select product_id from insert1), $${params.push(v.portions)}, $${params.push(v.quantity)}, $${params.push((new Big(v.quantity)).times(v.portions).toString())})`);
										}
										return acc;
									}, []);
								} else if(parameters.type === 'capsule') {
									//null quantity possible
									values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.gram_equivalency) && Number.isInteger(Number(v.portions))) {
											acc.push(`((select product_id from insert1), $${params.push(v.portions)}, ${isFinite(v.quantity) ? '$' + params.push(v.quantity) : 'null'}, $${params.push(v.gram_equivalency)})`);
										}
										return acc;
									}, []);
								} else {
									//default if falsy portions
									values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.gram_equivalency) && isFinite(v.quantity)) {
											acc.push(`((select product_id from insert1), ${v.portions ? '$' + params.push(v.portions) : 'default'}, $${params.push(v.quantity)}, $${params.push(v.gram_equivalency)}${parameters.type === 'disposable' || parameters.type === 'cartridge' ? `, ${v.flavor ? '$' + params.push(v.flavor) : 'null'}` : ''})`);
										}
										return acc;
									}, []);
								}

Replacement in server.js at line 549 [21.590]

B:BD[7.8697] → [7.8697:8901]

									query += `, insert${++q} as (insert into variant (product_id, portions, quantity, gram_equivalency) values ${values.join(', ')} on conflict do nothing)`;//haven't decided what to do with flavor

[7.8697]

[22.795]

									query += `, insert${++q} as (insert into variant (product_id, portions, quantity, gram_equivalency${parameters.type === 'disposable' || parameters.type === 'cartridge' ? ', flavor' : ''}) values ${values.join(', ')} on conflict do nothing)`;

Replacement in server.js at line 662 [21.590]

B:BD[4.5431] → [4.5431:5743]

						wack += ` 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`;

[4.5431]

[4.5743]

						wack += ` order by avg_range(thc) ${parameters.THC ? 'a' : 'de'}sc, case when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then avg_range(thc) / (min_portions + max_portions) else null end ${parameters.THC ? 'a' : 'de'}sc`;//per pack, per piece, do we need per g?

Replacement in server.js at line 664 [21.590]

B:BD[4.5798] → [4.5798:6110]

						wack += ` 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`;

[4.5798]

[4.6110]

						wack += ` order by avg_range(cbd) ${parameters.CBD ? 'a' : 'de'}sc, case when type in ('tea', 'gummy', 'mint', 'chocolate', 'baked') then avg_range(cbd) / (min_portions + max_portions) else null end ${parameters.CBD ? 'a' : 'de'}sc`;