Origin for each line in rsstg.sql from check-in 4e0a19d772:

61df933942 2020-11-18        arcade: create table rsstg_updates (owner integer, update jsonb);
61df933942 2020-11-18        arcade: 
61df933942 2020-11-18        arcade: create unique index rsstg_updates__id on rsstg_updates(update->>'update_id');
61df933942 2020-11-18        arcade: 
61df933942 2020-11-18        arcade: create table rsstg_source (
61df933942 2020-11-18        arcade: 	source_id serial,
f322efafd9 2020-11-30        arcade: 	channel text not null,
61df933942 2020-11-18        arcade: 	channel_id integer not null,
61df933942 2020-11-18        arcade: 	url text not null,
075be7e40e 2020-11-18        arcade: 	last_scrape not null timestamptz default now(),
075be7e40e 2020-11-18        arcade: 	enabled boolean not null default false,
61df933942 2020-11-18        arcade: 	iv_hash text,
61df933942 2020-11-18        arcade: 	owner bigint not null);
61df933942 2020-11-18        arcade: create unique index rsstg_source__source_id on rsstg_source(source_id);
61df933942 2020-11-18        arcade: create unique index rsstg_source__channel_id__owner on rsstg_source(channel_id, owner);
61df933942 2020-11-18        arcade: create index rsstg_source__owner on rsstg_source(owner);
61df933942 2020-11-18        arcade: 
61df933942 2020-11-18        arcade: create table rsstg_post (
61df933942 2020-11-18        arcade: 	source_id integer not null,
4e0a19d772 2021-10-01        arcade: 	posted timestamptz not null,
61df933942 2020-11-18        arcade: 	url text not null,
4e0a19d772 2021-10-01        arcade: 	hour smallint not null generated always as (extract('hour' from posted at time zone 'utc')) stored,
4e0a19d772 2021-10-01        arcade: 	hxm smallint not null generated always as (hxm(posted)) stored,
f322efafd9 2020-11-30        arcade: 	FOREIGN KEY (source_id) REFERENCES rsstg_source(source_id) on delete cascade,
61df933942 2020-11-18        arcade: );
61df933942 2020-11-18        arcade: create unique index rsstg_post__url on rsstg_post(url);
61df933942 2020-11-18        arcade: create index rsstg_post__hour on rsstg_post(hour);
0191d490fe 2020-11-18        arcade: create index rsstg_post__posted_hour on rsstg_post(posted,hour);
4e0a19d772 2021-10-01        arcade: create index rsstg_post__hxm on rsstg_post(hxm);
4e0a19d772 2021-10-01        arcade: create index rsstg_post__posted_hxm on rsstg_post(posted,hxm);
4e0a19d772 2021-10-01        arcade: 
4e0a19d772 2021-10-01        arcade: create or replace view rsstg_order_old as
4e0a19d772 2021-10-01        arcade: 	select source_id, coalesce(last_scrape + make_interval(0,0,0,0,0,(60 / (coalesce(activity, 1)/7 + 1) )::integer), now() - interval '1 minute') as next_fetch, owner
4e0a19d772 2021-10-01        arcade: 		from rsstg_source natural left join
4e0a19d772 2021-10-01        arcade: 		(select source_id, count(*) as activity
4e0a19d772 2021-10-01        arcade: 			from rsstg_post where 
4e0a19d772 2021-10-01        arcade: 				hour = extract('hour' from now())::smallint
4e0a19d772 2021-10-01        arcade: 				and posted > now() - interval '7 days'
4e0a19d772 2021-10-01        arcade: 				and posted < now() - interval '1 hour'
4e0a19d772 2021-10-01        arcade: 			group by source_id) as act
4e0a19d772 2021-10-01        arcade: 		where enabled
4e0a19d772 2021-10-01        arcade: 		order by next_fetch;
4e0a19d772 2021-10-01        arcade: 
4e0a19d772 2021-10-01        arcade: create or replace function hxm(timestamptz) returns smallint
4e0a19d772 2021-10-01        arcade: 	as $$ select(extract('hour' from $1) * extract('minute' from $1)); $$
4e0a19d772 2021-10-01        arcade: 	language sql immutable returns null on null input;
ebe7c281a5 2020-11-27        arcade: 
ebe7c281a5 2020-11-27        arcade: create or replace view rsstg_order as
ebe7c281a5 2020-11-27        arcade: 	select source_id, coalesce(last_scrape + make_interval(0,0,0,0,0,(60 / (coalesce(activity, 1)/7 + 1) )::integer), now() - interval '1 minute') as next_fetch, owner
ebe7c281a5 2020-11-27        arcade: 		from rsstg_source natural left join
ebe7c281a5 2020-11-27        arcade: 		(select source_id, count(*) as activity
ebe7c281a5 2020-11-27        arcade: 			from rsstg_post where 
4e0a19d772 2021-10-01        arcade: 			  (
4e0a19d772 2021-10-01        arcade: 					(hxm > hxm(now()) - 30 and hxm < hxm(now()) + 30)
4e0a19d772 2021-10-01        arcade: 					or (hxm < 30 and hxm < hxm(now()) + 30 - 1440)
4e0a19d772 2021-10-01        arcade: 					or (hxm > 1410 and hxm > 1440 + hxm(now()) - 30)
4e0a19d772 2021-10-01        arcade: 			  )
4e0a19d772 2021-10-01        arcade: 				and posted < now() - interval '1 hour'
0191d490fe 2020-11-18        arcade: 				and posted > now() - interval '7 days'
61df933942 2020-11-18        arcade: 			group by source_id) as act
61df933942 2020-11-18        arcade: 		where enabled
61df933942 2020-11-18        arcade: 		order by next_fetch;