a
    xˆcÌx  ã                   @   sè  d dl Z d dlZd dlZd dlZd dl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 e ¡ G dd„ deƒƒZ da!e j"dd„ ƒZ#G dd„ deƒZ$G dd„ de ƒZ%G dd„ deƒZ&G d d!„ d!eƒZ'e(ƒ Z)d"d#„ Z*d$d%„ Z+d&d'„ Z,d(d)„ Z-G d*d+„ d+e ƒZ.G d,d-„ d-e%ej/ƒZ0G d.d/„ d/e0ƒZ1G d0d1„ d1e%ƒZ2G d2d3„ d3eƒZ3dS )4é    Né   )Ú
assertions)Úconfig©Úschema©Úeq_)Úne_)ÚBasicEntity)ÚComparableEntity)ÚComparableMixin)Úadict)Údrop_all_tables_from_metadataé   )Úevent)Úutil)Údeclarative_base)Úregistry)ÚDeclarativeMeta)Úsort_tables_and_constraints)Úvisitors)ÚClauseElementc                   @   s  e Zd ZdZdZdZdZdZd$dd„Ze	 
¡ dd„ ƒZe	 
¡ dd	„ ƒZe	 
¡ d
d„ ƒZe	 
¡ dd„ ƒZe	 
¡ dd„ ƒZe	j
dd„ ƒZe	 
¡ dd„ ƒZe	 
¡ dd„ ƒZe	 
¡ dd„ ƒZe	 
¡ dd„ ƒZe	j
dd„ ƒZe	 
¡ dd„ ƒZe	j
dd„ d D ƒd!�d"d#„ ƒZdS )%ÚTestBase© NFc                 C   s   |sJ |ƒ‚d S ©Nr   )ÚselfÚvalÚmsgr   r   ú^/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/sqlalchemy/testing/fixtures.pyÚassert_7   s    zTestBase.assert_c                 c   s"   t jj}d t j_d V  |t j_d S r   ©r   ÚdbZ_compiled_cache©r   Ú_cacher   r   r   Únocache:   s    zTestBase.nocachec                 c   sD   t | dd ƒptj}| ¡ �}|V  W d   ƒ n1 s60    Y  d S ©NÚbind)Úgetattrr   r!   Úconnect)r   ÚengÚconnr   r   r   Úconnection_no_transA   s    
zTestBase.connection_no_transc                 c   sJ   t | dd ƒptj}| ¡ }| ¡ }|a|V  d a|jr>| ¡  | ¡  d S r%   )	r'   r   r!   r(   ÚbeginÚ_connection_fixture_connectionZ	is_activeÚrollbackÚclose)r   r)   r*   Útransr   r   r   Ú
connectionH   s    zTestBase.connectionc                 #   sj   g ‰ g ‰d‡ ‡fdd„	}|V  ˆD ]}z|  ¡  W q"   Y q"0 q"ˆ D ]}z| ¡  W qF   Y qF0 qFd S )NFc                    s   ˆ   | ¡ |rˆ  | ¡ d S r   )Úappend)ÚresultÚconsume©Úto_closeZ
to_consumer   r   Úgob   s    
z/TestBase.close_result_when_finished.<locals>.go)F)Úallr/   )r   r7   Úrr   r5   r   Úclose_result_when_finished]   s    z#TestBase.close_result_when_finishedc                 c   s   t |d�}|V  | ¡  d S ©N)Úmetadata)r   Údispose)r   r<   Úregr   r   r   r   s   s    
zTestBase.registryc                 C   s   |  ¡ S r   )Zgenerate_base)r   r   r   r   r   Ú	decl_basey   s    zTestBase.decl_basec                 c   s
   |V  d S r   r   )r   Úfuture_enginer1   r   r   r   Úfuture_connection}   s    zTestBase.future_connectionc                 c   sD   t | dd ƒptj}t|ƒ� d V  W d   ƒ n1 s60    Y  d S r%   ©r'   r   r!   Ú_push_future_engine©r   r)   r   r   r   r@   „   s    
