File: //opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyc
�
���ec _ @ s� d Z d d l Z d d l Z d d l Z d d l Z d d l Z d d l m Z d d l m Z d d l m Z d d l m
Z
d d l m Z d d l m Z d d
l m
Z
d d l m Z d d l m Z d d
l m Z d d l m Z d d l m Z d d l
m Z d d l m Z d d
l m 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/ 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 g^ � Z e j dq e j � Z e j dr e j � Z ds � e dt du � D� j dv g � Z e j dw e j � Z e j dw e j � Z e j dx e j � Z! e j dy e j" � Z# e j dz e j" � Z$ i d{ d| 6d} d~ 6d d� 6d� d� 6d� d� 6Z% e j d� � Z& e' e( d� d� � � Z) i% d� e j* 6d� e j+ 6d� e j, 6d� e j- 6d� e j. 6d� e j/ 6d� e j0 6d� e j1 6d� e j2 6d� e j3 6d� e j4 6d� e j5 6d� e j6 6d� e j7 6d� e j8 6d� e j9 6d� e j: 6d� e j; 6d� e j< 6d� e j= 6d� e j> 6d� e j? 6d� e j@ 6d� e jA 6d� e jB 6d� e jC 6d� e jD 6d� e jE 6d� e jF 6d� e jG 6d� e jH 6d� e jI 6d� e jJ 6d� e jK 6d� e jL 6d� e jM 6d� e jN 6ZO i d� e jP 6d� e jQ 6d� e jR 6d� e jS 6d� e jT 6d� e jU 6d� e jV 6d� e jW 6d� e jX 6d� e jY 6d� e jZ 6d� e j[ 6d� e j\ 6d� e j] 6Z^ i 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� 6Z_ i d� e j` ja 6d� e j` jb 6d� e j` jc 6d� e j` jd 6d� e j` je 6d� e j` jf 6Zg dt Zh d Zi d Zj d� Zk e jl d� d� d� d� d� d� g � Zm e jn d� d� d� dt �Zo e jn d� d� d� d �Zp e jn d� d� d� d �Zq e jn d� d� d� ep eq B�Zr d� e jl d� d� d� g � f d� � � YZs d� et f d� � � YZu d� e jv e jw et � f d� � � YZx d� e
jy f d� � � YZz d� eu f d� � � YZ{ d� e{ f d� � � YZ| d� eu f d� � � YZ} d� ex f d� � � YZ~ d� e~ f d� � � YZ d� et f d� � � YZ� d S(� s] Base SQL and DDL compiler implementations.
Classes provided include:
:class:`.compiler.SQLCompiler` - renders SQL
strings
:class:`.compiler.DDLCompiler` - renders DDL
(data definition language) strings
:class:`.compiler.GenericTypeCompiler` - renders
type specification strings.
To generate user-defined SQL strings, see
:doc:`/ext/compiler`.
i����Ni ( t base( t coercions( t crud( t elements( t functions( t operators( t schema( t
selectable( t sqltypes( t util( t NO_ARG( t prefix_anon_map( t quoted_namei ( t exct 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 ^[A-Z0-9_ $]+$c C s h | ] } t | � � q S( ( t str( t .0t x( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <setcomp>� s i i
t $s5 ^(?:RESTRICT|CASCADE|SET NULL|NO ACTION|SET DEFAULT)$s ^(?:DEFERRED|IMMEDIATE)$s% (?<![:\w\$\x5c]):([\w\$]+)(?![:\w\$])s \x5c(:[\w\$]*)(?![:\w\$])s
%%(%(name)s)st pyformatt ?t qmarks %%st formats :[_POSITION]t numerics :%(name)st nameds
[%\(\):\[\] ]s %():[] t PAZC___s AND s OR s + s * s - s / s % t -s < s <= s != s > s >= s = s IS DISTINCT FROM s IS NOT DISTINCT FROM s || s MATCH s NOT MATCH s IN s NOT IN s , s FROM s AS s IS s IS NOT s COLLATE s EXISTS s DISTINCT s NOT s ANY s ALL s DESCs ASCs NULLS FIRSTs NULLS LASTt coalescet CURRENT_DATEt CURRENT_TIMEt CURRENT_TIMESTAMPt CURRENT_USERt LOCALTIMEt LOCALTIMESTAMPt randomt sysdatet SESSION_USERt USERt CUBEt ROLLUPs
GROUPING SETSt montht dayt yeart secondt hourt doyt minutet quartert dowt weekt epocht millisecondst microsecondst
timezone_hourt timezone_minutet UNIONs UNION ALLt EXCEPTs
EXCEPT ALLt INTERSECTs
INTERSECT ALLi t
ExpandedStatet statementt additional_parameterst
processorst positiontupt parameter_expansiont
NO_LINTINGs Disable all linting.t canonicalt COLLECT_CARTESIAN_PRODUCTSsO Collect data on FROMs and cartesian products and gather into 'self.from_linter't WARN_LINTINGs, Emit warnings for linters that find problemst FROM_LINTINGsQ Warn for cartesian products; combines COLLECT_CARTESIAN_PRODUCTS and WARN_LINTINGt
FromLintert fromst edgesc B s e Z d d � Z d � Z RS( c s� | j } | s d St | j � } t | � } | d k rP | } | j | � n | j � } t j | g � } xi | r� | r� | j � � | j � � � f d � | D� } | j
� f d � | D� � | j | � qq W| r� | | f Sd Sd S( Nc s" h | ] } � | k r | � q S( ( ( Rm t edge( t node( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <setcomp>D s c 3 s# | ] } | | j � � Vq d S( N( t index( Rm R� ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>H s ( NN( NN( R� t NoneR\ R� t removet popt collectionst dequet popleftt discardt
extendleftt difference_update( t selft startR� R� t the_restt
start_witht stackt to_remove( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt lint, s&
c s � j � \ } } | r{ | } | r{ d } d j � f d � | D� � } | j d | d � j | � } t j | � q{ n d S( Ns� SELECT statement has a cartesian product between FROM element(s) {froms} and FROM element "{start}". Apply join condition(s) between each element to resolve.s , c 3 s( | ] } d j d � j | � Vq d S( s "{elem}"t elemN( Rs R� ( Rm t from_( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>` s R� R� ( R� RA Rs R� R t warn( R� R� R� R� t templatet froms_strt message( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� Q s
N( t __name__t
__module__R� R� R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� + s %t Compiledc B s� e Z d Z d Z d Z d Z e j Z e j Z
d Z d Z d Z
d Z d e e j � d � Z d � Z d � Z e d � � Z d � Z d � Z d d e d � Z e d � � Z RS(
s Represent a compiled SQL or DDL expression.
The ``__str__`` method of the ``Compiled`` object should produce
the actual text of the statement. ``Compiled`` objects are
specific to their underlying database dialect, and also may
or may not be specific to the columns referenced within a
particular set of bind parameters. In no case should the
``Compiled`` object be dependent on the actual values of those
bind parameters, even though it may reference those values as
defaults.
c C s� | | _ | j j | _ | r? | | _ | j j | � | _ n | d k r� | | _ | j | _ | j | _ | j r� | j
| _ n | j | j | � | _
| r� | j j | j
| � | _
q� n t j � | _ d S( s Construct a new :class:`.Compiled` object.
:param dialect: :class:`.Dialect` to compile against.
:param statement: :class:`_expression.ClauseElement` to be compiled.
:param schema_translate_map: dictionary of schema names to be
translated when forming the resultant SQL
.. versionadded:: 1.1
.. seealso::
:ref:`schema_translating`
:param compile_kwargs: additional kwargs that will be
passed to the initial call to :meth:`.Compiled.process`.
N( t dialectt identifier_preparert preparert schema_translate_mapt _with_schema_translateR� R� t supports_executiont can_executet _annotationst _execution_optionst execution_optionst processt stringt _render_schema_translatesR t perf_countert _gen_time( R� R� R� R� t render_schema_translatet compile_kwargs( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt __init__� s" c C s5 | j r | j | | | | � St j | j � � d S( N( R� t _execute_compiledR
t ObjectNotExecutableErrorR� ( R� t
connectiont multiparamst paramsR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _execute_on_connection� s c C s) t j t j | t | � � d | �d S( Nt replace_context( R t raise_R
t UnsupportedCompilationErrort type( R� t elementt err( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_unsupported_compilation� s c C s
t � � d S( s� Return a Compiled that is capable of processing SQL expressions.
If this compiler is one, it would likely just return 'self'.
N( t NotImplementedError( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt sql_compiler� s c K s | j | | � S( N( t _compiler_dispatch( R� t objt kwargs( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s
| j p d S( s3 Return the string text of the generated SQL or DDL.t ( R� ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt __str__� s c C s
t � � d S( s� Return the bind params for this compiled object.
:param params: a dict of string/object pairs whose values will
override bind values compiled in to the
statement.
N( R� ( R� R� t extracted_parameterst escape_names( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt construct_params� s
c C s
| j � S( s0 Return the bind params for this compiled object.( R� ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s N( R� R� t __doc__R� t _cached_metadatat _result_columnsR� R t
EMPTY_DICTR� R� t
compile_statet dml_compile_statet cache_keyR� t Falset
immutabledictR� R� R� t propertyR� R� R� t TrueR� R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� j s( -
t TypeCompilerc B s/ e Z d Z d Z d � Z d � Z d � Z RS( s2 Produces DDL specification for TypeEngine objects.s visit_\w+c C s
| | _ d S( N( R� ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s c K s | j | | � S( N( R� ( R� t type_t kw( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s c K s# t j t j | | � d | �d S( NR� ( R R� R
R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s ( R� R� R� t ensure_kwargR� R� R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s
t
_CompileLabelc B sM e Z d Z d Z d Z d d � Z e d � � Z e d � � Z d � Z RS(
s; lightweight label object which acts as an expression.Label.t labelR� t namec C s& | | _ | | _ | f | | _ d S( N( R� R� t
_alt_names( R� t colR� t alt_names( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� ' s c C s
| j j S( N( R� t proxy_set( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� , s c C s
| j j S( N( R� R� ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� 0 s c K s | S( N( ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
self_group4 s ( R� R� ( (
R� R� R� t __visit_name__t __slots__R� R� R� R� R ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s t SQLCompilerc B s� e Z d Z e Z e Z e Z Z Z
e Z d� Z
e Z e Z e Z e Z e Z e Z e Z e Z e Z d� Z e � Z e � Z e j Z e Z d� Z Z! e Z" d� Z# e$ j% d � Z& d� Z' d� Z( e Z) d� d� e e* d � Z+ e, d � � Z- e, d � � Z. e j/ d � � Z0 e j1 d � � Z2 e3 j4 d � � Z5 d � Z6 e j/ d � � Z7 d
� Z8 e, d � � Z9 d� d� e d� e d � Z: e j1 d� d� d
� � Z; e, d � � Z< d� e d � Z= e j> d � d � � Z? e j/ d � � Z@ e j/ e j> d � d � � � ZA e j/ e j> d � d � � � ZB d � ZC e d � ZD d � ZE e d � ZF e d � ZG d� e e d� d� d � ZH d � ZI d � ZJ d� e d� d � ZK d � ZL d � ZM d! � ZN d" � ZO d# � ZP d$ � ZQ d� d% � ZR d� e d& � ZS d' � ZT d( � ZU d) � ZV d* � ZW d+ � ZX d, � ZY d- � ZZ d. � Z[ d/ � Z\ d0 � Z] d1 � Z^ d2 � Z_ d3 � Z` d4 � Za d5 � Zb d6 � Zc d� d7 � Zd d8 � Ze d9 � Zf d: � Zg e d� d; � Zh d< � Zi d= � Zj d� d� d> � Zk d? � Zl d@ � Zm dA � Zn dB � Zo dC � Zp dD � Zq d� dE � Zr dF � Zs d� e d� d� dG � Zt dH � Zu dI � Zv dJ � Zw dK � Zx dL � Zy e dM � Zz dN � Z{ dO � Z| e j/ dP � � Z} dQ � Z~ dR � Z dS � Z� dT � Z� dU � Z� dV � Z� dW � Z� dX � Z� dY � Z� dZ � Z� d[ � Z� d\ � Z� d] � Z� d^ � Z� d_ � Z� e e e e e d` � Z� e� d� da � Z� db � Z� dc � Z� dd � Z� de � Z� d� e e d� df � Z� e e d� d� d� dg � Z� dh � Z� di � Z� e e e d� e e d� d� dj � Z� dk � Z� dl � Z� e dm � Z� e d� dn � Z� do � Z� dp � Z� d� dq � Z� d� d� d� e e e dr � Z� ds � Z� dt � Z� du � Z� dv � Z� dw � Z� e j� dx e � f dy e � f g � Z� e dz � Z� d� Z� e e d� d� d� e d� d{ � Z� d| � Z� d} � Z� d~ � Z� d � Z� d� e d� d� � Z� d� � Z� d� � Z� d� � Z� d� � Z� d� � Z� d� � Z� d� � Z� d� � Z� e e e d� e d� d� � Z� e d� 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(� s~ Default implementation of :class:`.Compiled`.
Compiles :class:`_expression.ClauseElement` objects into SQL strings.
s" __\[POSTCOMPILE_(\S+?)(~~.+?~~)?\]c K s� | | _ | | _ | rQ d � | d D� | _ } | j d � | d D� � n | | _ | | _ i | _ t j � | _ g | _
g | _ | j | _ | j r� i | _
g | _ | j d k | _ n t | j | _ d | _ | j p� | j | _ t � | _ i | _ t j | | | | � | j s=| j s=| j r�| j rU| j | _ n | j sg| j r�| j! r|t" | _# q�| j r�| j s�| j$ j% r�| j& r�t" | _# q�q�n | j r�| j r�| j' � n | j( r�| j) d t" � n d S( s� Construct a new :class:`.SQLCompiler` object.
:param dialect: :class:`.Dialect` to be used
:param statement: :class:`_expression.ClauseElement` to be compiled
:param column_keys: a list of column names to be compiled into an
INSERT or UPDATE statement.
:param for_executemany: whether INSERT / UPDATE statements should
expect that they are to be invoked in an "executemany" style,
which may impact how the statement will be expected to return the
values of defaults and autoincrement / sequences and similar.
Depending on the backend and driver in use, support for retrieving
these values may be disabled which means SQL expressions may
be rendered inline, RETURNING may not be rendered, etc.
:param kwargs: additional keyword arguments to be consumed by the
superclass.
c S s i | ] } | | j � q S( ( t key( Rm t b( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys
<dictcomp>� s i c S s i | ] } | g | � q S( ( ( Rm R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys
<dictcomp>� s Rt t _populate_selfN(* t column_keysR� t _cache_key_bind_matcht updatet for_executemanyt lintingt bindsR t column_dictt
bind_namesR� R� t
positionalt positiontup_levelR� t
paramstylet _numeric_bindst BIND_TEMPLATESt bindtemplateR� t ctest label_lengtht max_identifier_lengthR t anon_mapt truncated_namesR� R� t isinsertt isupdatet isdeletet
_returningt returningt _inlineR� t inlineR� t insert_executemany_returningt _return_defaultst _apply_numbered_paramst _render_postcompilet# _process_parameters_for_postcompile( R� R� R� R� R R
R R� t ckbm( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � sJ
c C sF y | j d d SWn, t k
rA } t j t d � d | �n Xd S( s� Return the current 'executable' that is being compiled.
This is currently the :class:`_sql.Select`, :class:`_sql.Insert`,
:class:`_sql.Update`, :class:`_sql.Delete`,
:class:`_sql.CompoundSelect` object that is being compiled.
Specifically it's assigned to the ``self.stack`` list of elements.
When a statement like the above is being compiled, it normally
is also assigned to the ``.statement`` attribute of the
:class:`_sql.Compiler` object. However, all SQL constructs are
ultimately nestable, and this attribute should never be consulted
by a ``visit_`` method, as it is not guaranteed to be assigned
nor guaranteed to correspond to the current statement being compiled.
.. versionadded:: 1.3.21
For compatibility with previous versions, use the following
recipe::
statement = getattr(self, "current_executable", False)
if statement is False:
statement = self.stack[-1]["selectable"]
For versions 1.4 and above, ensure only .current_executable
is used; the format of "self.stack" may change.
i����R s$ Compiler does not have a stack entryR� N( R� t
IndexErrorR R� ( R� t ie( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt current_executableA s c C s t | j | j � S( N( t listt insert_prefetcht update_prefetch( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt prefetchg s c C s i S( N( ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _global_attributesk s c C s^ t j � | _ i | _ i | _ t | _ | j rZ i | _ i | _ t
j t � | _
n d S( s� Initialize collections related to CTEs only if
a CTE is located, to save on the overhead of
these collections otherwise.
N( R t OrderedDictR t ctes_by_level_namet level_name_by_cteR� t ctes_recursiveR t cte_positionalt cte_levelR� t defaultdictR* t cte_order( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _init_cte_stateo s c c s� | j | j } } g t | _ | _ z> | j rL | j d } t | d <n d } | j | j f VWd | r} | j d � n | | | _ | _ Xd S( s; special API to support the use case of 'nested result sets'i����t need_result_map_for_nestedN( R� t _ordered_columnsR� R� R� R� R� ( R� t result_columnst ordered_columnst entry( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _nested_result� s
c s7 t j d � � t j d � f d � | j � | _ d S( Ni s
\[_POSITION\]c s t t j � � � S( N( Rl R t next( t m( t poscount( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt <lambda>� R� ( t itertoolst countt ret subR� ( R� ( ( R@ sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR# � s c s' t d � � f d � � j D� D� � S( Nc s s- | ]# \ } } | d k r | | f Vq d S( N( R� ( Rm R t value( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s c 3 s_ | ]U } � j | | j j s4 | j j � j � n t � f d � | j j D� � f Vq d S( c 3 s! | ] } | j � j � Vq d S( N( t _cached_bind_processorR� ( Rm t elem_type( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s N( R R� t _is_tuple_typeRG R� t tuplet types( Rm t bindparam( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( t dictR ( R� ( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _bind_processors� s c C s t | j � d k S( Ni ( t lenR� ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt is_subquery� s c C s | S( N( ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c s� | o t | j � } | r� y | j d } Wn/ t k
r] } t j t j d � d | �n X| j � � f d � t | | � D� } n d } | r�i }
x | j j � D]
\ } } | r� | j j
| | � n | }
| j | k r� | | j |
|
<q� | | k r| | |
|
<q� | rq| j rq| rRt j d | j | f d d �� q�t j d | j d d �� q� | r�| j
| | � } n | } | j r�| j |
|
<q� | j |
|
<q� W|
Si }
x� | j j � D]� \ } } | r�| j j
| | � n | }
| r\| j r\| r=t j d | j | f d d �� q\t j d | j d d �� n | rw| j
| | � } n | } | j r�| j |
|
<q�| j |
|
<q�W|
Sd S(
s5 return a dictionary of bind parameter keys and valuesi sc This compiled object has no original cache key; can't pass extracted_parameters to construct_paramsR� c s0 i | ]& \ } } � | D] } | | � q q S( ( ( Rm R t extractedt bind( R& ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys
<dictcomp>� s s@ A value is required for bind parameter %r, in parameter group %dt codet cd3xs) A value is required for bind parameter %rN( t boolt escaped_bind_namesR� t TypeErrorR R� R
t CompileErrorR t zipR� R t itemst getR t requiredt InvalidRequestErrort callablet effective_valueRF ( R� R� t
_group_numbert _checkR� R� t has_escaped_namest orig_extractedR� t resolved_extractedt pdRL R� t escaped_namet value_param( ( R& sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � sz
c s� t | d � s d S| j � | j j � � d k rU � d k rU � � f d � } n � � � � f d � } i } | j } xn | j D]c } | | k r� q� n | j j r� g | j j D] } | | � ^ q� | | <q� | | j � | | <q� W| S( NR c s | j � � j � � } | S( N( t dialect_implt get_dbapi_type( t typt dbtype( t dbapiR� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _lookup_typeJ s c s� | j � � } | j � � j � � } | d k r� � d k s] | � k r� t | � � k r� � d k s� | � k s� t | � � k r� | Sd Sd S( N( t _unwrapped_dialect_implRh Ri R� R� ( Rj Rh Rk ( Rl R� t
exclude_typest
include_types( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRm P s ( t hasattrR� R� Rl t literal_execute_paramsR R� RI RK ( R� Rp Ro Rm t
inputsizesRr RL Rj ( ( Rl R� Ro Rp sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _get_set_input_sizes_lookup7 s ,c C s | j d t � S( s� Return the bind param dictionary embedded into this
compiled object, for those values that are present.
.. seealso::
:ref:`faq_sql_expression_string` - includes a usage example for
debugging use cases.
Ra ( R� R� ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� z s c sj | d k r! | j d t � } n i } | j r9 g } n d } | j � i } | j ro | j ro t d � � n i � i } x�| j r� | j n | j j � D]�� | j
r� | j
j � � � n � } | j � } | | j
k r| � k r� | j | d | j | � �� | <q� q� n | | j k r@| � k rB| | } nD | j � � }
| j } | | | |
� \ } } | | | <| � | <| j sY| j | � | j j r�| j � � f d � t |
d � D� � n | j � � f d � | D� � | j r| j d � | D� � n g | D] \ }
} |
^ q | � <qYq� | j r� | j � � q� q� W� f d � } t j | j | | j � } t | | | | | � } | rf| j | _ | j j | j � | j | _ t � | _ x� | j! D]y } | j j | � } | j j | � xN t" | j# | j! | � D]3 \ } } | j$ | � | j | <} | | j | <q(Wq�Wn | S(
s� handle special post compile parameters.
These include:
* "expanding" parameters -typically IN tuples that are rendered
on a per-parameter basis for an otherwise fixed SQL statement string.
* literal_binds compiled with the literal_execute flag. Used for
things like SQL Server "TOP N" where the driver does not accommodate
N as a bound parameter.
R� s\ 'post-compile' bind parameters are not supported with the 'numeric' paramstyle at this time.t render_literal_valuec 3 sz | ]p \ } } t | d � D]T \ } } � � k r � � | d d k r d � | | f � � | d f Vq q d S( i s %s_%s_%sN( t enumerateR� ( Rm t it
tuple_elementt jRF ( R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s i c 3 s1 | ]' \ } } � � k r | � � f Vq d S( N( ( Rm R RF ( R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s c s s | ] \ } } | Vq d S( N( ( Rm R� RF ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s c s� | j d � } � | } | j d � r� | j d � j d � } | d | d � � d j � � f d � | j d � D� � } n | S( Ni i s ~~i s , c 3 s" | ] } d � | � f Vq d S( s %s%s%sN( ( Rm t exp( t be_leftt be_right( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr> s ( R7 t splitRA ( R? R t exprt tok( t replacement_expressions( R{ R| sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt process_expanding s
N(% R� R� R� R RN R R� R� R t valuesRV R[ R Rr t render_literal_bindparamR� t post_compile_paramst$ _literal_execute_expanding_parametert literal_executeR R� RI Rv t extendt appendRD RE t _post_compile_patternR� R� R� R� t frozensetR� RY RF t _with_value( R� t
parametersR t expanded_parametersR� t new_processorst to_update_setsRf t parametert to_updateR� t leept replacement_exprt
expand_keyRF R� R� t expanded_stateR RR t expanded_keyt new_param( ( R� R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR% � s� %
) s sqlalchemy.engine.cursorc C s t j j } | j j | j � S( s( utility method used for unit tests only.( R t preloadedt
engine_cursort CursorResultMetaDatat _create_description_match_mapR� ( R� t cursor( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _create_result_map3 s c C s | j d } | S( Ni ( t _key_getters_for_crud_column( R� t getter( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _within_exec_param_key_getter; s
s sqlalchemy.engine.resultc s� t j j } | j } | j j } g | j D]' } t j d | | � d � | f ^ q+ � | j
� � d k r� � j j | j
d � � n d � | j g | j D] } | j ^ q� � � � � � � f d � } | S( NR[ c se � d k r � � � � n � d k rA � � f d � � D� � S� � � � f d � � D� � Sd S( s given cursor.lastrowid value and the parameters used for INSERT,
return a "row" that represents the primary key, either by
using the "lastrowid" or by extracting values from the parameters
that were sent along with the INSERT.
c 3 s! | ] \ } } | � � Vq d S( N( ( Rm R� R� ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>c s c 3 s3 | ]) \ } } | � k r! � n | � � Vq d S( N( ( Rm R� R� ( t autoinc_colt lastrowidR� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>f s N( R� ( R� R� ( R� t getterst proct row_fn( R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR[ X s ( R R� t
engine_resultR� R� R` t primary_keyt operatort methodcallerR� t _autoincrement_columnR� t _cached_result_processorR� t result_tupleR ( R� t resultt param_key_getterR` R� R[ ( ( R� R� R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt+ _inserted_primary_key_from_lastrowid_getter@ s 4 (c s� t j j } | j } | j j } d � t | j � D� } g | j D]L } | | k ro t j
| | � t f n t j d | | � d � t f ^ qD � | j g | j D] } | j ^ q� � � � � f d � } | S( Nc S s i | ] \ } } | | � q S( ( ( Rm t idxR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys
<dictcomp>t s R[ c s � � � f d � � D� � S( Nc 3 s3 | ]) \ } } | r! | � � n | � � Vq d S( N( ( Rm R� t use_row( R� t row( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( ( R� R� ( R� R� ( R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR[ � s ( R R� R� R� R� R` Rv R R� R� t
itemgetterR� R� R� R� R� R ( R� R� R� R` t retR� R[ ( ( R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt+ _inserted_primary_key_from_returning_getterl s Y(c C s d S( s� Called when a SELECT statement has no froms, and no FROM clause is
to be appended.
Gives Oracle a chance to tack on a ``FROM DUAL`` to the string output.
R� ( ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt default_from� s c K s d | j j | | � d S( Nt (t )( R� R� ( R� t groupingt asfromR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_grouping� s c K s d | j j | | � d S( NR� R� ( R� R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_select_statement_grouping� s c
K s� | j r� | j j r� | j d d } | j \ } } } | rG | } n | } | j j } | d k r� | j | k r� | j | | j � r� | j j | d <q� n | j | j d | | �S( Ni����R� t render_label_as_labelt within_columns_clause(
R� R� t supports_simple_order_by_labelt _label_resolve_dictR� t _order_by_label_elementR� R� t shares_lineageR� (
R� R� R� R� R� t with_colst
only_fromst only_colst resolve_dictt
order_by_elem( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_label_reference� s c
K s� | j s | j | j � S| j d d } | j \ } } } y' | rU | | j } n
| | j } Wn8 t k
r� } t j | j d d d t j d | �n! X| | d <| j | d | | �Sd S( Ni����R� t extrasE Can't resolve label reference for ORDER BY / GROUP BY / DISTINCT etc.t exc_clsR� R� R� (
R� R� t _text_clauseR� R� t KeyErrorR t _no_text_coercionR
RX (
R� R� R� R� R� R� R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_textual_label_reference� s"
c K s | o
| } | | k } | s% | r^ t | j t j � rR | j d | j � }
q^ | j }
n | r� | d k r� | |
| j | |
f | j | | j � n | j j | d t
d t
| �t t j
| j j | |
� S| r� | j j | |
� S| j j | d t | �Sd S( Nt colidentR� t within_label_clause( t
isinstanceR� R t _truncated_labelt _truncated_identifierR� R� R� R� R� R� t OPERATORSR t as_R� t format_labelR� ( R� R� t add_to_result_mapR� R� R� t result_map_targetsR� t render_label_with_ast render_label_onlyt labelname( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_label� s$
= c C s t j d � � d S( Ns: Cannot compile Column object until its 'name' is assigned.( R
RX ( R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _fallback_column_name s c K s | j } | j | | � S( N( t _resolvedR� ( R� R� R� t sql_element( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_lambda_element s c K s� | j } } | d k r+ | j | � } n | j } | rb t | t j � rb | j d | � } n | d k r� | | | j f | } | j r� | | j f 7} n | | | | | j
� n | r� | j | � } n | j j
| � } | j }
|
d k s | s |
j r
| S| j j |
� } | r>| j j | � d } n d } |
j }
t |
t j � rt| j d |
� }
n | | j j
|
� d | Sd S( NR� t .R� t alias( R� R� R� t
is_literalR� R R� R� R t _tq_labelR� t escape_literal_columnR� t quoteR` t named_with_columnt schema_for_objectt quote_schema( R� R R� t
include_tableR� R� R� t orig_nameR� t targetsR` t effective_schemat
schema_prefixt tablename( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_column s2
c K s | j j | j � S( N( R� t format_collationt collation( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_collationF s c K s | j S( N( R� ( R� t
fromclauseR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_fromclauseI s c K s | j S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_indexL s c K s0 | | d <| j | d <| j j j | j | � S( Nt type_expressionR� ( R� R� t
type_compilerR� R� ( R� t
typeclauseR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_typeclauseO s
c C s% | j j r! | j d d � } n | S( Nt %s %%( R� t _double_percentst replace( R� t text( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt post_process_textT s c C s% | j j r! | j d d � } n | S( NR� s %%( R� R� R� ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� Y s c sw � � � f d � } � j s* t � _ n | rL | d d � f t j � n t j d � t j | � j � j
� � � S( Nc sI | j d � } | � j k r5 � j � j | � � S� j | � � Sd S( Ni ( R7 t _bindparamsR� t bindparam_string( R? R� ( R� R� t
textclause( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt do_bindparam_ s c S s
| j d � S( Ni ( R7 ( R? ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRA q R� ( R� R� t isplaintextR� R t NULLTYPEt BIND_PARAMS_ESCRE t BIND_PARAMSR� R� ( R� R R� R� R ( ( R� R� R sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_textclause^ s c
K s� | j } | r | j n
| j d } i t � d 6t � d 6| d 6} | j j | � | j r� x$ | j D] } | j | | � qj Wn | p� | d k r� | j d t � p� | j d t � } | r%| j | _ | _
| j o� t | j � | _
x0 | j D]" }
| j |
d t d | j �q� Wn | j | j | � } | j r�| sXt | j � n d } | j d
| d | j d � � | } n | j j d � | S( Ni����t correlate_fromst asfrom_fromsR i t need_result_map_for_compoundR8 R� R� t
nesting_levelt visiting_cte( R� t _default_stack_entryR\ R� t _independent_ctesR� R[ R� R R9 t _textual_ordered_columnsRU t column_argst _loose_column_name_matchingR� R� t _add_to_result_mapR� R RO R� t _render_cte_clauseR� (
R� t taft compound_indexR� R� t toplevelR< t new_entryt ctet populate_result_mapt cR� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_textual_selectw s@
c K s d S( Nt NULL( ( R� R~ R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_null� s c K s | j j r d Sd Sd S( NRd t 1( R� t supports_native_boolean( R� R~ R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_true� s c K s | j j r d Sd Sd S( NR0 t 0( R� R ( R� R~ R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_false� s c s* | j d � � � f d � | D� D� � S( Nc s s | ] } | r | Vq d S( N( ( Rm t s( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s c 3 s! | ] } | j � � � Vq d S( N( R� ( Rm R ( R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( RA ( R� R t separatorR� ( ( R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _generate_delimited_list� s c s� t j j t j t j j t j j | � \ } } | d k rP | d j � � � St t j } | j
d � � � f d � | D� D� � Sd S( Ni i c s s | ] } | r | Vq d S( N( ( Rm R$ ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s c 3 s! | ] } | j � � � Vq d S( N( R� ( Rm R ( R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( R t BooleanClauseListt _process_clauses_for_booleanR t and_t True_t
_singletont False_R� R� RA ( R� t clausesR� t lccR% ( ( R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _generate_delimited_and_list� s
c K s d | j | | � S( Ns (%s)( t visit_clauselist( R� t
clauselistR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_tuple� s c K sA | j } | d k r d } n
t | j } | j | j | | � S( Nt ( R� R� R� R& R- ( R� R1 R� t sep( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR0 � s
c K s� d } | j d k r5 | | j j | | � d 7} n xI | j D]> \ } } | d | j | | � d | j | | � d 7} q? W| j d k r� | d | j j | | � d 7} n | d 7} | S( Ns CASE R3 s WHEN s THEN s ELSE t END( RF R� R� t whenst else_( R� t clauseR� Rn t condR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_case� s 3!
c K s | j j | | � S( N( t typed_expressionR� ( R� t type_coerceR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_type_coerce� s c K s, d | j j | | � | j j | | � f S( Ns CAST(%s AS %s)( R8 R� R� ( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_cast� s c K s* d | d t j k r d nx | d t j k r5 d n_ | d d k rq d | j t j t | d � � | � f n# d | j t j | d � | � f | d t j k r� d nx | d t j k r� d n_ | d d k rd | j t j t | d � � | � f n# d | j t j | d � | � f f S( Ns %s AND %si s UNBOUNDED PRECEDINGs CURRENT ROWs %s PRECEDINGs %s FOLLOWINGi s UNBOUNDED FOLLOWING( R t RANGE_UNBOUNDEDt
RANGE_CURRENTR� t literalt abs( R� t range_R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _format_frame_clause s < <c
K s� | j j | | � } | j r: d | j | j | � } n+ | j r_ d | j | j | � } n d } d | d j g d | j f d | j f f D]@ \ } } | d k r� t | � r� d | | j | | � f ^ q� | r� | g n g � f S( Ns RANGE BETWEEN %ss ROWS BETWEEN %ss %s OVER (%s)R3 t PARTITIONt ORDERs %s BY %s(
R� R� RC RD t rowsR� RA t partition_byt order_byRO ( R� t overR� R� RC t wordR8 ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_over s 7c K s, d | j j | | � | j j | | � f S( Ns %s WITHIN GROUP (ORDER BY %s)( R� R� RI ( R� t withingroupR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_withingroup7 s c K s, d | j j | | � | j j | | � f S( Ns %s FILTER (WHERE %s)( t funcR� t criterion( R� t
funcfilterR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_funcfilter= s c K s8 | j j | j | j � } d | | j j | | � f S( Ns EXTRACT(%s FROM %s)( t extract_mapR[ t fieldR~ R� ( R� t extractR� RT ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_extractC s c K s5 | j | j | � } | j | | � } d | | f S( Ns (%s).%s( t visit_functiont fnR� ( R� R� R� t compiled_fnt compiled_col( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_scalar_function_columnJ s c K s~ | d k r+ | | j | j d | j � n t | d | j j � d � } | rb | | | � } nt j | j � j d � } | r� | j r� | d 7} q� nO | j } | j
j | � s� t | t
j � r� | j
j | � n | } | d } d j g | j D]B } | j
j | � s%t | t
j � r7| j
j | � n | ^ q� | g � i | j | | � d 6} | j rz| d 7} n | S( Ns
visit_%s_funcs %(expr)sR� R~ s WITH ORDINALITY( ( R� R� R� t getattrt lowert FUNCTIONSR[ t _deannotatet __class__t _has_argsR� t _requires_quotes_illegal_charsR� R R R� RA t packagenamest function_argspect _with_ordinality( R� RO R� R� t dispR� R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRW O s, $
L
c K s | j | j � S( N( t visit_sequencet sequence( R� t
next_valueR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_next_value_funcu s c K s t d | j j � � d S( Ns2 Dialect '%s' does not support sequence increments.( R� R� R� ( R� Rh R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRg x s c K s | j j | | � S( N( t clause_exprR� ( R� RO R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRd ~ s c s � j } | j | � � � } | r; � j r; | � _ n | j } | rS � j n
� j d } | p| | o| | j d t � } | d k r� | | d <n � j j i | d d 6| d d 6| d 6| d 6| d 6� | j rx$ | j D] }
|
j � � � q� Wn � j
j | j � } d | d j � � � f d
� t
| j � D� � } t � d <| � j | t d � � � � 7} | � j | � � 7} | j r�| � j | � � 7} n � j r| s�t � j � n d }
� j d
|
d t d � j d � � | } n � j j d � | S( Ni����R i t select_0R R
R R� R3 c 3 s3 | ]) \ } } | j � d � d | � �Vq d S( R� R N( R� ( Rm Rw R ( R� R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s R� R� R t include_following_stackR
( R� t _compile_state_factoryR� R� R R[ R� R� R R� t compound_keywordst keywordRA Rv t selectst group_by_clauseRM t order_by_clauset _has_row_limiting_clauset _row_limit_clauseR RO R� R R� R� ( R� t csR� R R� R R� t
compound_stmtR< t need_result_mapR Rp R� R ( ( R� R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_compound_select� sN
"
c K s3 | j d k r | j | | � S| j | | � Sd S( N( t
_fetch_clauseR� t fetch_clauset limit_clause( R� Rv R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRu � s c C s6 d | j | | r d | n d f } t | | d � S( Ns
visit_%s_%s%st _R� ( R� R\ R� ( R� t operator_t
qualifier1t
qualifier2t attrname( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _get_operator_dispatch� s
c K s | d k r0 | | f 7} | | d <| | d <n | j r� | j rT t j d � � n | j | j d d � } | r� | | | j | � S| j | t | j | � Snf | j r� | j | j d d � } | r� | | | j | � S| j | t | j | � Sn t j d � � d S( NR� R� sF Unary expression does not support operator and modifier simultaneouslyt unaryR� t modifiers, Unary expression has no operator or modifier( R� R� R� R
RX R� t _generate_generic_unary_operatorR� t _generate_generic_unary_modifier( R� R� R� R� R� Rf ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_unary� s.
c K sC | j s | j j r( | j | j | � Sd | j | j | � Sd S( Ns %s = 1( t _is_implicitly_booleanR� R R� R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_is_true_unary_operator� s c K sG | j s | j j r, d | j | j | � Sd | j | j | � Sd S( Ns NOT %ss %s = 0( R� R� R R� R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_is_false_unary_operator s c K s d | j | d t j �S( Ns NOT %st override_operator( t visit_binaryR t match_op( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_not_match_op_binary s c K s d | j | t | | � S( Ns (%s)( t _generate_generic_binaryR� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_not_in_op_binary s c C s� | t j k rC t | � d k r< d d j d � | D� � Sd SnP | t j k r� t | � d k r d d j d � | D� � Sd Sn
| j | � Sd S( Ni s (%s)) OR (1 = 1s , c s s | ] } d Vq d S( R N( ( Rm R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr> s s NULL) OR (1 = 1s (%s)) AND (1 != 1c s s | ] } d Vq d S( R N( ( Rm R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr># s s NULL) AND (1 != 1( R t not_in_opRO RA t in_opt visit_empty_set_expr( R� R� t expand_op( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_empty_set_op_expr s c C s t d | j j � � d S( Ns3 Dialect '%s' does not support empty set expression.( R� R� R� ( R� t
element_types( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� * s c s� � j j � j � } | sv | j rX � j j r6 d n d � j � j j � j � } q�� j � j g � j � } n[| j s� | j rt | d t
j j � rt | d t
j
t
j � r| j r� t d � � n � j j r� d n d d j � � f d � t | � D� � } n� | r�� j } | j | � } | rK| j d � sWt d � � | j d � j d � } | d
| d � � d j � � � � f d � | D� � } n" d j � � f d
� | D� � } d | f S( Ns VALUES R� i s? bind_expression() on TupleType not supported with literal_bindss , c 3 sG | ]= \ } } d d j � f d � t | � j j � D� � Vq d S( s (%s)s , c 3 s' | ] \ } } � j | | � Vq d S( N( Ru ( Rm RF t
param_type( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>[ s N( RA RY R� RK ( Rm Rw Rx ( R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>X s i s) unexpected format for expanding parameters ~~i i c 3 s1 | ]' } d � � j | � j � � f Vq d S( s %s%s%sN( Ru R� ( Rm RF ( R{ R| R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>n s c 3 s$ | ] } � j | � j � Vq d S( N( Ru R� ( Rm RF ( R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>x s ( ( R� Rn R� RI t tuple_in_valuesR� RK R� t _isnullR� R t collections_abct Sequencet string_typest binary_typest _has_bind_expressionR� RA Rv R� t searchR7 t AssertionErrorR} ( R� R� R� t bind_expression_templatet typ_dialect_implt replacement_expressiont post_compile_patternR? R ( ( R{ R| R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt2 _literal_execute_expanding_parameter_literal_binds0 sF
c
s� | j r � j | | � S| j j � j � } | s g � | j ra � j | j j | j � } q�� j | j g | j � } nH| j s� | j rpt
| d t j j
� rpt
| d t j t j � rp| j s� t � g t | d � D]A \ } } t | d � D]% \ } } d | | | f | f ^ qq� � � j j rAd n d d j � � f d � t | � D� � } nW g t | d � D]" \ } } d | | f | f ^ q�� d j � f d � � D� � } � | f S(
Ni i s %s_%s_%ss VALUES R� s , c 3 sG | ]= \ � � d d j � � � � f d � t � � D� � Vq d S( s (%s)s , c 3 s? | ]5 \ } } � j i � � t � � | d d 6Vq d S( i R� N( R RO ( Rm Ry RF ( Rw R� R� Rx ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s N( RA Rv ( Rm ( R� R� ( Rw Rx sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s s %s_%sc 3 s) | ] \ } } � j i | d 6Vq d S( R� N( R ( Rm R RF ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( R� R� R� Rn R� RI R� RK R� R� R� R R� R� R� R� t _is_arrayR� Rv R� RA (
R� R� R� R� R� R� Rw Rx Ry RF ( ( R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� ~ s:
;5c K sr | r� t j | j � r� | d k rg | d } | j j t j | j j | g | j
j | g � � q� | j j t j | j j | j
j � � n | j r� t | j t
j � r� t | j
t
j � r� t | d <n | p� | j } | j | d d � } | r | | | | � Sy t | }
Wn2 t k
rN} t j t j | | � d | �n X| j | |
d | d | | �Sd S( Nt enclosing_lateralR� R R� t from_lintert lateral_from_linter( R t
is_comparisonR� R� R� R RB t productRC t
_from_objectsRY t ansi_bind_rulesR� R t
BindParameterR� R� R� R� R R� R
R� R� ( R� R R� t eager_groupingR� R� R� R� R~ Rf t opstringR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s<
c K s | j | j | � S( N( R� t sql_function( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt& visit_function_as_comparison_op_binary� s c K sd | j j r6 | j | j | � d | j | j | � S| j | j | � d | j | j | � Sd S( Ns %% s % ( R� R� R� RC RY ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_mod_binary� s *c K s4 | j | d <| j | d | j | j � d | � S( NR� R3 ( R� R� R� R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_custom_op_binary� s
c K s# | j | | j | j � d | � S( NR3 ( R� R� R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_custom_op_unary_operator s c K s# | j | d | j | j � | � S( NR3 ( R� R� R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_custom_op_unary_modifier s c K s~ | j d t � } t | d <| j | d <| j j | d | | �| | j j | d | | �} | rz | rz d | } n | S( Nt
_in_binaryt
_binary_opR� s (%s)( R[ R� R� R� RC R� RY ( R� R R� R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s
%
c K s | | j j | | � S( N( R� R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� ' s c K s | j j | | � | S( N( R� R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� * s c C s t j d d t j �S( Ns '%'R� ( R t literal_columnR t
STRINGTYPE( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _like_percent_literal- s c K sF | j � } | j } | j | j � j | � | _ | j | | | � S( N( t _cloneR� t concatRY t visit_like_op_binary( R� R R� R� t percent( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_contains_op_binary1 s c K sF | j � } | j } | j | j � j | � | _ | j | | | � S( N( R� R� R� RY t visit_not_like_op_binary( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_not_contains_op_binary7 s c K s= | j � } | j } | j | j � | _ | j | | | � S( N( R� R� t _rconcatRY R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_startswith_op_binary= s c K s= | j � } | j } | j | j � | _ | j | | | � S( N( R� R� R� RY R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_not_startswith_op_binaryC s c K s= | j � } | j } | j | j � | _ | j | | | � S( N( R� R� R� RY R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_endswith_op_binaryI s c K s= | j � } | j } | j | j � | _ | j | | | � S( N( R� R� R� RY R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_not_endswith_op_binaryO s c K sd | j j d d � } d | j j | | � | j j | | � f | r_ d | j | t j � n d S( Nt escapes
%s LIKE %ss ESCAPE R� ( t modifiersR[ R� RC R� RY Ru R R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� U s c K sd | j j d d � } d | j j | | � | j j | | � f | r_ d | j | t j � n d S( NR� s %s NOT LIKE %ss ESCAPE R� ( R� R[ R� RC R� RY Ru R R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� b s c K sd | j j d d � } d | j j | | � | j j | | � f | r_ d | j | t j � n d S( NR� s lower(%s) LIKE lower(%s)s ESCAPE R� ( R� R[ R� RC R� RY Ru R R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_ilike_op_binarym s c K sd | j j d d � } d | j j | | � | j j | | � f | r_ d | j | t j � n d S( NR� s lower(%s) NOT LIKE lower(%s)s ESCAPE R� ( R� R[ R� RC R� RY Ru R R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_not_ilike_op_binaryx s c K s4 | j j d t � } | j | | r* d n d | � S( NR_ s BETWEEN SYMMETRIC s BETWEEN ( R� R[ R� R� ( R� R R� R� R_ ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_between_op_binary� s c K s4 | j j d t � } | j | | r* d n d | � S( NR_ s NOT BETWEEN SYMMETRIC s
NOT BETWEEN ( R� R[ R� R� ( R� R R� R� R_ ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_not_between_op_binary� s
c K s t j d | j j � � d S( Ns/ %s dialect does not support regular expressions( R
RX R� R� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_regexp_match_op_binary� s c K s t j d | j j � � d S( Ns/ %s dialect does not support regular expressions( R
RX R� R� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_not_regexp_match_op_binary� s c K s t j d | j j � � d S( Ns; %s dialect does not support regular expression replacements( R
RX R� R� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_regexp_replace_op_binary� s c
K sk | s� | j j | j � } | j r� | j | � } | j | d t d | d | oX | j d | d | | �}
| j r� t j d |
� } | s� t
d � � d | j d � | j d
� | j d � f }
| r� | j | d t d |
| �} d
| Sn |
Sn | s4| p | j
p | o | j } | p.| j }
n t }
| rr| j | d t | �} | j rnd
| } n | S| j | � } | | j k rb| j | } | | k rb| j s�| j r�| j j | j � r�| j j | j � r�t j d | � � q_| j | j k r(t j d | f � � q_| j s:| j r_t j d | j | j f � � q_qbn | | j | j <| j | <| j } | r�xD | j D]6 } | j | k r�| | j } | | j | � q�q�Wn | j r�t | _ n |
r0| r t | _ n | r| j | h O_ q0| j | h O_ n | j! | d |
d | j | �} | j rgd
| } n | S( Nt skip_bind_expressionR� t
literal_bindsR� t render_postcompiles& ^(.*)\(__\[POSTCOMPILE_(\S+?)\]\)(.*)$s) unexpected format for expanding parameters$ (__[POSTCOMPILE_%s~~%s~~REPL~~%s~~])i i i R� s (%s)sI Bind parameter '%s' conflicts with unique bind parameter of the same names Can't reuse bound parameter name '%s' in both 'expanding' (e.g. within an IN expression) and non-expanding contexts. If this parameter is to receive a list/array value, set 'expanding=True' on it for expressions that aren't IN, otherwise use a different parameter name.s� bindparam() name '%s' is reserved for automatic usage in the VALUES or SET clause of this insert/update statement. Please use a name other than column name when using bindparam() with insert() or update() (for example, 'b_%s').t post_compilet expanding(" R� Rh R� R� t bind_expressionR� R� R� RD t matchR� R7 R� R� R� R� t _truncate_bindparamR Rf R� t intersectiont _cloned_setR
RX t _is_crudR R R� t
isoutparamt has_out_parametersR$ Rr R� R ( R� RL R� R� R� R� R� R� t implR� t wrappedR? R� R� R� t existingR& t bpt cb( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_bindparam� s�
c
K s� | t k r | } n� | j d k r� | j d k r� | j d d � } | r| | t j t j f k r| t j d | j
f � n | j t j
| � S| j } | j r� | j } | | | d | �\ } } | S| j | | j � Sd S( NR� s� Bound parameter '%s' rendering literal NULL in a SQL expression; comparisons to NULL should not use operators outside of 'is' or 'is not'R� ( R
RF R� R^ R[ R t is_t is_notR t warn_limitedR R� R R R_ R� R� Ru R� (
R� RL Ru R� R� RF t opR� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� 3
s$ c C s� | j | j � } | rn y | | � SWq� t k
rj } t j t j d t j | � | f � d | �q� Xn" t j d t j | � | f � � d S( s Render the value of a bind parameter as a quoted literal.
This is used for statement sections that do not accept bind parameters
on the target driver/database.
This should be implemented by subclasses using the quoting services
of the DBAPI.
s] Could not render literal value "%s" with datatype %s; see parent stack trace for more detail.R� sN No literal value renderer is available for literal value "%s" with datatype %sN( t _cached_literal_processorR� t ExceptionR R� R
RX t sql_utilt _repr_single_value( R� RF R� t processort e( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRu T
s
c C s[ | | j k r | j | S| j } t | t j � rJ | j d | � } n | | j | <| S( NRL ( R R R� R R� R� ( R� RL t bind_name( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� z
s
c C s� | | f | j k r& | j | | f S| j | j � } t | � | j d k r� | j j | d � } | d t | j d d � !d t | � d } | d | j | <n | } | | j | | f <| S( Ni i i R} i ( R t apply_mapR RO R R[ t maxt hex( R� t ident_classR� t anonnamet countert truncname( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� �
s /c C s | | j S( N( R ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
_anonymize�
s c K s� | j rN | d k r% | j | � n | j j | � t | j � | j | <n | s� t j | � r� t j d � | � } | } | } q� n | r� | j
s� i | _
n | | j
| <n | r� d | S| j i | d 6Sd S( Nc S s t | j d � S( Ni ( t _BIND_TRANSLATE_CHARSR7 ( R? ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRA �
R� s __[POSTCOMPILE_%s]R� ( R R� R� R� RO R� R t _BIND_TRANSLATE_RER� RE RV R ( R� R� t positional_namesR� R� t escaped_fromR� t new_name( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR �
s&
c s9 � j � | | d <| j } t | t j � rD � j d | � } n t } t }
| j � } | � j k r� � j | \ } }
|
| k s� t
� n | j r� t � j
� n d } | | f } | � j k r�� j | } | | k }
| | j k s | | k r t } q�| | j k r;� j | =| j � } � j | =q�| j d k sY| j d k rq| j | � rqt } q�t j d | � � n | r�| r�d S| j d k r�| j } | j j } t | t j � r�� j d | � } q�n | } d } | r�| � j | <| � j | <d | j j k r]d � j k r]� j j i | j j d d 6� � _ n � j rv| � j | <n | � j k r�� j | | � n | r�| � j k r�| j r�t � _ n � j j! | | � } | j r�t | j t" j# � r| j } n: t | j t" j$ � r*| j j% d } n t s<t
d � � g | j& t � D]' \ }
} } } } | sL| pp| ^ qL} | d d j' � f d
� | D� � 7} n � j r�g | d <� j( | <n | j) d t � t k s�t
� � j
s| j j* � d
| | �S� j+ | | j, | � } | j j* � d
t | �} | d | | f 7} | j- rw| d � j+ | | j- | � 7} n | � j | <q�n | r5| r�| | j. | <n | r�|
r�� j j! | | � S| r � j j! | | � } � j j/ | � r� j j0 | � } n | � j1 | � 7} | S� j j! | | � Sn d S( NR
R� i s5 Multiple, unrelated CTEs found with the same name: %rt
autocommiti s% cte should only be against SelectBases (%s)s , c 3 s* | ] } � j j | d � j �Vq d S( R N( R� t format_label_nameR ( Rm t ident( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>K s R� t subqueryR� s AS %s
(%s)R3 (2 R7 R� R� R R� R� R� R� t _get_reference_cteR1 R� t nestingRO R� R0 t _restatesR t _is_clone_ofR� t compareR
RX t
_cte_aliasR� R� R� Re R R4 t visit_ctet recursiveR2 R� t format_aliasR t Selectt CompoundSelectRq t _generate_columns_plus_namesRA R3 R[ R� t _generate_prefixest _prefixest _suffixesR� t _requires_quotesR� t get_render_as_alias_suffix( R� R R� t ashintt fromhintsR
R� R� t cte_namet
is_new_ctet embedded_in_current_named_ctet _reference_cteR4 R} t cte_level_namet existing_ctet existing_cte_reference_ctet
pre_alias_ctet cte_pre_alias_nameR� t
col_sourcet
proxy_namet fallback_label_nameR t repeatedt
recur_colst prefixesR< ( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR �
s�
"
c K sC | j r d | d <n | j r/ | j | | � S| j | | � Sd S( NR� ( t joins_implicitlyR� t _is_lateralt
visit_lateralt visit_alias( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_table_valued_alias s
c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_table_valued_column� s c
sN | r\ d � k r. � j s! t � � � d <n | r\ d � k r\ d � k r\ | � d <q\ n | d k r� | j � k r� � j j � d | d | d | d | d | d � � �} | r� | s� | r� d | f } n | S� } � d <| s� | r)t � j t j � r � j d
� j � } q)� j } n | rB� j
j � | � S| r1| r^| | j � <n � j j � d t
d | � �} | r�d | f } n | � j � j
j � | � � }
� j r�� j r�|
d d j � � � f d � � j D� � 7}
n | r-� | k r-� j |
� | � | � }
n |
S� j j � d | � �Sd S(
NR� R� R� R t iscrudR t lateralt enclosing_aliass (%s)R� s , c 3 sV | ]L } d � j j | j � � j rF d � j j j | j � � n d f Vq d S( s %s%ss %sR� N( R� R� R� t _render_derived_w_typesR� R� R� R� ( Rm R� ( R� R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s
( R# R� R� R� R� R� R� R R� R� R� R R� R� R t _supports_derived_columnst _render_derivedRA R t format_from_hint_text( R� R� R� R R( R R� R) R* R� R� R< t
alias_nameR� ( ( R� R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR% � s`
c K s t | d <| j | | � S( NR� ( R� R% ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_subquery� s
c K s t | d <d | j | | � S( NR) s
LATERAL %s( R� R% ( R� t lateral_R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR$ � s
c K sg d | j | d t | �| j � j | | � f } | j d k rc | d | j j | | � 7} n | S( Ns %s TABLESAMPLE %sR� s REPEATABLE (%s)( R% R� t _get_methodR� t seedR� ( R� t tablesampleR� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_tablesample� s c s% � j d � j � d d j � � � f d � � j D� � } t � j t j � rl � j d � j � } n � j } � j r� d } n d } | r!| r� | d k r� | n d | j � <n | rd | | � j � j
j | � � d j � � f d
� � j D� � f } q!d | | f } n | S( NR� s VALUES %ss , c 3 sF | ]< } | D]/ } � j t j d � j | � j � � � Vq
q d S( RK N( R� R t Tuplet
_column_typesR ( Rm t chunkR� ( R� R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr> s R� s LATERAL R� s (unnamed VALUES element)s
%s(%s)%s (%s)c 3 s' | ] } | j � d t � �Vq d S( R� N( R� R� ( Rm R ( R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>& s s %s(%s)( t
setdefaultR� RA t _dataR� R� R R� R� R# R� R� R R� R� t columns( R� R� R� R� R� t vR� R) ( ( R� R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_values s. "c C s d | S( Ns AS ( ( R� t alias_name_text( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR 1 s c C sh | d k s | d k r- t | _ t | _ n | j rH t j d � � n | j j | | | | f � d S( Nt *sx Most backends don't support SELECTing from a tuple() object. If this is an ORM query, consider using the Bundle object.(
R� R� R9 R� t _ad_hoc_textualRI R
RX R� R� ( R� t keynameR� t objectsR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR 4 s c K s. | j d | t t | d k r$ i n | | � S( sL Render a column with necessary labels inside of a RETURNING clause.
This method is provided for individual dialects in place of calling
the _label_select_column method directly, so that the two use cases
of RETURNING vs. SELECT can be disambiguated going forward.
.. versionadded:: 1.4.21
N( t _label_select_columnR� R� R� ( R� t stmtR t column_clause_argsR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _label_returning_column@ s c s� � j j | j � } | j r< | s* | r< | j � � }
n � }
| r� | j } |
ro | � � f d � } q� |
� k r� | � � � f d � } q� n d } | s� t d � � t � t j
� r� |
� k r� t |
� j d � j
f �} q^|
} ne| r8| d k st d � � t |
| d | � j f �} n&|
� k rMt } n� t � t j � r�| o{� j o{� j d k } np t � t j � r�t } nU t � t j � r�� j p�| } n1 t � t j � r�� j d k r�t } n t } | rX| s|
s
t � � j } n t | t j � s7t j | � n | } t |
| d | f �} n |
} | j d | d | � | j | | � S( s. produce labeled columns present in a select().c s � | | d | � d S( N( ( ( RA R� RB R� ( R ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� z s c s � | | � f | | � d S( N( ( RA R� RB R� ( R R ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s sX _label_select_column is only relevant within the columns clause of a SELECT or RETURNINGR� s* proxy_name is required if 'name' is passedR� R� N( R� Rh R� t _has_column_expressiont column_expressionR R� R� R� R t LabelR� R� R� R� R� t ColumnClauseR� R` t
TextClauseR� t UnaryExpressiont wraps_column_expressiont NamedColumnt _non_anon_labelt _anon_name_labelR� R R� ( R� RZ R R R� RE R� R R R� t column_is_repeatedt need_column_expressionsR� t col_exprR� t result_exprt render_with_label( ( R R sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRC U sr
c C s- | j | | � } | r) | d | 7} n | S( NR3 ( t get_from_hint_text( R� t sqltextR` t hintR( t hinttext( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR. � s c C s d S( N( R� ( R� t byfroms( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt get_select_hint_text� s c C s d S( N( R� ( R� R` R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRV
s c C s d S( N( R� ( R� R` R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt get_crud_hint_text
s c C s
d j | � S( NR3 ( RA ( R� t
hint_texts( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt get_statement_hint_text
s R R
c K s� | j } | r | j n
| j d } | j | | � } | d } | d } | r} | r} | j d | j | � d d � }
n | j d | d | � }
|
S( Ni����R R
t explicit_correlate_fromst implicit_correlate_froms( ( R� R Rn t _get_display_fromst
difference( R� t select_stmtR� R) R� R R< R� R R
R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _display_froms_for_select
s
c & s� | d k s t d � � t | d <| j | | | � }
|
j } | j } | rf | j rf |
| _ n | d k pu | } | j r� | j | d | | �}
|
| k r� |
} | } |
} | j | | | � }
|
j } q� n | r� | j n
| j d } | p | j d t � p | j d t � } } | r4t } n | rQd | k rQ| d =n | j
| |
| | | | � } | j � } | j i t d 6t d 6� d } | j
r�| j | � \ } } | r�| | d
7} q�n d } | j r
x$ | j D] } | j | | � q�Wn | j r2| | j | | j | � 7} n | | j | | � 7} g g |
j D]N \ } } } } } | j | | | | | d | d | d
| d | d | �^ qUD] } | d k r�| ^ q�} | r�| d k r�t t g |
j D] \ } } } } } | ^ q�g | j D] \ } } } } } | ^ q� � � g | j D]: \ } } } }! | | t � f d � | D� � |! f ^ q@| _ n | j | | |
| | | | | � } | j rg | j D]* \ }" }# |" d | j j f k r�|# ^ q�}$ |$ r| d
| j |$ � 7} qn | j ri| s&| ri| s;t | j � n d }% | j! d |% d | j d � � | } n | j" r�| d
| j | | j" | � 7} n | j j# d � | S( Nsp SQLAlchemy 1.4 requires use of the translate_select_structure hook for structural translations of SELECT objectsR� R� i����R R8 R� R� s SELECT R3 R� R R RQ RR c 3 s! | ] } � j | | � Vq d S( N( R[ ( Rm t o( t translate( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>�
s R? R R
($ R� R� R� Rn R� R� R� t translate_select_structureR R[ t _setup_select_stackt copyR t _hintst _setup_select_hintsR R� R
R t get_select_precolumnst columns_plus_namesRC RM RY R� RJ t _compose_select_bodyt _statement_hintsR� R� R^ R RO R R R� (& R� Rc R� t insert_intoR R t select_wraps_forR) R� R� R� R t is_embedded_selectt new_select_stmtt compile_state_wraps_forR< R RR R� RE R� t hint_textt byfromR R� R R R R R t
inner_columnsR R� R� t dialect_namet htt per_dialectR ( ( Rf sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_select1
s�
_%.M $
c
C s� t g | j j � D]P \ \ } } } | d | j j f k r | | i | j | d t �d 6f ^ q � } | j | � } | | f S( NR? R R� ( RM Rj RZ R� R� R� R� R[ ( R� RZ R� R� RY Rv Ru ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRk �
s Gc C s6 | d } | d } | d k r- | | d <nf | r� | d } t | j � }
t | j � |
k r� t j d d |
| d t | j � f � � q� n | r� | r� | j d | j | � d d � } n | j d | d | � } t t j | � � } | j
| � }
i | d 6|
d 6| d 6| d
6} | j j | � | S( NR R
i Rl s} All selectables passed to CompoundSelect must have identical numbers of columns; select #%d has %d columns, select #%d has %di R_ R` R R� ( (
RO t _all_selected_columnsRm R
RX Ra Rb R\ R R� Re R� R� ( R� RZ R� R< R� R) R R R
Rl t numcolsR� t new_correlate_fromst all_correlate_fromsR ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRh s>
c
C s, | d j | � 7} | j t @rT t i t � � } | j t @}
| r` | | _ q` n d } t }
| r| d 7} | j r� | d j g | D]* } | j
| d t d | d | | �^ q� � 7} q| d j g | D]$ } | j
| d t d | | �^ q� � 7} n | | j � 7} | j
rO| j | j
d | | �} | rO| d | 7} qOn |
rb| j � n | j r�| | j | | � 7} n | j r�| j | j | � } | r�| d | 7} q�n | j r�| | j | | � 7} n | j r | | j | | � 7} n | j d k r(| | j | | � 7} n | S( Ns , s
FROM R� R R� s
WHERE s
HAVING ( RA R R� R� R\ R� R� R� R� Rj R� R� R� t _where_criteriaR/ R� t _group_by_clausesRr t _having_criteriat _order_by_clausesRs Rt Ru t _for_update_argt for_update_clause(
R� R� RZ R� Rw R� Rv R R� R� t warn_lintingt ft t( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRn B sN
; 5
c s9 d j � � f d � | D� � } | r5 | d 7} n | S( NR3 c 3 sE | ]; \ } } | d k s- | � j j k r | j � � � Vq d S( N( R� R� R� R� ( Rm t prefixRx ( R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( RA ( R� RD R! R� R8 ( ( R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � s
c
s; � j s
d S| r� | d k r� t j � } x� t � j j � � D]g } � j | j � \ } } | | k p | o | | d k } | j o� | s� qA n � j | | | <qA Wn � j } | s� d St g | D] } | j ^ q� � } � j
ry� j | j | � | d k ry� j ry� j d k s+t � � � � f d � � � f d � � � d � }
� � j |
| � � _ qyn � j | � d } | d j g | j � D] } | ^ q�� 7} | d 7} | r7| d k r7x` t | j � � D]I } � j | j � \ } } � j | =� j | | f =� j | j � =q�Wn | S( s�
include_following_stack
Also render the nesting CTEs on the next stack. Useful for
SQL structures like UNION or INSERT that can wrap SELECT
statements containing nesting CTEs.
R� i c s� | � j k r� � j j | � } t t j j � f d � | D� � � } | � j k rz � � j | | � j | d � S| Sn � j j | g � Sd S( Nc 3 s | ] } � | � Vq d S( N( ( Rm t child_cte( t get_nested_positional( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s i ( R6 R� R* RB t chaint
from_iterableR3 R4 R[ ( R t childrent to_add( R� t reorder_positionalR� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s
c sd | s | | Sd } x7 t t | � � D]# \ } } � j | | k r' Pq' q' W| | | | | S( Ni ( Rv t reversedR ( t posR� t levelR� R� ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s R3 s ,
s
N( R R R/ R* t keysR1 R R R R R R6 R� R� R� R� t get_cte_preambleRA R� R0 (
R� R Rm R
R R R4 R t is_rendered_levelR2 R� t cte_textt txt( ( R� R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � sH " ,
c C s | r
d Sd Sd S( Ns WITH RECURSIVEt WITH( ( R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c K s0 | j r t j d d d �n | j r, d Sd S( sc Called when building a ``SELECT`` statement, position is just
before column list.
s DISTINCT ON is currently supported only by the PostgreSQL dialect. Use of DISTINCT ON for other backends is currently silently ignored, however this usage is deprecated, and will raise CompileError in a future release for all backends that do not support this syntax.t versions 1.4s DISTINCT R� ( t _distinct_onR t warn_deprecatedt _distinct( R� RZ R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRl s
c K s5 | j | j t t j | � } | r- d | Sd Sd S( s5 allow dialects to customize how GROUP BY is rendered.s
GROUP BY R� N( R& R� R� R t comma_op( R� RZ R� t group_by( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRr s
c K s5 | j | j t t j | � } | r- d | Sd Sd S( s5 allow dialects to customize how ORDER BY is rendered.s
ORDER BY R� N( R& R� R� R R� ( R� RZ R� RI ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs s
c K s d S( Ns FOR UPDATE( ( R� RZ R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� ( s c C s t j d � � d S( Ns@ RETURNING is not supported by this dialect's statement compiler.( R
RX ( R� RD t returning_cols( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt returning_clause+ s c K s� d } | j d k r5 | d | j | j | � 7} n | j d k r� | j d k r` | d 7} n | d | j | j | � 7} n | S( NR� s
LIMIT s
LIMIT -1s OFFSET ( t
_limit_clauseR� R� t _offset_clause( R� RZ R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR| 1 s
c K s� d } | j d k r5 | d | j | j | � 7} n | j d k r� | d | j | j | � | j d ro d n d | j d r� d n d f 7} n | S( NR� s
OFFSET %s ROWSs
FETCH FIRST %s%s ROWS %sR� s PERCENTt with_tiess WITH TIESt ONLY( R� R� R� Rz t _fetch_clause_options( R� RZ R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR{ ; s c K s� | r | j | j | <n | s% | r� | j j | � } | ro | ro | j j | � d | j j | j � }
n | j j | j � }
| r� | | k r� | j |
| | | | � }
n |
Sd Sd S( NR� R� ( t fullnameR� R� R� R� R� R� R. ( R� R` R� R( R R t
use_schemaR� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_tableK s ,c K s� | r1 | j j t j | j j | j j � � n | j rC d } n | j rU d } n d } | j j | d t
d | | �| | j j | d t
d | | �d | j j | d | | �S( Ns FULL OUTER JOIN s LEFT OUTER JOIN s JOIN R� R� s ON ( R� R RB R� RC R� RY R5 t isouterR� R� t onclause( R� RA R� R� R� t join_type( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_joinl s Nc C s� t g | j j � D]6 \ \ } } } | d | j j f k r | | f ^ q � } | j | k r� | j | | j | | j t � } n | | f S( NR? ( RM Rj RZ R� R� R` R. R� ( R� RD t
table_textR` R� Ru t
dialect_hints( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _setup_crud_hints� s - c
K s� | j | | | � } | j } | j } | rd t | _ | j sL | | _ n | j sd | | _ qd n | j j i t � d 6t � d 6| d 6� t j
| | | | � } | r� | j j r� | j j
r� | j j r� t j d | j j � � n | j r/| j j s"t j d | j j � � n | d } n | } | j } | j j } d } | j rx| | j | | j | � 7} n | d 7} | j | j � }
| j r�| j | |
� \ } }
n | j r�x$ | j D] } | j | | � q�Wn | |
7} | s�| r5| d d
j g | D] \ }
} } | ^ q� 7} n | j sG| j r�| j | | j p_| j � } | j! r�| d | 7} q�n d } | j# d k r3| j$ | j d d
d t | �} | j% r"| j j& r"| s�t' | j � n d } | d | j( d | d t d | j) d � � | f 7} q�| d | 7} n� | rM| rM| d 7} nx | j rz| d d
j d � | D� � 7} nK d
j g | D] \ }
} } | ^ q�� } | d | 7} | r�| | _* n | j+ d k r| j$ | j+ | � } | r| d | 7} qn | r$| j! r$| d | 7} n | j% r�| j j& r�| sOt' | j � n d } | j( d | d t d | j) d � � | } n | j j, d � | S( NR R
R sW The '%s' dialect with current database version settings does not support empty inserts.sc The '%s' dialect with current database version settings does not support in-place multirow inserts.i s INSERT s INTO s (%s)s , R3 i����t insert_from_selectRp s %s%sR Rm R
s %ss DEFAULT VALUESs
VALUES %sc s s, | ]" } d d j d � | D� � Vq d S( s (%s)s , c s s | ] \ } } } | Vq d S( N( ( Rm R R~ RF ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr> s N( RA ( Rm t crud_param_set( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr> s s VALUES (%s)(- Rn R� R� R� R R� R� R� R\ R t _get_crud_paramsR� t supports_default_valuest supports_default_metavaluet supports_empty_insertR
RX R� t _has_multi_parameterst supports_multivalues_insertR� R
R t format_tableR` Rj R� R R� RA R R R� t returning_precedes_valuesR� RZ R� R t cte_follows_insertRO R R[ t insert_single_values_exprt _post_values_clauseR� ( R� t insert_stmtR� R� R t crud_paramst crud_params_singleR� R� R� R� R} R R R~ RF R� t select_textR R� t post_values_clause( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_insert� s�
*
%
c C s d S( s3 Provide a hook for MySQL to add LIMIT to the UPDATEN( R� ( R� t update_stmt( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt update_limit_clause, s c K s t | d <| j | d t | �S( s| Provide a hook to override the initial table clause
in an UPDATE statement.
MySQL overrides this.
R� R( ( R� R� ( R� R� t
from_tablet extra_fromsR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt update_tables_clause0 s
c K s t d � � d S( s~ Provide a hook to override the generation of an
UPDATE..FROM clause.
MySQL and MSSQL override this.
sC This backend does not support multiple-table criteria within UPDATEN( R� ( R� R� R� R� t
from_hintsR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt update_from_clause: s c K sy | j | | | � } | j } | j } | rd t | _ | j sL | | _ n | j sd | | _ qd n | j } t | � } | r� t t
j | j � � } g | D] } | | k r� | ^ q� } | j
| � }
n g } | j h }
| j j i |
d 6|
d 6| d 6� d } | j r3| | j | | j | � 7} n | j | | j | | � } t j | | | | � }
| j r�| j | | � \ } } n d } | j r�x$ | j D] } | j | | � q�Wn | | 7} | d 7} | d j d � |
D� � 7} | j s| j r8| j r8| d | j | | j p*| j � 7} q8n | rv| j | | j | | | � } | rv| d | 7} qvn | j r�| j | j | � } | r�| d | 7} q�n | j! | � } | r�| d | 7} n | j s�| j r| j r| d | j | | j p| j � 7} n | j" re| s7t# | j � n d } | j$ d
| d | j% d � � | } n | j j& d � | S(
NR R
R s UPDATE s SET s , c s s& | ] \ } } } | d | Vq d S( t =N( ( Rm R R~ RF ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s R3 s WHERE R R
i����(' Rn R� R� R� R R� R� t _extra_fromsRU R\ R R� R` Re R� R
R R� R R� Rj R� R� R R� RA R R R� R� R� R� R/ R� R RO R R[ R� ( R� R� R� R� R R� t
is_multitablet
main_fromsR� t render_extra_fromsR R� R� R� R� R t extra_from_textR� R| R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_updateH s�
%
c K s t d � � d S( s� Provide a hook to override the generation of an
DELETE..FROM clause.
This can be used to implement DELETE..USING for example.
MySQL and MSSQL override this.
sC This backend does not support multiple-table criteria within DELETEN( R� ( R� R� R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt delete_extra_from_clause� s c C s | j | d t d t �S( NR� R( ( R� R� ( R� t delete_stmtR� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt delete_table_clause� s c K s� | j | | | � } | j } | j } | rd t | _ | j sL | | _ n | j sd | | _ qd n | j } | j h j | � } | j j
i | d 6| d 6| d 6� d } | j r� | | j | | j | � 7} n | d 7} | j
| | j | � } | j r| j | | � \ } } n d } | j rQx$ | j D] }
|
j | | � q4Wn | | 7} | j r�| j r�| d | j | | j � 7} q�n | r�| j | | j | | | � } | r�| d | 7} q�n | j r| j | j | � } | r| d | 7} qn | j r9| j r9| d | j | | j � 7} n | j r�| sWt | j � n d }
| j d |
d | j d � � | } n | j j d
� | S( NR R
R s DELETE s FROM R3 s WHERE R R
i����( Rn R� R� R� R R� R� R� R` Re R� R
R R� Rj R� R� R R� R R� R� R� R� R/ R RO R R[ R� ( R� R� R� R� R R� R R� R� R� R R� R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_delete� sz
c C s d | j j | � S( Ns SAVEPOINT %s( R� t format_savepoint( R� t savepoint_stmt( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_savepoint+ s c C s d | j j | � S( Ns ROLLBACK TO SAVEPOINT %s( R� R� ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_rollback_to_savepoint. s c C s d | j j | � S( Ns RELEASE SAVEPOINT %s( R� R� ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_release_savepoint3 s N( ( ( ( (� R� R� R� t EXTRACT_MAPRS t COMPOUND_KEYWORDSRo R� R R R R R� R R� t' render_table_with_column_in_update_fromR� R R@ R� R9 R R R$ R� R� Rr R� R R� RV R� R+ R, t postfetch_lastrowidR RD t compileR� R� R R R� R� R� R) R- t memoized_propertyR. t memoized_instancemethodR7 t
contextlibt contextmanagerR= R# RN RP R� R� Rt R� R% t preload_moduleR� 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/ R2 R0 R: R= R> RD RL RN RR RV R[ RW Rj Rg Rd Ry Ru 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� R� R� R� R� R� R� R
R� Ru R� R� R� R R R& R' R% R0 R$ R5 R= R R RF RC R. R[ RV R\ R^ R� R Rd Rg R{ Rk Rh Rn R R R� Rl Rr Rs R� R� R| R{ R� R� R� R� R� R� R� R� R� R� R� R� R� R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR 8 s�
h& mA�+ & * * ; & B & M = 0
� &
# � Y
/
� !
� 4 T W
�
s ] t StrSQLCompilerc B s� e Z d Z d � Z e j d � 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( s� A :class:`.SQLCompiler` subclass which allows a small selection
of non-standard SQL features to render into a string value.
The :class:`.StrSQLCompiler` is invoked whenever a Core expression
element is directly stringified without calling upon the
:meth:`_expression.ClauseElement.compile` method.
It can render a limited set
of non-standard SQL constructs to assist in basic stringification,
however for more substantial custom or dialect-specific SQL constructs,
it will be necessary to make use of
:meth:`_expression.ClauseElement.compile`
directly.
.. seealso::
:ref:`faq_sql_expression_string`
c C s d S( Ns <name unknown>( ( R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� M s s sqlalchemy.engine.urlc K s� | j d k rj t j j } | j j | j � j � � } | j | d � } t | t
� sj | j | � Sn t t
| � j
| | � S( NR( ( t stringify_dialectR R� t
engine_urlt URLR! t get_dialectt statement_compilerR� R� R� R� t superR� ( R� R� R� R� t urlR� t compiler( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� P s c K s, d | j | j | � | j | j | � f S( Ns %s[%s]( R� RC RY ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_getitem_binary^ s c K s | j | | | � S( N( R� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_json_getitem_op_binaryd s c K s | j | | | � S( N( R� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt! visit_json_path_getitem_op_binaryg s c K s d | j j | � S( Ns <next sequence value: %s>( R� t format_sequence( R� t seqR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRg j s c
C sQ g t j | � D]* } | j d | t t i d | j �^ q } d d j | � S( NR s
RETURNING s , ( R t _select_iterablesRC R� R� R� RO RA ( R� RD R� R R; ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� m s =c s1 t � d <d d j � � � f d � | D� � S( NR� s FROM s , c 3 s' | ] } | j � d � � �Vq d S( R N( R� ( Rm R� ( R� R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>| s ( R� RA ( R� R� R� R� R� R� ( ( R� R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� w s
c s1 t � d <d d j � � � f d � | D� � S( NR� s , c 3 s' | ] } | j � d � � �Vq d S( R N( R� ( Rm R� ( R� R� R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( R� RA ( R� R� R� R� R� R� ( ( R� R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s
c C s d S( Ns SELECT 1 WHERE 1!=1( ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s d | S( Ns [%s]( ( R� R` R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRV � s c K s | j | d | � S( Ns
<regexp> ( R� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c K s | j | d | � S( Ns <not regexp> ( R� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c K s, d | j j | | � | j j | | � f S( Ns <regexp replace>(%s, %s)( RC R� RY ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s ( R� R� R� R� R R� R� R� R� R� Rg R� R� R� R� RV R� R� R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� 9 s
t DDLCompilerc B s� e Z e j d � � Z e j d � � Z d( d( e d � Z d � Z d � Z
d � Z d � Z e
d � Z d( d � Z d � Z d
� Z d � Z e
e d � Z d
� Z e
d � Z d � Z d � Z d � Z d � Z d � Z d � Z d( 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, d& � Z- d' � Z. RS() c C s | j j | j d d | j �S( NR� ( R� R� R� R� ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s
| j j S( N( R� R� ( R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s d S( N( R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c K s� | j } t | j t j � r� | j � } | j } | j | j � } t | � d k rk | d d } } n | d | d } } | j d | � | j d | � | j d | j
| j � � n | j j | j
| � S( Ni i R� i����R` R R� ( t contextR� t targetR t TableRi R� t format_table_seqRO R9 R� R� R� R� ( R� t ddlR� R� R� t pathR` t sch( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_ddl� s c K s | j j | j � } d | S( Ns CREATE SCHEMA ( R� t
format_schemaR� ( R� R! R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_create_schema� s c K s9 | j j | j � } d | } | j r5 | d 7} n | S( Ns DROP SCHEMA s CASCADE( R� R� R� t cascade( R� t dropR� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_drop_schema� s
c K s� | j } | j } d } | j r> | d j | j � d 7} n | d 7} | j r^ | d 7} n | | j | � d 7} | j | � } | r� | | d 7} n | d 7} d } t } x� | j D]� } | j }
yb | j | d |
j
o� | �} | d k r| | 7} d } | d | 7} n |
j
r+t } n Wq� t
j k
r�} t j t
j t j d
� | j |
j | j d f � d | �q� Xq� W| j | d
| j �}
|
r�| | d |
7} n | d | j | � 7} | S( Ns
CREATE R3 s TABLE s IF NOT EXISTS R� s
t first_pks ,
s s (in table '%s', column '%s'): %si R� t _include_foreign_key_constraintss
)%s
( R� R� R
RA t
if_not_existsR� t create_table_suffixR� R; R� R� R� R� R
RX R R� t ut descriptionR� t argst create_table_constraintst include_foreign_key_constraintst post_create_table( R� R! R� R` R� R� R R% R t
create_columnR t processedt cet const( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_create_table� sN
c sh | j } | j r d S� j | d | �} d j � f d � | j D� � } | rd | d | 7} n | S( NR R3 c 3 s | ] } � j | � Vq d S( N( R� ( Rm R ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr> s ( R� t systemR� t get_column_specificationRA t constraints( R� R! R R� R R� R ( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_create_column s c s� g } | j r" | j | j � n | j } | d k rI | j | � } n t � } | j g | j D]' } | | j k rb | | k rb | ^ qb � d j d � � f d � | D� D� � S( Ns ,
c s s! | ] } | d k r | Vq d S( N( R� ( Rm t p( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>) s c 3 s\ | ]R } | j d k s' | j � � r � j j sG t | d t � r � j | � Vq d S( t use_alterN( t _create_ruleR� R� t supports_alterR\ R� R� ( Rm R ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>+ s
( R� R� t foreign_key_constraintsR� Rb R\ R� t _sorted_constraintsRA ( R� R` R R� R t all_fkcst omit_fkcsR ( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR s
( c K s3 d } | j r | d 7} n | | j j | j � S( Ns
DROP TABLE s
IF EXISTS ( t if_existsR� R� R� ( R� R R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_drop_table9 s
c K s d | j j | j � S( Ns
DROP VIEW ( R� R� R� ( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_drop_view? s c C s, | j d k r( t j d | j � � n d S( Ns, Index '%s' is not associated with any table.( R` R� R
RX R� ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _verify_index_tableB s c s� | j } � j | � � j } d } | j r; | d 7} n | j d k r\ t j d � � n | d 7} | j r| | d 7} n | d � j | d | �| j
| j d | �d j � f d
� | j
D� � f 7} | S( Ns CREATE s UNIQUE s0 CREATE INDEX requires that the index have a names INDEX s IF NOT EXISTS s
%s ON %s (%s)t include_schemaR� s , c 3 s- | ]# } � j j | d t d t �Vq d S( R� R� N( R� R� R� R� ( Rm R~ ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>` s ( R� R R� Rf R� R� R
RX R t _prepared_index_nameR� R` RA t expressions( R� R! R! t include_table_schemaR� R� R� R� ( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_create_indexH s(
c K s] | j } | j d k r* t j d � � n d } | j rF | d 7} n | | j | d t �S( Ns. DROP INDEX requires that the index have a names
DROP INDEX s
IF EXISTS R! ( R� R� R� R
RX R R" R� ( R� R R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_drop_indexh s
c C s� | j d k r' | j j | j � } n d } | rN | rN | j j | � } n d } | j j | � } | r} | d | } n | S( NR� ( R` R� R� R� R� t format_index( R� R� R! R� t schema_namet
index_name( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR" u s c K s, d | j j | j j � | j | j � f S( Ns ALTER TABLE %s ADD %s( R� R� R� R` R� ( R� R! R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_add_constraint� s c K s8 d | j j | j � | j j | j j t j � � f S( Ns COMMENT ON TABLE %s IS %s( R� R� R� R� Ru t commentR t String( R� R! R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_set_table_comment� s c K s d | j j | j � S( Ns COMMENT ON TABLE %s IS NULL( R� R� R� ( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_drop_table_comment� s c K sD d | j j | j d t d t �| j j | j j t j � � f S( Ns COMMENT ON COLUMN %s IS %st use_tableR� ( R� t
format_columnR� R� R� Ru R+ R R, ( R� R! R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_set_column_comment� s
c K s d | j j | j d t �S( Ns COMMENT ON COLUMN %s IS NULLR/ ( R� R0 R� R� ( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_drop_column_comment� s c C s= g } | j d k r, | j d | j � n | j d k rR | j d | j � n | j d k rx | j d | j � n | j d k r� | j d | j � n | j d k r� | j d � n | j d k r� | j d � n | j d k r| j d | j � n | j d k r0| j | j r&d n d � n d
j
| � S( Ns INCREMENT BY %ds
START WITH %ds MINVALUE %ds MAXVALUE %ds NO MINVALUEs NO MAXVALUEs CACHE %dt CYCLEs NO CYCLER3 ( t incrementR� R� R� t minvaluet maxvaluet
nominvaluet
nomaxvaluet cachet cycleRA ( R� t identity_optionsR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt get_identity_options� s$ c K s� d | j j | j � } | r, | | 7} n | j j d k rS | j j | j _ n | j | j � } | r| | d | 7} n | S( Ns CREATE SEQUENCE %sR3 ( R� R� R� R� R� R� t default_sequence_baseR< ( R� R! R� R� R� t options( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_create_sequence� s
c K s d | j j | j � S( Ns DROP SEQUENCE %s( R� R� R� ( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_drop_sequence� s c K s� | j } | j d k r- | j j | � } n d } | d k rX t j d | j � � n d | j j | j j � | | j r� d p� d f S( Ns< Can't emit DROP CONSTRAINT for constraint %r; it has no names# ALTER TABLE %s DROP CONSTRAINT %s%ss CASCADER� (
R� R� R� R� t format_constraintR
RX R� R` R� ( R� R R� R t formatted_name( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_drop_constraint� s c K s� | j j | � d | j j j | j d | �} | j | � } | d k r^ | d | 7} n | j d k r� | d | j | j � 7} n | j d k r� | j j
r� | d | j | j � 7} n | j r� | j s� | j j
r� | d 7} n | S( NR3 R� s DEFAULT s NOT NULL( R� R0 R� R� R� R� t get_column_default_stringR� t computedt identityt supports_identity_columnst nullable( R� R R� t colspecR( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � s
c C s d S( NR� ( ( R� R` ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � s c C s d S( NR� ( ( R� R` ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � s c C sp t | j t j � rh t | j j t j � rI | j j | j j t j
� S| j j | j j d t �Sn d Sd S( NR� ( R� t server_defaultR t
DefaultClauset argR R� R� Ru R R� R� R� R� ( R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRD � s c K s' | j r | j | � S| j | � Sd S( N( t is_column_levelt visit_column_check_constraintt visit_check_constraint( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt& visit_table_or_column_check_constraint s
c K s� d } | j d k rG | j j | � } | d k rG | d | 7} qG n | d | j j | j d t d t �7} | | j | � 7} | S( NR� s CONSTRAINT %s s
CHECK (%s)R� R� (
R� R� R� RA R� R� RW R� R� t define_constraint_deferrability( R� R R� R� RB ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRO s c K s� d } | j d k rG | j j | � } | d k rG | d | 7} qG n | d | j j | j d t d t �7} | | j | � 7} | S( NR� s CONSTRAINT %s s
CHECK (%s)R� R� (
R� R� R� RA R� R� RW R� R� RQ ( R� R R� R� RB ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRN s c s� t | � d k r d Sd } | j d k r] � j j | � } | d k r] | d | 7} q] n | d 7} | d d j � f d � | j r� | j n | j D� � 7} | � j | � 7} | S( Ni R� s CONSTRAINT %s s PRIMARY KEY s (%s)s , c 3 s$ | ] } � j j | j � Vq d S( N( R� R� R� ( Rm R ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>3 s (
RO R� R� R� RA RA t _implicit_generatedt columns_autoinc_firstR; RQ ( R� R R� R� RB ( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_primary_key_constraint) s
c s | j � d } | j d k rP | j j | � } | d k rP | d | 7} qP n t | j � d j j } | d d j � f d � | j D� � | j | | � � d j � f d � | j D� � f 7} | | j
| � 7} | | j | � 7} | | j | � 7} | S( NR� s CONSTRAINT %s i s" FOREIGN KEY(%s) REFERENCES %s (%s)s , c 3 s$ | ] } � j | j j � Vq d S( N( R� t parentR� ( Rm R� ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>G s c 3 s$ | ] } � j | j j � Vq d S( N( R� R R� ( Rm R� ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>M s (
R� R� R� RA R* R R R` RA t define_constraint_remote_tablet define_constraint_matcht define_constraint_cascadesRQ ( R� R R� R� RB t remote_table( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_foreign_key_constraint= s$ !c C s
| j | � S( s= Format the remote table clause of a CREATE CONSTRAINT clause.( R� ( R� R R` R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRV U s c s� t | � d k r d Sd } | j d k r] � j j | � } | d k r] | d | 7} q] n | d d j � f d � | D� � 7} | � j | � 7} | S( Ni R� s CONSTRAINT %s s UNIQUE (%s)s , c 3 s$ | ] } � j j | j � Vq d S( N( R� R� R� ( Rm R ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>c s ( RO R� R� R� RA RA RQ ( R� R R� R� RB ( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_unique_constraintZ s !c C sn d } | j d k r8 | d | j j | j t � 7} n | j d k rj | d | j j | j t � 7} n | S( NR� s
ON DELETE %ss
ON UPDATE %s( t ondeleteR� R� t validate_sql_phraset FK_ON_DELETEt onupdatet FK_ON_UPDATE( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRX h s c C sn d } | j d k r8 | j r+ | d 7} q8 | d 7} n | j d k rj | d | j j | j t � 7} n | S( NR� s DEFERRABLEs NOT DEFERRABLEs
INITIALLY %s( R) R� R; R� R] t FK_INITIALLY( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRQ t s
c C s- d } | j d k r) | d | j 7} n | S( NR� s MATCH %s( R� R� ( R� R R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRW � s c K sa d | j j | j d t d t �} | j t k rA | d 7} n | j t k r] | d 7} n | S( Ns GENERATED ALWAYS AS (%s)R� R� s STOREDs VIRTUAL( R� R� RW R� R� t persisted( R� t generatedR� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_computed_column� s
c K sF d | j r d n d f } | j | � } | rB | d | 7} n | S( Ns GENERATED %s AS IDENTITYt ALWAYSs
BY DEFAULTs (%s)( t alwaysR< ( R� RF R� R� R> ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_identity_column� s N(/ 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. R1 R2 R< R? R@ RC R R R RD RP RO RN RT RZ RV R[ RX RQ RW Rd Rg ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � sP 7 (
t GenericTypeCompilerc B s� e 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 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" d! � Z# d" � Z$ d# � Z% d$ � Z& d% � Z' d& � Z( d' � Z) d( � Z* d) � Z+ RS(* c K s d S( Nt FLOAT( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_FLOAT� s c K s d S( Nt REAL( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_REAL� s c K sT | j d k r d S| j d k r4 d i | j d 6Sd i | j d 6| j d 6Sd S( Nt NUMERICs NUMERIC(%(precision)s)t precisions! NUMERIC(%(precision)s, %(scale)s)t scale( Rn R� Ro ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_NUMERIC� s
c K sT | j d k r d S| j d k r4 d i | j d 6Sd i | j d 6| j d 6Sd S( Nt DECIMALs DECIMAL(%(precision)s)Rn s! DECIMAL(%(precision)s, %(scale)s)Ro ( Rn R� Ro ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_DECIMAL� s
c K s d S( Nt INTEGER( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_INTEGER� s c K s d S( Nt SMALLINT( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_SMALLINT� s c K s d S( Nt BIGINT( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_BIGINT� s c K s d S( Nt TIMESTAMP( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_TIMESTAMP� s c K s d S( Nt DATETIME( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_DATETIME� s c K s d S( Nt DATE( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_DATE� s c K s d S( Nt TIME( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_TIME� s c K s d S( Nt CLOB( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_CLOB� s c K s d S( Nt NCLOB( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_NCLOB� s c C sD | } | j r# | d | j 7} n | j r@ | d | j 7} n | S( Ns (%d)s
COLLATE "%s"( t lengthR� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _render_string_type� s c K s | j | d � S( Nt CHAR( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_CHAR� s c K s | j | d � S( Nt NCHAR( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_NCHAR� s c K s | j | d � S( Nt VARCHAR( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_VARCHAR� s c K s | j | d � S( Nt NVARCHAR( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_NVARCHAR� s c K s | j | d � S( Nt TEXT( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_TEXT� s c K s d S( Nt BLOB( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_BLOB� s c K s d | j r d | j p d S( Nt BINARYs (%d)R� ( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_BINARY� s c K s d | j r d | j p d S( Nt VARBINARYs (%d)R� ( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_VARBINARY� s c K s d S( Nt BOOLEAN( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_BOOLEAN� s c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_large_binary� s c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_boolean� s c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_time� s c K s | j | | � S( N( R| ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_datetime s c K s | j | | � S( N( R~ ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_date s c K s | j | | � S( N( Rx ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_big_integer s c K s | j | | � S( N( Rv ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_small_integer s c K s | j | | � S( N( Rt ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_integer s c K s | j | | � S( N( Rl ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_real s c K s | j | | � S( N( Rj ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_float s c K s | j | | � S( N( Rp ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_numeric s c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_string s c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_unicode s c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_text s c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_unicode_text! s c K s | j | | � S( N( R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
visit_enum$ s c K s t j d | � � d S( NsK Can't generate DDL for %r; did you forget to specify a type on this Column?( R
RX ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR ' s c K s | j | j | j � | � S( N( R� t type_engineR� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_type_decorator. s c K s
| j | � S( N( t get_col_spec( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_user_defined1 s (, R� R� Rj Rl Rp Rr Rt Rv Rx Rz 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� R� R R� R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRh � sT t StrSQLTypeCompilerc B s5 e Z d � Z d � Z d � Z d � Z d � Z RS( c K s? y
| j } Wn t k
r- | j | | � SX| | | � Sd S( N( R� t AttributeErrort _visit_unknown( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� 6 s
c C s& | j d � r | j St | � � d S( Nt visit_( t
startswithR� R� ( R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt __getattr__> s c K s6 | j j | j j j � k r( | j j St | � Sd S( N( R` R� t uppert repr( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� D s
c K s d S( NR ( ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR J s c K s6 y
| j } Wn t k
r' t | � SX| | � Sd S( N( R� R� R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� M s
( R� R� R� R� R� R R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� 5 s
t IdentifierPreparerc B s� e Z d Z e Z e Z e Z e j
d � Z d d d e
e d � Z d � Z d � Z d � Z d � Z d � Z d � Z d
� Z d � Z d d � Z d d
� Z d � Z e
d � Z d d � Z d d � Z d d � Z e j d � e
d � � Z! e
d � Z" e
d � Z# d � Z$ d � Z% e
d d � Z& d � Z' d d � Z( e d d e d d � Z) e
d � Z* e j+ d � � Z, d � Z- RS(! s@ Handle quoting and case-folding of identifiers based on options.R t "c C sq | | _ | | _ | p | j | _ | | _ | j d | _ | | _ | | _ i | _ | j j d k | _ d S( ss 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.
i Rs Rp N( Rs Rp (
R� t
initial_quotet final_quotet escape_quotet escape_to_quotet omit_schemat quote_case_sensitive_collationst _stringsR R� ( R� R� R� R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� k s c sD | j j | j � } | j j | j � � f d � } | | _ | S( Nc s} | j } | � k rr | j rr | d k rX d | k sB d | k rX t j d | � � n t d | pg d d t �S| j Sd S( Nt [t ]sJ Square bracket characters ([]) not supported in schema translate name '%s's
__[SCHEMA_%s]t _noneR� ( R t _use_schema_mapR� R
RX R R� ( R� R� ( R� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt
symbol_getter� s $
( R` t __new__t __dict__R R� ( R� R� t prepR� ( ( R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s
c sH | � d � k r# � d � d <n � � f d � } t j d | | � S( NR� c sS | j d � } � | } | sF � j j } | sF t j d � � qF n � j | � S( Ni sL Dialect has no default schema name; can't use None as dynamic schema target.( R7 R� t default_schema_nameR
RX R� ( R? R� R� ( t dR� ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s
s (__\[SCHEMA_([^\]]+)\])( R� RD RE ( R� R� R� R� ( ( R� R� sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s
c C s: | j | j | j � } | j r6 | j d d � } n | S( s� Escape an identifier.
Subclasses should override this to provide database-dependent
escaping behavior.
R� s %%( R� R� R� R� ( R� RF ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _escape_identifier� s c C s | j | j | j � S( s� Canonicalize an escaped identifier.
Subclasses should override this to provide database-dependent
unescaping behavior that reverses _escape_identifier.
( R� R� R� ( R� RF ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _unescape_identifier� s c C s? | d k r; | j | � r; t j d | | j f � � n | S( s� keyword sequence filter.
a filter for elements that are intended to represent keyword sequences,
such as "INITIALLY", "INITIALLY DEFERRED", etc. no special characters
should be present.
.. versionadded:: 1.3
s/ Unexpected SQL phrase: %r (matching against %r)N( R� R� R
RX t pattern( R� R� t reg( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR] � s
c C s | j | j | � | j S( s~ Quote an identifier.
Subclasses should override this to provide database-dependent
quoting behavior.
( R� R� R� ( R� RF ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt quote_identifier� s
c C sT | j � } | | j k pS | d | j k pS | j j t j | � � pS | | k S( s5 Return True if the given identifier requires quoting.i ( R] t reserved_wordst illegal_initial_characterst legal_charactersR� R t text_type( R� RF t lc_value( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � s
c C s | j j t j | � � S( sj Return True if the given identifier requires quoting, but
not taking case convention into account.( R� R� R R� ( R� RF ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRb � s c C s/ | d k r" t j d d d �n | j | � S( s Conditionally quote a schema name.
The name is quoted if it is a reserved word, contains quote-necessary
characters, or is an instance of :class:`.quoted_name` which includes
``quote`` set to ``True``.
Subclasses can override this to provide database-dependent
quoting behavior for schema names.
:param schema: string schema name
:param force: unused
.. deprecated:: 0.9
The :paramref:`.IdentifierPreparer.quote_schema.force`
parameter is deprecated and will be removed in a future
release. This flag has no effect on the behavior of the
:meth:`.IdentifierPreparer.quote` method; please refer to
:class:`.quoted_name`.
s� The IdentifierPreparer.quote_schema.force parameter is deprecated and will be removed in a future release. This flag has no effect on the behavior of the IdentifierPreparer.quote method; please refer to quoted_name().R� s 0.9N( R� R R� R� ( R� R t force( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s
c C s� | d k r" t j d d d �n t | d d � } | d k r� | | j k rZ | j | S| j | � r� | j | � | j | <n
| | j | <| j | Sn | r� | j | � S| Sd S( s Conditionally quote an identifier.
The identifier is quoted if it is a reserved word, contains
quote-necessary characters, or is an instance of
:class:`.quoted_name` which includes ``quote`` set to ``True``.
Subclasses can override this to provide database-dependent
quoting behavior for identifier names.
:param ident: string identifier
:param force: unused
.. deprecated:: 0.9
The :paramref:`.IdentifierPreparer.quote.force`
parameter is deprecated and will be removed in a future
release. This flag has no effect on the behavior of the
:meth:`.IdentifierPreparer.quote` method; please refer to
:class:`.quoted_name`.
s� The IdentifierPreparer.quote.force parameter is deprecated and will be removed in a future release. This flag has no effect on the behavior of the IdentifierPreparer.quote method; please refer to quoted_name().R� s 0.9R� N( R� R R� R\ R� R R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� " s
c C s | j r | j | � S| Sd S( N( R� R� ( R� t collation_name( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� V s
c C s[ | j | j � } | j | � } | j rW | rW | d k rW | j | � d | } n | S( NR� ( R� R� R� R� R� R� ( R� Rh R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� \ s
c C s | j | p | j � S( N( R� R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� i s c C s | j | p | j � S( N( R� R� ( R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR l s c C s4 | p | j } | j | � r0 | j | � } n | S( N( R� R R� ( R� t savepointR� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� o s s sqlalchemy.sql.namingc C s� t j j } | j t j k rF | j | | j � } | d k rO d Sn | j } | j d k rq | j
| d | �S| j | d | �Sd S( NR� t _alembic_quote( R R� t
sql_namingR� R t
_NONE_NAMEt _constraint_name_for_tableR` R� R t truncate_and_render_index_namet# truncate_and_render_constraint_name( R� R R� t namingR� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRA x s
c C s+ | j j p | j j } | j | | | � S( N( R� t max_index_name_lengthR t _truncate_and_render_maxlen_name( R� R� R� t max_( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s+ | j j p | j j } | j | | | � S( N( R� t max_constraint_name_lengthR R� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s{ t | t j � rP t | � | k r` | d | d !d t j | � d } q` n | j j | � | sj | S| j | � Sd S( Ni i R} i����( R� R R� RO R t md5_hexR� t validate_identifierR� ( R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s ,c C s
| j | � S( N( RA ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR' � s c C sj | d k r | j } n | j | � } | j | � } | j rf | rf | rf | j | � d | } n | S( s' Prepare a quoted table and schema name.R� N( R� R� R� R� R� R� ( R� R` R� R� R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s
| j | � S( s Prepare a quoted schema name.( R� ( R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s= | d k r0 t | t j � r0 | j | � } n | j | � S( s Prepare a quoted column name.N( R� R� R R� R� R� ( R� R� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s� | d k r | j } n | d k rH t | t j � rH | j | � } n t | d t � s� | r� | j | j d | d | �d | j
| � S| j
| � Sn. | r� | j | j d | d | �d | S| Sd S( s Prepare a quoted column name.R� R� R� R� N( R� R� R� R R� R� R\ R� R� R` R� ( R� R R/ R� t
table_nameR� R ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR0 � s -$c C sa | j | � } | j rG | rG | rG | j | � | j | d t �f S| j | d t �f Sd S( s( Format table name and schema as a tuple.R� N( R� R� R� R� R� ( R� R` R� R� ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s
c C sr g | j | j | j | j � f D] } t j | � ^ q" \ } } } t j d i | d 6| d 6| d 6� } | S( NsM (?:(?:%(initial)s((?:%(escaped)s|[^%(final)s])+)%(final)s|([^\.]+))(?=\.|$))+t initialt finalt escaped( R� R� R� RD R� R� ( R� R$ R� R� t
escaped_finalt r( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _r_identifiers s 7 c C sQ | j } g g | j | � D] \ } } | p1 | ^ q D] } | j | � ^ q8 S( s: Unpack 'schema.table.column'-like strings into components.( R� t findallR� ( R� t identifiersR� t aR Rw ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt unformat_identifiers' s N(. R� R� R� t RESERVED_WORDSR� t LEGAL_CHARACTERSR� t ILLEGAL_INITIAL_CHARACTERSR� R� t
attrgetterR� R� R� R� R� R� R� R� R� R] R� R Rb R� R� R� R� R� R R� R R� RA R� R� R� R' R� R� R� R0 R� R� R� R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� V sT
' 4
& (� R� R� R� RB R� RD R� R R R R R R R R R R R� R
R R R
R\ R� R� t IR� t LEGAL_CHARACTERS_PLUS_SPACEt rangeRe R� R^ R` Ra t UNICODER R R R� RM RY R� R) t or_t addt mulRE t divt modt truedivt negt ltt let net gtt get eqt is_distinct_fromt is_not_distinct_fromt concat_opR� t not_match_opR� R� R� R� R� R� R� R t existst distinct_opt invt any_opt all_opt desc_opt asc_opt nulls_first_opt
nulls_last_opR� Rx R# R% R& R' RF RG R R� R[ Rg t cubet rollupt
grouping_setsR^ R� R
R� t UNION_ALLR� t
EXCEPT_ALLR� t
INTERSECT_ALLR� t RM_RENDERED_NAMEt RM_NAMEt
RM_OBJECTSt RM_TYPEt
namedtupleR� t symbolR� R� R� R� R� t objectR� t with_metaclasst EnsureKWArgTypeR� t
ColumnElementR� R R� R� Rh R� R� ( ( ( sH /opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt <module> s %
(?�%� � � � � � � � � � � � � � � c� � �!