Make it possible to enable database query echoing

Signed-off-by: Patrick Uiterwijk <puiterwijk@redhat.com>
Reviewed-by: Rob Crittenden <rcritten@redhat.com>

diff --git a/ipsilon/util/data.py b/ipsilon/util/data.py
index 52fde62..0981c52 100644 (file)
--- a/ipsilon/util/data.py
+++ b/ipsilon/util/data.py
@@ -69,7 +69,10 @@ class SqlStore(BaseStore):
             # It's not possible to share connections for SQLite between
             #  threads, so let's use the SingletonThreadPool for them
             pool_args = {'poolclass': SingletonThreadPool}
-        self._dbengine = create_engine(engine_name, **pool_args)
+        self._dbengine = create_engine(engine_name,
+                                       echo=cherrypy.config.get('db.echo',
+                                                                False),
+                                       **pool_args)
         self.is_readonly = False
 
     def add_constraint(self, constraint):

diff --git a/templates/install/ipsilon.conf b/templates/install/ipsilon.conf
index f68c12a..f69ac9d 100644 (file)
--- a/templates/install/ipsilon.conf
+++ b/templates/install/ipsilon.conf
@@ -5,6 +5,7 @@ template_dir = "templates"
 cache_dir = "${cachedir}"
 cleanup_interval = ${cleanup_interval}
 db.conn.log = False
+db.echo = False
 
 log.screen = ${debugging}
 base.mount = "/${instance}"