boogerlad/mj - Change Y5J5F72VRDZQYJJPD4UPS4I4VHWBXN22FATHE5EZNN5Q7Q4NBLUAC

fuck roz

Created by boogerlad on November 25, 2020

Y5J5F72VRDZQYJJPD4UPS4I4VHWBXN22FATHE5EZNN5Q7Q4NBLUAC

Dependencies

In channels

main

Change contents

File deletion: gene2jane.js

BF:BFD[1.0] → [8.0:14]

BF:BFD[8.14] → [8.15:15]

B:BD[8.15] → [8.16:1348]

const { Pool } = require('pg');
const pool = new Pool();
require('dotenv').config();
require('fs').readFileSync(0).toString().slice(0, -1).split('\n').forEach(l => {
	let [email, hash, genes] = l.split('\t');
	genes = new Map(genes.slice(1, -1).split(',').map(r => {
		let k = r.split('_');
		let v = k.pop();
		k = k.join('_');
		if(v === 'vv') {
			v = 'Val/Val';
		} else if(v === 'vm') {
			v = 'Val/Met';
		} else if(v === 'mm') {
			v = 'Met/Met';
		} else if(v === 'inc') {
			v = 'inconclusive';
		} else if(v === 'tt') {
			v = 'T/T';
		} else if(v === 'ct') {
			v = 'C/T';
		} else if(v === 'cc') {
			v = 'C/C';
		} else if(v === '11') {
			v = '*1/*1';
		} else if(v === '13') {
			v = '*1/*3';
		} else if(v === '33') {
			v = '*3/*3';
		} else if(v === '12') {
			v = '*1/*2';
		} else if(v === '22') {
			v = '*2/*2';
		} else if(v === '117') {
			v = '*1/*17';
		} else if(v === '1717') {
			v = '*17/*17';
		}
		return [k, v]
	}));
	let keys = [...genes.keys()];
	let values = [...genes.values()];
	try {
		pool.query(
			`insert into usr (email, webportal_hash, ${keys.join(',')})
			values ($1, $2, ${values.map((_, i) => '$' + (i + 3)).join(',')})
			on conflict (email) do nothing`,
			[email, hash].concat(values)
		);
	} catch(e) {
		console.log(e);
	}
});

Deletion in initialize.sql at line 128 [11.17]
∅:D[9.1330] → [10.15:102]
∅:D[12.6076] → [10.15:102]
B:BD[11.1134] → [10.15:102]
```
create type effect as enum('happy', 'calm', 'focused', 'energetic', 'sleep', 'pain');
```
Deletion in initialize.sql at line 133 [11.17]
B:BD[12.6182] → [13.0:17]
```
	effect effect,
```

Replacement in initialize.sql at line 212 [11.17]

B:BD[11.4351] → [8.1349:1461]

	webportal_hash text,
	passphrase_hash text,
	check ((webportal_hash is null) != (passphrase_hash is null)),

[11.4351]

[11.4389]

	passphrase_hash not null text,

Deletion in initialize.sql at line 224 [11.17]
∅:D[14.1444] → [15.3054:3143]
B:BD[16.248] → [15.3054:3143]
B:BD[15.3143] → [17.30:55]
```
	comt comt,
	akt1 akt1,
	cyp2c9 cyp2c9,
	cyp2c19_2 cyp2c19_2,
	cyp2c19_3 cyp2c19_3,
	cyp2c19_17 cyp2c19_17,
```

Replacement in initialize.sql at line 299 [11.17]

B:BD[18.471] → [13.45:2983]

B:BD[13.2983] → [6.0:117]

∅:D[6.117] → [13.3100:4418]

B:BD[13.3100] → [13.3100:4418]

B:BD[13.4418] → [6.118:174]

∅:D[6.174] → [13.4474:5207]

B:BD[13.4474] → [13.4474:5207]

B:BD[13.5207] → [6.175:229]

∅:D[6.229] → [13.5261:9236]

B:BD[13.5261] → [13.5261:9236]

B:BD[13.9236] → [6.230:275]

∅:D[6.275] → [13.9281:10495]

