From 28cf3c383efee96087039d932cdb181aab0b19f6 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Mon, 21 Nov 2016 12:12:08 +0000
Subject: [PATCH] detach sqlite

---
 etc/dbq/{shell.php => 000-local.php} | 0
 lib/php/db.php                       | 1 -
 lib/php/db/types/sqlite.php          | 3 +++
 3 files changed, 3 insertions(+), 1 deletion(-)
 rename etc/dbq/{shell.php => 000-local.php} (100%)

diff --git a/etc/dbq/shell.php b/etc/dbq/000-local.php
similarity index 100%
rename from etc/dbq/shell.php
rename to etc/dbq/000-local.php
diff --git a/lib/php/db.php b/lib/php/db.php
index 527f2e6b..f30373c9 100644
--- a/lib/php/db.php
+++ b/lib/php/db.php
@@ -299,7 +299,6 @@ class Db extends nb {
 
 	public function disconnect() {
     if (empty($this->conn)) return null;
-    #$this->conn->exec('COMMIT');
     $this->method('disconnect');
 # NB 09.09.16     return $this->conn->close();
   }
diff --git a/lib/php/db/types/sqlite.php b/lib/php/db/types/sqlite.php
index 5edb1b94..65c7b6ef 100644
--- a/lib/php/db/types/sqlite.php
+++ b/lib/php/db/types/sqlite.php
@@ -124,4 +124,7 @@ $DB_TYPES['sqlite'] = array (
   #debug($sql);
   return $sql;
 },
+'disconnect' => function($Db) {
+  foreach ($Db->sql_pre() as $s) { if ($s = preg_replace('/^ATTACH DATABASE.*? as (.*?)$/','DETACH DATABASE $1',$s)) $Db->conn->exec($s); }
+},
 );?>
-- 
2.47.3