boogerlad/mj - Change 5CESNJJQPZDHWDKA2C46FZO5VYDDHTC2ENZS6ZSIZM767IQPZ52AC

"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

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 120 [6.17]

B:BD[5.102] → [2.0:69]

create type species as enum('indica', 'sativa', 'hybrid', 'blend');

[5.102]

[7.0]

create type species as enum('indica', 'sativa', 'hybrid');

Replacement in initialize.sql at line 126 [6.17]
B:BD[8.17] → [2.70:99]
```
	s_species species not null
```
[8.17]
[5.209]
```
	species species not null
```
Insertion in initialize.sql at line 132 [6.17]
[9.55]
[10.183]
```
	check (brand != '' or producer is not null),
```

Replacement in initialize.sql at line 136 [6.17]

B:BD[11.305] → [7.126:212]

	species species not null,
	strain_id integer references strain on delete set null,

[11.305]

[10.214]

	species species,
	blend boolean not null,
	strain_id integer references strain on delete restrict,
	check (
		blend and species is not null and strain_id is null or
		not blend and (species is null) != (strain_id is null)
	),

Deletion in initialize.sql at line 147 [6.17]
B:BD[12.7012] → [9.56:103]
```
	check (brand != '' or producer is not null),
```

Replacement in initialize.sql at line 192 [6.17]

B:BD[13.1910] → [7.312:355]

	check (lower(cbd) > 0 or lower(thc) > 0)

[13.1910]

[6.3610]

	check (lower(cbd) + upper(cbd) > 0 or lower(thc) + upper(thc) > 0)

Replacement in initialize.sql at line 559 [6.17]

∅:D[9.344] → [7.472:741]

B:BD[14.642] → [7.472:741]

create or replace function ios_product_id(_producer text, _brand text, _display_name text, _joined_name citext, _type product_type, _species species, _strain citext, _description text, _show boolean, _terpenes citext[], _dosage decimal, out _product_id integer) as $$

[9.344]

[14.916]

create or replace function ios_product_id(_producer text, _brand text, _display_name text, _joined_name citext, _type product_type, _species species, _blend boolean, _strain citext, _description text, _show boolean, _terpenes citext[], _dosage decimal, out _product_id integer) as $$

Insertion in initialize.sql at line 578 [6.17]
[7.755]
[7.755]
```
			blend,
```
Insertion in initialize.sql at line 591 [6.17]
[7.785]
[7.785]
```
			_blend,
```
Insertion in initialize.sql at line 688 [6.17]
[15.60]
[9.1304]
```
	_blend boolean = null,
```
Insertion in initialize.sql at line 716 [6.17]
[7.1935]
[3.315]
```
	blend boolean,
```
Replacement in initialize.sql at line 737 [6.17]
B:BD[7.2153] → [7.2153:2165]
```
		species,
```
[7.2153]
[3.359]
```
		coalesce(product.species, strain.species),
		blend,
```
Insertion in initialize.sql at line 823 [6.17]
[15.1785]
[15.1785]
```
		(blend = _blend or _blend is null) and
```

Replacement in initialize.sql at line 964 [6.17]

B:BD[9.5721] → [9.5721:5814]

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

[9.5721]

[9.5814]

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

Insertion in initialize.sql at line 1018 [6.17]
[3.1389]
[3.1389]
```
	_blend boolean = null,
```
Insertion in initialize.sql at line 1044 [6.17]
[16.743]
[16.743]
```
	blend boolean,
```
Insertion in initialize.sql at line 1065 [6.17]
[3.2138]
[3.2138]
```
		blend,
```
Insertion in initialize.sql at line 1080 [6.17]
[3.2319]
[3.2319]
```
		_blend => _blend,
```
Insertion in initialize.sql at line 1103 [6.17]
[3.2822]
[3.2822]
```
	_blend boolean = null,
```
Insertion in initialize.sql at line 1129 [6.17]
[3.3510]
[3.3510]
```
	blend boolean,
```
Insertion in initialize.sql at line 1167 [6.17]
[16.1485]
[3.4564]
```
		blend,
```
Insertion in initialize.sql at line 1182 [6.17]
[3.4730]
[3.4730]
```
		_blend => _blend,
```
Insertion in initialize.sql at line 1222 [6.17]
[7.3445]
[7.3466]
```
	blend boolean,
```

