about summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2019-12-02 02:05:53 -0500
committerJune McEnroe <june@causal.agency>2019-12-02 02:06:10 -0500
commit926138b463fff770cf5fbb4438853d535205da2b (patch)
treeb55ab230c7c033a9033c1dffcbb19dbb197c6b24
parentImplement DB initialization and migration (diff)
downloadlitterbox-926138b463fff770cf5fbb4438853d535205da2b.tar.gz
litterbox-926138b463fff770cf5fbb4438853d535205da2b.zip
Enable foreign key enforcement
-rw-r--r--database.h9
1 files changed, 7 insertions, 2 deletions
diff --git a/database.h b/database.h
index 290564e..b98721b 100644
--- a/database.h
+++ b/database.h
@@ -47,14 +47,19 @@ static inline sqlite3 *dbOpen(char *path, int flags) {
 		if (error && errno != EEXIST) err(EX_CANTCREAT, "%s", path);
 		*base = '/';
 	}
+
 	sqlite3 *db;
 	int error = sqlite3_open_v2(path, &db, flags, NULL);
-	if (!error) return db;
 	if (error == SQLITE_CANTOPEN) {
 		sqlite3_close(db);
 		return NULL;
 	}
-	errx(EX_NOINPUT, "%s: %s", path, sqlite3_errmsg(db));
+	if (error) errx(EX_NOINPUT, "%s: %s", path, sqlite3_errmsg(db));
+
+	error = sqlite3_exec(db, "PRAGMA foreign_keys = true;", NULL, NULL, NULL);
+	if (error) errx(EX_SOFTWARE, "sqlite3_exec: %s", sqlite3_errmsg(db));
+
+	return db;
 }
 
 static inline sqlite3 *dbFind(int flags) {