simple-web-app

commit b067e95c8802a34e87604a809eeb49b2cd2388ce
parent 79dd01e19d78c56a1ceceb3024ae2c67fc7769c2
Author: Silas Brack <silasbrack@gmail.com>
Date:   Sat, 13 Jun 2026 13:19:23 +0200

test: verify foreign_keys is ON after migrations

Catches migrations that disable foreign_keys and forget to
re-enable them.

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>

Diffstat:
M
src/migrations.rs
 | 
14
++++++++++++++

1 file changed, 14 insertions(+), 0 deletions(-)
diff --git a/src/migrations.rs b/src/migrations.rs
@@ -117,4 +117,18 @@ mod tests {
             assert!(version >= expected);
         }
     }
+
+    #[test]
+    fn foreign_keys_on_after_migrations() {
+        let conn = Connection::open_in_memory().unwrap();
+        conn.execute_batch("PRAGMA foreign_keys=ON;").unwrap();
+
+        run(&conn).unwrap();
+
+        let fk_enabled: i64 = conn
+            .query_row("PRAGMA foreign_keys", [], |row| row.get(0))
+            .unwrap();
+
+        assert_eq!(fk_enabled, 1, "foreign_keys must be ON after migrations");
+    }
 }