zTestBase.future_enginec                 #   s0   ddl m‰  d‡ fdd„	}|V  ˆ j d¡ d S )Nr   ©ÚenginesFc                    s(   |d u ri }d|d< ˆ j | ||||d�S )NÚfixtureÚscope©ÚurlÚoptionsÚfutureÚasyncioZtransfer_staticpool©Útesting_enginerI   rE   r   r   Úgen_testing_engineŽ   s    ûz3TestBase.testing_engine.<locals>.gen_testing_enginerG   )NNNFF)Ú rF   Ztesting_reaperZ_drop_testing_engines)r   rP   r   rE   r   rO   Š   s         ûzTestBase.testing_enginec                    s   ‡ fdd„}|S )Nc                     s   d| d< ˆ f i | ¤ŽS )NTrM   r   )ÚkwrN   r   r   r7   ¦   s    z)TestBase.async_testing_engine.<locals>.gor   )r   rO   r7   r   rN   r   Úasync_testing_engine¤   s    zTestBase.async_testing_enginec                 C   s   t ƒ S r   )Úfixture_session©r   r   r   r   rT   ¬   s    zTestBase.fixture_sessionc                 c   sˆ   ddl m} | ¡ }||j_|V  |j`trxt ¡ rxt ¡ }| ¡  t 	¡ � t
|tƒ W d  ƒ q„1 sl0    Y  nt
|tjƒ dS )z>Provide bound MetaData for a single test, dropping afterwards.r   r   N)Úsqlr   ÚMetaDataÚinstancer<   r-   Zin_transactionZget_transactionr.   r,   r   r   r!   )r   Úrequestr   r<   r0   r   r   r   r<   °   s     ÿþ
ÿ$zTestBase.metadatac                 C   s*   g | ]"}d D ]}dD ]}|||f‘qqqS ))ÚnoneÚexecuter,   ©TFr   )Ú.0r.   Úsecond_operationÚbegin_nestedr   r   r   Ú
<listcomp>É   s   ýzTestBase.<listcomp>r\   )Úparamsc                    s~   |j \‰‰‰ ddlm}m}m}m‰m‰ ddlm‰ |d||d|ƒƒ‰t	| dd ƒpVt
j}ˆ |¡ ‡ ‡‡‡‡‡‡fdd	„}|S )
Nr   )ÚTableÚColumnÚIntegerÚfuncÚselectr   r   ÚtestÚdatar&   c              
      sJ  |   ¡ ��œ}ˆ �rltjjjs&t d¡ |r4|  ¡ }n| ¡ }|�æ |r\|  ˆ ¡ ddi¡ n| ˆ ¡ ddi¡ ˆr~| 	¡  n| 
¡  ˆdk�rt tjjd¡�f ˆdkrÚ|rÄ|  ˆ ¡ ddi¡ qø| ˆ ¡ ddi¡ nˆdkrø|rð|  ¡  n| ¡  W d   ƒ n1 �s0    Y  W d   ƒ n1 �s.0    Y  |�rT|  ˆ ¡ dd	i¡ n| ˆ ¡ dd	i¡ �n,|�rˆ|  ˆ ¡ ddi¡ n| ˆ ¡ ddi¡ |�r¼ˆ�r²|  	¡  n|  
¡  nˆ�rÌ| 	¡  n| 
¡  ˆdk�r˜t tjjd¡�˜ ˆdk�r,|�r|  ˆ ¡ ddi¡ n| ˆ ¡ ddi¡ nLˆdk�rVt|dƒ�rL|  ¡  n|   ¡  n"ˆd
k�rx|�rp|  ¡  n| ¡  W d   ƒ n1 �sŽ0    Y  W d   ƒ n1 �s®0    Y  d}ˆ �rÊ|d7 }ˆ�sØ|d7 }|�rþˆ|  ˆˆ ¡ ƒ ˆ¡¡|ƒ nH|  ¡ �.}ˆ| ˆˆ ¡ ƒ ˆ¡¡|ƒ W d   ƒ n1 �s<0    Y  d S )Nzsavepoints not enabledrh   é
   rZ   z‚Can't operate on closed transaction inside context manager.  Please complete the context manager before emitting further commands.r[   é   r,   é   r_   r   r   )r,   r   ÚrequirementsÚ
