timezone text

	timezone text,
	use_for_compute boolean default true not null,--online stores have stupid ass numbers so initially, use for compute, but once we have stores turn it off.

	use_for_compute boolean default true not null,--online stores have stupid ass numbers so initially, use for compute, but once we have stores turn it off.

							strain_family_effect.name as strain_family,

							strain_family.name as strain_family,

							left outer join strain_family_effect on (product.strain_family = strain_family_effect.id)

							left outer join strain_family on (product.strain_family = strain_family.id)

							strain_family_effect.id
					`)).rows//I guess it's necessary to group by strain_family_effect.id as well because there's no way for postgres to know that there'll only be one row in the result per strain_family_effect. ask dba

							strain_family.id
					`)).rows//I guess it's necessary to group by strain_family.id as well because there's no way for postgres to know that there'll only be one row in the result per strain_family. ask dba

								first(strain_family_effect.name) as strain_family,

								first(strain_family.name) as strain_family,

								left outer join strain_family_effect on (product.strain_family = strain_family_effect.id)

								left outer join strain_family on (product.strain_family = strain_family.id)

								await pool.query(query.slice(0, -1), params);

								await pool.query(query.slice(0, -1) + ` on conflict on constraint unique_menu_item do update set
									cbd_min = excluded.cbd_min,
									cbd_max = excluded.cbd_max,
									thc_min = excluded.thc_min,
									thc_max = excluded.thc_max,
									price = excluded.price,
									featured = excluded.featured
									`,
									params
								);