No OneTemporary
Actions

Size

738 B

Subscribers

None

View Options

	diff --git a/sql/upgrades/040.sql b/sql/upgrades/040.sql
	new file mode 100644
	index 00000000..ebcb334e
	--- /dev/null
	+++ b/sql/upgrades/040.sql
	@@ -0,0 +1,24 @@
	+-- SWH DB schema upgrade
	+-- from_version: 39
	+-- to_version: 40
	+-- description: Open entity get by uuid
	+
	+insert into dbversion(version, release, description)
	+ values(40, now(), 'Work In Progress');
	+
	+create or replace function swh_entity_get(entity_uuid uuid)
	+ returns setof entity
	+ language sql
	+ stable
	+as $$
	+ with recursive entity_hierarchy as (
	+ select e.*
	+ from entity e where uuid = entity_uuid
	+ union
	+ select p.*
	+ from entity_hierarchy e
	+ join entity p on e.parent = p.uuid
	+ )
	+ select *
	+ from entity_hierarchy;
	+$$;