H`Tc_@sdZddlZddlmZmZmZmZmZm Z m Z m Z m Z ddlmZm Z ddlZddlZddlZeddd d d d d ddddddddddddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcddg^ZejdeejZegedfdgD]Zee^qjdhgZejdiejZejdjejZidkdl6dmdn6dodp6dqdr6dsdt6ZejdudvZ i dwej!6dxej"6dyej#6dzej$6d{ej%6d|ej&6d}ej'6d|ej(6d~ej)6dej*6dej+6dej,6dej-6dej.6dej/6dej06dej16dej26dej36dej46dej56dej66dej76dej86dej96dej:6dej;6dej<6dej=6dej>6dej?6dej@6ZAi dejB6dejC6dejD6dejE6dejF6dejG6dejH6dejI6dejJ6dejK6dejL6ZMidd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6ZNide jOjP6de jOjQ6de jOjR6de jOjS6de jOjT6de jOjU6ZVdeWfdYZXdeWfdYZYde jZfdYZ[deXfdYZ\deXfdYZ]deYfdYZ^deWfdYZ_dS(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`. iNi( tschematsqltypest operatorst functionstutiltvisitorstelementst selectabletbasei(Rtexctalltanalysetanalyzetandtanytarraytastasct asymmetrict authorizationtbetweentbinarytbothtcasetcasttchecktcollatetcolumnt constrainttcreatetcrosst current_datet current_rolet current_timetcurrent_timestampt current_usertdefaultt deferrabletdesctdistincttdotelsetendtexcepttfalsetfortforeigntfreezetfromtfulltgranttgroupthavingtiliketint initiallytinnert intersecttintotistisnulltjointleadingtlefttliketlimitt localtimetlocaltimestamptnaturaltnewtnottnotnulltnulltofftoffsettoldtontonlytortordertoutertoverlapstplacingtprimaryt referencestrighttselectt session_usertsettsimilartsomet symmetricttabletthenttottrailingttruetuniontuniquetusertusingtverbosetwhentwheres ^[A-Z0-9_$]+$ii t$s%(? s >= s = s || s MATCH s IN s NOT IN s, s FROM s AS s IS s IS NOT s COLLATE sEXISTS s DISTINCT sNOT s DESCs ASCs NULLS FIRSTs NULLS LASTscoalesce%(expr)st CURRENT_DATEt CURRENT_TIMEtCURRENT_TIMESTAMPt CURRENT_USERt LOCALTIMEtLOCALTIMESTAMPsrandom%(expr)stsysdatet SESSION_USERtUSERtmonthtdaytyeartsecondthourtdoytminutetquartertdowtweektepocht millisecondst microsecondst timezone_hourttimezone_minutetUNIONs UNION ALLtEXCEPTs EXCEPT ALLt INTERSECTs INTERSECT ALLtCompiledcBseZdZd ejdZejdddZdZ e dZ dZ dZ d d Ze d Zd Zd ZRS(sRepresent 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. cCsR||_||_|dk rN||_|j|_|j|j||_ndS(sConstruct a new ``Compiled`` object. :param dialect: ``Dialect`` to compile against. :param statement: ``ClauseElement`` to be compiled. :param bind: Optional Engine or Connection to compile this statement against. :param compile_kwargs: additional kwargs that will be passed to the initial call to :meth:`.Compiled.process`. .. versionadded:: 0.8 N(tdialecttbindtNonet statementtsupports_executiont can_executetprocesststring(tselfRRRtcompile_kwargs((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt__init__s      s0.7s>:class:`.Compiled` objects now compile within the constructor.cCsdS(sDProduce the internal string representation of this element. N((R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytcompilescCs|j|||S(N(t_execute_compiled(Rt connectiont multiparamstparams((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_execute_on_connectionscCs tdS(sReturn a Compiled that is capable of processing SQL expressions. If this compiler is one, it would likely just return 'self'. N(tNotImplementedError(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt sql_compilerscKs|j||S(N(t_compiler_dispatch(Rtobjtkwargs((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRscCs |jp dS(s3Return the string text of the generated SQL or DDL.t(R(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt__str__scCs tdS(sReturn 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(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytconstruct_paramsscCs |jS(s0Return the bind params for this compiled object.(R(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRscOs:|j}|dkr'tjdn|j|||S(sExecute this compiled object.s>This Compiled object is not bound to any Engine or Connection.N(RRR tUnboundExecutionErrorR(RRRte((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytexecutes    cOs|j||jS(sJExecute this compiled object and return the result's scalar value.(Rtscalar(RRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRsN(t__name__t __module__t__doc__RRt immutabledictRt deprecatedRRtpropertyRRRRRRR(((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs      t TypeCompilercBs eZdZdZdZRS(s2Produces DDL specification for TypeEngine objects.cCs ||_dS(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR scCs |j|S(N(R(Rttype_((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR s(RRRRR(((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs t _CompileLabelcBsDeZdZdZdZddZedZedZRS( s;lightweight label object which acts as an expression.Label.tlabeltelementtnamecCs&||_||_|f||_dS(N(RRt _alt_names(RtcolRt alt_names((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs  cCs |jjS(N(Rt proxy_set(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRscCs |jjS(N(Rttype(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR s(selementsname(( RRRt__visit_name__t __slots__RRRR(((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs  t SQLCompilercBseZdZeZeZeZZ Z e Z eZ eZeZe edZejdZdZejdZdZedZe e edZedZd Zed Ze eee d Ze ed Z d Z!dZ"dZ#dZ$dZ%dZ&edeeedZ'dZ(dZ)dZ*e dZ+dZ,dZ-dZ.dZ/dZ0e dZ1dZ2d Z3d!Z4eedd"Z5d#Z6d$Z7d%Z8d&Z9d'Z:d(Z;d)Z<d*Z=d+Z>d,Z?ejd-Z@d.ZAd/ZBd0ZCd1ZDd2ZEd3ZFd4ZGd5ZHd6ZId7ZJd8ZKd9ZLeeed:ZMd;ZNd<ZOd=ZPd>ZQd?ZRd@ZSe dAZTeee dBZUeeee dCZVdDZWe edEZXdFZYdGZZdHZ[dIZ\dJZ]dKZ^ej_dLefdMe`fdNe`fgZadOZbeeee deedPZcdQZddRZedSZfdTZgdUZhdVZidWZjdXZkeeee dYZledZZmd[Znd\Zod]Zpd^Zqd_Zree d`ZsejdaZtdbZudcZvddZwdeZxdfZyRS(gsDefault implementation of Compiled. Compiles ClauseElements into SQL strings. Uses a similar visit paradigm as visitors.ClauseVisitor but implements its own traversal. cKs||_|pt|dt|_i|_tj|_g|_i|_ |j |_ |j rog|_ nt |j |_d|_|j|_|jp|j|_tj|j|_i|_tj|||||j r|j dkr|jndS(sConstruct a new ``DefaultCompiler`` object. dialect Dialect to be used statement ClauseElement to be compiled column_keys a list of column names to be compiled into an INSERT or UPDATE statement. tinlineRmN(t column_keystgetattrtFalseRtbindsRt column_dictt bind_nameststackt result_mapt positionalt positiontuptBIND_TEMPLATESt paramstylet bindtemplateRtctestidentifier_preparertpreparert label_lengthtmax_identifier_lengtht PopulateDictt _process_anontanon_mapttruncated_namesRRt_apply_numbered_params(RRRRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRQs&            cCs:tj|_i|_t|_|jr6i|_ndS(sInitialize collections related to CTEs only if a CTE is located, to save on the overhead of these collections otherwise. N(Rt OrderedDictRt ctes_by_nameRtctes_recursiveRtcte_positional(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_init_cte_states    cs7tjdtjdfd|j|_dS(Nis \[_POSITION\]csttjS(N(tstrRtnext(tm(tposcount(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyts(t itertoolstcounttretsubR(R((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs  cs'tdfdjDDS(Ncss-|]#\}}|dk r||fVqdS(N(R(t.0tkeytvalue((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s c3s1|]'}j||jjjfVqdS(N(RRt_cached_bind_processorR(Rt bindparam(R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s(tdictR(R((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_bind_processorss cCst|jdkS(Ni(tlenR(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt is_subqueryscCs|S(N((R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRscCsM|ri}x|jjD]\}}|j|krK||j||scKs|jS(N(R(Rt fromclauseR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_fromclauseDscKs|jS(N(R(RtindexR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_indexGscKs|jjj|jS(N(Rt type_compilerRR(Rt typeclauseR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_typeclauseJscCs|S(N((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytpost_process_textMsc s@fd}tjdtj|jjS(NcsI|jd}|jkr5jj|Sj|SdS(Ni(R3t _bindparamsRtbindparam_string(RR(t textclauseRR(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt do_bindparamQscSs |jdS(Ni(R3(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRZs(tBIND_PARAMS_ESCRt BIND_PARAMSR"R(RR%RR&((RRR%s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_textclausePs ic Ks|j }|r|jn |jd} |pE|dkoE|pE| d} | rx0|jD]"} |j| dtd|jqXWn|j|j|} |r|rd| } n| S(Niit iswrapperRRs(%s)(Rt_default_stack_entryt column_argsRRt_add_to_result_mapR( RttafR*tcompound_indextforce_result_mapRtparensRttopleveltentrytpopulate_result_maptcR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_text_as_from`s     cKsdS(NtNULL((RtexprR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_nullyscKs|jjrdSdSdS(NR`t1(Rtsupports_native_boolean(RR8R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_true|s cKs|jjrdSdSdS(NR,t0(RR;(RR8R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_falses c sw|dk rj||S|j}|dkr=d}n t|j}|jdfd|jDDS(Nt css|]}|r|VqdS(N((Rts((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys sc3s!|]}|jVqdS(N(R(RR5(RR(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s(Rt_order_by_clauselisttoperatorRR=tclauses(Rt clauselisttorder_by_selectRtsep((RRs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_clauselists      c sItd|jDdjdfd|jDDS(Ncss*|] }|jdk r|jjVqdS(N(t_order_by_label_elementRR(Rtl((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys ss, css|]}|r|VqdS(N((RR@((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s c3sQ|]G}|jd|jdk r?|jjkr?|jndVqdS(RN(RRHRR(RR5(RRtraw_col(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s(RXt _raw_columnsR=RC(RRDRER((RRRJs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRAs  cKsd}|jdk r5||jj||d7}nxI|jD]>\}}|d|j||d|j||d7}q?W|jdk r|d|jj||d7}n|d7}|S(NsCASE R?sWHEN s THEN sELSE tEND(RRRtwhenstelse_(RtclauseRtxtcondtresult((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_cases 3! cKs,d|jj|||jj||fS(NsCAST(%s AS %s)(RORR (RRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_castsc sQd|jjdjfdd|jfd|jffDfS(Ns %s OVER (%s)R?c3sI|]?\}}|dk rt|rd||jfVqdS(s%s BY %sN(RRR(RtwordRO(RR(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s t PARTITIONtORDER(tfuncRR=t partition_bytorder_by(RtoverR((RRs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_overs  cKs8|jj|j|j}d||jj||fS(NsEXTRACT(%s FROM %s)(t extract_maptgettfieldR8R(RtextractRR_((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_extractscKs|dk r+||j|jd|jnt|d|jjd}|r]|||Stj|j|jd}djt |j |gi|j ||d6SdS(Ns visit_%s_funcs%(expr)sR R8(( RRRRtlowert FUNCTIONSR^t __class__R=tlistt packagenamestfunction_argspec(RRXRRtdispR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_functions  cKs|j|jS(N(tvisit_sequencetsequence(Rt next_valueR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_next_value_funcscCstd|jjdS(Ns2Dialect '%s' does not support sequence increments.(RRR(RRk((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRjscKs|jj||S(N(t clause_exprR(RRXR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRgsc  s{j }|rjn jd}jji|dd6|d6|dd6jj|j}d|djfdt|jD} |j j d} | r| d| 7} n| j |7} | |j dk s|jdk rj|pd 7} jrK|d krK|rKj| } njjdrs|rsd | d S| SdS( Nitcorrelate_fromsR*t asfrom_fromsR?c 3s9|]/\}}|jddtd|VqdS(RR1R/N(RR(RtiR5(RRR(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys sRs GROUP BY RiRR(RR+tappendtcompound_keywordsR^tkeywordR=t enumeratetselectst_group_by_clauseRtorder_by_clauset_limitRt_offsett limit_clauseRt_render_cte_clausetpop( RtcsRR1R/RR2R3RtRtgroup_by((RRRs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_compound_selects2    !   cKs|jrv|jr$tjdnt|d|jjd}|rY|||j|S|j|t|j|Snj|jrt|d|jjd}|r|||j|S|j |t|j|SntjddS(NsFUnary expression does not support operator and modifier simultaneouslysvisit_%s_unary_operatorsvisit_%s_unary_modifiers,Unary expression has no operator or modifier( RBtmodifierR R RRRt _generate_generic_unary_operatorRt _generate_generic_unary_modifier(RtunaryRRh((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_unarys&      cKs:|jjr|j|j|Sd|j|j|SdS(Ns%s = 1(RR;RR(RRRBR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_istrue_unary_operator2s cKs>|jjr#d|j|j|Sd|j|j|SdS(NsNOT %ss%s = 0(RR;RR(RRRBR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_isfalse_unary_operator8s cKs|jr@t|jtjr@t|jtjr@t|ds    cKs|j|d|jd|S(NR?(RR(RRRBR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_custom_op_binaryQscKs|j||jd|S(NR?(RR(RRRBR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_custom_op_unary_operatorUscKs|j|d|j|S(NR?(RR(RRRBR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_custom_op_unary_modifierYscKs*|jj||||jj||S(N(R?RRU(RRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR]scKs||jj||S(N(RR(RRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRbscKs|jj|||S(N(RR(RRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRescCstjddtjS(Ns'%'R(Rtliteral_columnRt STRINGTYPE(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_like_percent_literalhscKsF|j}|j}|j|jj||_|j|||S(N(t_cloneRt__add__RUtvisit_like_op_binary(RRRBRtpercent((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_contains_op_binaryls  cKsF|j}|j}|j|jj||_|j|||S(N(RRRRUtvisit_notlike_op_binary(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_notcontains_op_binaryrs  cKs=|j}|j}|j|j|_|j|||S(N(RRt__radd__RUR(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_startswith_op_binaryxs   cKs=|j}|j}|j|j|_|j|||S(N(RRRRUR(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_notstartswith_op_binarys   cKs=|j}|j}|j|j|_|j|||S(N(RRRRUR(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_endswith_op_binarys  cKs=|j}|j}|j|j|_|j|||S(N(RRRRUR(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_notendswith_op_binarys  cKsd|jjdd}d|jj|||jj||f|r_d|j|tjndS(Ntescapes %s LIKE %ss ESCAPE R( t modifiersR^RR?RRUtrender_literal_valueRR(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs cKsd|jjdd}d|jj|||jj||f|r_d|j|tjndS(NRs%s NOT LIKE %ss ESCAPE R( RR^RR?RRURRR(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs cKsd|jjdd}d|jj|||jj||f|r_d|j|tjndS(NRslower(%s) LIKE lower(%s)s ESCAPE R( RR^RR?RRURRR(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_ilike_op_binarys cKsd|jjdd}d|jj|||jj||f|r_d|j|tjndS(NRslower(%s) NOT LIKE lower(%s)s ESCAPE R( RR^RR?RRURRR(RRRBRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_notilike_op_binarys cKs4|jjdt}|j||r*dnd|S(NR[s BETWEEN SYMMETRIC s BETWEEN (RR^RR(RRRBRR[((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_between_op_binaryscKs4|jjdt}|j||r*dnd|S(NR[s NOT BETWEEN SYMMETRIC s NOT BETWEEN (RR^RR(RRRBRR[((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_notbetween_op_binarysc Ksw| r8|jjr8|jj|}|j|dtS|sM|r|jr|jdkr|jdkrt j d|j n|j |dt|S|j |}||jkrL|j|}||k rL|js|jr|jj|j rt j d|j qI|js$|jrIt j d|j |j fqIqLn||j|j <|j|<|j||S(Ntskip_bind_expressions@Bind parameter '%s' without a renderable value not allowed here.RsIBind parameter '%s' conflicts with unique bind parameter of the same namesbindparam() 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').(Rt_has_bind_expressiontbind_expressionRRRRRtcallableR R Rtrender_literal_bindparamt_truncate_bindparamRRbRt intersectiont_is_crudR$( RRRRRRRRtexisting((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_bindparams8       cKs|j}|j||jS(N(RRR(RRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs cCs6|j|j}|r"||Std|dS(sRender 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(Don't know how to literal-quote value %rN(t_cached_literal_processorRR(RRRt processor((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs  cCs[||jkr|j|S|j}t|tjrJ|jd|}n||j|<|S(NR(RRRRRR(RRt bind_name((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRs   cCs||f|jkr&|j||fS|j|j}t||jkr|jj|d}|dt|jdd!dt|d}|d|j|t|jtjr|j} n4t|jtjr|jjd} n tstgtj| jD]} | dk r| ^q} | ddjfd| D7} njr_g|d<j|ysRs AS Rs AS (!RRRRRRRt _restatesRt format_aliasRR R t _cte_aliasRt visit_ctet recursiveRRtoriginalRtSelecttCompoundSelectRvRtAssertionErrorRt unique_listt inner_columnsR=RRR(RtcteRtashintt fromhintsRtcte_namet existing_ctetorig_ctetcte_alias_nameRt col_sourceR5t recur_cols((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRAsh                 c Ks|s |rEt|jtjr9|jd|j}qE|j}n|r^|jj||S|r|jj|dt |d|jj||}|r||kr|j |||||}n|S|jj||SdS(NR Rs AS ( RRRRRRRRRRtformat_from_hint_text( RR RRtiscrudRRt alias_nametret((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_aliass   cCsw|jjs|j}n||jkr]|j|\}}}||||f|j|gsc3s"|]}|j|fVqdS(N(R(RR5(t inner_col(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys ks(RRReRRttupleR^( RRVttransformed_selecttdRRtobjsttypR((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt&_transform_result_map_for_nested_joinses  ++R*RoRpcCs|j }|r|jn |jd}|d}|d}|rd|jd|j|dd}n|jd|d|}|S(NiRoRptexplicit_correlate_fromstimplicit_correlate_froms((RR+t_get_display_fromst difference(RRVRR2R3RoRptfroms((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_display_froms_for_selectxs        c $KsY|jo$| o$|j o$|jj } | r{|j|} |j| d|d|d|d|d|d|dt| } n|j } | r|jn |jd}|p|d ko| p|d}| r|r|j|| n| S|d }|d }|r$|j d |j |d d}n|j d |d |}t t j |}|j|}i|d 6|d6|d 6}|jj|| j}|jitd6td6d} |jrVtg|jjD]P\\}}}|d|jjfkr||i|j|dtd6f^q}|j|}|rV| |d7} qVn|jr~| |j||j| 7} n| |j|7} gg|jD]-\}}|j|||||d|^qD]}|dk r|^q}| dj|7} |r| d7} |jrZ| djg|D]$} | j|dtd|| ^q)7} q| djg|D]} | j|dt| ^qj7} n| |j 7} |j!dk r|j!j|| }!|!r| d|!7} qn|j"j#r|j"j|| }"|"r| d|"7} qn|j$dk r\|j$j|| }!|!r\| d|!7} q\n|j%j#r|jj&r}|}#nd}#| |j'|d|#| 7} n|j(dk s|j)dk r| |j*|7} n|j+dk r| |j,|7} n|j-r)|d kr)| r)|j.| } n|jj/d|rQ|rQd| dS| SdS(NRR1R*RR/R0tnested_join_translationiiRoRpRRRRsSELECT t*RRR?s, s FROM s WHERE s GROUP BY s HAVING RERR((0RRRtsupports_right_nested_joinsRt visit_selectRR+RRRRXRt _from_objectsRaRrtcopyRRt_hintsRRRRRt _prefixest_generate_prefixestget_select_precolumnst_columns_plus_namesRRR=Rt _whereclauseRwRCt_havingt_order_by_clausetsupports_simple_order_by_labelRxRyRzR{t_for_update_argtfor_update_clauseRR|R}($RRVRR1R*RR/R0R!Rtneeds_nested_translationRRR2R3R4RoRpRtnew_correlate_fromstall_correlate_fromst new_entryRtfrom_RRtbyfromt hint_textRRR5RtfttRRE((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR$s                     G  >   5 /          c s9djfd|D}|r5|d7}n|S(NR?c3sE|];\}}|dks-|jjkr|jVqdS(N(RRRR(Rtprefixt dialect_name(RR(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys 3s  (R=(RtstmttprefixesRRO((RRs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR)1s   cCs|jrBtg|jD]}|j|^qg|j|_n|j|jd}|djg|jjD] }|^qq7}|d7}|S(NR?s, s ( RtsumRRRtget_cte_preambleRR=tvalues(RRtcte_textttxt((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR|<s # & cCs|r dSdSdS(NsWITH RECURSIVEtWITH((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR@IscCs|jrdpdS(scCalled when building a ``SELECT`` statement, position is just before column list. s DISTINCT R(t _distinct(RRV((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR*OscKs+|jj||}|r#d|SdSdS(Ns ORDER BY R(R.R(RRVRRZ((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRxVscCsdS(Ns FOR UPDATE((RRV((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR1]scCstjddS(Ns@RETURNING is not supported by this dialect's statement compiler.(R R (RR=treturning_cols((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytreturning_clause`scCsd}|jdk r;|d|jtj|j7}n|jdk r|jdkrf|d7}n|d|jtj|j7}n|S(NRs LIMIT s LIMIT -1s OFFSET (RyRRRtliteralRz(RRVR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR{es& &cKs|s |rt|ddrM|jj|jd|jj|j}n|jj|j}|r||kr|j|||||}n|SdSdS(NRR R(RRRRRRRR(RR\RRRRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_tableos / cKs\|jj|dt||jr'dp*d|jj|dt|d|jj||S(NRs LEFT OUTER JOIN s JOIN s ON (R?RRtisouterRUR(RR=RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_join~sHc Kst|_|j||}| rX|jj rX|jj rXtjd|jjn|j r|jj stjd|jjn|d}n|}|j }|jj}d}|j r||j ||j |7}n|d7}|j|j}|jrtg|jjD]6\\} } } | d|jjfkr| | f^q} |j| kr|j||j| |jt}qn||7}|s| r|ddjg|D]} |j| d^q7}n|js|jr7|jp|j|_|j||j}|jr7|d |7}q7n|jdk rf|d |j|j|7}nu| r|r|d 7}n[|j r|d djd |D7}n.|ddjg|D]} | d^q7}|jr|j r|d |7}n|S(NsWThe '%s' dialect with current database version settings does not support empty inserts.scThe '%s' dialect with current database version settings does not support in-place multirow inserts.isINSERT sINTO R"s (%s)s, R?s %ss DEFAULT VALUESs VALUES %scss,|]"}ddjd|DVqdS(s(%s)s, css|]}|dVqdS(iN((RR5((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys sN(R=(Rt colparam_set((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys ss VALUES (%s)i(Rtisinsertt_get_colparamsRtsupports_default_valuestsupports_empty_insertR R Rt_has_multi_parameterstsupports_multivalues_insertRR(R)t format_tableR\R'RRRR=Rt returningt _returningRGtreturning_precedes_valuesRVRR(Rt insert_stmtRt colparamstcolparams_singleRRORt table_textR\RR8t dialect_hintsR5RG((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_insertsr             -   +     (cCsdS(s3Provide a hook for MySQL to add LIMIT to the UPDATEN(R(Rt update_stmt((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytupdate_limit_clausescKs|j|dtdt|S(s|Provide a hook to override the initial table clause in an UPDATE statement. MySQL overrides this. RR(RR(RR]t from_tablet extra_fromsR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytupdate_tables_clausesc s'ddjfd|DS(s~Provide a hook to override the generation of an UPDATE..FROM clause. MySQL and MSSQL override this. sFROM s, c3s-|]#}|jdtdVqdS(RRN(RR(RR:(t from_hintsRR(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s(R=(RR]R_R`RbR((RbRRs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytupdate_from_clauses c sjjit|jgd6td6t|jgd6t_|j}d}|jr}|j ||j|7}nj ||j||}j ||}|j r<t g|j jD]6\\}}} |djjfkr|| f^q} |j| krBj||j| |jt}qBnd} ||7}|d7}|obj|djfd|D7}js|jrjs|j_njr|d j|j7}qn|rj||j|| |} | r|d | 7}qn|jdk rZj|j} | rZ|d | 7}qZnj|} | r|d | 7}njrj r|d j|j7}njjd |S( NRoR*RpsUPDATE R"s SET s, c3s4|]*}|djdd|dVqdS(iRt=iN(R(RR5(RR(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys 'sR?s WHERE i(RRrRXR\RRtisupdatet _extra_fromsR(R)RaRNR'RRRRRRt'render_table_with_column_in_update_fromR=RTRURVRGRcR,RR^R}(RR]RR`RRZRXR\RR8R[textra_from_textR:R{((RRs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_updatest       -          cCsO|dkr|j}ntj||d|jd|}t|_|j|S(NRR(RRRRRRRR(RRRRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_create_crud_bind_paramMs    cs|jrW|jjrWt|jjfd}fd}fd}ntj}tjd}}|||fS(NcsEtj|}t|dr=|jkr=|jj|fS|SdS(NR\(Rt_column_as_keyRR\R(Rtstr_key(t_et(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRk`scs-|jkr"|jj|jfS|jSdS(N(R\RR(R(Rm(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_getattr_col_keygscs1|jkr&d|jj|jfS|jSdS(Ns%s_%s(R\RR(R(Rm(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_col_bind_namemsR(ReRRfRXRRkRBt attrgetter(RRkRnRo((Rms]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_key_getters_for_crud_columnUs c s g_g_g_jdkrnjdkrngjjD]$}|j|ddt f^qFSj rjdn jj \}}jdkri}n"t fdjD}g}dk rxj D]\}} |} | dk r2|j| | qtj| rkjtjd| d|j} nj| j} |j|| fqWnjoj oj } | ojjojj} jr| oj} n3jr jjojjoj} nt} | rbjt krPtjj} qbtj} n| oqjj }i}jrj!rrt dj D}t}xj!D]}x|jD]}||kr|j"|||||<||}tj|rFj||d|t#kd||}n(jj|j|j}|j||fqqWqWx|D]}x|jD]}||krqq|j$dk r_|j$j% r_|j$j&r!|j|j|j$j'jfjj|q|j|j|dd||fjj|q|j(dk rjj|qqWqWnjrj)rfdj)D}n jj}xc|D][}||}||krL||krL|j*|}tj|r^j||d|t#kdj sH||n d||}nt+|tjr|jj,r|j-}|j|_n|j.r| rjj|j|j}ne| r|| krjj|j|j}n(jj|j|j}|j||fqjr |j.r| r| s| s|jj/k r| r|j0dk r|j0j%rjj1r|j0j2 sjj3 rj|j0}|j||fnjj|q|j0j&rR|j|j|j0j'jfjj|q|j|j|dfjj|qjj|q |j0dk r|j0j% sjj1s|jj/kr jj1sjj4r |j|j|dfjj|q q+ |j0dk r{ |j0j%rjj1rx |j0j2 s_jj3 rx j|j0}|j||f| r|| krjj|q|j.sjj|qqx q |j0j&rI |j|j|j0j'jf| r* || kr* jj|qx |j.sx jj|qx q |j|j|dfjj|q+ |j5dk r | r || kr jj|q |j.s jj|q q+ | r+ || kr+ jj|q+ qjr|j$dk r |j$j% r |j$j&r |j|j|j$j'jf| rw || krw jj|q jj|q( |j|j|dfjj|q+ |j(dk r | r || kr jj|q( jj|q+ | r+ || kr+ jj|q+ qqW|r r t|j6fd jDj7|}|r t8j9d d j:d |Dq nj r ||g}|j;fd t<jdDn|S(shcreate a set of tuples representing column/string pairs for use in an INSERT or UPDATE statement. Also generates the Compiled object's postfetch, prefetch, and returning column collections, used for default handling and ultimately populating the ResultProxy's prefetch_cols() and postfetch_cols() collections. Ric3s4|]*} s|kr|tfVqdS(N(Ro(RR(Rktstmt_parameters(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys sRcss*|] \}}tj||fVqdS(N(Rt_clause_element_as_expr(RR5tparam((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys sRc3s%|]}jj|VqdS(N(R\R5(RR(RkR=(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys ss%s_0c3s|]}|VqdS(N((RR (Rk(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys ssUnconsumed column names: %ss, css|]}d|VqdS(s%sN((RR5((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys sc 3s|]\}}gD]\}}||j|krtj||jrzj|||jdd|j|dfqj||jjn|f^qVqdS(Rs%s_%diN(RRt _is_literalRjRt self_group(RRqtrowR5Rt(Rtvalues_0R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s iN(=t postfetchtprefetchRTRRt parametersR\tcolumnsRjRRQRqRRt setdefaultRRuRRRRvRrRMRRURtimplicit_returningt_return_defaultsReRRXR5tpostfetch_lastrowidRftaddRotonupdatet is_sequencetis_clause_elementtargtserver_onupdatet select_namesR}Rt_isnullRt primary_keyt_autoincrement_columnR$tsupports_sequencestoptionaltsequences_optionalt"preexecute_autoincrement_sequencestserver_defaultRRR R R=textendRu(RR=RR5RnRoR{RAR Rtcolkeytneed_pksR~timplicit_return_defaultsRt check_columnstnormalized_paramstaffected_tablesR:Rtcolstcol_keytprocR((RRkRR=RrRxs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRNys   2                                                                     #   c Ks|jjit|jgd6td6t|jgd6t|_d}|jrt||j||j|7}n|d7}|jj |dtdt}|j r.t g|j j D]6\\}}}|d|j jfkr||f^q}|j|kr4|j||j||jt}q4nd}||7}|jr|j|_|jr|d |j||j7}qn|jdk r|jj |} | r|d | 7}qn|jr|j r|d |j||j7}n|jjd |S( NRoR*RpsDELETE sFROM RRR"R?s WHERE i(RRrRXR\RRtisdeleteR(R)RR'RRRRRRRURTRVRGR,R}( Rt delete_stmtRRRZR\RR8R[R:((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_deletesL      -       cCsd|jj|S(Ns SAVEPOINT %s(Rtformat_savepoint(Rtsavepoint_stmt((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_savepointscCsd|jj|S(NsROLLBACK TO SAVEPOINT %s(RR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_rollback_to_savepointscCsd|jj|S(NsRELEASE SAVEPOINT %s(RR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_release_savepoint s(zRRRt EXTRACT_MAPR]tCOMPOUND_KEYWORDSRsRRRMReRRTRVRgRRRtmemoized_instancemethodRRtmemoized_propertyRRRRRRRRRR RRRRR!R"R)R6R9R<R>RGRARSRTR\RaRiRmRjRgRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR$RRR-RRRRRRRRt frozensetR+R R$R)R|R@R*RxR1RGR{RIRKR\R^RaRcRiRjRqRNRRRR(((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR%s >  '  # '                   '                   -       L   D     Y            V   R$ K 7  t DDLCompilercBsOeZejdZejdZedZd dZ dZ dZ dZ dZ edZd Zd Zd Zd Zeed ZdZedZdZdZdZdZdZdZdZdZdZ dZ!dZ"dZ#dZ$dZ%dZ&dZ'RS(!cCs|jj|jdS(N(Rtstatement_compilerR(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR scCs |jjS(N(RR(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR scCs |jjS(N(RR(R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR scCsdS(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR scKs|j}t|jtjr|j}|jj}|j|j}t |dkrn|dd}}n|d|d}}|j d||j d||j d|j |jn|j j |j|S(NiiRiR\Rtfullname(tcontextRttargetRtTableR&RRtformat_table_seqRR}RSRR"R(RtddlRRRtpathR\tsch((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_ddl s   cCs|jj|j}d|S(NsCREATE SCHEMA (Rt format_schemaR(RRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_create_schema* scCs9|jj|j}d|}|jr5|d7}n|S(Ns DROP SCHEMA s CASCADE(RRRtcascade(RtdropRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_drop_schema. s    c Csf|j}|jj}ddjdg|jd|j|dg}d}t}x|jD]}|j}yb|j|d|j o| } | dk r||7}d}|d| 7}n|j rt }nWq^t j k r } tjt j tjd |j|j| jd fq^Xq^W|j|} | rK|d | 7}n|d |j|7}|S( Ns R?tCREATEtTABLERtfirst_pks, s s (in table '%s', column '%s'): %sis, s )%s (RRRR=R(RSRR|RRRRR R Rtraise_from_causetut descriptionRtargstcreate_table_constraintstpost_create_table( RRR\RRt separatorRt create_columnRt processedtcetconst((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_create_table5 s>              )csh|j}|jrdSj|d|}djfd|jD}|rd|d|7}n|S(NRR?c3s|]}j|VqdS(N(R(RR(R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys f s(RtsystemRtget_column_specificationR=t constraints(RRRRRR((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_create_column\ s   cs{g}|jr"|j|jn|jg|jD]}||jk r2|^q2djdfd|DDS(Ns, css!|]}|dk r|VqdS(N(R(Rtp((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys x s c3s\|]R}|jdks'|jrjj sGt|dt rj|VqdS(t use_alterN(t _create_ruleRRtsupports_alterRRR(RR(R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys y s  (RRrRt_sorted_constraintsR=(RR\RR5((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRm s   cCsd|jj|jS(Ns DROP TABLE (RRSR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_drop_table scCsd|jj|jS(Ns DROP VIEW (RRSR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_drop_view scCs,|jdkr(tjd|jndS(Ns,Index '%s' is not associated with any table.(R\RR R R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_verify_index_table s cs|j}j|j}d}|jr;|d7}n|dj|d||j|jd|djfd|jDf7}|S(NsCREATE sUNIQUE sINDEX %s ON %s (%s)tinclude_schemat use_schemas, c3s-|]#}jj|dtdtVqdS(RRN(RRRR(RR8(R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys s( RRRRbt_prepared_index_nameRSR\R=t expressions(RRRtinclude_table_schemaRRR((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_create_index s       cCs |j}d|j|dtS(Ns DROP INDEX R(RRR(RRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_drop_index s  cCs|rB|jdk rB|jjrB|jj}|jj|}nd}|j}t|tjr|j j px|j j }t ||kr|d|d!dt j|d}qn|j j||jj|}|r|d|}n|S(NiiRiR (R\RRRRRRRRRtmax_index_name_lengthRRRtmd5_hextvalidate_identifierR(RRRRt schema_nameRtmax_t index_name((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR s!    ,cCs,d|jj|jj|j|jfS(NsALTER TABLE %s ADD %s(RRSRR\R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_add_constraint scCsod|jj|j}|jjdk rB|d|jj7}n|jjdk rk|d|jj7}n|S(NsCREATE SEQUENCE %ss INCREMENT BY %ds START WITH %d(Rtformat_sequenceRt incrementRtstart(RRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_create_sequence scCsd|jj|jS(NsDROP SEQUENCE %s(RRR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_drop_sequence scCsAd|jj|jj|jj|j|jr9dp<dfS(Ns#ALTER TABLE %s DROP CONSTRAINT %s%ss CASCADER(RRSRR\tformat_constraintR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_drop_constraint scKsr|jj|d|jjj|j}|j|}|dk rX|d|7}n|jsn|d7}n|S(NR?s DEFAULT s NOT NULL( RRRRRRtget_column_default_stringRtnullable(RRRtcolspecR$((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR s   cCsdS(NR((RR\((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR scCs\t|jtjrTt|jjtjr;d|jjS|jj|jjSndSdS(Ns'%s'( RRRt DefaultClauseRRt string_typesRRR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR s cCsd}|jdk rG|jj|}|dk rG|d|7}qGn|d|jj|jdtdt7}||j |7}|S(NRsCONSTRAINT %s s CHECK (%s)RR( RRRRRRRRRtdefine_constraint_deferrability(RRRtformatted_name((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_check_constraint s  cCsod}|jdk rG|jj|}|dk rG|d|7}qGn|d|j7}||j|7}|S(NRsCONSTRAINT %s s CHECK (%s)(RRRRRR(RRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_column_check_constraint s cst|dkrdSd}|jdk r]jj|}|dk r]|d|7}q]n|d7}|ddjfd|D7}|j|7}|S(NiRsCONSTRAINT %s s PRIMARY KEY s(%s)s, c3s$|]}jj|jVqdS(N(RRR(RR5(R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys  s(RRRRRR=R(RRRR((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_primary_key_constraint s  cs|jjd}|jdk rS|jj|}|dk rS|d|7}qSnt|jjdj j }|ddj fd|jjD|j ||dj fd|jjDf7}||j |7}||j|7}||j|7}|S(NRsCONSTRAINT %s is"FOREIGN KEY(%s) REFERENCES %s (%s)s, c3s$|]}j|jjVqdS(N(RtparentR(RR9(R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys  sc3s$|]}j|jjVqdS(N(RRR(RR9(R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys " s(RRRRRRRet _elementsRARR\R=tdefine_constraint_remote_tabletdefine_constraint_matchtdefine_constraint_cascadesR(RRRRt remote_table((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_foreign_key_constraint s$   cCs |j|S(s=Format the remote table clause of a CREATE CONSTRAINT clause.(RS(RRR\R((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR* scst|dkrdSd}|jdk rNjj|}|d|7}n|ddjfd|D7}|j|7}|S(NiRsCONSTRAINT %s s UNIQUE (%s)s, c3s$|]}jj|jVqdS(N(RRR(RR5(R(s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pys 7 s(RRRRRR=R(RRRR((Rs]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_unique_constraint/ scCsPd}|jdk r)|d|j7}n|jdk rL|d|j7}n|S(NRs ON DELETE %ss ON UPDATE %s(tondeleteRR(RRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR< s cCs_d}|jdk r8|jr+|d7}q8|d7}n|jdk r[|d|j7}n|S(NRs DEFERRABLEs NOT DEFERRABLEs INITIALLY %s(R%RR7(RRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRD s   cCs-d}|jdk r)|d|j7}n|S(NRs MATCH %s(tmatchR(RRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRO sN((RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR(((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR sB     '                 tGenericTypeCompilercBseZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!d Z"d!Z#d"Z$d#Z%d$Z&d%Z'd&Z(d'Z)d(Z*d)Z+RS(*cCsdS(NtFLOAT((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_FLOATX scCsdS(NtREAL((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_REAL[ scCsT|jdkrdS|jdkr4di|jd6Sdi|jd6|jd6SdS(NtNUMERICsNUMERIC(%(precision)s)t precisions!NUMERIC(%(precision)s, %(scale)s)tscale(RRR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_NUMERIC^ s cCsT|jdkrdS|jdkr4di|jd6Sdi|jd6|jd6SdS(NtDECIMALsDECIMAL(%(precision)s)Rs!DECIMAL(%(precision)s, %(scale)s)R(RRR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_DECIMALi s cCsdS(NtINTEGER((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_INTEGERt scCsdS(NtSMALLINT((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_SMALLINTw scCsdS(NtBIGINT((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_BIGINTz scCsdS(Nt TIMESTAMP((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_TIMESTAMP} scCsdS(NtDATETIME((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_DATETIME scCsdS(NtDATE((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_DATE scCsdS(NtTIME((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_TIME scCsdS(NtCLOB((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_CLOB scCsdS(NtNCLOB((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_NCLOB scCsD|}|jr#|d|j7}n|jr@|d|j7}n|S(Ns(%d)s COLLATE "%s"(tlengtht collation(RRRR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_render_string_type s   cCs|j|dS(NtCHAR(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_CHAR scCs|j|dS(NtNCHAR(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_NCHAR scCs|j|dS(NtVARCHAR(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_VARCHAR scCs|j|dS(NtNVARCHAR(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_NVARCHAR scCs|j|dS(NtTEXT(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_TEXT scCsdS(NtBLOB((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_BLOB scCsd|jrd|jpdS(NtBINARYs(%d)R(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_BINARY scCsd|jrd|jpdS(Nt VARBINARYs(%d)R(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_VARBINARY scCsdS(NtBOOLEAN((RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_BOOLEAN scCs |j|S(N(R&(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_large_binary scCs |j|S(N(R,(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_boolean scCs |j|S(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_time scCs |j|S(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_datetime scCs |j|S(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_date scCs |j|S(N(R (RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_big_integer scCs |j|S(N(R (RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_small_integer scCs |j|S(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_integer scCs |j|S(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_real scCs |j|S(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_float scCs |j|S(N(R(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_numeric scCs |j|S(N(R (RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_string scCs |j|S(N(R (RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_unicode scCs |j|S(N(R$(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_text scCs |j|S(N(R$(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_unicode_text scCs |j|S(N(R (RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt visit_enum scCstjd|dS(NsKCan't generate DDL for %r; did you forget to specify a type on this Column?(R R (RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR9 s cCs|j|j|jS(N(Rt type_engineR(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_type_decorator scCs |jS(N(t get_col_spec(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytvisit_user_defined s(,RRRRRRRR R R RRRRRRRRR R"R$R&R(R*R,R-R.R/R0R1R2R3R4R5R6R7R8R9R:R;R<R9R>R@(((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyRV sT                                      tIdentifierPreparercBs eZdZeZeZeZddde dZ dZ dZ dZdZddZddZed Zdd Zdd Zdd Zejd dZeddZddZe dddZedZejdZdZ RS(s@Handle quoting and case-folding of identifiers based on options.t"cCsS||_||_|p|j|_||_|jd|_||_i|_dS(ssConstruct 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. iN(Rt initial_quotet final_quotet escape_quotetescape_to_quotet omit_schemat_strings(RRRCRDRERG((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR s    cCs|j|j|jS(sEscape an identifier. Subclasses should override this to provide database-dependent escaping behavior. (RRERF(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_escape_identifier scCs|j|j|jS(sCanonicalize an escaped identifier. Subclasses should override this to provide database-dependent unescaping behavior that reverses _escape_identifier. (RRFRE(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_unescape_identifier scCs|j|j||jS(s~Quote an identifier. Subclasses should override this to provide database-dependent quoting behavior. (RCRIRD(RR((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pytquote_identifier# scCsT|j}||jkpS|d|jkpS|jjtj| pS||kS(s5Return True if the given identifier requires quoting.i(Rbtreserved_wordstillegal_initial_characterstlegal_charactersRRt text_type(RRtlc_value((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyt_requires_quotes. s  cCs|j||S(sConditionally quote a schema. Subclasses can override this to provide database-dependent quoting behavior for schema names. the 'force' flag should be considered deprecated. (R(RRtforce((s]/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/compiler.pyR6 s cCst|dd}|dkr{||jkr8|j|S|j|r`|j||j|s @     :                                                   c Q