B:BD[13.9281] → [13.9281:10495]

	(default, 'Original Glue', 'glueoriginal', 'happy', 'sativa'),
	(default, 'AK-47', 'ak47', 'happy', 'sativa'),
	(default, 'Platinum GSC', 'gscplatinum', 'calm', 'sativa'),
	(default, 'LSD', 'lsd', 'happy', 'sativa'),
	(default, 'Bruce Banner', 'bannerbruce', 'happy', 'sativa'),
	(default, 'Trainwreck', 'trainwreck', 'calm', 'sativa'),
	(default, 'Sherbert', 'sherbert', 'calm', 'sativa'),
	(default, 'MasterKush', 'masterkush', 'calm', 'sativa'),
	(default, 'Strawberry Cough', 'coughstrawberry', 'calm', 'sativa'),
	(default, 'Space Queen', 'queenspace', 'calm', 'sativa'),
	(default, 'J1', 'j1', 'focused', 'sativa'),
	(default, 'Snowcap', 'snowcap', 'focused', 'sativa'),
	(default, 'Dutch Hawaiian', 'dutchhawaiian', 'focused', 'sativa'),
	(default, 'Canna-Tsu', 'cannatsu', 'focused', 'sativa'),
	(default, 'Galactic Jack', 'galacticjack', 'focused', 'sativa'),
	(default, 'Durban Poison', 'durbanpoison', 'energetic', 'sativa'),
	(default, 'Golden Goat', 'goatgolden', 'energetic', 'sativa'),
	(default, 'Harlequin', 'harlequin', 'energetic', 'sativa'),
	(default, 'Lamb''s Bread', 'breadlambs', 'energetic', 'sativa'),
	(default, 'Cinderella 99', '99cinderella', 'energetic', 'sativa'),
	(default, 'Tahoe OG Kush', 'kushogtahoe', 'sleep', 'hybrid'),
	(default, 'Lavender', 'lavender', 'sleep', 'indica'),
	(default, '9 Pound Hammer', '9hammerpound', 'sleep', 'indica'),
	(default, 'Blackberry Kush', 'blackberrykush', 'sleep', 'indica'),
	(default, 'Do-Si-Dos', 'dosidos', 'sleep', 'indica'),
	(default, 'Remedy', 'remedy', 'calm', 'indica'),
	(default, 'God''s Gift', 'giftgods', 'calm', 'indica'),
	(default, 'Cotton candy Kush', 'candycottonkush', 'happy', 'hybrid'),
	(default, 'Vanilla Kush', 'kushvanilla', 'calm', 'indica'),
	(default, 'Pineapple Express', 'expresspineapple', 'happy', 'hybrid'),
	(default, 'Lemon Haze', 'hazelemon', 'happy', 'sativa'),
	(default, 'Jillybean', 'jillybean', 'happy', 'hybrid'),
	(default, 'ACDC', 'acdc', 'calm', 'sativa'),
	(default, 'Flo', 'flo', 'happy', 'hybrid'),
	(default, 'Cheese Quake', 'cheesequake', 'happy', 'hybrid'),
	(default, 'Blue Widow', 'bluewidow', 'happy', 'hybrid'),
	(default, 'Harle-Tsu', 'harletsu', 'calm', 'hybrid'),
	(default, 'Plushberry', 'plushberry', 'calm', 'indica'),
	(default, 'CBD Critical Mass', 'cbdcriticalmass', null, 'indica'),
	(default, 'Sweet and Sour Widow', 'andsoursweetwidow', null, 'indica'),
	(default, 'Sherbet', 'sherbet', 'calm', 'hybrid'),
	(default, 'G13', 'g13', 'happy', 'indica'),
	(default, 'Animal Cookies', 'animalcookies', 'calm', 'hybrid'),
	(default, 'Sour Diesel', 'dieselsour', 'happy', 'sativa'),
	(default, 'Super Lemon Haze', 'hazelemonsuper', 'happy', 'sativa'),
	(default, 'Super Silver Haze', 'hazesilversuper', 'energetic', 'sativa'),
	(default, 'Amnesia Haze', 'amnesiahaze', 'happy', 'sativa'),
	(default, 'Tangerine Dream', 'dreamtangerine', 'happy', 'sativa'),
	(default, 'White Widow', 'whitewidow', 'calm', 'hybrid'),
	(default, 'Blueberry', 'blueberry', 'calm', 'indica'),
	(default, 'Candyland', 'candyland', 'calm', 'sativa'),
	(default, 'Cannatonic', 'cannatonic', 'calm', 'sativa'),
	(default, 'Kali Mist', 'kalimist', 'focused', 'sativa'),
	(default, 'Liberty Haze', 'hazeliberty', 'focused', 'sativa'),
	(default, 'Candy Jack', 'candyjack', 'focused', 'sativa'),
	(default, 'MediHaze', 'medihaze', 'focused', 'sativa'),
	(default, 'Green Crack', 'crackgreen', 'energetic', 'sativa'),
	(default, 'Jack Herer', 'hererjack', 'energetic', 'sativa'),
	(default, 'Ghost Train Haze', 'ghosthazetrain', 'energetic', 'sativa'),
	(default, 'Northern Lights', 'lightsnorthern', 'sleep', 'indica'),
	(default, 'Blueberry Kush', 'blueberrykush', 'sleep', 'indica'),
	(default, 'Granddaddy Purple', 'granddaddypurple', 'sleep', 'indica'),
	(default, 'Bubba Kush', 'bubbakush', 'sleep', 'indica'),
	(default, 'Chemdog', 'chemdog', 'happy', 'hybrid'),
	(default, 'Maui Wowie', 'mauiwowie', 'happy', 'sativa'),
	(default, 'Island Sweet Skunk', 'islandskunksweet', 'happy', 'sativa'),
	(default, 'Critical Mass', 'criticalmass', 'calm', 'indica'),
	(default, 'Pennywise', 'pennywise', 'calm', 'indica'),
	(default, 'Kosher Kush', 'kosherkush', 'calm', 'indica'),
	(default, 'Sensi Star', 'sensistar', 'calm', 'indica'),
	(default, 'Shishkaberry', 'shishkaberry', 'calm', 'indica'),
	(default, 'Pink Kush', 'kushpink', 'calm', 'indica'),
	(default, 'Wappa', 'wappa', null, 'hybrid'),
	(default, 'Mango Haze', 'hazemango', 'happy', 'sativa'),
	(default, 'Jean Guy', 'guyjean', 'happy', 'hybrid'),
	(default, 'Nordle', 'nordle', 'calm', 'indica'),
	(default, 'Sour Kush', 'kushsour', 'happy', 'hybrid'),
	(default, 'Cold Creek Kush', 'coldcreekkush', 'calm', 'hybrid'),
	(default, 'Delahaze', 'delahaze', 'energetic', 'sativa'),
	(default, 'Warlock', 'warlock', 'calm', 'hybrid'),
	(default, 'OG Kush', 'kushog', 'happy', 'hybrid'),
	(default, 'Critical Kush', 'criticalkush', 'calm', 'indica'),
	(default, 'Hash Plant', 'hashplant', 'calm', 'indica'),
	(default, 'SFV OG', 'ogsfv', 'calm', 'hybrid'),
	(default, 'Blue Dream', 'bluedream', 'happy', 'hybrid'),
	(default, 'MK Ultra', 'mkultra', 'calm', 'sativa'),
	(default, 'Ultra Sour', 'sourultra', null, 'hybrid'),
	(default, 'UK Cheese', 'cheeseuk', 'happy', 'hybrid'),
	(default, 'White Walker Kush', 'kushwalkerwhite', null, 'hybrid'),
	(default, 'Star Killer', 'killerstar', 'calm', 'indica'),
	(default, 'Sour OG', 'ogsour', 'happy', 'hybrid'),
	(default, 'Headstash', 'headstash', null, 'indica'),
	(default, 'Frost Monster', 'frostmonster', null, 'hybrid'),
	(default, 'Afghani', 'afghani', 'calm', 'indica'),
	(default, 'Alien Dawg', 'aliendawg', 'calm', 'indica'),
	(default, 'All Kush', 'allkush', null, 'indica'),
	(default, 'Banana Split', 'bananasplit', 'happy', 'hybrid'),
	(default, 'Blue Haze', 'bluehaze', 'happy', 'hybrid'),
	(default, 'Bubba Erkle Cookies', 'bubbacookieserkle', null, 'hybrid'),
	(default, 'Buddha Haze', 'buddhahaze', null, 'sativa'),
	(default, 'Buddhas Sister', 'buddhassister', 'calm', 'indica'),
	(default, 'California Orange', 'californiaorange', 'happy', 'hybrid'),
	(default, 'God Bud', 'budgod', 'calm', 'indica'),
	(default, 'CBD Shark', 'cbdshark', 'calm', 'indica'),
	(default, 'Shark Shock', 'sharkshock', 'calm', 'indica'),
	(default, 'Skunk Haze', 'hazeskunk', 'focused', 'hybrid'),
	(default, 'Pakistani Chitral Kush', 'chitralkushpakistani', 'calm', 'indica'),
	(default, 'Chocolate Fondue', 'chocolatefondue', null, 'sativa'),
	(default, 'Chocolate Thai', 'chocolatethai', 'happy', 'sativa'),
	(default, 'City Lights', 'citylights', null, 'hybrid'),
	(default, 'Dancehall', 'dancehall', null, 'hybrid'),
	(default, 'Durga Mata II', '2durgamata', null, 'hybrid'),
	(default, 'Durga Mata', 'durgamata', null, 'indica'),
	(default, 'Gold Kush', 'goldkush', null, 'indica'),
	(default, 'Great White Shark', 'greatsharkwhite', 'happy', 'sativa'),
	(default, 'Ice Cream', 'creamice', 'happy', 'indica'),
	(default, 'Ken''s Kush', 'kenskush', null, 'hybrid'),
	(default, 'LA Confidential', 'confidentialla', 'calm', 'indica'),
	(default, 'Lemon Skunk', 'lemonskunk', 'energetic', 'hybrid'),
	(default, 'Mongolian', 'mongolian', null, 'indica'),
	(default, 'Ocean View', 'oceanview', null, 'sativa'),
	(default, 'Quantum Kush', 'kushquantum', 'happy', 'sativa'),
	(default, 'Royal Purple Kush', 'kushpurpleroyal', null, 'indica'),
	(default, 'Spoetnik #1', '1spoetnik', null, 'indica'),
	(default, 'Strawberry Banana', 'bananastrawberry', 'calm', 'hybrid'),
	(default, 'Super Skunk', 'skunksuper', 'calm', 'indica'),
	(default, 'Treasure Island', 'islandtreasure', null, 'hybrid'),
	(default, 'Wabanaki', 'wabanaki', null, 'sativa'),
	(default, 'Royal Highness', 'highnessroyal', null, 'hybrid'),
	(default, 'Rockstar', 'rockstar', 'calm', 'indica'),
	(default, 'Brian Berry Citrus Blend', 'berryblendbriancitrus', null, 'hybrid'),
	(default, 'brian berry cough', 'berrybriancough', null, 'hybrid'),
	(default, 'Sour Tangie', 'sourtangie', 'happy', 'sativa'),
	(default, 'Hindu Kush', 'hindukush', 'sleep', 'indica'),
	(default, 'Larry OG', 'larryog', 'happy', 'hybrid'),
	(default, 'Conspiracy Kush', 'conspiracykush', 'calm', 'indica'),
	(default, 'NYC Diesel', 'dieselnyc', 'happy', 'sativa'),
	(default, 'Texada Timewarp', 'texadatimewarp', null, 'sativa'),
	(default, 'Lemon Thai', 'lemonthai', 'energetic', 'sativa'),
	(default, 'Atomical Haze', 'atomicalhaze', null, 'sativa'),
	(default, 'Belladonna', 'belladonna', null, 'hybrid'),
	(default, 'Purple Kush', 'kushpurple', 'sleep', 'indica'),
	(default, 'CBD Critical Cure', 'cbdcriticalcure', 'calm', 'indica'),
	(default, 'Headband', 'headband', 'happy', 'hybrid'),
	(default, 'White Russian', 'russianwhite', 'happy', 'hybrid'),
	(default, 'Strawberry Ice', 'icestrawberry', null, 'sativa'),
	(default, 'Acadia', 'acadia', null, 'sativa'),
	(default, 'Sunset Haze', 'hazesunset', null, 'hybrid'),
	(default, 'Nana''s Fix', 'fixnanas', null, 'hybrid'),
	(default, 'Critical Plus', 'criticalplus', 'calm', 'hybrid'),
	(default, 'Mango', 'mango', 'calm', 'indica'),
	(default, 'GSC', 'gsc', 'calm', 'indica'),
	(default, 'Josh D OG', 'djoshog', null, 'indica'),
	(default, 'Orange Cookies', 'cookiesorange', 'calm', 'hybrid'),
	(default, 'Raskal OG', 'ograskal', 'calm', 'hybrid'),
	(default, 'Jack Haze', 'hazejack', null, 'sativa'),
	(default, 'White Rhino', 'rhinowhite', 'calm', 'indica'),
	(default, 'Intergalactic', 'intergalactic', 'happy', 'hybrid'),
	(default, 'White Castle', 'castlewhite', null, 'hybrid'),
	(default, 'Afghan Kush', 'afghankush', 'sleep', 'indica'),
	(default, 'Glueberry OG', 'glueberryog', 'energetic', 'sativa'),
	(default, 'Cinderella Jack', 'cinderellajack', 'calm', 'hybrid'),
	(default, 'Orange Bud', 'budorange', 'happy', 'hybrid'),
	(default, 'Sinmint Cookies', 'cookiessinmint', 'calm', 'hybrid'),
	(default, 'Chocolope', 'chocolope', null, 'sativa'),
	(default, 'Moby Dick', 'dickmoby', null, 'sativa'),
	(default, 'Moonbeam', 'moonbeam', null, 'indica'),
	(default, 'Purple Haze', 'hazepurple', null, 'sativa'),
	(default, 'Riverview Ride', 'rideriverview', null, 'indica'),
	(default, 'Rockstar Kush', 'kushrockstar', null, 'indica'),
	(default, 'Sweet Deep Grapefruit', 'deepgrapefruitsweet', null, 'indica'),
	(default, 'Zkittlez', 'zkittlez', null, 'indica');

