113.sql
No OneTemporary
Actions

Size

1 KB

Subscribers

None

113.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 112
	-- to_version: 113
	-- description: Open indexer_configuration_add endpoint

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

	CREATE OR REPLACE FUNCTION swh_indexer_configuration_add() RETURNS SETOF indexer_configuration
	LANGUAGE plpgsql
	AS $$
	begin
	insert into indexer_configuration(tool_name, tool_version, tool_configuration)
	select tool_name, tool_version, tool_configuration from tmp_indexer_configuration tmp
	on conflict(tool_name, tool_version, tool_configuration) do nothing;

	return query
	select id, tool_name, tool_version, tool_configuration
	from tmp_indexer_configuration join indexer_configuration
	using(tool_name, tool_version, tool_configuration);

	return;
	end
	$$;

	CREATE OR REPLACE FUNCTION swh_mktemp_indexer_configuration() RETURNS void
	LANGUAGE sql
	AS $$
	create temporary table tmp_indexer_configuration (
	like indexer_configuration including defaults
	) on commit drop;
	alter table tmp_indexer_configuration drop column id;
	$$;