a
    xˆclï  ã                   @   s"  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 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\Z$Z%G dd „ d e	j&ƒZ'G d!d"„ d"e'ƒZ(G d#d$„ d$e	j&ƒZ)G d%d&„ d&e	j&ƒZ*G d'd(„ d(e'ƒZ+G d)d*„ d*e	j,ƒZ-G d+d,„ d,e	j,ƒZ.G d-d.„ d.e	j&ƒZ/G d/d0„ d0e	j0ƒZ1G d1d2„ d2e	j&ƒZ2G d3d4„ d4e	j&ƒZ3d5Z4dS )6é    Né   )Úconfig)Úengines)Úeq_)Úexpect_warnings)Úfixtures)Úis_)Úget_temp_table_name)Útemp_table_keyword_args©ÚColumn)ÚTableé   )Úevent)Ú
ForeignKey)Úfunc)ÚIdentity)Úinspect)ÚInteger)ÚMetaData)ÚString)Útesting)Útypes)ÚDDL)ÚIndex)Úquoted_name)ÚBLANK_SCHEMA)Úis_false)Úis_true)NNc                   @   s   e Zd Zedd„ ƒZdS )ÚOneConnectionTablesTestc                 C   s6   t jjjr,ddlm} tjt|j	dd�d�S t j
S d S )Nr   )ÚpoolÚclass)Z	poolclassZscope)Úoptions)r   ÚrequirementsZindependent_connectionsÚenabledÚ
sqlalchemyr    r   Útesting_engineÚdictZ
StaticPoolÚdb)Úclsr    © r*   úk/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_reflection.pyÚ
setup_bind%   s    
ÿz"OneConnectionTablesTest.setup_bindN)Ú__name__Ú
__module__Ú__qualname__Úclassmethodr,   r*   r*   r*   r+   r   $   s   r   c                   @   sÈ   e Zd ZdZedd„ ƒZedd„ ƒZedd„ ƒZedd	„ ƒZd
d„ Z	e
jjdd„ ƒZe
 dd¡e
jjdd„ ƒƒZe
jjdd„ ƒZe
jje
jje
jjdd„ ƒƒƒZe
 dd¡e
jje
jjdd„ ƒƒƒZdS )ÚHasTableTestTc                 C   s~   t d|tdtdd�tdtdƒƒƒ tjjjrTt d|tdtdd�tdtdƒƒtj	d� tjj
rf|  |¡ tjjjrz|  |¡ d S )	NÚ
test_tableÚidT©Úprimary_keyÚdataé2   Útest_table_s©Úschema)r   r   r   r   r   ÚrequiresÚschemasr$   r   Útest_schemaÚview_reflectionÚdefine_viewsÚhas_temp_tableÚdefine_temp_tables©r)   Úmetadatar*   r*   r+   Údefine_tables7   s$    ü
û

zHasTableTest.define_tablesc                 C   sp   d}t  |dt|ƒ¡ t  |dtdƒ¡ tjjjrldtjtjf }t  |dt|ƒ¡ t  |dtdtj ƒ¡ d S )Nz*CREATE VIEW vv AS SELECT * FROM test_tableÚafter_createÚbefore_dropzDROP VIEW vvz2CREATE VIEW %s.vv AS SELECT * FROM %s.test_table_szDROP VIEW %s.vv)	r   Úlistenr   r   r;   r<   r$   r   r=   )r)   rC   Úqueryr*   r*   r+   r?   M   s    
þýzHasTableTest.define_viewsc                 C   s   t ttjdtjf ƒS ©Núuser_tmp_%s)r	   r   r(   Úident)r)   r*   r*   r+   Útemp_table_name`   s    ÿzHasTableTest.temp_table_namec              	   C   s„   t ttjƒ}|  ¡ }t||tdtjdd�tdt d¡ƒfi |¤Ž}t	j
jjr€t	j
jjr€t |dtdtj ƒ¡ t |dtd	ƒ¡ d S )
Nr3   Tr4   Únamer7   rE   ú=create temporary view user_tmp_v as select * from user_tmp_%srF   údrop view user_tmp_v)r
   r   r(   rL   r   r   ÚsaÚINTÚVARCHARr   r;   r>   r$   Útemporary_viewsr   rG   r   rK   ©r)   rC   ÚkwÚ
table_nameÚuser_tmpr*   r*   r+   rA   f   s0    üûÿþÿÿýzHasTableTest.define_temp_tablesc                 C   sj   t j ¡ �L}tt jj |d¡ƒ tt jj |d¡ƒ tt jj |d¡ƒ W d   ƒ n1 s\0    Y  d S )Nr2   r8   Únonexistent_table)r   r(   Úbeginr   ÚdialectÚ	has_tabler   ©ÚselfÚconnr*   r*   r+   Útest_has_table   s    zHasTableTest.test_has_tablec                 C   s|   t j ¡ �^}tt jjj|dt jd�ƒ tt jjj|dt jd�ƒ tt jjj|dt jd�ƒ W d   ƒ n1 sn0    Y  d S )Nr2   r9   r8   rX   )r   r(   rY   r   rZ   r[   r=   r   r\   r*   r*   r+   Útest_has_table_schema…   s     ÿÿÿÿÿÿz"HasTableTest.test_has_table_schemaÚoraclezJper #8700 this remains at its previous behavior of not working within 1.4.c                 C   s   t |ƒ}t| d¡ƒ d S ©NÚvv©r   r   r[   ©r]   Ú
connectionÚinspr*   r*   r+   Útest_has_table_view˜   s    z HasTableTest.test_has_table_viewc                 C   s"   t |ƒ}|  ¡ }t| |¡ƒ d S ©N)r   rL   r   r[   )r]   rf   rg   rL   r*   r*   r+   Útest_has_table_temp_table¢   s    z&HasTableTest.test_has_table_temp_tablec                 C   s   t |ƒ}t| d¡ƒ d S ©NÚ
user_tmp_vrd   re   r*   r*   r+   Útest_has_table_temp_view¨   s    z%HasTableTest.test_has_table_temp_viewzIper #8700 this remains at its previous behavior of not working within 1.4c                 C   s   t |ƒ}t| dtj¡ƒ d S rb   )r   r   r[   r   r=   re   r*   r*   r+   Útest_has_table_view_schema¯   s    z'HasTableTest.test_has_table_view_schemaN)r-   r.   r/   Ú__backend__r0   rD   r?   rL   rA   r_   r   r;   r<   r`   Zfails_onÚviewsrh   r@   rj   r>   rS   rm   rn   r*   r*   r*   r+   r1   4   s>   




