Merge commit 'efcea3a80da7c4479d5fe168435ecc9fd06bdc72' as 'subprojects/boost-sqlite'

1 files changed, 29 insertions, 0 deletions

diff --git a/subprojects/boost-sqlite/test/test-db.sql b/subprojects/boost-sqlite/test/test-db.sql
new file mode 100644
index 0000000..251313c
--- /dev/null
+++ b/subprojects/boost-sqlite/test/test-db.sql
@@ -0,0 +1,29 @@
+--query_helper(R"(
+
+create table author (
+    id integer primary key autoincrement not null,
+    first_name text unique not null,
+    last_name text
+);
+
+insert into author (first_name, last_name) values
+                   ('vinnie', 'falco'),
+                   ('richard', 'hodges'),
+                   ('ruben', 'perez'),
+                   ('peter', 'dimov')
+;
+
+create table library(
+    id integer  primary key autoincrement,
+    name text unique,
+    author  integer references author(id)
+);
+
+insert into library ("name", author) values
+                    ('beast',    (select id from author where first_name = 'vinnie' and last_name = 'falco')),
+                    ('mysql',    (select id from author where first_name = 'ruben'  and last_name = 'perez')),
+                    ('mp11',     (select id from author where first_name = 'peter'  and last_name = 'dimov')),
+                    ('variant2', (select id from author where first_name = 'peter'  and last_name = 'dimov'))
+;
+
+--)")
\ No newline at end of file