enable foreign keys if the cppdb driver is 'sqlite3'

1 files changed, 17 insertions, 0 deletions

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 );