From 923c1080c3038781d1ca56fd192e34d3808e26dc Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Thu, 17 Nov 2016 09:25:28 +0000
Subject: [PATCH] sql.[rep

---
 lib/php/db.php              | 4 ++++
 lib/php/db/types/sqlite.php | 7 +++++++
 2 files changed, 11 insertions(+)

diff --git a/lib/php/db.php b/lib/php/db.php
index f5b8f624..3902a42b 100644
--- a/lib/php/db.php
+++ b/lib/php/db.php
@@ -946,6 +946,10 @@ class Db extends nb {
       if (($i++) == 0) echo "\n-- SQL_PRE\n";
       echo rtrim($s,';').";\n";
     }
+    $i = 0; foreach ((array)$this->method('sql.pre') as $s) {
+      if (($i++) == 0) echo "\n-- SQL.PRE\n";
+      echo rtrim($s,';').";\n";
+    }
 
       #bye($this->db()->type);
     foreach ($tables as $t) {
diff --git a/lib/php/db/types/sqlite.php b/lib/php/db/types/sqlite.php
index cb60c261..771024af 100644
--- a/lib/php/db/types/sqlite.php
+++ b/lib/php/db/types/sqlite.php
@@ -5,6 +5,13 @@ if (!class_exists('Db')) {
 }
 $DB_TYPES['sqlite'] = array (
 'use_path' => true,
+'sql.pre' => [
+  'PRAGMA foreign_keys=OFF',
+  'BEGIN TRANSACTION',
+],
+'sql.post' => [
+  'COMMIT',
+],
 'extra_where' => 'denorm',
 
 'quote_name' => '`',
-- 
2.47.3