From 2b599474908fad582078157f946d1ae10cde9eff Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Mon, 5 Sep 2016 17:02:01 +0100 Subject: [PATCH] type.tables --- lib/php/db/types/sqlite.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/lib/php/db/types/sqlite.php b/lib/php/db/types/sqlite.php index 10b0ab8d..811cdc77 100644 --- a/lib/php/db/types/sqlite.php +++ b/lib/php/db/types/sqlite.php @@ -69,6 +69,7 @@ $DB_TYPES['sqlite'] = array ( 'tables' => function($Db) { # NB 03.09.16 # Handle attach mechnisum + #$Db->tables(); $dbs = $Db->databases(); $debug = 0;#$Db->p('db')=='all'; @@ -80,8 +81,9 @@ $DB_TYPES['sqlite'] = array ( $sql = ''; foreach ($dbs as $db) { $sql .= ($sql ? ' UNION ' : '').str_replace('sqlite_',$db['name'].'.sqlite_', + #"SELECT name as name,type FROM sqlite_master WHERE type IN('table','view') AND name NOT LIKE 'sqlite_%'" "SELECT '".$db['name'].".'||name as name,type FROM sqlite_master WHERE type IN('table','view') AND name NOT LIKE 'sqlite_%'" - ); + ); } if ($debug) debug($sql); -- 2.47.3