a
    •˜ëj”é ã                   @   s  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 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m0Z0 dd(lm1Z1 dd)lm2Z2 dd*lm3Z3 dd+lm4Z4 d,\Z5Z6G d-d.„ d.ej7ƒZ8G d/d0„ d0e8ƒZ9G d1d2„ d2ej7ƒZ:G d3d4„ d4ej;ƒZ<G d5d6„ d6ej;ƒZ=G d7d8„ d8ej7ƒZ>d9d:„ Z?G d;d<„ d<e0e8ƒZ@G d=d>„ d>ej;ƒZAG d?d@„ d@e/ej;ƒZBG dAdB„ dBej7ƒZCG dCdD„ dDejDƒZEG dEdF„ dFej7ƒZFG dGdH„ dHej7ƒZGdIZHdS )Jé    Né   )Úconfig)Úengines)Úeq_)Úeq_regex)Úexpect_raises)Úexpect_raises_message)Úexpect_warnings)Úfixtures)Úis_)Úget_temp_table_name)Útemp_table_keyword_args©ÚColumn)ÚTableé   )ÚBoolean)ÚDateTime)Úevent)Ú
ForeignKey)Úfunc)ÚIdentity)Úinspect)ÚInteger)ÚMetaData)ÚString)Útesting)Útypes)Ú	Inspector)Ú
ObjectKind)ÚObjectScope)ÚNoSuchTableError)ÚUnreflectableTableError)ÚDDL)ÚIndex)Úquoted_name)ÚBLANK_SCHEMA)ÚComparesIndexes)ÚComparesTables)Úis_false)Úis_none)Úis_true)Úmock)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	poolclassÚscope)Úoptions)r   ÚrequirementsZindependent_connectionsÚenabledÚ
sqlalchemyr.   r   Útesting_engineÚdictZ
StaticPoolÚdb)Úclsr.   © r9   úg/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_reflection.pyÚ
setup_bind;   s    
ÿz"OneConnectionTablesTest.setup_bindN)Ú__name__Ú
__module__Ú__qualname__Úclassmethodr;   r9   r9   r9   r:   r-   :   s   r-   c                   @   sÌ   e Zd ZdZ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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jejjdd„ ƒƒƒZejjejjdd„ ƒƒZdS )ÚHasTableTestTNc                 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Úschemasr3   r   Útest_schemaÚview_reflectionÚdefine_viewsÚhas_temp_tableÚdefine_temp_tables©r8   Úmetadatar9   r9   r:   Údefine_tablesO   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 )Nz1CREATE VIEW vv AS SELECT id, data FROM test_tableÚafter_createÚbefore_dropzDROP VIEW vvz9CREATE VIEW %s.vv AS SELECT id, data FROM %s.test_table_szDROP VIEW %s.vv)	r   Úlistenr#   r   rJ   rK   r3   r   rL   )r8   rR   Úqueryr9   r9   r:   rN   e   s     
þÿÿýzHasTableTest.define_viewsc                 C   s   t ttjdtj› �ƒS ©NZ	user_tmp_©r   r   r7   Úident©r8   r9   r9   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 )
NrB   TrC   ÚnamerF   rT   ú=create temporary view user_tmp_v as select * from user_tmp_%srU   údrop view user_tmp_v)r   r   r7   r\   r   r   ÚsaÚINTÚVARCHARr   rJ   rM   r3   Útemporary_viewsr   rV   r#   rZ   ©r8   rR   ÚkwÚ
table_nameÚuser_tmpr9   r9   r:   rP   �   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 )NrA   rG   Únonexistent_table)r   r7   Úbeginr+   ÚdialectÚ	has_tabler)   ©ÚselfÚconnr9   r9   r:   Útest_has_tableš   s    zHasTableTest.test_has_tablec              	   C   sŒ   t tjƒ}t| d¡ƒ td|tdtƒƒ}t| d¡ƒ | 	tj¡ z4t| d¡ƒ | 
¡  t| d¡ƒ W | tj¡ n| tj¡ 0 d S )NrA   Z	new_tableÚcol)r   r   r7   r+   rk   r   r   r   r)   ÚcreateÚclear_cacheÚdrop)rm   rR   ÚinspÚntr9   r9   r:   Útest_has_table_cache    s    
z!HasTableTest.test_has_table_cachec                 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 )NrA   rH   rG   rh   )r   r7   ri   r)   rj   rk   rL   r+   rl   r9   r9   r:   Útest_has_table_schema­   s     ÿÿÿÿÿÿz"HasTableTest.test_has_table_schemac                 C   sF   t j ¡ �(}tt jjj|ddd�ƒ W d   ƒ n1 s80    Y  d S )NrA   Znonexistent_schemarH   )r   r7   ri   r)   rj   rk   rl   r9   r9   r:   Ú!test_has_table_nonexistent_schemaÀ   s    ÿÿz.HasTableTest.test_has_table_nonexistent_schemac                 C   s   t |ƒ}t| d¡ƒ d S ©NÚvv©r   r+   rk   ©rm   Ú
connectionrt   r9   r9   r:   Útest_has_table_viewÉ   s    z HasTableTest.test_has_table_viewc                 C   s"   t |ƒ}|  ¡ }t| |¡ƒ d S ©N)r   r\   r+   rk   )rm   r}   rt   r\   r9   r9   r:   Útest_has_table_temp_tableÎ   s    z&HasTableTest.test_has_table_temp_tablec                 C   s   t |ƒ}t| d¡ƒ d S ©NÚ
user_tmp_vr{   r|   r9   r9   r:   Útest_has_table_temp_viewÔ   s    z%HasTableTest.test_has_table_temp_viewc                 C   s   t |ƒ}t| dtj¡ƒ d S ry   )r   r+   rk   r   rL   r|   r9   r9   r:   Útest_has_table_view_schemaÛ   s    z'HasTableTest.test_has_table_view_schema)r<   r=   r>   Ú__sparse_driver_backend__Úrun_deletesr?   rS   rN   r\   rP   ro   rv   r   rJ   rK   rw   rx   Úviewsr~   rO   r€   rM   rc   rƒ   r„   r9   r9   r9   r:   r@   J   s6   







r@   c                   @   sX   e Zd ZdZdZedd„ ƒZejdddd�Z	d	d
„ Z
e	dd„ ƒZejje	dd„ ƒƒZdS )ÚHasIndexTestT)Úindex_reflectionc              	   C   s€   t d|tdtdd�tdtdƒƒtdtdƒƒƒ}td|jjƒ tjj	j
r|t d|tdtdd�tdtdƒƒtjd	�}td
|jjƒ d S )NrA   rB   TrC   rE   rF   Údata2Úmy_idxrH   Úmy_idx_s)r   r   r   r   r$   ÚcrE   r   rJ   rK   r3   r   rL   )r8   rR   Úttr9   r9   r:   rS   æ   s"    û
ûzHasIndexTest.define_tablesrj   Ú	inspectorÚkind©Úargnamesc                    s"   |dkr‡ fdd„S t ˆ ƒjS d S )Nrj   c                     s   t jjjˆ g| ¢R i |¤ŽS r   )r   r7   rj   Ú	has_index)ÚaÚk©rn   r9   r:   Ú<lambda>ÿ   ó    z)HasIndexTest._has_index.<locals>.<lambda>)r   r“   )rm   r�   rn   r9   r–   r:   Ú
_has_indexý   s    zHasIndexTest._has_indexc              	   C   s&  |   ||¡}|ddƒsJ ‚|ddƒr(J ‚|ddƒr6J ‚|ddƒrDJ ‚|ddƒrRJ ‚|ddƒr`J ‚td| jjjjƒ}td|td	tƒtdd	ƒƒ}| 	|¡ | 	|¡ zj|d
krÐ|ddƒr¸J ‚|ddƒrÆJ ‚|j
 ¡  |ddƒdu sâJ ‚|ddƒdu sôJ ‚W | |¡ | |¡ n| |¡ | |¡ 0 d S )NrA   r‹   rŒ   rh   Znonexistent_idxZmy_idx_2Ztest_table_2Zmy_idx_3Úfoor�   T)r™   r$   ÚtablesrA   r�   rŠ   r   r   r   rq   Ú__self__rr   rs   )rm   r�   r}   rR   ÚmethÚidxZtblr9   r9   r:   Útest_has_index  s6    ü



ÿ
zHasIndexTest.test_has_indexc                 C   s`   |   ||¡}|ddtjd�s J ‚|ddtjd�r4J ‚|ddtjd�rHJ ‚|ddtjd�r\J ‚d S )NrA   rŒ   rH   r‹   rh   Znonexistent_idx_s)r™   r   rL   )rm   r�   r}   r�   r9   r9   r:   Útest_has_index_schema!  s    ÿ
ÿz"HasIndexTest.test_has_index_schemaN)r<   r=   r>   r…   Ú__requires__r?   rS   r   Úcombinationsr�   r™   rŸ   rJ   rK   r    r9   r9   r9   r:   rˆ   â   s   

rˆ   c                   @   s„   e Zd ZdZdd„ Zdd„ Ze dddg¡eƒ eƒ ejj	dd	„ ƒƒƒƒZ
eƒ eƒ ejjd
d„ ƒƒƒZeƒ eƒ ejjdd„ ƒƒƒZdS )ÚBizarroCharacterTestTc                   C   s   t jdddddd�S )N)Z	plainname)z(3))zcol%p)z[brack]Ú
columnnamer‘   ©r   r¢   r9   r9   r9   r:   Úcolumn_names3  s    ûz!BizarroCharacterTest.column_namesc                   C   s   t jdddddd�S )N)Úplain)z(2))z
per % cent)z
[brackets]Ú	tablenamer‘   r¥   r9   r9   r9   r:   Útable_names<  s    ûz BizarroCharacterTest.table_namesÚuse_compositeFc           
      C   s  t ||t|tddd�dd�}|r4| tdtdd�¡ |r~t d|tdtdd�tdtƒtd	tƒt dd	g|jj|jjg¡dd� n*t d|tdtdd�tdt	|jjƒƒdd� | 
|¡ tƒ }t d||d
�}|j| }	|jj |	jd ¡sèJ ‚|�r|jj |	jd ¡�sJ ‚dS )ztests for #10275rB   T)ÚkeyrD   ©Útest_needs_fkÚid2rC   ÚotherÚrefÚref2©Úautoload_withr   é   N)r   r   r   Zappend_columnr`   ÚForeignKeyConstraintr�   rB   r®   r   Ú
create_allr   r›   r°   Ú
referencesr±   )
rm   r}   rR   rª   r¨   r¤   rŽ   Úm2Zo2Út1r9   r9   r:   Útest_fk_refE  s@    üù
û

z BizarroCharacterTest.test_fk_refc              	   C   sL   t ||t|ttƒ dd�ƒ | |¡ t|ƒ}t| |¡d d d dƒ d S )NTrC   r   ÚidentityÚstartr´   ©r   r   r   r   r¶   r   r   Úget_columns©rm   r¨   r¤   r}   rR   rt   r9   r9   r:   Útest_reflect_identityt  s    ý
z*BizarroCharacterTest.test_reflect_identityc              	   C   sP   t ||tdtdd�t|tdd�ƒ | |¡ t|ƒ}t| |¡d d dƒ d S )NrB   TrC   úsome comment©Úcommentr´   rÃ   ©r   r   r   r¶   r   r   r¾   r¿   r9   r9   r:   Útest_reflect_comments„  s    ü
z*BizarroCharacterTest.test_reflect_commentsN)r<   r=   r>   r…   r¦   r©   r   Z	variationrJ   Ú!foreign_key_constraint_reflectionrº   Úidentity_columnsrÀ   Úcomment_reflectionrÅ   r9   r9   r9   r:   r£   /  s    		+r£   c                   @   sB   e Zd ZdZdZejdd„ ƒZejj	dd„ ƒZ
ejjdd„ ƒZd	S )
ÚTempTableElementsTestT)Útemp_table_reflectionc                 C   s   t ttjdtj› �ƒS )NZ
ident_tmp_rY   ©rm   r9   r9   r:   r¨   œ  s    ÿzTempTableElementsTest.tablenamec              	   C   sL   t ||tdttƒ dd�ƒ | |¡ t|ƒ}t| |¡d d d dƒ d S )NrB   TrC   r   r»   r¼   r´   r½   ©rm   r¨   r}   rR   rt   r9   r9   r:   rÀ   ¢  s    ý
z+TempTableElementsTest.test_reflect_identityc              	   C   sP   t ||tdtdd�tdtdd�ƒ | |¡ t|ƒ}t| |¡d d dƒ d S )	NrB   TrC   ZfoobarrÁ   rÂ   r´   rÃ   rÄ   rÌ   r9   r9   r:   rÅ   ®  s    ü
z+TempTableElementsTest.test_reflect_commentsN)r<   r=   r>   r…   r¡   r   Úfixturer¨   rJ   rÇ   rÀ   Ztemp_table_comment_reflectionrÅ   r9   r9   r9   r:   rÉ   –  s   

