diff options
Diffstat (limited to 'subprojects/boost-sqlite/test/test-db.sql')
| -rw-r--r-- | subprojects/boost-sqlite/test/test-db.sql | 29 |
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 |