• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

doc/development/postgresql_vfs_testdata.sql@79029fe26aae (annotated)

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

278 38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	1
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	2
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	3	insert into Resource (nodename, iscollection) values ('', true);
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	4
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	5	insert into Resource(parent_id, nodename) values
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	6	((select resource_id from Resource where parent_id is null), 'file1.txt'),
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	7	((select resource_id from Resource where parent_id is null), 'file2.txt'),
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	8	((select resource_id from Resource where parent_id is null), 'file3.txt'),
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	9	((select resource_id from Resource where parent_id is null), 'file4.txt');
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	10
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	11	insert into Resource(parent_id, nodename, iscollection) values
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	12	((select resource_id from Resource where parent_id is null), 'dir1', true);
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	13
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	14	insert into Resource(parent_id, nodename, iscollection) values
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	15	((select resource_id from Resource where nodename = 'dir1'), 'dir2', true);
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	16
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	17	insert into Resource(parent_id, nodename) values
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	18	((select resource_id from Resource where nodename = 'dir1'), 'd1file1.txt'),
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	19	((select resource_id from Resource where nodename = 'dir2'), 'd2file1.txt'),
38bf7b42b58c implement pg_vfs_open Olaf Wintermann <olaf.wintermann@gmail.com> parents: diff changeset	20	((select resource_id from Resource where nodename = 'dir2'), 'd2file2.txt');