boogerlad/mj - Change JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC

update dependencies deduplicate imports and stop reading the wrong .env don't upgrade the connection to a websocket if wrong origin switch from user type enum to god boolean + acl. this way, a user can be a(n) worker / owner of multiple stores don't bother caching the user type in ws anymore. always get the truth from database skip stock check if just changing cart's user implement otp login on connection as fallback to remember me token on connection login event instead of firth return minimum number of fields from user on unauthorized due to not >= store (owner || worker), update user acl event only publish number of authenticated / connected on change register logs in as well merge cart (associate anonymous cart to user on login / register, transfer line item from anonymous cart to authenticated cart, add quantities of line items with same menu item together from anonymous to authenticated cart) end connection on logout and old connection if exists if login elsewhere taxes for types (bc 20% vapes) + include tax in price when viewing products stock level now takes into account # of reserved trigger for stock decrement on ready -> paid min / max quantity filter for products when user / store deleted and last status of cart is 'placed' or 'ready', add fake final store / user cancelled event if god, created product will be visible for menu_item_loader. if store owner, not visible so that lobo can review implement roles so that a store owner / worker can only access their stores defined by the acl for menu items, reservations implement god see users' reservations and cancel implement the rest of the reservation flow notifications (store status update, user cancel) implement store add event sadly, lots of copy and paste. if the pattern is good, let's clean this up. I estimate 500 lines of code to be shaven off

Created by boogerlad on July 6, 2020

JP2LJ6B34S4IS6MPKF5LMMYUWIYMGU3JCJRRR4PTZ4IWM653JCXAC

Dependencies

In channels

main

Change contents

Replacement in event.json at line 4 [16.41]

B:BD[12.50] → [12.50:201]

	data: [row objects] || row object || id to splice || {id: integer, property_that_has_changed: new_value, other_property_that_has_changed: new_value}

[12.50]

[16.204]

	data: ([row objects] || row object) || row object || id to splice || {id: integer, property_that_has_changed: new_value, other_property_that_has_changed: new_value}
	why: "string" || undefined

Insertion in initialize.sql at line 72 [19.17]

[17.558]

[18.504]

create or replace function s(anyarray) returns anyarray as $$
	select array_agg(distinct n order by n) from unnest($1) as t(n);
$$ language sql immutable;
create type product_type as enum ('flower', 'preroll', 'cartridge', 'disposable', 'oil', 'spray', 'capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked');

Replacement in initialize.sql at line 81 [19.17]

B:BD[20.5370] → [17.559:584]

	unique(store_id, name)

[20.5370]

[19.528]

	types product_type[] check (cardinality(types) > 0 and cardinality(types) < array_length(enum_range(null::product_type), 1) and array_ndims(types) = 1)

Insertion in initialize.sql at line 83 [19.17]

[19.532]

[18.773]

create unique index upi_store_tax_2 on store_tax (store_id, name) where types is null;
create unique index upi_store_tax_3 on store_tax (store_id, name, s(types)) where types is not null;
create or replace function remove_duplicates_in_array() returns trigger as $$ begin
	if new.types is not null then
		new.types = s(new.types);
		if array_length(new.types, 1) = array_length(enum_range(null::product_type), 1) then
			new.types = null;
		end if;
	end if;
	return new;
end $$ language plpgsql volatile;
drop trigger if exists remove_duplicates_in_array_trigger on store_tax;
create trigger remove_duplicates_in_array_trigger before insert or update on store_tax for each row execute function remove_duplicates_in_array();

Deletion in initialize.sql at line 120 [19.17]

B:BD[21.213] → [4.0:157]

create type product_type as enum ('flower', 'preroll', 'cartridge', 'disposable', 'oil', 'spray', 'capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked');

Deletion in initialize.sql at line 181 [19.17]

B:BD[19.3614] → [22.293:392]

--create table menu_item_tax for vapes in bc 20% tax. guess this could also be for discounts too?

Deletion in initialize.sql at line 189 [19.17]
∅:D[18.2828] → [19.4186:4265]
∅:D[23.2961] → [19.4186:4265]
B:BD[19.4186] → [19.4186:4265]
```
create type user_type as enum ('god', 'store owner', 'store worker', 'user');
```

Replacement in initialize.sql at line 205 [19.17]

∅:D[24.28] → [19.4556:4653]

B:BD[19.4556] → [19.4556:4653]

B:BD[19.4653] → [16.206:248]

	address text,
	address2 text,
	city text,
	region text,
	country text,
	postal_code text,
	type user_type not null default 'user',

[24.28]

[23.3054]

	god boolean not null default false,

Replacement in initialize.sql at line 214 [19.17]

∅:D[25.98] → [19.4805:4913]

∅:D[18.2899] → [19.4805:4913]

∅:D[23.3167] → [19.4805:4913]

B:BD[19.4805] → [19.4805:4913]

);--not done. more research needed on best practices, email reset, sign in count, IP address, etc. survey?

[25.98]

[23.3168]

);--not done. more research needed on best practices, sign in count, IP address, etc. survey?
create table user_store (
	user_store_id serial primary key,
	user_id integer references usr on delete cascade,
	store_id integer references store on delete cascade,
	unique(user_id, store_id),
	owner boolean not null--otherwise just worker
);
create table user_address (
	user_store_id serial primary key,
	user_id integer references usr on delete cascade,
	address citext not null,
	address2 citext not null,
	city citext not null,
	region citext not null,
	country citext not null,
	postal_code citext not null,
	longitude decimal not null,
	latitude decimal not null,
	osrm_hint_foot text not null,
	osrm_hint_car text not null,
	unique(user_id, address, city, region, country, postal_code)
);

Replacement in initialize.sql at line 253 [19.17]

B:BD[19.6200] → [20.8462:8563]

--todo: store reviews, product reviews, notifications, watched products, mixology, full text search

[19.6200]

[20.8563]

--todo: store reviews, product reviews, notifications, watched products, mixology, full text search, discounts

Insertion in initialize.sql at line 277 [19.17]

[23.3976]

[20.9688]

	periods.add_system_time_period('user_store'),
	periods.add_system_versioning('user_store'),
	periods.add_system_time_period('user_address'),
	periods.add_system_versioning('user_address'),

Replacement in initialize.sql at line 616 [19.17]

B:BD[26.432] → [27.0:56]