[18.471]

[19.0]

	(default, 'Original Glue', 'glueoriginal', 'sativa'),
	(default, 'AK-47', 'ak47', 'sativa'),
	(default, 'Platinum GSC', 'gscplatinum', 'sativa'),
	(default, 'LSD', 'lsd', 'sativa'),
	(default, 'Bruce Banner', 'bannerbruce', 'sativa'),
	(default, 'Trainwreck', 'trainwreck', 'sativa'),
	(default, 'Sherbert', 'sherbert', 'sativa'),
	(default, 'MasterKush', 'masterkush', 'sativa'),
	(default, 'Strawberry Cough', 'coughstrawberry', 'sativa'),
	(default, 'Space Queen', 'queenspace', 'sativa'),
	(default, 'J1', 'j1', 'sativa'),
	(default, 'Snowcap', 'snowcap', 'sativa'),
	(default, 'Dutch Hawaiian', 'dutchhawaiian', 'sativa'),
	(default, 'Canna-Tsu', 'cannatsu', 'sativa'),
	(default, 'Galactic Jack', 'galacticjack', 'sativa'),
	(default, 'Durban Poison', 'durbanpoison', 'sativa'),
	(default, 'Golden Goat', 'goatgolden', 'sativa'),
	(default, 'Harlequin', 'harlequin', 'sativa'),
	(default, 'Lamb''s Bread', 'breadlambs', 'sativa'),
	(default, 'Cinderella 99', '99cinderella', 'sativa'),
	(default, 'Tahoe OG Kush', 'kushogtahoe', 'hybrid'),
	(default, 'Lavender', 'lavender', 'indica'),
	(default, '9 Pound Hammer', '9hammerpound', 'indica'),
	(default, 'Blackberry Kush', 'blackberrykush', 'indica'),
	(default, 'Do-Si-Dos', 'dosidos', 'indica'),
	(default, 'Remedy', 'remedy', 'indica'),
	(default, 'God''s Gift', 'giftgods', 'indica'),
	(default, 'Cotton candy Kush', 'candycottonkush', 'hybrid'),
	(default, 'Vanilla Kush', 'kushvanilla', 'indica'),
	(default, 'Pineapple Express', 'expresspineapple', 'hybrid'),
	(default, 'Lemon Haze', 'hazelemon', 'sativa'),
	(default, 'Jillybean', 'jillybean', 'hybrid'),
	(default, 'ACDC', 'acdc', 'sativa'),
	(default, 'Flo', 'flo', 'hybrid'),
	(default, 'Cheese Quake', 'cheesequake', 'hybrid'),
	(default, 'Blue Widow', 'bluewidow', 'hybrid'),
	(default, 'Harle-Tsu', 'harletsu', 'hybrid'),
	(default, 'Plushberry', 'plushberry', 'indica'),
	(default, 'CBD Critical Mass', 'cbdcriticalmass', 'indica'),
	(default, 'Sweet and Sour Widow', 'andsoursweetwidow', 'indica'),
	(default, 'Sherbet', 'sherbet', 'hybrid'),
	(default, 'G13', 'g13', 'indica'),
	(default, 'Animal Cookies', 'animalcookies', 'hybrid'),
	(default, 'Sour Diesel', 'dieselsour', 'sativa'),
	(default, 'Super Lemon Haze', 'hazelemonsuper', 'sativa'),
	(default, 'Super Silver Haze', 'hazesilversuper', 'sativa'),
	(default, 'Amnesia Haze', 'amnesiahaze', 'sativa'),
	(default, 'Tangerine Dream', 'dreamtangerine', 'sativa'),
	(default, 'White Widow', 'whitewidow', 'hybrid'),
	(default, 'Blueberry', 'blueberry', 'indica'),
	(default, 'Candyland', 'candyland', 'sativa'),
	(default, 'Cannatonic', 'cannatonic', 'sativa'),
	(default, 'Kali Mist', 'kalimist', 'sativa'),
	(default, 'Liberty Haze', 'hazeliberty', 'sativa'),
	(default, 'Candy Jack', 'candyjack', 'sativa'),
	(default, 'MediHaze', 'medihaze', 'sativa'),
	(default, 'Green Crack', 'crackgreen', 'sativa'),
	(default, 'Jack Herer', 'hererjack', 'sativa'),
	(default, 'Ghost Train Haze', 'ghosthazetrain', 'sativa'),
	(default, 'Northern Lights', 'lightsnorthern', 'indica'),
	(default, 'Blueberry Kush', 'blueberrykush', 'indica'),
	(default, 'Granddaddy Purple', 'granddaddypurple', 'indica'),
	(default, 'Bubba Kush', 'bubbakush', 'indica'),
	(default, 'Chemdog', 'chemdog', 'hybrid'),
	(default, 'Maui Wowie', 'mauiwowie', 'sativa'),
	(default, 'Island Sweet Skunk', 'islandskunksweet', 'sativa'),
	(default, 'Critical Mass', 'criticalmass', 'indica'),
	(default, 'Pennywise', 'pennywise', 'indica'),
	(default, 'Kosher Kush', 'kosherkush', 'indica'),
	(default, 'Sensi Star', 'sensistar', 'indica'),
	(default, 'Shishkaberry', 'shishkaberry', 'indica'),
	(default, 'Pink Kush', 'kushpink', 'indica'),
	(default, 'Wappa', 'wappa', 'hybrid'),
	(default, 'Mango Haze', 'hazemango', 'sativa'),
	(default, 'Jean Guy', 'guyjean', 'hybrid'),
	(default, 'Nordle', 'nordle', 'indica'),
	(default, 'Sour Kush', 'kushsour', 'hybrid'),
	(default, 'Cold Creek Kush', 'coldcreekkush', 'hybrid'),
	(default, 'Delahaze', 'delahaze', 'sativa'),
	(default, 'Warlock', 'warlock', 'hybrid'),
	(default, 'OG Kush', 'kushog', 'hybrid'),
	(default, 'Critical Kush', 'criticalkush', 'indica'),
	(default, 'Hash Plant', 'hashplant', 'indica'),
	(default, 'SFV OG', 'ogsfv', 'hybrid'),
	(default, 'Blue Dream', 'bluedream', 'hybrid'),
	(default, 'MK Ultra', 'mkultra', 'sativa'),
	(default, 'Ultra Sour', 'sourultra', 'hybrid'),
	(default, 'UK Cheese', 'cheeseuk', 'hybrid'),
	(default, 'White Walker Kush', 'kushwalkerwhite', 'hybrid'),
	(default, 'Star Killer', 'killerstar', 'indica'),
	(default, 'Sour OG', 'ogsour', 'hybrid'),
	(default, 'Headstash', 'headstash', 'indica'),
	(default, 'Frost Monster', 'frostmonster', 'hybrid'),
	(default, 'Afghani', 'afghani', 'indica'),
	(default, 'Alien Dawg', 'aliendawg', 'indica'),
	(default, 'All Kush', 'allkush', 'indica'),
	(default, 'Banana Split', 'bananasplit', 'hybrid'),
	(default, 'Blue Haze', 'bluehaze', 'hybrid'),
	(default, 'Bubba Erkle Cookies', 'bubbacookieserkle', 'hybrid'),
	(default, 'Buddha Haze', 'buddhahaze', 'sativa'),
	(default, 'Buddhas Sister', 'buddhassister', 'indica'),
	(default, 'California Orange', 'californiaorange', 'hybrid'),
	(default, 'God Bud', 'budgod', 'indica'),
	(default, 'CBD Shark', 'cbdshark', 'indica'),
	(default, 'Shark Shock', 'sharkshock', 'indica'),
	(default, 'Skunk Haze', 'hazeskunk', 'hybrid'),
	(default, 'Pakistani Chitral Kush', 'chitralkushpakistani', 'indica'),
	(default, 'Chocolate Fondue', 'chocolatefondue', 'sativa'),
	(default, 'Chocolate Thai', 'chocolatethai', 'sativa'),
	(default, 'City Lights', 'citylights', 'hybrid'),
	(default, 'Dancehall', 'dancehall', 'hybrid'),
	(default, 'Durga Mata II', '2durgamata', 'hybrid'),
	(default, 'Durga Mata', 'durgamata', 'indica'),
	(default, 'Gold Kush', 'goldkush', 'indica'),
	(default, 'Great White Shark', 'greatsharkwhite', 'sativa'),
	(default, 'Ice Cream', 'creamice', 'indica'),
	(default, 'Ken''s Kush', 'kenskush', 'hybrid'),
	(default, 'LA Confidential', 'confidentialla', 'indica'),
	(default, 'Lemon Skunk', 'lemonskunk', 'hybrid'),
	(default, 'Mongolian', 'mongolian', 'indica'),
	(default, 'Ocean View', 'oceanview', 'sativa'),
	(default, 'Quantum Kush', 'kushquantum', 'sativa'),
	(default, 'Royal Purple Kush', 'kushpurpleroyal', 'indica'),
	(default, 'Spoetnik #1', '1spoetnik', 'indica'),
	(default, 'Strawberry Banana', 'bananastrawberry', 'hybrid'),
	(default, 'Super Skunk', 'skunksuper', 'indica'),
	(default, 'Treasure Island', 'islandtreasure', 'hybrid'),
	(default, 'Wabanaki', 'wabanaki', 'sativa'),
	(default, 'Royal Highness', 'highnessroyal', 'hybrid'),
	(default, 'Rockstar', 'rockstar', 'indica'),
	(default, 'Brian Berry Citrus Blend', 'berryblendbriancitrus', 'hybrid'),
	(default, 'brian berry cough', 'berrybriancough', 'hybrid'),
	(default, 'Sour Tangie', 'sourtangie', 'sativa'),
	(default, 'Hindu Kush', 'hindukush', 'indica'),
	(default, 'Larry OG', 'larryog', 'hybrid'),
	(default, 'Conspiracy Kush', 'conspiracykush', 'indica'),
	(default, 'NYC Diesel', 'dieselnyc', 'sativa'),
	(default, 'Texada Timewarp', 'texadatimewarp', 'sativa'),
	(default, 'Lemon Thai', 'lemonthai', 'sativa'),
	(default, 'Atomical Haze', 'atomicalhaze', 'sativa'),
	(default, 'Belladonna', 'belladonna', 'hybrid'),
	(default, 'Purple Kush', 'kushpurple', 'indica'),
	(default, 'CBD Critical Cure', 'cbdcriticalcure', 'indica'),
	(default, 'Headband', 'headband', 'hybrid'),
	(default, 'White Russian', 'russianwhite', 'hybrid'),
	(default, 'Strawberry Ice', 'icestrawberry', 'sativa'),
	(default, 'Acadia', 'acadia', 'sativa'),
	(default, 'Sunset Haze', 'hazesunset', 'hybrid'),
	(default, 'Nana''s Fix', 'fixnanas', 'hybrid'),
	(default, 'Critical Plus', 'criticalplus', 'hybrid'),
	(default, 'Mango', 'mango', 'indica'),
	(default, 'GSC', 'gsc', 'indica'),
	(default, 'Josh D OG', 'djoshog', 'indica'),
	(default, 'Orange Cookies', 'cookiesorange', 'hybrid'),
	(default, 'Raskal OG', 'ograskal', 'hybrid'),
	(default, 'Jack Haze', 'hazejack', 'sativa'),
	(default, 'White Rhino', 'rhinowhite', 'indica'),
	(default, 'Intergalactic', 'intergalactic', 'hybrid'),
	(default, 'White Castle', 'castlewhite', 'hybrid'),
	(default, 'Afghan Kush', 'afghankush', 'indica'),
	(default, 'Glueberry OG', 'glueberryog', 'sativa'),
	(default, 'Cinderella Jack', 'cinderellajack', 'hybrid'),
	(default, 'Orange Bud', 'budorange', 'hybrid'),
	(default, 'Sinmint Cookies', 'cookiessinmint', 'hybrid'),
	(default, 'Chocolope', 'chocolope', 'sativa'),
	(default, 'Moby Dick', 'dickmoby', 'sativa'),
	(default, 'Moonbeam', 'moonbeam', 'indica'),
	(default, 'Purple Haze', 'hazepurple', 'sativa'),
	(default, 'Riverview Ride', 'rideriverview', 'indica'),
	(default, 'Rockstar Kush', 'kushrockstar', 'indica'),
	(default, 'Sweet Deep Grapefruit', 'deepgrapefruitsweet', 'indica'),
	(default, 'Zkittlez', 'zkittlez', 'indica');