savepointsÚenabledZ	skip_testr_   r[   Úinsertr.   Úcommitr   Zexpect_raises_messageÚsaÚexcZInvalidRequestErrorÚhasattrZscalarÚcountÚselect_fromr(   )ÚsubjectZtrans_on_subjectZexecute_on_subjectr0   Znested_transZexpected_committedr*   ©r_   r   re   r.   r^   rf   Útr   r   Úrun_testÞ   s”    




þÿ
H



þ





Hþ
þz4TestBase.trans_ctx_manager_fixture.<locals>.run_test)ÚparamÚ
sqlalchemyrb   rc   rd   re   rf   rQ   r   r'   r   r!   Úcreate)r   rY   r<   rb   rc   rd   r)   ry   r   rw   r   Útrans_ctx_manager_fixtureÈ   s    
xz"TestBase.trans_ctx_manager_fixture)N)Ú__name__Ú
__module__Ú__qualname__Ú__requires__Z__unsupported_on__Z__only_on__Z__skip_if__Z"__leave_connections_for_teardown__r   r   rG   r$   r+   r1   r:   r   r?   rA   r@   rO   rS   rT   r<   r}   r   r   r   r   r   "   sH   












þÿr   c                 c   sF   ddl m} ddlm} | | ¡}tj ||¡ |V  tj |¡ d S )Nr   )ÚEnginer   ©Útesting)	Zfuture.enginer‚   r{   r„   Z_future_facader   Ú_currentZpush_engineÚpop)Zenginer‚   r„   Zfacader   r   r   rC   \  s    
rC   c                   @   s"   e Zd Zejddd�dd„ ƒZdS )ÚFutureEngineMixinTÚclass©ZautouserH   c                 c   sD   t | dd ƒptj}t|ƒ� d V  W d   ƒ n1 s60    Y  d S r%   rB   rD   r   r   r   rC   k  s    
z%FutureEngineMixin._push_future_engineN)r~   r   r€   r   rG   rC   r   r   r   r   r‡   j  s   r‡   c                   @   s  e Zd ZdZdZdZdZdZdZdZ	dZ
dZdZdZejddd�dd„ ƒZejdd	d�d
d„ ƒZedd„ ƒZedd„ ƒZedd„ ƒZedd„ ƒZdd„ Zdd„ Zdd„ Zedd„ ƒZedd„ ƒZedd„ ƒZed d!„ ƒZed"d#„ ƒZed$d%„ ƒZ d&d'„ Z!d(d)„ Z"ed*d+„ ƒZ#dS ),Ú
TablesTestÚonceÚeachNTrˆ   r‰   c                 c   s0   | j }| ¡  | ¡  | ¡  d V  | ¡  d S r   )Ú	__class__Ú_init_classÚ_setup_once_tablesÚ_setup_once_insertsÚ_teardown_once_metadata_bind©r   Úclsr   r   r   Ú_setup_tables_test_classŒ  s    z#TablesTest._setup_tables_test_classÚfunctionc                 c   s"   |   ¡  |  ¡  d V  |  ¡  d S r   )Ú_setup_each_tablesÚ_setup_each_insertsÚ_teardown_each_tablesrU   r   r   r   Ú_setup_tables_test_instance™  s    z&TablesTest._setup_tables_test_instancec                 C   s   | j S r   )Ú_tables_metadatarU   r   r   r   Útables_test_metadata¢  s    zTablesTest.tables_test_metadatac                 C   sX   | j dkr(| jdkrd| _| jdv s(J ‚tƒ | _tƒ | _tƒ | _|  ¡ | _t	 
¡ | _d S )NrŒ   r‹   )rŒ   N)Úrun_define_tablesÚrun_create_tablesÚrun_insertsr   ÚotherÚtablesÚ	sequencesÚ
setup_bindr&   rq   rW   rš   ©r“   r   r   r   rŽ   ¦  s    


