boogerlad/mj - Change NBNPI4ATCXHIMKSXW5VRS3KM4WJZZMOPD7H4QTDNOQFRSQYFSIBAC

fuck it client side stores since shimple enough

Created by boogerlad on June 4, 2020

NBNPI4ATCXHIMKSXW5VRS3KM4WJZZMOPD7H4QTDNOQFRSQYFSIBAC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 604 [5.17]

B:BD[4.432] → [2.1531:1781]

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 $$

[4.432]

[6.1103]

create or replace function get_stores() returns table(
	id integer,
	name text,
	url text,
	address text,
	longitude decimal,
	latitude decimal,
	images json,
	times json,
	timezone text,
	phone packed_phone_number,
	partner boolean,
	delivery boolean,
	pickup boolean,
	prepayment boolean
) as $$

Insertion in initialize.sql at line 621 [5.17]
[6.1112]
[6.1112]
```
		store_id,
```
Insertion in initialize.sql at line 625 [5.17]
[2.1856]
[6.1230]
```
		longitude,
		latitude,
```
Deletion in initialize.sql at line 656 [5.17]
B:BD[6.1673] → [6.1673:1705]
```
	where
		store_id = _store_id
```

Replacement in server.js at line 504 [7.590]

B:BD[3.1643] → [3.1643:1827]

				let stores = (await pool.query(`select distinct on(store_id) store_id, name, longitude, latitude, store_image.url from store left outer join store_image using (store_id)`)).rows;

[3.1643]

[3.1827]

				let stores = (await pool.query(`select * from get_stores()`)).rows;

Deletion in server.js at line 546 [7.590]

∅:D[3.3786] → [8.492:609]

B:BD[9.533] → [8.492:609]

B:BD[8.609] → [6.7227:7309]

∅:D[6.7309] → [8.1416:1585]

B:BD[8.1416] → [8.1416:1585]

∅:D[8.1585] → [10.1028:1035]

B:BD[10.1028] → [10.1028:1035]

B:BD[10.1035] → [8.1586:1674]

∅:D[8.1674] → [10.1035:1047]

B:BD[10.1035] → [10.1035:1047]

B:BD[10.1047] → [8.1675:1681]

			case 'store': {
				let s = Number(parameters.id);
				let data = 'invalid id';
				if(Number.isInteger(s)) {
					let response = (await pool.query(`select * from get_store($1)`, [s])).rows;
					if(response.length === 0) {
						data = 'store not found';
					} else {
						data = response[0];
						//ws.subscribe('store/' + parameters.store);
					}
				}
				ws.send(JSON.stringify({
					response_ID: request_ID,
					data: data
				}));
				break;
			}