Replacement in initialize.sql at line 687 [11.17]
B:BD[20.278] → [20.278:314]
```
create or replace function common(
```
[20.278]
[21.0]
```
create or replace function get_products(
```
Deletion in initialize.sql at line 691 [11.17]
∅:D[22.778] → [23.1304:1332]
∅:D[21.60] → [23.1304:1332]
B:BD[23.1304] → [23.1304:1332]
```
	_effects effect[] = null,
```
Deletion in initialize.sql at line 693 [11.17]
B:BD[23.1396] → [23.1396:1424]
B:BD[23.1424] → [24.0:64]
```
	frequency text = 'daily',
	age integer = null,
	sex boolean = true,--false means female
```

Deletion in initialize.sql at line 697 [11.17]

∅:D[21.119] → [23.1755:1904]

B:BD[23.1755] → [23.1755:1904]

B:BD[23.1904] → [21.120:144]

∅:D[21.144] → [23.1904:1964]

B:BD[23.1904] → [23.1904:1964]

B:BD[23.1964] → [14.2701:2733]

	--_user_id integer = null, cte vs plpgsql variable?. will replace below parameters once user stuff is done
	akt1 akt1 = null,
	comt comt = null,
	cyp2c9 cyp2c9 = null,
	cyp2c19_2 cyp2c19_2 = null,
	cyp2c19_3 cyp2c19_3 = null,
	cyp2c19_17 cyp2c19_17 = null,

Insertion in initialize.sql at line 793 [11.17]
[18.2980]
[21.1366]
```
				show and
```
Deletion in initialize.sql at line 811 [11.17]
B:BD[18.3103] → [25.85:104]
```
		show = true and
```

Replacement in initialize.sql at line 815 [11.17]

∅:D[22.896] → [21.1785:1894]

