boogerlad/mj - Change NHVZFKZDPQGCZ6UOVQU5U3Q3SOAKGOGZNFIE7C6IB6YP3ZS4VVDAC

there's a difference between null "open"(unknown) and empty array "open"(never open) get rid of idk trigger since constraint has been relaxed and doesn't really save any code and not worth performance hit

Created by boogerlad on July 22, 2020

NHVZFKZDPQGCZ6UOVQU5U3Q3SOAKGOGZNFIE7C6IB6YP3ZS4VVDAC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 70 [3.17]

B:BD[2.355] → [2.355:431]

	open int4range[] check (cardinality(open) > 0 and array_ndims(open) = 1),

[2.355]

[2.431]

	open int4range[] check (array_ndims(open) = 1),

Deletion in initialize.sql at line 76 [3.17]

B:BD[4.407] → [2.805:1206]

create or replace function idk() returns trigger as $$ begin
	new.open = (select range_agg(x, true, true) from unnest(new.open) as t(x));
	if cardinality(new.open) = 0 then
		new.open = null;
	end if;
	return new;
end $$ language plpgsql volatile;
--drop trigger if exists idk_trigger on store;
create trigger idk_trigger before insert or update on store for each row execute function idk();

Replacement in scrape/stores.js at line 725 [2.2622]

B:BD[2.25750] → [2.25750:25851]

		(select array_agg(int4range((x->>0)::int, (x->>1)::int)) from json_array_elements(open) as t(x)),

[2.25750]

[2.25851]

		(select range_agg(int4range((x->>0)::int, (x->>1)::int), true, true) from json_array_elements(open) as t(x)),

Replacement in scrape/stores.js at line 1173 [2.2622]

B:BD[2.38792] → [2.38792:38893]

		(select array_agg(int4range((x->>0)::int, (x->>1)::int)) from json_array_elements(open) as t(x)),

[2.38792]

[2.38893]

		(select range_agg(int4range((x->>0)::int, (x->>1)::int), true, true) from json_array_elements(open) as t(x)),

Replacement in scrape/stores.js at line 1415 [2.2622]

B:BD[2.45227] → [2.45227:45328]

		(select array_agg(int4range((x->>0)::int, (x->>1)::int)) from json_array_elements(open) as t(x)),

[2.45227]

[2.45328]

		(select range_agg(int4range((x->>0)::int, (x->>1)::int), true, true) from json_array_elements(open) as t(x)),

Replacement in scrape/stores.js at line 2051 [2.2622]

B:BD[2.62970] → [2.62970:63071]

		(select array_agg(int4range((x->>0)::int, (x->>1)::int)) from json_array_elements(open) as t(x)),

[2.62970]

[2.63071]

		(select range_agg(int4range((x->>0)::int, (x->>1)::int), true, true) from json_array_elements(open) as t(x)),