rÉ   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e	j
jdd„ ƒƒZee	j
j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 ' onerB   r]   rF   rE   Z
related_idzpk quote ' one©r]   zix quote ' onezuq quote' onez
related.idzfk quote ' onezname != 'foo'zck quote ' onezquote ' one commentT)rÃ   r­   úquote " twozpk quote " twozix quote " twozuq quote" twozfk quote " twozck quote " two zquote " two commentÚrelatedrC   r¬   z"CREATE VIEW %s AS SELECT * FROM %súview %srT   rU   zDROP VIEW %s)r   r   r   r   r`   ÚPrimaryKeyConstraintr$   ÚUniqueConstraintrµ   ÚCheckConstraintr   rJ   Úsymbol_names_w_double_quoter3   Úview_column_reflectionr   r7   rj   Zidentifier_preparerÚquoter   rV   r#   )r8   rR   Únamesr]   rW   r9   r9   r:   rS   À  s”    
þ
ÿî

þ
ÿîûþÿ
ÿü
ÿÿÿýz$QuotedNameArgumentTest.define_tablesc                 C   s   t  ddt jjf¡| ƒS )N)rÐ   rÒ   )r   r¢   rJ   rØ   )Úfnr9   r9   r:   Úquote_fixtures  s    
þýz%QuotedNameArgumentTest.quote_fixturesc                 C   sd   t tjƒ}tjjjr.| |¡}tt	|t
ƒƒ n2ttƒ� | |¡ W d   ƒ n1 sV0    Y  d S r   )r   r   r7   r   rJ   Úreflect_table_optionsr3   Úget_table_optionsr+   Ú
isinstancer6   r   ÚNotImplementedError)rm   r]   rt   Úresr9   r9   r:   Útest_get_table_options  s    



z-QuotedNameArgumentTest.test_get_table_optionsc                 C   s    t tjƒ}| d| ¡sJ ‚d S )NrÔ   )r   r   r7   Úget_view_definition©rm   r]   rt   r9   r9   r:   Útest_get_view_definition$  s    
z/QuotedNameArgumentTest.test_get_view_definitionc                 C   s   t tjƒ}| |¡sJ ‚d S r   )r   r   r7   r¾   rå   r9   r9   r:   Útest_get_columns*  s    
z'QuotedNameArgumentTest.test_get_columnsc                 C   s   t tjƒ}| |¡sJ ‚d S r   )r   r   r7   Úget_pk_constraintrå   r9   r9   r:   Útest_get_pk_constraint/  s    
z-QuotedNameArgumentTest.test_get_pk_constraintc                 C   s   t tjƒ}| |¡sJ ‚d S r   )r   r   r7   Úget_foreign_keysrå   r9   r9   r:   Útest_get_foreign_keys4  s    
z,QuotedNameArgumentTest.test_get_foreign_keysc                 C   s   t tjƒ}| |¡sJ ‚d S r   )r   r   r7   Úget_indexesrå   r9   r9   r:   Útest_get_indexes:  s    
z'QuotedNameArgumentTest.test_get_indexesc                 C   s   t tjƒ}| |¡sJ ‚d S r   )r   r   r7   Úget_unique_constraintsrå   r9   r9   r:   Útest_get_unique_constraints@  s    
z2QuotedNameArgumentTest.test_get_unique_constraintsc                 C   s   t tjƒ}| |¡sJ ‚d S r   )r   r   r7   Úget_table_commentrå   r9   r9   r:   Útest_get_table_commentF  s    
z-QuotedNameArgumentTest.test_get_table_commentc                 C   s   t tjƒ}| |¡sJ ‚d S r   )r   r   r7   Úget_check_constraintsrå   r9   r9   r:   Útest_get_check_constraintsL  s    
z1QuotedNameArgumentTest.test_get_check_constraintsN)r<   r=   r>   Zrun_create_tablesr…   r?   rS   rÝ   rã   r   rJ   rÙ   ræ   rç   ré   rÆ   rë   r‰   rí   Úunique_constraint_reflectionrï   rÈ   rñ   Úcheck_constraint_reflectionró   r9   r9   r9   r:   rÎ   ¼  s:   
R



rÎ   c              
   C   sŒ   t jd dd„ t jjfdd�}t jtjtjtjdd�}t jtj	tj
tjtjtjtj	tj
B tj	tjB dd�}t jddd	d�}||||| ƒƒƒƒS )
Nc                   S   s   t jS r   )r   rL   r9   r9   r9   r:   r—   W  r˜   z$_multi_combination.<locals>.<lambda>rI   r‘   r0   r�   TFÚ
use_filter)r   r¢   rJ   rK   r    ÚDEFAULTÚ	TEMPORARYÚANYr   ÚTABLEÚVIEWÚMATERIALIZED_VIEWZANY_VIEW)rÜ   rI   r0   r�   Úfilter_namesr9   r9   r:   Ú_multi_combinationS  s2    þúü

ø
rþ   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dd„ Zdd„ Zdd„ Zdejejdfdd„Zdejejdfdd„Zdejejdfdd„Zedd„ ƒZdejejdfdd„Zedd„ ƒZdejejdfdd „Zed!d"„ ƒZdejejdfd#d$„Zed%d&„ ƒZdejejdd'fd(d)„Zed*d+„ ƒZdejejdfd,d-„Zed.d/„ ƒZ e!j"j#d0d1„ ƒZ$e!j"j#d2d3„ ƒZ%e!j"j#d4d5„ ƒZ&e!j"j#d6d7„ ƒZ'e!j"j#e!j"j(d8d9„ ƒƒZ)e!j"j#d:d;„ ƒZ*e!j"j#d<d=„ ƒZ+e!j,dd>e!j"j-fd?d@�e!j,de!j"j.fd'dAd@�dBdC„ ƒƒZ/e!j,de!j"j.fd'dAd@�dDdE„ ƒZ0e!j"j1dFdG„ ƒZ2e!j"j3e!j"j4dHdI„ ƒƒZ5e!j"j6dJdK„ ƒZ7e!j"j6e!j"j.dLdM„ ƒƒZ8dÄdNdO„Z9e!j,dPd'de!j"j.fdd'e!j"j3fdde!j"j.e!j"j3 fdQd@�dRdS„ ƒZ:e!j"j;dTdU„ ƒZ<e!j"j;dVdW„ ƒZ=e!j"j;e!j"j>e!j"j4dXdY„ ƒƒƒZ?e!j,dZde!j"j.fdAd@�e!j"j@d[d\„ ƒƒZAe!j,d]d^d_d`dad@�e!j"j@e!j"jBdbdc„ ƒƒƒZCe!j,dZde!j"j.fdAd@�e!j"j-ddde„ ƒƒZDe!j,dfdgdhdidjd@�e!j"j-dkdl„ ƒƒZEe!j"jFe!j"j.dmdn„ ƒƒZGe!j,dZde!j"j.fdAd@�e!j"jHdodp„ ƒƒZIe!j,dqdrdsd@�e!j"jHe!j"jJe!j"jKdtdu„ ƒƒƒƒZLe!j,dvdwdxdydzd@�e!j"jHd{d|„ ƒƒZMe!j"j;e!j"jNd}d~„ ƒƒZOe!j"jPdd€„ ƒZQe!j,de!j"j.fdZdAd@�e!j"jNd�d‚„ ƒƒZRe!j,dƒd„d…d†d‡d@�e!j"jNdˆd‰„ ƒƒZSe!j"j3e!j,dZde!j"j.fdAd@�dŠd‹„ ƒƒZTe!j"j3dŒd�„ ƒZUe!j"jVdŽd�„ ƒZWe!j,de!j"j.fdZdAd@�d�d‘„ ƒZXe! ,de!j"j.fd'¡d’d“„ ƒZYe!jZd”d•„ ƒZ[e!j"j\e]d–d—„ ƒƒZ^e!j"j6e]d˜d™„ ƒƒZ_dšd›„ Z`dÅdœd�„ZadÆdždŸ„Zbe]d d¡„ ƒZce!j"j@e]d¢d£„ ƒƒZdd¤d¥„ Zee!j"j-e]d¦d§„ ƒƒZfe!j"jHe]d¨d©„ ƒƒZge!j"jNe]dªd«„ ƒƒZhe!j"jie]d¬d­„ ƒƒZje!j,d®e!j"j\fd¯d°e!j"j@fd±e!j"j-fd²e!j"jHfd³e!j"jNfd´e!j"jifdµe!j"j6fd¶d@�	d·d¸„ ƒZkd¹dº„ Zle!j,dd'dAd@�e!j,de!j"jmfd'd»d@�d¼d½„ ƒƒZne!j"j6d¾d¿„ ƒZoe!j"jpdÀdÁ„ ƒZqe!j"jre!j"jsdÂdÃ„ ƒƒZtdS )ÇÚComponentReflectionTestNTc                 C   s*   |   |d ¡ tjjjr&|   |tjj¡ d S r   )Údefine_reflected_tablesr   rJ   rK   r3   r   rL   rQ   r9   r9   r:   rS   v  s    
z%ComponentReflectionTest.define_tablesc                 C   s¢  |r|d }nd}t jjjr0td| dd�f}nd}td|tdtjd	d
�tdt 	d¡dd�tdt 
¡ dd�tdtjg|¢R Ž tjdddd�t d¡|d	d�
}td|tdtjd	d
�tdtjtd| ddd�ƒtdtjtd| ƒƒtdt d¡d	d �tjd!d"d�tjddd#d$d�|d	d�
 td%|tdtjƒtd&tjt|jjƒƒtd't d(¡d	d)�tjdd*d+d�|d	d� td,|td-tjd	d.d/�tdt d(¡d0d1�td2t d(¡d3d1�td4t d5¡d6d1�|d7d8� td9|tdt d(¡ƒ|d:d8� t jjj�r¤|d u �r6t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dAtjjj ƒƒtdt d(¡ƒ|d	d� tdB|td-tjd	d
�tdt d(¡ƒ|d	d� t jjj�rjtdC|jj|jjd	d � tdD|jj|jj|jjƒ |�sjtdE|tdFt d¡ƒd	dG�}tdH|td-tjd	d
�tdFt d¡ƒd	dG�}t jjj�rjt jjj�rjtdI|jj ¡ ƒ tdJ|jj ¡ ƒ t jj j�r‚|  !||¡ |�sžt jj"j�rž|  #|¡ d S )KNÚ.Ú z%susers.user_idÚ
user_id_fkrÑ   r9   ÚusersÚuser_idTrC   Útest1é   F©ÚnullableÚtest2Úparent_user_idú	test2 > 0Úzz_test2_gt_zeroúusers check constraint©r]   rÃ   útest2 <= 1000©rI   r­   Ú
dingalingsÚdingaling_idÚ
address_idz%semail_addresses.address_idÚzz_email_add_id_fgúdi fk commentÚid_userrE   é   )Úuniquez$address_id > 0 AND address_id < 1000Úaddress_id_gt_zeroÚzz_dingalings_multipleúdi unique commentÚemail_addressesÚremote_user_idÚemail_addressé   )ÚindexÚemail_ad_pkúea pk commentÚcomment_testrB   ú
id comment)rD   rÃ   údata % commentrÂ   Úd2ú)Comment types type speedily ' " \ '' Fun!Úd3é*   úComment
withescapesúthe test % ' " \ table comment)rI   rÃ   Úno_constraintsú"no
constraintshasescapedcommentÚlocal_tableÚ	remote_idz%s.remote_table_2.id)r­   rI   Úremote_tableÚlocal_idz%s.local_table.idÚremote_table_2Úusers_t_idxÚusers_all_idxÚnoncol_idx_test_nopkÚqr¬   Únoncol_idx_test_pkÚnoncol_idx_nopkÚnoncol_idx_pk)$r   rJ   Úself_referential_foreign_keysr3   r   r   r   r`   ra   ÚCHARZFloatr   r×   r   rÖ   r�   r  rÕ   Úcross_schema_fk_reflectionr   rL   r7   rj   Údefault_schema_namer‰   r$   r  r
  Úindexes_with_ascdescÚreflect_indexes_with_ascdescr7  ÚdescrÙ   rN   rÊ   rP   )r8   rR   rI   Zschema_prefixZparent_id_argsr  r6  r8  r9   r9   r:   r   |  s>   

ÿÿýòýý	
ýþüâ 
ÿöýôû

ÿþôÿÿþóú	ÿüû	ÿþz/ComponentReflectionTest.define_reflected_tablesc                 C   s   t ttjdtj› �ƒS rX   rY   r[   r9   r9   r:   r\   *  s    ÿz'ComponentReflectionTest.temp_table_namec                 C   s¬   t t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 )NrB   TrC   r]   rF   rš   Úuser_tmp_uq_rÑ   Úuser_tmp_ixrT   r^   rU   r_   )r   r   r7   r\   r   r   r`   ra   rb   rÖ   rZ   r$   r   rJ   rM   r3   rc   r   rV   r#   rd   r9   r9   r:   rP   0  s6    

