[Jc @ sV d Z d d k Z d d k Z d d k Z d d k l Z l Z l Z l Z d d k l
Z l Z
d d k l Z l Z d d k l Z l Z d d k l Z d d d
d d d
d d d d d d d g
Z d e i 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 i f d YZ d
e 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- 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 i0 6e% e i1 6e- e i2 6e e i3 6Z4 h e+ d$ 6e d% 6e d& 6e' d' 6e! d( 6e# d) 6e d* 6e d+ 6e- d, 6e d- 6e d. 6e d. 6e d/ 6e) d0 6e% d1 6e d2 6Z5 d3 e i6 f d4 YZ7 d5 e i8 f d6 YZ9 d7 e i: f d8 YZ; d9 e i< f d: YZ= d; e i> f d< YZ? d= e i@ f d> YZA d? e iB f d@ YZC dA e iD f dB YZE dC e iF f dD YZG dE ZH e= ZI eC eI _J e? eI _K eE eI _L eG eI _M eA eI _N e7 eI _O d S(F s Support for the MaxDB database.
TODO: More module docs! MaxDB support is currently experimental.
Overview
--------
The ``maxdb`` dialect is **experimental** and has only been tested on 7.6.03.007
and 7.6.00.037. Of these, **only 7.6.03.007 will work** with SQLAlchemy's ORM.
The earlier version has severe ``LEFT JOIN`` limitations and will return
incorrect results from even very simple ORM queries.
Only the native Python DB-API is currently supported. ODBC driver support
is a future enhancement.
Connecting
----------
The username is case-sensitive. If you usually connect to the
database with sqlcli and other tools in lower case, you likely need to
use upper case for DB-API.
Implementation Notes
--------------------
Also check the DatabaseNotes page on the wiki for detailed information.
With the 7.6.00.37 driver and Python 2.5, it seems that all DB-API
generated exceptions are broken and can cause Python to crash.
For 'somecol.in_([])' to work, the IN operator's generation must be changed
to cast 'NULL' to a numeric, i.e. NUM(NULL). The DB-API doesn't accept a
bind parameter there, so that particular generation must inline the NULL value,
which depends on [ticket:807].
The DB-API is very picky about where bind params may be used in queries.
Bind params for some functions (e.g. MOD) need type information supplied.
The dialect does not yet do this automatically.
Max will occasionally throw up 'bad sql, compile again' exceptions for
perfectly valid SQL. The dialect does not currently handle these, more
research is needed.
MaxDB 7.5 and Sap DB <= 7.4 reportedly do not support schemas. A very
slightly different version of this dialect would be required to support
those versions, and can easily be added if there is demand. Some other
required components such as an Max-aware 'old oracle style' join compiler
(thetas with (+) outer indicators) are already done and available for
integration- email the devel list if you're interested in working on
this.
iN( t exct schemat sqlt util( t operatorst
expression( t compilert visitors( t baset default( t typest MaxStringt
MaxUnicodet MaxChart MaxTextt
MaxIntegert MaxSmallIntegert
MaxNumerict MaxFloatt MaxTimestampt MaxDatet MaxTimet
MaxBooleant MaxBlobt _StringTypec B s8 e Z d Z d d d Z d Z d Z d Z RS( c K s) t t | i d | | | | _ d S( Nt length( t superR t __init__t encoding( t selfR R t kw( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR N s c C sf | i d j o
d } n d | i | i f } | i d j o" d i | | i i g } n | S( Nt LONGs %s(%s)t ( R t Nonet _typeR t joint upper( R t spec( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt get_col_specR s
"c s, | i d j o d S f d } | Sd S( Nt unicodec s) t | t o | i i S| Sd S( N( t
isinstanceR' t encodeR ( t value( t dialect( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt process` s ( R R! ( R R+ R, ( ( R+ s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt bind_processor\ s c s f d } | S( Nc s x t o | d j o d St | t o | St | t o- i p
i o | i i S| Sq t | d o | i | i
} q q | Sq Wd S( Nt read( t TrueR! R( R' t strt convert_unicodet decodeR t hasattrR. t remainingLength( R* ( R+ R ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, h s
( ( R R+ R, ( ( R+ R s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt result_processorg s N( t __name__t
__module__R! R" R R& R- R5 ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR K s
c B s e Z d Z d Z RS( t VARCHARc O s t t | i | | d S( N( R R R ( R t aR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s ( R6 R7 R" R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR } s c B s e Z d Z d d Z RS( R8 c K s# t t | i d | d d d S( NR R R' ( R R R ( R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s N( R6 R7 R" R! R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s e Z d Z RS( t CHAR( R6 R7 R" ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR
s c B s e Z d Z d Z d Z RS( R c O s t t | i | | d S( N( R R R ( R R9 R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c C sY d } | i d j o d i | | i f } n$ | i o d i | d f } n | S( NR R t UNICODE( R R! R# R1 ( R R% ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& s
( R6 R7 R" R R& ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s e Z d Z RS( c C s d S( Nt INTEGER( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& s ( R6 R7 R& ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s e Z d Z RS( c C s d S( Nt SMALLINT( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& s ( R6 R7 R& ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s/ e Z d Z d d d Z d Z d Z RS( s, The FIXED (also NUMERIC, DECIMAL) data type.c K s6 | i d t t t | i d | d | | d S( Nt asdecimalt scalet precision( t
setdefaultR/ R R R ( R R@ R? R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c C s d S( N( R! ( R R+ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR- s c C sG | i o | i o d | i | i f S| i o d | i Sd Sd S( Ns
FIXED(%s, %s)s FIXED(%s)R< ( R? R@ ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& s
N( R6 R7 t __doc__R! R R- R& ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s e Z d Z d Z RS( s The FLOAT data type.c C s' | i d j o d Sd | i f Sd S( Nt FLOATs FLOAT(%s)( R@ R! ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& s ( R6 R7 RB R& ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s# e Z d Z d Z d Z RS( c C s d S( Nt TIMESTAMP( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& s c s f d } | S( Nc s | d j o d St | t o | S i d j o( t | d d } | i d d | S i d j o( t | d d } | i d d | St i d i f d S( Nt internalt microsecondi s %Y%m%d%H%M%Ss %06ut isos %Y-%m-%d %H:%M:%S.s% datetimeformat '%s' is not supported.( R! R( t
basestringt datetimeformatt getattrt strftimeR t InvalidRequestError( R* t ms( R+ ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, s
( ( R R+ R, ( ( R+ s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR- s c s f d } | S( Nc s3 | d j o d S i d j or t i g } | d d !| d d !| d d !| d d !| d d !| d d !| d f D] } | t | qv ~ S i d j or t i g } | d d !| d
d !| d d !| d d
!| d d !| d d !| d f D] } | t | q ~ St i d i f d S( NRE i i i i i
i i RG i i i i
i i i i s% datetimeformat '%s' is not supported.( R! RI t datetimet intR RL ( R* t _[1]t vt _[2]( R+ ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, s"
) )( ( R R+ R, ( ( R+ s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR5 s ( R6 R7 R& R- R5 ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s# e Z d Z d Z d Z RS( c C s d S( Nt DATE( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& s c s f d } | S( Nc s | d j o d St | t o | S i d j o | i d S i d j o | i d St i d i f d S( NRE s %Y%m%dRG s %Y-%m-%ds% datetimeformat '%s' is not supported.( R! R( RH RI RK R RL ( R* ( R+ ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, s
( ( R R+ R, ( ( R+ s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR- s
c s f d } | S( Nc s | d j o d S i d j oM t i g } | d d !| d d !| d d !f D] } | t | qQ ~ S i d j oM t i g } | d d !| d d !| d d !f D] } | t | q ~ St i d
i f d S( NRE i i i i RG i i i
s% datetimeformat '%s' is not supported.( R! RI RN t dateRO R RL ( R* RP RQ RR ( R+ ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, s
GG( ( R R+ R, ( ( R+ s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR5 s
( R6 R7 R& R- R5 ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s# e Z d Z d Z d Z RS( c C s d S( Nt TIME( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& s c s f d } | S( Nc s | d j o d St | t o | S i d j o | i d S i d j o | i d St i d i f d S( NRE s %H%M%SRG s %H-%M-%Ss% datetimeformat '%s' is not supported.( R! R( RH RI RK R RL ( R* ( R+ ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, s
( ( R R+ R, ( ( R+ s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR- s
c s f d } | S( Nc s | d j o d S i d j oS t i g } | d d !| d d !| d d !f D] } | t | qQ ~ } | S i d j oM t i g } | d d !| d d !| d d !f D] } | t | q ~ St i d
i f d S( NRE i i i i RG i i i
s% datetimeformat '%s' is not supported.( R! RI RN t timeRO R RL ( R* RP RQ t tRR ( R+ ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, . s
HG( ( R R+ R, ( ( R+ s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR5 - s ( R6 R7 R& R- R5 ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c B s e Z d Z RS( c C s d S( Nt BOOLEAN( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& @ s ( R6 R7 R& ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR ? s c B s# e Z d Z d Z d Z RS( c C s d S( Ns LONG BYTE( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR& E s c C s
d } | S( Nc S s | d j o d St | Sd S( N( R! R0 ( R* ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, I s
( ( R R+ R, ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR- H s c C s
d } | S( Nc S s) | d j o d S| i | i Sd S( N( R! R. R4 ( R* ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR, Q s
( ( R R+ R, ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR5 P s ( R6 R7 R& R- R5 ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR D s t booleant chart characterRT t fixedt floatRO t integers long binarys long unicodet longt smallintRV t timestampt varchart MaxDBExecutionContextc B s e Z d Z d Z RS( c C s| | i i oX| i oM| i i i } t | \ } } | o!| i i p | i p | i | d j o | i o d | i i
i | } n d | i i
i | } | i i
i o | i i
i i | n | i i | } | i d } | i i
i o | i i
i i | g n | i p d g t | i i | _ n | | i | /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR{ s*
c C sW | i i d j o7 x4 | i i D]" } | d d j o t | Sq Wn t i | S( Ni s Long Binaryt Longs Long Unicode( s Long BinaryR s Long Unicode( Rs t descriptionR! t MaxDBResultProxyt engine_baset ResultProxy( R t column( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt get_result_proxy s
( R6 R7 R{ R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyRc s !t MaxDBCachedColumnRowc B sM e Z d Z d Z d Z d Z d Z d Z d Z d Z RS( s< A RowProxy that only runs result_processors once per column.c C s8 t t | i | | h | _ | | _ | | _ d S( N( R R R Rz t _rowt _parent( R t parentt row( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c C s> | | i j o# | i i | i | | i | /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s #c c s2 x+ t t | i D] } | i | Vq Wd S( N( t xrangeRx R R ( R t i( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt __iter__ s c C s t t | S( N( t reprt list( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt __repr__ s c C sP | | j pC | t g } t t | i D] } | | i | q- ~ j S( N( t tupleR Rx R R ( R t otherRP R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt __eq__ s
c C sn t | t oM | i t | i } t g } t | D] } | | i | q< ~ S| i | Sd S( N( R( t slicet indicesRx R R R R ( R R R RP R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt __getitem__ s 5c C s7 y | i | SWn t j
o t | n Xd S( N( R t KeyErrort AttributeError( R t name( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt __getattr__ s (
R6 R7 RB R R R R R R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s R c B s e Z e Z RS( ( R6 R7 R t _process_row( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s t MaxDBDialectc B s e Z d Z e Z e Z d Z e Z e Z e Z
d Z e d Z d Z
e e
Z
d Z d Z d d Z d Z d Z d d
Z d Z d Z d
Z RS( t maxdbi RE c K s t t | i | | | _ | i d j o
h | _ nm h t d 6t d 6t d 6t d 6t
d 6t d 6t t i 6t
t i
6t t i 6| _ d S( Ns Long Binarys Long byte_ts Long Unicodet Timestampt Datet Time( R R R t _raise_knownt dbapiR! t dbapi_type_mapR R R R R RN RT RV ( R t _raise_known_sql_errorsR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s
c C s d d k l } | S( Ni( R ( t sapdbR ( t clst _dbapi( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c C s, | i d d } | i | i g | f S( Nt usernamet user( t translate_connect_argst updatet query( R t urlt opts( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt create_connect_args s c C sR t | t o
| } n t | t i o | i t St i | t Sd S( N( R( t typet sqltypest Unicodet adaptR t
adapt_typet colspecs( R t typeobj( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt type_descriptor s
c C s@ | i | | } t | t o | d j o
| | _ n d S( N( Rt R( RO R! t _rowcount( R Rs Rg t
parameterst contextt res( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt
do_execute s c C s d S( N( ( R Rn R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt do_release_savepoint
s c C sP y | i SWn> t j
o2 | i i | i d i } | | _ | SXd S( Ns SELECT CURRENT_SCHEMA FROM DUAL( t _default_schema_nameR t identifier_preparert _normalize_nameRt t scalar( R Rn R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt get_default_schema_name s c C s} | i i } | | g } | d j o
d } n d } | i | | | i | | } t | i } | i | S( Ns\ SELECT tablename FROM TABLES WHERE TABLES.TABLENAME=? AND TABLES.SCHEMANAME=CURRENT_SCHEMA sQ SELECT tablename FROM TABLES WHERE TABLES.TABLENAME = ? AND TABLES.SCHEMANAME=? ( R t _denormalize_nameR! t appendRt t boolRu t close( R Rn t
table_nameR t denormalizet bindR t rpt found( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt has_table s
c C s | d j o d } | i | } n+ d } | i i | } | i | | } | i i } g } | D] } | | | d qg ~ S( Ns? SELECT TABLENAME FROM TABLES WHERE SCHEMANAME=CURRENT_SCHEMA s2 SELECT TABLENAME FROM TABLES WHERE SCHEMANAME=? i ( R! Rt R R R ( R Rn R R R~ t matchnamet normalizeRP R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt table_names. s
c * C s | i i } | i i } d } d } | | i g } | i p | d } | d } n+ | d } | d } | i | | i | i | | i } | p t i | i
n t | p g } xu| D]m}
|
\ } } }
} } } } } } | | } | o | | j o q n g h } } |
d j oM | | f } | d j o0 | d j o# | i
d o d }
| f } qnZ |
d j o
| f } n@ |
d% j o | f } | | d | d j o0 t i t i d | i d d | d /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt s t .t
REFSCHEMANAMEt REFTABLENAMEt
REFCOLUMNNAMER s DELETE i t ondeleteR t autoloadt
autoload_witht link_to_name( s CHARs VARCHAR( s
REFSCHEMANAMEs REFTABLENAMER ( s REFTABLENAMER (. R R R R R R Rt t fetchallR t NoSuchTableErrort fullnamet setR! t
startswitht
ischema_namest lowerR R t warnR t NullTypet FalseR/ t
DefaultClauseR t textt replacet
append_columnt Columnt itertoolst groupbyR t
COLUMNNAMEt _maybe_quote_identifiert in_schemaR# t RULER t _get_table_keyR t gett metadatat tablest Tablet ForeignKeyConstraintt append_constraint(* R Rn Rh t include_columnsR R t stt fkt paramst rowsR R t modet col_typeR R R? R t constant_deft func_deft type_argst type_kwt type_clst
type_instancet col_kwt fk_setst fkeynamet fkeyRP t rt key_colsRz t referantst quoteRR t ct _[3]t
constraint_kwt rulet table_kwt ref_keyt
constraint( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt reflecttable; s
!
$ *
2 2
c C sJ | i i } d } | i | | | } t | i } | i | S( Ns: SELECT sequence_name FROM SEQUENCES WHERE SEQUENCE_NAME=? ( R R Rt R Ru R ( R Rn R R R R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt has_sequence s
N( R6 R7 R R/ t supports_altert supports_unicode_statementst max_identifier_lengtht supports_sane_rowcountR t supports_sane_multi_rowcountt preexecute_pk_sequencesRI R R t classmethodR R R! R R R R R R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s(
t
MaxDBCompilerc B s e Z e i i i Z d e e i /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s RS t CURRENT_DATERU t CURRENT_TIMERD t CURRENT_TIMESTAMPR t FALSEt SYSDBAt TIMEZONEt TRANSACTIONt TRUEt USERt UIDt USERGROUPt UTCDATEt UTCDIFFc C s d S( Ns
FROM DUAL( ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt default_from s c C s | i } | t j o d S| d j o d S| d j o d S| d j o d S| d j o d St | t o d | i S| p d Sd Sd S(
Ns WITH LOCK EXCLUSIVEt R. s
WITH LOCKt ignores WITH LOCK (IGNORE) EXCLUSIVEt nowaits WITH LOCK (NOWAIT) EXCLUSIVEs
WITH LOCK %s( t
for_updateR/ R! R( RH R$ ( R t selectt clause( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt for_update_clause s
c C s5 | i i | i j o t | i d j St Sd S( Ni ( R R$ t bare_functionsRx t clausesR/ ( R t func( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt apply_function_parens s c K sW | i i | i i d } | o | i } | | _ n t t | i | | S( N( t function_conversionR R R$ R! t _cloneR R( t visit_function( R t fnR t transform( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyRF s
c K ss t | i t i t i f o d | i | i St | i t i o d | i | i S| i | i Sd S( Ns NUM(%s)s CHR(%s)( R( R R t Integert NumericR, R> t String( R t castt kwargs( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt
visit_cast s
c C s* | i o d S| i i i | d Sd S( Ns .NEXTVAL( t optionalR! R+ R t format_sequence( R t sequence( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt visit_sequence s
t
ColumnSnaggerc B s e Z d Z d Z RS( c C s d | _ d | _ d S( Ni ( t countR! R ( R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s c C s | | _ | i d 7_ d S( Ni ( R RT ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt visit_column s ( R6 R7 R RU ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyRS s c C s h } x | D] } t | t o q
n | i } | i | | i d j oR t | t i o | i | t | i /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt _find_labeled_columns s
"c C s | i | i } | o t | d t ot | i | i | i } | oQ xN | i D]< } t i d t i
| } | i d | | | } qX Wq n | o; | i o% | i
o t i d q d Sn d | Sd Sd S( Nt _distincts (^| )(%s)(,| |$)s \1%s\3s- MaxDB does not support ORDER BY in subqueriesR9 s
ORDER BY ( R, t _order_by_clauseRJ R R] t
inner_columnsRZ t keyst ret compilet escapet subt is_subqueryt _limitR RL ( R R= t order_byR[ t needs_aliasR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt order_by_clause, s&
c C sd | i o d p d } | i o< | i o2 | i o t i d n | d | i 7} n | S( Ns DISTINCT R9 s, MaxDB does not support LIMIT with an offset.s TOP %s ( R^ Rf Rg t _offsetR RL ( R R= R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt get_select_precolumnsJ s
c C sA | i o d S| i o t i d n d | i f Sd S( NR9 s, MaxDB does not support LIMIT with an offset.s
LIMIT %s( Rf Rk R RL Rg ( R R= ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt limit_clauseT s
c C s t | _ t | _ | i | } x? | i p h i D]' } t | t i o t | _ Pq8 q8 Wd i
d | i i | i
d d i
g } | D] } | | i i | d q ~ d d i
g } | D] } | | d q ~ d f S( NR9 s INSERT INTO s (s , i s
) VALUES (i t )( R/ Re Rj t _get_colparamsR t
itervaluesR( RW t FunctionR R# Rl Rm Rh t
format_column( R t insertt colparamsR* RP R RR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt visit_insert` s
*+( R6 R7 R t DefaultCompilerR t copyt
sql_operatorst modRD R R@ R8 R? RC RF RN RR R t
ClauseVisitorRS R R] Rj Rl Rm Ru ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR( s,
t MaxDBDefaultRunnerc B s e Z d Z RS( c C s/ | i o d S| i d | i i i | S( Ns SELECT %s.NEXTVAL FROM DUAL( RO R! t execute_stringR+ R RP ( R t seq( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyRR u s
( R6 R7 RR ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR{ t s t MaxDBIdentifierPreparerc B s e Z e d d d d d d d d d d d
d d d
d d d d d d d d d d d d d d d d d d d d! d" d# d$ d% d& d' d( d) d* d+ d, d- d. d/ d0 d1 d2 d3 d4 d5 d6 d7 d8 d9 d: d; d< d= d> d? d@ dA dB dC dD dE dF dG dH dI dJ dK dL dM dN dO dP dQ dR dS dT dU dV dW dX dY dZ d[ d\ d] d^ d_ d` da db dc dd de df dg dh di dj dk dl dm dn do dp dq dr ds dt du dv dw dx dy dz d{ d| d} d~ d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d g Z d Z d Z d Z RS( t abst absolutet acost adddatet addtimet allt alphat altert anyt asciit asint atant atan2t avgt binaryt bitRY t bytet caset ceilt ceilingRZ R[ t checkt chrR t concatR t cost cosht cotRT t crosst curdatet currentt curtimet databaseRT t datedifft dayt daynamet
dayofmontht dayofweekt dayofyeart dect decimalR2 R t degreest deletet digitst distinctt doublet exceptt existst expt expandt firstR\ R] t floort fort fromt fullt get_objectnamet
get_schemat graphict greatestt groupt havingt hext hextorawt hourt ifnullR: R| t initcapt innerRs RO R^ RE t intersectt intoR# R t lastt lcaset leastt leftR t lfillR t lnt locatet logt log10R_ t longfileR t lpadt ltrimt makedatet maketimet mapchart maxt mbcsRF t mint minuteRy t montht monthnamet naturalt nchart nextt not noroundt nott nowt nullt numt numerict objectt oft ont ordert packedt pit powert prevt primaryt radianst realt rejectt relativeR t rfillt rightt roundt rowidt rownot rpadt rtrimt secondR= t selupdt serialR t showt signt sint sinhR` t somet soundext spacet sqrtt stampt
statisticst stddevt subdatet substrt substringt subtimet sumt sysdbaRh t tant tanhRV t timediffRa t timezonet tot toidentifiert transactiont translatet trimt trunct truncatet ucaset uidR' t unionR R$ R t usergroupt usingt utcdatet utcdiffR* t valuesRb t
vargraphict variancet weekt
weekofyeart whent wheret witht yeart zonedc C sH | d j o d S| i o% | i } | i | p | Sn | S( N( R! t isupperR t _requires_quotes( R R t lc_name( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s
c C sC | d j o d S| i o | i | o | i S| Sd S( N( R! t islowerR& R$ ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s
c C s& | i | o | i | S| Sd S( N( R& t quote_identifier( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR s ( R6 R7 R t reserved_wordsR R R ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR~ | sD t MaxDBSchemaGeneratorc B s# e Z d Z d Z d Z RS( c K s | i i | | i i | i i g } | i p | i d n | i } | i | } | o" t
| t i o | i
o n | d j o | i d | n | i o | i o y g } | i i i D]\ } | i oL t
| i t i p t
| i t o | i i o | i o | | q q ~ i d } | | j o | i d n Wq}t j
o q}Xn d i | S( Ns NOT NULLs
DEFAULT %si s DEFAULT SERIALR ( Rl Rr R t dialect_implR+ R& R R R t get_column_default_stringR( R t SequenceRO R! Ry R Rh Rz R RI R R@ t foreign_keyst popt
IndexErrorR# ( R R R t colspecR t default_strRP R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt get_column_specification s0
(
c C s t | i t i oo t | i i t o9 t | i t i o t
| i i Sd | i i Sq t | i | i i d Sn d Sd S( Ns '%s'( R( R R R R t argRH R R RI R0 R' t _compileR! ( R R ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR- s c C sV | i oG| i p | i i | i | i o d | i i | g } d | _ | i d j o | i
d t | i f n | i d j o | i
d t | i f n t
g } | i i D]= } | d i d o# | | d d i | d f q q ~ } d | j o! | i
d t | d f n% | i d
t o | i d n d | j o! | i
d
t | d f n% | i d t o | i d n | i d t o | i d n d | j o! | i
d t | d f n% | i d t o | i d n | i d i | | i n d S( s Creates a SEQUENCE.
TODO: move to module doc?
start
With an integer value, set the START WITH option.
increment
An integer value to increment by. Default is the database default.
maxdb_minvalue
maxdb_maxvalue
With an integer value, sets the corresponding sequence option.
maxdb_no_minvalue
maxdb_no_maxvalue
Defaults to False. If true, sets the corresponding sequence option.
maxdb_cycle
Defaults to False. If true, sets the CYCLE option.
maxdb_cache
With an integer value, sets the CACHE option.
maxdb_no_cache
Defaults to False. If true, sets NOCACHE.
s CREATE SEQUENCEi s INCREMENT BYs
START WITHi t maxdb_i t maxvaluet MAXVALUEt no_maxvaluet
NOMAXVALUEt minvaluet MINVALUEt no_minvaluet
NOMINVALUEt cyclet CYCLEt cachet CACHEt no_cachet NOCACHER N( RO t
checkfirstR+ R Rn R Rl RP t incrementR! t extendR0 t startt dictRM t itemsR R R R R R# Rt ( R RQ t ddlRP t pairR ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyRR s:
C
!
!
!( R6 R7 R4 R- RR ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyR+ s $ t MaxDBSchemaDropperc B s e Z d Z RS( c C sa | i oR | i p | i i | i | i o+ | i d | i i | | i n d S( Ns DROP SEQUENCE %s(
RO RF R+ R Rn R R Rl RP Rt ( R RQ ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyRR - s ( R6 R7 RR ( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyRN , s c C s x t | i i D] \ } } t | i t i t i f or | i oh t | i t
i o | i i o | | f Sq | i d j p t | i t
i o | | f Sq q Wd S( s= Finds the effective DEFAULT SERIAL column of a Table, if any.N( NN( t enumerateRy Rz R( R R RI RJ R R R R. RO R! R R ( Rh R| t col( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyRi 6 s
(P RB RN R Rb t
sqlalchemyR R R R t sqlalchemy.sqlR Rx R RW R R t sqlalchemy.engineR R R R
R t __all__RK R R R R
R RI R R RJ R t FloatR t DateTimeR R R R R t BooleanR t BinaryR t Smallintegert TextR: RD t BLOBR R R t DefaultExecutionContextRc t RowProxyR R R t DefaultDialectR Rv R( t
DefaultRunnerR{ t IdentifierPreparerR~ t SchemaGeneratorR+ t
SchemaDropperRN Ri R+ Rl t statement_compilert schemageneratort
schemadroppert
defaultrunnert execution_ctx_cls( ( ( s> /usr/lib/python2.6/site-packages/sqlalchemy/databases/maxdb.pyt : s $" 2
-%&
*':v