관리-도구
편집 파일: default_comparator.cpython-38.pyc
U -?�fCA � ? @ sX U d Z ddlmZ ddlZddlmZ ddlmZ ddlmZ ddlmZ ddlmZ dd lm Z dd lm Z dd lm Z d d l m Z d dl mZ d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlm Z d d lm Z d d lm Z d d l m Z d d l m Z ej!d!ed"�Z"ej#�r�d d#lm$Z$ d d$lm%Z% d d%lm&Z& dd&e'd�e(fdd'�d(d)d*d+d,d-d.d*d/d0� d1d2�Z)dnd(d3d*d,d4d*d(d5�d6d7�Z*d&dd8�d(d)d9d,d:d*d;d5�d<d=�Z+d(d)d*d*d(d>�d?d@�Z,d(d)dAd*d(dB�dCdD�Z-d(d)dEd)d*d(dF�dGdH�Z.d(d)d*d*d(d>�dIdJ�Z/d(d)d*d*dKdL�dMdN�Z0d(d)d*d(dO�dPdQ�Z1d(d)d*d(dO�dRdS�Z2d(d)d*d(dO�dTdU�Z3d(d)d*d*d(d>�dVdW�Z4d(d)d*d(dO�dXdY�Z5d(d)d*d*d*d(dZ�d[d\�Z6d]d)d^d*d]d_�d`da�Z7d]d)d*dbd*d(dc�ddde�Z8d(d)d*d*dbd*d(df�dgdh�Z9e,e j:fe,e j:fe1e j:fe+e j:fe+e j:fe+e j:fe+e j:fe+e j:fe+e j:fe+e j:fe+e j:fe3e j:fe+e j:fe+e j:fe+e j:fe+e j:fe*e j:fe+e j:fe+e j:fe+e j:fe-e �;diej<i�fe-e �;diej=i�fe)e �;djej>i�fe)e �;djej?i�fe)e �;djej@i�fe)e �;djejAi�fe)e �;djejBi�fe)e �;djejCi�fe)e �;djejDi�fe)e �;djejEi�fe)e �;djejFi�fe)e �;djejGi�fe)e �;djejHi�fe)e �;djejIi�fe)e �;djejJi�fe)e �;djejKi�fe)e �;djejLi�fe)e �;djejMi�fe)e �;djejNi�fe)e �;djejOi�fe-e �;die jPi�fe-e �;die jQi�fe-e �;die jRi�fe-e �;die jSi�fe.e �;djejTi�fe.e �;djejUi�fe)e �;djejVi�fe)e �;djejWi�fe7e j:fe4e j:fe4e j:fe5e j:fe6e j:fe6e j:fe2e j:fe/e j:fe0e j:fe0e j:fe0e j:fe8e j:fe8e j:fe9e j:fdk�>ZXdleYdm< dS )oz5Default implementation of SQL comparison operations. � )� annotationsN)�Any)�Callable)�Dict)�NoReturn)�Optional)�Tuple)�Type)�Union� )� coercions)� operators)�roles)�type_api)�and_)�BinaryExpression)� ClauseElement)�CollationClause)�CollectionAggregate)�ExpressionClauseList)�False_)�Null)�OperatorExpression)�or_)�True_)�UnaryExpression)� OperatorType� )�exc)�util�_T)�bound)� ColumnElement)� custom_op)� TypeEngineF)� negate_op�reverse�_python_is_types� result_typezColumnElement[Any]r r zOptional[OperatorType]�boolzTuple[Type[Any], ...]zOptional[TypeEngine[bool]]zOperatorExpression[bool]) �expr�op�objr% r& r' r( �kwargs�returnc K sl |d krt j}t||tttf ��r"|tjtjfkrdt|t ttf�rdt j | t � tj|�||||d�S |tjtjfkr�t j | t � tj|�||||d�S | jr�t j tj||| d�}np|tjtjfkr�t j | t � tj|�tjtj|d�S |tjtjfk�rt j | t � tj|�tjtj|d�S t�d��nt j tj||| d�}|�rRt j || ||||d�S t j | |||||d�S d S )N)�type_�negate� modifiers)�element�operatorr* )r0 r/ z~Only '=', '!=', 'is_()', 'is_not()', 'is_distinct_from()', 'is_not_distinct_from()' operators can be used with None/True/False)r � BOOLEANTYPE� isinstancer r r r �eq�ner) r �_construct_for_opr �expectr Z ConstExprRole�is_distinct_from�is_not_distinct_fromZ_is_collection_aggregate�is_�is_notr � ArgumentError�BinaryElementRole)r* r+ r, r% r& r' r( r- � r@ �Q/opt/hc_python/lib64/python3.8/site-packages/sqlalchemy/sql/default_comparator.py�_boolean_compare3 s� � �� � � � �� �� �rB zcustom_op[Any]zOptional[TypeEngine[Any]])r* r+ r, r& r( �kwr. c K s< |d kr"|j r|j }n |jr"tj}t| ||f||d�|��S )N�r& r( )� return_typeZ is_comparisonr r4 �_binary_operate)r* r+ r, r& r( rC r@ r@ rA �_custom_op_operate� s � ��rG rD z roles.BinaryElementRole[Any]zOptional[TypeEngine[_T]]zOperatorExpression[_T]c K s^ t jtj|| |d�}|r$|| }}n | | }}|d krJ|j�||j�\}}tj|||||d�S )N�r* r3 )r/ r1 )r r9 r r? Z comparatorZ_adapt_expressionr r8 ) r* r+ r, r& r( rC Z coerced_obj�left�rightr@ r@ rA rF � s* � � �rF )r* r+ �otherrC r. c K s2 |t jkrt| |�S |t jkr(t| |�S t� �d S �N)r r r �NotImplementedError�r* r+ rK rC r@ r@ rA �_conjunction_operate� s rO z2Callable[[ColumnElement[Any]], ColumnElement[Any]])r* r+ �fnrC r. c K s || �S rL r@ )r* r+ rP rC r@ r@ rA �_scalar� s rQ r )r* r+ �seq_or_selectabler% rC r. c K sD t jtj|| |d�}d|jkr,|jd \}}t| ||fd|i|��S )NrH Zin_opsr% )r r9 r Z InElementRoleZ _annotationsrB )r* r+ rR r% rC r@ r@ rA �_in_impl� s" � ���rS c K sd t | jtj�s,t | jtj�rPt | jjtj�rPtjtj || |d�}t | ||f|�S t | ||f|� d S )NrH ) r5 �typer Z INDEXABLEZ TypeDecoratorZ impl_instancer r9 r r? rF �_unsupported_implrN r@ r@ rA � _getitem_impl� s � �� �rV r )r* r+ �argrC r. c O s t d|j ��d S )Nz1Operator '%s' is not supported on this expression)rM �__name__)r* r+ rW rC r@ r@ rA rU � s �rU )r* r+ rC r. c K s t | d�r| jS | �� S dS )z%See :meth:`.ColumnOperators.__inv__`.�negation_clauseN)�hasattrrY Z_negate�r* r+ rC r@ r@ rA � _inv_impl� s r\ c K s t | tj| jd�S )z%See :meth:`.ColumnOperators.__neg__`.�r3 r/ )r r �negrT r[ r@ r@ rA � _neg_impl s r_ c K s t | tj| jd�S )z)See :meth:`.ColumnOperators.bitwise_not`.r] )r r �bitwise_not_oprT r[ r@ r@ rA �_bitwise_not_impl s �ra c K sB t | tjtjtj|| tjd�ftj|tjkr2tj ntjd�|��S )z#See :meth:`.ColumnOperators.match`.rH )r( r% ) rB r �match_opr r9 r r? r Z MATCHTYPE� not_match_oprN r@ r@ rA � _match_impl s" �� ���rd c K s t | tj| jd�S )z&See :meth:`.ColumnOperators.distinct`.r] )r r � distinct_oprT r[ r@ r@ rA �_distinct_impl4 s �rf )r* r+ �cleft�crightrC r. c K s\ t | tjtjtjtjt j || tjd�tjt j || tjd�dd�||tj krPtj ntj |d�S )z%See :meth:`.ColumnOperators.between`.rH F��group�r0 r1 ) r r �_construct_for_listr r r �NULLTYPEr r9 r r? � between_op�not_between_op)r* r+ rg rh rC r@ r@ rA � _between_impl= s2 �����rp zColumnElement[str]�str)r* r+ � collationrC r. c K s t �| |�S rL )r Z _create_collation_expression)r* r+ rr rC r@ r@ rA � _collate_implb s rs z Optional[str])r* r+ �pattern�flagsrC r. c K s* t | tjtj|| tjd�|tjd|id�S )NrH ru rk )r r r9 r r? r �comma_op�not_regexp_match_op)r* r+ rt ru rC r@ r@ rA �_regexp_match_implh s ��rx )r* r+ rt � replacementru rC r. c K sL t | tjtjtjtjt j || tjd�tjt j || tjd�dd�|d|id�S )NrH Fri ru )r1 ) r r rl r rv r rm r r9 r r? )r* r+ rt ry ru rC r@ r@ rA �_regexp_replace_impl} s, ����rz rP r% )>r r �inv�add�mul�sub�div�modZbitwise_xor_opZ bitwise_or_opZbitwise_and_opr` Zbitwise_lshift_opZbitwise_rshift_op�truediv�floordivr# Zjson_path_getitem_opZjson_getitem_opZ concat_opZany_opZall_op�lt�ler7 �gt�ger6 r: r; �like_op�ilike_op� not_like_op� not_ilike_opZ contains_opZ icontains_opZ startswith_opZistartswith_opZ endswith_opZ iendswith_opZdesc_opZasc_opZnulls_first_opZ nulls_last_op�in_op� not_in_opr< r= Zcollaterb rc re rn ro r^ �getitem�lshift�rshift�containsZregexp_match_oprw Zregexp_replace_opz�Dict[str, Tuple[Callable[..., ColumnElement[Any]], util.immutabledict[str, Union[OperatorType, Callable[..., ColumnElement[Any]]]]]]�operator_lookup)FN)Z�__doc__� __future__r �typingr r r r r r r r � r r r r �elementsr r r r r r r r r r r r r r r �TypeVarr � TYPE_CHECKINGr" r# r$ rT r) rB rG rF rO rQ rS rV rU r\ r_ ra rd rf rp rs rx rz � EMPTY_DICTZ immutabledictZ _create_anyZ _create_allr� r� r6 r� r� r7 r; r: r� r� r� r� Znot_contains_opZnot_icontains_opZnot_startswith_opZnot_istartswith_opZnot_endswith_opZnot_iendswith_opZ _create_descZ _create_ascZ_create_nulls_firstZ_create_nulls_lastr� r� r< r= r� �__annotations__r@ r@ r@ rA �<module> sN �"b � � %+������������������������