Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/site-packages/sqlalchemy/testing/suite/__pycache__/test_cte.cpython-39.pyc
Ðазад
a _�h� � @ s� d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ ddl mZ ddl m Z dd l m Z dd l m Z dd l m Z G d d � d ej �ZdS )� )�config)�fixtures)�eq_)�Column)�Table� )� ForeignKey)�Integer)�select)�String)�testingc @ s� e Zd ZdZdZdZdZedd� �Zedd� �Z dd � Z d d � Z d d � Z e jje jjdd� ��Ze jje jjdd� ��Ze jjdd� �ZdS )�CTETestT)ZctesZeachc C s\ t d|tdtdd�tdtd��tdtd��� t d |tdtdd�tdtd��tdt�� d S ) N� some_table�idT)Z primary_key�data�2 � parent_idz some_table.id�some_other_table)r 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_cte.py� define_tables s � �zCTETest.define_tablesc C sJ |� | jj�� ddd d�dddd�dddd�dd dd�d d dd�g� d S ) N� �d1�r r r r �d2r �d3� �d4� �d5)�execute�tablesr �insert)r � connectionr r r � insert_data& s ��zCTETest.insert_datac C s� | j j}tj�� �l}t|g��|jj� g d���� d�}|� t|jjg��|jj� ddg���}t |� � dg� W d � n1 s�0 Y d S )N�r r r �some_cter r! �r )r# r r �db�connectr �where�cr �in_�cter" r �fetchall)�selfr �connr/ �resultr r r �#test_select_nonrecursive_round_trip3 s ��� �z+CTETest.test_select_nonrecursive_round_tripc C s� | j j}tj�� ��}t|g��|jj� g d���j ddd�}|� d�}|� � }|� t|g��|jj |jjk��}|�t|jjg��|jjdk��|jj�� ��}t|�� g d�� W d � n1 s�0 Y d S )Nr' r( T)� recursive�c1r )r) �r r7 �r r8 r8 )r# r r r* r+ r r, r- r r. r/ �aliasZ union_allr r r" �order_by�descr r0 )r1 r r2 r/ Z cte_aliasZst1r3 r r r � test_select_recursive_round_tripA s0 ��� � � ���z(CTETest.test_select_recursive_round_tripc C s� | j j}| j j}tj�� �|}t|g��|jj � g d���� d�}|� |� � �g d�t|g��� t|� t|g��|jj���� g d�� W d � n1 s�0 Y d S )Nr' r( r ))r r r )r r r )r r r )r# r r r r* r+ r r, r- r r. r/ r" r$ � from_selectr r: r r0 �r1 r r r2 r/ r r r �"test_insert_from_select_round_trip\ s( �������z*CTETest.test_insert_from_select_round_tripc C s� | j j}| j j}tj�� ��}|�|�� �g d�t |g��� t |g�� |j j � g d����d�}|�|�� jdd�� |j j |j j k�� t|�t |g��|j j���� g d�� W d � n1 s�0 Y d S )Nr r' r( r )r )�r r N)r r r )r r r )r r r �r r! r )r# r r r r* r+ r" r$ r= r r, r- r r. r/ �update�valuesr r: r r0 r> r r r �test_update_from_round_tripr s6 �� ��������z#CTETest.test_update_from_round_tripc C s� | j j}| j j}tj�� ��}|�|�� �g d�t |g��� t |g�� |j j � g d����d�}|�|�� � |j j |j j k�� t|�t |g��|j j���� ddg� W d � n1 s�0 Y d S �Nr r' r( r@ rA )r# r r r r* r+ r" r$ r= r r, r- r r. r/ �deleter r: r r0 r> r r r �test_delete_from_round_trip� s2 �� �������z#CTETest.test_delete_from_round_tripc C s� | j j}| j j}tj�� ��}|�|�� �g d�t |g��� t |g�� |j j � g d����d�}|�|�� � |j j t |j j g�� |j j|j jk�k�� t|�t |g��|j j���� ddg� W d � n1 s�0 Y d S rE )r# r r r r* r+ r" r$ r= r r, r- r r. r/ rF r r r: r0 r> r r r �"test_delete_scalar_subq_round_trip� s: �� ���������z*CTETest.test_delete_scalar_subq_round_tripN)�__name__� __module__� __qualname__Z __backend__� __requires__Z run_insertsZ run_deletes� classmethodr r& r4 r< r? r �requiresZctes_with_update_deleteZ update_fromrD Z delete_fromrG rH r r r r r s& " r N)� r r Z assertionsr Zschemar r r r r r r Z TablesTestr r r r r �<module> s
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка