From 10e1bb55e479e003164cb0e87ed023b455e567b0 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <mail@andreasbaumann.cc>
Date: Sat, 2 May 2015 13:57:28 +0200
Subject: enable foreign keys if the cppdb driver is 'sqlite3'

---
 src/strusCms.cpp | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

diff --git a/src/strusCms.cpp b/src/strusCms.cpp
index 137a209..3858b32 100644
--- a/src/strusCms.cpp
+++ b/src/strusCms.cpp
@@ -3,6 +3,20 @@
 #include <cppcms/url_mapper.h>   
 #include <cppcms/http_response.h>
 #include <cppcms/json.h>
+#include <cppdb/frontend.h>
+
+namespace {
+
+void setup_dbconnection( cppdb::session &sql )
+{
+	std::string driver = sql.driver( );
+		
+	if( driver == "sqlite3" ) {
+		sql << "PRAGMA foreign_keys = 1" << cppdb::exec;
+	}
+}
+
+}
 
 namespace apps {
 
@@ -21,6 +35,9 @@ strusCms::strusCms( cppcms::service &srv )
 	locale_name = "en";
 	script = settings( ).get<std::string>( "strusCms.script" );
 
+	cppdb::session sql( conn );
+	sql.once( setup_dbconnection );
+	
 	add( intro );
 	add( user );
 
-- 
cgit v1.2.3-54-g00ecf