comparison: doc/development/postgresql_vfs_testdata.sql
doc/development/postgresql_vfs_testdata.sql
- branch
- webdav
- changeset 281
- e9dc53661df4
- parent 278
- 38bf7b42b58c
- child 283
- 25e5b771677d
equal
deleted
inserted
replaced
| 280:d0d5a970292f | 281:e9dc53661df4 |
|---|---|
| 1 | 1 |
| 2 do $$ | |
| 3 declare | |
| 4 res_id int; | |
| 5 begin | |
| 6 insert into Resource (nodename, iscollection) values ('', true); | |
| 7 res_id := lastval(); | |
| 8 | |
| 9 insert into Resource(parent_id, nodename) values | |
| 10 (res_id, 'file1.txt'), | |
| 11 (res_id, 'file2.txt'), | |
| 12 (res_id, 'file3.txt'), | |
| 13 (res_id, 'file4.txt'); | |
| 14 | |
| 15 insert into Resource(parent_id, nodename, iscollection) values | |
| 16 (res_id, 'dir1', true); | |
| 17 res_id := lastval(); | |
| 18 | |
| 19 insert into Resource(parent_id, nodename, iscollection) values | |
| 20 (res_id, 'dir2', true); | |
| 21 res_id := lastval(); | |
| 22 | |
| 23 insert into Resource(parent_id, nodename) values | |
| 24 (res_id, 'd1file1.txt'), | |
| 25 (res_id, 'd2file1.txt'), | |
| 26 (res_id, 'd2file2.txt'); | |
| 2 | 27 |
| 3 insert into Resource (nodename, iscollection) values ('', true); | 28 end $$; |
| 4 | 29 |
| 5 insert into Resource(parent_id, nodename) values | |
| 6 ((select resource_id from Resource where parent_id is null), 'file1.txt'), | |
| 7 ((select resource_id from Resource where parent_id is null), 'file2.txt'), | |
| 8 ((select resource_id from Resource where parent_id is null), 'file3.txt'), | |
| 9 ((select resource_id from Resource where parent_id is null), 'file4.txt'); | |
| 10 | |
| 11 insert into Resource(parent_id, nodename, iscollection) values | |
| 12 ((select resource_id from Resource where parent_id is null), 'dir1', true); | |
| 13 | |
| 14 insert into Resource(parent_id, nodename, iscollection) values | |
| 15 ((select resource_id from Resource where nodename = 'dir1'), 'dir2', true); | |
| 16 | |
| 17 insert into Resource(parent_id, nodename) values | |
| 18 ((select resource_id from Resource where nodename = 'dir1'), 'd1file1.txt'), | |
| 19 ((select resource_id from Resource where nodename = 'dir2'), 'd2file1.txt'), | |
| 20 ((select resource_id from Resource where nodename = 'dir2'), 'd2file2.txt'); |