Replacement in initialize.sql at line 1234 [6.17]

B:BD[7.3587] → [7.3587:3599]

B:BD[7.3599] → [17.22:210]

		species,
		(select strain.display_name from strain where strain.strain_id = product.strain_id),--aggregate first, then join https://stackoverflow.com/a/27626358 use subquery since small selection

[7.3587]

[17.210]

		coalesce(product.species, strain.species),
		blend,
		strain.display_name,

Replacement in initialize.sql at line 1239 [6.17]

∅:D[3.5750] → [7.3804:3926]

B:BD[7.3804] → [7.3804:3926]

		coalesce((select json_agg(destination) from product_image where product_image.product_id = product.product_id), '[]'),

[3.5750]

[7.3926]

		coalesce((select json_agg(destination) from product_image where product_image.product_id = product.product_id), '[]'),--aggregate first, then join https://stackoverflow.com/a/27626358 use subquery since small selection

Replacement in initialize.sql at line 1251 [6.17]
B:BD[7.4342] → [7.4342:4353]
```
		product
```
[7.4342]
[7.4353]
```
		product left join
		strain using (strain_id)
```
Insertion in initialize.sql at line 1317 [6.17]
[18.1607]
[18.1607]
```
	blend boolean,
```
Replacement in initialize.sql at line 1327 [6.17]
B:BD[18.1769] → [18.1769:1781]
```
		species,
```
[18.1769]
[18.1781]
```
		coalesce(product.species, strain.species),
		blend,
```

Insertion in initialize.sql at line 1528 [6.17]

[19.5454]

			'species', coalesce(product.species, strain.species),
			'blend', blend,

Insertion in initialize.sql at line 1616 [6.17]

[4.4946]

			'species', coalesce(product__as_of.species, strain__as_of.species),
			'blend', blend,

Insertion in initialize.sql at line 1703 [6.17]

[4.7732]

			'species', coalesce(product__as_of.species, strain__as_of.species),
			'blend', blend,

"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

Dependencies

In channels

Change contents

Replacement in initialize.sql at line 120 [6.17]

Replacement in initialize.sql at line 126 [6.17]

Insertion in initialize.sql at line 132 [6.17]

Replacement in initialize.sql at line 136 [6.17]

Deletion in initialize.sql at line 147 [6.17]

Replacement in initialize.sql at line 192 [6.17]

Replacement in initialize.sql at line 559 [6.17]

Insertion in initialize.sql at line 578 [6.17]

Insertion in initialize.sql at line 591 [6.17]

Insertion in initialize.sql at line 688 [6.17]

Insertion in initialize.sql at line 716 [6.17]

Replacement in initialize.sql at line 737 [6.17]

Insertion in initialize.sql at line 823 [6.17]

Replacement in initialize.sql at line 964 [6.17]

Insertion in initialize.sql at line 1018 [6.17]

Insertion in initialize.sql at line 1044 [6.17]

Insertion in initialize.sql at line 1065 [6.17]

Insertion in initialize.sql at line 1080 [6.17]

Insertion in initialize.sql at line 1103 [6.17]

Insertion in initialize.sql at line 1129 [6.17]

Insertion in initialize.sql at line 1167 [6.17]

Insertion in initialize.sql at line 1182 [6.17]

Insertion in initialize.sql at line 1222 [6.17]

Replacement in initialize.sql at line 1234 [6.17]

Replacement in initialize.sql at line 1239 [6.17]

Replacement in initialize.sql at line 1251 [6.17]

Insertion in initialize.sql at line 1317 [6.17]

Replacement in initialize.sql at line 1327 [6.17]

Insertion in initialize.sql at line 1528 [6.17]

Insertion in initialize.sql at line 1616 [6.17]

Insertion in initialize.sql at line 1703 [6.17]