boogerlad/mj - Change 4ADMC3SGJNATDR6D7WXHNZ6RD5F5BUPLPRMCEUERWRWKVZQVAO3AC

get rid of currency code, since it should be same as country. if not, we'll deal with it later. finish create store, but change to dynamic hours for lunch breaks and easier to find stores that are open. dynamic hours to be implemented

Created by kevin on January 15, 2020

4ADMC3SGJNATDR6D7WXHNZ6RD5F5BUPLPRMCEUERWRWKVZQVAO3AC

Dependencies

In channels

main

Change contents

Deletion in initialize.sql at line 33 [3.17]
B:BD[3.1134] → [3.1134:1192]
```
create type currency_abbreviation as enum('CAD', 'USD');
```
Deletion in initialize.sql at line 43 [3.17]
B:BD[3.1404] → [2.0:56]
```
	currency_abbreviation currency_abbreviation not null,
```

Replacement in initialize.sql at line 44 [3.17]

B:BD[2.85] → [2.85:448]

	monday_open time,
	monday_close time,
	tuesday_open time,
	tuesday_close time,
	wednesday_open time,
	wednesday_close time,
	thursday_open time,
	thursday_close time,
	friday_open time,
	friday_close time,
	saturday_open time,
	saturday_close time,
	sunday_open time,
	sunday_close time,
	timezone text--fuck this doesn't work for lunch breaks...

[2.85]

[3.1459]

	timezone text

Replacement in initialize.sql at line 46 [3.17]
B:BD[3.1463] → [2.449:475]
```
create table tax_store (
```
[3.1463]
[2.475]
```
create table store_tax (
```

Insertion in initialize.sql at line 52 [3.17]

[2.615]

[3.1463]

create table store_hours (
	ID serial primary key,
	store integer not null references store on delete cascade,
	day integer constraint valid_day check (day > 0 and day < 8),--does this imply not null?
	open_time time not null,
	close_time time not null
);

Replacement in server.js at line 243 [4.590]

B:BD[2.3177] → [2.3177:3446]

						try {//country match to currency abbreviation?
							let fuck = await googleMapsClient.geocode({address: `${parameters.address}, ${parameters.address2}, ${parameters.city}, ${parameters.region}, ${parameters.country}, ${parameters.postal_code}`}).asPromise();

[2.3177]

[2.3446]

						try {
							let fuck = await googleMapsClient.geocode({address: `${parameters.address}, ${parameters.address2}, ${parameters.city}, ${parameters.region}, ${parameters.country}, ${parameters.postal_code}`}).asPromise().then();

Deletion in server.js at line 246 [4.590]

B:BD[2.3509] → [2.3509:3631]

								let x = fuck.json.results[0].geometry.location.lat;
								let y = fuck.json.results[0].geometry.location.lng;

Replacement in server.js at line 248 [4.590]

B:BD[2.3785] → [2.3785:4801]

									fuck2.json.timeZoneId
									//how to determine if store is open?
									//also find timezone with api, modify time X because https://stackoverflow.com/questions/40246420/postgresql-handling-of-full-time-zones-for-timetz-data-type
									// let store = await pool.query('insert into stores values ($1, $2, $3, $4, $5, $6, $7, $8, $9, point($10, $11), $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26) returning id', [parameters.name, parameters.URL, parameters.address, parameters.address2, parameters.city, parameters.region, parameters.country, parameters.postal_code, parameters.currency_abbreviation, x, y, parameters.monday_open, parameters.monday_close, parameters.tuesday_open, parameters.tuesday_close, parameters.wednesday_open, parameters.wednesday_close, parameters.thursday_open, parameters.thursday_close, parameters.friday_open, parameters.friday_close, parameters.saturday_open, parameters.saturday_close, parameters.sunday_open, parameters.sunday_close]);

[2.3785]

[2.4801]

									let store = await pool.query('insert into store values (default, $1, $2, $3, $4, $5, $6, $7, $8, point($9, $10), $11) returning id', [
											parameters.name,
											parameters.URL,
											parameters.address,
											parameters.address2,
											parameters.city,
											parameters.region,
											parameters.country,
											parameters.postal_code,
											fuck.json.results[0].geometry.location.lat,
											fuck.json.results[0].geometry.location.lng,
											fuck2.json.timeZoneId
										]);

Replacement in server.js at line 262 [4.590]

B:BD[2.4875] → [2.4875:4934]

									// 	let query = 'insert into tax_store values ';

[2.4875]

[2.4934]

									// 	let query = 'insert into store_tax values ';

Replacement in server.js at line 271 [4.590]
B:BD[2.5327] → [2.5327:5342]
```
									// }
```
[2.5327]
[2.5342]
```
									// } I guess we'll do the same thing with hours
```