a
    •˜ëjl  ã                   @   sš   d dl mZ d dlmZ d dlmZ d dlmZ ddl mZ ddl mZ ddl m	Z	 dd	l m
Z
 dd
l mZ ddl mZ ddl mZ G dd„ dejƒZdS )é   )Úfixtures)Úeq_)ÚColumn)ÚTableé   )Úcolumn)Ú
ForeignKey)ÚInteger)Úselect)ÚString)Útesting)Úvaluesc                   @   sÌ   e Zd ZdZdZdZdZedd„ ƒZedd„ ƒZ	dd	„ Z
d
d„ Zdd„ Zejjejjdd„ ƒƒZejjejjdd„ ƒƒZejjdd„ ƒZe dddg¡e dddg¡e dddg¡ejjdd„ ƒƒƒƒZdS )ÚCTETestT)ZctesZeachc              	   C   s\   t d|tdtdd�tdtdƒƒtdtdƒƒƒ t d	|tdtdd�tdtdƒƒtdtƒƒ 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   ú`/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_cte.pyÚdefine_tables   s    ûûzCTETest.define_tablesc                 C   sJ   |  | jj ¡ ddd dœddddœddddœdd	ddœd
dddœg¡ d S )Né   Úd1©r   r   r   r   Úd2r   Úd3é   Úd4é   Úd5)ÚexecuteÚtablesr   Úinsert)r   Ú
connectionr   r   r   Úinsert_data/   s    





ûþzCTETest.insert_datac                 C   sd   | j j}t|ƒ |jj g d¢¡¡ d¡}| t|jjƒ |jj ddg¡¡¡}t	| 
¡ dgƒ 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|ƒ |jj g d¢¡¡jddd�}| d¡}| ¡ }| 	t|ƒ |jj
|jjk¡¡}| t|jjƒ |jjdk¡ |jj ¡ ¡¡}t| ¡ g d¢ƒ d S )Nr(   r)   T)Ú	recursiveZc1r   )r*   ©r   r4   ©r   r5   r5   )r$   r   r
   r+   r,   r   r-   r.   ÚaliasZ	union_allr   r   r#   Úorder_byÚdescr   r/   )r0   r&   r   r.   Z	cte_aliasZst1r1   r   r   r   Ú test_select_recursive_round_tripI   s.    ÿþÿ
ÿ
ÿ
þÿþz(CTETest.test_select_recursive_round_tripc                 C   sz   | j j}| j j}t|ƒ |jj g d¢¡¡ d¡}| 	| 
¡  g d¢t|ƒ¡¡ t| 	t|ƒ |jj¡¡ ¡ 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   r7   r   r/   ©r0   r&   r   r   r.   r   r   r   Ú"test_insert_from_select_round_tripc   s&    ÿþÿÿÿÿüz*CTETest.test_insert_from_select_round_tripc                 C   s¢   | j j}| j j}| | ¡  g d¢t|ƒ¡¡ t|ƒ |jj	 
g d¢¡¡ d¡}| | ¡ jdd� |jj	|jj	k¡¡ t| t|ƒ |jj¡¡ ¡ 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%   r:   r
   r+   r,   r   r-   r.   Úupdater   r   r7   r   r/   r;   r   r   r   Útest_update_from_round_tripx   s4    ÿÿÿþÿÿþÿÿüz#CTETest.test_update_from_round_tripc                 C   sš   | j j}| j j}| | ¡  g d¢t|ƒ¡¡ t|ƒ |jj	 
g d¢¡¡ d¡}| | ¡  |jj	|jj	k¡¡ t| t|ƒ |jj¡¡ ¡ ddgƒ d S ©Nr   r(   r)   r=   r>   )r$   r   r   r#   r%   r:   r
   r+   r,   r   r-   r.   Údeleter   r7   r   r/   r;   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|ƒ |jj	 
g d¢¡¡ d¡}| | ¡  |jj	t|jj	ƒ |jj|jjk¡ ¡ k¡¡ t| t|ƒ |jj¡¡ ¡ ddgƒ d S rA   )r$   r   r   r#   r%   r:   r
   r+   r,   r   r-   r.   rB   r   Zscalar_subqueryr   r7   r/   r;   r   r   r   Ú"test_delete_scalar_subq_round_trip¸   s8    ÿÿÿþÿÿÿÿÿÿüz*CTETest.test_delete_scalar_subq_round_tripÚvalues_namedFÚ	cte_namedÚliteral_bindsc                 C   sh   t tdtƒtdtƒt|ƒ|r dnd d� ddg¡ |r:dnd ¡}t|ƒ}| |¡ 	¡ }t
|ddgƒ d S )NZcol1Zcol2z	some name)rG   Úname)Úar   )Úbr   Úcte1)r   r   r   r	   Úboolr   r.   r
   r#   Úallr   )r0   r&   rE   rF   rG   rK   ÚstmtÚrowsr   r   r   Útest_values_named_via_cte×   s    	
üú
ùÿz!CTETest.test_values_named_via_cteN)Ú__name__Ú
__module__Ú__qualname__Z__sparse_driver_backend__Ú__requires__Zrun_insertsZrun_deletesÚclassmethodr   r'   r2   r9   r<   r   ÚrequiresZctes_with_update_deleteZupdate_fromr@   Zdelete_fromrC   rD   Z	variationZctes_with_valuesrP   r   r   r   r   r      s0   

!
r   N)Ú r   Z
assertionsr   Zschemar   r   r   r   r	   r
   r   r   r   Z
TablesTestr   r   r   r   r   Ú<module>	   s   