PORT=80

PORT=80
GAPI=

create type effect as enum('happy', 'calm', 'focused', 'energetic', 'sleep', 'pain');
create table strain_family_effect (
	ID serial primary key,
	name text not null unique,
	effect effect
);
insert into strain_family_effect values
	(default,'Original Glue','happy'),
	(default,'AK-47','happy'),
	(default,'Platinum GSC','calm'),
	(default,'LSD','happy'),
	(default,'Bruce Banner','happy'),
	(default,'Trainwreck','calm'),
	(default,'Sherbert','calm'),
	(default,'MasterKush','calm'),
	(default,'Strawberry Cough','calm'),
	(default,'Space Queen','calm'),
	(default,'J1','focused'),
	(default,'Snowcap','focused'),
	(default,'Dutch Hawaiian','focused'),
	(default,'Canna-Tsu','focused'),
	(default,'Galactic Jack','focused'),
	(default,'Durban Poison','energetic'),
	(default,'Golden Goat','energetic'),
	(default,'Harlequin','energetic'),
	(default,'Lamb''s Bread','energetic'),
	(default,'Cinderella 99','energetic'),
	(default,'Tahoe OG kush','sleep'),
	(default,'Lavender','sleep'),
	(default,'9 Pound Hammer','sleep'),
	(default,'Blackberry Kush','sleep'),
	(default,'Do-Si-Dos','sleep'),
	(default,'Remedy','calm'),
	(default,'God''s Gift','calm'),
	(default,'Cotton candy Kush','happy'),
	(default,'Vanilla Kush','calm'),
	(default,'Pineapple Express','happy'),
	(default,'Lemon Haze','happy'),
	(default,'Jillybean','happy'),
	(default,'ACDC','calm'),
	(default,'Flo','happy'),
	(default,'Cheese Quake','happy'),
	(default,'Blue Widow','happy'),
	(default,'Harle-Tsu','calm'),
	(default,'Plushberry','calm'),
	(default,'CBD Critical Mass',null),
	(default,'Sweet and Sour Widow',null),
	(default,'Sherbet','calm'),
	(default,'G13','happy'),
	(default,'Animal Cookies','calm'),
	(default,'Sour Diesel','happy'),
	(default,'Super Lemon Haze','happy'),
	(default,'Super Silver Haze','energetic'),
	(default,'Amnesia Haze','happy'),
	(default,'Tangerine Dream','happy'),
	(default,'White Widow','calm'),
	(default,'Blueberry','calm'),
	(default,'Candyland','calm'),
	(default,'Cannatonic','calm'),
	(default,'Kali Mist','focused'),
	(default,'Liberty Haze','focused'),
	(default,'Candy Jack','focused'),
	(default,'MediHaze','focused'),
	(default,'Green Crack','energetic'),
	(default,'Jack Herer','energetic'),
	(default,'Ghost Train Haze','energetic'),
	(default,'Northern Lights','sleep'),
	(default,'Blueberry Kush','sleep'),
	(default,'Granddaddy Purple','sleep'),
	(default,'Bubba Kush','sleep'),
	(default,'Chemdog','happy'),
	(default,'Maui Wowie','happy'),
	(default,'Island Sweet Skunk','happy'),
	(default,'Critical Mass','calm'),
	(default,'Pennywise','calm'),
	(default,'Kosher Kush','calm'),
	(default,'Sensi Star','calm'),
	(default,'Shishkaberry','calm'),
	(default,'Pink Kush','calm'),
	(default,'Wappa',null),
	(default,'Mango Haze','happy'),
	(default,'Jean Guy','happy'),
	(default,'Nordle','calm'),
	(default,'Sour Kush','happy'),
	(default,'Cold Creek Kush','calm'),
	(default,'Delahaze','energetic'),
	(default,'Warlock','calm'),
	(default,'OG Kush','happy'),
	(default,'Critical Kush','calm'),
	(default,'Hash Plant','calm'),
	(default,'SFV OG','calm'),
	(default,'Blue Dream','happy'),
	(default,'MK Ultra','calm'),
	(default,'Ultra Sour',null),
	(default,'UK Cheese','happy'),
	(default,'White Walker Kush',null),
	(default,'Star Killer','calm'),
	(default,'Sour OG','happy'),
	(default,'Headstash',null),
	(default,'Frost Monster',null),
	(default,'Afghani','calm'),
	(default,'Alien Dawg','calm'),
	(default,'All Kush',null),
	(default,'Banana Split','happy'),
	(default,'Blue Haze','happy'),
	(default,'Bubba Erkle Cookies',null),
	(default,'Buddha Haze',null),
	(default,'Buddhas Sister','calm'),
	(default,'California Orange','happy'),
	(default,'God Bud','calm'),
	(default,'CBD Shark','calm'),
	(default,'Shark Shock','calm'),
	(default,'Skunk Haze','focused'),
	(default,'Pakistani Chitral Kush','calm'),
	(default,'Chocolate Fondue',null),
	(default,'Chocolate Thai','happy'),
	(default,'City Lights',null),
	(default,'Dancehall',null),
	(default,'Durga Mata II',null),
	(default,'Durga Mata',null),
	(default,'Gold Kush',null),
	(default,'Great White Shark','happy'),
	(default,'Ice Cream','happy'),
	(default,'Ken''s Kush',null),
	(default,'LA Confidential','calm'),
	(default,'Lemon Skunk','energetic'),
	(default,'Mongolian',null),
	(default,'Ocean View',null),
	(default,'Quantum Kush','happy'),
	(default,'Royal Purple Kush',null),
	(default,'Spoetnik #1',null),
	(default,'Strawberry Banana','calm'),
	(default,'Super Skunk','calm'),
	(default,'Treasure Island',null),
	(default,'Wabanaki',null),
	(default,'Royal Highness',null),
	(default,'Rockstar','calm'),
	(default,'Brian Berry Citrus Blend',null),
	(default,'brian berry cough',null),
	(default,'Sour Tangie','happy'),
	(default,'Hindu Kush','sleep'),
	(default,'Larry OG','happy'),
	(default,'Conspiracy Kush','calm'),
	(default,'NYC Diesel','happy'),
	(default,'Texada Timewarp',null),
	(default,'Lemon Thai','energetic'),
	(default,'Atomical Haze',null),
	(default,'Belladonna',null),
	(default,'Purple Kush','sleep'),
	(default,'CBD Critical Cure','calm'),
	(default,'Headband','happy'),
	(default,'White Russian','happy'),
	(default,'Strawberry Ice',null),
	(default,'Acadia',null),
	(default,'Sunset Haze',null),
	(default,'nana''s fix',null),
	(default,'Critical Plus','calm'),
	(default,'Mango','calm'),
	(default,'GSC','calm'),
	(default,'afghani kush','sleep'),
	(default,'Josh D Og',null),
	(default,'Orange Cookies','calm'),
	(default,'Raskal OG','calm'),
	(default,'jack haze',null),
	(default,'White Rhino','calm'),
	(default,'Intergalactic','happy'),
	(default,'white castle',null),
	(default,'afghan kush','sleep'),
	(default,'Glueberry Og','energetic'),
	(default,'cinderella jack','calm'),
	(default,'orange bud','happy'),
	(default,'Sinmint Cookies','calm');

	joined_brand text not null,
	joined_name text not null,

	joined_brand citext not null,
	joined_name citext not null,

	display_producer text,

	producer text,

	display_strain text not null,
	display_description text not null,

	strain text not null,
	strain_family integer references strain_family_effect on delete cascade,
	description text not null,