óòÿþÿÿýz*ComponentReflectionTest.define_temp_tablesc              
   C   sæ   t jjjrdh}ntƒ }dD ]Ä}|}|r6|› d|› �}|d }||v rJdnd}d|› d|› d	|› �}t |d
t|ƒ¡ ||v rÂd}	|ržt  d¡rž|› d|	› �}	d|	› d|› d�}
t |d
t|
ƒ¡ t |dtd|› d|› �ƒ¡ qd S )Nr  ©r  r  r  r  Z_vzMATERIALIZED r  zCREATE zVIEW z AS SELECT * FROM rT   Ú	mat_indexÚoraclezCREATE INDEX z ON z(data)rU   zDROP )	r   rJ   Úmaterialized_viewsr3   Úsetr   rV   r#   Úagainst)r8   rR   rI   Úmaterializedrf   ÚfullnameZ	view_nameÚprefixrW   Z
index_namerž   r9   r9   r:   rN   R  s*    
ÿÿz$ComponentReflectionTest.define_viewsc                 C   sD   i }t j|v r| |¡ t j|v r,| |¡ t j|v r@| |¡ |S r   )r   rú   Úupdaterû   rü   )rm   r�   r›   r‡   rJ  râ   r9   r9   r:   Ú_resolve_kindm  s    





z%ComponentReflectionTest._resolve_kindc                 C   s<   t jjjs| ¡  | ¡  nt jjjs8| |¡ | ¡  d S r   )r   rJ   rÙ   r3   ÚclearrG  rM  )rm   r‡   rJ  r9   r9   r:   Ú_resolve_viewsw  s    



z&ComponentReflectionTest._resolve_viewsc              	      sü   dd„ ‰|t ju rdd„ ‰|t ju r,dd„ ‰d ddhtjjddd	d
|  ¡ hi‰tjjj	s|ˆd   
d¡ ˆtjj  ddg¡ tjjj	s˜ˆd   dd	g¡ tjjj	r¬tjjj	sÂˆd   d
|  ¡ g¡ tjjj	sÜˆd   d
g¡ ‡ ‡‡‡fdd„| ¡ D ƒ}|S )Nc                 S   s   dS )NTr9   )Ú_r9   r9   r:   r—   €  r˜   z8ComponentReflectionTest._resolve_names.<locals>.<lambda>c                 S   s   d| d vS ©NÚtmpr´   r9   ©r•   r9   r9   r:   r—   ‚  r˜   c                 S   s   d| d v S rR  r9   rT  r9   r9   r:   r—   „  r˜   r1  r3  r/  r6  r8  r‚   c                    s>   i | ]6\}}ˆ|ƒr|d  ˆˆ vrˆ r4|d  ˆ v r||“qS )r´   r9   )Ú.0r•   Úv©rý   ÚremovedrI   Zscope_filterr9   r:   Ú
<dictcomp>¡  s
   üz:ComponentReflectionTest._resolve_names.<locals>.<dictcomp>)r    r÷   rø   r   r   rL   r\   rJ   r=  r3   ÚaddrM  r‰   rÊ   Útemp_table_namesrc   Úitems)rm   rI   r0   rý   Úvaluesrâ   r9   rW  r:   Ú_resolve_names  sD    

ûþ

ÿ
ÿÿþ
þz&ComponentReflectionTest._resolve_namesc           	      C   sÖ   |dft ji}|dft j|dft j|dft ji}|  ||¡ |dft j|dft j|dft j|dft j|d	ft j|d
ft j|dft j|dft j|dft j|dft j||  ¡ ft ji}|  ||||¡}|  ||||¡}|S )NÚdingalings_vÚemail_addresses_vÚusers_vr‚   r  r  r  r$  r-  r/  r1  r3  r6  r8  ©r,   rù   rP  r\   rN  r^  )	rm   rI   r0   r�   rý   rJ  r‡   r›   râ   r9   r9   r:   Úexp_optionsª  s*    


ý









õz#ComponentReflectionTest.exp_optionsc           
      C   sÈ   dd i}|df|i}|df||df||df|i}|   ||¡ |df||df||df||d	fdd
i|dfddi|df||df||df||df||df|||  ¡ f|i}|  ||||¡}	|  ||||	¡}	|	S )NÚtextr_  r`  ra  r‚   r  r  r  r$  r,  r-  r.  r/  r1  r3  r6  r8  )rP  r\   rN  r^  )
rm   rI   r0   r�   rý   ÚemptyrJ  r‡   r›   râ   r9   r9   r:   Úexp_commentsÉ  s4    ýÿÿñz$ComponentReflectionTest.exp_commentsc           
         s$  dt jd dfdd„‰ ‡ fdd„}|dfˆ dd	t jd
�ˆ dƒˆ dƒˆ dƒgi}|dfˆ dd	t jd
�ˆ dƒˆ dƒg|dfˆ dd	t jd
�ˆ dt jd�ˆ dt jd�ˆ dƒg|dfˆ dd	t jd
�ˆ dƒˆ dƒgi}|  ||¡ |df|dƒˆ ddd�ˆ ddd�ˆ dƒg|df|dƒˆ dƒˆ dƒˆ dƒg|df|dƒˆ dƒˆ dƒg|df|ddd �ˆ dd!d �ˆ d"d#d �ˆ d$d%d �g|d&fˆ dƒg|d'f|dƒˆ dƒˆ d(ƒg|d)f|dƒˆ d*ƒˆ dƒg|d+f|dƒˆ dƒg|d,fˆ d-ƒg|d.f|dƒˆ d-ƒg||  ¡ f|dƒˆ dƒˆ dƒgi}|  ||||¡}	|  ||||	¡}	|	S )/NFTc                 S   s*   | |t j|||dœ}|dkr&| d¡ |S )N)r]   ÚautoincrementÚtypeÚdefaultrÃ   r	  Úomitrg  )r,   rù   Úpop)r]   Úautori  rÃ   r	  râ   r9   r9   r:   rp   ô  s    ú
z0ComponentReflectionTest.exp_columns.<locals>.colc                    s"   dt jddœ|¥}ˆ | fi |¤ŽS )NTF)rl  ri  r	  ©r,   rù   )r]   re   ©rp   r9   r:   Úpk  s    z/ComponentReflectionTest.exp_columns.<locals>.pkr_  r  rj  )rl  r	  r  r  rE   r`  r  r  ra  r  r  r  r
  r  r‚   rB   r]   rš   r  r  r  r$  r%  rÂ   r&  r'  r(  r)  r+  r-  r/  r0  r1  r2  r3  r6  r7  r8  rb  )
rm   rI   r0   r�   rý   ro  rJ  r‡   r›   râ   r9   rn  r:   Úexp_columnsí  sŠ    
ÿ
üÿ	ýüýô

üüý

þ
ù	
ýß'z#ComponentReflectionTest.exp_columnsc                 C   s   h d£S )N>   r	  r]   ri  rh  r9   rË   r9   r9   r:   Ú_required_column_keysM  s    z-ComponentReflectionTest._required_column_keysc                 C   sN  t jd dœdd„}|d d�}tjjjr8|df|dƒi}n|df|i}|df||df||d	f|i}|  ||¡ |d
f|dƒ|df|dƒ|df|dddd�|df|dƒ|df||df|dƒ|df|dƒ|df|dƒ|df||df|dƒ||  ¡ f|dƒi}	tjjj�s*|	 	¡ D ]}
|
d d u�r
t j|
d< �q
|  
||	||¡}|  ||||¡}|S )Nr  c                 W   s   t |ƒ| |dœS )N)Úconstrained_columnsr]   rÃ   )Úlist)r]   rÃ   Úcolsr9   r9   r:   ro  X  s    ýz+ComponentReflectionTest.exp_pks.<locals>.pkrÑ   r_  r  r`  ra  r‚   r  r  r  r  r  r"  r#  r$  rB   r-  r/  r1  r3  r6  r8  r]   )r,   rù   r   rJ   Zmaterialized_views_reflect_pkr3   rP  r\   Úreflects_pk_namesr]  rN  r^  )rm   rI   r0   r�   rý   ro  re  rJ  r‡   r›   Úvalrâ   r9   r9   r:   Úexp_pksQ  s>    

ýÿózComponentReflectionTest.exp_pksc                 C   s   ddhS )Nr]   rr  r9   rË   r9   r9   r:   Ú_required_pk_keys�  s    z)ComponentReflectionTest._required_pk_keysc                    s¢  G dd„ dƒ‰ |t jd f‡ fdd„	}|dfg i}|dfg |dfg |dfg i}|  ||¡ |d	f|d
gdgd	dd�g|df|dgdgd	ƒ|dgdgdddd�g|df|dgdgd	ƒg|dfg |dfg |df|dgdgdtjd�g|df|dgdgdd d�g|dfg |dfg |d fg ||  ¡ fg i}tjjj	�s<||d	f  
¡  tjjj	�s~| ¡ D ],}	|	D ] }
|
d! t ju�rXt j|
d!< �qX�qP|  ||||¡}|  ||||¡}|S )"Nc                   @   s   e Zd Zdd„ ZdS )z+ComponentReflectionTest.exp_fks.<locals>.ttc                 S   s   |d u pt jjj|kS r   )r   r7   rj   r>  ©rm   r¯   r9   r9   r:   Ú__eq__�  s    þz2ComponentReflectionTest.exp_fks.<locals>.tt.__eq__N©r<   r=   r>   rz  r9   r9   r9   r:   rŽ   Œ  s   rŽ   c                    s$   | ||t j|d ur|nˆ ƒ ||dœS )N)rr  Úreferred_columnsr]   r1   Úreferred_schemaÚreferred_tablerÃ   rm  )rt  Zref_colZ	ref_tableÚ
ref_schemar]   rÃ   ©rŽ   r9   r:   Úfk“  s    	÷z+ComponentReflectionTest.exp_fks.<locals>.fkr_  r`  ra  r‚   r  r  r  r  rÑ   r  r  r  r  r  r  r  r  r$  r-  r/  r0  rB   r3  )r  r1  r2  r6  r8  r]   )r,   rù   rP  r   rL   r\   r   rJ   r;  r3   rO  Únamed_constraintsr]  rN  r^  )rm   rI   r0   r�   rý   r�  rJ  r‡   r›   Úvalsrv  râ   r9   r€  r:   Úexp_fks…  sn    úýÿûþ
ÿüÿÿß#zComponentReflectionTest.exp_fksc                 C   s   h d£S )N>   rr  r}  r~  r]   r|  r9   rË   r9   r9   r:   Ú_required_fk_keysÝ  s    z)ComponentReflectionTest._required_fk_keysc           
      C   s
  dd dddœdd„}|dfg i}|dfg |dfg |dfg i}|   ||¡ |rf||df  |d	d
