a
    •˜ëjä:  ã                   @  s   d dl m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 G dd„ deƒZG dd„ dƒZG dd„ dƒZG dd„ deƒZG dd„ dƒZd dd„ZdS )!é    )ÚannotationsNé   )ÚTestBaseé   )Úconfig)Úmock)Ú	provision)Úeq_)Úne_)Úadict)Údrop_all_tables_from_metadataé   )Úevent)Úutil)Úsort_tables_and_constraints)Úvisitors)ÚClauseElementc                   @  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�ej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ÚeachNTÚclass©ZautouseZscopec                 c  s*   |   ¡  |  ¡  |  ¡  d V  |  ¡  d S ©N)Ú_init_classÚ_setup_once_tablesÚ_setup_once_insertsÚ_teardown_once_metadata_bind©Úcls© r   ú^/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/fixtures/sql.pyÚ_setup_tables_test_class7   s
    z#TablesTest._setup_tables_test_classÚfunctionc                 c  s"   |   ¡  |  ¡  d V  |  ¡  d S r   )Ú_setup_each_tablesÚ_setup_each_insertsÚ_teardown_each_tables©Úselfr   r   r    Ú_setup_tables_test_instanceD   s    z&TablesTest._setup_tables_test_instancec                 C  s   | j S r   )Ú_tables_metadatar&   r   r   r    Útables_test_metadataM   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_bindÚbindÚsaZMetaDatar)   r   r   r   r    r   Q   s    


zTablesTest._init_classc                 C  sJ   | j dkrF|  ¡  | j ¡ �}|  |¡ W d   ƒ n1 s<0    Y  d S ©Nr   ©r-   Ú_load_fixturesr2   ÚbeginÚinsert_data)r   Úconnr   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 r4   ©
r+   Údefine_tablesr)   r,   Z
create_allr2   r/   Úupdater0   Z
_sequencesr   r   r   r    r   f   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:   r&   r   r   r    r#   o   s    


zTablesTest._setup_each_tablesc                 C  sJ   | j dkrF|  ¡  | j ¡ �}|  |¡ W d   ƒ n1 s<0    Y  d S r=   r5   ©r'   r9   r   r   r    r$   y   s    
zTablesTest._setup_each_insertsc                 C  s¬   | j dkr8| j ¡  | jdkr,t| j| jƒ | j ¡  n| jdkrPt| j| jƒ | j dkr¨| jdkr¨| jdkr¨| j ¡ � }t	 
|t| j¡ W d   ƒ n1 sž0    Y  d S )Nr   r   )r+   r/   Úclearr,   r   r)   r2   Úrun_deletesr7   r   Zdelete_from_all_tablesr   r>   r   r   r    r%      s"    



ÿþýÿ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 r4   )r,   r   r)   r2   Ú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   Údbr   r   r   r    r1       s    zTablesTest.setup_bindc                 C  s*   t |dƒr| ¡  nt |dƒr&| ¡  d S )NÚdisposeÚclose)ÚhasattrrE   rF   )r   r2   r   r   r    rB   ¤   s    


zTablesTest.dispose_bindc                 C  s   d S r   r   )r   Úmetadatar   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   Ú
connectionr   r   r    r8   ³   s    zTablesTest.insert_datac                 C  s   |   | j||¡ d S r   )Zassert_sql_countr2   )r'   ÚcountÚfnr   r   r    Ú
sql_count_·   s    zTablesTest.sql_count_c                 C  s   |   | j||¡ d S r   )Z
assert_sqlr2   )r'   Z	callable_Z
statementsr   r   r    Úsql_eq_º   s    zTablesTest.sql_eq_c              	     sÞ   i i  ‰ }|   ¡  ¡ D ]F\‰}t|ƒdk r,qtˆtƒr@| jˆ ‰|d ˆ ˆ< |dd… |ˆ< qt| jj ¡ ƒD ]j\‰}ˆdu r€qnˆˆ vrŠqn| j	 
¡ �4}| ˆ ¡ ‡ ‡fdd„|ˆ D ƒ¡ W d  ƒ qn1 sÎ0    Y  qndS )z4Insert rows as represented by the fixtures() method.r   r   r   Nc                   s   g | ]}t tˆ ˆ |ƒƒ‘qS r   )ÚdictÚzip)Ú.0Zcolumn_values©ÚheadersÚtabler   r    Ú
<listcomp>Ò   s   ÿz-TablesTest._load_fixtures.<locals>.<listcomp>)rI   ÚitemsÚlenÚ
isinstanceÚstrr/   r   r)   Úvaluesr2   r7   ÚexecuteÚinsert)r   ÚrowsÚdataZfksr9   r   rR   r    r6   ½   s,    



