관리-도구
편집 파일: test_reflection.cpython-38.pyc
U -?�f� � @ s� d dl Z d dlZd dlZddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm Z dd lm Z dd lm Z dd l mZ dd l mZ dd lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddl m Z ddl m Z dd l m!Z! dd l"m#Z# dd l"m$Z$ dd lm%Z% dd lm&Z& dd!l'm(Z( dd"l)m*Z* dd#lm+Z+ dd$lm,Z, dd%lm-Z- dd&lm.Z. dd'lm/Z/ d(\Z0Z1G d)d*� d*e j2�Z3G d+d,� d,e3�Z4G d-d.� d.e j2�Z5G d/d0� d0e j6�Z7G d1d2� d2e j2�Z8d3d4� Z9G d5d6� d6e,e3�Z:G d7d8� d8e j6�Z;G d9d:� d:e+e j6�Z<G d;d<� d<e j2�Z=G d=d>� d>e j>�Z?G d?d@� d@e j2�Z@G dAdB� dBe j2�ZAdCZBdS )D� N� )�config)�engines)�eq_)� expect_raises)�expect_raises_message)�expect_warnings)�fixtures)�is_)�get_temp_table_name)�temp_table_keyword_args��Column)�Table� )�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_true)�mock)NNc @ s e Zd Zedd� �ZdS )�OneConnectionTablesTestc C s6 t jjjr,ddlm} tjt|j dd�d�S t j S d S )Nr )�pool�class)Z poolclass�scope)�options) r � requirementsZindependent_connections�enabled� sqlalchemyr* r �testing_engine�dictZ StaticPool�db)�clsr* � r5 �X/opt/hc_python/lib64/python3.8/site-packages/sqlalchemy/testing/suite/test_reflection.py� setup_bind7 s �z"OneConnectionTablesTest.setup_bindN)�__name__� __module__� __qualname__� classmethodr7 r5 r5 r5 r6 r) 6 s r) c @ s� e Zd ZdZedd� �Zedd� �Zedd� �Zedd � �Zd d � Z d d � Z e j j dd� �Ze j j dd� �Ze j jdd� �Ze j jdd� �Ze j je j je j jdd� ���Ze j je j j dd� ��ZdS )� HasTableTestTc C s~ t d|tdtdd�tdtd��� tjjjrTt d|tdtdd�tdtd��tj d� tjj rf| � |� tjj jrz| � |� 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�r4 �metadatar5 r5 r6 � define_tablesI s$ � � zHasTableTest.define_tablesc C sp d}t �|dt|�� t �|dtd�� tjjjrldtjtjf }t �|dt|�� t �|dtdtj �� 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_szDROP VIEW %s.vv) r �listenr r rF rG r/ r rH )r4 rN �queryr5 r5 r6 rJ _ s ��� �zHasTableTest.define_viewsc C s t ttjdtj� ��S �NZ user_tmp_�r r r3 �ident�r4 r5 r5 r6 �temp_table_nameu s �z HasTableTest.temp_table_namec C s� t ttj�}| �� }t||tdtjdd�tdt�d��f|�}t j j j r|t j j j r|t�|dtdtj �� t�|dtd �� d S ) Nr> Tr? �namerB rP �=create temporary view user_tmp_v as select * from user_tmp_%srQ �drop view user_tmp_v)r r r3 rX r r �sa�INT�VARCHARr rF rI r/ �temporary_viewsr rR r rV �r4 rN �kw� table_name�user_tmpr5 r5 r6 rL { s0 �������z HasTableTest.define_temp_tablesc C sV t j�� �B}tt jj�|d�� tt jj�|d�� tt jj�|d�� W 5 Q R X d S )Nr= rC �nonexistent_table)r r3 �beginr' �dialect� has_tabler& ��self�connr5 r5 r6 �test_has_table� s zHasTableTest.test_has_tablec C s� t tj�}t|�d�� td|tdt��}t|�d�� |� tj� z(t|�d�� |� � t|�d�� W 5 |� tj� X d S )Nr= Z new_table�col) r r r3 r' rg r r r r& �create�drop� clear_cache)ri rN �insp�ntr5 r5 r6 �test_has_table_cache� s z!HasTableTest.test_has_table_cachec C sh t j�� �T}tt jjj|dt jd�� tt jjj|dt jd�� tt jjj|dt jd�� W 5 Q R X d S )Nr= rD rC rd )r r3 re r& rf rg rH r' rh r5 r5 r6 �test_has_table_schema� s, �� �� ��z"HasTableTest.test_has_table_schemac C s2 t j�� � }tt jjj|ddd�� W 5 Q R X d S )Nr= Znonexistent_schemarD )r r3 re r& rf rg rh r5 r5 r6 �!test_has_table_nonexistent_schema� s ��z.HasTableTest.test_has_table_nonexistent_schemac C s t |�}t|�d�� d S �NZvv�r r' rg �ri � connectionrp r5 r5 r6 �test_has_table_view� s z HasTableTest.test_has_table_viewc C s" t |�}| �� }t|�|�� d S �N)r rX r' rg )ri rx rp rX r5 r5 r6 �test_has_table_temp_table� s z&HasTableTest.test_has_table_temp_tablec C s t |�}t|�d�� d S �N� user_tmp_vrv rw r5 r5 r6 �test_has_table_temp_view� s z%HasTableTest.test_has_table_temp_viewc C s t |�}t|�dtj�� d S ru )r r' rg r rH rw r5 r5 r6 �test_has_table_view_schema� s z'HasTableTest.test_has_table_view_schemaN)r8 r9 r: � __backend__r; rO rJ rX rL rk rr r rF rG rs rt �viewsry rK r{ rI r_ r~ r r5 r5 r5 r6 r< F s4 r< c @ sT e Zd ZdZedd� �Zejdddd�Zdd � Z ed d � �Z ej j ed d � ��Z dS )� HasIndexTestTc C s� t d|tdtdd�tdtd��tdtd���}td|jj� tjj j r|t d|tdtdd�tdtd��t j d �}td |jj� d S ) Nr= r> Tr? rA rB �data2�my_idxrD �my_idx_s) r r r r r! �crA r rF rG r/ r rH )r4 rN �ttr5 r5 r6 rO � s" � �zHasIndexTest.define_tablesrf � inspector�kind��argnamesc s" |dkr� fdd�S t � �jS d S )Nrf c s t jjj� f| �|�S rz )r r3 rf � has_index)�a�k�rj r5 r6 �<lambda>� � z)HasIndexTest._has_index.<locals>.<lambda>)r r� )ri r� rj r5 r� r6 � _has_index� s zHasIndexTest._has_indexc C s | � ||�}|dd�st�|dd�r(t�|dd�r6t�|dd�rDt�|dd�rRt�|dd�r`t�td| jjjj�}td|td t �tdd ��}|� |� |� |� zV|d kr�|dd�r�t�|dd�r�t�|j � � |dd�d ks�t�|dd�d ks�t�W 5 |� |� |� |� X d S ) Nr= r� r� rd Znonexistent_idxZmy_idx_2Z test_table_2Zmy_idx_3�foor� T)r� �AssertionErrorr! �tablesr= r� r� r r r rm rn �__self__ro )ri r� rx rN �meth�idxZtblr5 r5 r6 �test_has_index� s2 � zHasIndexTest.test_has_indexc C s` | � ||�}|ddtjd�s t�|ddtjd�r4t�|ddtjd�rHt�|ddtjd�r\t�d S )Nr= r� rD r� rd Znonexistent_idx_s)r� r rH r� )ri r� rx r� r5 r5 r6 �test_has_index_schema s � �z"HasIndexTest.test_has_index_schemaN)r8 r9 r: r� r; rO r � combinationsr� r� r� rF rG r� r5 r5 r5 r6 r� � s r� c @ sT e Zd ZdZdZejdddddd�e�d dd g�ejd d d ddd�dd� ���ZdS )� BizarroCharacterFKResolutionTestztests for #10275T)r> )z(3))zcol%p)z[brack]� columnnamer� � use_compositeF)�plain)z(2))z per % cent)z [brackets]� tablenamec C s t ||t|tddd�dd�}|r4|�tdtdd�� |r~t d|tdtdd�tdt�td t�t�dd g|jj|jjg�dd� n*t d|tdtdd�tdt |jj��dd� |� |� t � }t d||d �}|j | } |jj �| jd �s�t�|�r|jj�| jd ��st�d S ) Nr> T)�keyr@ �� test_needs_fk�id2r? �other�ref�ref2�� autoload_withr � )r r r � append_columnr\ �ForeignKeyConstraintr� r> r� r � create_allr r� r� � referencesr� r� ) ri rx rN r� r� r� r� �m2�o2�t1r5 r5 r6 � test_fk_ref- s@ � � � z,BizarroCharacterFKResolutionTest.test_fk_refN) r8 r9 r: �__doc__r� r r� Z variationr� r5 r5 r5 r6 r� ( s$ ��r� c @ s� e Zd ZdZdZedd� �Zdd� Zedd� �Zee j j d d � ��Z ed d � �Z ed d� �Zedd� �Zedd� �Zee j jdd� ��Zee j jdd� ��Zee j jdd� ��ZdS )�QuotedNameArgumentTest�onceTc C s� t d|tdt�tdtd��tdtd��tdt�tjddd�t�d d�tjdd d�tjdgd gd d�tj d dd�ddd� t j j j r�t d|tdt�tdtd��tdtd��tdt�tjddd�t�dd�tjddd�tjdgd gdd�tj d dd�ddd� t d|tdtdd�tdt�dd� t j jj �r�t j j j �r>ddg}ndg}|D ]f}d tjjj�d | �tjjj�|�f }t�|d t|�� t�|d td tjjj�d | � �� �qHd S )!N� quote ' oner> rY rB rA Z related_idzpk quote ' one�rY zix quote ' onez uq quote' onez related.idzfk quote ' onez name != 'foo'zck quote ' onezquote ' one commentT)�commentr� � quote " twozpk quote " twozix quote " twoz uq quote" twozfk quote " twozck quote " two zquote " two comment�relatedr? r� z"CREATE VIEW %s AS SELECT * FROM %s�view %srP rQ z DROP VIEW %s)r r r r r\ �PrimaryKeyConstraintr! �UniqueConstraintr� �CheckConstraintr rF �symbol_names_w_double_quoter/ �view_column_reflectionr r3 rf Zidentifier_preparer�quoter rR r )r4 rN �namesrY rS r5 r5 r6 rO g s� � � � � � � � �� �� ����z$QuotedNameArgumentTest.define_tablesc C s t �ddt jjf�| �S )N)r� r� )r r� rF r� )�fnr5 r5 r6 �quote_fixtures� s ��z%QuotedNameArgumentTest.quote_fixturesc C sP t tj�}tjjjr.|�|�}tt |t �� n t t �� |�|�}W 5 Q R X d S rz ) r r r3 r rF �reflect_table_optionsr/ �get_table_optionsr' � isinstancer2 r �NotImplementedError)ri rY rp �resr5 r5 r6 �test_get_table_options� s z-QuotedNameArgumentTest.test_get_table_optionsc C s t tj�}|�d| �s t�d S )Nr� )r r r3 �get_view_definitionr� �ri rY rp r5 r5 r6 �test_get_view_definition� s z/QuotedNameArgumentTest.test_get_view_definitionc C s t tj�}|�|�st�d S rz )r r r3 � get_columnsr� r� r5 r5 r6 �test_get_columns� s z'QuotedNameArgumentTest.test_get_columnsc C s t tj�}|�|�st�d S rz )r r r3 �get_pk_constraintr� r� r5 r5 r6 �test_get_pk_constraint� s z-QuotedNameArgumentTest.test_get_pk_constraintc C s t tj�}|�|�st�d S rz )r r r3 �get_foreign_keysr� r� r5 r5 r6 �test_get_foreign_keys� s z,QuotedNameArgumentTest.test_get_foreign_keysc C s t tj�}|�|�st�d S rz )r r r3 � get_indexesr� r� r5 r5 r6 �test_get_indexes� s z'QuotedNameArgumentTest.test_get_indexesc C s t tj�}|�|�st�d S rz )r r r3 �get_unique_constraintsr� r� r5 r5 r6 �test_get_unique_constraints� s z2QuotedNameArgumentTest.test_get_unique_constraintsc C s t tj�}|�|�st�d S rz )r r r3 �get_table_commentr� r� r5 r5 r6 �test_get_table_comment� s z-QuotedNameArgumentTest.test_get_table_commentc C s t tj�}|�|�st�d S rz )r r r3 �get_check_constraintsr� r� r5 r5 r6 �test_get_check_constraints� s z1QuotedNameArgumentTest.test_get_check_constraintsN)r8 r9 r: Zrun_create_tablesr� r; rO r� r� r rF r� r� r� r� r� r� � unique_constraint_reflectionr� �comment_reflectionr� �check_constraint_reflectionr� r5 r5 r5 r6 r� c s6 R r� c C s� t jd dd� t jjfdd�}t jtjtjtjdd�}t jtj tj tj tjtj tj tj B tj tj B dd�}t jddd d�}||||| ����S ) Nc S s t jS rz )r rH r5 r5 r5 r6 r� � r� z$_multi_combination.<locals>.<lambda>rE r� r, r� TF� use_filter) r r� rF rG r �DEFAULT� TEMPORARY�ANYr �TABLE�VIEW�MATERIALIZED_VIEWZANY_VIEW)r� rE r, r� � filter_namesr5 r5 r6 �_multi_combination� s2 ��� � r� c @ s$ e Zd Zd ZZdZedd� �Zedd� �Zedd� �Z ed d � �Z ed d � �Z d d� Z dd� Z dd� Zdejejdfdd�Zdejejdfdd�Zdejejdfdd�Zedd� �Zdejejdfdd �Zed d � �Zdejejdfd d �Zed!d"� �Zdejejdfd#d$�Zed%d&� �Z dejejdd'fd(d)�Z ed*d+� �Z dejejdfd,d-�Z ed.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,dd>e!j"j-fd?d@�e!j,de!j"j.fd'dAd@�dBdC� ��Z/e!j,de!j"j.fd'dAd@�dDdE� �Z0e!j"j1dFdG� �Z2e!j"j3e!j"j4dHdI� ��Z5e!j"j6dJdK� �Z7e!j"j6e!j"j.dLdM� ��Z8d�dNdO�Z9e!j,dPd'de!j"j.fdd'e!j"j3fdde!j"j.e!j"j3 fdQd@�dRdS� �Z:e!j"j;dTdU� �Z<e!j"j;dVdW� �Z=e!j"j;e!j"j>e!j"j4dXdY� ���Z?e!j,dZde!j"j.fdAd@�e!j"j@d[d\� ��ZAe!j,dZde!j"j.fdAd@�e!j"j-d]d^� ��ZBe!j"jCe!j"j.d_d`� ��ZDe!j,dZde!j"j.fdAd@�e!j"jEdadb� ��ZFe!j,dcddded@�e!j"jEe!j"jGe!j"jHdfdg� ����ZIe!j"j;e!j"jJdhdi� ��ZKe!j"jLdjdk� �ZMe!j,de!j"j.fdZdAd@�e!j"jJdldm� ��ZNe!j"j3e!j,dZde!j"j.fdAd@�dndo� ��ZOe!j"j3dpdq� �ZPe!j"jQdrds� �ZRe!j,de!j"j.fdZdAd@�dtdu� �ZSe!�,de!j"j.fd'�dvdw� �ZTe!jUdxdy� �ZVe!j"jWeXdzd{� ��ZYe!j"j6eXd|d}� ��ZZd~d� Z[d�d�d��Z\d�d�d��Z]eXd�d�� �Z^e!j"j@eXd�d�� ��Z_d�d�� Z`e!j"j-eXd�d�� ��Zae!j"jEeXd�d�� ��Zbe!j"jJeXd�d�� ��Zce!j"jdeXd�d�� ��Zee!j,d�e!j"jWfd�d�e!j"j@fd�e!j"j-fd�e!j"jEfd�e!j"jJfd�e!j"jdfd�e!j"j6fd�d@� d�d�� �Zfd�d�� Zge!j,dd'dAd@�e!j,de!j"jhfd'd�d@�d�d�� ��Zie!j"j6d�d�� �Zje!j"jkd�d�� �ZldS )��ComponentReflectionTestNTc C s* | � |d � tjjjr&| � |tjj� d S rz )�define_reflected_tablesr rF rG r/ r rH rM r5 r5 r6 rO s z%ComponentReflectionTest.define_tablesc C s� |r|d }nd}t jjjr0td| dd�f}nd}td|tdtjd d �td t� d �d d�tdt� � d d�tdtj f|�� tj dddd�t� d�|d d� }td|tdtj d d �tdtj td| dd d��td tj td| ��td t� d �d d �tj d!d"d�tjddd#d$d�|d d� td%|tdtj �td&tj t|jj��td't� d(�d d)�tjdd*d+d�|d d� td,|td-tj d d.d/�td t� d(�d0d1�td2t� d(�d3d1�td4t� d5�d6d1�|d7d8� td9|td t� d(��|d:d8� t jjj�r�|d k�r4td;|td-tj d d �td t� d(��td<td=t jj ��d tjjjd>� nntd?|td-tj d d �td@tdAtjjj ��td t� d(��|d d� tdB|td-tj d d �td t� d(��|d d� t jjj�rhtdC|jj|jjd d � tdD|jj|jj|jj� |�shtdE|tdFt� d ��d dG�}tdH|td-tj d d �tdFt� d ��d dG�}t jj j�rht jj j�rhtdI|jj � � � tdJ|jj � � � t jj j�r�| �!||� |�s�t jj"j�r�| �#|� d S )KN�.� z%susers.user_id� user_id_fkr� r5 �users�user_idTr? �test1� F��nullable�test2�parent_user_id� test2 > 0�zz_test2_gt_zero�users check constraint�rY r� � test2 <= 1000�rE r� � dingalings� dingaling_id� address_idz %semail_addresses.address_id�zz_email_add_id_fg� di fk comment�id_userrA � )�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_testr> � id comment)r@ r� �data % comment�r� �d2�)Comment types type speedily ' " \ '' Fun!�d3�* �Comment with escapes� the test % ' " \ table comment)rE r� �no_constraints�"no constraints has escaped comment� local_table� remote_idz%s.remote_table_2.id)r� rE � 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 rF � self_referential_foreign_keysr/ r r r r\ r] ZCHAR�Floatr r� r r� r� r� r� �cross_schema_fk_reflectionr rH r3 rf �default_schema_name�index_reflectionr! r� r� �indexes_with_ascdesc� reflect_indexes_with_ascdescr! �descr� rJ �temp_table_reflectionrL )r4 rN rE Z schema_prefixZparent_id_argsr� r r" r5 r5 r6 r� ! sJ ������ ���� �� ��� �������� ��� �� z/ComponentReflectionTest.define_reflected_tablesc C s t ttjdtj� ��S rT rU rW r5 r5 r6 rX � s �z'ComponentReflectionTest.temp_table_namec C s� t ttj�}| �� }t||tdtjdd�tdt�d��tdtj�tj ddtj � �d�t� d d�f|�}t j jjr�t j jjr�t�|d td tj �� t�|d td �� d S )Nr> Tr? rY rB r� � user_tmp_uq_r� � user_tmp_ixrP rZ rQ r[ )r r r3 rX r r r\ r] r^ r� rV r! r rF rI r/ r_ r rR r r` r5 r5 r6 rL � s6 �������z*ComponentReflectionTest.define_temp_tablesc C s� t jjjrdh}nt� }dD ]�}|}|r6|� d|� �}|d }||krJdnd}d|� d|� d |� �}t�|d t|�� ||kr�d } |r�t �d �r�|� d| � �} d | � d|� d�} t�|d t| �� t�|dtd|� d|� ��� q d S )Nr� )r� r r� r� �_vz MATERIALIZED r� zCREATE zVIEW z AS SELECT * FROM rP � mat_index�oraclez CREATE INDEX z ON z(data)rQ zDROP ) r rF �materialized_viewsr/ �setr rR r �against) r4 rN rE � materializedrb �fullnameZ view_name�prefixrS Z index_namer� r5 r5 r6 rJ � s. � �z$ComponentReflectionTest.define_viewsc C sD i }t j|kr|�|� t j|kr,|�|� t j|kr@|�|� |S rz )r r� �updater� r� )ri r� r� r� r6 r� r5 r5 r6 � _resolve_kind s z%ComponentReflectionTest._resolve_kindc C s< t jjjs |�� |�� n t jjjs8|�|� |�� d S rz )r rF r� r/ �clearr3 r9 )ri r� r6 r5 r5 r6 �_resolve_views s z&ComponentReflectionTest._resolve_viewsc s� dd� �|t jkrdd� �|t jkr,dd� �d ddhtjjddd d | �� hi�tjjj s|�d � d� �tjj � ddg� tjj j s��d � dd g� tjj j r�tjjj sd � d | �� g� tjjj s܈d � d g� � ���fd d �|�� D �}|S ) Nc S s dS )NTr5 )�_r5 r5 r6 r� % r� z8ComponentReflectionTest._resolve_names.<locals>.<lambda>c S s d| d kS �N�tmpr� r5 �r� r5 r5 r6 r� ' r� c S s d| d kS r> r5 r@ r5 r5 r6 r� ) r� r r r r r" r} c s> i | ]6\}}�|�r|d �� kr� r4|d � kr||�qS )r� r5 )�.0r� �v�r� ZremovedrE Z scope_filterr5 r6 � <dictcomp>F s � z:ComponentReflectionTest._resolve_names.<locals>.<dictcomp>)r r� r� r r rH rX rF r' r/ �addr9 r) r- �temp_table_namesr_ �items)ri rE r, r� �valuesr� r5 rC r6 �_resolve_names$ sF �� � ��� �z&ComponentReflectionTest._resolve_namesc C s� |dft ji}|dft j|dft j|dft ji}| �||� |dft j|dft j|dft j|dft j|d ft j|d ft j|d ft j|d ft j|d ft j|dft j|| �� ft ji }| �||||�}| �||||�}|S )N� dingalings_v�email_addresses_v�users_vr} r� r� r r r r r r r r" �r( r� r< rX r: rI ) ri rE r, r� r� r6 r� r� r� r5 r5 r6 � exp_optionsO sF � � z#ComponentReflectionTest.exp_optionsc C s� dd i}|df|i}|df||df||df|i}| � ||� |df||df||df||d fdd i|d fdd i|d f||df||df||df||df||| �� f|i }| �||||�} | �|||| �} | S )N�textrJ rK rL r} r� r� r r r r r r r r r r" )r< rX r: rI ) ri rE r, r� r� �emptyr6 r� r� r� r5 r5 r6 � exp_commentsn sP � � � �z$ComponentReflectionTest.exp_commentsc s$ dt jd dfdd�� � fdd�}|df� dd t jd �� d �� d �� d �gi}|df� d d t jd �� d�� d�g|df� dd t jd �� dt jd�� dt jd�� d�g|df� dd t jd �� d�� d�gi}| �||� |df|d�� ddd�� ddd�� d�g|d f|d�� d �� d �� d �g|d f|d �� d�� d�g|d f|dd 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�gi }| �||||�} | �|||| �} | S )/NFTc S s* | |t j|||d�}|dkr&|�d� |S )N)rY � autoincrement�type�defaultr� r� �omitrR )r( r� �pop)rY �autorT r� r� r� r5 r5 r6 rl � s � z0ComponentReflectionTest.exp_columns.<locals>.colc s dt jdd�|�}� | f|�S )NTF)rW rT r� �r( r� )rY ra �rl r5 r6 �pk� s z/ComponentReflectionTest.exp_columns.<locals>.pkrJ r� rU )rW r� r� r rA rK r r rL r� r� r� r� r� r} r> rY r� r� r� r r r r r r r r r r r r r r r r r! r" rM ) ri rE r, r� r� rZ r6 r� r� r� r5 rY r6 � exp_columns� s� � �� � ��� ��� � � ��'z#ComponentReflectionTest.exp_columnsc C s ddddhS )NrY rS r� rT r5 �ri r5 r5 r6 �_required_column_keys� s z-ComponentReflectionTest._required_column_keysc C sN t jd d�dd�}|d d�}tjjjr8|df|d�i}n |df|i}|df||df||d f|i}| �||� |d f|d �|d f|d�|d f|dddd�|df|d�|df||df|d�|df|d�|df|d�|df||df|d�|| �� f|d�i } tjjj�s*| � � D ] } | d d k �r t j| d< �q | � || ||�} | � |||| �} | S )Nr� c W s t |�| |d�S )N)�constrained_columnsrY r� )�list)rY r� �colsr5 r5 r6 rZ � s �z+ComponentReflectionTest.exp_pks.<locals>.pkr� rJ r� rK rL r} r� r� r� r r� r r r r> r r r r r r" rY ) r( r� r rF Z materialized_views_reflect_pkr/ r< rX �reflects_pk_namesrH r: rI ) ri rE r, r� r� rZ rP r6 r� r� �valr� r5 r5 r6 �exp_pks� s^ � � � z ComponentReflectionTest.exp_pksc C s ddhS )NrY r^ r5 r\ r5 r5 r6 �_required_pk_keys& s z)ComponentReflectionTest._required_pk_keysc s� G dd� d�� |t jd f� fdd� }|dfg i}|dfg |dfg |dfg i}| �||� |d f|d gd gd d d �g|df|dgd gd �|dgdgdddd�g|df|dgd gd �g|dfg |dfg |df|dgdgdtjd �g|d f|d gdgdd d �g|dfg |d fg |d fg || �� fg i }tjjj �s<||d f � � tjj j �s~|� � D ],} | D ] } | d! t jk �rXt j| d!< �qX�qP| � ||||�} | �|||| �} | S )"Nc @ s e Zd Zdd� ZdS )z+ComponentReflectionTest.exp_fks.<locals>.ttc S s |d kpt jjj|kS rz )r r3 rf r( �ri r� r5 r5 r6 �__eq__2 s �z2ComponentReflectionTest.exp_fks.<locals>.tt.__eq__N�r8 r9 r: rf r5 r5 r5 r6 r� 1 s r� c s$ | ||t j|d k r|n� � ||d�S )N)r^ �referred_columnsrY r- �referred_schema�referred_tabler� rX )r` Zref_colZ ref_table� ref_schemarY r� �r� r5 r6 �fk8 s �z+ComponentReflectionTest.exp_fks.<locals>.fkrJ rK rL r} r� r� r� r� r� r� r r� r r� r� r� r r r r r r> r )rk r r r r" rY )r( r� r< r rH rX r rF r% r/ r; �named_constraintsrH r: rI ) ri rE r, r� r� rm r6 r� r� �valsrb r� r5 rl r6 �exp_fks* s� � � ��� � ��� �# z ComponentReflectionTest.exp_fksc C s dddddhS )NrY r^ ri rj rh r5 r\ r5 r5 r6 �_required_fk_keys� s �z)ComponentReflectionTest._required_fk_keysc C s� dd ddd�dd�}|dfg i}|dfg |dfg |dfg i}| � ||� |rf||df �|d d d �� |d f|d ddd�|ddddd �|ddddd��|df|d tjddd�|dtjdd�|ddd ddd��|d f|d tjd �|d tjdd��|d fg |d!fg |d"f|d#tjdd��|d$f|d%tjdd��|d&fg |d'f|d(d)d(d*id+��|d,f|d(d-d(d*id+��|| �� f|d.d/d �|d0d1tj� �ddd2��i }tjj j �r�tjj j �s�||d'f � � ||d,f � � | � ||||�} | �|||| �} | S )3NF)r �column_sorting� duplicatesrm c s� t jj}t jj}t jj}|r"|jr,|r0|js0dS |t|�| tjg d�} � r~� | d< |jr~| d | d< } � fdd�| D �| d< |r�| | d< | gS ) Nr5 )r � column_namesrY �dialect_options�include_columnsrr rt � expressionsc s g | ]}|� krd n|�qS rz r5 �rA r� �rr r5 r6 � <listcomp>� s zDComponentReflectionTest.exp_indexes.<locals>.idx.<locals>.<listcomp>Zduplicates_constraint) r rF Z foreign_keys_reflect_as_indexZ#unique_constraints_reflect_as_indexZ*reflect_indexes_with_ascdesc_as_expressionr/ r_ r( r� ) rY r rr rs rm r` Zfk_reqZdup_reqZsorting_expressionr� �origr5 ry r6 r� � s4 � ��� � z0ComponentReflectionTest.exp_indexes.<locals>.idxrJ rK rL r} rA r1 r� r� r� r� T)rY rm r� r� r� r r )rY r r� )rY r rs r r� r� r r r r r r r r r r r r r! r# )r, )rY rr r" r$ r� r/ rY r. )rY rs r )r< �extendr( r� rX r rV r rF r* r/ r+ r; r: rI ) ri rE r, r� r� r� r6 r� r� r� r5 r5 r6 � exp_indexes� s� � % � � ��� � �� �� �� ���5��z#ComponentReflectionTest.exp_indexesc C s dddhS )NrY rt r r5 r\ r5 r5 r6 �_required_index_keys s z,ComponentReflectionTest._required_index_keysFc C s d dd d�dd�}|dfg i}|dfg |dfg |dfg i}| � ||� |d f|d d d d d d��|df|dtjtjd�|dddddd��|dfg |dfg |dfg |dfg |dfg |d fg |d fg |d fg || �� f|d d tj� �d!��i } |r�||| �S | �|| ||�} | �|||| �} | S d S )"NF)�duplicates_index�is_indexr� c W s8 t jj}|r|jsdS t|�| |d�}|r2||d< |gS )Nr5 )rt rY r� r )r rF Z*unique_index_reflect_as_unique_constraintsr/ r_ )rY r r� r� r` �reqr� r5 r5 r6 �uc s �z+ComponentReflectionTest.exp_ucs.<locals>.ucrJ rK rL r} r� r� r� r T)rY r r� r� rA )rY r r� r� r r )rY r r� r r r r r r r r" rY r. r� )r< r( r� rX r rV r: rI ) ri rE r, r� r� �all_r� r6 r� r� r� r5 r5 r6 �exp_ucs sr � � �� �� �� z ComponentReflectionTest.exp_ucsc C s ddhS )NrY rt r5 r\ r5 r5 r6 �_required_unique_cst_keysJ s z1ComponentReflectionTest._required_unique_cst_keysc s� G dd� dt �� d� fdd� }|dfg i}|dfg |dfg |dfg i}| �||� |d f|d tj�|d d d d�g|df|ddd�g|dfg |dfg |dfg |dfg |dfg |dfg |dfg |dfg || �� fg i }| �||||�} | �|||| �} | S ) Nc @ s e Zd Zdd� ZdS )z+ComponentReflectionTest.exp_ccs.<locals>.ttc S s( |� � �dd��dd��dd�}| |kS )N�(r� �)�`)�lower�replace)ri r� r� r5 r5 r6 rf V s � � ��z2ComponentReflectionTest.exp_ccs.<locals>.tt.__eq__Nrg r5 r5 r5 r6 r� U s r� c s � | �||d�S )N)�sqltextrY r� r5 )rO rY r� rl r5 r6 �cc_ s z+ComponentReflectionTest.exp_ccs.<locals>.ccrJ rK rL r} r� r� r� r� r� r r� z$address_id > 0 and address_id < 1000r r� r r r r r r r r" )N)�strr< r( r� rX r: rI ) ri rE r, r� r� r� r6 r� r� r� r5 rl r6 �exp_ccsN s^ � ���� �z ComponentReflectionTest.exp_ccsc C s ddhS )NrY r� r5 r\ r5 r5 r6 �_required_cc_keys� s z)ComponentReflectionTest._required_cc_keysc C s t |�}ttjj|�� k� d S rz )r r' r r rH �get_schema_namesrw r5 r5 r6 �test_get_schema_names� s z-ComponentReflectionTest.test_get_schema_namesc C s, t |�}t|�tjj�� t|�d�� d S )N�sa_fake_schema_foo)r r' � has_schemar r rH r& rw r5 r5 r6 �test_has_schema� s z'ComponentReflectionTest.test_has_schemac C s8 |j ddttjjid�}t|�}ttjj|�� k� dS )z test #7300r� �bar�Zschema_translate_mapN)�execution_optionsr# r r rH r r' r� rw r5 r5 r6 �%test_get_schema_names_w_translate_map� s ��z=ComponentReflectionTest.test_get_schema_names_w_translate_mapc C sD |j ddttjjid�}t|�}t|�tjj�� t|�d�� d S )Nr� r� r� r� ) r� r# r r rH r r' r� r& rw r5 r5 r6 � test_has_schema_w_translate_map� s ��z7ComponentReflectionTest.test_has_schema_w_translate_mapc C s� t |�}td|�� k� t|�d�� |�td�� zHtd|�� k� t|�d�� |�� td|�� k� t|�d�� W 5 |�td�� X d S )NZfoo_barzCREATE SCHEMA foo_barzDROP SCHEMA foo_bar)r r& r� r� �executer ro r' rw r5 r5 r6 �test_schema_cache� s z)ComponentReflectionTest.test_schema_cachec C s$ t �� }t|� t|jd�s t�d S )Nr( )r r1 r �hasattrrf r� )ri �enginer5 r5 r6 �test_dialect_initialize� s z/ComponentReflectionTest.test_dialect_initializec C s t |�}t|j|jj� d S rz )r r r( rf rw r5 r5 r6 � test_get_default_schema_name� s z4ComponentReflectionTest.test_get_default_schema_name� foreign_key�order_byr� � use_schemac s� |r t j}nd }dddddddh� t|�}|rDdd � |�|�D �}n |�|�}� fd d �|D �}|d kr~d d dg}t||� ndd d g}tt|�|� d S )Nr r" r r r r r c S s g | ]}|d r|d �qS )r r5 )rA Zrecr5 r5 r6 rz � s �z@ComponentReflectionTest.test_get_table_names.<locals>.<listcomp>c s g | ]}|� kr|�qS r5 r5 �rA �t�Z_ignore_tablesr5 r6 rz � s r� r� r r� )r rH r Z get_sorted_table_and_fkc_names�get_table_namesr �sorted) ri rx r� r� rE rp r� � table_names�answerr5 r� r6 �test_get_table_names� s. � � z,ComponentReflectionTest.test_get_table_namesc C sn t |�}|rtj}nd }|�|�}tjjjrRtt |�ddg� t|� |�dg� ndddg}tt |�|� d S )NrK rL rJ ) r r rH �get_view_namesr rF r3 r/ r r� �get_materialized_view_names)ri rx r� rp rE r� r� r5 r5 r6 �test_get_view_names� s z+ComponentReflectionTest.test_get_view_namesc C s, t |�}|�� }tt|�dtj� �g� d S rT )r Zget_temp_table_namesr r� r rV �ri rx rp rF r5 r5 r6 �test_get_temp_table_names s z1ComponentReflectionTest.test_get_temp_table_namesc C s$ t |�}|�� }tt|�dg� d S r| )r Zget_temp_view_namesr r� r� r5 r5 r6 �test_get_temp_view_names s z0ComponentReflectionTest.test_get_temp_view_namesc C s | � |� d S rz )�_test_get_comments�ri rx r5 r5 r6 �test_get_comments s z)ComponentReflectionTest.test_get_commentsc C s | � |tjj� d S rz )r� r r rH r� r5 r5 r6 � test_get_comments_with_schema s z5ComponentReflectionTest.test_get_comments_with_schemac C s� t |�}| j|d�}t|jd|d�||df � t|jd|d�||df � t|jd|d�||df � | jjj}t|j||d�|||f � d S )NrD r r� )r rQ r r� r� r rY )ri rx rE rp �exp�no_cstr5 r5 r6 r� " s& � � � �z*ComponentReflectionTest._test_get_comments)FFzuse_views,use_schemac C sl |r t j}nd }| jj| jj }}|r2dddg}nddg}t|�}t|||f�D �]\} } |} |j| | d�} tt | �dkt | �� t | j �D ]�\} }t |j | | d � | | d j}|j}t|tjj�r�|j}t�d �r�|tjtjfkr�tj}tt t|j��|j��tj tj tjtjtj tj tj g��dkd |j |j| | d |f � |j!s�| | d d ks�t"�q�qPd S ) NrL rK rJ r� r rD r rY rS r2 z%s(%s), %s(%s)rT )#r rH r� r� r r �zipr� r' �len� enumerate�columnsr rY � __class__rS r� r\ r Z TypeEnginer r5 � sql_types�Date�DateTimer4 �__mro__� intersectionr �NumericZTimer Z_Binaryr@ r� )ri rx Z use_viewsr� rE r� � addressesr� rp rb �tableZ schema_namer` �irl �ctypeZ ctype_defr5 r5 r6 r� : s\ � �������z(ComponentReflectionTest.test_get_columnsc C s6 | � � }| j| }t|t� |d�}| j||dd� d S )Nr� F)Zstrict_constraints)rX r� r r Zassert_tables_equal)ri rx rb rc Zreflected_user_tmpr5 r5 r6 � test_reflect_table_temp_table� s � �z5ComponentReflectionTest.test_reflect_table_temp_tablec C sf | � � }| j| }t|�}|�|�}tt|�dkt|�� t|j�D ] \}}t|j || d � qDd S )Nr rY ) rX r� r r� r' r� r� r� r rY )ri rx rb rc rp r` r� rl r5 r5 r6 �test_get_temp_table_columns� s z3ComponentReflectionTest.test_get_temp_table_columnsc C s0 t |�}|�d�}tdd� |D �dddg� d S )Nr} c S s g | ] }|d �qS r� r5 �rA rl r5 r5 r6 rz � s zFComponentReflectionTest.test_get_temp_view_columns.<locals>.<listcomp>r> rY r� )r r� r )ri rx rp r` r5 r5 r6 �test_get_temp_view_columns� s z2ComponentReflectionTest.test_get_temp_view_columns�Fc C s� |rt jj}nd }| jj| jj }}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 5 Q R X | jjj } | � |j| |d�g||| f g| j � d S )NrD r^ rY r )r r rH r� r� r r rc r� rY � _check_listrd r rF ra �fail_ifr ) ri rx r� rE r� r� rp r� Z users_consZ addr_consZexp_colsr� r5 r5 r6 r� � s. � �z.ComponentReflectionTest.test_get_pk_constraintc C sT |r t j}nd }| jj| jj }}t|�}|}tjjj r�|j |j |d�}|d } tjj � � � t| d d� W 5 Q R X t| d |� t| d |j � t| d dg� t| d d g� |j |j |d�} | d } tjj� � � t| d d k � W 5 Q R X t| d |� t| d |j � t| d dg� t| d d g� | jjj } t|j | |d�g � d S ) NrD r rY r� ri rj rh r� r^ r� r )r rH r� r� r r r rF r% r/ r� rY rn r� r � implicitly_named_constraintsr' r ) ri rx r� rE r� r� rp Zexpected_schemaZ users_fkeys�fkey1Z addr_fkeysr� r5 r5 r6 r� � s2 z-ComponentReflectionTest.test_get_foreign_keysc C s | � d|jj dtjj dtjj �\}}}t|�}|�|j�}t t |�d� |d }t |d tjj� t |d |j� t |d d g� t |d d g� |j|jtjjd �}t t |�d� |d } t | d d |jjfk� 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 ri rj rh r> r^ r rD r ) r� rf r( r r rH r r� rY r r� r' ) ri rx r r r rp Z local_fkeysr� Z remote_fkeysZfkey2r5 r5 r6 �"test_get_inter_schema_foreign_keys� s: � ����z:ComponentReflectionTest.test_get_inter_schema_foreign_keysc C sz |r t j}nd }t|�}|jd|d�}| j|d�}| �|||df | j� | jjj }| �|j||d�|||f | j� d S )Nr� rD ) r rH r r� r} r� r~ r� r rY )ri rx r� rE rp �indexesr� r� r5 r5 r6 r� s" � �z(ComponentReflectionTest.test_get_indexes)r r# )r" r$ z tname,ixnamec C s� t |�}|�|�}| �� d |f }| �||| j� t|t� |d�}tt|j �d� t t |j �d j |� tt |j �d j |� d S )Nr� r� r )r r� r} r� r~ r r r r� r� r r_ r� rY )ri rx �tnameZixnamerp r� Zexpected_indexesr� r5 r5 r6 �test_get_noncol_index0 s z-ComponentReflectionTest.test_get_noncol_indexc C sB t |�}| �� }|�|�}| jdd�d |f }| �||| j� d S )NT)r� )r rX r� r� r� r~ )ri rx rp rY � reflectedr� r5 r5 r6 �&test_get_temp_table_unique_constraintsF s z>ComponentReflectionTest.test_get_temp_table_unique_constraintsc C sn t |�}| �� }|�|�}|D ]}|�dd � q ddgdd�g}tjjjrVg |d d< tdd � |D �|� d S ) Nru Fr� r/ )r rt rY r rv c S s g | ]}|d dkr|�qS )rY r/ r5 �rA r� r5 r5 r6 rz \ s zGComponentReflectionTest.test_get_temp_table_indexes.<locals>.<listcomp>) r rX r� rV r rF � index_reflects_included_columnsr/ r )ri rx rp rb r� �ind�expectedr5 r5 r6 �test_get_temp_table_indexesO s � �z3ComponentReflectionTest.test_get_temp_table_indexesc C s |r t j}nd }tddgd�ddddgd�ddddgd�dd d gd�d dgd�d dgd�gt�d �d�}td|tdt�d��tdt�d��tdtj �td t�d��td t�d��|d�}|D ]"}|� tj |d d |d i�� q�|� |� t |�}t|jd|d�t�d �d�} t� } tt|�t| �� t|| �D ]B\} } | �dd �} | �rT| �| � t| �dd �d � t| | � �q0t� }td|||d�} dd� | jD �}dd� | jD ��dg�}|�|��r�t�| �r�t| |� t|t� � | jj j }t|j||d�g � d S )NZunique_ar� )rY rt Z unique_a_b_c�br� Z unique_c_a_bZunique_asc_key�ascr� z i.have.dotsz i have spacesrY �r� Ztesttblr r rD rt r r� )r� rE c S s h | ] }|j �qS r5 r� r� r5 r5 r6 � <setcomp>� s zFComponentReflectionTest.test_get_unique_constraints.<locals>.<setcomp>c S s h | ]}t |tj�r|j�qS r5 )r� r\ r� rY )rA Zuqr5 r5 r6 r� � s �) r rH r� �operator� itemgetterr r r\ r r Zappend_constraintr� rm r r� r4 r r� r� rV rE r r� � constraints� differencer� r� r� r rY )ri rN rx r� rE Zuniquesr� r� rp r� Znames_that_duplicate_indexr{ ZreflZdupeZreflected_metadataZ idx_namesZuq_namesr� r5 r5 r6 r� ` sx �� � � � � �� z3ComponentReflectionTest.test_get_unique_constraintsc C s@ |r t j}nd }t|�}dD ] }|j||d�}tt|�� q d S )N)rL rK rJ rD )r rH r r� r' �bool)ri rx r� rE rp �viewrB r5 r5 r6 r� � s z0ComponentReflectionTest.test_get_view_definitionc C sH t |�}tt�� |�d� W 5 Q R X tt�� |�d� W 5 Q R X d S )NZview_does_not_existr� )r r r r� rw r5 r5 r6 �'test_get_view_definition_does_not_exist� s z?ComponentReflectionTest.test_get_view_definition_does_not_existc C sF t |�}dD ]4\}}|�|�}dd� |D �| }|�dd�s t�q dS )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 |�qS r� r5 rx r5 r5 r6 rD � s zBComponentReflectionTest.test_autoincrement_col.<locals>.<dictcomp>rR TN)r r� �getr� )ri rx rp r� �cnamer` Zid_r5 r5 r6 �test_autoincrement_col� s z.ComponentReflectionTest.test_autoincrement_colc C s� t tj�}|rtjnd }tjjjr\|jd|d�}t t |t �� |jd|d�}t t |t �� n"t t �� |jd|d�}W 5 Q R X d S )Nr� rD r )r r r3 rH r rF r� r/ r� r' r� r2 r r� )ri r� rp rE r� r5 r5 r6 r� � s z.ComponentReflectionTest.test_get_table_optionsc sv t tj�� tjjjrV|r tjnd �� j�d�}� �fdd�� j �d�D �}t ||� n t t �� � �� }W 5 Q R X d S )NrD c s i | ]}�|f� j |�d ��qS )rD )r� )rA r� �rp rE r5 r6 rD s � zHComponentReflectionTest.test_multi_get_table_options.<locals>.<dictcomp>) r r r3 r rF r� r/ rH �get_multi_table_optionsr� r r r� )ri r� r� r� r5 r� r6 � test_multi_get_table_options� s � z4ComponentReflectionTest.test_multi_get_table_optionsc s � fdd�}|S )Nc s t � �}||d� ||d�}| r&| � } g }tj|krD|�dddg� tj|kr\|�ddg� tj|krt|�ddg� | r�| |d< |r�||d < || |||�d �d �} |g} |tjkr�|� � } | � d � | � | � |tjkr�|� � } | � d � | � | � t � �| | fS ) Nr )r, r� r r� zdoes-not-existrK rJ rE r� )rE r, r� r� r, r� ) r r r� r| r� r� r� r r� �copyrV �append) rE r, r� r� Zsingle_reflect_fnZ exp_methodrp ra r� r� �kwsZnkw�rx r5 r6 �provide_fixture sD � � z>ComponentReflectionTest.get_multi_exp.<locals>.provide_fixturer5 )ri rx r� r5 r� r6 � get_multi_exp s .z%ComponentReflectionTest.get_multi_expc C sH |||||t j| j�\}}}|D ]"} |�� |jf | �} t| |� q d S rz )r r� rN ro r� r � ri r� rE r, r� r� rp r� r� ra �resultr5 r5 r6 �#test_multi_get_table_options_tables< s � z;ComponentReflectionTest.test_multi_get_table_options_tablesc C sD |||||t j| j�\}}}|D ] } |�� t|jf | �|� q d S rz )r r� rQ ro r Zget_multi_table_comment) ri r� rE r, r� r� rp r� r� ra r5 r5 r6 � test_get_multi_table_commentN s � z4ComponentReflectionTest.test_get_multi_table_commentc sV t d�dd�� t|t�r8t� fdd�|�� D �||� nt� fdd�|D �||� d S )N�rO c S s t �dd| ��� S )Nz['\" ]r� )�re�subr� r� r5 r5 r6 �_clean` s z:ComponentReflectionTest._check_expressions.<locals>._cleanc s i | ]\}}� |�|�qS r5 r5 )rA �erB �r� r5 r6 rD d s z>ComponentReflectionTest._check_expressions.<locals>.<dictcomp>c s g | ] }� |��qS r5 r5 )rA r� r� r5 r6 rz f s z>ComponentReflectionTest._check_expressions.<locals>.<listcomp>)r� r� r2 r rG )ri r� r� �err_msgr5 r� r6 �_check_expressions_ s z*ComponentReflectionTest._check_expressionsc C s� |d krt |||� n�t t|�t|�|� t||�D ]~\}}t|�t|�B D ]d}||ksh||krL||krL|� d|� d|� �}|dkr�| �|| || |� qLt || || |� qLq4d S )Nz - )rw rr )r r� r� r4 r� ) ri r� r� �req_keys�msg�rr� r� r� r5 r5 r6 r� h s z#ComponentReflectionTest._check_listc C s\ t t|�� �t|�� �� |D ]8}|| || }}|rF|g|g }}| �||||� q d S rz )r r4 �keysr� )ri r� r� r� � make_listsr� r� r� r5 r5 r6 �_check_table_dictv s z)ComponentReflectionTest._check_table_dictc C sN |||||t j| j�\}}}|D ](} |�� |jf | �} | �| || j� q d S rz )r r� r[ ro �get_multi_columnsr r] r� r5 r5 r6 �test_get_multi_columns~ s � z.ComponentReflectionTest.test_get_multi_columnsc C sR |||||t j| j�\}}}|D ],} |�� |jf | �} | j| || jdd� q d S )NT)r )r r� rc ro Zget_multi_pk_constraintr rd r� r5 r5 r6 � test_get_multi_pk_constraint� s" � �z4ComponentReflectionTest.test_get_multi_pk_constraintc C sT t jjjsP||fD ]<}|�� D ].}t|�dkr tdd� |D ��r |j|d� q qd S )Nr� c s s" | ]}|� d �dtjfkV qdS )rY N)r� r( r� )rA rB r5 r5 r6 � <genexpr>� s z7ComponentReflectionTest._adjust_sort.<locals>.<genexpr>r� )r rF r� r/ rH r� �any�sort)ri r� r� r� �objrb r5 r5 r6 � _adjust_sort� s �z$ComponentReflectionTest._adjust_sortc C s` |||||t j| j�\}}}|D ]:} |�� |jf | �} | �| |dd� � | �| || j� q d S )Nc S s t | d �S )Nr^ ��tuple��dr5 r5 r6 r� � r� zEComponentReflectionTest.test_get_multi_foreign_keys.<locals>.<lambda>)r r� rp ro Zget_multi_foreign_keysr r rq r� r5 r5 r6 �test_get_multi_foreign_keys� s" � �z3ComponentReflectionTest.test_get_multi_foreign_keysc C sN |||||t j| j�\}}}|D ](} |�� |jf | �} | �| || j� q d S rz )r r� r} ro Zget_multi_indexesr r~ r� r5 r5 r6 �test_get_multi_indexes� s � z.ComponentReflectionTest.test_get_multi_indexesc C s` |||||t j| j�\}}}|D ]:} |�� |jf | �} | �| |dd� � | �| || j� q d S )Nc S s t | d �S )Nrt r r r5 r5 r6 r� � r� zKComponentReflectionTest.test_get_multi_unique_constraints.<locals>.<lambda>)r r� r� ro Z get_multi_unique_constraintsr r r� r� r5 r5 r6 �!test_get_multi_unique_constraints� s � z9ComponentReflectionTest.test_get_multi_unique_constraintsc C s` |||||t j| j�\}}}|D ]:} |�� |jf | �} | �| |dd� � | �| || j� q d S )Nc S s t | d �S )Nr� r r r5 r5 r6 r� � r� zJComponentReflectionTest.test_get_multi_check_constraints.<locals>.<lambda>)r r� r� ro Zget_multi_check_constraintsr r r� r� r5 r5 r6 � test_get_multi_check_constraints� s � z8ComponentReflectionTest.test_get_multi_check_constraintsr� r� r� r� r� r� r� r� �methodc C s2 t |�}t||�}tt�� |d� W 5 Q R X d S )NZtable_does_not_exists)r �getattrr r )ri r rx rp r� r5 r5 r6 �test_not_existing_table� s z/ComponentReflectionTest.test_not_existing_tablec s` t j� � fdd�}tj�t d|��4 ttd�� t|��t dt � �d � W 5 Q R X W 5 Q R X d S )Nc s" |� di �}td�|d< � | |�S )NZ unreflectable�err)N� some_table)� setdefaultr )r� r� �ur�Zmcr5 r6 �patched s z;ComponentReflectionTest.test_unreflectable.<locals>.patchedr r r ) r r r( �patch�objectr r r Z reflect_tabler r )ri rx r r5 r r6 �test_unreflectable s �z*ComponentReflectionTest.test_unreflectabler� c s� t � }|rtjnd � |j|� |dd� t|�}|�� �}|rr||�� �7 }z||�� �7 }W n tk rp Y nX � r�� fdd�|D �}t t |j �t |�� d S )NF)rE r� Z resolve_fksc s g | ]}� � d |� ��qS )r� r5 r� rD r5 r6 rz 7 s z9ComponentReflectionTest.test_metadata.<locals>.<listcomp>) r r rH �reflectr r� r� r� r� r r� r� )ri rx r� r� �mrp r� r5 rD r6 � test_metadata% s z%ComponentReflectionTest.test_metadatac C s� t d|tdtdd�tdtdd�dd� |�|� t|�}|�d�}t|ddi� |�d�}d d � |D �}ddd �}t||� d S ) N�unicode_comments�unicodeu é試蛇ẟΩr �emojiu ☁️✨u 試蛇ẟΩ✨rO c S s i | ]}|d |d �qS r� r5 rx r5 r5 r6 rD K s zAComponentReflectionTest.test_comments_unicode.<locals>.<dictcomp>)r# r$ �r r r r� r r� r r� )ri rx rN rp �tcr` �valuer� r5 r5 r6 �test_comments_unicode: s � z-ComponentReflectionTest.test_comments_unicodec C sp t d|tdtdd�dd� |�|� t|�}|�d�}t|ddi� |�d�d }t|d |d iddi� d S ) Nr" r$ u& 🐍🧙🝝🧙♂️🧙♀️r u& 🎩🁰🝑🤷♀️🤷♂️rO r rY r� r% )ri rx rN rp r& r� r5 r5 r6 �test_comments_unicode_fullO s � z2ComponentReflectionTest.test_comments_unicode_full)N)NN)NF)mr8 r9 r: � run_inserts� run_deletesr� r; rO r� rX rL rJ r: r< rI r r� r rN rQ r[ �propertyr] rc rd rp rq r} r~ r� r� r� r� r rF Zschema_reflectionr� r� r� r� Zschema_create_deleter� r� r� r� �!foreign_key_constraint_reflectionrG r� r� rF r� rI r_ r� r� r� r� r� r� r- r� r� r� r� �!primary_key_constraint_reflectionr� r� r' r� r) r� r* r+ r� r� r� Ztemp_table_reflect_indexesr� r� r� r� �table_reflectionr� r� r� �fixturer� r� r� r� r� r� r� r r r r r r r r� r r r r� r! r( Z comment_reflection_full_unicoder) r5 r5 r5 r6 r� s . ! -� !� &� ` � 0 � X � u � E � : � � # � �� A � � & $ � � � V � � 1 �� �� � � r� c @ sh e Zd ZdZdZejdd� �Zejdd� �Zdd� Z d d � Z d d � Z ej j d d� �Zej j dd� �ZdS )�TableNoColumnsTest)Zreflect_tables_no_columnsTc C s t d|� |�|� d S �NrP )r r� �ri rx rN r5 r5 r6 �table_no_columnse s z#TableNoColumnsTest.table_no_columnsc C s< t d|� t�|dtd�� t�|dtd�� |�|� d S )NrP rP z*CREATE VIEW empty_v AS SELECT * FROM emptyrQ zDROP VIEW IF EXISTS empty_v)r r rR r r� r3 r5 r5 r6 �view_no_columnsj s � �z"TableNoColumnsTest.view_no_columnsc C s$ t dt� |d�}tt|j�g � d S )NrP r� �r r r r_ r� )ri rx r4 �t2r5 r5 r6 � test_reflect_table_no_columnsz s z0TableNoColumnsTest.test_reflect_table_no_columnsc C s2 t |�}t|�d�g � |�� }t|dg i� d S )NrP r2 )r r r� r )ri rx r4 rp �multir5 r5 r6 �!test_get_columns_table_no_columns~ s z4TableNoColumnsTest.test_get_columns_table_no_columnsc C s* t � }|�|� t|j��dg�s&t�d S r2 )r r r4 r� r� r� )ri rx r4 r r5 r5 r6 �"test_reflect_incl_table_no_columns� s z5TableNoColumnsTest.test_reflect_incl_table_no_columnsc C s$ t dt� |d�}tt|j�g � d S )N�empty_vr� r6 )ri rx r5 r7 r5 r5 r6 � test_reflect_view_no_columns� s z/TableNoColumnsTest.test_reflect_view_no_columnsc C s8 t |�}t|�d�g � |jtjd�}t|dg i� d S )Nr< )r� )Nr< )r r r� r r r� )ri rx r5 rp r9 r5 r5 r6 � test_get_columns_view_no_columns� s z3TableNoColumnsTest.test_get_columns_view_no_columnsN)r8 r9 r: � __requires__r� r r0 r4 r5 r8 r: r; rF r� r= r> r5 r5 r5 r6 r1 a s r1 c @ s� e Zd ZdZejdejjfddd�ejjdd� ��Z ejj dd� �Z ejj d d � �Z d d � Zejjd d� �Zejjdd� �Zejjdd� �Zejdddejjfdddejjfi ddejjfi ddejjfdddejjfdddejjfdd�dd� �ZdS )� ComponentReflectionTestExtraTr� r� r� c s� |r t j}nd }td|tdt� �tjddd�tjddd�|d� td |td t�d ��|d� |�|� t |�}t |j d|d�t � d �d �}dd� � � fdd�|D �}t|ddd�ddd�g� d }t|j ||d�g � d S )NZsa_ccr� za > 1 AND a < 5Zcc1r� za = 1 OR (a > 2 AND a < 5)Z UsesCasingrD r rA r rY r� c S s d� t�d| �� tj��S )N� zand|\d|=|a|or|<|>)�joinr� �findallr� �I)r� r5 r5 r6 � normalize� s �zJComponentReflectionTestExtra.test_get_check_constraints.<locals>.normalizec s" g | ]}|d � |d �d��qS )rY r� �rY r� r5 )rA �item�rE r5 r6 rz � s �zKComponentReflectionTestExtra.test_get_check_constraints.<locals>.<listcomp>za = 1 or a > 2 and a < 5rF za > 1 and a < 5)r rH r r r r\ r� r r� r r� r� r� r� r )ri rN rx r� rE rp r� r� r5 rH r6 r� � sL �� � � ���z7ComponentReflectionTestExtra.test_get_check_constraintsc s� t d|tdtd��tdtd��tdtd���}tdt�|jj�|jjt�|jj �� d�tdt� |jj��� td |jj� |� � � t � �}d dgd i d �g}� fd d �}||d � G dd� dt �}G �fdd�dt �}tjjj�rtdd dd g|d�d|d�gd d�} || � |�d| � dd g|d�� d��gd d�} || � |�| � t|�d�|� t� } t d| � d�} n8td��* t|�d�|� t� } t d| � d�} W 5 Q R X | �| |� jj� d S )Nr� �xr �y�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_longZt_idx_2F)rY rt r ru c s: t jjjr*g | d< � jj� d�g i| d< n | �di � d S )Nrv Z_includeru )r rF r� r/ r� rY r )�entryr� r5 r6 � completeIndex� s � zYComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.completeIndexr c @ s e Zd Zdd� ZdS )z[ComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.lower_index_strc S s |� � }d|ko d|kp d|kS )Nr� rI rJ �r� )ri r� �olr5 r5 r6 rf � s zbComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.lower_index_str.__eq__Nrg r5 r5 r5 r6 �lower_index_str� s rQ c s e Zd Z� fdd�ZdS )z^ComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.coalesce_index_strc s d|� � ko� |kS )N�coalescerO re ��long_strr5 r6 rf s zeComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.coalesce_index_str.__eq__Nrg r5 rS r5 r6 �coalesce_index_str� s rU zlower(x)zlower(y))rY rt rw r z coalesce(x, 'z')r� z>Skipped unsupported reflection of expression-based index t_idx)r r r r! r r� r� rI rK rJ rR r� r r� r rF Z reflect_indexes_with_expressionsr/ �insertr� r r� r r Z!compare_table_index_with_expectedr� rY ) ri rN rx r� rp r� rN rQ rU Z expr_indexZexpr_index_longr� r7 r5 )rx rT r6 �%test_reflect_expression_based_indexes� sp �& �� �� �� � �zBComponentReflectionTestExtra.test_reflect_expression_based_indexesc C s� t d|tdtd��tdtd���}td|jj�}dg|j|jj d< |� |� t |�}|� d�}t |ddgdgdt jd�g� t |d d d |jj dg� t dt� |d �}t t|j�d j|jj d dg� d S ) Nr� rI r rJ rL �includeF)rY rt rv r ru r ru z %s_includer� )r r r r! r� rI ru r� rY r� r r� r r( r� r r_ r� )ri rN rx r� r� rp r� r7 r5 r5 r6 �test_reflect_covering_index- sD � ��� ����z8ComponentReflectionTestExtra.test_reflect_covering_indexc G s@ t d|fdd� t|�D ��� }|�|� dd� t|��d�D �S )Nr� c S s g | ]\}}t d | |��qS )zt%dr )rA r� �type_r5 r5 r6 rz \ s zAComponentReflectionTestExtra._type_round_trip.<locals>.<listcomp>c S s g | ] }|d �qS )rS r5 rx r5 r5 r6 rz ` s )r r� rm r r� )ri rx rN r r� r5 r5 r6 �_type_round_tripX s �� z-ComponentReflectionTestExtra._type_round_tripc C sH | � ||t�dd��D ],}t|tj�s*t�t|jd� t|jd� qd S )N� r� )r[ r� r� r� r� r � precision�scale�ri rx rN �typr5 r5 r6 �test_numeric_reflectionb s � z4ComponentReflectionTestExtra.test_numeric_reflectionc C s8 | � ||t�d��d }t|tj�s(t�t|jd� d S )N�4 r )r[ r� r r� r� r �lengthr_ r5 r5 r6 �test_varchar_reflectionk s ��z4ComponentReflectionTestExtra.test_varchar_reflectionc C sT t d|tdtdd�tdtdd��}|�|� tdd� t|��d�D �ddd �� d S ) Nr� r� Tr� r� Fc S s i | ]}|d |d �qS )rY r� r5 r� r5 r5 r6 rD } s � zIComponentReflectionTestExtra.test_nullable_reflection.<locals>.<dictcomp>)r� r� )r r r rm r r r� )ri rx rN r� r5 r5 r6 �test_nullable_reflections s � ��z5ComponentReflectionTestExtra.test_nullable_reflectionNZCASCADEzSET NULLz NO ACTIONZRESTRICTzexpected,ondelete,onupdatec s" i }|r||d< |r ||d< |d kr(|}t d|tdtdd�dd� t d|tdtdd�td ttd d d ��td td��dd� t d|tdtdd�tdtd�dd�tdt�tjdgdgfddi|��dd� |�|� t|�}|� d�d d � t � fdd�� D �i � |� d�d d � t � |� d S )N�ondelete�onupdaterI r> Tr? r� r� Zx_idzx.id�xidr� �test� �userrY rB Fr� �tidztable.idZmyfkr r- c s i | ]}� | r|� | �qS r5 r5 )rA r� ��optsr5 r6 rD � s zMComponentReflectionTestExtra.test_get_foreign_key_options.<locals>.<dictcomp>) r r r r r r\ r� r� r r� r )ri rx rN r� rf rg r- rp r5 rm r6 � test_get_foreign_key_options� sV * � � ���� z9ComponentReflectionTestExtra.test_get_foreign_key_options)r8 r9 r: r� r r� rF rG r� r� Zindexes_with_expressionsrW r� rY r[ r/ ra rd re 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_restrictro r5 r5 r5 r6 r@ � sj � 5 Z * �������'r@ c @ s0 e Zd ZdZdZedd� �Zdd� Zdd� Zd S ) �NormalizedNameTest)Zdenormalized_namesTc C sL t tddd�|tdtdd�� t tddd�|tdtdd�tdtd��� d S ) Nr� T�r� r> r? r7 �t1idzt1.id)r r" r r r rM r5 r5 r6 rO � s � �z NormalizedNameTest.define_tablesc C s~ t � }ttddd�|tjd�}|jd }|jj�|jj �s>t �t � }|j tjdd� d� |jd jj�|jd jj �szt �d S ) Nr7 Trq r� r� c S s | � � dkS )N�r� r7 rO )rY r r5 r5 r6 r� � r� zINormalizedNameTest.test_reflect_lowercase_forced_tables.<locals>.<lambda>)�only) r r r" r r3 r� r� rr r� r> r� r )ri r� Zt2_refZt1_refZm3r5 r5 r6 �$test_reflect_lowercase_forced_tables� s � �z7NormalizedNameTest.test_reflect_lowercase_forced_tablesc C sP dd� t tj��� D �}t|d �� |d �� � t|d �� |d �� � d S )Nc S s g | ]}|� � d kr|�qS )rs rO r� r5 r5 r6 rz s �z;NormalizedNameTest.test_get_table_names.<locals>.<listcomp>r r� )r r r3 r� r �upperr� )ri Z tablenamesr5 r5 r6 r� s �z'NormalizedNameTest.test_get_table_namesN) r8 r9 r: r? r� r; rO ru r� r5 r5 r5 r6 rp � s rp c @ s< e Zd Zdd� Zdd� Zdd� Zdd� Zejj d d � �Z d S ) �ComputedReflectionTestc C s^ t tj�}|�d�}dd� |D �}td|d d k� t|d d d � t|d d d � d S ) N�computed_default_tablec S s i | ]}|d |�qS r� r5 rx r5 r5 r6 rD s zLComputedReflectionTest.test_computed_col_default_not_set.<locals>.<dictcomp>Z42� with_defaultrT �normal� computed_col)r r r3 r� r' r )ri rp r` Zcol_datar5 r5 r6 �!test_computed_col_default_not_set s z8ComputedReflectionTest.test_computed_col_default_not_setc C s� t tj�}|�d�}dd� |D �}dD ]}td|| k� q&|d }td|k� td|d k� t| �|d d �d� td |d ktjj j � tjj j r�t|d d tjj j � d S ) Nrx c S s i | ]}|d |�qS r� r5 rx r5 r5 r6 rD s zKComputedReflectionTest.test_get_column_returns_computed.<locals>.<dictcomp>)r> rz ry �computedr{ r� � normal+42� persisted) r r r3 r� r' r rE r rF �"computed_columns_reflect_persistedr/ �"computed_columns_default_persisted)ri rp r` rA r� �compDatar5 r5 r6 � test_get_column_returns_computed s$ � �z7ComputedReflectionTest.test_get_column_returns_computedc C sX t d|| k� || d }t| �|d �|� tjjjrTt d|k� t|d |� d S )Nr} r� r )r' r rE r rF r� r/ r )ri rA �columnr� r r� r5 r5 r6 � check_column, s z#ComputedReflectionTest.check_columnc C sp t tj�}|�d�}dd� |D �}| �|ddtjjj� tjj jrR| �|ddd� tjj jrl| �|d d d � d S ) N�computed_column_tablec S s i | ]}|d |�qS r� r5 rx r5 r5 r6 rD 8 s zLComputedReflectionTest.test_get_column_returns_persisted.<locals>.<dictcomp>�computed_no_flagr~ �computed_virtualznormal+2F�computed_storedz normal-42T) r r r3 r� r� r rF r� r/ �computed_columns_virtual�computed_columns_stored�ri rp r` rA r5 r5 r6 �!test_get_column_returns_persisted4 s. � � �z8ComputedReflectionTest.test_get_column_returns_persistedc C sv t tj�}|jdtjd�}dd� |D �}| �|ddtjjj � tjj j rX| �|ddd � tjj j rr| �|d d d � d S ) Nr� rD c S s i | ]}|d |�qS r� r5 rx r5 r5 r6 rD V s zXComputedReflectionTest.test_get_column_returns_persisted_with_schema.<locals>.<dictcomp>r� z normal/42r� znormal/2Fr� z normal*42T) r r r3 r� rH r� r rF r� r/ r� r� r� r5 r5 r6 �-test_get_column_returns_persisted_with_schemaO s4 �� � �zDComputedReflectionTest.test_get_column_returns_persisted_with_schemaN) r8 r9 r: r| r� r� r� r rF rG r� r5 r5 r5 r6 rw s rw c @ sH e Zd Zd ZZdZdZedd� �Zdd� Z dd � Z e j j d d � �ZdS ) �IdentityReflectionTestNT)Zidentity_columnsr/ c C s| t d|tdt�tdtt� �� t d|tdttdddd d dd d ��� tjjjrxt d|tdt�tdttdd d��tj d� d S )Nr� rz �id1r7 r� Tr r ���r � ��always�start� increment�minvalue�maxvalue�cycle�cacher )r� r� rD ) r r r r r rF rG r/ r rH rM r5 r5 r6 rO t s> ���� �z$IdentityReflectionTest.define_tablesc C s� t jjjr�d}t|�D ]}||kr|�|� q|r�tt|�t|�� |D ]T}|dkrjt|| || k� qH|dkr�t|| || k� qHt|| || |� qHq�t||� n$t|d |d � t|d |d � d S )Nr� r� > r� r� r� r� ) r rF Zidentity_columns_standardr/ r_ rV r r� r' )ri r' r� �approxZ common_keysr� r5 r5 r6 �check� s z IdentityReflectionTest.checkc C s t tj�}|�d�|�d� }|D ]�}|d dkr@td|k� q"|d dkr�d|kr`t|d � t|d d � td|k� | j|d td d d d d d d d �d d� q"|d dkr"d|kr�t|d � t|d d � td|k� | j|d td ddddd dd �d d� q"d S )Nr� r7 rY rz �identityr� rR rT Fr� ��r� T�r� r� r r r� r r� ) r r r3 r� r& r' r r� r2 �ri rp r` rl r5 r5 r6 �test_reflect_identity� sR � � � �z,IdentityReflectionTest.test_reflect_identityc C s� t tj�}|jdtjd�}|D ]~}|d dkr<td|k� q |d dkr d|kr\t|d � t|d d � td|k� | j|d t d d d d d d d d�d d� q d S )Nr� rD rY rz r� r� rR rT Tr r� r� Fr� r� ) r r r3 r� rH r& r' r r� r2 r� r5 r5 r6 � test_reflect_identity_schema� s. � �z3IdentityReflectionTest.test_reflect_identity_schema)r8 r9 r: r* r+ r� r? r; rO r� r� r rF rG r� r5 r5 r5 r6 r� n s ! ,r� c @ s< e Zd ZdZedd� �Zejjdd� �Z ejj dd� �Z dS ) �CompositeKeyReflectionTestTc C s� t d|tdt�tdt�tdt�d��tjddddd�d dd �}t d |tdtdd �td t�td t�tdt�d��tjdd d g|jj |jj |jj gdd�d dd � d S )N�tb1r> �attrrY r Zpk_tb1r� Tr� �tb2r? �pid�pattr�pnameZfk_tb1_name_id_attr) r r r r� r^ r\ r� r� r� rY r> r� )r4 rN r� r5 r5 r6 rO � s2 � ��z(CompositeKeyReflectionTest.define_tablesc C s2 t |�}|�| jjj�}t|�d�dddg� d S )Nr^ rY r> r� )r r� r� r� rY r r� )ri rx rp r@ r5 r5 r6 �test_pk_column_order s z/CompositeKeyReflectionTest.test_pk_column_orderc C s^ t |�}|�| jjj�}tt|�d� |d }t|�d�dddg� t|�d�dd d g� d S ) Nr� r rh rY r> r� r^ r� r� r� )r r� r� r� rY r r� r� )ri rx rp Z foreign_keysr� r5 r5 r6 �test_fk_column_order! s z/CompositeKeyReflectionTest.test_fk_column_orderN) r8 r9 r: r� r; rO r rF r. r� r- r� r5 r5 r5 r6 r� � s r� ) r� r@ r1 r� r� r< r� rp rw r� r� )Cr� r� r0 r\ r� r r r r r r r r Z provisionr r rE 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( rN r� Z TablesTestr) r< r� ZTestBaser� r� r� r� r1 r@ rp Z ComputedReflectionFixtureTestrw r� r� �__all__r5 r5 r5 r6 �<module> s� L; Y5 N+a 1