d�¡ |dfg |dddd�¢|ddddd�¢|ddddd�¢|dfg |d	tjddd�¢|dtjdd�¢|dddddd�¢|dfg |dtjd�¢|dtjdd�¢|d fg |d!fg |d"fg |d#tjdd�¢|d$fg |d%tjdd�¢|d&fg |d'fg |d(d)d(d*id+�¢|d,fg |d(d-d(d*id+�¢||  ¡ fg |d.d/d�¢|d0d1tj› �ddd2�¢i}tjj	j
�rÆtjjj
�sæ||d'f  ¡  ||d,f  ¡  |  ||||¡}	|  ||||	¡}	|	S )3NF)r  Úcolumn_sortingÚ
duplicatesr�  c                    s�   t jj}t jj}t jj}|r"|jr,|r0|js0dS |t|ƒ| tjg dœ}	ˆ r~ˆ |	d< |jr~|	d  |	d< }
‡ fdd„|
D ƒ|	d< |rŠ| |	d< |	gS )	Nr9   )r  r¦   r]   Údialect_optionsÚinclude_columnsr†  r¦   Úexpressionsc                    s   g | ]}|ˆ v rd n|‘qS r   r9   ©rU  r�   ©r†  r9   r:   Ú
<listcomp>  s   zDComponentReflectionTest.exp_indexes.<locals>.idx.<locals>.<listcomp>Zduplicates_constraint)	r   rJ   Zforeign_keys_reflect_as_indexZ#unique_constraints_reflect_as_indexZ*reflect_indexes_with_ascdesc_as_expressionr3   rs  r,   rù   )r]   r  r†  r‡  r�  rt  Zfk_reqZdup_reqZsorting_expressionrâ   Úorigr9   rŒ  r:   rž   î  s4    ÿ
ÿÿû
ÿ
z0ComponentReflectionTest.exp_indexes.<locals>.idxr_  r`  ra  r‚   rE   rE  rÑ   r  r  r  T)r]   r�  r  r
  r  r5  r4  )r]   r  r  )r]   r  r‡  r  r  r  r  r  r  r  r$  r-  r/  r0  r1  r2  r3  r6  r7  r9  )rA  )r]   r†  r8  r:  rš   rC  r]   rB  )r]   r‡  r  )rP  Úextendr,   rù   r\   r   rZ   r   rJ   r?  r3   r@  rO  rN  r^  )
rm   rI   r0   r�   rý   rž   rJ  r‡   r›   râ   r9   r9   r:   Úexp_indexesç  s¢    
ú%ý
ÿÿþýÿþûýÿþÿÿýÿ
ÿÿ
ÿ
üþÖ5ÿþz#ComponentReflectionTest.exp_indexesc                 C   s   h d£S )N>   r¦   r]   r  r9   rË   r9   r9   r:   Ú_required_index_keys\  s    z,ComponentReflectionTest._required_index_keysFc                 C   s.  d dd dœdd„}|dfg i}|dfg |dfg |dfg i}|   ||¡ |d	fg |d
ddddd�¢|dfg |dtjtjd�¢|dddddd�¢|dfg |dfg |dfg |dfg |dfg |dfg |dfg |dfg ||  ¡ fg |dd tj› �d!�¢i}	|�ri |¥|¥|	¥S |  ||	||¡}
|  ||||
¡}
|
S d S )"NF)Úduplicates_indexÚis_indexrÃ   c                 W   s8   t jj}|r|jsdS t|ƒ| |dœ}|r2||d< |gS )Nr9   )r¦   r]   rÃ   r’  )r   rJ   Z*unique_index_reflect_as_unique_constraintsr3   rs  )r]   r’  r“  rÃ   rt  Úreqrâ   r9   r9   r:   Úuch  s    
ýz+ComponentReflectionTest.exp_ucs.<locals>.ucr_  r`  ra  r‚   r  r  r
  r4  T)r]   r’  r“  r  rE   )r]   r’  r  r  r  r  )r]   r’  rÃ   r  r$  r-  r/  r1  r3  r6  r8  r]   rB  rÑ   )rP  r,   rù   r\   r   rZ   rN  r^  )rm   rI   r0   r�   rý   Úall_r•  rJ  r‡   r›   râ   r9   r9   r:   Úexp_ucs`  sZ    	ÿýûÿ	ÿûþ
ÿä zComponentReflectionTest.exp_ucsc                 C   s   ddhS )Nr]   r¦   r9   rË   r9   r9   r:   Ú_required_unique_cst_keys¥  s    z1ComponentReflectionTest._required_unique_cst_keysc           
         sö   G dd„ dt ƒ‰ d‡ fdd„	}|dfg i}|dfg |dfg |dfg i}|  ||¡ |d	f|d
tjƒ|dddd�g|df|ddd�g|dfg |dfg |dfg |dfg |dfg |dfg |dfg |dfg ||  ¡ fg i}|  ||||¡}	|  ||||	¡}	|	S )Nc                   @   s   e Zd Zdd„ ZdS )z+ComponentReflectionTest.exp_ccs.<locals>.ttc                 S   s(   |  ¡  dd¡ dd¡ dd¡}| |v S )Nú(r  ú)ú`)ÚlowerÚreplace)rm   r¯   râ   r9   r9   r:   rz  ±  s    ÿþýÿz2ComponentReflectionTest.exp_ccs.<locals>.tt.__eq__Nr{  r9   r9   r9   r:   rŽ   °  s   rŽ   c                    s   ˆ | ƒ||dœS )N)Úsqltextr]   rÃ   r9   )rd  r]   rÃ   r€  r9   r:   Úccº  s    z+ComponentReflectionTest.exp_ccs.<locals>.ccr_  r`  ra  r‚   r  r  r  r  r  rÂ   r  z$address_id > 0 and address_id < 1000r  rÑ   r  r$  r-  r/  r1  r3  r6  r8  )N)ÚstrrP  r,   rù   r\   rN  r^  )
rm   rI   r0   r�   rý   rŸ  rJ  r‡   r›   râ   r9   r€  r:   Úexp_ccs©  sF    
ý
ýþþÿézComponentReflectionTest.exp_ccsc                 C   s   ddhS )Nr]   rž  r9   rË   r9   r9   r:   Ú_required_cc_keysã  s    z)ComponentReflectionTest._required_cc_keysc                 C   s    t |ƒ}ttjj| ¡ v ƒ d S r   )r   r+   r   r   rL   Úget_schema_namesr|   r9   r9   r:   Útest_get_schema_namesç  s    z-ComponentReflectionTest.test_get_schema_namesc                 C   s,   t |ƒ}t| tjj¡ƒ t| d¡ƒ d S )NÚsa_fake_schema_foo)r   r+   Ú
has_schemar   r   rL   r)   r|   r9   r9   r:   Útest_has_schemaí  s    z'ComponentReflectionTest.test_has_schemac                 C   s8   |j ddttjjid�}t|ƒ}ttjj| ¡ v ƒ dS )z
test #7300rš   Úbar©Zschema_translate_mapN)Úexecution_optionsr&   r   r   rL   r   r+   r£  r|   r9   r9   r:   Ú%test_get_schema_names_w_translate_mapô  s    þÿz=ComponentReflectionTest.test_get_schema_names_w_translate_mapc                 C   sD   |j ddttjjid�}t|ƒ}t| tjj¡ƒ t| d¡ƒ d S )Nrš   r¨  r©  r¥  )	rª  r&   r   r   rL   r   r+   r¦  r)   r|   r9   r9   r:   Útest_has_schema_w_translate_map  s    þÿz7ComponentReflectionTest.test_has_schema_w_translate_mapc              
   C   s    t |ƒ}td| ¡ v ƒ t| d¡ƒ | tdƒ¡ zVtd| ¡ v ƒ t| d¡ƒ | ¡  td| ¡ v ƒ t| d¡ƒ W | tdƒ¡ n| tdƒ¡ 0 d S )NZfoo_barzCREATE SCHEMA foo_barzDROP SCHEMA foo_bar)r   r)   r£  r¦  Úexecuter#   rr   r+   r|   r9   r9   r:   Útest_schema_cache  s    z)ComponentReflectionTest.test_schema_cachec                 C   s$   t  ¡ }t|ƒ t|jdƒs J ‚d S )Nr>  )r   r5   r   Úhasattrrj   )rm   Úenginer9   r9   r:   Útest_dialect_initialize   s    z/ComponentReflectionTest.test_dialect_initializec                 C   s   t |ƒ}t|j|jjƒ d S r   )r   r   r>  rj   r|   r9   r9   r:   Útest_get_default_schema_name&  s    z4ComponentReflectionTest.test_get_default_schema_nameÚforeign_keyÚorder_byr‘   Ú
use_schemac           	         sŒ   |rt j}nd }h d£‰ t|ƒ}|r:dd„ | |¡D ƒ}n
| |¡}‡ fdd„|D ƒ}|dkrrg d¢}t||ƒ ng d¢}tt|ƒ|ƒ d S )N>   r/  r3  r$  r1  r6  r-  r8  c                 S   s   g | ]}|d  r|d  ‘qS )r   r9   ©rU  Úrecr9   r9   r:   r�  F  s   þz@ComponentReflectionTest.test_get_table_names.<locals>.<listcomp>c                    s   g | ]}|ˆ vr|‘qS r9   r9   ©rU  Út©Z_ignore_tablesr9   r:   r�  M  r˜   r³  rD  )r  r  r  )r   rL   r   Zget_sorted_table_and_fkc_namesÚget_table_namesr   Úsorted)	rm   r}   r´  rµ  rI   rt   r›   r©   Úanswerr9   rº  r:   Útest_get_table_names+  s     	
þ
z,ComponentReflectionTest.test_get_table_namesc                 C   sl   t |ƒ}|rtj}nd }| |¡}tjjjrRtt	|ƒddgƒ t| 
|¡dgƒ ng d¢}tt	|ƒ|ƒ d S )Nr`  ra  r_  )r_  r`  ra  )r   r   rL   Úget_view_namesr   rJ   rG  r3   r   r¼  Úget_materialized_view_names)rm   r}   rµ  rt   rI   r©   r½  r9   r9   r:   Útest_get_view_namesV  s    

z+ComponentReflectionTest.test_get_view_namesc                 C   s,   t |ƒ}| ¡ }tt|ƒdtj› �gƒ d S rX   )r   Zget_temp_table_namesr   r¼  r   rZ   ©rm   r}   rt   r[  r9   r9   r:   Útest_get_temp_table_namesg  s    z1ComponentReflectionTest.test_get_temp_table_namesc                 C   s$   t |ƒ}| ¡ }tt|ƒdgƒ d S r�   )r   Zget_temp_view_namesr   r¼  rÂ  r9   r9   r:   Útest_get_temp_view_namesm  s    z0ComponentReflectionTest.test_get_temp_view_namesc                 C   s   |   |¡ d S r   )Ú_test_get_comments©rm   r}   r9   r9   r:   Útest_get_commentst  s    z)ComponentReflectionTest.test_get_commentsc                 C   s   |   |tjj¡ d S r   )rÅ  r   r   rL   rÆ  r9   r9   r:   Útest_get_comments_with_schemax  s    z5ComponentReflectionTest.test_get_comments_with_schemac                 C   s’   t |ƒ}| j|d�}t|jd|d�||df ƒ t|jd|d�||df ƒ t|jd|d�||df ƒ | jjj}t|j||d�|||f ƒ d S )NrH   r$  r  )r   rf  r   rð   r›   r-  r]   )rm   r}   rI   rt   ÚexpÚno_cstr9   r9   r:   rÅ  }  s&    
þ
þ
þ

þz*ComponentReflectionTest._test_get_comments)FFzuse_views,use_schemac                 C   sj  |rt j}nd }| jj| jj }}|r0g d¢}nddg}t|ƒ}t|||fƒD �]\}	}
|}|j|	|d�}t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	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 )N©ra  r`  r_  r  r  rH   r   r]   rh  rF  z%s(%s), %s(%s)ri  )"r   rL   r›   r  r  r   Úzipr¾   r+   ÚlenÚ	enumerateÚcolumnsr   r]   Ú	__class__rh  rà   r`   r   Z
TypeEnginer   rI  Ú	sql_typesÚDater   rH  Ú__mro__Úintersectionr   ÚNumericZTimer   Z_BinaryrD   )rm   r}   Z	use_viewsrµ  rI   r  Ú	addressesr©   rt   rf   ÚtableZschema_namert  Úirp   ÚctypeZ	ctype_defr9   r9   r:   rç   •  s\    
þ
ÿùýÿñÿïz(ComponentReflectionTest.test_get_columnsc                 C   s6   |   ¡ }| j| }t|tƒ |d�}| j||dd� d S )Nr²   F)Zstrict_constraints)r\   r›   r   r   Zassert_tables_equal)rm   r}   rf   rg   Zreflected_user_tmpr9   r9   r:   Útest_reflect_table_temp_tableá  s    
ÿÿz5ComponentReflectionTest.test_reflect_table_temp_tablec                 C   sf   |   ¡ }| j| }t|ƒ}| |¡}tt|ƒdkt|ƒƒ t|jƒD ]\}}t|j	|| d ƒ qDd S )Nr   r]   )
r\   r›   r   r¾   r+   rÍ  rÎ  rÏ  r   r]   )rm   r}   rf   rg   rt   rt  rØ  rp   r9   r9   r:   Útest_get_temp_table_columnsí  s    

z3ComponentReflectionTest.test_get_temp_table_columnsc                 C   s.   t |ƒ}| d¡}tdd„ |D ƒg d¢ƒ d S )Nr‚   c                 S   s   g | ]}|d  ‘qS rÑ   r9   ©rU  rp   r9   r9   r:   r�  þ  r˜   zFComponentReflectionTest.test_get_temp_view_columns.<locals>.<listcomp>)rB   r]   rš   )r   r¾   r   )rm   r}   rt   rt  r9   r9   r:   Útest_get_temp_view_columnsø  s    
z2ComponentReflectionTest.test_get_temp_view_columns)Fc                 C   s  |rt jj}nd }| jj| jj }}t|ƒ}| j|d�}|j|j	|d�}|  
|g|||j	f g| j¡ |j|j	|d�}	|||j	f d }
t|	d |
ƒ t jj ¡ � t|	d dƒ W d   ƒ n1 sÆ0    Y  | jjj	}|  
|j||d�g|||f g| j¡ d S )NrH   rr  r]   r"  )r   r   rL   r›   r  r  r   rw  rè   r]   Ú_check_listrx  r   rJ   ru  Úfail_ifr-  )rm   r}   rµ  rI   r  rÖ  rt   rÉ  Z
users_consZ	addr_consZexp_colsrÊ  r9   r9   r:   ré      s*    
ÿ,
ýz.ComponentReflectionTest.test_get_pk_constraintZPK_test_tableZpk_test_tableZmixedCasePKzpk.with.dotsÚpk_namec              	   C   sh   t d|tdtƒtdtdƒƒtjd|d�ƒ | |¡ t|ƒ}| d¡}t	|d |ƒ t	|d dgƒ dS )	zZTest that primary key constraint names with various casing are
        properly reflected.rA   rB   rE   rF   rÑ   r]   rr  N)
