?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/testing/suite/__pycache__/test_cte.cpython-39.pyc
???????
a ��Jh3 � @ s� d dl mZ d dlmZ d dlmZ d dlmZ ddl mZ ddl mZ ddl m Z dd l m Z dd l m Z G d d � d ej �Z d S )� )�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 �V/home/agenciai/.local/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 sd | j j}t|��|jj�g d����d�}|�t|jj��|jj�ddg���}t |� � dg� d S )N�r r r �some_cter r �r ) r" r r �where�cr �in_�cter! r �fetchall)�selfr$ r r, �resultr r r �#test_select_nonrecursive_round_trip: s ��� �z+CTETest.test_select_nonrecursive_round_tripc C s� | j j}t|��|jj�g d���jddd�}|�d�}|�� }|� t|��|jj |jj k��}|� t|jj��|jjdk�� |jj�� ��}t|�� g d�� d S )Nr& r' T)� recursiveZc1r )r( �r r2 �r r3 r3 )r" r r r) r* r r+ r, �aliasZ union_allr r r! �order_by�descr r- )r. r$ r r, Z cte_aliasZst1r/ r r r � test_select_recursive_round_tripG s. ��� � � ���z(CTETest.test_select_recursive_round_tripc C sz | j j}| j j}t|��|jj�g d����d�}|� |� � � g d�t|��� t |� t|�� |jj���� g d�� 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# � from_selectr r5 r r- �r. r$ r r r, r r r �"test_insert_from_select_round_tripa s& ��� ����z*CTETest.test_insert_from_select_round_tripc C s� | j j}| j j}|�|�� �g d�t|��� t|��|jj � g d���� d�}|�|� � j dd��|jj |jj k�� t|�t|��|jj���� g d�� 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# r8 r r) r* r r+ r, �update�valuesr r5 r r- r9 r r r �test_update_from_round_tripv s4 ����������z#CTETest.test_update_from_round_tripc C s� | j j}| j j}|�|�� �g d�t|��� t|��|jj � g d���� d�}|�|� � �|jj |jj k�� t |�t|��|jj���� ddg� d S �Nr r& r' r; r< )r" r r r! r# r8 r r) r* r r+ r, �deleter r5 r r- r9 r r r �test_delete_from_round_trip� s0 ���������z#CTETest.test_delete_from_round_tripc C s� | j j}| j j}|�|�� �g d�t|��� t|��|jj � g d���� d�}|�|� � �|jj t|jj ��|jj |jj k��� k�� t|�t|��|jj ���� ddg� d S r@ )r" r r r! r# r8 r r) r* r r+ r, rA r Zscalar_subqueryr r5 r- r9 r r r �"test_delete_scalar_subq_round_trip� s8 ����� ������z*CTETest.test_delete_scalar_subq_round_tripN)�__name__� __module__� __qualname__Z __backend__� __requires__Z run_insertsZ run_deletes� classmethodr r% r0 r7 r: r �requiresZctes_with_update_deleteZ update_fromr? Z delete_fromrB rC r r r r r s& ! r N)� r Z assertionsr Zschemar r r r r r r Z TablesTestr r r r r �<module> s
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????