B:BD[21.1785] → [21.1785:1894]

∅:D[21.1894] → [23.2185:2637]

B:BD[23.2185] → [23.2185:2637]

B:BD[23.2637] → [21.1895:1970]

B:BD[21.1970] → [26.1075:1219]

∅:D[26.1219] → [21.2160:2170]

B:BD[21.2160] → [21.2160:2170]

∅:D[21.2170] → [23.2942:3166]

B:BD[23.2942] → [23.2942:3166]

B:BD[23.3166] → [21.2171:2246]

B:BD[21.2246] → [26.1220:1364]

∅:D[26.1364] → [21.2436:2446]

B:BD[21.2436] → [21.2436:2446]

∅:D[21.2446] → [23.3471:3501]

B:BD[23.3471] → [23.3471:3501]

B:BD[23.3501] → [24.65:246]

∅:D[24.246] → [26.1365:1446]

B:BD[23.3630] → [26.1365:1446]

∅:D[26.1446] → [21.2772:2813]

B:BD[21.2772] → [21.2772:2813]

B:BD[21.2813] → [26.1447:1521]

B:BD[26.1521] → [24.247:262]

∅:D[26.1521] → [21.2893:2945]

∅:D[24.262] → [21.2893:2945]

B:BD[21.2893] → [21.2893:2945]

B:BD[21.2945] → [26.1522:1611]

∅:D[26.1611] → [21.3041:3094]

B:BD[21.3041] → [21.3041:3094]

B:BD[21.3094] → [26.1612:1699]

∅:D[26.1699] → [21.3190:3226]

B:BD[21.3190] → [21.3190:3226]

B:BD[21.3226] → [26.1700:1787]

∅:D[26.1787] → [21.3318:3337]

B:BD[21.3318] → [21.3318:3337]

B:BD[21.3337] → [26.1788:1844]

∅:D[26.1844] → [23.4316:4357]

∅:D[21.3391] → [23.4316:4357]

B:BD[23.4316] → [23.4316:4357]

B:BD[23.4357] → [26.1845:1925]

B:BD[26.1925] → [24.263:278]

∅:D[26.1925] → [23.4447:4499]

∅:D[24.278] → [23.4447:4499]

∅:D[21.3466] → [23.4447:4499]

B:BD[23.4447] → [23.4447:4499]

B:BD[23.4499] → [26.1926:2021]

∅:D[26.2021] → [23.4605:4658]

∅:D[21.3555] → [23.4605:4658]

B:BD[23.4605] → [23.4605:4658]

B:BD[23.4658] → [26.2022:2117]

∅:D[26.2117] → [23.4762:4798]

∅:D[21.3642] → [23.4762:4798]

B:BD[23.4762] → [23.4762:4798]

B:BD[23.4798] → [26.2118:2207]

∅:D[26.2207] → [23.4902:4921]

∅:D[21.3733] → [23.4902:4921]

B:BD[23.4902] → [23.4902:4921]

B:BD[23.4921] → [26.2208:2294]

∅:D[26.2294] → [21.3813:3854]

B:BD[21.3813] → [21.3813:3854]

∅:D[21.3854] → [23.5099:5173]

B:BD[23.5099] → [23.5099:5173]

B:BD[23.5173] → [24.279:294]

∅:D[24.294] → [23.5173:5588]

B:BD[23.5173] → [23.5173:5588]

B:BD[23.5588] → [24.295:368]

B:BD[24.368] → [4.0:138]

∅:D[4.138] → [24.504:586]

B:BD[24.504] → [24.504:586]

B:BD[24.586] → [4.139:277]

∅:D[4.277] → [24.722:812]

B:BD[24.722] → [24.722:812]

B:BD[24.812] → [4.278:376]

∅:D[4.376] → [23.5588:5597]

∅:D[24.908] → [23.5588:5597]

B:BD[23.5588] → [23.5588:5597]

B:BD[23.5597] → [24.909:952]

B:BD[24.952] → [4.377:514]

∅:D[4.514] → [24.1088:1112]

B:BD[24.1088] → [24.1088:1112]

B:BD[24.1112] → [4.515:653]

∅:D[4.653] → [24.1248:1257]

B:BD[24.1248] → [24.1248:1257]

∅:D[24.1257] → [23.5597:5649]

B:BD[23.5597] → [23.5597:5649]

B:BD[23.5649] → [5.245:480]

∅:D[22.992] → [23.5814:5874]

∅:D[5.480] → [23.5814:5874]

B:BD[23.5814] → [23.5814:5874]

B:BD[23.5874] → [5.481:940]

∅:D[5.940] → [26.2295:2433]

B:BD[21.3973] → [26.2295:2433]

∅:D[26.2433] → [21.4113:4197]

B:BD[21.4113] → [21.4113:4197]

B:BD[21.4197] → [26.2434:2535]

∅:D[26.2535] → [23.6439:6447]

∅:D[21.4326] → [23.6439:6447]

B:BD[23.6439] → [23.6439:6447]

B:BD[23.6447] → [21.4327:4377]

		(min_thc2tc is null or max_thc2tc is null or thc2tc(thc, cbd) between min_thc2tc and max_thc2tc) and case
			when akt1 in ('C/T', 'C/C') then thc2tc(thc, cbd) < .6
			else true
		end and case
			when comt in ('Val/Val', 'Val/Met') then
				thc2tc(thc, cbd) < .75 or
				terpenes[1] ilike '%pinene' or
				terpenes[2] ilike '%pinene'
			else true
		end and case--cbd
			when--slow
				(cyp2c19_17 = '*1/*1' or cyp2c19_17 = '*1/*17') and
				((cyp2c19_2 = '*1/*1' and cyp2c19_3 = '*1/*3') or (cyp2c19_2 = '*1/*2' and cyp2c19_3 = '*1/*1'))
			then
				(type in ('flower', 'preroll', 'cartridge', 'disposable', 'spray') or
				avg_range(cbd) < case
					when type = 'oil' then 76
					when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 20
				end)
			when--very slow
				cyp2c19_17 = '*1/*1' and (
					cyp2c19_2 = '*1/*1' and cyp2c19_3 = '*3/*3' or
					cyp2c19_2 = '*1/*2' and cyp2c19_3 = '*1/*3' or
					cyp2c19_2 = '*2/*2' and cyp2c19_3 = '*1/*1'
				)
			then
				(type in ('flower', 'preroll', 'cartridge', 'disposable', 'spray') or
				avg_range(cbd) < case
					when type = 'oil' then 20
					when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 10
				end)
			else true
		end and case
			when (frequency = 'daily' and (cyp2c9 is null or cyp2c9 in ('inconclusive', '*1/*1')) or type in ('oil', 'spray')) and sex and (age is null or age >= 26 and age < 40) then true
			else avg_range(thc) < case
				when type in ('flower', 'preroll') then case
					when frequency = 'daily' then case
						when cyp2c9 = '*1/*3' then 18
						when cyp2c9 = '*3/*3' then 15
						else 33
					end
					when frequency = 'weekly' then case
						when cyp2c9 = '*1/*3' then 13
						when cyp2c9 = '*3/*3' then 10
						else 22
					end
					when frequency = 'monthly' then case
						when cyp2c9 = '*1/*3' then 7
						when cyp2c9 = '*3/*3' then 4
						else 13
					end
					else case--'rarely'
						when cyp2c9 = '*1/*3' then 5
						when cyp2c9 = '*3/*3' then 2
						else 10
					end
				end
				when type in ('cartridge', 'disposable') then case
					when frequency = 'daily' then case
						when cyp2c9 = '*1/*3' then 49.09
						when cyp2c9 = '*3/*3' then 40.91
						else 90
					end
					when frequency = 'weekly' then case
						when cyp2c9 = '*1/*3' then 44.18
						when cyp2c9 = '*3/*3' then 33.91
						else 75
					end
					when frequency = 'monthly' then case
						when cyp2c9 = '*1/*3' then 35.31
						when cyp2c9 = '*3/*3' then 18.46
						else 60
					end
					else case--'rarely'
						when cyp2c9 = '*1/*3' then 20
						when cyp2c9 = '*3/*3' then 10
						else 40
					end
				end
				when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then case
					when frequency = 'daily' then case
						when cyp2c9 = '*1/*3' then 7.5
						when cyp2c9 = '*3/*3' then 5
						else 10
					end
					when frequency = 'weekly' then case
						when cyp2c9 = '*1/*3' then 5
						when cyp2c9 = '*3/*3' then 3
						else 7.5
					end
					when frequency = 'monthly' then case
						when cyp2c9 = '*1/*3' then 3
						when cyp2c9 = '*3/*3' then 2
						else 5
					end
					else case--'rarely'
						when cyp2c9 = '*1/*3' then 2.4
						when cyp2c9 = '*3/*3' then 1.2
						else 3
					end
				end
				else 30
			end * case
				when sex then 1
				else case
					when frequency = 'daily' then .98
					when frequency = 'weekly' then .95
					when frequency = 'monthly' then .92
					else .89
				end
			end * case
				when age is null then 1
				when age < 26 then case
					when frequency = 'daily' then .98
					when frequency = 'weekly' then .95
					when frequency = 'monthly' then .92
					else .89
				end
				when age >= 26 and age < 40 then case
					when frequency = 'daily' then 1
					when frequency = 'weekly' then .98
					when frequency = 'monthly' then .95
					else .92
				end
				when age >= 40 and age < 60 then case
					when frequency = 'daily' then .98
					when frequency = 'weekly' then .96
					when frequency = 'monthly' then .93
					else .9
				end
				else case
					when frequency = 'daily' then .96
					when frequency = 'weekly' then .94
					when frequency = 'monthly' then .91
					else .88
				end
			end
		end and
		coalesce((select bool_or(case
			when x = 'sleep' then coalesce(product.species, strain.species) = 'indica' and thc2tc(thc, cbd) >= .1
			when x = 'calm' then (coalesce(product.species, strain.species) in ('indica', 'hybrid') or blend) and thc2tc(thc, cbd) <= .6
			when x = 'pain' then thc2tc(thc, cbd) between .1 and .8
			when x = 'happy' then coalesce(product.species, strain.species) = 'sativa' or coalesce(product.species, strain.species) = 'hybrid' and thc2tc(thc, cbd) >= .35
			when x = 'energetic' then coalesce(product.species, strain.species) = 'sativa' and thc2tc(thc, cbd) >= .1
			when x = 'focused' then coalesce(product.species, strain.species) = 'hybrid' and thc2tc(thc, cbd) between .25 and .7 or coalesce(product.species, strain.species) = 'sativa' and case
				when type in ('flower', 'preroll') then avg_range(thc) <= 10
				when type in ('disposable', 'cartridge') then avg_range(thc) <= 40
				when type = 'oil' then avg_range(thc) <= 20
				when type = 'spray' then true
				when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then avg_range(thc) <= 5
			end
		end) from unnest(_effects) as t(x)), true) and

