Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/site-packages/sqlalchemy/testing/suite/__pycache__/test_select.cpython-39.pyc
Ðазад
a _�hI_ � @ s� d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ ddl m Z dd l m Z dd l m Z dd l m Z dd l m Z dd l mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ G dd� dej�Z G d d � d ej�Z G d d � d ej�Z G d d!� d!ej�Z G d"d#� d#ej�Z G d$d%� d%ej�Z!G d&d'� d'ej�Z"G d(d)� d)ej�Z#G d*d+� d+ej�Z$d,S )-� )�config)�fixtures)�eq_)�in_)�Column)�Table� )� bindparam)�case)�Computed)�exists)�false)�func)�Integer)�literal)�literal_column)�null)�select)�String)�testing)�text)�true)�tuple_)�union)�utilc @ s@ e Zd ZdZedd� �Zedd� �Zdd� Zej j dd � �Z d S ) � CollateTestTc C s& t d|tdtdd�tdtd��� d S )N� some_table�idT�Z primary_key�data�d �r r r r ��cls�metadata� r% ��/root/rpmbuild/BUILDROOT/imh-python39-modules-3.9.7-92.el8.x86_64/opt/imh-python/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_select.py� define_tables s �zCollateTest.define_tablesc C s( |� | jj�� ddd�ddd�g� d S )N� � collate data1�r r r � collate data2��execute�tablesr �insert�r# � connectionr% r% r& � insert_data' s ��zCollateTest.insert_datac C s t tj�|��� |� d S �N�r r �dbr- �fetchall��selfr �resultr% r% r& �_assert_result1 s zCollateTest._assert_resultc C sD t j�t j�}| �t| jjg��| jjj j � |�� � �ddg� d S )N)r( r) )r r+ ) r �requiresZget_order_by_collationr r: r r. r �order_by�cr Zcollate�asc)r8 Z collationr% r% r& �test_collate_order_by4 s ��z!CollateTest.test_collate_order_byN) �__name__� __module__� __qualname__� __backend__� classmethodr' r2 r: r r; Zorder_by_collationr? r% r% r% r& r s r c @ sl e Zd ZdZdZedd� �Zedd� �Zdd� Zd d � Z d d � Z d d� Z dd� Z dd� Z ejjdd� �ZdS )�OrderByLabelTestz�Test the dialect sends appropriate ORDER BY expressions when labels are used. This essentially exercises the "supports_simple_order_by_label" setting. Tc C sB t d|tdtdd�tdt�tdt�tdtd��td td��� d S ) Nr r Tr �x�y�q�2 �pr! r" r% r% r& r' K s �z OrderByLabelTest.define_tablesc C sB |� | jj�� dddddd�dddddd�ddd d d d�g� d S ) Nr( r �q1Zp3)r rF rG rH rJ r �q2Zp2� Zq3�p1r, r0 r% r% r& r2 W s ��z OrderByLabelTest.insert_datac C s t tj�|��� |� d S r3 r4 r7 r% r% r& r: b s z OrderByLabelTest._assert_resultc C s6 | j j}|jj�d�}| �t|g��|�g d�� d S )N�lx)�r( �r �r )r. r r= rF �labelr: r r< �r8 �tablerO r% r% r& � test_plaine s zOrderByLabelTest.test_plainc C s> | j j}|jj|jj �d�}| �t|g��|�g d�� d S )NrO )rR �� �� ) r. r r= rF rG rS r: r r< rT r% r% r& �test_composed_intj s z"OrderByLabelTest.test_composed_intc C s� | j j}|jj|jj �d�}t�|jj�|jj �d�}| � t ||g�� ||� � �dt�d�fdt�d�fdt�d�fg� d S ) NrO �lyr Zq1p3rX Zq2p2rZ Zq3p1)r. r r= rF rG rS r �lowerrH rJ r: r r< �descr �u)r8 rU rO r\ r% r% r& �test_composed_multipleo s &�z'OrderByLabelTest.test_composed_multiplec C s: | j j}|jj�d�}| �t|g��|�� �g d�� d S )NrO )rR rQ rP ) r. r r= rF rS r: r r< r^ rT r% r% r& �test_plain_descx s �z OrderByLabelTest.test_plain_descc C sB | j j}|jj|jj �d�}| �t|g��|� � �g d�� d S )NrO )rY rW rR ) r. r r= rF rG rS r: r r< r^ rT r% r% r& �test_composed_int_desc s �z'OrderByLabelTest.test_composed_int_descc C sT | j j}|jj|jj �d�}tt�|jj �|g�� |�� |�}| � |g d�� d S )NrO ))r( r )r( rX )r( rZ ) r. r r= rF rG rS r r �countr Zgroup_byr< r: )r8 rU �expr�stmtr% r% r& �test_group_by_composed� s ���z'OrderByLabelTest.test_group_by_composedN)r@ rA rB �__doc__rC rD r' r2 r: rV r[ r` ra rb r r; Zgroup_by_complex_expressionrf r% r% r% r& rE @ s rE c @ s� e Zd ZdZedd� �Zedd� �Zddd�Zd d � Ze j j d d � �Z e j j d d� �Z e j j dd� �Ze j jdd� �Ze j jdd� �Ze j jdd� �ZdS )�LimitOffsetTestTc C s* t d|tdtdd�tdt�tdt�� d S �Nr r Tr rF rG �r r r r" r% r% r& r' � s �z LimitOffsetTest.define_tablesc C s@ |� | jj�� dddd�dddd�dddd�dddd�g� d S �Nr( r )r rF rG r rM rX r, r0 r% r% r& r2 � s ��zLimitOffsetTest.insert_datar% c C s t tj�||��� |� d S r3 r4 �r8 r r9 �paramsr% r% r& r: � s z LimitOffsetTest._assert_resultc C s2 | j j}| �t|g��|jj��d�ddg� d S )Nr �r( r( r �r r r )r. r r: r r< r= r �limit�r8 rU r% r% r& �test_simple_limit� s �z!LimitOffsetTest.test_simple_limitc C s2 | j j}| �t|g��|jj��d�ddg� d S )Nr �r r rM �rM rM rX )r. r r: r r< r= r �offsetrq r% r% r& �test_simple_offset� s �z"LimitOffsetTest.test_simple_offsetc C s8 | j j}| �t|g��|jj��d��d�ddg� d S )Nr r( ro rs ) r. r r: r r< r= r rp ru rq r% r% r& �test_simple_limit_offset� s �z(LimitOffsetTest.test_simple_limit_offsetc C sZ | j j}t|g��|jj��d��d�}|jt j j ddid�}t |�}| � |ddg� dS ) z7test that 'literal binds' mode works - no bound params.r r( Z literal_bindsT)�dialect�compile_kwargsro rs N)r. r r r< r= r rp ru �compiler r5 rx �strr: )r8 rU re �sqlr% r% r& �test_limit_offset_nobinds� s �z)LimitOffsetTest.test_limit_offset_nobindsc C s> | j j}| jt|g��|jj��td��ddgddid� d S )N�lrn ro r �rm ) r. r r: r r< r= r rp r rq r% r% r& �test_bound_limit� s �z LimitOffsetTest.test_bound_limitc C s> | j j}| jt|g��|jj��td��ddgddid� d S )N�ors rt r r ) r. r r: r r< r= r ru r rq r% r% r& �test_bound_offset� s �z!LimitOffsetTest.test_bound_offsetc C sJ | j j}| jt|g��|jj��td��� td��ddgddd�d� d S ) Nr~ r� ro rs r r( )r~ r� r ) r. r r: r r< r= r rp r ru rq r% r% r& �test_bound_limit_offset� s ����z'LimitOffsetTest.test_bound_limit_offsetN)r% )r@ rA rB rC rD r' r2 r: rr r r; ru rv rw r} Zbound_limit_offsetr� r� r� r% r% r% r& rh � s& rh c @ s� e Zd ZdZedd� �Zedd� �Zddd�Zd d � Zd d � Z e j j e j j d d� ��Ze j jdd� �Zdd� Ze j j dd� �Zdd� ZdS )�CompoundSelectTestTc C s* t d|tdtdd�tdt�tdt�� d S ri rj r" r% r% r& r' � s �z CompoundSelectTest.define_tablesc C s@ |� | jj�� dddd�dddd�dddd�dddd�g� d S rk r, r0 r% r% r& r2 � s ��z CompoundSelectTest.insert_datar% c C s t tj�||��� |� d S r3 r4 rl r% r% r& r: s z!CompoundSelectTest._assert_resultc C s` | j j}t|g��|jjdk�}t|g��|jjdk�}t||�}| �|�|jj�ddg� d S �Nr r ro rs ) r. r r �wherer= r r r: r< �r8 rU �s1�s2�u1r% r% r& �test_plain_union s z#CompoundSelectTest.test_plain_unionc C sh | j j}t|g��|jjdk�}t|g��|jjdk�}t||��� �� }| �|� |jj�ddg� d S r� ) r. r r r� r= r r �aliasr: r< r� r% r% r& � test_select_from_plain_union s z/CompoundSelectTest.test_select_from_plain_unionc C s� | j j}t|g��|jjdk��d��|jj�}t|g��|jjdk��d��|jj�}t||��d�}| � |�|jj�ddg� d S �Nr r( r ro rs ) r. r r r� r= r rp r< r r: r� r% r% r& �&test_limit_offset_selectable_in_unions s& ���� ����z9CompoundSelectTest.test_limit_offset_selectable_in_unionsc C sz | j j}t|g��|jjdk��|jj�}t|g��|jjdk��|jj�}t||��d�}| � |�|jj�ddg� d S r� ) r. r r r� r= r r< r rp r: r� r% r% r& �"test_order_by_selectable_in_unions1 s ""z5CompoundSelectTest.test_order_by_selectable_in_unionsc C sn | j j}t|g��|jjdk��� }t|g��|jjdk��� }t||��d�}| � |� |jj�ddg� d S r� ) r. r r r� r= r Zdistinctr rp r: r< r� r% r% r& �"test_distinct_selectable_in_unions: s z5CompoundSelectTest.test_distinct_selectable_in_unionsc C s� | j j}t|g��|jjdk��d��|jj�}t|g��|jjdk��d��|jj�}t||�� � }| � |�� �d��|jj�ddg� d S r� ) r. r r r� r= r rp r< r r� r: r� r% r% r& �&test_limit_offset_in_unions_from_aliasB s* ���� ���� �z9CompoundSelectTest.test_limit_offset_in_unions_from_aliasc C s� | j j}t|g��|jjdk��d��|jj��� �� }t|g��|jjdk��d��|jj��� �� }t ||��d�}| � |�|jj�ddg� d S r� ) r. r r r� r= r rp r< r� r r: r� r% r% r& �.test_limit_offset_aliased_selectable_in_unionsX s& ��� � ��� � zACompoundSelectTest.test_limit_offset_aliased_selectable_in_unionsN)r% )r@ rA rB rC rD r' r2 r: r� r� r r; Zorder_by_col_from_unionZ/parens_in_union_contained_select_w_limit_offsetr� Z0parens_in_union_contained_select_wo_limit_offsetr� r� r� r� r% r% r% r& r� � s" r� c @ s� e Zd ZdZedd� �Zedd� �Zd dd�Zd d � Ze j j d d � �Z e j j d d� �Z dd� Ze j jdd� �Ze j jdd� �Zdd� Zdd� Zdd� Zdd � Zd d � Zd S )!�ExpandingBoundInTestTc C s6 t d|tdtdd�tdt�tdt�tdtd��� d S ) Nr r Tr rF rG �zrI r! r" r% r% r& r' r s �z"ExpandingBoundInTest.define_tablesc C sH |� | jj�� ddddd�ddddd�ddddd�ddd d d�g� d S ) Nr( r Zz1)r rF rG r� r �z2rM �z3rX �z4r, r0 r% r% r& r2 } s ��z ExpandingBoundInTest.insert_datar% c C s t tj�||��� |� d S r3 r4 rl r% r% r& r: � s z#ExpandingBoundInTest._assert_resultc C sj | j j}t|jjg��|jj�tddd����|jj �tddd���� |jj�}| j |g g g d�d� d S )NrH T�� expandingrJ )rH rJ r ) r. r r r= r r� rF r r rG r< r: �r8 rU re r% r% r& �test_multiple_empty_sets� s ����z-ExpandingBoundInTest.test_multiple_empty_setsc C sZ | j j}t|jjg��t|jj|jj�� t ddd���� |jj�}| j |g dg id� d S �NrH Tr� r � r. r r r= r r� r rF r� r r r< r: r� r% r% r& � test_empty_heterogeneous_tuples� s ���� z4ExpandingBoundInTest.test_empty_heterogeneous_tuplesc C sZ | j j}t|jjg��t|jj|jj�� t ddd���� |jj�}| j |g dg id� d S r� � r. r r r= r r� r rF rG r r r< r: r� r% r% r& � test_empty_homogeneous_tuples� s ���� z2ExpandingBoundInTest.test_empty_homogeneous_tuplesc C sX | j j}t|jjg��|jj�tddd���� |jj�}| j |g d�dg d�id� d S )NrH Tr� �rQ rR �rM )r r rM r � r. r r r= r r� rF r r r< r: r� r% r% r& �test_bound_in_scalar� s ���z)ExpandingBoundInTest.test_bound_in_scalarc C sb | j j}t|jjg��t|jj|jj�� t ddd���� |jj�}| j |g d�dg d�id� d S )NrH Tr� r� ))r r )r rM )rM rX r r� r� r% r% r& �test_bound_in_two_tuple� s ���� �z,ExpandingBoundInTest.test_bound_in_two_tuplec C sb | j j}t|jjg��t|jj|jj�� t ddd���� |jj�}| j |g d�dg d�id� d S )NrH Tr� r� ))r r� )r r� )rM r� r r� r� r% r% r& �%test_bound_in_heterogeneous_two_tuple� s ���� �z:ExpandingBoundInTest.test_bound_in_heterogeneous_two_tuplec C sP | j j}t|jjg��|jj�tddd���� |jj�}| j |g dg id� d S r� r� r� r% r% r& � test_empty_set_against_integer� s ���z3ExpandingBoundInTest.test_empty_set_against_integerc C sT | j j}t|jjg��|jj�tddd���� |jj�}| j |g d�dg id� d S �NrH Tr� )rP rQ rR r� r ) r. r r r= r r� rF �notin_r r< r: r� r% r% r& �'test_empty_set_against_integer_negation� s ���z<ExpandingBoundInTest.test_empty_set_against_integer_negationc C sP | j j}t|jjg��|jj�tddd���� |jj�}| j |g dg id� d S r� ) r. r r r= r r� r� r r r< r: r� r% r% r& � test_empty_set_against_string s ���z2ExpandingBoundInTest.test_empty_set_against_stringc C sT | j j}t|jjg��|jj�tddd���� |jj�}| j |g d�dg id� d S r� ) r. r r r= r r� r� r� r r< r: r� r% r% r& �&test_empty_set_against_string_negation s ���z;ExpandingBoundInTest.test_empty_set_against_string_negationc C sL t tt� �tdddd��t� fgt� d�g�}ttj� |�� � d d� d S )NZfoor% T)�valuer� )Zelse_� )Fr� ) r r r r r r r r r5 r- Zfetchone)r8 re r% r% r& � test_null_in_empty_set_is_false s ������z4ExpandingBoundInTest.test_null_in_empty_set_is_falseN)r% )r@ rA rB rC rD r' r2 r: r� r r; Ztuple_in_w_emptyr� r� r� Ztuple_inr� r� r� r� r� r� r� r% r% r% r& r� o s* r� c @ s� e Zd ZdZdZdZedd� �Zedd� �Zdd � Z d d � Z d d � Z dd� Z dd� Z dd� Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d!� Zd"d#� Zd$d%� ZdS )&�LikeFunctionsTestT�onceNc C s& t d|tdtdd�tdtd��� d S )Nr r Tr r rI r! r" r% r% r& r' 0 s �z LikeFunctionsTest.define_tablesc C sh |� | jj�� ddd�ddd�ddd�dd d�d d d�d d d�ddd�ddd�ddd�ddd�g � d S )Nr( Zabcdefgr* r zab/cdefgr zab%cdefgrM Zab_cdefgrX zabcde/fg� zabcde%fgrZ zab#cdefg� Zab9cdefg� zabcde#fg� Zabcd9fgr, r0 r% r% r& r2 9 s ��z LikeFunctionsTest.insert_datac C sd | j j}tj�� �4}dd� |�t|jjg�� |��D �}W d � n1 sL0 Y t ||� d S )Nc S s h | ] \}|�qS r% r% )�.0r� r% r% r& � <setcomp>O s �z*LikeFunctionsTest._test.<locals>.<setcomp>) r. r r r5 �connectr- r r= r r� r )r8 rd �expectedr �conn�rowsr% r% r& �_testK s ��$zLikeFunctionsTest._testc C s& | j jjj}| �|�d�h d�� d S )N�ab%c� r( r r rM rX r� rZ r� r� r� �r. r r= r r� � startswith�r8 �colr% r% r& �test_startswith_unescapedX s z+LikeFunctionsTest.test_startswith_unescapedc C s( | j jjj}| �|jddd�dh� d S )Nr� T�� autoescaper r� r� r% r% r& �test_startswith_autoescape\ s z,LikeFunctionsTest.test_startswith_autoescapec C s* | j jjj}| �|�td��h d�� d S )Nz'ab%c'r� )r. r r= r r� r� r r� r% r% r& �test_startswith_sqlexpr` s �z)LikeFunctionsTest.test_startswith_sqlexprc C s( | j jjj}| �|jddd�dh� d S )Nzab##c�#��escaperZ r� r� r% r% r& �test_startswith_escapeg s z(LikeFunctionsTest.test_startswith_escapec C sD | j jjj}| �|jdddd�dh� | �|jdddd�dh� d S )Nr� Tr� �r� r� r zab#crZ r� r� r% r% r& �!test_startswith_autoescape_escapek s z3LikeFunctionsTest.test_startswith_autoescape_escapec C s& | j jjj}| �|�d�h d�� d S )N�e%fg� r( r r rM rX r� rZ r� r� �r. r r= r r� �endswithr� r% r% r& �test_endswith_unescapedp s z)LikeFunctionsTest.test_endswith_unescapedc C s* | j jjj}| �|�td��h d�� d S )Nz'e%fg'r� )r. r r= r r� r� r r� r% r% r& �test_endswith_sqlexprt s �z'LikeFunctionsTest.test_endswith_sqlexprc C s( | j jjj}| �|jddd�dh� d S )Nr� Tr� r� r� r� r% r% r& �test_endswith_autoescapez s z*LikeFunctionsTest.test_endswith_autoescapec C s( | j jjj}| �|jddd�dh� d S )Nze##fgr� r� r� r� r� r% r% r& �test_endswith_escape~ s z&LikeFunctionsTest.test_endswith_escapec C sD | j jjj}| �|jdddd�dh� | �|jdddd�dh� d S )Nr� Tr� r� r� ze#fgr� r� r� r% r% r& � test_endswith_autoescape_escape� s z1LikeFunctionsTest.test_endswith_autoescape_escapec C s& | j jjj}| �|�d�h d�� d S )N�b%cder� �r. r r= r r� �containsr� r% r% r& �test_contains_unescaped� s z)LikeFunctionsTest.test_contains_unescapedc C s( | j jjj}| �|jddd�dh� d S )Nr� Tr� r r� r� r% r% r& �test_contains_autoescape� s z*LikeFunctionsTest.test_contains_autoescapec C s( | j jjj}| �|jddd�dh� d S )Nzb##cder� r� rZ r� r� r% r% r& �test_contains_escape� s z&LikeFunctionsTest.test_contains_escapec C sD | j jjj}| �|jdddd�dh� | �|jdddd�dh� d S )Nzb%cdTr� r� r zb#cdrZ r� r� r% r% r& � test_contains_autoescape_escape� s z1LikeFunctionsTest.test_contains_autoescape_escape)r@ rA rB rC Z run_insertsZ run_deletesrD r' r2 r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r% r% r% r& r� * s, r� c @ s< e Zd ZdZdZedd� �Zedd� �Zdd� Zd d � Z d S ) �ComputedColumnTestT)Zcomputed_columnsc C s> t d|tdtdd�tdt�tdttd��tdttd ��� d S ) N�squarer Tr �side�areaz side * side� perimeterz4 * side)r r r r r" r% r% r& r' � s �z ComputedColumnTest.define_tablesc C s( |� | jj�� ddd�ddd�g� d S )Nr( r� )r r� �* )r- r. r� r/ r0 r% r% r& r2 � s �z ComputedColumnTest.insert_datac C sl t j�� �N}|�ttd�g��| jj�� | jjj j ��� � }t |ddg� W d � n1 s^0 Y d S )N�*)r( r� r �( )r� r� �� � )r r5 r� r- r r � select_fromr. r� r< r= r r6 r �r8 r� �resr% r% r& �test_select_all� s � ��z"ComputedColumnTest.test_select_allc C sz t j�� �\}|�t| jjjj| jjjj g�� | jj�� | jjjj ��� � }t|ddg� W d � n1 sl0 Y d S )N)r r� )r� r� )r r5 r� r- r r. r� r= r� r� r� r< r r6 r r� r% r% r& �test_select_columns� s �� ��z&ComputedColumnTest.test_select_columnsN) r@ rA rB rC � __requires__rD r' r2 r� r� r% r% r% r& r� � s r� c @ s8 e Zd ZdZedd� �Zedd� �Zdd� Zdd � Zd S ) � ExistsTestTc C s& t d|tdtdd�tdtd��� d S )N�stuffr Tr r rI r! r" r% r% r& r' � s �zExistsTest.define_tablesc C s8 |� | jj�� ddd�ddd�ddd�ddd�g� d S )Nr( � some datar* r r rM zsome other data)r- r. r� r/ r0 r% r% r& r2 � s ��zExistsTest.insert_datac C sB | j j}t|�ttd�g��t� �|jj dk���� � dg� d S )Nr( r� rP � r. r� r r- r r r� r r= r r6 �r8 r1 r� r% r% r& �test_select_exists� s ���z ExistsTest.test_select_existsc C s@ | j j}t|�ttd�g��t� �|jj dk���� � g � d S )Nr( zno datar� r� r% r% r& �test_select_exists_false� s ���z#ExistsTest.test_select_exists_falseN) r@ rA rB rC rD r' r2 r� r� r% r% r% r& r� � s r� c @ s@ e Zd ZdZdZedd� �Zejddddd d d d �d d� �Z dS )�IsOrIsNotDistinctFromTestT)Zsupports_is_distinct_fromc C s2 t d|tdtdd�tdtdd�tdtdd�� d S )N�is_distinct_testr Tr �col_a)Znullable�col_brj r" r% r% r& r' � s �z'IsOrIsNotDistinctFromTest.define_tables)Zboth_int_differentr� r( r( )Z both_int_samer( r( r� )Zone_null_firstNr( r( )Zone_null_secondr� Nr( )Z both_nullNNr� Ziaaaz3col_a_value, col_b_value, expected_row_count_for_is)Zid_�argnamesc C s� | j j}|�|�� d||d�g� |�|�|jj�|jj���� � }t t |�|� |dkr^dnd}|�|�|jj� |jj���� � }t t |�|� d S )Nr( )r r� r� r� ) r. r� r- r/ r r= r� Zis_distinct_fromr� r6 r �lenZisnot_distinct_from)r8 Z col_a_valueZ col_b_valueZexpected_row_count_for_isr1 Ztblr9 Z expected_row_count_for_isnotr% r% r& � test_is_or_isnot_distinct_from s* ������z8IsOrIsNotDistinctFromTest.test_is_or_isnot_distinct_fromN) r@ rA rB rC r� rD r' r � combinationsr� r% r% r% r& r� � s � r� N)%� r r Z assertionsr r Zschemar r r r r r r r r r r r r r r r r r r r Z TablesTestr rE rh r� r� r� r� r� r� r% r% r% r& �<module> sB %R_~ <o+/
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка