1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
"""Wrapper around psycopg1/2.
Preferred is psycopg2, fallback to psycopg1.
Interface provided is psycopg1:
- dict* methods.
- new columns can be assigned to row.
"""
__all__ = []
try:
##from psycopg2.psycopg1 import connect as _pgconnect
# psycopg2.psycopg1.cursor is too backwards compatible,
# to the point of avoiding optimized access.
# only backwards compat thing we need is dict* methods
import psycopg2.extensions, psycopg2.extras
from psycopg2.extensions import QuotedString
class _CompatRow(psycopg2.extras.DictRow):
"""Allow setting fields by name."""
def __setitem__(self, k, v):
if type(k) != int:
if k not in self._index:
self._index[k] = len(self._index)
k = self._index[k]
while k >= len(self):
self.append(None)
return list.__setitem__(self, k, v)
def copy(self):
"Return regular dict"
return dict(self.items())
class _CompatCursor(psycopg2.extras.DictCursor):
"""Regular psycopg2 DictCursor with dict* methods."""
def __init__(self, *args, **kwargs):
psycopg2.extras.DictCursor.__init__(self, *args, **kwargs)
self.row_factory = _CompatRow
dictfetchone = psycopg2.extras.DictCursor.fetchone
dictfetchall = psycopg2.extras.DictCursor.fetchall
dictfetchmany = psycopg2.extras.DictCursor.fetchmany
class _CompatConnection(psycopg2.extensions.connection):
"""Connection object that uses _CompatCursor."""
def cursor(self):
return psycopg2.extensions.connection.cursor(self, cursor_factory = _CompatCursor)
def _pgconnect(cstr):
"""Create a psycopg2 connection."""
return _CompatConnection(cstr)
except ImportError:
# use psycopg 1
from psycopg import connect as _pgconnect
from psycopg import QuotedString
def connect_database(connstr):
"""Create a db connection with connect_timeout option.
Default connect_timeout is 15, to change put it directly into dsn.
"""
# allow override
if connstr.find("connect_timeout") < 0:
connstr += " connect_timeout=15"
# create connection
return _pgconnect(connstr)
|
