From 9e987ef0f403efda60210ff508d435211a5e9828 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@semantico.com>
Date: Fri, 2 Sep 2016 11:03:47 +0100
Subject: [PATCH] bin/dbq-dir2sqlite

---
 etc/dbs.php    | 16 ++++++++++++++++
 etc/dbs.yaml   |  9 +--------
 etc/dbs/nb.php |  3 +--
 etc/dbs/wp.php |  2 +-
 4 files changed, 19 insertions(+), 11 deletions(-)

diff --git a/etc/dbs.php b/etc/dbs.php
index 4b0fc1e7..11a7c7e7 100644
--- a/etc/dbs.php
+++ b/etc/dbs.php
@@ -1,4 +1,5 @@
 <?php
+require_once dirname(__FILE__).'/../lib/php/nb.php';
 $CONF = array();
 #$dev = (bool)(stripos(gethostname(),'macbook') !== false);
 $LOCAL_DB = (
@@ -6,6 +7,20 @@ $LOCAL_DB = (
   and ! file_exists('/opt/local/var/run/mysql5/mysqld.sock')
 ) ? true : false;
 
+# Look for sqlite db path
+$DIR_SQLITE = '~nicoadm/ownCloud';
+foreach ([
+  '~nico/ownCloud',
+  '~nicoadm/ownCloud',
+] as $dir) {
+  $dir = nb::untilde($dir);
+  if (!is_readable($dir)) continue;
+  $DIR_SQLITE = $dir;
+  break;
+}
+if ($DIR_SQLITE) $DIR_SQLITE .= '/var/lib/sqlite';
+
+# Includes
 $dir = dirname(__FILE__).'/dbs';
 foreach (array(
   'postfix',
@@ -17,4 +32,5 @@ foreach (array(
 ) as $file) {
   if (file_exists("$dir/$file.php")) require_once("$dir/$file.php");
 }
+
 ?>
diff --git a/etc/dbs.yaml b/etc/dbs.yaml
index defbc91e..0fc34a49 100644
--- a/etc/dbs.yaml
+++ b/etc/dbs.yaml
@@ -44,13 +44,6 @@ izi-dev:
 
 postfix:
   title: Postfix on Izideal
-  host: mail.izideal.vpn
+  host: admin.izideal.vpn
   user: postfix
   type: mysql
-
-owncloud:
-  host: /home/owncloud/data/owncloud.db
-  #host: /dev/shm/owncloud.db
-  #host: /opt/owncloud/data/owncloud.db
-  type: sqlite
-  default_table: oc_users
diff --git a/etc/dbs/nb.php b/etc/dbs/nb.php
index c1f06de7..e3a442d9 100644
--- a/etc/dbs/nb.php
+++ b/etc/dbs/nb.php
@@ -1,6 +1,5 @@
 <?php
 
-#bye($LOCAL_DB);
 $CONF['nb'] = array(
   'host' => 'admin.izideal.vpn',
   'type' => 'mysql',
@@ -11,7 +10,7 @@ $CONF['nb'] = array(
 );
 
 $CONF['nb-sqlite'] = array (
-  'pdo' => 'sqlite:'.nb::untilde('~nico/ownCloud/var/lib/sqlite/nb.db'),
+  'host' => "$DIR_SQLITE/nb.db",
   'type' => 'sqlite',
   '_import' => '_rent',
 );
diff --git a/etc/dbs/wp.php b/etc/dbs/wp.php
index fcb1202c..f13220b2 100644
--- a/etc/dbs/wp.php
+++ b/etc/dbs/wp.php
@@ -22,7 +22,7 @@ if (false and !empty($GLOBALS['wpdb'])) {
 }
 
 $CONF['wp-sqlite'] = array (
-  'host' => nb::untilde('~nico/ownCloud/var/lib/sqlite/wp.db'),
+  'host' => "$DIR_SQLITE/wp.db",
   'type' => 'sqlite',
   '_import' => '_wp',
 );
-- 
2.47.3