þ
þr1   c                   @   s4   e Zd ZdZedd„ ƒZdd„ Zejj	dd„ ƒZ
dS )	ÚHasIndexTestTc                 C   st   t d|tdtdd�tdtdƒƒƒ}td|jjƒ tjj	j
rpt d|tdtdd�tdtdƒƒtjd�}td	|jjƒ d S )
Nr2   r3   Tr4   r6   r7   Úmy_idxr9   Úmy_idx_s)r   r   r   r   r   Úcr6   r   r;   r<   r$   r   r=   )r)   rC   Úttr*   r*   r+   rD   ¾   s     ü
ûzHasIndexTest.define_tablesc                 C   s†   t j ¡ �h}t jj |dd¡s"J ‚t jj |dd¡r8J ‚t jj |dd¡rNJ ‚t jj |dd¡rdJ ‚W d   ƒ n1 sx0    Y  d S )Nr2   rr   rs   rX   Znonexistent_idx)r   r(   rY   rZ   Ú	has_indexr\   r*   r*   r+   Útest_has_indexÒ   s    ÿÿÿzHasIndexTest.test_has_indexc                 C   sž   t j ¡ �€}t jjj|ddt jd�s(J ‚t jjj|ddt jd�rDJ ‚t jjj|ddt jd�r`J ‚t jjj|ddt jd�r|J ‚W d   ƒ n1 s�0    Y  d S )Nr2   rs   r9   rr   rX   Znonexistent_idx_s)r   r(   rY   rZ   rv   r=   r\   r*   r*   r+   Útest_has_index_schemaß   s&    
ÿ

ÿ
ü
üz"HasIndexTest.test_has_index_schemaN)r-   r.   r/   ro   r0   rD   rw   r   r;   r<   rx   r*   r*   r*   r+   rq   »   s   
rq   c                   @   s´   e Zd ZdZdZedd„ ƒZdd„ Zedd„ ƒZee	j
jd	d
„ ƒƒZedd„ ƒZedd„ ƒZedd„ ƒZedd„ ƒZee	j
jdd„ ƒƒZee	j
jdd„ ƒƒZee	j
jdd„ ƒƒZdS )ÚQuotedNameArgumentTestÚonceTc                 C   s´  t d|tdtƒtdtdƒƒtdtdƒƒtdtƒtjddd�t d	d¡tjdd
d�tjdgdgdd�tj	ddd�ddd� t
jjjrút d|tdtƒtdtdƒƒtdtdƒƒtdtƒtjddd�t dd¡tjddd�tjdgdgdd�tj	ddd�ddd� t d|tdtdd�tdtƒdd� t
jjj�r°t
jjj�r>ddg}ndg}|D ]f}dtjjj d| ¡tjjj |¡f }t |dt|ƒ¡ t |dtd tjjj d| ¡ ƒ¡ �qHd S )!Núquote ' oner3   rM   r7   r6   Z
related_idzpk quote ' one©rM   zix quote ' onezuq quote' onez
related.idzfk quote ' onezname != 'foo'zck quote ' onezquote ' one commentT)ÚcommentÚtest_needs_fkúquote " twozpk quote " twozix quote " twozuq quote" twozfk quote " twozck quote " two zquote " two commentÚrelatedr4   ©r~   ú"CREATE VIEW %s AS SELECT * FROM %súview %srE   rF   úDROP VIEW %s)r   r   r   r   rP   ÚPrimaryKeyConstraintr   ÚUniqueConstraintÚForeignKeyConstraintÚCheckConstraintr   r;   Úsymbol_names_w_double_quoter$   Úview_column_reflectionr   r(   rZ   Zidentifier_preparerÚquoter   rG   r   )r)   rC   ÚnamesrM   rH   r*   r*   r+   rD   ú   s”    
þ
ÿî

