boogerlad/mj - Change VKFRSWSYYX7JNFGTWLWYTIALQJTOWKEDUISIJY4VLYOHHAE3EWCAC

buildfix and fix potential runtime error in ios_product_id where species is defined twice

Created by boogerlad on August 23, 2020

VKFRSWSYYX7JNFGTWLWYTIALQJTOWKEDUISIJY4VLYOHHAE3EWCAC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 584 [4.17]
B:BD[3.1359] → [3.1359:1373]
```
		) values (
```
[3.1359]
[3.1373]
```
		)
		select
```
Replacement in initialize.sql at line 591 [4.17]
B:BD[3.1448] → [5.771:785]
```
			_species,
```
[3.1448]
[2.740]
```
			case when strain_id is null then _species end,
```
Replacement in initialize.sql at line 593 [4.17]
∅:D[2.752] → [5.785:849]
B:BD[5.785] → [5.785:849]
```
			(select strain_id from strain where joined_name = _strain),
```
[2.752]
[3.1546]
```
			strain_id,
```

Replacement in initialize.sql at line 598 [4.17]

B:BD[3.1602] → [3.1602:1630]

		) on conflict do nothing

[3.1602]

[3.1630]

		from strain
		where joined_name = _strain
		on conflict do nothing

Replacement in initialize.sql at line 825 [4.17]

B:BD[6.2127] → [7.1732:1785]

		(species = any(_species) or _species is null) and

[6.2127]

[2.854]

		(coalesce(product.species, strain.species) = any(_species) or _species is null) and

Replacement in initialize.sql at line 966 [4.17]

B:BD[6.5649] → [6.5649:5721]

B:BD[6.5721] → [2.897:992]

			when x = 'sleep' then species = 'indica' and thc2tc(thc, cbd) >= .1
			when x = 'calm' then (species in ('indica', 'hybrid') or blend) and thc2tc(thc, cbd) <= .6

[6.5649]

[6.5814]

			when x = 'sleep' then coalesce(product.species, strain.species) = 'indica' and thc2tc(thc, cbd) >= .1
			when x = 'calm' then (coalesce(product.species, strain.species) in ('indica', 'hybrid') or blend) and thc2tc(thc, cbd) <= .6

Replacement in initialize.sql at line 969 [4.17]

B:BD[6.5874] → [6.5874:6045]

B:BD[6.6045] → [7.3855:3973]

			when x = 'happy' then species = 'sativa' or species = 'hybrid' and thc2tc(thc, cbd) >= .35
			when x = 'energetic' then species = 'sativa' and thc2tc(thc, cbd) >= .1
			when x = 'focused' then species = 'hybrid' and thc2tc(thc, cbd) between .25 and .7 or species = 'sativa' and case

[6.5874]

[8.2295]

			when x = 'happy' then coalesce(product.species, strain.species) = 'sativa' or coalesce(product.species, strain.species) = 'hybrid' and thc2tc(thc, cbd) >= .35
			when x = 'energetic' then coalesce(product.species, strain.species) = 'sativa' and thc2tc(thc, cbd) >= .1
			when x = 'focused' then coalesce(product.species, strain.species) = 'hybrid' and thc2tc(thc, cbd) between .25 and .7 or coalesce(product.species, strain.species) = 'sativa' and case