create or replace function get_stores() returns table(

[26.432]

[27.56]

create or replace function get_stores(_store_id integer = null) returns table(

Insertion in initialize.sql at line 675 [19.17]
[14.795]
[26.433]
```
	where _store_id is null or store_id = _store_id
```

Replacement in initialize.sql at line 710 [19.17]

B:BD[26.1964] → [28.145:176]

	cyp2c19_17 cyp2c19_17 = null

[26.1964]

[29.1819]

	cyp2c19_17 cyp2c19_17 = null,
	min_quantity decimal = null,
	max_quantity decimal = null

Replacement in initialize.sql at line 775 [19.17]
∅:D[30.418] → [29.2807:2824]
B:BD[29.2807] → [29.2807:2824]
```
				min(price),
```
[30.418]
[8.45]
```
				min(price * (1 + tax)),
```

Insertion in initialize.sql at line 790 [19.17]

[31.697]

[29.2970]

				left join lateral (
					select coalesce(sum(rate), 0) as tax
					from store_tax
					where
						menu_item.store_id = store_tax.store_id and
						(types is null or poop.type = any(types))
				) as t on true
				left join lateral (
					select (coalesce(sum(quantity), 0)) as reserved
					from line_item inner join cart using (cart_id)
					where
						status <= 'ready' and
						line_item.menu_item_id = menu_item.menu_item_id
				) as w on true

Replacement in initialize.sql at line 807 [19.17]

B:BD[32.383] → [33.403:477]

					when in_stock then stock > 0
					when not in_stock then stock = 0

[32.383]

[32.459]

					when in_stock then stock > reserved
					when not in_stock then stock <= reserved

Replacement in initialize.sql at line 810 [19.17]

B:BD[32.475] → [32.475:484]

end

[32.475]

[29.3027]

				end and
				(min_quantity is null or quantity >= min_quantity) and
				(max_quantity is null or quantity <= max_quantity)

Insertion in initialize.sql at line 1374 [19.17]

[34.273]

	--raise exception 'Value: %, %, %, %', proposed_gram_equivalency_line_item, gram_equivalency_in_cart, held, stock;

Deletion in initialize.sql at line 1403 [19.17]

B:BD[34.1590] → [34.1590:2041]

		select coalesce(sum(line_item.quantity), 0)
		into strict held
		from cart inner join line_item using (cart_id)
		where status <= 'ready' and cart.cart_id != new.cart_id and line_item.menu_item_id = new.menu_item_id;
		select stock
		into strict _stock
		from menu_item
		where menu_item.menu_item_id = new.menu_item_id;
		--raise exception 'Value: %, %, %, %', proposed_gram_equivalency_line_item, gram_equivalency_in_cart, held, stock;

Replacement in initialize.sql at line 1405 [19.17]

B:BD[34.2162] → [34.2162:2265]

		elsif _stock - held < new.quantity then
			raise exception 'out of stock';
		else
			return new;

[34.2162]

[34.2265]

		end if;
		if not (old.cart_id is not null and old.cart_id != new.cart_id and old.menu_item_id = new.menu_item_id and old.quantity = new.quantity) then
			select coalesce(sum(line_item.quantity), 0)
			into strict held
			from cart inner join line_item using (cart_id)
			where status <= 'ready' and cart.cart_id != new.cart_id and line_item.menu_item_id = new.menu_item_id;
			select stock
			into strict _stock
			from menu_item
			where menu_item.menu_item_id = new.menu_item_id;
			if _stock - held < new.quantity then
				raise exception 'out of stock';
			end if;

Insertion in initialize.sql at line 1421 [19.17]
[34.2276]
[34.2276]
```
		return new;
```

Insertion in initialize.sql at line 1427 [19.17]

[34.2539]

create or replace function decrement_stock() returns trigger as $$ begin
	if old.status = 'ready' and new.status = 'paid' then
		update menu_item
		set stock = greatest(stock - quantity, 0)
		from line_item
		where
			menu_item.menu_item_id = line_item.menu_item_id and
			line_item.cart_id = new.cart_id;
	end if;
	return new;
end $$ language plpgsql volatile;
drop trigger if exists decrement_stock_trigger on cart;
create trigger decrement_stock_trigger before update on cart for each row execute function decrement_stock();

Replacement in initialize.sql at line 1633 [19.17]
B:BD[35.5954] → [35.5954:5984]
```
		'as_of', system_time_start
```
[35.5954]
[35.5984]
```
		'as_of', system_time_start,
		'end', system_time_end
```
Replacement in initialize.sql at line 1718 [19.17]
B:BD[35.8738] → [35.8738:8768]
```
		'as_of', system_time_start
```
[35.8738]
[35.8768]
```
		'as_of', system_time_start,
		'end', system_time_end
```

Replacement in package-lock.json at line 8 [38.145]

B:BD[36.182] → [37.0:267]

      "version": "2.6.0",
      "resolved": "https://registry.npmjs.org/@googlemaps/google-maps-services-js/-/google-maps-services-js-2.6.0.tgz",
      "integrity": "sha512-+eVnmvMxfp++yGiwewSUyNtAy0Rd6E2b+Fs9IlzWERq0J8jsX4U/s9LoG0qc+yNEYZGh0GX6fNYVGpYyuZ4+Yw==",

[36.182]

[39.957]

      "version": "3.1.2",
      "resolved": "https://registry.npmjs.org/@googlemaps/google-maps-services-js/-/google-maps-services-js-3.1.2.tgz",
      "integrity": "sha512-RmCyqs9L0KiqTHmmx31NLwtZ3dqjX1w/zD/NuHHah+gCVEj427ZuyVFxgcXUm38ttUukpBLtLlxT036JYek1jA==",

Replacement in package-lock.json at line 15 [38.145]
B:BD[30.3305] → [30.3305:3338]
```
        "retry-axios": "^2.1.2"
```
[30.3305]
[39.1045]
```
        "retry-axios": "^2.2.1"
```

Insertion in package-lock.json at line 24 [38.145]

[38.562]

      }
    },
    "@sendgrid/client": {
      "version": "7.2.1",
      "resolved": "https://registry.npmjs.org/@sendgrid/client/-/client-7.2.1.tgz",
      "integrity": "sha512-QizSa+qKnq5xquMyeB2x0l2JNH3jvg3zHmGt0Ghz+DLUGpW8i1m/zvrqSZ0wdcGVO4/2lW3WFN0drv1+jOxVgA==",
      "requires": {
        "@sendgrid/helpers": "^7.2.0",
        "axios": "^0.19.2"

Replacement in package-lock.json at line 35 [38.145]

B:BD[40.121] → [40.121:322]

    "@types/mime-types": {
      "version": "2.1.0",
      "resolved": "https://registry.npmjs.org/@types/mime-types/-/mime-types-2.1.0.tgz",
      "integrity": "sha1-nKUs2jY/aZxpRmwqbM2q2RPqenM="

[40.121]

[37.268]

    "@sendgrid/helpers": {
      "version": "7.2.0",
      "resolved": "https://registry.npmjs.org/@sendgrid/helpers/-/helpers-7.2.0.tgz",
      "integrity": "sha512-Ps8rc3xFpaQvIWoW1zlWi9G7QnxYwXFOeq0915DzXf5knoiOgXdFk/XBXbCFjr2lf/JIzjgFUtAV/dN8Z8jzHw==",
      "requires": {
        "chalk": "^2.0.1",
        "deepmerge": "^4.2.2"
      }
    },
    "@sendgrid/mail": {
      "version": "7.2.1",
      "resolved": "https://registry.npmjs.org/@sendgrid/mail/-/mail-7.2.1.tgz",
      "integrity": "sha512-LBAdwL+c6HmN2B/Q24LFy2do/IzBFeFoF05xBqgELxp8lMUwis4fbqgo09Zyj1CY0qHN+CfWcUfLNvHfVCh8oQ==",
      "requires": {
        "@sendgrid/client": "^7.2.1",
        "@sendgrid/helpers": "^7.2.0"
      }

Replacement in package-lock.json at line 54 [38.145]

B:BD[37.298] → [37.298:526]

      "version": "13.13.4",
      "resolved": "https://registry.npmjs.org/@types/node/-/node-13.13.4.tgz",
      "integrity": "sha512-x26ur3dSXgv5AwKS0lNfbjpCakGIduWU1DU91Zz58ONRWrIKGunmZBNv4P7N+e27sJkiGDsw/3fT4AtsqQBrBA==",

[37.298]

[37.526]

      "version": "14.0.14",
      "resolved": "https://registry.npmjs.org/@types/node/-/node-14.0.14.tgz",
      "integrity": "sha512-syUgf67ZQpaJj01/tRTknkMNoBBLWJOBODF0Zm4NrXmiSuxjymFrxnTu1QVYRubhVkRcZLYZG8STTwJRdVm/WQ==",

Replacement in package-lock.json at line 79 [38.145]

B:BD[36.640] → [37.891:1128]

      "version": "4.1.2",
      "resolved": "https://registry.npmjs.org/agentkeepalive/-/agentkeepalive-4.1.2.tgz",
      "integrity": "sha512-waNHE7tQBBn+2qXucI8HY0o2Y0OBPWldWOWsZwY71JcCm4SvrPnWdceFfB5NIXSqE8Ewq6VR/Qt5b1i69P6KCQ==",

[36.640]

[39.1321]

      "version": "4.1.3",
      "resolved": "https://registry.npmjs.org/agentkeepalive/-/agentkeepalive-4.1.3.tgz",
      "integrity": "sha512-wn8fw19xKZwdGPO47jivonaHRTd+nGOMP1z11sgGeQzDy2xd5FG0R67dIMcKHDE2cJ5y+YXV30XVGUBPRSY7Hg==",

Replacement in package-lock.json at line 89 [38.145]

B:BD[41.1024] → [30.3339:3556]

      "version": "6.12.0",
      "resolved": "https://registry.npmjs.org/ajv/-/ajv-6.12.0.tgz",
      "integrity": "sha512-D6gFiFA0RRLyUbvijN74DWAjXSFxWKaWP7mldxkVhyhAV3+SWA9HEJPHQ2c9soIeTFJqcSdFDGFgdqs1iUU2Hw==",

[41.1024]

[41.1241]

      "version": "6.12.2",
      "resolved": "https://registry.npmjs.org/ajv/-/ajv-6.12.2.tgz",
      "integrity": "sha512-k+V+hzjm5q/Mr8ef/1Y9goCmlsK4I6Sm74teeyGvFk1XrOsbsKLjEdrvny42CZ+a8sXbk8KWpY/bDwS+FLL2UQ==",

Insertion in package-lock.json at line 103 [38.145]

[38.1011]

    },
    "ansi-styles": {
      "version": "3.2.1",
      "resolved": "https://registry.npmjs.org/ansi-styles/-/ansi-styles-3.2.1.tgz",
      "integrity": "sha512-VT0ZI6kZRdTh8YyJw3SMbYm/u+NqfsAxEpWO0Pf9sq8/e94WxxOpPKx9FR1FlyCtOVDNOQ+8ntlqFxiRc+r5qA==",
      "requires": {
        "color-convert": "^1.9.0"
      }

Replacement in package-lock.json at line 127 [38.145]

B:BD[38.1656] → [38.1656:1794]

      "version": "github:boogerlad/node-argon2#1bb1fbbd8cdbedc7ba325012ece1054b21532581",
      "from": "github:boogerlad/node-argon2",

[38.1656]

[38.1794]

      "version": "0.26.2",
      "resolved": "https://registry.npmjs.org/argon2/-/argon2-0.26.2.tgz",
      "integrity": "sha512-Tk9I/r3KIHCIHU5x2UawKsPi+g7MByAYnUZghXztQDXRp/997P31wa4qvdvokTaFBpsu6jOZACd+2qkBGGssRA==",

Replacement in package-lock.json at line 160 [38.145]

B:BD[41.2320] → [41.2320:2536]

      "version": "1.9.1",
      "resolved": "https://registry.npmjs.org/aws4/-/aws4-1.9.1.tgz",
      "integrity": "sha512-wMHVg2EOHaMRxbzgFJ9gtjOOCrI80OHLG14rxi28XwOW8ux6IiEbRCGGGqCtdAIg4FQCbW20k9RsT4y3gJlFug=="

[41.2320]

[41.2536]

      "version": "1.10.0",
      "resolved": "https://registry.npmjs.org/aws4/-/aws4-1.10.0.tgz",
      "integrity": "sha512-3YDiu347mtVtjpyV3u5kVqQLP242c06zwDOgpeRnybmXlYYsLbtTrUBUm8i8srONt+FWobl5aibnU1030PeeuA=="

Replacement in package-lock.json at line 183 [38.145]

B:BD[42.1479] → [42.1479:1700]

      "version": "4.0.1",
      "resolved": "https://registry.npmjs.org/bcrypt/-/bcrypt-4.0.1.tgz",
      "integrity": "sha512-hSIZHkUxIDS5zA2o00Kf2O5RfVbQ888n54xQoF/eIaquU4uaLxK8vhhBdktd0B3n2MjkcAWzv4mnhogykBKOUQ==",

[42.1479]

[42.1700]

      "version": "5.0.0",
      "resolved": "https://registry.npmjs.org/bcrypt/-/bcrypt-5.0.0.tgz",
      "integrity": "sha512-jB0yCBl4W/kVHM2whjfyqnxTmOHkCX4kHEa5nYKSoGeYe8YrjTYTc87/6bwt1g8cmV0QrbhKriETg9jWtcREhg==",

Replacement in package-lock.json at line 187 [38.145]

B:BD[42.1721] → [42.1721:1792]

        "node-addon-api": "^2.0.0",
        "node-pre-gyp": "0.14.0"

[42.1721]

[42.1792]

        "node-addon-api": "^3.0.0",
        "node-pre-gyp": "0.15.0"
      },
      "dependencies": {
        "node-addon-api": {
          "version": "3.0.0",
          "resolved": "https://registry.npmjs.org/node-addon-api/-/node-addon-api-3.0.0.tgz",
          "integrity": "sha512-sSHCgWfJ+Lui/u+0msF3oyCgvdkhxDbkCS6Q8uiJquzOimkJBvX6hl5aSSA7DR1XbMpdM8r7phjcF63sF4rkKg=="
        },
        "node-pre-gyp": {
          "version": "0.15.0",
          "resolved": "https://registry.npmjs.org/node-pre-gyp/-/node-pre-gyp-0.15.0.tgz",
          "integrity": "sha512-7QcZa8/fpaU/BKenjcaeFF9hLz2+7S9AqyXFhlH/rilsQ/hPZKK32RtR5EQHJElgu+q5RfbJ34KriI79UWaorA==",
          "requires": {
            "detect-libc": "^1.0.2",
            "mkdirp": "^0.5.3",
            "needle": "^2.5.0",
            "nopt": "^4.0.1",
            "npm-packlist": "^1.1.6",
            "npmlog": "^4.0.2",
            "rc": "^1.2.7",
            "rimraf": "^2.6.1",
            "semver": "^5.3.0",
            "tar": "^4.4.2"
          }
        }

Insertion in package-lock.json at line 283 [38.145]

[41.3001]

[38.3348]

    "chalk": {
      "version": "2.4.2",
      "resolved": "https://registry.npmjs.org/chalk/-/chalk-2.4.2.tgz",
      "integrity": "sha512-Mti+f9lpJNcwF4tWV8/OrTTtF1gZi+f8FqlyAdouralcFWFQWF2+NgCHShjkCb+IFBLq9buZwE1xckQU4peSuQ==",
      "requires": {
        "ansi-styles": "^3.2.1",
        "escape-string-regexp": "^1.0.5",
        "supports-color": "^5.3.0"
      }
    },

Replacement in package-lock.json at line 338 [38.145]

B:BD[43.1650] → [30.5205:5436]

      "version": "1.21.0",
      "resolved": "https://registry.npmjs.org/cloudinary/-/cloudinary-1.21.0.tgz",
      "integrity": "sha512-am8wpHbHl8bcpy9oGSlWrpWLNQ9szkW/jmhcJdEpMjaL23BYt05V1frWyrXDlo8Jt7aCo5NE6EO0CM9Zaynd5g==",

[43.1650]

[43.1881]

      "version": "1.22.0",
      "resolved": "https://registry.npmjs.org/cloudinary/-/cloudinary-1.22.0.tgz",
      "integrity": "sha512-qQhSVqGyOWtGbPc3JrwyUXJEZpdqsEzBFSf5+gTo7gbKbXdzEysLagigoSlp6JYI7YW2oEbz4aeZlgN2ucOkzQ==",

Insertion in package-lock.json at line 342 [38.145]
[43.1902]
[43.1902]
```
        "core-js": "^3.6.5",
```

Insertion in package-lock.json at line 352 [38.145]

[38.3797]

[43.2007]

    "color-convert": {
      "version": "1.9.3",
      "resolved": "https://registry.npmjs.org/color-convert/-/color-convert-1.9.3.tgz",
      "integrity": "sha512-QfAUtd+vFdAtFQcC8CCyYt1fYWxSqAiK2cSD6zDB8N3cpsEBAvRxp9zOGg6G/SHHJYAT88/az/IuDGALsNVbGg==",
      "requires": {
        "color-name": "1.1.3"
      }
    },
    "color-name": {
      "version": "1.1.3",
      "resolved": "https://registry.npmjs.org/color-name/-/color-name-1.1.3.tgz",
      "integrity": "sha1-p9BVi9icQveV3UIyj3QIMcpTvCU="
    },

Insertion in package-lock.json at line 388 [38.145]

[38.4226]

    "core-js": {
      "version": "3.6.5",
      "resolved": "https://registry.npmjs.org/core-js/-/core-js-3.6.5.tgz",
      "integrity": "sha512-vZVEEwZoIsI+vPEuoF9Iqf5H7/M3eeQqWlQnYa8FSKKePuYTf5MWnxb5SDAzCa60b3JBRS5g9b+Dq7b1y/RCrA=="
    },

Insertion in package-lock.json at line 423 [38.145]

[38.4976]

    },
    "deepmerge": {
      "version": "4.2.2",
      "resolved": "https://registry.npmjs.org/deepmerge/-/deepmerge-4.2.2.tgz",
      "integrity": "sha512-FJ3UgI4gIl+PHZm53knsuSFpE+nESMr7M4v9QcgB7S63Kj/6WqMiFQJpBBYz1Pt+66bZpP3Q7Lye0Oo9MPKEdg=="

Insertion in package-lock.json at line 476 [38.145]

[41.4096]

    "escape-string-regexp": {
      "version": "1.0.5",
      "resolved": "https://registry.npmjs.org/escape-string-regexp/-/escape-string-regexp-1.0.5.tgz",
      "integrity": "sha1-G2HAViGQqN/2rjuyzwIAyhMLhtQ="
    },

Replacement in package-lock.json at line 487 [38.145]

B:BD[40.1572] → [37.3318:3549]

      "version": "2.0.0",
      "resolved": "https://registry.npmjs.org/extract-zip/-/extract-zip-2.0.0.tgz",
      "integrity": "sha512-i42GQ498yibjdvIhivUsRslx608whtGoFIhF26Z7O4MYncBxp8CwalOs1lnHy21A9sIohWO2+uiE4SRtC9JXDg==",

[40.1572]

[40.1741]

      "version": "2.0.1",
      "resolved": "https://registry.npmjs.org/extract-zip/-/extract-zip-2.0.1.tgz",
      "integrity": "sha512-GDhU9ntwuKyGXdZBUgTIe+vXnWj0fppUEtMDL0+idd5Sta8TGpHssn/eusA9mrPr9qNDym6SxAYZjNvCn/9RBg==",

Replacement in package-lock.json at line 503 [38.145]

B:BD[41.4555] → [41.4555:4793]

      "version": "3.1.1",
      "resolved": "https://registry.npmjs.org/fast-deep-equal/-/fast-deep-equal-3.1.1.tgz",
      "integrity": "sha512-8UEa58QDLauDNfpbrX55Q9jrGHThw2ZMdOky5Gl1CDtVeJDPVrG4Jxx1N8jw2gkWaff5UUuX1KJd+9zGe2B+ZA=="

[41.4555]

[41.4793]

      "version": "3.1.3",
      "resolved": "https://registry.npmjs.org/fast-deep-equal/-/fast-deep-equal-3.1.3.tgz",
      "integrity": "sha512-f3qQ9oQy9j2AhBe/H9VC91wLmKBCCU/gDOnKNAYG5hswO7BLKj09Hc5HYNz9cGI++xlpDCIgDaitVs03ATR84Q=="

Insertion in package-lock.json at line 518 [38.145]

[40.2681]

      }
    },
    "find-up": {
      "version": "4.1.0",
      "resolved": "https://registry.npmjs.org/find-up/-/find-up-4.1.0.tgz",
      "integrity": "sha512-PpOwAdQ/YlXQ2vj8a3h8IipDuYRi3wceVQQGYWxNINccq40Anw7BlsEXCMbt1Zt+OLA6Fq9suIpIWD0OsnISlw==",
      "requires": {
        "locate-path": "^5.0.0",
        "path-exists": "^4.0.0"

Insertion in package-lock.json at line 643 [38.145]

[38.7361]

    "has-flag": {
      "version": "3.0.0",
      "resolved": "https://registry.npmjs.org/has-flag/-/has-flag-3.0.0.tgz",
      "integrity": "sha1-tdRU3CGZriJWmfNGfloH87lVuv0="
    },

Insertion in package-lock.json at line 772 [38.145]

[41.8431]

      }
    },
    "locate-path": {
      "version": "5.0.0",
      "resolved": "https://registry.npmjs.org/locate-path/-/locate-path-5.0.0.tgz",
      "integrity": "sha512-t7hw9pI+WvuwNJXwk5zVHpyhIqzg2qTlklJOf0mVxGSbe3Fp2VieZcduNYjaLDoy6p9uGpQEGWG87WpMKlNq8g==",
      "requires": {
        "p-locate": "^4.1.0"

Replacement in package-lock.json at line 788 [38.145]

B:BD[40.3429] → [37.4671:4887]

      "version": "2.4.5",
      "resolved": "https://registry.npmjs.org/mime/-/mime-2.4.5.tgz",
      "integrity": "sha512-3hQhEUF027BuxZjQA3s7rIv/7VCQPa27hN9u9g87sEkWaKwQPuXOkVKtOeiyUrnWqTDiOs8Ed2rwg733mB0R5w=="

[40.3429]

[40.3645]

      "version": "2.4.6",
      "resolved": "https://registry.npmjs.org/mime/-/mime-2.4.6.tgz",
      "integrity": "sha512-RZKhC3EmpBchfTGBVb8fb+RL2cWyw/32lshnsETttkBAyAUXSGHxbEJWWRXc751DrIxG1q04b8QwMbAwkRPpUA=="

Replacement in package-lock.json at line 793 [38.145]

B:BD[41.8467] → [41.8467:8691]

      "version": "1.43.0",
      "resolved": "https://registry.npmjs.org/mime-db/-/mime-db-1.43.0.tgz",
      "integrity": "sha512-+5dsGEEovYbT8UY9yD7eE4XTc4UwJ1jBYlgaQQF38ENsKR3wj/8q8RFZrF9WIZpB2V1ArTVFUva8sAul1NzRzQ=="

[41.8467]

[41.8691]

      "version": "1.44.0",
      "resolved": "https://registry.npmjs.org/mime-db/-/mime-db-1.44.0.tgz",
      "integrity": "sha512-/NOTfLrsPBVeH7YtFPgsVWveuL+4SjjYxaQ1xtM1KMFj7HdxlBlxeyNLzhyJVx7r4rZGJAZ/6lkKCitSc/Nmpg=="

Replacement in package-lock.json at line 798 [38.145]

B:BD[41.8720] → [41.8720:8951]

      "version": "2.1.26",
      "resolved": "https://registry.npmjs.org/mime-types/-/mime-types-2.1.26.tgz",
      "integrity": "sha512-01paPWYgLrkqAyrlDorC1uDwl2p3qZT7yl806vW7DvDoxwXi46jsjFbg+WdwotBIk6/MbEhO/dh5aZ5sNj/dWQ==",

[41.8720]

[41.8951]

      "version": "2.1.27",
      "resolved": "https://registry.npmjs.org/mime-types/-/mime-types-2.1.27.tgz",
      "integrity": "sha512-JIhqnCasI9yD+SsmkquHBxTSEuZdQX5BuQnS2Vc7puQQQ+8yiP5AY5uWhpdv4YL4VM5c6iliiYWPgJ/nJQLp7w==",

Replacement in package-lock.json at line 802 [38.145]
B:BD[41.8972] → [41.8972:9001]
```
        "mime-db": "1.43.0"
```
[41.8972]
[41.9001]
```
        "mime-db": "1.44.0"
```

Replacement in package-lock.json at line 814 [38.145]

B:BD[38.10124] → [38.10124:10286]

      "version": "0.0.8",
      "resolved": "https://registry.npmjs.org/minimist/-/minimist-0.0.8.tgz",
      "integrity": "sha1-hX/Kv8M5fSYluCKCYuhqp6ARsF0="

[38.10124]

[38.10286]

      "version": "1.2.5",
      "resolved": "https://registry.npmjs.org/minimist/-/minimist-1.2.5.tgz",
      "integrity": "sha512-FM9nNUYrRBAELZQT3xeZQ7fmMOBg6nWNmJKTcgsJeaLstP/UODVpGsr5OhXhhXg6f+qtJ8uiZ+PUxkDWcgIXLw=="

Insertion in package-lock.json at line 834 [38.145]

[38.10943]

    },
    "mitt": {
      "version": "2.0.1",
      "resolved": "https://registry.npmjs.org/mitt/-/mitt-2.0.1.tgz",
      "integrity": "sha512-FhuJY+tYHLnPcBHQhbUFzscD5512HumCPE4URXZUgPi3IvOJi4Xva5IIgy3xX56GqCmw++MAm5UURG6kDBYTdg=="

Replacement in package-lock.json at line 841 [38.145]

B:BD[38.10968] → [38.10968:11127]

      "version": "0.5.1",
      "resolved": "https://registry.npmjs.org/mkdirp/-/mkdirp-0.5.1.tgz",
      "integrity": "sha1-MAV0OOrGz3+MR2fzhkjWaX11yQM=",

[38.10968]

[38.11127]

      "version": "0.5.5",
      "resolved": "https://registry.npmjs.org/mkdirp/-/mkdirp-0.5.5.tgz",
      "integrity": "sha512-NKmAlESf6jMGym1++R0Ra7wvhV+wFW63FaSOFPwRahvea0gMUcGUhVeAg/0BC0wiv9ih5NYPB1Wn1UEI1/L+xQ==",

Replacement in package-lock.json at line 845 [38.145]
B:BD[38.11148] → [38.11148:11177]
```
        "minimist": "0.0.8"
```
[38.11148]
[38.11177]
```
        "minimist": "^1.2.5"
```

Replacement in package-lock.json at line 859 [38.145]

B:BD[38.11682] → [30.5942:6163]

      "version": "2.4.1",
      "resolved": "https://registry.npmjs.org/needle/-/needle-2.4.1.tgz",
      "integrity": "sha512-x/gi6ijr4B7fwl6WYL9FwlCvRQKGlUNvnceho8wxkwXqN8jvVmmmATTmZPRRG7b/yC1eode26C2HO9jl78Du9g==",

[38.11682]

[38.11903]

      "version": "2.5.0",
      "resolved": "https://registry.npmjs.org/needle/-/needle-2.5.0.tgz",
      "integrity": "sha512-o/qITSDR0JCyCKEQ1/1bnUXMmznxabbwi/Y4WwJElf+evwJNFNwIDMCCt5IigFVxgeGBJESLohGtIS9gEzo1fA==",

Replacement in package-lock.json at line 879 [38.145]

B:BD[38.12052] → [38.12052:12288]

      "version": "2.0.0",
      "resolved": "https://registry.npmjs.org/node-addon-api/-/node-addon-api-2.0.0.tgz",
      "integrity": "sha512-ASCL5U13as7HhOExbT6OlWJJUV/lLzL2voOSP1UVehpRD8FbSrSDjfScK/KwAvVTI5AS6r4VwbOMlIqtvRidnA=="

[38.12052]

[38.12288]

      "version": "2.0.2",
      "resolved": "https://registry.npmjs.org/node-addon-api/-/node-addon-api-2.0.2.tgz",
      "integrity": "sha512-Ntyt4AIXyaLIuMHF6IOoTakB3K+RWxwtsHNRxllEoA6vPwP9o4866g6YWDLUdnucilZhmkxiHwHr11gAENw+QA=="

Insertion in package-lock.json at line 983 [38.145]

[38.15912]

      }
    },
    "p-limit": {
      "version": "2.3.0",
      "resolved": "https://registry.npmjs.org/p-limit/-/p-limit-2.3.0.tgz",
      "integrity": "sha512-//88mFWSJx8lxCzwdAABTJL2MyWB12+eIY7MDL2SqLmAkeKU9qxRvWuSyTjm3FUmpBEMuFfckAIqEaVGUDxb6w==",
      "requires": {
        "p-try": "^2.0.0"
      }
    },
    "p-locate": {
      "version": "4.1.0",
      "resolved": "https://registry.npmjs.org/p-locate/-/p-locate-4.1.0.tgz",
      "integrity": "sha512-R79ZZ/0wAxKGu3oYMlz8jy/kbhsNrS7SKZ7PxEHBgJ5+F2mtFW2fK2cOtBh1cHYkQsbzFV7I+EoRKe6Yt0oK7A==",
      "requires": {
        "p-limit": "^2.2.0"

Insertion in package-lock.json at line 1001 [38.145]

[38.15929]

    "p-try": {
      "version": "2.2.0",
      "resolved": "https://registry.npmjs.org/p-try/-/p-try-2.2.0.tgz",
      "integrity": "sha512-R4nPAVTAU0B9D35/Gk3uJf/7XYbQcyohSKdvAxIRSNghFl4e71hVoGnBNQz9cWaXxO2I10KTC+3jMdvvoKw6dQ=="
    },

Insertion in package-lock.json at line 1010 [38.145]

[38.16187]

    },
    "path-exists": {
      "version": "4.0.0",
      "resolved": "https://registry.npmjs.org/path-exists/-/path-exists-4.0.0.tgz",
      "integrity": "sha512-ak9Qy5Q7jYb2Wwcey5Fpvg2KoAc/ZIhLSLOSBmRmygPsGwkVVt0fZa0qrtMz+m6tJTAHfZQ8FnmB4MG4LWy7/w=="

Replacement in package-lock.json at line 1032 [38.145]

B:BD[38.16421] → [37.5158:5371]

      "version": "8.0.3",
      "resolved": "https://registry.npmjs.org/pg/-/pg-8.0.3.tgz",
      "integrity": "sha512-fvcNXn4o/iq4jKq15Ix/e58q3jPSmzOp6/8C3CaHoSR/bsxdg+1FXfDRePdtE/zBb3++TytvOrS1hNef3WC/Kg==",

[38.16421]

[38.16636]

      "version": "8.2.1",
      "resolved": "https://registry.npmjs.org/pg/-/pg-8.2.1.tgz",
      "integrity": "sha512-DKzffhpkWRr9jx7vKxA+ur79KG+SKw+PdjMb1IRhMiKI9zqYUGczwFprqy+5Veh/DCcFs1Y6V8lRLN5I1DlleQ==",

Replacement in package-lock.json at line 1038 [38.145]

B:BD[38.16727] → [38.16727:16769]

B:BD[38.16769] → [37.5372:5436]

        "pg-connection-string": "0.1.3",
        "pg-pool": "^3.1.1",
        "pg-protocol": "^1.2.2",

[38.16727]

[38.16838]

        "pg-connection-string": "^2.2.3",
        "pg-pool": "^3.2.1",
        "pg-protocol": "^1.2.4",

Replacement in package-lock.json at line 1054 [38.145]

B:BD[38.17207] → [38.17207:17393]

      "version": "0.1.3",
      "resolved": "https://registry.npmjs.org/pg-connection-string/-/pg-connection-string-0.1.3.tgz",
      "integrity": "sha1-2hhHsglA5C7hSSvq9l1J2RskXfc="

[38.17207]

[38.17393]

      "version": "2.2.3",
      "resolved": "https://registry.npmjs.org/pg-connection-string/-/pg-connection-string-2.2.3.tgz",
      "integrity": "sha512-I/KCSQGmOrZx6sMHXkOs2MjddrYcqpza3Dtsy0AjIgBr/bZiPJRK9WhABXN1Uy1UDazRbi9gZEzO2sAhL5EqiQ=="

Replacement in package-lock.json at line 1064 [38.145]

B:BD[38.20013] → [37.5437:5659]

      "version": "3.1.1",
      "resolved": "https://registry.npmjs.org/pg-pool/-/pg-pool-3.1.1.tgz",
      "integrity": "sha512-kYH6S0mcZF1TPg1F9boFee2JlCSm2oqnlR2Mz2Wgn1psQbEBNVeNTJCw2wCK48QsctwvGUzbxLMg/lYV6hL/3A=="

[38.20013]

[37.5659]

      "version": "3.2.1",
      "resolved": "https://registry.npmjs.org/pg-pool/-/pg-pool-3.2.1.tgz",
      "integrity": "sha512-BQDPWUeKenVrMMDN9opfns/kZo4lxmSWhIqo+cSAF7+lfi9ZclQbr9vfnlNaPr8wYF3UYjm5X0yPAhbcgqNOdA=="

Replacement in package-lock.json at line 1069 [38.145]

B:BD[37.5689] → [37.5689:5919]

      "version": "1.2.2",
      "resolved": "https://registry.npmjs.org/pg-protocol/-/pg-protocol-1.2.2.tgz",
      "integrity": "sha512-r8hGxHOk3ccMjjmhFJ/QOSVW5A+PP84TeRlEwB/cQ9Zu+bvtZg8Z59Cx3AMfVQc9S0Z+EG+HKhicF1W1GN5Eqg=="

[37.5689]

[38.20235]

      "version": "1.2.4",
      "resolved": "https://registry.npmjs.org/pg-protocol/-/pg-protocol-1.2.4.tgz",
      "integrity": "sha512-/8L/G+vW/VhWjTGXpGh8XVkXOFx1ZDY+Yuz//Ab8CfjInzFkreI+fDG3WjCeSra7fIZwAFxzbGptNbm8xSXenw=="

Insertion in package-lock.json at line 1091 [38.145]

[38.20927]

      }
    },
    "pkg-dir": {
      "version": "4.2.0",
      "resolved": "https://registry.npmjs.org/pkg-dir/-/pkg-dir-4.2.0.tgz",
      "integrity": "sha512-HRDzbaKjC+AOWVXxAU/x54COGeIv9eb+6CkDSQoNTt4XyWoIJvuPsXizxu/Fr23EiekbtZwmh1IcIG/l/a10GQ==",
      "requires": {
        "find-up": "^4.0.0"

Replacement in package-lock.json at line 1140 [38.145]

B:BD[43.2525] → [43.2525:2739]

      "version": "1.7.0",
      "resolved": "https://registry.npmjs.org/psl/-/psl-1.7.0.tgz",
      "integrity": "sha512-5NsSEDv8zY70ScRnOTn7bK7eanl2MvFrOrS/R6x+dBt5g1ghnj9Zv90kO8GwT8gxcu2ANyFprnFYB85IogIJOQ=="

[43.2525]

[37.6392]

      "version": "1.8.0",
      "resolved": "https://registry.npmjs.org/psl/-/psl-1.8.0.tgz",
      "integrity": "sha512-RIdOzyoavK+hA18OGGWDqUTsCLhtA7IcZ/6NCs4fFJaHBDab+pDDmDIByWFRQJq2Cd7r1OoQxBGKOaztq+hjIQ=="

Replacement in package-lock.json at line 1159 [38.145]

B:BD[40.4319] → [37.6725:6952]

      "version": "3.0.2",
      "resolved": "https://registry.npmjs.org/puppeteer/-/puppeteer-3.0.2.tgz",
      "integrity": "sha512-5jS/POFVDW9fqb76O8o0IBpXOnq+Na8ocGMggYtnjCRBRqmAFvX0csmwgLOHkYnQ/vCBcBPYlOq0Pp60z1850Q==",

[40.4319]

[40.4546]

      "version": "5.0.0",
      "resolved": "https://registry.npmjs.org/puppeteer/-/puppeteer-5.0.0.tgz",
      "integrity": "sha512-JnZcgRQnfowRSJoSHteKU7G9fP/YYGB/juPn8m4jNqtzvR0h8GOoFmdjTBesJFfzhYkPU1FosHXnBVUB++xgaA==",

Deletion in package-lock.json at line 1163 [38.145]
B:BD[40.4567] → [40.4567:4607]
```
        "@types/mime-types": "^2.1.0",
```

Replacement in package-lock.json at line 1167 [38.145]

B:BD[40.4736] → [40.4736:4770]

        "mime-types": "^2.1.25",

[40.4736]

[40.4770]

        "mitt": "^2.0.1",
        "pkg-dir": "^4.2.0",

Replacement in package-lock.json at line 1198 [38.145]

B:BD[36.3650] → [37.7394:7629]

      "version": "6.12.1",
      "resolved": "https://registry.npmjs.org/query-string/-/query-string-6.12.1.tgz",
      "integrity": "sha512-OHj+zzfRMyj3rmo/6G8a5Ifvw3AleL/EbcHMD27YA31Q+cO5lfmQxECkImuNVjcskLcvBRVHNAB3w6udMs1eAA==",

[36.3650]

[36.3831]

      "version": "6.13.1",
      "resolved": "https://registry.npmjs.org/query-string/-/query-string-6.13.1.tgz",
      "integrity": "sha512-RfoButmcK+yCta1+FuU8REvisx1oEzhMKwhLUNcepQTPGcNMp1sIqjnfCtfnvGSQZQEhaBHvccujtWoUV3TTbA==",

Deletion in package-lock.json at line 1216 [38.145]

B:BD[38.22688] → [38.22688:22746]

B:BD[38.22746] → [30.7766:8002]

∅:D[30.8002] → [38.22920:22931]

B:BD[38.22920] → [38.22920:22931]

      },
      "dependencies": {
        "minimist": {
          "version": "1.2.5",
          "resolved": "https://registry.npmjs.org/minimist/-/minimist-1.2.5.tgz",
          "integrity": "sha512-FM9nNUYrRBAELZQT3xeZQ7fmMOBg6nWNmJKTcgsJeaLstP/UODVpGsr5OhXhhXg6f+qtJ8uiZ+PUxkDWcgIXLw=="
        }

Replacement in package-lock.json at line 1285 [38.145]

B:BD[30.8324] → [30.8324:8554]

      "version": "2.1.2",
      "resolved": "https://registry.npmjs.org/retry-axios/-/retry-axios-2.1.2.tgz",
      "integrity": "sha512-MVNOizOgcM+dXK/kJCMnHPCGjp2Z0o3Ngznh7SfJkIVrqemHmDcgUEAbEHs3RyR3lbJtSyamq9k3gmgGSaow1g=="

[30.8324]

[30.8554]

      "version": "2.2.1",
      "resolved": "https://registry.npmjs.org/retry-axios/-/retry-axios-2.2.1.tgz",
      "integrity": "sha512-vSZzu29W48+/mVPOq+gwKe+qYWcppiKODXi4FN9q0iN+4s2z10/l1LDS4Ju4vReTyuvKOoqmHqY0rOAmuFjI/Q=="

Replacement in package-lock.json at line 1298 [38.145]

B:BD[38.24135] → [38.24135:24365]

      "version": "5.2.0",
      "resolved": "https://registry.npmjs.org/safe-buffer/-/safe-buffer-5.2.0.tgz",
      "integrity": "sha512-fZEwUGbVl7kouZs1jCdMLdt95hdIv0ZeHg6L7qPeciMZhZ+/gdesW4wgTARkrFWEpspjEATAzUGPG8N2jJiwbg=="

[38.24135]

[38.24365]

      "version": "5.2.1",
      "resolved": "https://registry.npmjs.org/safe-buffer/-/safe-buffer-5.2.1.tgz",
      "integrity": "sha512-rp3So07KcdmmKbGvgaNxQSJr7bGVSVk5S9Eq1F+ppbRo70+YeaDxkw5Dd8NPN+GD6bjnYm2VuPuCXmpuYvmCXQ=="

Insertion in package-lock.json at line 1403 [38.145]

[38.27278]

    },
    "supports-color": {
      "version": "5.5.0",
      "resolved": "https://registry.npmjs.org/supports-color/-/supports-color-5.5.0.tgz",
      "integrity": "sha512-QjVjwdXIt408MIiAqCX4oUKsgU2EqAGzs2Ppkm4aQYbjm+ZEWEcW4SfFNTr4uMNZma0ey4f5lgLrkB0aX0QMow==",
      "requires": {
        "has-flag": "^3.0.0"
      }

Replacement in package-lock.json at line 1427 [38.145]

B:BD[37.7664] → [37.7664:7885]

      "version": "2.0.1",
      "resolved": "https://registry.npmjs.org/tar-fs/-/tar-fs-2.0.1.tgz",
      "integrity": "sha512-6tzWDMeroL87uF/+lin46k+Q+46rAJ0SyPGz7OW7wTgblI273hsBqk2C1j0/xNadNLKDTUL9BukSjB7cwgmlPA==",

[37.7664]

[37.7885]

      "version": "2.1.0",
      "resolved": "https://registry.npmjs.org/tar-fs/-/tar-fs-2.1.0.tgz",
      "integrity": "sha512-9uW5iDvrIMCVpvasdFHW0wJPez0K4JnMZtsuIeDI7HyMGJNxmDZDOCQROr7lXyS+iL/QMpj07qcjGYTSdRFXUg==",

Replacement in package-lock.json at line 1489 [38.145]

B:BD[38.27983] → [44.33:188]

      "version": "github:uNetworking/uWebSockets.js#116a85f9668dcb03e7799db06dc8275bc43c0963",
      "from": "github:uNetworking/uWebSockets.js#v17.4.0"

[38.27983]

[41.12321]

      "version": "github:uNetworking/uWebSockets.js#63c610cefde1ef71c27cba6dd1072495977ee34d",
      "from": "github:uNetworking/uWebSockets.js#v18.3.0"

Replacement in package-lock.json at line 1493 [38.145]

B:BD[37.8991] → [37.8991:9228]

      "version": "1.4.2",
      "resolved": "https://registry.npmjs.org/unbzip2-stream/-/unbzip2-stream-1.4.2.tgz",
      "integrity": "sha512-pZMVAofMrrHX6Ik39hCk470kulCbmZ2SWfQLPmTWqfJV/oUm0gn1CblvHdUu4+54Je6Jq34x8kY6XjTy6dMkOg==",

[37.8991]

[37.9228]

      "version": "1.4.3",
      "resolved": "https://registry.npmjs.org/unbzip2-stream/-/unbzip2-stream-1.4.3.tgz",
      "integrity": "sha512-mlExGW4w71ebDJviH16lQLtZS32VKqsSfk80GCfUlwT/4/hNRFsoscrF/c++9xinkMzECL1uL9DDwXqFWkruPg==",

Replacement in package-lock.json at line 1543 [38.145]

B:BD[40.5473] → [37.9325:9537]

      "version": "7.2.5",
      "resolved": "https://registry.npmjs.org/ws/-/ws-7.2.5.tgz",
      "integrity": "sha512-C34cIU4+DB2vMyAbmEKossWq2ZQDr6QEyuuCzWrM9zfw1sGc0mYiJ0UnG9zzNykt49C2Fi34hvr2vssFQRS6EA=="

[40.5473]

[40.5751]

      "version": "7.3.0",
      "resolved": "https://registry.npmjs.org/ws/-/ws-7.3.0.tgz",
      "integrity": "sha512-iFtXzngZVXPGgpTlP1rBqsUK82p9tKqsWRPg5L56egiljujJT3vGAYnHANvFxBieXrTFavhzhxW52jnaWV+w2w=="

Replacement in package.json at line 9 [38.29376]
B:BD[25.153] → [25.153:186]
∅:D[37.9819] → [38.29526:29573]
∅:D[36.4530] → [38.29526:29573]
∅:D[39.2558] → [38.29526:29573]
∅:D[25.186] → [38.29526:29573]
∅:D[30.9221] → [38.29526:29573]
B:BD[38.29526] → [38.29526:29573]
B:BD[38.29573] → [42.1810:1835]
```
    "@sendgrid/mail": "^7.2.0",
    "argon2": "github:boogerlad/node-argon2",
    "bcrypt": "^4.0.1",
```
[25.153]
[38.29573]
```
    "@sendgrid/mail": "^7.2.1",
    "argon2": "^0.26.2",
    "bcrypt": "^5.0.0",
```
Replacement in package.json at line 14 [38.29376]
∅:D[37.9851] → [30.9253:9283]
B:BD[30.9253] → [30.9253:9283]
```
    "cloudinary": "^1.21.0",
```
[37.9851]
[38.29598]
```
    "cloudinary": "^1.22.0",
```
Replacement in package.json at line 16 [38.29376]
B:BD[38.29623] → [45.0:21]
B:BD[45.21] → [37.9852:9880]
```
    "pg": "^8.0.3",
    "puppeteer": "^3.0.2",
```
[38.29623]
[30.9302]
```
    "pg": "^8.2.1",
    "puppeteer": "^5.0.0",
```

Replacement in package.json at line 20 [38.29376]

B:BD[43.4874] → [44.189:256]

    "uWebSockets.js": "github:uNetworking/uWebSockets.js#v17.4.0"

[43.4874]

[38.29740]

    "uWebSockets.js": "github:uNetworking/uWebSockets.js#v18.3.0"

Replacement in scrape/common.js at line 1 [43.4897]

B:BD[43.4897] → [43.4898:4944]

require('dotenv').config({path: '../.env'});

[43.4897]

[43.4944]

require('dotenv').config({path: require('path').resolve(__dirname, '../.env')});

Deletion in scrape/common.js at line 7 [43.4897]
B:BD[43.5154] → [43.5154:5189]
```
const { Client } = require('pg');
```
Replacement in scrape/common.js at line 10 [43.4897]
B:BD[43.5322] → [43.5322:5352]
```
let postgres = new Client();
```
[43.5322]
[43.5352]
```
const postgres = new (require('pg').Client)();
```
Replacement in server.js at line 1 [16.590]
∅:D[39.2737] → [16.591:631]
B:BD[16.590] → [16.591:631]
```
const uWS = require('uWebSockets.js');
```
[16.590]
[46.0]
```
const { normalize, Big, util, request } = require('./scrape/common.js');
```
Deletion in server.js at line 5 [16.590]
B:BD[42.1871] → [47.0:52]
∅:D[47.52] → [16.666:725]
∅:D[42.1871] → [16.666:725]
B:BD[16.666] → [16.666:725]
∅:D[39.2870] → [16.874:996]
B:BD[16.874] → [16.874:996]
B:BD[16.996] → [24.29:62]
B:BD[24.62] → [42.1872:1902]
∅:D[42.1902] → [48.515:546]
B:BD[24.62] → [48.515:546]
∅:D[48.546] → [24.111:244]
B:BD[24.111] → [24.111:244]
∅:D[24.244] → [16.996:999]
B:BD[16.996] → [16.996:999]
```
const request = require('request-promise-native');
const { Pool } = require('pg');
const pool = new Pool();
function isLoggedIn(ws) {
	return ws.user_ID !== undefined;
}
function is(ws, type) {
	return ws.user_type === type;
}
function desensitize(user) {
	delete user.webportal_hash;
	delete user.passphrase_hash;
	delete user.token_hash;
	delete user.token_expiry;
	Object.keys(user).forEach((key) => (user[key] == null) && delete user[key]);
}
```

Deletion in server.js at line 6 [16.590]

B:BD[16.1034] → [16.1034:1131]

B:BD[16.1131] → [36.4554:4645]

const randomBytes = require('util').promisify(crypto.randomBytes);
require('dotenv').config();
const googleMapsClient = new (require("@googlemaps/google-maps-services-js").Client)({});

Insertion in server.js at line 8 [16.590]

[25.271]

[24.245]

const pool = new (require('pg').Pool)();
const googleMapsClient = new (require("@googlemaps/google-maps-services-js").Client)({});
const randomBytes = util.promisify(crypto.randomBytes);

Replacement in server.js at line 13 [16.590]

B:BD[24.263] → [49.0:188]

∅:D[49.188] → [50.185:276]

B:BD[50.185] → [50.185:276]

let authenticated = new Map(/*<user_ID, websocket>*/);//when we want to allow multiple sockets with same user, change to set<websockets>. have to figure out how token is supposed to work
//maybe login takes remember_me, and if not present, don't generate / persist new token??

[24.263]

[21.6292]

const authenticated = new Map(/*<user_ID, websocket>*/);
setInterval(() => pool.query('select invalidate_stale_carts()'), 1000);

Replacement in server.js at line 17 [16.590]

B:BD[21.6294] → [30.10475:10534]

const { normalize, Big } = require('./scrape/common.js');

[21.6294]

async function is(ws, store, owner) {//ws->user_ID || undefined, store_id integer || undefined, owner boolean || undefined
//https://stackoverflow.com/questions/354070/sql-join-where-clause-vs-on-clause
	return (await pool.query(`select god or (owner is not null and owner >= $1) as t from usr left join user_store on usr.user_id = user_store.user_id and store_id = $2 where usr.user_id = $3`, [Boolean(owner), store, ws.user_ID])).rows?.[0]?.t;
}

Insertion in server.js at line 39 [16.590]
[21.8416]
[51.0]

Replacement in server.js at line 43 [16.590]

∅:D[44.390] → [52.953:1026]

B:BD[51.61] → [52.953:1026]

B:BD[52.1026] → [44.391:510]

setInterval(() => pool.query('select invalidate_stale_carts()'), 1000);
const app = uWS[(ssl ? 'SSL' : '') + 'App']({key_file_name: process.env.SSLKEY, cert_file_name: process.env.SSLCERT})

[44.390]

[16.1156]

const app = require('uWebSockets.js')[(ssl ? 'SSL' : '') + 'App']({key_file_name: process.env.SSLKEY, cert_file_name: process.env.SSLCERT})

Replacement in server.js at line 50 [16.590]
B:BD[16.1280] → [46.37:66]
```
	open: async (ws, req) => {
```
[16.1280]
[53.50]
```
	upgrade: (res, req, context) => {
```

Replacement in server.js at line 52 [16.590]

B:BD[53.126] → [46.67:104]

B:BD[46.104] → [12.202:421]

			console.log('WebSocket opened');
			pool.query(`select * from get_stores()`).then(r => {
				for(let i = 0; i < r.rows.length; ++i) {
					for(const prop in r.rows[i]) {
						if(r.rows[i][prop] === null) {
							delete r.rows[i][prop];
						}

[53.126]

[12.421]

			res.upgrade(
				{q: qs.parse(req.getQuery())},
				req.getHeader('sec-websocket-key'),
				req.getHeader('sec-websocket-protocol'),
				req.getHeader('sec-websocket-extensions'),
				context
			);
		} else {
			res.close();
		}
	},
	open: async ws => {
		console.log('WebSocket opened');
		pool.query(`select * from get_stores()`).then(r => {
			for(let i = 0; i < r.rows.length; ++i) {
				for(const prop in r.rows[i]) {
					if(r.rows[i][prop] === null) {
						delete r.rows[i][prop];

Replacement in server.js at line 72 [16.590]

B:BD[12.436] → [12.436:464]

				ws.subscribe('store');

[12.436]

[12.464]

			}
			ws.subscribe('store');
			ws.send(JSON.stringify({
				what: 'store',
				how: 'replace',
				data: r.rows
			}));
		});
		let fuck;
		let hack;
		if(ws.q.token) {
			let user = (await pool.query('select user_id, email, 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 token_hash = $1 and now() < token_expiry group by user_id', [crypto.createHash('BLAKE2b512').update(Buffer.from(ws.q.token, 'base64')).digest()])).rows[0];//possible timing attack?
			if(user === undefined) {
				fuck = JSON.stringify({
					what: 'user',
					how: 'replace',
					data: null,
					why: 'invalid token'
				});
			} else {
				ws.user_ID = user.user_id;
				delete user.user_id;
				hack = user;
				let old = authenticated.get(ws.user_ID);
				authenticated.set(ws.user_ID, ws);
				if(old) {
					old.end();
				} else {
					ws.publish('user/authenticated', JSON.stringify({
						what: 'user/authenticated',//tbd
						how: 'replace',
						data: authenticated.size
					}));
				}
			}
		}
		if(ws.q.otp && (ws.q.token && fuck || !ws.q.token)) {
			//click link && original tab closed(sharedworker dead, so no preexisting connection)
			//good thing this is a fallback to token. magic links won't invalidate remember me :)
			let token = await randomBytes(128);
			let user = (await pool.query(
				`with u as (
					update usr
					set
						otp_hash = null,
						token_hash = $1
					where
						otp_hash = $2 and
						now() < otp_expiry
					returning
						user_id,
						email,
						god
				)
				select u.*, json_object_agg(store_id, owner) filter (where store_id is not null) as acl
				from u left join user_store using (user_id)
				group by user_id`,
				[
					crypto.createHash('BLAKE2b512').update(token).digest(),
					crypto.createHash('BLAKE2b512').update(Buffer.from(parameters.otp, 'base64')).digest()
				]
			)).rows[0];//possible timing attack?
			if(user === undefined) {

Replacement in server.js at line 136 [16.590]
B:BD[12.494] → [12.494:515]
```
					what: 'store',
```
[12.494]
[12.515]
```
					what: 'user',
```
Replacement in server.js at line 138 [16.590]
B:BD[12.537] → [12.537:556]
```
					data: r.rows
```
[12.537]
[12.556]
```
					data: null,
					why: 'invalid otp'
```

Replacement in server.js at line 141 [16.590]

B:BD[12.566] → [12.566:573]

∅:D[12.573] → [46.104:537]

B:BD[46.104] → [46.104:537]

			})
			let parameters = qs.parse(req.getQuery());
			if(parameters.token) {
				let user = (await pool.query('select * from usr where token_hash = $1 and now() < token_expiry', [crypto.createHash('BLAKE2b512').update(Buffer.from(parameters.token, 'base64')).digest()])).rows[0];//possible timing attack?
				if(user === undefined) {
					ws.send(JSON.stringify({
						response_ID: 'firth',
						data: 'invalid token'
					}));

[12.566]

[46.537]

				if(fuck) {
					ws.send(fuck);
				}
			} else {
				ws.user_ID = user.user_id;
				delete user.user_id;
				user.token = token.toString('base64');
				hack = user;
				let old = authenticated.get(ws.user_ID);
				authenticated.set(ws.user_ID, ws);
				if(old) {
					old.end();

Deletion in server.js at line 154 [16.590]

B:BD[46.551] → [46.551:921]

B:BD[46.921] → [10.0:38]

∅:D[10.38] → [46.976:1027]

B:BD[46.976] → [46.976:1027]

					ws.user_ID = user.user_id;
					ws.user_type = user.type;
					desensitize(user);
					ws.send(JSON.stringify({
						response_ID: 'firth',
						data: user
					}));
					//disallow multiple sockets with same credentials
					let old = authenticated.get(user.user_id);
					if(old !== undefined) {
						delete old.user_ID;
						delete old.user_type;
						old.send('{"what":"logout"}');
					}
					authenticated.set(user.user_id, ws);

Replacement in server.js at line 156 [16.590]
B:BD[46.1123] → [46.1123:1145]
```
						how: 'update',
```
[46.1123]
[46.1145]
```
						how: 'replace',
```

Replacement in server.js at line 160 [16.590]

B:BD[46.1195] → [25.272:452]

B:BD[25.452] → [15.0:91]

			} else if(parameters.otp) {
				//click link && original tab closed(sharedworker dead, so no preexisting connection)
				//debating whether or not I should implement this...
				//good thing this is a fallback to token. magic links won't invalidate remember me :)

[46.1195]

			}
		} else if(fuck) {
			ws.send(fuck);
		}
		++clients;
		ws.publish('user/count', JSON.stringify({
			what: 'user/count',//tbd
			//how: 'update',
			data: clients
		}));
		if(hack && Array.isArray(ws.q.carts) && (ws.q.carts = ws.q.carts.map(Number)).every(Number.isInteger)) {
			const client = await pool.connect();
			let m = (await client.query(`
				with f as (
					select distinct on (store_id) cart_id, store_id
					from cart
					where cart_id = any($2) and user_id is null and status = 'active'
				),
				r as (
					update cart
					set user_id = $1
					where
						cart_id in (select cart_id from f) and
						not exists(select 1 from cart as c where c.user_id = $1 and c.store_id = cart.store_id and status <= 'ready')
					returning cart_id, store_id
				)
				select * from f except select * from r
			`, [ws.user_ID, ws.q.carts])).rows;
			//todo: set based merge cart or cursor plpgsql function. this is ugly
			for(let i = 0; i < m.length; ++i) {
				let c = (await client.query({
					text: `select cart_id from cart where user_id = $1 and store_id = $2 and status = 'active'`,
					values: [ws.user_ID, m[i].store_id],
					rowMode: 'array'
				})).rows?.[0]?.[0];
				if(c) {
					let li = (await client.query({
						text: 'select line_item_id, menu_item_id, quantity from line_item where cart_id = $1',
						values: [m[i].cart_id],
						rowMode: 'array'
					})).rows;
					let later = [];
					for(let j = 0; j < li.length; ++j) {
						try {
							await client.query('savepoint wow');
							await client.query(`update line_item set cart_id = $1 where line_item_id = $2`, [c, li[j][0]]);
						} catch(e) {
							await client.query('rollback to wow');
							if(e.constraint === 'line_item_cart_id_menu_item_id_key') {
								later.push(li[j]);
							} else if(e.message === 'exceeded 30g limit') {
								later = [];
								break;
							} else {
								console.error(e);
							}
						}
					}
					for(let j = 0; j < later.length; ++j) {
						try {
							await client.query('savepoint wow');
							await client.query('update line_item set quantity = quantity + $1 where cart_id = $2 and menu_item_id = $3', [later[j][2], c, later[j][1]]);
						} catch(e) {
							await client.query('rollback to wow');
							if(e.message === 'exceeded 30g limit') {
								break;
							} else {
								console.error(e);
							}
						}
					}
				} else {
					console.log(`failed to merge cart. reservation in progress with store ${m[i].store_id}`);
				}

Replacement in server.js at line 235 [16.590]

∅:D[46.1201] → [54.85:217]

B:BD[54.85] → [54.85:217]

			++clients;
			ws.publish('user/count', JSON.stringify({
				what: 'user/count',//tbd
				//how: 'update',
				data: clients

[46.1201]

[54.217]

			await client.query('delete from cart where cart_id = any($1)', [m]);
			await client.query('commit');
			client.release();
		}
		delete ws.q;
		if(hack) {
			ws.send(JSON.stringify({
				what: 'user',
				how: 'replace',
				data: hack

Deletion in server.js at line 246 [16.590]
B:BD[54.226] → [55.126:138]
B:BD[55.138] → [46.1202:1225]
```
		} else {
			ws.close/*end*/();
```
Replacement in server.js at line 252 [16.590]
B:BD[25.477] → [25.477:503]
```
				if(isLoggedIn(ws)) {
```
[25.477]
[25.503]
```
				if(ws.user_ID) {
```
Replacement in server.js at line 277 [16.590]
B:BD[25.1632] → [25.1632:1663]
```
							data: 'user not found'
```
[25.1632]
[25.1663]
```
							data: 'user does not exist'
```
Replacement in server.js at line 283 [16.590]
B:BD[25.1827] → [25.1827:1853]
```
				if(isLoggedIn(ws)) {
```
[25.1827]
[25.1853]
```
				if(ws.user_ID) {
```

Replacement in server.js at line 290 [16.590]

B:BD[25.2016] → [25.2016:2411]

					let user = (await pool.query('update usr set otp_hash = null, token_hash = $1 where otp_hash = $2 and now() < otp_expiry returning user_id, email, type, comt, akt1, cyp2c9, cyp2c19_2, cyp2c19_3, cyp2c19_17', [crypto.createHash('BLAKE2b512').update(token).digest(), crypto.createHash('BLAKE2b512').update(Buffer.from(parameters.otp, 'base64')).digest()])).rows[0];//possible timing attack?

[25.2016]

[25.2411]

					let user = (await pool.query(
						`with u as (
							update usr
							set
								otp_hash = null,
								token_hash = $1
							where
								otp_hash = $2 and
								now() < otp_expiry
							returning
								user_id,
								email,
								god
						)
						select u.*, json_object_agg(store_id, owner) filter (where store_id is not null) as acl
						from u left join user_store using (user_id)
						group by user_id`,
						[
							crypto.createHash('BLAKE2b512').update(token).digest(),
							crypto.createHash('BLAKE2b512').update(Buffer.from(parameters.otp, 'base64')).digest()
						]
					)).rows[0];//possible timing attack?

Replacement in server.js at line 315 [16.590]
B:BD[25.2507] → [25.2507:2535]
```
							data: 'invalid otp'
```
[25.2507]
[25.2535]
```
							data: "invalid otp"
```

Replacement in server.js at line 319 [16.590]

B:BD[25.2596] → [25.2596:2655]

						ws.user_type = user.type;
						desensitize(user);

[25.2596]

[25.2655]

						if(Array.isArray(parameters.carts) && (parameters.carts = parameters.carts.map(Number)).every(Number.isInteger)) {
							const client = await pool.connect();
							let m = (await client.query(`
								with f as (
									select distinct on (store_id) cart_id, store_id
									from cart
									where cart_id = any($2) and user_id is null and status = 'active'
								),
								r as (
									update cart
									set user_id = $1
									where
										cart_id in (select cart_id from f) and
										not exists(select 1 from cart as c where c.user_id = $1 and c.store_id = cart.store_id and status <= 'ready')
									returning cart_id, store_id
								)
								select * from f except select * from r
							`, [user.user_id, parameters.carts])).rows;
							//todo: set based merge cart or cursor plpgsql function. this is ugly
							for(let i = 0; i < m.length; ++i) {
								let c = (await client.query({
									text: `select cart_id from cart where user_id = $1 and store_id = $2 and status = 'active'`,
									values: [user.user_id, m[i].store_id],
									rowMode: 'array'
								})).rows?.[0]?.[0];
								if(c) {
									let li = (await client.query({
										text: 'select line_item_id, menu_item_id, quantity from line_item where cart_id = $1',
										values: [m[i].cart_id],
										rowMode: 'array'
									})).rows;
									let later = [];
									for(let j = 0; j < li.length; ++j) {
										try {
											await client.query('savepoint wow');
											await client.query(`update line_item set cart_id = $1 where line_item_id = $2`, [c, li[j][0]]);
										} catch(e) {
											await client.query('rollback to wow');
											if(e.constraint === 'line_item_cart_id_menu_item_id_key') {
												later.push(li[j]);
											} else if(e.message === 'exceeded 30g limit') {
												later = [];
												break;
											} else {
												console.error(e);
											}
										}
									}
									for(let j = 0; j < later.length; ++j) {
										try {
											await client.query('savepoint wow');
											await client.query('update line_item set quantity = quantity + $1 where cart_id = $2 and menu_item_id = $3', [later[j][2], c, later[j][1]]);
										} catch(e) {
											await client.query('rollback to wow');
											if(e.message === 'exceeded 30g limit') {
												break;
											} else {
												console.error(e);
											}
										}
									}
								} else {
									console.log(`failed to merge cart. reservation in progress with store ${m[i].store_id}`);
								}
							}
							await client.query('delete from cart where cart_id = any($1)', [m]);
							await client.query('commit');
							client.release();
						}
						delete user.user_id;

Replacement in server.js at line 394 [16.590]

B:BD[25.2797] → [25.2797:3032]

						//disallow multiple sockets with same credentials
						let old = authenticated.get(user.user_id);
						if(old !== undefined) {
							delete old.user_ID;
							delete old.user_type;
							old.send('{"what":"logout"}');

[25.2797]

[25.3032]

						let old = authenticated.get(ws.user_ID);
						authenticated.set(ws.user_ID, ws);
						if(old) {
							old.end();
						} else {
							ws.publish('user/authenticated', JSON.stringify({
								what: 'user/authenticated',//tbd
								how: 'replace',
								data: authenticated.size
							}));

Deletion in server.js at line 405 [16.590]

B:BD[25.3041] → [25.3041:3251]

						authenticated.set(user.user_id, ws);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'update',
							data: authenticated.size
						}));

Replacement in server.js at line 409 [16.590]
B:BD[16.1575] → [16.1575:1601]
```
				if(isLoggedIn(ws)) {
```
[16.1575]
[16.1601]
```
				if(ws.user_ID) {
```

Replacement in server.js at line 416 [16.590]

B:BD[16.1734] → [29.5043:5271]

						let newUser = await pool.query('insert into usr (email, passphrase_hash) values ($1, $2) returning user_id, email, type', [parameters.email, await argon2.hash(parameters.passphrase)]);//technically, we only need the id??

[16.1734]

[16.1886]

						let token = await randomBytes(128);
						let user = (await pool.query(`
							with i as (
								insert into usr
								(email, passphrase_hash, token_hash)
								values ($1, $2, $3)
								returning user_id
							), u as (
								update cart
								set (user_id) = (select user_id from i)
								where cart_id = any($4) and user_id is null and status = 'active'
							)
							select user_id from i`,
							[
								parameters.email,
								await argon2.hash(parameters.passphrase),
								crypto.createHash('BLAKE2b512').update(token).digest(),
								parameters.carts
							])).rows[0];
						ws.user_ID = user.user_id;

Replacement in server.js at line 437 [16.590]

B:BD[16.1918] → [16.1918:1950]

							response_ID: request_ID

[16.1918]

[49.382]

							response_ID: request_ID,
							data: token.toString('base64')/*sharedworker needs to intercept this and emit virtual event
							what: 'user',
							how: 'replace',
							data: {email: fromforminput, god: false(default), acl: null(default)}*/

Insertion in server.js at line 443 [16.590]

[49.394]

						user.email = parameters.email;
						user.god = false;
						user.acl = null;

Replacement in server.js at line 449 [16.590]
B:BD[49.482] → [49.482:512]
```
							data: newUser.rows[0]
```
[49.482]
[16.1950]
```
							data: user
```

Insertion in server.js at line 452 [16.590]

[24.865]

[16.1962]

						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.set(ws.user_ID, ws).size
						}));

Replacement in server.js at line 471 [16.590]
B:BD[24.889] → [24.889:915]
```
				if(isLoggedIn(ws)) {
```
[24.889]
[29.5319]
```
				if(ws.user_ID) {
```

Deletion in server.js at line 473 [16.590]

∅:D[29.5395] → [24.995:1087]

B:BD[24.995] → [24.995:1087]

					authenticated.delete(ws.user_ID);
					delete ws.user_ID;
					delete ws.user_type;

Insertion in server.js at line 478 [16.590]
[24.1360]
[24.1360]
```
					authenticated.delete(ws.user_ID);
```
Replacement in server.js at line 481 [16.590]
B:BD[24.1456] → [24.1456:1478]
```
						how: 'update',
```
[24.1456]
[24.1478]
```
						how: 'replace',
```
Insertion in server.js at line 484 [16.590]
[24.1521]
[24.1521]
```
					ws.end();
```
Replacement in server.js at line 488 [16.590]
B:BD[24.1598] → [24.1598:1627]
```
						data: 'not logged in'
```
[24.1598]
[24.1627]
```
						data: 'unauthenticated'
```
Replacement in server.js at line 493 [16.590]
B:BD[16.2280] → [16.2280:2306]
```
				if(isLoggedIn(ws)) {
```
[16.2280]
[16.2306]
```
				if(ws.user_ID) {
```

Replacement in server.js at line 500 [16.590]

∅:D[25.3667] → [29.5396:5499]

B:BD[16.2427] → [29.5396:5499]

					let user = (await pool.query('select * from usr where email = $1', [parameters.email])).rows[0];

[25.3667]

[16.2539]

					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];

Deletion in server.js at line 510 [16.590]
∅:D[29.5536] → [16.2817:2852]
B:BD[16.2817] → [16.2817:2852]
```
								ws.user_type = user.type;
```

Replacement in server.js at line 511 [16.590]

B:BD[16.2897] → [29.5537:5738]

B:BD[29.5738] → [42.2054:2229]

								await pool.query('update usr set token_hash = $1 where user_id = $2', [crypto.createHash('BLAKE2b512').update(token).digest(), user.user_id]);//update to blake3 once it's available in openSSL
								desensitize(user);
								user.token = token.toString('base64');//yuck, since json can't send binary, need to base64 encode. fyi base64 is smaller than hex(base16)

[16.2897]

[42.2229]

								const client = await pool.connect();
								await client.query('update usr set token_hash = $1 where user_id = $2', [crypto.createHash('BLAKE2b512').update(token).digest(), user.user_id]);//update to blake3 once it's available in openSSL
								if(Array.isArray(parameters.carts) && (parameters.carts = parameters.carts.map(Number)).every(Number.isInteger)) {
									let m = (await client.query(`
										with f as (
											select distinct on (store_id) cart_id, store_id
											from cart
											where cart_id = any($2) and user_id is null and status = 'active'
										),
										r as (
											update cart
											set user_id = $1
											where
												cart_id in (select cart_id from f) and
												not exists(select 1 from cart as c where c.user_id = $1 and c.store_id = cart.store_id and status <= 'ready')
											returning cart_id, store_id
										)
										select * from f except select * from r
									`, [user.user_id, parameters.carts])).rows;
									//todo: set based merge cart or cursor plpgsql function. this is ugly
									for(let i = 0; i < m.length; ++i) {
										let c = (await client.query({
											text: `select cart_id from cart where user_id = $1 and store_id = $2 and status = 'active'`,
											values: [user.user_id, m[i].store_id],
											rowMode: 'array'
										})).rows?.[0]?.[0];
										if(c) {
											let li = (await client.query({
												text: 'select line_item_id, menu_item_id, quantity from line_item where cart_id = $1',
												values: [m[i].cart_id],
												rowMode: 'array'
											})).rows;
											let later = [];
											for(let j = 0; j < li.length; ++j) {
												try {
													await client.query('savepoint wow');
													await client.query(`update line_item set cart_id = $1 where line_item_id = $2`, [c, li[j][0]]);
												} catch(e) {
													await client.query('rollback to wow');
													if(e.constraint === 'line_item_cart_id_menu_item_id_key') {
														later.push(li[j]);
													} else if(e.message === 'exceeded 30g limit') {
														later = [];
														break;
													} else {
														console.error(e);
													}
												}
											}
											for(let j = 0; j < later.length; ++j) {
												try {
													await client.query('savepoint wow');
													await client.query('update line_item set quantity = quantity + $1 where cart_id = $2 and menu_item_id = $3', [later[j][2], c, later[j][1]]);
												} catch(e) {
													await client.query('rollback to wow');
													if(e.message === 'exceeded 30g limit') {
														break;
													} else {
														console.error(e);
													}
												}
											}
										} else {
											console.log(`failed to merge cart. reservation in progress with store ${m[i].store_id}`);
										}
									}
									await client.query('delete from cart where cart_id = any($1)', [m]);
								}
								await client.query('commit');
								client.release();
								//yuck, since json can't send binary, need to base64 encode. fyi base64 is smaller than hex(base16)

Replacement in server.js at line 586 [16.590]

B:BD[42.2515] → [42.2515:2536]

									data: user

[42.2515]

[42.2536]

									data: {token: token.toString('base64'), god: user.god, acl: user.acl}

Replacement in server.js at line 588 [16.590]

B:BD[42.2550] → [42.2550:2756]

B:BD[42.2756] → [10.39:80]

								//disallow multiple sockets with same credentials
								let old = authenticated.get(user.user_id);
								if(old !== undefined) {
									delete old.user_ID;
									delete old.user_type;
									old.send('{"what":"logout"}');

[42.2550]

[42.2791]

								let old = authenticated.get(ws.user_ID);
								authenticated.set(ws.user_ID, ws);
								if(old) {
									old.end();
								} else {
									ws.publish('user/authenticated', JSON.stringify({
										what: 'user/authenticated',//tbd
										how: 'replace',
										data: authenticated.size
									}));

Deletion in server.js at line 599 [16.590]

B:BD[42.2802] → [42.2802:3024]

								authenticated.set(user.user_id, ws);
								ws.publish('user/authenticated', JSON.stringify({
									what: 'user/authenticated',//tbd
									how: 'update',
									data: authenticated.size
								}));

Deletion in server.js at line 601 [16.590]
B:BD[42.3279] → [42.3279:3314]
```
								ws.user_type = user.type;
```

Replacement in server.js at line 602 [16.590]

B:BD[42.3359] → [42.3359:3647]

∅:D[42.3647] → [24.1658:1686]

∅:D[29.5738] → [24.1658:1686]

B:BD[16.3097] → [24.1658:1686]

∅:D[24.1686] → [16.3198:3345]

B:BD[16.3198] → [16.3198:3345]

								await pool.query('update usr set token_hash = $1, passphrase_hash = $3, webportal_hash = null where user_id = $2', [crypto.createHash('BLAKE2b512').update(token).digest(), user.user_id, await argon2.hash(parameters.passphrase)]);//update to blake3 once it's available in openSSL
								desensitize(user);
								user.token = token.toString('base64');//yuck, since json can't send binary, need to base64 encode. fyi base64 is smaller than hex(base16)

[42.3359]

[24.1687]

								const client = await pool.connect();
								await client.query('update usr set token_hash = $1, passphrase_hash = $3, webportal_hash = null where user_id = $2', [crypto.createHash('BLAKE2b512').update(token).digest(), user.user_id, await argon2.hash(parameters.passphrase)]);//update to blake3 once it's available in openSSL
								if(Array.isArray(parameters.carts) && (parameters.carts = parameters.carts.map(Number)).every(Number.isInteger)) {
									let m = (await client.query(`
										with f as (
											select distinct on (store_id) cart_id, store_id
											from cart
											where cart_id = any($2) and user_id is null and status = 'active'
										),
										r as (
											update cart
											set user_id = $1
											where
												cart_id in (select cart_id from f) and
												not exists(select 1 from cart as c where c.user_id = $1 and c.store_id = cart.store_id and status <= 'ready')
											returning cart_id, store_id
										)
										select * from f except select * from r
									`, [user.user_id, parameters.carts])).rows;
									//todo: set based merge cart or cursor plpgsql function. this is ugly
									for(let i = 0; i < m.length; ++i) {
										let c = (await client.query({
											text: `select cart_id from cart where user_id = $1 and store_id = $2 and status = 'active'`,
											values: [user.user_id, m[i].store_id],
											rowMode: 'array'
										})).rows?.[0]?.[0];
										if(c) {
											let li = (await client.query({
												text: 'select line_item_id, menu_item_id, quantity from line_item where cart_id = $1',
												values: [m[i].cart_id],
												rowMode: 'array'
											})).rows;
											let later = [];
											for(let j = 0; j < li.length; ++j) {
												try {
													await client.query('savepoint wow');
													await client.query(`update line_item set cart_id = $1 where line_item_id = $2`, [c, li[j][0]]);
												} catch(e) {
													await client.query('rollback to wow');
													if(e.constraint === 'line_item_cart_id_menu_item_id_key') {
														later.push(li[j]);
													} else if(e.message === 'exceeded 30g limit') {
														later = [];
														break;
													} else {
														console.error(e);
													}
												}
											}
											for(let j = 0; j < later.length; ++j) {
												try {
													await client.query('savepoint wow');
													await client.query('update line_item set quantity = quantity + $1 where cart_id = $2 and menu_item_id = $3', [later[j][2], c, later[j][1]]);
												} catch(e) {
													await client.query('rollback to wow');
													if(e.message === 'exceeded 30g limit') {
														break;
													} else {
														console.error(e);
													}
												}
											}
										} else {
											console.log(`failed to merge cart. reservation in progress with store ${m[i].store_id}`);
										}
									}
									await client.query('delete from cart where cart_id = any($1)', [m]);
								}
								await client.query('commit');
								client.release();
								//yuck, since json can't send binary, need to base64 encode. fyi base64 is smaller than hex(base16)

Replacement in server.js at line 677 [16.590]

B:BD[16.3500] → [16.3500:3521]

									data: user

[16.3500]

[16.3521]

									data: {token: token.toString('base64'), god: user.god, acl: user.acl}

Replacement in server.js at line 679 [16.590]

B:BD[16.3535] → [24.1905:1964]

B:BD[24.1964] → [29.5739:5791]

∅:D[29.5791] → [24.2011:2106]

B:BD[24.2011] → [24.2011:2106]

B:BD[24.2106] → [10.81:122]

								//disallow multiple sockets with same credentials
								let old = authenticated.get(user.user_id);
								if(old !== undefined) {
									delete old.user_ID;
									delete old.user_type;
									old.send('{"what":"logout"}');

[16.3535]

[24.2141]

								let old = authenticated.get(ws.user_ID);
								authenticated.set(ws.user_ID, ws);
								if(old) {
									old.end();
								} else {
									ws.publish('user/authenticated', JSON.stringify({
										what: 'user/authenticated',//tbd
										how: 'replace',
										data: authenticated.size
									}));

Deletion in server.js at line 690 [16.590]

B:BD[24.2152] → [29.5792:5838]

∅:D[29.5838] → [24.2193:2369]

B:BD[24.2193] → [24.2193:2369]

								authenticated.set(user.user_id, ws);
								ws.publish('user/authenticated', JSON.stringify({
									what: 'user/authenticated',//tbd
									how: 'update',
									data: authenticated.size
								}));

Replacement in server.js at line 707 [16.590]
B:BD[16.5216] → [24.3051:3077]
```
				if(isLoggedIn(ws)) {
```
[16.5216]
[29.6201]
```
				if(ws.user_ID) {
```
Deletion in server.js at line 709 [16.590]
∅:D[29.6315] → [24.3195:3287]
B:BD[24.3195] → [24.3195:3287]
```
					authenticated.delete(ws.user_ID);
					delete ws.user_ID;
					delete ws.user_type;
```
Insertion in server.js at line 712 [16.590]
[24.3360]
[24.3360]
```
					authenticated.delete(ws.user_ID);
```
Replacement in server.js at line 715 [16.590]
B:BD[24.3456] → [24.3456:3478]
```
						how: 'update',
```
[24.3456]
[24.3478]
```
						how: 'replace',
```
Replacement in server.js at line 718 [16.590]
B:BD[24.3521] → [24.3521:3523]
[24.3521]
[24.3523]
```
					ws.end();
```
Replacement in server.js at line 722 [16.590]
B:BD[24.3600] → [24.3600:3629]
```
						data: 'not logged in'
```
[24.3600]
[24.3629]
```
						data: 'unauthenticated'
```

Replacement in server.js at line 726 [16.590]

B:BD[16.5284] → [16.5284:5307]

B:BD[16.5307] → [24.3648:3700]

B:BD[24.3700] → [29.6316:6411]

∅:D[29.6411] → [24.3804:4340]

B:BD[24.3804] → [24.3804:4340]

			case 'list_users':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {
						let users = (await pool.query('select * from usr')).rows;//* is a bad idea... fix later
						for(let i = 0; i < users.length; ++i) {
							desensitize(users[i]);//shouldn't need this loop
						}
						ws.subscribe('user/#');//maybe for each subscribe call, call unsubscribeAll before (0.17.1 not released yet)?
						//I suppose the only issue with over subscribe is waste of resources - and if user type changes
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: users
						}));
					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'forbidden'

[16.5284]

[24.4340]

			case 'list_users': {
				const auth = await is(ws);
				if(auth) {
					ws.subscribe('user/#');//if user type changes, need to auto unsubscribe somehow
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: (await pool.query('select user_id, email, comt, akt1, cyp2c9, cyp2c19_2, cyp2c19_3, cyp2c19_17 from usr')).rows
					}));
				} else if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size

Insertion in server.js at line 742 [16.590]
[24.4352]
[24.4352]
```
						delete ws.user_ID;
```

Insertion in server.js at line 744 [16.590]

[24.4360]

[16.5482]

					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null

Replacement in server.js at line 752 [16.590]
B:BD[24.4452] → [24.4452:4463]
```
					}));
```
[24.4452]
[16.5627]
```
					}));//client side virtual event user god false
```

Replacement in server.js at line 754 [16.590]

B:BD[16.5634] → [16.5634:5646]

B:BD[16.5646] → [24.4464:4576]

				break;
			// case 'update_user' for god, case 'update_profile' for self(change pw new token, return user and ws.user)

[16.5634]

[25.3668]

				break;}
			// case 'update_user' for god bulk edit

Replacement in server.js at line 757 [16.590]
B:BD[25.3695] → [25.3695:3721]
```
				if(isLoggedIn(ws)) {
```
[25.3695]
[25.3721]
```
				if(ws.user_ID) {
```

Replacement in server.js at line 768 [16.590]

B:BD[25.4085] → [25.4085:4251]

							await pool.query(`update usr set ${dawg.join(',')} where user_id = $1`, poop);
							ws.send(JSON.stringify({
								response_ID: request_ID
							}));

[25.4085]

[25.4251]

							if((await pool.query(`update usr set ${dawg.join(',')} where user_id = $1`, poop)).rowCount) {
								ws.send(JSON.stringify({
									response_ID: request_ID
								}));
							} else {
								authenticated.delete(ws.user_ID);
								ws.publish('user/authenticated', JSON.stringify({
									what: 'user/authenticated',//tbd
									how: 'replace',
									data: authenticated.size
								}));
								delete ws.user_ID;
								ws.send(JSON.stringify({
									response_ID: request_ID,
									data: 'unauthenticated'
								}));
							}

Replacement in server.js at line 805 [16.590]
B:BD[25.4762] → [25.4762:4791]
```
						data: 'not logged in'
```
[25.4762]
[25.4791]
```
						data: 'unauthenticated'
```

Replacement in server.js at line 809 [16.590]

∅:D[25.4821] → [39.3100:3177]

B:BD[24.4576] → [39.3100:3177]

B:BD[39.3177] → [30.10535:10652]

∅:D[30.10652] → [36.5238:5483]

B:BD[36.5238] → [36.5238:5483]

B:BD[36.5483] → [47.72:105]

B:BD[47.105] → [11.0:117]

∅:D[11.117] → [47.222:274]

B:BD[47.222] → [47.222:274]

∅:D[47.274] → [36.5515:5866]

B:BD[36.5515] → [36.5515:5866]

			case 'create_store':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {
						if(notmissing(parameters, ['name', 'address', 'city', 'region', 'country', 'postal_code'], ws, request_ID)) {
							let params = [
								parameters.name,
								parameters.URL,
								parameters.address,
								parameters.address2 ? parameters.address2 : null,
								parameters.city,
								parameters.region,
								parameters.country,
								parameters.postal_code,
								Boolean(parameters.delivery),
								Boolean(parameters.pickup),
								Boolean(parameters.prepayment),
								parameters.phone ? parameters.phone : null
							];
							//I went through the effort of delaying gapi as long as I could and folding three inserts into one transaction, only for the unique constraint to goof me up. Likely won't happen often though, so accept the tradeoff.
							let q = 1;
							let query = '';
							if(Array.isArray(parameters.taxes) && parameters.taxes.length) {

[25.4821]

[36.5866]

			case 'create_store': {
				const auth = await is(ws);
				if(auth) {
					if(notmissing(parameters, ['name', 'address', 'city', 'region', 'country', 'postal_code'], ws, request_ID)) {
						let params = [
							parameters.name,
							parameters.URL,
							parameters.address,
							parameters.address2 ? parameters.address2 : null,
							parameters.city,
							parameters.region,
							parameters.country,
							parameters.postal_code,
							Boolean(parameters.delivery),
							Boolean(parameters.pickup),
							Boolean(parameters.prepayment),
							parameters.phone ? parameters.phone : null
						];
						//I went through the effort of delaying gapi as long as I could and folding three inserts into one transaction, only for the unique constraint to goof me up. Likely won't happen often though, so accept the tradeoff.
						let q = 1;
						let query = '';
						if(Array.isArray(parameters.taxes) && parameters.taxes.length) {
							query += `, insert${++q} as (
								insert into store_tax (store_id, name, rate, types)
								values ${parameters.taxes.map(tax => `((select store_id from insert1), $${params.push(tax.name)}, $${params.push(tax.rate)}, $${params.push(tax.types)})`).join(', ')}
							)`;
						}
						if(Array.isArray(parameters.times)) {
							let fuck = [];
							for(let i = 0; i < parameters.times.length; ++i) {
								try {
									let ts = parameters.times[i].time_start.split(':');
									ts = Number(parameters.times[i].day_start) * 1440 + Number(ts[0]) * 60 + Number(ts[1]);
									let te = parameters.times[i].time_end.split(':');
									te = Number(parameters.times[i].day_end) * 1440 + Number(te[0]) * 60 + Number(te[1]);
									if(te <= ts) {
										fuck.push(`(int4range($${params.push(ts)}, 10080)),(int4range(0, $${params.push(te)}))`);
										//oops possibly 0,0 empty range. nvm good job range_agg
									} else {
										fuck.push(`(int4range($${params.push(ts)}, $${params.push(te)}))`);
									}
								} catch(e) {}
							}
							if(fuck.length) {

Replacement in server.js at line 854 [16.590]

B:BD[36.5905] → [29.6412:6616]

									insert into store_tax (store_id, name, rate)
									values ${parameters.taxes.map(tax => `((select store_id from insert1), $${params.push(tax.name)}, $${params.push(tax.rate)})`).join(', ')}

[36.5905]

[36.6100]

									insert into store_time (store_id, open)
									select store_id, unnest from insert1 cross join (select unnest(range_agg(column1, true, true)) from (values ${fuck.join(',')}) as ex) as idc

Replacement in server.js at line 858 [16.590]

B:BD[36.6123] → [13.125:1230]

							if(Array.isArray(parameters.times)) {
								let fuck = [];
								for(let i = 0; i < parameters.times.length; ++i) {
									try {
										let ts = parameters.times[i].time_start.split(':');
										ts = Number(parameters.times[i].day_start) * 1440 + Number(ts[0]) * 60 + Number(ts[1]);
										let te = parameters.times[i].time_end.split(':');
										te = Number(parameters.times[i].day_end) * 1440 + Number(te[0]) * 60 + Number(te[1]);
										if(te <= ts) {
											fuck.push(`(int4range($${params.push(ts)}, 10080)),(int4range(0, $${params.push(te)}))`);
											//oops possibly 0,0 empty range. nvm good job range_agg
										} else {
											fuck.push(`(int4range($${params.push(ts)}, $${params.push(te)}))`);
										}
									} catch(e) {}
								}
								if(fuck.length) {
									query += `, insert${++q} as (
										insert into store_time (store_id, open)
										select store_id, unnest from insert1 cross join (select unnest(range_agg(column1, true, true)) from (values ${fuck.join(',')}) as ex) as idc
									)`;
								}

[36.6123]

[36.7264]

						}
						if(Array.isArray(parameters.images) && parameters.images.length) {
							query += `, insert${++q} as (
								insert into store_image (store_id, URL)
								values ${parameters.images.map(image => `((select store_id from insert1), $${params.push(image)})`).join(', ')}
							)`;
						}
						/*
						two google maps api error handlers because their api is inconsistent as fuck
						missing api key will return 'REQUEST_DENIED', but 200, so (2)
						wrong parameters will return 'INVALID_REQUEST', so 400 (1) for geocode
						but 200 (2) for timezone!! 400 throws automatically, but 200 need to be thrown manually
						*/
						let location;
						try {
							location = (await googleMapsClient.geocode({params: {address: `${parameters.address}, ${parameters.address2}, ${parameters.city}, ${parameters.region}, ${parameters.country}, ${parameters.postal_code}`, key: process.env.GAPI}})).data;
							if(location.status === 'OK') {
								location = location.results[0].geometry.location;
							} else {
								throw location;

Replacement in server.js at line 879 [16.590]

B:BD[36.7274] → [36.7274:7388]

B:BD[36.7388] → [29.6757:6929]

∅:D[29.6929] → [36.7551:7564]

B:BD[36.7551] → [36.7551:7564]

							if(Array.isArray(parameters.images) && parameters.images.length) {
								query += `, insert${++q} as (
									insert into store_image (store_id, URL)
									values ${parameters.images.map(image => `((select store_id from insert1), $${params.push(image)})`).join(', ')}
								)`;

[36.7274]

[36.7564]

						} catch(e) {
							if(e.response) {
								console.error(e.response.data);//google maps api(1)

Replacement in server.js at line 883 [16.590]

B:BD[36.7574] → [36.7574:8306]

∅:D[36.8306] → [39.5468:5486]

B:BD[39.5468] → [39.5468:5486]

B:BD[39.5486] → [36.8307:8333]

∅:D[36.8333] → [39.5521:5532]

B:BD[39.5521] → [39.5521:5532]

B:BD[39.5532] → [36.8334:8736]

							/*
							two google maps api error handlers because their api is inconsistent as fuck
							missing api key will return 'REQUEST_DENIED', but 200, so (2)
							wrong parameters will return 'INVALID_REQUEST', so 400 (1) for geocode
							but 200 (2) for timezone!! 400 throws automatically, but 200 need to be thrown manually
							*/
							let location;
							try {
								location = (await googleMapsClient.geocode({params: {address: `${parameters.address}, ${parameters.address2}, ${parameters.city}, ${parameters.region}, ${parameters.country}, ${parameters.postal_code}`, key: process.env.GAPI}})).data;
								if(location.status === 'OK') {
									location = location.results[0].geometry.location;
								} else {
									throw location;
								}
							} catch(e) {
								if(e.response) {
									console.error(e.response.data);//google maps api(1)
								}
								else if(e.status) {
									console.error(e);//google maps api(2)
								}
								ws.send(JSON.stringify({
									response_ID: request_ID,
									data: 'google geocode failure'
								}));//todo: status: 'ZERO_RESULTS' => "invalid address :("
								break;

[36.7574]

[39.5582]

							else if(e.status) {
								console.error(e);//google maps api(2)

Replacement in server.js at line 886 [16.590]

B:BD[39.5592] → [47.275:588]

∅:D[47.588] → [36.8737:9342]

B:BD[39.5592] → [36.8737:9342]

							let hints = Promise.all([
								request(`http://127.0.0.1:5000/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint),
								request(`http://127.0.0.1:5001/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint)
							]);
							let tz;
							try {
								tz = (await googleMapsClient.timezone({params: {location, timestamp: 0, key: process.env.GAPI}})).data;
								if(tz.status === 'OK') {
									tz = tz.timeZoneId;
								} else {
									throw tz;
								}
							} catch(e) {
								if(e.response) {
									console.error(e.response.data);//google maps api(1)
								}
								else if(e.status) {
									console.error(e);//google maps api(2)
								}
								ws.send(JSON.stringify({
									response_ID: request_ID,
									data: 'google timezone failure'
								}));
								break;

[39.5592]

[39.5756]

							ws.send(JSON.stringify({
								response_ID: request_ID,
								data: 'google geocode failure'
							}));//todo: status: 'ZERO_RESULTS' => "invalid address :("
							break;
						}
						let hints = Promise.all([
							request(`http://127.0.0.1:5000/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint),
							request(`http://127.0.0.1:5001/nearest/v1/fuck/${location.lng},${location.lat}`).then(x => JSON.parse(x).waypoints[0].hint)
						]);
						let tz;
						try {
							tz = (await googleMapsClient.timezone({params: {location, timestamp: 0, key: process.env.GAPI}})).data;
							if(tz.status === 'OK') {
								tz = tz.timeZoneId;
							} else {
								throw tz;

Replacement in server.js at line 904 [16.590]

B:BD[39.5766] → [47.589:618]

∅:D[47.618] → [36.9343:9499]

B:BD[39.5766] → [36.9343:9499]

B:BD[36.9499] → [47.619:1407]

∅:D[47.1407] → [29.6930:6959]

∅:D[30.10912] → [29.6930:6959]

B:BD[36.9756] → [29.6930:6959]

∅:D[29.6959] → [36.9779:9798]

B:BD[36.9779] → [36.9779:9798]

B:BD[36.9798] → [29.6960:7000]

∅:D[29.7000] → [36.9832:9870]

B:BD[36.9832] → [36.9832:9870]

B:BD[36.9870] → [47.1408:1621]

∅:D[47.1621] → [36.9919:11131]

∅:D[29.7056] → [36.9919:11131]

B:BD[36.9919] → [36.9919:11131]

							hints = await hints;
							//promise then catch is fine since this is the last thing to do this function. don't need to break;
							pool.query(
								`with insert1 as (
									insert into store (
										name,
										url,
										address,
										address2,
										city,
										region,
										country,
										postal_code,
										delivery,
										pickup,
										prepayment,
										phone,
										longitude,
										latitude,
										osrm_hint_foot,
										osrm_hint_car,
										timezone
									) values (
										$1,
										$2,
										$3,
										$4,
										$5,
										$6,
										$7,
										$8,
										$9,
										$10,
										$11,
										$12,
										$${params.push(location.lng)},
										$${params.push(location.lat)},
										$${params.push(hints[0])},
										$${params.push(hints[1])},
										$${params.push(tz)}
									)
									returning store_id
								)${query}
								select store_id from insert1`,
								params
							).then(r => {
								ws.publish('store', JSON.stringify({
									what: 'store',
									how: 'add',
									data: {
										store_id: r.rows[0].store_id,
										//other relevant fields
									}
								}));
								ws.send(JSON.stringify({
									response_ID: request_ID
								}));
							}).catch(e => {
								/* todo
								Class 23 https://www.postgresql.org/docs/current/errcodes-appendix.html with e.code
								e.table
								https://stackoverflow.com/a/4108266
								use implicit names in initialize.sql. then, can use e.constraint, remove e.table + _ from beginning, remove suffix to see which columns are affected
								e.detail is fine for 23505, but 23514 just complains about the row as a whole. how can we get the specific details? https://stackoverflow.com/a/47972916 for python...
useful
  code: '23505',
  detail: 'Key (store, name)=(21, hst) already exists.',
useless
  [message]: 'new row for relation "store_tax" violates check constraint "store_tax_rate_check"',
  name: 'error',
  length: 266,
  severity: 'ERROR',
  code: '23514',
  detail: 'Failing row contains (15, 28, hst, 2, 2020-02-11 20:20:54.923496-05, infinity).',
what I want: rate > 0 and rate < 1
2 > 0 and 2 < 1
true and false
false
								*/
								console.log(e);
								ws.send(JSON.stringify({
									response_ID: request_ID,
									data: 'db fuckup'
								}));
							});

[39.5766]

[39.5867]

						} catch(e) {
							if(e.response) {
								console.error(e.response.data);//google maps api(1)
							}
							else if(e.status) {
								console.error(e);//google maps api(2)
							}
							ws.send(JSON.stringify({
								response_ID: request_ID,
								data: 'google timezone failure'
							}));
							break;

Replacement in server.js at line 917 [16.590]

B:BD[39.5876] → [39.5876:5982]

					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'forbidden'

[39.5876]

[39.5982]

						hints = await hints;
						//promise then catch is fine since this is the last thing to do this function. don't need to break;
						pool.query(
							`with insert1 as (
								insert into store (
									name,
									url,
									address,
									address2,
									city,
									region,
									country,
									postal_code,
									delivery,
									pickup,
									prepayment,
									phone,
									longitude,
									latitude,
									osrm_hint_foot,
									osrm_hint_car,
									timezone
								) values (
									$1,
									$2,
									$3,
									$4,
									$5,
									$6,
									$7,
									$8,
									$9,
									$10,
									$11,
									$12,
									$${params.push(location.lng)},
									$${params.push(location.lat)},
									$${params.push(hints[0])},
									$${params.push(hints[1])},
									$${params.push(tz)}
								)
								returning store_id
							)${query}
							select * from get_stores((select store_id from insert1))`,
							params
						).then(r => {
							ws.publish('store', JSON.stringify({
								what: 'store',
								how: 'add',
								data: r.rows[0]
							}));
							ws.send(JSON.stringify({
								response_ID: request_ID
							}));
						}).catch(e => {
							/* todo
							Class 23 https://www.postgresql.org/docs/current/errcodes-appendix.html with e.code
							e.table
							https://stackoverflow.com/a/4108266
							use implicit names in initialize.sql. then, can use e.constraint, remove e.table + _ from beginning, remove suffix to see which columns are affected
							e.detail is fine for 23505, but 23514 just complains about the row as a whole. how can we get the specific details? https://stackoverflow.com/a/47972916 for python...
							useful
							  code: '23505',
							  detail: 'Key (store, name)=(21, hst) already exists.',
							useless
							  [message]: 'new row for relation "store_tax" violates check constraint "store_tax_rate_check"',
							  name: 'error',
							  length: 266,
							  severity: 'ERROR',
							  code: '23514',
							  detail: 'Failing row contains (15, 28, hst, 2, 2020-02-11 20:20:54.923496-05, infinity).',
							what I want: rate > 0 and rate < 1
							2 > 0 and 2 < 1
							true and false
							false
							*/
							console.log(e);
							ws.send(JSON.stringify({
								response_ID: request_ID,
								data: 'db fuckup'
							}));
						});
					}
				} else if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size

Insertion in server.js at line 1009 [16.590]
[39.5994]
[39.5994]
```
						delete ws.user_ID;
```

Insertion in server.js at line 1011 [16.590]

[39.6002]

					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null

Replacement in server.js at line 1019 [16.590]
B:BD[39.6107] → [56.60:71]
```
					}));
```
[39.6107]
[56.71]
```
					}));//client side virtual event user god false
```
Replacement in server.js at line 1021 [16.590]
B:BD[56.78] → [56.78:90]
```
				break;
```
[56.78]
[47.1870]
```
				break;}
```

Replacement in server.js at line 1057 [16.590]

∅:D[57.1681] → [58.1047:1221]

B:BD[58.1047] → [58.1047:1221]

B:BD[58.1221] → [2.0:37]

∅:D[2.37] → [58.1272:1390]

B:BD[58.1272] → [58.1272:1390]

			case 'cloudinary_preset':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {// || is(ws, 'store owner')
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: process.env.CLOUDINARY
						}));
					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'forbidden'

[47.3786]

[58.1390]

			case 'cloudinary_preset': {
				//owner is not null if want to accept >= store worker as well. right now just >= store owner
				const auth = (await pool.query(`select god or owner as t from usr left join user_store using (user_id) where user_id = $1 order by owner desc nulls last limit 1`, [ws.user_ID])).rows?.[0]?.t;
				if(auth) {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: process.env.CLOUDINARY
					}));
				} else if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size

Insertion in server.js at line 1073 [16.590]
[58.1402]
[58.1402]
```
						delete ws.user_ID;
```

Insertion in server.js at line 1075 [16.590]

[58.1410]

					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null

Insertion in server.js at line 1083 [16.590]

[58.1515]

[21.8427]

					}));//client side virtual event user god false
					let r = (await pool.query({text: 'select store_id, owner from user_store where user_id = $1', values: [ws.user_ID], rowMode: 'array'})).rows;
					ws.send(JSON.stringify({
						what: 'user',
						how: 'update',
						data: r.length ? Object.fromEntries(r) : null

Replacement in server.js at line 1091 [16.590]

B:BD[21.8445] → [21.8445:8457]

B:BD[21.8457] → [18.3958:3983]

∅:D[18.3983] → [21.8485:8537]

B:BD[21.8485] → [21.8485:8537]

B:BD[21.8537] → [29.7310:7627]

∅:D[29.7627] → [18.4613:4624]

∅:D[59.185] → [18.4613:4624]

B:BD[18.4613] → [18.4613:4624]

∅:D[18.4624] → [21.8537:8602]

B:BD[21.8537] → [21.8537:8602]

B:BD[21.8602] → [29.7628:7663]

				break;
			case 'product_form':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {
						const [strains, pgenum] = await Promise.all([
							pool.query('select strain_id as id, display_name as name from strain').then(x => x.rows),
							pool.query('select array_to_json(enum_range(null::species)) as species, array_to_json(enum_range(null::product_type)) as product_types').then(x => x.rows[0])
						]);
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: {strains, ...pgenum}

[21.8445]

[21.8685]

				break;}
			case 'product_form': {
				//owner is not null if want to accept >= store worker as well. right now just >= store owner
				const auth = (await pool.query(`select god or owner as t from usr left join user_store using (user_id) where user_id = $1 order by owner desc nulls last limit 1`, [ws.user_ID])).rows?.[0]?.t;
				if(auth) {
					const [strains, pgenum] = await Promise.all([
						pool.query('select strain_id as id, display_name as name from strain').then(x => x.rows),
						pool.query('select array_to_json(enum_range(null::species)) as species, array_to_json(enum_range(null::product_type)) as product_types').then(x => x.rows[0])
					]);
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: {strains, ...pgenum}
					}));
				} else if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size

Replacement in server.js at line 1112 [16.590]

B:BD[21.8697] → [21.8697:8815]

					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'forbidden'
						}));

[21.8697]

[21.8815]

						delete ws.user_ID;

Insertion in server.js at line 1114 [16.590]

[21.8823]

					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null

Insertion in server.js at line 1122 [16.590]

[21.8928]

					}));//client side virtual event user god false
					let r = (await pool.query({text: 'select store_id, owner from user_store where user_id = $1', values: [ws.user_ID], rowMode: 'array'})).rows;
					ws.send(JSON.stringify({
						what: 'user',
						how: 'update',
						data: r.length ? Object.fromEntries(r) : null

Replacement in server.js at line 1130 [16.590]

B:BD[21.8946] → [21.8946:9011]

B:BD[21.9011] → [29.7664:7690]

∅:D[60.929] → [21.9037:9050]

∅:D[29.7690] → [21.9037:9050]

B:BD[21.9037] → [21.9037:9050]

B:BD[21.9050] → [29.7691:7710]

B:BD[29.7710] → [30.10913:11549]

∅:D[30.11549] → [61.171:250]

∅:D[29.8171] → [61.171:250]

B:BD[61.171] → [61.171:250]

B:BD[30.11571] → [30.11571:11615]

B:BD[30.11615] → [62.907:971]

∅:D[62.971] → [30.11733:11771]

B:BD[30.11733] → [30.11733:11771]

B:BD[30.11771] → [62.972:1027]

∅:D[62.1027] → [30.11908:11962]

B:BD[30.11908] → [30.11908:11962]

B:BD[30.11962] → [62.1028:1258]

				break;
			case 'create_product':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {
						try {
							let q = 1;
							let [producer, brand, joined_name, display_name] = normalize(parameters.brand, parameters.name, parameters.type);
							let params = [
								producer,
								brand,
								joined_name,
								display_name,
								parameters.type,
								parameters.species,
								parameters.strain,
								parameters.description,
								parameters.terpenes
							];
							let query = `with insert1 as (insert into product (producer, brand, display_name, joined_name, type, species, strain_id, description, terpenes, show) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, true) on conflict do nothing returning product_id)`;
							if(Array.isArray(parameters.variants) && parameters.variants.length) {
								if(parameters.type === 'flower') {
									let values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.quantity)) {
											acc.push(`($${params.push(v.quantity)})`);
										}
										return acc;
									}, []);
									if(values.length) {
										query += `, insert${++q} as (insert into variant (product_id, quantity) select product_id, x::numeric from insert1 cross join (values ${values.join(',')}) as t(x) on conflict do nothing)`;

[21.8946]

[62.1258]

				break;}
			case 'create_product': {
				const auth = (await pool.query(`select god, owner from usr left join user_store using (user_id) where user_id = $1 order by owner desc nulls last limit 1`, [ws.user_ID])).rows?.[0];
				if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size
						}));
						delete ws.user_ID;
					}
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null
				} else if(auth.god || auth.owner) {
					try {
						let q = 1;
						let [producer, brand, joined_name, display_name] = normalize(parameters.brand, parameters.name, parameters.type);
						let params = [
							producer,
							brand,
							joined_name,
							display_name,
							parameters.type,
							parameters.species,
							parameters.strain,
							parameters.description,
							parameters.terpenes,
							auth.god
						];
						let query = `with insert1 as (insert into product (producer, brand, display_name, joined_name, type, species, strain_id, description, terpenes, show) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) on conflict do nothing returning product_id)`;
						if(Array.isArray(parameters.variants) && parameters.variants.length) {
							if(parameters.type === 'flower') {
								let values = parameters.variants.reduce((acc, v) => {
									if(isFinite(v.quantity)) {
										acc.push(`($${params.push(v.quantity)})`);

Replacement in server.js at line 1170 [16.590]

B:BD[62.1270] → [62.1270:1542]

∅:D[62.1542] → [30.12125:12203]

B:BD[30.12125] → [30.12125:12203]

B:BD[30.12203] → [62.1543:1627]

∅:D[62.1627] → [30.12390:12444]

B:BD[30.12390] → [30.12390:12444]

B:BD[30.12444] → [62.1628:1884]

								} else if(parameters.type === 'preroll' || parameters.type === 'tea' || parameters.type === 'gummy' || parameters.type === 'mint' || parameters.type === 'chocolate' || parameters.type === 'baked') {
									let values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.quantity) && Number.isInteger(Number(v.portions))) {
											acc.push(`($${params.push(v.portions)}, $${params.push(v.quantity)})`);
										}
										return acc;
									}, []);
									if(values.length) {
										query += `, insert${++q} as (insert into variant (product_id, portions, quantity) select product_id, x::smallint, y::numeric from insert1 cross join (values ${values.join(',')}) as t(x, y) on conflict do nothing)`;

[62.1270]

[62.1884]

									return acc;
								}, []);
								if(values.length) {
									query += `, insert${++q} as (insert into variant (product_id, quantity) select product_id, x::numeric from insert1 cross join (values ${values.join(',')}) as t(x) on conflict do nothing)`;
								}
							} else if(parameters.type === 'preroll' || parameters.type === 'tea' || parameters.type === 'gummy' || parameters.type === 'mint' || parameters.type === 'chocolate' || parameters.type === 'baked') {
								let values = parameters.variants.reduce((acc, v) => {
									if(isFinite(v.quantity) && Number.isInteger(Number(v.portions))) {
										acc.push(`($${params.push(v.portions)}, $${params.push(v.quantity)})`);

Replacement in server.js at line 1180 [16.590]

B:BD[62.1896] → [62.1896:2195]

∅:D[62.2195] → [30.12869:12923]

B:BD[30.12869] → [30.12869:12923]

B:BD[30.12923] → [62.2196:2440]

								} else if(parameters.type === 'cartridge' || parameters.type === 'disposable') {
									let values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.quantity)) {
											acc.push(`($${params.push(v.quantity)}, ${v.flavor ? '$' + params.push(v.flavor) : 'null'})`);
										}
										return acc;
									}, []);
									if(values.length) {
										query += `, insert${++q} as (insert into variant (product_id, quantity, flavor) select product_id, x::numeric, y from insert1 cross join (values ${values.join(',')}) as t(x, y) on conflict do nothing)`;

[62.1896]

[62.2440]

									return acc;
								}, []);
								if(values.length) {
									query += `, insert${++q} as (insert into variant (product_id, portions, quantity) select product_id, x::smallint, y::numeric from insert1 cross join (values ${values.join(',')}) as t(x, y) on conflict do nothing)`;
								}
							} else if(parameters.type === 'cartridge' || parameters.type === 'disposable') {
								let values = parameters.variants.reduce((acc, v) => {
									if(isFinite(v.quantity)) {
										acc.push(`($${params.push(v.quantity)}, ${v.flavor ? '$' + params.push(v.flavor) : 'null'})`);

Replacement in server.js at line 1190 [16.590]

B:BD[62.2452] → [62.2452:2774]

∅:D[62.2774] → [30.13426:13480]

B:BD[30.13426] → [30.13426:13480]

B:BD[30.13480] → [62.2775:3038]

								} else if (parameters.type === 'oil' || parameters.type === 'spray') {
									let values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.gram_equivalency) && Number.isInteger(Number(v.quantity))) {
											acc.push(`($${params.push(v.quantity)}, $${params.push(v.gram_equivalency)})`);
										}
										return acc;
									}, []);
									if(values.length) {
										query += `, insert${++q} as (insert into variant (product_id, quantity, gram_equivalency) select product_id, y::numeric, z::numeric from insert1 cross join (values ${values.join(',')}) as t(y, z) on conflict do nothing)`;

[62.2452]

[62.3038]

									return acc;
								}, []);
								if(values.length) {
									query += `, insert${++q} as (insert into variant (product_id, quantity, flavor) select product_id, x::numeric, y from insert1 cross join (values ${values.join(',')}) as t(x, y) on conflict do nothing)`;
								}
							} else if (parameters.type === 'oil' || parameters.type === 'spray') {
								let values = parameters.variants.reduce((acc, v) => {
									if(isFinite(v.gram_equivalency) && Number.isInteger(Number(v.quantity))) {
										acc.push(`($${params.push(v.quantity)}, $${params.push(v.gram_equivalency)})`);

Replacement in server.js at line 1200 [16.590]

B:BD[62.3050] → [62.3050:3753]

								} else if(parameters.type === 'capsule') {
									let values = parameters.variants.reduce((acc, v) => {
										if(isFinite(v.gram_equivalency) && Number.isInteger(Number(v.portions))) {
											acc.push(`($${params.push(v.portions)}, ${isFinite(v.quantity) ? '$' + params.push(v.quantity) : 'null'}, $${params.push(v.gram_equivalency)})`);
										}
										return acc;
									}, []);
									if(values.length) {
										query += `, insert${++q} as (insert into variant (product_id, portions, quantity, gram_equivalency) select product_id, x::smallint, y::numeric, z::numeric from insert1 cross join (values ${values.join(',')}) as t(x, y, z) on conflict do nothing)`;

[62.3050]

[62.3753]

									return acc;
								}, []);
								if(values.length) {
									query += `, insert${++q} as (insert into variant (product_id, quantity, gram_equivalency) select product_id, y::numeric, z::numeric from insert1 cross join (values ${values.join(',')}) as t(y, z) on conflict do nothing)`;
								}
							} else if(parameters.type === 'capsule') {
								let values = parameters.variants.reduce((acc, v) => {
									if(isFinite(v.gram_equivalency) && Number.isInteger(Number(v.portions))) {
										acc.push(`($${params.push(v.portions)}, ${isFinite(v.quantity) ? '$' + params.push(v.quantity) : 'null'}, $${params.push(v.gram_equivalency)})`);

Insertion in server.js at line 1210 [16.590]

[62.3765]

[61.795]

									return acc;
								}, []);
								if(values.length) {
									query += `, insert${++q} as (insert into variant (product_id, portions, quantity, gram_equivalency) select product_id, x::smallint, y::numeric, z::numeric from insert1 cross join (values ${values.join(',')}) as t(x, y, z) on conflict do nothing)`;

Deletion in server.js at line 1215 [16.590]

B:BD[61.806] → [29.8902:8987]

B:BD[29.8987] → [62.3766:4007]

							}
							if(Array.isArray(parameters.images) && parameters.images.length) {
								query += `, insert${++q} as (insert into product_image (product_id, destination) select product_id, x from insert1 cross join (values ${parameters.images.map(i => `(${params.push(i)})`).join(',')}) as t(x) on conflict do nothing)`;

Replacement in server.js at line 1216 [16.590]

B:BD[61.934] → [62.4008:4106]

∅:D[61.934] → [21.9626:9659]

∅:D[29.9322] → [21.9626:9659]

∅:D[62.4106] → [21.9626:9659]

B:BD[21.9626] → [21.9626:9659]

B:BD[21.9659] → [62.4107:4141]

B:BD[62.4141] → [7.0:126]

∅:D[7.126] → [21.9692:9858]

∅:D[62.4269] → [21.9692:9858]

B:BD[21.9692] → [21.9692:9858]

							let product = (await pool.query(query + ' select product_id from insert1', params)).rows;
							ws.send(JSON.stringify({
								response_ID: request_ID,
								data: product.length === 1 && Number.isInteger(Number(product[0].product_id)) ? undefined : 'product already exists'
							}));
						} catch(e) {
							console.error(e);
							ws.send(JSON.stringify({
								response_ID: request_ID,
								data: 'check log'
							}));

[61.934]

[21.9858]

						}
						if(Array.isArray(parameters.images) && parameters.images.length) {
							query += `, insert${++q} as (insert into product_image (product_id, destination) select product_id, x from insert1 cross join (values ${parameters.images.map(i => `(${params.push(i)})`).join(',')}) as t(x) on conflict do nothing)`;

Replacement in server.js at line 1220 [16.590]

B:BD[21.9867] → [21.9867:9882]

					} else {

[21.9867]

[21.9882]

						let product = (await pool.query(query + ' select product_id from insert1', params)).rows;
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: product.length === 1 && Number.isInteger(Number(product[0].product_id)) ? undefined : 'product already exists'
						}));
					} catch(e) {
						console.error(e);

Replacement in server.js at line 1229 [16.590]
B:BD[21.9947] → [21.9947:9973]
```
							data: 'forbidden'
```
[21.9947]
[21.9973]
```
							data: 'check log'
```

Insertion in server.js at line 1236 [16.590]

[21.10098]

[56.987]

					}));//client side virtual event user god false
					let r = (await pool.query({text: 'select store_id, owner from user_store where user_id = $1', values: [ws.user_ID], rowMode: 'array'})).rows;
					ws.send(JSON.stringify({
						what: 'user',
						how: 'update',
						data: r.length ? Object.fromEntries(r) : null

Replacement in server.js at line 1244 [16.590]
B:BD[39.6125] → [39.6125:6137]
B:BD[39.6137] → [63.232:252]
∅:D[57.1889] → [21.10245:10275]
∅:D[63.252] → [21.10245:10275]
B:BD[21.10245] → [21.10245:10275]
B:BD[21.10275] → [29.9323:9354]
B:BD[29.9354] → [3.100:218]
∅:D[57.2954] → [21.10581:10591]
∅:D[64.521] → [21.10581:10591]
∅:D[3.218] → [21.10581:10591]
∅:D[65.439] → [21.10581:10591]
∅:D[18.6049] → [21.10581:10591]
∅:D[29.9480] → [21.10581:10591]
∅:D[66.10601] → [21.10581:10591]
∅:D[67.699] → [21.10581:10591]
∅:D[63.349] → [21.10581:10591]
B:BD[21.10581] → [21.10581:10591]
B:BD[21.10591] → [63.350:362]
```
				break;
			case 'strains':
				ws.send(JSON.stringify({
					response_ID: request_ID,
					data: (await pool.query(`select strain_id as id, display_name as name, s_species as species from strain`)).rows
				}));
				break;
```
[39.6125]
[33.853]
```
				break; }
```

Insertion in server.js at line 1321 [16.590]

[28.5053]

[26.11326]

					}
					if(parameters.min_quantity) {
						qs += `min_quantity => $${params.push(parameters.min_quantity)},`;

Insertion in server.js at line 1325 [16.590]

[26.11334]

[6.0]

					if(parameters.max_quantity) {
						qs += `max_quantity => $${params.push(parameters.max_quantity)},`;
					}

Replacement in server.js at line 1428 [16.590]

∅:D[68.2896] → [69.4099:4180]

B:BD[69.4099] → [69.4099:4180]

B:BD[69.4211] → [69.4211:4276]

B:BD[69.4276] → [70.3038:3134]

			case 'menu_item_loader':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: (await pool.query(`select * from menu_item_loader($1)`, [parameters.store])).rows

[71.3103]

[72.603]

			case 'menu_item_loader': {
				const auth = await is(ws, parameters.store);
				if(auth) {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: (await pool.query(`select * from menu_item_loader($1)`, [parameters.store])).rows
					}));
				} else if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size

Replacement in server.js at line 1443 [16.590]

∅:D[72.615] → [69.4475:4593]

B:BD[69.4475] → [69.4475:4593]

					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'forbidden'
						}));

[72.615]

[69.4593]

						delete ws.user_ID;

Insertion in server.js at line 1445 [16.590]

[69.4601]

					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null

Insertion in server.js at line 1453 [16.590]

[69.4706]

					}));//client side virtual event user god false
					let r = (await pool.query({text: 'select store_id, owner from user_store where user_id = $1', values: [ws.user_ID], rowMode: 'array'})).rows;
					ws.send(JSON.stringify({
						what: 'user',
						how: 'update',
						data: r.length ? Object.fromEntries(r) : null

Replacement in server.js at line 1461 [16.590]

∅:D[69.4724] → [21.10660:10672]

B:BD[21.10660] → [21.10660:10672]

B:BD[21.10672] → [65.440:523]

B:BD[65.523] → [73.0:17]

∅:D[73.17] → [74.0:789]

B:BD[65.523] → [74.0:789]

∅:D[74.789] → [64.1023:1035]

B:BD[64.1023] → [64.1023:1035]

∅:D[64.1035] → [75.1157:1167]

B:BD[75.1157] → [75.1157:1167]

B:BD[75.1167] → [70.3135:3247]

∅:D[70.3247] → [74.895:1173]

∅:D[73.138] → [74.895:1173]

B:BD[74.895] → [74.895:1173]

B:BD[74.1173] → [70.3248:3359]

∅:D[70.3359] → [74.1261:1273]

∅:D[73.240] → [74.1261:1273]

B:BD[74.1261] → [74.1261:1273]

B:BD[74.1273] → [73.241:369]

				break;
			case 'menu_items_builder':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god')) {
						let shit;
						if(Array.isArray(parameters.fresh) && parameters.fresh.length) {
							let query = 'insert into menu_item values ';//since we're god, trusting parameters.store is fine. otherwise, need to check
							let params = [];
							for(let i = 0; i < parameters.fresh.length; ++i) {
								query += `(default, $${i * 7 + 1}, $${i * 7 + 2}, $${i * 7 + 3}, $${i * 7 + 4}, $${i * 7 + 5}, $${i * 7 + 6}, $${i * 7 + 7}),`;
								params.push(
									parameters.fresh[i].variant,
									parameters.store,
									`[${parameters.fresh[i].min_cbd},${parameters.fresh[i].max_cbd}]`,
									`[${parameters.fresh[i].min_thc},${parameters.fresh[i].max_thc}]`,
									parameters.fresh[i].price,
									parameters.fresh[i].stock,
									Boolean(parameters.fresh[i].featured)
								);
							}
							shit = (await pool.query({text: query.slice(0, -1) + ` on conflict (variant_id, store_id) do update set
								cbd = excluded.cbd,
								thc = excluded.thc,
								price = excluded.price,
								stock = excluded.stock,
								featured = excluded.featured
							where (menu_item.cbd, menu_item.thc, menu_item.price, menu_item.stock, menu_item.featured) is distinct from
							(excluded.cbd, excluded.thc, excluded.price, excluded.stock, excluded.featured) returning menu_item_id
								`,
								values: params,
								rowMode: 'array'
							})).rows.flat();//risky: https://stackoverflow.com/questions/5439293

[69.4724]

[75.1399]

				break;}
			case 'menu_items_builder': {
				const auth = await is(ws, parameters.store);
				if(auth) {
					let shit;
					if(Array.isArray(parameters.fresh) && parameters.fresh.length) {
						let query = 'insert into menu_item values ';
						let params = [];
						for(let i = 0; i < parameters.fresh.length; ++i) {
							query += `(default, $${i * 7 + 1}, $${i * 7 + 2}, $${i * 7 + 3}, $${i * 7 + 4}, $${i * 7 + 5}, $${i * 7 + 6}, $${i * 7 + 7}),`;
							params.push(
								parameters.fresh[i].variant,
								parameters.store,
								`[${parameters.fresh[i].min_cbd},${parameters.fresh[i].max_cbd}]`,
								`[${parameters.fresh[i].min_thc},${parameters.fresh[i].max_thc}]`,
								parameters.fresh[i].price,
								parameters.fresh[i].stock,
								Boolean(parameters.fresh[i].featured)
							);

Replacement in server.js at line 1481 [16.590]

B:BD[75.1408] → [74.1301:1348]

B:BD[74.1348] → [29.9628:9772]

∅:D[29.9772] → [74.1501:1562]

B:BD[74.1501] → [74.1501:1562]

B:BD[74.1562] → [5.0:1942]

						if(Array.isArray(parameters.updated)) {
							//whenever store_owner lands: update menu_item set where store = (select store from usr where id = $1) and id = $2 or keep store in ws?
							for(let i = 0; i < parameters.updated.length; ++i) {
								if(Number.isInteger(Number(parameters.updated[i].menu_item))) {
									let params = [parameters.store, parameters.updated[i].menu_item];
									let what = [];
									if(isFinite(parameters.updated[i].price)) {
										what.push(`price = $${params.push(parameters.updated[i].price)}`);
									}
									if(Number.isInteger(Number(parameters.updated[i].stock))) {
										what.push(`stock = $${params.push(parameters.updated[i].stock)}`);
									}
									if(typeof parameters.updated[i].featured === 'boolean') {
										what.push(`featured = $${params.push(parameters.updated[i].featured)}`);
									}
									if(isFinite(parameters.updated[i].min_cbd) && isFinite(parameters.updated[i].max_cbd)) {
										what.push(`cbd = $${params.push(`[${parameters.updated[i].min_cbd},${parameters.updated[i].max_cbd}]`)}`);
									} else if(isFinite(parameters.updated[i].min_cbd)) {
										what.push(`cbd = numrange($${params.push(parameters.updated[i].min_cbd)}, upper(cbd), '[]')`);
									} else if(isFinite(parameters.updated[i].max_cbd)) {
										what.push(`cbd = numrange(lower(cbd), $${params.push(parameters.updated[i].max_cbd)}, '[]')`);
									}
									if(isFinite(parameters.updated[i].min_thc) && isFinite(parameters.updated[i].max_thc)) {
										what.push(`thc = $${params.push(`[${parameters.updated[i].min_thc},${parameters.updated[i].max_thc}]`)}`);
									} else if(isFinite(parameters.updated[i].min_thc)) {
										what.push(`thc = numrange($${params.push(parameters.updated[i].min_thc)}, upper(thc), '[]')`);
									} else if(isFinite(parameters.updated[i].max_thc)) {
										what.push(`thc = numrange(lower(thc), $${params.push(parameters.updated[i].max_thc)}, '[]')`);
									}
									if(what.length > 0) {
										await pool.query(`update menu_item set ${what.join(', ')} where store_id = $1 and menu_item_id = $2`, params);
									}

[75.1408]

[5.1942]

						shit = (await pool.query({text: query.slice(0, -1) + ` on conflict (variant_id, store_id) do update set
							cbd = excluded.cbd,
							thc = excluded.thc,
							price = excluded.price,
							stock = excluded.stock,
							featured = excluded.featured
						where (menu_item.cbd, menu_item.thc, menu_item.price, menu_item.stock, menu_item.featured) is distinct from
						(excluded.cbd, excluded.thc, excluded.price, excluded.stock, excluded.featured) returning menu_item_id
							`,
							values: params,
							rowMode: 'array'
						})).rows.flat();//risky: https://stackoverflow.com/questions/5439293
					}
					if(Array.isArray(parameters.updated)) {
						for(let i = 0; i < parameters.updated.length; ++i) {
							if(Number.isInteger(Number(parameters.updated[i].menu_item))) {
								let params = [parameters.store, parameters.updated[i].menu_item];
								let what = [];
								if(isFinite(parameters.updated[i].price)) {
									what.push(`price = $${params.push(parameters.updated[i].price)}`);
								}
								if(Number.isInteger(Number(parameters.updated[i].stock))) {
									what.push(`stock = $${params.push(parameters.updated[i].stock)}`);
								}
								if(typeof parameters.updated[i].featured === 'boolean') {
									what.push(`featured = $${params.push(parameters.updated[i].featured)}`);
								}
								if(isFinite(parameters.updated[i].min_cbd) && isFinite(parameters.updated[i].max_cbd)) {
									what.push(`cbd = $${params.push(`[${parameters.updated[i].min_cbd},${parameters.updated[i].max_cbd}]`)}`);
								} else if(isFinite(parameters.updated[i].min_cbd)) {
									what.push(`cbd = numrange($${params.push(parameters.updated[i].min_cbd)}, upper(cbd), '[]')`);
								} else if(isFinite(parameters.updated[i].max_cbd)) {
									what.push(`cbd = numrange(lower(cbd), $${params.push(parameters.updated[i].max_cbd)}, '[]')`);
								}
								if(isFinite(parameters.updated[i].min_thc) && isFinite(parameters.updated[i].max_thc)) {
									what.push(`thc = $${params.push(`[${parameters.updated[i].min_thc},${parameters.updated[i].max_thc}]`)}`);
								} else if(isFinite(parameters.updated[i].min_thc)) {
									what.push(`thc = numrange($${params.push(parameters.updated[i].min_thc)}, upper(thc), '[]')`);
								} else if(isFinite(parameters.updated[i].max_thc)) {
									what.push(`thc = numrange(lower(thc), $${params.push(parameters.updated[i].max_thc)}, '[]')`);
								}
								if(what.length > 0) {
									await pool.query(`update menu_item set ${what.join(', ')} where store_id = $1 and menu_item_id = $2`, params);

Replacement in server.js at line 1527 [16.590]

B:BD[74.1971] → [74.1971:2047]

B:BD[74.2047] → [76.362:478]

B:BD[76.478] → [5.1954:2056]

∅:D[5.2056] → [74.2139:2180]

B:BD[74.2139] → [74.2139:2180]

B:BD[74.2180] → [73.370:422]

∅:D[73.422] → [74.2212:2224]

B:BD[74.2212] → [74.2212:2224]

∅:D[74.2224] → [65.523:629]

∅:D[75.1408] → [65.523:629]

B:BD[65.523] → [65.523:629]

						if(Array.isArray(parameters.deleted) && parameters.deleted.length) {
							//need to check if menu item actually belongs to the store
							//and check if store belongs to the user
							await pool.query('delete from menu_item where menu_item_id = any($1)', [parameters.deleted]);
						}
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: shit
						}));
					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'forbidden'

[74.1971]

[65.629]

					}
					if(Array.isArray(parameters.deleted) && parameters.deleted.length) {
						await pool.query('delete from menu_item where menu_item_id = any($1) and store_id = $2', [parameters.deleted, parameters.store]);
					}
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: shit
					}));
				} else if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size

Insertion in server.js at line 1543 [16.590]
[65.641]
[65.641]
```
						delete ws.user_ID;
```

Insertion in server.js at line 1545 [16.590]

[65.649]

					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null

Insertion in server.js at line 1553 [16.590]

[65.754]

					}));//client side virtual event user god false
					let r = (await pool.query({text: 'select store_id, owner from user_store where user_id = $1', values: [ws.user_ID], rowMode: 'array'})).rows;
					ws.send(JSON.stringify({
						what: 'user',
						how: 'update',
						data: r.length ? Object.fromEntries(r) : null

Replacement in server.js at line 1561 [16.590]
B:BD[65.772] → [65.772:784]
```
				break;
```
[65.772]
[34.6394]
```
				break;}
```
Replacement in server.js at line 1569 [16.590]
B:BD[69.6257] → [34.6685:6712]
```
					if(isLoggedIn(ws)) {
```
[69.6257]
[34.6712]
```
					if(ws.user_ID) {
```
Replacement in server.js at line 1589 [16.590]
B:BD[72.2684] → [72.2684:2710]
```
				if(isLoggedIn(ws)) {
```
[72.2684]
[72.2710]
```
				if(ws.user_ID) {
```
Replacement in server.js at line 1602 [16.590]
B:BD[69.8026] → [35.10113:10139]
```
				if(isLoggedIn(ws)) {
```
[69.8026]
[35.10139]
```
				if(ws.user_ID) {
```

Deletion in server.js at line 1649 [16.590]

B:BD[35.11885] → [35.11885:12963]

						}));
					}
					//send notification to store
				}// else if()//parameters.cart_id, paramaters.email, parameters.password
					//if login success
					//delete from cart where user_id = $1 and status = 'active' and store_id = $2
					//update cart set user_id = $1 where cart_id = $2//this will fail if there's another placed || ready with same store, which is ok. let them know
					//if login failure
					//do nothing with carts, ask to retry
				//else if () //parameters.cart_id, paramaters.email
/* but with empty password ""
update cart set status = 'placed', user_id = $2 where cart_id = $1
subquery doesn't work :(
					try {
						let newUser = await pool.query('insert into usr (email, passphrase_hash) values ($1, $2) returning user_id, email, type', [parameters.email, await argon2.hash(parameters.passphrase)]);//technically, we only need the id??
						ws.send(JSON.stringify({
							response_ID: request_ID
						}));
						ws.publish('user/s', JSON.stringify({
							what: "users",
							how: 'add',
							data: newUser.rows[0]

Deletion in server.js at line 1650 [16.590]

B:BD[35.12975] → [35.12975:13371]

						//ws.publish('/users/' + id? dunno if needed, JSON.stringify(event.json id, email, add))
					} catch(e) {
						let error = 'user already exists'; do nothing with carts, ask to retry
						if(e.constraint !== 'usr_email_key') {
							console.error(e);
							error = 'error';
						}
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: error
						}));

Replacement in server.js at line 1651 [16.590]

B:BD[35.13379] → [35.13379:13383]

*/

[35.13379]

[69.8623]

				} else {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null
				}

Replacement in server.js at line 1658 [16.590]

B:BD[69.8635] → [35.13384:13414]

∅:D[35.13414] → [69.8678:8704]

B:BD[69.8678] → [69.8678:8704]

B:BD[69.8704] → [35.13415:13552]

∅:D[35.13552] → [69.8730:8795]

B:BD[69.8730] → [69.8730:8795]

B:BD[69.8795] → [35.13553:13644]

			case 'user_reservations':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god') && parameters && Number.isInteger(Number(parameters.user_ID))) {
						//trust parameters.user_id
					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: (await pool.query(`select * from user_reservations($1)`, [ws.user_ID])).rows

[69.8635]

[69.9107]

			case 'user_reservations': {
				const auth = await is(ws);
				let n = Number.isInteger(Number(parameters?.user_ID));
				if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size

Insertion in server.js at line 1669 [16.590]
[69.9119]
[35.13645]
```
						delete ws.user_ID;
```

Insertion in server.js at line 1671 [16.590]

[35.13653]

					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null
				} else if(!auth && n) {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthorized'
					}));//client side virtual event user god false

Insertion in server.js at line 1681 [16.590]

[35.13667]

					const id = auth && n ? parameters.user_ID : ws.user_ID;
					ws.subscribe('user/reservations/' + id);
					let data = (await pool.query(`select * from user_reservations($1)`, [id])).rows;
					for(let i = 0; i < data.length; ++i) {
						let out;
						for(let j = 0; j < data[i].statuses.length; ++j) {
							if(j === data[i].statuses.length - 1 && data[i].statuses[j].end !== Infinity && (data[i].statuses[j].status === 'placed' || data[i].statuses[j].status === 'ready')) {
								out = {status: 'store_cancelled', as_of: data[i].statuses[j].end};
							}
							delete data[i].statuses[j].end;
						}
						if(out) {
							data[i].statuses.push(out);
						}
					}

Replacement in server.js at line 1698 [16.590]
B:BD[35.13730] → [35.13730:13758]
```
						data: 'unauthorized'
```
[35.13730]
[35.13758]
```
						data
```

Replacement in server.js at line 1701 [16.590]

B:BD[35.13776] → [35.13776:13972]

∅:D[35.13972] → [69.9119:9199]

B:BD[69.9119] → [69.9119:9199]

B:BD[69.9199] → [35.13973:14173]

				break;
			case 'user_cancel_reservation':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god') && parameters && Number.isInteger(Number(parameters.user_ID))) {
						//trust parameters.user_id
					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: (await pool.query(`update cart set status = 'user_cancelled' where user_id = $1 and store_id = $2 and (status = 'placed' or status = 'ready')`, [ws.user_ID, parameters.store])).rowCount

[35.13776]

[69.9225]

				break;}
			case 'user_cancel_reservation': {
				const auth = await is(ws);
				let n = Number.isInteger(Number(parameters?.user_ID));
				if(auth === undefined) {
					if(ws.user_ID) {
						authenticated.delete(ws.user_ID);
						ws.publish('user/authenticated', JSON.stringify({
							what: 'user/authenticated',//tbd
							how: 'replace',
							data: authenticated.size

Replacement in server.js at line 1713 [16.590]
B:BD[69.9237] → [35.14174:14210]
```
						//send notification to store
```
[69.9237]
[69.9237]
```
						delete ws.user_ID;
```

Insertion in server.js at line 1715 [16.590]

[69.9245]

					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthenticated'
					}));//client side virtual event user null
				} else if(!auth && n) {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'unauthorized'
					}));//client side virtual event user god false

Insertion in server.js at line 1725 [16.590]

[69.9259]

					const id = auth && n ? parameters.user_ID : ws.user_ID;
					let r = (await pool.query(`update cart set status = 'user_cancelled' where user_id = $1 and store_id = $2 and (status = 'placed' or status = 'ready') returning system_time_start`, [id, parameters.store]));

Replacement in server.js at line 1729 [16.590]
B:BD[69.9322] → [69.9322:9350]
```
						data: 'unauthorized'
```
[69.9322]
[69.9350]
```
						data: r.rowCount
```

Insertion in server.js at line 1731 [16.590]

[69.9361]

					if(r.rowCount === 1) {
						ws.publish('store/reservations/' + parameters.store, JSON.stringify({
							what: 'store/reservations/' + parameters.store,
							how: 'update',
							data: {
								user_id: id,
								status: 'user_cancelled',
								as_of: r.rows[0].system_time_start
							}
						}));
					}

Replacement in server.js at line 1743 [16.590]

B:BD[69.9368] → [69.9368:9380]

B:BD[69.9380] → [35.14211:14416]

				break;
			case 'store_reservations':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god') && parameters && Number.isInteger(Number(parameters.store))) {
						ws.subscribe('store/reservations/' + parameters.store)

[69.9368]

[35.14416]

				break;}
			case 'store_reservations': {
				if(Number.isInteger(Number(parameters?.store))) {
					const auth = await is(ws, parameters.store);
					if(auth) {
						ws.subscribe('store/reservations/' + parameters.store);
						let data = (await pool.query(`select * from store_reservations($1)`, [parameters.store])).rows;
						for(let i = 0; i < data.length; ++i) {
							let out;
							for(let j = 0; j < data[i].statuses.length; ++j) {
								if(j === data[i].statuses.length - 1 && data[i].statuses[j].end !== Infinity && (data[i].statuses[j].status === 'placed' || data[i].statuses[j].status === 'ready')) {
									out = {status: 'user_cancelled', as_of: data[i].statuses[j].end};
								}
								delete data[i].statuses[j].end;
							}
							if(out) {
								data[i].statuses.push(out);
							}
						}
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data
						}));
					} else if(auth === undefined) {
						if(ws.user_ID) {
							authenticated.delete(ws.user_ID);
							ws.publish('user/authenticated', JSON.stringify({
								what: 'user/authenticated',//tbd
								how: 'replace',
								data: authenticated.size
							}));
							delete ws.user_ID;
						}
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'unauthenticated'
						}));//client side virtual event user null
					} else {

Replacement in server.js at line 1783 [16.590]

B:BD[35.14481] → [35.14481:14579]

							data: (await pool.query(`select * from store_reservations($1)`, [parameters.store])).rows

[35.14481]

[35.14579]

							data: 'unauthorized'
						}));//client side virtual event user god false
						let r = (await pool.query({text: 'select store_id, owner from user_store where user_id = $1', values: [ws.user_ID], rowMode: 'array'})).rows;
						ws.send(JSON.stringify({
							what: 'user',
							how: 'update',
							data: r.length ? Object.fromEntries(r) : null

Insertion in server.js at line 1792 [16.590]

[35.14599]

				} else {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'missing store'
					}));

