125.sql
No OneTemporary
Actions

Size

1 KB

Subscribers

None

125.sql
View Options

	-- SWH Indexer DB schema upgrade
	-- from_version: 124
	-- to_version: 125
	-- description: Add 'origin_url' column to origin_intrinsic_metadata.

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

	alter table origin_intrinsic_metadata
	add column origin_url text;

	create or replace function swh_origin_intrinsic_metadata_add(
	conflict_update boolean)
	returns void
	language plpgsql
	as $$
	begin
	perform swh_origin_intrinsic_metadata_compute_tsvector();
	if conflict_update then
	insert into origin_intrinsic_metadata (id, origin_url, metadata, indexer_configuration_id, from_revision, metadata_tsvector, mappings)
	select id, origin_url, metadata, indexer_configuration_id, from_revision,
	metadata_tsvector, mappings
	from tmp_origin_intrinsic_metadata
	on conflict(id, indexer_configuration_id)
	do update set
	metadata = excluded.metadata,
	mappings = excluded.mappings;

	else
	insert into origin_intrinsic_metadata (id, origin_url, metadata, indexer_configuration_id, from_revision, metadata_tsvector, mappings)
	select id, origin_url, metadata, indexer_configuration_id, from_revision,
	metadata_tsvector, mappings
	from tmp_origin_intrinsic_metadata
	on conflict(id, indexer_configuration_id)
	do nothing;
	end if;
	return;
	end
	$$;

	comment on function swh_origin_intrinsic_metadata_add(boolean) IS 'Add new origin intrinsic metadata';