JezK
Edit File: compiler.pyc
� 1��fc _ @ 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( ( sJ /opt/alt/python27/lib64/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( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <setcomp>D s c 3 s# | ] } | | j � � Vq d S( N( t index( Rm R� ( R� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� Q s N( t __name__t __module__R� R� R� ( ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt sql_compiler� s c K s | j | | � S( N( t _compiler_dispatch( R� t objt kwargs( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s c K s | j | | � S( N( R� ( R� t type_t kw( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s ( R� R� R� t ensure_kwargR� R� R� ( ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� ' s c C s | j j S( N( R� t proxy_set( R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� , s c C s | j j S( N( R� R� ( R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� 0 s c K s | S( N( ( R� R� ( ( sJ /opt/alt/python27/lib64/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 ( ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <dictcomp>� s i c S s i | ] } | g | � q S( ( ( Rm R ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt prefetchg s c C s i S( N( ( R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt <lambda>� R� ( t itertoolst countt ret subR� ( R� ( ( R@ sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( t dictR ( R� ( ( R� sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _bind_processors� s c C s t | j � d k S( Ni ( t lenR� ( R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt is_subquery� s c C s | S( N( ( R� ( ( sJ /opt/alt/python27/lib64/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& ( sJ /opt/alt/python27/lib64/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& sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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( sJ /opt/alt/python27/lib64/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 sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s c s s | ] \ } } | Vq d S( N( ( Rm R� RF ( ( sJ /opt/alt/python27/lib64/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( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr> s ( R7 t splitRA ( R? R t exprt tok( t replacement_expressions( R{ R| sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>f s N( R� ( R� R� ( R� t getterst proct row_fn( R� R� sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( ( R� R� ( R� R� ( R� R� sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_collationF s c K s | j S( N( R� ( R� t fromclauseR� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_fromclauseI s c K s | j S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt do_bindparam_ s c S s | j d � S( Ni ( R7 ( R? ( ( sJ /opt/alt/python27/lib64/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 sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_textual_selectw s@ c K s d S( Nt NULL( ( R� R~ R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s c 3 s! | ] } | j � � � Vq d S( N( R� ( Rm R ( R� R� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( RA ( R� R t separatorR� ( ( R� R� sJ /opt/alt/python27/lib64/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$ ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s c 3 s! | ] } | j � � � Vq d S( N( R� ( Rm R ( R� R� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyRg x s c K s | j j | | � S( N( t clause_exprR� ( R� RO R� ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>[ s N( RA RY R� RK ( Rm Rw Rx ( R� R� ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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 ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s N( RA Rv ( Rm ( R� R� ( Rw Rx sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s< c K s | j | j | � S( N( R� t sql_function( R� R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� s % c K s | | j j | | � S( N( R� R� ( R� R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� ' s c K s | j j | | � | S( N( R� R� ( R� R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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_ ( ( sJ /opt/alt/python27/lib64/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_ ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s /c C s | | j S( N( R ( R� R� ( ( sJ /opt/alt/python27/lib64/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? ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_table_valued_alias s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR% � s` c K s t | d <| j | | � S( NR� ( R� R% ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_values s. "c C s d | S( Ns AS ( ( R� t alias_name_text( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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 ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� z s c s � | | � f | | � d S( N( ( RA R� RB R� ( R R ( sJ /opt/alt/python27/lib64/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 sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR. � s c C s d S( N( R� ( R� t byfroms( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt get_select_hint_text� s c C s d S( N( R� ( R� R` R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyRV s c C s d S( N( R� ( R� R` R� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( sJ /opt/alt/python27/lib64/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 sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( RA ( R� RD R! R� R8 ( ( R� R� sJ /opt/alt/python27/lib64/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( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � sH " , c C s | r d Sd Sd S( Ns WITH RECURSIVEt WITH( ( R� R ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs s c K s d S( Ns FOR UPDATE( ( R� RZ R� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr> s N( RA ( Rm t crud_param_set( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_getitem_binary^ s c K s | j | | | � S( N( R� ( R� R R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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; ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>| s ( R� RA ( R� R� R� R� R� R� ( ( R� R� R� sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>� s ( R� RA ( R� R� R� R� R� R� ( ( R� R� R� sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s d S( Ns SELECT 1 WHERE 1!=1( ( R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s d | S( Ns [%s]( ( R� R` R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyRV � s c K s | j | d | � S( Ns <regexp> ( R� ( R� R R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c K s | j | d | � S( Ns <not regexp> ( R� ( R� R R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s | j j S( N( R� R� ( R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s d S( N( R� ( R� R� R� R� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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( ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � s c C s d S( NR� ( ( R� R` ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR � s c C s d S( NR� ( ( R� R` ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/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� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pys <genexpr>c s ( RO R� R� R� RA RA RQ ( R� R R� R� RB ( ( R� sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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> ( ( sJ /opt/alt/python27/lib64/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 ( ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_FLOAT� s c K s d S( Nt REAL( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_DECIMAL� s c K s d S( Nt INTEGER( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_INTEGER� s c K s d S( Nt SMALLINT( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_SMALLINT� s c K s d S( Nt BIGINT( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_BIGINT� s c K s d S( Nt TIMESTAMP( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_TIMESTAMP� s c K s d S( Nt DATETIME( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_DATETIME� s c K s d S( Nt DATE( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_DATE� s c K s d S( Nt TIME( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_TIME� s c K s d S( Nt CLOB( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_CLOB� s c K s d S( Nt NCLOB( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt _render_string_type� s c K s | j | d � S( Nt CHAR( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_CHAR� s c K s | j | d � S( Nt NCHAR( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_NCHAR� s c K s | j | d � S( Nt VARCHAR( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_VARCHAR� s c K s | j | d � S( Nt NVARCHAR( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_NVARCHAR� s c K s | j | d � S( Nt TEXT( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_TEXT� s c K s d S( Nt BLOB( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_VARBINARY� s c K s d S( Nt BOOLEAN( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_BOOLEAN� s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_large_binary� s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_boolean� s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_time� s c K s | j | | � S( N( R| ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_datetime s c K s | j | | � S( N( R~ ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_date s c K s | j | | � S( N( Rx ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_big_integer s c K s | j | | � S( N( Rv ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_small_integer s c K s | j | | � S( N( Rt ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_integer s c K s | j | | � S( N( Rl ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_real s c K s | j | | � S( N( Rj ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_float s c K s | j | | � S( N( Rp ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_numeric s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_string s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_unicode s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_text s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_unicode_text! s c K s | j | | � S( N( R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR ' s c K s | j | j | j � | � S( N( R� t type_engineR� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� D s c K s d S( NR ( ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� M s ( R� R� R� R� R� R R� ( ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt symbol_getter� s $ ( R` t __new__t __dict__R R� ( R� R� t prepR� ( ( R� sJ /opt/alt/python27/lib64/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� ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s s (__\[SCHEMA_([^\]]+)\])( R� RD RE ( R� R� R� R� ( ( R� R� sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� \ s c C s | j | p | j � S( N( R� R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� i s c C s | j | p | j � S( N( R� R� ( R� R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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_( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s ,c C s | j | � S( N( RA ( R� R� ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyR� � s c C s | j | � S( s Prepare a quoted schema name.( R� ( R� R� ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( sJ /opt/alt/python27/lib64/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( ( sJ /opt/alt/python27/lib64/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 ( ( sJ /opt/alt/python27/lib64/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� ( ( ( sJ /opt/alt/python27/lib64/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� ( ( ( sJ /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/sql/compiler.pyt <module> s % (?�%� � � � � � � � � � � � � � � c� � �!