r   r   r   r   r`   rÕ   r¶   r   rè   r   )rm   r}   rR   rà  rt   Zpk_consr9   r9   r:   Ú"test_get_pk_constraint_quoted_name!  s    û

z:ComponentReflectionTest.test_get_pk_constraint_quoted_namec                 C   s~  |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|	d	 d
gƒ |j
|j|d�}
|
d }	tjj ¡ �  t|	d d uƒ W d   ƒ n1 �s0    Y  t|	d |ƒ t|	d |jƒ t|	d dgƒ t|	d	 dgƒ | jjj}t|j
||d�g ƒ d S )NrH   r   r]   r  r}  r~  r|  r  rr  r  r  )r   rL   r›   r  r  r   r   rJ   r;  r3   rê   r]   r‚  rß  r   Úimplicitly_named_constraintsr+   r-  )rm   r}   rµ  rI   r  rÖ  rt   Zexpected_schemaZusers_fkeysÚfkey1Z
addr_fkeysrÊ  r9   r9   r:   rë   @  s2    
,0
z-ComponentReflectionTest.test_get_foreign_keysZFK_users_idZfk_users_idZmixedCaseNamezfk.with.dotsÚfk_namec              
   C   sì   t d|tdtdd�dd� t d|tdtdd�tdtƒtjdgdg|d	�dd� | |¡ t|ƒ}| d¡}tt	|ƒd
ƒ |d }t
jj ¡ � t|d |ƒ W d  ƒ n1 s°0    Y  t|d dƒ t|d dgƒ t|d dgƒ dS )zZTest that foreign key constraint names with various casing are
        properly reflected.Z	users_refr  TrC   r¬   Zuser_ordersZorder_idzusers_ref.user_idrÑ   r´   r   r]   Nr~  r|  rr  )r   r   r   r`   rµ   r¶   r   rê   r   rÍ  r   rJ   r‚  rß  )rm   r}   rR   rä  rt   ZfkeysZfkeyr9   r9   r:   Ú!test_get_foreign_keys_quoted_namej  s8    üýö

,z9ComponentReflectionTest.test_get_foreign_keys_quoted_namec           
      C   s  |   d|jj dtjj dtjj ¡\}}}t|ƒ}| |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 }	t|	d d |jjfv ƒ t	|	d |jƒ t	|	d d	gƒ t	|	d
 dgƒ d S )Nz%s.local_tablez%s.remote_tablez%s.remote_table_2r´   r   r}  r~  r|  rB   rr  r0  rH   r2  )r›   rj   r>  r   r   rL   r   rê   r]   r   rÍ  r+   )
rm   r}   r/  r1  r3  rt   Zlocal_fkeysrã  Zremote_fkeysZfkey2r9   r9   r:   Ú"test_get_inter_schema_foreign_keys™  s8    


ý

ÿþÿÿz:ComponentReflectionTest.test_get_inter_schema_foreign_keysc                 C   sz   |rt j}nd }t|ƒ}|jd|d�}| j|d�}|  |||df | j¡ | jjj	}|  |j||d�|||f | j¡ d S )Nr  rH   )
r   rL   r   rì   r�  rÞ  r‘  r›   r-  r]   )rm   r}   rµ  rI   rt   ÚindexesrÉ  rÊ  r9   r9   r:   rí   ¿  s    ÿ

ýz(ComponentReflectionTest.test_get_indexes)r6  r9  )r8  r:  ztname,ixnamec                 C   s‚   t |ƒ}| |¡}|  ¡ d |f }|  ||| j¡ t|tƒ |d�}tt|j	ƒdƒ t
t|j	ƒd j|ƒ tt|j	ƒd j|ƒ d S )Nr²   r´   r   )r   rì   r�  rÞ  r‘  r   r   r   rÍ  rç  r   rs  r×  r]   )rm   r}   ÚtnameZixnamert   rç  Zexpected_indexesr¹  r9   r9   r:   Útest_get_noncol_indexÙ  s    	
z-ComponentReflectionTest.test_get_noncol_indexZIX_test_dataZix_test_dataZmixedCaseIndexzix.with.dotsÚidx_namec           	         s®   t d|tdtdd�tdtdƒƒƒ}tˆ |jjƒ | |¡ t|ƒ}| 	d¡}dd„ |D ƒ}ˆ |v svJ d	ˆ › d
|› �ƒ‚‡ fdd„|D ƒ}t
t|ƒdƒ t
|d d dgƒ dS )zATest that index names with various casing are properly reflected.rA   rB   TrC   rE   rF   c                 S   s   g | ]}|d  ‘qS rÑ   r9   ©rU  rž   r9   r9   r:   r�    r˜   zHComponentReflectionTest.test_get_indexes_quoted_name.<locals>.<listcomp>z	Expected ú in c                    s   g | ]}|d  ˆ kr|‘qS rÑ   r9   rë  ©rê  r9   r:   r�    r˜   r´   r   r¦   N)r   r   r   r   r$   r�   rE   r¶   r   rì   r   rÍ  )	rm   r}   rR   rê  r¹  rt   rç  Zindex_namesZmatching_idxr9   rí  r:   Útest_get_indexes_quoted_nameï  s    ü

z4ComponentReflectionTest.test_get_indexes_quoted_namec                 C   sB   t |ƒ}|  ¡ }| |¡}| jdd�d |f }|  ||| j¡ d S )NT)r–  )r   r\   rî   r—  rÞ  r‘  )rm   r}   rt   r]   Ú	reflectedrÉ  r9   r9   r:   Ú&test_get_temp_table_unique_constraints  s
    
z>ComponentReflectionTest.test_get_temp_table_unique_constraintsc                 C   sn   t |ƒ}|  ¡ }| |¡}|D ]}| dd ¡ qddgddœg}tjjjrVg |d d< tdd	„ |D ƒ|ƒ d S )
Nrˆ  Frš   rC  )r  r¦   r]   r   r‰  c                 S   s   g | ]}|d  dkr|‘qS )r]   rC  r9   rë  r9   r9   r:   r�  %  r˜   zGComponentReflectionTest.test_get_temp_table_indexes.<locals>.<listcomp>)	r   r\   rì   rk  r   rJ   Úindex_reflects_included_columnsr3   r   )rm   r}   rt   rf   rç  ÚindÚexpectedr9   r9   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t|ƒt|	ƒƒ t||	ƒD ]N\}}| dd ¡}|�rP|
 |¡ t| dd ¡d ƒ | dd ¡ t||ƒ �q,tƒ }td|||d�}	dd„ |	jD ƒ}dd„ |	jD ƒ dg¡}| |¡�rÊJ ‚|
�ræt|
|ƒ t|tƒ ƒ | jjj}t|j||d�g ƒ d S )NZunique_ar”   )r]   r¦   Zunique_a_b_c)r”   Úbr�   Zunique_c_a_b)r�   r”   rõ  Zunique_asc_keyZascr«   zi.have.dotsrõ  zi have spacesr�   r]   ©r«   Ztesttblr   r  rH   r¦   r’  rÃ   rˆ  )r³   rI   c                 S   s   h | ]
}|j ’qS r9   rÑ   rë  r9   r9   r:   Ú	<setcomp>v  r˜   zFComponentReflectionTest.test_get_unique_constraints.<locals>.<setcomp>c                 S   s   h | ]}t |tjƒr|j’qS r9   )rà   r`   rÖ   r]   )rU  Zuqr9   r9   r:   r÷  w  s   þ)r   rL   r¼  ÚoperatorÚ
itemgetterr   r   r`   r   r   Zappend_constraintrÖ   rq   r   rî   rH  r   rÍ  rÌ  rk  rZ  r   rç  ÚconstraintsÚ
differencerÔ  r›   r-  r]   )rm   rR   r}   rµ  rI   Zuniquesr×  r•  rt   rï  Znames_that_duplicate_indexrŽ  ZreflZdupeZreflected_metadataZ	idx_namesZuq_namesrÊ  r9   r9   r:   rï   )  sz    


ú÷
÷ÿ
þ
üþü

z3ComponentReflectionTest.test_get_unique_constraintsZUQ_emailZuq_emailZmixedCaseUQzuq.with.dotsÚuq_namec              	   C   s‚   t d|tdtdd�tdtdƒƒtjd|d�ƒ | |¡ t|ƒ}| d¡}t	t
|ƒdƒ t	|d	 d
 |ƒ t	|d	 d dgƒ dS )zUTest that unique constraint names with various casing are
        properly reflected.rA   rB   TrC   ÚemailrF   rÑ   r´   r   r]   r¦   N)r   r   r   r   r`   rÖ   r¶   r   rî   r   rÍ  )rm   r}   rR   rü  rt   Zuq_consr9   r9   r:   Ú'test_get_unique_constraints_quoted_name…  s    û

z?ComponentReflectionTest.test_get_unique_constraints_quoted_namec                 C   s@   |rt j}nd }t|ƒ}dD ]}|j||d�}tt|ƒƒ qd S )NrË  rH   )r   rL   r   rä   r+   Úbool)rm   r}   rµ  rI   rt   ÚviewrV  r9   r9   r:   ræ   ¤  s    z0ComponentReflectionTest.test_get_view_definitionc                 C   sp   t |ƒ}ttƒ� | d¡ W d   ƒ n1 s00    Y  ttƒ� | d¡ W d   ƒ n1 sb0    Y  d S )NZview_does_not_existr  )r   r   r!   rä   r|   r9   r9   r:   Ú'test_get_view_definition_does_not_exist²  s
    
(
z?ComponentReflectionTest.test_get_view_definition_does_not_existc                 C   sF   t |ƒ}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Ñ   r9   r‹  r9   r9   r:   rY  Ð  r˜   zBComponentReflectionTest.test_autoincrement_col.<locals>.<dictcomp>rg  TN)r   r¾   Úget)rm   r}   rt   rè  Úcnamert  Zid_r9   r9   r:   Útest_autoincrement_colº  s
    
z.ComponentReflectionTest.test_autoincrement_colc                 C   s–   t tjƒ}|rtjnd }tjjjr\|jd|d�}t	t
|tƒƒ |jd|d�}t	t
|tƒƒ n6ttƒ� |jd|d� W d   ƒ n1 sˆ0    Y  d S )Nr  rH   r-  )r   r   r7   rL   r   rJ   rÞ   r3   rß   r+   rà   r6   r   rá   )rm   rµ  rt   rI   râ   r9   r9   r:   rã   Ó  s    


z.ComponentReflectionTest.test_get_table_optionsc                    sŠ   t tjƒ‰ tjjjrV|rtjnd ‰ˆ jˆd�}‡ ‡fdd„ˆ j	ˆd�D ƒ}t
||ƒ n0ttƒ� ˆ  ¡  W d   ƒ n1 s|0    Y  d S )NrH   c                    s    i | ]}ˆ|fˆ j |ˆd �“qS )rH   )rß   )rU  r×  ©rt   rI   r9   r:   rY  ë  s   ÿzHComponentReflectionTest.test_multi_get_table_options.<locals>.<dictcomp>)r   r   r7   r   rJ   rÞ   r3   rL   Úget_multi_table_optionsr»  r   r   rá   )rm   rµ  râ   rÉ  r9   r  r:   Útest_multi_get_table_optionsä  s    


þ
z4ComponentReflectionTest.test_multi_get_table_optionsc                    s   ‡ fdd„}|S )Nc                    s   t ˆ ƒ}||dƒ ||dœ}| r&| ƒ } g }tj|v rB| g d¢¡ tj|v rZ| ddg¡ tj|v rr| ddg¡ | r~| |d< |rŠ||d< || ||| d¡d	�}	|g}
|tjkrÌ| 	¡ }| 
d
¡ |
 |¡ |tjkrò| 	¡ }| 
d¡ |
 |¡ t ˆ ƒ|
|	fS )Nr  )r0   r�   )r$  r  údoes-not-existr`  r  r_  rI   rý   )rI   r0   r�   rý   r0   r�   )r   r   rú   r�  rû   rü   r  r    r÷   Úcopyrk  Úappend)rI   r0   r�   rö   Zsingle_reflect_fnZ
exp_methodrt   re   rý   rÉ  ÚkwsZnkw©r}   r9   r:   Úprovide_fixtureö  sD    


ÿ

ü





z>ComponentReflectionTest.get_multi_exp.<locals>.provide_fixturer9   )rm   r}   r  r9   r  r:   Úget_multi_expô  s    .z%ComponentReflectionTest.get_multi_expc                 C   sL   |||||t j| jƒ\}}}|D ]&}	| ¡  |jf i |	¤Ž}
t|
|ƒ q d S r   )r   rß   rc  rr   r  r   ©rm   r  rI   r0   r�   rö   rt   r  rÉ  re   Úresultr9   r9   r:   Ú#test_multi_get_table_options_tables&	  s    ú
z;ComponentReflectionTest.test_multi_get_table_options_tablesc           
      C   sH   |||||t j| jƒ\}}}|D ]"}	| ¡  t|jf i |	¤Ž|ƒ q d S r   )r   rð   rf  rr   r   Zget_multi_table_comment)
