Revision 50ae16fba0878a153ea635c3e658975d346370a5 authored by Antoine R. Dumont (@ardumont) on 08 July 2016, 09:54:31 UTC, committed by Antoine R. Dumont (@ardumont) on 08 July 2016, 09:54:31 UTC
swh_visit_get was installed to initially use it in the new api. It was finally dismissed but got commited by error.
1 parent ee4a1bd
041.sql
-- 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
$$;
Computing file changes ...