a
    xˆcƒ+  ã                   @   st  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 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G dd„ dejƒZG dd„ dejƒZG dd„ dejƒZG dd „ d ejƒZG d!d"„ d"ejeƒZ G d#d$„ d$ejƒZ!d%S )&é   )Útestingé   )Úassert_raises)Úconfig)Úengines)Úeq_)Úfixtures)Úne_)Úprovide_metadata)Úrequirements)Ú set_default_schema_on_connection)ÚColumn)ÚTableé   )Ú	bindparam)Úevent)Úexc)ÚInteger)Úliteral_column)Úselect)ÚString)Úcompatc                   @   s:   e Zd ZdZdZdZedd„ ƒZej	dd„ ƒZ
dd	„ Zd
S )ÚExceptionTestz¶Test basic exception wrapping.

    DBAPIs vary a lot in exception behavior so to actually anticipate
    specific exceptions from real round trips, we need to be conservative.

    ÚeachTc              	   C   s(   t d|tdtddd�tdtdƒƒƒ d S )NÚ	manual_pkÚidTF©Úprimary_keyZautoincrementÚdataé2   ©r   r   r   r   ©ÚclsÚmetadata© r$   úh/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_dialect.pyÚdefine_tables%   s    üzExceptionTest.define_tablesc                 C   sx   t j ¡ �Z}| ¡ }| | jj ¡ dddœ¡ tt	j
|j| jj ¡ dddœƒ | ¡  W d   ƒ n1 sj0    Y  d S )Nr   Úd1©r   r   )r   ÚdbÚconnectÚbeginÚexecuteÚtablesr   Úinsertr   r   ZIntegrityErrorÚrollback)ÚselfÚconnÚtransr$   r$   r%   Útest_integrity_error.   s    ÿ
üz"ExceptionTest.test_integrity_errorc                 C   s¶   t j ¡ �˜}z| ttdƒƒ¡ ds(J ‚W nD tjyn } z*t|ƒ}t|j	ƒt|ƒv sZJ ‚W Y d }~n
d }~0 0 t
jr†t|tƒs”J ‚nt|tƒs”J ‚W d   ƒ n1 s¨0    Y  d S )Nu   mÃ©ilF)r   r)   r*   r,   r   r   r   Z
DBAPIErrorÚstrÚorigr   Zpy2kÚ
isinstance)r0   r1   ÚerrÚerr_strr$   r$   r%   Útest_exception_with_non_asciiA   s    ,z+ExceptionTest.test_exception_with_non_asciiN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Úrun_deletesÚ__backend__Úclassmethodr&   r   Z$duplicate_key_raises_integrity_errorr3   r9   r$   r$   r$   r%   r      s   

