diff options
Diffstat (limited to 'src/db.phel')
| -rw-r--r-- | src/db.phel | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/src/db.phel b/src/db.phel new file mode 100644 index 0000000..3f50ccc --- /dev/null +++ b/src/db.phel @@ -0,0 +1,9 @@ +(ns lezer.db + (:require phel.pdo)) + +(def conn (pdo/connect "sqlite:test.db")) + +(defn initialize-database [] + (pdo/exec conn "create table if not exists books (id integer primary key autoincrement, title varchar(255), subtitle varchar(255))") + (pdo/exec conn "create table if not exists authors (id integer primary key autoincrement, name varchar(255))") + (pdo/exec conn "create table if not exists authors_books (author_id integer, book_id integer)")) |