From efcea3a80da7c4479d5fe168435ecc9fd06bdc72 Mon Sep 17 00:00:00 2001 From: John Turner Date: Sun, 14 Sep 2025 00:16:10 -0400 Subject: Squashed 'subprojects/boost-sqlite/' content from commit 3378e35 git-subtree-dir: subprojects/boost-sqlite git-subtree-split: 3378e353705271e569cf4ba15c467b840a39798c --- test/test-db.sql | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 test/test-db.sql (limited to 'test/test-db.sql') diff --git a/test/test-db.sql b/test/test-db.sql new file mode 100644 index 0000000..251313c --- /dev/null +++ b/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 -- cgit v1.2.3