boogerlad/mj - Change XQA3IQXSGAO2FST3F64WLVZ7JNLMQYKT3LO4SHHKYR2D765OPGHQC

update store table

Created by boogerlad on June 4, 2020

XQA3IQXSGAO2FST3F64WLVZ7JNLMQYKT3LO4SHHKYR2D765OPGHQC

Dependencies

In channels

main

Change contents

Deletion in initialize.sql at line 69 [8.17]
∅:D[6.894] → [7.0:56]
B:BD[9.480] → [7.0:56]
```
create type store_type as enum ('online', 'physical');
```
Replacement in initialize.sql at line 82 [8.17]
B:BD[10.41] → [10.41:59]
```
	osrm_hint text,
```
[10.41]
[11.141]
```
	osrm_hint_foot text,
	osrm_hint_car text,
```

Replacement in initialize.sql at line 88 [8.17]

B:BD[12.171] → [7.172:219]

B:BD[7.219] → [13.0:10]

B:BD[13.10] → [10.60:444]

∅:D[10.444] → [11.454:458]

∅:D[7.538] → [11.454:458]

B:BD[11.454] → [11.454:458]

	type store_type not null default 'physical',
	check (
		(type = 'online' and url is not null and address is null and address2 is null and city is null and postal_code is null and longitude is null and latitude is null and osrm_hint is null and timezone is null) or
		(type = 'physical' and address is not null and city is not null and postal_code is not null and longitude is not null and latitude is not null and timezone is not null)
	)

[12.171]

[14.403]

	partner boolean not null default true,
	delivery boolean not null default true,
	pickup boolean not null default true,
	prepayment boolean not null default true--right now, this means the dumb af "give me credit card number" over phone, or etransfer, but eventually will be moneris

Replacement in initialize.sql at line 448 [8.17]

B:BD[15.30] → [15.30:156]

create or replace function ios_store_id(_name text, _url text, _region citext, _country citext, out _store_id integer) as $$

[15.30]

[15.156]

create or replace function ios_store_id(
	_name text,
	_region citext,
	_country citext,
	_address citext = null,
	_address2 citext = null,
	_city citext = null,
	_postal_code citext = null,
	_url text = null,
	_longitude decimal = null,
	_latitude decimal = null,
	_osrm_hint_foot text = null,
	_osrm_hint_car text = null,
	_timezone text = null,
	_phone packed_phone_number = null,
	_partner boolean = false,
	_delivery boolean = false,
	_pickup boolean = false,
	_prepayment boolean = false,
	out _store_id integer
) as $$

Deletion in initialize.sql at line 474 [8.17]
B:BD[15.212] → [15.212:236]
```
			type = 'online' and
```
Deletion in initialize.sql at line 475 [8.17]
B:BD[15.257] → [15.257:276]
```
			url = _url and
```

Replacement in initialize.sql at line 476 [8.17]

B:BD[15.301] → [15.301:324]

			country = _country

[15.301]

[15.324]

			country = _country and
			address is not distinct from _address and
			address2 is not distinct from _address2 and
			city is not distinct from _city and
			postal_code is not distinct from _postal_code

Deletion in initialize.sql at line 485 [8.17]
B:BD[15.396] → [15.396:405]
```
			url,
```

Replacement in initialize.sql at line 487 [8.17]

B:BD[15.430] → [15.430:439]

			type

[15.430]

[15.439]

			address,
			address2,
			city,
			postal_code,
			url,
			longitude,
			latitude,
			osrm_hint_foot,
			osrm_hint_car,
			timezone,
			phone,
			partner,
			delivery,
			pickup,
			prepayment

Deletion in initialize.sql at line 504 [8.17]
B:BD[15.464] → [15.464:474]
```
			_url,
```

Replacement in initialize.sql at line 506 [8.17]

B:BD[15.501] → [15.501:514]

			'online'

[15.501]

[15.514]

			_address,
			_address2,
			_city,
			_postal_code,
			_url,
			_longitude,
			_latitude,
			_osrm_hint_foot,
			_osrm_hint_car,
			_timezone,
			_phone,
			_partner,
			_delivery,
			_pickup,
			_prepayment

Replacement in initialize.sql at line 604 [8.17]

B:BD[16.432] → [3.0:290]

create or replace function get_store(_store_id integer) returns table(name text, url text, address citext, address2 citext, city citext, region citext, country citext, postal_code citext, longitude decimal, latitude decimal, timezone text, images json, times json, physical boolean) as $$

[16.432]

[17.1103]

create or replace function get_store(_store_id integer) returns table(name text, url text, address text, images json, times json, timezone text, phone packed_phone_number, partner boolean, delivery boolean, pickup boolean, prepayment boolean) as $$

Replacement in initialize.sql at line 608 [8.17]
B:BD[17.1129] → [17.1129:1202]
B:BD[17.1202] → [10.718:745]
∅:D[10.745] → [17.1217:1230]
B:BD[17.1217] → [17.1217:1230]
```
		address,
		address2,
		city,
		region,
		country,
		postal_code,
		longitude,
		latitude,
		timezone,
```
[17.1129]
[17.1230]
```
		concat_ws(',', address,	address2, city, region,	country, postal_code),
```

Replacement in initialize.sql at line 611 [8.17]

B:BD[3.301] → [3.301:322]

		type = 'physical'

[3.301]

[17.1250]

		timezone,
		phone,
		partner,
		delivery,
		pickup,
		prepayment

Replacement in initialize.sql at line 1160 [8.17]

B:BD[18.415] → [18.415:543]

B:BD[18.543] → [5.0:148]

∅:D[5.148] → [18.693:700]

B:BD[18.693] → [18.693:700]

			'store', json_build_object(
				--distance
				--closed or open. if closed, when is it opening next?
				'id', store_id,
				'name', s.name,
				'image', (select store_image.url from store_image where store_image.store_id = s.store_id limit 1)--order by rank someday
			),

[18.415]

[18.700]

			'store', store_id,

Replacement in initialize.sql at line 1167 [8.17]
B:BD[18.886] → [18.886:934]
```
		) order by type)--display online stores last
```
[18.886]
[18.934]
```
		) order by partner)
```

Replacement in initialize.sql at line 1239 [8.17]

B:BD[4.2564] → [4.2564:2851]

					'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)

[4.2564]

[18.2411]

					'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 not store.partner and variant_id = v.variant_id)

Replacement in scrape/ocs.ca.js at line 74 [19.11674]

B:BD[19.13467] → [15.4738:4880]

	let storeID = (await postgres.query(`select ios_store_id('Ontario Cannabis Store', $1, 'ontario', 'canada')`, [url])).rows[0].ios_store_id;

[19.13467]

[2.0]

	let storeID = (await postgres.query(`select ios_store_id('Ontario Cannabis Store', 'ontario', 'canada', _url => $1, _delivery => true, _prepayment => true)`, [url])).rows[0].ios_store_id;

update store table

Dependencies

In channels

Change contents

Deletion in initialize.sql at line 69 [8.17]

Replacement in initialize.sql at line 82 [8.17]

Replacement in initialize.sql at line 88 [8.17]

Replacement in initialize.sql at line 448 [8.17]

Deletion in initialize.sql at line 474 [8.17]

Deletion in initialize.sql at line 475 [8.17]

Replacement in initialize.sql at line 476 [8.17]

Deletion in initialize.sql at line 485 [8.17]