From bf137ba4e38322270af20d6b1b352b3ccacd7a3d Mon Sep 17 00:00:00 2001 From: Razvan Deaconescu Date: Fri, 19 Aug 2011 13:43:53 +0300 Subject: [PATCH] ppf: Add Python logging module support. --- ppf/db/access.py | 32 ++++++++++++++++++++++++++------ 1 file changed, 26 insertions(+), 6 deletions(-) diff --git a/ppf/db/access.py b/ppf/db/access.py index 9d8bd57..db7cc46 100644 --- a/ppf/db/access.py +++ b/ppf/db/access.py @@ -1,8 +1,30 @@ import sys import sqlite3 import os.path +import logging + +# +# Logging code heavily inspired by Logging HOWTO documentation: +# http://docs.python.org/dev/howto/logging.html#configuring-logging +# + +# Create logger; default logging level is DEBUG. +logger = logging.getLogger(__name__) +logger.setLevel(logging.DEBUG) + +# Create console handler and set level to ERROR. +ch = logging.StreamHandler() +ch.setLevel(logging.ERROR) + +# Create formatter. +formatter = logging.Formatter('%(asctime)s - %(name)s - %(levelname)s - %(message)s') + +# Add formatter to console handler. +ch.setFormatter(formatter) + +# Add console handler to logger. +logger.addHandler(ch) -DEBUG = False class DatabaseAccess: """ @@ -329,15 +351,14 @@ class SQLiteDatabaseAccess(DatabaseAccess): print ("[client_sessions]An error ocurred: ", e.args[0]) def insert_status_messages_row(self, row): - if DEBUG == True: - print "[status_messages] INSERT row", row + logger.debug("[status_messages] INSERT row: %s" %row[0]) try: self.cursor.execute(""" INSERT INTO status_messages VALUES(?,?,?,?,?,?,?,?,?) """, row) self.conn.commit() except sqlite3.Error, e: - print ("[status_messages]An error ocurred: ", e.args[0]) + logger.error("[status_messages]An error ocurred: ", e.args[0]) def select_status_messages(self, show=False, cs_id=None, restrictArray=None): @@ -379,8 +400,7 @@ class SQLiteDatabaseAccess(DatabaseAccess): print("[status_messages]An error ocurred: ", e.args[0]) def insert_verbose_messages_row(self, row): - if DEBUG == True: - print "[verbose_messages] insert row", row + logger.debug("[verbose_messages] INSERT row %s" %row[0]) try: self.cursor.execute(""" INSERT INTO verbose_messages VALUES(?,?,?,?,?,?,?,?,?,?) -- 2.20.1