From 1fd54b7aa0449bd16b484f289da7b5264161f967 Mon Sep 17 00:00:00 2001
From: Tom Willemse
Date: Tue, 8 Sep 2026 00:26:08 -0700
Subject: Move database initialization

---
 src/db.phel | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 src/db.phel

(limited to 'src/db.phel')

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)"))
-- 
cgit v1.3-2-g0d8e