r   c                   @   s4   e Zd ZdZdZdd„ Zdd„ Zdd„ Zd	d
„ ZdS )ÚIsolationLevelTestT©Zisolation_levelc                 C   sF   t  t¡}|d }|d }t|ƒ d|g¡}|r8| ¡ S t d¡ d S )NÚdefaultÚ	supportedÚ
AUTOCOMMITz(no non-default isolation level available)r   Úget_isolation_levelsr   ÚsetÚ
differenceÚpopZ	skip_test)r0   ÚlevelsrC   rD   Úsr$   r$   r%   Ú _get_non_default_isolation_level]   s    
z3IsolationLevelTest._get_non_default_isolation_levelc                 C   s   t tjjjt t¡d ƒ d S )NrC   )r   r   r)   ÚdialectZdefault_isolation_levelr   rF   )r0   r$   r$   r%   Útest_default_isolation_leveli   s    þz/IsolationLevelTest.test_default_isolation_levelc                 C   s~   |   ¡ }tj ¡ �X}| ¡ }t||ƒ |j|d� t| ¡ |ƒ |j 	|j
¡ t| ¡ |ƒ W d   ƒ n1 sp0    Y  d S )NrB   )rL   r   r)   r*   Úget_isolation_levelr	   Úexecution_optionsr   rM   Úreset_isolation_levelÚ
connection)r0   Znon_defaultr1   Úexistingr$   r$   r%   Ú test_non_default_isolation_levelo   s    
z3IsolationLevelTest.test_non_default_isolation_levelc              	   C   sÊ   t  t¡}|d }t|ƒ dg¡D ]¢}tj ¡ �H}|j|d� t| 	¡ |ƒ | 
¡ }| ¡  t| 	¡ |ƒ W d   ƒ n1 s~0    Y  tj ¡ �"}t| 	¡ |d ƒ W d   ƒ q"1 sº0    Y  q"d S )NrD   rE   rB   rC   )r   rF   r   rG   rH   r)   r*   rP   r   rO   r+   r/   )r0   rJ   Z
all_levelsÚlevelr1   r2   r$   r$   r%   Útest_all_levels   s    
,þz"IsolationLevelTest.test_all_levelsN)	r:   r;   r<   r?   Ú__requires__rL   rN   rT   rV   r$   r$   r$   r%   rA   X   s   rA   c                   @   sD   e Zd ZdZdZdZedd„ ƒZdd„ Zdd	„ Z	d
d„ Z
dd„ ZdS )ÚAutocommitIsolationTestr   )Ú
autocommitTc              	   C   s,   t d|tdtddd�tdtdƒƒdd� d S )	NÚ
some_tabler   TFr   r   r   )Ztest_needs_acidr    r!   r$   r$   r%   r&   ž   s    ûz%AutocommitIsolationTest.define_tablesc                 C   sŒ   |  ¡ }| | jj ¡ dddœ¡ | ¡  t| t| jjj	j
ƒ¡|rHdnd ƒ |  ¡ �" | | jj ¡ ¡ W d   ƒ n1 s~0    Y  d S )Nr   z	some datar(   )r+   r,   r-   rZ   r.   r/   r   Úscalarr   Úcr   Údelete)r0   r1   rY   r2   r$   r$   r%   Ú_test_conn_autocommits¨   s    ÿ
þ
z.AutocommitIsolationTest._test_conn_autocommitsc                 C   s:   |}|j dd�}|  |d¡ |j |j¡ |  |d¡ d S )NrE   rB   TF)rP   r^   rM   rQ   rR   )r0   Úconnection_no_transr1   Úc2r$   r$   r%   Útest_autocommit_on·   s
    z*AutocommitIsolationTest.test_autocommit_onc                 C   s   |}|   |d¡ d S )NF)r^   ©r0   r_   r1   r$   r$   r%   Útest_autocommit_offÀ   s    z+AutocommitIsolationTest.test_autocommit_offc                 C   sB   |}|j dd�}|  |d¡ |j t t¡d d� |  |d¡ d S )NrE   rB   TrC   F)rP   r^   r   rF   r   rb   r$   r$   r%   Ú.test_turn_autocommit_off_via_default_iso_levelÄ   s    ÿÿzFAutocommitIsolationTest.test_turn_autocommit_off_via_default_iso_levelN)r:   r;   r<   r>   rW   r?   r@   r&   r^   ra   rc   rd   r$   r$   r$   r%   rX   –   s   
		rX   c                   @   s   e Zd Zedd„ ƒZdS )ÚEscapingTestc              	   C   sÖ   | j }td|tdtdƒƒƒ}| tj¡ tj ¡ ��}| | 	¡ t
dd�¡ | | 	¡ t
dd�¡ t| t|jjƒ |jjtdƒk¡¡dƒ t| t|jjƒ |jjtdƒk¡¡dƒ W d	  ƒ n1 sÈ0    Y  d	S )
z|test that the DBAPI accommodates for escaped / nonescaped
        percent signs in a way that matches the compiler

        Útr   r   zsome % value)r   zsome %% other valuez'some % value'z'some %% other value'N)r#   r   r   r   Úcreater   r)   r+   r,   r.   Údictr   r[   r   r\   r   Úwherer   )r0   Úmrf   r1   r$   r$   r%   Útest_percent_sign_round_tripÔ   s,    ÿÿú	ÿÿúz)EscapingTest.test_percent_sign_round_tripN)r:   r;   r<   r
   rk   r$   r$   r$   r%   re   Ó   s   re   c                   @   s4   e Zd ZdZdZdd„ Zdd„ Zdd„ Zd	d
„ ZdS )Ú WeCanSetDefaultSchemaWEventsTestT)Zdefault_schema_name_switchc                 C   sL   t jjj}t ¡ }| ¡ � W d   ƒ n1 s00    Y  t|jj|ƒ d S ©N)r   r)   rM   Údefault_schema_namer   Útesting_enginer*   r   )r0   rn   Úengr$   r$   r%   Útest_control_caseù   s
    

