[Jc @ s d d k l Z l Z l Z l Z l Z d d k l Z l Z d d k l
Z
l Z d e i f d YZ
d e i f d YZ d e i f d YZ d
e i f d YZ d e i f d
YZ d e i f d YZ d e i f d YZ d e i f d YZ d e i f d YZ d e i f d YZ d e i f d YZ d e i! f d YZ" d e i# f d YZ$ d e i% f d YZ& d e
i' f d! YZ( d/ \ a* a+ d" e
i, f d# YZ- d$ e i. f d% YZ/ d& e i0 f d' YZ1 d( e i2 f d) YZ3 d* e i4 f d+ YZ5 d, e i6 f d- YZ7 e- Z8 e i9 e8 _: e/ e8 _; e1 e8 _< e3 e8 _= e7 e8 _> e5 e8 _? e( e8 _@ d. S(0 i( t sqlt schemat typest exct pool( t compilert
expression( t defaultt baset AcNumericc B s# e Z d Z d Z d Z RS( c C s d S( N( t None( t selft dialect( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt result_processor s c C s
d } | S( Nc S s | d j o | St | Sd S( N( R
t str( t value( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt process s
( ( R R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt bind_processor s c C s d S( Nt NUMERIC( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt get_col_spec s ( t __name__t
__module__R
R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR
s t AcFloatc B s e Z d Z d Z RS( c C s d S( Nt FLOAT( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR s c C s
d } | S( s= By converting to string, we can use Decimal types round-trip.c S s | d j o t | Sd S( N( R
R ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR # s
( ( R R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR ! s ( R R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR s t AcIntegerc B s e Z d Z RS( c C s d S( Nt INTEGER( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR * s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR ) s t
AcTinyIntegerc B s e Z d Z RS( c C s d S( Nt TINYINT( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR . s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR - s t AcSmallIntegerc B s e Z d Z RS( c C s d S( Nt SMALLINT( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR 2 s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR 1 s t
AcDateTimec B s e Z d Z d Z RS( c O s t t | i t d S( N( t superR t __init__t False( R t at kw( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR 6 s c C s d S( Nt DATETIME( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR 9 s ( R R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR 5 s t AcDatec B s e Z d Z d Z RS( c O s t t | i t d S( N( R R% R R! ( R R" R# ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR = s c C s d S( NR$ ( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR @ s ( R R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR% < s t AcTextc B s e Z d Z RS( c C s d S( Nt MEMO( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR D s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR& C s t AcStringc B s e Z d Z RS( c C s d | i o d | i p d S( Nt TEXTs (%d)t ( t length( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR H s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR( G s t AcUnicodec B s# e Z d Z d Z d Z RS( c C s d | i o d | i p d S( NR) s (%d)R* ( R+ ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR L s c C s d S( N( R
( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR O s c C s d S( N( R
( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR
R s ( R R R R R
( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR, K s t AcCharc B s e Z d Z RS( c C s d | i o d | i p d S( NR) s (%d)R* ( R+ ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR V s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR- U s t AcBinaryc B s e Z d Z RS( c C s d S( Nt BINARY( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR Z s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR. Y s t AcBooleanc B s# e Z d Z d Z d Z RS( c C s d S( Nt YESNO( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR ^ s c C s
d } | S( Nc S s$ | d j o d S| o t p t S( N( R
t TrueR! ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR b s
( ( R R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR
a s c C s
d } | S( Nc S sL | t j o d S| t j o d S| d j o d S| o t p t Sd S( Ni i ( R2 R! R
( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR i s
( ( R R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR h s ( R R R R
R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR0 ] s t AcTimeStampc B s e Z d Z RS( c C s d S( Nt TIMESTAMP( ( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR u s ( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR3 t s t AccessExecutionContextc B s e Z d Z d Z RS( c C sy | i ok | i oa t | i t i oG | i o< | i d j p# t | i t i
o | i i o t Squ n t
S( N( t primary_keyt
autoincrementt
isinstancet typeR t Integert foreign_keysR R
R t Sequencet optionalR2 R! ( R t column( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt _has_implicit_sequencey s !&
c C s | i i o | i i i } t | d pR d | _ xF | i D]7 } t | d t p | i
| o | | _ Pq? q? Wn t | i o9 | i i
d | i i } t | d g | _ q n t t | i d S( s= If we inserted into a row with a COUNTER column, fetch the IDt has_sequencet sequences SELECT @@identity AS lastrowidi N( t compiledt isinsertt statementt tablet hasattrR
R@ t ct getattrR! R? t boolt cursort executet fetchonet intt _last_inserted_idsR R5 t post_exec( R t tblR> t row( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyRO s
#
( R R R? RO ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR5 x s t
AccessDialectc B s e Z h
e e i 6e e i 6e e i 6e e i
6e e i 6e
e i 6e e i 6e e i 6e e i 6e e i 6e e i 6e e i 6e e i 6Z d Z e Z e Z! d Z" d Z# d Z$ e% e$ Z$ d Z& d Z' d Z( d Z) d d Z+ d Z, d
Z- RS( t accessc C s t i | | i } | S( N( R t
adapt_typet colspecs( R t typeobjt newobj( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt type_descriptor s c K s, t t | i | t | _ d | _ d S( N( R RR R R! t text_as_varcharR
t _dtbs( R t params( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR s c C s d d k } d d k } t d j og | i i a xX d D]= } y | i i i d | a PWq8 | i j
o q8 Xq8 Wt
i d n d d k } | S( Nis .36s .35s .30s DAO.DBEnginesQ Can't find a DB engine. Check http://support.microsoft.com/kb/239114 for details.( s .36s .35s .30(
t win32com.clientt pythoncomt constR
t clientt constantst gencachet EnsureDispatcht daoEnginet com_errorR t InvalidRequestErrort pyodbc( t clst win32comR] t suffixt module( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt dbapi s
c C s | i } d g } | i d | d | i d d } | o2 | i d | | i d | i d d n d i | g h g S(
Ns( Driver={Microsoft Access Driver (*.mdb)}s Dbq=%st databaset usernames UID=%ss PWD=%st passwordR* t ;( t translate_connect_argst appendt getR
t join( R t urlt optst
connectorst user( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt create_connect_args s !c C s
| i i S( N( t contextt last_inserted_ids( R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyRz s c K s: | h j o
d } n t t | i | | | | d S( N( ( R RR t
do_execute( R RJ RD R[ t kwargs( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR{ s
c C sn y: | h j o
d } n | i | | | i | i _ Wn- t j
o! } t i i | | | n Xd S( N( ( RK t rowcountRy t ExceptionR t
DBAPIErrort instance( R RG RD t
parameterst e( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt _execute s
c C s6 y | i d | t SWn t j
o
} t SXd S( Ns select top 1 * from [%s]( RK R2 R~ R! ( R t
connectiont tablenameR R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt has_table s
c C s t | d p{ h t t i 6t t i 6t t i 6t t i 6t t i 6t
t i 6t t i 6t
t i 6t t i 6t t i 6t t i 6| _ n t i | i i i } z!xG | i D]* } | i i | i i j o Pq q Wt i | i x| i! D]
} | i | i" } | i" t i j o | | i# } n h | i$ p | i% t i& @ d 6} | i' } | i% t i& @o t( i) | i d | d | i1 |
i! d
i } | i2 p t; | _< |
i= | _> qqqqWx | i? D] } | i@ | i j o q%n g }
| i! D] } |
| iA qS~
} g } | i! D] } | d | iB | i f qz~ } | iC t( iD | | d t; q%WWd | iE Xd S(
Nt
ischema_namest nullablet _seqR t Yest 1t 0t server_defaulti i s %s.%st link_to_name(F RF R. R^ t dbByteR t dbIntegert dbLongR t dbSinglet dbDoubleR t dbDatet dbLongBinaryR& t dbMemoR0 t dbBooleanR, t dbTextR t
dbCurrencyR Rc t OpenDatabaset engineRt Rl t TableDefst Namet lowert nameR t NoSuchTableErrort Fieldst Typet Sizet Requiredt
Attributest dbAutoIncrFieldt DefaultValueR R< t
DefaultClauseR t textt
append_columnt Columnt Indexest PrimaryRG R6 t addR8 R9 R t argR! R7 t lenR2 t indext Uniquet uniquet Relationst ForeignTablet ForeignNamet Tablet append_constraintt ForeignKeyConstraintt Close( R R RE t include_columnst dtbsRP t colt coltypet colargsR t idxt thecolt fkt _[1]RG t scolst _[2]t rcols( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt reflecttable s|
#
$
'4'c C sy t i | i i i } g } | i D]< } | i d d j o" | i d d j o | | i q& q& ~ } | i | S( Ni t MSyss ~TMP( Rc R R Rt Rl R R R ( R R R R R t tt names( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt table_names@ s S
N(. R R R, R t UnicodeR R: R t SmallintegerR t NumericR t FloatR t DateTimeR% t DateR( t StringR. t BinaryR0 t BooleanR& t TextR- t CHARR3 R4 RU R R! t supports_sane_rowcountt supports_sane_multi_rowcountRX R Rk t classmethodRx Rz R{ R R
R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyRR s8
St AccessCompilerc B s e Z e i i i Z e i h
d d 6d d 6d d 6d d 6d d 6d
d 6d d
6d d 6d d 6d d 6 d Z d Z d Z d Z
h d d 6d d 6d d 6Z d Z d Z
e d Z e d Z d! Z RS(" t mt montht dt dayt yyyyt yeart st secondt ht hourt yt doyt nt minutet qt quartert wt dowt wwt weekc C sW | i o d p d } | i o | d | i 7} n | i o t i d n | S( s, Access puts TOP, it's version of LIMIT here s DISTINCT R* s TOP %s s, Access does not support LIMIT with an offset( t distinctt limitt offsetR Re ( R t selectR ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt visit_select_precolumnsY s
c C s d S( s+ Limit in access is after the select keywordR* ( ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt limit_clauseb s c C s | i d j o d p | i S( s! Access uses "mod" instead of "%" t %t mod( t operator( R t binary( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt binary_operator_stringf s c C s> t | t i o | i St t | i | | | Sd S( N( R8 R t Functiont labelR R t label_select_column( R R R> t asfrom( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR j s t nowt current_datet current_timestampR R+ c C s4 | i i | i | i | _ t t | i | S( sI Access function names differ from the ANSI SQL names; rewrite common ones( t function_rewritesRr R R R t visit_function( R t func( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR t s c C s d S( s6 FOR UPDATE is not supported by Access; silently ignoreR* ( ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt for_update_clausey s c K s) | o | i i | i | i Sd Sd S( NR* ( t preparert quoteR ( R RE R R| ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt visit_table~ s c K sU | i | i d t | i o d p d | i | i d t d | i | i S( NR s LEFT OUTER JOIN s INNER JOIN s ON ( R t leftR2 t isoutert rightt onclause( R Rs R R| ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt
visit_join s c C s5 | i i | i | i } d | | i | i f S( Ns DATEPART("%s", %s)( t extract_mapRr t fieldR t expr( R t extractR ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt
visit_extract s ( R R R t DefaultCompilerR
t copyt updateR R R R R R R R! R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR J s0
t AccessSchemaGeneratorc B s e Z d Z RS( c K sO | i i | d | i i | i i } t | i d t o | i o | i
ou t | i t i
o_ | i oT | i d j p# t | i t i o* | i i o t i | i d | _ q n | i p | d 7} n t | d o& | | i _ | i i | d } n/ | i | } | d j o | d | 7} n | S( Nt R@ R s NOT NULLRA s counters DEFAULT ( R t
format_columnR9 t dialect_implR R RH RE R! R6 R7 R8 R R: R; R R
R R< R= R RA R RF R@ t get_column_default_string( R R> R| t colspecR ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt get_column_specification s /!+3!
( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR s t AccessSchemaDropperc B s e Z d Z RS( c C s: | i d | i i | i | i t f | i d S( Ns
DROP INDEX [%s].[%s]( Rq RE R t _validate_identifierR! RK ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt visit_index s ,( R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR s t AccessDefaultRunnerc B s e Z RS( ( R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR s t AccessIdentifierPreparerc B s3 e Z e i i Z e i d d g d Z RS( R R c C s& t t | i | d d d d d S( Nt
initial_quotet [t final_quotet ]( R R R ( R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR s ( R R R t RESERVED_WORDSR t reserved_wordsR R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyR s N( NN(A t
sqlalchemyR R R R R t sqlalchemy.sqlR R t sqlalchemy.engineR R R R R R R: R R R R R R R R% R R& R R( R R, R R- R R. R R0 R4 R3 t DefaultExecutionContextR5 R
R^ Rc t DefaultDialectRR R R t SchemaGeneratorR t
SchemaDropperR t
DefaultRunnerR t IdentifierPreparerR R t SingletonThreadPoolt poolclasst statement_compilert schemageneratort
schemadropperR t
defaultrunnert execution_ctx_cls( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/access.pyt s@ (
! C