037.sql
No OneTemporary
Actions

Size

654 B

Subscribers

None

037.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 36
	-- to_version: 37
	-- description: Permit directory entry lookup per path

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

	-- Find a directory entry by its path
	create or replace function swh_find_directory_entry_by_path(walked_dir_id sha1_git,
	dir_or_content_path unix_path)
	returns directory_entry
	language sql
	stable
	as $$
	select dir_id, type, target, name, perms, status, sha1, sha1_git, sha256
	from swh_directory_walk(walked_dir_id)
	where name = dir_or_content_path
	$$;

File Metadata

Mime Type: text/plain
Expires: Thu, Apr 17, 8:20 AM (4 d, 20 h ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3245900

Event Timeline