§ ä[©âyÚãól—dZddlZddlZddlZddlmZddlmZddlmZddlmZddlm Z dd lm Z dd lmZddlmZdd lm Z ddlmZegd¢¦«Zejdej¦«Zejdej¦«Zd„edd¦«D¦« dg¦«Zejdej¦«Zejdej¦«Zejdej¦«Zejdej¦«Zejdej¦«ZddddddœZiejd“ej d “ej!d!“ej"d"“ej#d#“ej$d$“ej%d%“ej&d$“ej'd&“ej(d'“ej)d(“ej*d)“ej+d*“ej,d+“ej-d,“ej.d-“ej/d.“iej0d/“ej1d0“ej2d1“ej3d2“ej4d3“ej5d4“ej6d5“ej7d6“ej8d7“ej9d8“ej:d9“ej;d:“ej<d;“ej=d<“ej>d=“ej?d>“ej@d?“¥ejAd@ejBdAejCdBi¥ZDejEdCejFdDejGdEejHdFejIdGejJdHejKdIejLdJejMdKejNdLejOdMejPdNejQdOejRdPiZSdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`œZTe jUjVdae jUjWdbe jUjXdce jUjYdde jUjZdee jUj[dfiZ\Gdg„dhe]¦«Z^Gdi„djej_ej`e]¦«¦«ZaGdk„dlejb¦«ZcGdm„dned¦«ZeGdo„dpe^¦«ZfGdq„dref¦«ZgGds„dte^¦«ZhGdu„dvea¦«ZiGdw„dxei¦«ZjGdy„dze]¦«ZkdS){a]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`. éNé)Úcrud)Úelements)Ú functions)Ú operators)Úschema)Ú selectable)Úsqltypes)Úvisitorsé)Úexc)Úutil)^ÚallÚanalyseÚanalyzeÚandÚanyÚarrayÚasÚascÚ asymmetricÚ authorizationÚbetweenÚbinaryÚbothÚcaseÚcastÚcheckÚcollateÚcolumnÚ constraintÚcreateÚcrossÚcurrent_dateÚcurrent_roleÚcurrent_timeÚcurrent_timestampÚcurrent_userÚdefaultÚ deferrableÚdescÚdistinctÚdoÚelseÚendÚexceptÚfalseÚforÚforeignÚfreezeÚfromÚfullÚgrantÚgroupÚhavingÚilikeÚinÚ initiallyÚinnerÚ intersectÚintoÚisÚisnullÚjoinÚleadingÚleftÚlikeÚlimitÚ localtimeÚlocaltimestampÚnaturalÚnewÚnotÚnotnullÚnullÚoffÚoffsetÚoldÚonÚonlyÚorÚorderÚouterÚoverlapsÚplacingÚprimaryÚ referencesÚrightÚselectÚsession_userÚsetÚsimilarÚsomeÚ symmetricÚtableÚthenÚtoÚtrailingÚtrueÚunionÚuniqueÚuserÚusingÚverboseÚwhenÚwherez ^[A-Z0-9_$]+$z^[A-Z0-9_ $]+$có,—h|]}t|¦«’ŒS©)Ústr)Ú.0Úxs úk/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/sql/compiler.pyú rss€Ð;Ð;Ð;¨c !™fœfÐ;Ð;Ð;óé ú$z5^(?:RESTRICT|CASCADE|SET NULL|NO ACTION|SET DEFAULT)$z^(?:DEFERRED|IMMEDIATE)$z%(? z >= z = z IS DISTINCT FROM z IS NOT DISTINCT FROM z || z MATCH z NOT MATCH z IN z NOT IN ú, ú FROM ú AS ú IS z IS NOT z COLLATE zEXISTS ú DISTINCT zNOT zANY zALL z DESCz ASCz NULLS FIRSTz NULLS LASTÚcoalesceÚCURRENT_DATEÚCURRENT_TIMEÚCURRENT_TIMESTAMPÚCURRENT_USERÚ LOCALTIMEÚLOCALTIMESTAMPÚrandomÚsysdateÚSESSION_USERÚUSERÚCUBEÚROLLUPz GROUPING SETSÚmonthÚdayÚyearÚsecondÚhourÚdoyÚminuteÚquarterÚdowÚweekÚepochÚmillisecondsÚmicrosecondsÚ timezone_hourÚtimezone_minute)r’r“r”r•r–r—r˜r™ršr›rœrržrŸr ÚUNIONz UNION ALLÚEXCEPTz EXCEPT ALLÚ INTERSECTz INTERSECT ALLcóè—eZdZdZdZdZej¦«Z ddej¦«fd„Z ej dd¦«d„¦«Zd„Ze d„¦«Zd „Zd „Zdd„Ze d„¦«Zd „Zd„ZdS)ÚCompiledaRepresent 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. Ncó—||_||_|jj|_||_|r|j |¦«|_|@||_|j|_|jr|j |_ |j|jfi|¤Ž|_dSdS)a|Construct a new :class:`.Compiled` object. :param dialect: :class:`.Dialect` to compile against. :param statement: :class:`_expression.ClauseElement` to be compiled. :param bind: Optional Engine or Connection to compile this statement against. :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) ÚdialectÚbindÚidentifier_preparerÚpreparerÚschema_translate_mapÚ_with_schema_translateÚ statementÚsupports_executionÚcan_executeÚ_execution_optionsÚexecution_optionsÚprocessÚstring)Úselfr§rr¨r«Úcompile_kwargss rrÚ__init__zCompiled.__init__s¥€ð@ˆŒØˆŒ ØœÔ8ˆŒ Ø$8ˆÔ!Øð Ø œM×@Ò@Ø$ñôˆDŒMðÐ Ø&ˆDŒNØ(Ô;ˆDÔØÔð FØ)2Ô)EÔ&Ø&˜$œ, t¤~ÐHÐH¸ÐHÐHˆDŒKˆKˆKð!Ð rtz0.7zÊThe :meth:`.Compiled.compile` method is deprecated and will be removed in a future release. The :class:`.Compiled` object now runs its compilation within the constructor, and this method does nothing.có—dS)z;Produce the internal string representation of this element.Nrn©r´s rrÚcompilezCompiled.compileDs €ð ˆrtcóp—|jr| |||¦«Stj|j¦«‚©N)r¯Ú_execute_compiledr ÚObjectNotExecutableErrorr)r´Ú connectionÚmultiparamsÚparamss rrÚ_execute_on_connectionzCompiled._execute_on_connectionOs8€ØÔð ?Ø×/Ò/°°kÀ6ÑJÔJÐJåÔ.¨t¬~Ñ>Ô>Ð>rtcó—t¦«‚)zReturn a Compiled that is capable of processing SQL expressions. If this compiler is one, it would likely just return 'self'. ©ÚNotImplementedErrorr¸s rrÚsql_compilerzCompiled.sql_compilerUó€õ"Ñ#Ô#Ð#rtcó—|j|fi|¤ŽSr»©Ú_compiler_dispatch)r´ÚobjÚkwargss rrr²zCompiled.process_s€Ø%ˆsÔ% dÐ5Ð5¨fÐ5Ð5Ð5rtcó—|jpdS)z3Return the string text of the generated SQL or DDL.Ú)r³r¸s rrÚ__str__zCompiled.__str__bs€ðŒ{Ð ˜bÐ rtcó—t¦«‚)zâ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. rÃ©r´rÀs rrÚconstruct_paramszCompiled.construct_paramsgrÆrtcó*—| ¦«S)z0Return the bind params for this compiled object.©rÑr¸s rrrÀzCompiled.paramsqs€ð×$Ò$Ñ&Ô&Ð&rtcón—|j}|€tjdd¬¦«‚| |||¦«S)zExecute this compiled object.Nz>This Compiled object is not bound to any Engine or Connection.Ú2afi©Úcode)r¨r ÚUnboundExecutionErrorr¼)r´r¿rÀÚes rrÚexecutezCompiled.executevsL€ð ŒIˆØˆ9ÝÔ+ð!àðñôð ð ×"Ò" 4¨°fÑ=Ô=Ð=rtcó@—|j|i|¤Ž ¦«S)zJExecute this compiled object and return the result's scalar value.)rÚÚscalar)r´r¿rÀs rrrÜzCompiled.scalar‚s'€ðˆtŒ|˜[Ð3¨FÐ3Ð3×:Ò:Ñ<Ô<Ðð >ð >ð=ð=ð=ð=ð=rtr¥có"—eZdZdZdZd„Zd„ZdS)ÚTypeCompilerz2Produces DDL specification for TypeEngine objects.z visit_\w+có—||_dSr»)r§)r´r§s rrr¶zTypeCompiler.__init__Žs €ØˆŒˆˆrtcó—|j|fi|¤ŽSr»rÈ©r´Útype_Úkws rrr²zTypeCompiler.process‘s€Ø'ˆuÔ'¨Ð3Ð3°Ð3Ð3Ð3rtN)rÝrÞrßràÚensure_kwargr¶r²rnrtrrræræ‰s=€€€€€Ø<Ð<à€Lðððð4ð4ð4ð4ð4rtræcóT—eZdZdZdZdZd d„Zed„¦«Zed„¦«Z d„Z d S)Ú _CompileLabelz;lightweight label object which acts as an expression.Label.Úlabel)ÚelementÚnamerncó8—||_||_|f|z|_dSr»)rðrñÚ _alt_names)r´ÚcolrñÚ alt_namess rrr¶z_CompileLabel.__init__œs"€ØˆŒØˆŒ Ø˜& 9Ñ,ˆŒˆˆrtcó—|jjSr»)rðÚ proxy_setr¸s rrr÷z_CompileLabel.proxy_set¡s €àŒ|Ô%Ð%rtcó—|jjSr»)rðÚtyper¸s rrrùz_CompileLabel.type¥s €àŒ|Ô Ð rtcó—|Sr»rn)r´rës rrÚ self_groupz_CompileLabel.self_group©s€ØˆrtN)rn)rÝrÞrßràÚ__visit_name__Ú __slots__r¶rär÷rùrûrnrtrrrîrî•s}€€€€€àEÐEà€NØ!€Ið-ð-ð-ð-ð ð&ð&ñ„Xð&ðð!ð!ñ„Xð!ðððððrtrîcó—eZdZdZd„ZdS)Úprefix_anon_mapacA map that creates new keys for missing key access. Considers keys of the form " " to produce new symbols "_", where "index" is an incrementing integer corresponding to . Inlines the approach taken by :class:`sqlalchemy.util.PopulateDict` which is otherwise usually used for this type of operation. có¨—| dd¦«\}}| |d¦«}|dz||<|dzt|¦«z}|||<|S)Nú rÚ_)ÚsplitÚgetro)r´ÚkeyÚidentÚderivedÚanonymous_counterÚvalues rrÚ__missing__zprefix_anon_map.__missing__¶sa€ØŸ9š9 S¨!Ñ,Ô,ÑˆØ ŸHšH W¨aÑ0Ô0ÐØ)¨AÑ-ˆˆW‰ Ø˜#‘ ¥Ð$5Ñ 6Ô 6Ñ6ˆØˆˆS‰ ØˆrtN)rÝrÞrßràr rnrtrrrÿrÿs-€€€€€ðððððððrtrÿcó—eZdZdZeZeZdxZxZ Z dZdZ dZ dZ dZ dZ dZ dZ dZ dZ dxZZ d‡d„Zed„¦«Zed„¦«Zejd „¦«Zejd „¦«Z d„Z!ej"d„¦«Z#d „Z$ed„¦«Z%dˆd„Z&ed„¦«Z'ej(d¦«d„¦«Z)d„Z*d‰d„Z+ d‰d„Z, d‰d„Z- dŠd„Z.d„Z/ d‹d„Z0d„Z1d„Z2d„Z3d„Z4d„Z5d„Z6d „Z7 dŒd!„Z8d"„Z9d#„Z:d$„Z;d%„Zd(„Z?d)„Z@d*„ZAd+„ZBd,„ZCd-„ZDdd.„ZEd/„ZFd0„ZGd1„ZH dŽd3„ZId4„ZJd5„ZKd6„ZLd7„ZMd8„ZNd9„ZOd:„ZPd;„ZQd<„ZR d‡d=„ZSd>„ZTd?„ZUd@„ZVdA„ZWdB„ZX d‰dC„ZYdD„ZZdE„Z[ej"dF„¦«Z\dG„Z]dH„Z^dI„Z_dJ„Z`dK„ZadL„ZbdM„ZcdN„ZddO„ZedP„ZfdQ„ZgdR„Zh ddS„ZidT„ZjdU„ZkdV„ZldW„ZmdX„Zn d‡dY„Zo ddZ„Zp d‘d[„Zqd\„Zrd‰d]„Zsd^„Ztd_„Zu d’d`„Zvda„Zwdb„Zxdc„Zydd„Zzde„Z{df„Z|dg„Z}ej~dhe¦«fdie¦«fg¦«Z€d‰dj„Z d“dk„Z‚dl„Zƒdm„Z„dn„Z…do„Z†dp„Z‡dq„Zˆdr„Z‰ds„ZŠdt„Z‹du„ZŒdv„Zdw„ZŽ d”dx„Zd‰dy„Zdz„Z‘d‰d{„Z’d|„Z“d}„Z”d~„Z•d‰d„Z–ej"d€„¦«Z—d„Z˜d‚„Z™d‰dƒ„Zšd„„Z›d…„Zœd†„ZdS)•ÚSQLCompilerz~Default implementation of :class:`.Compiled`. Compiles :class:`_expression.ClauseElement` objects into SQL strings. FNTrncóL—||_|pt|dd¦«|_i|_t j¦«|_g|_g|_|j |_ |j rg|_ |jdk|_t|j|_d|_|jp|j|_t%¦«|_i|_t+j|||fi|¤Ž|js|js|jr|jr|j|_|j r|jr| ¦«dSdSdS)aConstruct 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 inline: whether to generate INSERT statements as "inline", e.g. not formatted to return any generated defaults :param kwargs: additional keyword arguments to be consumed by the superclass. ÚinlineFr{N)Úcolumn_keysÚgetattrrÚbindsrÚcolumn_dictÚ bind_namesÚstackÚ_result_columnsÚ positionalÚpositiontupÚ paramstyleÚ_numeric_bindsÚBIND_TEMPLATESÚbindtemplateÚctesÚlabel_lengthÚmax_identifier_lengthrÿÚanon_mapÚtruncated_namesr¥r¶ÚisinsertÚisupdateÚisdeleteÚ _returningÚ returningÚ_apply_numbered_params)r´r§rrrrËs rrr¶zSQLCompiler.__init__s_€ð&'ˆÔðÐC¥¨ °8¸UÑ CÔ CˆŒðˆŒ õÔ*Ñ,Ô,ˆŒðˆŒ ð "ˆÔð"Ô,ˆŒØŒ?ð BØ!ˆDÔØ")Ô"4¸ Ò"AˆDÔÝ*¨7Ô+=Ô>ˆÔàˆŒ ð Ô ÐA GÔ$Að Ôõ(Ñ)Ô)ˆŒ ð "ˆÔåÔ˜$ ¨Ð=Ð=°fÐ=Ð=Ð=ð ŒMð 2Ø!œ]ð 2Ø.2¬mð 2àÔ"ð 2ð'Ô1ˆDŒNàŒ?ð *˜tÔ2ð *Ø×'Ò'Ñ)Ô)Ð)Ð)Ð)ð *ð *ð *ð *rtcó — |jddS#t$r.}tjtd¦«|¬¦«Yd}~dSd}~wwxYw)a±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. éÿÿÿÿr z$Compiler does not have a stack entry©Úreplace_contextN)rÚ IndexErrorrÚraise_)r´Úies rrÚcurrent_executablezSQLCompiler.current_executableZs}€ð< Ø”:˜b”> ,Ô/Ð/øÝð ð ð ÝŒKÝÐAÑBÔBØ "ð ñ ô ð ð ð ð ð ð ð øøøøð øøøs‚• A Ÿ#AÁA có:—t|j|jz¦«Sr»)ÚlistÚinsert_prefetchÚupdate_prefetchr¸s rrÚprefetchzSQLCompiler.prefetch€s€åDÔ(¨4Ô+?Ñ?Ñ@Ô@Ð@rtcór—tj¦«|_i|_d|_|jr i|_dSdS)z’Initialize collections related to CTEs only if a CTE is located, to save on the overhead of these collections otherwise. FN)rÚOrderedDictrÚctes_by_nameÚctes_recursiverÚcte_positionalr¸s rrÚ_init_cte_statezSQLCompiler._init_cte_state„sF€õÔ$Ñ&Ô&ˆŒ ØˆÔØ#ˆÔØŒ?ð %Ø"$ˆDÔÐÐð %ð %rtc#ó@K—|j|j}}gdc|_|_ |jr|jd}d|d<nd}|j|jfV—|r| d¦«||c|_|_dS#|r| d¦«||c|_|_wxYw)z;special API to support the use case of 'nested result sets'Fr(TÚneed_result_map_for_nestedN)rÚ_ordered_columnsrÚpop)r´Úresult_columnsÚordered_columnsÚentrys rrÚ_nested_resultzSQLCompiler._nested_result’sðèè€ð Ô ØÔ!ð(ˆð79¸%Ð3ˆÔ˜dÔ3ð ØŒzð Øœ 2œØ6:Ð2Ñ3Ð3àØÔ&¨Ô(=Ð=Ð=Ð=Ð=àð 8Ø— ’ Ð6Ñ7Ô7Ð7àØð 8ˆDÔ $Ô"7Ð"7Ð"7øðð 8Ø— ’ Ð6Ñ7Ô7Ð7àØð 8ˆDÔ $Ô"7ð ð ð ð s¡,A5Á5(Bcóv‡—tjd¦«Štjdˆfd„|j¦«|_dS)Nrz \[_POSITION\]cóF•—ttj‰¦«¦«Sr»)rorÚnext)ÚmÚposcounts €rrúz4SQLCompiler._apply_numbered_params..sø€D¬I°hÑ,?Ô,?Ñ(@Ô(@€rt)Ú itertoolsÚcountÚreÚsubr³)r´rFs @rrr&z"SQLCompiler._apply_numbered_paramsªs<ø€Ý”? 1Ñ%Ô%ˆÝ”fØÐ@Ð@Ð@Ð@À$Ä+ñ ô ˆŒˆˆrtcóX‡—td„ˆfd„‰jD¦«D¦«¦«S)Nc3ó(K—|] \}}|®||fV—ŒdSr»rn)rprr s rrú z/SQLCompiler._bind_processors..²s@èè€ð ð áUðÐ ð%ˆLð!Ð Ð Ð ð ð rtc3óp•K—|]0}‰j||j ‰j¦«fV—Œ1dSr»)rrùÚ_cached_bind_processorr§)rpÚ bindparamr´s €rrrNz/SQLCompiler._bind_processors..´sZøèè€ððð ð”O IÔ.Ø”N×9Ò9¸$¼,ÑGÔGðððððððrt)Údictrr¸s`rrÚ_bind_processorszSQLCompiler._bind_processors°sXø€åð ð ððððð "&¤ðñôð ñ ô ñ ô ð rtcó2—t|j¦«dkS©Nr)Úlenrr¸s rrÚis_subqueryzSQLCompiler.is_subquery¾s€Ý4”:‰Œ Ò"Ð"rtcó—|Sr»rnr¸s rrrÅzSQLCompiler.sql_compilerÁs€àˆrtcól—|rªi}|jD]ž}|j|}|j|vr||j||<Œ)||vr||||<Œ9|rG|jr@|r tjd|j|fzd¬¦«‚tjd|jzd¬¦«‚|jr|j||<Œ”|j||<ŒŸ|Si}|jD]}}|rG|jr@|r tjd|j|fzd¬¦«‚tjd|jzd¬¦«‚|jr|j||j|<Œh|j||j|<Œ~|S)z5return a dictionary of bind parameter keys and valuesz@A value is required for bind parameter %r, in parameter group %dÚcd3xrÖz)A value is required for bind parameter %r)rrÚrequiredr ÚInvalidRequestErrorÚcallableÚeffective_valuer )r´rÀÚ _group_numberÚ_checkÚpdrQrñs rrrÑzSQLCompiler.construct_paramsÅsÜ€ðð3 ØˆBØ!œ_ð /ð / Ø” yÔ1Ø”= FÐ*Ð*Ø% i¤mÔ4Bt‘HHØ˜V^^Ø% dœ|Bt‘HHàð/ Ô 2ð/Ø$ðÝ!Ô5ð4à(œ}¨mÐ<ñ=ð"(ð ñôðõ"Ô5ØGØ'œmñ,à!'ðñôððÔ'ð/Ø(Ô8Bt‘HHà(œBt‘HHØˆIàˆBØ!œ_ð Eð E Øð ˜iÔ0ð Ø$ðÝ!Ô5ð4à(œ}¨mÐ<ñ=ð"(ð ñôðõ"Ô5ØGØ'œmñ,à!'ðñôððÔ%ðEØ5>Ô5NBt” yÔ1Ñ2Ð2à5>´_Bt” yÔ1Ñ2Ð2ØˆIrtcó.—| d¬¦«S)zoReturn the bind param dictionary embedded into this compiled object, for those values that are present.F)r`rÓr¸s rrrÀzSQLCompiler.paramsýs€ð×$Ò$¨EÐ$Ñ2Ô2Ð2rtzsqlalchemy.engine.resultcó@—|j |j¦«S)z(utility method used for unit tests only.)ÚResultMetaDataÚ_create_result_mapr)r´Úresults rrrezSQLCompiler._create_result_maps€ðÔ$×7Ò7¸Ô8LÑMÔMÐMrtcó—dS)z´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Írnr¸s rrÚdefault_fromzSQLCompiler.default_froms €ðˆrrtcó4—d|jj|fi|¤ŽzdzS)Nú(ú)©rðrÉ)r´ÚgroupingÚasfromrËs rrÚvisit_groupingzSQLCompiler.visit_groupings+€ØÐ8XÔ%Ô8¸ÐHÐHÀÐHÐHÑHÈ3ÑNÐNrtcó(—|jrw|jjrk|jdd}|j\}}}|r|}n|}|jj} | 8| j|vr/| || j¦«r|jj|d<|j|jfd|i|¤ŽS)Nr(r Úrender_label_as_labelÚwithin_columns_clause) rr§Úsupports_simple_order_by_labelÚ_label_resolve_dictrðÚ_order_by_label_elementrñÚshares_lineager²) r´rðrrrËr Ú with_colsÚ only_fromsÚ only_colsÚresolve_dictÚ order_by_elems rrÚvisit_label_referencez!SQLCompiler.visit_label_referencesÝ€ðŒ:ð <˜$œ,ÔEð <Øœ Bœ¨Ô5ˆJà/9Ô/MÑ,ˆIz 9Ø$ð )Ø)à(ð$œOÔCˆMðÐ)Ø!Ô&¨,Ð6Ð6Ø!×0Ò0Ø Ô!3Ô4ñôð7ð”OÔ;ðØ+ñðˆtŒ|ØŒOð ð à"7ð ðð ð ð rtcód—|js| |j¦«S|jdd}|j\}}} |r||j}n ||j}||d<|j|fd|i|¤ŽS#t $r2} t j|jtj d| ¬¦«Yd} ~ dSd} ~ wwxYw)Nr(r rqrrzECan't resolve label reference for ORDER BY / GROUP BY / DISTINCT etc.)Úerr) rr²Ú_text_clausertrðÚKeyErrorrÚ_no_text_coercionr ÚCompileError) r´rðrrrËr rwrxryrôÚkes rrÚvisit_textual_label_referencez)SQLCompiler.visit_textual_label_reference6s€ðŒzð 6à—<’< Ô 4Ñ5Ô5Ð5à”Z ”^ LÔ1ˆ Ø+5Ô+IÑ(ˆ :˜yð Ø$ð 1Ø ¤Ô1à ¤Ô0ð/2ˆFÐ*Ñ+Ø4”<ØððØ+@ðØDJððð øõð ð ð ÝÔ&Ø”ÝÔ ð+àð ñ ô ð ð ð ð ð ð ð øøøøð øøøsÁA3Á3 B/Á='B*Â*B/cóä—|o|}||u}|s|rBt|jtj¦«r| d|j¦«} n|j} |rn|"|| |j|| f|jz|j¦«|jj|fdddœ|¤Žttjz|j || ¦«zS|r|j || ¦«S|jj|fddi|¤ŽS)NÚcolidentT)rrÚwithin_label_clauserrF)Ú isinstancerñrÚ_truncated_labelÚ_truncated_identifierrórùrðrÉÚ OPERATORSrÚas_rªÚformat_label) r´rïÚadd_to_result_mapr‡rrrqrëÚrender_label_with_asÚrender_label_onlyÚ labelnames rrÚvisit_labelzSQLCompiler.visit_labelRsa€ð "Ð=Ð*=Ð&=ð ð2°UÐ:Ðàð 'Ð 4ð 'Ý˜%œ*¥hÔ&?Ñ@Ô@ð 'Ø ×6Ò6°zÀ5Ä:ÑNÔN à!œJ àð Ø Ð,Ø!Ð!ØØ”JØ˜IÐ&¨Ô)9Ñ9Ø”Jñ ôðð1” Ô0Øðà*.Ø(,ðððð ðõIœMÔ*ñ +ð”-×,Ò,¨U°IÑ>Ô>ñ?ð ðð Ø”=×-Ò-¨e°YÑ?Ô?Ð?à35”=Ô3ØððØ,1ðØ57ððð rtcó*—tjd¦«‚)Nz:Cannot compile Column object until its 'name' is assigned.©r r‚©r´r s rrÚ_fallback_column_namez!SQLCompiler._fallback_column_nameƒs€ÝÔØKñ ô ð rtcó¦—|jx}}|€| |¦«}|j}|s0t|tj¦«r| d|¦«}|||||||jf|j¦«|r| |¦«}n|j |¦«}|j}| |r|j s|S|j |¦«} | r|j | ¦«dz} nd} |j}t|tj¦«r| d|¦«}| |j |¦«zdz|zS)Nr†ú.rÍÚalias)rñr–Ú is_literalrˆrr‰rŠrrùÚescape_literal_columnrªÚquoteraÚnamed_with_columnÚschema_for_objectÚquote_schema)r´r rŽÚ include_tablerËrñÚ orig_nameršraÚeffective_schemaÚ schema_prefixÚ tablenames rrÚvisit_columnzSQLCompiler.visit_columnˆs€€ð"œ;Ð&ˆˆyØˆ<Ø×-Ò-¨fÑ5Ô5ˆDàÔ&ˆ Øð @j¨xÔ/HÑIÔIð @Ø×-Ò-¨j¸$Ñ?Ô?ˆDàÐ(ØÐØi &¨$°´ Ð!;¸V¼[ñ ô ð ðð -ð×-Ò-¨dÑ3Ô3ˆDˆDà”=×&Ò& tÑ,Ô,ˆDØ”ˆØˆ= ˆ=°UÔ5Lˆ=ØˆKà#œ}×>Ò>¸uÑEÔEÐàð #à”M×.Ò.Ð/?Ñ@Ô@À3ÑFð ð!# Øœ ˆIÝ˜)¥XÔ%>Ñ?Ô?ð KØ ×6Ò6°wÀ ÑJÔJ à 4¤=×#6Ò#6°yÑ#AÔ#AÑAÀCÑGÈ$ÑNÐNrtcó@—|j |j¦«Sr»)rªÚformat_collationÚ collation)r´rðrës rrÚvisit_collationzSQLCompiler.visit_collation°s€ØŒ}×-Ò-¨gÔ.?Ñ@Ô@Ð@rtcó—|jSr»©rñ)r´Ú fromclauserËs rrÚvisit_fromclausezSQLCompiler.visit_fromclause³s €ØŒÐrtcó—|jSr»r«)r´ÚindexrËs rrÚvisit_indexzSQLCompiler.visit_index¶s €ØŒzÐrtcóF—||d<|jjj|jfi|¤ŽS)NÚtype_expression)r§Ú type_compilerr²rù)r´Ú typeclauserës rrÚvisit_typeclausezSQLCompiler.visit_typeclause¹s/€Ø *ˆÐÑØ1ˆtŒ|Ô)Ô1°*´/ÐHÐHÀRÐHÐHÐHrtcóJ—|jjr| dd¦«}|S©Nú%ú%%©rªÚ_double_percentsÚreplace©r´Útexts rrÚpost_process_textzSQLCompiler.post_process_text½ó'€ØŒ=Ô)ð +Ø—<’< TÑ*Ô*ˆDØˆrtcóJ—|jjr| dd¦«}|Sr·rºr½s rrr›z!SQLCompiler.escape_literal_columnÂrÀrtc óÌ‡‡‡—ˆˆˆfd„}‰jsd‰_t d„t |‰ ‰j¦«¦«¦«S)NcóŽ•—| d¦«}|‰jvr‰j‰j|fi‰¤ŽS‰j|fi‰¤ŽSrU)r8Ú_bindparamsr²Úbindparam_string)rErñrër´Ú textclauses €€€rrÚdo_bindparamz2SQLCompiler.visit_textclause..do_bindparamÈs]ø€Ø—7’7˜1‘:”:ˆDØzÔ-Ð-Ð-Ø#t”| JÔ$:¸4Ô$@ÐGÐGÀBÐGÐGÐGà,tÔ,¨TÐ8Ð8°RÐ8Ð8Ð8rtTcó,—| d¦«SrU)r8)rEs rrrGz.SQLCompiler.visit_textclause..Ôs€a—g’g˜a‘j”j€rt)rÚisplaintextÚBIND_PARAMS_ESCrKÚBIND_PARAMSr¿r¾)r´rÆrërÇs``` rrÚvisit_textclausezSQLCompiler.visit_textclauseÇs‚øøø€ð 9ð 9ð 9ð 9ð 9ð 9ð 9ðŒzð $Ø#ˆDÔõ×"Ò"Ø Ð ÝOŠOØ˜d×4Ò4°Z´_ÑEÔEñ ô ñ ô ð rtcóZ—|j}|r|jn|jd}|p1|dko| dd¦«p| dd¦«}|r:|jx|_|_|jD]} | | d|j¬¦«Œ |j|j fi|¤Ž} |r|rd| z} | S) Nr(rÚneed_result_map_for_compoundFr;T©rrrŽú(%s)) rÚ_default_stack_entryrrr<Ú_textual_ordered_columnsÚcolumn_argsr²Ú_add_to_result_maprð)r´ÚtafÚcompound_indexrnÚparensrëÚtoplevelr@Úpopulate_result_mapÚcr¾s rrÚvisit_text_as_fromzSQLCompiler.visit_text_as_fromÚs€ð”z>ˆØ-5ÐIÔ)Ð)¸4¼:Àb¼>ˆð ð >à !Ò#ðEØ—I’IÐ<¸eÑDÔDð >ð yŠyÐ5°uÑ=Ô=ð ðð ð”ð ˆDÔ!ØÔ-à”_ð ð Ø—’ØØ*.Ø&*Ô&=ðñôðððˆtŒ|˜CœKÐ.Ð.¨2Ð.Ð.ˆØð !fð !Ø˜D‘=ˆDØˆrtcó—dS)NÚNULLrn©r´Úexprrës rrÚ visit_nullzSQLCompiler.visit_nullúó€Øˆvrtcó"—|jjrdSdS)NreÚ1©r§Úsupports_native_booleanrÞs rrÚ visit_truezSQLCompiler.visit_trueýs€ØŒ<Ô/ð Ø6à3rtcó"—|jjrdSdS)Nr1Ú0rärÞs rrÚvisit_falsezSQLCompiler.visit_falses€ØŒ<Ô/ð Ø7à3rtcóØ‡‡—|j}|€d}nt|j}| d„ˆˆfd„|jD¦«D¦«¦«}|jr‰jjrd|z}|S)Nrc3óK—|]}|¯|V—Œ dSr»rn©rpÚss rrrNz/SQLCompiler.visit_clauselist..s>èè€ð ð àðð Ø ð ð ð ð ð ð rtc3ó4•K—|]}|j‰fi‰¤ŽV—ŒdSr»rÈ)rprÚrër´s €€rrrNz/SQLCompiler.visit_clauselist..sJøèè€ððØ56Ð$Ô$ TÐ0Ð0¨RÐ0Ð0ððððððrtzVALUES )Úoperatorr‹rBÚclausesÚ _tuple_valuesr§Útuple_in_values)r´Ú clauselistrëÚsepr¾s` ` rrÚvisit_clauselistzSQLCompiler.visit_clauselist s§øø€ØÔ!ˆØˆ;ØˆCˆCå˜JÔ/Ô0ˆCàxŠxð ð ðððððØ:DÔ:Lðñôð ñ ô ñ ô ˆðÔ#ð $¨¬Ô(Dð $Ø˜tÑ#ˆDØˆrtcó—d}|j||jj|fi|¤Ždzz }|jD].\}}|d|j|fi|¤Žzdz|j|fi|¤Žzdzz }Œ/|j|d|jj|fi|¤Žzdzz }|dz }|S)NzCASE rzWHEN z THEN zELSE ÚEND)r rÉÚwhensÚelse_)r´ÚclauserËrqÚcondrfs rrÚ visit_casezSQLCompiler.visit_casesñ€ØˆØŒ<Ð#Ø Ð0”Ô0°Ð@Ð@¸Ð@Ð@À3ÑFÑFˆAØ"œLð ð ‰LˆD&Ø ØØ)$Ô)¨$Ð9Ð9°&Ð9Ð9ñ:àñð,&Ô+¨DÐ;Ð;°FÐ;Ð;ñ<ðñ ñ ˆAˆAðŒ<Ð#Ø ØÐ9˜&œ,Ô9¸$ÐIÐIÀ&ÐIÐIÑIÈCÑOñ ˆAð ˆU‰ ˆØˆrtcó(—|jj|fi|¤ŽSr»)Útyped_expressionrÉ)r´Útype_coercerës rrÚvisit_type_coercezSQLCompiler.visit_type_coerce.s €Ø>ˆ{Ô+Ô>¸tÐJÐJÀrÐJÐJÐJrtcóX—d|jj|fi|¤Ž›d|jj|fi|¤Ž›dS)NzCAST(r‚rk)rúrÉr´)r´rrËs rrÚ visit_castzSQLCompiler.visit_cast1sN€€à*ˆDŒKÔ*¨4Ð:Ð:°6Ð:Ð:Ð:Ð:Ø.ˆDŒOÔ.¨tÐ>Ð>°vÐ>Ð>Ð>Ð>ð ð rtc ód—|dtjurdn€|dtjurdnj|ddkr6|jtjt|d¦«¦«fi|¤Ž›dn(|jtj|d¦«fi|¤Ž›d›d|dtjurdn€|dtjurdnj|ddkr6|jtjt|d¦«¦«fi|¤Ž›dn(|jtj|d¦«fi|¤Ž›d›S) NrzUNBOUNDED PRECEDINGzCURRENT ROWz PRECEDINGz FOLLOWINGr}rzUNBOUNDED FOLLOWING)rÚRANGE_UNBOUNDEDÚ RANGE_CURRENTr²ÚliteralÚabs)r´Úrange_rës rrÚ_format_frame_clausez SQLCompiler._format_frame_clause7s’€ðaŒyHÔ4Ð4Ð4ð "Ð!ðaŒyHÔ2Ð2Ð2ððaŒy˜1Š}ˆ}ðˆtŒ|HÔ,S°¸´©^¬^Ñ<Ô<ÐCÐCÀÐCÐCÐCÐCðFðFðˆtŒ|HÔ,¨V°A¬YÑ7Ô7Ð>Ð>¸2Ð>Ð>Ð>Ð>ðAð Að AðaŒyHÔ4Ð4Ð4ð "Ð!ðaŒyHÔ2Ð2Ð2ððaŒy˜1Š}ˆ}ðˆtŒ|HÔ,S°¸´©^¬^Ñ<Ô<ÐCÐCÀÐCÐCÐCÐCðFðFðˆtŒ|HÔ,¨V°A¬YÑ7Ô7Ð>Ð>¸2Ð>Ð>Ð>Ð>ðAð Að ð rtcó$‡‡—|jrd‰j|jfi‰¤Žz}n |jrd‰j|jfi‰¤Žz}nd}|jj‰fi‰¤Ž›dd ˆˆfd„d|jfd|jffD¦«|r|gngz¦«›dS) NzRANGE BETWEEN %szROWS BETWEEN %sz OVER (rc ó^•—g|])\}}|®t|¦«¯|›d|j‰fi‰¤Ž›‘Œ*S)Nz BY )rVrÉ)rpÚwordrúrËr´s €€rrú z*SQLCompiler.visit_over..]scø€ðððñ%˜˜fðÐ)c°&©k¬kÐ)ðttÐ6˜VÔ6°tÐFÐF¸vÐFÐFÐFðHð*Ð)Ð)rtÚ PARTITIONÚORDERrk)rr ÚrowsrðrÉrBÚpartition_byÚorder_by)r´ÚoverrËrs` ` rrÚ visit_overzSQLCompiler.visit_overNs!øø€ØŒ;ð Ø'Ð*C¨$Ô*CØ”ð+ð+Ø%ð+ð+ñˆFˆFðŒYð Ø&Ð)B¨Ô)BØ” ð*ð*Ø#ð*ð*ñˆFˆFðˆFð ,ˆDŒLÔ+¨DÐ;Ð;°FÐ;Ð;Ð;Ð;ØHŠHðððððð% dÔ&7Ð8Ø $¤-Ð0ð)ðñôð &Ð-F88¨2ñ /ñ ô ð ð ð ð rtcóV—|jj|fi|¤Ž›d|jj|fi|¤Ž›dS)Nz WITHIN GROUP (ORDER BY rk)rðrÉr)r´ÚwithingrouprËs rrÚvisit_withingroupzSQLCompiler.visit_withingroupjsN€à2ˆKÔÔ2°4ÐBÐB¸6ÐBÐBÐBÐBØ3ˆKÔ Ô3°DÐCÐC¸FÐCÐCÐCÐCð ð rtcóV—|jj|fi|¤Ž›d|jj|fi|¤Ž›dS)Nz FILTER (WHERE rk)ÚfuncrÉÚ criterion)r´Ú funcfilterrËs rrÚvisit_funcfilterzSQLCompiler.visit_funcfilterpsM€à.ˆJŒOÔ.¨tÐ>Ð>°vÐ>Ð>Ð>Ð>Ø3ˆJÔ Ô3°DÐCÐC¸FÐCÐCÐCÐCð ð rtcó€—|j |j|j¦«}d|›d|jj|fi|¤Ž›dS)NzEXTRACT(rrk)Úextract_maprÚfieldrßrÉ)r´ÚextractrËrs rrÚ visit_extractzSQLCompiler.visit_extractvsQ€ØÔ ×$Ò$ W¤]°G´MÑBÔBˆˆàˆEˆEØ+ˆGŒLÔ+¨DÐ;Ð;°FÐ;Ð;Ð;Ð;ð ð rtcó>‡‡—|||j|jd|j¦«t‰d|j ¦«zd¦«}|r ||fi|¤ŽSt |jd¦«Š‰r |jr‰dz Šn\|jŠ‰j ‰¦«st‰tj¦«r‰j ‰¦«n‰Š‰dzŠd ˆˆfd„|jD¦«‰gz¦«d‰j|fi|¤ŽizS)Nrnz visit_%s_funcz%(expr)sr˜có°•—g|]R}‰j |¦«st‰tj¦«r‰j |¦«n|‘ŒSSrn)rªÚ_requires_quotes_illegal_charsrˆrÚquoted_namerœ)rpÚtokrñr´s €€rrr z.SQLCompiler.visit_function..“soø€ððððð œ=×GÒGÈÑLÔLð!å% dHÔ,@ÑAÔAð!˜œ ×+Ò+¨CÑ0Ô0Ð0ð!ðððrtrß)rñrùrÚlowerÚ FUNCTIONSrÚ __class__Ú _has_argsrªr$rˆrr%rœrBÚpackagenamesÚfunction_argspec)r´rrŽrËÚdisprñs` @rrÚvisit_functionzSQLCompiler.visit_function}svøø€ØÐ(ØÐ˜dœi¨¬°B¸¼ ÑBÔBÐBåt˜_¨t¬y¯ªÑ/@Ô/@Ñ@À$ÑGÔGˆØð @Ø4˜Ð'Ð' Ð'Ð'Ð'å—=’= ¤°Ñ6Ô6ˆDØð )Ø”>ð'Ø˜JÑ&Døà”yð”}×CÒCÀDÑIÔIðå! $Ô(<Ñ=Ô=ðD”M×'Ò'¨Ñ-Ô-Ð-ðð ð˜jÑ(Ø—8’8ðððððð $Ô0ðñôð&ñ ñôðÐ.˜Ô.¨tÐ>Ð>°vÐ>Ð>Ð?ñ@ð @rtcó6—| |j¦«Sr»)Úvisit_sequenceÚsequence)r´Ú next_valuerës rrÚvisit_next_value_funcz!SQLCompiler.visit_next_value_funcŸs€Ø×"Ò" :Ô#6Ñ7Ô7Ð7rtcó:—td|jjz¦«‚)Nz2Dialect '%s' does not support sequence increments.©rÄr§rñ)r´r1rës rrr0zSQLCompiler.visit_sequence¢s$€Ý!Ø@ØŒlÔñ ñ ô ð rtcó(—|jj|fi|¤ŽSr»)Úclause_exprrÉ)r´rrËs rrr,zSQLCompiler.function_argspec¨s €Ø2ˆtÔÔ2°4ÐBÐB¸6ÐBÐBÐBrtrc óÀ‡‡‡—‰j}|r‰jn‰jd}|p|dko| dd¦«}‰j |d|d||dœ¦«‰j |j¦«} d| zdz ˆˆˆfd „t|j¦«D¦«¦«} | ‰j |fitdd ‰i‰¤Ž¤Žz } | ‰j|fi‰¤Žz } | |jdus |j dur‰j|fi‰¤Žpdz } ‰jr|r‰ ¦«| z} ‰j d¦«‰r |rd| zd zS| S)Nr(rrÎFÚcorrelate_fromsÚasfrom_froms)r9r:r rÎrc3óB•K—|]\}}|j‰f‰d|dœ‰¤ŽV—ŒdS)F)rnr×rÖNrÈ)rpÚirÚrnrËr´s €€€rrrNz4SQLCompiler.visit_compound_select..Ásløèè€ð ð ñAqð%Ô$Øðà!Ø Ø#$ð ðð ððð ð ð ð ð ð rtrnrÍrjrkrn)rrÑrÚappendÚcompound_keywordsÚkeywordrBÚ enumerateÚselectsÚgroup_by_clauserRÚorder_by_clauseÚ _limit_clauseÚ_offset_clauseÚlimit_clauserÚ_render_cte_clauser=)r´Úcsrnr×rÖrËrØr@Úneed_result_mapr?r¾s` ` ` rrÚvisit_compound_selectz!SQLCompiler.visit_compound_select«søøø€ð”z>ˆØ-5ÐIÔ)Ð)¸4¼:Àb¼>ˆØ"ð Ø˜aÒð AØ— ’ Ð8¸%Ñ@Ô@ð ð Œ ×Òà#(Ð):Ô#;Ø % nÔ 5Ø Ø0?ð ð ñ ô ð ðÔ(×,Ò,¨R¬ZÑ8Ô8ˆàg‘ Ñ#×)Ò)ð ð ð ð ð ð õ& b¤jÑ1Ô1ð ñ ô ñ ô ˆð Ð$Ô$ RÐIÐI4Ð+HÐ+H°vÐ+HÀÐ+HÐ+HÐIÐIÑIˆØÐ$Ô$ RÐ2Ð2¨6Ð2Ð2Ñ2ˆØØ Ô TÐ )Ð J¨RÔ->ÀdÐ-Jð 0Ø!Ô! "Ð/Ð/¨Ð/Ð/ð àñ ˆðŒ9ð 4˜ð 4Ø×*Ò*Ñ,Ô,¨tÑ3ˆDàŒ ŠrÑÔÐØð fð Ø˜‘: Ñ#Ð#àˆKrtcóP—d|j›d|›|rd|znd›}t||d¦«S)NÚvisit_rrÍ)rÝr)r´Ú operator_Ú qualifier1Ú qualifier2Úattrnames rrÚ_get_operator_dispatchz"SQLCompiler._get_operator_dispatchÞsE€€àÔÐÐØˆJØ *Ð2ˆC*ÑÐ°Ð2ð ˆõ t˜X tÑ,Ô,Ð,rtcó¬—|jrg|jrtjd¦«‚| |jdd¦«}|r|||jfi|¤ŽS|j|t|jfi|¤ŽS|jrL| |jdd¦«}|r|||jfi|¤ŽS|j|t|jfi|¤ŽStjd¦«‚)NzFUnary expression does not support operator and modifier simultaneouslyÚunaryrïÚmodifierz,Unary expression has no operator or modifier)rïrTr r‚rQÚ _generate_generic_unary_operatorr‹Ú _generate_generic_unary_modifier)r´rSrër-s rrÚvisit_unaryzSQLCompiler.visit_unaryæs@€ØŒ>ð ØŒ~ð ÝÔ&ð2ñôðð×.Ò.Ø” ¨ñôˆDðð Øt˜E 5¤>Ð8Ð8°RÐ8Ð8Ð8à<tÔ<Ø9 U¤^Ô4ððØ8:ððððŒ^ð Ø×.Ò.Ø” ¨ñôˆDðð Øt˜E 5¤>Ð8Ð8°RÐ8Ð8Ð8à<tÔ<Ø9 U¤^Ô4ððØ8:ðððõÔ"Ø>ñôð rtcóz—|js|jjr|j|jfi|¤ŽSd|j|jfi|¤ŽzS)Nz%s = 1©Ú_is_implicitly_booleanr§rår²rð©r´rðrïrës rrÚvisit_istrue_unary_operatorz'SQLCompiler.visit_istrue_unary_operators[€àÔ*ð BàŒ|Ô3ð Bð 4”< ¤Ð6Ð6°2Ð6Ð6Ð6à˜l˜dœl¨7¬?ÐAÐA¸bÐAÐAÑAÐArtcó€—|js|jjrd|j|jfi|¤ŽzSd|j|jfi|¤ŽzS)NúNOT %sz%s = 0rYr[s rrÚvisit_isfalse_unary_operatorz(SQLCompiler.visit_isfalse_unary_operators`€àÔ*ð BàŒ|Ô3ð Bð˜l˜dœl¨7¬?ÐAÐA¸bÐAÐAÑAÐAà˜l˜dœl¨7¬?ÐAÐA¸bÐAÐAÑAÐArtcóJ—d| |tj¬¦«zS)Nr^)Úoverride_operator)Úvisit_binaryrÚmatch_op©r´rrïrës rrÚvisit_notmatch_op_binaryz$SQLCompiler.visit_notmatch_op_binarys.€Ø˜$×+Ò+Ø¥iÔ&8ð,ñ ô ñ ð rtcó.—tjd¦«dS)NzÀThe IN-predicate was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate. Consider alternative strategies for improved performance.)rÚwarnr¸s rrÚ_emit_empty_in_warningz"SQLCompiler._emit_empty_in_warnings%€ÝŒ ð 3ñ ô ð ð ð rtcó¤—|jjrdS|jjr| ¦«| |j|jk¦«S)Nz1 != 1©r§Ú_use_static_inÚ_warn_on_empty_inrhr²rDrds rrÚvisit_empty_in_op_binaryz$SQLCompiler.visit_empty_in_op_binary%sN€ØŒ<Ô&ð <Ø8àŒ|Ô-ð .Ø×+Ò+Ñ-Ô-Ð-Ø—<’< ¤¨v¬{Ò :Ñ;Ô;Ð;rtcó¤—|jjrdS|jjr| ¦«| |j|jk¦«S)Nz1 = 1rjrds rrÚvisit_empty_notin_op_binaryz'SQLCompiler.visit_empty_notin_op_binary-sN€ØŒ<Ô&ð <Ø7àŒ|Ô-ð .Ø×+Ò+Ñ-Ô-Ð-Ø—<’< ¤¨v¬{Ò :Ñ;Ô;Ð;rtcó:—td|jjz¦«‚)Nz3Dialect '%s' does not support empty set expression.r5)r´Ú element_typess rrÚvisit_empty_set_exprz SQLCompiler.visit_empty_set_expr5s$€Ý!ØAØŒlÔñ ñ ô ð rtcóª—|jrCt|jtj¦«r$t|jtj¦«rd|d<|p|j}| |dd¦«}|r |||fi|¤ŽS t|}|j ||fi|¤ŽS#t$r4}tjtj||¦«|¬¦«Yd}~dSd}~wwxYw)NTÚ literal_bindsrr))Úansi_bind_rulesrˆrDrÚ BindParameterrZrïrQr‹Ú_generate_generic_binaryr€rr,r ÚUnsupportedCompilationError) r´rraÚeager_groupingrërMr-Úopstringr~s rrrbzSQLCompiler.visit_binary;s+€ð Ô ð 'å˜6œ;Ô(>Ñ?Ô?ð 'õ˜6œ<Ô)?Ñ@Ô@ð 'ð #'ˆBˆÑà%Ð8¨¬ˆ Ø×*Ò*¨9°hÀÑEÔEˆØð MØ4˜ Ð0Ð0¨RÐ0Ð0Ð0ð MÝ$ YÔ/ð5tÔ4°V¸XÐLÐLÈÐLÐLÐLøõ ð ð ð Ý”ÝÔ3°D¸)ÑDÔDØ$'ðñôðððððððøøøøð øøøsÁ8 BÂ CÂ)C Ã Ccó(—|j|jfi|¤ŽSr»)r²Úsql_functionr[s rrÚ&visit_function_as_comparison_op_binaryz2SQLCompiler.visit_function_as_comparison_op_binaryVs€ØˆtŒ|˜GÔ0Ð7Ð7°BÐ7Ð7Ð7rtcóÂ—|jjr*|j|jfi|¤Ždz|j|jfi|¤ŽzS|j|jfi|¤Ždz|j|jfi|¤ŽzS)Nz %% r~)rªr»r²rDrZrds rrÚvisit_mod_binaryzSQLCompiler.visit_mod_binaryYs™€ØŒ=Ô)ð à”˜Vœ[Ð/Ð/¨BÐ/Ð/Øñà$”,˜vœ|Ð2Ð2¨rÐ2Ð2ñ3ð ð”˜Vœ[Ð/Ð/¨BÐ/Ð/Øñà$”,˜vœ|Ð2Ð2¨rÐ2Ð2ñ3ð rtcóJ—|j|d<|j|d|jzdzfi|¤ŽS)Nryr)ryrwrzr[s rrÚvisit_custom_op_binaryz"SQLCompiler.visit_custom_op_binarygsF€Ø'Ô6ˆÐÑØ,ˆtÔ,ØS˜8Ô,Ñ,¨sÑ2ð ð Ø68ð ð ð rtcó0—|j||jdzfi|¤ŽS©Nr)rUrzr[s rrÚvisit_custom_op_unary_operatorz*SQLCompiler.visit_custom_op_unary_operatorms3€Ø4ˆtÔ4ØXÔ&¨Ñ,ð ð Ø02ð ð ð rtcó0—|j|d|jzfi|¤ŽSrƒ)rVrzr[s rrÚvisit_custom_op_unary_modifierz*SQLCompiler.visit_custom_op_unary_modifierrs3€Ø4ˆtÔ4ØS˜8Ô,Ñ,ð ð Ø02ð ð ð rtcóª—| dd¦«}d|d<|jj|fd|i|¤Ž|z|jj|fd|i|¤Žz}|r|rd|z}|S)NÚ _in_binaryFTryrÐ)rrDrÉrZ)r´rrzryrërˆr¾s rrrwz$SQLCompiler._generate_generic_binaryws®€ð—V’V˜L¨%Ñ0Ô0ˆ àˆˆ<Ñà*ˆFŒKÔ*Øð ð Ø%3ð Ø79ð ð ðñ ð.ˆfŒlÔ-ØððØ%3ðØ79ððñ ð ðð !˜.ð !Ø˜D‘=ˆDØˆrtcó.—||jj|fi|¤ŽzSr»rl©r´rSrzrës rrrUz,SQLCompiler._generate_generic_unary_operatorŒs%€ØÐ:˜%œ-Ô:¸4ÐFÐFÀ2ÐFÐFÑFÐFrtcó.—|jj|fi|¤Ž|zSr»rlrŠs rrrVz,SQLCompiler._generate_generic_unary_modifiers$€Ø/ˆuŒ}Ô/°Ð;Ð;¸Ð;Ð;¸hÑFÐFrtcóB—tjdtj¬¦«S)Nz'%')rê)rÚliteral_columnr Ú STRINGTYPEr¸s rrÚ_like_percent_literalz!SQLCompiler._like_percent_literal’s€åÔ& uµHÔ4GÐHÑHÔHÐHrtcóº—| ¦«}|j}| |j¦« |¦«|_|j||fi|¤ŽSr»©Ú_clonerÚ__add__rZÚvisit_like_op_binary©r´rrïrëÚpercents rrÚvisit_contains_op_binaryz$SQLCompiler.visit_contains_op_binary–sW€Ø—’‘”ˆØÔ,ˆØ—’ v¤|Ñ4Ô4×<Ò<¸WÑEÔEˆŒØ(ˆtÔ(¨°Ð@Ð@¸RÐ@Ð@Ð@rtcóº—| ¦«}|j}| |j¦« |¦«|_|j||fi|¤ŽSr»©r’rr“rZÚvisit_notlike_op_binaryr•s rrÚvisit_notcontains_op_binaryz'SQLCompiler.visit_notcontains_op_binaryœsW€Ø—’‘”ˆØÔ,ˆØ—’ v¤|Ñ4Ô4×<Ò<¸WÑEÔEˆŒØ+ˆtÔ+¨F°HÐCÐCÀÐCÐCÐCrtcó”—| ¦«}|j}| |j¦«|_|j||fi|¤ŽSr»)r’rÚ__radd__rZr”r•s rrÚvisit_startswith_op_binaryz&SQLCompiler.visit_startswith_op_binary¢sK€Ø—’‘”ˆØÔ,ˆØ×'Ò'¨¬Ñ5Ô5ˆŒØ(ˆtÔ(¨°Ð@Ð@¸RÐ@Ð@Ð@rtcó”—| ¦«}|j}| |j¦«|_|j||fi|¤ŽSr»)r’rrrZršr•s rrÚvisit_notstartswith_op_binaryz)SQLCompiler.visit_notstartswith_op_binary¨sK€Ø—’‘”ˆØÔ,ˆØ×'Ò'¨¬Ñ5Ô5ˆŒØ+ˆtÔ+¨F°HÐCÐCÀÐCÐCÐCrtcó”—| ¦«}|j}| |j¦«|_|j||fi|¤ŽSr»r‘r•s rrÚvisit_endswith_op_binaryz$SQLCompiler.visit_endswith_op_binary®sI€Ø—’‘”ˆØÔ,ˆØ—’ v¤|Ñ4Ô4ˆŒØ(ˆtÔ(¨°Ð@Ð@¸RÐ@Ð@Ð@rtcó”—| ¦«}|j}| |j¦«|_|j||fi|¤ŽSr»r™r•s rrÚvisit_notendswith_op_binaryz'SQLCompiler.visit_notendswith_op_binary´sI€Ø—’‘”ˆØÔ,ˆØ—’ v¤|Ñ4Ô4ˆŒØ+ˆtÔ+¨F°HÐCÐCÀÐCÐCÐCrtcóÚ—|j dd¦«}|jj|fi|¤Ž›d|jj|fi|¤Ž›|r#d| |tj¦«zndzS)NÚescapez LIKE ú ESCAPE rÍ©Ú modifiersrrDrÉrZÚrender_literal_valuer rŽ©r´rrïrër¦s rrr”z SQLCompiler.visit_like_op_binaryºs’€ØÔ!×%Ò% h°Ñ5Ô5ˆð +ˆFŒKÔ*¨4Ð6Ð6°2Ð6Ð6Ð6Ð6Ø+ˆFŒLÔ+¨DÐ7Ð7°BÐ7Ð7Ð7ð ð ð ˆJ˜×2Ò2°6½8Ô;NÑOÔOÑOÐOàñ ð rtcóÚ—|j dd¦«}|jj|fi|¤Ž›d|jj|fi|¤Ž›|r#d| |tj¦«zndzS)Nr¦z NOT LIKE r§rÍr¨r«s rrršz#SQLCompiler.visit_notlike_op_binaryÇs€ØÔ!×%Ò% h°Ñ5Ô5ˆà*ˆFŒKÔ*¨4Ð6Ð6°2Ð6Ð6Ð6Ð6Ø+ˆFŒLÔ+¨DÐ7Ð7°BÐ7Ð7Ð7ð ð ð ˆJ˜×2Ò2°6½8Ô;NÑOÔOÑOÐOàñ ð rtcóÞ—|j dd¦«}d|jj|fi|¤Ž›d|jj|fi|¤Ž›d|r#d| |tj¦«zndzS)Nr¦úlower(z ) LIKE lower(rkr§rÍr¨r«s rrÚvisit_ilike_op_binaryz!SQLCompiler.visit_ilike_op_binaryÒó•€ØÔ!×%Ò% h°Ñ5Ô5ˆˆà*ˆFŒKÔ*¨4Ð6Ð6°2Ð6Ð6Ð6Ð6Ø+ˆFŒLÔ+¨DÐ7Ð7°BÐ7Ð7Ð7Ð7ð ð ð ˆJ˜×2Ò2°6½8Ô;NÑOÔOÑOÐOàñ ð rtcóÞ—|j dd¦«}d|jj|fi|¤Ž›d|jj|fi|¤Ž›d|r#d| |tj¦«zndzS)Nr¦r®z) NOT LIKE lower(rkr§rÍr¨r«s rrÚvisit_notilike_op_binaryz$SQLCompiler.visit_notilike_op_binaryÝr°rtcó^—|j dd¦«}|j||rdndfi|¤ŽS)Nr`Fz BETWEEN SYMMETRIC z BETWEEN ©r©rrw©r´rrïrër`s rrÚvisit_between_op_binaryz#SQLCompiler.visit_between_op_binaryèsN€ØÔ$×(Ò(¨°eÑ<Ô<ˆ Ø,ˆtÔ,Ø¨YÐGÐ)Ð)¸Kð ð ØKMð ð ð rtcó^—|j dd¦«}|j||rdndfi|¤ŽS)Nr`Fz NOT BETWEEN SYMMETRIC z NOT BETWEEN r´rµs rrÚvisit_notbetween_op_binaryz&SQLCompiler.visit_notbetween_op_binaryîsQ€ØÔ$×(Ò(¨°eÑ<Ô<ˆ Ø,ˆtÔ,ØØ)2ÐGÐ%Ð%¸ð ð ðð ð ð rtcóÜ—|sM|j |j¦«}|jr'| |¦«}|j|fd||dœ|¤ŽS|s |rA|jr:|j€#|j€tj d|jz¦«‚|j|fddi|¤ŽS| |¦«}||jvr|j|} | |ur|| js|jr;| j |j¦«stj d|jz¦«‚| js|jr%tj d|j›d|j›d¦«‚|x|j|j<|j|<|j|fd |ji|¤ŽS) NT)Úskip_bind_expressionrrrtz@Bind parameter '%s' without a renderable value not allowed here.rrzIBind parameter '%s' conflicts with unique bind parameter of the same namezbindparam() name 'zÌ' 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_z').Ú expanding)rùÚdialect_implr§Ú_has_bind_expressionÚbind_expressionr²rur r]r r‚rÚrender_literal_bindparamÚ_truncate_bindparamrrgr÷ÚintersectionÚ_is_crudrÅr») r´rQrrrtrºrËÚimplr¾rñÚexistings rrÚvisit_bindparamzSQLCompiler.visit_bindparamös €ð$ð Ø”>×.Ò.¨t¬|Ñ<Ô<ˆDØÔ(ð Ø"&×"6Ò"6°yÑ"AÔ"AØ#t”|Ø#ðà)-Ø*?Ø"/ð ðð ððððð Ð2ð °tÔ7Kð ØŒÐ&¨9Ô+=Ð+EÝÔ&ð9Ø;D¼=ñIñôðð14Ô0ØððØ15ðØ9?ððð ð×'Ò'¨ Ñ2Ô2ˆà4”:ÐÐØ”z $Ô'ˆHØ˜yÐ(Ð(à”OðØ'0Ô'7ðà"Ô,×9Ò9¸)Ô:MÑNÔNðõÔ*ðAà#œ-ñ(ñôðð Ô&ð ¨)Ô*<ð ÝÔ*Ð*ð%œ=˜=˜=¨)¬-¨-¨-ð 9ñôðð8AÐ@ˆŒ 9”=Ñ! D¤J¨tÑ$4à$ˆtÔ$Øð ð Ø%Ô/ð Ø39ð ð ð rtcóF—|j}| ||j¦«Sr»)r^rªrù)r´rQrër s rrr¿z$SQLCompiler.render_literal_bindparam3s"€ØÔ)ˆØ×(Ò(¨° ´Ñ?Ô?Ð?rtcót—| |j¦«}|r||¦«Std|z¦«‚)aRender 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. z(Don't know how to literal-quote value %r)Ú_cached_literal_processorr§rÄ)r´r rêÚ processors rrrªz SQLCompiler.render_literal_value7sK€ð×3Ò3°D´LÑAÔAˆ Øð Ø9˜UÑ#Ô#Ð#å%Ø:¸UÑBñôð rtcó´—||jvr |j|S|j}t|tj¦«r| d|¦«}||j|<|S)NrQ)rrrˆrr‰rŠ)r´rQÚ bind_names rrrÀzSQLCompiler._truncate_bindparamJsb€Ø˜œÐ'Ð'Ø”? 9Ô-Ð-à”Mˆ Ýi¥Ô!:Ñ;Ô;ð KØ×2Ò2°;À ÑJÔJˆIð&/ˆŒ˜ Ñ"àÐrtcóˆ—||f|jvr|j||fS| |j¦«}t|¦«|jdz krd|j |d¦«}|dt |jdz d¦«…dzt|¦«dd…z}|dz|j|<n|}||j||f<|S)Nérrrr)r Ú apply_maprrVrrÚmaxÚhex)r´Úident_classrñÚanonnameÚcounterÚ truncnames rrrŠz!SQLCompiler._truncated_identifierWsâ€Ø˜Ð $Ô"6Ð6Ð6ØÔ'¨°dÐ(;Ô<Ð<à—>’> $¤-Ñ0Ô0ˆåˆx‰=Œ=˜4Ô,¨qÑ0Ò0Ð0ØÔ*×.Ò.¨{¸AÑ>Ô>ˆGà˜S Ô!2°QÑ!6¸Ñ:Ô:Ð:Ô;Øñåg‘,”,˜q˜r˜rÔ"ñ#ð ð 18¸!±ˆDÔ Ñ-Ð-à ˆIØ4=ˆÔ˜k¨4Ð0Ñ1ØÐrtcó—||jzSr»)r©r´rñs rrÚ _anonymizezSQLCompiler._anonymizejs€Ød”mÑ#Ð#rtcó¨—|jr2|| |¦«n|j |¦«|rd|_d|zS|jd|izS)NTz([EXPANDING_%s])rñ)rr=rÚcontains_expanding_parametersr)r´rñÚpositional_namesr»rës rrrÅzSQLCompiler.bindparam_stringmso€ðŒ?ð .ØÐ+Ø ×'Ò'¨Ñ-Ô-Ð-Ð-àÔ ×'Ò'¨Ñ-Ô-Ð-Øð 6Ø15ˆDÔ.Ø%¨Ñ,Ð,àÔ$¨° ~Ñ5Ð5rtc óÞ‡—‰ ¦«||d<t|jtj¦«r‰ d|j¦«}n|j}d}d} |‰jvrJ‰j|} || u} || jvs|| urd}n)| |jvr ‰j| =ntj d|z¦«‚|s|rO|jD|j}|jj}t|tj¦«r‰ d|¦«}n|}d}|r¼|‰j|<d|jj vr:d‰jvr1‰j d|jj di¦«‰_|‰jvr‰j|fi|¤Ž|sP|‰jvrF|jrd‰_‰j ||¦«} |jr¥t|jt,j¦«r|j}n4t|jt,j¦«r|jjd}nJ‚d„t5j|j¦«D¦«}| d d ˆfd„|D¦«¦«zz } ‰jrgx|d<‰j|<| d ‰j ||j!fi|¤Ž›d|jj"‰fddi|¤Ž›z } |j#r| d‰j ||j#fi|¤Žzz } | ‰j|<|r¥|s| r‰j ||¦«S|ri‰j ||¦«} ‰j $|¦«r‰j %|¦«}| ‰ &|¦«z } | S‰j ||¦«SdS)NÚvisiting_cter™TFz5Multiple, unrelated CTEs found with the same name: %rÚ autocommitrcó—g|]}|®|‘ŒSr»rn©rprÚs rrr z)SQLCompiler.visit_cte..Ìs%€ð"ð"ð"àØ˜=ðà(˜=˜=rtrÐr€c3óL•K—|]}‰j |¦«V—ŒdSr»)rªÚ format_column)rprr´s €rrrNz(SQLCompiler.visit_cte..ÓsGøèè€ð"ð"à %ð!œM×7Ò7¸Ñ>Ô>ð"ð"ð"ð"ð"ð"rtrÚr‚ú rnr)'r9rˆrñrr‰rŠr6Ú _restatesrr r‚Ú _cte_aliasrðr°r±rfÚ visit_cteÚ recursiver7rªÚformat_aliasÚoriginalr ÚSelectÚCompoundSelectrArÚunique_listÚ inner_columnsrBrr8Ú_generate_prefixesÚ _prefixesrÉÚ _suffixesÚ_requires_quotesrœÚget_render_as_alias_suffix)r´ÚcternÚashintÚ fromhintsrÜrËÚcte_nameÚ is_new_cteÚembedded_in_current_named_cteÚexisting_cteÚ pre_alias_cteÚcte_pre_alias_namer¾Ú col_sourceÚ recur_colss` rrråzSQLCompiler.visit_cte{sˆø€ð ×ÒÑÔÐà!$ˆˆ~ÑÝc”h¥Ô 9Ñ:Ô:ð Ø×1Ò1°'¸3¼8ÑDÔDˆHˆHà”xˆHàˆ Ø(-Ð%àtÔ(Ð(Ð(ØÔ,¨XÔ6ˆLØ,8¸LÐ,HÐ)ðlÔ,Ð,Ð,°°|Ð0CÐ0CØ" Ø ¤Ð.Ð.ð”I˜lÐ+Ð+åÔ&ð(Ø*2ñ3ñôðð ð *Zð *ØŒ~Ð)Ø #¤ Ø%(¤^Ô%8Ð"ÝÐ0µ(Ô2KÑLÔLðØ)-×)CÒ)CØÐ!3ñ*ô*Ð&øð!$ Ø%)Ð"àñ: &Ø*-ˆDÔ˜hÑ'ð ¤Ô >Ð>Ð>Ø ¨Ô(>Ð>Ð>à)-Ô)?×)EÒ)Eà$ c¤kÔ&DØ(ô'ðñ*ô*Ô&ð D¤IÐ-Ð-Ø”˜}Ð7Ð7°Ð7Ð7Ð7à%ñ' &¨#°T´YÐ*>Ñ*>Ø”=ð/Ø*.DÔ'Ø”}×1Ò1°#°xÑ@Ô@Ø”=ðÝ! #¤,µ Ô0AÑBÔBð%Ø%(¤\˜ ˜ Ý# C¤Lµ*Ô2KÑLÔLð%Ø%(¤\Ô%9¸!Ô%<˜ ˜ à$˜uð"ð"å!%Ô!1°*Ô2JÑ!KÔ!Kð"ñ"ô"Jð˜FØŸ š ð"ð"ð"ð"à)3ð"ñ"ô"ñôññDð”?ðOØLNÐNFÐ-Ñ.°Ô1DÀSÑ1IàØ+DÔ+¨C°´ÐIÐIÀ&ÐIÐIÐIÐIØ3C”LÔ3ØððØ%)ðØ-3ððððñð”=ðØ˜CÐ"9 $Ô"9Ø˜Sœ]ð#ð#Ø.4ð#ð#ññDð"&” ˜#‘àð AØð AÐ"?ð AØ”}×1Ò1°#°xÑ@Ô@Ð@à!ð AØ”}×1Ò1°#Ð7IÑJÔJØ”=×1Ò1°(Ñ;Ô;ð=Ø#œ}×2Ò2°8Ñ<Ô<HØ˜×7Ò7¸ÑAÔAÑAØà”}×1Ò1°#°xÑ@Ô@Ð@ð Að ArtcóÆ—|s|rBt|jtj¦«r| d|j¦«}n|j}|r|j ||¦«S|rj|jj|fddi|¤Ž| |j ||¦«¦«z}|r"||vr| |||||¦«}|S|jj|fi|¤ŽS)Nr™rnT)rˆrñrr‰rŠrªrçrèrÉrñÚformat_from_hint_text) r´r™rnróÚiscrudrôrËÚ alias_nameÚrets rrÚvisit_aliaszSQLCompiler.visit_alias÷s*€ðð (Vð (Ý˜%œ*¥hÔ&?Ñ@Ô@ð (Ø!×7Ò7¸ÀÄÑLÔL à"œZ àð EØ”=×-Ò-¨e°ZÑ@Ô@Ð@Ø ð EØ3%”.Ô3ØððØ!ðØ%+ððà×/Ò/Ø” ×*Ò*¨5°*Ñ=Ô=ñôñˆCðð ˜U iÐ/Ð/Ø×0Ò0Ø˜ ¨%Ô 0°&ñôðˆJà45”>Ô4°TÐDÐD¸VÐDÐDÐDrtcó.—d|d<d|j|fi|¤ŽzS)NTÚlateralz LATERAL %s)r)r´rrës rrÚ visit_lateralzSQLCompiler.visit_laterals,€Øˆˆ9‰ ØÐ.˜dÔ.¨wÐ=Ð=¸"Ð=Ð=Ñ=Ð=rtcó¬—|j|fddi|¤Ž›d| ¦«j|fi|¤Ž›}|j|d|jj|fi|¤Žzz }|S)NrnTz TABLESAMPLE z REPEATABLE (%s))rÚ_get_methodrÉÚseed)r´Útablesamplernrër¾s rrÚvisit_tablesamplezSQLCompiler.visit_tablesamples’€àˆDÔ˜[Ð<Ð<°Ð<¸Ð<Ð<Ð<Ð<Ø8ˆK×#Ò#Ñ%Ô%Ô8¸ÐDÐDÀÐDÐDÐDð ˆð ÔÐ'ØÐ&Ø3Ô Ô3°DÐ?Ð?¸BÐ?Ð?ññ ˆDðˆrtcó—d|zS)Nr‚rn)r´Úalias_name_texts rrrñz&SQLCompiler.get_render_as_alias_suffix)s €Ø˜Ñ'Ð'rtcóB—|j ||||f¦«dSr»)rr=)r´ÚkeynamerñÚobjectsrês rrrÔzSQLCompiler._add_to_result_map,s(€ØÔ×#Ò# W¨d°G¸UÐ$CÑDÔDÐDÐDÐDrtc ó ‡‡—‰j ‰j¦«} | jr%|s|r!| ‰¦«} |rˆˆfd„}nd}n‰} |r‰j}nd}|s| }n‰t ‰tj¦«r'| ‰urt| ‰j ‰jf¬¦«}nL| }nH||rt| |‰jf¬¦«}n*|rwt ‰tj ¦«r]‰jsV‰jOt ‰jt j¦«s0t| tj‰j ¦«‰jf¬¦«}n±t ‰tj¦«sat ‰tj¦«r‰jr@t/‰d¦«rt ‰t0j¦«rt| ‰j¦«}n6| ‰ur0t| tj‰j ¦«‰jf¬¦«}n| }| ||¬¦«|j‰fi|¤ŽS)z.produce labeled columns present in a select().có@•—‰ ||‰f|z|¦«dSr»)rÔ)rrñrrêr r´s €€rrrŽz;SQLCompiler._label_select_column..add_to_result_mapEs5ø€Ø×+Ò+Ø ¨ y°7Ñ':¸EñôðððrtN)rõrñrÏ)rùr¼r§Ú_has_column_expressionÚcolumn_expressionrÔrˆrÚLabelrîrñrðÚ _key_labelÚColumnClauseršrar réÚ _as_truncatedrÚ TextClauseÚUnaryExpressionÚwraps_column_expressionÚhasattrrÚFunctionÚ anon_labelÚupdaterÉ) r´r[r rÙrnÚcolumn_clause_argsrñrrÚneed_column_expressionsrÃÚcol_exprrŽÚresult_exprs ` ` rrÚ_label_select_columnz SQLCompiler._label_select_column/s«øø€ðŒ{×'Ò'¨¬Ñ5Ô5ˆàÔ&ð )Ø#ð )Ø':ð )ð×-Ò-¨fÑ5Ô5ˆHà"ð )ðððððððð%)Ð!Ð!àˆHØ"ð )Ø$(Ô$;Ð!Ð!à$(Ð!à$ð0 #Ø"ˆK‰KÝ ˜¥¤Ñ /Ô /ð. #Ø˜vÐ%Ð%Ý+Ø˜fœk°f´nÐ5Fðñô‘ð'‘à Ð DÐ Ý'Ø˜$¨6Ô+<Ð*>ðñôˆK‰Kð ð! #å˜6¥8Ô#8Ñ9Ô9ð! #ðÔ%ð! #ð”Ð(Ý˜vœ|ZÔ->Ñ?Ô?ð)õ(ØÝÔ& v¤{Ñ3Ô3Ø!œ:˜-ðñôˆKˆKõ˜6¥8Ô#6Ñ7Ô7ð #õ˜v¥xÔ'?Ñ@Ô@ð #ðÔ1ð #õ˜F FÑ+Ô+ð #õ˜f¥iÔ&8Ñ9Ô9ð #õ(¨°&Ô2CÑDÔDˆKˆKØ ˜VÐ #Ð #õ(ØÝÔ& v¤{Ñ3Ô3Ø!œ:˜-ðñôˆKˆKð#ˆKà×!Ò!Ø"7Ø/ð "ñ ô ð ð.ˆ{Ô-¨dÐIÐIÐ6HÐIÐIÐIrtcóF—| ||¦«}|r|d|zz }|Srƒ)Úget_from_hint_text)r´ÚsqltextraÚhintrÿÚhinttexts rrrþz!SQLCompiler.format_from_hint_text‹s2€Ø×*Ò*¨5°$Ñ7Ô7ˆØð &Øs˜X‘~Ñ%ˆGØˆrtcó—dSr»rn)r´Úbyfromss rrÚget_select_hint_textz SQLCompiler.get_select_hint_text‘ó€Øˆtrtcó—dSr»rn©r´rar¾s rrr%zSQLCompiler.get_from_hint_text”r,rtcó—dSr»rnr.s rrÚget_crud_hint_textzSQLCompiler.get_crud_hint_text—r,rtcó,—d |¦«Srƒ©rB)r´Ú hint_textss rrÚget_statement_hint_textz#SQLCompiler.get_statement_hint_textšs€ØxŠx˜ Ñ#Ô#Ð#rtcó6‡‡‡—iŠigŠˆˆˆfd„Š‰|¦«S)z×Rewrite any "a JOIN (b JOIN c)" expression as "a JOIN (select * from b JOIN c) AS anon", to support databases that can't parse a parenthesized join correctly (i.e. sqlite < 3.7.16). cóÒ•—|‰dvr‰d|S|‰ vr‰ |S| ¦«x}‰ |<|jrœ|jr”t|jt j¦«rt| ¦«‰|jfi|¤Ž|_‰|jfi|¤Ž}tj |j gd¬¦« ¦«}|jD]}|j |_|j|_Œt#t%|jj j|j¦«¦«}|||j j<|||j j<|||jj j<|||jj j<t'‰d ¦«¦«D]\}}||vr||‰d|<Œ‰d |¦«||_‰|jfi|¤Ž|_n„|jrd|d<|jdd‰i|¤Žnh|jrR|jrK| dd¦«dk} | r‰ i¦«d|d<|jdd‰i|¤Ž| r‰d=n|jdd‰i|¤Ž|S) Nr(T)Ú use_labelsÚselect_containerÚtransform_clueÚcloneÚ inside_selectrn)r’Ú is_selectableÚ_is_joinrˆrZr ÚFromGroupingÚ_reset_exportedrDrérðr™rÚrrrñÚ_labelrRÚzipr0ÚitemsrÚonclauseÚ_is_from_containerÚ_copy_internalsÚ _is_selectrr=) rðrëÚnewelemrZÚselectable_rÚÚtranslate_dictÚkÚvÚbarrier_selectÚclonedÚcolumn_translateÚvisits €€€rrrOz=SQLCompiler._transform_select_for_nested_joins..visit§sø€ØÐ*¨2Ô.Ð.Ð.Ø'¨Ô+¨GÔ4Ð4à˜FÐ"Ð"Ø˜g”Ð&à(/¯ªÑ(8Ô(8Ð8ˆGf˜W‘oðÔ%ñD ;àÔ$ñD ;õ˜wœ}jÔ.EÑFÔFñD ;ð×'Ò'Ñ)Ô)Ð)Ø$˜u W¤\Ð8Ð8°RÐ8Ð8”à˜˜gœmÐ2Ð2¨rÐ2Ð2å(Ô/Ø”]O°ðñôç’%‘'”'ðð%œð&ð&AØ#$¤5A”LØ œvA”HHå!%Ý˜œ Ô-Ô/°´Ñ?Ô?ñ"ô"ð6A˜uœ}Ô1Ñ2Ø6A˜uœ}Ô2Ñ3Ø=H˜wœ}Ô4Ô9Ñ:Ø>I˜wœ}Ô4Ô:Ñ;õ!Ð!1°"Ô!5×!;Ò!;Ñ!=Ô!=Ñ>Ô>ðDðD‘DAqØ˜NÐ*Ð*ð3AÀÔ2CÐ(¨Ô,¨QÑ/øà Ô$×+Ò+¨NÑ;Ô;Ð;à +” à#( 5¨Ô)9Ð#@Ð#@¸RÐ#@Ð#@Ô Ð àÔ+ð ;ð(:Ð#Ñ$Ø'Ô'Ð:Ð:¨eÐ:°rÐ:Ð:Ð:Ð:ØÔ&ð ;¨7Ô+=ð ;à—F’FÐ+¨TÑ2Ô2Ð6HÒHðð"ð0Ø$×+Ò+¨BÑ/Ô/Ð/Ø'6Ð#Ñ$Ø'Ô'Ð:Ð:¨eÐ:°rÐ:Ð:Ð:Ø!ð-Ø(¨Ð,øà'Ô'Ð:Ð:¨eÐ:°rÐ:Ð:Ð:àˆNrtrn)r´r[rMrNrOs @@@rrÚ"_transform_select_for_nested_joinsz.SQLCompiler._transform_select_for_nested_joinssOøøø€ðˆØ˜4ÐðO ðO ðO ðO ðO ðO ðO ðbˆuV‰}Œ}Ðrtcó¶‡‡—td„|jD¦«¦«Štˆfd„|jD¦«¦«Šˆfd„|jD¦«|_dS)Nc3ó(K—|] }|j|fV—ŒdSr»©rrßs rrrNzESQLCompiler._transform_result_map_for_nested_joins..ýs:èè€ð ð Ø"#ˆQŒ\˜1Ðð ð ð ð ð ð rtc3ó6•K—|]}‰|j|fV—ŒdSr»rS)rprÚÚ inner_cols €rrrNzESQLCompiler._transform_result_map_for_nested_joins..s/øèè€ÐLÐL°!)˜AœLÔ)¨1Ð-ÐLÐLÐLÐLÐLÐLrtcóX•—g|]&\}}}}||tˆfd„|D¦«¦«|f‘Œ'S)có<•—g|]}‰ ||¦«‘ŒSrn©r)rprôÚds €rrr zQSQLCompiler._transform_result_map_for_nested_joins...s%ø€Ð?Ð?Ð?°3˜qŸušu S¨#™œÐ?Ð?Ð?rt©Útuple)rprrñÚobjsÚtyprYs €rrr zFSQLCompiler._transform_result_map_for_nested_joins..sWø€ð ð ð á$T˜4 ð$Ð?Ð?Ð?Ð?¸$Ð?Ñ?Ô?Ñ@Ô@À#ÐFð ð ð rt)rRrìr)r´r[Útransformed_selectrYrUs @@rrÚ&_transform_result_map_for_nested_joinsz2SQLCompiler._transform_result_map_for_nested_joinsúsøø€õð ð Ø'9Ô'Gð ñ ô ñ ô ˆ õ ÐLÐLÐLÐL°vÔ7KÐLÑLÔLÑLÔLˆð ð ð ð à(,Ô(<ð ñ ô ˆÔÐÐrtr9r:cóî—|j}|r|jn|jd}|d}|d}|r-|s+| | |¦«d¬¦«}n| ||¬¦«}|S)Nr(r9r:rn©Úexplicit_correlate_fromsÚimplicit_correlate_froms)rrÑÚ_get_display_fromsÚ difference) r´r[rnrrØr@r9r:Úfromss rrÚ_display_froms_for_selectz%SQLCompiler._display_froms_for_selects©€ð ”z>ˆØ-5ÐIÔ)Ð)¸4¼:Àb¼>ˆàÐ 1Ô2ˆØ˜^Ô,ˆàð ˜'ð Ø×-Ò-Ø)8×)CÒ)CØ ñ*ô*ð*,ð .ñôˆEˆEð×-Ò-Ø)8Ø)5ð.ñôˆEðˆrtc óF‡‡‡‡‡‡‡—‰jo|o‰jo‰jj} | r)‰ ‰¦«}‰j|f‰|||ddœ| ¤Ž}‰j} | r‰jn‰jd}| p+| dd¦«p| dd¦«xŠŠ|dkrdŠ‰sd| vr| d=| r‰r‰ ‰|¦«|S‰ ‰|‰|¦«}| ¦«Š‰ ddd œ¦«d }‰jr#‰ ‰¦«\}}|r||dzz }nd}‰jr|‰j‰‰jfi| ¤Žz }|‰j‰fi| ¤Žz }d„ˆˆˆˆˆˆfd „‰jD¦«D¦«}‰rU|St%t'd„‰jD¦«d„|jD¦«¦«¦«Šˆfd„‰jD¦«‰_‰ |‰|||| ¦«}‰jr0ˆfd„‰jD¦«}|r|d‰ |¦«zz }‰jr| r‰ ¦«|z}‰jr|d‰j‰‰jfi| ¤Žzz }‰j d¦«‰s|r |rd|zdzS|S)NT)rnr×rôrÖÚnested_join_translationr(rÎFr;rrŽ)r‡rrzSELECT rcó—g|]}|®|‘ŒSr»rnrßs rrr z,SQLCompiler.visit_select..us)€ð ð ð àðˆ}ð ðˆ}ˆ}rtcóN•—g|]!\}}‰ ‰|‰‰‰|‰¬¦«‘Œ"S))rñr ©r#) rprñr rnrr rÙr[r´s €€€€€€rrr z,SQLCompiler.visit_select..wsYø€ðððñ!D˜&ð×)Ò)ØØØ'ØØ&ØØ,Cð*ñôðððrtcó—g|]\}}|‘ŒSrnrn©rprrñs rrr z,SQLCompiler.visit_select..Œs€ÐHÐHÐH™k˜s DTÐHÐHÐHrtcó—g|]\}}|‘ŒSrnrnrns rrr z,SQLCompiler.visit_select..s,€ðððá'˜S $ððððrtcóX•—g|]&\}}}}||tˆfd„|D¦«¦«|f‘Œ'S)c3óD•K—|]}‰ ||¦«V—ŒdSr»rX)rpÚoÚ translates €rrrNz6SQLCompiler.visit_select...•s1øèè€Ð!CÐ!C¸! )§-¢-°°1Ñ"5Ô"5Ð!CÐ!CÐ!CÐ!CÐ!CÐ!CrtrZ)rprrñrÊrêrss €rrr z,SQLCompiler.visit_select..”sWø€ð$ð$ð$á)C˜˜s EðdEÐ!CÐ!CÐ!CÐ!C¸sÐ!CÑ!CÔ!CÑCÔCÀUÐKð$ð$ð$rtcó:•—g|]\}}|d‰jjfv¯|‘ŒS©Ú*©r§rñ)rpÚdialect_nameÚhtr´s €rrr z,SQLCompiler.visit_select..žs<ø€ðððá&\ 2Ø C¨¬Ô):Ð#;Ð;Ð;ðà;Ð;Ð;rtrjrk)r7rr§Úsupports_right_nested_joinsrPÚvisit_selectrÑrr_Ú_setup_select_stackÚcopyrÚ_hintsÚ_setup_select_hintsrîríÚget_select_precolumnsÚ_columns_plus_namesrRrArÚ_compose_select_bodyÚ_statement_hintsr4rrGrïr=)r´r[rnr×rôrÖriÚselect_wraps_forrrËÚneeds_nested_translationr^r¾rØr@rfÚ hint_textÚbyfromrìÚper_dialectrr rÙrss``` @@@@rrr{zSQLCompiler.visit_select%sbøøøøøøø€ð Ôð =Ø+Ð+ð =à”Jð =ð”LÔ<Ð<ð !ð$ð Ø!%×!HÒ!HØñ"ô"Ðð%4Ô$Ø"ðàØØ#Ø-Ø(,ð ððððˆDð”z>ˆØ-5ÐIÔ)Ð)¸4¼:Àb¼>ˆð ð >ØyŠyÐ7¸Ñ?Ô?ð >àyŠyÐ5°uÑ=Ô=ð ÐÐ5ð˜AÒÐØ"'Ðð #ð ,Ð':¸fÐ'DÐ'DØÐ*Ð+à#ð Ø"ð Ø×;Ò;ØÐ.ñôððˆKà×(Ò(¨°¸ÀÑHÔHˆà#Ÿ[š[™]œ]ÐØ×!Ò!Ø$)ÀEÐJÐJñ ô ð ðˆàŒ=ð Ø $× 8Ò 8¸Ñ @Ô @ÑˆIvØð (Ø˜ C™Ñ'øàˆFàÔð PØÐ+DÔ+¨F°FÔ4DÐOÐOÈÐOÐOÑOˆDàÐ*Ô*¨6Ð<Ð<°VÐ<Ð<Ñ<ˆð ð ðððððððððð%+Ô$>ðñôð ñ ô ˆ ð"ð Ð#3Ð#?õÝØHÐH¨VÔ-GÐHÑHÔHððà+;Ô+OðñôñôñôˆIð$ð$ð$ð$à-1Ô-Að$ñ$ô$ˆDÔ ð ×(Ò(Ø&˜-¨°¸ñ ô ˆðÔ"ð Hððððà*0Ô*AðñôˆKð ð HØ˜˜d×:Ò:¸;ÑGÔGÑGÑGàŒ9ð 4˜ð 4Ø×*Ò*Ñ,Ô,¨tÑ3ˆDàÔð ØCÐ1˜$Ô1Ø˜Ô(ððØ,2ððññ ˆDð Œ ŠrÑÔÐàð gð 6ð Ø˜‘: Ñ#Ð#àˆKrtcóš‡—tˆfd„|j ¦«D¦«¦«}‰ |¦«}||fS)Nc óx•—g|]6\\}}}|d‰jjfv¯||d| ‰d¬¦«izf‘Œ7S)rvrñT)ró©r§rñrÉ)rpÚfrom_r§r(r´s €rrr z3SQLCompiler._setup_select_hints..·snø€ð ð ð ñ/Ñ$U˜G hØ˜s D¤LÔ$5Ð6Ð6Ð6ðØØ˜u×7Ò7¸ÀTÐ7ÑJÔJÐKñLðð7Ð6Ð6rt)rRr~rBr+)r´r[r‡r†s` rrrzSQLCompiler._setup_select_hintsµshø€Ýð ð ð ð ð39´-×2EÒ2EÑ2GÔ2Gð ñ ô ñ ô ˆð×-Ò-¨fÑ5Ô5ˆ Ø˜&Ð Ð rtcóR—|d}|d}|r-|s+| | |¦«d¬¦«}n| ||¬¦«}ttj|Ž¦«}| |¦«} || |dœ} |j | ¦«|S)Nr9r:rnra)r:r9r )rdrer]r Ú _from_objectsrfrr=)r´r[r@rnrr9r:rfÚnew_correlate_fromsÚall_correlate_fromsÚ new_entrys rrr|zSQLCompiler._setup_select_stackÄsß€ØÐ 1Ô2ˆØ˜^Ô,ˆàð ˜'ð Ø×-Ò-Ø)8×)CÒ)CØ ñ*ô*ð*,ð .ñôˆEˆEð×-Ò-Ø)8Ø)5ð.ñôˆEõ "¥*Ô":¸EÐ"BÑCÔCÐØ1×7Ò7¸ÑHÔHÐð0Ø2Ø ð ð ˆ ð Œ ×Ò˜)Ñ$Ô$Ð$àˆrtcó’‡‡‡—|d |¦«z }|rY|dz }|jr'|d ˆˆˆfd„|D¦«¦«z }n=|d ˆˆfd„|D¦«¦«z }n|‰ ¦«z }|j|jj‰fi‰¤Ž}|r|d|zz }|jjr|‰j|fi‰¤Žz }|j|jj‰fi‰¤Ž}|r|d|zz }|j jr|‰j |fi‰¤Žz }|j€|j|‰j |fi‰¤Žz }|j|‰j|fi‰¤Žz }|S)Nr€z FROM có2•—g|]}|j‰fd‰dœ‰¤Ž‘ŒS)T©rnrôrÈ)rpÚfr‡rËr´s €€€rrr z4SQLCompiler._compose_select_body..ësTø€ððððð-˜Ô,Ø ðØ)-¸ððØCIðððððrtcó0•—g|]}|j‰fddi‰¤Ž‘ŒS)rnTrÈ)rpr•rËr´s €€rrr z4SQLCompiler._compose_select_body..ôsCø€ðððàð-˜Ô,¨TÐIÐI¸$ÐIÀ&ÐIÐIðððrtz WHERE z HAVING )rBr~rhÚ_whereclauserÉÚ_group_by_clauserðrBÚ_havingÚ_order_by_clauserCrDrErFÚ_for_update_argÚfor_update_clause)r´r¾r[rìrfr‡rËÚts` `` rrr‚z SQLCompiler._compose_select_bodyásøøø€ð — ’ ˜-Ñ(Ô(Ñ(ˆàð (ØJÑˆDàŒ}ð Ø˜Ÿ š ððððððð"'ð ñôñôñð˜Ÿ š ðððððà!&ðñôñôñð D×%Ò%Ñ'Ô'Ñ'ˆDàÔÐ*Ø6Ô#Ô6°tÐFÐF¸vÐFÐFˆAØð (Ø˜ a™Ñ'àÔ"Ô*ð ;ØÐ(DÔ(¨Ð:Ð:°6Ð:Ð:Ñ:ˆDàŒ>Ð%Ø1”Ô1°$ÐAÐA¸&ÐAÐAˆAØð )Ø˜ qÑ(Ñ(àÔ"Ô*ð ;ØÐ(DÔ(¨Ð:Ð:°6Ð:Ð:Ñ:ˆDð Ô Ð,ØÔ$Ð0àÐ%DÔ% fÐ7Ð7°Ð7Ð7Ñ7ˆDàÔ!Ð-ØÐ*DÔ*¨6Ð<Ð<°VÐ<Ð<Ñ<ˆDàˆrtcó\‡‡—d ˆˆfd„|D¦«¦«}|r|dz }|S)Nrc3ó^•K—|]'\}}||‰jjk¯|j‰fi‰¤ŽV—Œ(dSr»r‹)rpÚprefixrxrër´s €€rrrNz1SQLCompiler._generate_prefixes.. s]øèè€ð ð á$˜ØÐ# |°t´|Ô7HÒ'HÐ'Hð &ˆFÔ% dÐ1Ð1¨bÐ1Ð1à'HÐ'HÐ'HÐ'Hð ð rtr2)r´ÚstmtÚprefixesrërús` ` rrrízSQLCompiler._generate_prefixes sZøø€Ø—’ð ð ð ð ð à(0ð ñ ô ñ ô ˆð ð Øc‰MˆFØˆ rtcó(‡—‰jr.tˆfd„‰jD¦«g¦«‰jz‰_‰ ‰j¦«dz}|d d„‰j ¦«D¦«¦«z }|dz }|S)Ncó*•—g|]}‰j|‘ŒSrn)r8)rpròr´s €rrr z2SQLCompiler._render_cte_clause..$ s!ø€ÐCÐCÐC°#TÔ(¨Ô-ÐCÐCÐCrtrú, có—g|]}|‘ŒSrnrn)rpÚtxts rrr z2SQLCompiler._render_cte_clause..( s€Ð CÐ CÐ C¨ Ð CÐ CÐ Crtz )rÚsumrrÚget_cte_preambler7rBÚvalues)r´Úcte_texts` rrrGzSQLCompiler._render_cte_clause! s£ø€ØŒ?ð åÐCÐCÐCÐC¸¼ÐCÑCÔCÀRÑHÔHØÔ"ñ#ð Ôð×(Ò(¨Ô)<Ñ=Ô=ÀÑCˆØF—K’KÐ CÐ C°´ ×0@Ò0@Ñ0BÔ0BÐ CÑ CÔ CÑDÔDÑDˆØEÑˆØˆrtcó—|rdSdS)NzWITH RECURSIVEÚWITHrn)r´ræs rrr©zSQLCompiler.get_cte_preamble, s€Øð Ø#Ð#à6rtcó—|jrdpdS)zcCalled when building a ``SELECT`` statement, position is just before column list. r„rÍ)Ú _distinct©r´r[rës rrr€z!SQLCompiler.get_select_precolumns2 s€ð ÔÐ/ KÐ5°2Ð5rtcó:—|jj|fi|¤Ž}|rd|zSdS)z5allow dialects to customize how GROUP BY is rendered.z GROUP BY rÍ)r˜rÉ)r´r[rëÚgroup_bys rrrBzSQLCompiler.group_by_clause9 ó9€ð>6Ô*Ô=¸dÐIÐIÀbÐIÐIˆØð Ø (Ñ*Ð*à2rtcó:—|jj|fi|¤Ž}|rd|zSdS)z5allow dialects to customize how ORDER BY is rendered.z ORDER BY rÍ)ršrÉ)r´r[rërs rrrCzSQLCompiler.order_by_clauseB r³rtcó—dS)Nz FOR UPDATErnr°s rrrœzSQLCompiler.for_update_clauseK s€Øˆ}rtcó*—tjd¦«‚)Nz@RETURNING is not supported by this dialect's statement compiler.r”)r´r¡Úreturning_colss rrÚreturning_clausezSQLCompiler.returning_clauseN s€ÝÔð ,ñ ô ð rtcó¢—d}|j|d|j|jfi|¤Žzz }|j%|j€|dz }|d|j|jfi|¤Žzz }|S)NrÍz LIMIT z LIMIT -1z OFFSET )rDr²rE)r´r[rër¾s rrrFzSQLCompiler.limit_clauseT s}€ØˆØÔÐ+ØK , $¤,¨vÔ/CÐ"JÐ"JÀrÐ"JÐ"JÑJÑJˆDØÔ Ð,ØÔ#Ð+Ø˜ Ñ%ØJ ¤¨fÔ.CÐ!JÐ!JÀrÐ!JÐ!JÑJÑJˆDØˆrtcóP—|s|r¡|j |¦«}|r@|r>|j |¦«dz|j |j¦«z} n|j |j¦«} |r"||vr| | ||||¦«} | SdS)Nr˜rÍ)rªržrŸrœrñrþ) r´rarnrÿrórôÚ use_schemarËr¢rs rrÚvisit_tablezSQLCompiler.visit_table^ sÐ€ðð Vð Ø#œ}×>Ò>¸uÑEÔEÐàð 6Ð.ð 6à”M×.Ò.Ð/?Ñ@Ô@Øñà”m×)Ò)¨%¬*Ñ5Ô5ñ6ðð”m×)Ò)¨%¬*Ñ5Ô5Øð ˜U iÐ/Ð/Ø×0Ò0Ø˜ ¨%Ô 0°&ñôðˆJà2rtcó¸—|jrd}n|jrd}nd}|jj|fddi|¤Ž|z|jj|fddi|¤Žzdz|jj|fi|¤ŽzS)Nz FULL OUTER JOIN z LEFT OUTER JOIN z JOIN rnTú ON )r6ÚisouterrDrÉrZrC)r´rBrnrËÚ join_types rrÚ visit_joinzSQLCompiler.visit_join{ s¥€ØŒ9ð !Ø+ˆIˆIØ Œ\ð !Ø+ˆIˆIà ˆIà(ˆDŒIÔ(¨ÐEÐE°dÐE¸fÐEÐEØñ à+ˆdŒjÔ+¨DÐHÐH¸ÐHÀÐHÐHñ Iðñ ð/ˆdŒmÔ.¨tÐ>Ð>°vÐ>Ð>ñ ?ð rtcóÒ‡—tˆfd„|j ¦«D¦«¦«}|j|vr(‰ ||j||jd¦«}||fS)NcóD•—g|]\\}}}|d‰jjfv¯||f‘ŒSrurw)rprar§r†r´s €rrr z1SQLCompiler._setup_crud_hints..Œ sFø€ð ð ð á/Ñ$U˜G iØ˜s D¤LÔ$5Ð6Ð6Ð6ð˜ Ð"à6Ð6Ð6rtT)rRr~rBrarþ)r´r¡Ú table_textÚ dialect_hintss` rrÚ_setup_crud_hintszSQLCompiler._setup_crud_hintsŠ s‰ø€Ýð ð ð ð à37´;×3DÒ3DÑ3FÔ3Fð ñ ô ñ ô ˆ ðŒ:˜Ð&Ð&Ø×3Ò3Ø˜DœJ¨ °d´jÔ(AÀ4ñôˆJð˜jÐ(Ð(rtcóþ‡—|j}|j t¦«t¦«|dœ¦«tj||tjfi|¤Ž}|s9|jjs-|jjs!tj d|jjz¦«‚|jr6|jj s!tj d|jjz¦«‚|d}n|}|jŠ|jj}d}|jr||j||jfi|¤Žz }|dz }‰ |j¦«} |jr| || ¦«\} } || z }|s|s'|dd ˆfd „|D¦«¦«zz }|js|jr2| ||jp|j¦«}|jr|d |zz }nd}|jN|j|jfi|¤Ž}|jr+|r)|jjr|d | ¦«›|›z }np|d|zz }ng|s|r|dz }n]|jr&|d d d„|D¦«¦«zz }n0d d„|D¦«¦«} |d| zz }|r| |_ |j!|j|j!fi|¤Ž}|r|d |zz }|r|js|d |zz }|jr%|r#|jjs| ¦«|z}|j "d¦«|rd|zdzS|S)N©r9r:r zWThe '%s' dialect with current database version settings does not support empty inserts.zcThe '%s' dialect with current database version settings does not support in-place multirow inserts.rzINSERT zINTO z (%s)r€cóF•—g|]}‰ |d¦«‘ŒS)r)rá)rprÚrªs €rrr z,SQLCompiler.visit_insert..Ñ s+ø€ÐJÐJÐJ°!×'Ò'¨¨!¬Ñ-Ô-ÐJÐJÐJrtrz %sz DEFAULT VALUESz VALUES %sc3óZK—|]&}dd d„|D¦«¦«zV—Œ'dS)rÐr€c3ó&K—|]}|dV—Œ dS)rNrnrßs rrrNz5SQLCompiler.visit_insert...ê s&èè€Ð'EÐ'E°¨¨!¬Ð'EÐ'EÐ'EÐ'EÐ'EÐ'ErtNr2)rpÚcrud_param_sets rrrNz+SQLCompiler.visit_insert..é sVèè€ððà&ð˜dŸišiÐ'EÐ'E°nÐ'EÑ'EÔ'EÑEÔEÑFððððððrtcó—g|] }|d‘ŒS)rrnrßs rrr z,SQLCompiler.visit_insert..ï s€Ð2MÐ2MÐ2M¸A°1°Q´4Ð2MÐ2MÐ2Mrtz VALUES (%s)r(rjrk)#rr=r]rÚ_setup_crud_paramsÚISINSERTr§Úsupports_default_valuesÚsupports_empty_insertr r‚rñÚ_has_multi_parametersÚsupports_multivalues_insertrªrîríÚformat_tablerar~rÆrBr%r$r¸Úreturning_precedes_valuesr[r²Ú_insert_from_selectrÚcte_follows_insertrGÚinsert_single_values_exprÚ_post_values_clauser=)r´Úinsert_stmtrnrërØÚcrud_paramsÚcrud_params_singlerÐr¾rÄrr¸Úselect_textrØÚpost_values_clauserªs @rrÚvisit_insertzSQLCompiler.visit_insert˜ sQø€Ø”z>ˆàŒ ×Òå#&¡5¤5Ý #¡¤Ø)ð ð ñ ô ð õÔ-Ø+tœ}ð ð Ø02ð ð ˆð ð à”LÔ8ð ð”LÔ6ð õ Ô"ðà!œ\Ô.ñ/ñôð ðÔ,ð -Ø”<Ô;ð ÝÔ&ð1à37´<Ô3DñEñôðð "-¨Q¤ÐÐà!,Ðà”=ˆØ"&¤,Ô"FÐàˆàÔ ð ØÐ+DÔ+Ø˜[Ô2ððØ68ððñ ˆDð ‰ˆØ×*Ò*¨;Ô+<Ñ=Ô=ˆ àÔð LØ ×2Ò2°;À ÑKÔK‰MˆAˆzà Ñˆàð Ð%<ð ØG˜dŸišiØJÐJÐJÐJÐ7IÐJÑJÔJñôññ ˆDðŒ>ð $˜[Ô3ð $Ø#×4Ò4Ø˜Tœ^ÐE¨{Ô/Eñ ô ÐðÔ-ð /Ø˜Ð.Ñ.Ñ.øà#ÐàÔÐ)Ø&˜$œ, tÔ'?ÐFÐFÀ2ÐFÐFˆKàŒyð ,˜Xð ,¨$¬,Ô*Ið ,Ø 4×#:Ò#:Ñ#<Ô#<Ð#<¸k¸kÐJÑJà˜ Ñ+Ñ+Øð KÐ!8ð KØÐ%Ñ%ˆDˆDØ Ô .ð KØLØ— ’ ððà*5ðñôñôññ ˆDˆDð)-¯ ª Ð2MÐ2MÀÐ2MÑ2MÔ2MÑ(NÔ(NÐ%ØNÐ%>Ñ>Ñ>ˆDØð KØ1JÔ.àÔ*Ð6Ø!- ¤ØÔ/ð"ð"Ø35ð"ð"Ðð"ð 1Ø˜Ð0Ñ0Ñ0àð + DÔ$Bð +ØCÐ*Ñ*Ñ*ˆDàŒ9ð 4˜ð 4¨$¬,Ô*Ið 4Ø×*Ò*Ñ,Ô,¨tÑ3ˆDàŒ ŠrÑÔÐàð Ø˜‘: Ñ#Ð#àˆKrtcó—dS)z3Provide a hook for MySQL to add LIMIT to the UPDATENrn)r´Úupdate_stmts rrÚupdate_limit_clausezSQLCompiler.update_limit_clause s€àˆtrtcó,—d|d<|j|fddi|¤ŽS)z|Provide a hook to override the initial table clause in an UPDATE statement. MySQL overrides this. TrnrÿrÈ)r´ráÚ from_tableÚextra_fromsrës rrÚupdate_tables_clausez SQLCompiler.update_tables_clause s-€ðˆˆ8‰Ø,ˆzÔ,¨TÐEÐE¸$ÐEÀ"ÐEÐEÐErtcó —td¦«‚)z~Provide a hook to override the generation of an UPDATE..FROM clause. MySQL and MSSQL override this. zCThis backend does not support multiple-table criteria within UPDATErÃ©r´ráräråÚ from_hintsrës rrÚupdate_from_clausezSQLCompiler.update_from_clause s€õ"ð %ñ ô ð rtcóÒ‡‡‡—‰j}|j}t|¦«}|rJtt j|j¦«¦«Šˆfd„|D¦«}‰ |¦«}n g}|jh}‰j |||dœ¦«d} |j r| ‰j ||j fi|¤Žz } ‰j||j|fi|¤Ž} tj ‰|tjfi|¤Ž}|jr‰ || ¦«\}} nd}| | z } | dz } |o‰jŠ| d ˆˆfd„|D¦«¦«z } ‰js|jr/‰jr(| d‰ |‰jp|j¦«zz } |r ‰j||j||fi|¤Ž} | r| d| zz } |j‰j|jfi|¤Ž}|r| d|zz } ‰ |¦«}|r| d|zz } ‰js|jr/‰js(| d‰ |‰jp|j¦«zz } ‰jr|r‰ ¦«| z} ‰j d ¦«|rd | zdzS| S)Ncó•—g|]}|‰v¯|‘Œ Srnrn)rpr•Ú main_fromss €rrr z,SQLCompiler.visit_update..- s*ø€ð"ð"ð"Ø¨!°:Ð*=Ð*=Ð*=Ð*=Ð*=rtrÈzUPDATE z SET r€c3ój•K—|]-}|d ‰‰¬¦«dz|dzV—Œ.dS)r)r ú=rNrÈ)rprÚr r´s €€rrrNz+SQLCompiler.visit_update..X sdøèè€ð ð ðð ˆaŒD×#Ò# D¸ Ð#ÑFÔFØñ àŒdñ ð ð ð ð ð ð rtrú WHERE r(rjrk)rÚ_extra_fromsÚboolr]r rŽrarfr=rîrírærrÎÚISUPDATEr~rÆÚ'render_table_with_column_in_update_fromrBr%r$rÕr¸rêr—r²rârrGr=)r´rárnrërØråÚ is_multitableÚrender_extra_fromsr9r¾rÄrÛrÅÚextra_from_textrrFr rís` @@rrÚvisit_updatezSQLCompiler.visit_update$ s¼øøø€Ø”z>ˆà!Ô.ˆÝ˜[Ñ)Ô)ˆ àð 2åZÔ5°kÔ6GÑHÔHÑIÔIˆJð"ð"ð"ð"Ø&ð"ñ"ô"Ðð)×.Ò.¨{Ñ;Ô;ˆOˆOà!#ÐØ*Ô0Ð1ˆOàŒ ×Òà#2Ø /Ø)ð ð ñ ô ð ðˆàÔ ð ØÐ+DÔ+Ø˜[Ô2ððØ68ððñ ˆDð/TÔ.Ø˜Ô*Ð,>ð ð ØBDð ð ˆ õÔ-Ø+tœ}ð ð Ø02ð ð ˆðÔð !Ø(,×(>Ò(>Ø˜Zñ)ô)Ñ%ˆM˜:˜:ð!ˆMà Ñˆà‰ˆàÐJ˜dÔJð ð — ’ ð ð ð ð ð ð!ð ñ ô ñ ô ñ ˆðŒ>ð ˜[Ô3ð ØÔ-ð Ø˜˜d×3Ò3Ø ¤Ð!I°;Ô3Iñôññðð .Ø5˜dÔ5ØØÔ!Ø"Øð ðð ððˆOðð .Ø˜˜oÑ-Ñ-àÔ#Ð/Ø”˜[Ô5Ð<Ð<¸Ð<Ð<ˆAØð &Ø˜ A™ Ñ%à×/Ò/°Ñ<Ô<ˆØð 'ØC˜,Ñ&Ñ&ˆDð ŒNð Ø)Ô4ð àÔ0ð ð C˜$×/Ò/Ø˜Tœ^ÐE¨{Ô/Eñôññ ˆDðŒ9ð 4˜ð 4Ø×*Ò*Ñ,Ô,¨tÑ3ˆDàŒ ŠrÑÔÐàð Ø˜‘: Ñ#Ð#àˆKrtcó6—tj||j¦«Sr»)rÚ_key_getters_for_crud_columnrr¸s rrrúz(SQLCompiler._key_getters_for_crud_columnŠ s€åÔ0°°t´~ÑFÔFÐFrtcó —td¦«‚)zÀ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. zCThis backend does not support multiple-table criteria within DELETErÃrès rrÚdelete_extra_from_clausez$SQLCompiler.delete_extra_from_clauseŽ s€õ"ð %ñ ô ð rtcó2—| |dd¬¦«S)NT)rnrÿrÈ)r´Údelete_stmträrås rrÚdelete_table_clausezSQLCompiler.delete_table_clausež s€Ø×,Ò,¨T¸$ÀtÐ,ÑLÔLÐLrtcót—|j}tj||tjfi|¤Ž|j}|jh |¦«}|j |||dœ¦«d}|jr||j ||jfi|¤Žz }|dz }| ||j|¦«}|jr| ||¦«\} }nd} ||z }|j r(|jr!|d| ||j ¦«zz }|r |j||j|| fi|¤Ž} | r|d| zz }|j|jj|fi|¤Ž}|r|d|zz }|j r(|js!|d| ||j ¦«zz }|jr|r| ¦«|z}|j d¦«|rd|zdzS|S) NrÈzDELETE úFROM rrðr(rjrk)rrrÎÚISDELETErñrarfr=rîrírÿr~rÆr$rÕr¸rür—rÉrrGr=)r´rþrnrërØrår9r¾rÄrÅr÷rs rrÚvisit_deletezSQLCompiler.visit_delete¡ s€Ø”z>ˆåÔ kµ4´=ÐGÐGÀBÐGÐGÐGà!Ô.ˆà&Ô,Ð-×3Ò3°KÑ@Ô@ˆØŒ ×Òà#2Ø /Ø)ð ð ñ ô ð ðˆàÔ ð ØÐ+DÔ+Ø˜[Ô2ððØ68ððñ ˆDð ‰ˆØ×-Ò-Ø˜Ô*¨Kñ ô ˆ ðÔð !Ø(,×(>Ò(>Ø˜Zñ)ô)Ñ%ˆM˜:˜:ð!ˆMà ÑˆàÔ!ð ØÔ-ð Ø˜˜d×3Ò3Ø Ô!7ñôññðð .Ø;˜dÔ;ØØÔ!ØØð ðð ððˆOðð .Ø˜˜oÑ-Ñ-àÔ#Ð/Ø;Ô(Ô;¸DÐGÐGÀBÐGÐGˆAØð &Ø˜ A™ Ñ%àÔ!ð ¨$Ô*Hð ØC˜$×/Ò/Ø˜[Ô3ñôññ ˆDðŒ9ð 4˜ð 4Ø×*Ò*Ñ,Ô,¨tÑ3ˆDàŒ ŠrÑÔÐàð Ø˜‘: Ñ#Ð#àˆKrtcó<—d|j |¦«zS)NzSAVEPOINT %s©rªÚformat_savepoint©r´Úsavepoint_stmts rrÚvisit_savepointzSQLCompiler.visit_savepointë s€Ø ¤ × >Ò >¸~Ñ NÔ NÑNÐNrtcó<—d|j |¦«zS)NzROLLBACK TO SAVEPOINT %srrs rrÚvisit_rollback_to_savepointz'SQLCompiler.visit_rollback_to_savepointî s&€Ø)¨D¬M×,JÒ,JØñ- ô- ñ ð rtcó<—d|j |¦«zS)NzRELEASE SAVEPOINT %srrs rrÚvisit_release_savepointz#SQLCompiler.visit_release_savepointó s&€Ø%¨¬ ×(FÒ(FØñ) ô) ñ ð rt)NF)NNT©F)NFFN)NT)NFTr»)FTr)FFF)FFNN)FFFN©NTF)FTNrFNF)FFFNT)žrÝrÞrßràÚEXTRACT_MAPrÚCOMPOUND_KEYWORDSr>r#r!r"rÉr%rÕrôrÙrurÒr<rrØr1r2r¶rär.r3rÚmemoized_instancemethodr9Ú contextlibÚcontextmanagerrAr&Úmemoized_propertyrSrWrÅrÑrÀÚdependenciesrerhror|r„r’r–r¥r©rr°rµr¿r›rÌrÛràrærérõrürrr rrrr!r.r3r0r,rJrQrWr\r_rerhrmrorrrbr}rrr„r†rwrUrVrr—r›ržr r¢r¤r”ršr¯r²r¶r¸rÅr¿rªrÀrŠr×rÅrårrr rñrÔr#rþr+r%r0r4rPr_râÚ frozensetrÑrgr{rr|r‚rírGr©r€rBrCrœr¸rFr¼rÁrÆrßrârærêrørúrürÿrr rr rnrtrrrr¿sŽ €€€€€ððð€Kà)Ðà%*Ð*€HÐ*ˆx˜(ðð €Kà€Iðð !&Ððð/4Ð+ðð %*Ð!ðð€Oðð %ÐððÐðð€Nðð!%Ððð)+Ð*€OoðØ!Ø#Ø"ð /ð/ð/ð/ðb ð ð ð=Að&Oð&Oð&Oð&OðPAðAðAðððððððIðIðIðððð ððð ð ð ð(>Bððððð@ðððððððððððð$ððð&KðKðKð ð ð ð ð ð ð. ð ð ð8 ð ð ð ð ð ð ð ð ð @ð @ð @ð @ðD8ð8ð8ð ð ð ðCðCðCð=>ð1ð1ð1ð1ðf-ð-ð-ðððð>BðBðBðBðBðBð ð ð ð ð ð ð<ð<ð<ð<ð<ð<ð ð ð ð>CðMðMðMðMð68ð8ð8ðððð ð ð ð ð ð ð ð ð ð05ððððð*GðGðGðGðGðGð ÔðIðIñÔðIðAðAðAðDðDðDðAðAðAðDðDðDðAðAðAðDðDðDð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð$ØØ"ð; ð; ð; ð; ðz@ð@ð@ðððð&ðððððð&$ð$ð$ð6;ð6ð6ð6ð6ð"ØØØð zAðzAðzAðzAð~ØØØð EðEðEðEðB>ð>ð>ððððð(ð(ð(ðEðEðEðØ"Ø %ðZJðZJðZJðZJðxðððððððððððð$ð$ð$ð[ð[ð[ðz ð ð ð.˜4Ô-Ø ˜Y˜Y™[œ[Ð )¨N¸I¸I¹K¼KÐ+HÐIñôÐððððð8ØØØØ %ØØðNðNðNðNð` !ð !ð !ðððð:4ð4ð4ðlððð ð ð ðððð6ð6ð6ðððððððððð ð ð ððððØØØØððððð: ð ð ð ð)ð)ð)ðnðnðnðnð`ðððFðFðFð ð ð ðdðdðdðdðL ÔðGðGñÔðGð ð ð ð MðMðMðHðHðHðHðTOðOðOð ð ð ð ð ð ð ð rtrcóH—eZdZdZd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Zd „ZdS)ÚStrSQLCompilera“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ó—dS)Nzrnr•s rrr–z$StrSQLCompiler._fallback_column_name s€ØÐrtcóV—|j|jfi|¤Ž›d|j|jfi|¤Ž›dS)Nú[ú])r²rDrZrds rrÚvisit_getitem_binaryz#StrSQLCompiler.visit_getitem_binarysJ€àˆDŒL˜œÐ+Ð+¨Ð+Ð+Ð+Ð+ØˆDŒL˜œÐ,Ð,¨Ð,Ð,Ð,Ð,ð ð rtcó —|j||fi|¤ŽSr»©rrds rrÚvisit_json_getitem_op_binaryz+StrSQLCompiler.visit_json_getitem_op_binaryó€Ø(ˆtÔ(¨°Ð@Ð@¸RÐ@Ð@Ð@rtcó —|j||fi|¤ŽSr»r rds rrÚ!visit_json_path_getitem_op_binaryz0StrSQLCompiler.visit_json_path_getitem_op_binaryr"rtcó<—d|j |¦«zS)Nz)rªÚformat_sequence)r´Úseqrës rrr0zStrSQLCompiler.visit_sequences€Ø*¨T¬]×-JÒ-JÈ3Ñ-OÔ-OÑOÐOrtcót‡—ˆfd„tj|¦«D¦«}dd |¦«zS)Nc óB•—g|]}‰ d|ddi¦«‘ŒSrrl©rprÚr´s €rrr z3StrSQLCompiler.returning_clause.. s?ø€ð ð ð àð ×%Ò% d¨A¨t°U¸BÑ?Ô?ð ð ð rtz RETURNING r€)rÚ_select_iterablesrB)r´r¡r·Úcolumnss` rrr¸zStrSQLCompiler.returning_clausesOø€ð ð ð ð åÔ/°Ñ?Ô?ð ñ ô ˆð ˜dŸiši¨Ñ0Ô0Ñ0Ð0rtcóT‡‡‡—dd ˆˆˆfd„|D¦«¦«zS)Nrr€c3ó:•K—|]}|j‰fd‰dœ‰¤ŽV—ŒdS©Tr”NrÈ©rprrérër´s €€€rrrNz4StrSQLCompiler.update_from_clause..*sSøèè€ð# ð# àð !ˆAÔ ÐO¨d¸jÐOÐOÈBÐOÐOð# ð# ð# ð# ð# ð# rtr2rès` ``rrrêz!StrSQLCompiler.update_from_clause'sTøøø€ð˜Ÿšð# ð# ð# ð# ð# ð# à ð# ñ# ô# ñ ô ñ ð rtcóT‡‡‡—dd ˆˆˆfd„|D¦«¦«zS)Nr€c3ó:•K—|]}|j‰fd‰dœ‰¤ŽV—ŒdSr/rÈr0s €€€rrrNz:StrSQLCompiler.delete_extra_from_clause..2sSøèè€ð ð àð !ˆAÔ ÐO¨d¸jÐOÐOÈBÐOÐOð ð ð ð ð ð rtr2rès` ``rrrüz'StrSQLCompiler.delete_extra_from_clause/sTøøø€ðd—i’ið ð ð ð ð ð à ð ñ ô ñ ô ñ ð rtcó—d|zS)Nz[%s]rnr.s rrr%z!StrSQLCompiler.get_from_hint_text7s€Ø˜‰}ÐrtN) rÝrÞrßràr–rr!r$r0r¸rêrür%rnrtrrrrù s®€€€€€ððð& ð ð ð ð ð ðAðAðAðAðAðAðPðPðPð1ð1ð1ð ð ð ð ð ð ðððððrtrcó.—eZdZejd„¦«Zejd„¦«Zd)d„Zd„Zd„Z d„Z d„Zd*d „Z d)d„Z d„Zd „Zd„Z d+d„Zd„Zd*d„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z d „Z!d!„Z"d"„Z#d#„Z$d$„Z%d%„Z&d&„Z'd'„Z(d(„Z)dS),ÚDDLCompilercóP—|j |jd|j¬¦«S)N)r«)r§Ústatement_compilerr«r¸s rrrÅzDDLCompiler.sql_compiler<s-€àŒ|×.Ò.ØŒL˜$°TÔ5Nð/ñ ô ð rtcó—|jjSr»)r§r³r¸s rrr³zDDLCompiler.type_compilerBs €àŒ|Ô)Ð)rtNcó—dSr»rnrÐs rrrÑzDDLCompiler.construct_paramsFr,rtcó—|j}t|jtj¦«r½| ¦«}|j}| |j¦«}t|¦«dkr|dd}}n|d|d}}| d|¦«| d|¦«| d| |j¦«¦«|j |j |z¦«S)NrrrÍr(rarÚfullname)ÚcontextrˆÚtargetrÚTabler}rªÚformat_table_seqrVÚ setdefaultrÔrÅr¿r)r´ÚddlrËr<rªÚpathraÚschs rrÚ visit_ddlzDDLCompiler.visit_ddlIsè€à”+ˆÝc”j¥&¤,Ñ/Ô/ð NØ—l’l‘n”nˆGà”}ˆHØ×,Ò,¨S¬ZÑ8Ô8ˆDÝ4‰yŒy˜AŠ~ˆ~Ø! !œW bsà! "œX t¨A¤wsà×Ò˜w¨Ñ.Ô.Ð.Ø×Ò˜x¨Ñ-Ô-Ð-Ø×Ò˜z¨8×+@Ò+@ÀÄÑ+LÔ+LÑMÔMÐMàÔ ×2Ò2°3´=À7Ñ3JÑKÔKÐKrtcóJ—|j |j¦«}d|zS)NzCREATE SCHEMA )rªÚ format_schemarð)r´r"rs rrÚvisit_create_schemazDDLCompiler.visit_create_schema\s$€Ø”×,Ò,¨V¬^Ñ<Ô<ˆØ &Ñ(Ð(rtcóf—|j |j¦«}d|z}|jr|dz }|S)NzDROP SCHEMA ú CASCADE)rªrFrðÚcascade)r´Údroprr¾s rrÚvisit_drop_schemazDDLCompiler.visit_drop_schema`s<€Ø”×,Ò,¨T¬\Ñ:Ô:ˆØ Ñ&ˆØŒ<ð ØJÑˆDØˆrtcó—|j}|j}d}|jr |d |j¦«dzz }|d| |¦«zdzz }| |¦«}|r||dzz }|dz }d}d}|jD]´}|j} | || jo|¬¦«} | ||z }d}|d | zz }| jrd }ŒD#tj $r_}tjtj tj d¦«|j| j|jdfz¦«|¬ ¦«Yd}~Œd}~wwxYw| ||j¬¦«}|r||d z|zz }|d| |¦«zz }|S)Nz CREATE rzTABLE rjrâF©Úfirst_pkr¥ú Tz (in table '%s', column '%s'): %sr)rŒ)Ú _include_foreign_key_constraintsz )%s )rðrªrîrBrÔÚcreate_table_suffixr,r²Úprimary_keyr r‚rr,ÚuÚdescriptionrñÚargsÚcreate_table_constraintsÚinclude_foreign_key_constraintsÚpost_create_table) r´r"rarªr¾rRÚ separatorrOÚ create_columnr Ú processedÚceÚconsts rrÚvisit_create_tablezDDLCompiler.visit_create_tablegs€Ø”ˆØ”=ˆàˆØŒ?ð 4ØC—H’H˜Uœ_Ñ-Ô-°Ñ3Ñ3ˆDØ˜8×0Ò0°Ñ7Ô7Ñ7¸#Ñ=Ñ=ˆà"×6Ò6°uÑ=Ô=ÐØð .ØÐ'¨#Ñ-Ñ-ˆDà‰ˆàˆ ðˆØ#œ^ð ð ˆMØ"Ô*ˆFð Ø ŸLšLØ!¨FÔ,>Ð,OÀxÀ<ð)ñô ðÐ(Ø˜IÑ%DØ &IØ˜D 9Ñ,Ñ,DØÔ%ð$Ø#HøøÝÔ#ð ð ð Ý”ÝÔ$ÝœÐAÑBÔBØ Ô,¨f¬k¸2¼7À1¼:ÐFñGñôððñôððððððøøøøð øøøð×-Ò-ØØ-3Ô-Sð.ñ ô ˆðð -ØI Ñ$ uÑ,Ñ,ˆDà˜d×4Ò4°UÑ;Ô;Ñ;Ñ;ˆØˆsÂ9C Ã D7ÃAD2Ä2D7Fcó¶‡—|j}|jrdS‰ ||¬¦«}d ˆfd„|jD¦«¦«}|r|d|zz }|S)NrNrc3óB•K—|]}‰ |¦«V—ŒdSr»)r²©rpr!r´s €rrrNz2DDLCompiler.visit_create_column.. s@øèè€ð ð Ø)3ˆDLŠL˜Ñ$Ô$ð ð ð ð ð ð rt)rðÚsystemÚget_column_specificationrBÚconstraints)r´r"rOr r¾r^s` rrÚvisit_create_columnzDDLCompiler.visit_create_column™sŠø€Ø”ˆàŒ=ð Ø4à×,Ò,¨V¸hÐ,ÑGÔGˆØ—’ð ð ð ð Ø7=Ô7Ið ñ ô ñ ô ˆðð ØC˜%‘KÑˆDàˆrtcóL‡‡‡—g}‰jr| ‰j¦«‰j}|| |¦«Šnt ¦«Š| ˆˆfd„‰jD¦«¦«d d„ˆfd„|D¦«D¦«¦«S)Ncó.•—g|]}|‰ju¯|‰v¯|‘ŒSrn)rS)rprÚÚ omit_fkcsras €€rrr z8DDLCompiler.create_table_constraints..¹s;ø€ð ð ð àØ˜EÔ-Ð-Ð-°!¸9Ð2DÐ2Dðà2DÐ2DÐ2Drtz, c3óK—|]}|®|V—Œ dSr»rn)rpÚps rrrNz7DDLCompiler.create_table_constraints..Às4èè€ð ð àðˆ}ð ðˆ}ˆ}ˆ}ð ð rtc3ó´•K—|]R}|j| ‰¦«¯‰jjrt|dd¦«°;‰ |¦«V—ŒSdS)NÚ use_alterF)Ú_create_ruler§Úsupports_alterrr²rbs €rrrNz7DDLCompiler.create_table_constraints..Âsøèè€ððààÔ+Ð3Ø!×.Ò.¨tÑ4Ô4ð4ðœÔ3ð 4õ # :¨{¸EÑBÔBð4ð—’˜ZÑ(Ô(ð4Ð3Ð3Ð3ð ðrt)rSr=Úforeign_key_constraintsrer]ÚextendÚ_sorted_constraintsrB)r´rarQreÚall_fkcsris`` @rrrWz$DDLCompiler.create_table_constraints¨søøøø€ðˆØÔð 2Ø×Ò˜uÔ0Ñ1Ô1Ð1àÔ0ˆØ+Ð7Ø ×+Ò+Ð,LÑMÔMˆIˆIå™œˆIà×Òð ð ð ð ð àÔ2ð ñ ô ñ ô ð ð}Š}ð ð ððððà"-ðñôð ñ ô ñ ô ð rtcóF—d|j |j¦«zS)Nz DROP TABLE ©rªrÔrð©r´rKs rrÚvisit_drop_tablezDDLCompiler.visit_drop_tableÑs€Ø ¤×!;Ò!;¸D¼LÑ!IÔ!IÑIÐIrtcóF—d|j |j¦«zS)Nz DROP VIEW rurvs rrÚvisit_drop_viewzDDLCompiler.visit_drop_viewÔs€Ø ¤ × :Ò :¸4¼<Ñ HÔ HÑHÐHrtcóL—|j€tjd|jz¦«‚dS)Nz,Index '%s' is not associated with any table.)rar r‚rñ©r´r¯s rrÚ_verify_index_tablezDDLCompiler._verify_index_table×s1€ØŒ;ÐÝÔ"ØAÀEÄJÑNñôð ðÐrtTc ód‡—|j}‰ |¦«‰j}d}|jr|dz }|j€tjd¦«‚|d‰ ||¬¦«›d| |j |¬¦«›dd ˆfd „|jD¦«¦«›dz }|S)NzCREATE zUNIQUE z0CREATE INDEX requires that the index have a namezINDEX ©Úinclude_schemar¾©r»ú (r€c3óR•K—|]!}‰j |dd¬¦«V—Œ"dS)FT©r rtN)rÅr²)rprßr´s €rrrNz1DDLCompiler.visit_create_index..ïsXøèè€ððððÔ!×)Ò)Ø¨¸Tð*ñôððððððrtrk)rðr|rªrgrñr r‚Ú_prepared_index_namerÔrarBÚexpressions)r´r"rÚinclude_table_schemar¯rªr¾s` rrÚvisit_create_indexzDDLCompiler.visit_create_indexÝsø€ð”ˆØ× Ò Ñ'Ô'Ð'Ø”=ˆØˆØŒ<ð ØIÑˆDØŒ:ÐÝÔ"ØBñôð ð ˆØ×%Ò% e¸NÐ%ÑKÔKÐKÐKØ×!Ò!Ø”Ð(<ð "ñ ô ð ð ð IŠIððððð"Ô-ð ñôñ ô ð ð ð ñ ˆðˆrtcóz—|j}|j€tjd¦«‚d| |d¬¦«zS)Nz.DROP INDEX requires that the index have a namez DROP INDEX Tr~)rðrñr r‚r„)r´rKr¯s rrÚvisit_drop_indexzDDLCompiler.visit_drop_indexøsT€Ø”ˆàŒ:ÐÝÔ"Ø@ñôð ð ×!:Ò!:Ø $ð";ñ" ô" ñ ð rtcóâ—|j |j |j¦«}nd}|r|r|j |¦«}nd}|j |¦«}|r|dz|z}|S©Nr˜)rarªržrŸÚformat_index)r´r¯rr¢Úschema_nameÚ index_names rrr„z DDLCompiler._prepared_index_namesŠ€ØŒ;Ð"Ø#œ}×>Ò>¸u¼{ÑKÔKÐÐà#ÐØð Ð.ð Øœ-×4Ò4Ð5EÑFÔFˆKˆKàˆKà”]×/Ò/°Ñ6Ô6ˆ àð 8Ø$ sÑ*¨ZÑ7ˆJØÐrtcó†—d|j |jj¦«›d| |j¦«›S)NúALTER TABLE z ADD )rªrÔrðrar²©r´r"s rrÚvisit_add_constraintz DDLCompiler.visit_add_constraints@€€àŒM×&Ò& v¤~Ô';Ñ<Ô<Ð<Ð<ØLŠL˜œÑ(Ô(Ð(ð ð rtcó´—d|j |j¦«›d|j |jjt j¦«¦«›S)NzCOMMENT ON TABLE rƒ)rªrÔrðrÅrªÚcommentr ÚStringr‘s rrÚvisit_set_table_commentz#DDLCompiler.visit_set_table_commentsV€€àŒM×&Ò& v¤~Ñ6Ô6Ð6Ð6ØÔ×2Ò2Ø”Ô&¬Ñ(9Ô(9ñ ô ð ð ð rtcóF—d|j |j¦«zS)NzCOMMENT ON TABLE %s IS NULLrurvs rrÚvisit_drop_table_commentz$DDLCompiler.visit_drop_table_comment!s(€Ø,¨t¬}×/IÒ/IØŒLñ0 ô0 ñ ð rtcóº—d|j |jdd¬¦«›d|j |jjt j¦«¦«›S)NzCOMMENT ON COLUMN T)Ú use_tabler»rƒ)rªrárðrÅrªr”r r•r‘s rrÚvisit_set_column_commentz$DDLCompiler.visit_set_column_comment&sj€€àŒM×'Ò'Ø”¨$¸4ð (ñ ô ð ð ð Ô×2Ò2Ø”Ô&¬Ñ(9Ô(9ñ ô ð ð ð rtcóJ—d|j |jd¬¦«zS)NzCOMMENT ON COLUMN %s IS NULLT)rš)rªrárðrvs rrÚvisit_drop_column_commentz%DDLCompiler.visit_drop_column_comment0s0€Ø-°´ ×0KÒ0KØŒL Dð1Lñ1 ô1 ñ ð rtcó—d|j |j¦«z}|jj|d|jjzz }|jj|d|jjzz }|jj|d|jjzz }|jj|d|jjzz }|jj|dz }|jj|dz }|jj |d|jj zz }|jj d ur|d z }|jj|dz }|S)NzCREATE SEQUENCE %sz INCREMENT BY %dz START WITH %dz MINVALUE %dz MAXVALUE %dz NO MINVALUEz NO MAXVALUEz CACHE %dTz ORDERz CYCLE)rªr&rðÚ incrementÚstartÚminvalueÚmaxvalueÚ nominvalueÚ nomaxvalueÚcacherTÚcycle)r´r"r¾s rrÚvisit_create_sequencez!DDLCompiler.visit_create_sequence5s"€Ø# d¤m×&CÒ&CØŒNñ' ô' ñ ˆðŒ>Ô#Ð/ØÐ&¨¬Ô)AÑAÑAˆDØŒ>ÔÐ+ØÐ$ v¤~Ô';Ñ;Ñ;ˆDØŒ>Ô"Ð.ØN V¤^Ô%<Ñ<Ñ<ˆDØŒ>Ô"Ð.ØN V¤^Ô%<Ñ<Ñ<ˆDØŒ>Ô$Ð0ØNÑ"ˆDØŒ>Ô$Ð0ØNÑ"ˆDØŒ>ÔÐ+ØK &¤.Ô"6Ñ6Ñ6ˆDØŒ>Ô 4Ð'Ð'ØHÑˆDØŒ>ÔÐ+ØHÑˆDØˆrtcóF—d|j |j¦«zS)NzDROP SEQUENCE %s)rªr&rðrvs rrÚvisit_drop_sequencezDDLCompiler.visit_drop_sequenceMs€Ø! D¤M×$AÒ$AÀ$Ä,Ñ$OÔ$OÑOÐOrtcóþ—|j}|j|j |¦«}nd}|€t jd|jz¦«‚d|j |jj¦«›d|›|jrdpd›S)NzÑ9Ñ9Ø˜tÔ0×8Ò8ØÔ¨eÀ4ð 9ñ ô ñ ñ ˆð ×4Ò4°ZÑ@Ô@Ñ@ˆØˆrtcóà—d}|j$|j |¦«}||d|zz }|d|j |jdd¬¦«zz }|| |¦«z }|Sr¾rÀrÂs rrÚvisit_column_check_constraintz)DDLCompiler.visit_column_check_constraint”rÄrtcó:‡—t|¦«dkrdSd}|j$‰j |¦«}||d|zz }|dz }|dd ˆfd„|jr|jn|jD¦«¦«zz }|‰ |¦«z }|S)NrrÍr¿zPRIMARY KEY rÐr€c3óV•K—|]#}‰j |j¦«V—Œ$dSr»©rªrœrñr*s €rrrNz;DDLCompiler.visit_primary_key_constraint..©sIøèè€ð# ð# àð ŒM×Ò ¤Ñ'Ô'ð# ð# ð# ð# ð# ð# rt) rVrñrªr«rBÚ_implicit_generatedÚcolumns_autoinc_firstr,rÁrÂs` rrÚvisit_primary_key_constraintz(DDLCompiler.visit_primary_key_constraint sÙø€Ýˆz‰?Œ?˜aÒÐØ2ØˆØŒ?Ð&Ø!œ]×<Ò<¸ZÑHÔHˆNØÐ)ØÐ(¨>Ñ9Ñ9ØÑˆØ˜Ÿšð# ð# ð# ð# ðÔ1ð( Ô0Ð0àÔ'ð# ñ# ô# ñ ô ñ ñ ˆð ×4Ò4°ZÑ@Ô@Ñ@ˆØˆrtc ó ‡—|jŠd}|j$|j |¦«}||d|zz }t|j¦«djj}|dd ˆfd„|jD¦«¦«›d| ||‰¦«›dd ˆfd „|jD¦«¦«›d z }|| |¦«z }|| |¦«z }|| |¦«z }|S)NrÍr¿rzFOREIGN KEY(r€c3óV•K—|]#}‰ |jj¦«V—Œ$dSr»)rœÚparentrñ©rpr•rªs €rrrNz;DDLCompiler.visit_foreign_key_constraint..½óDøèè€ððØ23—’˜qœxœ}Ñ-Ô-ððððððrtz ) REFERENCES rc3óV•K—|]#}‰ |jj¦«V—Œ$dSr»)rœr rñrÐs €rrrNz;DDLCompiler.visit_foreign_key_constraint..ÃrÑrtrk)rªrñr«r0rr rarBÚdefine_constraint_remote_tableÚdefine_constraint_matchÚdefine_constraint_cascadesrÁ)r´r!r¾r¬Úremote_tablerªs @rrÚvisit_foreign_key_constraintz(DDLCompiler.visit_foreign_key_constraint´smø€Ø”=ˆØˆØŒ?Ð&Ø!œ]×<Ò<¸ZÑHÔHˆNØÐ)ØÐ(¨>Ñ9Ñ9Ý˜JÔ/Ñ0Ô0°Ô3Ô:Ô@ˆØˆØIŠIððððØ7AÔ7Jðñôñ ô ð ð ð ×/Ò/Ø˜L¨(ñ ô ð ð ð IŠIððððØ7AÔ7Jðñôñ ô ð ð ð ñ ˆð ×,Ò,¨ZÑ8Ô8Ñ8ˆØ×/Ò/° Ñ;Ô;Ñ;ˆØ×4Ò4°ZÑ@Ô@Ñ@ˆØˆrtcó,—| |¦«S)z=Format the remote table clause of a CREATE CONSTRAINT clause.)rÔ)r´r!rarªs rrrÓz*DDLCompiler.define_constraint_remote_tableÌs€ð×$Ò$ UÑ+Ô+Ð+rtcó ‡—t|¦«dkrdSd}|j$‰j |¦«}||d|zz }|dd ˆfd„|D¦«¦«zz }|‰ |¦«z }|S)NrrÍr¿zUNIQUE (%s)r€c3óV•K—|]#}‰j |j¦«V—Œ$dSr»rÉr*s €rrrNz6DDLCompiler.visit_unique_constraint..Ús5øèè€ÐFÐF°ad”m×)Ò)¨!¬&Ñ1Ô1ÐFÐFÐFÐFÐFÐFrt)rVrñrªr«rBrÁrÂs` rrÚvisit_unique_constraintz#DDLCompiler.visit_unique_constraintÑs¥ø€Ýˆz‰?Œ?˜aÒÐØ2ØˆØŒ?Ð&Ø!œ]×<Ò<¸ZÑHÔHˆNØÐ)ØÐ(¨>Ñ9Ñ9Ø ØIŠIÐFÐFÐFÐF¸:ÐFÑFÔFÑFÔFñ ñ ˆð ×4Ò4°ZÑ@Ô@Ñ@ˆØˆrtcóÒ—d}|j+|d|j |jt¦«zz }|j+|d|j |jt ¦«zz }|S)NrÍz ON DELETE %sz ON UPDATE %s)ÚondeleterªÚvalidate_sql_phraseÚFK_ON_DELETEÚonupdateÚFK_ON_UPDATE©r´r!r¾s rrrÕz&DDLCompiler.define_constraint_cascadesßs|€ØˆØÔÐ*ØO d¤m×&GÒ&GØÔ#¥\ñ'ô'ññ ˆDðÔÐ*ØO d¤m×&GÒ&GØÔ#¥\ñ'ô'ññ ˆDðˆrtcó —d}|j|jr|dz }n|dz }|j+|d|j |jt¦«zz }|S)NrÍz DEFERRABLEz NOT DEFERRABLEz INITIALLY %s)r*r<rªrÞÚFK_INITIALLYrâs rrrÁz+DDLCompiler.define_constraint_deferrabilityëso€ØˆØÔ Ð,ØÔ$ð *Ø˜ Ñ%àÐ)Ñ)ØÔÐ+ØO d¤m×&GÒ&GØÔ$¥lñ'ô'ññ ˆDðˆrtcó2—d}|j |d|jzz }|S)NrÍz MATCH %s)Úmatchrâs rrrÔz#DDLCompiler.define_constraint_matchøs'€ØˆØÔÐ'ØK *Ô"2Ñ2Ñ2ˆDØˆrtcóŠ—d|j |jdd¬¦«z}|jdur|dz }n|jdur|dz }|S)NzGENERATED ALWAYS AS (%s)FTrƒz STOREDz VIRTUAL)rÅr²r&Ú persisted)r´Ú generatedr¾s rrÚvisit_computed_columnz!DDLCompiler.visit_computed_columnþsj€Ø)¨DÔ,=×,EÒ,EØÔ¨UÀ$ð-Fñ- ô- ñ ˆðÔ $Ð&Ð&ØIÑˆDˆDØ Ô EÐ )Ð )ØJÑˆDØˆrtr»r)FT)*rÝrÞrßrrrÅr³rÑrDrGrLr_rfrWrwryr|r‡r‰r„r’r–r˜r›rr§r©rrdrRrYr¯rÃrÆrÌr×rÓrÛrÕrÁrÔrêrnrtrrr5r5;s€€€€€Ø Ôð ð ñÔð ð Ôð*ð*ñÔð*ðððððLðLðLð&)ð)ð)ðððð0ð0ð0ðd ð ð ð ð 7;ð' ð' ð' ð' ðRJðJðJðIðIðIððððBFððððð6 ð ð ððððð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ððð0PðPðPð ð ð ð$ððð&ððððððððð ð ð ð ð ð ðððð(ððð0,ð,ð,ð ððð ð ð ðððððððððððrtr5có —eZdZd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Zd „Zd„Z d„Zd „Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„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+S),ÚGenericTypeCompilercó—dS)NÚFLOATrnrés rrÚvisit_FLOATzGenericTypeCompiler.visit_FLOAT ó€Øˆwrtcó—dS)NÚREALrnrés rrÚ visit_REALzGenericTypeCompiler.visit_REAL rártcó^—|j€dS|j€dd|jizSd|j|jdœzS)NÚNUMERICzNUMERIC(%(precision)s)Ú precisionz!NUMERIC(%(precision)s, %(scale)s)©röÚscaler÷rés rrÚ visit_NUMERICz!GenericTypeCompiler.visit_NUMERIC óJ€ØŒ?Ð"Ø9Ø Œ[Ð Ø+¨{¸E¼OÐ.LÑLÐLà6Ø"œ_Øœð:ð:ñð rtcó^—|j€dS|j€dd|jizSd|j|jdœzS)NÚDECIMALzDECIMAL(%(precision)s)röz!DECIMAL(%(precision)s, %(scale)s)r÷r÷rés rrÚ visit_DECIMALz!GenericTypeCompiler.visit_DECIMAL rúrtcó—dS)NÚINTEGERrnrés rrÚ visit_INTEGERz!GenericTypeCompiler.visit_INTEGER& ó€Øˆyrtcó—dS)NÚSMALLINTrnrés rrÚvisit_SMALLINTz"GenericTypeCompiler.visit_SMALLINT) ó€Øˆzrtcó—dS)NÚBIGINTrnrés rrÚvisit_BIGINTz GenericTypeCompiler.visit_BIGINT, s€Øˆxrtcó—dS)NÚ TIMESTAMPrnrés rrÚvisit_TIMESTAMPz#GenericTypeCompiler.visit_TIMESTAMP/ s€Øˆ{rtcó—dS)NÚDATETIMErnrés rrÚvisit_DATETIMEz"GenericTypeCompiler.visit_DATETIME2 rrtcó—dS)NÚDATErnrés rrÚ visit_DATEzGenericTypeCompiler.visit_DATE5 rártcó—dS)NÚTIMErnrés rrÚ visit_TIMEzGenericTypeCompiler.visit_TIME8 rártcó—dS)NÚCLOBrnrés rrÚ visit_CLOBzGenericTypeCompiler.visit_CLOB; rártcó—dS)NÚNCLOBrnrés rrÚvisit_NCLOBzGenericTypeCompiler.visit_NCLOB> rðrtcóZ—|}|jr |d|jzz }|jr |d|jzz }|S)Nú(%d)z COLLATE "%s")Úlengthr¨)r´rêrñr¾s rrÚ_render_string_typez'GenericTypeCompiler._render_string_typeA sB€àˆØŒ<ð *ØF˜Uœ\Ñ)Ñ)ˆDØŒ?ð 6ØO e¤oÑ5Ñ5ˆDØˆrtcó.—| |d¦«S)NÚCHAR©rrés rrÚ visit_CHARzGenericTypeCompiler.visit_CHARJ ó€Ø×'Ò'¨¨vÑ6Ô6Ð6rtcó.—| |d¦«S)NÚNCHARr!rés rrÚvisit_NCHARzGenericTypeCompiler.visit_NCHARM s€Ø×'Ò'¨¨wÑ7Ô7Ð7rtcó.—| |d¦«S)NÚVARCHARr!rés rrÚ visit_VARCHARz!GenericTypeCompiler.visit_VARCHARP s€Ø×'Ò'¨¨yÑ9Ô9Ð9rtcó.—| |d¦«S)NÚNVARCHARr!rés rrÚvisit_NVARCHARz"GenericTypeCompiler.visit_NVARCHARS s€Ø×'Ò'¨¨zÑ:Ô:Ð:rtcó.—| |d¦«S)NÚTEXTr!rés rrÚ visit_TEXTzGenericTypeCompiler.visit_TEXTV r#rtcó—dS)NÚBLOBrnrés rrÚ visit_BLOBzGenericTypeCompiler.visit_BLOBY rártcó.—d|jr d|jzpdzS)NÚBINARYrrÍ©rrés rrÚvisit_BINARYz GenericTypeCompiler.visit_BINARY\ s €Ø˜5œ<ÐA¨F°U´\Ñ,AÐGÀRÑHÐHrtcó.—d|jr d|jzpdzS)NÚ VARBINARYrrÍr5rés rrÚvisit_VARBINARYz#GenericTypeCompiler.visit_VARBINARY_ s €Ø˜eœlÐD¨v¸¼Ñ/DÐJÈÑKÐKrtcó—dS)NÚBOOLEANrnrés rrÚ visit_BOOLEANz!GenericTypeCompiler.visit_BOOLEANb rrtcó—|j|fi|¤ŽSr»)r2rés rrÚvisit_large_binaryz&GenericTypeCompiler.visit_large_binarye ó€ØˆtŒ˜uÐ+Ð+¨Ð+Ð+Ð+rtcó—|j|fi|¤ŽSr»)r<rés rrÚ visit_booleanz!GenericTypeCompiler.visit_booleanh ó€Ø!ˆtÔ! %Ð.Ð.¨2Ð.Ð.Ð.rtcó—|j|fi|¤ŽSr»)rrés rrÚ visit_timezGenericTypeCompiler.visit_timek r?rtcó—|j|fi|¤ŽSr»)rrés rrÚvisit_datetimez"GenericTypeCompiler.visit_datetimen ó€Ø"ˆtÔ" 5Ð/Ð/¨BÐ/Ð/Ð/rtcó—|j|fi|¤ŽSr»)rrés rrÚ visit_datezGenericTypeCompiler.visit_dateq r?rtcó—|j|fi|¤ŽSr»)rrés rrÚvisit_big_integerz%GenericTypeCompiler.visit_big_integert s€Ø ˆtÔ Ð-Ð-¨"Ð-Ð-Ð-rtcó—|j|fi|¤ŽSr»)rrés rrÚvisit_small_integerz'GenericTypeCompiler.visit_small_integerw rGrtcó—|j|fi|¤ŽSr»)rrés rrÚ visit_integerz!GenericTypeCompiler.visit_integerz rBrtcó—|j|fi|¤ŽSr»)rórés rrÚ visit_realzGenericTypeCompiler.visit_real} r?rtcó—|j|fi|¤ŽSr»)rïrés rrÚvisit_floatzGenericTypeCompiler.visit_float€ s€ØˆtÔ Ð,Ð,¨Ð,Ð,Ð,rtcó—|j|fi|¤ŽSr»)rùrés rrÚ visit_numericz!GenericTypeCompiler.visit_numericƒ rBrtcó—|j|fi|¤ŽSr»©r)rés rrÚvisit_stringz GenericTypeCompiler.visit_string† rBrtcó—|j|fi|¤ŽSr»rWrés rrÚ visit_unicodez!GenericTypeCompiler.visit_unicode‰ rBrtcó—|j|fi|¤ŽSr»©r/rés rrÚ visit_textzGenericTypeCompiler.visit_textŒ r?rtcó—|j|fi|¤ŽSr»r\rés rrÚvisit_unicode_textz&GenericTypeCompiler.visit_unicode_text r?rtcó—|j|fi|¤ŽSr»rWrés rrÚ visit_enumzGenericTypeCompiler.visit_enum’ rBrtcó0—tjd|z¦«‚)NzKCan't generate DDL for %r; did you forget to specify a type on this Column?r”rés rrràzGenericTypeCompiler.visit_null• s$€ÝÔð #à%*ñ +ñ ô ð rtcóN—|j| |j¦«fi|¤ŽSr»)r²Útype_enginer§rés rrÚvisit_type_decoratorz(GenericTypeCompiler.visit_type_decoratorœ s,€ØˆtŒ|˜E×-Ò-¨d¬lÑ;Ô;ÐBÐB¸rÐBÐBÐBrtcó—|jdi|¤ŽS)Nrn)Úget_col_specrés rrÚvisit_user_definedz&GenericTypeCompiler.visit_user_definedŸ s€Ø!ˆuÔ!Ð'Ð' BÐ'Ð'Ð'rtN)-rÝrÞrßrïrórùrýrrrrrrrrrrr"r&r)r,r/r2r6r9r<r>rArDrFrIrKrMrOrQrSrUrXrZr]r_raràrerhrnrtrrrìrì s“€€€€€ððððððð ð ð ð ð ð ððððððððððððððððððððððððððððððð7ð7ð7ð8ð8ð8ð:ð:ð:ð;ð;ð;ð7ð7ð7ððððIðIðIðLðLðLðððð,ð,ð,ð/ð/ð/ð,ð,ð,ð0ð0ð0ð,ð,ð,ð.ð.ð.ð0ð0ð0ð/ð/ð/ð,ð,ð,ð-ð-ð-ð/ð/ð/ð/ð/ð/ð/ð/ð/ð,ð,ð,ð,ð,ð,ð/ð/ð/ð ð ð ðCðCðCð(ð(ð(ð(ð(rtrìcó—eZdZd„Zd„ZdS)ÚStrSQLTypeCompilercóX—| d¦«r|jSt|¦«‚)NrL)Ú startswithÚ_visit_unknownÚAttributeError)r´rs rrÚ__getattr__zStrSQLTypeCompiler.__getattr__¤ s-€Ø>Š>˜(Ñ#Ô#ð &ØÔ&Ð&å Ñ%Ô%Ð%rtcó —d|jjzS)Nz%s)r)rÝrés rrrmz!StrSQLTypeCompiler._visit_unknownª s€Øe”oÔ.Ñ.Ð.rtN)rÝrÞrßrormrnrtrrrjrj£ s2€€€€€ð&ð&ð&ð/ð/ð/ð/ð/rtrjcó4—eZdZdZeZeZeZ e jd¦«Z dd„Z d„Zd„Zd „Zd „Zd„Zd„Zd „Zdd„Zdd„Zd„Zd d„Zdd„Zdd„Zdd„Zejd¦«d„¦«Zd„Zd!d„Z d„Z! d"d„Z"d d„Z#ej$d„¦«Z%d„Z&dS)#ÚIdentifierPreparerz@Handle quoting and case-folding of identifiers based on options.Nú"TFcóº—||_||_|p|j|_||_|jdz|_||_||_i|_|jjdv|_ dS)asConstruct 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. r)rzrxN) r§Ú initial_quoteÚfinal_quoteÚescape_quoteÚescape_to_quoteÚomit_schemaÚquote_case_sensitive_collationsÚ_stringsrr»)r´r§rurvrwrzrys rrr¶zIdentifierPreparer.__init__º so€ð.ˆŒØ*ˆÔØ&Ð<¨$Ô*<ˆÔØ(ˆÔØ#Ô0°1Ñ4ˆÔØ&ˆÔØ/NˆÔ,ØˆŒ Ø $¤Ô 7ð< ð! ˆÔÐÐrtcó´—|j |j¦«}|j |j¦«t j|¦«|_|Sr»)r)Ú__new__Ú__dict__rrÚ_schema_getterrž)r´r«Úpreps rrr¬z)IdentifierPreparer._with_schema_translateÞ sJ€ØŒ~×%Ò% d¤nÑ5Ô5ˆØŒ ×Ò˜Tœ]Ñ+Ô+Ð+Ý!'Ô!6Ð7KÑ!LÔ!LˆÔØˆrtcó€—| |j|j¦«}|jr| dd¦«}|S)z€Escape an identifier. Subclasses should override this to provide database-dependent escaping behavior. r¸r¹)r¼rwrxr»©r´r s rrÚ_escape_identifierz%IdentifierPreparer._escape_identifierä s@€ð— ’ ˜dÔ/°Ô1EÑFÔFˆØÔ ð -Ø—M’M # tÑ,Ô,ˆEØˆrtcóB—| |j|j¦«S)z±Canonicalize an escaped identifier. Subclasses should override this to provide database-dependent unescaping behavior that reverses _escape_identifier. )r¼rxrwr‚s rrÚ_unescape_identifierz'IdentifierPreparer._unescape_identifierð s€ð}Š}˜TÔ1°4Ô3DÑEÔEÐErtcót—|5| |¦«s tjd|›d|j›d¦«‚|S)zý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 NzUnexpected SQL phrase: z (matching against rk)rær r‚Úpattern)r´rðÚregs rrrÞz&IdentifierPreparer.validate_sql_phraseù sN€ðÐ s§y¢y°Ñ'9Ô'9ÐÝÔ"Ð"à77˜CœK˜K˜Kð)ñôð ðˆrtcóL—|j| |¦«z|jzS)z~Quote an identifier. Subclasses should override this to provide database-dependent quoting behavior. )rurƒrvr‚s rrÚquote_identifierz#IdentifierPreparer.quote_identifiers0€ð ÔØ×%Ò% eÑ,Ô,ñ -àÔñ ð rtcóÀ—| ¦«}||jvpA|d|jvp2|j tj|¦«¦«p||kS)z5Return True if the given identifier requires quoting.r)r'Úreserved_wordsÚillegal_initial_charactersÚlegal_charactersrærÚ text_type)r´r Úlc_values rrrðz#IdentifierPreparer._requires_quotessh€à—;’;‘=”=ˆà˜Ô+Ð+ð #ØQŒx˜4Ô:Ð:ð #àÔ(×.Ò.t¬~¸eÑ/DÔ/DÑEÔEÐEð #ð˜EÒ!ð rtcó\—|j tj|¦«¦«S)zjReturn True if the given identifier requires quoting, but not taking case convention into account.)rŽrærrr‚s rrr$z1IdentifierPreparer._requires_quotes_illegal_chars"s(€ðÔ(×.Ò.t¬~¸eÑ/DÔ/DÑEÔEÐEÐErtcóX—|tjd¦«| |¦«S)aConditionally 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`. NzÚ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Úwarn_deprecatedrœ)r´rÚforces rrrŸzIdentifierPreparer.quote_schema's:€ð.Ðõ Ô ð!ñ ô ð ðzŠz˜&Ñ!Ô!Ð!rtcóF—|tjd¦«t|dd¦«}|€`||jvr |j|S| |¦«r| |¦«|j|<n ||j|<|j|S|r| |¦«S|S)aConditionally quote an identfier. 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`. NzÓ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œ)rr“rr{rðrŠ)r´rr”s rrrœzIdentifierPreparer.quoteLsÅ€ð,Ðõ Ô ð!ñ ô ð õ˜˜w¨Ñ-Ô-ˆàˆ=Ø˜œ Ð%Ð%Ø”} UÔ+Ð+à×(Ò(¨Ñ/Ô/ð1Ø+/×+@Ò+@ÀÑ+GÔ+GD”M %Ñ(Ð(à+0D”M %Ñ(Ø”} UÔ+Ð+Ø ð Ø×(Ò(¨Ñ/Ô/Ð/àˆLrtcó>—|jr| |¦«S|Sr»)rzrœ)r´Úcollation_names rrr§z#IdentifierPreparer.format_collation~s%€ØÔ/ð "Ø—:’:˜nÑ-Ô-Ð-à!Ð!rtcó°—| |j¦«}| |¦«}|js|r|| |¦«dz|z}|Sr‹)rœrñržryrŸ)r´r1r»rñr¢s rrr&z"IdentifierPreparer.format_sequence„sk€ØzŠz˜(œ-Ñ(Ô(ˆà×1Ò1°(Ñ;Ô;ÐðÔ ð Dàð Dð!Ð,à×$Ò$Ð%5Ñ6Ô6¸Ñ<¸tÑCˆDØˆrtcó:—| |p|j¦«Sr»©rœrñ)r´rïrñs rrrzIdentifierPreparer.format_label‘ó€ØzŠz˜$Ð, %¤*Ñ-Ô-Ð-rtcó:—| |p|j¦«Sr»rš)r´r™rñs rrrçzIdentifierPreparer.format_alias”r›rtcól—|p|j}| |¦«r| |¦«}|Sr»)rrðrŠ)r´Ú savepointrñrs rrrz#IdentifierPreparer.format_savepoint—s>€ðÐ'˜ œˆØ× Ò Ñ'Ô'ð 1Ø×)Ò)¨%Ñ0Ô0ˆEØˆrtzsqlalchemy.sql.namingcó—|jtjur | ||j¦«}|€dSn|j}t|tj¦«r}|jdkr|jj p|jj }n|jjp|jj }t|¦«|kr-|d|dz …dztj|¦«dd…z}n|j |¦«| |¦«S)Nr¯réréüÿÿÿ)rñrÚ _NONE_NAMEÚ_constraint_name_for_tablerarˆr‰rür§Úmax_index_name_lengthrÚmax_constraint_name_lengthrVrÚmd5_hexÚvalidate_identifierrœ)r´Únamingr!rñÚmax_s rrr«z$IdentifierPreparer.format_constraint s€àŒ?hÔ1Ð1Ð1Ø×4Ò4Ø˜JÔ,ñôˆDðˆ|Øtðð”?ˆDådHÔ5Ñ6Ô6ð 3ðÔ(¨GÒ3Ð3à”LÔ6ð:Ø”|Ô9ðð”LÔ;ð:Ø”|Ô9ðõ4‰yŒy˜4ÒÐØ˜A q¡˜LÔ)¨CÑ/µ$´,¸tÑ2DÔ2DÀRÀSÀSÔ2IÑIøàŒL×,Ò,¨TÑ2Ô2Ð2àzŠz˜$ÑÔÐrtcó,—| |¦«Sr»)r«r{s rrrŒzIdentifierPreparer.format_indexÁs€Ø×%Ò% eÑ,Ô,Ð,rtcó¸—|€|j}| |¦«}| |¦«}|js|r|r| |¦«dz|z}|S)z'Prepare a quoted table and schema name.Nr˜)rñrœržryrŸ)r´rar»rñrfr¢s rrrÔzIdentifierPreparer.format_tableÄsu€ðˆ<Ø”:ˆDØ—’˜DÑ!Ô!ˆà×1Ò1°%Ñ8Ô8ÐàÔð H Jð HÐ3Cð HØ×&Ò&Ð'7Ñ8Ô8¸3Ñ>ÀÑGˆFØˆ rtcó,—| |¦«S)zPrepare a quoted schema name.)rœrÖs rrrFz IdentifierPreparer.format_schemaÑs€ðzŠz˜$ÑÔÐrtcó—|€|j}t|dd¦«sM|r6| |j||¬¦«dz| |¦«zS| |¦«S|r#| |j||¬¦«dz|zS|S)zPrepare a quoted column name.NršF)r»rñr˜)rñrrÔrarœ)r´r ršrñÚ table_namer»s rrráz IdentifierPreparer.format_columnÖsÑ€ðˆ<Ø”;ˆDÝv˜|¨UÑ3Ô3ð Øð (à×%Ò%Øœ°À*ð&ñôðñð—j’j Ñ&Ô&ñ 'ðð—z’z $Ñ'Ô'Ð'ð ð à×%Ò%Øœ°À*ð&ñôðñðñ ððrtcóÊ—| |¦«}|js0|r.|r,| |¦«| |d¬¦«fS| |d¬¦«fS)z(Format table name and schema as a tuple.Fr€)ržryrŸrÔ)r´rar»r¢s rrr?z#IdentifierPreparer.format_table_seqüs…€ð ×1Ò1°%Ñ8Ô8ÐàÔð A Jð AÐ3Cð Aà×!Ò!Ð"2Ñ3Ô3Ø×!Ò! %°EÐ!Ñ:Ô:ðð ð ×%Ò% e¸Ð%Ñ>Ô>Ð@Ð@rtcó¦—d„|j|j| |j¦«fD¦«\}}}tjd|||dœz¦«}|S)Ncó6—g|]}tj|¦«‘ŒSrn)rJr¦rìs rrr z5IdentifierPreparer._r_identifiers..s0€ð) ð) ð) àõ ŒIa‰LŒLð) ð) ð) rtzM(?:(?:%(initial)s((?:%(escaped)s|[^%(final)s])+)%(final)s|([^\.]+))(?=\.|$))+)ÚinitialÚfinalÚescaped)rurvrƒrJr¹)r´r²r³Ú escaped_finalÚrs rrÚ_r_identifiersz!IdentifierPreparer._r_identifiers s€ð) ð) ðÔ"ØÔ Ø×'Ò'¨Ô(8Ñ9Ô9ðð) ñ) ô) Ñ%ˆ˜ õ ŒJð $ð"¨E¸mÐLÐLñ Mñ ô ˆðˆrtcóh‡—‰j}ˆfd„d„| |¦«D¦«D¦«S)z:Unpack 'schema.table.column'-like strings into components.có:•—g|]}‰ |¦«‘ŒSrn)r…)rpr<r´s €rrr z;IdentifierPreparer.unformat_identifiers..#s7ø€ð ð ð àð ×%Ò% aÑ(Ô(ð ð ð rtcó—g|] \}}|p|‘Œ Srnrn)rpÚaÚbs rrr z;IdentifierPreparer.unformat_identifiers..%s €Ð@Ð@Ð@¡ Aaf˜1Ð@Ð@Ð@rt)r·Úfindall)r´Úidentifiersr¶s` rrÚunformat_identifiersz'IdentifierPreparer.unformat_identifierssRø€ð Ôˆð ð ð ð à@Ð@¨¯ª°;Ñ)?Ô)?Ð@Ñ@Ô@ð ñ ô ð rt)rsNrsTFr»)T)TN)FNNF)'rÝrÞrßràÚRESERVED_WORDSrŒÚLEGAL_CHARACTERSrŽÚILLEGAL_INITIAL_CHARACTERSrrrržr¶r¬rƒr…rÞrŠrðr$rŸrœr§r&rrçrrrr«rŒrÔrFrár?rr·r¿rnrtrrrrrr® s"€€€€€àJÐJà#€Nà'Ðà!;Ðà-˜Ô-¨dÑ3Ô3Ðð ØØØ(,Øð" ð" ð" ð" ðHððð ð ð ðFðFðFðððð$ ð ð ð ð ð ðFðFðFð #"ð#"ð#"ð#"ðJ0ð0ð0ð0ðd"ð"ð"ððððð.ð.ð.ð.ð.ð.ð.ð.ððððð€TÔÐ.Ñ/Ô/ð ð ñ0Ô/ð ð@-ð-ð-ððððð ð ð ðØ ØØð $ð$ð$ð$ðLAðAðAðAð" ÔððñÔðð" ð ð ð ð rtrr)lràrrHrJrÍrrrrrr r rr rr]rÀr¹ÚIrÁÚLEGAL_CHARACTERS_PLUS_SPACEÚrangerfrÂrßráräÚUNICODErËrÊrÚand_Úor_ÚaddÚmulrKÚdivÚmodÚtruedivÚnegÚltÚleÚneÚgtÚgeÚeqÚis_distinct_fromÚisnot_distinct_fromÚ concat_oprcÚnotmatch_opÚin_opÚnotin_opÚcomma_oprŒrŒÚis_ÚisnotrÚexistsÚdistinct_opÚinvÚany_opÚall_opÚdesc_opÚasc_opÚ nullsfirst_opÚnullslast_opr‹r…r$r&r'r(rGrHrŒrr\rhÚcubeÚrollupÚ grouping_setsr(rrêr¡Ú UNION_ALLr¢Ú EXCEPT_ALLr£Ú INTERSECT_ALLrÚobjectr¥Úwith_metaclassÚEnsureKWArgTyperæÚ VisitablerîrRrÿrrr5rìrjrrrnrtrrúrñs$ðððð$ÐÐÐØÐÐÐØ € € € àÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐØÐÐÐÐÐðð_ð_ð_ñaôa€ðF2”:Ð.°´Ñ5Ô5ÐØ(˜bœjÐ):¸B¼DÑAÔAÐØ;Ð;¨e¨e°A°r©l¬lÐ;Ñ;Ô;×AÒAÀ3À%ÑHÔHÐàˆrŒzØ<¸b¼dñô€ðˆrŒzØ<¸b¼dñô€ðˆrŒzÐ5°r´tÑ<Ô<€ØˆbŒjÐAÀ2Ä:ÑNÔN€Ø"”*Ð9¸2¼:ÑFÔF€ð Ø ØØØ ðð€ð) à „NGð) ð„M6ð) ð„M5ð ) ð „M5ð) ð„M5ð ) ð„M5ð) ð„M5ð) ðÔuð) ð„M3ð) ð„L%ð) ð„L&ð) ð„L&ð) ð„L%ð) ð„L&ð) ð „L%ð!) ð"ÔÐ 4ð#) ð$Ô!Ð#;ð%) ð) ð&Ô˜ð') ð(Ô˜ ð)) ð*Ô˜=ð+) ð,„OVð-) ð.Ô˜ ð/) ð0Ô˜ð1) ð2„OXð3) ð4„M6ð5) ð6„M6ð7) ð8„OZð9) ð:Ô{ð;) ð>Ôið?) ð@Ô˜;ðA) ðB„M6ðC) ðDÔfðE) ðFÔfðG) ðJÔwðK) ð) ðLÔfØ Ô˜^Ø Ô˜MðQ) ð) € ðXÔ˜ Ø Ô˜NØ Ô˜NØ ÔÐ!4Ø Ô˜NØ Ô˜Ø ÔÐ.Ø ÔhØ ÔyØ Ô˜NØ „NFØ „NFØ ÔhØ Ô˜_ð € ð$ØØØØØØØØØØ Ø"Ø"Ø$Ø(ðð€ð&ÔÔ# WØÔÔ'¨ØÔÔ$ hØÔÔ(¨,ØÔÔ'¨ØÔÔ+¨_ð ÐðJ=ðJ=ðJ=ðJ=ðJ=ˆvñJ=ôJ=ðJ=ðZ 4ð 4ð 4ð 4ð 4Ð&4Ô& tÔ';¸VÑDÔDñ 4ô 4ð 4ðððððHÔ&ñôðð0ððððdñôðð$w$ ðw$ ðw$ ðw$ ðw$ (ñw$ ôw$ ðw$ ðtI?ð?ð?ð?ð?[ñ?ô?ð?ðDKðKðKðKðK(ñKôKðKð\W(ðW(ðW(ðW(ðW(˜,ñW(ôW(ðW(ðt/ð/ð/ð/ð/Ð,ñ/ô/ð/ðx ðx ðx ðx ðx ˜ñx ôx ðx ðx ðx rt