From c895083b7e9b8a32c1b87f9caaf696f7601afd29 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Wed, 14 Sep 2016 18:05:24 +0200
Subject: [PATCH] sqlite dirs

---
 bin/dbq-dir2sqlite | 9 +++++++++
 etc/dbs.php        | 2 ++
 2 files changed, 11 insertions(+)

diff --git a/bin/dbq-dir2sqlite b/bin/dbq-dir2sqlite
index 1dd30e27..a3857fea 100755
--- a/bin/dbq-dir2sqlite
+++ b/bin/dbq-dir2sqlite
@@ -136,6 +136,15 @@ for vars in $(dbq a=ls type='!sqlite' out=sh); do
   fi
 
   mv "$TMP_DB" "$id.db"
+  cat <<EOF > "$id.php"
+<?php
+\$CONF['sqlite-$id'] = [
+  'type' => 'sqlite',
+  'host' => '$id.db',
+  'title' => 'created by $NAME',
+];
+?>
+EOF
   [ "$VERBOSE" -gt 0 ] && echo "done - $( du -sh "$id.db" | awk '{print $1}' )"
 done
 
diff --git a/etc/dbs.php b/etc/dbs.php
index c6e63d2f..ac3880f9 100644
--- a/etc/dbs.php
+++ b/etc/dbs.php
@@ -40,6 +40,7 @@ foreach ($CONF as $id => $db) {
     and !empty($db['host']) 
   ) $host_already_exists[$db['host']] = $id;
 }
+
 if ($DIR_SQLITE) {
   foreach (nb::ls_dir($DIR_SQLITE,'\.db$') as $file) {
 
@@ -54,6 +55,7 @@ if ($DIR_SQLITE) {
       'host' => "$DIR_SQLITE/$file",
       'type' => 'sqlite',
       'title' => 'created by dbs.php',
+      #'_import' => basename($file,'.db'),
     ];
   }
 }
-- 
2.47.3