þ
ÿîûþÿ
ÿü
ÿÿÿýz$QuotedNameArgumentTest.define_tablesc                 C   s   t  ddt jjf¡| ƒS )N)r{   r   )r   Úcombinationsr;   r‰   )Úfnr*   r*   r+   Úquote_fixturesN  s    
þýz%QuotedNameArgumentTest.quote_fixturesc                 C   s   t tjƒ}| |¡ d S ri   )r   r   r(   Zget_table_options©r]   rM   rg   r*   r*   r+   Útest_get_table_optionsT  s    
z-QuotedNameArgumentTest.test_get_table_optionsc                 C   s    t tjƒ}| d| ¡sJ ‚d S )Nrƒ   )r   r   r(   Úget_view_definitionr�   r*   r*   r+   Útest_get_view_definitionZ  s    
z/QuotedNameArgumentTest.test_get_view_definitionc                 C   s   t tjƒ}| |¡sJ ‚d S ri   )r   r   r(   Úget_columnsr�   r*   r*   r+   Útest_get_columns`  s    
z'QuotedNameArgumentTest.test_get_columnsc                 C   s   t tjƒ}| |¡sJ ‚d S ri   )r   r   r(   Úget_pk_constraintr�   r*   r*   r+   Útest_get_pk_constrainte  s    
z-QuotedNameArgumentTest.test_get_pk_constraintc                 C   s   t tjƒ}| |¡sJ ‚d S ri   )r   r   r(   Úget_foreign_keysr�   r*   r*   r+   Útest_get_foreign_keysj  s    
z,QuotedNameArgumentTest.test_get_foreign_keysc                 C   s   t tjƒ}| |¡sJ ‚d S ri   )r   r   r(   Úget_indexesr�   r*   r*   r+   Útest_get_indexeso  s    
z'QuotedNameArgumentTest.test_get_indexesc                 C   s   t tjƒ}| |¡sJ ‚d S ri   )r   r   r(   Úget_unique_constraintsr�   r*   r*   r+   Útest_get_unique_constraintst  s    
z2QuotedNameArgumentTest.test_get_unique_constraintsc                 C   s   t tjƒ}| |¡sJ ‚d S ri   )r   r   r(   Úget_table_commentr�   r*   r*   r+   Útest_get_table_commentz  s    
z-QuotedNameArgumentTest.test_get_table_commentc                 C   s   t tjƒ}| |¡sJ ‚d S ri   )r   r   r(   Úget_check_constraintsr�   r*   r*   r+   Útest_get_check_constraints€  s    
z1QuotedNameArgumentTest.test_get_check_constraintsN)r-   r.   r/   Zrun_create_tablesro   r0   rD   r�   r‘   r   r;   rŠ   r“   r•   r—   r™   r›   Úunique_constraint_reflectionr�   Úcomment_reflectionrŸ   Úcheck_constraint_reflectionr¡   r*   r*   r*   r+   ry   ö   s6   
S




ry   c                   @   s*  e Zd Zd ZZdZedd„ ƒZedd„ ƒZedd„ ƒZ	ed	d
„ ƒZ
edd„ ƒZejjdd„ ƒZejjdd„ ƒZejjdd„ ƒZejjdd„ ƒZejjejdddddejjfddddddejjfdddddejjfdd�dd„ ƒƒZejjdd„ ƒZejjejjejjd d!„ ƒƒƒZejjd"d#„ ƒZejjejjd$d%„ ƒƒZdRd&d'„Zejd(ddejjfddejjfddejjejj fd)d�d*d+„ ƒZ ejj!d,d-„ ƒZ"ejj!ejj#ejjd.d/„ ƒƒƒZ$ejd0dejjfd1d�ejj%d2d3„ ƒƒZ&ejd0dejjfd1d�ejjd4d5„ ƒƒZ'ejj(ejjd6d7„ ƒƒZ)d8d9„ Z*ejd0dejjfd1d�d:d;„ ƒZ+ejd<d=d>d�ejj,ejj-d?d@„ ƒƒƒZ.ejj!ejj/dAdB„ ƒƒZ0ejj1dCdD„ ƒZ2ejdejjfd0d1d�ejj/dEdF„ ƒƒZ3ejjejd0dejjfd1d�dGdH„ ƒƒZ4ejdIdJdejjfdKd�e 5dLdM¡dNdO„ ƒƒZ6ejj7dPdQ„ ƒZ8dS )SÚComponentReflectionTestNTc                 C   s*   |   |d ¡ tjjjr&|   |tjj¡ d S ri   )Údefine_reflected_tablesr   r;   r<   r$   r   r=   rB   r*   r*   r+   rD   Œ  s    
z%ComponentReflectionTest.define_tablesc                 C   s$  |r|d }nd}t jjjrztd|tdtjdd�tdt d¡d	d
�tdt 	d¡d	d
�tdtj
tjd| dd�ƒ|dd�}nBtd|tdtjdd�tdt d¡d	d
�tdt 	d¡d	d
�|dd�}td|tdtj
dd�tdtj
t d| ¡ƒtdt d¡ƒ|dd� td|tdtj
ƒtdtj
t |jj¡ƒtdt d¡ƒtjddd�|dd� td|tdtj
ddd�tdt d¡d d!�td"t d¡d#d!�|d$d%� t jjj�rX|d u �rêtd&|tdtj
dd�tdt d¡ƒtd'td(t jj ƒƒdtjjjd)� nntd*|tdtj
dd�td+td,tjjj ƒƒtdt d¡ƒ|dd� td-|tdtj
dd�tdt d¡ƒ|dd� t jjj�rì|  ||¡ |�sìtd.|td/t d¡ƒdd0�}td1|tdtj
dd�td/t d¡ƒdd0�}t jjj�rìtd2|jj ¡ ƒ td3|jj ¡ ƒ t jjj�r|  ||¡ |�s t jjj�r |  |¡ d S )4NÚ.Ú ÚusersÚuser_idTr4   Útest1é   F©ÚnullableÚtest2Úparent_user_idz%susers.user_idÚ
user_id_fkr|   ©r:   r~   Ú
dingalingsÚdingaling_idÚ
address_idz%semail_addresses.address_idr6   é   Úemail_addressesÚremote_user_idZemail_addressé   Úemail_ad_pkÚcomment_testr3   ú
id comment)r5   r}   údata % comment)r}   Úd2ú)Comment types type speedily ' " \ '' Fun!úthe test % ' " \ table comment)r:   r}   Úlocal_tableÚ	remote_idz%s.remote_table_2.id)r~   r:   Úremote_tableÚlocal_idz%s.local_table.idÚremote_table_2Únoncol_idx_test_nopkÚqr�   Únoncol_idx_test_pkÚnoncol_idx_nopkÚnoncol_idx_pk) r   r;   Úself_referential_foreign_keysr$   r   r   rP   rQ   ZCHARZFloatr   r   r   rt   rª   r…   Úcross_schema_fk_reflectionr   r=   r(   rZ   Údefault_schema_nameÚindex_reflectionÚdefine_indexÚindexes_with_ascdescr   rÇ   ÚdescrŠ   r?   Útemp_table_reflectionrA   )r)   rC   r:   Zschema_prefixr©   rÆ   rÈ   r*   r*   r+   r¦   ’  s   

ÿýòù
ýõ
ÿöýõ

ÿþôÿÿþóú	üûz/ComponentReflectionTest.define_reflected_tablesc                 C   s¶   t ttjƒ}tttjdtj ƒ}t||tdtjdd�tdt 	d¡ƒtdtjƒtj
ddtj d	�t d
d¡fi |¤Ž}tjjjr²tjjjr²t |dtdtj ƒ¡ t |dtdƒ¡ d S )NrJ   r3   Tr4   rM   r7   Úfooúuser_tmp_uq_%sr|   Úuser_tmp_ixrE   rN   rF   rO   )r
   r   r(   r	   rK   r   r   rP   rQ   rR   r†   r   r   r;   r>   r$   rS   r   rG   r   rT   r*   r*   r+   rA   "  s:    ÿ

óòÿþÿÿýz*ComponentReflectionTest.define_temp_tablesc                 C   s2   t d|jj|jjƒ t d|jj|jj|jjƒ d S )NÚusers_t_idxÚusers_all_idx)r   rt   r«   r¯   rª   )r)   rC   r©   r*   r*   r+   rÏ   F  s    z$ComponentReflectionTest.define_indexc                 C   s^   dD ]T}|}|rd||f }|d }d||f }t  |dt|ƒ¡ t  |dtd| ƒ¡ qd S )N)r©   r·   z%s.%sZ_vr‚   rE   rF   r„   )r   rG   r   )r)   rC   r:   rV   ÚfullnameZ	view_namerH   r*   r*   r+   r?   K  s    þÿz$ComponentReflectionTest.define_viewsc                 C   s$   t | jƒ}|  tjj| ¡ v ¡ d S ri   )r   ÚbindÚassert_r   r   r=   Úget_schema_names©r]   rg   r*   r*   r+   Útest_get_schema_names\  s    
z-ComponentReflectionTest.test_get_schema_namesc                 C   s:   |j ddttjjid�}t|ƒ}|  tjj| ¡ v ¡ dS )z
test #7300rÓ   Úbar)Zschema_translate_mapN)Zexecution_optionsr   r   r   r=   r   rÚ   rÛ   re   r*   r*   r+   Ú%test_get_schema_names_w_translate_mapb  s    þÿz=ComponentReflectionTest.test_get_schema_names_w_translate_mapc                 C   s$   t  ¡ }t|ƒ t|jdƒs J ‚d S )NrÍ   )r   r&   r   ÚhasattrrZ   )r]   Úenginer*   r*   r+   Útest_dialect_initializep  s    z/ComponentReflectionTest.test_dialect_initializec                 C   s    t | jƒ}t|j| jjjƒ d S ri   )r   rÙ   r   rÍ   rZ   rÜ   r*   r*   r+   Útest_get_default_schema_namev  s    
z4ComponentReflectionTest.test_get_default_schema_name)NTFFF)Úforeign_keyTFF)NFTF)NTTFz/order_by,include_plain,include_views,use_schema©Úargnamesc                    s¼   |rt j}nd }g d¢‰ t|ƒ}|rL| |¡}| ¡  ddg}	tt|ƒ|	ƒ |r¸|rjdd„ | |¡D ƒ}
n
| |¡}
‡ fdd„|
D ƒ}|dkr¢g d¢}	t||	ƒ ng d	¢}	tt|ƒ|	ƒ d S )
N)r»   rÈ   rÆ   rÁ   rÃ   rÅ   Úemail_addresses_vÚusers_vc                 S   s   g | ]}|d  r|d  ‘qS )r   r*   ©Ú.0Zrecr*   r*   r+   Ú
<listcomp>¢  s   þz@ComponentReflectionTest.test_get_table_names.<locals>.<listcomp>c                    s   g | ]}|ˆ vr|‘qS r*   r*   ©rê   Út©Z_ignore_tablesr*   r+   rë   ©  ó    rä   )r©   r·   r³   )r³   r·   r©   )	r   r=   r   Zget_view_namesÚsortr   ÚsortedZget_sorted_table_and_fkc_namesÚget_table_names)r]   rf   Zorder_byZinclude_plainZinclude_viewsÚ
use_schemar:   rg   Útable_namesZanswerÚtablesr*   rî   r+   Útest_get_table_names{  s,    	
þ
z,ComponentReflectionTest.test_get_table_namesc                 C   s,   t | jƒ}| ¡ }tt|ƒdtj gƒ d S rI   )r   rÙ   Zget_temp_table_namesr   rñ   r   rK   ©r]   rg   Útemp_table_namesr*   r*   r+   Útest_get_temp_table_names²  s    
z1ComponentReflectionTest.test_get_temp_table_namesc                 C   s&   t | jƒ}| ¡ }tt|ƒdgƒ d S rk   )r   rÙ   Zget_temp_view_namesr   rñ   r÷   r*   r*   r+   Útest_get_temp_view_names¸  s    
z0ComponentReflectionTest.test_get_temp_view_namesc                 C   s   |   ¡  d S ri   )Ú_test_get_comments©r]   r*   r*   r+   Útest_get_commentsÀ  s    z)ComponentReflectionTest.test_get_commentsc                 C   s   |   tjj¡ d S ri   )rû   r   r   r=   rü   r*   r*   r+   Útest_get_comments_with_schemaÄ  s    z5ComponentReflectionTest.test_get_comments_with_schemac                 C   st   t | jƒ}t|jd|d�ddiƒ t|jd|d�dd iƒ tdd„ |jd|d�D ƒdd	d
œddd
œddd
œgƒ d S )Nr»   r9   ÚtextrÀ   r©   c                 S   s   g | ]}|d  |d dœ‘qS )rM   r}   )rM   r}   r*   ré   r*   r*   r+   rë   Ô  s   ÿz>ComponentReflectionTest._test_get_comments.<locals>.<listcomp>r¼   r3   )r}   rM   r½   r6   r¿   r¾   )r   rÙ   r   rž   r”   )r]   r:   rg   r*   r*   r+   rû   É  s"    
þþüýûz*ComponentReflectionTest._test_get_comments)FFzuse_views,use_schemac                 C   sn  |rt j}nd }| jj| jj }}|r0ddg}nddg}t|ƒ}t|||fƒD �]\}	}
|}|j|	|d�}|  t	|ƒdkt	|ƒ¡ t
|
jƒD ]Ú\}}t|j|| d ƒ || d j}|j}t|tjjƒrÐ|j}t d	¡rð|tjtjfv rðtj}|  t	t|jƒ |j¡ tjtjtjtjtjtjtj g¡ƒdkd
|j|j|| d |f ¡ |j!sŒ|| d d u sŒJ ‚qŒqNd S )Nrè   rç   r©   r·   r9   r   rM   Útypera   z%s(%s), %s(%s)Údefault)"r   r=   rõ   r©   r·   r   Úzipr”   rÚ   ÚlenÚ	enumerateÚcolumnsr   rM   Ú	__class__r   Ú
isinstancerP   r   Z
TypeEnginer   ZagainstÚ	sql_typesÚDateÚDateTimeÚsetÚ__mro__Úintersectionr   ÚNumericZTimer   Z_Binaryr5   )r]   rf   Z	use_viewsró   r:   r©   Ú	addressesrô   rg   rV   ÚtableZschema_nameÚcolsÚiÚcolÚctypeZ	ctype_defr*   r*   r+   r•   ä  s\    
þ
ÿùýÿñÿïz(ComponentReflectionTest.test_get_columnsc                 C   sv   t t| jdtj ƒ}| j| }t| jƒ}| |¡}|  t|ƒdkt|ƒ¡ t	|j
ƒD ]\}}t|j|| d ƒ qTd S )NrJ   r   rM   )r	   r   rÙ   rK   rõ   r   r”   rÚ   r  r  r  r   rM   )r]   rV   rW   rg   r  r  r  r*   r*   r+   Útest_get_temp_table_columns.  s    ÿ


z3ComponentReflectionTest.test_get_temp_table_columnsc                 C   s0   t | jƒ}| d¡}tdd„ |D ƒg d¢ƒ d S )Nrl   c                 S   s   g | ]}|d  ‘qS r|   r*   ©rê   r  r*   r*   r+   rë   A  rï   zFComponentReflectionTest.test_get_temp_view_columns.<locals>.<listcomp>)r3   rM   rÓ   )r   rÙ   r”   r   )r]   rg   r  r*   r*   r+   Útest_get_temp_view_columns;  s    

z2ComponentReflectionTest.test_get_temp_view_columns©Fró   c                 C   s²   |rt jj}nd }| jj| jj }}t|ƒ}|j|j|d�}|d }t	|dgƒ |j|j|d�}	|	d }
t	|
dgƒ t j
j ¡ � t	|	d dƒ W d   ƒ n1 s¤0    Y  d S )Nr9   Úconstrained_columnsrª   rµ   rM   rº   )r   r   r=   rõ   r©   r·   r   r–   rM   r   r;   Zreflects_pk_namesÚfail_if)r]   rf   ró   r:   r©   r  rg   Z
users_consZusers_pkeysZ	addr_consZ
addr_pkeysr*   r*   r+   r—   C  s    
z.ComponentReflectionTest.test_get_pk_constraintc                 C   sl  |rt j}nd }| jj| jj }}t|ƒ}|}tjjj	rÒ|j
|j|d�}|d }	tjj ¡ � t|	d dƒ W d   ƒ n1 s€0    Y  t|	d |ƒ t|	d |jƒ t|	d dgƒ tjjj	rÒt|	d	 d
gƒ |j
|j|d�}
|
d }	tjj ¡ �" |  |	d d u¡ W d   ƒ n1 �s 0    Y  t|	d |ƒ t|	d |jƒ t|	d dgƒ t|	d	 dgƒ d S )Nr9   r   rM   r±   Úreferred_schemaÚreferred_tableÚreferred_columnsrª   r  r°   r¸   )r   r=   rõ   r©   r·   r   r   r;   rË   r$   r˜   rM   Znamed_constraintsr  r   Zimplicitly_named_constraintsrÚ   )r]   rf   ró   r:   r©   r  rg   Zexpected_schemaZusers_fkeysÚfkey1Z
addr_fkeysr*   r*   r+   r™   [  s0    
,
2z-ComponentReflectionTest.test_get_foreign_keysc           	      C   s  |   d| jjj dtjj dtjj ¡\}}}t| jƒ}| |j	¡}t
t|ƒdƒ |d }t
|d tjjƒ t
|d |j	ƒ t
|d d	gƒ t
|d
 dgƒ |j|j	tjjd�}t
t|ƒdƒ |d }|d d | jjjfv sàJ ‚t
|d |j	ƒ t
|d d	gƒ t
|d
 dgƒ d S )Nz%s.local_tablez%s.remote_tablez%s.remote_table_2é   r   r  r  r  r3   r  rÂ   r9   rÄ   )rõ   rÙ   rZ   rÍ   r   r   r=   r   r˜   rM   r   r  )	r]   rÁ   rÃ   rÅ   rg   Zlocal_fkeysr  Zremote_fkeysZfkey2r*   r*   r+   Ú"test_get_inter_schema_foreign_keysƒ  s2    

ý


ÿþ
z:ComponentReflectionTest.test_get_inter_schema_foreign_keysc                 C   sZ   dd„ |D ƒ}|D ]B}|d |v s&J ‚||  |d ¡ }|D ]}t|| || ƒ q<qd S )Nc                 S   s   g | ]}|d  ‘qS r|   r*   )rê   Údr*   r*   r+   rë   §  rï   z@ComponentReflectionTest._assert_insp_indexes.<locals>.<listcomp>rM   )Úindexr   )r]   ÚindexesÚexpected_indexesZindex_namesZe_indexr"  Úkeyr*   r*   r+   Ú_assert_insp_indexes¦  s    z,ComponentReflectionTest._assert_insp_indexesc                 C   sX   |rt j}nd }t| jƒ}|jd|d�}dddgddœdg d¢d	dœg}|  ||¡ d S )
Nr©   r9   Fr«   r¯   rÖ   ©ÚuniqueÚcolumn_namesrM   )rª   r¯   r«   r×   )r   r=   r   rÙ   rš   r&  )r]   rf   ró   r:   rg   r#  r$  r*   r*   r+   r›   ®  s    
ýýúz(ComponentReflectionTest.test_get_indexes)rÆ   rÉ   )rÈ   rÊ   ztname,ixnamec                 C   sz   t |ƒ}| |¡}d|dœg}|  ||¡ t|tƒ |d�}tt|jƒdƒ tt	|jƒd j
|ƒ tt	|jƒd j|ƒ d S )NF)r(  rM   ©Úautoload_withr  r   )r   rš   r&  r   r   r   r  r#  r   Úlistr  rM   )r]   rf   ÚtnameZixnamerg   r#  r$  rí   r*   r*   r+   Útest_get_noncol_indexÊ  s    
z-ComponentReflectionTest.test_get_noncol_indexc                 C   sN   t | jƒ}| dtj ¡}|D ]}| dd ¡ qt|dgdtj dœgƒ d S )NrJ   Úduplicates_indexrM   rÔ   )r)  rM   )r   rÙ   rœ   r   rK   Úpopr   )r]   rg   Ú	reflectedÚreflr*   r*   r+   Ú&test_get_temp_table_unique_constraintsà  s    
þÿþz>ComponentReflectionTest.test_get_temp_table_unique_constraintsc                 C   s|   t | jƒ}tttjdtj ƒ}| |¡}|D ]}| dd ¡ q,ddgddœg}tj	j
jrdg |d d< td	d
„ |D ƒ|ƒ d S )NrJ   Údialect_optionsFrÓ   rÕ   r'  r   Úinclude_columnsc                 S   s   g | ]}|d  dkr|‘qS )rM   rÕ   r*   ©rê   Úidxr*   r*   r+   rë     rï   zGComponentReflectionTest.test_get_temp_table_indexes.<locals>.<listcomp>)r   rÙ   r	   r   r(   rK   rš   r0  r   r;   Úindex_reflects_included_columnsr$   r   )r]   rg   rV   r#  ÚindÚexpectedr*   r*   r+   Útest_get_temp_table_indexesó  s    
ÿ
ÿ
þz3ComponentReflectionTest.test_get_temp_table_indexesc                 C   sÂ  |rt j}nd }tddgdœdg d¢dœdg d¢dœdd	d
gdœddgdœddgdœgt d¡d�}td|tdt d¡ƒtdt d¡ƒtdtj	ƒtd	t d¡ƒtd
t d¡ƒ|d�}|D ]"}| 
tj|d d|d iŽ¡ q¸| |¡ t|ƒ}t|jd|d�t d¡d�}	tƒ }
t||	ƒD ]0\}}| dd ¡}|�r>|
 |¡ t||ƒ �qtƒ }td|||d�}	tdd„ |	jD ƒƒ}tdd„ |	jD ƒƒ dg¡}| |¡�r¢J ‚|
�r¾t|
|ƒ t|tƒ ƒ d S )NZunique_aÚa)rM   r)  Zunique_a_b_c)r<  Úbrt   Zunique_c_a_b)rt   r<  r=  Zunique_asc_keyZascr%  zi.have.dotsr=  zi have spacesrt   rM   ©r%  Ztesttblr¹   r¶   r9   r)  r/  )r+  r:   c                 S   s   g | ]
}|j ‘qS r*   r|   r6  r*   r*   r+   rë   N  rï   zGComponentReflectionTest.test_get_unique_constraints.<locals>.<listcomp>c                 S   s   g | ]}t |tjƒr|j‘qS r*   )r  rP   r†   rM   )rê   Zuqr*   r*   r+   rë   P  s   þ)r   r=   rñ   ÚoperatorÚ
itemgetterr   r   rP   r   r   Zappend_constraintr†   Úcreater   rœ   r  r  r0  Úaddr   r   r#  ÚconstraintsÚ
differencer  )r]   rC   rf   ró   r:   Zuniquesr  ZucÚ	inspectorr1  Znames_that_duplicate_indexÚorigr2  ZdupeZreflected_metadataZ	idx_namesZuq_namesr*   r*   r+   r�     st    


ú÷
÷ÿ
þ
üþÿú
z3ComponentReflectionTest.test_get_unique_constraintsc           	      C   sT   |rt j}nd }d}d}t|ƒ}|j||d�}|  |¡ |j||d�}|  |¡ d S )Nrè   rç   r9   )r   r=   r   r’   rÚ   )	r]   rf   ró   r:   Z
view_name1Z
view_name2rg   Zv1Zv2r*   r*   r+   r“   \  s    
z0ComponentReflectionTest.test_get_view_definition)r©   Fr©   ztable_name,use_schemaZ
postgresqlzPG specific featurec                 C   s8   |rt j}nd }t|ƒ}| ||¡}|  t|tƒ¡ d S ri   )r   r=   r   Zget_table_oidrÚ   r  Úint)r]   rf   rV   ró   r:   rg   Úoidr*   r*   r+   Útest_get_table_oidn  s    z*ComponentReflectionTest.test_get_table_oidc                 C   sH   t | jƒ}dD ]4\}}| |¡}dd„ |D ƒ| }| dd¡sJ ‚qdS )aˆ  test that 'autoincrement' is reflected according to sqla's policy.

        Don't mark this test as unsupported for any backend !

        (technically it fails with MySQL InnoDB since "id" comes before "id2")

        A backend is better off not returning "autoincrement" at all,
        instead of potentially returning "False" for an auto-incrementing
        primary key column.

        ))r©   rª   )r·   rµ   )r³   r´   c                 S   s   i | ]}|d  |“qS r|   r*   ©rê   rt   r*   r*   r+   Ú
<dictcomp>“  rï   zBComponentReflectionTest.test_autoincrement_col.<locals>.<dictcomp>ÚautoincrementTN)r   rÙ   r”   Úget)r]   rg   r-  Úcnamer  Zid_r*   r*   r+   Útest_autoincrement_col}  s
    

z.ComponentReflectionTest.test_autoincrement_col)N)9r-   r.   r/   Úrun_insertsÚrun_deletesro   r0   rD   r¦   rA   rÏ   r?   r   r;   Zschema_reflectionrÝ   rß   râ   rã   Ú!foreign_key_constraint_reflectionr�   r<   rö   rø   rù   r>   rS   rú   r£   rý   rþ   rû   r•   rÒ   r  rŠ   r  Ú!primary_key_constraint_reflectionr—   r™   rÌ   r   r&  r›   rÎ   rÐ   r.  r¢   r3  Ztemp_table_reflect_indexesr;  r�   r“   Zonly_onrI  Útable_reflectionrO  r*   r*   r*   r+   r¥   ‡  sà   

 
#





ø
,


ý÷
?
ÿÿ$!ÿ
ý
ÿRÿý
	r¥   c                   @   s�   e Zd ZdZdZejdd„ ƒZejdd„ ƒZej	j
dd„ ƒZej	j
d	d
„ ƒZej	j
dd„ ƒZej	jej	j
dd„ ƒƒZej	jej	j
dd„ ƒƒZdS )ÚTableNoColumnsTest)Úreflect_tables_no_columnsTc                 C   s   t d|ƒ | |¡ d S ©NÚempty)r   Ú
create_all©r]   rf   rC   r*   r*   r+   Útable_no_columns›  s    
z#TableNoColumnsTest.table_no_columnsc                 C   sP   t d|ƒ | |¡ t d|ƒ t |dtdƒ¡ t |dtdƒ¡ | |¡ d S )NrX  rE   z*CREATE VIEW empty_v AS SELECT * FROM emptyrF   zDROP VIEW IF EXISTS empty_v)r   rY  r   rG   r   rZ  r*   r*   r+   Úview_no_columns   s    


ý
ÿz"TableNoColumnsTest.view_no_columnsc                 C   s$   t dtƒ |d�}tt|jƒg ƒ d S )NrX  r*  ©r   r   r   r,  rt   )r]   rf   r[  Út2r*   r*   r+   Útest_reflect_table_no_columns³  s    z0TableNoColumnsTest.test_reflect_table_no_columnsc                 C   s   t t|ƒ d¡g ƒ d S rW  ©r   r   r”   )r]   rf   r[  r*   r*   r+   Ú!test_get_columns_table_no_columns¸  s    z4TableNoColumnsTest.test_get_columns_table_no_columnsc                 C   s*   t ƒ }| |¡ t|jƒ dg¡s&J ‚d S rW  )r   Úreflectr  rõ   r  )r]   rf   r[  Úmr*   r*   r+   Ú"test_reflect_incl_table_no_columns¼  s    
z5TableNoColumnsTest.test_reflect_incl_table_no_columnsc                 C   s$   t dtƒ |d�}tt|jƒg ƒ d S )NÚempty_vr*  r]  )r]   rf   r\  r^  r*   r*   r+   Útest_reflect_view_no_columnsÂ  s    z/TableNoColumnsTest.test_reflect_view_no_columnsc                 C   s   t t|ƒ d¡g ƒ d S )Nre  r`  )r]   rf   r\  r*   r*   r+   Ú test_get_columns_view_no_columnsÈ  s    z3TableNoColumnsTest.test_get_columns_view_no_columnsN)r-   r.   r/   Ú__requires__ro   r   Zfixturer[  r\  r;   rV  r_  ra  rd  rp   rf  rg  r*   r*   r*   r+   rU  —  s$   




rU  c                
   @   sø   e Zd ZdZejdejjfddd�ejjdd„ ƒƒZ	ejj
dd„ ƒZejjd	d
„ ƒZdd„ Zejjdd„ ƒZejjdd„ ƒZejjdd„ ƒZejdddejjfdddejjfi ddejjfi ddejjfdddejjfdddejjfdd�dd„ ƒZdS )ÚComponentReflectionTestExtraTr  ró   rå   c              	      s¦   |rt j}nd }td|tdtƒ ƒtjddd�tjddd�|d� | |¡ t|ƒ}t	|j
d|d�t d	¡d
�}dd„ ‰ ‡ fdd„|D ƒ}t|dddœdddœgƒ d S )NZsa_ccr<  za > 1 AND a < 5Zcc1r|   za = 1 OR (a > 2 AND a < 5)Z
UsesCasingr9   rM   r>  c                 S   s   d  t d|  ¡ tj¡¡S )Nú zand|\d|=|a|or|<|>)ÚjoinÚreÚfindallÚlowerÚI)Úsqltextr*   r*   r+   Ú	normalizeò  s    ÿzJComponentReflectionTestExtra.test_get_check_constraints.<locals>.normalizec                    s"   g | ]}|d  ˆ |d ƒdœ‘qS )rM   rp  ©rM   rp  r*   )rê   Úitem©rq  r*   r+   rë   ÷  s   ÿzKComponentReflectionTestExtra.test_get_check_constraints.<locals>.<listcomp>za = 1 or a > 2 and a < 5rr  za > 1 and a < 5)r   r=   r   r   r   rP   rˆ   rY  r   rñ   r    r?  r@  r   )r]   rC   rf   ró   r:   rE  r1  r*   rt  r+   r¡   Ò  s:    
ÿø
þ
þþþz7ComponentReflectionTestExtra.test_get_check_constraintsc                 C   sÜ   t d|tdtdƒƒtdtdƒƒƒ}tdt |jj¡t |jj¡ƒ td|jjƒ | 	|¡ t
|ƒ}ddgddœg}tjjjr g |d	 d
< d|jj g i|d	 d< tdƒ�  t| d¡|ƒ W d   ƒ n1 sÎ0    Y  d S )Nrí   Úxr¶   ÚyÚt_idxZt_idx_2F)rM   r)  r(  r   r5  ú
%s_includer4  z>Skipped unsupported reflection of expression-based index t_idx)r   r   r   r   r   rn  rt   ru  rv  rY  r   r   r;   r8  r$   rá   rM   r   r   rš   )r]   rC   rf   rí   rg   r:  r*   r*   r+   Ú%test_reflect_expression_based_indexes  s.    ü 
ÿ
ÿÿþzBComponentReflectionTestExtra.test_reflect_expression_based_indexesc                 C   s¾   t d|tdtdƒƒtdtdƒƒƒ}td|jjƒ}dg|j|jj d< | 	|¡ t
|ƒ}t| d¡ddgdgdd|jj dgid	œgƒ t dtƒ |d
�}tt|jƒd j|jj d dgƒ d S )Nrí   ru  r¶   rv  rw  ÚincludeFrx  )rM   r)  r5  r(  r4  r*  r   )r   r   r   r   rt   ru  r4  rá   rM   rY  r   r   rš   r   r,  r#  )r]   rC   rf   rí   r7  rg   r^  r*   r*   r+   Útest_reflect_covering_index%  s8    ü
ÿûÿþÿüz8ComponentReflectionTestExtra.test_reflect_covering_indexc                 G   sB   t d|gdd„ t|ƒD ƒ¢R Ž }| |¡ dd„ t|ƒ d¡D ƒS )Nrí   c                 S   s   g | ]\}}t d | |ƒ‘qS )zt%dr   )rê   r  Útype_r*   r*   r+   rë   O  rï   zAComponentReflectionTestExtra._type_round_trip.<locals>.<listcomp>c                 S   s   g | ]}|d  ‘qS )r   r*   rJ  r*   r*   r+   rë   S  rï   )r   r  rA  r   r”   )r]   rf   rC   r   rí   r*   r*   r+   Ú_type_round_tripK  s    þý
z-ComponentReflectionTestExtra._type_round_tripc                 C   sH   |   ||t dd¡¡D ],}t|tjƒs*J ‚t|jdƒ t|jdƒ qd S )Né   r¬   )r}  r  r  r  r   Z	precisionZscale©r]   rf   rC   Útypr*   r*   r+   Útest_numeric_reflectionU  s    ÿz4ComponentReflectionTestExtra.test_numeric_reflectionc                 C   s8   |   ||t d¡¡d }t|tjƒs(J ‚t|jdƒ d S )Né4   r   )r}  r  r   r  r   Úlengthr  r*   r*   r+   Útest_varchar_reflection^  s    ÿþz4ComponentReflectionTestExtra.test_varchar_reflectionc              	   C   sX   t d|tdtdd�tdtdd�ƒ}| |¡ ttdd„ t|ƒ d¡D ƒƒddd	œƒ d S )
Nrí   r<  Tr­   r=  Fc                 s   s   | ]}|d  |d fV  qdS )rM   r®   Nr*   r  r*   r*   r+   Ú	<genexpr>p  s   ÿzHComponentReflectionTestExtra.test_nullable_reflection.<locals>.<genexpr>)r<  r=  )r   r   r   rA  r   r'   r   r”   )r]   rf   rC   rí   r*   r*   r+   Útest_nullable_reflectionf  s    ü
þûz5ComponentReflectionTestExtra.test_nullable_reflectionNZCASCADEzSET NULLz	NO ACTIONZRESTRICTzexpected,ondelete,onupdatec                    s(  i }|r||d< |r||d< |d u r(|}t d|tdtdd�dd� t d|tdtdd�td	ttjd
dd�ƒtdtdƒƒdd� t d|tdtdd�tdtdƒdd�tdtƒtjdgdgfddi|¤Ždd� | |¡ t|ƒ}| 	d¡d d ‰ t
t‡ fdd„ˆ D ƒƒi ƒ | 	d¡d d ‰ t
ˆ |ƒ d S )NÚondeleteÚonupdateru  r3   Tr4   r�   r  Zx_idzx.idÚxidr|   Útesté
   ÚuserrM   r7   Fr­   Útidztable.idZmyfkr   r"   c                 3   s"   | ]}ˆ | r|ˆ | fV  qd S ri   r*   )rê   Úk©Úoptsr*   r+   r…  Î  rï   zLComponentReflectionTestExtra.test_get_foreign_key_options.<locals>.<genexpr>)r   r   r   rP   r   r   r‡   rY  r   r˜   r   r'   )r]   rf   rC   r:  r‡  rˆ  r"   rg   r*   r�  r+   Útest_get_foreign_key_optionsw  sT    *üú	ÿÿÿ÷
