enable sqlite foreign_keys = ON by default

Wed, 21 Jan 2026 18:02:19 +0100

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Wed, 21 Jan 2026 18:02:19 +0100
changeset 50
c160700751ec
parent 49
34c723ed7190
child 51
e3163dc41a80

enable sqlite foreign_keys = ON by default

dbutils/sqlite.c file | annotate | diff | comparison | revisions
--- a/dbutils/sqlite.c	Wed Jan 21 17:59:45 2026 +0100
+++ b/dbutils/sqlite.c	Wed Jan 21 18:02:19 2026 +0100
@@ -47,7 +47,13 @@
     DBUConnection *conn = dbuSQLiteConnectionFromDB(db, true);
     if(!conn) {
         sqlite3_close(db);
+    } else {
+        if(dbuSqlExec(conn, "PRAGMA foreign_keys = ON;")) {
+            dbuConnectionFree(conn);
+            return NULL;
+        }
     }
+    
     return conn;
 }
 

mercurial