const googleMapsClient = require('@google/maps').createClient({key: 'AIzaSyDcUB69niG5Boyt4eAb-DkzlLagsqDAPp4', Promise: Promise});

const googleMapsClient = require('@google/maps').createClient({key: process.env.GAPI, Promise: Promise});

const inBrackets = /\s*\(.*\)\s*/;
const specialqty = /((\d+)\s*[Xx]\s*)?(\d*\.?\d+)\s*([A-WYZa-wyz]{1,2})(\b|$)/;
function normalize(brand, title, type) {
	let ot = title.toLowerCase();
	title = title.replace(brand, '');
	brand = brand.toLowerCase().replace('.', '').replace(/&|(\b(and|health|therapeutics|co|company|inc|cannabis)\b)/g, '').trim();
	if(brand.includes('sundial')) {
		brand = brand.replace(/\b(calm|ease|flow|lift|spark)\b/g, '').trim();
		title = title.replace(/\b(calm|ease|flow|lift|spark)\b/g, '').trim();
	} else if(brand === 'alta vie') {
		brand = 'altavie';
	} else if(brand === 'twd') {
		brand = 'tweed';
	}
	let ratio = title.match(/\d+:\d+/);
	let q = title.match(specialqty);
	title = title
		.toLowerCase()
		.replace(inBrackets, '')
		.replace(brand, '')
		.replace(/twd(\.?)|"|-|−|(\d+:\d+)|%|&|:/g, '')
		.replace(/\b(liquid|and|oral|drop(s?)|((hard|soft|liquid)(-|−| )?)?(capsule|cap|gel)(s?)|pre(-|−| )?roll(s?)|pack(s?)|joint(s?)|oil|flower|spray)\b/g, '')
		.replace(specialqty, '')
		.trim();
	if(ot.includes('fiveup') || /5\s*up/.test(ot)) {
		title = '5up';
		//early return?
	} else if(ot.includes('tenup') || /10\s*up/.test(ot)) {
		title = '10up';
		//early return?
	} else if(title.includes('reserve') && brand.includes('edison')) {
		title = title.replace('reserve', '').trim();
		brand = 'edison reserve';
	} else if(title.includes('select') && brand.includes('canaca')) {
		title = title.replace('select', '').trim();
		brand = 'canaca select';
	} else if(brand === 'tantalus labs') {
		title = title.replace(/bc|sungrown/g, '').trim();
	}
	if(title.includes('casa') && title.includes('blanca') && brand.includes('edison')) {
		title = 'casablanca';
	}
	if(type === 'oil' || type === 'spray') {
		title = title.replace('mist', '').trim();
	}
	if(title.length === 0) {
		if(ratio === null) {
			title = ot;
		} else {
			title = ratio[0];
		}
	}
	if(type === 'capsule' && q !== null) {
		title += ' ' + q[0].replace(/\s+/, '');
	}
	title = title.split(/\s+/).sort().join(' ');
	return [brand, title, type];
}

					}));
				}
				break;
			case 'strain_families':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: (await pool.query('select id, name from strain_family_effect')).rows
						}));
					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'forbidden'
						}));
					}
				} else {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthorized'
					}));
				}
				break;
			case 'create_product':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {
						try {
							let j = normalize(parameters.brand, parameters.name, parameters.type);
							let product = await pool.query('insert into product values (default, $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) returning id', [
								...j,
								parameters.concentration_unit,
								parameters.measurement_unit,
								parameters.brand,
								parameters.producer,
								parameters.name,
								parameters.strain,
								parameters.strain_family === "" ? undefined : Number(parameters.strain_family),
								parameters.description,
								true
							]);
							ws.send(JSON.stringify({
								response_ID: request_ID
							}));
						} catch(e) {
							console.error(e);
							ws.send(JSON.stringify({
								response_ID: request_ID,
								data: 'check log'
							}));
						}
					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'forbidden'
						}));
					}
				} else {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthorized'

			case 'products':
				//for sort by thc, cbd, price, need to join with variant, menu items as well
				//simple case is return all though :)
				ws.send(JSON.stringify({
					response_ID: request_ID,
					data: (await pool.query('select product.id, type, display_brand, producer, display_name, strain, strain_family_effect.name as strain_family from product left outer join strain_family_effect on (product.strain_family = strain_family_effect.id) where show = true')).rows
				}));
				break;
			case 'product':
				//join with variant, menu items
				break;