z9ComponentReflectionTestExtra.test_get_foreign_key_options)r-   r.   r/   ro   r   r�   r;   r<   r¤   r¡   Zindexes_with_expressionsry  r8  r{  r}  rT  r�  r„  r†  Z1foreign_key_constraint_option_reflection_ondeleteZ1foreign_key_constraint_option_reflection_onupdateZ1fk_constraint_option_reflection_ondelete_noactionZ1fk_constraint_option_reflection_onupdate_restrictZ1fk_constraint_option_reflection_ondelete_restrictr‘  r*   r*   r*   r+   ri  Î  sf   ÿ-
!
%



üüüüüüÛ'ri  c                   @   s0   e Zd ZdZdZedd„ ƒZdd„ Zdd„ Zd	S )
ÚNormalizedNameTest)Zdenormalized_namesTc                 C   sL   t tddd�|tdtdd�ƒ t tddd�|tdtdd�tdtdƒƒƒ d S )	NÚt1T©r‹   r3   r4   r^  Út1idzt1.id)r   r   r   r   r   rB   r*   r*   r+   rD   Ù  s    
ý
üz NormalizedNameTest.define_tablesc                 C   s~   t ƒ }ttddd�|tjd�}|jd }|jj |jj	¡s>J ‚t ƒ }|j
tjdd„ d� |jd jj |jd jj	¡szJ ‚d S )	Nr^  Tr”  r*  r“  c                 S   s   |   ¡ dv S )N©r“  r^  ©rn  )rM   rc  r*   r*   r+   Ú<lambda>ò  rï   zINormalizedNameTest.test_reflect_lowercase_forced_tables.<locals>.<lambda>)Úonly)r   r   r   r   r(   rõ   rt   r•  Z
referencesr3   rb  )r]   Úm2Zt2_refZt1_refZm3r*   r*   r+   Ú$test_reflect_lowercase_forced_tablesç  s    ÿ