zTablesTest._init_classc                 C   sJ   | j dkrF|  ¡  | j ¡ �}|  |¡ W d   ƒ n1 s<0    Y  d S ©Nr‹   ©rž   Ú_load_fixturesr&   r,   Úinsert_data)r“   r*   r   r   r   r�   ´  s    
zTablesTest._setup_once_insertsc                 C   sR   | j dkrN|  | j¡ | jdkr.| j | j¡ | j | jj¡ | j | jj	¡ d S r¤   ©
rœ   Údefine_tablesrš   r�   Ú
create_allr&   r    Úupdater¡   Z
_sequencesr£   r   r   r   r�   »  s    

zTablesTest._setup_once_tablesc                 C   sl   | j dkrP|  | j¡ | jdkr.| j | j¡ | j | jj¡ | j | jj	¡ n| jdkrh| j | j¡ d S ©NrŒ   r¨   rU   r   r   r   r–   Ä  s    


zTablesTest._setup_each_tablesc                 C   sJ   | j dkrF|  ¡  | j ¡ �}|  |¡ W d   ƒ n1 s<0    Y  d S r¬   r¥   )r   r*   r   r   r   r—   Î  s    
zTablesTest._setup_each_insertsc                 C   sr  | j dkr8| j ¡  | jdkr,t| j| jƒ | j ¡  n| jdkrPt| j| jƒ ttj	ddƒ}|rh|j
}| j dk�rn| jdk�rn| jdk�rn| j ¡ �Æ}tdd„ t| jj ¡ ƒD ƒƒD ]–}zN|rø| ¡ � | | ¡ ¡ W d   ƒ n1 sì0    Y  n| | ¡ ¡ W q¶ tjj�yJ } z$tjd||f tjd� W Y d }~q¶d }~0 0 q¶W d   ƒ n1 �sd0    Y  d S )NrŒ   rm   Fc                 S   s   g | ]\}}|d ur|‘qS r   r   )r]   rx   Úfksr   r   r   r`   é  s   üz4TablesTest._teardown_each_tables.<locals>.<listcomp>zError emptying table %s: %r)Úfile)rœ   r    Úclearr�   r   rš   r&   r'   r   rl   rn   Úrun_deletesr,   Úreversedr   Úvaluesr_   r[   Údeleterq   rr   Z
DBAPIErrorr   Úprint_ÚsysÚstderr)r   rm   r*   ÚtableÚexr   r   r   r˜   Ô  sD    



ÿþý
ÿþÿ	
.
þz TablesTest._teardown_each_tablesc                 C   sF   | j rt| j| jƒ | jdkr*|  | j¡ d | j_| jd urBd | _d S r¤   )r�   r   rš   r&   Úrun_dispose_bindÚdispose_bindÚrun_setup_bindr£   r   r   r   r‘   ý  s    

z'TablesTest._teardown_once_metadata_bindc                 C   s   t jS r   )r   r!   r£   r   r   r   r¢   
  s    zTablesTest.setup_bindc                 C   s*   t |dƒr| ¡  nt |dƒr&| ¡  d S )Nr=   r/   )rs   r=   r/   )r“   r&   r   r   r   rº     s    


zTablesTest.dispose_bindc                 C   s   d S r   r   )r“   r<   r   r   r   r©     s    zTablesTest.define_tablesc                 C   s   i S r   r   r£   r   r   r   Úfixtures  s    zTablesTest.fixturesc                 C   s   d S r   r   )r“   r1   r   r   r   r§     s    zTablesTest.insert_datac                 C   s   |   | j||¡ d S r   )Zassert_sql_countr&   )r   rt   Úfnr   r   r   Ú
sql_count_!  s    zTablesTest.sql_count_c                 C   s   |   | j||¡ d S r   )Z
assert_sqlr&   )r   Z	callable_Z
statementsr   r   r   Úsql_eq_$  s    zTablesTest.sql_eq_c              	      sà   i i  ‰ }|   ¡  ¡ D ]H\‰}t|ƒdk r,qtˆtjƒrB| jˆ ‰|d ˆ ˆ< |dd… |ˆ< qt| jj 	¡ ƒD ]j\‰}ˆdu r‚qpˆˆ vrŒqp| j
 ¡ �4}| ˆ ¡ ‡ ‡fdd„|ˆ D ƒ¡ W d  ƒ qp1 sÐ0    Y  qpdS )z4Insert rows as represented by the fixtures() method.r   r   r   Nc                    s   g | ]}t tˆ ˆ |ƒƒ‘qS r   )ÚdictÚzip)r]   Zcolumn_values©Úheadersr·   r   r   r`   <  s   ÿz-TablesTest._load_fixtures.<locals>.<listcomp>)r¼   ÚitemsÚlenÚ
