Mercurial > hg > webserver / file revision

do $$
declare
    res_id int;
begin
    insert into Resource (nodename, iscollection) values ('', true);
    res_id := lastval();
   
    insert into Resource(parent_id,  nodename) values
    (res_id, 'file1.txt'),
    (res_id, 'file2.txt'),
    (res_id, 'file3.txt'),
    (res_id, 'file4.txt');
    
    insert into Resource(parent_id,  nodename, iscollection) values
    (res_id, 'dir1', true);
    res_id := lastval();
    
    insert into Resource(parent_id,  nodename, iscollection) values
    (res_id, 'dir2', true);
    res_id := lastval();
    
    insert into Resource(parent_id,  nodename) values
    (res_id, 'd1file1.txt'),
    (res_id, 'd2file1.txt'),
    (res_id, 'd2file2.txt');

end $$;