# HG changeset patch
# User Olaf Wintermann <olaf.wintermann@gmail.com>
# Date 1650112568 -7200
# Node ID 7dd45173f68a832bbfaa5b3e771b693031d2fd98
# Parent  a171da778817e0f6326aa04f876e200640cbaf86
create pg test data

diff -r a171da778817 -r 7dd45173f68a src/server/plugins/postgresql/test/createtestdb.sh
--- a/src/server/plugins/postgresql/test/createtestdb.sh	Sat Feb 19 16:34:29 2022 +0100
+++ b/src/server/plugins/postgresql/test/createtestdb.sh	Sat Apr 16 14:36:08 2022 +0200
@@ -41,6 +41,23 @@
 fi
 echo "success"
 
+echo "## create test data"
+psql -h $TESTDB_ABS/run -d testdb -f postgresql_vfs.sql
+if [ $? -ne 0 ]; then
+	echo "## create test data (1) failed"
+	echo "## stop database"
+	pg_ctl -D $TESTDB_ABS stop
+	exit 1
+fi
+psql -h $TESTDB_ABS/run -d testdb -f postgresql_vfs_testdata.sql
+if [ $? -ne 0 ]; then
+	echo "## create test data (2) failed"
+	echo "## stop database"
+	pg_ctl -D $TESTDB_ABS stop
+	exit 1
+fi
+echo "success"
+
 echo "## stop database"
 pg_ctl -D $TESTDB_ABS stop
 exit $?
diff -r a171da778817 -r 7dd45173f68a src/server/plugins/postgresql/test/postgresql_vfs.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/server/plugins/postgresql/test/postgresql_vfs.sql	Sat Apr 16 14:36:08 2022 +0200
@@ -0,0 +1,16 @@
+
+create table Resource (
+    resource_id       serial    primary key,
+    parent_id         int       references Resource(resource_id),
+    nodename          text      not null,
+    iscollection      boolean   not null default false,
+	
+    lastmodified      timestamp not null default current_date,
+    creationdate      timestamp not null default current_date,
+    contentlength     bigint    not null default 0,
+
+    resoid            oid,
+    
+    unique(parent_id, nodename)
+);
+
diff -r a171da778817 -r 7dd45173f68a src/server/plugins/postgresql/test/postgresql_vfs_testdata.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/server/plugins/postgresql/test/postgresql_vfs_testdata.sql	Sat Apr 16 14:36:08 2022 +0200
@@ -0,0 +1,29 @@
+
+do $$
+declare
+    res_id int;
+begin
+    insert into Resource (nodename, iscollection) values ('', true);
+    res_id := lastval();
+   
+    insert into Resource(parent_id,  nodename, resoid) values
+    (res_id, 'file1.txt', (select lo_create(0))),
+    (res_id, 'file2.txt', (select lo_create(0))),
+    (res_id, 'file3.txt', (select lo_create(0))),
+    (res_id, 'file4.txt', (select lo_create(0)));
+    
+    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, resoid) values
+    (res_id, 'd1file1.txt', (select lo_create(0))),
+    (res_id, 'd2file1.txt', (select lo_create(0))),
+    (res_id, 'd2file2.txt', (select lo_create(0)));
+
+end $$;
+