ÿþþzTablesTest._load_fixtures)%Ú__name__Ú
__module__Ú__qualname__rC   r+   r,   r-   r@   rA   r2   r)   r/   r.   r0   r   ÚfixtureZfixture_classmethodr!   r(   Úpropertyr*   Úclassmethodr   r   r   r#   r$   r%   r   r1   rB   r;   rI   r8   rM   rN   r6   r   r   r   r    r      sV   











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   rD   Z_compiled_cache)r'   Ú_cacher   r   r    Ú_disable_cacheÚ   s    zNoCache._disable_cacheN)r_   r`   ra   r   rb   rg   r   r   r   r    re   Ù   s   re   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   )Úsetr&   r   r   r    Ú
_event_fnsã   s    zRemovesEvents._event_fnsc                 K  s,   | j  |||f¡ tj|||fi |¤Ž d S r   )rj   Úaddr   Úlisten)r'   ÚtargetÚnamerL   Úkwr   r   r    Úevent_listenç   s    zRemovesEvents.event_listenTr"   r   c                 c  s    d V  | j D ]}tj|Ž  qd S r   )rj   r   Úremove)r'   Úkeyr   r   r    Ú_remove_eventsë   s    
zRemovesEvents._remove_eventsN)
r_   r`   ra   r   Zmemoized_propertyrj   rp   r   rb   rs   r   r   r   r    rh   â   s
   
rh   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 )NÚ )Ú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   )ÚInteger)Útesting)ÚColumn)ÚComputed)ÚTableZ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 / 42)ÚschemaZcomputed_virtualz
normal + 2F)Z	persistedz
normal / 2Zcomputed_storedznormal - 42znormal * 42)ru   r{   r|   r‚   r}   r~   r   ÚrequiresZschemasZenabledr   Ztest_schemaZcomputed_columns_virtualZappend_columnZcomputed_columns_stored)	r   rH   r{   r|   r}   r~   r   ÚtÚt2r   r   r    r;   ý   sz    ú	û
ú	
ýÿ
ýÿ
ýÿ
ýÿz+ComputedReflectionFixtureTest.define_tables)r_   r`   ra   r-   r@   Z__backend__Ú__requires__ÚreÚcompilerv   rz   rd   r;   r   r   r   r    rt   ò   s   
rt   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 )NÚnocache©Úcompare_values)	Ú_generate_cache_keyÚ_annotationsÚgetr	   rr   ÚhashrP   Ú
bindparamsÚcompare)r'   ÚaÚbrŒ   Úa_keyÚb_keyÚa_paramÚb_paramr   r   r    Ú_compare_equalC  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   ©rr   ©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ÚrangerW   r™   r�   rŽ   r�   rr   rP   r‘   r’   r
   rX   r   r   ZiterateZ__visit_name__Úappendr	   Úsortedr   Zunique_list)r'   rb   rŒ   Úcase_aÚcase_br“   r”   r•   r–   r—   r˜   Zassert_a_paramsZassert_b_paramsÚelemr   r   r    Ú_run_cache_key_fixtureS  sh    ÿÿÿÿÿÿþÿþz&CacheKeyFixture._run_cache_key_fixturec                 C  sD   |ƒ }|ƒ }t  tt|ƒƒd¡D ]\}}|  || || |¡ q d S )Nr   )rž   rŸ   r    rW   r™   )r'   rb   rŒ   r£   r¤   r“   r”   r   r   r    Ú_run_cache_key_equal_fixturež  s    ÿz,CacheKeyFixture._run_cache_key_equal_fixtureN)r_   r`   ra   r™   r¦   r§   r   r   r   r    r‰   B  s   Kr‰   Fc                   sJ   | j }|j‰| j‰G dd„ dƒ‰ ‡ ‡‡‡fdd„‰‡‡fdd„}|| _d S )Nc                   @  s,   e Zd ZdZdd„ Zedd„ ƒZdd„ ZdS )	z.insertmanyvalues_fixture.<locals>.RandomCursor©Úcursorc                 S  s
   || _ d S r   r¨   )r'   r©   r   r   r    Ú__init__²  s    z7insertmanyvalues_fixture.<locals>.RandomCursor.__init__c                 S  s   | j jS r   )r©   Údescriptionr&   r   r   r    r«   ¹  s    z:insertmanyvalues_fixture.<locals>.RandomCursor.descriptionc                 S  s    | j  ¡ }t|ƒ}t |¡ |S r   )r©   ÚfetchallÚlistÚrandomÚshuffle)r'   r]   r   r   r    r¬   ½  s    

z7insertmanyvalues_fixture.<locals>.RandomCursor.fetchallN)r_   r`   ra   Ú	__slots__rª   rc   r«   r¬   r   r   r   r    ÚRandomCursor¯  s
   
r±   c                 3  sB   ˆrˆ |ƒ}ˆ| |||||ƒD ]}ˆr6|j r6t d¡ |V  qd S )Nz)Batches were downgraded for sorted INSERT)Zis_downgradedr   Úwarn)rJ   r©   Z	statementÚ
parametersZgeneric_setinputsizesÚcontextÚbatch)r±   Úorig_dialectÚrandomize_rowsÚwarn_on_downgradedr   r    Ú!_deliver_insertmanyvalues_batchesÃ  s    ú

zCinsertmanyvalues_fixture.<locals>._deliver_insertmanyvalues_batchesc                   s@   t jj| dˆ d�� ˆ| |ƒW  d   ƒ S 1 s20    Y  d S )Nr¹   )Únew)r   ÚpatchÚobject)Údialectr´   )r¹   Ú	orig_connr   r    Ú_exec_insertmany_contextÚ  s    ýz:insertmanyvalues_fixture.<locals>._exec_insertmany_context)r½   r¹   r¿   )rJ   r·   r¸   r½   r¿   r   )r±   r¹   r¾   r¶   r·   r¸   r    Úinsertmanyvalues_fixture¨  s    rÀ   )FF) Ú
__future__r   rž   r®   r‡   Z
sqlalchemyr3   Úbaser   ru   r   r   r   Z
assertionsr	   r
   r   r   r   r   r‚   r   Zsqlr   Zsql.elementsr   r   re   rh   rt   r‰   rÀ   r   r   r   r    Ú<module>   s2    <	Pg ÿ