case 'stores':
				//todo: parameters(lat, long, radius, open now or open + closed, (pickup, delivery) for future))
				let stores = (await pool.query('select * from store')).rows;
				//ws.subscribe('store/#'); maybe this doesn't make sense? with the filters at least, hard to be dynamic. would be cool as a store opens, it shoes up

			case 'stores'://wait for postgis to land before implementing
				//todo: parameters(lat, long, radius, open now or open + closed, (pickup, delivery) for future)), or by province, city, country
				//https://postgis.net/docs/ST_DWithin.html vs http://postgis.net/docs/geometry_distance_knn.html
				//what are the tradeoffs? I want to use geography I think since I don't want to deal with projections, but are we sure google maps coordinates are correct
				//what is the spheroid to use?
				let stores = (await pool.query('select distinct on(store.id) store.id, store.name, store_image.URL from store left outer join store_image on store.id = store_image.store')).rows;
				//ws.subscribe('store/#'); maybe this doesn't make sense? with the filters at least, hard to be dynamic. would be cool as a store opens, it shows up

					if(is(ws, 'god')) {

					if(is(ws, 'god')) {//todo: cte this into a single transaction, images. see create_store

			case 'products'://in need of revamp 20200206

			case 'products'://in need of revamp 20200206 WHERE ARE THE TEREPENES?

					let params = [];
					let poop = 0;
					let str = '';

					let params = [parameters.product];
					let query = '';

						params.push(parameters.variant);
						++poop;
						str += ' and menu_item.variant = $' + poop;

						query += ' and menu_item.variant = $' + params.push(parameters.variant);

						params.push(parameters.store);
						++poop;
						str += ' and menu_item.store = $' + poop;

						query += ' and menu_item.store = $' + params.push(parameters.store);

					str = str.slice(5);

								id,

								menu_item.id,

								store

								store,
								store.URL || path as url

								inner join store on menu_item.store = store.id
								inner join variant on menu_item.variant = variant.id
								inner join product on variant.product = product.id

								${str}

								product.id = $1
								${query}

				let wow = await pool.query('select store.url || path as fuck from menu_item inner join store on menu_item.store = store.id where variant = $1 and store = $2', [parameters.variant, parameters.store]);
				if(wow.rows.length && wow.rows[0].fuck !== null) {
					ws.send(JSON.stringify({
						response_ID: request_ID,
						data: wow.rows[0].fuck
					}));
					break;
				}