boogerlad/mj - Change 47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC

rename _in_stock to in_stock fuzzy searching products across producer, brand and name filter by species order by price add endpoint to get valid enum values for product search

Created by boogerlad on March 26, 2020

47JKAGWEDSPFXKMFOVMTEYGUFFS5SEJMNZIZPJJAWJ5U3CH5YGMQC

Dependencies

In channels

main

Change contents

Insertion in initialize.sql at line 17 [4.17]
[2.47]
[3.413]
```
create extension if not exists pg_trgm;
```

Replacement in initialize.sql at line 574 [4.17]

B:BD[5.1793] → [6.0:27]

	_user_id integer = null,

[5.1793]

[6.27]

	--_user_id integer = null,
	_species species = null,
	_effect effect = null,--not working yet

Replacement in initialize.sql at line 579 [4.17]

B:BD[2.292] → [2.292:319]

	_in_stock boolean = null

[2.292]

[5.1819]

	in_stock boolean = null,
	sort_price boolean = null,--true asc, false desc, null don't sort by it
	sort_thc boolean = null,--not working yet
	sort_cbd boolean = null,--not working yet
	sort_rank boolean = null,--contingent on ranking
	search text = null

Replacement in initialize.sql at line 638 [4.17]

B:BD[2.383] → [2.383:459]

					when _in_stock then stock > 0
					when not _in_stock then stock = 0

[2.383]

[2.459]

					when in_stock then stock > 0
					when not in_stock then stock = 0

Replacement in initialize.sql at line 648 [4.17]

B:BD[6.158] → [6.158:193]

∅:D[6.193] → [5.3118:3227]

B:BD[5.3118] → [5.3118:3227]

		(type = _type or _type is null)
		--brand ilike $1
	--order by cbd, thc, min_price, etc. idk if ranges are sortable... looks like they are

[6.158]

[2.485]

		(type = _type or _type is null) and
		(species = _species or _species is null)
	order by
		word_similarity(concat_ws(' ', producer, brand, product.display_name), lower(search)),
		case when sort_price then min end asc,
		case when not sort_price then min end desc

Replacement in initialize.sql at line 658 [4.17]
B:BD[2.600] → [2.600:627]
```
	_in_stock boolean = null
```
[2.600]
[2.627]
```
	in_stock boolean = null
```

Replacement in initialize.sql at line 728 [4.17]

B:BD[2.2361] → [2.2361:2437]

					when _in_stock then stock > 0
					when not _in_stock then stock = 0

[2.2361]

[2.2437]

					when in_stock then stock > 0
					when not in_stock then stock = 0

Insertion in server.js at line 545 [7.590]

[6.362]

			case 'productsq':
				const [strains, pgenum] = await Promise.all([
					pool.query('select strain_id as id, display_name as name from strain').then(x => x.rows),
					pool.query(`select
						array_to_json(enum_range(null::species)) as species,
						array_to_json(enum_range(null::product_type)) as product_types,
						array_to_json(enum_range(null::effect)) as effects,
						array_to_json(enum_range(null::comt)) as comt,
						array_to_json(enum_range(null::akt1)) as akt1,
						array_to_json(enum_range(null::cyp2c9)) as cyp2c9,
						array_to_json(enum_range(null::cyp2c19_2)) as cyp2c19_2,
						array_to_json(enum_range(null::cyp2c19_3)) as cyp2c19_3,
						array_to_json(enum_range(null::cyp2c19_17)) as cyp2c19_17
					`).then(x => x.rows[0])
				]);
				ws.send(JSON.stringify({
					response_ID: request_ID,
					data: {strains, ...pgenum}
				}));
				break;

Insertion in server.js at line 579 [7.590]

[8.395]

[2.3628]

					}
					if(typeof parameters.species === 'string') {
						qs += `_species => $${params.push(parameters.species)},`;
					}
					if(typeof parameters.search === 'string') {
						qs += `search => $${params.push(parameters.search)},`;

Replacement in server.js at line 587 [7.590]

B:BD[2.3689] → [2.3689:3756]

						qs += `_in_stock => $${params.push(parameters.in_stock)},`;

[2.3689]