blob: a83a29042db642d8fe6d31d0f8f2849bbcd8f982 (
plain)
1
2
3
4
5
6
7
8
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), created_at integer, updated_at integer)")
(pdo/exec conn "create table if not exists authors (id integer primary key autoincrement, name varchar(255), created_at integer, updated_at integer)")
(pdo/exec conn "create table if not exists authors_books (author_id integer, book_id integer)"))
|
