U d^@s UdZddlmZddlZddlmZddlZddlm Z ddl Z ddl Z ddl Z ddl mZddlZddlmZddlmZddlmZdd lmZdd lmZdd lmZdd lmZdd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z ddlm!Z!ddlm"Z"ddlm#Z#ddl$m%Z%ddl$m&Z&ddl$m'Z'ddl$m(Z(ddl$m)Z)dd l$m*Z*dd!l$m+Z+dd"l$m,Z,dd#l$m-Z-dd$l$m.Z.dd%l$m/Z0dd&l1m2Z2dd'l1m3Z3dd(l%m4Z4dd)l%m5Z5dd*l%m6Z6dd+l%m7Z7dd,l(m8Z8dd-l(m9Z9dd.l,m:Z:dd/l.m;Z;dd0lm?Z?dd2l>m@Z@d3d4l$mAZAd3d%l$m/Z/d3d5lBmCZCd3d6lBmDZDd3d7lBmEZEej"rdd8lFmGZGdd9l%mHZHdd:l%mIZIdd;lJmKZKddlNmPZPdd?lNmQZQdd@l(mRZRddAl(mSZSddBl(mTZTddCl(mUZUddDl(mVZVddEl)mWZWddFl-mXZXddGl-mYZYddHl-mZZZddIl-m[Z[ddJl-m\Z\ddKl-m]Z]ddLl-m^Z^ddMl-m_Z_ddNld>e؃ZGd?d@d@eуZGdAdBdBeӃZGdCdDdDeۃZGdEdFdFeDZGdGdHdHeDZGdIdJdJZdS(Ka]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`. ) annotationsN)IntEnum) perf_counter)Any)Callable)cast)ClassVar)Dict) FrozenSet)Iterable)List)Mapping)MutableMapping) NamedTuple)NoReturn)Optional)Pattern)Sequence)Set)Tuple)Type) TYPE_CHECKING)Union)base) coercions)crud)elements) functions) operators)roles)schema) selectable)sqltypes)utilis_column_element)is_dml) _from_objects) _NONE_NAME) Executable)NO_ARG) ClauseElement) quoted_name)Column) TupleType) TypeEngine)prefix_anon_map) Visitable)exc)Literal)Protocol) TypedDict)_AnnotationDict)_AmbiguousTableNameMap) CompileState)CacheKey)ExecutableDDLElement)Insert) UpdateBase) ValuesBase)_truncated_label) BindParameter) ColumnClause) ColumnElement)Label)Function)AliasedReturnsRows)CompoundSelectState)CTE) FromClause)NamedFromClause) ReturnsRows)Select) SelectState)_BindProcessorType)CursorResultMetaData)_CoreSingleExecuteParams)_ExecuteOptions)_MutableCoreSingleExecuteParams)Dialect)SchemaTranslateMapTyperIallZanalyseZanalyzeandanyarrayasZascZ asymmetric authorizationZbetweenbinaryZbothZcasercheckcollatecolumn constraintcreateZcross current_dateZ current_role current_timecurrent_timestamp current_userdefault deferrabledescZdistinctZdoelseendexceptfalseforZforeignfreezefromfullZgrantgroupZhavingZilikein initiallyinnerZ intersectZintoisZisnulljoinleadingleftlikelimit localtimelocaltimestampZnaturalnewnotZnotnullnulloffoffsetoldononlyororderouteroverlapsZplacingZprimaryZ referencesrightselect session_usersetZsimilarZsome symmetrictableZthentoZtrailingtrueunionuniqueuserZusingverbosewhenwherez ^[A-Z0-9_$]+$z^[A-Z0-9_ $]+$cCsh|] }t|qS)str).0xrr;/tmp/pip-unpacked-wheel-wbr0uges/sqlalchemy/sql/compiler.py sr $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 , z FROM  AS z IS z IS NOT z COLLATE zEXISTS DISTINCT zNOT zANY zALL z DESCz ASCz NULLS FIRSTz NULLS LASTz ^ z | z & ~z << z >> coalesceZ CURRENT_DATEZ CURRENT_TIMEZCURRENT_TIMESTAMPZ CURRENT_USERZ LOCALTIMEZLOCALTIMESTAMPrandomsysdateZ SESSION_USERUSERZCUBEZROLLUPz GROUPING SETSzDict[Type[Function[Any]], str] FUNCTIONSmonthdayyearsecondhourdoyminutequarterdowweekepoch milliseconds microseconds timezone_hourtimezone_minute)rrrrrrrrrrrrrrrUNIONz UNION ALLEXCEPTz EXCEPT ALL INTERSECTz INTERSECT ALLc@s2eZdZUdZded<ded<ded<ded<d S) ResultColumnsEntryaTracks a column expression that is expected to be represented in the result rows for this statement. This normally refers to the columns clause of a SELECT statement but may also refer to a RETURNING clause, as well as for dialect-specific emulations. rkeynamenameTuple[Any, ...]objectsTypeEngine[Any]typeN__name__ __module__ __qualname____doc____annotations__rrrrrQs  rc@s"eZdZddddddddZdS) _ResultMapAppenderrz Sequence[Any]rNonerrrtype_returncCsdSNrselfrrrrrrr__call__qsz_ResultMapAppender.__call__Nrrrrrrrrrpsrz Literal[0]RM_RENDERED_NAMEz Literal[1]RM_NAMEz Literal[2] RM_OBJECTSz Literal[3]RM_TYPEc@s&eZdZUded<ded<ded<dS)_BaseCompilerStackEntryzSet[FromClause] asfrom_fromscorrelate_fromsrKr"Nrrrrrrrrrs rc@s6eZdZUded<ded<ded<ded<ded <d S) _CompilerStackEntryr: compile_stateboolneed_result_map_for_nestedneed_result_map_for_compoundrKselect_0 Select[Any]insert_from_selectNrrrrrrs rF)totalc@s^eZdZUdZded<ded<ded<ded <d ed <ed d ddZedd ddZdS) ExpandedStatearepresents state to use when producing "expanded" and "post compile" bound parameters for a statement. "expanded" parameters are parameters that are generated at statement execution time to suit a number of parameters passed, the most prominent example being the individual elements inside of an IN expression. "post compile" parameters are parameters where the SQL literal value will be rendered into the SQL statement at execution time, rather than being passed as separate parameters to the driver. To create an :class:`.ExpandedState` instance, use the :meth:`.SQLCompiler.construct_expanded_state` method on any :class:`.SQLCompiler` instance. r statementrP parameters%Mapping[str, _BindProcessorType[Any]] processorsOptional[Sequence[str]] positiontupzMapping[str, List[str]]Zparameter_expansionrrcs,jdkrtdtfddjDS)zrTuple of positional parameters, for statements that were compiled using a positional paramstyle. Nz.statement does not use a positional paramstylec3s|]}j|VqdSrrrkeyrrr sz6ExpandedState.positional_parameters..)rr4InvalidRequestErrortuplerrrrpositional_parameterss  z#ExpandedState.positional_parameterscCs|jS)z.synonym for :attr:`.ExpandedState.parameters`.rrrrradditional_parameterssz#ExpandedState.additional_parametersN)rrrrrpropertyrrrrrrrs   rc@s2eZdZUdZded<ded<ded<ded <d S) _InsertManyValueszErepresents state to use for executing an "insertmanyvalues" statementris_default_exprrsingle_values_exprList[crud._CrudParamElementStr]insert_crud_paramsintnum_positional_params_countedNrrrrrrs rc@seZdZdZdZdZdS) CompilerStaterrr3N)rrr COMPILINGSTRING_APPLIED NO_STATEMENTrrrrrsrc@s$eZdZdZdZdZdZeeBZdS)Lintingzrepresent preferences for the 'SQL linting' feature. this feature currently includes support for flagging cartesian products in SQL statements. rrr3N)rrrr NO_LINTINGCOLLECT_CARTESIAN_PRODUCTS WARN_LINTING FROM_LINTINGrrrrrs rc@s"eZdZdZdddZddZdS) FromLinterzKrepresents current state for the "cartesian product" detection feature.Ncs|j}|sdSt|j}t|}|dk r8|}||n|}t|g}|r|r||fdd|D}| fdd|D| |qL|r||fSdSdS)N)NNcsh|]}|kr|qSrrrZedgenoderrrsz"FromLinter.lint..c3s|]}|| VqdSr)indexrrrrr#sz"FromLinter.lint..) fromsredgesremovepop collectionsdequepopleftdiscard extendleftdifference_update)rstartrrthe_rest start_withstackZ to_removerrrlints&     zFromLinter.lintcsV\}}|rR|}|rRd}dfdd|D}|j|j|d}t|dS)NzSELECT statement has a cartesian product between FROM element(s) {froms} and FROM element "{start}". Apply join condition(s) between each element to resolve.rc3s |]}dj|dVqdS)"N)r)rfrom_rrrr:sz"FromLinter.warn..)rr)r rurrr$warn)rrrrtemplateZ froms_strmessagerrrr#,s zFromLinter.warn)N)rrrrr r#rrrrr s %r rrcsPeZdZUdZdZded<dZded<ded <d Zd ZdZ d ed <dZ d ed<dZ ded<e j Zded<ded<e j Zded<dZded<dZded<dZded<ded<dd e fddddd d!d"d#Zd$d%fd&d' Zed(d)Zd*d+Zd,d-Zed.d/Zd0d1dd2d3d4Zdd%d5d6Zd@d8d9dd:d;dd?ZZ S)ACompiledaRepresent 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. NOptional[ClauseElement]rrstringrstateFzOptional[CursorResultMetaData]_cached_metadataz"Optional[List[ResultColumnsEntry]]_result_columns Optional[SchemaTranslateMapType]schema_translate_maprQexecution_optionsIdentifierPreparerpreparerr8 _annotationszOptional[CompileState]rdml_compile_stateOptional[CacheKey] cache_keyfloat _gen_timerSrMapping[str, Any]dialectrr.render_schema_translatecompile_kwargscCs||_|jj|_|r(||_|j||_|dk rtj|_||_|j |_ |j |_ |j rnt rft |tsft|j|_|j|jf||_|r|j|j||_tj|_ntj|_t|_dS)aConstruct a new :class:`.Compiled` object. :param dialect: :class:`.Dialect` to compile against. :param statement: :class:`_expression.ClauseElement` to be compiled. :param schema_translate_map: dictionary of schema names to be translated when forming the resultant SQL .. versionadded:: 1.1 .. seealso:: :ref:`schema_translating` :param compile_kwargs: additional kwargs that will be passed to the initial call to :meth:`.Compiled.process`. N)r:identifier_preparerr1r._with_schema_translaterrr*rZsupports_execution can_executer2r isinstancer*AssertionErrorZ_execution_optionsr/processr)_render_schema_translatesrrrr7rr:rr.r;r<rrr__init__s2  zCompiled.__init__rrcs|tSr)_init_compiler_clssuper__init_subclass__cls __class__rrrHszCompiled.__init_subclass__cCsdSrrrIrrrrFszCompiled._init_compiler_clscCs$|jr||||St|jdSr)r?Z_execute_compiledr4ZObjectNotExecutableErrorr)r connectionZdistilled_paramsr/rrr_execute_on_connectionszCompiled._execute_on_connectioncKst|t||dSrr4UnsupportedCompilationErrorrrelementerrkwrrrvisit_unsupported_compilationsz&Compiled.visit_unsupported_compilationcCs tdS)zReturn a Compiled that is capable of processing SQL expressions. If this compiler is one, it would likely just return 'self'. NNotImplementedErrorrrrr sql_compilerszCompiled.sql_compilerr2r)objkwargsrcKs|j|f|Sr_compiler_dispatch)rrYrZrrrrBszCompiled.processcCs|jtjkr|jSdSdS)z3Return the string text of the generated SQL or DDL.r(N)r*rrr)rrrr__str__s zCompiled.__str__T"Optional[_CoreSingleExecuteParams]&Optional[Sequence[BindParameter[Any]]])Optional[_MutableCoreSingleExecuteParams]paramsextracted_parameters escape_namesrcCs tdS)zReturn 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. NrVrrbrcrdrrrconstruct_paramss zCompiled.construct_paramscCs|S)z0Return the bind params for this compiled object.rfrrrrrb szCompiled.params)NNT)!rrrrrrr)is_sqlis_ddlr+r,r.r$ EMPTY_DICTr/r2rr3r5 immutabledictrErH classmethodrFrNrUrrXrBr]rfrb __classcell__rrrKrr&DsF        :    r&c@sHeZdZdZdZddddZddd d d d Zdd dddddZdS) TypeCompilerz2Produces DDL specification for TypeEngine objects.z visit_\w+rSr:cCs ||_dSrro)rr:rrrrEszTypeCompiler.__init__rrr)rrTrcKs0|jr"|jj|jkr"|j|jj}|j|f|Sr)Z_variant_mappingr:rr\rrrTrrrrBs  zTypeCompiler.process Exceptionr)rRrSrTrcKst|||dSr)r4rPrQrrrrU"sz*TypeCompiler.visit_unsupported_compilationN)rrrrZ ensure_kwargrErBrUrrrrrns rnc@sBeZdZdZdZdZdddZeddZed d Z d d Z d S) _CompileLabelz;lightweight label object which acts as an expression.Label.labelrRr _alt_namesrcCs||_||_|f||_dSrrt)rcolr alt_namesrrrrE3sz_CompileLabel.__init__cCs|jjSrrR proxy_setrrrrry8sz_CompileLabel.proxy_setcCs|jjSrrRrrrrrr<sz_CompileLabel.typecKs|SrrrrTrrr self_group@sz_CompileLabel.self_groupN)r) rrrr__visit_name__ __slots__rErryrr|rrrrrr*s   rrc@sHeZdZdZdZdZddZeddZedd Z d d Z d d Z dS)ilike_case_insensitiveaproduce a wrapping element for a case-insensitive portion of an ILIKE construct. The construct usually renders the ``lower()`` function, but on PostgreSQL will pass silently with the assumption that "ILIKE" is being used. .. versionadded:: 2.0 Zilike_case_insensitive_operandrRZ comparatorcCs||_|j|_dSrr)rrRrrrrEUszilike_case_insensitive.__init__cCs|jjSrrxrrrrryYsz ilike_case_insensitive.proxy_setcCs|jjSrrzrrrrr]szilike_case_insensitive.typecKs|Srrr{rrrr|asz!ilike_case_insensitive.self_groupcCst|j|Sr)rrR_with_binary_element_type)rrrrrrds z0ilike_case_insensitive._with_binary_element_typeN) rrrrr}r~rErryrr|rrrrrrDs   rc @sl eZdZUdZeZedddddddddZde d <d e d <de d <d Z e Z dZ de d<dZde d<dZde d<de d<dZde d<dZde d<dZde d<dZde d<de d<de d <d!e d"<dZde d#<dZde d$<dZde d%<d&e d'<d&e d(<d&e d)<d*e d+<dZde d,<dZde d-<d Zde d.<dZde d/<dZde d0<dZde d1<dZd2e d3<dZd4e d5<dZd6e d7<dZ d8e d9<dZ!d:e d;<e"Z#d<ej%Z&d?e d@<dZ'dZ(dZ)dAe dB<dZ*d6e dC<dZ+d6e dD<dZ,d6e dE<dZ-de dF<dGe dH<dIe dJ<dKe dL<de dM<e./dNZ0e./dOZ1e./e1j2dPe0j2Z3e4dQdRZ5e4dSdTZ6ddde7fdUdVdWdXddYdZd[d\d]Z8e9d4d^d_d`Z:ej;dd^dadbZe9dgdhZ?ej@did^djdkZAejBdld^dmdnZCeDjEdodpZFdqdrZGdsdtZHej@dud^dvdwZIdxdyZJe9dzd{ZKdd|dd}d~ddZLdd|dddddddddZMejBddZNe9ddZOdddd}dddZPeQdddZRde d<ej@dd^ddZSej@eQdddZTej@eQdddZUddZVdddZWddZXdddZYdddZZdddZ[ddZ\ddZ]dddddddZd&dddZ^ddZ_ddZ`ddZaddZbddZcddZddddZedddZfddÄZgddńZhddDŽZiddɄZjdd˄Zkdd̈́ZlddτZmddфZnddӄZoddՄZpddׄZqddلZrddۄZsdd݄Ztdd߄ZuddZvddZwddddZd&dddZxddZyddZzddZ{dddZ|ddZ}ddZ~dddZddZddZddZddZddZddZddZddZdddZdd Zdd d Zd d ZddZddZddZddZdddZddZddZej@ddZddZd d!Zd"d#Zd$d%Zd&d'Zd(d)Zd*d+Zd,d-Zd.d/Zd0d1Zd2d3Zd4d5Zd6d7Zd8d9Zd:d;Zd<d=Zd>d?Zd@dAZdBdCZdDdEZdFdGZdHdIZddJdKZdLdMZedfdNdOZdPdQZdRdSZd&dTd&dUdVdWZd&d&dXdYdZZdd&ddd4d[d\d6dZd&d] d^d_Zd`daZdddddedfdbdddcdddedfdZd4dg dhdiZdjdkZdldmZddndoZdpdqZdrdsZddtduZdvdwZddxdyZdzd{Zd|d}Zd&d&dd~ddddZdddZdddZÐddZĐddZŐddZƐddZǐddZȐde d<ejʐ sede"fde"fgZːdddZdZdZe d<dddZΐdddddZϐddZАddZѐddZҐdddZӐddZԐddZՐddZ֐ddZאddZؐddddZd&dddZِddZڐdddZېdddZܐdddZݐddZސddZߐddÄZddĐdńZdƐdDŽZdȐdɄZdʐd˄Zd̐d̈́ZdΐdτZdАdфZdҐdӄZdԐdՄZd֐dׄZdؐdلZdS( SQLCompilerz~Default implementation of :class:`.Compiled`. Compiles :class:`_expression.ClauseElement` objects into SQL strings. PAZC_)%():.[] zClassVar[Mapping[str, str]]bindname_escape_characterszClassVar[Pattern[str]]_bind_translate_re_bind_translate_charsTFrisdeleteisinsertisupdatezOptional[List[Column[Any]]]Z postfetchrzSequence[Column[Any]]insert_prefetchupdate_prefetchNz&Optional[Sequence[ColumnElement[Any]]]implicit_returning isplaintextzDict[str, BindParameter[Any]]bindszDict[BindParameter[Any], str] bind_nameszList[_CompilerStackEntry]rreturning_precedes_values'render_table_with_column_in_update_fromansi_bind_rulesr bindtemplatecompilation_bindtemplate_numeric_binds_identifier_charzList[ResultColumnsEntry]r,_textual_ordered_columns_ad_hoc_textual_ordered_columns_loose_column_name_matching_numeric_binds_render_postcompilezOptional[ExpandedState]_post_compile_expanded_state Optional[str]_pre_expanded_stringzOptional[List[str]]_pre_expanded_positiontupzOptional[_InsertManyValues]_insertmanyvaluesz!Optional[crud._CrudParamSequence]_insert_crud_paramszFrozenSet[BindParameter[Any]]literal_execute_paramspost_compile_paramszutil.immutabledict[str, str]escaped_bind_nameszbOptional[Tuple[Dict[BindParameter[Any], List[BindParameter[Any]]], Dict[str, BindParameter[Any]]]]_cache_key_bind_matchr_values_bindparam_visited_bindparaminlinez"Optional[MutableMapping[CTE, str]]cteszDict[Tuple[int, str], CTE]ctes_by_level_namez/Dict[CTE, Tuple[int, str, selectable._CTEOpts]]level_name_by_ctectes_recursivez"__\[POSTCOMPILE_(\S+?)(~~.+?~~)?\]z%\(([^)]+?)\)s|cCs |dSr)_init_bind_translaterIrrrrFszSQLCompiler._init_compiler_clscCs2td|j}td|d|_|j|_dS)Nr(rr)reescaperurcompilerr)rJregrrrrsz SQLCompiler._init_bind_translaterSr'r4rrr)r:rr5 column_keysfor_executemanylintingrZc Ks||_||_|r>dd|dD}dd|dD} | |f|_||_||_i|_t|_g|_ g|_ |j |_ |j r|j d|_} | r|j dkrdnd|_t|_n t|j |_d |_|jp|j|_t|_i|_i|_tj|||f||js|js|jrxtrt |t!st"|js*|jrxtr@t |t#s@t"|j$rPd |_%n(|jrx|jrr|j&j'rx|j(rxd |_%t|j |_)|j*t+j,kr|j r|jr|-n|.|j/r|j0d d d } |j1| d d d S)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 for_executemany: whether INSERT / UPDATE statements should expect that they are to be invoked in an "executemany" style, which may impact how the statement will be expected to return the values of defaults and autoincrement / sequences and similar. Depending on the backend and driver in use, support for retrieving these values may be disabled which means SQL expressions may be rendered inline, RETURNING may not be rendered, etc. :param kwargs: additional keyword arguments to be consumed by the superclass. cSsi|] }|j|qSrrrbrrr sz(SQLCompiler.__init__..rcSsi|] }||gqSrrrrrrrsrrrrNTFrd_no_postcompile)_populate_self)2rr5rrrrr$Z column_dictrrr, positional paramstyle startswithrr_pyformat_templaterBIND_TEMPLATESr label_lengthmax_identifier_lengthr1anon_maptruncated_names_truncated_countersr&rErrrrr@r>rAr?Z_inlinerr:Zinsert_executemany_returningZ_return_defaultsrr*rr_process_numeric_process_positionalrrf#_process_parameters_for_postcompile) rr:rr5rrrrZcksmckbmnbrrrrrEst      zSQLCompiler.__init__rcCs|jdkrdS|jjSdS)aWhen an INSERT is compiled with a single set of parameters inside a VALUES expression, the string is assigned here, where it can be used for insert batching schemes to rewrite the VALUES expression. .. versionadded:: 1.3.8 .. versionchanged:: 2.0 This collection is no longer used by SQLAlchemy's built-in dialects, in favor of the currently internal ``_insertmanyvalues`` collection that is used only by :class:`.SQLCompiler`. N)rrrrrrinsert_single_values_exprs z%SQLCompiler.insert_single_values_exprcCs:|jr |jS|jdk r2t|jr2dd|jjDSdSdS)aThe effective "returning" columns for INSERT, UPDATE or DELETE. This is either the so-called "implicit returning" columns which are calculated by the compiler on the fly, or those present based on what's present in ``self.statement._returning`` (expanded into individual columns using the ``._all_selected_columns`` attribute) i.e. those set explicitly using the :meth:`.UpdateBase.returning` method. .. versionadded:: 2.0 NcSsg|]}t|r|qSrr%rcrrr ?sz3SQLCompiler.effective_returning..)rrr'_all_selected_columnsrrrreffective_returning/s zSQLCompiler.effective_returningcCs|jS)zVbackwards compatibility; returns the effective_returning collection. )rrrrr returningHszSQLCompiler.returningc CsBz|jddWStk r<}ztd|W5d}~XYnXdS)aReturn 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 entryN)r IndexError)rZierrrcurrent_executablePszSQLCompiler.current_executablecCst|jt|jSr)listrrrrrrprefetchsszSQLCompiler.prefetchzDict[Any, Any]cCsiSrrrrrr_global_attributeswszSQLCompiler._global_attributeszMutableMapping[CTE, str]cCs$t}||_i|_i|_d|_|S)zInitialize collections related to CTEs only if a CTE is located, to save on the overhead of these collections otherwise. F)r$ OrderedDictrrrr)rrrrr_init_cte_state{s zSQLCompiler._init_cte_statec csp|j|j}}gd|_|_z0|jr8|jd}d|d<nd}|j|jfVW5|r\|d|||_|_XdS)z;special API to support the use case of 'nested result sets'FrrTN)r,rrr)rZresult_columnsZordered_columnsentryrrr_nested_results   zSQLCompiler._nested_resultcsjr tjtjkstjr$tjjdkr6dnjjdksFtdgdddfdd t j j _ j rd d j Dtj tkstfd d D_n_jrgt j jj}fdd jjD}tjj||jjd_dS)Nr%srrz re.Match[str]r)mrcs:|d}|r|S|d|dSdS)Nrr3r)rpappend)rZ normal_bind) placeholder positionsrr find_positions   z6SQLCompiler._process_positional..find_positioncSsi|]\}}||qSrr)rkvrrrrsz3SQLCompiler._process_positional..csg|]}||qSrgetrr)reverse_escaperrrsz3SQLCompiler._process_positional..c s4g|],}|d|dtj|d|dfqS)rrr3r)rsub_positional_patternrr)rrrrrs rrrr)rrAr*rrrr:rrrrr)ritemslenrrrrrr)rrrr)rrrrrrrsJ        zSQLCompiler._process_positionalc sdjs tjtjkstd}ijrZjdk rZtfddj Dj }n j }|D]T}|krvqhj |}|j ks|j krd|<qhj|}|d7}||<qh|_t_jrt}fddDt|kstjfddj_jr`jj}dd jjD}tjj||jjd _dS) Nrc3s|]}|jkr|VqdSr)rrrrrrs z/SQLCompiler._process_numeric..cs i|]\}}j|||qSr)rr)rrposrrrrs z0SQLCompiler._process_numeric..cs|dSNrrpr param_posrrz.SQLCompiler._process_numeric..cSs$g|]}|d|dd|dfqS)rrrrrrrrrr&sz0SQLCompiler._process_numeric..r)rrAr*rrrr itertoolschainrvaluesrrrrnext_numeric_posrrrrr_pyformat_patternrr)rrrrr) rnumr bind_namebindphZ len_beforerrr)rrrrsd         zSQLCompiler._process_numericzVMutableMapping[str, Union[_BindProcessorType[Any], Sequence[_BindProcessorType[Any]]]]csddfddjDDS)NcSsi|]\}}|dk r||qSrrrrvaluerrrr?s z0SQLCompiler._bind_processors..c3sN|]F}j||jjs$|jjntfddtt|jjDfVqdS)c3s|]}|jVqdSr)_cached_bind_processorr:)rZ elem_typerrrrFsz9SQLCompiler._bind_processors...N) rr_is_tuple_typerr:rrr/types)r bindparamrrrrAs   z/SQLCompiler._bind_processors..)rrrrr_bind_processors6s  zSQLCompiler._bind_processorscCst|jdkSr)rrrrrr is_subqueryPszSQLCompiler.is_subquerycCs|SrrrrrrrXSszSQLCompiler.sql_compilerr^r)rbrdrcCs|j||dd}||S)aRReturn a new :class:`.ExpandedState` for a given parameter set. For queries that use "expanding" or other late-rendered parameters, this method will provide for both the finalized SQL string as well as the parameters that would be used for a particular parameter set. .. versionadded:: 2.0.0rc1 Tr)rfr)rrbrdrrrrconstruct_expanded_stateWsz$SQLCompiler.construct_expanded_stater_z Optional[int]rR)rbrcrd _group_number_checkrrcs2|jr2|s2|jdk st|s(t|jjStd|o>t|j}|r|j dkrZt dn |j d}|j } | dk svt| \} fddt ||D} nd} |ri} |j D]\} }|r|j||n|}| j|kr|| j| |<q||kr||| |<q|rD| jrD|r.tjd| j|fdd ntjd | jdd q| rX| | | }n| }| jrp|j| |<q|j| |<q| Si} |j D]\} }|r|j||n|}|r| jr|rtjd| j|fdd ntjd | jdd | r| | | }n| }| jr|j| |<n |j| |<q| SdS) z5return a dictionary of bind parameter keys and valuesNzcan't construct new parameters when render_postcompile is used; the statement is hard-linked to the original parameters. Use construct_expanded_state to generate a new statement and parameters.zcThis compiled object has no original cache key; can't pass extracted_parameters to construct_paramsrcs$i|]\}}|D] }||qqSrr)rrZ extractedr rrrrs  z0SQLCompiler.construct_params..z@A value is required for bind parameter %r, in parameter group %dZcd3x)codez)A value is required for bind parameter %r)rrrAdictrr4rrrr5 CompileErrorrziprrrrrequiredcallableeffective_valuer)rrbrcrdrrrZhas_escaped_namesZorig_extracted ckbm_tuplerZresolved_extractedpdrr escaped_nameZ value_paramrrrrfns           zSQLCompiler.construct_paramscs|jjjjfddi}|j}|jD]F}||krHq:|jjrrfddtt |jj D||<q:|j||<q:|S)NcsD|}|dk r<dks(|kr<dks8|kr<|SdSdSr)_unwrapped_dialect_implZget_dbapi_type)typZdbtype)dbapir: exclude_types include_typesrr lookup_typesz.lookup_typecsg|] }|qSrr)rr$)r(rrrsz;SQLCompiler._get_set_input_sizes_lookup..) r:Zinclude_set_input_sizesZexclude_set_input_sizesr%rrrrrr/r)rZ inputsizesrrr)r%r:r&r'r(r_get_set_input_sizes_lookups     z'SQLCompiler._get_set_input_sizes_lookupcCs |jddS)zReturn the bind param dictionary embedded into this compiled object, for those values that are present. .. seealso:: :ref:`faq_sql_expression_string` - includes a usage example for debugging use cases. F)rrgrrrrrbs zSQLCompiler.params)rrrcsi}j}|dkrj}jr8g}j}|dkr@j}nd}}j}td|td|i}ii} d} jr|dk r|} jrg} n j } j } | D]p| r| n} j }|j kr| kr|| }j||d| <q|jkr| kr| | }d}n0|}| ||}|\}}|| | <|| <|js|||jjr|dk snt|fddt|dDn|fdd|D| dk r| d d|Dn|dk r|d d|Dd d |D|<q|dk r|qfd d}tj||}| dk r~|dk sDtfddt| jDjfdd|}|| t|||||}|r|_|_|j _jrt!|jpdnd_|_"|S)ahandle special post compile parameters. These include: * "expanding" parameters -typically IN tuples that are rendered on a per-parameter basis for an otherwise fixed SQL statement string. * literal_binds compiled with the literal_execute flag. Used for things like SQL Server "TOP N" where the driver does not accommodate N as a bound parameter. Nrz/Mapping[str, Sequence[_BindProcessorType[Any]]]render_literal_valuec3s`|]X\}}t|dD]D\}}kr|ddk rd||f|dfVqqdS)rN%s_%s_%s enumerate)ri tuple_elementjr)rtuple_processorsrrrs  zBSQLCompiler._process_parameters_for_postcompile..rc3s&|]\}}kr|fVqdSrr)rrr)rsingle_processorsrrrscss|]\}}|VqdSrrrrrrrrrscss|]\}}|VqdSrrr4rrrrscSsg|] \}}|qSrr)rZ expand_keyrrrrrszCSQLCompiler._process_parameters_for_postcompile..csb|d}|}|dr^|dd}|d|ddfdd|dD}|S)Nrr3~~rrc3s|]}d|fVqdSz%s%s%sNr)rexpbe_leftbe_rightrrrsz]SQLCompiler._process_parameters_for_postcompile..process_expanding..)rpsplitru)rrexprtok)replacement_expressionsr8rprocess_expandings  zJSQLCompiler._process_parameters_for_postcompile..process_expandingcs i|]\}}|j|qSrr)rr rrrrrszCSQLCompiler._process_parameters_for_postcompile..cs|dSrrrrrrrrzASQLCompiler._process_parameters_for_postcompile..r)#rr)rrrrrrrrrrrrrrender_literal_bindparamr$_literal_execute_expanding_parameterliteral_executeupdaterrrAr.extendrrr_post_compile_patternrrrrrr)rrrZexpanded_parametersZpre_expanded_stringZnew_positiontupZpre_expanded_positiontuprZnew_processorsZto_update_setsZnumeric_positiontupnamesZebnr" parameterr to_updaterZleep_resreplacement_exprr?rZexpanded_stater)rrr>rr3r2rr$s                       z/SQLCompiler._process_parameters_for_postcompilezsqlalchemy.engine.cursorcCstjj}|j|jS)z(utility method used for unit tests only.)r$ preloadedZ engine_cursorrOZ_create_description_match_mapr,)rcursorrrr_create_result_mapszSQLCompiler._create_result_map_BindNameForColProtocol_get_bind_name_for_colzCallable[[Any], str]cCs |j}|Sr)rO)rgetterrrr_within_exec_param_key_gettersz)SQLCompiler._within_exec_param_key_getterzsqlalchemy.engine.resultcstjj}|j|jdk st|jj}tr6t|t s6t|j }fdd|j Dd|j dk rj |jd|jkrfdd}|nd|dd|j Dfdd}|S)Ncs"g|]}td|d|fqS)rN)operator methodcallerrrv)param_key_getterrrr szKSQLCompiler._inserted_primary_key_from_lastrowid_getter..cs ||}|dk r|S|SdSrr) lastrowidrZ param_value) autoinc_keyrr_autoinc_getters zPSQLCompiler._inserted_primary_key_from_lastrowid_getter.._autoinc_gettercSsg|] }|jqSrrrTrrrr1scsNdk rdkr.fddDSfddDSdS)agiven cursor.lastrowid value and the parameters used for INSERT, return a "row" that represents the primary key, either by using the "lastrowid" or by extracting values from the parameters that were sent along with the INSERT. Nc3s|]\}}|VqdSrrrrPrvrrrr>szWSQLCompiler._inserted_primary_key_from_lastrowid_getter..get..c3s8|]0\}}|kr(dk r$q.n|VqdSrrrY) autoinc_colautoinc_getterrVrrrr@s rrVr)rZr[getterslastrowid_processorrow_fnr\rr3szDSQLCompiler._inserted_primary_key_from_lastrowid_getter..get)r$rK engine_resultrQrrArrr@r=r primary_keyZ_autoincrement_columnrZ_cached_result_processorr:r result_tuple)rresultrrrXrr)rZr[rWr]r^rUr_r+_inserted_primary_key_from_lastrowid_getters2   z7SQLCompiler._inserted_primary_key_from_lastrowid_gettercstjrddlm}ntjj}|jdk s*t|jj }trDt |t sDt|j |j }|j}|dk sbtddt|Dtdfdd|jD|dd|jDfd d }|S) Nr3)rccSsi|]\}}||qSrr)ridxrvrrrr`szKSQLCompiler._inserted_primary_key_from_returning_getter..z'List[Tuple[Callable[[Any], Any], bool]]cs<g|]4}|kr"t|dfntd|ddfqS)TrNF)rR itemgetterrSrT)rUretrrrds zKSQLCompiler._inserted_primary_key_from_returning_getter..cSsg|] }|jqSrrrTrrrroscsfddDS)Nc3s&|]\}}|r|n|VqdSrr)rrPZuse_rowrrowrrrrszWSQLCompiler._inserted_primary_key_from_returning_getter..get..r)rir)r]r_rhrrqszDSQLCompiler._inserted_primary_key_from_returning_getter..get)typingrZenginercr$rKr`rrArr@r=rQrrr.rrarb)rrcrrrrr)r]rUrgr_r+_inserted_primary_key_from_returning_getterMs*   z7SQLCompiler._inserted_primary_key_from_returning_gettercCsdS)zCalled 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(rrrrr default_fromyszSQLCompiler.default_fromcKsd|jj|f|dSNrrrRr\)rgroupingasfromrZrrrvisit_groupingszSQLCompiler.visit_groupingcKsd|jj|f|dSrmrn)rrorZrrrvisit_select_statement_groupingsz+SQLCompiler.visit_select_statement_groupingc Ks|jr|jjrztd|jdd}Wn.tk rT}ztd|W5d}~XYnX|j\}}}|rl|} n|} |jj } | dk r| j | kr| | | j r|jj |d<|j |jfd|i|S)N'Union[SelectState, CompoundSelectState]rrECan't resolve label reference for ORDER BY / GROUP BY / DISTINCT etc.render_label_as_labelwithin_columns_clause) rr:Zsupports_simple_order_by_labelrKeyErrorr4r_label_resolve_dictrRZ_order_by_label_elementrZshares_lineagerB) rrRrvrZrke with_cols only_froms only_colsZ resolve_dictZ order_by_elemrrrvisit_label_referencesP   z!SQLCompiler.visit_label_referencec Ks|js||jSztd|jdd}Wn8tk rb}ztj|jdtj |dW5d}~XYnX|j \}}}z|r||j} n ||j} Wn8tk r} ztj|jdtj | dW5d} ~ XYn X| |d<|j| fd|i|SdS)Nrsrrrt)extraZexc_clsrSrurv) rrBZ _text_clauserrwrZ_no_text_coercionrRr4rrx) rrRrvrZrryrzr{r|rvrSrrrvisit_textual_label_referencesD     z)SQLCompiler.visit_textual_label_referencec Ks|o| }||k} | s|r>t|jtjr8|d|j} n|j} |r|dk rj|| |j|| f|j||j|jj|fddd|t t j |j || S| r|j || S|jj|fddi|SdS)NcolidentT)rvwithin_label_clauservF)r@rrr@_truncated_identifierrurrRr\ OPERATORSras_r1 format_label) rrsadd_to_result_maprrvruresult_map_targetsrTZrender_label_with_asZrender_label_onlyZ labelnamerrr visit_labelsJ  zSQLCompiler.visit_labelcCstddS)Nz:Cannot compile Column object until its 'name' is assigned.r4rrr^rrr_fallback_column_name sz!SQLCompiler._fallback_column_namecKs|j}|j|f|Sr)Z _resolvedrB)rrRrTZ sql_elementrrrvisit_lambda_element sz SQLCompiler.visit_lambda_elementColumnClause[Any]zOptional[_ResultMapAppender]rz Optional[_AmbiguousTableNameMap])r^r include_tablerambiguous_table_name_maprZrcKsB|j}}|dkr||}|j} | s>t|tjr>|d|}|dk rx|||jf|} |jrh| |jf7} |||| |j | r| |}n |j |}|j } | dks|r| js|S|j | } | r|j | d} nd} trt| tst| j}| s |r ||kr ||}t|tjr&|d|}| |j |d|SdS)Nrrr(alias)rr is_literalr@rr@rr _tq_labelrescape_literal_columnr1quoterZnamed_with_columnschema_for_object quote_schemarrJrA)rr^rrrrrZr orig_namertargetsreffective_schemaZ schema_prefixZ tablenamerrr visit_column sF        zSQLCompiler.visit_columncKs|j|jSr)r1format_collation collationrrRrTrrrvisit_collationY szSQLCompiler.visit_collationcKs|jSrr)rZ fromclauserZrrrvisit_fromclause\ szSQLCompiler.visit_fromclausecKs|jSrr)rrrZrrr visit_index_ szSQLCompiler.visit_indexcKs&||d<|j|d<|jjj|jf|S)Ntype_expressionr=)r1r:type_compiler_instancerBr)r typeclauserTrrrvisit_typeclauseb s zSQLCompiler.visit_typeclausecCs|jjr|dd}|SNr%%r1_double_percentsreplacertextrrrpost_process_texti s zSQLCompiler.post_process_textcCs|jjr|dd}|Srrrrrrrn s z!SQLCompiler.escape_literal_columnc sRfdd}jsd_|r2|ddftjtddt|jS)Ncs:|d}|jkr(jj|fSj|fSdSr)rpZ _bindparamsrBbindparam_string)rrrTr textclauserr do_bindparamt s  z2SQLCompiler.visit_textclause..do_bindparamTcSs |dSrrrrrrr rz.SQLCompiler.visit_textclause..) rrr#NULLTYPEBIND_PARAMS_ESCr BIND_PARAMSrr)rrrrTrrrrvisit_textclauses s zSQLCompiler.visit_textclausec Ks|j }|r|jn|jd}tt|d}|j||jrJ||||pl|dkrb|ddpl|dd}|r|j|_|_ |j ot |j |_ |j D]} |j | d|jdq|j |jf|} |jr|st|jnd} |j| d | } |jd| S) Nrrrr"rrFrT)rvr nesting_level)r_default_stack_entryrr_independent_ctes_dispatch_independent_ctesrrrrrZ column_argsrrB_add_to_result_maprRrr_render_cte_clauser) rZtafcompound_indexrprTtoplevelr new_entrypopulate_result_maprrrrrrvisit_textual_select sD        z SQLCompiler.visit_textual_selectcKsdSNNULLrrr<rTrrr visit_null szSQLCompiler.visit_nullcKs|jjr dSdSdS)Nr1r:supports_native_booleanrrrr visit_true szSQLCompiler.visit_truecKs|jjr dSdSdS)Nrk0rrrrr visit_false szSQLCompiler.visit_falsec s$|ddfdd|DDS)Ncss|]}|r|VqdSrrrsrrrr sz7SQLCompiler._generate_delimited_list..c3s|]}|jfVqdSrr[rrTrrrr sru)rr separatorrTrrr_generate_delimited_list s z$SQLCompiler._generate_delimited_listc sltjtjtjjtjj|\}}|dkr:|djfSt tj}| ddfdd|DDSdS)Nrrcss|]}|r|VqdSrrrrrrr sz;SQLCompiler._generate_delimited_and_list..c3s|]}|jfVqdSrr[rrrrr s) rZBooleanClauseListZ_process_clauses_for_booleanrand_ZTrue_Z _singletonZFalse_r\rru)rclausesrTZlccrrrr_generate_delimited_and_list s  z(SQLCompiler._generate_delimited_and_listcKsd|j|f|SN(%s))visit_clauselist)r clauselistrTrrr visit_tuple szSQLCompiler.visit_tuplecKs0|j}|dkrd}n t|j}|j|j|f|SNr)rRrrr)rrrTseprrrr s  zSQLCompiler.visit_clauselistc Ksz|j}||dd}|r&|||f|Sz t|}Wn0tk rb}zt|||W5d}~XYnX|j|j|f|SdS)NZexpression_clauselist)rR_get_operator_dispatchrrwr4rPrr)rrrT operator_dispopstringrSrrrvisit_expression_clauselist s$  z'SQLCompiler.visit_expression_clauselistcKsd}|jdk r&||jj|f|d7}|jD]4\}}|d|j|f|d|j|f|d7}q,|jdk r|d|jj|f|d7}|d7}|S)NzCASE rzWHEN z THEN zELSE ZEND)rr\ZwhensZelse_)rclauserZrZcondrcrrr visit_case s*    zSQLCompiler.visit_casecKs|jj|f|Sr)Ztyped_expressionr\)rZ type_coercerTrrrvisit_type_coerce szSQLCompiler.visit_type_coercecKs$d|jj|f||jj|f|fS)NzCAST(%s AS %s))rr\r)rrrZrrr visit_cast szSQLCompiler.visit_castc Ksd|dtjkrdn\|dtjkr&dnJ|ddkrTd|jtt|df|fnd|jt|df|f|dtjkrdn\|dtjkrdnJ|ddkrd|jtt|df|fnd|jt|df|ffS) Nz %s AND %srzUNBOUNDED PRECEDINGz CURRENT ROWz %s PRECEDINGz %s FOLLOWINGrzUNBOUNDED FOLLOWING)rZRANGE_UNBOUNDEDZ RANGE_CURRENTrBliteralabs)rrange_rTrrr_format_frame_clause# s0      z SQLCompiler._format_frame_clausec s|jjf}|jr,dj|jf}n |jrHdj|jf}nd}d|dfddd|jfd|jffD|r|gngfS) NzRANGE BETWEEN %szROWS BETWEEN %sz %s OVER (%s)rcs6g|].\}}|dk rt|rd||jffqS)Nz%s BY %s)rr\)rwordrrZrrrrJ s z*SQLCompiler.visit_over..Z PARTITIONORDER)rRr\rrZrowsruZ partition_byorder_by)rZoverrZrrrrr visit_over: s4  zSQLCompiler.visit_overcKs$d|jj|f||jj|f|fS)Nz%s WITHIN GROUP (ORDER BY %s))rRr\r)rZ withingrouprZrrrvisit_withingroupW szSQLCompiler.visit_withingroupcKs$d|jj|f||jj|f|fS)Nz%s FILTER (WHERE %s))funcr\Z criterion)rZ funcfilterrZrrrvisit_funcfilter] szSQLCompiler.visit_funcfiltercKs*|j|j|j}d||jj|f|fS)NzEXTRACT(%s FROM %s)) extract_maprfieldr<r\)rextractrZrrrr visit_extractc s zSQLCompiler.visit_extractcKs*|j|jf|}|j|f|}d||fS)Nz(%s).%s)visit_functionfnr)rrRrTZ compiled_fnZ compiled_colrrrvisit_scalar_function_columnj sz(SQLCompiler.visit_scalar_function_columnz Function[Any])rrrZrc s|dk r||j|jd|jtd|jd}|rD||f|}nt|jdrj|jrd7n6|jj st t j rj nddfdd|jDgdj|f|i}|jr|d7}|S) Nrz visit_%s_funcz%(expr)srcs4g|],}j|s ttjr,j|n|qSr)r1_requires_quotes_illegal_charsr@rr-r)rr=rrrrr s   z.SQLCompiler.visit_function..r<z WITH ORDINALITY)rrgetattrlowerrrZ _deannotaterLZ _has_argsr1rr@rr-rruZ packagenamesfunction_argspecZ_with_ordinality)rrrrZrrrrrro s:       zSQLCompiler.visit_functioncKs ||jSr)visit_sequencesequence)rZ next_valuerTrrrvisit_next_value_func sz!SQLCompiler.visit_next_value_funccKstd|jjdS)Nz2Dialect '%s' does not support sequence increments.rWr:r)rrrTrrrr s zSQLCompiler.visit_sequencecKs|jj|f|Sr)Z clause_exprr\)rrrZrrrr szSQLCompiler.function_argspecc  sbj }|j|f}|r(js(|_|j}|r8jnjd}|pV| oV|dd} |dkrh||d<j|d|d||| d|jr|j |j } d | d  fd d t |j D} dd <| j|ftfd i7} | j|f7} |jr$| j|f7} jrR|s.rrpTrinclude_following_stack)r_compile_state_factoryrrrrrrrcompound_keywordskeywordrur.Zselectsgroup_by_clauserorder_by_clause_has_row_limiting_clause_row_limit_clauserrrr) rcsrprrZrrZ compound_stmtrZneed_result_maprrrrrrvisit_compound_select sX         z!SQLCompiler.visit_compound_selectcKs*|jdk r|j|f|S|j|f|SdSr) _fetch_clause fetch_clause limit_clause)rr rZrrrr  s zSQLCompiler._row_limit_clausecCs(d|j||rd|ndf}t||dS)Nz visit_%s_%s%srr()rr)rrZ qualifier1Z qualifier2attrnamerrrr s z"SQLCompiler._get_operator_dispatchcKs|dk r"||f7}||d<||d<|jrt|jr8td||jdd}|r\|||jf|S|j|t|jf|SnL|jr||jdd}|r|||jf|S|j|t|jf|Sn tddS)NrrzFUnary expression does not support operator and modifier simultaneouslyunaryrRmodifierz,Unary expression has no operator or modifier)rRrr4rr _generate_generic_unary_operatorr _generate_generic_unary_modifier)rrrrrTrrrr visit_unary sN zSQLCompiler.visit_unarycKsx|jjrP|j|jf|d|jt|j|jjjt j kr>|jjnt f|S|j|jf|d|j|jf|SdS)N / ) r:div_is_floordivrBrwrZCastrr_type_affinityr#ZNumericrr[rRrTrrrvisit_truediv_binary s, z SQLCompiler.visit_truediv_binarycKsh|jjr<|jjjtjkr<|j|jf|d|j|jf|Sd|j|jf|d|j|jf|SdS)Nrz FLOOR(%s)) r:rrrrr#ZIntegerrBrwrrrrvisit_floordiv_binary7 s"z!SQLCompiler.visit_floordiv_binarycKs6|js|jjr|j|jf|Sd|j|jf|SdS)Nz%s = 1Z_is_implicitly_booleanr:rrBrRrrRrRrTrrrvisit_is_true_unary_operatorH s z(SQLCompiler.visit_is_true_unary_operatorcKs:|js|jjr"d|j|jf|Sd|j|jf|SdS)NNOT %sz%s = 0rrrrrvisit_is_false_unary_operatorQ s z)SQLCompiler.visit_is_false_unary_operatorcKsd|j|tjdS)Nr )override_operator) visit_binaryrmatch_oprrrrvisit_not_match_op_binaryZ sz%SQLCompiler.visit_not_match_op_binarycKsd|j|t|f|Sr)_generate_generic_binaryrrrrrvisit_not_in_op_binary_ s z"SQLCompiler.visit_not_in_op_binarycKsv|tjkr4t|dkr.dddd|DSdSn>|tjkrht|dkrbdddd|DSd Sn ||SdS) Nrz(%s)) OR (1 = 1rcss|] }dVqdSrNrrrRrrrrk sz6SQLCompiler.visit_empty_set_op_expr..zNULL) OR (1 = 1z(%s)) AND (1 != 1css|] }dVqdSr(rr)rrrrr szNULL) AND (1 != 1)r not_in_oprruin_opvisit_empty_set_expr)rr expand_oprTrrrvisit_empty_set_op_exprg s    z#SQLCompiler.visit_empty_set_op_exprcKstd|jjdS)Nz3Dialect '%s' does not support empty set expression.r)rZ element_typesrTrrrr,y s z SQLCompiler.visit_empty_set_exprc sLjj}|sP|jr<jjr$dndjjj}njgj}n|js~|jrt |dt j rt |dt t fs|jrtdjjrdnddfddt|D}n|r*j}||}|r|dstd |dd }|d |d dfd d|D}ndfdd|D}d|fS)NVALUES r(rz?bind_expression() on TupleType not supported with literal_bindsrc3s8|]0\}}ddfddt|jjDVqdS)rrc3s|]\}}||VqdSrr*)rrZ param_typerrrr sz[SQLCompiler._literal_execute_expanding_parameter_literal_binds...N)rurrr)rr/r0rHrrrr s zQSQLCompiler._literal_execute_expanding_parameter_literal_binds..r3)unexpected format for expanding parameterr5rrc3s&|]}d|jfVqdSr6r+rrrr9r:rHrrrr s c3s|]}|jVqdSrr2r3r0rrr sr)rr#r:rtuple_in_valuesr.rr-_isnullr@collections_abcrrbytes_has_bind_expressionrWrur.rFsearchrprAr;) rrHrbind_expression_templatetyp_dialect_implreplacement_expressionZpost_compile_patternrr=rr4r2_literal_execute_expanding_parameter_literal_binds s\   z>SQLCompiler._literal_execute_expanding_parameter_literal_bindscsXjr|Sj}j|jr2jnjjjrZj rZfddn fdd|sgj r jj j }n jgj }nj sЈjr t|dtjr t|dttfs jrtfddt|dD|jrdnd d fd d t|D}n0fd dt|dDd fdd D}|fS)Ncsjd|iSNr)render_bind_castrr) bind_templaterHrr<rr_render_bindtemplate s  zNSQLCompiler._literal_execute_expanding_parameter.._render_bindtemplatecs d|iSr?rr)rArrrB srcs6g|].\}}t|dD]\}}d||f|fqqS)rr,r-)rr/r0r1rrrrr s zDSQLCompiler._literal_execute_expanding_parameter..rr/r(rc3s8|]0\ddfddtDVqdS)rrc3s.|]&\}}t|dVqdS)rN)r)rr1r)rBr/rIr0rrr szMSQLCompiler._literal_execute_expanding_parameter...N)rur.)r)rBrI)r/r0rr s  zCSQLCompiler._literal_execute_expanding_parameter..cs g|]\}}d|f|fqS)z%s_%sr)rr/rrrrr sc3s|]\}}|VqdSrrr )rBrrr s)rCr>r:rr#rrr_bind_typing_render_castsr@rr.rr-r6r@r7rrr8Z _is_arrayrAr.r5ru)rrrHrr:r=r)rBrArrHrrIr<rrB sd       z0SQLCompiler._literal_execute_expanding_parameterc Ks|rft|jrf|dk rJ|d}|jt|jj|g|j j|gn|jt|jj|j j|j rt |jt j rt |j t j rd|d<|p|j}||dd} | r| ||f|Sz t|} Wn0tk r} zt||| W5d} ~ XYnX|j|| f||d|SdS)Nenclosing_lateralTrCr[) from_linterlateral_from_linter)rZ is_comparisonrRrrDrproductrwr(rrr@rrArrrwr4rPr&) rr[r"eager_groupingrErFrTrDrrrrSrrrr# sN        zSQLCompiler.visit_binarycKs|j|jf|Sr)rBZ sql_functionrrrr&visit_function_as_comparison_op_binaryO sz2SQLCompiler.visit_function_as_comparison_op_binarycKsT|jjr,|j|jf|d|j|jf|S|j|jf|d|j|jf|SdS)Nz %% r)r1rrBrwrrrrrvisit_mod_binaryR szSQLCompiler.visit_mod_binarycKs*|j|d<|j|d||jdf|S)NrHr)rHr&rrrrrrvisit_custom_op_binary` s z"SQLCompiler.visit_custom_op_binarycKs|j|||jdf|Sr)rrrrrrrvisit_custom_op_unary_operatorh s z*SQLCompiler.visit_custom_op_unary_operatorcKs|j|d||jf|Sr)rrrrrrrvisit_custom_op_unary_modifierm s z*SQLCompiler.visit_custom_op_unary_modifiercKsf|dd}d|d<|j|d<|jj|fd|i|||jj|fd|i|}|rb|rbd|}|S)N _in_binaryFT _binary_oprHr)rrRrwr\r)rr[rrHrTrNrrrrr&r s0   z$SQLCompiler._generate_generic_binarycKs||jj|f|SrrnrrrrTrrrr sz,SQLCompiler._generate_generic_unary_operatorcKs|jj|f||SrrnrPrrrr sz,SQLCompiler._generate_generic_unary_modifiercCstjdtjdS)Nz'%')r)rZliteral_columnr# STRINGTYPErrrr_like_percent_literal sz!SQLCompiler._like_percent_literalcKsd|jj|f|dS)Nzlower(rrnrrrr$visit_ilike_case_insensitive_operand sz0SQLCompiler.visit_ilike_case_insensitive_operandcKs2|}|j}||j||_|j||f|Sr_clonerRconcatrvisit_like_op_binaryrr[rRrTpercentrrrvisit_contains_op_binary sz$SQLCompiler.visit_contains_op_binarycKs2|}|j}||j||_|j||f|SrrUrRrVrvisit_not_like_op_binaryrXrrrvisit_not_contains_op_binary sz(SQLCompiler.visit_not_contains_op_binarycKsB|}|j}t|j|_|t|j||_|j||f|SrrUrRrrwrVrvisit_ilike_op_binaryrXrrrvisit_icontains_op_binary s z%SQLCompiler.visit_icontains_op_binarycKsB|}|j}t|j|_|t|j||_|j||f|SrrUrRrrwrVrvisit_not_ilike_op_binaryrXrrrvisit_not_icontains_op_binary s z)SQLCompiler.visit_not_icontains_op_binarycKs,|}|j}||j|_|j||f|Sr)rUrR_rconcatrrWrXrrrvisit_startswith_op_binary sz&SQLCompiler.visit_startswith_op_binarycKs,|}|j}||j|_|j||f|Sr)rUrRrdrr\rXrrrvisit_not_startswith_op_binary sz*SQLCompiler.visit_not_startswith_op_binarycKs<|}|j}t|j|_|t|j|_|j||f|Sr)rUrRrrwrdrr_rXrrrvisit_istartswith_op_binary s  z'SQLCompiler.visit_istartswith_op_binarycKs<|}|j}t|j|_|t|j|_|j||f|Sr)rUrRrrwrdrrbrXrrrvisit_not_istartswith_op_binary s  z+SQLCompiler.visit_not_istartswith_op_binarycKs,|}|j}||j|_|j||f|SrrTrXrrrvisit_endswith_op_binary sz$SQLCompiler.visit_endswith_op_binarycKs,|}|j}||j|_|j||f|Srr[rXrrrvisit_not_endswith_op_binary sz(SQLCompiler.visit_not_endswith_op_binarycKs<|}|j}t|j|_|t|j|_|j||f|Srr^rXrrrvisit_iendswith_op_binary s  z%SQLCompiler.visit_iendswith_op_binarycKs<|}|j}t|j|_|t|j|_|j||f|SrrarXrrrvisit_not_iendswith_op_binary s  z)SQLCompiler.visit_not_iendswith_op_binarycKsL|jdd}d|jj|f||jj|f|f|rFd||tjndS)Nrz %s LIKE %s ESCAPE r( modifiersrrwr\rr+r#rQrr[rRrTrrrrrW sz SQLCompiler.visit_like_op_binarycKsL|jdd}d|jj|f||jj|f|f|rFd||tjndS)Nrz%s NOT LIKE %srmr(rnrprrrr\ sz$SQLCompiler.visit_not_like_op_binarycKs:|tjkr*|}t|j|_t|j|_|j||f|Sr)rZilike_oprUrrwrrWrrrrr_ s    z!SQLCompiler.visit_ilike_op_binarycKs:|tjkr*|}t|j|_t|j|_|j||f|Sr)rZ not_ilike_oprUrrwrr\rrrrrb s    z%SQLCompiler.visit_not_ilike_op_binarycKs&|jdd}|j||rdndf|S)NrFz BETWEEN SYMMETRIC z BETWEEN rorr&rr[rRrTrrrrvisit_between_op_binary s z#SQLCompiler.visit_between_op_binarycKs&|jdd}|j||rdndf|S)NrFz NOT BETWEEN SYMMETRIC z NOT BETWEEN rqrrrrrvisit_not_between_op_binary s z'SQLCompiler.visit_not_between_op_binarycKstd|jjdSNz/%s dialect does not support regular expressionsr4rr:rrrrrvisit_regexp_match_op_binary s z(SQLCompiler.visit_regexp_match_op_binarycKstd|jjdSrurvrrrr visit_not_regexp_match_op_binary$ s z,SQLCompiler.visit_not_regexp_match_op_binarycKstd|jjdS)Nz;%s dialect does not support regular expression replacementsrvrrrrvisit_regexp_replace_op_binary* s z*SQLCompiler.visit_regexp_replace_op_binarycKs|s|j|j}|jr||} |j| fd||o8|j ||d|} |jrtd| } | sft dd| d| d| df} |r|j |fd| d |} d | S| S|s|p|j p|o|j }|p|j} nd } |r|j |fd di|} |jrd | } | S||}||jkr|j|}||k r|js@|jrp|j|jsp|j|jsptd |nh|j|jkrtd|fnH|js|jr|jr|jrtdntd|jd|jd||j|j<|j|<|j}|r4|\}}|jD]*}|j|kr||j}|||q|jrBd|_| r||rTd|_|rl|j|hO_n|j|hO_|j|f| |j|jd|} |jrd | } | S)NT)skip_bind_expressionrv literal_bindsrCrender_postcompilez&^(.*)\(__\[POSTCOMPILE_(\S+?)\]\)(.*)$r1z$(__[POSTCOMPILE_%s~~%s~~REPL~~%s~~])r3rr)rvr;rFrvzIBind parameter '%s' conflicts with unique bind parameter of the same nameaCan't reuse bound parameter name '%s' in both 'expanding' (e.g. within an IN expression) and non-expanding contexts. If this parameter is to receive a list/array value, set 'expanding=True' on it for expressions that aren't IN, otherwise use a different parameter name.a)Encountered unsupported case when compiling an INSERT or UPDATE statement. If this is a multi-table UPDATE statement, please provide string-named arguments to the values() method with distinct names; support for multi-table UPDATE statements that target multiple tables for UPDATE is very limitedzbindparam() 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').) post_compile expandingbindparam_type) r dialect_implr:r9bind_expressionrBr~rmatchrArprArCr_truncate_bindparamrrry intersectionZ _cloned_setr4rZ_is_crudrrrZ isoutparamhas_out_parametersrrrr)rrrvr{rzrCr|rZimplrwrappedrrgr}rexistingr rrZbpcbrrrvisit_bindparam0 s                 zSQLCompiler.visit_bindparamcCs tdSrrV)rrZ dbapi_typesqltextrrrr@ szSQLCompiler.render_bind_castc Ks|tk r|}nZ|jdkrb|jdkrb|dd}|rR|tjtjfkrRtd|j f|j t j f|S|j }|jr|j}||||d\}} | S|||jSdS)NrOzBound parameter '%s' rendering literal NULL in a SQL expression; comparisons to NULL should not use operators outside of 'is' or 'is not')r;)r+rrrris_is_notr$Z warn_limitedrrBr#rrr~r>r+r) rrr+r;rTropZleeprIrJrrrrA s(  z$SQLCompiler.render_literal_bindparamc Cs||j}|r`z ||WStk r\}z$tdt|d|d|W5d}~XYq|Xntdt|d|dS)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 Could not render literal value "z" with datatype z); see parent stack trace for more detail.Nz:No literal value renderer is available for literal value ")Z_cached_literal_processorr:rqr4rsql_utilZ_repr_single_value)rrr processorerrrr+ s   z SQLCompiler.render_literal_valuecCs@||jkr|j|S|j}t|tjr2|d|}||j|<|S)Nr)rrr@rr@r)rrr rrrrs     zSQLCompiler._truncate_bindparamr@) ident_classrrcCs||f|jkr|j||fS||j}t||jdkr|j|d}|dt|jdddt|dd}|d|j|<n|}||j||f<|S)Nrrrr3) r apply_maprrrrrmaxhex)rrrZanonnamecounterZ truncnamerrrr$s z!SQLCompiler._truncated_identifier)rrcCs ||jSrrrrrrr _anonymize9szSQLCompiler._anonymizezOptional[TypeEngine[Any]]zOptional[Set[str]]) rr}r~ escaped_fromraccumulate_bind_namesvisited_bindparamrTrc  s |dk r|||dk r$|||sRj|rRjfdd|} |}| }|rhj||i_|rd|} |r|| S|dk r|j} | j r || | } | Sj t j krĈjd|i} njd|i} |dk rjjr|j} | j r || | } | S)Ncsj|dS)Nr)rrprrrrrXrz.SQLCompiler.bindparam_string..z__[POSTCOMPILE_%s]r)addrrr:rrrr#r:Zrender_literal_castr@r*rrrrrC) rrr}r~rrrrrTnew_namergZ type_implrrrr<sL      zSQLCompiler.bindparam_stringcCsF|}|ddt|j|jD]\}}|j|fd|i|q"dS)Ncte_opts)copyrrrZ_independent_ctes_optsr\)rstmtrTZlocal_kwcteoptrrrrs  z&SQLCompiler._dispatch_independent_ctesrHzOptional[_FromHintsType]z Optional[CTE]zOptional[FromLinter]zselectable._CTEOpts) rrpashint fromhints visiting_cterErrZrc s} | jkst||d<|j} t| tjr<d| } d} d} |} |j pV|j }| j krj | \}}}|| ks~t|| f}j |}|j r|j rt d|| f}|rtjnd}|| f}}j |=|j |<||fj | <n6|rtjnd}|| f}|j kr"j |}nd}|dk r||k} ||jksN||krTd} nx||jkr| |=|}|| ks|t||kstj |=n8|jdk s|jdk r||rd} nt d| |s| sdS|jdk r|j}|jj}t|tjrd|}n|}d}| r\|j |<||fj | <|jkrTj|f||s\|| kr\|jrrd_j|| }|jr|j}dd |dD}|d d fd d |D7}|dddkstjs|jjfd|i|Sj||jf|}|jjfddi|}|d||f7}|j rT|dj||j f|7}|| |<|r|rr| |j!|<| s| rj|| S|r̈j||}j"| rj#| } |$| 7}|Sj|| SdS)NrrTFz6CTE is stated as 'nest_here' in more than one locationrz5Multiple, unrelated CTEs found with the same name: %rcSs"g|]\}}}}}|s|p|qSrr)rr proxy_namefallback_label_namerrepeatedrrrrsz)SQLCompiler.visit_cte..rrc3s |]}jj|jdVqdS)rN)r1format_label_namer)ridentrrrr s z(SQLCompiler.visit_cte..subqueryrpz AS %s (%s)r)%rrrArr@rr@r_get_reference_ctenestingrrr4rrrZ _restatesZ _is_clone_ofcompareZ _cte_alias visit_cte recursiverr1 format_aliasrR_generate_columns_plus_namesrurr\_generate_prefixes _prefixes _suffixesr_requires_quotesrget_render_as_alias_suffix)rrrprrrrErrZZ self_ctescte_nameZ is_new_cteZembedded_in_current_named_cteZ_reference_cter cte_levelrZexisting_cte_optsZcte_level_nameZ existing_cteZold_level_nameZnew_level_nameZexisting_cte_reference_cteZ pre_alias_cteZcte_pre_alias_namerZ col_sourceZ recur_colsprefixesrsrrrrs                          zSQLCompiler.visit_ctecKs4|jrd|d<|jr"|j|f|S|j|f|SdS)NrE)Zjoins_implicitly _is_lateral visit_lateral visit_aliasrrrrvisit_table_valued_aliasTs z$SQLCompiler.visit_table_valued_aliascKs|j|f|Sr)rrrrrvisit_table_valued_column\sz%SQLCompiler.visit_table_valued_columnc  s|r:dkrjstd<| r:dkr:dkr:| d<|dk r|jkrjjf|||||d} |r|sz|rd| f} | S}d<|s|rtjtjrdj} nj} |r҈j | S|r| r| | j <jjfd|d} |rd| f} |  j | } j r^jr^| dd fd d jD7} |r|kr| ||} | Sjjfd |iSdS) NrDrF)rpriscrudrlateralenclosing_aliasrrrT)rprrc3sB|]:}dj|jjr2djjj|jfndfVqdS)z%s%s %sr(N)r1rrZ_render_derived_w_typesr:rrBrrTrrZrrrrs  z*SQLCompiler.visit_alias..r)rrArRr\r@rrr@rr1rrrZ_supports_derived_columnsZ_render_derivedrurformat_from_hint_text)rrrprrrrrrrErZrsZ alias_namergrrrr_s        zSQLCompiler.visit_aliascKsd|d<|j|f|S)NTrr)rrrTrrrvisit_subqueryszSQLCompiler.visit_subquerycKsd|d<d|j|f|S)NTrz LATERAL %sr)rZlateral_rTrrrrszSQLCompiler.visit_lateralcKsRd|j|fddi||j|f|f}|jdk rN|d|jj|f|7}|S)Nz%s TABLESAMPLE %srpTz REPEATABLE (%s))rZ _get_methodr\seed)rZ tablesamplerprTrrrrvisit_tablesamples zSQLCompiler.visit_tablesamplec s6djdfddjD}d|S)Nr{rc3s8|]0}|D]&}jtj|djifVq qdS)rN)rBrrZ _column_typesr|)rchunkelemrRrTrrrrsz-SQLCompiler._render_values..r/) setdefaultr{ru_data)rrRrTZtuplesrrr_render_valuess  zSQLCompiler._render_valuesc sj|f}|jrd}n$t|jtjr8d|j}n|j}|jrJd}nd}|r|rl|dk rb|nd|j|<|rd|| j |d fdd|j Df}n d ||f}|S) NrzLATERAL r(z(unnamed VALUES element)z %s(%s)%s (%s)rc3s$|]}|jfddiVqdS)rFNr[rrrrrsz+SQLCompiler.visit_values..z%s(%s))rZ_unnamedr@rrr@rrrrr1rrucolumns)rrRrprErTrrrrrr visit_valuess0 zSQLCompiler.visit_valuescKsd|j|f|dSrm)rrrrrvisit_scalar_values szSQLCompiler.visit_scalar_valuescCsd|S)Nrr)rZalias_name_textrrrrsz&SQLCompiler.get_render_as_alias_suffixrrrcCsF|dks|dkrd|_d|_|jr,td|jt||||dS)N*FTzxMost backends don't support SELECTing from a tuple() object. If this is an ORM query, consider using the Bundle object.)rrrr4rr,rrrrrrrs zSQLCompiler._add_to_result_mapcKs"|jd||d|dkrin|f|S)aLRender a column with necessary labels inside of a RETURNING clause. This method is provided for individual dialects in place of calling the _label_select_column method directly, so that the two use cases of RETURNING vs. SELECT can be disambiguated going forward. .. versionadded:: 1.4.21 NF_label_select_column)rrr^rcolumn_clause_argsrTrrr_label_returning_column&s z#SQLCompiler._label_returning_columnc sj|j} | jr(| s|r(| }n}|rh|j}| rL|fdd}ql|k rl|fdd}nd}| sxtdttj r|k rt |j j fd}n|}n|r|dk stdt |||j fd}n|k rd}n~ttjr |oj ojdk }nTttjr d }n@ttjr<jp8|}n$ttjs\jdkr\d}nd }|r|s|| rvtj}t|tjst|n|}t |||fd}n|}|j| || d |j|f|S) z.produce labeled columns present in a select().cs||d|dS)Nrrrrrr)rrrrasz;SQLCompiler._label_select_column..add_to_result_mapcs||f||dSrrrrr^rrris NzX_label_select_column is only relevant within the columns clause of a SELECT or RETURNING)rwz*proxy_name is required if 'name' is passedTF)rvrr)rrr:Z_has_column_expressionZcolumn_expressionrrAr@rrDrrrrRrrBrrZ TextClauseZUnaryExpressionZwraps_column_expressionZ NamedColumnZ_non_anon_labelZ_anon_name_labelr@rDr\)rrr^rrprrrrrvcolumn_is_repeatedneed_column_expressionsrrZcol_exprrZ result_exprZrender_with_labelrrrr;s     z SQLCompiler._label_select_columncCs |||}|r|d|7}|Sr)get_from_hint_text)rrrhintrhinttextrrrrs  z!SQLCompiler.format_from_hint_textcCsdSrr)rZbyfromsrrrget_select_hint_textsz SQLCompiler.get_select_hint_textcCsdSrrrrrrrrrszSQLCompiler.get_from_hint_textcCsdSrrrrrrget_crud_hint_textszSQLCompiler.get_crud_hint_textcCs d|Srr)rZ hint_textsrrrget_statement_hint_textsz#SQLCompiler.get_statement_hint_textrrrrc Ksh|j }|r|jn|jd}|||}|d}|d} |rV|sV|j|| dd} n|j|| d} | S)NrrrrZexplicit_correlate_fromsZimplicit_correlate_froms)rrr_get_display_froms difference) r select_stmtrprrTrrrrrrrrr_display_froms_for_selects" z%SQLCompiler._display_froms_for_selecttranslate_select_structurec  s|dkstdd| d<jf| } | j| d<| jj } | rPjsP| _|dk pZ|} jrjfdi| } | k r| }}| jf| } | j| rjnjd}| p|ddp|dd|rdsd | kr| d = | |||}|  ddd d }j rJ \}}|rN||d 7}nd}jrb| jr|jjf| 7}|jf| 7}d dfdd| jDD}r|dk rttdd| jDdd|jDfddjD_|| |||| | }jrRfddjD}|rR|d |7}jr| rf| r| svtjnd}j|d|}jr|d jjf| 7}jd|S)NzpSQLAlchemy 1.4 requires use of the translate_select_structure hook for structural translations of SELECT objectsFrvrrprrrr)rrvzSELECT rcSsg|]}|dk r|qSrrrrrrrsz,SQLCompiler.visit_select..cs4g|],\}}}}}j|||||d qS))rrrrrrrrrrr^r)rprrrrrrrrs$ cSsg|]\}}}}}|qSrrrrrrrrrrrrscSsg|]\}}}}}|qSrrrrrrrsc s4g|],\}}}}t||tfdd|D|qS)c3s|]}||VqdSrr)ro translaterrrsz6SQLCompiler.visit_select...)rr)rrrrYrrrrrs cs$g|]\}}|djjfkr|qSrr:r)r dialect_nameZhtrrrrsr)rArZ_ambiguous_table_name_maprrrrrr_setup_select_stackrrD_hints_setup_select_hintsrrrrget_select_precolumnscolumns_plus_namesrrr,_compose_select_bodyZ_statement_hintsrrrrrr)rrrp insert_intorrZselect_wraps_forrrErZrrZis_embedded_selectZnew_select_stmtZcompile_state_wraps_forrrr hint_textbyfrom inner_columnsZ per_dialectrr)rprrrrrrr visit_selects             zSQLCompiler.visit_selectrzTuple[str, _FromHintsType])rrcs*fdd|jD}|}||fS)Nc s<i|]4\\}}}|djjfkr||d|jddiqS)rrT)rr:rr\)rr"r:rrrrrs  z3SQLCompiler._setup_select_hints..)rrr)rrrrrrrrs   zSQLCompiler._setup_select_hintscCs|d}|d}|dkr"||d<nD|rf|d} t| j} t|j| krftdd| |dt|jf|r|s|j||dd} n|j||d} tt| } | |} | | ||d }|j || S) Nrrrrz}All selectables passed to CompoundSelect must have identical numbers of columns; select #%d has %d columns, select #%d has %drrr)rrr"r) rrrr4rrrrr(rrr)rrrrrprrrrrZnumcolsrZnew_correlate_fromsZall_correlate_fromsrrrrrsJ      zSQLCompiler._setup_select_stackc s|d|7}jt@r:titjt@} |rB_ndd} |sN|}|r|d7}|jr|dfdd|D7}q|dfdd|D7}n | 7}|j rj |j fdi} | r|d| 7}| rdk st  |jr|j|f7}|jr<j |jf} | r<|d | 7}|jrV|j|f7}|jrp|j|f7}|jdk r|j|f7}|S) NrFz FROM cs&g|]}|jfddqS)T)rprrEr[rfrrErZrrrrNsz4SQLCompiler._compose_select_body..cs$g|]}|jfddqS)TrprEr[r)rErZrrrr[srEz WHERE z HAVING )rurr r rr rErstriprrl_where_criteriarrAr#_group_by_clausesrZ_having_criteria_order_by_clausesr r r Z_for_update_argfor_update_clause) rrrrrrrrrZZ warn_lintingtrrrr)sl           z SQLCompiler._compose_select_bodyc s*dfdd|D}|r&|d7}|S)Nrc3s4|],\}}|dks|jjkr|jfVqdS))NrNr)rprefixrrrrrs z1SQLCompiler._generate_prefixes..r)rrrrTrrrrrs zSQLCompiler._generate_prefixesc Cs0|js dS|r|dkrt}t|jD]T}|j|\}}}|jpN|j}||kpf|of||dk} |r,| srq,|j|||<q,n|j}|sdStdd|D} | | d} | d dd| D7} | d7} |r,|dkr,t|D]8}|j|\}}}|j|=|j ||f=|j|=q| S) z include_following_stack Also render the nesting CTEs on the next stack. Useful for SQL structures like UNION or INSERT that can wrap SELECT statements containing nesting CTEs. r(rcSsg|] }|jqSr)r)rrrrrrsz2SQLCompiler._render_cte_clause..r, cSsg|]}|qSrr)rtxtrrrrsz ) rr$rrkeysrrrrWget_cte_preamblerurr) rrrrrrrrrZis_rendered_levelrZcte_textrrrrs>      zSQLCompiler._render_cte_clausecCs|rdSdSdS)NzWITH RECURSIVEZWITHr)rrrrrr szSQLCompiler.get_cte_preamblecKs"|jrtjddd|jrdSdS)zcCalled when building a ``SELECT`` statement, position is just before column list. a DISTINCT ON is currently supported only by the PostgreSQL dialect. Use of DISTINCT ON for other backends is currently silently ignored, however this usage is deprecated, and will raise CompileError in a future release for all backends that do not support this syntax.z1.4versionrr()Z _distinct_onr$warn_deprecatedZ _distinctrrrTrrrrs z!SQLCompiler.get_select_precolumnscKs,|j|jttjf|}|r$d|SdSdS)z5allow dialects to customize how GROUP BY is rendered.z GROUP BY r(N)rrrrcomma_op)rrrTZgroup_byrrrrszSQLCompiler.group_by_clausecKs,|j|jttjf|}|r$d|SdSdS)z5allow dialects to customize how ORDER BY is rendered.z ORDER BY r(N)rrrrr)rrrTrrrrr szSQLCompiler.order_by_clausecKsdS)Nz FOR UPDATErrrrrrszSQLCompiler.for_update_clauser>Sequence[ColumnElement[Any]]rreturning_colsrrTrc s6fddjdt|dD}dd|S)Nc s6g|].\}}}}}j|f||||dqS))rrrr)rrrTrrrrrrs$ z0SQLCompiler.returning_clause..T)cols RETURNING r)rr_select_iterablesrurrrrrTrrrrreturning_clauses zSQLCompiler.returning_clausecKs^d}|jdk r&|d|j|jf|7}|jdk rZ|jdkrB|d7}|d|j|jf|7}|S)Nr(z LIMIT z LIMIT -1z OFFSET )Z _limit_clauserB_offset_clause)rrrTrrrrrs   zSQLCompiler.limit_clausec Ks|dkr|j}|j}n ddd}d}|jdk rf|j}|rJ||rJ|}|j|f|} |d| 7}n |rr|d7}|dk r|r||r|}|d|j|f||drdnd|d rd nd f7}|S) NF)rY with_tiesr(z OFFSET %s ROWSz OFFSET 0 ROWSz FETCH FIRST %s%s ROWS %srYz PERCENTrz WITH TIESZONLY)rZ_fetch_clause_optionsrZ_simple_int_clauseZrender_literal_executerB) rrrZrequire_offsetZ"use_literal_execute_for_simple_intrTZfetch_clause_optionsrZ offset_clauseZ offset_strrrrr"s8   zSQLCompiler.fetch_clausec Ks|r|j|j|<|s|r|j|} |rL| rL|j| d|j|j} nJ|j|j} | s|r|j|kr|d||j} | ||j d| } |r||kr| | ||||} | SdSdS)Nrrr() fullnamerr1rrrrrrrr) rrrprrr use_schemarErrZrrgZ anon_namerrr visit_tableKsD       zSQLCompiler.visit_tablecKs|r |jt|jj|jj|jr,d}n|jr8d}nd}|jj |fd|d|||jj |fd|d|d|j j |fd|i|S)Nz FULL OUTER JOIN z LEFT OUTER JOIN z JOIN Trz ON rE) rrDrrGrwr(rroZisouterr\Zonclause)rrurprErZZ join_typerrr visit_join{sT zSQLCompiler.visit_joincsBfdd|jD}|j|kr:||j||jd}||fS)Ncs*i|]"\\}}}|djjfkr||qSrr)rrr:rrrrrs z1SQLCompiler._setup_crud_hints..T)rrrr)rr table_text dialect_hintsrrr_setup_crud_hintss  zSQLCompiler._setup_crud_hintscCs$|jjo"|jjo"|jjp"|jp"|jSr)r:supports_multivalues_insertZuse_insertmanyvaluesZ!use_insertmanyvalues_wo_returningrr,)rrrrr(_insert_stmt_should_use_insertmanyvaluessz4SQLCompiler._insert_stmt_should_use_insertmanyvaluesc&#s j}|dk std|jd}t}|jr^ jjs^tdD]\}|||fVq@dS||d} jj } | rt j } t|j } | | } t || | | }t } d}d}||||rdnd}|j }|dk std jsp jr jnitd} fddddfd d |Dd}|fd d |D}fd d ||D}d}nd}t}i}d|jd}t|j D]}|dqr j}|dk stfddt|D}t |t|dt|kst jr0t j}t|dd|}| r| d|}g| d|<rxddfdd tt|DD} jrp|j}|t|dkrd}}|}n4|dd}|dd}fdd |D}|t|dd} jrF|dkrF|r td} |t|| }!t fdd t| |!D}"||"}|d|}#ttj !|}$||$|}$nbg}%|"}$t|D]:\|%#|dt$|$fdd |Dq|dd|%}#|#|$|||fV|d7}q0dS)NrrrZ__EXECMANY_TOKEN__rcs@|D]6}||}|jd|ijd|di}q|S)NrZ__EXECMANY_INDEX__)rrr)r  formattedr)rrrrapply_placeholderss   zISQLCompiler._deliver_insertmanyvalues_batches..apply_placeholdersrc3s |]\}}}}||VqdSrr)rrr' bind_keys)r(rrr s z@SQLCompiler._deliver_insertmanyvalues_batches..c3s,|]$\}}}}|D]}||VqqdSrr)rrr)r)rrrrs csi|]}|d|qS)rrrrrrrszASQLCompiler._deliver_insertmanyvalues_batches..r(z), rcsh|]\}}|kr|qSrr)rrer)all_names_we_will_expandrrr*sz@SQLCompiler._deliver_insertmanyvalues_batches..z\d+rcSsg|]\}}}|||fqSrr)rZnew_keylen_r$rrrrDszASQLCompiler._deliver_insertmanyvalues_batches..c3s2|]*}D] \}}}|d|||fVq qdS)rNr)rrrr+r$)generic_setinputsizesrrrFsrc3s|]}|VqdSrrr)expand_pos_lower_indexexpand_pos_upper_indexrrrXsc3s|]}j|VqdSrr@rr/rrrrrsZEXECMANY_INDEX__cs i|]}|d|qS)__rr)r/paramrrrs )%rrArrrr:supports_default_metavaluer.rZinsertmanyvalues_max_parametersrrminrrrrrurrrDrrrrrrrrangerrrr from_iterablerrr)&rrrr,Z batch_sizeZimvZexecutemany_valuesZ lenparamsZbatchnumZ max_paramsZtotal_num_of_paramsZnum_params_per_batchZnum_params_outside_of_batchZbatchesZprocessed_setinputsizesZ total_batchesrZall_keysZformatted_values_clauseZkeys_to_replaceZbase_parametersZexecutemany_values_w_commarrZall_expand_positionsescapedbatchZnum_ins_paramsZextra_params_leftZextra_params_rightZbatch_iteratorZexpanded_values_stringrrirZreplaced_statementZreplaced_parametersZreplaced_values_clausesr) r*r(rr-r.r,r/r2rrr!_deliver_insertmanyvalues_batchess&                       z-SQLCompiler._deliver_insertmanyvalues_batchescKs|j||f|}|j}|j }|r@d|_|js4||_|js@||_|jtt|dd}d}|jrvd|k}|svg}t j ||||fd|i|}|jr|dk rt |}|j r|j dk r|j |7_ n||_ |j} | s |jjs |jjs |jjs td|jj|jr6|jjs.td|jj|j} n|j} |j} |jj} d} |jrl| |j||jf|7} | d 7} | |j} |jr||| \}} |jr| ||| | 7} | s| s| d d !d d | D7} |j"s|j#r|j$||j"p|j#|d}|j%r | d|7} nd}|j&dk r|j'|jddfddi|}|j(r|jj)r|snt |jnd}| d|j*|dd|f7} n | d|7} n| s| r| d7} |rT|+|rTt,d|jj-t.d| ||_/nv|jr| dd !dd|j0D7} nNd !dd t.d| D}| d|7} |rT|+|rTt,d|t.d| ||_/|j1dk r|j'|j1f|}|r| d|7} |r|j%s| d|7} |j(r|jj)s|st |jnd}|j*|dd| } |j2d| S)NTrrrrzWThe '%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.zINSERT zINTO  (%s)rcSsg|]\}}}}|qSrr)rrr<rrrrs z,SQLCompiler.visit_insert..rrrrrz %s%srrz DEFAULT VALUESrz VALUES %scss&|]}dddd|DVqdS)rrcss|]\}}}}|VqdSrrrrrrrrrCs z5SQLCompiler.visit_insert...Nr)rZcrud_param_setrrrrAsz+SQLCompiler.visit_insert..cSsg|]\}}}}|qSrrr<rrrrKs z VALUES (%s)F)3rrrrr3rrrrr_get_crud_paramsrrr single_paramsr:supports_default_valuesr3Zsupports_empty_insertr4rrZ_has_multi_parametersr%r1rr format_tablerrr$rrrur _returningrrrrBrZcte_follows_insertrr&rZdefault_metavalue_tokenrrZall_multi_paramsZ_post_values_clauser)rZ insert_stmtrrTrrZcounted_bindparamZhas_visiting_ctecrud_params_structZcrud_params_singler1r?rr"rrZ select_textrrZpost_values_clauserrr visit_inserts^                     zSQLCompiler.visit_insertcCsdS)z3Provide a hook for MySQL to add LIMIT to the UPDATENr)r update_stmtrrrupdate_limit_clausezszSQLCompiler.update_limit_clausecKsd|d<|j|fddi|S)z|Provide a hook to override the initial table clause in an UPDATE statement. MySQL overrides this. Trprr[)rrD from_table extra_fromsrTrrrupdate_tables_clause~sz SQLCompiler.update_tables_clausecKs tddS)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 UPDATENrVrrDrFrG from_hintsrTrrrupdate_from_clauses zSQLCompiler.update_from_clausec sp|j||f|}|j}|j }|r@d|_|js4||_|js@||_|j}t|}|r~tt |j fdd|D} |}n g}|j h}|j |||dd} |j r| |j||j f|7} |j||j |f|} tj||||f|} | j} |jr||| \} } nd} |jr|||| | 7} | d7} | ddd td | D7} |js\|jr|jr| d |j||jpz|j|d 7} |r|j||j || f|}|r| d |7} |jr|j|jf|}|r| d |7} | |}|r| d |7} |js |jr4|js4| d |j||jp(|j|d 7} |j!r`|sLt"|jnd}|j#|d| } |j$d| S)NTcsg|]}|kr|qSrrrZ main_fromsrrrsz,SQLCompiler.visit_update..rzUPDATE z SET rcss"|]\}}}}|d|VqdS)=Nr)rrr<rrrrrs z+SQLCompiler.visit_update..zList[Tuple[Any, str, str, Any]]rr; WHERE rr)%rrrrr3r _extra_fromsrrr(rrrrrrHrr=r>rr$rrrurrrArrrKrrrErrrr)rrDrTrrrGZ is_multitableZrender_extra_fromsrrr"rBZ crud_paramsr#extra_from_textrrrrrLr visit_updates               zSQLCompiler.visit_updatecKs tddS)zProvide 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 DELETENrVrIrrrdelete_extra_from_clause s z$SQLCompiler.delete_extra_from_clausecCs|j|dddS)NT)rprr[)r delete_stmtrFrGrrrdelete_table_clauseszSQLCompiler.delete_table_clausec Ks|j||f|}|j}|j }|r@d|_|js4||_|js@||_|j}|jh|}|j |||dd}|j r||j ||j f|7}|d7}| ||j|}t j||||f||jr|||\} }nd} |jr|||||7}|js|jr"|jr"|d|j||jp|j|d7}|rP|j||j|| f|} | rP|d| 7}|jrz|j|jf|} | rz|d| 7}|js|jr|js|d|j||jp|j|d7}|jr|st|jnd} |j| d|}|jd |S) NTrzDELETE FROM rr;rNrr)rrrrr3rrOrrrrrrTrr=rr$rrrrArrrRrrrrrr) rrSrTrrrGrrr"r#rPrrrrr visit_deletes         zSQLCompiler.visit_deletecKsd|j|S)Nz SAVEPOINT %sr1format_savepointrZsavepoint_stmtrTrrrvisit_savepoint~szSQLCompiler.visit_savepointcKsd|j|S)NzROLLBACK TO SAVEPOINT %srWrYrrrvisit_rollback_to_savepointsz'SQLCompiler.visit_rollback_to_savepointcKsd|j|S)NzRELEASE SAVEPOINT %srWrYrrrvisit_release_savepointsz#SQLCompiler.visit_release_savepoint)NT)NNTNTF)F)F)F)F)NFFNr)NTrN)N)NF)N)FN)Nr)N)NFNN)F)FFFFF)FFNNNN)FFFNFFNN)F)FN)N)NNNTFFT)F)FFNNNFN)NF)NFF)FFFNTNN)FN)N)rrrr EXTRACT_MAPrr$rkrrrhCOMPOUND_KEYWORDSrrrrrrrrrrrrrrrrrrrrrr frozensetrrrjrrZpostfetch_lastrowidrrrrrrrrFrpatternrrlrFrr rErrZro_memoized_propertyrrrrmemoized_propertyrZmemoized_instancemethodr contextlibcontextmanagerrrrrrrXrrfr)rbrpreload_modulerMrQrdrkrlrqrrr}rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr r rrrrrr!r%r'r.r,r>rBr#rIrJrKrLrMr&rrrRrSrZr]r`rcrerfrgrhrirjrkrlrWr\r_rbrsrtrwrxryrr@r+rAr+rrrrrr"Z_CTEOptsrrrrrrrrrrrrrrrrrrrrjrrrrrrrrrrr rrr rrrrr r!r$r&r9rCrErHrKrQrRrTrVrZr[r\rrrrrjs  +                           "  >M  & H  P *  0 0 1;  5 . A  '     L T3                       % !  *E 0L  c   '   %       N 4 _ 5    ! ,0 sX   v   _  rcseZdZdZddZedfddZddZd d Z d d Z d dZ ddddddddZ ddZ ddZddZddZdd Zd!d"Zd#d$ZZS)%StrSQLCompileraA :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` cCsdS)Nzrrrrrrsz$StrSQLCompiler._fallback_column_namezsqlalchemy.engine.urlc sT|jdkrFtjj}|j|j}||d}t|t sF| |St ||S)Nre) Zstringify_dialectr$rKZ engine_urlURLr` get_dialectstatement_compilerr@rerBrGrU)rrRrSrTurlr:compilerrKrrrUs    z,StrSQLCompiler.visit_unsupported_compilationcKs$d|j|jf||j|jf|fS)Nz%s[%s])rBrwrrrrrvisit_getitem_binarysz#StrSQLCompiler.visit_getitem_binarycKs|j||f|Srrkrrrrvisit_json_getitem_op_binarysz+StrSQLCompiler.visit_json_getitem_op_binarycKs|j||f|Srrlrrrr!visit_json_path_getitem_op_binarysz0StrSQLCompiler.visit_json_path_getitem_op_binarycKsd|j|S)Nz)r1format_sequence)rseqrTrrrrszStrSQLCompiler.visit_sequencer>rrrrrc s&fddt|D}dd|S)Nc sg|]}d|ddiqS)NTFrrrrrrsz3StrSQLCompiler.returning_clause..rr)rrrurrrrrs zStrSQLCompiler.returning_clausec s(dd<ddfdd|DS)NTrprUrc3s$|]}|jfdiVqdSrNr[rrrJrTrrrrsz4StrSQLCompiler.update_from_clause..rrIrrsrrKsz!StrSQLCompiler.update_from_clausec s(dd<ddfdd|DS)NTrprc3s$|]}|jfdiVqdSrqr[rrrsrrrsz:StrSQLCompiler.delete_extra_from_clause..rrIrrsrrRsz'StrSQLCompiler.delete_extra_from_clausecKsdS)NzSELECT 1 WHERE 1!=1rrprrrr,sz#StrSQLCompiler.visit_empty_set_exprcCsd|S)Nz[%s]rrrrrrsz!StrSQLCompiler.get_from_hint_textcKs|j|df|S)Nz r&rrrrrwsz+StrSQLCompiler.visit_regexp_match_op_binarycKs|j|df|S)Nz rtrrrrrxsz/StrSQLCompiler.visit_not_regexp_match_op_binarycKs:|jd}d|jj|f||jj|f||j|f|fS)N replacementz(%s, %s, %s))rorwr\r)rr[rRrTrurrrrys   z-StrSQLCompiler.visit_regexp_replace_op_binary)rrrrrr$rdrUrkrmrnrrrKrRr,rrwrxryrmrrrKrres    rec@seZdZdZer(dgddddddd d Zejd d Zejd dZ dhdddddddZ ddZ ddZ ddZ ddZdidd Zdjd!d"Zd#d$Zd%d&Zd'd(Zdkd)d*Zd+d,Zdld-d.Zd/d0Zd1d2Zd3d4Zd5d6Zd7d8Zd9d:Zd;d<Zd=d>Zdmd?d@ZdAdBZ dCdDZ!dEdFZ"dGdHZ#dIdJZ$dKdLZ%dMdNZ&dOdPZ'dQdRZ(dSdTZ)dUdVZ*dWdXZ+dYdZZ,d[d\Z-d]d^Z.d_d`Z/dadbZ0dcddZ1dedfZ2dS)n DDLCompilerT.rSr<r-rr8r9cCsdSrrrDrrrrEszDDLCompiler.__init__cCs|jj|jd|jdS)Nr.)r:rhr.rrrrrXs zDDLCompiler.sql_compilercCs|jjSr)r:rrrrr type_compilerszDDLCompiler.type_compilerNr^r_r`racCsdSrrrerrrrf szDDLCompiler.construct_paramscKs|j}t|jtjr|}|j}||j}t|dkrJ|dd}}n|d|d}}| d|| d|| d| |j|j |j |S)Nrrr(rrr!r)contextr@targetr!ZTablerr1format_table_seqrrr@rXrr)rddlrZryr1pathrZschrrr visit_ddls    zDDLCompiler.visit_ddlcKs$d}|jr|d7}||j|jS)NzCREATE SCHEMA IF NOT EXISTS ) if_not_existsr1 format_schemarR)rr`rTrrrrvisit_create_schema'szDDLCompiler.visit_create_schemacKs6d}|jr|d7}||j|j7}|jr2|d7}|S)Nz DROP SCHEMA IF EXISTS  CASCADE) if_existsr1rrRcascaderdroprTrrrrvisit_drop_schema-szDDLCompiler.visit_drop_schemac KsV|j}|j}d}|jr*|d|jd7}|d7}|jr@|d7}|||d7}||}|rl||d7}|d7}d}d}|jD]} | j} zD|j| | j o| d} | dk r||7}d }|d | 7}| j rd }Wqt j k r} z$t d |j | j | jd f| W5d} ~ XYqXq|j||jd} | r@||d | 7}|d||7}|S)Nz CREATE rzTABLE rr Ffirst_pkr  Tz (in table '%s', column '%s'): %sr) _include_foreign_key_constraintsz )%s )rRr1rrurr@create_table_suffixrrBrar4r descriptionrargscreate_table_constraintsZinclude_foreign_key_constraintspost_create_table)rr`rTrr1rrrrZ create_columnr^ processedZceconstrrrvisit_create_table6sX     zDDLCompiler.visit_create_tableFc sL|j}|jrdSj||d}dfdd|jD}|rH|d|7}|S)Nrrc3s|]}|VqdSr)rBrr_rrrrqsz2DDLCompiler.visit_create_column..)rRsystemget_column_specificationru constraints)rr`rrTr^rrrrrvisit_create_columnjs zDDLCompiler.visit_create_columnc stg}jr|jj}|dk r0||nt|fddjDdddfdd|DDS)Ncs"g|]}|jk r|kr|qSr)rar) omit_fkcsrrrrs z8DDLCompiler.create_table_constraints..z, css|]}|dk r|VqdSrr)rprrrrs z7DDLCompiler.create_table_constraints..c3s6|].}|rjjr$t|dds|VqdS)Z use_alterFN)Z_should_create_for_compilerr:Zsupports_alterrrBrrrrrs   )rarZforeign_key_constraintsrrrEZ_sorted_constraintsru)rrrrTrZall_fkcsr)rrrrrys"     z$DDLCompiler.create_table_constraintscKs$d}|jr|d7}||j|jS)Nz DROP TABLE r)rr1r@rRrrrrvisit_drop_tableszDDLCompiler.visit_drop_tablecKsd|j|jS)Nz DROP VIEW r1r@rRrrrTrrrvisit_drop_viewszDDLCompiler.visit_drop_viewcCs|jdkrtd|jdS)Nz,Index '%s' is not associated with any table.)rr4rrrrrrr_verify_index_tables zDDLCompiler._verify_index_tablec s|j}|j}d}|jr(|d7}|jdkr.) rRrr1rrr4rr_prepared_index_namer@rruZ expressions)rr`rZinclude_table_schemarTrr1rrrrvisit_create_indexs0    zDDLCompiler.visit_create_indexcKs>|j}|jdkrtdd}|jr,|d7}||j|ddS)Nz.DROP INDEX requires that the index have a namez DROP INDEX rTr)rRrr4rrr)rrrTrrrrrvisit_drop_indexs zDDLCompiler.visit_drop_indexcCsX|jdk r|j|j}nd}|r4|r4|j|}nd}|j|}|rT|d|}|SNr)rr1rr format_index)rrrrZ schema_nameZ index_namerrrrs   z DDLCompiler._prepared_index_namecKs d|j|jj||jfS)NzALTER TABLE %s ADD %s)r1r@rRrrBrr`rTrrrvisit_add_constraints z DDLCompiler.visit_add_constraintcKs(d|j|j|j|jjtfS)NzCOMMENT ON TABLE %s IS %s)r1r@rRrXr+commentr#Stringrrrrvisit_set_table_comments z#DDLCompiler.visit_set_table_commentcKsd|j|jS)NzCOMMENT ON TABLE %s IS NULLrrrrrvisit_drop_table_commentsz$DDLCompiler.visit_drop_table_commentcKs.d|jj|jddd|j|jjtfS)NzCOMMENT ON COLUMN %s IS %sT) use_tabler)r1 format_columnrRrXr+rr#rrrrrvisit_set_column_commentsz$DDLCompiler.visit_set_column_commentcKsd|jj|jddS)NzCOMMENT ON COLUMN %s IS NULLT)r)r1rrRrrrrvisit_drop_column_commentsz%DDLCompiler.visit_drop_column_commentcKst|t|dSrrOrrrrvisit_set_constraint_comment sz(DDLCompiler.visit_set_constraint_commentcKst|t|dSrrOrrrrvisit_drop_constraint_commentsz)DDLCompiler.visit_drop_constraint_commentcCsg}|jdk r|d|j|jdk r8|d|j|jdk rR|d|j|jdk rl|d|j|jdk r|d|jdk r|d|jdk r|d|j|jdk r||jrdnd |j dk r||j rd nd d |S) NzINCREMENT BY %dz START WITH %dz MINVALUE %dz MAXVALUE %dz NO MINVALUEz NO MAXVALUEzCACHE %drzNO ORDERZCYCLEzNO CYCLEr) incrementrrZminvalueZmaxvalueZ nominvalueZ nomaxvaluecachercycleru)rZidentity_optionsrrrrget_identity_optionss(           z DDLCompiler.get_identity_optionscKsPd}|jr|d7}||j|j7}|r0||7}||j}|rL|d|7}|S)NzCREATE SEQUENCE rr)rr1rorRr)rr`r rTroptionsrrrvisit_create_sequence)s  z!DDLCompiler.visit_create_sequencecKs$d}|jr|d7}||j|jS)NzDROP SEQUENCE r)rr1rorRrrrrvisit_drop_sequence6szDDLCompiler.visit_drop_sequencecKsj|j}|jdk r|j|}nd}|dkr:td|jd|j|jj|jrTdnd||j rbdndfS)Nzj|}|dk r>|d|7}|d7}|ddfdd|jrd|jn|jD7}||7}|S) Nrr(rz PRIMARY KEY rrc3s|]}j|jVqdSrr1rrrrrrrsz;DDLCompiler.visit_primary_key_constraint..) rrr1rruZ_implicit_generatedZcolumns_autoinc_firstrrrrrrvisit_primary_key_constraints     z(DDLCompiler.visit_primary_key_constraintc s|jd}|jdk r4|j|}|dk r4|d|7}t|jdjj}|ddfdd|jD|||dfdd|jDf7}|| |7}|| |7}|| |7}|S) Nr(rrz"FOREIGN KEY(%s) REFERENCES %s (%s)rc3s|]}|jjVqdSr)rparentrrr1rrrsz;DDLCompiler.visit_foreign_key_constraint..c3s|]}|jjVqdSr)rr^rrrrrrs) r1rrrrr^rrudefine_constraint_remote_tabledefine_constraint_matchdefine_constraint_cascadesr)rr_rTrrZ remote_tablerrrvisit_foreign_key_constraints0    z(DDLCompiler.visit_foreign_key_constraintcCs ||S)z=Format the remote table clause of a CREATE CONSTRAINT clause.)r@)rr_rr1rrrrsz*DDLCompiler.define_constraint_remote_tablec spt|dkrdSd}|jdk r>j|}|dk r>|d|7}|ddfdd|D7}||7}|S)Nrr(rz UNIQUE (%s)rc3s|]}j|jVqdSrrrrrrrsz6DDLCompiler.visit_unique_constraint..)rrr1rrurrrrrvisit_unique_constraints    z#DDLCompiler.visit_unique_constraintcCsLd}|jdk r&|d|j|jt7}|jdk rH|d|j|jt7}|S)Nr(z ON DELETE %sz ON UPDATE %s)Zondeleter1validate_sql_phrase FK_ON_DELETEZonupdate FK_ON_UPDATErr_rrrrrs    z&DDLCompiler.define_constraint_cascadescCsLd}|jdk r&|jr|d7}n|d7}|jdk rH|d|j|jt7}|S)Nr(z DEFERRABLEz NOT DEFERRABLEz INITIALLY %s)rfrrr1r FK_INITIALLYrrrrrs    z+DDLCompiler.define_constraint_deferrabilitycCs d}|jdk r|d|j7}|S)Nr(z MATCH %s)rrrrrrs z#DDLCompiler.define_constraint_matchcKsBd|jj|jddd}|jdkr,|d7}n|jdkr>|d7}|S)NzGENERATED ALWAYS AS (%s)FTrz STOREDz VIRTUAL)rXrBrZ persisted)r generatedrTrrrrvisit_computed_columns   z!DDLCompiler.visit_computed_columncKs2d|jr dndf}||}|r.|d|7}|S)NzGENERATED %s AS IDENTITYZALWAYSz BY DEFAULTr:)alwaysr)rrrTrrrrrvisit_identity_columns   z!DDLCompiler.visit_identity_column)...)NNT)F)N)FT)F)N)3rrrrirrEr$rarXrxrfr~rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrvsr    4  &         rvc@s~eZdZddZddZddZddZd d Zd d Zd dZ ddZ ddZ ddZ ddZ ddZddZddZddZd^d d!Zd"d#Zd$d%Zd&d'Zd(d)Zd*d+Zd,d-Zd.d/Zd0d1Zd2d3Zd4d5Zd6d7Zd8d9Zd:d;Zdd?Z!d@dAZ"dBdCZ#dDdEZ$dFdGZ%dHdIZ&dJdKZ'dLdMZ(dNdOZ)dPdQZ*dRdSZ+dTdUZ,dVdWZ-dXdYZ.dZd[Z/d\d]Z0dS)_GenericTypeCompilercKsdS)NFLOATrrprrr visit_FLOATszGenericTypeCompiler.visit_FLOATcKsdS)NZDOUBLErrprrr visit_DOUBLEsz GenericTypeCompiler.visit_DOUBLEcKsdS)NzDOUBLE PRECISIONrrprrrvisit_DOUBLE_PRECISIONsz*GenericTypeCompiler.visit_DOUBLE_PRECISIONcKsdS)NZREALrrprrr visit_REALszGenericTypeCompiler.visit_REALcKs<|jdkrdS|jdkr&dd|jiSd|j|jdSdS)NZNUMERICzNUMERIC(%(precision)s) precisionz!NUMERIC(%(precision)s, %(scale)s)rZscalerrprrr visit_NUMERICs  z!GenericTypeCompiler.visit_NUMERICcKs<|jdkrdS|jdkr&dd|jiSd|j|jdSdS)NZDECIMALzDECIMAL(%(precision)s)rz!DECIMAL(%(precision)s, %(scale)s)rrrprrr visit_DECIMAL&s  z!GenericTypeCompiler.visit_DECIMALcKsdS)NZINTEGERrrprrr visit_INTEGER1sz!GenericTypeCompiler.visit_INTEGERcKsdS)NZSMALLINTrrprrrvisit_SMALLINT4sz"GenericTypeCompiler.visit_SMALLINTcKsdS)NZBIGINTrrprrr visit_BIGINT7sz GenericTypeCompiler.visit_BIGINTcKsdS)N TIMESTAMPrrprrrvisit_TIMESTAMP:sz#GenericTypeCompiler.visit_TIMESTAMPcKsdS)NZDATETIMErrprrrvisit_DATETIME=sz"GenericTypeCompiler.visit_DATETIMEcKsdS)NZDATErrprrr visit_DATE@szGenericTypeCompiler.visit_DATEcKsdS)NZTIMErrprrr visit_TIMECszGenericTypeCompiler.visit_TIMEcKsdS)NZCLOBrrprrr visit_CLOBFszGenericTypeCompiler.visit_CLOBcKsdS)NZNCLOBrrprrr visit_NCLOBIszGenericTypeCompiler.visit_NCLOBNcCsB|}|r|d|7}n|jr*|d|j7}|jr>|d|j7}|S)N(%d)z COLLATE "%s")lengthr)rrrlength_overriderrrr_render_string_typeLsz'GenericTypeCompiler._render_string_typecKs ||dS)NCHARrrprrr visit_CHARWszGenericTypeCompiler.visit_CHARcKs ||dS)NZNCHARrrprrr visit_NCHARZszGenericTypeCompiler.visit_NCHARcKs ||dS)NZVARCHARrrprrr visit_VARCHAR]sz!GenericTypeCompiler.visit_VARCHARcKs ||dS)NZNVARCHARrrprrrvisit_NVARCHAR`sz"GenericTypeCompiler.visit_NVARCHARcKs ||dS)NZTEXTrrprrr visit_TEXTcszGenericTypeCompiler.visit_TEXTcKsdS)NZBLOBrrprrr visit_BLOBfszGenericTypeCompiler.visit_BLOBcKsd|jrd|jpdS)NBINARYrr(rrprrr visit_BINARYisz GenericTypeCompiler.visit_BINARYcKsd|jrd|jpdS)NZ VARBINARYrr(rrprrrvisit_VARBINARYlsz#GenericTypeCompiler.visit_VARBINARYcKsdS)NZBOOLEANrrprrr visit_BOOLEANosz!GenericTypeCompiler.visit_BOOLEANcKs|j|dddS)Nr )rrrprrr visit_uuidrszGenericTypeCompiler.visit_uuidcKs|j|f|Sr)rrprrrvisit_large_binaryusz&GenericTypeCompiler.visit_large_binarycKs|j|f|Sr)rrprrr visit_booleanxsz!GenericTypeCompiler.visit_booleancKs|j|f|Sr)rrprrr visit_time{szGenericTypeCompiler.visit_timecKs|j|f|Sr)rrprrrvisit_datetime~sz"GenericTypeCompiler.visit_datetimecKs|j|f|Sr)rrprrr visit_dateszGenericTypeCompiler.visit_datecKs|j|f|Sr)rrprrrvisit_big_integersz%GenericTypeCompiler.visit_big_integercKs|j|f|Sr)rrprrrvisit_small_integersz'GenericTypeCompiler.visit_small_integercKs|j|f|Sr)rrprrr visit_integersz!GenericTypeCompiler.visit_integercKs|j|f|Sr)rrprrr visit_realszGenericTypeCompiler.visit_realcKs|j|f|Sr)rrprrr visit_floatszGenericTypeCompiler.visit_floatcKs|j|f|Sr)rrprrr visit_doublesz GenericTypeCompiler.visit_doublecKs|j|f|Sr)rrprrr visit_numericsz!GenericTypeCompiler.visit_numericcKs|j|f|Srrrprrr visit_stringsz GenericTypeCompiler.visit_stringcKs|j|f|Srrrprrr visit_unicodesz!GenericTypeCompiler.visit_unicodecKs|j|f|Srrrprrr visit_textszGenericTypeCompiler.visit_textcKs|j|f|Srrrprrrvisit_unicode_textsz&GenericTypeCompiler.visit_unicode_textcKs|j|f|Srrrprrr visit_enumszGenericTypeCompiler.visit_enumcKstd|dS)NzKCan't generate DDL for %r; did you forget to specify a type on this Column?rrprrrrs zGenericTypeCompiler.visit_nullcKs|j||jf|Sr)rBZ type_enginer:rprrrvisit_type_decoratorsz(GenericTypeCompiler.visit_type_decoratorcKs |jf|Sr) get_col_specrprrrvisit_user_definedsz&GenericTypeCompiler.visit_user_defined)N)1rrrrrrrrrrrrrrrrrrrrrrrrrrrrr r r r r rrrrrrrrrrrrrrrrrrrrrs\   rc@s4eZdZddZddZddZddZd d Zd S) StrSQLTypeCompilercKs>z |j}Wn"tk r,|j|f|YSX||f|SdSr)r\AttributeError_visit_unknown)rrrTr\rrrrBs  zStrSQLTypeCompiler.processcCs|dr|jSt|dS)NZvisit_)rr"r!)rrrrr __getattr__s zStrSQLTypeCompiler.__getattr__cKs(|jj|jjkr|jjSt|SdSr)rLrupperreprrprrrr"sz!StrSQLTypeCompiler._visit_unknowncKsdSrrrprrrrszStrSQLTypeCompiler.visit_nullcKs6z |j}Wntk r&t|YSX|f|SdSr)rr!r%)rrrTrrrrrs  z%StrSQLTypeCompiler.visit_user_definedN)rrrrBr#r"rrrrrrr s r c@seZdZdddddZdS)_SchemaForObjectCallablerr)rYrcCsdSrr)rrYrrrrsz!_SchemaForObjectCallable.__call__Nrrrrrr&sr&c@seZdZdddddZdS)rNrr)rvrcCsdSrr)rrvrrrrsz _BindNameForColProtocol.__call__NrrrrrrNsrNc@seZdZUdZeZeZeZ de d<de d<de d<e dZ de d <dQddZddZddZdddddZdddddZddZdddddZdddddZd d!ZdRdd"dd#d$d%ZdSdd"dd&d'd(Zd)d*ZdTd+d,ZdUd-d.dd/d0d1ZdVd2d.dd3d4d5ZdWd6d7Zed8dXd9d:Z dYd;d<Z!dZd=d>Z"d?d@Z#dAdBZ$d[dCdDZ%dEdFZ&d\dGdHZ'd]dIdJZ(d^dKdLZ)ej*dMdNZ+dOdPZ,d S)_r0z@Handle quoting and case-folding of identifiers based on options.r initial_quote final_quotezMutableMapping[str, str]_stringsr!r&rr!NTFcCsN||_||_|p|j|_||_|jd|_||_||_i|_|jjdk|_ 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. r3)rrN) r:r'r( escape_quoteescape_to_quote omit_schemaquote_case_sensitive_collationsr)rr)rr:r'r(r*r-r,rrrrEs  zIdentifierPreparer.__init__cs2|j|j}|j|jfdd}||_|S)NcsX|j}|krN|jrN|dk r:d|ks,d|kr:td|td|pDdddS|jSdS)NrrzJSquare bracket characters ([]) not supported in schema translate name '%s'z __[SCHEMA_%s]_noneFr)r!Z_use_schema_mapr4rr-)rYrrwrr symbol_getter$s z@IdentifierPreparer._with_schema_translate..symbol_getter)rL__new____dict__rDr)rr.prepr0rrwrr> s  z)IdentifierPreparer._with_schema_translatecs4|dkrdd<fdd}td||S)Nr.cs6|d}|}|s,jj}|s,td|S)Nr3zLDialect has no default schema name; can't use None as dynamic schema target.)rpr:Zdefault_schema_namer4rr)rrrdrrrr:s z=IdentifierPreparer._render_schema_translates..replacez(__\[SCHEMA_([^\]]+)\]))rr)rrr.rrr4rrC5s   z,IdentifierPreparer._render_schema_translates)rrcCs&||j|j}|jr"|dd}|S)zEscape an identifier. Subclasses should override this to provide database-dependent escaping behavior. rr)rr*r+rrrrrr_escape_identifierIs z%IdentifierPreparer._escape_identifiercCs||j|jS)zCanonicalize an escaped identifier. Subclasses should override this to provide database-dependent unescaping behavior that reverses _escape_identifier. )rr+r*r6rrr_unescape_identifierUsz'IdentifierPreparer._unescape_identifiercCs*|dk r&||s&td||jf|S)zkeyword 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 Nz/Unexpected SQL phrase: %r (matching against %r))rr4rr`)rrRrrrrr^s z&IdentifierPreparer.validate_sql_phrasecCs|j|||jS)z~Quote an identifier. Subclasses should override this to provide database-dependent quoting behavior. )r'r7r(r6rrrquote_identifierps z#IdentifierPreparer.quote_identifierrcCs:|}||jkp8|d|jkp8|jt| p8||kS)z5Return True if the given identifier requires quoting.r)rreserved_wordsillegal_initial_characterslegal_charactersrr)rrZlc_valuerrrr}s  z#IdentifierPreparer._requires_quotescCs|jt| S)zjReturn True if the given identifier requires quoting, but not taking case convention into account.)r<rrr6rrrrsz1IdentifierPreparer._requires_quotes_illegal_charsr)r!forcercCs |dk rtjddd||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`. NzThe 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().0.9r)r$rr)rr!r=rrrrs  zIdentifierPreparer.quote_schema)rr=rcCs|dk rtjdddt|dd}|dkrp||jkr>|j|S||rZ|||j|<n ||j|<|j|Sn|r~||S|SdS)aConditionally quote an identifier. The identifier is quoted if it is a reserved word, contains quote-necessary characters, or is an instance of :class:`.quoted_name` which includes ``quote`` set to ``True``. Subclasses can override this to provide database-dependent quoting behavior for identifier names. :param ident: string identifier :param force: unused .. deprecated:: 0.9 The :paramref:`.IdentifierPreparer.quote.force` parameter is deprecated and will be removed in a future release. This flag has no effect on the behavior of the :meth:`.IdentifierPreparer.quote` method; please refer to :class:`.quoted_name`. NzThe 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)r$rrr)rr9)rrr=rrrrs        zIdentifierPreparer.quotecCs|jr||S|SdSr)r-r)rZcollation_namerrrrs z#IdentifierPreparer.format_collationcCs>||j}||}|js:|r:|dk r:||d|}|Sr)rrrr,r)rrrrrrrrros  z"IdentifierPreparer.format_sequencez Label[Any]r)rsrrcCs||p |jSr)rr)rrsrrrrrszIdentifierPreparer.format_labelzOptional[AliasedReturnsRows])rrrcCs.|dkr |dk st||jS||SdSr)rArr)rrrrrrrs  zIdentifierPreparer.format_aliascCs"|p|j}||r||}|Sr)rrr9)rZ savepointrrrrrrXs   z#IdentifierPreparer.format_savepointzsqlalchemy.sql.namingcCs^tjj}|jtkr.|||j}|dkr4dSn|j}|jdkrL|j||dS|j ||dSdS)Nr)_alembic_quote) r$rKZ sql_namingrr)Z_constraint_name_for_tablerr}truncate_and_render_index_name#truncate_and_render_constraint_name)rr_r?Znamingrrrrrs$  z$IdentifierPreparer.format_constraintcCs|jjp|jj}||||Sr)r:Zmax_index_name_lengthr _truncate_and_render_maxlen_namerrr?max_rrrr@(sz1IdentifierPreparer.truncate_and_render_index_namecCs|jjp|jj}||||Sr)r:Zmax_constraint_name_lengthrrBrCrrrrA4sz6IdentifierPreparer.truncate_and_render_constraint_namecCsbt|tjr@t||krL|d|ddt|dd}n |j||sT|S||SdS)Nrr) r@rr@rr$Zmd5_hexr:Zvalidate_identifierr)rrrDr?rrrrB@s  ( z3IdentifierPreparer._truncate_and_render_maxlen_namecCs ||Sr)rrrrrrLszIdentifierPreparer.format_indexcCsF|dkr|j}||}||}|jsB|rB|rB||d|}|S)z'Prepare a quoted table and schema name.Nr)rrrr,r)rrrrrcrrrrr@Os  zIdentifierPreparer.format_tablecCs ||S)zPrepare a quoted schema name.r/rrrrr]sz IdentifierPreparer.format_schemacCs(|dk rt|tjr||}||S)Prepare a quoted column name.N)r@rr@rr)rrrrrrrbs   z$IdentifierPreparer.format_label_namecCs|dkr|j}|dk r,t|tjr,||}t|ddsh|r\|j|j||dd||S||Sn"|r|j|j||dd|S|SdS)rGNrF)rrr) rr@rr@rrr@rr)rr^rrZ table_namerrrrrrps@     z IdentifierPreparer.format_columncCsD||}|js0|r0|r0|||j|ddfS|j|ddfSdS)z(Format table name and schema as a tuple.FrN)rr,rr@)rrrrrrrr{s   z#IdentifierPreparer.format_table_seqcCs@dd|j|j||jfD\}}}td|||d}|S)Ncss|]}t|VqdSr)rrrrrrrsz4IdentifierPreparer._r_identifiers..zM(?:(?:%(initial)s((?:%(escaped)s|[^%(final)s])+)%(final)s|([^\.]+))(?=\.|$))+)initialfinalr7)r'r(r7rr)rrHrIZ escaped_finalrrrr_r_identifierss   z!IdentifierPreparer._r_identifierscs(j}fdddd||DDS)z:Unpack 'schema.table.column'-like strings into components.csg|]}|qSr)r8r0rrrrsz;IdentifierPreparer.unformat_identifiers..cSsg|]\}}|p|qSrr)rarrrrrs)rKfindall)rZ identifiersrJrrrunformat_identifierss z'IdentifierPreparer.unformat_identifiers)r!Nr!TF)N)N)T)N)N)N)T)T)T)TN)N)FNNFN)T)-rrrrRESERVED_WORDSr:LEGAL_CHARACTERSr<ILLEGAL_INITIAL_CHARACTERSr;rrR attrgetterrrEr>rCr7r8rr9rrrrrrorrrXr$rdrr@rArBrr@rrrr{rarKrNrrrrr0sf  $    '4        -  r0)r __future__rrcollections.abcabcr7rbenumrrrRrtimerrjrrrrr r r r r rrrrrrrrrrrr(rrrrrrr r!r"r#r$r_typingr&r'r(r)r*r+r,r-r.r/Ztype_apir0Zvisitorsr1r2r4Z util.typingr5r6r7 annotationr8r9r:r5r;r|r<Zdmlr=r>r?r@rArBrCrDrErFrGrHrIrJrKrLrMrNZ engine.cursorrOZengine.interfacesrPrQrRrSrTrZ_FromHintsTyperOrIrPZLEGAL_CHARACTERS_PLUS_SPACEr5rrQrrrUNICODErrrrror_rmulrmodnegltlenegtgeeqZis_distinct_fromZis_not_distinct_fromZ concat_opr$Z not_match_opr+r*rr"rrrr]existsZ distinct_opinvZany_opZall_opZdesc_opZasc_opZnulls_first_opZ nulls_last_opZbitwise_xor_opZ bitwise_or_opZbitwise_and_opZbitwise_not_opZbitwise_lshift_opZbitwise_rshift_oprrrarbrcrdrzr{rrrrZcubeZrollupZ grouping_setsrrr]Z_CompoundSelectKeywordrZ UNION_ALLrZ EXCEPT_ALLrZ INTERSECT_ALLr^rrrrrrrrrrrrrr r r r  namedtupler r&Z EnsureKWArgrnZBinaryElementRoleZCompilerColumnElementrrrrrervrr r&rNr0rrrr sT                                                                                   a 1   =  (AO&Hg)!