ÿz7NormalizedNameTest.test_reflect_lowercase_forced_tablesc                 C   sP   dd„ t tjƒ ¡ D ƒ}t|d  ¡ |d  ¡ ƒ t|d  ¡ |d  ¡ ƒ d S )Nc                 S   s   g | ]}|  ¡ d v r|‘qS )r–  r—  rì   r*   r*   r+   rë   ÷  s   þz;NormalizedNameTest.test_get_table_names.<locals>.<listcomp>r   r  )r   r   r(   rò   r   Úupperrn  )r]   Z
tablenamesr*   r*   r+   rö   ö  s
    þz'NormalizedNameTest.test_get_table_namesN)	r-   r.   r/   rh  ro   r0   rD   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d„ Zejj	d	d
„ ƒZ
dS )ÚComputedReflectionTestc                 C   s^   t tjƒ}| d¡}dd„ |D ƒ}td|d d v ƒ t|d d d ƒ t|d d d ƒ d S )	NÚcomputed_default_tablec                 S   s   i | ]}|d  |“qS r|   r*   rJ  r*   r*   r+   rK    rï   zLComputedReflectionTest.test_computed_col_default_not_set.<locals>.<dictcomp>Z42Úwith_defaultr  ÚnormalÚcomputed_col)r   r   r(   r”   r   r   )r]   rg   r  Zcol_datar*   r*   r+   Ú!test_computed_col_default_not_set  s    

