Changeset View

Standalone View

Show First 20 Lines • Show All 586 Lines • ▼ Show 20 Lines	with origin_id as (
select id		select id
from origin		from origin
where url = origin_url		where url = origin_url
), last_known_visit as (		), last_known_visit as (
select coalesce(max(visit), 0) as visit		select coalesce(max(visit), 0) as visit
from origin_visit		from origin_visit
where origin = (select id from origin_id)		where origin = (select id from origin_id)
)		)
insert into origin_visit (origin, date, type, visit, status)		insert into origin_visit (origin, date, type, visit)
values ((select id from origin_id), date, type,		values ((select id from origin_id), date, type,
(select visit from last_known_visit) + 1, 'ongoing')		(select visit from last_known_visit) + 1)
returning visit;		returning visit;
$$;		$$;

create or replace function swh_snapshot_add(snapshot_id sha1_git)		create or replace function swh_snapshot_add(snapshot_id sha1_git)
returns void		returns void
language plpgsql		language plpgsql
as $$		as $$
declare		declare
▲ Show 20 Lines • Show All 343 Lines • Show Last 20 Lines