rm   r  rI   r0   r�   rö   rt   r  rÉ  re   r9   r9   r:   Útest_get_multi_table_comment8	  s    ú
z4ComponentReflectionTest.test_get_multi_table_commentc                    sV   t dœdd„‰ t|tƒr8t‡ fdd„| ¡ D ƒ||ƒ nt‡ fdd„|D ƒ||ƒ d S )N©rd  c                 S   s   t  dd| ¡ ¡ S )Nz['\" ]r  )ÚreÚsubrœ  r  r9   r9   r:   Ú_cleanJ	  s    z:ComponentReflectionTest._check_expressions.<locals>._cleanc                    s   i | ]\}}ˆ |ƒ|“qS r9   r9   )rU  ÚerV  ©r  r9   r:   rY  N	  r˜   z>ComponentReflectionTest._check_expressions.<locals>.<dictcomp>c                    s   g | ]}ˆ |ƒ‘qS r9   r9   )rU  r  r  r9   r:   r�  P	  r˜   z>ComponentReflectionTest._check_expressions.<locals>.<listcomp>)r   rà   r6   r   r\  )rm   r  rÉ  Úerr_msgr9   r  r:   Ú_check_expressionsI	  s    
 z*ComponentReflectionTest._check_expressionsc           	      C   s¸   |d u rt |||ƒ nžt t|ƒt|ƒ|ƒ t||ƒD ]~\}}t|ƒt|ƒB D ]d}||v sh||v rL||v rL|› d|› d|› �}|dv rœ|  || || |¡ qLt || || |ƒ qLq4d S )Nz - )rŠ  r†  )r   rÍ  rÌ  rH  r  )	rm   r  rÉ  Úreq_keysÚmsgÚrr  r•   r  r9   r9   r:   rÞ  R	  s    z#ComponentReflectionTest._check_listc                 C   s\   t t| ¡ ƒt| ¡ ƒƒ |D ]8}|| ||  }}|rF|g|g }}|  ||||¡ qd S r   )r   rH  ÚkeysrÞ  )rm   r  rÉ  r  Ú
make_listsr•   r  r  r9   r9   r:   Ú_check_table_dict`	  s    z)ComponentReflectionTest._check_table_dictc                 C   sR   |||||t j| jƒ\}}}|D ],}	| ¡  |jf i |	¤Ž}
|  |
|| j¡ q d S r   )r   r¾   rp  rr   Úget_multi_columnsr   rq  r  r9   r9   r:   Útest_get_multi_columnsh	  s    ú
	z.ComponentReflectionTest.test_get_multi_columnsc                 C   sV   |||||t j| jƒ\}}}|D ]0}	| ¡  |jf i |	¤Ž}
| j|
|| jdd� q d S )NT)r  )r   rè   rw  rr   Zget_multi_pk_constraintr   rx  r  r9   r9   r:   Útest_get_multi_pk_constraintz	  s    ú

ÿz4ComponentReflectionTest.test_get_multi_pk_constraintc                 C   sT   t jjjsP||fD ]<}| ¡ D ].}t|ƒdkrtdd„ |D ƒƒr|j|d� qqd S )Nr´   c                 s   s"   | ]}|  d ¡dtjfv V  qdS )r]   N)r  r,   rù   )rU  rV  r9   r9   r:   Ú	<genexpr>’	  s   z7ComponentReflectionTest._adjust_sort.<locals>.<genexpr>rö  )r   rJ   râ  r3   r]  rÍ  ÚanyÚsort)rm   r  ró  r«   Úobjrv  r9   r9   r:   Ú_adjust_sortŽ	  s    
ÿz$ComponentReflectionTest._adjust_sortc                 C   sd   |||||t j| jƒ\}}}|D ]>}	| ¡  |jf i |	¤Ž}
|  |
|dd„ ¡ |  |
|| j¡ q d S )Nc                 S   s   t | d ƒS )Nrr  ©Útuple©Údr9   r9   r:   r—   ¨	  r˜   zEComponentReflectionTest.test_get_multi_foreign_keys.<locals>.<lambda>)r   rê   r„  rr   Zget_multi_foreign_keysr(  r   r…  r  r9   r9   r:   Útest_get_multi_foreign_keys—	  s    ú

ÿz3ComponentReflectionTest.test_get_multi_foreign_keysc                 C   sR   |||||t j| jƒ\}}}|D ],}	| ¡  |jf i |	¤Ž}
|  |
|| j¡ q d S r   )r   rì   r�  rr   Zget_multi_indexesr   r‘  r  r9   r9   r:   Útest_get_multi_indexes¬	  s    ú
z.ComponentReflectionTest.test_get_multi_indexesc                 C   sd   |||||t j| jƒ\}}}|D ]>}	| ¡  |jf i |	¤Ž}
|  |
|dd„ ¡ |  |
|| j¡ q d S )Nc                 S   s   t | d ƒS )Nr¦   r)  r+  r9   r9   r:   r—   Î	  r˜   zKComponentReflectionTest.test_get_multi_unique_constraints.<locals>.<lambda>)r   rî   r—  rr   Zget_multi_unique_constraintsr(  r   r˜  r  r9   r9   r:   Ú!test_get_multi_unique_constraints¾	  s    ú
z9ComponentReflectionTest.test_get_multi_unique_constraintsc                 C   sd   |||||t j| jƒ\}}}|D ]>}	| ¡  |jf i |	¤Ž}
|  |
|dd„ ¡ |  |
|| j¡ q d S )Nc                 S   s   t | d ƒS ©Nrž  r)  r+  r9   r9   r:   r—   á	  r˜   zJComponentReflectionTest.test_get_multi_check_constraints.<locals>.<lambda>)r   rò   r¡  rr   Zget_multi_check_constraintsr(  r   r¢  r  r9   r9   r:   Ú test_get_multi_check_constraintsÑ	  s    ú
z8ComponentReflectionTest.test_get_multi_check_constraintsrß   r¾   rè   rê   rì   rî   rò   rð   Úmethodc                 C   sF   t |ƒ}t||ƒ}ttƒ� |dƒ W d   ƒ n1 s80    Y  d S )NZtable_does_not_exists)r   Úgetattrr   r!   )rm   r2  r}   rt   r�   r9   r9   r:   Útest_not_existing_tableä	  s    

z/ComponentReflectionTest.test_not_existing_tablec              	      sˆ   t j‰ ‡ fdd„}tj t d|¡�R ttdƒ�( t|ƒ t	dt
ƒ ƒd ¡ W d   ƒ n1 s\0    Y  W d   ƒ n1 sz0    Y  d S )Nc                     s&   |  di ¡}tdƒ|d< ˆ | i |¤ŽS )NZunreflectableÚerr)NÚ
some_table)Ú
setdefaultr"   )r”   r•   Úur©Zmcr9   r:   Úpatched
  s    z;ComponentReflectionTest.test_unreflectable.<locals>.patchedr!  r5  r6  )r   r!  r,   ÚpatchÚobjectr   r"   r   Zreflect_tabler   r   )rm   r}   r:  r9   r9  r:   Útest_unreflectable
  s    ÿz*ComponentReflectionTest.test_unreflectabler‡   c                    sž   t ƒ }|rtjnd ‰ |j|ˆ |dd� t|ƒ}| ˆ ¡}|rp|| ˆ ¡7 }z|| ˆ ¡7 }W n tyn   Y n0 ˆ r†‡ fdd„|D ƒ}t	t
|jƒt
|ƒƒ d S )NF)rI   r‡   Zresolve_fksc                    s   g | ]}ˆ › d |› �‘qS )r  r9   r¸  rH   r9   r:   r�  !
  r˜   z9ComponentReflectionTest.test_metadata.<locals>.<listcomp>)r   r   rL   Úreflectr   r»  r¿  rÀ  rá   r   r¼  r›   )rm   r}   rµ  r‡   Úmrt   r›   r9   rH   r:   Útest_metadata
  s    
z%ComponentReflectionTest.test_metadatac              	   C   s€   t d|tdtdd�tdtdd�dd� | |¡ t|ƒ}| d¡}t|ddiƒ | d¡}d	d
„ |D ƒ}dddœ}t||ƒ d S )NÚunicode_commentsÚunicodeu   Ã©è©¦è›‡áºŸÎ©rÂ   Úemojiu	   â˜�ï¸�âœ¨u   è©¦è›‡áºŸÎ©âœ¨rd  c                 S   s   i | ]}|d  |d “qS r  r9   r‹  r9   r9   r:   rY  5
  r˜   zAComponentReflectionTest.test_comments_unicode.<locals>.<dictcomp>)rB  rC  ©r   r   r   r¶   r   rð   r   r¾   )rm   r}   rR   rt   Útcrt  ÚvaluerÉ  r9   r9   r:   Útest_comments_unicode$
  s    û



z-ComponentReflectionTest.test_comments_unicodec                 C   sp   t d|tdtdd�dd� | |¡ t|ƒ}| d¡}t|ddiƒ | d¡d }t|d |d	 iddiƒ d S )
NrA  rC  u&   ðŸ��ðŸ§™ðŸ��ðŸ§™â€�â™‚ï¸�ðŸ§™â€�â™€ï¸�rÂ   u&   ðŸŽ©ðŸ�°ðŸ�‘ðŸ¤·â€�â™€ï¸�ðŸ¤·â€�â™‚ï¸�rd  r   r]   rÃ   rD  )rm   r}   rR   rt   rE  r�   r9   r9   r:   Útest_comments_unicode_full9
  s    ü

z2ComponentReflectionTest.test_comments_unicode_fullc           	      C   sª   t j t¡}td|tdtj|d�ƒtdt ¡ ƒƒ | |¡ t	ƒ }td||d�}t
|jjjj|ƒ t|jjjjƒ t|ƒ}| d¡\}}t
|d j|ƒ t|d jƒ d S )Nr¹  Úcollated)Ú	collationÚnot_collatedr²   rh  )r   rJ   Zget_order_by_collationr   r   r   r`   r   r¶   r   r   r�   rI  rh  rJ  r*   rK  r   r¾   )	rm   r}   rR   rJ  r¸   Út2rt   rI  rK  r9   r9   r:   Ú test_column_collation_reflectionJ
  s     ü
