Mercurial > hg > webserver / file diff

--- a/doc/development/postgresql_vfs_testdata.sql	Mon Jan 31 21:33:46 2022 +0100
+++ b/doc/development/postgresql_vfs_testdata.sql	Tue Feb 01 17:47:50 2022 +0100
@@ -1,20 +1,29 @@
-
-
-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);
+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');
 
-insert into Resource(parent_id,  nodename, iscollection) values
-((select resource_id from Resource where nodename = 'dir1'), 'dir2', true);
+end $$;
 
-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');