관리-도구
편집 파일: test_cte.cpython-38.pyc
U -?�f3 � @ 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 �Q/opt/hc_python/lib64/python3.8/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 sf | j j}t|��|jj�dddg���d�}|�t|jj��|jj�ddg���}t |� � dg� d S )Nr r r �some_cter �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�dddg��jddd�}|�d�}|�� }|� t|��|jj |jj k��}|� t|jj��|jjdk�� |jj�� ��}t|�� dd d d d d g� d S ) Nr r r r% T)� recursive�c1r& )r )r )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 s0 � �� � � ���z(CTETest.test_select_recursive_round_tripc C s� | j j}| j j}t|��|jj�dddg���d�}|� |� � � dddgt|��� t |� t|�� |jj���� dd d g� 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 r" � from_selectr r2 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}|�|�� �dddgt|��� t|��|jj � dddg��� d�}|�|� � j dd ��|jj |jj k�� t|�t|��|jj���� d d d d dg� d S )Nr r r r r r r% r )r �r r N)r r r )r r r )r r r �r r r )r! r r r r" r5 r r' r( r r) r* �update�valuesr r2 r r+ r6 r r r �test_update_from_round_tripv s@ �����������z#CTETest.test_update_from_round_tripc C s� | j j}| j j}|�|�� �dddgt|��� t|��|jj � dddg��� d�}|�|� � �|jj |jj k�� t |�t|��|jj���� dd g� d S � Nr r r r r r r% r8 r9 )r! r r r r" r5 r r' r( r r) r* �deleter r2 r r+ r6 r r r �test_delete_from_round_trip� s2 ���������z#CTETest.test_delete_from_round_tripc C s� | j j}| j j}|�|�� �dddgt|��� t|��|jj � dddg��� d�}|�|� � �|jj t|jj ��|jj |jj k��� k�� t|�t|��|jj ���� dd g� d S r= )r! r r r r" r5 r r' r( r r) r* r> r Zscalar_subqueryr r2 r+ r6 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$ r. r4 r7 r �requiresZctes_with_update_deleteZ update_fromr< Z delete_fromr? r@ 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