019.sql
No OneTemporary
Actions

Size

999 B

Subscribers

None

019.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 18
	-- to_version: 19
	-- description: improve performance of swh_{directory,revision,release}_missing

	insert into dbversion(version, release, description)
	values(19, now(), 'Work In Progress');


	create or replace function swh_directory_missing()
	returns setof sha1_git
	language plpgsql
	as $$
	begin
	return query
	select id from tmp_directory
	where not exists (
	select 1 from directory d
	where d.id = id);
	return;
	end
	$$;

	create or replace function swh_revision_missing()
	returns setof sha1_git
	language plpgsql
	as $$
	begin
	return query
	select id from tmp_revision
	where not exists (
	select 1 from revision r
	where r.id = id);
	return;
	end
	$$;

	create or replace function swh_release_missing()
	returns setof sha1_git
	language plpgsql
	as $$
	begin
	return query
	select id from tmp_release
	where not exists (
	select 1 from release r
	where r.id = id);
	return;
	end
	$$;