관리-도구
편집 파일: coercions.cpython-38.pyc
U -?�f�� � @ 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( ej�r�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� ZJdDdDdDdEdF�dGdH�ZKdDdDdIdJdK�dLdM�ZLedNdOdOdDdP�dQdR��ZMed=dS�dTdOdUdOdDdV�dWdR��ZMedXdOdOdYdP�dZdR��ZMed[dOdOd\dP�d]dR��ZMed^dOdOd_dP�d`dR��ZMedadOdOdbdP�dcdR��ZMedddedOdfdP�dgdR��ZMedhdedOdidP�djdR��ZMedkdOdOdldP�dmdR��ZMedndodOdpdP�dqdR��ZMedrdsdOdsdP�dtdR��ZMedudvdOdvdP�dwdR��ZMedxdydOdzdP�d{dR��ZMed=d|�dxdvdUdOd}d~�ddR��ZMed�d�dOd�dP�d�dR��ZMed�d�dOd�dP�d�dR��ZMed�dOdOdOdP�d�dR��ZMddd�d�d��d�dOd�d�d�d�dOdOd��d�dR�ZMdTdOdOdDdP�d�d��ZNd^d�d�d��d�d��ZOG d�d�� d��ZPG d�d�� d��ZQG d�d�� d��ZRG d�d�� d�eP�ZSG d�d�� d�eP�ZTde$jUddfdOd�d�d�d�d�d��d�d��ZVG d�d�� d�eP�ZWG d�d�� d�eP�ZXG d�d�� d�eP�ZYG d�d�� d�eP�ZZG d�d�� d�eP�Z[G d�d�� d�eP�Z\G d�d�� d�eTeP�Z]G d�d�� d�e]eP�Z^G d�d�� d�eP�Z_G d�d�� d�eTeP�Z`G d�d�� d�eXeTeP�ZaG d�d�� d�eXeP�ZbG d�d�� d�eWeP�ZcG d�d d�eSeP�ZdG d�dĄ d�eXeP�ZeG d�dƄ d�eXeTePejf�ZgG d�dȄ d�egeP�ZhG d�dʄ d�egeP�ZiG d�d̄ d�eSeP�ZjG d�d΄ d�eP�ZkG d�dЄ d�eReP�ZlG d�d҄ d�eQeXeP�ZmG d�dԄ d�eQeSeP�ZnG d�dք d�en�ZoG d�d d�eP�ZpG d�dڄ d�e]�ZqG d�d܄ d�eZeXeP�ZrG d�dބ d�eP�ZsG d�d� d�eXeP�ZtG d�d� d�eWeP�ZuG d�d� d�es�ZvG d�d� d�eP�ZwG d�d� d�eP�ZxG d�d� d�eZeWeP�ZyG d�d� d�ey�ZzG d�d� d�ez�Z{G d�d� d�eZeWeP�Z|G d�d� d�eWeP�Z}G d�d� d�eWeP�Z~i Ze�e�D ]JZ�e�ee��Z�e���d���rFe���d�d��Z�e�e�� k�rFe�� e� e��Z�e�ee�< �qFe�s�eej� Z�e�e�e�e�fD ]Z�e�eej�e� < �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 �H/opt/hc_python/lib64/python3.8/site-packages/sqlalchemy/sql/coercions.py� _is_literalO s � �rF c C sr t | tj�r2t | t�s2| 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 tttf�rXt|�dkrXt |d t�rJt�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 rc r^ rQ c K s d S r_ rD )r] rC rc 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 rd r^ rQ c K s d S r_ rD )r] rC rd 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 ) s z Type[_SR]c K s d S r_ rD r` rD rD rE ra 2 s F)�apply_propagate_attrs�argname� post_inspect�disable_inspectionzOptional[ClauseElement]� Optional[str]�bool)r] rC re rf rg rh r^ rQ c K s | j r2t|�r2t|d�r2tj|| tjf |�|d�S t| }|}t|tj t j t j tj f��sRd } |jrt|j|f|�} n�|}d} |jr�t|| �r�t|d�r�d} n(t|d�r�d} t|dd�s�|�� }q�q�q�| �sL|j�r*|�s*tj|dd�} | d k �r*|r�| j z | �� } W n" tk �r( |�||� Y nX | d k�rP|j|fd|i|��} n|} n t|tj ��rn|jf |�} n|} |d k �r�tj�r�t| t t f��s�t �|j �s�t| d d ��r�| j |_ |j | j!j"k�r�|j#�r�|j#| f||d �|��} | S |j$|| fd|i|��S d S ) N�__code__)re Fr? T�is_clause_element)Zraiseerrrf �_propagate_attrs)rf �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, �AssertionErrorrm � _role_class� __class__�__mro__�_post_coercion�_implicit_coercions) r] rC re rf rg rh r^ �implrn �resolvedrl ZinsprD rD rE ra : s� ��� � �� ��� ��� ���� ���c K s" |� dd � t| |fddi|��S )Nrc 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|t�r<t|t�s2t�| }}n(g }|j}t�|i d|i� |rd|d }|d k rp|n|}||||fV qd S )N�columnr )ra r@ rH r{ �appendr �traverse) r] r� �exprZstrnamer� r� �colsZ col_appendZ add_elementrD rD rE � expect_col_expression_collection� s r� c @ sv e Zd ZU dZdd� ZdZded< dZdZdd � Z dddd ddd �d d �Z ddddd�dd dd d dddd�dd�Z dS )�RoleImpl)r| �namerv c K s t � �d S r_ )�NotImplementedError��selfrC r^ rD rD rE rs � s zRoleImpl._literal_coercionNr r Fc C s || _ |j| _t|tj�| _d S r_ )r| Z _role_namer� rL r ZUsesInspectionrv )r� Z role_classrD rD rE �__init__� s zRoleImpl.__init__ri �rC r� rf r^ rQ c K s | � |||� d S r_ �ry �r� rC r� rf r^ rD rD rE r� � s z RoleImpl._implicit_coercions��advice�code�err� Optional[Any]�Optional[Exception]r �rC rf r� r� r� r� r^ 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 rf r� r� r� r� r^ �got�msgrD rD rE ry � s � z RoleImpl._raise_for_expected)N)NN) �__name__� __module__� __qualname__� __slots__rs r �__annotations__rr rt r� r� ry 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� rr rD rD rD rE r� s r� c @ s" e Zd ZdZddd�Zdd� ZdS )�_ReturnsStringKeyrD Nc K s t |t�r|S | �|||� d S r_ �r@ rH ry r� rD rD rE r� s z%_ReturnsStringKey._implicit_coercionsc K s |S r_ rD r� rD rD rE rs " s z#_ReturnsStringKey._literal_coercion)N�r� r� r� r� r� rs rD rD rD rE r� s r� c @ s" e Zd ZdZdd� Zddd�ZdS )�_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 |dd�s | �|||� nZ|jr6| �� |�� S |jrZt|tj�rZ| �� |j �� S | j j rl|j rl|S | �|||� d S )Nrl F) ru ry �_is_select_baser� �scalar_subquery�_is_from_clauser@ r$ r8 rC r| ro �_is_lambda_element)r� rC r� rf r^ rn rD rD rE r� 0 s � z$_ColumnCoercions._implicit_coercions)N)r� r� r� r� r� r� rD rD rD rE r� & s r� zType[exc.SQLAlchemyError]r� r )rC rf �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� rf r� )r �ellipses_string)rC rf r� r� r� rD rD rE �_no_text_coercionB s ����r� c @ s e Zd ZdZdd�dd�ZdS )�_NoTextCoercionrD N�rf c K s4 t |t�r$ttj| j�r$t||� n | �||� d S r_ )r@ rH rL r! � TextClauser| r� ry �r� rC rf r^ rD rD rE rs W s � z!_NoTextCoercion._literal_coercion�r� r� r� r� rs rD rD rD rE r� T s r� c @ s4 e Zd ZdZdZdZdZd dd�Zdd�dd�ZdS ) �_CoerceLiteralsrD FNc C s t ||�S r_ �r� �r� rC rf rD rD rE �_text_coercionf s z _CoerceLiterals._text_coercionr� c K s� t |t�r6| jr&|dkr&tjddd�S | j||f|�S | jrl|d krLt�� S |dkr\t�� S |dkrlt� � S | j r�t |t j �r�tjt|�dd�S | � ||� d S )N�*T)Z is_literalF)r@ rH � _coerce_starr! r- r� �_coerce_consts�Null�False_�True_�_coerce_numerics�numbers�Numberry r� rD rD rE rs i s z!_CoerceLiterals._literal_coercion)N) r� r� r� r� r� r� r� r� rs rD rD rD rE r� ` s r� c @ s* e Zd ZdZd ddd�dd�Zdd� ZdS ) �LiteralValueImplTNF)�type_�literal_executec K s4 t |�s | j|f||d�|�� tjd ||d|d�S )N)r� rf T)r� �uniquer� )rF ry r! r+ )r� rC r� rf r� r� r^ rD rD rE r� � s � ���z$LiteralValueImpl._implicit_coercionsc K s |S r_ rD r� rD rD rE rs � s z"LiteralValueImpl._literal_coercion)N)r� r� r� rr r� rs rD rD rD rE r� ~ s �� r� c s@ e Zd ZdZd dddd�ddddddddd �� fd d �Z� ZS ) �_SelectIsNotFromrD Nr� r ri r� r� r r� c sj |st |tj�s t |tj�r:d|d k r,|jn|f }d}nd }t� j|f|||||d�|�� dsft�d S )NzETo create a FROM clause from a %s object, use the .subquery() method.Z89ve)rf r� r� r� r� F)r@ r ZSelectStatementRoler} �superry r{ )r� rC rf r� r� r� r� r^ �r} rD rE ry � s0 � � ������ z$_SelectIsNotFrom._raise_for_expected)NN�r� r� r� r� ry � __classcell__rD rD r� rE r� � s ��r� c @ s0 e Zd ZdZd dddddd�dd�Zdd � ZdS ) �HasCacheKeyImplrD Nr ri r� c K s t |t�r|S | �|||� d S r_ )r@ r ry r� rD rD rE r� � s z#HasCacheKeyImpl._implicit_coercionsc K s |S r_ rD r� rD rD rE rs � s z!HasCacheKeyImpl._literal_coercion)Nr� rD rD rD rE r� � s � r� c @ s0 e Zd ZdZd dddddd�dd�Zdd � ZdS ) �ExecutableOptionImplrD Nr ri r� c K s t |t�r|S | �|||� d S r_ )r@ r ry r� rD rD rE r� � s z(ExecutableOptionImpl._implicit_coercionsc K s |S r_ rD r� rD rD rE rs � s z&ExecutableOptionImpl._literal_coercion)Nr� rD rD rD rE r� � s � r� c s4 e Zd ZdZdddd�dd�Zd � fdd� Z� ZS ) �ExpressionElementImplrD NF)r� r� �is_crudc K sp |d kr"|s"|d ks|j s"t�� S ztj|||d|d�W 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[ ry )r� rC r� r� r� r^ r� rD rD rE rs � s& ���� �z'ExpressionElementImpl._literal_coercionc sD t |tj�rd}nt |tj�r$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.�rf r� r� )r@ r$ �Valuesr ZAnonymizedFromClauseRoler� ry �r� rC rf r� r^ r� r� rD rE ry s � �� ��z)ExpressionElementImpl._raise_for_expected)NN)r� r� r� r� rs ry r� rD rD r� rE r� � s � r� c @ s. e Zd ZdZddd�dd�Zdd�dd�ZdS ) �BinaryElementImplrD N)�bindparam_typerf c K sJ z|j |||d�W S tjk rD } z| j||d� W 5 d }~X Y nX d S )N)r� r� )� _bind_paramr r[ ry )r� rC r� �operatorr� rf r^ r� rD rD rE rs s z#BinaryElementImpl._literal_coercion)r� c 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 ( s �z BinaryElementImpl._post_coercion)r� r� r� r� rs r rD rD rD rE r� s � r� c @ s@ e Zd ZdZddddddd�dd�Zdd � Zd d � Zd d � ZdS )� InElementImplrD Nr ri r� c K sd |j rRt|tj�r4|jjr4| �|� | j|jf|�S | �|� | j|�� f|�S n| � |||� d S r_ ) r� r@ r$ �AliasrC r� �_warn_for_implicit_coercionr �selectry r� rD rD rE r� 3 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� r} r� )r� rM rD rD rE r� G s ��z)InElementImpl._warn_for_implicit_coercionc s� t �|�r�i �t|�}|D ]F}t|�sLt|tj�sB| j|f|� q`|�|< q|d krt� � �|< q�r�tj � ��fdd�|D �� S � j �|dd�S n| j|f|� d S )Nc s( g | ] }|�kr�| n � � �|��qS rD )r� )�.0�o�r� Znon_literal_expressionsr� rD rE � <listcomp>c s �� z3InElementImpl._literal_coercion.<locals>.<listcomp>T)� expanding) r Zis_non_string_iterablerW rF r@ r ZColumnOperatorsry r! r� � ClauseListr� )r� rC r� r� r^ r� rD r� rE rs N s& � �� z InElementImpl._literal_coercionc K s| |j r|�� S t|tj�r8t|j�dkr,t�|j|d�S t|tj �r`|j dd�}d|_ ||_ |S t|t j�rt|�� S |S d S )Nr )ZagainstT)Z maintain_key)r� r� r@ r! r� rZ Zclausesr{ Z self_groupr+ Z_cloner� Z expand_opr$ r� Z scalar_values)r� rC r� r� r^ rD rD rE r r s z InElementImpl._post_coercion)N)r� r� r� r� r� r� rs r rD rD rD rE r� 0 s �$r� c @ s* e Zd ZdZdZdd� Zdd�dd�ZdS ) � OnClauseImplrD Tc K s | � |� d S r_ r� r� rD rD rE rs � s z OnClauseImpl._literal_coercionN)rn c K s t |tj�r|S |S r_ )r@ r �JoinTargetRole)r� r� rn r^ rD rD rE r � s zOnClauseImpl._post_coercion)r� r� r� r� r� rs r rD rD rD rE r� � s r� c @ s e Zd ZdZdZddd�ZdS )�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 ZdZdZddd�ZdS )�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 ZdZddd�ZdS )�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 ZdZdZddd�ZdS )�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 || j�r |jd k r t�|�S |S d S r_ )r@ r| 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 ZdZddddddd�dd�ZdS ) � GroupByImplrD Nr ri 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 ZdZdd�dd�ZdS )� DMLColumnImplrD Frb c K s |r |j S |S d S r_ )�key)r� rC rc r^ rD rD rE r � s z DMLColumnImpl._post_coercionNr� rD rD rD rE r� � s r� c @ s e Zd ZdZdd�dd�ZdS )� ConstExprImplrD Nr� c K s@ |d krt �� S |dkr t �� S |dkr0t �� S | �||� d S )NFT)r! r� r� r� ry r� rD rD rE rs � s z ConstExprImpl._literal_coercionr� rD rD rD rE r� � s r� c @ s0 e Zd ZdZd dddddd�dd�Zdd � ZdS ) �TruncatedLabelImplrD Nr ri r� c K s t |t�r|S | �|||� d S r_ r� r� rD rD rE r� � s z&TruncatedLabelImpl._implicit_coercionsc K s t |tj�r|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 rs s z$TruncatedLabelImpl._literal_coercion)Nr� rD rD rD rE r� � s � r� c @ s e Zd ZdZdZddd�ZdS )�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� ' s r� c @ s0 e Zd ZdZd dddddd�dd�Zdd � ZdS ) �LimitOffsetImplrD Nr ri r� c K s |d kr d S | � |||� d S r_ r� r� rD rD rE r� . s z#LimitOffsetImpl._implicit_coercionsc K s, |d kr d S t �|�}tj|||dd�S d S )NT)r� r� )r Zasintr$ Z_OffsetLimitParam)r� rC r� r� r^ �valuerD rD rE rs : s �z!LimitOffsetImpl._literal_coercion)Nr� rD rD rD rE r + s � r c s0 e Zd ZdZddddddd�� fdd� Z� ZS ) �LabeledColumnExprImplrD Nr ri r� c sX t |tj�r|�d �S t� j||fd|i|��}t |tj�rF|�d �S | �|||� d S �Nrf )r@ r �ExpressionElementRole�labelr� r� ry )r� rC r� rf r^ �newr� rD rE r� I s ��� z)LabeledColumnExprImpl._implicit_coercions)N)r� r� r� r� r� r� rD rD r� rE r F s �r c sL e Zd ZdZdZdZdZe�dej �Z d dd�� fdd� Z d dd �Z � Z S ) �ColumnsClauseImplrD Tz^\w\S*$N)r� c sF |s*t |t�r*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>j s z8ColumnsClauseImpl._raise_for_expected.<locals>.<genexpr>z)?r� )r@ rW �joinr� ry )r� rC rf r� r� r^ r� rD rE ry e s �� ��z%ColumnsClauseImpl._raise_for_expectedc C sL t |�}| j�|� }t�dt�|�|r2d|f nd|r<dndd� ��d S )Nz�Textual 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� rf r )rH �_guess_straight_column�matchr r[ r r� )r� rC rf Zguess_is_literalrD rD rE r� r s ���z ColumnsClauseImpl._text_coercion)NN)N)r� r� r� r� r� r� r� �re�compile�Ir ry r� r� rD rD r� rE r \ s �� r c @ s e Zd ZdZdS )�ReturnsRowsImplrD Nr� rD rD rD rE r � s r c s> e Zd ZdZdd�dd�Zd dddddd�� fd d � Z� ZS ) � StatementImplrD Nr� c K sF ||k rBt |t�sBz |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_connectionrx r �warn_deprecated)r� r� rn rf r^ rD rD rE r � s � �� z StatementImpl._post_coercionr ri 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)r� r� r� r� r r� r� rD rD r� rE r � s � �r c @ s( e Zd ZdZddddddd�dd�ZdS ) �SelectStatementImplrD Nr ri r� c K s |j r|�� S | �|||� d S r_ )�_is_text_clause�columnsry 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 @ sB e Zd ZdZdZdd�dd�Zddd�d d d d d d d �d d�ZdS )�JoinTargetImplrD TNr� c K s | � ||� d S r_ r� r� rD rD rE rs � s z JoinTargetImpl._literal_coercionF)�legacyr ri rj )rC r� rf r r^ rQ c K s> t |tj�r|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 ry )r� rC r� rf r r^ rD rD rE r� � s � z"JoinTargetImpl._implicit_coercions)N)r� r� r� r� rt rs r� rD rD rD rE r � s ��r c @ sB e Zd ZdZdddd�dddddddd �d d �Zdd �d d�ZdS )�FromClauseImplrD NFT)rd � allow_selectr ri rj )rC r� rf rd r r^ rQ c K sH |j r,|r|�� S |rDtjddd� |jS n|jr6|S | �|||� d S r )r� Zsubqueryr r �_implicit_subqueryr ry )r� rC r� rf rd r r^ rD rD rE r� � s �z"FromClauseImpl._implicit_coercions)� deannotatec K s |r |� � S |S d S r_ )Z _deannotate)r� rC r! r^ rD rD rE r s z FromClauseImpl._post_coercion)N)r� r� r� r� r� r rD rD rD rE r � s �� r c @ s0 e Zd ZdZd dd�ddddddd�d d �ZdS ) �StrictFromClauseImplrD NF)r r ri rj )rC r� rf r r^ rQ c K s0 |j r |r tjddd� |jS | �|||� d S r )r� r r r ry )r� rC r� rf r r^ rD rD rE r� s �z(StrictFromClauseImpl._implicit_coercions)Nr� rD rD rD rE r" s ��r" c @ s e Zd ZdZddd�dd�ZdS )�AnonymizedFromClauseImplrD FN)�flatr� c K s |d ks t �|j|d�S )N)r$ )r{ Z_anonymous_fromclause)r� rC r$ r� r^ rD rD rE r 3 s z'AnonymizedFromClauseImpl._post_coercionr� rD rD rD rE r# 0 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 < s zDMLTableImpl._post_coercionNr� rD rD rD rE r% 9 s r% c @ s( e Zd ZdZddddddd�dd�ZdS ) � DMLSelectImplrD Nr ri r� c K s< |j r*t|tj�r |jjr |jS |�� S n| �|||� d S r_ )r� r@ r$ r� rC r� r� ry r� rD rD rE r� F s �� z!DMLSelectImpl._implicit_coercions)Nr� rD rD rD rE r& C s �r& c s" e Zd ZdZd� fdd� Z� ZS )�CompoundElementImplrD Nc s> t |tj�r |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� ry r� r� rD rE ry \ s ��� ��z'CompoundElementImpl._raise_for_expected)NNr� rD rD r� rE r' Y s r' ZRoleZImpl)�� __future__r �collections.abc�abcrG r� r rz r r r r r r r r r r r r r r r r r� r r r Z_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' rq �dirr� ru �cls�endswith�replace�globalsr� r Zee_impl�intrj rH �floatZpy_typerD rD rD rE �<module> sT &� � � t 7 � )+W )*'%