Replacement in server.js at line 1798 [16.590]

∅:D[35.14606] → [69.9441:9453]

B:BD[69.9441] → [69.9441:9453]

B:BD[69.9453] → [35.14607:14837]

				break;
			case 'store_update_reservation':
				if(isLoggedIn(ws)) {
					if(is(ws, 'god') && parameters && Number.isInteger(Number(parameters.store)) && Number.isInteger(Number(parameters.user))) {
						let data = 'invalid update';

[35.14606]

[35.14837]

				break;}
			case 'store_update_reservation': {
				if(Number.isInteger(Number(parameters?.store)) && Number.isInteger(Number(parameters?.user))) {
					const auth = await is(ws, parameters.store);
					if(auth) {
						let data;

Replacement in server.js at line 1807 [16.590]

B:BD[35.14929] → [35.14929:15091]

									`update cart set status = 'ready' where store_id = $1 and user_id = $2 and status = 'placed'`,
									[parameters.store, parameters.user])).rowCount

[35.14929]

[35.15091]

									`update cart set status = 'ready' where store_id = $1 and user_id = $2 and status = 'placed' returning system_time_start`,
									[parameters.store, parameters.user]))

Replacement in server.js at line 1812 [16.590]

B:BD[35.15202] → [35.15202:15362]

									`update cart set status = 'paid' where store_id = $1 and user_id = $2 and status = 'ready'`,
									[parameters.store, parameters.user])).rowCount

