U
|
¸ý°dª£ ã @ sÄ d dl mZ d dlmZ d dlZd dlZd dlZd dlmZ d dlm Z d dlm
|
Z
|
d dlm Z d dlm Z d dlm Z d d lmZ d d
|
lmZ d d lmZ d d lmZ d d lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ ddlmZ ddlmZ ddlmZ ddl m Z ddl m Z ddl m Z ddl!m"Z" ddlm#Z# d d lm$Z$ d d lm%Z% d d lm&Z& d d l'm(Z( ejr´dd!lm)Z) dd"lm*Z* dd#lm+Z+ dd$lm,Z, dd%l m-Z- dd&l m.Z. dd'l m/Z/ dd(l m0Z0 dd)l m1Z1 dd*l2m3Z3 dd+l)m4Z4 dd,l)m5Z5 dd-l)m6Z6 dd.l)m7Z7 dd/l)m8Z8 dd0l)m9Z9 dd1l)m:Z: dd2l+m;Z; dd3l,m<Z< dd4l,m=Z= dd5l,m>Z> dd6l,m?Z? dd7l,m@Z@ dd8l,mAZA dd9lmBZB ed:ejCd;ZDed<e d=ef d;ZEed>ejFd;ZGed?ed;ZHd@dA ZIdBdC ZJdDdDdDdEdFdGdHZKdDdDdIdJdKdLdMZLedNdOdOdDdPdQdRZMed=dSdTdOdUdOdDdVdWdRZMedXdOdOdYdPdZdRZMed[dOdOd\dPd]dRZMed^dOdOd_dPd`dRZMedadOdOdbdPdcdRZMedddedOdfdPdgdRZMedhdedOdidPdjdRZMedkdOdOdldPdmdRZMedndodOdpdPdqdRZMedrdsdOdsdPdtdRZMedudvdOdvdPdwdRZMedxdydOdzdPd{dRZMed=d|dxdvdUdOd}d~ddRZMedddOddPddRZMedd
dOd
dPddRZMeddOdOdOdPddRZMddddddOddddOdOdddRZMdTdOdOdDdPddZNd^dddddZOG dd dZPG dd dZQG dd dZRG dd dePZSG dd d ePZTde$jUddfdOdd¡dd¢d£d¤d¥d¦ZVG d§d¨ d¨ePZWG d©dª dªePZXG d«d¬ d¬ePZYG dd® d®ePZZG d¯d° d°ePZ[G d±d² d²ePZ\G d³d´ d´eTePZ]G dµd¶ d¶e]ePZ^G d·d¸ d¸ePZ_G d¹dº dºeTePZ`G d»d¼ d¼eXeTePZaG d½d¾ d¾eXePZbG d¿dÀ dÀeWePZcG dÁd dÂeSePZdG dÃdÄ dÄeXePZeG dÅdÆ dÆeXeTePejfZgG dÇdÈ dÈegePZhG dÉdÊ dÊegePZiG dËdÌ dÌeSePZjG dÍdÎ dÎePZkG dÏdÐ dÐeRePZlG dÑdÒ dÒeQeXePZmG dÓdÔ dÔeQeSePZnG dÕdÖ dÖenZoG d×dØ dØePZpG dÙdÚ dÚe]ZqG dÛdÜ dÜeZeXePZrG dÝdÞ dÞePZsG dßdà dàeXePZtG dádâ dâeWePZuG dãdä däesZvG dådæ dæePZwG dçdè dèePZxG dédê dêeZeWePZyG dëdì dìeyZzG dídî dîezZ{G dïdð dðeZeWePZ|G dñdò dòeWePZ}G dódô dôeWePZ~i ZeeD ]JZeeeZe dõ¡rBe
dõdö¡Zee krBe e eZeee< qBesÀeej ZeeeefD ]Zeeeje < qªdS )÷é )Ú annotationsN)ÚAny)ÚCallable)Úcast)ÚDict)ÚIterable)ÚIterator)ÚList)ÚNoReturn)ÚOptional)Úoverload)ÚSequence)ÚTuple)ÚType)Ú TYPE_CHECKING)ÚTypeVar)ÚUnioné )Ú operators)Úroles)Úvisitors)Úis_from_clause)ÚExecutableOption)ÚOptions)Ú HasCacheKey)Ú Visitableé )Úexc)Ú
|
inspection)Úutil)ÚLiteral)Úelements)Úlambdas)Úschema)Ú
|
selectable)Ú_ColumnExpressionArgument)Ú_ColumnsClauseArgument)Ú_DDLColumnArgument)Ú_DMLTableArgument)Ú_FromClauseArgument)Ú_DMLTableElement)Ú BindParameter)Ú ClauseElement)Ú ColumnClause)Ú ColumnElement)ÚDQLDMLClauseElement)Ú NamedColumn)ÚSQLCoreOperations)ÚColumn)Ú_ColumnsClauseElement)Ú_JoinTargetProtocol)Ú
|
FromClause)ÚHasCTE)Ú
|
SelectBase)ÚSubquery)Ú_TraverseCallableTypeÚ_SR)ÚboundÚ_F.Ú _StringOnlyRÚ_Tc C s t | ttjf o t| d S )zhReturn whether or not the element is a "literal" in the context
|
of a SQL expression construct.
|
|
Ú__clause_element__)Ú
|
isinstancer r# ÚSchemaEventTargetÚhasattr)Úelement© rD úOd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/sql/coercions.pyÚ _is_literalO s þ
|
ýrF c C sr t | tjr2t | ts2| D ]}t|s dS qdS t | ttjtt t
|
j j f opt | d opt | t ppt| t S )a Return whether or not the element is a "literal" in the context
|
of a SQL expression construct.
|
|
does a deeper more esoteric check than _is_literal. is used
|
for lambda elements that have to distinguish values that would
|
be bound vs. not without any context.
|
|
FTr? )r@ Úcollections_abcr ÚstrÚ_deep_is_literalr r# rA r r r Z langhelpersÚsymbolrB ÚtypeÚ
|
issubclass)rC ÚelemrD rD rE rI [ s,
|
ÿûþ
|
|
ö
|
òrI rH zCallable[[_F], _F])Ú paramnameÚmeth_rstÚ param_rstÚreturnc C s t | d||f ¡S )NzÆ.. warning:: The %s argument to %s can be passed as a Python string argument, which will be treated as **trusted SQL text** and rendered as given. **DO NOT PASS UNTRUSTED INPUT TO THIS PARAMETER**.)r Zadd_parameter_text)rN rO rP rD rD rE Ú_document_text_coercion s ùþrR z+Union[Sequence[_T], Sequence[Sequence[_T]]]ú Sequence[_T])ÚattrnameÚfnnameÚargsrQ c C sb |rXt |d tttfrXt|dkrXt |d trJt d| d| d¡td|d S td|S )Nr r zThe "z" argument to zt(), when referring to a sequence of items, is now passed as a series of positional elements, rather than as a list. rS )r@ ÚlistÚsetÚdictÚlenr Ú ArgumentErrorr )rT rU rV rD rD rE Ú!_expression_collection_was_a_list s $ÿr\ z Type[roles.TruncatedLabelRole]r )ÚrolerC ÚkwrQ c K s d S ©NrD ©r] rC r^ rD rD rE Úexpect£ s ra )Úas_keyzType[roles.DMLColumnRole]z Literal[True])r] rC rb r^ rQ c K s d S r_ rD )r] rC rb r^ rD rD rE ra ¬ s z Type[roles.LiteralValueRole]zBindParameter[Any]c K s d S r_ rD r` rD rD rE ra · s z!Type[roles.DDLReferredColumnRole]z Column[Any]c K s d S r_ rD r` rD rD rE ra À s z#Type[roles.DDLConstraintColumnRole]zUnion[Column[Any], str]c K s d S r_ rD r` rD rD rE ra É s z Type[roles.StatementOptionRole]r/ c K s d S r_ rD r` rD rD rE ra Ò s z&Type[roles.LabeledColumnExprRole[Any]]z _ColumnExpressionArgument[_T]zNamedColumn[_T]c K s d S r_ rD r` rD rD rE ra Û s zgUnion[Type[roles.ExpressionElementRole[Any]], Type[roles.LimitOffsetRole], Type[roles.WhereHavingRole]]zColumnElement[_T]c K s d S r_ rD r` rD rD rE ra ä s
|
z¡Union[Type[roles.ExpressionElementRole[Any]], Type[roles.LimitOffsetRole], Type[roles.WhereHavingRole], Type[roles.OnClauseRole], Type[roles.ColumnArgumentRole]]zColumnElement[Any]c K s d S r_ rD r` rD rD rE ra ñ s zType[roles.DMLTableRole]r( r* c K s d S r_ rD r` rD rD rE ra s zType[roles.HasCTERole]r6 c K s d S r_ rD r` rD rD rE ra s z Type[roles.SelectStatementRole]r7 c K s d S r_ rD r` rD rD rE ra s zType[roles.FromClauseRole]r) r5 c K s d S r_ rD r` rD rD rE ra s )Úexplicit_subqueryr8 )r] rC rc r^ rQ c K s d S r_ rD )r] rC rc r^ rD rD rE ra $ s z Type[roles.ColumnsClauseRole]z_ColumnsClauseArgument[Any]r3 c K s d S r_ rD r` rD rD rE ra / s zType[roles.JoinTargetRole]r4 c K s d S r_ rD r` rD rD rE ra 8 s z Type[_SR]c K s d S r_ rD r` rD rD rE ra B s F)Úapply_propagate_attrsÚargnameÚ post_inspectzOptional[ClauseElement]ú Optional[str]Úbool)r] rC rd re rf r^ rQ c K sú | j r2t|r2t|dr2tj|| tjf ||dS t| }|}t|tj t
|
j t
|
j tj fsLd }|jrt|j|f|}nÖ|}d} |jrt|| rt|drd} n(t|drÄd} t|ddsÄ| ¡ }qqÄq| sF|jr$tj|dd}
|
|
|
d k r$|rô|
|
j z |
|
¡ }W n" tk
|
r" | ||¡ Y nX |d krJ|j|fd|i|}n|}n t|tj rh|jf |}n|}|d k rªtjrt|t t fst |j sª|j rª|j |_ |j |j!j"krÞ|j#rÚ|j#|f||d |}|S |j$||fd|i|S d S )
|
NÚ__code__)rd Fr? TÚis_clause_element)Zraiseerrre )re Úoriginal_element)%Ú allows_lambdaÚcallablerB r" Z LambdaElementZ LambdaOptionsÚ _impl_lookupr@ r! ZCompilerElementr# Z
|
SchemaItemZ FetchedValueZ PyWrapperÚ_resolve_literal_onlyÚ_literal_coercionÚ$_skip_clauseelement_for_target_matchÚgetattrr? Ú_use_inspectionr ÚinspectZ _post_inspectÚAttributeErrorÚ_raise_for_expectedZ_sa__py_wrapper_literalÚtypingr r1 r, ÚAssertionErrorZ_propagate_attrsÚ _role_classÚ __class__Ú__mro__Ú_post_coercionÚ_implicit_coercions) r] rC rd re rf r^ Úimplrk Úresolvedrj ZinsprD rD rE ra K s°
|
ÿúù
|
ü üþ ÿþý
|
|
|
|
ÿÿÿ
|
ÿþÿýü ÿÿÿc K s" | dd ¡ t| |fddi|S )Nrb T)Úpopra r` rD rD rE Ú expect_as_keyÀ s r z Iterable[_DDLColumnArgument]zwIterator[Tuple[Union[str, Column[Any]], Optional[ColumnClause[Any]], Optional[str], Optional[Union[Column[Any], str]]]])r] Ú expressionsrQ c c s |D ]~}d }d }t | |}t|tr<t|ts2t| }}n(g }|j}t |i d|i¡ |rd|d }|d k rp|n|}||||fV qd S )NÚcolumnr )ra r@ rH rx Úappendr Ztraverse) r] r ÚexprZstrnamer r ÚcolsZ
|
col_appendZ add_elementrD rD rE Ú expect_col_expression_collectionÇ s
|
|
|
r c
|
@ sl e Zd ZU dZdd ZdZded< dZdZdd Z dddd
|
ddd d d Z
|
ddd
|
dd
|
d
|
ddddddZ dS )ÚRoleImpl)ry Únamers c K s
|
t d S r_ )ÚNotImplementedError©ÚselfrC r^ rD rD rE rp è s zRoleImpl._literal_coercionNr r| Fc C s || _ |j| _t|tj| _d S r_ )ry Z
|
_role_namer rL r ZUsesInspectionrs )r Z
|
role_classrD rD rE Ú__init__ï s zRoleImpl.__init__rg ©rC r re r^ rQ c K s | |||¡ d S r_ ©rv ©r rC r re r^ rD rD rE r} ô s z RoleImpl._implicit_coercionsú Optional[Any]úOptional[Exception]r
|
©rC re r ÚadviceÚcodeÚerrr^ rQ c
|
K sn |d k r ||k r d||f }nt |}|r<d| j||f } nd| j|f } |rZ| d| 7 } tj| |d|d S )Nz!%r object resolved from %r objectz$%s expected for argument %r; got %s.z%s expected, got %s.ú )r )Úreprr r r[ )
|
r rC re r r r r r^ ÚgotÚmsgrD rD rE rv ý s
|
ý z RoleImpl._raise_for_expected)N)NNNNN) Ú__name__Ú
|
__module__Ú __qualname__Ú __slots__rp r| Ú__annotations__ro rq r r} rv rD rD rD rE r å s
|
ü ùr c @ s e Zd ZdZdd ZdS )Ú _DeannotaterD c K s ddl m} ||S )Nr )Ú_deep_deannotate)r r¡ )r r r^ r¡ rD rD rE r| s z_Deannotate._post_coercionN©r r r r r| rD rD rD rE r s r c @ s e Zd ZdZdZdS )Ú _StringOnlyrD TN)r r r r ro rD rD rD rE r£ $ s r£ c @ s" e Zd ZdZdddZdd ZdS )Ú_ReturnsStringKeyrD Nc K s t |tr|S | |||¡ d S r_ ©r@ rH rv r rD rD rE r} - s
|
z%_ReturnsStringKey._implicit_coercionsc K s |S r_ rD r rD rD rE rp 3 s z#_ReturnsStringKey._literal_coercion)N©r r r r r} rp rD rD rD rE r¤ * s
|
r¤ c @ s" e Zd ZdZdd ZdddZdS )Ú_ColumnCoercionsrD c C s t d¡ d S )Nz|implicitly coercing SELECT object to scalar subquery; please use the .scalar_subquery() method to produce a scalar subquery.)r Úwarn)r rD rD rE Ú"_warn_for_scalar_subquery_coercion: s ÿz3_ColumnCoercions._warn_for_scalar_subquery_coercionNc K s~ |}t |dds | |||¡ nZ|jr6| ¡ | ¡ S |jrZt|tjrZ| ¡ |j ¡ S | j
|
j rl|j rl|S | |||¡ d S )Nrj F) rr rv Ú_is_select_baser© Úscalar_subqueryÚ_is_from_clauser@ r$ r8 rC ry rl Ú_is_lambda_element)r rC r re r^ rk rD rD rE r} A s ÿ
|
z$_ColumnCoercions._implicit_coercions)N)r r r r r© r} rD rD rD rE r§ 7 s r§ zType[exc.SQLAlchemyError]r r
|
)rC re Úexc_clsÚextrar rQ c C s: |dt | ¡|rd|f nd|r(d| ndd |d S )Nzc%(extra)sTextual SQL expression %(expr)r %(argname)sshould be explicitly declared as text(%(expr)r)úfor argument %sÚ z%s )r
re r¯ )r Úellipses_string)rC re r® r¯ r rD rD rE Ú_no_text_coercionS s ýþÿør³ c @ s e Zd ZdZdddZdS )Ú_NoTextCoercionrD Nc K s4 t |tr$ttj| jr$t|| n | ||¡ d S r_ )r@ rH rL r! Ú
|
TextClausery r³ rv ©r rC re r^ rD rD rE rp h s ÿ z!_NoTextCoercion._literal_coercion)N©r r r r rp rD rD rD rE r´ e s r´ c @ s0 e Zd ZdZdZdZdZdddZd ddZdS )
|
Ú_CoerceLiteralsrD FNc C s
|
t ||S r_ ©r³ ©r rC re rD rD rE Ú_text_coercionw s z _CoerceLiterals._text_coercionc K s t |tr6| jr&|dkr&tjdddS | j||f|S | jrl|d krLt ¡ S |dkr\t ¡ S |dkrlt ¡ S | j
|
rt |t j rtjt|ddS | ||¡ d S )NÚ*T)Z
|
is_literalF)r@ rH Ú _coerce_starr! r- r» Ú_coerce_constsÚNullÚFalse_ÚTrue_Ú_coerce_numericsÚnumbersÚNumberrv r¶ rD rD rE rp z s
|
z!_CoerceLiterals._literal_coercion)N)N) r r r r r¾ r½ r r» rp rD rD rD rE r¸ q s
|
r¸ c @ s$ e Zd ZdZdddZd ddZdS )
|
ÚLiteralValueImplTNFc K s4 t |s | j|f||d| tjd ||d|dS )N)r re T)Útype_ÚuniqueÚliteral_execute)rF rv r! r+ )r rC r re rÆ rÈ r^ rD rD rE r} s ÿ ÿÿûz$LiteralValueImpl._implicit_coercionsc K s |S r_ rD )r rC re rÆ r^ rD rD rE rp ¨ s z"LiteralValueImpl._literal_coercion)NF)NN)r r r ro r} rp rD rD rD rE rÅ s
|
ú
|
rÅ c
|
s6 e Zd ZdZd ddddddddd fd d
|
Z ZS ) Ú_SelectIsNotFromrD Nr rg r r r
|
r c sj |st |tjs t |tjr:d|d k r,|jn|f }d}nd }t j|f|||||d| dsftd S )NzETo create a FROM clause from a %s object, use the .subquery() method.Z89ve)re r r r r F)r@ r ZSelectStatementRolerz Úsuperrv rx )r rC re r r r r r^ ©rz rD rE rv ¯ s0 ÿ
|
þ
|
ýþÿÿúù
|
z$_SelectIsNotFrom._raise_for_expected)NNNNN©r r r r rv Ú __classcell__rD rD rË rE rÉ ¬ s ùrÉ c @ s0 e Zd ZdZd
|
ddddddddZdd ZdS ) ÚHasCacheKeyImplrD Nr rg r c K s t |tr|S | |||¡ d S r_ )r@ r rv r rD rD rE r} × s
|
z#HasCacheKeyImpl._implicit_coercionsc K s |S r_ rD r rD rD rE rp ã s z!HasCacheKeyImpl._literal_coercion)Nr¦ rD rD rD rE rÎ Ô s ü rÎ c @ s0 e Zd ZdZd
|
ddddddddZdd ZdS ) ÚExecutableOptionImplrD Nr rg r c K s t |tr|S | |||¡ d S r_ )r@ r rv r rD rD rE r} ê s
|
z(ExecutableOptionImpl._implicit_coercionsc K s |S r_ rD r rD rD rE rp ö s z&ExecutableOptionImpl._literal_coercion)Nr¦ rD rD rD rE rÏ ç s ü rÏ c s, e Zd ZdZdddZd fdd Z ZS )
|
ÚExpressionElementImplrD NFc
|
K sp |d kr"|s"|d ks|j s"t ¡ S ztj|||d|dW S tjk
|
rj } z| j||d W 5 d }~X Y nX d S )NT)rÇ Z_is_crud©r )Zshould_evaluate_noner! r¿ r+ r r[ rv )r rC r rÆ re Úis_crudr^ r rD rD rE rp ý s& ÿþýý ÿz'ExpressionElementImpl._literal_coercionc sD t |tjrd}nt |tjr$d}nd }t j|f|||d|S )NzTTo create a column expression from a VALUES clause, use the .scalar_values() method.z`To create a column expression from a FROM clause row as a whole, use the .table_valued() method.©re r r )r@ r$ ÚValuesr ZAnonymizedFromClauseRolerÊ rv ©r rC re r r^ r rË rD rE rv s ÿ ÿÿ ÿÿz)ExpressionElementImpl._raise_for_expected)NNNF)NN)r r r r rp rv rÍ rD rD rË rE rÐ ú s ÿ
|
rÐ c @ s$ e Zd ZdZdddZdddZdS ) ÚBinaryElementImplrD Nc
|
K sJ z|j |||dW S tjk
|
rD } z| j||d W 5 d }~X Y nX d S )N)rÆ rÑ )Ú _bind_paramr r[ rv )r rC r
ÚoperatorÚbindparam_typere r^ r rD rD rE rp ) s z#BinaryElementImpl._literal_coercionc K s, |j jr(|j js(| |d k r |n|j ¡}|S r_ )rK Z_isnullZ_with_binary_element_type)r r r
rÙ r^ rD rD rE r| 1 s
|
ÿz BinaryElementImpl._post_coercion)NN)N)r r r r rp r| rD rD rD rE rÖ % s
|
ÿ
|
rÖ c @ s@ e Zd ZdZdddddddddZdd Zd
|
d Zd d ZdS )Ú InElementImplrD Nr rg r c K sd |j rRt|tjr4|jjr4| |¡ | j|jf|S | |¡ | j| ¡ f|S n| |||¡ d S r_ )
|
r¬ r@ r$ ÚAliasrC rª Ú_warn_for_implicit_coercionr| Úselectrv r rD rD rE r} < s
|
ÿþ
|
|
z!InElementImpl._implicit_coercionsc C s t d|jj ¡ d S )Nz_Coercing %s object into a select() for use in IN(); please pass a select() construct explicitly)r r¨ rz r )r rM rD rD rE rÜ P s
|
þÿz)InElementImpl._warn_for_implicit_coercionc s² t |tjr t |ts i t|}|D ]F}t|sXt |tjsN| j|f| ql||< q&|d kr&t
|
¡ |< q&rt j fdd|D S j |ddS n| j|f| d S )Nc s( g | ] }|kr| n
|
|¡qS rD )r× )Ú.0Úo©r
Znon_literal_expressionsrØ rD rE Ú
|
<listcomp>l s þÿ
|
z3InElementImpl._literal_coercion.<locals>.<listcomp>T)Ú expanding) r@ rG r rH rW rF r ZColumnOperatorsrv r! r¿ Ú
|
ClauseListr× )r rC r
rØ r^ rß rD rà rE rp W s, ÿý
|
üÿ z InElementImpl._literal_coercionc K s| |j r| ¡ S t|tjr8t|jdkr,t|j|dS t|tj r`|j
|
dd}d|_ ||_ |S t|t jrt| ¡ S |S d S )Nr )ZagainstT)Z maintain_key)rª r« r@ r! rã rZ Zclausesrx Z
|
self_groupr+ Z_clonerâ Z expand_opr$ rÔ Z scalar_values)r rC r
rØ r^ rD rD rE r| y s z InElementImpl._post_coercion)N)r r r r r} rÜ rp r| rD rD rD rE rÚ 9 s ü"rÚ c @ s( e Zd ZdZdZd ddZd
|
ddZdS ) Ú OnClauseImplrD TNFc K s | |¡ d S r_ r )r rC r rÆ re rÒ r^ rD rD rE rp s z OnClauseImpl._literal_coercionc K s t |tjr|S |S r_ )r@ r ÚJoinTargetRole)r r rk r^ rD rD rE r| s zOnClauseImpl._post_coercion)NNNF)N)r r r r r¾ rp r| rD rD rD rE rä s ÿ
|
rä c @ s e Zd ZdZdZdddZdS )ÚWhereHavingImplrD TNc C s
|
t ||S r_ r¹ rº rD rD rE r» ¨ s z WhereHavingImpl._text_coercion)N©r r r r r¾ r» rD rD rD rE ræ £ s ræ c @ s e Zd ZdZdZdddZdS )ÚStatementOptionImplrD TNc C s
|
t |¡S r_ ©r! rµ rº rD rD rE r» ± s z"StatementOptionImpl._text_coercion)Nrç rD rD rD rE rè ¬ s rè c @ s e Zd ZdZdS )ÚColumnArgumentImplrD N©r r r r rD rD rD rE rê µ s rê c @ s e Zd ZdZdS )ÚColumnArgumentOrKeyImplrD Nrë rD rD rD rE rì ¹ s rì c @ s e Zd ZdZdddZdS )ÚStrAsPlainColumnImplrD Nc C s
|
t |¡S r_ )r! r- rº rD rD rE r» À s z#StrAsPlainColumnImpl._text_coercion)N)r r r r r» rD rD rD rE rí ½ s rí c @ s e Zd ZdZdZdddZdS )ÚByOfImplrD TNc C s
|
t |¡S r_ )r! Z_textual_label_referencerº rD rD rE r» Ê s zByOfImpl._text_coercion)Nrç rD rD rD rE rî Ä s rî c @ s e Zd ZdZdd ZdS )Ú OrderByImplrD c K s( t || jr |jd k r t |¡S |S d S r_ )r@ ry Z_order_by_label_elementr! Z_label_reference)r r r^ rD rD rE r| Ñ s
|
ÿþ
|
zOrderByImpl._post_coercionNr¢ rD rD rD rE rï Î s rï c @ s( e Zd ZdZdddddddddZdS ) Ú GroupByImplrD Nr rg r c K s t |rtj|j S |S d S r_ )r r! rã Úcr rD rD rE r} Þ s z GroupByImpl._implicit_coercions)N©r r r r r} rD rD rD rE rð Û s ürð c @ s e Zd ZdZdddZdS )Ú DMLColumnImplrD Fc K s |r
|
|j S |S d S r_ )Úkey)r rC rb r^ rD rD rE r| î s z DMLColumnImpl._post_coercionN)Fr¢ rD rD rD rE ró ë s ró c @ s e Zd ZdZdddZdS )Ú ConstExprImplrD Nc K s@ |d krt ¡ S |dkr t ¡ S |dkr0t ¡ S | ||¡ d S )NFT)r! r¿ rÀ rÁ rv r¶ rD rD rE rp ø s z ConstExprImpl._literal_coercion)Nr· rD rD rD rE rõ õ s rõ c @ s2 e Zd ZdZd
|
ddddddddZd dd ZdS ) ÚTruncatedLabelImplrD Nr rg r c K s t |tr|S | |||¡ d S r_ r¥ r rD rD rE r} s
|
z&TruncatedLabelImpl._implicit_coercionsc K s t |tjr|S t |¡S dS )z¸coerce the given value to :class:`._truncated_label`.
|
|
Existing :class:`._truncated_label` and
|
:class:`._anonymous_label` objects are passed
|
unchanged.
|
N)r@ r! Z_truncated_labelr¶ rD rD rE rp s z$TruncatedLabelImpl._literal_coercion)N)Nr¦ rD rD rD rE rö s ü rö c @ s e Zd ZdZdZdddZdS )ÚDDLExpressionImplrD TNc C s
|
t |¡S r_ ré rº rD rD rE r» & s z DDLExpressionImpl._text_coercion)Nrç rD rD rD rE r÷ s r÷ c @ s e Zd ZdZdS )ÚDDLConstraintColumnImplrD Nrë rD rD rD rE rø . s rø c @ s e Zd ZdZdS )ÚDDLReferredColumnImplrD Nrë rD rD rD rE rù 2 s rù c @ s0 e Zd ZdZd
|
ddddddddZdd ZdS ) ÚLimitOffsetImplrD Nr rg r c K s |d kr d S | |||¡ d S r_ r r rD rD rE r} 9 s z#LimitOffsetImpl._implicit_coercionsc K s, |d kr d S t |¡}tj|||ddS d S )NT)rÆ rÇ )r Zasintr$ Z_OffsetLimitParam)r rC r rÆ r^ ÚvaluerD rD rE rp E s
|
ÿz!LimitOffsetImpl._literal_coercion)Nr¦ rD rD rD rE rú 6 s ü rú c s0 e Zd ZdZddddddd fdd Z ZS ) ÚLabeledColumnExprImplrD Nr rg r c sX t |tjr| d ¡S t j||fd|i|}t |tjrF| d ¡S | |||¡ d S ©Nre )r@ r ÚExpressionElementRoleÚlabelrÊ r} rv )r rC r re r^ ÚnewrË rD rE r} R s
|
ÿÿÿ
|
z)LabeledColumnExprImpl._implicit_coercions)N)r r r r r} rÍ rD rD rË rE rü O s ürü c sF e Zd ZdZdZdZdZe dej ¡Z
|
d fdd Z d
|
ddZ Z S ) ÚColumnsClauseImplrD Tz^\w\S*$Nc sF |s*t |tr*dd dd |D ¡ d}t j|f|||d|S )NzDid you mean to say select(z, c s s | ]}t |V qd S r_ )r )rÞ ÚerD rD rE Ú <genexpr>s s z8ColumnsClauseImpl._raise_for_expected.<locals>.<genexpr>z)?rÓ )r@ rW ÚjoinrÊ rv )r rC re r r r^ rË rD rE rv n s ÿÿ ÿÿz%ColumnsClauseImpl._raise_for_expectedc C sL t |}| j |¡ }t dt |¡|r2d|f nd|r<dndd ¡d S )NzTextual column expression %(column)r %(argname)sshould be explicitly declared with text(%(column)r), or use %(literal_column)s(%(column)r) for more specificityr° r± Úliteral_columnr )r re r )rH Ú_guess_straight_columnÚmatchr r[ r r² )r rC re Zguess_is_literalrD rD rE r» { s ÿûüÿz ColumnsClauseImpl._text_coercion)NNN)N)r r r r r¾ r r½ ÚreÚcompileÚIr rv r» rÍ rD rD rË rE r e s ÿ r c @ s e Zd ZdZdS )ÚReturnsRowsImplrD Nrë rD rD rD rE r s r c s: e Zd ZdZd
|
ddZd dddddd fdd Z ZS ) Ú StatementImplrD Nc K sF ||k rBt |tsBz
|
|j W n$ tk
|
r@ t d| d¡ Y nX |S )Na Object %r should not be used directly in a SQL statement context, such as passing to methods such as session.execute(). This usage will be disallowed in a future release. Please use Core select() / update() / delete() etc. with Session.execute() and other statement execution methods.ú1.4)r@ rH Z_execute_on_connectionru r Úwarn_deprecated)r r rk re r^ rD rD rE r| s
|
ÿ
|
úø
|
z StatementImpl._post_coercionr rg r c s( |j r
|
|S t j||fd|i|S d S rý )r rÊ r} r rË rD rE r} « s ÿÿÿz!StatementImpl._implicit_coercions)N)N)r r r r r| r} rÍ rD rD rË rE r s
|
ür c @ s( e Zd ZdZdddddddddZdS ) ÚSelectStatementImplrD Nr rg r c K s |j r| ¡ S | |||¡ d S r_ )Ú_is_text_clauseÚcolumnsrv r rD rD rE r} ½ s z'SelectStatementImpl._implicit_coercions)Nrò rD rD rD rE r º s ür c @ s e Zd ZdZdS )Ú
|
HasCTEImplrD Nrë rD rD rD rE r Ê s r c @ s e Zd ZdZdS )Ú IsCTEImplrD Nrë rD rD rD rE r Î s r c @ s8 e Zd ZdZdZd ddZddddd ddd
|
d d ZdS )ÚJoinTargetImplrD TNc K s | ||¡ d S r_ r r¶ rD rD rE rp × s z JoinTargetImpl._literal_coercionFr rg rh )rC r re Úlegacyr^ rQ c K s> t |tjr|S |r,|jr,tjddd |S | |||¡ d S ©NzÀImplicit coercion of SELECT and textual SELECT constructs into FROM clauses is deprecated; please call .subquery() on any Core select or ORM Query object in order to produce a subquery object.r )Úversion)r@ r rå rª r r rv )r rC r re r r^ rD rD rE r} Ú s
|
û z"JoinTargetImpl._implicit_coercions)N)NF)r r r r rq rp r} rD rD rD rE r Ò s
|
ûr c @ s6 e Zd ZdZd ddddddddd d
|
Zdd d ZdS )ÚFromClauseImplrD NFTr rg rh ©rC r re rc Ú allow_selectr^ rQ c K sH |j r,|r| ¡ S |rDtjddd |jS n|jr6|S | |||¡ d S r )rª Zsubqueryr r Ú_implicit_subqueryr rv ©r rC r re rc r r^ rD rD rE r} û s ûz"FromClauseImpl._implicit_coercionsc K s |r | ¡ S |S d S r_ )Z _deannotate)r rC Z
|
deannotater^ rD rD rE r| s z FromClauseImpl._post_coercion)NFT)F)r r r r r} r| rD rD rD rE r ø s ú r c @ s, e Zd ZdZd
|
dddddddddd ZdS ) ÚStrictFromClauseImplrD NFr rg rh r c K s0 |j r |r tjddd |jS | |||¡ d S r )rª r r r rv r rD rD rE r} s
|
ûz(StrictFromClauseImpl._implicit_coercions)NFFrò rD rD rD rE r s
|
úr c @ s e Zd ZdZdddZdS )ÚAnonymizedFromClauseImplrD FNc K s |d ks t |j|dS )N)Úflat)rx Z_anonymous_fromclause)r rC r r r^ rD rD rE r| 8 s z'AnonymizedFromClauseImpl._post_coercion)FNr¢ rD rD rD rE r 5 s r c @ s e Zd ZdZdd ZdS )Ú DMLTableImplrD c K s d|j kr|j d S |S d S )NZ dml_table)Z _annotationsr rD rD rE r| A s
|
|
zDMLTableImpl._post_coercionNr¢ rD rD rD rE r > s r c @ s( e Zd ZdZdddddddddZdS ) Ú DMLSelectImplrD Nr rg r c K s< |j r*t|tjr |jjr |jS | ¡ S n| |||¡ d S r_ )r¬ r@ r$ rÛ rC rª rÝ rv r rD rD rE r} K s
|
ÿþ
|
z!DMLSelectImpl._implicit_coercions)Nrò rD rD rD rE r! H s ür! c s" e Zd ZdZd fdd Z ZS )ÚCompoundElementImplrD Nc s> t |tjr |jrd}q"d}nd }t j|f|||d|S )NzFUse the plain select() object without calling .subquery() or .alias().z9To SELECT from any FROM clause, use the .select() method.rÓ )r@ r ZFromClauseRoleZ _is_subqueryrÊ rv rÕ rË rD rE rv a s ÿÿÿ ÿÿz'CompoundElementImpl._raise_for_expected)NNrÌ rD rD rË rE r" ^ s r" ZRoleZImpl)Ú
|
__future__r Úcollections.abcÚabcrG rà r rw r r r r r r r r
|
r r r r r r r r r± r r r Ú_typingr Úbaser r Ú cache_keyr r r r r Z util.typingr r! r" r# r$ r% r& r' r( r) Zdmlr* r+ r, r- r. r/ r0 r1 r2 r3 r4 r5 r6 r7 r8 r9 ZSQLRoler: r< Z
|
StringRoler= r> rF rI rR r\ ra r r r r r£ r¤ r§ r[ r³ r´ r¸ rÅ rÉ rÎ rÏ rÐ rÖ rÚ rä ræ rè rê rì rí ZByOfRolerî rï rð ró rõ rö r÷ rø rù rú rü r r r r r r r r r r r r! r" rn Údirr rr ÚclsÚendswithÚreplaceÚglobalsr~ rþ Zee_implÚintrh rH ÚfloatZpy_typerD rD rD rE Ú<module> sR &ü
|
ü
|
ú u 6 û (+U
|
|
)(&$
|
|
|
|