[22.896]

[21.4377]

		(min_thc2tc is null or max_thc2tc is null or thc2tc(thc, cbd) between min_thc2tc and max_thc2tc) and

Replacement in initialize.sql at line 819 [11.17]

B:BD[21.4498] → [21.4498:4624]

∅:D[21.4624] → [23.6861:8313]

B:BD[23.6861] → [23.6861:8313]

		case when search is not null then word_similarity(search, concat_ws(' ', producer, brand, product.display_name)) end desc,
		case
			when cyp2c9 in ('*1/*3', '*3/*3') then case
				when type in ('flower', 'preroll', 'cartridge', 'disposable') then 1
				when type in ('oil', 'spray') then 2
				when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 3
			end
		end,
		case
			when
				'sleep' = any(_effects) and terpenes[1] ilike '%myrcene' or
				'calm' = any(_effects) and terpenes[1] ilike '%limonene' or
				'pain' = any(_effects) and terpenes[1] ilike '%caryo%lene' and terpenes[2] ilike '%humulene' or
				'focused' = any(_effects) and terpenes[1] ilike '%pinene' or
				'energetic' = any(_effects) and terpenes[1] ilike '%terpinolene' or
				'happy' = any(_effects) and terpenes[1] ilike '%linalool'
			then 1
			when
				'sleep' = any(_effects) and terpenes[2] ilike '%myrcene' or
				'calm' = any(_effects) and terpenes[1] ilike '%caryo%lene' or
				'pain' = any(_effects) and terpenes[1] ilike '%caryo%lene' or
				'focused' = any(_effects) and terpenes[2] ilike '%pinene' or
				'energetic' = any(_effects) and terpenes[2] ilike '%terpinolene' or
				'happy' = any(_effects) and terpenes[2] ilike '%linalool'
			then 2
			when
				'calm' = any(_effects) and terpenes[2] ilike '%limonene' or
				'pain' = any(_effects) and terpenes[2] ilike '%caryo%lene'
			then 3
			when
				'calm' = any(_effects) and terpenes[2] ilike '%caryo%lene'
			then 4
			when strain.effect = any(_effects) then 10
			else 11
		end

[21.4498]

[23.8313]

		case when search is not null then word_similarity(search, concat_ws(' ', producer, brand, product.display_name)) end desc

Deletion in initialize.sql at line 821 [11.17]

B:BD[23.8338] → [20.1287:1389]

B:BD[20.1389] → [22.993:1018]

∅:D[22.1018] → [20.1389:1509]

B:BD[20.1389] → [20.1389:1509]

B:BD[20.1509] → [24.1258:1302]

∅:D[24.1302] → [20.1509:1933]

B:BD[20.1509] → [20.1509:1933]

∅:D[27.777] → [28.627:645]

∅:D[20.1933] → [28.627:645]

B:BD[28.627] → [28.627:645]

B:BD[28.645] → [20.1934:1976]

∅:D[20.1976] → [28.659:743]

B:BD[28.659] → [28.659:743]

B:BD[28.743] → [22.1019:1036]

∅:D[22.1036] → [28.743:758]

B:BD[28.743] → [28.743:758]

B:BD[28.758] → [20.1977:1994]

∅:D[20.1994] → [28.779:793]

B:BD[28.779] → [28.779:793]

B:BD[28.793] → [3.105:133]

∅:D[3.133] → [28.793:852]

B:BD[28.793] → [28.793:852]

B:BD[28.852] → [29.1832:1852]

∅:D[29.1852] → [20.1995:2044]

∅:D[30.216] → [20.1995:2044]

B:BD[28.852] → [20.1995:2044]

∅:D[20.2044] → [28.871:880]

B:BD[28.871] → [28.871:880]

B:BD[28.880] → [20.2045:2138]

B:BD[20.2138] → [22.1037:1047]

∅:D[22.1047] → [20.2138:2187]

B:BD[20.2138] → [20.2138:2187]

B:BD[20.2187] → [3.134:146]

∅:D[3.146] → [20.2187:2217]

B:BD[20.2187] → [20.2187:2217]

B:BD[20.2217] → [30.217:233]

∅:D[30.233] → [20.2217:2319]

B:BD[20.2217] → [20.2217:2319]

B:BD[20.2319] → [22.1048:1069]

∅:D[22.1069] → [20.2319:2423]

B:BD[20.2319] → [20.2319:2423]

B:BD[20.2423] → [24.1303:1333]

∅:D[24.1333] → [20.2423:2822]

B:BD[20.2423] → [20.2423:2822]

B:BD[20.2822] → [22.1070:1095]

∅:D[22.1095] → [20.2822:2942]

B:BD[20.2822] → [20.2822:2942]

B:BD[20.2942] → [24.1334:1378]

∅:D[24.1378] → [20.2942:3510]

B:BD[20.2942] → [20.2942:3510]

B:BD[20.3510] → [22.1096:1113]

∅:D[22.1113] → [20.3510:3556]

B:BD[20.3510] → [20.3510:3556]

B:BD[20.3556] → [3.147:175]

∅:D[3.175] → [20.3556:3615]

B:BD[20.3556] → [20.3556:3615]

B:BD[20.3615] → [29.1853:1873]

∅:D[29.1873] → [20.3615:3664]

∅:D[30.263] → [20.3615:3664]

B:BD[20.3615] → [20.3615:3664]

B:BD[20.3664] → [2.12:22]

∅:D[20.4368] → [28.880:904]

∅:D[2.22] → [28.880:904]

B:BD[28.880] → [28.880:904]