[35.15202]

[35.15362]

									`update cart set status = 'paid' where store_id = $1 and user_id = $2 and status = 'ready' returning system_time_start`,
									[parameters.store, parameters.user]))

Replacement in server.js at line 1817 [16.590]

B:BD[35.15436] → [35.15436:15608]

									`update cart set status = 'store_cancelled' where store_id = $1 and user_id = $2 and status = 'placed'`,
									[parameters.store, parameters.user])).rowCount

[35.15436]

[35.15608]

									`update cart set status = 'store_cancelled' where store_id = $1 and user_id = $2 and status = 'placed' returning system_time_start`,
									[parameters.store, parameters.user]))

Replacement in server.js at line 1822 [16.590]

B:BD[35.15682] → [35.15682:15845]

									`update cart set status = 'no_show' where store_id = $1 and user_id = $2 and status = 'ready'`,
									[parameters.store, parameters.user])).rowCount

[35.15682]

[35.15845]

									`update cart set status = 'no_show' where store_id = $1 and user_id = $2 and status = 'ready' returning system_time_start`,
									[parameters.store, parameters.user]))
						}
						if(data?.rowCount === 1) {
							ws.send(JSON.stringify({
								response_ID: request_ID
							}));
							if(parameters.update === 'cancel') {
								parameters.update = 'store_cancelled';
							} else if(parameters.update === 'noshow') {
								parameters.update = 'no_show';
							}
							ws.publish('store/reservations/' + parameters.store, JSON.stringify({
								what: 'store/reservations/' + parameters.store,
								how: 'update',
								data: {
									user_id: id,
									status: parameters.update,
									as_of: data.rows[0].system_time_start
								}
							}));
						} else {
							ws.send(JSON.stringify({
								response_ID: request_ID,
								data: 'invalid update'
							}));
						}
					} else if(auth === undefined) {
						if(ws.user_ID) {
							authenticated.delete(ws.user_ID);
							ws.publish('user/authenticated', JSON.stringify({
								what: 'user/authenticated',//tbd
								how: 'replace',
								data: authenticated.size
							}));
							delete ws.user_ID;

Replacement in server.js at line 1861 [16.590]

B:BD[35.15919] → [35.15919:15932]

							data

[35.15919]

[35.15932]

							data: 'unauthenticated'
						}));//client side virtual event user null
					} else {
						ws.send(JSON.stringify({
							response_ID: request_ID,
							data: 'unauthorized'
						}));//client side virtual event user god false
						let r = (await pool.query({text: 'select store_id, owner from user_store where user_id = $1', values: [ws.user_ID], rowMode: 'array'})).rows;
						ws.send(JSON.stringify({
							what: 'user',
							how: 'update',
							data: r.length ? Object.fromEntries(r) : null

Insertion in server.js at line 1875 [16.590]

[35.15952]

				} else {
					let out = [];
					if(!Number.isInteger(Number(parameters?.store))) {
						out.push('store');
					}
					if(!Number.isInteger(Number(parameters?.user))) {
						out.push('user')
					}
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: 'missing ' + out.join(' and ')
					}));

Replacement in server.js at line 1888 [16.590]
∅:D[35.15959] → [69.10001:10013]
B:BD[69.10001] → [69.10001:10013]
```
				break;
```
[35.15959]
[35.15960]
```
				break;}
```
Replacement in server.js at line 1907 [16.590]
B:BD[24.4617] → [24.4617:4641]
```
		if(isLoggedIn(ws)) {
```
[24.4617]
[29.10494]
```
		if(ws.user_ID) {
```
Replacement in server.js at line 1926 [16.590]
∅:D[9.145] → [44.511:539]
B:BD[16.6197] → [44.511:539]
∅:D[44.539] → [16.6245:6259]
B:BD[16.6245] → [16.6245:6259]
```
}).listen(port, token => {
	if(token) {
```
[9.145]
[44.540]
```
}).listen(port, μSocket => {
	if(μSocket) {
```