U
|
¸ý°d ã @ 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|tdtddtdtdtdtd t d |tdtddtdtdtdt 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 úXd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/testing/suite/test_cte.pyÚ define_tables s û ûzCTETest.define_tablesc C sJ | | jj ¡ ddd ddddddddddd ddd
|
d ddg¡ 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_trip4 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)Ú recursiveZc1r& )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_tripA 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 r1 r r+ ©r, r# r r 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}| | ¡ 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" r4 r r' r( r r) r* ÚupdateÚvaluesr r1 r r+ r5 r r r Útest_update_from_round_tripp 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% r7 r8 )r! r r r r" r4 r r' r( r r) r* Údeleter r1 r r+ r5 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" r4 r r' r( r r) r* r= r Zscalar_subqueryr r1 r+ r5 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. r3 r6 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
|