z8ComputedReflectionTest.test_computed_col_default_not_setc                 C   s¶   t tjƒ}| d¡}dd„ |D ƒ}dD ]}td|| vƒ q&|d }td|v ƒ td|d v ƒ t|  |d d ¡dƒ td	|d v tjj	j
ƒ tjj	j
r²t|d d	 tjjj
ƒ d S )
Nrž  c                 S   s   i | ]}|d  |“qS r|   r*   rJ  r*   r*   r+   rK    rï   zKComputedReflectionTest.test_get_column_returns_computed.<locals>.<dictcomp>)r3   r   rŸ  Úcomputedr¡  rp  ú	normal+42Ú	persisted)r   r   r(   r”   r   r   rq  r   r;   Ú"computed_columns_reflect_persistedr$   Ú"computed_columns_default_persisted)r]   rg   r  r6   r%  ÚcompDatar*   r*   r+   Ú test_get_column_returns_computed  s$    


þ

þz7ComputedReflectionTest.test_get_column_returns_computedc                 C   sX   t d|| v ƒ || d }t|  |d ¡|ƒ tjjjrTt d|v ƒ t|d |ƒ d S )Nr£  rp  r¥  )r   r   rq  r   r;   r¦  r$   r   )r]   r6   Úcolumnrp  r¥  r¨  r*   r*   r+   Úcheck_column   s    
z#ComputedReflectionTest.check_columnc                 C   sp   t tjƒ}| d¡}dd„ |D ƒ}|  |ddtjjj¡ tjj	jrR|  |ddd¡ tjj
jrl|  |d	d
d¡ d S )NÚcomputed_column_tablec                 S   s   i | ]}|d  |“qS r|   r*   rJ  r*   r*   r+   rK  ,  rï   zLComputedReflectionTest.test_get_column_returns_persisted.<locals>.<dictcomp>Úcomputed_no_flagr¤  Úcomputed_virtualznormal+2FÚcomputed_storedz	normal-42T)r   r   r(   r”   r«  r   r;   r§  r$   Úcomputed_columns_virtualÚcomputed_columns_stored©r]   rg   r  r6   r*   r*   r+   Ú!test_get_column_returns_persisted(  s.    

ü
ü
üz8ComputedReflectionTest.test_get_column_returns_persistedc                 C   sv   t tjƒ}|jdtjd�}dd„ |D ƒ}|  |ddtjjj	¡ tjj
j	rX|  |ddd	¡ tjjj	rr|  |d
dd¡ d S )Nr¬  r9   c                 S   s   i | ]}|d  |“qS r|   r*   rJ  r*   r*   r+   rK  J  rï   zXComputedReflectionTest.test_get_column_returns_persisted_with_schema.<locals>.<dictcomp>r­  z	normal/42r®  znormal/2Fr¯  z	normal*42T)r   r   r(   r”   r=   r«  r   r;   r§  r$   r°  r±  r²  r*   r*   r+   Ú-test_get_column_returns_persisted_with_schemaC  s2    
ÿü
ü
üzDComputedReflectionTest.test_get_column_returns_persisted_with_schemaN)r-   r.   r/   r¢  r©  r«  r³  r   r;   r<   r´  r*   r*   r*   r+   r�    s   	r�  c                   @   sH   e Zd Zd ZZdZdZedd„ ƒZdd„ Z	dd	„ Z
ejjd
d„ ƒZdS )ÚIdentityReflectionTestNT)Zidentity_columnsrT  c                 C   s|   t d|tdtƒtdttƒ ƒƒ t d|tdttdddd	d
ddd�ƒƒ tjjjrxt d|tdtƒtdttddd�ƒtj	d� d S )Nr“  r   Úid1r^  Úid2Tr   r   éþÿÿÿé*   é   ©ÚalwaysÚstartÚ	incrementÚminvalueÚmaxvalueÚcycleÚcacher¹   )r¼  r½  r9   )
r   r   r   r   r   r;   r<   r$   r   r=   rB   r*   r*   r+   rD   h  s>    üùýý
ûz$IdentityReflectionTest.define_tablesc                 C   sÔ   t jjjr¬d}t|ƒD ]}||vr| |¡ q|r tt|ƒt|ƒƒ |D ]T}|dkrjt|| || kƒ qH|dv rˆt|| || kƒ qHt|| || |ƒ qHqÐt||ƒ n$t|d |d ƒ t|d |d ƒ d S )Nr»  r¿  >   rÀ  rÂ  r½  r¾  )	r   r;   Zidentity_columns_standardr$   r,  r0  r   r  r   )r]   ÚvalueÚexpÚapproxZcommon_keysrŽ  r*   r*   r+   ÚcheckŠ  s     
	zIdentityReflectionTest.checkc                 C   s   t tjƒ}| d¡| d¡ }|D ]Ø}|d dkr@td|v ƒ q"|d dkržt|d dv ƒ t|d	 d ƒ td|v ƒ | j|d td
