[Jc @ su d 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 d d k l Z d d k l Z l Z l Z d d k l Z l Z l Z l Z l Z d
d d d
d d d d d d d d d d d d d d d d d g Z e 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 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 e Z e d e e d e d e e de e de d e de d e de Z e de e de d e e d e d e d
e e d e d e Z e d e e d
e d e e d e e e i! i" e de d e de d e de d e de e de e e i! i# e de e dN e e de Z$ e de e de e e i! i" d e e de d e e de e e i! i" Z% e de e de e e$ i! i" d e e de e e% i! i& d e e de e e$ i! i' d e e de Z( d e i) f d YZ* d e i+ f d YZ, d e i- e, f d YZ. d e i f d! YZ/ d
e/ f d" YZ0 d e/ f d# YZ1 d e/ f d$ YZ2 d e i3 f d% YZ4 d e i3 f d& YZ5 d e i6 f d' YZ7 d e i6 f d( YZ8 d e i9 f d) YZ: d e i9 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. YZA d e iB f d/ YZC d e iD f d0 YZE d e i) f d1 YZF d eF f d2 YZG d e i) f d3 YZH d4e iI f d5 YZJ d6eJ f d7 YZK d8eJ f d9 YZL d:e iM f d; YZN d<eN f d= YZO d>eN f d? YZP h eO d@6ZQ dAe iR f dB YZS dCe iT f dD YZU dEe iV f dF YZW dGe
iX f dH YZY dIe iZ f dJ YZ[ eN Z\ eS e\ _] eU e\ _^ eW e\ __ e[ e\ _` eY e\ _a d S(K s
Sybase database backend.
Known issues / TODO:
* Uses the mx.ODBC driver from egenix (version 2.1.0)
* The current version of sqlalchemy.databases.sybase only supports
mx.ODBC.Windows (other platforms such as mx.ODBC.unixODBC still need
some development)
* Support for pyodbc has been built in but is not yet complete (needs
further development)
* Results of running tests/alltests.py:
Ran 934 tests in 287.032s
FAILED (failures=3, errors=1)
* Tested on 'Adaptive Server Anywhere 9' (version 9.0.1.1751)
iN( t utilt sqlt schemat exc( t compilert
expression( t defaultt base( t types( t operators( t MetaDatat Tablet Column( t Stringt Integert SMALLINTt CHARt
ForeignKeyt SybaseTypeErrorSybaseNumerict SybaseFloatt
SybaseIntegert SybaseBigIntegert SybaseTinyIntegert SybaseSmallIntegert SybaseDateTime_mxodbct SybaseDateTime_pyodbct SybaseDate_mxodbct SybaseDate_pyodbct SybaseTime_mxodbct SybaseTime_pyodbct
SybaseTextt SybaseStringt
SybaseChart SybaseBinaryt
SybaseBooleant SybaseTimeStampt SybaseMoneyt SybaseSmallMoneyt SybaseUniqueIdentifiert addt allt altert andt anyt ast asct backupt begint betweent bigintt binaryt bitt bottomt breakt byt callt
capabilityt cascadet caset castt chart char_convertt charactert checkt
checkpointt closet commentt committ connectt
constraintt containst continuet convertt createt crosst cubet currentt current_timestampt current_usert cursort datet dbspacet
deallocatet dect decimalt declareR t deletet deletingt desct distinctt dot doublet dropt dynamict elset elseift encryptedt endt endift escapet exceptt exceptiont exect executet existingt existst externlogint fetcht firstt floatt fort forcet foreignt forwardt fromt fullt gotot grantt groupt havingt holdlockt
identifiedt ift int indext index_lparent innert inoutt insensitivet insertt insertingt installt insteadt intt integert
integratedt intersectt intot iqt ist isolationt joint keyt lateralt leftt liket lockt logint longt matcht
membershipt messaget modet modifyt naturalt newt not
noholdlockt nott notifyt nullt numerict oft offt ont opent optiont optionst ort ordert otherst outt outert overt passthrought precisiont preparet primaryt printt
privilegest proct proceduret publicationt raiserrort readtextt realt referencet
referencest releaset remotet removet renamet
reorganizet resourcet restoret restrictt returnt revoket rightt rollbackt rollupt savet savepointt scrollt selectt sensitivet sessiont sett setusert sharet smallintt somet sqlcodet sqlstatet startt stopt subtranst subtransactiont synchronizet syntax_errort tablet temporaryt thent timet timestampt tinyintt tot topt trant triggert truncatet tsequalt unboundedt uniont uniquet unknownt unsignedt updatet updatingt usert usingt validatet valuest varbinaryt varchart variablet varyingt viewt waitt waitfort whent wheret whilet windowt witht with_cubet with_lparent with_rollupt withint workt writetextt SYSTABLEt table_idt primary_keyt file_idt
table_namei t
table_typei
t creatort SYSDOMAINt domain_idt domain_namet type_idt quotet SYSCOLUMNt column_idt pkeyi t column_namet nullst widtht max_identityt scalet
SYSFOREIGNKEYt foreign_table_idt foreign_key_idt primary_table_idt SYSFKCOLt foreign_column_idt primary_column_idt SybaseTypeErrorc 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/sybase.pyt result_processor s c C s
d } | S( Nc S s t i d | g d S( Ns Data type not supported( R t InvalidRequestError( t value( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt process s ( ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt bind_processor s c C s t i d d S( Ns Data type not supported( R t CompileError( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt get_col_spec s ( t __name__t
__module__R$ R( R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s t
SybaseNumericc B s e Z d Z RS( c C s[ | i d j o+ | i d j o d Sd h | i d 6Sn d h | i d 6| i d 6Sd S( Nt NUMERICs NUMERIC(%(precision)s)R s! NUMERIC(%(precision)s, %(scale)s)R ( R R! R ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s
( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR- s c B s, e Z d e d d Z d Z d Z RS( i
i c K s, t t i | i | | | | | _ d S( N( t supert sqltypest FLOATt __init__R ( R" R t asdecimalR t kwargs( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C sC | i o t i | S| i d j o d Sd h | i d 6Sd S( NR1 s FLOAT(%(precision)s)R ( R3 R- R* R R! ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s
c C s( d } | i o t i | | S| S( Nc S s | d j o d St | S( N( R! Rm ( R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR' s
( R3 R- R$ ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR$ s
( R+ R, t FalseR2 R* R$ ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.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/sybase.pyR* s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s e Z d Z RS( c C s d S( Nt BIGINT( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s e Z d Z RS( c C s d S( Nt TINYINT( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s e Z d Z RS( c C s d S( NR ( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s e Z d Z d Z RS( c O s t t | i t d S( N( R/ R R2 R5 ( R" t at kw( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C s d S( Nt DATETIME( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s ( R+ R, R2 R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s, e Z d Z d Z d Z d Z RS( c O s t t | i t d S( N( R/ R R2 R5 ( R" R9 R: ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C s d S( NR; ( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s c C s
d } | S( Nc S s | d j o d S| S( N( R! ( R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR' s
( ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR$ s c C s
d } | S( Nc S s | d j o d S| S( N( R! ( R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR' s
( ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR( s ( R+ R, R2 R* R$ R( ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s e Z d Z d Z RS( c O s t t | i t d S( N( R/ R R2 R5 ( R" R9 R: ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C s d S( Nt DATE( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s ( R+ R, R2 R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s e Z d Z d Z RS( c O s t t | i t d S( N( R/ R R2 R5 ( R" R9 R: ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C s d S( NR< ( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s ( R+ R, R2 R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s# e Z d Z d Z d Z RS( c O s t t | i t d S( N( R/ R R2 R5 ( R" R9 R: ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C s d S( NR; ( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s c C s
d } | S( Nc S s4 | d j o d St i | i | i | i | i S( N( R! t datetimeR t hourt minutet secondt microsecond( R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR'
s
( ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR$ s ( R+ R, R2 R* R$ ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s, e Z d Z d Z d Z d Z RS( c O s t t | i t d S( N( R/ R R2 R5 ( R" R9 R: ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C s d S( NR; ( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* s c C s
d } | S( Nc S s4 | d j o d St i | i | i | i | i S( N( R! R= R R> R? R@ RA ( R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR' s
( ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR$ s c C s
d } | S( Nc S s= | d j o d St i d d d | i | i | i | i S( Ni i ( R! R= R> R? R@ RA ( R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR' $ s
( ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR( # s ( R+ R, R2 R* R$ R( ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c B s e Z d Z RS( c C s d S( Nt TEXT( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* + s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR * s c B s e Z d Z RS( c C s d h | i d 6S( Ns VARCHAR(%(length)s)t length( RC ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* / s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR . s c B s e Z d Z RS( c C s d h | i d 6S( Ns CHAR(%(length)s)RC ( RC ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* 3 s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR 2 s c B s e Z d Z RS( c C s d S( Nt IMAGE( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* 7 s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR! 6 s c B s# e Z d Z d Z d Z RS( c C s d S( Nt BIT( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* ; s c C s
d } | S( Nc S s$ | d j o d S| o t p t S( N( R! t TrueR5 ( R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR' ? s
( ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR$ > 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 ( RF R5 R! ( R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR' F s
( ( R" R# R' ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR( E s ( R+ R, R* R$ R( ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR" : s c B s e Z d Z RS( c C s d S( Nt TIMESTAMP( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* R s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR# Q s c B s e Z d Z RS( c C s d S( Nt MONEY( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* V s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR$ U s c B s e Z d Z RS( c C s d S( Nt
SMALLMONEY( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* Z s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR% Y s c B s e Z d Z RS( c C s d S( Nt UNIQUEIDENTIFIER( ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR* ^ s ( R+ R, R* ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR& ] s t SybaseSQLExecutionContextc B s e Z RS( ( R+ R, ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRK a s t SybaseSQLExecutionContext_mxodbcc B s, e Z d d d d Z d Z d Z RS( c C s& t t | i | | | | | d S( N( R/ RL R2 ( R" R# t
connectiont compiledt statementt
parameters( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 f s c C s t t | i d S( N( R/ RL t pre_exec( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRQ i s c C s | i i o | i i i } | i i d | i i } t | d } | d j oL t | d p | i d j o | g | _ q | g | i d | _ q n t t | i
d S( Ns SELECT @@identity AS lastrowidi t _last_inserted_idsi ( RN t isinsertRO R RO Rg t fetchoneR t hasattrRR R! R/ RL t post_exec( R" R t rowt lastrowid( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRV l s
! N( R+ R, R! R2 RQ RV ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRL d s t SybaseSQLExecutionContext_pyodbcc B s, e Z d d d d Z d Z d Z RS( c C s& t t | i | | | | | d S( N( R/ RY R2 ( R" R# RM RN RO RP ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C s t t | i d S( N( R/ RY RQ ( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRQ s c C s | i i o | i i i } | i i d | i i } t | d } | d j oL t | d p | i d j o | g | _ q | g | i d | _ q n t t | i
d S( Ns SELECT @@identity AS lastrowidi RR i ( RN RS RO R RO Rg RT R RU RR R! R/ RY RV ( R" R RW RX ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRV s
! N( R+ R, R! R2 RQ RV ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRY ~ s t SybaseSQLDialectc 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 6Z 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 d
6e
d 6e
d 6e
d 6e d 6e
d 6e d 6e d 6e d 6e d 6e d 6e d 6Z d Z e! Z" e! Z# e! Z$ e% Z& d& d Z( d Z) d& d Z* e+ e* Z* d Z, d Z- d Z. d Z/ d! Z0 d" Z1 d# Z2 d& d$ Z3 d% Z4 RS(' R s unsigned ints unsigned smallints unsigned bigintR1 R R R s long varcharR< RT R Rm R[ R2 s long binaryR R3 t imageR t moneyt
smallmoneyt uniqueidentifiers java.lang.Objects java serializationt sybasec O sp | t j o t t | i | | | S| o( | i GHt i | i } | | | St i | | | Sd S( N( RZ R/ t __new__R+ t dialect_mappingt gett object( t clst dbapit argsR4 R# ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR` s
c K s0 t t | i | t | _ | i d d S( Nt dba( R/ RZ R2 R5 t text_as_varchart set_default_schema_name( R" t params( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 s c C s | ow y t | } | i SWq t j
oL t i d d i g } t i D]
} | | qP ~ d | q XnJ xF t i D], } y | i SWq t j
o } q Xq Wt d d S( Ns5 Unsupported SybaseSQL module '%s' requested (must be s or t )s> No DBAPI module detected for SybaseSQL - please install mxodbc( Ra t import_dbapit KeyErrorR R% R t keysR t ImportError( Rd t module_namet dialect_clst _[1]t xt e( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRe s
N
c C s t i | | i } | S( N( R0 t
adapt_typet colspecs( R" t typeobjt newobj( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt type_descriptor s c C s
| i i S( N( t contextt last_inserted_ids( R" ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR{ s c C s | i S( N( t schema_name( R" RM ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt get_default_schema_name s c C s
| | _ d S( N( R| ( R" R| ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyRi s c K s/ t | } t t | i | | | | d S( N( t tupleR/ RZ t
do_execute( R" RO RO Rj R4 ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c C sw yC | h j o
d } n | i | | | i | i _ d | _ Wn- t j
o! } t i i | | | n Xd S( Nt Y( ( Rg t rowcountRz t DBPROP_COMMITPRESERVEt ExceptionR t
DBAPIErrort instance( R" t cRO RP Rt ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt _execute s
c C s~ t i t i i g t i t i i i d o t i i d j } | i | } g } | i D] } | | d qf ~ S( s* Ignore the schema and the charset for now.s SYS%id i (
R R t tablesR R t not_R R Rg t fetchall( R" RM R t st rpRr RW ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt table_names s
c C so t i t i i g t i i | j } | i | } | i } d | d t t | d j GH| d j S( Ns has_table: s : (
R R R R R Rg RT t strt boolR! ( R" RM t tablenameR R R RW ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt has_table s
' #c C s} | i d j o
| i } n | i | } t i t t g t i i | i
j d t i t i t g d t i i g } | i
| } t } xt o| i } | d j o Pn t } | t i i | t i i | t i i d j | t i i | t i i | t i i | t i i | t i i d j | t i i | t i i | t i i f \ } }
} } }
} } } } } } | o | | j o q n | d j o
d } n g } x5 | |
| f D]$ } | d j o | i | qqW| i i |
d } | t j o | d j o
t } n> | d j o$ t i! d |
| f t" i# } n | | } g } | d j o# | i t i$ t i% | n t i& | | d | d | | } t' | d j o8 t i( | d | _) t' | | i) _* d
| i) _+ n | i, | q Wd h | i
d 6} | i
| } h } x t o | i } | d j o Pn | d | d
| d
| d f \ } } } } | | i- j o( d | g d | | f g g | | s t dayofyeart doyt weekdayt dowt millisecondt millisecondsc C s@ t t | i | } | i i d o d | } n | S( Nt literals
STRING(%s)( R/ R t bindparam_stringt lowert
startswith( R" R t res( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c C s{ | i o d p d } | i o | d | i f 7} n | i o4 | i p | d 7} n | d | i d f 7} n | S( Ns DISTINCT t s TOP %s s TOP 1000000 s START AT %s i ( t _distinctt _limitt _offset( R" R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt get_select_precolumns s
c C s d S( NR ( ( R" R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt limit_clause s c C si t | i t i o9 | i t i j o& | i t i | i | i | i St t
| i | Sd S( sK Move bind parameters to the right-hand side of an operator, where possible.N( t
isinstanceR R t _BindParamClauset operatort eqR' t _BinaryExpressionR R/ R t visit_binary( R" R2 ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s )&c C sA t | t i o | i d St t | i | | | Sd S( N( R R t Functiont labelR! R/ R t label_select_column( R" R t columnt asfrom( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s R t current_datec C s | i i | i | i | _ t t | i | } | i i d j o2 t i | t } d | | i
| i f } n | S( NR s CAST(%s AS %s)( t function_rewritesRb R R/ R t visit_functionR R t _CastR R' t
typeclause( R" t funcR R; ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s c C s5 | i i | i | i } d | | i | i f S( Ns DATEPART("%s", %s)( t extract_mapRb t fieldR' t expr( R" t extractR ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt
visit_extract s c C s d S( NR ( ( R" R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt for_update_clause! s c C sB | i | i } | o! | i p
| i o d | Sd Sd S( Ns
ORDER BY R ( R' t _order_by_clauset is_subqueryR ( R" R R ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt order_by_clause% s ( R+ R, R t DefaultCompilerR R R t
sql_operatorst modR R R R R R R R R R R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR s$
t SybaseSQLSchemaGeneratorc B s e Z d Z RS( c K s> | i i | } t | i d t o~ | i ot | i oj t | i t i
oT | i d j p# t | i t
i o* | i i o t
i | i d | _ q n t | d o | | i _ | d 7} n$ | d | i i | i i 7} | i p | d 7} n | i | } | d j o | d | 7} n | S( Nt has_sequencet _seqR s Integer IDENTITYt s NOT NULLs DEFAULT ( t preparert
format_columnt getattrR R5 R t
autoincrementR R R0 R R R! R R t optionalR R RU R t dialect_implR# R* R t get_column_default_string( R" R R4 t colspecR ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt get_column_specification0 s ! 3! #
( R+ R, R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR / s t SybaseSQLSchemaDropperc B s e Z d Z RS( c C sX | i d | i i | i i | i i | i | i t | i f | i d S( Ns
DROP INDEX %s.%s( R R t quote_identifierR R R t _validate_identifierR5 Rg ( R" R| ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt visit_indexK s ,( R+ R, R ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR J s t SybaseSQLDefaultRunnerc B s e Z RS( ( R+ R, ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR! S s t SybaseSQLIdentifierPreparerc B s) e Z e Z d Z d Z d Z RS( c C s t t | i | d S( N( R/ R" R2 ( R" R# ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR2 Z s c C s | S( N( ( R" R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt _escape_identifier] s c C s | S( N( ( R" R& ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt _fold_identifier_casea s ( R+ R, t RESERVED_WORDSt reserved_wordsR2 R# R$ ( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyR" W s (b t __doc__R= R t
sqlalchemyR R R R t sqlalchemy.sqlR R t sqlalchemy.engineR R R R0 R R R
R R R
R R R R t __all__R R% t ischemaRF R R R R R
R t foreignkeysR R t fkcolst
TypeEngineR R R- R1 R R R R R R R R R R R R R R R R R R R R! R R" RG R# R$ R% R& t DefaultExecutionContextRK RL RY t DefaultDialectRZ R R Ra R
R t SchemaGeneratorR t
SchemaDropperR t
DefaultRunnerR! t IdentifierPreparerR" R# t statement_compilert schemageneratort
schemadropperR t
defaultrunner( ( ( s? /usr/lib/python2.6/site-packages/sqlalchemy/databases/sybase.pyt s& " ( !! !!!
.2
U