Ñò
žÅŠKc @ sG d Z d d k Z d d k Z d d k Z y d d k Z Wn
d Z n Xd d k l Z l Z d d k l
Z d d k l
Z d d k l Z d d k l Z d e f d „ ƒ YZ d
e f d „ ƒ YZ d e f d
„ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ d e f d „ ƒ YZ y5 d d k Z d e! f d „ ƒ YZ" d d d „ Z# Wn! e$ j
o Z% d d! „ Z# n Xd" e! f d# „ ƒ YZ& d d d$ „ Z' d% „ Z( d d d& „ Z) e* d' „ e+ ƒ i, ƒ ƒ Z- d S(( s¨ 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.
iÿÿÿÿN( t DATETIMEt DataError( t
extensions( t cursor( t
connection( t adaptt DictCursorBasec B s> e Z d Z d „ Z d „ Z d d „ Z d „ Z d „ Z RS( s% Base class for all dict-like cursors.c O sc | i d ƒ o | d } | d =n
t d ƒ ‚ t i | | | Ž d | _ d | _ | | _ d S( Nt row_factorys; DictCursorBase can't be instantiated without a row factory.i ( t has_keyt NotImplementedErrort _cursort __init__t _query_executedt _prefetchR ( t selft argst kwargsR ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR / s
c C sV | i o t i | ƒ } n | i o | i ƒ n | i p t i | ƒ } n | S( N( R
R
t fetchoneR t _build_index( R t res( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR ; s
c C s\ | i o t i | | ƒ } n | i o | i ƒ n | i p t i | | ƒ } n | S( N( R
R
t fetchmanyR R ( R t sizeR ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR D s
c C sV | i o t i | ƒ } n | i o | i ƒ n | i p t i | ƒ } n | S( N( R
R
t fetchallR R ( R R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR M s
c C sŠ | i o- t i | ƒ } | d j o
t ƒ ‚ q7 n | i o | i ƒ n | i p- t i | ƒ } | d j o
t ƒ ‚ q† n | S( N( R
R
R t Nonet
StopIterationR R ( R R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt nextV s
N( t __name__t
__module__t __doc__R R R R R R ( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR , s t DictConnectionc B s e Z d Z d d „ Z RS( s2 A connection that uses `DictCursor` automatically.c C s; | d j o t i | d t ƒSt i | | d t ƒSd S( Nt cursor_factory( R t _connectionR t
DictCursor( R t name( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR e s
N( R R R R R ( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR c s R c B s; e Z d Z d „ Z d d d „ Z d d „ Z d „ Z RS( s< A cursor that keeps a list of column name -> index mappings.c O s* t | d ª s c C s
t i | ƒ S( N( R1 t __iter__( R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt
itervalues s c C s t | i ƒ ƒ S( N( t dictR4 ( R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt copy° s c C s | i i | ƒ S( N( R. t __contains__( R R3 ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRC ³ s ( s _indexN( R R R t __slots__R R2 R4 R8 R: R R R< R= R> R@ RB RC ( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR" ƒ s t RealDictConnectionc B s e Z d Z d d „ Z RS( s6 A connection that uses `RealDictCursor` automatically.c C s; | d j o t i | d t ƒSt i | | d t ƒSd S( NR ( R R R t RealDictCursor( R R! ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR ¸ s
N( R R R R R ( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRE ¶ s RF c B s; e Z d Z d „ Z d d d „ Z d d „ Z d „ Z RS( sQ A cursor that uses a real dict as the base type for rows.
Note that this cursor is extremely specialized and does not allow
the normal access (using integer indices) to fetched data. If you need
to access database rows both as a dictionary and a list, then use
the generic `DictCursor` instead of `!RealDictCursor`.
c O s* t | d s
N( R R R RU RX R R ( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRa * s
Rg c B s) e Z d Z d d d „ Z d d „ Z RS( s= The cursor sub-class companion to `MinTimeLoggingConnection`.i c C s% t i ƒ | _ t i | | | | ƒ S( N( Rd Re R` R$ ( R R% R& R' ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR$ H s c C s" t i ƒ | _ t i | | | ƒ S( N( Rd Re R` R$ ( R R) R& ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR( L s N( R R R R R$ R( ( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRg E s t UUID_adapterc B s/ e Z d Z d „ Z d „ Z d „ Z e Z RS( sÅ Adapt Python's uuid.UUID__ type to PostgreSQL's uuid__.
.. __: http://docs.python.org/library/uuid.html
.. __: http://www.postgresql.org/docs/8.4/static/datatype-uuid.html
c C s
| | _ d S( N( t _uuid( R t uuid( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR ] s c C s d S( N( ( R t conn( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt prepare` s c C s d t | i ƒ d S( Nt 's '::uuid( t strRi ( R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt getquotedc s ( R R R R Rl Ro t __str__( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRh V s
c C sÈ | p d } d } n0 t | ƒ t j o | \ } } n
| } d } d „ } t i | f d d „ ƒ t _ t i | f d | ƒ t _ t i t i | ƒ t i t i | ƒ t i t i t ƒ t i S( s. Create the UUID type and an uuid.UUID adapter.i† i‡ c S s‡ | d j o d S| d j o g Sg } | d d !i d ƒ D]= } | t | ƒ d j o | d j o t i | ƒ p d q? ~ Sd S( Ns {}i iÿÿÿÿt ,i t NULL( R t splitR, Rj t UUID( t dataR t _[1]R3 ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt parseUUIDARRAYs s
Rt c S s | o t i | ƒ p d S( N( Rj Rt R ( Ru R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt } s s UUID[](
R/ R1 t _extt new_typeRt t UUIDARRAYt
register_typet register_adapterRj Rh ( t oidst conn_or_curst oid1t oid2Rw ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt
register_uuidh s
c C s
t ‚ d S( s® Create the UUID type and an uuid.UUID adapter.
This is a fake function that will always raise an error because the
import of the uuid module failed.
N( t e( t oid( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR‚ ‡ s t Inetc B s; e Z d Z d „ Z d „ Z d „ Z d „ Z d „ Z RS( sC Wrap a string to allow for correct SQL-quoting of inet values.
Note that this adapter does NOT check the passed value to make
sure it really is an inet-compatible address but DOES call adapt()
on it to make sure it is impossible to execute an SQL-injection
by passing an evil value to the initializer.
c C s
| | _ d S( N( t addr( R R† ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR š s c C s d | i i | i f S( Ns %s(%r)( t __class__R R† ( R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt __repr__ s c C s
| | _ d S( N( t _conn( R Rk ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRl s c C sA t | i ƒ } t | d ƒ o | i | i ƒ n | i ƒ d S( NRl s ::inet( t _AR† R] Rl R‰ Ro ( R t obj( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRo £ s c C s
t | i ƒ S( N( Rn R† ( R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRp © s ( R R R R Rˆ Rl Ro Rp ( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyR… ’ s c C s\ | p
d } n t i | f d d „ ƒ t _ t i t i | ƒ t i t d „ ƒ t i S( s) Create the INET type and an Inet adapter.ie t INETc S s | o
t | ƒ p d S( N( R… R ( Ru R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRx ° s c S s | S( ( ( R3 ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRx ² s ( Ry Rz RŒ R| R} R… ( R„ R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt
register_inet¬ s
c C sy y t | | ƒ SWna t f j
oR } | i d j o ‚ n t i d | d ƒ d j o ‚ n t | d | ƒ SXd S( Ns unable to parse times (\+|-)\d\d:\d\d:\d\di÷ÿÿÿiýÿÿÿ( R R t messaget regext matchR ( t sR t exc( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt _convert_tstz_w_secs¸ s c C sI | d j o
d } n t i | d t ƒ t _ t i t i | ƒ t i S( sà Register alternate type caster for :sql:`TIMESTAMP WITH TIME ZONE`.
The Python datetime module cannot handle time zones with
seconds in the UTC offset. There are, however, historical
"time zones" which contain such offsets, eg. "Asia/Calcutta".
In many cases those offsets represent true local time.
If you encounter "unable to parse time" on a perfectly valid
timestamp you likely want to try this type caster. It truncates
the seconds from the time zone data and retries casting
the timestamp. Note that this will generate timestamps
which are **inaccurate** by the number of seconds truncated
(unless the seconds were 00).
:param oids:
which OIDs to use this type caster for,
defaults to :sql:`TIMESTAMP WITH TIME ZONE`
:param conn_or_curs:
a cursor or connection if you want to attach
this type caster to that only, defaults to
``None`` meaning all connections and cursors
i t TSTZ_W_SECSN( i ( R Ry Rz R“ R” R| ( R~ R ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt register_tstz_w_secsÇ s
c C s | i d ƒ S( t _( t
startswith( t k( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyRx ç s (. R RZ Rd t reR RN R t psycopg2R R R Ry t psycopg2.extensionsR R
R R R RŠ R R R R1 R" RE RF RA RG RL R` Ra Rg Rj t objectRh R‚ t ImportErrorRƒ R… R R“ R• RX t localsR8 t __all__( ( ( s5 /usr/lib64/python2.6/site-packages/psycopg2/extras.pyt sD
73 /