B:BD[28.904] → [20.4369:4385]

∅:D[20.4385] → [28.904:942]

B:BD[28.904] → [28.904:942]

B:BD[28.942] → [20.4386:4501]

∅:D[20.4501] → [28.1013:1119]

B:BD[28.1013] → [28.1013:1119]

B:BD[28.1119] → [20.4502:4536]

∅:D[20.4536] → [28.1153:1180]

B:BD[28.1153] → [28.1153:1180]

B:BD[28.1392] → [28.1392:1416]

B:BD[28.1416] → [20.4537:4553]

∅:D[20.4553] → [28.1416:1448]

B:BD[28.1416] → [28.1416:1448]

B:BD[28.1448] → [20.4554:4563]

∅:D[20.4563] → [28.1473:1485]

B:BD[28.1473] → [28.1473:1485]

B:BD[28.1485] → [22.1114:1124]

∅:D[22.1124] → [20.4564:4613]

B:BD[28.1485] → [20.4564:4613]

B:BD[20.4613] → [3.176:188]

∅:D[3.188] → [28.1538:1554]

∅:D[20.4613] → [28.1538:1554]

B:BD[28.1538] → [28.1538:1554]

B:BD[28.1554] → [20.4614:4628]

B:BD[20.4628] → [30.264:280]

∅:D[30.280] → [20.4628:4730]

B:BD[20.4628] → [20.4628:4730]

B:BD[20.4730] → [22.1125:1146]

∅:D[22.1146] → [20.4730:4834]

B:BD[20.4730] → [20.4730:4834]

B:BD[20.4834] → [24.1379:1409]

∅:D[24.1409] → [20.4834:5128]

B:BD[20.4834] → [20.4834:5128]

∅:D[20.5128] → [28.2689:2864]

B:BD[28.2689] → [28.2689:2864]

B:BD[28.2864] → [20.5129:5485]

∅:D[20.5485] → [28.3021:3252]

B:BD[28.3021] → [28.3021:3252]

B:BD[28.3252] → [20.5486:5594]

B:BD[20.5594] → [2.23:185]

∅:D[20.5703] → [28.3617:3627]

∅:D[2.185] → [28.3617:3627]

B:BD[28.3617] → [28.3617:3627]

B:BD[28.3627] → [23.8610:8635]

create or replace function get_products(
	_store_ids integer[] = null,
	_species species[] = null,
	_blend boolean = null,
	_effects effect[] = null,
	_strain_ids integer[] = null,
	_types product_type[] = null,
	frequency text = 'daily',
	age integer = null,
	sex boolean = true,
	in_stock boolean = null,--true in stock only. false oos only. null everything
	search text = null,
	min_thc2tc decimal = null,
	max_thc2tc decimal = null,
	--_user_id integer = null, cte vs plpgsql variable?. will replace below parameters once user stuff is done
	akt1 akt1 = null,
	comt comt = null,
	cyp2c9 cyp2c9 = null,
	cyp2c19_2 cyp2c19_2 = null,
	cyp2c19_3 cyp2c19_3 = null,
	cyp2c19_17 cyp2c19_17 = null
) returns table(
	product_id integer,
	variant_ids json,
	type product_type,
	producer text,
	brand text,
	name text,
	species species,
	blend boolean,
	strain text,
	terpenes json,
	image text,
	x smallint,
	y smallint,
	cbd numrange,
	thc numrange,
	min_price decimal(5, 2),
	min_price_g text,
	min_portions smallint,
	max_portions smallint
) as $$
	select
		product_id,
		variant_ids,
		type,
		producer,
		brand,
		name,
		species,
		blend,
		strain,
		array_to_json(terpenes),
		image,
		x,
		y,
		cbd,
		thc,
		min_price,
		min_price_g,
		min_portions,
		max_portions
	from common(
		_store_ids => _store_ids,
		_species => _species,
		_blend => _blend,
		_effects => _effects,
		_strain_ids => _strain_ids,
		_types => _types,
		frequency => frequency,
		age => age,
		sex => sex,
		in_stock => in_stock,
		search => search,
		min_thc2tc => min_thc2tc,
		max_thc2tc => max_thc2tc,
		akt1 => akt1,
		comt => comt,
		cyp2c9 => cyp2c9,
		cyp2c19_2 => cyp2c19_2,
		cyp2c19_3 => cyp2c19_3,
		cyp2c19_17 => cyp2c19_17
	)
$$ language sql stable;
create or replace function similar_products(
	_variant_id integer,
	_store_ids integer[] = null,
	_species species[] = null,
	_blend boolean = null,
	_effects effect[] = null,
	_strain_ids integer[] = null,
	_types product_type[] = null,
	frequency text = 'daily',
	age integer = null,
	sex boolean = true,
	in_stock boolean = null,--true in stock only. false oos only. null everything
	search text = null,
	min_thc2tc decimal = null,
	max_thc2tc decimal = null,
	--_user_id integer = null, cte vs plpgsql variable?. will replace below parameters once user stuff is done
	akt1 akt1 = null,
	comt comt = null,
	cyp2c9 cyp2c9 = null,
	cyp2c19_2 cyp2c19_2 = null,
	cyp2c19_3 cyp2c19_3 = null,
	cyp2c19_17 cyp2c19_17 = null
) returns table(
	product_id integer,
	variant_ids json,
	type product_type,
	producer text,
	brand text,
	name text,
	species species,
	blend boolean,
	strain text,
	terpenes json,
	image text,
	x smallint,
	y smallint,
	cbd numrange,
	thc numrange,
	min_price decimal(5, 2),
	min_price_g text,
	min_portions smallint,
	max_portions smallint
) as $$ 
	with p as (
		select
			product_id,
			strain_id,
			type,
			species,
			thc2tc(range_merge(thc), range_merge(cbd)),
			terpenes,
			avg_range(range_merge(thc)),
			first(portions)
		from
			product
			inner join variant using (product_id)
			inner join menu_item using (variant_id)
		where variant_id = _variant_id
		group by product_id
	)
	select
		product_id,
		variant_ids,
		type,
		producer,
		brand,
		name,
		species,
		blend,
		strain,
		array_to_json(terpenes),
		image,
		x,
		y,
		cbd,
		thc,
		min_price,
		min_price_g,
		min_portions,
		max_portions
	from common(
		_store_ids => _store_ids,
		_species => _species,
		_blend => _blend,
		_effects => _effects,
		_strain_ids => _strain_ids,
		_types => _types,
		frequency => frequency,
		age => age,
		sex => sex,
		in_stock => in_stock,
		search => search,
		min_thc2tc => min_thc2tc,
		max_thc2tc => max_thc2tc,
		akt1 => akt1,
		comt => comt,
		cyp2c9 => cyp2c9,
		cyp2c19_2 => cyp2c19_2,
		cyp2c19_3 => cyp2c19_3,
		cyp2c19_17 => cyp2c19_17
	)
	where product_id != (select product_id from p)
	order by
		strain_id = (select strain_id from p) desc nulls last,
		type = (select type from p) desc,--should this be optional?
		species = (select species from p) desc,
		levenshtein(terpenes[1], (select terpenes[1] from p)) <= 2 desc nulls last,--replace with http://sigaev.ru/git/gitweb.cgi?p=smlar.git;a=blob;hb=HEAD;f=README https://medium.com/@Alibaba_Cloud/keyword-analysis-with-postgresql-algorithms-for-text-analysis-with-the-smlar-plug-in-64ad32475026 using terpene weights 3:2:1 or 2.5:2:1 or bccannabisstores.com
		levenshtein(terpenes[1], (select terpenes[2] from p)) <= 2 desc nulls last,
		levenshtein(terpenes[1], (select terpenes[3] from p)) <= 2 desc nulls last,
		round(@ thc2tc(thc, cbd) - (select thc2tc from p), 2) asc nulls last,
		@ avg_range(thc) - (select avg_range from p) asc nulls last,--won't work if type becomes optional though
		least(@ avg_range(thc) / min_portions - (select avg_range / first from p), @ avg_range(thc) / max_portions - (select avg_range / first from p)) asc nulls last
	limit 5
$$ language sql stable;

