boogerlad/mj - Change SUT4U63YUU3T5KTJP3SQW73VODBN6L67356ULGKMCAHR6OH3LIFQC

return an array of length 7 for store times instead of object with keys as days. also fix monday 8pm to monday 12pm case over sunday midnight boundary mistakenly being bounded to sunday instead of the day of the beginning of the range that ends at the boundary

Created by boogerlad on June 9, 2020

SUT4U63YUU3T5KTJP3SQW73VODBN6L67356ULGKMCAHR6OH3LIFQC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 604 [5.17]

B:BD[4.203] → [3.0:48]

∅:D[3.48] → [4.253:443]

B:BD[4.253] → [4.253:443]

		(select json_object_agg(x, array_agg) from (
			select
				case
					when wow then 6
					else lower(open) / 1440
				end as x,
				array_agg(open order by case
					when wow then 2147483647
					else lower(open)
				end asc)

[4.203]

[4.443]

		(
			select json_agg(coalesce(array_agg, '{}') order by generate_series)

Replacement in initialize.sql at line 608 [5.17]

B:BD[4.466] → [4.466:770]

B:BD[4.770] → [2.0:12]

					lower(open) = 0 and exists(
						select 1
						from store_time
						where
							store_time.store_id = store.store_id and
							upper(open) = 10080
					) as wow,
					open
				from store_time
				where store_time.store_id = store.store_id
			) as t
			group by x
			order by x asc
		) as y),

[4.466]

[6.1857]

					coalesce(wow, lower(open) / 1440) as x,
					array_agg(array[lower(open), upper(open)] order by case
						when wow is not null then 2147483647
						else lower(open)
					end asc)
				from (
					select
						case when lower(open) = 0 then (
							select lower(open) / 1440
							from store_time
							where
								store_time.store_id = store.store_id and
								upper(open) = 10080
						) end as wow,
						open
					from store_time
					where store_time.store_id = store.store_id
				) as t
				group by x
			) as y full join (
				select generate_series
				from generate_series(0,6)
			) as ayy on y.x = ayy.generate_series
		),