z8ComponentReflectionTest.test_column_collation_reflection)N)NN)NF)ur<   r=   r>   Úrun_insertsr†   r…   r?   rS   r   r\   rP   rN   rN  rP  r^  r    rù   r   rc  rf  rp  Úpropertyrq  rw  rx  r„  r…  r�  r‘  r—  r˜  r¡  r¢  r   rJ   Zschema_reflectionr¤  r§  r«  r¬  Zschema_create_deleter®  r±  r²  r¢   rÆ   rK   r¾  rÁ  r[  rÃ  rM   rc   rÄ  rÈ   rÇ  rÈ  rÅ  rç   rÊ   rÚ  rÛ  rÙ   rÝ  Ú!primary_key_constraint_reflectionré   ru  rá  rë   rå  r=  ræ  r‰   rí   r?  r@  ré  rî  rô   rð  Ztemp_table_reflect_indexesrô  rï   rþ  ræ   r  Útable_reflectionr  rã   r  rÍ   r  rÞ   rþ   r  r  r  rÞ  r   r"  r#  r(  r-  r.  r/  rõ   r1  r4  r=  r‡   r@  rG  Zcomment_reflection_full_unicoderH  Zcolumn_collation_reflectionZorder_by_collationrM  r9   r9   r9   r:   rÿ   q  s,  

 .

!

-û
!û
&û
`
û
0
û
X
û
u
ú
E
û
:







ýÿ#ÿ



ý÷
A


ÿûÿ&û'$ÿýû
ÿXûÿ


ÿ


1	


	
þþ
þþ
ë
ÿ

rÿ   c                   @   sh   e Zd ZdZdZejdd„ ƒZejdd„ ƒZdd„ Z	d	d
„ Z
dd„ Zejjdd„ ƒZejjdd„ ƒZdS )ÚTableNoColumnsTest)Zreflect_tables_no_columnsTc                 C   s   t d|ƒ | |¡ d S ©Nre  )r   r¶   ©rm   r}   rR   r9   r9   r:   Útable_no_columnsf
  s    
z#TableNoColumnsTest.table_no_columnsc                 C   s<   t d|ƒ t |dtdƒ¡ t |dtdƒ¡ | |¡ d S )Nre  rT   z*CREATE VIEW empty_v AS SELECT * FROM emptyrU   zDROP VIEW IF EXISTS empty_v)r   r   rV   r#   r¶   rT  r9   r9   r:   Úview_no_columnsk
  s    
ý
ÿz"TableNoColumnsTest.view_no_columnsc                 C   s$   t dtƒ |d�}tt|jƒg ƒ d S )Nre  r²   ©r   r   r   rs  r�   )rm   r}   rU  rL  r9   r9   r:   Útest_reflect_table_no_columns{
  s    z0TableNoColumnsTest.test_reflect_table_no_columnsc                 C   s2   t |ƒ}t| d¡g ƒ | ¡ }t|dg iƒ d S )Nre  rS  )r   r   r¾   r!  )rm   r}   rU  rt   Úmultir9   r9   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 rS  )r   r>  rH  r›   rÔ  )rm   r}   rU  r?  r9   r9   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²   rW  )rm   r}   rV  rL  r9   r9   r:   Útest_reflect_view_no_columnsŠ
  s    z/TableNoColumnsTest.test_reflect_view_no_columnsc                 C   s8   t |ƒ}t| d¡g ƒ |jtjd�}t|dg iƒ d S )Nr\  )r�   )Nr\  )r   r   r¾   r!  r   rû   )rm   r}   rV  rt   rY  r9   r9   r:   Ú test_get_columns_view_no_columns�
  s    z3TableNoColumnsTest.test_get_columns_view_no_columnsN)r<   r=   r>   r¡   r…   r   rÍ   rU  rV  rX  rZ  r[  rJ   r‡   r]  r^  r9   r9   r9   r:   rR  b
  s   


rR  c                   @   sd  e Zd ZdZejddgd�dd„ ƒZe ¡ dd„ ƒZdd	„ Zej	j
d
d„ ƒZej	jejddddd�dd„ ƒƒZej	j
ejddddd�dd„ ƒƒZej	jdd„ ƒZdd„ Zej	j
ejdddddd d!d�d"d#„ ƒƒZ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ejejejejej ej	j!fej"ej	j!fd.d�d/d0„ ƒƒZ#ej	jd1d2„ ƒZ$ejdd3dej	j%fddd4ej	j&fi dd5ej	j&fi d5dej	j'fddd6ej	j(fdd6dej	j)fd7d�d8d9„ ƒZ*eje+e, -d:¡d;fe+d:d;fe.e, /¡ d<fe+e, -d=¡d>ej	j0fe+e, -d?¡d@ej	j0fe1e2 3¡ dAfe+e, 4dB¡e, 4dC¡ d>ej	j0fdDd�ej	j5dEdF„ ƒƒZ6dS )GÚComponentReflectionTestExtraTF)Úparamsc                 C   s   |j rtjS d S d S r   )Úparamr   rL   )rm   Úrequestr9   r9   r:   Úuse_schema_fixtureš
  s    z/ComponentReflectionTestExtra.use_schema_fixturec                    s   t j‡ ‡‡fdd„ƒ}|S )Nc                 3   s   ˆt ˆ ƒfV  ˆ ˆ ¡ d S r   )r   r¶   )r¨   ©r}   rR   rc  r9   r:   Úgo£
  s    z:ComponentReflectionTestExtra.inspect_for_table.<locals>.go)Ú
contextlibÚcontextmanager)rm   rR   r}   rc  re  r9   rd  r:   Úinspect_for_table¡
  s    z.ComponentReflectionTestExtra.inspect_for_tablec                    sD   dd„ ‰ t ‡ fdd„|D ƒdd„ d�}t |dd„ d�}t||ƒ d S )	Nc                 S   s   d  t d|  ¡ tj¡¡S )Nú zand|\d|=|a|b|c|or|<|>)Újoinr  Úfindallrœ  ÚI)rž  r9   r9   r:   Ú	normalize¯
  s    ÿz5ComponentReflectionTestExtra.ck_eq.<locals>.normalizec                    s"   g | ]}|d  ˆ |d ƒdœ‘qS )r]   rž  ©r]   rž  r9   )rU  Úitem©rm  r9   r:   r�  µ
  s   ÿz6ComponentReflectionTestExtra.ck_eq.<locals>.<listcomp>c                 S   s   | d S r0  r9   ©ro  r9   r9   r:   r—   ¹
  r˜   z4ComponentReflectionTestExtra.ck_eq.<locals>.<lambda>rö  c                 S   s   | d S r0  r9   rq  r9   r9   r:   r—   ¾
  r˜   )r¼  r   )rm   rï  ró  r9   rp  r:   Úck_eq«
  s    
þûþz"ComponentReflectionTestExtra.ck_eqc              	   C   sb   |dƒ�0\}}t d|tdt d¡ƒ|d� W d   ƒ n1 s>0    Y  |  |jd|d�g ¡ d S )Nr-  rE   r   rH   )r   r   r`   r   rr  rò   )rm   rR   rh  rI   r�   r9   r9   r:   Ú#test_check_constraint_no_constraintÂ
  s    ü$þz@ComponentReflectionTestExtra.test_check_constraint_no_constraintÚ	my_inlineZMyInlineNÚconstraint_namer‘   c                 C   s–   |dƒ�R\}}t d|tdtƒ dd�tdtƒ tjd|d�ƒtdtd	ƒƒ|d
� W d   ƒ n1 s`0    Y  |jd|d
�}|  ||p†tj	ddœg¡ d S )NÚsa_ccrB   TrC   r”   úa > 1 AND a < 5rÑ   rE   rF   rH   úa > 1 and a < 5rn  )
r   r   r   r`   r×   r   rò   rr  r,   rù   ©rm   rR   rh  ru  rI   r�   rï  r9   r9   r:   Útest_check_constraint_inlineÑ
  s.    ÿýô$þÿþz9ComponentReflectionTestExtra.test_check_constraint_inlineZmy_ck_constZ	MyCkConstc              	   C   s|   |dƒ�8\}}t d|tdtƒ ƒtjd|d�|d� W d   ƒ n1 sF0    Y  |jd|d�}|  ||pltjddœg¡ d S )Nrv  r”   za = 1 OR (a > 2 AND a < 5)rÑ   rH   za = 1 or a > 2 and a < 5rn  )	r   r   r   r`   r×   rò   rr  r,   rù   ry  r9   r9   r:   Ú test_check_constraint_standaloneõ
  s$    
ÿù$
þÿþz=ComponentReflectionTestExtra.test_check_constraint_standalonec                 C   sâ   |dƒ�’\}}t d|tdtƒ dd�tdtƒ t d¡ƒtdtƒ tjdd	d
�ƒtdtƒ ƒtdtdƒƒtjddd
�tjddd
�tjddd
�|d� W d   ƒ n1 s 0    Y  |jd|d�}|  |dddœd	ddœt	j
ddœg¡ d S )Nrv  rB   TrC   r”   rw  rõ  zb > 1 AND b < 5rt  rÑ   r�   rE   rF   Zsome_uqzc > 1 AND c < 5Zcc1Z	some_c_uqrH   zc > 1 and c < 5rn  zb > 1 and b < 5rx  )r   r   r   r`   r×   r   rÖ   rò   rr  r,   rù   )rm   rR   rh  rI   r�   rï  r9   r9   r:   Útest_check_constraint_mixed  s4    ý
ñ$
ýþz8ComponentReflectionTestExtra.test_check_constraint_mixedc                 C   sH   |D ]}|d |kr|d   S qdsDJ d|›ddd„ |D ƒ› �ƒ‚dS )	z2return the sqltext for the named CHECK constraint.r]   rž  FzNo CHECK constraint named rì  c                 S   s   g | ]}|d  ‘qS rÑ   r9   r¶  r9   r9   r:   r�  <  r˜   z<ComponentReflectionTestExtra._cc_by_name.<locals>.<listcomp>Nr9   )rm   rï  r]   r·  r9   r9   r:   Ú_cc_by_name3  s    ÿÿz(ComponentReflectionTestExtra._cc_by_namez5(x IS NULL OR y IS NULL) AND (x IS NULL OR y IS NULL)za = '(' AND b = ')'za = 'it''s'z((((x > 0))))z((x > 1) AND (x < 5))zx > 0Ú
expressionc           
      C   sD  |dƒ�h\}}t d|tdtƒ dd�tdtƒ ƒtdtƒ ƒtdtdƒƒtd	tdƒƒtj|d
d�|d�	 W d  ƒ n1 sv0    Y  |jd|d�}|  |d
¡}|dƒ�h\}}t d|tdtƒ dd�tdtƒ ƒtdtƒ ƒtdtdƒƒtd	tdƒƒtj|dd�|d�	 W d  ƒ n1 �s0    Y  |jd|d�}|  |d¡}	t||	ƒ dS )aš  Regression test for #13157.

        A CHECK constraint expression must round-trip through reflection
        without its parentheses being incorrectly stripped.  The bug
        greedily paired the leading ``(`` with the trailing ``)`` and
        dropped both, producing an unbalanced, syntactically invalid
        expression such as ``x IS NULL OR y IS NULL) AND (x IS NULL OR
        y IS NULL``.
        rv  rB   TrC   ÚxÚyr”   rF   rõ  Zcc_exprrÑ   rH   NZsa_cc_2Z	cc_expr_2)	r   r   r   r   r`   r×   rò   r}  r   )
rm   rR   rh  r~  rI   r�   rï  Zreflected_textZ
reflected2Zreflected_text_2r9   r9   r:   Ú/test_check_constraint_parenthesized_expressions?  s:    

÷$	

÷&zLComponentReflectionTestExtra.test_check_constraint_parenthesized_expressionsc              	   C   s�   |dƒ�T\}}t d|tdtdd�tdtƒtdtƒƒ}td|jj|jj|jjƒ W d  ƒ n1 sb0    Y  | d¡}t	|d	 d
 g d¢ƒ dS )ztest for #12894Zsa_multi_indexÚColumn1TrC   ÚColumn2ÚColumn3ZIndex_ExampleNr   r¦   )r„  r‚  rƒ  )
r   r   r   r$   r�   r„  r‚  rƒ  rì   r   )rm   rR   rh  rI   r�   rA   rç  r9   r9   r:   Útest_index_column_order‹  s     ûü"
z4ComponentReflectionTestExtra.test_index_column_orderc              	      sÖ  t d|tdtdƒƒtdtdƒƒtdtdƒƒƒ}tdt |jj¡|jjt |jj	¡ƒ d‰tdt 
|jjˆ¡ƒ td	|jjƒ | ˆ ¡ tˆ ƒ}d	dgd
i dœg}‡ fdd„}||d ƒ G dd„ dtƒ}G ‡fdd„dtƒ}tjjj�rrdg d¢|dƒd|dƒgd
dœ}	||	ƒ | d|	¡ dd g|dˆ› d�ƒgd
dœ}
||
ƒ | |
¡ t| d¡|ƒ tƒ }t d|ˆ d�}nNtdƒ�4 t| d¡|ƒ tƒ }t d|ˆ d�}W d   ƒ n1 �s¶0    Y  |  ||ˆ jj¡ d S )Nr¹  r  r  r€  ÚzÚt_idxa°  long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string long string Z
t_idx_longZt_idx_2F)r]   r¦   r  rˆ  c                    s:   t jjjr*g | d< ˆ jj› d�g i| d< n|  di ¡ d S )Nr‰  Z_includerˆ  )r   rJ   rñ  r3   r°  r]   r7  )Úentryr  r9   r:   ÚcompleteIndex»  s
    
ÿ
zYComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.completeIndexr   c                   @   s   e Zd Zdd„ ZdS )z[ComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.lower_index_strc                 S   s    |  ¡ }d|v od|v pd|v S )Nrœ  r  r€  ©rœ  )rm   r¯   Úolr9   r9   r:   rz  Ç  s    zbComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.lower_index_str.__eq__Nr{  r9   r9   r9   r:   Úlower_index_strÆ  s   rŒ  c                       s   e Zd Z‡ fdd„ZdS )z^ComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.coalesce_index_strc                    s   d|  ¡ v oˆ |v S )NÚcoalescerŠ  ry  ©Úlong_strr9   r:   rz  Í  s    zeComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.coalesce_index_str.__eq__Nr{  r9   rŽ  r9   r:   Úcoalesce_index_strÌ  s   r�  )Nr†  Nzlower(x)zlower(y))r]   r¦   rŠ  r  zcoalesce(x, 'z')r²   z>Skipped unsupported reflection of expression-based index t_idx)r   r   r   r$   r   rœ  r�   r  r†  r€  r�  r¶   r   r   r   rJ   Z reflect_indexes_with_expressionsr3   Úinsertr
  r   rì   r   r	   Z!compare_table_index_with_expectedr°  r]   )rm   rR   r}   r¹  rt   ró  r‰  rŒ  r�  Z
expr_indexZexpr_index_longr¸   rL  r9   )r}   r�  r:   Ú%test_reflect_expression_based_indexesŸ  sl    û&
üÿ		ýø
ÿú
ÿ.
ÿ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
|ƒ}| d¡}t|ddgdgdtjdœgƒ t|d	 d
 d|jj  dgƒ t dtƒ |d�}tt|jƒd	 j|jj d dgƒ d S )Nr¹  r  r  r€  r‡  ÚincludeF)r]   r¦   r‰  r  rˆ  r   rˆ  z
%s_includer²   )r   r   r   r$   r�   r  rˆ  r°  r]   r¶   r   rì   r   r,   rù   r   rs  rç  )rm   rR   r}   r¹  rž   rt   rì   rL  r9   r9   r:   Útest_reflect_covering_indexú  sD    ü

ûÿþ

ÿüÿü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   )rU  rØ  Útype_r9   r9   r:   r�  )  r˜   zAComponentReflectionTestExtra._type_round_trip.<locals>.<listcomp>c                 S   s   g | ]}|d  ‘qS )rh  r9   r‹  r9   r9   r:   r�  -  r˜   )r   rÎ  rq   r   r¾   )rm   r}   rR   r   r¹  r9   r9   r:   Ú_type_round_trip%  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)rm   r}   rR   Útypr9   r9   r:   Útest_numeric_reflection/  s    ÿz4ComponentReflectionTestExtra.test_numeric_reflectionr•  c                 C   s‚   |   |||dƒ¡d }t|tjƒr4t|tjƒsbJ ‚n.t|tjƒrRt|tjƒsbJ ‚nt|tjƒsbJ ‚t|jdƒ t|jt	ƒs~J ‚d S )Né4   r   )
r–  Ú
issubclassrÑ  rb   rà   r<  r   r   ÚlengthÚint)rm   r}   rR   r•  r˜  r9   r9   r:   Útest_string_length_reflection8  s    
z:ComponentReflectionTestExtra.test_string_length_reflectionc              	   C   sT   t d|tdtdd�tdtdd�ƒ}| |¡ tdd„ t|ƒ d¡D ƒddd	œƒ d S )
Nr¹  r”   Tr  rõ  Fc                 S   s   i | ]}|d  |d “qS )r]   r	  r9   rÜ  r9   r9   r:   rY  W  s   ÿzIComponentReflectionTestExtra.test_nullable_reflection.<locals>.<dictcomp>)r”   rõ  )r   r   r   rq   r   r   r¾   )rm   r}   rR   r¹  r9   r9   r:   Útest_nullable_reflectionM  s    ü
þûz5ComponentReflectionTestExtra.test_nullable_reflectionZ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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
‡ fdd„ˆ D ƒi ƒ | 	d¡d d ‰ t
ˆ |ƒ d S )NÚondeleteÚonupdater  rB   TrC   r¬   r×  Zx_idzx.idÚxidrÑ   Útesté
   Úuserr]   rF   Fr  Útidztable.idZmyfkr   r1   c                    s   i | ]}ˆ | r|ˆ | “qS r9   r9   )rU  r•   ©Úoptsr9   r:   rY  µ  r˜   zMComponentReflectionTestExtra.test_get_foreign_key_options.<locals>.<dictcomp>)r   r   r   r   r   r`   rµ   r¶   r   rê   r   )rm   r}   rR   ró  r   r¡  r1   rt   r9   r§  r:   Útest_get_foreign_key_options^  sT    *üú	ÿÿÿ÷