ddddd
dd�dd� q"|d dkr"t|d dv ƒ t|d	 d ƒ td|v ƒ | j|d tdddddddd�d
d� q"d S )Nr“  r^  rM   r   Úidentityr¶  rL  ©TÚautor  Fr  éÿÿÿr»  T©rÅ  r·  r   r   r¸  r¹  rº  )	r   r   r(   r”   r   r   r   rÆ  r'   ©r]   rg   r  r  r*   r*   r+   Útest_reflect_identity§  sN    
ù	õù	õz,IdentityReflectionTest.test_reflect_identityc                 C   sž   t tjƒ}|jdtjd�}|D ]z}|d dkr<td|v ƒ q|d dkrt|d dv ƒ t|d	 d ƒ td|v ƒ | j|d t	d
ddddddd�d
d� qd S )Nr“  r9   rM   r   rÇ  r¶  rL  rÈ  r  Tr¹   r  rÊ  Fr»  rË  )
r   r   r(   r”   r=   r   r   r   rÆ  r'   rÌ  r*   r*   r+   Útest_reflect_identity_schemaÑ  s,    
ù	õz3IdentityReflectionTest.test_reflect_identity_schema)r-   r.   r/   rP  rQ  ro   rh  r0   rD   rÆ  rÍ  r   r;   r<   rÎ  r*   r*   r*   r+   rµ  b  s   
!*rµ  c                   @   s<   e Zd ZdZedd„ ƒZejjdd„ ƒZ	ejj
dd„ ƒZdS )	ÚCompositeKeyReflectionTestTc                 C   s    t d|tdtƒtdtƒtdt d¡ƒtjddddd�d dd	�}t d
|tdtdd�tdtƒtdtƒtdt d¡ƒtjg d¢|jj	|jj
|jjgdd�d dd	�	 d S )NÚtb1r3   ÚattrrM   r¹   Zpk_tb1r|   Tr²   Útb2r4   ÚpidÚpattrÚpname©rÕ  rÓ  rÔ  Zfk_tb1_name_id_attr)r   r   r   r  rR   rP   r…   r‡   rt   rM   r3   rÑ  )r)   rC   rÐ  r*   r*   r+   rD   ï  s2    ø
ýóz(CompositeKeyReflectionTest.define_tablesc                 C   s2   t | jƒ}| | jjj¡}t| d¡g d¢ƒ d S )Nr  ©rM   r3   rÑ  )r   rÙ   r–   rõ   rÐ  rM   r   rM  )r]   rg   r5   r*   r*   r+   Útest_pk_column_order  s    
z/CompositeKeyReflectionTest.test_pk_column_orderc                 C   s\   t | jƒ}| | jjj¡}tt|ƒdƒ |d }t| d¡g d¢ƒ t| d¡g d¢ƒ d S )Nr  r   r  r×  r  rÖ  )	r   rÙ   r˜   rõ   rÒ  rM   r   r  rM  )r]   rg   Zforeign_keysr  r*   r*   r+   Útest_fk_column_order  s    
z/CompositeKeyReflectionTest.test_fk_column_orderN)r-   r.   r/   ro   r0   rD   r   r;   rS  rØ  rR  rÙ  r*   r*   r*   r+   rÏ  ì  s   

rÏ  )
r¥   ri  rU  ry   r1   rq   r’  r�  rµ  rÏ  )5r?  rl  r%   rP   r¨   r   r   r   r   r   r   Z	provisionr	   r
   r:   r   r   r   r   r   r   r   r   r   r   r   r   r  r   r   Zsql.elementsr   Z
sql.schemar   r   r   rC   r©   Z
TablesTestr   r1   rq   ry   r¥   ZTestBaserU  ri  r’  ZComputedReflectionFixtureTestr�  rµ  rÏ  Ú__all__r*   r*   r*   r+   Ú<module>   sh    ;       7  	,a 1