rj"UdZddlmZddlZddlmZddlZddlm Z ddl Z ddl Z ddl Z ddl Z ddlmZddlZddlmZddlmZddlmZdd lmZdd lmZdd lmZdd lmZdd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z ddlm!Z!ddlm"Z"ddlm#Z#ddlm$Z$ddlm%Z%ddlm&Z&ddlm'Z'ddlm(Z(ddlm)Z)ddlm*Z*d d!l+m,Z,d d"l+m-Z-d d#l+m.Z.d d$l+m/Z/d d%l+m0Z0d d&l+m1Z1d d'l+m2Z2d d(l+m3Z3d d)l+m4Z4d d*l+m5Z5d d+l+m6Z7d d,l8m9Z9d d-l8m:Z:d d.l,m;Z;d d/l,mZ>d d2l,m?Z?d d3l/m@Z@d d4l5mAZAd d5lBmCZCd6d7l+mDZDd6d+l+m6Z6d6d8l6mEZEd6d9lFmGZGd6d:lFmHZHd6d;lFmIZIejPrhd dl,mMZMd d?l,mNZNd d@l,mOZOd dAlPmQZQd dBlRmSZSd dClRmTZTd dDlRmUZUd dElRmVZVd dFlWmXZXd dGlWmYZYd dHlWmZZZd dIlWm[Z[d dJlWm\Z\d dKlWm]Z]d dLl/m^Z^d dMl/m_Z_d dNl/m`Z`d dOl/maZad dPl/mbZbd dQl/mcZcd dRl/mdZdd dSl/meZed dTl/mfZfd dUl/mgZgd dVl0mhZhd dWl3miZid dXl3mjZjd dYl3mkZkd dZl3mlZld d[l3mmZmd d\l3mnZnd d]l3moZod d^l3mpZpd d_l3mqZqd d`l4mrZrd dal4msZsd dbl4mtZtd dcl4muZud ddl4mvZvd del4mwZwd dfl4mxZxd dgl4myZyd dhl4mzZzd dil{m|Z|d djl{m}Z}d dkl{m~Z~d dll{mZd dmlBmZd6dnlmZd6dolmZd6dplmZd6dqlmZd6drlmZd6dslmZd6dtlmZd6dulmZd6dvlmZd6dwlmZedxefZhdyZe j dze j"Ze j d{e j"Zedd|Dchc] }e| c}j+d}gZe j d~e j"Ze j d~e j"Ze j de j"Ze j de j"Ze/j6j8Ze j de j<ZdZeddddddZie1jDde1jFde1jHde1jJde1jLde1jNde1jPde1jRde1jTde1jVde1jXde1jZde1j\de1j^de1j`de1jbde1jddie1jfde1jhde1jjde1jlde1jnde1jpde1jrde1jtde1jvde1jxde1jzde1j|de1j~de1jde1jde1jde1jde1jde1jde1jde1jde1jde1jde1jdiZe0jde0jde0jde0jde0jde0jde0jde0jde0jde0jde0jde0jde0jde0jdiZded<ddddddddddddddddќZe4jjde4jjde4jjde4jjde4jjde4jjdiZGd؄deZGdڄde#ZdZded<d Zded<d6Zded<dZded<Gdde)ZGddedZGddeZGddeZGddeZGddeEZGdde ZGdde ZGdde Zee\ZZZZGddejdddgZGddZGdde6jZGdde2jee/jZGdde2jee/jZGdde2jee/jZGddeZGd d eZGd d eZGd deZGddeZGdde#ZGdde#Z GddZ ycc}w(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`. ) annotationsN)IntEnum) perf_counter) AbstractSet)Any)Callable)cast)ClassVar)Dict)Final) FrozenSet)Iterable)Iterator)List)Literal)Mapping)MutableMapping) NamedTuple)NoReturn)Optional)Pattern)Protocol)Sequence)Set)Tuple)Type) TYPE_CHECKING) TypedDict)Union)base) coercions)crud)elements) functions) operators)roles)schema) selectable)sqltypes)util)is_column_element)is_dml) _de_clone) _from_objects) _NONE_NAME) _SentinelDefaultCharacterization)NO_ARG) quoted_name) TupleType)prefix_anon_map)exc) FastIntFlag)Self)TupleAny)Unpack)_AnnotationDict)_AmbiguousTableNameMap) CompileState) Executable)ExecutableStatement)CacheKey)_TableViaSelect) CreateTableAs) CreateView)ExecutableDDLElement)Delete)Insert)Update) UpdateBase)UpdateDMLState) ValuesBase)_truncated_label)BinaryExpression) BindParameter) ClauseElement) ColumnClause) ColumnElement)False_)Label)Null)True_)Function)CheckConstraint)Column) Constraint)ForeignKeyConstraint)IdentityOptions)Index)PrimaryKeyConstraint)Table)UniqueConstraint)_ColumnsClauseElement)AliasedReturnsRows)CompoundSelectState)CTE) FromClause)NamedFromClause) ReturnsRows)Select) SelectState)_BindProcessorType) TypeDecorator) TypeEngine)UserDefinedType) Visitable)CursorResultMetaData)_CoreSingleExecuteParams)_DBAPIAnyExecuteParams)_DBAPIMultiExecuteParams)_DBAPISingleExecuteParams)_ExecuteOptions)_GenericSetInputSizesType)_MutableCoreSingleExecuteParams)Dialect)SchemaTranslateMapTyperd>^asdoinisonortoallandanyascendfornewnotoffoldsetbothcaser descelsefromfullintojoinleftlikenullonlysomethentrueuserwhenarraycheckcrossfalsegrantgroupilikeinnerlimitorderouterrighttableunionusingwherebinarycolumncreateexceptfreezehavingisnulloffsetselectuniqueanalyseanalyzebetweencollatedefaultforeignleadingnaturalnotnullplacingprimarysimilarverbosedistinctoverlapstrailing initially intersect localtime symmetric asymmetric constraint deferrable references current_date current_role current_time current_user session_user authorizationlocaltimestampcurrent_timestampz ^[A-Z0-9_$]+$z^[A-Z0-9_ $]+$ $z5^(?:RESTRICT|CASCADE|SET NULL|NO ACTION|SET DEFAULT)$z^(?:DEFERRED|IMMEDIATE)$z&^(?:CURRENT ROW|GROUP|TIES|NO OTHERS)$z\x5c(:\w*)(?![:\w])z %%(%(name)s)s?z%%sz :[_POSITION]z $[_POSITION]z :%(name)s)pyformatqmarkformatnumericnumeric_dollarnamed AND z OR z + z * z -  % -z < z <= z != 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 COLLATE zEXISTS DISTINCT zNOT zANY zALL z DESCz ASCz NULLS FIRSTz NULLS LASTz ^ z | z & ~z << z >> coalesce CURRENT_DATE CURRENT_TIMECURRENT_TIMESTAMP CURRENT_USER LOCALTIMELOCALTIMESTAMPrandomsysdate SESSION_USERUSERCUBEROLLUPz GROUPING SETSzDict[Type[Function[Any]], str] FUNCTIONSmonthdayyearsecondhourdoyminutequarterdowweekepoch milliseconds microseconds timezone_hourtimezone_minute)rrrrrrrrrrrrrrrUNIONz UNION ALLEXCEPTz EXCEPT ALL INTERSECTz INTERSECT ALLc@eZdZUdZded< ded< ded< ded<y ) 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. strkeynamenameTuple[Any, ...]objectsTypeEngine[Any]typeN__name__ __module__ __qualname____doc____annotations__b/var/www/html/python-recuperauto-other/env/lib/python3.12/site-packages/sqlalchemy/sql/compiler.pyr r zs1L; I%  rr c(eZdZ ddZy)_ResultMapAppendercyNrselfr r rtype_s r__call__z_ResultMapAppender.__call__s rN) r r r r rz Sequence[Any]r rreturnNonerrrr!rrrrrs7     rrz Literal[0]RM_RENDERED_NAMEz Literal[1]RM_NAMEz Literal[2] RM_OBJECTSz Literal[3]RM_TYPEc,eZdZUded<ded<ded<y)_BaseCompilerStackEntryzSet[FromClause] asfrom_fromscorrelate_fromsrfr)Nrrrrrrrr+r+s!!$$rr+c@eZdZUded<ded<ded<ded<ded <y ) _CompilerStackEntryr> compile_stateboolneed_result_map_for_nestedneed_result_map_for_compoundrfselect_0Select[Unpack[TupleAny]]insert_from_selectNr.rrrr0r0s  $$"&&00rr0F)totalcreZdZUdZded< ded< ded< ded < d ed < edd Zedd Zy) 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  statementro parameters%Mapping[str, _BindProcessorType[Any]] processorsOptional[Sequence[str]] positiontupzMapping[str, List[str]]parameter_expansioncjtjdtfdjDS)zrTuple of positional parameters, for statements that were compiled using a positional paramstyle. z.statement does not use a positional paramstylec3<K|]}j|ywrr<).0keyrs r z6ExpandedState.positional_parameters..sFcT__S)F)r@r7InvalidRequestErrortuplers`rpositional_parametersz#ExpandedState.positional_parameterss@    #))@ FT5E5EFFFrc|jS)z.synonym for :attr:`.ExpandedState.parameters`.rDrKs radditional_parametersz#ExpandedState.additional_parameterssrN)r"r )r"ro)rrrrrpropertyrLrNrrrr:r:si"N=((65+((10 G Grr:ceZdZUdZded< ded< ded< ded < d Zded < d Zded < d Zded< dZded< d Z ded< d Z ded< d Z ded< d Z ded<y )_InsertManyValuesarepresents state to use for executing an "insertmanyvalues" statement. The primary consumers of this object are the :meth:`.SQLCompiler._deliver_insertmanyvalues_batches` and :meth:`.DefaultDialect._deliver_insertmanyvalues_batches` methods. .. versionadded:: 2.0 r2is_default_exprr single_values_exprzList[crud._CrudParamElementStr]insert_crud_paramsintnum_positional_params_countedFsort_by_parameter_orderincludes_upsert_behaviorsNOptional[Sequence[Column[Any]]]sentinel_columnsrnum_sentinel_columnsr?sentinel_param_keysimplicit_sentinelhas_upsert_bound_parametersembed_values_counter) rrrrrrWrXrZr[r\r]r^r_rrrrQrQs 87M#&& %*T)',t+9=5<!"#!4807 $t# ).- "'$& rrQcveZdZUdZded<ded<ded<ded <d ed <d ed <d ed<d ed<ded<ded<y)_InsertManyValuesBatchasrepresents an individual batch SQL statement for insertmanyvalues. This is passed through the :meth:`.SQLCompiler._deliver_insertmanyvalues_batches` and :meth:`.DefaultDialect._deliver_insertmanyvalues_batches` methods out to the :class:`.Connection` within the :meth:`.Connection._exec_insertmany_context` method. .. versionadded:: 2.0.10 r replaced_statementrpreplaced_parameters#Optional[_GenericSetInputSizesType]processed_setinputsizesz#Sequence[_DBAPISingleExecuteParams]batchzSequence[Tuple[Any, ...]]sentinel_valuesrUcurrent_batch_sizebatchnum total_batchesr2 rows_sorted is_downgradedNrrrrrarazsD //@@ ....MrracLeZdZdZdZdZdZdZdZeezezezZ ee zZ dZ dZ y ) InsertmanyvaluesSentinelOptszcbitflag enum indicating styles of PK defaults which can work as implicit sentinel columns r r6 @N) rrrr NOT_SUPPORTED AUTOINCREMENTIDENTITYSEQUENCEMONOTONIC_FUNCTIONANY_AUTOINCREMENT_SUPPORTED_OR_NOTUSE_INSERT_FROM_SELECTRENDER_SELECT_COL_CASTSrrrrnrnsW MMHH  8+.@@&(99 rrnc eZdZdZdZ dZ dZy)AggregateOrderByStyleztDescribes backend database's capabilities with ORDER BY for aggregate functions .. versionadded:: 2.1 rr r6N)rrrrNONEINLINE WITHIN_GROUPrrrr~r~s' D: FL1rr~ceZdZdZ dZ dZy) CompilerStaterr r6N)rrr COMPILINGSTRING_APPLIED NO_STATEMENTrrrrrs I=N Lrrc,eZdZdZdZ dZ dZ eezZy)Lintingzrepresent preferences for the 'SQL linting' feature. this feature currently includes support for flagging cartesian products in SQL statements. rr r6N)rrrr NO_LINTINGCOLLECT_CARTESIAN_PRODUCTS WARN_LINTING FROM_LINTINGrrrrrs5J!"L2- .s"NDTdjj&6"67N") fromsredgesremovepop collectionsdequepopleftdiscard extendleftdifference_update) rstartrrthe_rest start_withstackr to_removers @rlintzFromLinter.lints DJJu:  J OOJ '!J!!:,/==?D   T " +0@$44<@I@   NIN N  # #I . Z' 'As  C Ccj\}}|rX|}|rSd}djfd|D}|j||j|}t j |yyy)Nz{stmt_type} statement has a cartesian product between FROM element(s) {froms} and FROM element "{start}". Apply join condition(s) between each element to resolve.rc3DK|]}dj|dyw)"N)r)rEfrom_rs rrGz"FromLinter.warn..s)&16a 5)*!,& ) stmt_typerr)rrrrr+warn)rrrrrtemplate froms_strmessages` rrzFromLinter.warns#yy{* E7 !II&:?& #//'#**Z0*  '"! rr)SELECT)rrrrrrrrrrrs#J#rrrrceZdZUdZdZded< dZded< ded < d Zd ZdZ d ed <dZ d ed<dZ ded<e jZded< ded<e jZded<dZded< dZded< dZded< ded< dd e j&f d'dZd(fd Zed Zd!Zed)d"Zd*d#Zd+d$Z d, d-d%Zed&ZxZS).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. NOptional[ClauseElement]r;r stringrstateFzOptional[CursorResultMetaData]_cached_metadataz"Optional[List[ResultColumnsEntry]]_result_columns Optional[SchemaTranslateMapType]schema_translate_maprsexecution_optionsIdentifierPreparerpreparerr< _annotationszOptional[CompileState]r1dml_compile_stateOptional[CacheKey] cache_keyfloat _gen_timec||_|jj|_|r'||_|jj ||_|t j |_||_|j|_ |j|_ |jr)trt|tsJ|j|_|j"|jfi||_|r/|J|jj'|j$||_t j(|_nt j*|_t-|_y)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 .. seealso:: :ref:`schema_translating` :param compile_kwargs: additional kwargs that will be passed to the initial call to :meth:`.Compiled.process`. N)dialectidentifier_preparerrr_with_schema_translaterrrr;supports_execution can_executerr isinstancer?_execution_optionsrprocessr_render_schema_translatesrrrrrrr;rrender_schema_translatecompile_kwargss r__init__zCompiled.__init__~s4  88 (O7>=A:A)-8 ! $(OOL/3,0M)0 15-4 %)I!( BF(-,>D,>,>,@ 7(7(+7(? 7( "& 7( * 7(r+  L$$66:GK! $2 $E $ $ 3 $''rrc<eZdZdZdZddZddZ d dZy) TypeCompilerz2Produces DDL specification for TypeEngine objects.z visit_\w+c||_yr)r)rrs rrzTypeCompiler.__init__s  rc |jrE|jj|jvr#|j|jj}|j|fi|Sr)_variant_mappingrr rrr rs rrzTypeCompiler.processsU  " " !!U%;%;;**4<<+<+<=E'u''333rc 0tj|||r)r7rrs rrz*TypeCompiler.visit_unsupported_compilations--dG<#ErN)rrv)r rrrr"r )rrr Exceptionrrr"r)rrrr ensure_kwargrrrrrrrrs><L4FF!*F25F FrrcFeZdZdZdZdZd dZedZedZ dZ y) _CompileLabelz;lightweight label object which acts as an expression.Label.labelrr  _alt_namesc6||_||_|f|z|_yrr)rcolr  alt_namess rrz_CompileLabel.__init__ s  &9,rc.|jjSrr proxy_setrKs rrz_CompileLabel.proxy_set||%%%rc.|jjSrrrrKs rrz_CompileLabel.type||   rc |Srrrrs r self_groupz_CompileLabel.self_group rN)r) rrrr__visit_name__ __slots__rrOrrrrrrrrsDFN/I- &&!!rrcPeZdZdZdZdZdZdZedZ edZ dZ dZ y ) aggregate_orderby_inlinez2produce ORDER BY inside of function argument listsraggregate_order_byc ||_||_yrr$)rrorderbys rrz!aggregate_orderby_inline.__init__%s ")rc,t|jSr)iterrrKs r__iter__z!aggregate_orderby_inline.__iter__)sDLL!!rc.|jjSrrrKs rrz"aggregate_orderby_inline.proxy_set,rrc.|jjSrrrKs rrzaggregate_orderby_inline.type0rrc |Srrrs rrz#aggregate_orderby_inline.self_group4rrc`t|jj||jSr)r#r_with_binary_element_typer%rr s rr/z2aggregate_orderby_inline._with_binary_element_type7s*' LL 2 25 9  # #  rN) rrrrr r!rr*rOrrrr/rrrr#r#sM=/N/I*"&&!! rr#cJeZdZdZdZdZdZedZedZ dZ dZ y ) 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 ilike_case_insensitive_operandr comparatorc4||_|j|_yrr4)rrs rrzilike_case_insensitive.__init__Os !,,rc.|jjSrrrKs rrz ilike_case_insensitive.proxy_setSrrc.|jjSrrrKs rrzilike_case_insensitive.typeWrrc |Srrrs rrz!ilike_case_insensitive.self_group[rrcJt|jj|Sr)r2rr/r0s rr/z0ilike_case_insensitive._with_binary_element_type^s!% LL 2 25 9  rN) rrrrr r!rrOrrrr/rrrr2r2>sJ 6N'I-&&!! rr2ceZdZUdZeZejdddddddddZde 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< ejJZ&d?e d@<dAe dB< dZ' dZ( dZ)dCe dD< dZ*d6e dE< dZ+d6e dF<dZ,d6e dG<dZ-de dH<dIe dJ<dKe dL<dMe dN<de dO<e.j^dPZ0e.j^dQZ1e.j^e1jddRe0jdZ3e.j^dSe1jdZ4e.j^dSe3jdZ5dTe dU<dVe dW<e6dXZ7e6dYZ8ddde9df dd[Z:e;dd\Ze;d^Z?e;d_Z@e;d`ZAejddaZCddbZDejd dcZFeGjddZIdeZJdfZKej d!dgZLejd"dhZMdiZNe;d#djZO d$ d%dkZP d& d'dlZQejdmZRe;dnZS d( d)doZTejdpdqZVdre ds<ejd*dtZWejejdudvZXejejdudwZYd+dxZZ d,dyZ[d(dzZ\d{Z] d(d|Z^ d(d}Z_ d-d~Z`dZadZb d. d/dZcdZddZedZfdZgdZhdZid0dZjdZkd0dZl d1dZmd2dZnd3dZod4dZpdZqdZrdZsdZtdZudZvdZwdZxdZydZzdZ{dZ|dZ}dZ~dZdZdddZdZdZ d0 d5dZdZdZd6dZ d7dZdZdZdZ d,dZdZdZdZdZdZdZdZdZ d0dZdZ d8dZdZdZdZdZdZ d( d9dZdZdZejdZdZdZd„ZdÄZdĄZdńZdƄZdDŽZdȄZdɄZdʄZd˄Zd̄Zd̈́Zd΄ZdτZdЄZdфZd҄Z d:dӄZ d:dԄZ d:dՄZdd֜dׄZ d;d؄ZdلZedfdڄZ ddބZd?d߄Z d@ dAdZdZdddddeÐjdf dBdZdZdZ dCdZdZdZʐd(dZdZ dDdZdZdZ dEdZ d0dZ dFdZdZdZ dGdZdZdZde d<eؐjs"ejde"fde"fgZ d(dZ dHdZdZdZe d< dIdZ dJdZdZdZdZ d1dZdZdKdZdZdZdZ dLdZdZ dMd Z dNd Zd7d Zd ZejejejejejejejejejejejejejiZejejejiZ dOd Z dPdZ dQdZdZdZ dRdZ dSdZ d0 dTdZdZdZd0dZdZdZdZ y(Urz~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_charsTFr2isdeleteisinsertisupdatezOptional[List[Column[Any]]] postfetchrzSequence[Column[Any]]insert_prefetchupdate_prefetchN&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_stringOptional[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_nameszSet[str]_escaped_bind_names_usedzbOptional[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|z%%|z Final[bool]_collect_paramszutil.immutabledict[str, Any]_collected_paramsc$|jyr)_init_bind_translaters rrzSQLCompiler._init_compiler_clss   "rctjdj|j}tjd|d|_|j|_y)NrrFrG)reescaperrIcompilerJrK)rregs rrzz SQLCompiler._init_bind_translatesFii > >?@!#auAJ!7$'$B$B!rrc ||_||_|r:|dD cic]} | j| } } |dD cic]} | | g} } | | f|_||_||_i|_tj|_ g|_ g|_ |j|_ |jrH|jjdx|_} | r|jdk(rdnd|_t"|_nt&|j|_d|_|j*xs |j,|_t/|_i|_i|_|sd|_tj8|_nd|_t=j>|||fi||j@s|jBs |jDrtFrtI|tJsJ|j@s |jBrmtFrtI|tLsJ|jNrd|_(nA|jr5|j@r"|jRjTr|jVrd|_(t&|j|_,|rK|jZj]|jZj_D cic] \} }| d vr| |c}} |j`tbjdurm|jr-|jr|jgn|ji|jjr'|jmdd }|jo|d yyycc} wcc} wcc}} w) 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. r rrrrDNTF>rrr positionalrZrar[r_no_postcompile)_populate_self)8 column_keysrrFrnfor_executemanylintingrUr+ column_dictrVrrr paramstyle startswithrar\_pyformat_templater[BIND_TEMPLATESrr label_lengthmax_identifier_lengthr5anon_maptruncated_names_truncated_countersrwrrxrrrMrNrLrrrIrK_inlinerqrinsert_executemany_returning_return_defaultsrZ__dict__updateitemsrrr_process_numeric_process_positionalrbr#_process_parameters_for_postcompile)rrr;rrrr_supporting_againstrbcksmckbmnbkvr<s rrzSQLCompiler.__init__s@'" &/l3AEE1H3D3$-aL1qAsF1D1*.D & /  **, !",, ??'.'9'9'D'DY'O OD ""--1AACs3-?D ),:7;M;M,ND )   AG$A$A  () <>35 #'D %)__D "#(D $=f= ==DMMT]]!)Z888}}  %i<<<$$"&DK))  AA%66#'DK*7+=+=>  MM !4 < < B B D 1 qD  " ::55 5&&))+,,.''!22!&$(3 88t9 ( 6C41` sL5 L:L? cH|jy|jjS)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. .. 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)rhrSrKs rinsert_single_values_exprz%SQLCompiler.insert_single_values_exprAs%  ! ! )))<< >,B==$Q' sA*c|jS)zVbackwards compatibility; returns the effective_returning collection. )rrKs r returningzSQLCompiler.returningks '''rcb |jddS#t$r}td|d}~wwxYw)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. r)z$Compiler does not have a stack entryN)r IndexError)ries rcurrent_executablezSQLCompiler.current_executabless;" M::b>,/ / MCD" L Ms . ).cXt|jt|jzSr)listrPrQrKs rprefetchzSQLCompiler.prefetchs#D(()D1E1E,FFFrciSrrrKs r_global_attributeszSQLCompiler._global_attributess rcZ|jr|j|jz|_yyr)_paramsrx)ritems r_add_to_paramszSQLCompiler._add_to_paramss' <<%)\\D4J4J%JD " rcftj}||_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+ OrderedDictrrrsrtru)rrrs r_init_cte_statezSQLCompiler._init_cte_states:*.)9)9); #%"$# rc#hK|j|j}}gdc|_|_ |jr|jd}d|d<nd}|j|jf|r|jd||c|_|_y#r|jd||c|_|_wxYww)z;special API to support the use case of 'nested result sets'FrTr3N)rr_rr)rresult_columnsordered_columnsentrys r_nested_resultzSQLCompiler._nested_results   ! !(79%3d3 zz 26:23&&(=(== = 67 8D $"7 67 8D $"7s(B2=B (#B2 $B//B2c N |jrJ|jtjusJ|jrJ|j j dk(rd n|j j dk(sJd g |j|jrQ|jjDcic]\}}|| c}} t|jt k(sJi |jjr |j}n |j}d  fd }tj |||j"|_ r& Dcgc]} j%||c}|_n |_|j&rg tj |||j&j(}|j&j*Dcgc])}|d|dtj |||d|d f+}}|j&j-|| |_yycc}}wcc}wcc}w) Nr%srrc@|jd}|r8j||vr|jdSj|S|jdr1j|jd|jdS|jdS)Nr rr6)rgetappend)m normal_bindrU placeholder positionsreverse_escapes r find_positionz6SQLCompiler._process_positional..find_positions''!*K!%%k;?uL771:%  -""  ,wwqz!wwqz!rrr r6r(rSrT)rz re.Match[str]r"r )r@rrrrarrrUrlrlenr_double_percents_pct_escaped_positional_pattern_positional_patternr|subrrrhrSrT_replace) rrrpositional_patternrr rSrTrUrrrs @@@@rrzSQLCompiler._process_positionals####zz]99999&&&& << " "h .K<<**g5 55K    " "/3/F/F/L/L/NOtq!adONt../3~3FF FFN == ) )!%!E!E !%!9!9  " " ff/ L ;D 37""4. D  )D   ! !I!#"&&99" //BB" aDaDFF-}adCaD " "&*%;%;%D%D#5#5&E&D "% "GP: "s/ H H.H"c jsJjtjusJd}i jr\j Pt jfdjjDjj}njj}|D]R}| vrj|}|jvs|jvrd |<9j|}|dz }| |<T|_t _j"rYt% } j'Dcic]"\}}j"j)|||$c}} t% |k(sJj*j,r j.} n j0} | j3 fdj4_jrljj6 z} jj8D cgc]} | d| dd| df} } jj;| | _yycc}}wcc} w)Nr c3>K|]}|jvr|ywr)ro)rEr rs rrGz/SQLCompiler._process_numeric..s'4#9#99cdj|jd|jdSNr rrrr param_poss rz.SQLCompiler._process_numeric..Js"immAGGAJ ;rrrr(r)rarrrrhro itertoolschainrVvaluesrUrkrjr\next_numeric_posrr@rlrrrrr_pct_escaped_pyformat_pattern_pyformat_patternrrrSrTr)rnumr bind_namebindph len_beforer pospyformat_patternrSrrTrs` @rrzSQLCompiler._process_numericsk""""zz]99999$&  ! !d&<&<&HOO $ 6 6 8 &&( EOO**,E *II%::i(D0004666(, )$;;Z/ // == ) )#AA #55 '** ;T[[    ! !&&99 //BB"1qtT1Q4(" " &*%;%;%D%D#5#5 &E&D " "#0"s 'IIcffdjDDcic] \}}||| c}}Scc}}w)Nc 3:K|]}|jvrj||jjs%|jj j n5t fdtt|jjDfyw)c3TK|]}|jj!ywr)_cached_bind_processorr)rE elem_typers rrGz9SQLCompiler._bind_processors...ps(# )&<.jsD$?$??'OOI. )~~<<"==dllK"#-1 )9>>.#e # sBB)rV)rrFvalues` r_bind_processorszSQLCompiler._bind_processors`sC"& U. 1 J   s-ct|jjj|j|jjS)aNames that the individual elements of an expanding parameter may not take when the parameter is expanded at execution time. This is every bound parameter name in the statement, both in its compiled and in its escaped form. See :ticket:`13695`. ) frozensetrVrrrlrKs r_expanded_bind_names_reservedz)SQLCompiler._expanded_bind_names_reservedsC//1288  # #T%<%<%C%C%E  rc2t|jdkDSNr )rrrKs r is_subqueryzSQLCompiler.is_subquerys4::""rc|SrrrKs rrzSQLCompiler.sql_compilers rcL|j||d}|j|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)rr)rrrr<s rconstruct_expanded_statez$SQLCompiler.construct_expanded_states:** % + 77   rc$||jrJ|jr |j}|r |s|}ni||}|jrF|sD|jJ|st |jj St jd|xrt|j}|rq|jt jd|jd} |j} | J| \} } t| |D cic]\} }| | D]}||}}} }nd}|ri}|jjD]\}}|r|jj!||n|}|j"|vr||j"||<G||vr ||||<T|rX|j$rL|r&t jd|j"|fzdt jd|j"zd|r|j!||}n|}|j&r|j(||<|j*||<|Si}|jjD]\}}|r|jj!||n|}|rX|j$rL|r&t jd|j"|fzdt jd|j"zd|r|j!||}n|}|j&r|j(||<|j*||<|Scc}}} w) 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_paramsr z@A value is required for bind parameter %r, in parameter group %dcd3x)codez)A value is required for bind parameter %r)rwrxrbrcdictr<r7rIr2rlr CompileErrorrnziprVrrrFrequiredcallableeffective_valuer)rrrr _group_number_checkrrxhas_escaped_namesorig_extracted ckbm_tuplerr@r extractedrresolved_extractedpdrr  escaped_name value_params rrzSQLCompiler.construct_paramss  (++ ++  ! ! $ 6 6  *8-88  # #O44@ @@D==HHII--4)JT$2I2I-J ~~%&&J "&!233J) )) GD!%(8L$M"" Ay G"i"" " "&  B#'??#8#8#:% = 4)++//d; ==F*'-imm'.lookup_typeCsH009HHOF""*fM.I"*f .E r) rinclude_set_input_sizesexclude_set_input_sizesrrjrVrrr r4r) rr inputsizesrjrrrrrrs @@@@r_get_set_input_sizes_lookupz'SQLCompiler._get_set_input_sizes_lookup:s,,77 77    !%!DD) $) 9% )4INN(C 9% D)sC c&|jdS)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)rrrKs rrzSQLCompiler.paramsas$$E$22rcD !i}|j}| |j}|jrg}|j}||j}ndx}}|j }t d|!t d|}i} i i} t|j} d} |jr||} |jrg} n|jj} |j}| D]|r|jn}|j}||jvr*| vr%|j!||j#| |<a||j$vr| vr| |}d}n5|j#}|j'|||| }|\}}|| |<| |<|j(r|j+||j,j.r9|vrP|t1| j+fdt3|Dn| j+!fd|D| | j5d|Dn||j5d |D|Dcgc]\}}| c}}|<||j7 fd }t9j:|j<||}| |Jt3| |j>Dcic]\}}||j@|c}}|jBjDr |jF}n |jH}|j;fd |}|j5| tK||| ||}|rR||_||_|jL|_|jrtO|jxsd nd|_||_(|Scc}}wcc}}w) 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. Nr=z/Mapping[str, Sequence[_BindProcessorType[Any]]]render_literal_value) taken_namesc3NK|]\}\}}|z ||zfywrr)rEidxrFr@element_processorsrs rrGzBSQLCompiler._process_parameters_for_postcompile..s?2$1C#q#5cCi#@#L"%&8s&C D2s"%c3:K|]\}}vr |fywrr)rErFr@r single_processorss rrGzBSQLCompiler._process_parameters_for_postcompile..s1. &Q#'88!"3D"9:.c3&K|] \}}| ywrrrEr r@s rrGzBSQLCompiler._process_parameters_for_postcompile..s3%,T1D3c3&K|] \}}| ywrrr)s rrGzBSQLCompiler._process_parameters_for_postcompile..s.Mat.Mr*c|jd}|}|jdrU|jdjd}|d|dcdjfd|jdD}|S)Nr r6~~r(rc3.K|] }|ywrr)rEexpbe_leftbe_rights rrGz]SQLCompiler._process_parameters_for_postcompile..process_expanding.. s !!(h7!s)rsplitr)rrFexprtokr0r1replacement_expressionss @@rprocess_expandingzJSQLCompiler._process_parameters_for_postcompile..process_expanding s~''!*C*3/Dwwqzggaj&&t,$'FCF!yy!#zz$/!Krcdj|jd|jdSrrrs rrzASQLCompiler._process_parameters_for_postcompile..* s")-- AGGAJ?rr))rerrrgr@rr rrrarVrrlrrUrjrender_literal_bindparamrrk$_literal_execute_expanding_parameterliteral_executerrrr enumerateextendrr|r_post_compile_patternrr\rrrrr:r;rrc)"rr<rexpanded_parameterspre_expanded_stringnew_positiontuppre_expanded_positiontupr>tuple_processorsnew_processorsto_update_setsexpanded_taken_namesnumeric_positiontupnamesebnr  parameter to_updaterleep_resreplacement_expr expand_keyr@r6r;rrFrexpanded_stater$r rr5r&s" ` @@@@@rrz/SQLCompiler._process_parameters_for_postcompilens7$!#77  &"&++  ?? O'+'E'E $'/+/+;+;(:> =O6**  3Z  =z >@24)+*-  . .* 48 ??7C#;E""&(#OO**,E%%K -D253774.4L 4(ID777'>>55%1; 1M6,L9 D444#:: .| y5I2 '--.*3. +6+223093)4(...M9.MM8A1'4z1 1'-!,&&t,WK -Z FF  & &(9;N   *". ..!*')>)>!C;;._autoinc_getterz s)",..i"HK". +* )(rcjfdDSfdDS)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. c34K|]\}}|ywrr)rErXrr<s rrGzWSQLCompiler._inserted_primary_key_from_lastrowid_getter..get.. sL[VSfZ0Lc3VK|] \}}|ur  n n|"ywrr)rErXr autoinc_colautoinc_getterr]r<s rrGzWSQLCompiler._inserted_primary_key_from_lastrowid_getter..get.. sJ $+- .9+9jA!*$J/ 0 &)r)r]r<rerfgetterslastrowid_processorrow_fns``rrzDSQLCompiler._inserted_primary_key_from_lastrowid_getter..get sH#./ :  LGLLL (/   r)r+rP engine_resultrYr1r;rrrGr primary_keyoperator methodcaller_autoincrement_columnr_cached_result_processorrrU result_tuplerF)rresultparam_key_getterr;rrr`rrerfr_rhrirjs @@@@@@r+_inserted_primary_key_from_lastrowid_getterz7SQLCompiler._inserted_primary_key_from_lastrowid_getterV sB--==!!---&&00 i0 00((  " "5*:3*? F L  11  ""-"2"2"K"K d# +;7Kdjj( )"1#' $$9J9J%K#cgg%KL  4 G N&Ls &EEc  tjj}|jJ|jj}t rt |tsJ|j}|j}|j}|Jt|Dcic]\}}|| }}}td|jDcgc]?}||vrtj||dfntj d||ddfAc} |j#|jDcgc]}|j$c} fd} | Scc}}wcc}wcc}w)Nz'List[Tuple[Callable[[Any], Any], bool]]TrFc,fdDS)Nc3HK|]\}}|r|n|ywrr)rErXuse_rowr<rows rrGzWSQLCompiler._inserted_primary_key_from_returning_getter..get.. s-#FG 's F:,>>rr)ryr<rhrjs``rrzDSQLCompiler._inserted_primary_key_from_returning_getter..get s'. r)r+rPrkr1r;rrrGrYrrSr;r rlrm itemgetterrnrqrF) rrrr;rsrrr#rretrrhrjs @@r+_inserted_primary_key_from_returning_getterz7SQLCompiler._inserted_primary_key_from_returning_getter sO--!!---&&00 i0 00==++ $$$(1)(<=HCsCx== 5!,, cz((S2D9!--!#3C#8$   "$$9J9J%K#cgg%KL   7> &Ls D93AD? Ecy)zCalled when a SELECT statement has no froms, and no FROM clause is to be appended. Gives Oracle Database a chance to tack on a ``FROM DUAL`` to the string output. rrrKs r default_fromzSQLCompiler.default_from src  |||fz }||d<||d<|jj|fi|}|jD]C}||jvr|j|}|j |j|j dd}|j |} |x|j|<|j| <| |j |<|j j|d||jvr|xj|hzc_||jvr|xj|hzc_ |j} | s| \} } |jD]4}|j | vs| |j } | | j|6F|S)aSQL compile the nested element of an _OverrideBinds with bindparams swapped out. The _OverrideBinds is not normally expected to be compiled; it is meant to be used when an already cached statement is to be used, the compilation was already performed, and only the bound params should be swapped in at execution time. However, there are test cases that exericise this object, and additionally the ORM subquery loader is known to feed in expressions which include this construct into new queries (discovered in #11173), so it has to do the right thing at compile time as well. Nadd_to_result_mapresult_map_targetsTF) maintain_keyr) rr translaterU _with_valuerFrVrrkrjrn _cloned_setr)roverride_bindsrrrsqltextrbpnew_bpr r rrcbs rvisit_override_bindsz SQLCompiler.visit_override_binds s,  ( >"3 3 &7B" #'9B# $<.((;;DGBG ))" 0A "AB^^((0!$F ??2&D/5 5DJJqMDJJt,&*DOOF # OO  D )T---((VH4(T000++x7+33J' d..0Bvv~!"&&\R/0?" 0Hrc Hd|jj|fi|zdzSNrBrCrr)rgroupingasfromrs rvisit_groupingzSQLCompiler.visit_grouping1 +8X%%88HHH3NNrc Hd|jj|fi|zdzSrr)rrrs rvisit_select_statement_groupingz+SQLCompiler.visit_select_statement_grouping4 rrc |jr|jjr td|jdd}|j\}}}|r|} n|} |jj} | E| j| vr7| j| | jr|jj|d<|j|jfd|i|S#t$r}t j d|d}~wwxYw)N'Union[SelectState, CompoundSelectState]rr1ECan't resolve label reference for ORDER BY / GROUP BY / DISTINCT etc.render_label_as_labelwithin_columns_clause) rrsupports_simple_order_by_labelr KeyErrorr7r_label_resolve_dictr_order_by_label_elementr shares_lineager) rrrrr1ke with_cols only_froms only_cols resolve_dict order_by_elems rvisit_label_referencez!SQLCompiler.visit_label_reference7 s ::$,,EE  $=JJrN?3! 11  $) ( $OOCCM)!&&,6!00 !3!34 OO;;./t|| OO "7   A &&/ sC C7C22C7c >|js|j|jS td|jdd}j\}}} |r||j} n||j} | |d<|j| fd|i|S#t$r;}t j |jdtj|Yd}~d}~wwxYw#t$r;} t j |jdtj| Yd} ~ yd} ~ wwxYw)Nrrr1r)extraexc_clsrrr) rr _text_clauser rr"_no_text_coercionrr7rr) rrrrr1rrrrrrs rvisit_textual_label_referencez)SQLCompiler.visit_textual_label_referencef s*zz<< 4 45 5  9 2/M,9+L+L( :y $ 10/2F* +4<<+@DJ ;   ' '/((   "   ' '/((   s/B!C C1CC D!1DDc v|rtjd|xr| } ||u} | s| rMt|jtj r|j d|j} n |j} | r|1| |j|| f|jz|z|j|jj|fddd|ttjz|jj| zS| r|jj| S|jj|fddi|S)NzUsing label() directly inside tstring is not supported as it is ambiguous how the label expression should be rendered without knowledge of how it's being used in SQLcolidentT)rwithin_label_clauserF)r7rrr r$rL_truncated_identifierrrrr OPERATORSr&as_r format_label) rrrrrrrwithin_tstringrrender_label_with_asrender_label_only labelnames r visit_labelzSQLCompiler.visit_label s] ""K  " =*=&= 2U:  4%**h&?&?@ 66z5::N !JJ  ,!JJI&)9)99? ==--eY? ?35==33,157 rc,tjd)Nz:Cannot compile Column object until its 'name' is assigned.r7rrrs r_fallback_column_namez!SQLCompiler._fallback_column_name s H  rc @|j}|j|fi|Sr) _resolvedr)rrr sql_elements rvisit_lambda_elementz SQLCompiler.visit_lambda_element s#'' t||K.2..rc Z|jx}}||j|}|j} | s,t|tj r|j d|}|C|||jf|z} |jr| |jfz } |||| |j| r|j|}n|jj|}|j} | |r | js|S|jj| } | r|jj!| dz} nd} t"rt| t$sJ| j}| s |r ||vr||}t|tj r|j d|}| |jj|zdz|zS)NrrEralias)r r is_literalrr$rLrrF _tq_labelrescape_literal_columnrquoternamed_with_columnschema_for_object quote_schemarre)rrr include_tablerambiguous_table_name_maprr  orig_namertargetsreffective_schema schema_prefix tablenames r visit_columnzSQLCompiler.visit_column s";;&y <--f5D&& jx/H/HI--j$?D  (tVZZ03EEGF,,.. dIw D --d3D==&&t,D  = U5L5LK#}}>>uE MM../?@3F!# !%999 I%,!994Y? )X%>%>? 66w J  4==#6#6y#AACG$N Nrc b|jj|j|jSr)rformat_collation collationcollation_schemarrrs rvisit_collationzSQLCompiler.visit_collation s*}}--   w77  rc |jSrr )r fromclausers rvisit_fromclausezSQLCompiler.visit_fromclause s rc |jSrr)rrrs r visit_indexzSQLCompiler.visit_index s zzrc ||d<|j|d<|jjj|jfi|S)Ntype_expressionr)rrtype_compiler_instancerr)r typeclausers rvisit_typeclausezSQLCompiler.visit_typeclause sJ * $(MM !:t||22:: OO !  rcV|jjr|jdd}|SNrA%%rrreplacertexts rpost_process_textzSQLCompiler.post_process_text! $ == ) )<<T*D rcV|jjr|jdd}|Srrrs rrz!SQLCompiler.escape_literal_column& rrc 6jrjfd}jsd_|r|ddftj t jdtj|jjS)Nc|jd}|jvr jj|fiSj|fiSr)r _bindparamsrbindparam_string)rr rr textclauses r do_bindparamz2SQLCompiler.visit_textclause..do_bindparam/ sW771:Dz---#t||J$:$:4$@GBGG,t,,T8R88rTc$|jdSr)r)rs rrz.SQLCompiler.visit_textclause..A saggajr) rwrrrTr*NULLTYPEBIND_PARAMS_ESCr BIND_PARAMSrr)rrrrrs`` ` rvisit_textclausezSQLCompiler.visit_textclause+ s       + 9zz#D   dD:-9J9J K"" OOd44Z__E   rc 8|j|jSr)rrrs rvisit_tstring_textzSQLCompiler.visit_tstring_textG s%%gll33rc jrj|jsd_|r|dd|ftj dd<dj fd|jDS)NTrrc3DK|]}j|fiywrr)rEpartrrs rrGz,SQLCompiler.visit_tstring..Y s!JD|t||D/B/Jr)rwrrrTr*rrparts)rtstringrrs` `r visit_tstringzSQLCompiler.visit_tstringJ sj       (zz#D   dD7*h6G6G H $ wwJGMMJJJrc \|jr|j||j }|r |jn|jd}t t |d}|jj ||j r|j|||xs-|dk(xr|jddxs|jdd}|rp|jx|_ |_ |j xrt|j|_|jD] } |j| d|j "|j|j"fi|} |j$r.|st'|jnd} |j)| | z} |jj+d| S) Nrr-r,r)rr4Fr3T)rr nesting_level)rwrr_default_stack_entryrr_independent_ctes_dispatch_independent_ctesrrr_r]r2 column_argsr`r_add_to_result_maprrrr_render_cte_clauser) rtafcompound_indexrrtoplevelr new_entrypopulate_result_maprrrs rvisit_textual_selectz SQLCompiler.visit_textual_select[ s       $zz>-5))4::b> #uE* )$   + +C 4  >!#EII yy5u=   D !D$A 47>>/A0dGD ,__  *.&*&=&= t||CKK.2. 993;C OM***G$ND r rc yNNULLrrr3rs r visit_nullzSQLCompiler.visit_null rc 2|jjryy)Nr1rsupports_native_booleanrs r visit_truezSQLCompiler.visit_true s << / /rc 2|jjryy)Nr0rrs r visit_falsezSQLCompiler.visit_false s << / /rc J|jdfd|DDS)Nc3$K|]}|r| ywrrrEss rrGz7SQLCompiler._generate_delimited_list.. s   c3DK|]}|jfiywrrrErrrs rrGz7SQLCompiler._generate_delimited_list.. s$I1*a**4626Irr)rr$ separatorrs` `r_generate_delimited_listz$SQLCompiler._generate_delimited_list s&~~ II   rc ttjjtjtj j tjj |\}}|dk(r|djfiSttj}|jdfd|DDS)Nr rc3$K|]}|r| ywrrr s rrGz;SQLCompiler._generate_delimited_and_list.. s""r"c3DK|]}|jfiywrrr$s rrGz;SQLCompiler._generate_delimited_and_list.. s$Lq.!..t:r:Lr) r$BooleanClauseList_process_clauses_for_booleanr&and_rU _singletonrRrrr)rclausesrlccr&s` ` r_generate_delimited_and_listz(SQLCompiler._generate_delimited_and_list s11NN NN NN % % OO & &   W !8071:00<< <!)..1I>>"LGL" rc .d|j|fi|zSN(%s))visit_clauselist)r clauselistrs r visit_tuplezSQLCompiler.visit_tuple s ---j?B???rc >|j|jdfi|SNrHr'r/rs rvisit_element_listzSQLCompiler.visit_element_list s ,t,,W__cHRHHrc >|j|jdfi|S)Nrr:rs rvisit_order_by_listzSQLCompiler.visit_order_by_list s ,t,,W__dIbIIrc |j}|d}nt|j}|j|j|fi|Sr9)rmrr'r/)rr6rseps rr5zSQLCompiler.visit_clauselist sG!! ;CJ//0C,t,,Z-?-?KKKrc |j}|j|dd}|r |||fi|S t|}d|d<|j|j|fi|S#t $r}t j|||d}~wwxYw)Nexpression_clauselistT_in_operator_expression)rm_get_operator_dispatchrr'r/rr7r)rr6r operator_dispopstringrs rvisit_expression_clauselistz'SQLCompiler.visit_expression_clauselist s'' ** .   I44 4  +H-1B( )0400""H02   L11$ B K Ls A A>"A99A>c dd}|j#||jj|fi|dzz }|jD]8\}}|d|j|fi|zdz|j|fi|zdzz }:|j&|d|jj|fi|zdzz }|dz }|S)NzCASE rHzWHEN z THEN zELSE END)rrwhenselse_)rclauserxcondrrs r visit_casezSQLCompiler.visit_case s  << # 000@@3F FA"LL LD& )$))$9&9:,&++D;F;<  A  << # 9&,,99$I&IICO A U rc <|jj|fi|Sr)typed_expressionr)r type_coercers rvisit_type_coercezSQLCompiler.visit_type_coerce s >{++>>tJrJJrc |jj|fi|}tjd|}d|jj|fi|d|r|j dn|d|r|j dSdS)Nz(.*)( COLLATE .*)zCAST(rr rCr6r)rrr|matchrLr)rr r type_clauserUs r visit_castzSQLCompiler.visit_cast s8doo88HH ,k: *DKK * *4 :6 :#EKKN 4#EKKN +  *, +  rc |jtjjurd}nw|jtjjurd}nN|j |j fi|}|jtjjur|d}n|d}|jtjjurd}nw|jtjjurd}nN|j |jfi|}|jtjjur|d}n|d}|d|S)NzUNBOUNDED PRECEDINGz CURRENT ROWz PRECEDINGz FOLLOWINGzUNBOUNDED FOLLOWINGr) lower_typer$FrameClauseType UNBOUNDEDCURRENTr lower_bind PRECEDING upper_type upper_bind)r frameclauserrvalrs rvisit_frame_clausezSQLCompiler.visit_frame_clause s)  ! !X%=%=%G%G G(D  # #x'?'?'G'G G D$,,{55<v> ;; "%ldll4;;&I&&I%JKF YY "$\T\\$))%Fv%F$GHF [[ $&|t||DKK'J6'J&KLFF  $,,": kDMM$E$E 0% F  HH %d&7&78 $--0)%f)c&k 6V66tFvFH &F82 /   s/Ec ~|jj|fi|d|jj|fi|dS)Nz WITHIN GROUP (ORDER BY rC)rrrn)r withingrouprs rvisit_withingroupzSQLCompiler.visit_withingroup6 sB 2K   2 24 B6 B 3K 3 3D CF C  rc ~|jj|fi|d|jj|fi|dS)Nz FILTER (WHERE rC)funcr criterion)r funcfilterrs rvisit_funcfilterzSQLCompiler.visit_funcfilter< s@ .JOO . .t >v > 3J 3 3D CF C  rc |jjtjurt j d|jjtj uro|jj}tjt|jj|j|_ |j|fi|S|j|fi|S)NzCthis dialect does not support ORDER BY within an aggregate function)raggregate_order_by_styler~rr7rrr_cloner$Groupingr# clause_exprrnrrt)raggregateorderbyrnew_fns rvisit_aggregateorderbyz"SQLCompiler.visit_aggregateorderbyB s << 0 04I4N4N N""8  LL 1 1$++ ,&--446F!)!2!2(&&..0@0I0I"F  -6,,Tt'>'>t'Jr'J&K2/9//E EFG7H77CCDAG %%Q'>t'>'>t'Jr'J&K2/9//E EFaI rc |jj|j|j}d|d|jj|fi|dS)NzEXTRACT(rrC) extract_maprfieldr3r)rextractrrs r visit_extractzSQLCompiler.visit_extract sH  $$W]]GMMB  +GLL + +D ;F ;  rc r|j|jfi|}|j|fi|}d|d|S)NrBz).)visit_functionrr)rrr compiled_fn compiled_cols rvisit_scalar_function_columnz(SQLCompiler.visit_scalar_function_column s?)d))'**;; (t((7B7 '66rc |jr|j||4||j|j|jf|jt |d|jj zd}d|d<|r ||fi|}n8t j|jjd}|r|jri|dz }nc|j}|jj|st|tjr|jj!|n|}|dz}dj#|j$Dcgc]T}|jj|st|tjr|jj!|n|Vc}|gzd|j&|fi|iz}|j(r|dz }|Scc}w)Nz visit_%s_funcTwithin_aggregate_functionz%(expr)srEr3z WITH ORDINALITY)rwrr rrlowerrr _deannotater _has_argsr_requires_quotes_illegal_charsrr$r3rr packagenamesfunction_argspec_with_ordinality)rrvrrrErr r4s rrzSQLCompiler.visit_function s       %  ( diiTYYL$)) Lt_tyy/@@$G/3*+ ''D==!1!1!3!=!=tDD>>J&Dyy}}CCDI!$(<(<=MM''-  j(88 $00  ==GGL%dH,@,@A ++C0!!&  ...t>v>? @D  & &D s AGc 8|j|jSr)visit_sequencesequence)r next_valuers rvisit_next_value_funcz!SQLCompiler.visit_next_value_func s"":#6#677rc Ftd|jjz)Nz2Dialect '%s' does not support sequence increments.rrr rrrs rrzSQLCompiler.visit_sequence s$! @ll   rc <|jj|fi|Sr)r~r)rrvrs rrzSQLCompiler.function_argspec s 2t224B6BBrc jrj|j }|j|fi}|rjs|_|j }|r j njd}|xs| xr|jdd} |dk(r||d<jj|d|d||| d|jrj|j|j} d | zd zjfd t|jD} dd <| j |fit#dd iz } | j$|fiz } |j&r| j(|fiz } j*r/|st-jnd} j/| d | z} jj1d| S)Nrr4Frr5r-r,)r-r,r)r1r4rHc3PK|]\}}|jf|dyw))rr Nr)rEirrrrs rrGz4SQLCompiler.visit_compound_select.. sA Aq%$$!'=C s#&rrTrinclude_following_stackr)rwrr_compile_state_factoryr1r;rrrrrcompound_keywordskeywordrr;selectsgroup_by_clauserorder_by_clause_has_row_limiting_clause_row_limit_clauserrrr r) rcsrr rr r1 compound_stmtrneed_result_maprrrs ` ` ` rvisit_compound_selectz!SQLCompiler.visit_compound_select s       #zz>111"dEfE D..!.D %// -5))4::b>"   A 8%@  Q  "E*  #():#; %n 5 !.0?     * *  + +M6 B((4g #)) &bjj1   #( $$$RI4+Hv+H+HII $$$R2622 & & *D**288 8D 993;C OM''"/,0(   r rc f|j|j|fi|S|j|fi|Sr) _fetch_clause fetch_clause limit_clause)rrrs rrzSQLCompiler._row_limit_clause s>   '$4$$R262 2$4$$R262 2rcRd|jd||rd|znd}t||dS)Nvisit_r@r)rr)rrD qualifier1 qualifier2attrnames rrCz"SQLCompiler._get_operator_dispatch s5     *C*  2  tXt,,rc@d|jd|}t||dS)Nr_op_) visit_namer)rrDrrs r_get_custom_operator_dispatchz)SQLCompiler._get_custom_operator_dispatch s!'0';';ZHtXt,,rc |||fz }||d<||d<|jtjur'|jddst j d|jry|j rtjd|j|jdd}|r|||jfi|S|j|t|jfi|S|j rX|j|j dd }|r|||j fi|S|j|t|j fi|Stjd ) NrrrFzColumn-expression-level unary distinct() should not be used outside of an aggregate function. For general 'SELECT DISTINCT' support use select().distinct().zFUnary expression does not support operator and modifier simultaneouslyunaryrmmodifierz,Unary expression has no operator or modifier) rmr& distinct_oprr+rrr7rrC _generate_generic_unary_operatorr _generate_generic_unary_modifier)rrrrrrEs r visit_unaryzSQLCompiler.visit_unary! so  ( 5( * &7B" #'9B# $ >>Y22 2266 '<  II+  >>~~&&2..DE5>>8R88>8R88 rc |jjr|j|jfi|dz|jt j |j |j jjtjtjfvr|j jntjfi|zS|j|jfi|dz|j|j fi|zS)N / ) rdiv_is_floordivrrr$Castrr_type_affinityr*NumericFloatrrrmrs rvisit_truediv_binaryz SQLCompiler.visit_truediv_binaryQ s << ' ' V[[/B/$,,MM  &||00?? ( 0 0(..A B#LL--"*!1!1!3     ( V[[/B/$,,v||2r23 rc |jjr|jjjt j urn|jjjt j ur>|j|jfi|dz|j|jfi|zSd|j|jfi|dz|j|jfi|zzS)Nrz FLOOR(%s)) rrrrrr*Integerrrrs rvisit_floordiv_binaryz!SQLCompiler.visit_floordiv_binaryl s LL ( ( !!00H4D4DD   //83C3CC V[[/B/$,,v||2r23   V[[/B/$,,v||2r23 rc |js|jjr|j|jfi|Sd|j|jfi|zS)Nz%s = 1_is_implicitly_booleanrrrrrrrmrs rvisit_is_true_unary_operatorz(SQLCompiler.visit_is_true_unary_operator~ sQ  * *||334<<626 6ldll7??AbAA Arc |js|jjr d|j|jfi|zSd|j|jfi|zS)NNOT %sz%s = 0rrs rvisit_is_false_unary_operatorz)SQLCompiler.visit_is_false_unary_operator sV  * *||33ldll7??AbAA Aldll7??AbAA Arc Jd|j|tjzS)Nr)override_operator) visit_binaryr&match_oprs rvisit_not_match_op_binaryz%SQLCompiler.visit_not_match_op_binary s,$++ i&8&8,   rc >d|j|t|fi|zSr3)_generate_generic_binaryrrs rvisit_not_in_op_binaryz"SQLCompiler.visit_not_in_op_binary s3555 Ih' +-   rc |tjur*t|dkDrddjd|DzSy|tjur*t|dkDrddjd|DzSy|j |S) Nr z(%s)) OR (1 = 1rc3 K|]}dywrNrrErs rrGz6SQLCompiler.visit_empty_set_op_expr.. :f: zNULL) OR (1 = 1z(%s)) AND (1 != 1c3 K|]}dywrrrs rrGz6SQLCompiler.visit_empty_set_op_expr.. rrzNULL) AND (1 != 1)r& not_in_oprrin_opvisit_empty_set_expr)rr  expand_oprs rvisit_empty_set_op_exprz#SQLCompiler.visit_empty_set_op_expr s  ++ +5zA~(II:E::) )// )5zA~*II:E::+,,U3 3rc Ftd|jjz)Nz3Dialect '%s' does not support empty set expression.rr element_typesrs rrz SQLCompiler.visit_empty_set_expr s$! All   rc jjj}|s|jrOjjrdndj jj jz}d|fSj jgj}d|fS|jsB|jrt|dtjrst|dttfsZ|jr tdjjrdnddj!fdt#|Dz}d|fS|rj$}|j'|}|r|j)dsJd|j)dj+d }|d |d c dj! fd |D}d|fSdj!fd |D}d|fS)NVALUES rrz?bind_expression() on TupleType not supported with literal_bindsrc 3K|]B\}}ddjfdt|jjDzDyw)r4rc3HK|]\}}j||ywrr)rEr param_typers rrGz[SQLCompiler._literal_execute_expanding_parameter_literal_binds... s*-E:11%DrN)rrrr)rEr tuple_elementrIrs rrGzQSQLCompiler._literal_execute_expanding_parameter_literal_binds.. sQ %A}II14)9>>+?+?2 sAA r6)unexpected format for expanding parameterr-r r(c3bK|]&}j|j(ywrr r)rErr0r1rIrs rrGzQSQLCompiler._literal_execute_expanding_parameter_literal_binds.. s73  11%H 3s,/c3VK|] }j|j"ywrr)rErrIrs rrGzQSQLCompiler._literal_execute_expanding_parameter_literal_binds.. s*3--eY^^D3rgr)rrrrtuple_in_valuesrrr_isnullrcollections_abcrr bytes_has_bind_expressionrrr;r=searchrr2) rrIrbind_expression_templatetyp_dialect_implreplacement_expressionpost_compile_patternrr4r0r1s `` @@r2_literal_execute_expanding_parameter_literal_bindsz>SQLCompiler._literal_execute_expanding_parameter_literal_binds s%>>AA$,,O  ..!%!=!=I200NN(()*=*=*&z)))m*.)E)E^^$i&9&9*&l)))e , ,  $ $6!9o&>&>?vay3,744)$ "\\99 r )2&(9   & "N)))1('+'A'A$(//0HIQWW?>?ggaj&&t,$'FCF!)-3"(3*&))) *.3!'3*& )))rc jrj|Sj}jj |j r j n j jjrjr fd n fd fd}|smgjr4jjjj}|fSjjgj}|fSjsBjrt|dt j"rt|dt$t&fsj(rJt+|dD cgc]+\}} t+| dD]\} } ||d|d| | f-c} } } }|j,rdndd j/ fd t+|Dz}|fSt+|dD cgc]\}} ||d|| fc} }d j/ fd D}|fScc} } } }wcc} }w) aRender the per-element bound parameters of an expanding parameter. ``taken_names`` is a set of names the elements may not use; each name generated is checked against it and added to it. The element names are normally ``_``, or ``__`` for tuples, which may be the name of another parameter in the same statement, e.g. a parameter ``x_1`` alongside the expanding parameter ``x``, or the element of another expanding parameter. A colliding name is uniquified with a counter, rather than the element value replacing the value of the other parameter. See :ticket:`13695`. cHjjd|izSNr )render_bind_castr)r  bind_templaterIrr s r_render_bindtemplatezNSQLCompiler._literal_execute_expanding_parameter.._render_bindtemplate!s,,,NN$!VTN2rcd|izSrr)r rs rrzNSQLCompiler._literal_execute_expanding_parameter.._render_bindtemplate*s$~55rcd|vr|}d}|vr|dz }d||fz}|vrj||S)Nrr %s__%d)add)rFr!counterr!s r _unique_namezFSQLCompiler._literal_execute_expanding_parameter.._unique_name-sSk![(qLG #dG_4C [( OOC Jrrr r@rrrc3zK|]0\ddjfdtDz2yw)r4rc3^K|]$\}}tz|zd&yw)rN)r)rEjrrrrJrs rrGzMSQLCompiler._literal_execute_expanding_parameter...Ws@%Au-%a#m*<&.TsD %A}II)2-(@  s6;c34K|]\}}|ywrr)rErFrrs rrGzCSQLCompiler._literal_execute_expanding_parameter..es /.8c5$S)/rc)r:r rrrrar[rZ_bind_typing_render_castsrrrrrrrrrr r _is_arrayr;rr)rr rIrr!rrr rrrrrrrJr s` ` ` @@@@rr9z0SQLCompiler._literal_execute_expanding_parameter sb  $ $JJ6 ,,$>>AA'J    99M --M LL 2 2 11   6 I..)-)E)ENN(()*=*=*&V000O*.)E)E^^$i&9&9*&N000G , ,  $ $6!9o&>&>?vay3,7'11 11)2&!(<$A} )- ;AuD!Q78%@@I%44 " )2&(9   & ".000 !*&! 4Auq12E:I&*YY/(>?6<<)?)?@$(B !%8 **9hE  0R0 0 $Y/5t44!,(;    P55dIFCO Ps F.. G7GGc <|j|jfi|Sr)r sql_functionrs r&visit_function_as_comparison_op_binaryz2SQLCompiler.visit_function_as_comparison_op_binaryst||G007B77rc &|jjr>|j|jfi|dz|j|jfi|zS|j|jfi|dz|j|jfi|zS)Nz %% r)rrrrrrs rvisit_mod_binaryzSQLCompiler.visit_mod_binarys == ) ) V[[/B/$,,v||2r23  V[[/B/$,,v||2r23 rc |jr|j|d}|r |||fi|S|j|d<|j|d|j |j zdzfi|S)Nrr&rH)rrr&rrrFrrrmrrEs rvisit_custom_op_binaryz"SQLCompiler.visit_custom_op_binarys   55hIDGX444'66 ,t,,  $,,X->->? ?# E   rc |jr|j|d}|r |||fi|S|j||j|jdzfi|SNrrH)rrrrrFr-s rvisit_custom_op_unary_operatorz*SQLCompiler.visit_custom_op_unary_operatorsj   55hHDGX4444t44 T//0A0ABSH LN  rc |jr|j|d}|r |||fi|S|j|d|j|jzfi|Sr0)rrrrrFr-s rvisit_custom_op_unary_modifierz*SQLCompiler.visit_custom_op_unary_modifiersj   55hHDGX4444t44 S455h6G6GHH LN  rc |jdd}d|d<|j|d<|jj|fd|i||z|jj|fd|i|z}|r|rd|z}|S)NrBFT _binary_opr&r4)rrmrrr)rrrFr&rrBrs rrz$SQLCompiler._generate_generic_binarys#%&&)BE"J(, $%!??< *FKK * * %3 79  .fll--%379    #~D=D rc B||jj|fi|zSrrrrrFrs rrz,SQLCompiler._generate_generic_unary_operators$:%--::4F2FFFrc B|jj|fi||zSrrr7s rrz,SQLCompiler._generate_generic_unary_modifiers#/u}}//;;hFFrcLtjdtjS)Nz'%')r )r$literal_columnr* STRINGTYPErKs r_like_percent_literalz!SQLCompiler._like_percent_literals&&uH4G4GHHrc Dd|jj|fi|dS)Nzlower(rCrrs r$visit_ilike_case_insensitive_operandz0SQLCompiler.visit_ilike_case_insensitive_operands):::4F2FGqIIrc |j}|j}|j|jj||_|j||fi|Srr|r<concatrvisit_like_op_binaryrrrmrpercents rvisit_contains_op_binaryz$SQLCompiler.visit_contains_op_binarysQ,,~~fll3::7C (t((@R@@rc |j}|j}|j|jj||_|j||fi|Srr|r<rArvisit_not_like_op_binaryrCs rvisit_not_contains_op_binaryz(SQLCompiler.visit_not_contains_op_binarysQ,,~~fll3::7C ,t,,VXDDDrc |j}|j}t|j|_|j t|j j ||_|j ||fi|Srr|r<r2rrArvisit_ilike_op_binaryrCs rvisit_icontains_op_binaryz%SQLCompiler.visit_icontains_op_binarysl,,,V[[9 ~~ "6<< 0 &/  *t))&(AbAArc |j}|j}t|j|_|j t|j j ||_|j ||fi|Srr|r<r2rrArvisit_not_ilike_op_binaryrCs rvisit_not_icontains_op_binaryz)SQLCompiler.visit_not_icontains_op_binarysl,,,V[[9 ~~ "6<< 0 &/  .t--fhE"EErc |j}|j}|j|j|_|j||fi|Sr)r|r<_rconcatrrBrCs rvisit_startswith_op_binaryz&SQLCompiler.visit_startswith_op_binarysH,,'' 5 (t((@R@@rc |j}|j}|j|j|_|j||fi|Sr)r|r<rSrrHrCs rvisit_not_startswith_op_binaryz*SQLCompiler.visit_not_startswith_op_binarysH,,'' 5 ,t,,VXDDDrc |j}|j}t|j|_|j t|j |_|j ||fi|Sr)r|r<r2rrSrrLrCs rvisit_istartswith_op_binaryz'SQLCompiler.visit_istartswith_op_binary%s^,,,V[[9 ''(>v||(LM )t))&(AbAArc |j}|j}t|j|_|j t|j |_|j ||fi|Sr)r|r<r2rrSrrPrCs rvisit_not_istartswith_op_binaryz+SQLCompiler.visit_not_istartswith_op_binary,s^,,,V[[9 ''(>v||(LM -t--fhE"EErc |j}|j}|j|j|_|j||fi|Srr@rCs rvisit_endswith_op_binaryz$SQLCompiler.visit_endswith_op_binary3sF,,~~fll3 (t((@R@@rc |j}|j}|j|j|_|j||fi|SrrGrCs rvisit_not_endswith_op_binaryz(SQLCompiler.visit_not_endswith_op_binary9sF,,~~fll3 ,t,,VXDDDrc |j}|j}t|j|_|j t|j |_|j ||fi|SrrKrCs rvisit_iendswith_op_binaryz%SQLCompiler.visit_iendswith_op_binary?s\,,,V[[9 ~~&>..t||+>>** :> @&&)*<*<((Y-?-?"..&  "..0@"#,--5  8A@ 9==!DJJt$4// #JD$++ /66T>bffBHOOI. /   &*D # !+/(++ {:+((YK7(#d##  %))$>>       cU!*C rctrr)rr  dbapi_typers rrzSQLCompiler.render_bind_castVs !##rc T|tur|}n|jr2|j|jvr|j|j}n|j|j x|j dd}|rC|tjtjfvr!tjd|jf|jtjfi|S|j}|j r|j"}||||\}} | S|j%||j&S)Nr5zBound parameter '%s' rendering literal NULL in a SQL expression; comparisons to NULL should not use operators outside of 'is' or 'is not')r )r2rwrFrxrrrr&is_is_notr+ warn_limitedrr*rrrr r r) rrr r rropleeprJrLs rr8z$SQLCompiler.render_literal_bindparamYs v -(E  ! !immt7M7M&M**9==9E&9+=+=+EVVL$/"Y]]I4D4D$EE%%@#(  $t||H$5$5<<<--E   JJD*.)A+ 'I' $ #,,UINNC Crc|9|js-|jtjj S|j |j }|r ||Stjdtj|d|#t$r5}tjdtj|d|d|d}~wwxYw)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. Nz Could not render literal value "z" with datatype z); see parent stack trace for more detail.z:No literal value renderer is available for literal value ") should_evaluate_nonerr$rT _instance_cached_literal_processorrr r7rsql_util_repr_single_value)rrr  processores rr z SQLCompiler.render_literal_value~s =!;!;<< 7 7 9: :33DLLA   ''""//678!!&)  && 33E:;<%g##   sB C0C  Cc||jvr|j|S|j}t|tjr|j d|}||j|<|S)Nr)rVrFrr$rLr)rrrs rrzSQLCompiler._truncate_bindparams^  '??9- -MM i!:!: ;22; JI&/ "rc||f|jvr|j||fS|j|j}t||jdz kDr]|j j |d}|dt|jdz ddzt|ddz}|dz|j |<n|}||j||f<|S)Nr rr@r6) r apply_maprrrrrmaxhex)r ident_classr anonnamer truncnames rrz!SQLCompiler._truncated_identifiers  $"6"6 6''d(;< <>>$--0 x=4,,q0 0..22;BGS!2!2Q!6:;g,qr"#  5. sd88Drz__[POSTCOMPILE_%s]r )rrrJrrrlrmrrrrender_literal_castrrrrr[rZr) rr rrrraccumulate_bind_namesvisited_bindparamrnew_namer{ type_impls ` rrzSQLCompiler.bindparam_strings ! , ! % %d +  (  $ $T *&&--d3 2266D $ ''D999 $ **<>D &-C )*BBLL 00// 3OCJ ZZ=22 2//64.@C##vtn4C  & 66&>>t||LI))++NIsK rc|j}|jddt|j|jD]\}}|j |fd|i|y)Ncte_opts)copyrrr_independent_ctes_optsr)rstmtrlocal_kwcteopts rrz&SQLCompiler._dispatch_independent_ctes8sb779 Z&  " "D$?$?  CHC #C " "4 B# B B Crc N j} | jusJ||d<|j} t| tj rj d| } d} d} |j} |jxs |j}| jvrj| \}}}|| k(sJ|| f}j|}|jr|jrtjd|| f}|rtjnd}|| fx}}j|=|j|<||fzj| <n=|rtjnd}|| f}|jvrj|}nd}|||u} ||jus||urd} n||jur-| |=|j}|| usJ||usJj|=n[t!|t!|k(s)|j" |j"|j%|rd} ntjd| z|s| sy|j&O|j&}|j&j}t|tj rj d|}n|}d}| r|j|<||fzj| <|jvrj(|fi||ss|| vrn|j*rd_j.j1|| }|j*s|j2j4r^|j2}|j7dDcgc]\}}}}}|s|xs|}}}}}}|dd j9fd |Dzz }|j;d ddusJjs|j2j<fd |i|Sj>||j@fi|} |j2j<fd di|}!|d | d|!dz }|jBr$|dj>||jBfi|zz }|| |<|r|r| |jD|jG<| s| rj.j1|| S|rhj.j1||}j.jI| rj.jK| } |jM| z }|Sj.j1|| Sycc}}}}}w)N visiting_cterTFz6CTE is stated as 'nest_here' in more than one locationr z5Multiple, unrelated CTEs found with the same name: %rr4rc3lK|]+}jj|j-yw)rN)rformat_label_namer)rEidentrs rrGz(SQLCompiler.visit_cte..s8"!&!MM;; % <"s14subqueryrrz (rCrH)'rrrr rr$rLr_get_reference_ctenestingrtrsr7rrr _restateshash _is_clone_ofcompare _cte_alias visit_cte recursiverur format_aliasrname_cte_columns_generate_columns_plus_namesrrr_generate_prefixes _prefixes _suffixesrr._requires_quotesrget_render_as_alias_suffix)"rrrashint fromhintsrr"rr self_ctescte_name is_new_cteembedded_in_current_named_cte_reference_cter cte_levelr@existing_cte_optscte_level_name existing_cteold_level_namenew_level_nameexisting_cte_reference_cte pre_alias_ctecte_pre_alias_namer col_source proxy_namefallback_label_namerrepeated recur_colsprefixesrs"` rrzSQLCompiler.visit_cte@s((* DII%%%!$~88 h 9 9 :11'8DH (-%//1++1!1!1 T33 3.2.D.D/ +Iq+= ='2N22>BL $,,**1 #,X!6/6C OA 3> %NNM!$!4!4 ,h.G.GH%)%?%?/&" M!%  69D # #N 35CG6D " "> 2DII-}77%#Y*>==*.D'}}11#x@==CKK$@$@!$J")EEdK"" &/$',9z9 "J" F "*4 "Dzz*e4===zz:3;;99%+/5 7t66S]] .4 H;CKK::%)-3Eh>>D==C"9$"9"9S]]#.4#D"& # 5= !!#--/2"?}}11#x@@!}}11#7IJ==11(;#}}228.ks{ !MM//9 $)#@#@ !&"M$,,"E"E"M"M$'HH#"06#"!" &( !( sA3A6r)rrrrr r$rLrrrrr.r_supports_derived_columns_render_derivedrrformat_from_hint_text)rrrrrrrrrr"rrr alias_namer{s`` ` rrzSQLCompiler.visit_alias#s3 "&0((((.3*+ )7'610;,-  &?+B+Be+K4EMM44 # %  EVw"')L(-F$ % V~%**h&?&?@!77L "ZZ ==--eZ@ @ ~7A !!%//"344EMM44!76<E"')$99 **5*=C..53H3HvII$)77$Ui/00 % 0&J45==33%)/ rc 2d|d<|j|fi|S)NTrr)rrrs rvisit_subqueryzSQLCompiler.visit_subquerys#:t/B//rc 8d|d<d|j|fi|zS)NTrz LATERAL %sr)rlateral_rs rrzSQLCompiler.visit_laterals)9 .d..x>2>>>rc |j|fddi|d|jj|fi|}|j#|d|jj|fi|zz }|S)NrTz TABLESAMPLE z REPEATABLE (%s))r _get_methodrseed)r tablesamplerrrs rvisit_tablesamplezSQLCompiler.visit_tablesamples D  [ < < < 8K # # % 8 8 D D     ' &3   33D?B? D rc jdjdjfdjD}d|S)Nrrc 3K|]I}|D]B}jtj|djij fiDKyw)rN)rr$r _column_typesr)rEchunkelemrrrs rrGz-SQLCompiler._render_values..sk     DLL26!//*,        AAr) setdefaultrr_data)rrrtupless``` r_render_valueszSQLCompiler._render_valuessG ow'<'<=  !   !!rc |jrj|j|fi}|jrd}nMt |j t jrjd|j }n |j }|jrd}nd}|r|r!||nd|j|j<|1|j|ur#|jrtjd|S|r`dd<|d|d jj j#|d d j%fd |j&Dd }|S|d|d }|S) NrzLATERAL rz(unnamed VALUES element)z5Can't use a LATERAL VALUES expression inside of a CTEFrrBrC (rc3DK|]}|jfiywrrr$s rrGz+SQLCompiler.visit_values..s+" !1A00<<"r)rrr_unnamedrr r$rLrrrr.rr7rrrrrcolumns) rrrr"rrrr rs ` ` r visit_valueszSQLCompiler.visit_valuess\  $ $  + +GR 8 D   .2 .   D  h&?&? @--h ED<.add_to_result_map6s&wwj%Hrc$||f|z|yrr)r r rr rrs rrz;SQLCompiler._label_select_column..add_to_result_map>s&y7':ErNzX_label_select_column is only relevant within the columns clause of a SELECT or RETURNING)rz*proxy_name is required if 'name' is passedTF)rrrr)rrr_has_column_expressioncolumn_expressionrrr$rSrr rrrPrr TextClauseUnaryExpressionrmr&is_falseis_truer_wraps_unnamed_column NamedColumn_non_anon_label_anon_name_labelrLrr)rrrrrr%r rrrcolumn_is_repeatedneed_column_expressionsrrcol_exprr result_exprrender_with_labelrs ` @rr$z SQLCompiler._label_select_columns {{'' 5  & & #':--f5HH  !% 7 7  "%6"I '%6" !% %  : $ fhnn -v%+fkkfnn5F ' & <; <&( $$ K&v%%)!FH$9$9:1"---1 D0" FH$7$78$)!FH$<$<=P%.. 0A0ABCE $ D DD 335 ""vx';';<**2$(!$)! * 211*0*A*A'&+X-F-F--.AB- $,1j] ' !!"7/' " .{--dI6HIIrc>|j||}|r|d|zz }|Sr9)get_from_hint_text)rrrhintrhinttexts rrz!SQLCompiler.format_from_hint_texts***5$7  sX~ %Grcyrr)rbyfromss rget_select_hint_textz SQLCompiler.get_select_hint_textrcyrrrrrs rr:zSQLCompiler.get_from_hint_textsrcyrrrBs rget_crud_hint_textzSQLCompiler.get_crud_hint_textr@rc$dj|Sr9r%)r hint_textss rget_statement_hint_textz#SQLCompiler.get_statement_hint_textsxx ##rr0rr-r,c |j }|r |jn|jd}|j||||}|j|||\}} |j || S)Nrrexplicit_correlate_fromsimplicit_correlate_froms)rrr_enclosing_correlate_froms_get_display_froms) r select_stmtrrrr rr1explicitimplicits r_display_froms_for_selectz%SQLCompiler._display_froms_for_selectszz>-5))4::b>#:: fg; "<< 67 (//%-%-0  rch|d}|d}|r#|s!|j|tjfS||fS)a[Given the stack entry of an enclosing statement, return the explicit and implicit correlate FROMs for a SELECT that's embedded within it, as passed to :meth:`.SelectState._get_display_froms`. explicit_correlate_froms: FROMs of enclosing SELECTs that this SELECT may correlate to when explicit correlation is used, i.e. :meth:`.Select.correlate` or :meth:`.Select.correlate_except`. Includes the FROMs of all enclosing SELECTs. implicit_correlate_froms: FROMs of enclosing SELECTs that this SELECT will correlate to automatically, assuming auto-correlation is in effect. Includes only the FROMs of the immediately enclosing SELECT, and is empty if this SELECT is a subquery in a FROM clause that's not LATERAL. Is always a subset of explicit_correlate_froms. r-r,) differencer+ EMPTY_SET)rrrrr-r,s rrLz&SQLCompiler._enclosing_correlate_fromssC& 12^, '"--l;T^^K K"L0 0rtranslate_select_structurec  v (|Jd|jr|j|d| d<|j||f||d| } | j| d<| j}|j } | r|j s| |_|duxs|} |jrB|j|fd|i| } | |ur)| }|}| }|j||f||d| } | j}| r |jn|j d}| xs&|jddxs|jd dx}}|rd}|sd | vr| d =|j|| ||||}| j}|jddd d }|j'|j|jfi| }|||d zz }|jr|j!|\}}|r ||d zz }nd}|j"r|j%|| |j&r!||j(||j&fi| z }||j*|fi| z }|j,'|j|j,fi| }|||d zz }| j.Dcgc]#\}}}}}|j1|||||||||| %c}}}}}Dcgc]}||}}|r|t3t5| j.D cgc] \} }}}}| c}}}}} j.D cgc] \} }}}}| c}}}}} (|j6D !"cgc]'\} }}!}"t9| |t;(fd|!D|")c}"}!}} |_|j=||| |||| | }|j>'|j|j>fi| }#|#r|d |#zz }|j@rQ|j@D$%cgc]!\}$}%|$d|jBjDfvr|%#}&}$}%|&r|d |jG|&zz }|jHr2| r| r.| stK|j nd}'|jM|'|z}|jNr$|d |j(||jNfi| zz }|j jQd|Scc}}}}}wcc}wcc}}}}} wcc}}}}} wcc}"}!}} wcc}%}$w)NzpSQLAlchemy 1.4 requires use of the translate_select_structure hook for structural translations of SELECT objectsFrrrrrr4r3r)rrzSELECT rH)r rrr4r5c3BK|]}j||ywrr\)rEors rrGz+SQLCompiler.visit_select..s$FQY]]1a%8$Fsr"r))rwrr_ambiguous_table_name_mapr;rr1rUrr_setup_select_stackrr_post_select_clauser_hints_setup_select_hintsrrrrget_select_precolumns_pre_columns_clausecolumns_plus_namesr$rrrr rJ_compose_select_body_post_body_clause_statement_hintsrr rGrrrr rr))rrNr insert_intorr select_wraps_forrr"rr1r is_embedded_selectnew_select_stmtcompile_state_wraps_forrrr5rr%rpsc hint_textbyfrompccr rrrrr inner_columnsrFrr pbc dialect_nameht per_dialectrrs) @r visit_selectzSQLCompiler.visit_select7s '  - '       ,+0&': ::  &,g AG   3 3 )*$-- zz> D..!.D +47F;  * *=d==$*.4O k1*7'#. - B B B!"# !  ! ,55 -5))4::b>  >yy7? >yy5u= 5 "'  #':f'D*+(( vw $[[]!!$)E J   * * 6$,,{>>I&ICc !    $ 8 8 E Iv C'F  ( (  + +K @  +D++[226< D ***;A&AA  * * 6$,,{>>I&ICc !0#55''#))'&)(;'/,C*  *}-   4 #3#?+==  &/ $  $5GG  &/ $  I:.2-A-A $$*CsE#u$F#$FF$D ((            ( ( 4$,,{<<GGCc !  ' '+6*F*F&\2C):):#;;K d::;GGG 990H3;C OM***G$ND  C1$11[226< D r C @  $0s$/(R R R4R$#,R- &R5c |jjDcic];\\}}}|d|jjfvr||d|j |diz=}}}}|j |}||fScc}}}w)Nr"r T)r)r\rrr rr?)rrrrr<rkrjs rr]zSQLCompiler._setup_select_hintss /5mm.A.A.C  + (3 1 122 8u//T/BCD D  --f5 &   sAA8c |dk(r||d<nf|rd|d}t|j}t|j|k7r2tjdd||dzt|jfz|j |||\} } |j | | } tt| } | j|d} | | ||d}|jj|| S)Nrr5z}All selectables passed to CompoundSelect must have identical numbers of columns; select #%d has %d columns, select #%d has %dr rIr-)r,r-r)r1) rrr`r7rrLrMrr/rrr)rrr1rrrr r5numcolsrOrPrnew_correlate_fromsall_correlate_fromsr s rrZzSQLCompiler._setup_select_stack&s Q  &E*  Z(H(889G=334?&&! &*F889    "<< 67 (00%-%-1  "-"78177 # $  02 * * )$ rc |dj|z }|jtzr1tit } |jt z} |r | |_nd} d} |s|j}|r|dz }|jr8|dj|D cgc]} | j|fd|| d|c} z }nJ|dj|D cgc]} | j|fd| d|c} z }n||jz }|jr)|j|jfd| i|} | r|d| zz }| r| J| j|jr||j|fi|z }|j r'|j|j fi|} | r|d | zz }|j"'|j$|j"fi|} | |d | zz }|j&r||j(|fi|z }|j*r||j,|fi|z }|j.||j0|fi|z }|Scc} wcc} w) NrFz FROM T)rrr"rr"r"z WHERE z HAVING z )rrrrrrr"rstripr\rr~_where_criteriar1r_group_by_clausesr_having_criteria_post_criteria_clauser_order_by_clausesrrr_for_update_argfor_update_clause)rrrr1rmrrkr rr" warn_lintingftrls rraz SQLCompiler._compose_select_bodyTs  -(( <<4 4$R/K<<,6L#. K L;;=D  J D}} "' -,, #'&,(3  %     "' -,, #'(3%    D%%' 'D  ! !111&&4?CIA a' * **      # # (D((:6: :D  " "111''+1A q((  ' ' 3$,,v;;FvFC #  # # (D((:6: :D  * * *D**6.sH $ {*ldll>O>O.O &F % %d 1b 1 s=Ar%)rrrrrLs` ` rrzSQLCompiler._generate_prefixess1 (0    cMF rcv|jsy|r|dkDrtj}t|jj D]g}|j |j \}}}|jxs |j}||k(xs |xr||dzk(} |r| sV|j|||<in |j}|syt|Dcgc]}|jc}} |j| dz} | dj|jD cgc]} | c} z } | dz } |r{|dkDrvt|j D]Z}|j |j \}}}|j|=|j||f=|j |j =\| Scc}wcc} w)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. rr rH, z )rrr+rrkeysrtrrrrget_cte_preamblerrrs) rrrrrrrrrris_rendered_levelructe_texttxts rr zSQLCompiler._render_cte_clausesyy ]Q.##%DDIINN,- +040F0F**,1- 8X++9)9)9$-$>%+N ]Q=N0N" $5 IIcNS  +99Dt<cmm<=((83>FKK > >??E ]Q.DIIK( E040F0F**,1- 8XIIcN++Y,AB**3+A+A+CD  E=!?s F1 F6 c |ryy)NzWITH RECURSIVEWITHr)rrs rrzSQLCompiler.get_cte_preambles #rc h|jrtjdd|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.4)versionrr) _distinct_onr+warn_deprecated _distinctrrrs rr^z!SQLCompiler.get_select_precolumnss:     3   %..{6B6rc x|j|jttjfi|}|rd|zSy)z5allow dialects to customize how GROUP BY is rendered.z GROUP BY r)r'r|rr&comma_op)rrrgroup_bys rrzSQLCompiler.group_by_clause sG1400  $ $i 0B0B&C GI  (* *rc x|j|jttjfi|}|rd|zSy)z5allow dialects to customize how ORDER BY is rendered.rr)r'rrr&r)rrrrns rrzSQLCompiler.order_by_clausesG1400  $ $i 0B0B&C GI  (* *rc y)Nz FOR UPDATErrs rrzSQLCompiler.for_update_clause$src |jdtj|D cgc]"\}}}}} |j|||f|| ||d|$} }}}}} ddj | zScc} }}}}w)NT)cols)rr4r r RETURNING r)rr!_select_iterablesr&r) rrreturning_colsrrr rrrrrs rreturning_clausezSQLCompiler.returning_clause's222411.A3#  # )D ( (# %8#+%    ,dii000- s'A. c d}|j#|d|j|jfi|zz }|j4|j|dz }|d|j|jfi|zz }|S)Nrz LIMIT z LIMIT -1z OFFSET ) _limit_clauser_offset_clause)rrrrs rrzSQLCompiler.limit_clauseGs    + K,$,,v/C/C"Jr"JJ JD  ,##+ % Jf.C.C!Jr!JJ JD rc ||j}|j}nddd}d}|jK|j}|r!|j|r|j }|j |fi|} |d| zz }n|r|dz }|O|r!|j|r|j }|d|j |fi||drdndd |d rd nd z }|S) NF)rD with_tiesrz OFFSET %s ROWSz OFFSET 0 ROWSz FETCH FIRST rDz PERCENTz ROWS rz WITH TIESONLY)r_fetch_clause_optionsr_simple_int_clauserender_literal_executer) rrrrequire_offset"use_literal_execute_for_simple_intrfetch_clause_optionsr offset_clause offset_strs rrzSQLCompiler.fetch_clauseQs  !//L#)#?#? /45#I   ,"11M2--m< - D D F %m:r:J '*4 4D  & &D  #2--l;+BBD  \0R029= 2E3K@ fL D  rc  v|r|j|j|<|s|s| r|jj|} |rG| rE|jj | dz|jj |j z} n|jj |j } | | j|ur_| s]|r[|j |vrM|jd||j }| |j|jjd|z} |r||vr|j| ||||} | Sy)NrErr) fullnamerrrrrr rrrrr)rrrrrr use_schemar"rrrrrr{ anon_names r visit_tablezSQLCompiler.visit_tablezs; ',~~K  e $ V~#}}>>uE .MM../?@mm))%**56 mm))%**5(/*22%?,0 &>> $ : :!9%**!E!I ? ? 224C!CUi/00 % 0&Jrc |ri|jjtjt |j j t |jj |jrd}n|jrd}nd}|j j|fd|d||z|jj|fd|d|zdz|jj|fd|i|zS)Nz FULL OUTER JOIN z LEFT OUTER JOIN z JOIN Try ON r") rrrr%r.rr/rrisouterronclause)rrrr"r join_types r visit_joinzSQLCompiler.visit_joins      $ $!!dii556djj667  99+I \\+I I (DII ( ( !{ >D  ,djj++!{>D   /dmm.."-17  rc"|jjDcic]%\\}}}|d|jjfvr||'}}}}|j|vr+|j ||j||jd}||fScc}}}w)Nr"T)r\rrr rr)rr table_textrrrj dialect_hintss r_setup_crud_hintszSQLCompiler._setup_crud_hintss04{{/@/@/B  + )3 1 122 9   :: &33DJJ djj(A4Jj(( s*B c|jj}|j}|j}|y|jr'|j j |jd}n&|jj |jd}||zr|S|jr3tjd|dd|jjdy)a)given a :class:`.Table`, return a usable sentinel column or columns for this dialect if any. Return None if no sentinel columns could be identified, or raise an error if a column was marked as a sentinel explicitly but isn't compatible with this dialect. NrzColumn z@ can't be explicitly marked as a sentinel column when using the a dialect, as the particular type of default generation on this column is not currently compatible with this dialect's specific INSERT..RETURNING syntax which can receive the server-generated value in a deterministic way. To remove this error, remove insert_sentinel=True from primary key autoincrement columns; these columns are automatically used as sentinels for supported dialects in any case.) r"insertmanyvalues_implicit_sentinel _sentinel_column_characteristicsr is_autoinc_sentinel_col_autoinc_lookuprdefault_characterization _sentinel_col_non_autoinc_lookup is_explicitr7rIr )rr sentinel_optssentinel_characteristics sent_colsbitmasks r_get_sentinel_column_for_tablez*SQLCompiler._get_sentinel_column_for_tables GG #(#I#I ,44   # . .77;;(AA1G;;??(AA1G 7 "  # / /)))A,(><<$$%&@ @  rc #8 @ABCDKj}|J|jsd} ntj|j} t |} |j rj jsd} d} nzj jr2|r5jr)|j|jr|jsd} d} n-|jr|jsjrd} d} nd} d} | rNttdt!||dD]*\} \}}t#|||g| r | |gngd| | || ,y|r,t%j&j(j*|}nd}|j,}|r||}d|d}|j/|d}j j0}|rAt j2}t |j4}||z }t7|||z |z}td t9|}td t9|}d}d} | |z| |zrdnd z}|j4}|J|r$|Dcgc]\}}}}|||||f}}}}}d xCDj:sj<r j<AniAt?|d } Afd @|jrd }!nd }!ddjA@fd|D|!d}"| jCAfd|D}#| jE|#Dcic] }||d | }$}d Bnd }"t?}#i}$|jrd|dBnd|dBt?}%|j4D]}&|%jG|&d|%r]jH}'|'Jt|'D()chc] \}(})|)|%vr|( }*}(})t7|*CtK|*dzDt |*DCz k(sJjLr9tOjPjR}+tOjT|+ddBB|r[|d |},|d |}-g|d |g|d ||r|}.n t |,}.r,fdtW|.DD/01cgc] \}/}0}1|/|0|1f }}0}/}1j:r|jX}2|2t |,d k(rdx}3}4|,}5n|,d dC}3|,d Dd}4CDfd|,D}5|jr'd jABfdt|,Ddd}6nB|.zdd}6jLr9|2d kDr4|4rJCdz}7|2|.z|7z}8t[fdtW|7|8D}9|6|9z}6|j/d|6}:t[t\j^ja|5};|3|;z|4z};ng}<|$jc};t|,D]\}=}|"j/dte|=}>|jr|>j/dte|=}>||;jG|#Dcic] }|d|=||c}|j/ddjA|<}:t#|:|;||,| r|-D?cgc] }?| |? c}?ng|.| ||d | dz } |rZyycc}}}}wcc}wcc})}(wcc}1}0}/wcc}wcc}?ww)NTFzKSequence[Tuple[_DBAPISingleExecuteParams, _MutableCoreSingleExecuteParams]]r rrBrC__EXECMANY_TOKEN__zList[Sequence[Any]]rc|D]G}j||}|jjd|izjd|diz}I|S)Nr __EXECMANY_INDEX__)rrrZ)r formattedrFrlrs rapply_placeholderszISQLCompiler._deliver_insertmanyvalues_batches..apply_placeholdersslC,00c:C ) 1 1))VSM9))!cU*<#=>?!I! rz, _IMV_VALUES_COUNTERrrc3:K|]\}}}}||ywrr)rEr@r bind_keysrs rrGz@SQLCompiler._deliver_insertmanyvalues_batches..s(6.Aq)Y#9i86r'c3ZK|]"\}}}}|D]}j||$ywrr\)rEr@rrFrls rrGz@SQLCompiler._deliver_insertmanyvalues_batches..sC4&Aq!Y$4#&&sC0404(+z, _IMV_VALUES_COUNTER), z), r(z\d+rc3HK|]}D]\}}}|d|||fyw)r@Nr)rErrFlen_rgeneric_setinputsizess rrGz@SQLCompiler._deliver_insertmanyvalues_batches..8sF/!.C/+Cs 5%)45/5/rrc3(K|] }| ywrr)rErexpand_pos_lower_indexexpand_pos_upper_indexs rrGz@SQLCompiler._deliver_insertmanyvalues_batches..Ms"&01GH&sc3ZK|]"\}}jdt|$yw)_IMV_VALUES_COUNTERN)rr )rErr@executemany_values_w_commas rrGz@SQLCompiler._deliver_insertmanyvalues_batches..Ts3 !%17>> 5s1v rc3>K|]}j|ywr)r\)rErrs rrGz@SQLCompiler._deliver_insertmanyvalues_batches..qs)& >>?sC&rEXECMANY_INDEX__r__)4rhr\rmrzrrRrsupports_default_metavaluesupports_multivalues_insertrrZrXr_r^r;r rra functoolspartialrrrSrinsertmanyvalues_max_parametersrVrTminrrrlrrrrSrr@rrar|r}r\rrangerVrJrr from_iterablerr r)Err;r<compiled_parametersr batch_sizerWrimv_sentinel_from_params lenparamsuse_row_at_a_time downgradedriparamcompiled_paramrstimv_single_values_exprexecutemany_values max_paramstotal_num_of_paramsnum_params_per_batchnum_params_outside_of_batchbatchescompiled_batchesrerjrTrrFr3stall_keysimv_values_counterformatted_values_clausekeys_to_replacebase_parametersall_names_we_will_expandrr@r#r all_expand_positionsescapedrfcompiled_batchrhnew_keyrrnum_ins_paramsextra_params_leftextra_params_rightbatch_iteratorexpanded_values_stringrrrrbrcreplaced_values_clausesrfmvrrrlrrrsE` ` @@@@@r!_deliver_insertmanyvalues_batchesz-SQLCompiler._deliver_insertmanyvalues_batches;sR$$&&$( !$,$7$7((% ! O   t||'N'N!% J99 #$$$$,1144!% J  + +,,$$!% J % J 5>a $78 6 115.-)G1/~>?+ .  ## 77%9C C!$!7!7 %()?%@ " !7 8:%%&8:NO \\AA "%doo"6 #&s'='=#> #&:: ("==+,J,d:.>? !4(;#< HL!Z/Z'AQ !33!--- +=""&CdBc3t9b)" " ;<;!7&&%)%<%<"%'":a=)H !''%<"%'"*+DII62D6-,""!'' # '334*<4O$..?Z]3''O *, &&( #!eO O''.//GH+011G0H-L*14 $.. 9(//Q8 9(".. "...&/{%;(!T77($( *--A)B&),-A)BQ)F&,--0FFGG""))D$G$GH-/VVy$d,F.*Aj)E-a ;N$&GAj !-/ Qz *%/"%(Z"$ /%*+=%>/++*sdC(+'+!$!B!B "Sq]2=??%(:%*N(-a1H2H(I%).q2H2I)J&&!&&N ++ )2%(8   r.*46HHr.*&&>A+= 2112Q6E(,>?%GC!&&!&uc!2&!I.Di-O*%.%6%6(*@&"',OO11.A'# &)*()$+-'&5&:&:&<# )% 0 HAu199*CFC//!kk*?QH+2237'..>MNsC51#c 2N &/%6%6(II56&" )"#'-:HH2*2.H"'  MHIq"P<(D+xOIsXIZY6 &B"ZY>A;ZZ#B5ZZ (FZZ 9Z ZZ4&Zc &|j|fi|}|j}|||d<d}n j }|r-d_js|_j s|_jj tt|dd}d}jr|g}tj|||fd|i|}jrB|@t|}jr)jxj|z c_ n|_ |j} | snjj sXjj"sBjj$s,t'j(djj*z|j,rjj.s,t'j(djj*zj0s |j2r!|j4rt'j(d |j} n |j} j6} jj } d } |j8r!| j:||j8fi|z } | d z } | j=|j>} |j@rjC|| \}} |jDrjG||| | z } | s| s,| d d jI| Dcgc] \}}}}| c}}zz } |jJ}d}d}d}j0xs |j2}|r|jL}||sJ| Dcic] \}}}}|| }}}}g}|D]7}||vrd}n/jO|}|||vrd}n|j |9|@jjPtRjTzrd}n|djVrJdtY|tY|z}j[|||}j\r | d|zz } nd}|j^j`jddfddi|}jbrLjjdr6|stjnd}| djg|d|z } nf| d|zz } n\| s\| rZ| dz } |rPtidjjj| ||j4|jldu||r t|nd| _7n|j,r*| dd jId|jpDz } n|r|r!jjPtRjrzr|jtsd}jjPtRjvz}|xsd&d jI| Dcgc] \}}}}|&vr|c}}}} d jI&fdty| D}!|r%d jI&fdty| D}"n#d jI&fdty| D}"| D#cgc] }#|#d&vr|# }$}#| d|"d| d |!d!z } n3d}| }$d jI| Dcgc] \}}}}| c}}} | d"| d#z } tid| |$||j4|jldu||r t|nd|||$ _7n/d jI| Dcgc] \}}}}| c}}} | d"| d#z } |jl'j`|jlfi|}%|%r| d|%zz } |rj\s| d|zz } jbrEjjds/|stjnd}jg|d| z} jj{d| Scc}}wcc}}}wcc}}}wcc}#wcc}}wcc}}w)%NrFTrrrzWThe '%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.zdRETURNING cannot be deterministically sorted when using an INSERT which includes multi-row values().zINSERT zINTO  (%s)rzTsentinel selection rules should have prevented us from getting here for this dialectrrHrr7rdrrz DEFAULT VALUES)rWrXrZr[r]z VALUES c3RK|]}ddjd|Dz!yw)r4rc3*K|] \}}}}| ywrr)rEr@rs rrGz5SQLCompiler.visit_insert...s L>1a LsNr%)rEcrud_param_sets rrGz+SQLCompiler.visit_insert..s2'yy L^ LLNs%'rc3<K|]\}}|dvrd|yw)rpNr)rErcpadd_sentinel_sets rrGz+SQLCompiler.visit_insert..s0%2!u$44sG%rHc3K|]U\}\}}}}|vrCj|j|jjjd|n|WywrN)rrrr)rErrr@r3rrs rrGz+SQLCompiler.visit_insert..sn 01A0Qa #*:: !11 # # @ @ N"#A3 "& & 0sAAc3DK|]\}\}}}}|vrd|n|ywrr)rErrr@r3rs rrGz+SQLCompiler.visit_insert..s900A0Qa%(/?$?1QCTI0rz SELECT z FROM (VALUES (z)) AS imp_sen(z#, sen_counter) ORDER BY sen_counterz VALUES (rC) rRrSrTrVrWrXrZr[r\r]r_)>rr;rrMrr1rrrr#_get_crud_paramsrraro single_paramsrsupports_default_valuesrsupports_empty_insertr7rr _has_multi_parametersrrS _returning_sort_by_parameter_orderrrr format_tablerr\rrrruse_insertmanyvaluesuse_sentinel_columnsrYrrnry_insert_sentinelrrrWrrrrcte_follows_insertr rQdefault_metavalue_token_post_values_clauserhall_multi_paramsr{is_default_metavalue_onlyr|r;r)'r insert_stmtrrrr1r counted_bindparamcrud_params_structcrud_params_singlerr rrr@r3r&named_sentinel_paramsadd_sentinel_colsr]rr param_names_params_by_col_add_sentinel_col param_namer select_textrembed_sentinel_valuerender_bind_castsrrcolnamescolnames_w_castrrTpost_values_clausers'` @r visit_insertzSQLCompiler.visit_inserts% ; ::  !# $--  #!-B~ H::~H  DM)))6&%%%2" #&5 #)  ! ??|3 !# !22      0     ??0< #$5 6 ""))5**.??*->D*/==#LL88LL;;LL66""!\\../   . .<<;;&&137<<3D3DE '';+A+A66&&I"4!A!A !3!A!A =="&,,"F"F  +D++[2268 D **;+<+<=    22; KMAz  ( (  + +K <  %< Gdii+=>-!T1a> D 2FF9= !00JK4J4J  2 G G  ,+++3E"".Q;$"")+%): =%(>04-!%!C!C)"J"8I)JJ04-)00< =)0 GG6HHI-1)$5Q#7#H#HDH"&n!5=N8O!O#44$, 5   --... $     )&$,, 234BFJLKyyT\\<<7?DJJT ++&304,  ++#(? % %D#):LL88&%#<<$77tC%62C-.&7*&" 0 0  +=*M*M D"!LLCC2IIJ ,EE (,$LLCC2JJK" $5#: ,0II1C,CE1&66-) 99%!*+=!>% %'+ii 05>.5 0 'O'+ii04=.50'O!3&Aw&66&"& /0 9:;""*,++(-$%7",0II1CD~q!UAUD-))$=#>a@@%6 %#<#5.?)4)M)M334?!2.?C)*Q$9"3%9&D "&)- -?@>1a@) % i 9:!< |jFr2|d |jI||jBxs |jD| zz }|r,|jJ||j$| |fd|i|}|r|d |zz }|jLr)|jN|jLfd|i|}|r|d |zz }|jP|fd|i|}|r|d |zz }|jBs |jDr>|jFs2|d |jI||jBxs |jD| zz }|jRr.|stU|j nd}|jW||z}|r|J|jYd|j j[d|Scc} w)NrFTrzUPDATE r"z SET rc36K|]\}}}}|dz|zyw)=Nr)rEr@r3rs rrGz+SQLCompiler.visit_update..s) !4 3J  szList[Tuple[Any, str, str, Any]]rHr WHERE rUPDATErr).rrrrJr;rrNrr1rrrrrr" _extra_fromsr2r/rrrrrrCr#rrr\rrrrr rSr#rWrrGr{r1rJrrrr rr)rr@rrr1r r"rrB is_multitable main_fromsrrender_extra_fromsr-rrr0 crud_paramsrextra_from_textrulcrs r visit_updatezSQLCompiler.visit_updateksx ; ::  !#  m^< <<#--  #!-B~ H::~H  DM)))6&%%%2" <<4 4$R/K<<,6L#. K L#00 [) ];+<+<=>J&"!:*=" ")..{;O!# *001O #2 /)    +D++[2268 D/T..      $    "22 +}h :< )66   (,(>(>Z) %M:!M  ( (  + +K <     %)1;&     " "k&<&<--d33++E{/E/E(04 5d55!!"  (   Oo--  & &111++9DHJA A %.d..  %0 46   C#I D  # #{'='=00 C$//''A;+A+A$,0 D 993;C OM***G$ND * **   x  0 r W"s  O Oc td)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 DELETErrrMrArBrFrs rdelete_extra_from_clausez$SQLCompiler.delete_extra_from_clauses" %  rc .|j|fddd|S)NT)rrr)rrMrArBrs rdelete_table_clausezSQLCompiler.delete_table_clauses,,z,,  d .0  rc &|j||fi|}|j}|||d<d}n |j }|r-d|_|js||_|j s||_|j tzr1tit}|j tz}|r ||_ nd}d}|j}|jhj|} |jj| | |dd} |j r!| |j"||j fi|z } | dz } |j%||j||} t+j,||||fi||j.r|j1|| \} } nd} |j2r|j5||| | z } |j6s |j8r>|j:r2| d|j=||j6xs |j8| zz } |r,|j>||j|| fd |i|}|r| d|zz } |j@r)|jB|j@fd |i|}|r| d |zz } |jD|fd |i|}|r| d|zz } |j6s |j8r>|j:s2| d|j=||j6xs |j8| zz } |jFr.|stI|jnd}|jK| | z} |r|J|jMd |jjOd| S#t&$r@|j%||j|} |r|j)|j|} YEwxYw)NrFTrzDELETE FROM )r"rHrr"rRrDELETErTr)(rr;rrLrr1rrrrrr"rUrrrrrra TypeErrorrr#rr\rrrrSr#rWrr_r{r1rNrrrr rr)rrMrrr1r r"rrBr-rrr@rrZrdlcrs r visit_deletezSQLCompiler.visit_deletes: ::  !# $--  #!-B~ H::~H  DM)))6&%%%2" <<4 4$R/K<<,6L#. K L#00 &,,-33K@ #2 /)    +D++[2268 D  M11!!' 2J dKOBO   (,(>(>Z) %M:!M  ( (  + +K <   # #{'='=,, C$//''A;+A+A$,0 D ;d;;!!  (   Oo--  & &111++9DHJA A %.d..  %0 46   C#I D  # #{'='=00 C$//''A;+A+A$,0 D 993;C OM***G$ND * **   x  0 r Y M11[.. JLL!2!2 LL Ms+MANNc >d|jj|zS)Nz SAVEPOINT %srformat_savepointrsavepoint_stmtrs rvisit_savepointzSQLCompiler.visit_savepoints > >~ NNNrc >d|jj|zS)NzROLLBACK TO SAVEPOINT %srirks rvisit_rollback_to_savepointz'SQLCompiler.visit_rollback_to_savepoints#)DMM,J,J -   rc >d|jj|zS)NzRELEASE SAVEPOINT %srirks rvisit_release_savepointz#SQLCompiler.visit_release_savepoints#% (F(F )   r)rrvr;rrrrr?rr2rrrzOptional[SQLCompiler]rr)r"rd)r"rR)r"zDict[Any, Any])rr@r"r#)r"zMutableMapping[CTE, str])r"zVMutableMapping[str, Union[_BindProcessorType[Any], Sequence[_BindProcessorType[Any]]]])r"zFrozenSet[str])r"r9)NT)rrrr2r"r:)NNTNTFN)rrrrrr2r Optional[int]rr2rr2rxz_CoreSingleExecuteParams | Noner"ruF)r<rurr2r"r:)r"zCallable[[Any], str]rNr)NFFNrF)NTrN)rColumnClause[Any]rOptional[_ResultMapAppender]rr2rr rz Optional[_AmbiguousTableNameMap]rrr"r r)NF)r3rTrrr"r )r3rUrrr"r )r3rRrrr"r )rv Function[Any]rrvrrr"r )rvrwrrr"r )FN)NFNN) rBinaryExpression[Any]rFr r&r2rrr"r )rrxrmrrrr"r )FFFFFF)rrr zsqltypes.TypeEngine[Any]r"r )rr r rLr"r )r r r"r )rr r r r"r )FFNNNN)r r rr2rr2rrdrzOptional[TypeEngine[Any]]rzOptional[Set[str]]rrfrrr"r )rrcrr2rr2rzOptional[_FromHintsType]r Optional[CTE]r"zOptional[FromLinter]rzselectable._CTEOptsrrr"rd) FFFNFFNNF)FNN) r r r r rr r rr"r#)NNNTFFT)rrdrrdr"rd)rr0rr2rr2r"z7Tuple[AbstractSet[FromClause], AbstractSet[FromClause]])FFNNNFN)rr6r"zTuple[str, _FromHintsType]rz Select[Any]rrr"r  rrIrzSequence[_ColumnsClauseElement]rr2rrr"r )NFF) FFFNTNNNF)rr^r"rY)r;r r<rqrz%List[_MutableCoreSingleExecuteParams]rrdrrUrWr2rrr"z Iterator[_InsertManyValuesBatch]r)r@rHrrr"rd)rMrFrrr"rd)r@rHrryrrr"r ( rrrr EXTRACT_MAPrr+rrIrrCOMPOUND_KEYWORDSrrLrMrNrPrQrSrTrWrXrYr]r^r_r`rarbrcrergrhrirrjrkrrlrpostfetch_lastrowidrnr@rorprqr|r~r=rpatternrrrrrrzrrrOrro_memoized_propertyrrrrmemoized_propertyrrmemoized_instancemethodr contextlibcontextmanagerrrrrrrrrrrrrpreload_modulerTrYrtr|r~rrrrrrrrrrrrrrrrrrrrrrr'r1r7r;r=r5rGrOrSrWrcrqrtryrrrrrrrrrrrrCrrrrrrrrrrr r9rr)r+r.r1r3rrrr<r>rErIrMrQrTrVrXrZr\r^r`rbrBrHrLrPrprrrvryr{r~rrr2r8r rrrrrrr)_CTEOptsrrrrrrr rrrrrr&r$rr?r:rDrGtypingrrrQrLrUrrr]rZrarr rr^rrrrrrrrrr1 CLIENTSIDErnrzSENTINEL_DEFAULTrrvrwrxrrrurrrr>rCrGrJrNr\r_rargrmrorqrrrrrds K    ; :/.66 F)HdHdHd +*%.0O*/.0O*/$BF>EK ((I--6 %$4',t+5:+T9 "OT!B!!%(' .- &+d*"OT!"d! ).- !ND  !&%=A "9@+/-. 6:295929=A:A> , = =,>> , 1 1,>> , 5 5,55 , 5 5,55 , ? ?,??# ($,$D#I#I , 1 1,:: $ << (<|oo-oC o C o  o"&o?o *od AEEN F  !), "!), ('+TT$T T Tl  CJO  rrceZdZdZddZdZejdfdZdZ dZ dZ d Z dd Z d Zd Zd ZdZfdZdZdZdZdZxZS)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` c "|jrdSdS)Nrr)rrs rr^z$StrSQLCompiler.get_select_precolumnss$..{6B6rcy)Nzrrs rrz$StrSQLCompiler._fallback_column_namesrzsqlalchemy.engine.urlc T|jdk7rtjj}|jj |jj }|j|d|}t|ts|j|fi|St|1||S)Nr)r) stringify_dialectr+rP engine_urlURLr get_dialectstatement_compilerrrrrr)rrrrurlrcompilerrs rrz,StrSQLCompiler.visit_unsupported_compilations  $ $ 1..++CMcggnnW%>%>?KKMOG1142Hh7'x''6266w4WcBBrc ~|j|jfi|d|j|jfi|dS)NrFrG)rrrrs rvisit_getitem_binaryz#StrSQLCompiler.visit_getitem_binarys: DLL + + DLL , ,  rc *|j||fi|Srrrs rvisit_json_getitem_op_binaryz+StrSQLCompiler.visit_json_getitem_op_binary(t((@R@@rc *|j||fi|Srrrs r!visit_json_path_getitem_op_binaryz0StrSQLCompiler.visit_json_path_getitem_op_binaryrrc @d|jj|dS)Nz)rformat_sequencers rrzStrSQLCompiler.visit_sequences#$T]]%B%B8%L$MQ O rc tj|Dcgc]}|jd|ddi}}ddj|zScc}w)NTFrr)r!rr$r)rrrrrrrs rrzStrSQLCompiler.returning_clausesZ++N;   % %dAtUB ?  dii000  sA c Pdd<ddjfd|DzS)NTrrcrc3HK|]}|jfdiywrNrrErrFrrs rrGz4StrSQLCompiler.update_from_clause..s0#  !A  B Br B# rr%rEs` ``rrGz!StrSQLCompiler.update_from_clauses38 #  #    rc Pdd<ddjfd|DzS)NTrrc3HK|]}|jfdiywrrrs rrGz:StrSQLCompiler.delete_extra_from_clause..s0  !A  B Br B rr%r^s` ``rr_z'StrSQLCompiler.delete_extra_from_clauses38 dii      rc y)NzSELECT 1 WHERE 1!=1rrs rrz#StrSQLCompiler.visit_empty_set_exprs$rc d|zS)Nz[%s]rrBs rr:z!StrSQLCompiler.get_from_hint_texts }rc <t||fd|ji|S)Nr)rrr )rrrrs rrz+StrSQLCompiler.visit_aggregate_strings_funcs,w3  "$'' -/  rc *|j|dfi|S)Nz rrs rrvz+StrSQLCompiler.visit_regexp_match_op_binary s,t,,V\HRHHrc *|j|dfi|S)Nz rrs rryz/StrSQLCompiler.visit_not_regexp_match_op_binarys,t,,V5ELLLrc d|jj|fi|d|jj|fi|dS)Nz(rrC)rrrrs rr{z-StrSQLCompiler.visit_regexp_replace_op_binarys> *FKK * *4 62 6 +FLL + +D 7B 7  rc d|jj|fi|d|jj|fi|dS)Nz TRY_CAST(rrC)rLrr)rr rs rvisit_try_castzStrSQLCompiler.visit_try_casts> *DKK * *4 :6 : .DOO . .t >v >  rrzr{)rrrrr^rr+rrrrrrrrGr_rr:rrvryr{rrrs@rrrs&7 T01 C2 C AA 1 18 1 " 1  1  1  % IM  rrceZdZdZer d; d d?dZ dZ dZ d Zd Zd@d ZdAd Z dBd Z dC dDdZdEdZ dCdZdZdZdFdZ dGdZdZ dE dHdZdZdZdZdZdZ dZ!dZ"dIdZ#dCdZ$d Z%d!Z& dJd"Z'dKd#Z(dKd$Z)dLd%Z*dMd&Z+d'Z,d(Z-d)Z. dNd*Z/ dOd+Z0d,Z1 dPd-Z2 dQd.Z3 dNd/Z4 dOd0Z5 dPd1Z6dRd2Z7 dPd3Z8 dSd4Z9 dSd5Z: dSd6Z;dTd7Zd:Z?y)U DDLCompilerTcyrrrs rrzDDLCompiler.__init__%s rcf|jj|jd|jS)Nr)rrrrKs rrzDDLCompiler.sql_compiler.s/||.. LL$T5N5N/  rc.|jjSr)rrrKs r type_compilerzDDLCompiler.type_compiler4s||222rNcyrrrs rrzDDLCompiler.construct_params8s rc |j}t|jtjr|j }|j }|j|j}t|dk(r|dd}}n |d|d}}|jd||jd||jd|j|j|jj|j|zS)Nr rrrrr(r)contextrtargetr(r^rrformat_table_seqrrr%rrr;)rddlrrrpathrschs r visit_ddlzDDLCompiler.visit_ddl@s++ cjj&,, /llnG}}H,,SZZ8D4yA~!!Wbs!"XtAws   w .   x -   z8+@+@+L M  223==73JKKrc xd}|jr|dz }||jj|jzS)NzCREATE SCHEMA IF NOT EXISTS ) if_not_existsr format_schemar)rrrrs rvisit_create_schemazDDLCompiler.visit_create_schemaSs9    $ $Ddmm11&..AAArc d}|jr|dz }||jj|jz }|jr|dz }|S)Nz DROP SCHEMA IF EXISTS  CASCADE) if_existsrrrcascaderdroprrs rvisit_drop_schemazDDLCompiler.visit_drop_schemaYsK >> L D  ++DLL99 << J D rc ,|j}|j}d}|jr!|dj|jdzz }|dz }|jr|dz }||j |dzz }|j |}|r||dzz }|dz }d}d}|jD]P} | j} |j| | jxr| } | ||z }d }|d | zz }| jrd }R|j||j } | r ||d z| zz }|d|j#|zz }|S#tj$rE} tjd |jd | jd| jd| d} ~ wwxYw)Nz CREATE rHzTABLE rrB Ffirst_pkr Tz (in table 'z ', column 'z'): r) _include_foreign_key_constraintsz )%s )rrrrrr%create_table_suffixrrrlr7r descriptionr argscreate_table_constraintsinclude_foreign_key_constraintspost_create_table)rrrrrrrr&r create_columnr processedceconsts rvisit_create_tablezDDLCompiler.visit_create_tablebs== ?? CHHU__-3 3D     $ $D %%e,s22"66u=  '#- -D   #^^ M"**F  LL!F,>,>,Ox<) (I%D &ID9,,D%%#H $-- -3-S-S.   I$u, ,D d44U;;; ## &&((&++rwwqzC s5AD;;FAFFc *|j|dfi|S)Nview_generate_table_selectrs rvisit_create_viewzDDLCompiler.visit_create_views*t**7FAbAArc *|j|dfi|S)Ncreate_table_asrrs rvisit_create_table_asz!DDLCompiler.visit_create_table_ass*t**74ELLLrc yNrr)rrr rs rcreate_table_select_suffixesz(DDLCompiler.create_table_select_suffixess rc |j}t|}d|d<|jj|jfi|}||n |j }dt |ddrdnd|jrdnd|dk(rt |d drd n|d k(rd nd |rdnd|j|jg} |j||fi|} | r| j| | d|gz } djd| DS)NTrCREATE or_replaceFz OR REPLACE TEMPORARYr materializedzMATERIALIZED VIEWrTABLEVIEWz IF NOT EXISTSASrHc3&K|] }|s| ywrrrErs rrGz5DDLCompiler._generate_table_select..s.aA.s) rrrrr)rr temporaryr%rrrr) rrr rrprepinner_kw select_sqluse_if_not_existsrsuffixess rrz"DDLCompiler._generate_table_selects}}8$(!.T&&..w/A/ANXN ( &&  #G\5ALt",,K$F?ww'N$ %): :W0Od   gmm , & 5444WeJrJ  LL " $ ##xx.5...rc |j}|jryj||}djfd|jD}|r|d|zz }|S)NrrHc3@K|]}j|ywrrrErrs rrGz2DDLCompiler.visit_create_column..s )3DLL $ s)rsystemget_column_specificationr constraints)rrrrrrrs` rvisit_create_columnzDDLCompiler.visit_create_columnsd ==,,Vh,G 7=7I7I    C%K D rc lg}|jr|j|j|j}||j|}n t }|j |j Dcgc]}||jur||vr|c}djdfd|DDScc}w)Nz, c3$K|]}|| ywrrrs rrGz7DDLCompiler.create_table_constraints..s  }   r"c3K|]I}|jr6jjr t|ddsj |Kyw) use_alterFN)_should_create_for_compilerrsupports_alterrrrs rrGz7DDLCompiler.create_table_constraints..sI::4@ 33":{EB  Z(r)rlrforeign_key_constraintsrSrr<_sorted_constraintsr)rrrrrall_fkcs omit_fkcsrs` rrz$DDLCompiler.create_table_constraintss       u00 100 + 7 ++,LMII22 E---!92D  }}  "-    s.B1c xd}|jr|dz }||jj|jzS)Nz DROP TABLE r)rrr%rrs rvisit_drop_tablezDDLCompiler.visit_drop_tables6 >> L Ddmm00>>>rc d}|jr|dz }n|dz }|jr|dz }||jj|jzS)Nz DROP zMATERIALIZED VIEW zVIEW r)rrrr%rrs rvisit_drop_viewzDDLCompiler.visit_drop_viewsS    ( (D GOD >> L Ddmm00>>>rc`|j"tjd|jzy)Nz,Index '%s' is not associated with any table.)rr7rr )rrs r_verify_index_tablezDDLCompiler._verify_index_tables0 ;; "">K  rc |j}j|j}d}|jr|dz }|jt j d|dz }|jr|dz }|j||d|j|j|d d jfd |jDd z }|S) NzCREATE UNIQUE z0CREATE INDEX requires that the index have a namezINDEX rinclude_schemarrrrc3ZK|]"}jj|dd$yw)FTrrN)rr)rEr3rs rrGz1DDLCompiler.visit_create_index..+s8!!))T*rrC) rrrrr r7rr_prepared_index_namer%rr expressions)rrrinclude_table_schemarrrrs` rvisit_create_indexzDDLCompiler.visit_create_indexs   '== << I D :: ""B      $ $D  % %eN % K  ! ! (< "  II"--     rc |j}|jtjdd}|jr|dz }||j |dzS)Nz.DROP INDEX requires that the index have a namez DROP INDEX rTr)rr r7rrr)rrrrrs rvisit_drop_indexzDDLCompiler.visit_drop_index4s^  :: ""@  >> L Dd//d/KKKrc|j&|jj|j}nd}|r|r|jj|}nd}|jj |}|r|dz|z}|SNrE)rrrr format_index)rrrr schema_name index_names rrz DDLCompiler._prepared_index_nameAsy ;; "#}}>>u{{K #  .--445EFKK--44U; $s*Z7Jrc d|jj|jjd|j |jS)N ALTER TABLE z ADD )rr%rrrrrrs rvisit_add_constraintz DDLCompiler.visit_add_constraintSs8 MM & &v~~';'; < LL (  rc d|jj|jd|jj |jj t jS)NzCOMMENT ON TABLE r)rr%rrr commentr*Stringr$s rvisit_set_table_commentz#DDLCompiler.visit_set_table_commentYsL MM & &v~~ 6    2 2&&(9   rc Rd|jj|jzS)NzCOMMENT ON TABLE %s IS NULL)rr%rrrrs rvisit_drop_table_commentz$DDLCompiler.visit_drop_table_commentas',t}}/I/I LL0   rc d|jj|jddd|jj |jj t jS)NzCOMMENT ON COLUMN T) use_tablerr)r format_columnrrr r'r*r(r$s rvisit_set_column_commentz$DDLCompiler.visit_set_column_commentfsZ MM ' '$4 (     2 2&&(9    rc Vd|jj|jdzS)NzCOMMENT ON COLUMN %s IS NULLT)r.)rr/rr+s rvisit_drop_column_commentz%DDLCompiler.visit_drop_column_commentps/- 0K0K LLD1L1   rc @tj|t|rrr$s rvisit_set_constraint_commentz(DDLCompiler.visit_set_constraint_commentus--dDLAArc @tj|t|rrr+s rvisit_drop_constraint_commentz)DDLCompiler.visit_drop_constraint_commentxs--dDJ??rcg}|j|jd|jz|j|jd|jz|j|jd|jz|j|jd|jz|j |jd|j |jd|j|jd|jz|j|j|jrdnd d j|S) NzINCREMENT BY %dz START WITH %dz MINVALUE %dz MAXVALUE %dz NO MINVALUEz NO MAXVALUEzCACHE %dCYCLEzNO CYCLErH) incrementrrminvaluemaxvalue nominvalue nomaxvaluecachecycler)ridentity_optionsrs rget_identity_optionsz DDLCompiler.get_identity_options{s  % % 1 KK),<,F,FF G  ! ! - KK*:*@*@@ A  $ $ 0 KK (8(A(AA B  $ $ 0 KK (8(A(AA B  & & 2 KK &  & & 2 KK &  ! ! - KK %5%;%;; <  ! ! - KK#3#9#9z Jxx~rc d}|jr|dz }||jj|jz }|r||z }|j |j}|r|d|zz }|S)NzCREATE SEQUENCE rrH)rrrrrA)rrrrroptionss rvisit_create_sequencez!DDLCompiler.visit_create_sequencesn!    $ $D  --fnn==  FND++FNN;  C'M !D rc xd}|jr|dz }||jj|jzS)NzDROP SEQUENCE r)rrrrrs rvisit_drop_sequencezDDLCompiler.visit_drop_sequences6 >> L Ddmm33DLLAAArc d|j}|j|jj|}nd}|"t j d|jzd|jj |jjd|jrdnd||jrdSdS)Nz2>> 44Z@@ rc |j|fi|}||j|fi|z }||j|z }||j|z }||j |z }|Sr)rddefine_foreign_key_bodydefine_constraint_matchdefine_constraint_cascadesrfrgs rvisit_foreign_key_constraintz(DDLCompiler.visit_foreign_key_constraints|/t..z@R@ ,,,Z>2>> ,,Z88 // ;; 44Z@@ rc$|j|S)z=Format the remote table clause of a CREATE CONSTRAINT clause.)r%)rrrrs rdefine_constraint_remote_tablez*DDLCompiler.define_constraint_remote_table s$$U++rc t|dk(ry|j|fi|}||j|fi|z }||j|z }|Srk)rrddefine_unique_bodyrfrgs rvisit_unique_constraintz#DDLCompiler.visit_unique_constraintsa z?a .t..z@R@ ''' 9b99 44Z@@ rc ld}|j%|jj|}||d|zz }|S)NrzCONSTRAINT %s )r rrH)rrrrrIs rrdz&DDLCompiler.define_constraint_preamblesB ?? &!]]<99 rc d}|dz }|ddjfd|jr |jn |jDzz }|S)Nrz PRIMARY KEY r4rc3hK|])}jj|j+ywrrrr rErrs rrGz6DDLCompiler.define_primary_key_body..*s,#  MM   '# /2)r_implicit_generatedcolumns_autoinc_firstrrgs` rrlz#DDLCompiler.define_primary_key_body%s`  # 1100'' #     rc :|jt|jdjj}ddj fd|jDd|j ||ddj fd|jDd}|S) Nrz FOREIGN KEY(rc3hK|])}j|jj+ywr)rparentr rErrs rrGz6DDLCompiler.define_foreign_key_body..:'23qxx}}-r}z ) REFERENCES rc3hK|])}j|jj+ywr)rrr rs rrGz6DDLCompiler.define_foreign_key_body..@rr}rC)rrr$rrrrt)rrr remote_tablerrs @rroz#DDLCompiler.define_foreign_key_body4s==J//03::@@ II7A7J7J   / /L(  II7A7J7J    rc ldj|fi|ddjfd|Dd}|S)NrrBrc3hK|])}jj|j+ywrr{r|s rrGz1DDLCompiler.define_unique_body..Ks$Fadmm))!&&1Fr}rC)!define_unique_constraint_distinctrrgs` rrvzDDLCompiler.define_unique_bodyFs: 3D 2 2: D D IIF:F F  rc \d|jj|jddz}|S)Nz CHECK (%s)FTr)rrrrgs rrezDDLCompiler.define_check_bodyOs8d//77   e48   rc yrrr`s rrz-DDLCompiler.define_unique_constraint_distinctUsrcd}|j||j|z }|j||j|z }|Sr)ondelete"define_constraint_ondelete_cascadeonupdate"define_constraint_onupdate_cascaderrrs rrqz&DDLCompiler.define_constraint_cascadesZsP    * D;;JG GD    * D;;JG GD rc\d|jj|jtzS)Nz ON DELETE %s)rrkr FK_ON_DELETErrs rrz.DDLCompiler.define_constraint_ondelete_cascadee-!B!B   "   rc\d|jj|jtzS)Nz ON UPDATE %s)rrkr FK_ON_UPDATErs rrz.DDLCompiler.define_constraint_onupdate_cascadelrrcd}|j|jr|dz }n|dz }|j0|d|jj|jtzz }|S)Nrz DEFERRABLEz NOT DEFERRABLEz INITIALLY %s)rrrrk FK_INITIALLYrs rrfz+DDLCompiler.define_constraint_deferrabilityssq  ,$$ %))    + Odmm&G&G$$l' D rcFd}|j|d|jzz }|S)Nrz MATCH %s)rUrs rrpz#DDLCompiler.define_constraint_matchs-    ' K*"2"22 2D rc d|jj|jddz}|jdur|dz }|S|jdur|dz }|S)NzGENERATED ALWAYS AS (%s)FTrz STOREDz VIRTUAL)rrr persisted)r generatedrrs rvisit_computed_columnz!DDLCompiler.visit_computed_columnsr)D,=,=,E,E   U$-F-     $ & I D  E ) J D rc dd|jrdndd}|j|}|r|d|zz }|S)Nz GENERATED ALWAYSz BY DEFAULTz AS IDENTITYr)alwaysrA)rrNrrrCs rvisit_identity_columnz!DDLCompiler.visit_identity_columns@ H\ 9 ++H5  Gg% %D r)...) rrvr;rErrrr2rrrrr)rrDrrr"r )rrCrrr"r )rrBr r rrr"r r) rrBr r rzOptional[bool]rrr"r rs)rr\r"r#)FT)rr\rr2r"r )r@r[r"r )r Column[Any]rrr"r )rr^r"r )rrr"rd)rzUnion[Visitable, str]r"r )rr]rrr"r )rrZrrr"r )rr_rrr"r )rrYrrr"r )rrWrrr"r )rrZr"r )rrYr"r )@rrrrrrr+rrrrrrrrrrrrrrrr r rrrrr%r)r,r0r2r4r6rArDrFrJrrrrLrYrar_r^rmrrrtrwrdrlrorvrerrqrrrfrprrrrrrr sU F FI,/03   , #C   &*   .      33 6:GK! 2E  3 L&B 2hBM   )- $/ $/$/& $/  $/ $/L  7;# J? ?BF@ L49,0 $     B@( B  &!-0 : J;   .69 .69 , *25 $,/  . 69   .69 $*25  *25  .    .   .    rrceZdZd1dZd2dZ d3dZd4dZd5dZd6dZd7dZ d8dZ d9d Z d:d Z d;d Z ddZd?dZ d@ dAdZdBdZdCdZdDdZdEdZd?dZdFdZdGdZdHdZdIdZdJdZdFdZ dGdZdJdZd=dZ d;d Z!dtu+++rc (|j|fi|Sr)rr s rvisit_datetimez"GenericTypeCompiler.visit_datetimeAs"t""5/B//rc (|j|fi|Sr)rr s r visit_datezGenericTypeCompiler.visit_dateDr rc (|j|fi|Sr)rr s rvisit_big_integerz%GenericTypeCompiler.visit_big_integerG t  -"--rc (|j|fi|Sr)rr s rvisit_small_integerz'GenericTypeCompiler.visit_small_integerJs#t""5/B//rc (|j|fi|Sr)rr s r visit_integerz!GenericTypeCompiler.visit_integerOr rc (|j|fi|Sr)rr s r visit_realzGenericTypeCompiler.visit_realRr rc (|j|fi|Sr)rr s r visit_floatzGenericTypeCompiler.visit_floatUst,,,rc (|j|fi|Sr)rr s r visit_doublez GenericTypeCompiler.visit_doubleXr rc (|j|fi|Sr)rr s r visit_numericz!GenericTypeCompiler.visit_numeric[r rc (|j|fi|Srrr s r visit_stringz GenericTypeCompiler.visit_string^r rc (|j|fi|Srr r s r visit_unicodez!GenericTypeCompiler.visit_unicodear rc (|j|fi|Srrr s r visit_textzGenericTypeCompiler.visit_textdr rc (|j|fi|Srr% r s rvisit_unicode_textz&GenericTypeCompiler.visit_unicode_textgr rc (|j|fi|Srr r s r visit_enumzGenericTypeCompiler.visit_enumlr rc 2tjd|z)NzKCan't generate DDL for %r; did you forget to specify a type on this Column?rr s rrzGenericTypeCompiler.visit_nullos" #%* +  rc Z|j|j|jfi|Sr)r type_enginerr s rvisit_type_decoratorz(GenericTypeCompiler.visit_type_decoratorvs)t||E--dll;BrBBrc &|jdi|Srt) get_col_specr s rvisit_user_definedz&GenericTypeCompiler.visit_user_defined{s"u!!'B''r)r zsqltypes.Float[Any]rrr"r )r zsqltypes.Double[Any]rrr"r )r zsqltypes.DOUBLE_PRECISION[Any]rrr"r )r zsqltypes.REAL[Any]rrr"r )r zsqltypes.Numeric[Any]rrr"r )r zsqltypes.DECIMAL[Any]rrr"r )r zsqltypes.Integerrrr"r )r zsqltypes.SmallIntegerrrr"r )r zsqltypes.BigIntegerrrr"r )r zsqltypes.TIMESTAMPrrr"r )r zsqltypes.DateTimerrr"r )r z sqltypes.Daterrr"r )r z sqltypes.Timerrr"r )r z sqltypes.CLOBrrr"r )r z sqltypes.Textrrr"r r)r r rrrrrdrrdrzOptional[IdentifierPreparer]rrr"r )r z sqltypes.CHARrrr"r )r zsqltypes.NCHARrrr"r )r zsqltypes.Stringrrr"r )r zsqltypes.NVARCHARrrr"r )r zsqltypes.Uuid[Any]rrr"r )r zsqltypes.LargeBinaryrrr"r )r zsqltypes.BINARYrrr"r )r zsqltypes.VARBINARYrrr"r )r zsqltypes.Booleanrrr"r )r zsqltypes.Unicoderrr"r )r zsqltypes.UnicodeTextrrr"r )r z sqltypes.Enumrrr"r )r zTypeDecorator[Any]rrr"r )r zUserDefinedType[Any]rrr"r )2rrrrrrrrrrrrrrrrrrrrrrrrrrrrrr r r r r r r r r r r r r r! r# r& r( r* rr. r1 rrrrrs"3";>" "   +/<@ !  (  :  (     IL 0,),14, , /,0,.0*0250 0 /,-.///,,),14, , / C'C/2C C ()(14( (rrc*eZdZdZdZdZdZdZy)StrSQLTypeCompilerc r |j}||fi|S#t$r|j|fi|cYSwxYwr)rAttributeError_visit_unknown)rr rrs rrzStrSQLTypeCompiler.processsN 2!&!9!9 &d1b1 1 4&4&&u33 3 4s 66cR|jdr |jSt|)Nr)rr6 r5 )rrFs r __getattr__zStrSQLTypeCompiler.__getattr__s% >>( #&& & % %rc |jj|jjjk(r|jjSt|Sr)rrupperreprr s rr6 z!StrSQLTypeCompiler._visit_unknownsA ?? # #u'?'?'E'E'G G??++ +; rc yrrr s rrzStrSQLTypeCompiler.visit_nullrrc ` |j}|di|S#t$rt|cYSwxYwrt)r0 r5 r; )rr rr0 s rr1 z%StrSQLTypeCompiler.visit_user_defineds= & --L %"% % ;  s --N)rrrrr8 r6 rr1 rrrr3 r3 s2&  &rr3 ceZdZddZy)_SchemaForObjectCallablecyrr)rrs rr!z!_SchemaForObjectCallable.__call__rN)rrr"r r$rrrr? r? s/rr? ceZdZddZy)rUcyrr)rrs rr!z _BindNameForColProtocol.__call__rA rN)rrur"r r$rrrrUrUs:rrUcfeZdZUdZeZeZeZ de d<de d<de d<e jdZ de d < d Zd e d < d+ d,dZdZ d-dZd.dZd.dZdZd.dZd/dZdZd0dZd1dZd2dZ d3 d4dZ d2 d5dZ d2 d6dZd2dZej@d d3 d7dZ! d3 d8d Z" d3 d8d!Z# d9d"Z$d:d#Z% d; dd'Z)d3d(Z*ejVd)Z,d?d*Z-y )@rz@Handle quoting and case-folding of identifiers based on options.r  initial_quote final_quotezMutableMapping[str, str]_stringsr(r? rFr2_includes_none_schema_translateNc||_||_|xs |j|_||_|jdz|_||_||_i|_|jjdv|_ y)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. r6)rrN) rrE rF escape_quoteescape_to_quote omit_schemaquote_case_sensitive_collationsrG rr)rrrE rF rJ rM rL s rrzIdentifierPreparer.__init__st. *&<$*<*<(#0014&/N, $ 7 7< ! rc|jj|j}|jj|jd|vfd}||_|_|S)Nc|j}|jr:|r6| d|vsd|vrtjd|zt d|xsdzdS|jS)NrFrGzJSquare bracket characters ([]) not supported in schema translate name '%s'z __[SCHEMA_%s]_noneFr)r(_use_schema_mapr7rr3)rr  includes_nones r symbol_getterz@IdentifierPreparer._with_schema_translate..symbol_gettersw::D""(8M#t **8:>?##tw7uzz!r)r__new__rrrrH )rrrrT rS s @rrz)IdentifierPreparer._with_schema_translatesX~~%%dnn5 T]]+ 44  ""//<, rc|dvr)jstjddd<fd}tjd||S)Nzschema translate map which previously did not have `None` present as a key now has `None` present; compiled statement may lack adequate placeholders. Please use consistent keys in successive schema_translate_map dictionaries.rP c|jd}|vr|}n|dvrtjd|}|s-jj}|stj dj |S)Nr6)NrP zschema translate map which previously had `None` present as a key now no longer has it present; don't know how to apply schema for compiled statement. Please use consistent keys in successive schema_translate_map dictionaries.zLDialect has no default schema name; can't use None as dynamic schema target.)rr7rIrdefault_schema_namerr)rr rdrs rrz=IdentifierPreparer._render_schema_translates..replace s771:Dqy#$T7 ?*11=$( ##'<<#C#C '**=$$%56 6rz(__\[SCHEMA_([^\]]+)\]))rH r7rIr|r)rr;rrrY s` @rrz,IdentifierPreparer._render_schema_translates s\ ! 1977--94AgJ 72vv0'9EErc|j|j|j}|jr|jdd}|S)zEscape an identifier. Subclasses should override this to provide database-dependent escaping behavior. rAr)rrJ rK rrrs r_escape_identifierz%IdentifierPreparer._escape_identifier- s> d//1E1EF  MM#t,E rcN|j|j|jS)zCanonicalize an escaped identifier. Subclasses should override this to provide database-dependent unescaping behavior that reverses _escape_identifier. )rrK rJ r[ s r_unescape_identifierz'IdentifierPreparer._unescape_identifier9 s!}}T1143D3DEErcx|7|j|s&tjd|d|jd|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. zUnexpected SQL phrase: z (matching against rC)rUr7rr)rrrs rrkz&IdentifierPreparer.validate_sql_phraseB s=  syy'9""CKK) rcX|j|j|z|jzS)z~Quote an identifier. Subclasses should override this to provide database-dependent quoting behavior. )rE r\ rF r[ s rquote_identifierz#IdentifierPreparer.quote_identifierR s3   %%e, -  rc|sy|j}||jvxs?|d|jvxs,|jj t | xs||k7S)z5Return True if the given identifier requires quoting.Tr)rreserved_wordsillegal_initial_characterslegal_charactersrUr )rrlc_values rrz#IdentifierPreparer._requires_quotes_ sn ;;= ++ + #Qx4::: #((..s5z:: #E!  rcL|jjt| S)zjReturn True if the given identifier requires quoting, but not taking case convention into account.)re rUr r[ s rrz1IdentifierPreparer._requires_quotes_illegal_charso s"((..s5z:::rc$|j|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 rQ )rr(s rrzIdentifierPreparer.quote_schemat szz&!!rc t|dd}|k||jvr|j|S|j|r|j||j|<n||j|<|j|S|r|j|S|S)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 rN)rrG rra )rrforces rrzIdentifierPreparer.quote sw- = %}}U++((/+/+@+@+GDMM%(+0DMM%(}}U++ ((/ /Lrcv|jr|j|}n|}||j|d|S|Sr)rM rr)rcollation_namerr s rrz#IdentifierPreparer.format_collation sG  / /::n-D!D  '''(89:!D6B BKrc|j|j}|j|}|js|r||j |dz|z}|Sr)rr rrL r)rrrr rs rrz"IdentifierPreparer.format_sequence s[zz(--(11(;   ,$$%56GF rc$|j|S)zPrepare a quoted schema name.rQ rs rrz IdentifierPreparer.format_schema-!szz$rc~|+t|tjr|j|}|j |S)Prepare a quoted column name.)rr$rLrr)rr rs rrz$IdentifierPreparer.format_label_name2!s;  J (++% >>(+Dzz$rcv||j}|J|+t|tjr|j |}t |ddsF|r3|j |j||dz|j|zS|j|S|r$|j |j||dz|zS|S)r rF)rr rE) r rr$rLrrr%rr)rrr.r  table_namerrs rr/z IdentifierPreparer.format_column@!s <;;D# ##  J (++% >>(+Dv|U3%% *&jj& 'zz$'' %% *&  rc|j|}|js(|r&|r$|j||j|dfS|j|dfS)z(Format table name and schema as a tuple.Fr)rrL rr%)rrrrs rrz#IdentifierPreparer.format_table_seqn!sj 11%8J3C!!"23!!%E!:  %%e%>@ @rcd|j|j|j|jfD\}}}tjd|||dz}|S)Nc3FK|]}tj|ywr)r|r}r s rrGz4IdentifierPreparer._r_identifiers..!s )  IIaL) s!zM(?:(?:%(initial)s((?:%(escaped)s|[^%(final)s])+)%(final)s|([^\.]+))(?=\.|$))+)initialfinalr)rE rF r\ r|r~)rr r escaped_finalrs r_r_identifiersz!IdentifierPreparer._r_identifiers!sp) ""  ''(8(89) %  JJ $"EmL M  rc|j}|j|Dcgc] \}}|xs| c}}Dcgc]}|j|c}Scc}}wcc}w)z:Unpack 'schema.table.column'-like strings into components.)r findallr^ )r identifiersr arrs runformat_identifiersz'IdentifierPreparer.unformat_identifiers!s]   *+;)?@Aaf1f@   % %a (  @ s AA)rNrTF) rrvrE r rF rdrJ r rM r2rL r2)r;r rrwr"r )rr r"r )rr r"r2)r(r r"r )rr r"r r)T)rzschema.Sequencerr2r"r )rz Label[Any]r rdr"r )rzOptional[AliasedReturnsRows]r rdr"r )rzUnion[Constraint, Index]rt r2r"rd)r r rt r2r"r )r r r~ rUrt r2r"r )rr\r"r )TN)rrdrr2r rdr"r )FNNFN)rzColumnElement[Any]r.r2r rdr rdrr2rzOptional[Mapping[str, Any]]r"r )r r r"z Sequence[str]).rrrrRESERVED_WORDSrc LEGAL_CHARACTERSre ILLEGAL_INITIAL_CHARACTERSrd rrm attrgetterrrH rrrr\ r^ rkra rrrrrrrrrjr+rrHrw rx r| rr%rrr/rrr r rrrrrsJ#N'!;&&2E(2E2Eh2O/O-2#T1 !%)04!" " " # "  " *. " " H0)F)F4J)F )FV F   ; "8 =A ' 59    8<..'4. . JN$1$9F$ $T01KO2DH 2415    )-    15    )-     $ $" $48 $  $ "   (   " "$( 04,",, , " ,  ,., ,\A" " rr( r __future__rrcollections.abcabcrrenumrrrrmr|timerrrrrr r r r r rrrrrrrrrrrrrrrrrrrr!r"r#r$r%r&r'r(r)r*r+r_typingr,r-r.r/r0r1r2r3r4visitorsr5r7r8 util.typingr9r:r; annotationr<r=r>r?r@rrArrBrCrDrEdmlrFrGrHrIrJrKrLrMrNrOrPrQrRrSrTrUrVrWrXrYrZr[r\r]r^r_r`rarbrcrdrerfrgrhtype_apirirjrkrlrm engine.cursorrnengine.interfacesrorprqrrrsrtrurvrwr _FromHintsTyper r~Ir LEGAL_CHARACTERS_PLUS_SPACErrr rrrrlr,_bind_params_regexrUNICODErrrr-or_rmulrmodnegltlenegtgeeqis_distinct_fromis_not_distinct_from concat_opr not_match_oprrrrrrrrexistsrinvany_opall_opdesc_opasc_opnulls_first_op nulls_last_opbitwise_xor_op bitwise_or_opbitwise_and_opbitwise_not_opbitwise_lshift_opbitwise_rshift_oprrrrrrrrrrrrcuberollup grouping_setsrrr|_CompoundSelectKeywordr UNION_ALLr EXCEPT_ALLr INTERSECT_ALLr}r rr%r&r'r)r+r0r:rQrarnr~rrrJrrrr namedtuplerr EnsureKWArgrBinaryElementRoleCompilerColumnElementrr#r2rrrrr3 r? rUr)rMs0rr s$#)  ! &2!%"  +," )#$")#**''&' #'",',(1./&+'"','$)#4<:<=3=C+:lC'(_B2::.5(bjj):BDDA.3Arl;c!f;AA3%HrzzMM6?. @fA. BfC. FwG. HfI. JnK. L] e U e c  [.  b  N N !4 N  . h y N NNF NNF h _- )&       ""$( &%%++W%%//%%,,h%%00,%%//%%33_ > !*  Ji 111:J:zA AHZ2!;!*1G1( G  g.FK FB & l ?#''' w6HI?#D''DF4##F0 C ("@"@2  C ("@"@ B#  C ("@"@# LB] (B] Jzt [t nw (w td(,d(N&,&B0x0;h;n n Qu