Mercurial > hg > dbutils / file diff

--- a/testdata.sql	Wed Jan 21 18:19:31 2026 +0100
+++ b/testdata.sql	Wed Feb 04 20:00:54 2026 +0100
@@ -28,6 +28,21 @@
 	name text
 );
 
+create table Resource(
+	resource_id integer primary key autoincrement,
+	parent_id integer references Resource(resource_id),
+	nodename text,
+	content text,
+	iscollection integer default 0
+);
+
+create table Note(
+	note_id integer primary key autoincrement,
+	resource_id integer references Resource(resource_id),
+	tags text,
+	type int
+);
+
 insert into country (name) values ('Germany');
 
 insert into address (street, zip, city, country_id) 
@@ -46,3 +61,39 @@
 (1, 'manager'), 
 (2, 'extern');
 
+insert into Resource(nodename, iscollection)
+values
+('root', 1);
+
+insert into Resource(parent_id, nodename, iscollection)
+values
+((select resource_id from Resource where nodename = 'root'), 'Collection1', 1);
+
+insert into Resource(parent_id, nodename, iscollection)
+values
+((select resource_id from Resource where nodename = 'root'), 'Collection2', 1);
+
+insert into Resource(parent_id, nodename, content)
+values
+((select resource_id from Resource where nodename = 'Collection1'), 'note1', 'Hello World!');
+
+insert into Resource(parent_id, nodename, content)
+values
+((select resource_id from Resource where nodename = 'Collection1'), 'note2', 'Test String');
+
+insert into Resource(parent_id, nodename, content)
+values
+((select resource_id from Resource where nodename = 'Collection2'), 'note3', 'Content Text');
+
+insert into Note(resource_id, tags, type)
+values
+((select resource_id from Resource where nodename = 'note1'), 'todo, test', 1);
+
+insert into Note(resource_id, tags, type)
+values
+((select resource_id from Resource where nodename = 'note2'), 'work, project2501, ai', 2);
+
+insert into Note(resource_id, tags, type)
+values
+((select resource_id from Resource where nodename = 'note3'), 'finance', 3);
+