isinstancer   Ústring_typesr    r   rš   r²   r&   r,   r[   ro   )r“   Úrowsrh   r­   r*   r   rÂ   r   r¦   '  s,    


ÿþþzTablesTest._load_fixtures)$r~   r   r€   r»   rœ   r�   rž   r°   r¹   r&   rš   r    rŸ   r¡   r   rG   r”   r™   Úpropertyr›   ÚclassmethodrŽ   r�   r�   r–   r—   r˜   r‘   r¢   rº   r©   r¼   r§   r¾   r¿   r¦   r   r   r   r   rŠ   r  sT   






)





rŠ   c                   @   s"   e Zd Zejddd�dd„ ƒZdS )ÚNoCacheTr•   r‰   c                 c   s"   t jj}d t j_d V  |t j_d S r   r    r"   r   r   r   Ú_disable_cacheD  s    zNoCache._disable_cacheN)r~   r   r€   r   rG   rÌ   r   r   r   r   rË   C  s   rË   c                   @   s8   e Zd Zejdd„ ƒZdd„ Zejddd�dd	„ ƒZ	d
S )ÚRemovesEventsc                 C   s   t ƒ S r   )ÚsetrU   r   r   r   Ú
_event_fnsM  s    zRemovesEvents._event_fnsc                 K   s,   | j  |||f¡ tj|||fi |¤Ž d S r   )rÏ   Úaddr   Úlisten)r   ÚtargetÚnamer½   rR   r   r   r   Úevent_listenQ  s    zRemovesEvents.event_listenTr•   r‰   c                 c   s    d V  | j D ]}tj|Ž  qd S r   )rÏ   r   Úremove)r   Úkeyr   r   r   Ú_remove_eventsU  s    
zRemovesEvents._remove_eventsN)
r~   r   r€   r   Zmemoized_propertyrÏ   rÔ   r   rG   r×   r   r   r   r   rÍ   L  s
   
