--- /dev/null
+"""Miscellaneous goodies for psycopg2
+
+This module is a generic place used to hold little helper functions
+and classes untill a better place in the distribution is found.
+"""
+# psycopg/extras.py - miscellaneous extra goodies for psycopg
+#
+# Copyright (C) 2003-2004 Federico Di Gregorio <fog@debian.org>
+#
+# This program is free software; you can redistribute it and/or modify
+# it under the terms of the GNU General Public License as published by the
+# Free Software Foundation; either version 2, or (at your option) any later
+# version.
+#
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTIBILITY
+# or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
+# for more details.
+
+import os
+import time
+
+try:
+ import logging
+except:
+ logging = None
+
+from psycopg2.extensions import cursor as _cursor
+from psycopg2.extensions import connection as _connection
+from psycopg2.extensions import register_adapter as _RA
+from psycopg2.extensions import adapt as _A
+
+
+class DictConnection(_connection):
+ """A connection that uses DictCursor automatically."""
+ def cursor(self):
+ return _connection.cursor(self, cursor_factory=DictCursor)
+
+class DictCursor(_cursor):
+ """A cursor that keeps a list of column name -> index mappings."""
+
+ __query_executed = 0
+
+ def execute(self, query, vars=None, async=0):
+ self.row_factory = DictRow
+ self.index = {}
+ self.__query_executed = 1
+ return _cursor.execute(self, query, vars, async)
+
+ def callproc(self, procname, vars=None):
+ self.row_factory = DictRow
+ self.index = {}
+ self.__query_executed = 1
+ return _cursor.callproc(self, procname, vars)
+
+ def _build_index(self):
+ if self.__query_executed == 1 and self.description:
+ for i in range(len(self.description)):
+ self.index[self.description[i][0]] = i
+ self.__query_executed = 0
+
+ def fetchone(self):
+ res = _cursor.fetchone(self)
+ if self.__query_executed:
+ self._build_index()
+ return res
+
+ def fetchmany(self, size=None):
+ res = _cursor.fetchmany(self, size)
+ if self.__query_executed:
+ self._build_index()
+ return res
+
+ def fetchall(self):
+ res = _cursor.fetchall(self)
+ if self.__query_executed:
+ self._build_index()
+ return res
+
+ def next(self):
+ res = _cursor.fetchone(self)
+ if res is None:
+ raise StopIteration()
+ if self.__query_executed:
+ self._build_index()
+ return res
+
+class DictRow(list):
+ """A row object that allow by-colun-name access to data."""
+
+ def __init__(self, cursor):
+ self._index = cursor.index
+ self[:] = [None] * len(cursor.description)
+
+ def __getitem__(self, x):
+ if type(x) != int:
+ x = self._index[x]
+ return list.__getitem__(self, x)
+
+ def items(self):
+ res = []
+ for n, v in self._index.items():
+ res.append((n, list.__getitem__(self, v)))
+ return res
+
+ def keys(self):
+ return self._index.keys()
+
+ def values(self):
+ return tuple(self[:])
+
+ def has_key(self, x):
+ return self._index.has_key(x)
+
+ def get(self, x, default=None):
+ try:
+ return self[x]
+ except:
+ return default
+
+
+class SQL_IN(object):
+ """Adapt any iterable to an SQL quotable object."""
+
+ def __init__(self, seq):
+ self._seq = seq
+
+ def prepare(self, conn):
+ self._conn = conn
+
+ def getquoted(self):
+ # this is the important line: note how every object in the
+ # list is adapted and then how getquoted() is called on it
+ pobjs = [_A(o) for o in self._seq]
+ for obj in pobjs:
+ if hasattr(obj, 'prepare'):
+ obj.prepare(self._conn)
+ qobjs = [str(o.getquoted()) for o in pobjs]
+ return '(' + ', '.join(qobjs) + ')'
+
+ __str__ = getquoted
+
+_RA(tuple, SQL_IN)
+
+
+class LoggingConnection(_connection):
+ """A connection that logs all queries to a file or logger object."""
+
+ def initialize(self, logobj):
+ """Initialize the connection to log to `logobj`.
+
+ The `logobj` parameter can be an open file object or a Logger instance
+ from the standard logging module.
+ """
+ self._logobj = logobj
+ if logging and isinstance(logobj, logging.Logger):
+ self.log = self._logtologger
+ else:
+ self.log = self._logtofile
+
+ def filter(self, msg, curs):
+ """Filter the query before logging it.
+
+ This is the method to overwrite to filter unwanted queries out of the
+ log or to add some extra data to the output. The default implementation
+ just does nothing.
+ """
+ return msg
+
+ def _logtofile(self, msg, curs):
+ msg = self.filter(msg, curs)
+ if msg: self._logobj.write(msg + os.linesep)
+
+ def _logtologger(self, msg, curs):
+ msg = self.filter(msg, curs)
+ if msg: self._logobj.debug(msg)
+
+ def _check(self):
+ if not hasattr(self, '_logobj'):
+ raise self.ProgrammingError(
+ "LoggingConnection object has not been initialize()d")
+
+ def cursor(self):
+ self._check()
+ return _connection.cursor(self, cursor_factory=LoggingCursor)
+
+class LoggingCursor(_cursor):
+ """A cursor that logs queries using its connection logging facilities."""
+
+ def execute(self, query, vars=None, async=0):
+ try:
+ return _cursor.execute(self, query, vars, async)
+ finally:
+ self.connection.log(self.query, self)
+
+ def callproc(self, procname, vars=None):
+ try:
+ return _cursor.callproc(self, procname, vars)
+ finally:
+ self.connection.log(self.query, self)
+
+
+class MinTimeLoggingConnection(LoggingConnection):
+ """A connection that logs queries based on execution time.
+
+ This is just an example of how to sub-class LoggingConnection to provide
+ some extra filtering for the logged queries. Both the `.inizialize()` and
+ `.filter()` methods are overwritten to make sure that only queries
+ executing for more than `mintime` ms are logged.
+
+ Note that this connection uses the specialized cursor MinTimeLoggingCursor.
+ """
+ def initialize(self, logobj, mintime=0):
+ LoggingConnection.initialize(self, logobj)
+ self._mintime = mintime
+
+ def filter(self, msg, curs):
+ t = (time.time() - curs.timestamp) * 1000
+ if t > self._mintime:
+ return msg + os.linesep + " (execution time: %d ms)" % t
+
+ def cursor(self):
+ self._check()
+ return _connection.cursor(self, cursor_factory=MinTimeLoggingCursor)
+
+class MinTimeLoggingCursor(LoggingCursor):
+ """The cursor sub-class companion to MinTimeLoggingConnection."""
+
+ def execute(self, query, vars=None, async=0):
+ self.timestamp = time.time()
+ return LoggingCursor.execute(self, query, vars, async)
+
+ def callproc(self, procname, vars=None):
+ self.timestamp = time.time()
+ return LoggingCursor.execute(self, procname, var)