[Jc d @ s 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
l Z l Z d d k l
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/ 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 g^ Z e i dd e i Z e i de Z e i df e i Z e i dg e i Z h dh di 6dj dk 6dl dm 6dn do 6dp dq 6Z h" dr e i 6ds e i 6dt e i 6du e i 6dv e i 6dw e i 6dx e i 6dy e i 6dx e i! 6dz e i" 6d{ e i# 6d| e i$ 6d} e i% 6d~ e i& 6d e i' 6d e i( 6d e i) 6e* d e i+ 6e* d e i, 6e* d e i- 6e* d e i. 6d e i/ 6d e i0 6d e i1 6d e i2 6d e i3 6d e i4 6d e i5 6d e i6 6d e i7 6d e i8 6d e i9 6d e i: 6d e i; 6Z< h d e
i= 6d e
i> 6d e
i? 6d e
i@ 6d e
iA 6d e
iB 6d e
iC 6d e
iD 6d e
iE 6d e
iF 6d e
iG 6ZH h d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d 6ZI d e iJ f d YZK d e iL f d YZM d e iN f d YZO d eO f d YZP d eO f d YZQ d eR f d YZS d S( s Base SQL and DDL compiler implementations.
Provides the :class:`~sqlalchemy.sql.compiler.DefaultCompiler` class, which is
responsible for generating all SQL query strings, as well as
:class:`~sqlalchemy.sql.compiler.SchemaGenerator` and :class:`~sqlalchemy.sql.compiler.SchemaDropper`
which issue CREATE and DROP DDL for tables, sequences, and indexes.
The elements in this module are used by public-facing constructs like
:class:`~sqlalchemy.sql.expression.ClauseElement` and :class:`~sqlalchemy.engine.Engine`.
While dialect authors will want to be familiar with this module for the purpose of
creating database-specific compilers and schema generators, the module
is otherwise internal to SQLAlchemy.
iN( t schemat enginet utilt exc( t operatorst functionsR t visitors( t
expressiont allt analyset analyzet andt anyt arrayt ast asct
asymmetrict
authorizationt betweent binaryt botht caset castt checkt collatet columnt
constraintt createt crosst current_datet current_rolet current_timet current_timestampt current_usert defaultt
deferrablet desct distinctt dot elset endt exceptt falset fort foreignt freezet fromt fullt grantt groupt havingt iliket int initiallyt innert intersectt intot ist isnullt joint leadingt leftt liket limitt localtimet localtimestampt naturalt newt nott notnullt nullt offt offsett oldt ont onlyt ort ordert outert overlapst placingt primaryt
referencest rightt selectt session_usert sett similart somet symmetrict tablet thent tot trailingt truet uniont uniquet usert usingt verboset whent wheres
^[A-Z0-9_$]+$s [0-9$]s% (?s >=t =t DISTINCTs ||c C s$ d | | f | o d | p d S( s
%s LIKE %ss ESCAPE '%s't ( ( t xt yt escape( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt N s c C s$ d | | f | o d | p d S( s %s NOT LIKE %ss ESCAPE '%s'Rx ( ( Ry Rz R{ ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR| O s c C s$ d | | f | o d | p d S( s lower(%s) LIKE lower(%s)s ESCAPE '%s'Rx ( ( Ry Rz R{ ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR| P s c C s$ d | | f | o d | p d S( s lower(%s) NOT LIKE lower(%s)s ESCAPE '%s'Rx ( ( Ry Rz R{ ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR| Q s t BETWEENt MATCHt INs NOT INs , t DESCt ASCt FROMt ASt EXISTSt ISs IS NOTt COLLATEs coalesce%(expr)st CURRENT_DATEt CURRENT_TIMEt CURRENT_TIMESTAMPt CURRENT_USERt LOCALTIMEt LOCALTIMESTAMPs random%(expr)st sysdatet SESSION_USERt USERt montht dayt yeart secondt hourt doyt minutet quartert dowt weekt epocht millisecondst microsecondst
timezone_hourt timezone_minutet
_CompileLabelc B s2 e Z d Z d Z d Z d Z e d Z RS( s< lightweight label object which acts as an expression._Label.t labelt elementt namec C s | | _ | | _ d S( N( R R ( t selft colR ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt __init__ s c C s
| i i S( N( R t quote( R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s ( s elements name( t __name__t
__module__t __doc__t __visit_name__t __slots__R t propertyR ( ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
t DefaultCompilerc B s5 e Z d Z e Z e Z e Z e Z
Z Z d5 e d Z d Z d Z d Z d5 d Z e e Z d Z d Z d5 e d Z d5 d Z d
Z d Z d Z d
Z d Z d Z d Z d Z d Z! d Z" d Z# d5 d Z$ d Z% d Z& e e' d Z( d Z) d Z* d Z+ d Z, d Z- d Z. d Z/ d Z0 d! Z1 e d" Z2 d# Z3 e e' e d$ d% Z4 d& Z5 d' Z6 d( Z7 d) Z8 e d* Z9 e d+ Z: d, Z; d- Z< d. Z= d/ Z> d0 Z? d1 Z@ d2 ZA d3 ZB d4 ZC RS(6 s Default implementation of Compiled.
Compiles ClauseElements into SQL strings. Uses a similar visit
paradigm as visitors.ClauseVisitor but implements its own traversal.
c K s t i i | | | | | | p t | d t | _ h | _ t i | _ g | _
h | _ | i i
| _
| i
o
g | _ n t | i i | _ | i i | _ | i i p
| i i | _ t i | i | _ h | _ d S( s Construct a new ``DefaultCompiler`` object.
dialect
Dialect to be used
statement
ClauseElement to be compiled
column_keys
a list of column names to be compiled into an INSERT or UPDATE
statement.
t inlineN( R t CompiledR t getattrt FalseR t bindsR t column_dictt
bind_namest stackt
result_mapt dialectt
positionalt positiontupt BIND_TEMPLATESt
paramstylet bindtemplatet identifier_preparert preparert label_lengtht max_identifier_lengtht PopulateDictt
_process_anont anon_mapt truncated_names( R R t statementt column_keysR t kwargs( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
c C s | i | i | _ d S( N( t processR t string( R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt compile s c K s | i | | S( N( t _compiler_dispatch( R t objR ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s c C s t | i d j S( Ni ( t lenR ( R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt is_subquery s c C s | o t i | } h } x | i i D] \ } } xq | i | i | f D]& } | | j o | | | | ^ s c 3 s" x | ] } i | Vq Wd S( N( R ( R t c( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys ^ s ( t operatorR R t comma_opR R; t clauses( R t
clauselistR t sep( ( R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_clauselistV s
c K s d } | i o | | i | i d 7} n xC | i D]8 \ } } | d | i | d | i | d 7} q8 W| i o" | d | i | i d 7} n | d 7} | S( Ns CASE R s WHEN s THEN s ELSE t END( R R t whenst else_( R t clauseR Ry t condt result( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt
visit_casea s
0
"
c K s& d | i | i | i | i f S( Ns CAST(%s AS %s)( R R R ( R R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt
visit_castl s c K s5 | i i | i | i } d | | i | i f S( Ns EXTRACT(%s FROM %s)( t extract_mapt gett fieldR t expr( R t extractR R" ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt
visit_extracto s c K s | d j o& | i d | i f | | i i s R R/ s
GROUP BY Rx R R ( R t appendR! R t TrueR R; t enumeratet selectst keywordR t _group_by_clauset order_by_clauset _limitt _offsett limit_clauset pop( R t csR/ R0 R t entryR t group_by( ( R R/ s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_compound_select s *:
c K sf | i | i } | i o | i | i d | } n | i o | d | i | i } n | S( NR ( R R R R t modifier( R t unaryR R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_unary s
c K s~ | i | i } t i | o, | | i | i | i | i | i S| i | i d | d | i | i Sd S( NR ( R R R R R R= RS t modifiers( R R R t op( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_binary s ,c C s | i i | t | S( N( R R! t str( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s c K s | i | } | | i j oL | i | } | | j o. | i p
| i o t i d | i qk n | | i | i <| i | <| i | S( NsI Bind parameter '%s' conflicts with unique bind parameter of the same name( t _truncate_bindparamR R` R t CompileErrorR R ( R R R R t existing( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_bindparam s
! c C sb | | i j o | i | S| i } t | t i o | i d | p | } | | i | <| S( NR ( R R R R R R ( R R t bind_name( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyRI s
c C s | | f | i j o | i | | f S| | i } t | | i j oY | i i | d } | d t | i d d !d t | d } | d | i | s R/ R s SELECT R c 3 s" x | ] } i | Vq Wd S( N( R ( R Ry ( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys " s s , s
FROM c 3 s( x! | ] } i | d t Vq Wd S( R/ N( R R4 ( R t f( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys ( s s
WHERE s
GROUP BY s
HAVING R R ( R R! R t _get_display_fromsRV R t
_from_objectsR3 R R R t unique_listt
inner_columnsR Rj R4 t _prefixesR; t get_select_precolumnsR t _whereclauseR8 R t _havingt _order_by_clauseR9 R: R; R< t
for_updatet for_update_clauseR= ( R RT R/ R0 R. R1 R R? t
existingfromst fromst correlate_fromst column_clause_argsR* t coRo R t tR@ ( ( R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_select sV (H
.
'
c C s | i o d p d S( sQ Called when building a ``SELECT`` statement, position is just before column list.s DISTINCT Rx ( t _distinct( R RT ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyRq I s c C s* | i | i } | o d | Sd Sd S( Ns
ORDER BY Rx ( R Rt ( R RT t order_by( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR9 N s c C s | i o d Sd Sd S( Ns FOR UPDATERx ( Ru ( R RT ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyRv U s
c C s~ d } | i d j o | d t | i 7} n | i d j o9 | i d j o | d 7} n | d t | i 7} n | S( NRx s
LIMIT s
LIMIT -1s OFFSET ( R: R RH R; ( R RT R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR< [ s c K sv | og t | d d o7 | i i | i | i d | i i | i | i S| i i | i | i Sn d Sd S( NR R Rx ( R R R R R R R ( R RZ R/ R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_tablee s
7 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 JOIN s ON ( R R= R4 t isouterRS t onclause( R R; R/ R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt
visit_joinn s c C s d S( N( R ( R t seq( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_sequencer s c
C sN t | _ | i | } | i } d i d g g } | i D] } | | i | q; ~ } | o9 | i i o+ | i i o t
i d | i i n | o) | i i o | d | i
| i f S| d | i
| i d i g } | D] } | | i | d q ~ d i g } | D] } | | d q*~ f Sd S( NR t INSERTs? The version of %s you are using does not support empty inserts.s INTO %s DEFAULT VALUESs INTO %s (%s) VALUES (%s)s , i i ( R4 t isinsertt _get_colparamsR R; Rp R R t supports_default_valuest supports_empty_insertR RJ R t format_tableRZ t
format_column(
R t insert_stmtt colparamsR R* Ry t insertt _[2]R t _[3]( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_insertu s 1$
'c s i i h t | i g d 6 t _ i | } d i d i i | i d d i f d | D f } | i
o | d i | i
7} n i i d | S( NR. R t UPDATEt SETs , c 3 sB x; | ]4 } i i | d i | d i d | d Vq Wd S( i Rv i N( R R R ( R R ( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys s s WHERE i(
R R3 RV RZ R4 t isupdateR R; R R Rr R R= ( R t update_stmtR R ( ( R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_update s #
c s f d } g _ g _ i d j oE | i d j o5 g } | i i D] } | | | | d f qR ~ S i d j o
h } n t d i D } | i d j o= x: | i i D]% \ } } | i t
i | | q Wn g } x| i i D]} | i | j ol | | i } t
i
| o | | | } n& i i | i | i } | i | | f q t | t i o i o| i o i i o i o t | i t i o | i i p2 i i p' | i d j oG t | i t i o0 | i | | | d f i i | qqt | i t i o t | i i t
i oJ | i | i | i i i f | i p i i | qq| i | | | d f i i | q| i d j o" | i p i i | qqt | i t i oX i | i }
|
d j o5 | i | |
f | i p i i | qqqq i! o t | i" t i o t | i" i t
i o< | i | i | i" i i f i i | q| i | | | d f i i | q| i# d j o i i | qt | i" t i$ o i i | qqq q W| S( ss create a set of tuples representing column/string pairs for use
in an INSERT or UPDATE statement.
c sD t i | i | d | i } | i | i < i i | S( NR ( R R R R R R RI ( R R R ( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt create_bind_param s c s s( x! | ] } t i | d f Vq Wd S( N( R t _column_as_keyR ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys s N(% t postfetcht prefetchR R t
parametersRZ t columnst dictR t
setdefaultR R R t _is_literalR3 R t
self_groupR R t ColumnR t primary_keyR t preexecute_pk_sequencesR R" t Sequencet optionalt supports_pk_autoincrementt
ColumnDefaultt argt
ClauseElementt server_defaultR t onupdatet server_onupdatet FetchedValue( R t stmtR R* R R t kt vt valuesR t proc( ( R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR sz 5
!
" (
( c C s | i i h t | i g d 6 t | _ d | i i | i } | i o | d | i | i 7} n | i i
d | S( NR. s DELETE FROM s WHERE i( R R3 RV RZ R4 t isdeleteR R Rr R R= ( R t delete_stmtR ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_delete s #
c C s d | i i | S( Ns SAVEPOINT %s( R t format_savepoint( R t savepoint_stmt( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_savepoint s c C s d | i i | S( Ns ROLLBACK TO SAVEPOINT %s( R R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_rollback_to_savepoint s c C s d | i i | S( Ns RELEASE SAVEPOINT %s( R R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_release_savepoint s c C s | i p d S( NRx ( R ( R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt __str__
s N(D R R R t OPERATORSR t FUNCTIONSR t EXTRACT_MAPR 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 R R% R+ R( R& R4 RA RD RG R RL RI R RU R R R^ Rj R} Rq R9 Rv R< R R R R R R R R R R R ( ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR sr 6
K
U
t DDLBasec B s e Z d Z d Z RS( c sg g d t i f f d Y} | } x/ D]' } x | i D] } | i | qH Wq8 W S( Nt FindAlterablesc s e Z f d Z RS( c s/ | i o! | i j o i | n d S( N( t use_alterRZ R3 ( R R ( t tablest
alterables( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_foreign_key_constraint s ( R R R ( ( R R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s ( R t
SchemaVisitort constraintst traverse( R R R t findalterablesRZ R ( ( R R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt find_alterables s "
c C s | ok t | | i i j oJ t | d d } | d | _ | d | i i d !d t | i d S| Sn | i i | | Sd S( NRS i i i RN i ( R R R R RS RP t validate_identifier( R RW t truncateRS ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt _validate_identifier s
+( R R R R ( ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR
s t SchemaGeneratorc B s e Z e d d Z e d Z d Z d Z d Z d Z d Z
d Z d Z d Z
d
Z d Z d Z d
Z d Z d Z d Z d Z RS( c K sX t t | i | | | | _ | o
t | p d | _ | i | _ | | _ d S( N(
t superR R t
checkfirstRV R R R R R ( R R t
connectionR R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR ( s
c C s
t d S( N( t NotImplementedError( R R t first_pk( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt get_column_specification/ s c C sb | i i | i | i o | i i | i n | i p# | i i | i | i d | i S( NR ( R R R R R t has_tableR ( R RZ ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt _can_create2 s
c C s | i o
| i } n | i i } g } t i | D]! } | i | o | | q: q: ~ } x | D] } | i | qk W| i i o+ x( | i | D] } | i | q Wn d S( N(
R R t sql_utilt sort_tablesR t traverse_singleR t supports_alterR t add_foreignkey( R t metadataR R* R| t
collectionRZ t alterable( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_metadata8 s
>
c
C s) x( | i d D] } | d | | i q Wx5 | i D]* } | i d j o | i | i q5 q5 W| i d d i d g | i d | i i
| d g d } t } x | i D]y } | i | d } | i d | i | d | i
o | | i
o
t } n x | i D] } | i | qWq W| i
o | i | i
n xM g } | i D]! } | | i
j o | | qbqb~ D] } | i | qW| i d
| i | | i t | d o% x" | i D] } | i | qWn x( | i d D] } | d | | i qWd S(
Ns
before-creates
R t CREATEt TABLER s ,
s R s
)%s
t indexess after-create( t
ddl_listenersR R R" R R R3 R; Rp R R R R R R4 R t post_create_tablet executeRg R (
R RZ t listenerR t separatorR R R* R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR D sL
+
9
c C s d S( NRx ( ( R RZ ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR o s c C sc t | i t i oE t | i i t o d | i i St | i | i i d Sn d Sd S( Ns '%s'( R R R t
DefaultClauseR t
basestringt unicodet _compileR ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt get_column_default_stringr s
c C s) | i i | i | | } | i | S( sI compile the given string/parameters using this SchemaGenerator's dialect.( R t statement_compilerR ( R t tocompileR t compiler( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR { s
c C sc | i d | i d j o! | i d | i i | n | i d | i | i | d S( Ns ,
s CONSTRAINT %s s CHECK (%s)( R3 R R R t format_constraintt sqltextt define_constraint_deferrability( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_check_constraint s
c C s% | i d | i | i | d S( Ns CHECK (%s)( R3 R R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_column_check_constraint s c s t | d j o d S i d | i d j o! i d i i | n i d i d d i f d | D i | d S( Ni s ,
s CONSTRAINT %s s PRIMARY KEY s (%s)s , c 3 s. x' | ] } i i | i | i Vq Wd S( N( R R R ( R R ( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys s ( R R3 R R R R R; R ( R R ( ( R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_primary_key_constraint s
!
c C s: | i o | i i o d S| i d | i | d S( Ns ,
( R R R R3 t define_foreign_key( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
c C s; | i d | i i | i | i | | i d S( Ns ALTER TABLE %s ADD ( R3 R R RZ R R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
c s | i | i d j o | i d i | n t | i d i i } | i d d i f d | i D i
| d i f d | i D f | i d j o | i d | i n | i d j o | i d | i n | i
| d S( Ns CONSTRAINT %s i s" FOREIGN KEY(%s) REFERENCES %s (%s)s , c 3 s1 x* | ]# } i | i i | i i Vq Wd S( N( R t parentR ( R Rk ( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys s c 3 s1 x* | ]# } i | i i | i i Vq Wd S( N( R R R ( R Rk ( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys s s
ON DELETE %ss
ON UPDATE %s( R R R R3 R t listt elementsR RZ R; R t ondeleteR R ( R R RZ ( ( R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
c sy i d | i d j o! i d i i | n i d d i f d | D i | d S( Ns ,
s CONSTRAINT %s s UNIQUE (%s)s , c 3 s. x' | ] } i i | i | i Vq Wd S( N( R R R ( R R ( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys s ( R3 R R R R R; R ( R R ( ( R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt visit_unique_constraint s
*c C sh | i d j o, | i o | i d q< | i d n | i d j o | i d | i n d S( Ns DEFERRABLEs NOT DEFERRABLEs
INITIALLY %s( R# R R3 R5 ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
c C s d S( N( ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s c s | i | i d | i o | i d n | i d i | i | i t | i i | i d i f d | i
D f | i d S( Ns CREATE s UNIQUE s INDEX %s ON %s (%s)s , c 3 s+ x$ | ] } i | i | i Vq Wd S( N( R R ( R R ( R ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pys s ( R R3 R` R R R R4 R RZ R; R R ( R R ( ( R s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
!N( R R R R R R R R R R R R R R R R R R R R R R ( ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR ' s$ + t
SchemaDropperc B sD e Z e d d Z d Z d Z d Z d Z d Z RS( c K sD t t | i | | | | _ | | _ | i | _ | | _ d S( N( R R R R R R R R ( R R R R R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
c C s | i o
| i } n | i i } g } t t i | D]! } | i | o | | q@ q@ ~ } | i i o+ x( | i | D] } | i | q Wn x | D] } | i
| q Wd S( N( R R t reversedR R t _can_dropR R R t drop_foreignkeyR ( R R R R* R| R R RZ ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
D
c C sa | i i | i | i o | i i | i n | i p" | i i | i | i d | i S( NR ( R R R R R R R ( R RZ ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
c C s@ | i d | i i | i | i t | i | i d S( Ns
DROP INDEX ( R3 R R R R R R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s 2c C s@ | i d | i i | i | i i | f | i d S( Ns! ALTER TABLE %s DROP CONSTRAINT %s( R3 R R RZ R R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s c C s x( | i d D] } | d | | i q Wx5 | i D]* } | i d j o | i | i q5 q5 W| i d | i i | | i x( | i d D] } | d | | i q Wd S( Ns before-drops
DROP TABLE s
after-drop(
R R R R" R R R3 R R R ( R RZ R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
N(
R R R R R R R R R R ( ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s t IdentifierPreparerc B s e Z d Z e Z e Z e Z d d e
d Z d Z d Z
d Z d Z d Z d Z e d Z d d
Z d d Z d d Z d
Z e d d Z e
d d d Z e d Z d Z RS( s@ Handle quoting and case-folding of identifiers based on options.t "c C s; | | _ | | _ | p | i | _ | | _ h | _ d S( si Construct a new ``IdentifierPreparer`` object.
initial_quote
Character that begins a delimited identifier.
final_quote
Character that ends a delimited identifier. Defaults to `initial_quote`.
omit_schema
Prevent prepending schema name. Useful for databases that do
not support schemae.
N( R t
initial_quotet final_quotet omit_schemat _strings( R R R R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s
c C s | i d d S( s Escape an identifier.
Subclasses should override this to provide database-dependent
escaping behavior.
R s ""( R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt _escape_identifier' s c C s | i d d S( s Canonicalize an escaped identifier.
Subclasses should override this to provide database-dependent
unescaping behavior that reverses _escape_identifier.
s ""R ( R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt _unescape_identifier0 s c C s | i | i | | i S( s~ Quote an identifier.
Subclasses should override this to provide database-dependent
quoting behavior.
( R R R ( R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt quote_identifier9 s c C sW | i } | | i j p; | i i | d p$ | i i t | p
| | j S( s5 Return True if the given identifier requires quoting.i ( R t reserved_wordst illegal_initial_characterst matcht legal_charactersR ( R R t lc_value( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt _requires_quotesB s
c C s | i | | S( sz Quote a schema.
Subclasses should override this to provide database-dependent
quoting behavior.
( R ( R R t force( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR J s c C s | d j ob | | i j o | i | S| i | o | i | | i | | o7 t | d d o$ | i | i | i d | } n | S( s' Prepare a quoted table and schema name.R R N( R R R R R R R ( R RZ R R R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR s s
%$c C s | d j o
| i } n t | d t pR | o4 | i | i d t d | d | i | | i S| i | | i Sn1 | o% | i | i d t d | d | S| Sd S( s Prepare a quoted column name.R R R R N( R R R R R RZ R ( R R t use_tableR t
table_name( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR } s
4%c C sk | i oF | o? t | d d o, | i | i | i | i | d t f S| i | d t f Sd S( s( Format table name and schema as a tuple.R R N( R R R R R R R ( R RZ R ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt format_table_seq s %c
C s y
| i } Wn t j
o g } | i | i | i | i f D] } | t i | qD ~ \ } } } t i d h | d 6| d 6| d 6 } | | _ n Xg } g } | i | D] \ }
} | |
p | q ~ D] } | | i | q ~ S( s: Unpack 'schema.table.column'-like strings into components.sM (?:(?:%(initial)s((?:%(escaped)s|[^%(final)s])+)%(final)s|([^\.]+))(?=\.|$))+t initialt finalt escaped(
t _r_identifierst AttributeErrorR R R t reR{ R t findallR (
R t identifierst rR* R R R t
escaped_finalR R t at bR2 ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt unformat_identifiers s
;
N( R R R t RESERVED_WORDSR t LEGAL_CHARACTERSR t ILLEGAL_INITIAL_CHARACTERSR
R R R R R R R R R R4 R R R\ R R R R R R# ( ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyR
s(
(T R R R t
sqlalchemyR R R R t sqlalchemy.sqlR R R R R R RV R$ R t IR% R& t UNICODER R R t and_t or_t invt addt mulR t divt modt truedivt ltt let net gtt get eqt distinct_opt concat_opR t like_opt
notlike_opt ilike_opt notilike_opt
between_opt match_opt in_opt notin_opR t desc_opt asc_opt from_R t existst is_t isnotR R t coalesceR R R R! R@ RA t randomR RU Ra R R t VisitableR R R t SchemaIteratorR R R t objectR ( ( ( s; /usr/lib/python2.6/site-packages/sqlalchemy/sql/compiler.pyt s ""
3