rÍ   c                  K   sH   |   dd¡ |   dd¡ |  dtj¡}tjj|fi | ¤Ž}t |¡ |S )NZ	autoflushTZexpire_on_commitr&   )	Ú
setdefaultr†   r   r!   rq   ÚormÚSessionÚ_fixture_sessionsrÐ   )rR   r&   Úsessr   r   r   rT   _  s    
rT   c                   C   s   t jj ¡  t ¡  d S r   )rq   rÙ   ÚsessionÚclose_all_sessionsrÛ   r¯   r   r   r   r   Ú_close_all_sessionsj  s    rß   c                 C   s   t ƒ  tj ¡  d S r   )rß   rq   rÙ   Úclear_mappersr£   r   r   r   Ústop_test_class_inside_fixturesp  s    rá   c                   C   s   t r
tƒ  d S r   )rÛ   rß   r   r   r   r   Ú
after_testu  s    râ   c                   @   s   e Zd ZdS )ÚORMTestN©r~   r   r€   r   r   r   r   rã   z  s   rã   c                   @   s¸   e Zd ZdZdZdZejddd�dd„ ƒZejdd	d�d
d„ ƒZ	e
dd„ ƒZe
dd„ ƒZe
dd„ ƒZdd„ Zdd„ Ze
dd„ ƒZe
dd„ ƒZdd„ Zdd„ Ze
dd„ ƒZe
d d!„ ƒZdS )"Ú
MappedTestr‹   rŒ   NTrˆ   r‰   c                 c   sZ   | j }| ¡  |jd u r tƒ |_| ¡  | ¡  | ¡  | ¡  d V  | ¡  | 	¡  d S r   )
r�   rŽ   Úclassesr   r�   Ú_setup_once_classesÚ_setup_once_mappersr�   Ú_teardown_once_classr‘   r’   r   r   r   r”   ‡  s    
z#MappedTest._setup_tables_test_classr•   c                 c   sN   |   ¡  |  ¡  |  ¡  |  ¡  d V  tjj ¡  |  ¡  |  	¡  |  
¡  d S r   )r–   Ú_setup_each_classesÚ_setup_each_mappersr—   rq   rÙ   rÝ   rÞ   Ú_teardown_each_mappersÚ_teardown_each_classesr˜   rU   r   r   r   r™   ™  s    z&MappedTest._setup_tables_test_instancec                 C   s   | j  ¡  d S r   )ræ   r¯   r£   r   r   r   ré   §  s    zMappedTest._teardown_once_classc                 C   s   | j dkr|  | j¡ d S r¤   ©Úrun_setup_classesÚ_with_register_classesÚsetup_classesr£   r   r   r   rç   «  s    
zMappedTest._setup_once_classesc                 C   s*   | j dkr&|  ¡ \| _| _|  | j¡ d S r¤   )Úrun_setup_mappersÚ_generate_registryÚmapper_registryÚmapperrð   Úsetup_mappersr£   r   r   r   rè   °  s    
zMappedTest._setup_once_mappersc                 C   s8   | j dkr|  ¡ \| j_| j_| j dkr4|  | j¡ d S )Nr‹   rŒ   )rò   ró   r�   rô   rõ   rð   rö   rU   r   r   r   rë   ¶  s    
ý
zMappedTest._setup_each_mappersc                 C   s   | j dkr|  | j¡ d S r¬   rî   rU   r   r   r   rê   À  s    
zMappedTest._setup_each_classesc                 C   s   t | jd�}||jfS r;   )r   rš   Zmap_imperatively)r“   Údeclr   r   r   ró   Ä  s    zMappedTest._generate_registryc                    sx   | j ‰ ˆ dusJ ‚G ‡ fdd„dtƒ}G dd„ dt |t¡ƒ}G dd„ dt|ƒ}G dd	„ d	t|ƒ}|| _|| _|ƒ  dS )
z¥Run a setup method, framing the operation with a Base class
        that will catch new subclasses to be established within
        the "classes" registry.

        Nc                       s   e Zd Z‡ fdd„ZdS )z6MappedTest._with_register_classes.<locals>.FindFixturec                    s   | ˆ |< t  | |||¡ d S r   )ÚtypeÚ__init__©r“   Ú	classnameÚbasesZdict_©Zcls_registryr   r   rù   Õ  s    z?MappedTest._with_register_classes.<locals>.FindFixture.__init__N©r~   r   r€   rù   r   rý   r   r   ÚFindFixtureÔ  s   rÿ   c                   @   s   e Zd ZdS )z0MappedTest._with_register_classes.<locals>._BaseNrä   r   r   r   r   Ú_BaseÙ  s   r   c                   @   s   e Zd ZdS )z0MappedTest._with_register_classes.<locals>.BasicNrä   r   r   r   r   ÚBasicÜ  s   r  c                   @   s   e Zd ZdS )z5MappedTest._with_register_classes.<locals>.ComparableNrä   r   r   r   r   Ú
Comparableß  s   r  )	ræ   rø   r   Úwith_metaclassÚobjectr
   r   r  r  )r“   r½   rÿ   r   r  r  r   rý   r   rð   É  s    z!MappedTest._with_register_classesc                 C   s   | j dkrtj ¡  d S r¤   )rò   rq   rÙ   rà   rU   r   r   r   rì   æ  s    