z2WeCanSetDefaultSchemaWEventsTest.test_control_casec                 C   sx   t jjj}t ¡ }t |d¡dd„ ƒ}| ¡ �(}|j 	|¡}t
|t jƒ W d   ƒ n1 s\0    Y  t
|jj|ƒ d S )Nr*   c                 S   s   t t| tjƒ d S rm   ©r   r   Útest_schema©Údbapi_connectionZconnection_recordr$   r$   r%   Ú
on_connect  s    ÿzMWeCanSetDefaultSchemaWEventsTest.test_wont_work_wo_insert.<locals>.on_connect)r   r)   rM   rn   r   ro   r   Úlistens_forr*   Ú_get_default_schema_namer   rs   )r0   rn   rp   rv   r1   Úwhat_it_should_ber$   r$   r%   Útest_wont_work_wo_insert  s    



*z9WeCanSetDefaultSchemaWEventsTest.test_wont_work_wo_insertc                 C   st   t  ¡ }tj|ddd�dd„ ƒ}| ¡ �(}|j |¡}t|tj	ƒ W d   ƒ n1 sV0    Y  t|jj
tj	ƒ d S )Nr*   T©r.   c                 S   s   t t| tjƒ d S rm   rr   rt   r$   r$   r%   rv     s    ÿzRWeCanSetDefaultSchemaWEventsTest.test_schema_change_on_connect.<locals>.on_connect)r   ro   r   rw   r*   rM   rx   r   r   rs   rn   )r0   rp   rv   r1   ry   r$   r$   r%   Útest_schema_change_on_connect  s    

*z>WeCanSetDefaultSchemaWEventsTest.test_schema_change_on_connectc                 C   sœ   t  ¡ }tj|ddd�dd„ ƒ}| ¡ �P}| ¡ }|j |¡}t|t	j
ƒ | ¡  |j |¡}t|t	j
ƒ W d   ƒ n1 s~0    Y  t|jjt	j
ƒ d S )Nr*   Tr{   c                 W   s   t t| tjƒ d S rm   rr   )ru   Úargr$   r$   r%   rv   %  s    ÿz\WeCanSetDefaultSchemaWEventsTest.test_schema_change_works_w_transactions.<locals>.on_connect)r   ro   r   rw   r*   r+   rM   rx   r   r   rs   r/   rn   )r0   rp   rv   r1   r2   ry   r$   r$   r%   Ú'test_schema_change_works_w_transactions"  s    

*zHWeCanSetDefaultSchemaWEventsTest.test_schema_change_works_w_transactionsN)	r:   r;   r<   r?   rW   rq   rz   r|   r~   r$   r$   r$   r%   rl   ô   s   	rl   c                   @   s   e Zd ZdS )Ú&FutureWeCanSetDefaultSchemaWEventsTestN)r:   r;   r<   r$   r$   r$   r%   r   7  s   r   c                   @   sB   e Zd ZdZejdddddddd	d
dddddddd�dd„ ƒZdS )ÚDifficultParametersTestT)Zboring)zper cent)z
per % cent)z%percent)zpar(ens))zpercent%(ens)yah)zcol:ons)Z_starts_with_underscore)zdot.s)zmore :: %colons%)z	/slashes/)zmore/slashes)zq?marks)Z1param)z1col:onÚname)Úargnamesc              	   C   sö   t d|tdtdd�t|tdƒdd�ƒ}| |¡ | | ¡  dd|d	i¡¡ t|j	| ƒ 
|j	| d	k¡}t| |¡d	ƒ t|j	| ƒ 
|j	| t|ƒk¡}| ||d	i¡ ¡ }t|j| d	ƒ t|j	| ƒ 
|j	|  d	d
g¡¡}| |¡ ¡ }d S )Nrf   r   T)r   r   F)Znullabler   z	some namezsome other_name)r   r   r   r   rg   r,   r.   Úvaluesr   r\   ri   r   r[   r   ÚfirstÚ_mappingZin_)r0   r�   rR   r#   rf   ÚstmtÚrowr$   r$   r%   Útest_round_trip@  s"    ü
"ÿz'DifficultParametersTest.test_round_tripN)r:   r;   r<   r?   r   Úcombinationsrˆ   r$   r$   r$   r%   r€   =  s(   ðr€   N)"Ú r   r   r   r   r   r   r	   r
   r   Z	provisionr   Zschemar   r   r   r   r   r   r   r   r   Úutilr   Z
TablesTestr   ZTestBaserA   rX   re   rl   ZFutureEngineMixinr   r€   r$   r$   r$   r%   Ú<module>   s8   ?>=!C
ÿ