z9ComponentReflectionTestExtra.test_get_foreign_key_optionsÚ10z'?10'?z1|truez3 + 5z3\+5z(3 * 5)z3\*5zcurrent_timestamp|now|getdateÚ3Ú5zdatatype, default, expected_regc           	   	   C   sd   t d|tdtdd�td||d�ƒ}| |¡ t|ƒ d¡d d }t d	d
|¡}t||tj	d� d S )Nr¹  rB   TrC   Zthecol)Zserver_defaultr´   ri  z	[\(\) \']r  )Úflags)
r   r   r   rq   r   r¾   r  r  r   Ú
IGNORECASE)	rm   rR   r}   Údatatyperi  Zexpected_regr¹  rï  Zreflected_sanitizedr9   r9   r:   Útest_server_defaults»  s    ü
z1ComponentReflectionTestExtra.test_server_defaults)7r<   r=   r>   r…   r   rÍ   rc  rh  rr  rJ   rõ   rs  Z"inline_check_constraint_reflectionr¢   rz  r{  r|  r}  r�  Zindexes_check_column_orderr…  Zindexes_with_expressionsr’  rñ  r”  r–  rQ  r™  rÑ  r   rb   r<  ZNVARCHARZnvarchar_typesZNCHARrž  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`   rd  r   ÚtrueZexpression_server_defaultsr   r   ÚnowZliteral_columnZserver_defaultsr°  r9   r9   r9   r:   r_  —
  sÞ   

	
ÿ ÿ
ð9

Z
*

ú
üüüüüüÛ'
6üüüér_  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 )	Nr¹   T©rÚ   rB   rC   rL  Út1idzt1.id)r   r%   r   r   r   rQ   r9   r9   r:   rS   é  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 )	NrL  Tr´  r²   r¹   c                 S   s   |   ¡ dv S )N©r¹   rL  rŠ  )r]   r?  r9   r9   r:   r—     r˜   zINormalizedNameTest.test_reflect_lowercase_forced_tables.<locals>.<lambda>)Úonly)r   r   r%   r   r7   r›   r�   rµ  r·   rB   r>  )rm   r¸   Zt2_refZt1_refZm3r9   r9   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¸  r9   r9   r:   r�    s   þz;NormalizedNameTest.test_get_table_names.<locals>.<listcomp>r   r´   )r   r   r7   r»  r   Úupperrœ  )rm   Z
tablenamesr9   r9   r:   r¾    s
    þz'NormalizedNameTest.test_get_table_namesN)	r<   r=   r>   r¡   r…   r?   rS   r¸  r¾  r9   r9   r9   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Ñ   r9   r‹  r9   r9   r:   rY    r˜   zLComputedReflectionTest.test_computed_col_default_not_set.<locals>.<dictcomp>Z42Úwith_defaultri  ÚnormalÚcomputed_col)r   r   r7   r¾   r+   r   )rm   rt   rt  Zcol_datar9   r9   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Ñ   r9   r‹  r9   r9   r:   rY    r˜   zKComputedReflectionTest.test_get_column_returns_computed.<locals>.<dictcomp>)rB   r½  r¼  Úcomputedr¾  rž  ú	normal+42Ú	persisted)r   r   r7   r¾   r+   r   rm  r   rJ   Ú"computed_columns_reflect_persistedr3   Ú"computed_columns_default_persisted)rm   rt   rt  rE   r«   ÚcompDatar9   r9   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À  rž  rÂ  )r+   r   rm  r   rJ   rÃ  r3   r   )rm   rE   Úcolumnrž  rÂ  rÅ  r9   r9   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Ñ   r9   r‹  r9   r9   r:   rY  ;  r˜   zLComputedReflectionTest.test_get_column_returns_persisted.<locals>.<dictcomp>Úcomputed_no_flagrÁ  Úcomputed_virtualznormal+2FÚcomputed_storedz	normal-42T)r   r   r7   r¾   rÈ  r   rJ   rÄ  r3   Úcomputed_columns_virtualÚcomputed_columns_stored©rm   rt   rt  rE   r9   r9   r:   Ú!test_get_column_returns_persisted7  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É  rH   c                 S   s   i | ]}|d  |“qS rÑ   r9   r‹  r9   r9   r:   rY  Y  r˜   zXComputedReflectionTest.test_get_column_returns_persisted_with_schema.<locals>.<dictcomp>rÊ  z	normal/42rË  znormal/2FrÌ  z	normal*42T)r   r   r7   r¾   rL   rÈ  r   rJ   rÄ  r3   rÍ  rÎ  rÏ  r9   r9   r:   Ú-test_get_column_returns_persisted_with_schemaR  s2    
ÿü
ü
üzDComputedReflectionTest.test_get_column_returns_persisted_with_schemaN)r<   r=   r>   r¿  rÆ  rÈ  rÐ  r   rJ   rK   rÑ  r9   r9   r9   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)rÇ   rQ  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½  Úid1rL  r®   Tr   r   éþÿÿÿr*  é   ©Úalwaysr¼   Ú	incrementÚminvalueÚmaxvalueÚcycleÚcacher   )r×  r¼   rH   )
r   r   r   r   r   rJ   rK   r3   r   rL   rQ   r9   r9   r:   rS   w  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   rJ   Zidentity_columns_standardr3   rs  rk  r   rÍ  r+   )rm   rF  rÉ  ÚapproxZcommon_keysr•   r9   r9   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¢d|v r`t|d ƒ t|d d ƒ td|v ƒ | j|d td	d
d
d
dd	d
d�dd� q"|d dkr"d|v rÂt|d ƒ t|d d ƒ td|v ƒ | j|d tdddddddd�d	d� q"d S )Nr¹   rL  r]   r½  r»   rÓ  rg  ri  Fr´   éÿÿÿrÖ  T©rÝ  r®   r   r   rÔ  r*  rÕ  )	r   r   r7   r¾   r)   r+   r   rÞ  r6   ©rm   rt   rt  rp   r9   r9   r:   rÀ   ¶  sR    
ù	õù	õz,IdentityReflectionTest.test_reflect_identityc                 C   s¢   t tjƒ}|jdtjd�}|D ]~}|d dkr<td|v ƒ q|d dkrd|v r\t|d ƒ t|d d ƒ td|v ƒ | j|d t	d	d
dddddd�d	d� qd S )Nr¹   rH   r]   r½  r»   rÓ  rg  ri  Tr   r´   rß  FrÖ  rà  )
r   r   r7   r¾   rL   r)   r+   r   rÞ  r6   rá  r9   r9   r:   Útest_reflect_identity_schemaâ  s.    
ù	õz3IdentityReflectionTest.test_reflect_identity_schema)r<   r=   r>   rN  r†   r…   r¡   r?   rS   rÞ  rÀ   r   rJ   rK   râ  r9   r9   r9   r:   rÒ  q  s   
!,rÒ  c                   @   sj   e Zd ZdZedd„ ƒZejjdd„ ƒZ	ejj
dd„ ƒZejejjdd	„ ƒƒZ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Útb1rB   Úattrr]   r   Zpk_tb1rÑ   Tr  Útb2rC   ÚpidÚpattrÚpname©ré  rç  rè  Zfk_tb1_name_id_attr)r   r   r   rÑ  rb   r`   rÕ   rµ   r�   r]   rB   rå  )r8   rR   rä  r9   r9   r:   rS     s2    ø
ýóz(CompositeKeyReflectionTest.define_tablesc                 C   s0   t |ƒ}| | jjj¡}t| d¡g d¢ƒ d S )Nrr  ©r]   rB   rå  )r   rè   r›   rä  r]   r   r  )rm   r}   rt   rD   r9   r9   r:   Útest_pk_column_order  s    z/CompositeKeyReflectionTest.test_pk_column_orderc                 C   sZ   t |ƒ}| | jjj¡}tt|ƒdƒ |d }t| d¡g d¢ƒ t| d¡g d¢ƒ d S )Nr´   r   r|  rë  rr  rê  )r   rê   r›   ræ  r]   r   rÍ  r  )rm   r}   rt   Zforeign_keysrã  r9   r9   r:   Útest_fk_column_order$  s    z/CompositeKeyReflectionTest.test_fk_column_orderc                 c   s   |  d¡ d V  |  d¡ d S )Na  
            CREATE TABLE rep_fk_t (
                id INTEGER NOT NULL,
                cid INTEGER NOT NULL,
                PRIMARY KEY (id),
                UNIQUE (id, cid),
                CONSTRAINT rem_fk_cons FOREIGN KEY (cid, cid) REFERENCES rep_fk_t (id, cid)
            )zDROP TABLE rep_fk_t)Zexec_driver_sqlrÆ  r9   r9   r:   Úfk_repeated_col_fixture.  s
    ÿ
z2CompositeKeyReflectionTest.fk_repeated_col_fixturec                 C   s   t jjjrd|d< |S )z>normalize an inspect.get_foreign_keys() entry across dialects.NrÃ   )r   rJ   rÈ   r3   )rm   rˆ  r9   r9   r:   Ú_exp_fk>  s    
z"CompositeKeyReflectionTest._exp_fkc                 C   s6   t t|ƒ d¡|  dddgddddgi dœ¡gƒ dS )z´test the inspector can retrieve foreign keys with repeated
        source columns.

        See issue #13525 which addressed this on the schema construction
        side.

        Zrep_fk_tZrem_fk_consZcidNrB   )r]   rr  r}  r~  r|  r1   )r   r   rê   rï  )rm   r}   rî  r9   r9   r:   Ú2test_fk_repeated_source_cols_reported_by_inspectorD  s    úÿÿþzMCompositeKeyReflectionTest.test_fk_repeated_source_cols_reported_by_inspectorN)r<   r=   r>   r…   r?   rS   r   rJ   rP  rì  rÆ   rí  rÍ   Zrepeated_column_foreign_keysrî  rï  rð  r9   r9   r9   r:   rã  þ  s   


	rã  )rÿ   r_  rR  rÎ   r£   r@   rˆ   r³  rº  rÒ  rã  rÉ   )Irf  rø  r  r4   r`   r  r   r   r   r   r   r   r	   r
   r   Z	provisionr   r   rI   r   r   r   r   r   r   r   r   r   r   r   r   r   r   rÑ  r°  r   r   r    Úexcr!   r"   r#   r$   Zsql.elementsr%   Z
sql.schemar&   r'   r(   r)   r*   r+   r,   rR   r  Z
TablesTestr-   r@   rˆ   ZTestBaser£   rÉ   rÎ   rþ   rÿ   rR  r_  r³  ZComputedReflectionFixtureTestrº  rÒ  rã  Ú__all__r9   r9   r9   r:   Ú<module>	   s¤    Mg&                 5    R+a c