z!MappedTest._teardown_each_mappersc                 C   s   | j dkr| j ¡  d S r¤   )rï   ræ   r¯   rU   r   r   r   rí   í  s    
z!MappedTest._teardown_each_classesc                 C   s   d S r   r   r£   r   r   r   rñ   ñ  s    zMappedTest.setup_classesc                 C   s   d S r   r   r£   r   r   r   rö   õ  s    zMappedTest.setup_mappers)r~   r   r€   rï   rò   ræ   r   rG   r”   r™   rÊ   ré   rç   rè   rë   rê   ró   rð   rì   rí   rñ   rö   r   r   r   r   rå   ~  s2   








rå   c                       s4   e Zd ZdZdZedd„ ƒZe‡ fdd„ƒZ‡  ZS )ÚDeclarativeMappedTestr‹   c                 C   s   d S r   r   r£   r   r   r   r�   þ  s    z(DeclarativeMappedTest._setup_once_tablesc                    sp   | j ‰ G ‡ fdd„dtƒ}G dd„ dtƒ}t| j||d�}|| _tt| ƒ |¡ | jj	rl| j
rl| j tj¡ d S )Nc                       s   e Zd Z‡ fdd„ZdS )zLDeclarativeMappedTest._with_register_classes.<locals>.FindFixtureDeclarativec                    s   | ˆ |< t  | |||¡ d S r   )r   rù   rú   rý   r   r   rù     s    zUDeclarativeMappedTest._with_register_classes.<locals>.FindFixtureDeclarative.__init__Nrþ   r   rý   r   r   ÚFindFixtureDeclarative  s   r  c                   @   s   e Zd ZejZdS )zFDeclarativeMappedTest._with_register_classes.<locals>.DeclarativeBasicN)r~   r   r€   r   rb   Z__table_cls__r   r   r   r   ÚDeclarativeBasic  s   r  )r<   Ú	metaclassr“   )ræ   r   r  r   rš   r  Úsuperr  rð   r    r�   rª   r   r!   )r“   r½   r  r  Z	_DeclBase©r�   rý   r   rð     s    ýz,DeclarativeMappedTest._with_register_classes)	r~   r   r€   rï   rò   rÊ   r�   rð   Ú__classcell__r   r   r
  r   r  ú  s   