Deletion in package.json at line 11 [31.29376]
B:BD[14.19000] → [14.19000:19025]
```
    "bcrypt": "^5.0.0",
```
Deletion in server.js at line 4 [16.590]
B:BD[16.666] → [8.1836:1871]
```
const bcrypt = require('bcrypt');
```

Replacement in server.js at line 483 [16.590]

B:BD[17.3667] → [14.31462:31740]

					let user = (await pool.query('select user_id, webportal_hash, passphrase_hash, god, json_object_agg(store_id, owner) filter (where store_id is not null) as acl from usr left join user_store using (user_id) where email = $1 group by user_id', [parameters.email])).rows[0];

[17.3667]

[16.2539]

					let user = (await pool.query('select user_id, passphrase_hash, god, json_object_agg(store_id, owner) filter (where store_id is not null) as acl from usr left join user_store using (user_id) where email = $1 group by user_id', [parameters.email])).rows[0];

Deletion in server.js at line 491 [16.590]
B:BD[16.2711] → [7.10360:10400]
```
							let q = '';
							let p = [];
```

Replacement in server.js at line 492 [16.590]

B:BD[8.2053] → [7.10401:10413]

∅:D[7.10413] → [32.0:242]

B:BD[8.3024] → [32.0:242]

B:BD[32.242] → [7.10414:10535]

								//
							} else if(user.webportal_hash && await bcrypt.compare(parameters.passphrase + 'a7da287aa2db01ab44144e98f5c5a11edc8f4572c0bd77fcd4d5f036534ab9eb95ff4b9ee2a0dcc32a5aecc3290610ffbfd46c8e911f637e366fd0ec90621252', user.webportal_hash)) {
								q = ', passphrase_hash = $3, webportal_hash = null';
								p.push(await argon2.hash(parameters.passphrase));

[8.2053]

[33.860]

								ws.user_ID = user.user_id;
								let token = await randomBytes(16);
								const client = await pool.connect();
								await client.query('begin');
								await client.query(`update usr set token_hash = $1 where user_id = $2`, [blake3(token, {length: 16}), ws.user_id]);
								await mergeCart(client, parameters.carts, ws);
								await client.query('commit');
								client.release();
								//yuck, since json can't send binary, need to hex encode. fyi base64 is smaller than hex(base16), but after compressing, hex is smaller. also base64 has issues with regards to url encoding, and slower than hex
								//if remember me on client side, store in localstorage. else do nothing with token
								//on subsequent new sockets, auto_login with token. token will be invalid(undefined) if remember me was not checked
								ws.send(JSON.stringify({
									response_ID: request_ID,
									data: {token: token.toString('hex'), god: user.god, acl: user.acl}
								}));
								let old = authenticated.get(ws.user_ID);
								authenticated.set(ws.user_ID, ws);
								if(old) {
									old.send(JSON.stringify({
										what: 'user',
										how: 'replace',
										data: null,
										why: 'logged in elsewhere'
									}));
									old.end(1000, 'logged in elsewhere');//this works correctly in firefox onclose, but not in chrome. https://stackoverflow.com/a/53340067 todo: report on chromium bug tracker
								} else {
									ws.publish('user/authenticated', JSON.stringify({
										what: 'user/authenticated',//tbd
										how: 'replace',
										data: authenticated.size
									}));
								}

Deletion in server.js at line 529 [16.590]
B:BD[16.3668] → [7.10536:10552]
```
								break;
```

Deletion in server.js at line 530 [16.590]

B:BD[16.3678] → [7.10553:12213]

							ws.user_ID = user.user_id;
							let token = await randomBytes(16);
							const client = await pool.connect();
							await client.query('begin');
							await client.query(`update usr set token_hash = $1${q} where user_id = $2`, [blake3(token, {length: 16}), ws.user_id].concat(p));
							await mergeCart(client, parameters.carts, ws);
							await client.query('commit');
							client.release();
							//yuck, since json can't send binary, need to hex encode. fyi base64 is smaller than hex(base16), but after compressing, hex is smaller. also base64 has issues with regards to url encoding, and slower than hex
							//if remember me on client side, store in localstorage. else do nothing with token
							//on subsequent new sockets, auto_login with token. token will be invalid(undefined) if remember me was not checked
							ws.send(JSON.stringify({
								response_ID: request_ID,
								data: {token: token.toString('hex'), god: user.god, acl: user.acl}
							}));
							let old = authenticated.get(ws.user_ID);
							authenticated.set(ws.user_ID, ws);
							if(old) {
								old.send(JSON.stringify({
									what: 'user',
									how: 'replace',
									data: null,
									why: 'logged in elsewhere'
								}));
								old.end(1000, 'logged in elsewhere');//this works correctly in firefox onclose, but not in chrome. https://stackoverflow.com/a/53340067 todo: report on chromium bug tracker
							} else {
								ws.publish('user/authenticated', JSON.stringify({
									what: 'user/authenticated',//tbd
									how: 'replace',
									data: authenticated.size
								}));
							}

Replacement in server.js at line 566 [16.590]

B:BD[14.39555] → [14.39555:39680]

						data: (await pool.query('select user_id, email, comt, akt1, cyp2c9, cyp2c19_2, cyp2c19_3, cyp2c19_17 from usr')).rows

[14.39555]

[14.39680]

						data: (await pool.query('select user_id, email from usr')).rows

Replacement in server.js at line 1053 [16.590]

B:BD[27.1107] → [27.1107:1596]

						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

[27.1107]

[27.1596]

						array_to_json(enum_range(null::product_type)) as product_types

Deletion in server.js at line 1078 [16.590]

B:BD[23.10290] → [23.10290:10457]

∅:D[23.10457] → [27.1876:1884]

B:BD[27.1876] → [27.1876:1884]

					if(Array.isArray(parameters.effects) && parameters.effects.every(s => typeof s === 'string')) {
						qs += `_effects => $${params.push(parameters.effects)},`;
					}

Deletion in server.js at line 1080 [16.590]

∅:D[27.1996] → [28.3628:3636]

B:BD[34.395] → [28.3628:3636]

B:BD[28.3636] → [23.10458:10579]

B:BD[23.10579] → [24.1410:1544]

∅:D[24.1544] → [23.10579:10587]

B:BD[23.10579] → [23.10579:10587]

B:BD[23.10587] → [24.1545:1657]

∅:D[24.1657] → [23.10587:11185]

B:BD[23.10587] → [23.10587:11185]

					}
					if(typeof parameters.frequency === 'string') {
						qs += `frequency => $${params.push(parameters.frequency)},`;
					}
					if(Number.isInteger(parameters.age = Number(parameters.age))) {
						qs += `age => $${params.push(parameters.age)},`;
					}
					if(typeof parameters.sex === 'boolean') {
						qs += `sex => $${params.push(parameters.sex)},`;
					}
					if(typeof parameters.akt1 === 'string') {
						qs += `akt1 => $${params.push(parameters.akt1)},`;
					}
					if(typeof parameters.comt === 'string') {
						qs += `comt => $${params.push(parameters.comt)},`;
					}
					if(typeof parameters.cyp2c9 === 'string') {
						qs += `cyp2c9 => $${params.push(parameters.cyp2c9)},`;
					}
					if(typeof parameters.cyp2c19_2 === 'string') {
						qs += `cyp2c19_2 => $${params.push(parameters.cyp2c19_2)},`;
					}
					if(typeof parameters.cyp2c19_3 === 'string') {
						qs += `cyp2c19_3 => $${params.push(parameters.cyp2c19_3)},`;

Deletion in server.js at line 1081 [16.590]

B:BD[23.11193] → [23.11193:11325]

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

fuck roz

Dependencies

In channels

Change contents

File deletion: gene2jane.js

Deletion in initialize.sql at line 128 [11.17]

Deletion in initialize.sql at line 133 [11.17]

Replacement in initialize.sql at line 212 [11.17]

Deletion in initialize.sql at line 224 [11.17]

Replacement in initialize.sql at line 299 [11.17]

Replacement in initialize.sql at line 687 [11.17]

Deletion in initialize.sql at line 691 [11.17]

Deletion in initialize.sql at line 693 [11.17]

Deletion in initialize.sql at line 697 [11.17]

Insertion in initialize.sql at line 793 [11.17]

Deletion in initialize.sql at line 811 [11.17]