Page MenuHomeSoftware Heritage

041.sql
No OneTemporary

-- SWH DB schema upgrade
-- from_version: 40
-- to_version: 41
-- description: Open directory get by id
insert into dbversion(version, release, description)
values(41, now(), 'Work In Progress');
-- Retrieve information on directory from temporary table
create or replace function swh_directory_get()
returns setof directory
language plpgsql
as $$
begin
return query
select d.id, d.dir_entries, d.file_entries, d.rev_entries
from tmp_directory t
inner join directory d on t.id = d.id;
return;
end
$$;

File Metadata

Mime Type
text/plain
Expires
Sat, Jun 21, 8:51 PM (3 w, 6 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3245340

Event Timeline