r  c                   @   s:   e Zd Zd ZZdZdZe d¡Z	dd„ Z
edd„ ƒZdS )	ÚComputedReflectionFixtureTestNT)Zcomputed_columnsZtable_reflectionz[\[\]\(\)\s`'\"]*c                 C   s   | j  d|¡ ¡ S )NrQ   )ÚregexpÚsubÚlower)r   Útextr   r   r   Ú	normalize&  s    z'ComputedReflectionFixtureTest.normalizec           	      C   sx  ddl m} ddl m} ddlm} ddlm} ddlm} |d||d|d	d
�|d|ƒ|d||dƒƒ|d|dd�ƒ |d||d|d	d
�|d|ƒ|d||dƒƒƒ}|jjj	rÜ|d||d|d	d
�|d|ƒ|d||dƒƒt
jd�}|jjj	�r(| |d||ddd�ƒ¡ |jjj	�r(| |d||ddd�ƒ¡ |jjj	�rt| |d||dd	d�ƒ¡ |jjj	�rt| |d||dd	d�ƒ¡ d S )Nr   )rd   rƒ   )rc   )ÚComputed)rb   Zcomputed_default_tableÚidT)Zprimary_keyÚnormalZcomputed_colznormal + 42Zwith_defaultZ42)Zserver_defaultZcomputed_column_tableZcomputed_no_flagznormal / 42r   Zcomputed_virtualz
normal + 2F)Z	persistedz
normal / 2Zcomputed_storedznormal - 42znormal * 42)rQ   rd   r„   r   rc   r  rb   ÚrequiresZschemasrn   r   Ztest_schemaZcomputed_columns_virtualZappend_columnZcomputed_columns_stored)	r“   r<   rd   r„   rc   r  rb   rx   Út2r   r   r   r©   )  sz    ú	û
ú	
ýÿ
ýÿ
ýÿ
ýÿz+ComputedReflectionFixtureTest.define_tables)r~   r   r€   rž   r°   Z__backend__r�   ÚreÚcompiler  r  rÊ   r©   r   r   r   r   r    s   
r  c                   @   s$   e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚCacheKeyFixturec                 C   sŒ   |  ¡ }|  ¡ }|d u r6|j d¡s(J ‚|d u s„J ‚nNt|j|jƒ tt|jƒt|jƒƒ t|j|jƒD ]\}}|j||d�shJ ‚qh||fS )Nr$   ©Úcompare_values)	Ú_generate_cache_keyÚ_annotationsÚgetr   rÖ   ÚhashrÁ   Ú
bindparamsÚcompare)r   ÚaÚbr  Úa_keyÚb_keyÚa_paramÚb_paramr   r   r   Ú_compare_equalo  s    zCacheKeyFixture._compare_equalc                 C   sè  |ƒ }|ƒ }t  tt|ƒƒd¡D �]À\}}||krX|  || || |¡\}}|d u rVq nº||  ¡ }||  ¡ }|d u s€|d u rº|d u rœ|| j d¡sœJ ‚|d u r || j d¡s J ‚q |j|jk�rt	|j
|j
ƒD ]\}	}
|	j|
|d�sÖ �qqÖt|j|jƒ nt|j|jƒ t|| tƒr t|| tƒr g }g }t || ¡D ]}|jdk�rD| |¡ �qDt || ¡D ]}|jdk�rp| |¡ �qptt|j
dd„ d�tt |¡dd„ d�ƒ tt|j
d	d„ d�tt |¡d
d„ d�ƒ q d S )Nr   r$   r  Z	bindparamc                 S   s   | j S r   ©rÖ   ©r#  r   r   r   Ú<lambda>¿  ó    z8CacheKeyFixture._run_cache_key_fixture.<locals>.<lambda>r)  c                 S   s   | j S r   r)  r*  r   r   r   r+  Á  r,  c                 S   s   | j S r   r)  r*  r   r   r   r+  Å  r,  c                 S   s   | j S r   r)  r*  r   r   r   r+  Ç  r,  )Ú	itertoolsÚcombinations_with_replacementÚrangerÅ   r(  r  r  r  rÖ   rÁ   r   r!  r	   rÆ   r   r   ZiterateZ__visit_name__r2   r   Úsortedr   Zunique_list)r   rG   r  Úcase_aÚcase_br"  r#  r$  r%  r&  r'  Zassert_a_paramsZassert_b_paramsÚelemr   r   r   Ú_run_cache_key_fixture€  sh    ÿÿÿÿÿÿþÿþz&CacheKeyFixture._run_cache_key_fixturec                 C   sD   |ƒ }|ƒ }t  tt|ƒƒd¡D ]\}}|  || || |¡ q d S )Nr   )r-  r.  r/  rÅ   r(  )r   rG   r  r1  r2  r"  r#  r   r   r   Ú_run_cache_key_equal_fixtureË  s    ÿz,CacheKeyFixture._run_cache_key_equal_fixtureN)r~   r   r€   r(  r4  r5  r   r   r   r   r  n  s   Kr  )4Ú
contextlibr-  r  rµ   r{   rq   rQ   r   r   r   r   r	   Úentitiesr
   r   r   r   r   r   r   rÙ   r   r   Zorm.decl_apir   r   rV   r   Zsql.elementsr   Zmark_base_test_classr  r   r-   ÚcontextmanagerrC   r‡   rŠ   rË   rÍ   rÎ   rÛ   rT   rß   rá   râ   rã   ZAssertsExecutionResultsrå   r  r  r  r   r   r   r   Ú<module>   sX     8
 R	|$P