-- 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; $$;