관리-도구
편집 파일: default_comparator.cpython-37.pyc
B ��4]�/ � 2 @ s d Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z dd lm Z dd lm Z dd lm Z dd lm Z dd lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm Z d d lm Z d d lm Z d d e j e!fd fd!d"�Z"d@d#d$�Z#dAd%d&�Z$d'd(� Z%d)d*� Z&d+d,� Z'd-d.� Z(d/d0� Z)d1d2� Z*d3d4� Z+d5d6� Z,d7d8� Z-d9d:� Z.d;d<� Z/e%fe%fe*fe$fe$fe$fe$fe$fe$fe#fe$fe$fe$fe&ej0fe&ej1fe"ej2fe"ej3fe"ej4fe"ej5fe"ej6fe"ej7fe"ej8fe"ej9fe"ej:fe"ej;fe"ej<fe"ej=fe"ej>fe"ej?fe"ej@fe&ejAfe&ejBfe&ejCfe&ejDfe'ejEfe'ejFfe"ejGfe"ejHfe/fe,fe,fe-fe.fe.fe+fe(fe)fe)fe)fd=�1ZIdBd>d?�ZJd S )Cz5Default implementation of SQL comparison operations. � )� operators)�type_api)�_clause_element_as_expr)� _const_expr)� _is_literal)�_literal_as_text)�and_)�BinaryExpression)� BindParameter)� ClauseElement)� ClauseList)�collate)�CollectionAggregate)� ColumnElement)�False_)�Null)�or_)� TextClause)�True_)�Tuple)�UnaryExpression)� Visitable)�Alias)� ScalarSelect)� Selectable)� SelectBase� )�exc)�utilNFc K s |d krt j}t||tttf �r�|tjtjfkrZt|t ttf�rZt | t |�||||d�S |tj tj fkr�t | t |�||||d�S |tjtjfkr�t | t|�tjtj|d�S |tjtjfkr�t | t|�tjtj|d�S t�d��n t| ||�}|�rt || ||||d�S t | |||||d�S d S )N)�type_�negate� modifiers)r r z|Only '=', '!=', 'is_()', 'isnot()', 'is_distinct_from()', 'isnot_distinct_from()' operators can be used with None/True/False)r � BOOLEANTYPE� isinstancer r r r �eq�ne�boolr r �is_distinct_from�isnot_distinct_from�is_r �isnotr � ArgumentError�_check_literal)�expr�op�objr �reverseZ_python_is_types� result_type�kwargs� r3 �T/opt/alt/python37/lib64/python3.7/site-packages/sqlalchemy/sql/default_comparator.py�_boolean_compare) sT r5 c K s< |d kr"|j r|j }n |jr"tj}t| ||f||d�|��S )N)r0 r1 )� return_typeZ is_comparisonr r" �_binary_operate)r- r. r/ r0 r1 �kwr3 r3 r4 �_custom_op_operateu s r9 c K sT t | ||�}|r || }}n | | }}|d krB|j�||j�\}}t|||||d�S )N)r r! )r, Z comparatorZ_adapt_expressionr )r- r. r/ r0 r1 r8 �left�rightr3 r3 r4 r7 � s r7 c K s2 |t jkrt| |�S |t jkr(t| |�S t� �d S )N)r r r �NotImplementedError)r- r. �otherr8 r3 r3 r4 �_conjunction_operate� s r> c K s || �S )Nr3 )r- r. �fnr8 r3 r3 r4 �_scalar� s r@ c K s� t |�}t|t�r"t| |||d�S t|t�rHt| ||�� fd|i|��S t|ttf�rnt| ||fd|i|��S t|t�r�t|t �r�|j r�t| t �r�|� dd� | D ��}t| |||d�S t �d| ��g }xX|D ]P}t|�s�t|tj�s�t �d| ��n |d k�rt� }n | �||�}|�|� q�W t|�dk�rX|tjk�rHtjtjfn tjtjf\}}t| |t|dt| t �i�j|d�|d�S ) N)r r c S s g | ] }|j �qS r3 )�type)�.0�elemr3 r3 r4 � <listcomp>� s z _in_impl.<locals>.<listcomp>z_in_() accepts either a list of expressions, a selectable, or an "expanding" bound parameter: %r� Z _tuple_values)Zagainst)r r# r r5 r � as_scalarr r r r Z expandingr Z_with_expanding_in_typesr ZInvalidRequestErrorr r ZColumnOperatorsr � _bind_param�append�len�in_opZ empty_in_opZempty_notin_opr Z self_group)r- r. Zseq_or_selectableZ negate_opr8 �args�or3 r3 r4 �_in_impl� sP rM c K s> t | jtj�r*t| ||�}t| ||f|�S t| ||f|� d S )N)r# rA r Z INDEXABLEr, r7 �_unsupported_impl)r- r. r= r8 r3 r3 r4 � _getitem_impl� s rO c O s t d|j ��d S )Nz1Operator '%s' is not supported on this expression)r< �__name__)r- r. �argr8 r3 r3 r4 rN � s rN c K s t | d�r| jS | �� S dS )z%See :meth:`.ColumnOperators.__inv__`.�negation_clauseN)�hasattrrR Z_negate)r- r. r8 r3 r3 r4 � _inv_impl� s rT c K s t | tj| jd�S )z%See :meth:`.ColumnOperators.__neg__`.)�operatorr )r r �negrA )r- r. r8 r3 r3 r4 � _neg_impl� s rW c K s: t | tjt| tj|�ftj|tjkr*tjntjd�|��S )z#See :meth:`.ColumnOperators.match`.)r1 r )r5 r �match_opr, r Z MATCHTYPE� notmatch_op)r- r. r= r8 r3 r3 r4 � _match_impl s rZ c K s t | tj| jd�S )z&See :meth:`.ColumnOperators.distinct`.)rU r )r r � distinct_oprA )r- r. r8 r3 r3 r4 �_distinct_impl s r\ c K sH t | tt| tj|�t| tj|�tjddd�||tjkr<tjntj|d�S )z%See :meth:`.ColumnOperators.between`.F)rU �groupZgroup_contents)r r! )r r r, r r � between_op� notbetween_op)r- r. ZcleftZcrightr8 r3 r3 r4 � _between_impl s r` c K s t | |�S )N)r )r- r. r= r8 r3 r3 r4 � _collate_impl, s ra )1r r �inv�add�mul�subZdiv�mod�truedivZ custom_opZjson_path_getitem_opZjson_getitem_opZ concat_opZany_opZall_op�lt�ler% �gt�ger$ r' r( �like_op�ilike_op� notlike_op� notilike_opZ contains_opZ startswith_opZ endswith_opZdesc_opZasc_opZ nullsfirst_opZ nullslast_oprJ �notin_opr) r* r rX rY r[ r^ r_ rV �getitem�lshift�rshift�containsc C s� t |ttf�r4t |t�r0|jjr0|�� }| j|_|S t|d�rH|�� }nt |t j j �r\|j }t |t tf�rr|�� S t |t�s�| j|||d�S |S d S )N�__clause_element__)r )r# r r r rA Z_isnullZ_clonerS ru r Z TypeEngineZ Comparatorr- r r rF r rG )r- rU r= Zbindparam_typer3 r3 r4 r, g s r, )FN)FN)N)K�__doc__� r r �elementsr r r r r r r r r r r r r r r r r r r r Z selectabler r r r r r ZNoneTyper& r5 r9 r7 r> r@ rM rO rN rT rW rZ r\ r` ra Z _create_anyZ _create_allrk rj r$ ri rh r% r( r' rn ro rl rm Znotcontains_opZnotstartswith_opZnotendswith_opZ _create_descZ _create_ascZ_create_nullsfirstZ_create_nullslastrp rJ r) r* Zoperator_lookupr, r3 r3 r3 r4 �<module> s� E J