summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRob Crittenden <rcritten@redhat.com>2015-05-07 15:51:23 -0400
committerRob Crittenden <rcritten@redhat.com>2015-05-07 15:51:23 -0400
commitc3cc4b620884e9e7935f87486131f18f5658292e (patch)
tree6e36cc50f79f8f96249079ebc023c40db8e18e99
parent1bcc0d697dd37a9268641f0cbaa7e9e781552233 (diff)
downloadipsilon.git-c3cc4b620884e9e7935f87486131f18f5658292e.tar.gz
ipsilon.git-c3cc4b620884e9e7935f87486131f18f5658292e.tar.xz
ipsilon.git-c3cc4b620884e9e7935f87486131f18f5658292e.zip
Add db.conn.log option to suppress sql logs by defaultlogger
The Store logging is quite verbose with a flurry of init and destroy messages with each session. Setting db.conn.log to False (default) will suppress these. If one needs to do connection tracing it can be enabled. Signed-off-by: Rob Crittenden <rcritten@redhat.com>
-rw-r--r--examples/ipsilon.conf1
-rw-r--r--ipsilon/util/data.py8
-rw-r--r--templates/install/ipsilon.conf1
3 files changed, 9 insertions, 1 deletions
diff --git a/examples/ipsilon.conf b/examples/ipsilon.conf
index e89f970..bd4924b 100644
--- a/examples/ipsilon.conf
+++ b/examples/ipsilon.conf
@@ -2,6 +2,7 @@
debug = True
tools.log_request_response.on = False
template_dir = "templates"
+db.conn.log = False
log.screen = True
base.mount = "/idp"
diff --git a/ipsilon/util/data.py b/ipsilon/util/data.py
index eec00b5..26fa859 100644
--- a/ipsilon/util/data.py
+++ b/ipsilon/util/data.py
@@ -37,11 +37,13 @@ class SqlStore(Log):
@classmethod
def get_connection(cls, name):
if name not in cls.__instances.keys():
- logging.debug('SqlStore new: %s', name)
+ if cherrypy.config.get('db.conn.log', False):
+ logging.debug('SqlStore new: %s', name)
cls.__instances[name] = SqlStore(name)
return cls.__instances[name]
def __init__(self, name):
+ self.db_conn_log = cherrypy.config.get('db.conn.log', False)
self.debug('SqlStore init: %s' % name)
self.name = name
engine_name = name
@@ -61,6 +63,10 @@ class SqlStore(Log):
self._dbengine = create_engine(engine_name, **pool_args)
self.is_readonly = False
+ def debug(self, fact):
+ if self.db_conn_log:
+ super(SqlStore, self).debug(fact)
+
def engine(self):
return self._dbengine
diff --git a/templates/install/ipsilon.conf b/templates/install/ipsilon.conf
index 522cb38..b57aa55 100644
--- a/templates/install/ipsilon.conf
+++ b/templates/install/ipsilon.conf
@@ -2,6 +2,7 @@
debug = ${debugging}
tools.log_request_response.on = False
template_dir = "templates"
+db.conn.log = False
log.screen = ${debugging}
base.mount = "/${instance}"