doc/development/postgresql_vfs_testdata.sql

Mon, 31 Jan 2022 17:18:12 +0100

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Mon, 31 Jan 2022 17:18:12 +0100
branch
webdav
changeset 279
79029fe26aae
parent 278
38bf7b42b58c
child 281
e9dc53661df4
permissions
-rw-r--r--

add basic postgresql vfs directory functions



insert into Resource (nodename, iscollection) values ('', true);

insert into Resource(parent_id,  nodename) values
((select resource_id from Resource where parent_id is null), 'file1.txt'),
((select resource_id from Resource where parent_id is null), 'file2.txt'),
((select resource_id from Resource where parent_id is null), 'file3.txt'),
((select resource_id from Resource where parent_id is null), 'file4.txt');

insert into Resource(parent_id,  nodename, iscollection) values
((select resource_id from Resource where parent_id is null), 'dir1', true);

insert into Resource(parent_id,  nodename, iscollection) values
((select resource_id from Resource where nodename = 'dir1'), 'dir2', true);

insert into Resource(parent_id,  nodename) values
((select resource_id from Resource where nodename = 'dir1'), 'd1file1.txt'),
((select resource_id from Resource where nodename = 'dir2'), 'd2file1.txt'),
((select resource_id from Resource where nodename = 'dir2'), 'd2file2.txt');

mercurial