?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/testing/suite/__pycache__/test_reflection.cpython-39.pyc
???????
a ��Jhɲ � @ s� d dl Z d dlZd dlZd dlZddlmZ ddlmZ ddlmZ ddlm Z ddlm Z ddlm Z dd lm Z dd lm Z dd lmZ dd lmZ dd lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm Z ddlm Z ddlm Z dd lm Z! dd l"m#Z# dd l"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&l m/Z/ dd'l m0Z0 dd(l m1Z1 dd)l m2Z2 dd*l m3Z3 d+\Z4Z5G d,d-� d-e j6�Z7G d.d/� d/e7�Z8G d0d1� d1e j6�Z9G d2d3� d3e j:�Z;G d4d5� d5e j6�Z<d6d7� Z=G d8d9� d9e0e7�Z>G d:d;� d;e j:�Z?G d<d=� d=e/e j:�Z@G d>d?� d?e j6�ZAG d@dA� dAe jB�ZCG dBdC� dCe j6�ZDG dDdE� dEe j6�ZEdFZFdS )G� 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_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- � r8 �]/home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_reflection.py� setup_bind; s �z"OneConnectionTablesTest.setup_bindN)�__name__� __module__� __qualname__� classmethodr: r8 r8 r8 r9 r, : 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�schemasr2 r � test_schema�view_reflection� define_views�has_temp_table�define_temp_tables�r7 �metadatar8 r8 r9 � define_tablesM 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 rI rJ r2 r rK )r7 rQ �queryr8 r8 r9 rM c s ��� �zHasTableTest.define_viewsc C s t ttjdtj� ��S �NZ user_tmp_�r r r6 �ident�r7 r8 r8 r9 �temp_table_namey s �z HasTableTest.temp_table_namec C s� t ttj�}| �� }t||tdtjdd�tdt�d��fi |��}t j j j r�t j j j r�t�|dtdtj �� t�|dtd �� d S ) NrA TrB �namerE rS �=create temporary view user_tmp_v as select * from user_tmp_%srT �drop view user_tmp_v)r r r6 r[ r r �sa�INT�VARCHARr rI rL r2 �temporary_viewsr rU r# rY �r7 rQ �kw� table_name�user_tmpr8 r8 r9 rO s0 �������z HasTableTest.define_temp_tablesc C sj t j�� �L}tt jj�|d�� tt jj�|d�� tt jj�|d�� W d � n1 s\0 Y d S )Nr@ rF �nonexistent_table)r r6 �beginr* �dialect� has_tabler) ��self�connr8 r8 r9 �test_has_table� s zHasTableTest.test_has_tablec C s� t tj�}t|�d�� td|tdt��}t|�d�� |� tj� z4t|�d�� |� � t|�d�� W |� tj� n|� tj� 0 d S )Nr@ Z new_table�col) r r r6 r* rj r r r r) �create� clear_cache�drop)rl rQ �insp�ntr8 r8 r9 �test_has_table_cache� s z!HasTableTest.test_has_table_cachec C s| t j�� �^}tt jjj|dt jd�� tt jjj|dt jd�� tt jjj|dt jd�� W d � n1 sn0 Y d S )Nr@ rG rF rg )r r6 rh r) ri rj rK r* rk r8 r8 r9 �test_has_table_schema� s ������z"HasTableTest.test_has_table_schemac C sF t j�� �(}tt jjj|ddd�� W d � n1 s80 Y d S )Nr@ Znonexistent_schemarG )r r6 rh r) ri rj rk r8 r8 r9 �!test_has_table_nonexistent_schema� s ��z.HasTableTest.test_has_table_nonexistent_schemac C s t |�}t|�d�� d S �N�vv�r r* rj �rl � connectionrs r8 r8 r9 �test_has_table_view� s z HasTableTest.test_has_table_viewc C s" t |�}| �� }t|�|�� d S �N)r r[ r* rj )rl r| rs r[ r8 r8 r9 �test_has_table_temp_table� s z&HasTableTest.test_has_table_temp_tablec C s t |�}t|�d�� d S �N� user_tmp_vrz r{ r8 r8 r9 �test_has_table_temp_view� s z%HasTableTest.test_has_table_temp_viewc C s t |�}t|�dtj�� d S rx )r r* rj r rK r{ r8 r8 r9 �test_has_table_view_schema� s z'HasTableTest.test_has_table_view_schemaN)r; r< r= � __backend__r> rR rM r[ rO rn ru r rI rJ rv rw �viewsr} rN r rL rb r� r� r8 r8 r8 r9 r? J s4 r? c @ sX e Zd ZdZdZedd� �Zejdddd�Z d d � Z e d d � �Z ej j e d d� ��ZdS )� HasIndexTestT)�index_reflectionc C s� t d|tdtdd�tdtd��tdtd���}td|jj� tjj j r|t d|tdtdd�tdtd��t j d �}td |jj� d S ) Nr@ rA TrB rD rE �data2�my_idxrG �my_idx_s) r r r r r$ �crD r rI rJ r2 r rK )r7 rQ �ttr8 r8 r9 rR � s" � �zHasIndexTest.define_tablesri � inspector�kind��argnamesc s" |dkr� fdd�S t � �jS d S )Nri c s t jjj� g| �R i |��S r~ )r r6 ri � has_index)�a�k�rm r8 r9 �<lambda>� � z)HasIndexTest._has_index.<locals>.<lambda>)r r� )rl r� rm r8 r� r9 � _has_index� s zHasIndexTest._has_indexc C s& | � ||�}|dd�sJ �|dd�r(J �|dd�r6J �|dd�rDJ �|dd�rRJ �|dd�r`J �td| jjjj�}td|td t�tdd ��}|� |� |� |� zj|d kr�|dd�r�J �|dd�r�J �|j � � |dd�d u s�J �|dd�d u s�J �W |� |� |� |� n|� |� |� |� 0 d S ) Nr@ r� r� rg Znonexistent_idxZmy_idx_2Z test_table_2Zmy_idx_3�foor� T) r� r$ �tablesr@ r� r� r r r rp �__self__rq rr )rl r� r| rQ �meth�idxZtblr8 r8 r9 �test_has_index s6 � � zHasIndexTest.test_has_indexc C s` | � ||�}|ddtjd�s J �|ddtjd�r4J �|ddtjd�rHJ �|ddtjd�r\J �d S )Nr@ r� rG r� rg Znonexistent_idx_s)r� r rK )rl r� r| r� r8 r8 r9 �test_has_index_schema s � �z"HasIndexTest.test_has_index_schemaN)r; r< r= r� � __requires__r> rR r � combinationsr� r� r� rI rJ r� r8 r8 r8 r9 r� � s r� c @ sX e Zd ZdZdZdZejdddddd �e�d dd g�ejd d dddd �dd� ���Z dS )� BizarroCharacterFKResolutionTestztests for #10275T)�!foreign_key_constraint_reflection)rA )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�J �|�r|jj�| jd ��sJ �d S ) NrA T)�keyrC �� test_needs_fk�id2rB �other�ref�ref2�� autoload_withr � )r r r Z append_columnr_ �ForeignKeyConstraintr� rA r� r � create_allr r� r� � referencesr� ) rl r| rQ r� r� r� r� �m2Zo2�t1r8 r8 r9 � test_fk_ref3 s@ � � � z,BizarroCharacterFKResolutionTest.test_fk_refN) r; r< r= �__doc__r� r� r r� Z variationr� r8 r8 r8 r9 r� - s ��r� c @ s� e Zd ZdZdZedd� �Zdd� Zedd� �Zee j j d d � ��Z ed d � �Z ed d� �Zee j jdd� ��Zee j jdd� ��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 ' onerA r\ rE rD Z related_idzpk quote ' one�r\ 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�relatedrB r� z"CREATE VIEW %s AS SELECT * FROM %s�view %srS rT z DROP VIEW %s)r r r r r_ �PrimaryKeyConstraintr$ �UniqueConstraintr� �CheckConstraintr rI �symbol_names_w_double_quoter2 �view_column_reflectionr r6 ri Zidentifier_preparer�quoter rU r# )r7 rQ �namesr\ rV r8 r8 r9 rR m s� � � � � � � � �� �� ����z$QuotedNameArgumentTest.define_tablesc C s t �ddt jjf�| �S )N)r� r� )r r� rI r� )�fnr8 r8 r9 �quote_fixtures� s ��z%QuotedNameArgumentTest.quote_fixturesc C sd t tj�}tjjjr.|�|�}tt |t �� n2t t �� |�|� W d � n1 sV0 Y d S r~ ) r r r6 r rI �reflect_table_optionsr2 �get_table_optionsr* � isinstancer5 r �NotImplementedError)rl r\ rs �resr8 r8 r9 �test_get_table_options� s z-QuotedNameArgumentTest.test_get_table_optionsc C s t tj�}|�d| �s J �d S )Nr� )r r r6 �get_view_definition�rl r\ rs r8 r8 r9 �test_get_view_definition� s z/QuotedNameArgumentTest.test_get_view_definitionc C s t tj�}|�|�sJ �d S r~ )r r r6 � get_columnsr� r8 r8 r9 �test_get_columns� s z'QuotedNameArgumentTest.test_get_columnsc C s t tj�}|�|�sJ �d S r~ )r r r6 �get_pk_constraintr� r8 r8 r9 �test_get_pk_constraint� s z-QuotedNameArgumentTest.test_get_pk_constraintc C s t tj�}|�|�sJ �d S r~ )r r r6 �get_foreign_keysr� r8 r8 r9 �test_get_foreign_keys� s z,QuotedNameArgumentTest.test_get_foreign_keysc C s t tj�}|�|�sJ �d S r~ )r r r6 � get_indexesr� r8 r8 r9 �test_get_indexes� s z'QuotedNameArgumentTest.test_get_indexesc C s t tj�}|�|�sJ �d S r~ )r r r6 �get_unique_constraintsr� r8 r8 r9 �test_get_unique_constraints� s z2QuotedNameArgumentTest.test_get_unique_constraintsc C s t tj�}|�|�sJ �d S r~ )r r r6 �get_table_commentr� r8 r8 r9 �test_get_table_comment� s z-QuotedNameArgumentTest.test_get_table_commentc C s t tj�}|�|�sJ �d S r~ )r r r6 �get_check_constraintsr� r8 r8 r9 �test_get_check_constraints� s z1QuotedNameArgumentTest.test_get_check_constraintsN)r; r< r= Zrun_create_tablesr� r> rR r� r� r rI r� r� r� r� r� r� r� r� � unique_constraint_reflectionr� �comment_reflectionr� �check_constraint_reflectionr� r8 r8 r8 r9 r� i s: 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 r~ )r rK r8 r8 r8 r9 r� r� z$_multi_combination.<locals>.<lambda>rH r� r/ r� TF� use_filter) r r� rI rJ r �DEFAULT� TEMPORARY�ANYr �TABLE�VIEW�MATERIALIZED_VIEWZANY_VIEW)r� rH r/ r� � filter_namesr8 r8 r9 �_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 r~ )�define_reflected_tablesr rI rJ r2 r rK rP r8 r8 r9 rR # 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 g|�R � 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 u �r6td;|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�rjtdC|jj|jjd d � tdD|jj|jj|jj� |�sjtdE|tdFt� d ��d dG�}tdH|td-tj d d �tdFt� d ��d dG�}t jj j�rjt jj j�rjtdI|jj � � � tdJ|jj � � � t jj j�r�| �!||� |�s�t jj"j�r�| �#|� d S )KN�.� z%susers.user_id� user_id_fkr� r8 �users�user_idTrB �test1� F��nullable�test2�parent_user_id� test2 > 0�zz_test2_gt_zero�users check constraint�r\ r� � test2 <= 1000�rH r� � dingalings� dingaling_id� address_idz %semail_addresses.address_id�zz_email_add_id_fg� di fk comment�id_userrD � )�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_testrA � id comment)rC r� �data % comment�r� �d2�)Comment types type speedily ' " \ '' Fun!�d3�* �Comment with escapes� the test % ' " \ table comment)rH r� �no_constraints�"no constraints has escaped comment� local_table� remote_idz%s.remote_table_2.id)r� rH � 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 rI � self_referential_foreign_keysr2 r r r r_ r` ZCHARZFloatr r� r r� r� r� r� �cross_schema_fk_reflectionr rK r6 ri �default_schema_namer� r$ r� r� �indexes_with_ascdesc� reflect_indexes_with_ascdescr% �descr� rM �temp_table_reflectionrO )r7 rQ rH Z schema_prefixZparent_id_argsr� r$ r& r8 r8 r9 r� ) s> ������ ���� �� ��� �������� ��� �� z/ComponentReflectionTest.define_reflected_tablesc C s t ttjdtj� ��S rW rX rZ r8 r8 r9 r[ � s �z'ComponentReflectionTest.temp_table_namec C s� t ttj�}| �� }t||tdtjdd�tdt�d��tdtj�tj ddtj � �d�t� d d�fi |��}t j jjr�t j jjr�t�|d td tj �� t�|d td �� d S )NrA TrB r\ rE r� � user_tmp_uq_r� � user_tmp_ixrS r] rT r^ )r r r6 r[ r r r_ r` ra r� rY r$ r rI rL r2 rb r rU r# rc r8 r8 r9 rO � s6 �������z*ComponentReflectionTest.define_temp_tablesc C s� t jjjrdh}nt� }dD ]�}|}|r6|� d|� �}|d }||v rJdnd}d|� d|� d |� �}t�|d t|�� ||v r�d } |r�t �d �r�|� d| � �} d | � d|� d�} t�|d t| �� t�|dtd|� d|� ��� q d S )Nr� �r� r r� r� Z_vz MATERIALIZED r� zCREATE zVIEW z AS SELECT * FROM rS � mat_index�oraclez CREATE INDEX z ON z(data)rT zDROP ) r rI �materialized_viewsr2 �setr rU r# �against) r7 rQ rH � materializedre �fullnameZ view_name�prefixrV Z index_namer� r8 r8 r9 rM � 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� )rl r� r� r� r8 r� r8 r8 r9 � _resolve_kind s z%ComponentReflectionTest._resolve_kindc C s< t jjjs |�� |�� n t jjjs8|�|� |�� d S r~ )r rI r� r2 �clearr5 r; )rl r� r8 r8 r8 r9 �_resolve_views$ s z&ComponentReflectionTest._resolve_viewsc s� dd� �|t ju rdd� �|t ju r,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 )NTr8 )�_r8 r8 r9 r� - r� z8ComponentReflectionTest._resolve_names.<locals>.<lambda>c S s d| d vS �N�tmpr� r8 �r� r8 r8 r9 r� / r� c S s d| d v S r@ r8 rB r8 r8 r9 r� 1 r� r r! r r$ r& r� c s> i | ]6\}}�|�r|d �� vr� r4|d � v r||�qS )r� r8 )�.0r� �v�r� �removedrH Z scope_filterr8 r9 � <dictcomp>N s �z:ComponentReflectionTest._resolve_names.<locals>.<dictcomp>)r r� r� r r rK r[ rI r* r2 �addr; r� r/ �temp_table_namesrb �items)rl rH r/ r� �valuesr� r8 rE r9 �_resolve_names, sD �� � ��� �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> r[ r< rL ) rl rH r/ r� r� r8 r� r� r� r8 r8 r9 � exp_optionsW s* � � 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�textrM rN rO r� r� r� r r r r r r r r! r$ r& )r> r[ r< rL ) rl rH r/ r� r� �emptyr8 r� r� r� r8 r8 r9 � exp_commentsv s4 � �� �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)r\ � autoincrement�type�defaultr� r� �omitrU )r+ r� �pop)r\ �autorW r� r� r� r8 r8 r9 ro � s � z0ComponentReflectionTest.exp_columns.<locals>.colc s" dt jdd�|�}� | fi |��S )NTF)rZ rW r� �r+ r� )r\ rd �ro r8 r9 �pk� s z/ComponentReflectionTest.exp_columns.<locals>.pkrM r rX )rZ r� r r rD rN r r rO r� r� r� r� r� r� rA r\ r� r� r� r r r r r r r r r r r r r r r! r$ r% r& rP ) rl rH r/ r� r� r] r8 r� r� r� r8 r\ r9 � exp_columns� s� � �� � ��� ��� � � ��'z#ComponentReflectionTest.exp_columnsc C s h d�S )N> r� rV r\ rW r8 �rl r8 r8 r9 �_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 u�r t j| d< �q | � || ||�} | � |||| �} | S )Nr� c W s t |�| |d�S )N)�constrained_columnsr\ r� )�list)r\ r� �colsr8 r8 r9 r] s �z+ComponentReflectionTest.exp_pks.<locals>.pkr� rM r rN rO r� r� r� r� r r r r r rA r r r r! r$ r& r\ ) r+ r� r rI Z materialized_views_reflect_pkr2 r> r[ �reflects_pk_namesrK r< rL ) rl rH r/ r� r� r] rS r8 r� r� �valr� r8 r8 r9 �exp_pks� s> � � � z ComponentReflectionTest.exp_pksc C s ddhS )Nr\ ra r8 r_ r8 r8 r9 �_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 ju�rXt j| d!< �qX�qP| � ||||�} | �|||| �} | S )"Nc @ s e Zd Zdd� ZdS )z+ComponentReflectionTest.exp_fks.<locals>.ttc S s |d u pt jjj|kS r~ )r r6 ri r+ �rl r� r8 r8 r9 �__eq__: s �z2ComponentReflectionTest.exp_fks.<locals>.tt.__eq__N�r; r< r= ri r8 r8 r8 r9 r� 9 s r� c s$ | ||t j|d ur|n� � ||d�S )N)ra �referred_columnsr\ r0 �referred_schema�referred_tabler� r[ )rc Zref_colZ ref_table� ref_schemar\ r� �r� r8 r9 �fk@ s �z+ComponentReflectionTest.exp_fks.<locals>.fkrM rN rO r� r� r� r� r� r� r� r r r r r r� r r r r r rA r! )rn r r r$ r& r\ )r+ r� r> r rK r[ r rI r) r2 r= �named_constraintsrK r< rL ) rl rH r/ r� r� rp r8 r� r� �valsre r� r8 ro r9 �exp_fks2 sn � � ��� ���� �# z ComponentReflectionTest.exp_fksc C s h d�S )N> rm r\ rk ra rl r8 r_ r8 r8 r9 �_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 fg |d ddd��|ddddd ��|ddddd��|dfg |d tjddd��|dtjdd��|ddd ddd��|d fg |d tjd ��|d tjdd��|d fg |d!fg |d"fg |d#tjdd��|d$fg |d%tjdd��|d&fg |d'fg |d(d)d(d*id+��|d,fg |d(d-d(d*id+��|| �� fg |d.d/d ��|d0d1tj� �ddd2��i }tjj j �r�tjj j �s�||d'f � � ||d,f � � | � ||||�} | �|||| �} | S )3NF)r �column_sorting� duplicatesrp 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 ) Nr8 )r � column_namesr\ �dialect_options�include_columnsru rw � expressionsc s g | ]}|� v rd n|�qS r~ r8 �rC r� �ru r8 r9 � <listcomp>� s zDComponentReflectionTest.exp_indexes.<locals>.idx.<locals>.<listcomp>Zduplicates_constraint) r rI Z foreign_keys_reflect_as_indexZ#unique_constraints_reflect_as_indexZ*reflect_indexes_with_ascdesc_as_expressionr2 rb r+ r� ) r\ r ru rv rp rc Zfk_reqZdup_reqZsorting_expressionr� �origr8 r| r9 r� � s4 � ��� � z0ComponentReflectionTest.exp_indexes.<locals>.idxrM rN rO r� rD r3 r� r� r� r� T)r\ rp r� r� r� r# r" )r\ r r� )r\ r rv r r r r r r r r r r r r r r! r$ r% r' )r. )r\ ru r& r( r� r1 r\ r0 )r\ rv r )r> �extendr+ r� r[ r rY r rI r, r2 r- r= r< rL ) rl rH r/ r� r� r� r8 r� r� r� r8 r8 r9 � exp_indexes� s� � % � � ������� ������ �� � ���5��z#ComponentReflectionTest.exp_indexesc C s h d�S )N> r rw r\ r8 r_ r8 r8 r9 �_required_index_keys s z,ComponentReflectionTest._required_index_keysFc C s. d dd d�dd�}|dfg i}|dfg |dfg |dfg i}| � ||� |d fg |d d d d d d��|dfg |dtjtjd��|dddddd��|dfg |dfg |dfg |dfg |dfg |d fg |d fg |d fg || �� fg |d d tj� �d!��i } |�ri |�|�| �S | �|| ||�} | �|||| �} | S d S )"NF)�duplicates_index�is_indexr� c W s8 t jj}|r|jsdS t|�| |d�}|r2||d< |gS )Nr8 )rw r\ r� r� )r rI Z*unique_index_reflect_as_unique_constraintsr2 rb )r\ r� r� r� rc �reqr� r8 r8 r9 �uc s �z+ComponentReflectionTest.exp_ucs.<locals>.ucrM rN rO r� r� r� r� r" T)r\ r� r� r� rD )r\ r� r r r r )r\ r� r� r r r r r r! r$ r& r\ r0 r� )r> r+ r� r[ r rY r< rL ) rl rH r/ r� r� �all_r� r8 r� r� r� r8 r8 r9 �exp_ucs sZ � � �� ��� �� z ComponentReflectionTest.exp_ucsc C s ddhS )Nr\ rw r8 r_ r8 r8 r9 �_required_unique_cst_keysR 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�}| |v S )N�(r� �)�`)�lower�replace)rl r� r� r8 r8 r9 ri ^ s ����z2ComponentReflectionTest.exp_ccs.<locals>.tt.__eq__Nrj r8 r8 r8 r9 r� ] s r� c s � | �||d�S )N)�sqltextr\ r� r8 )rR r\ r� ro r8 r9 �ccg s z+ComponentReflectionTest.exp_ccs.<locals>.ccrM rN rO 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� r[ r< rL ) rl rH r/ r� r� r� r8 r� r� r� r8 ro r9 �exp_ccsV sF � ���� �z ComponentReflectionTest.exp_ccsc C s ddhS )Nr\ r� r8 r_ r8 r8 r9 �_required_cc_keys� s z)ComponentReflectionTest._required_cc_keysc C s t |�}ttjj|�� v � d S r~ )r r* r r rK �get_schema_namesr{ r8 r8 r9 �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 rK r) r{ r8 r8 r9 �test_has_schema� s z'ComponentReflectionTest.test_has_schemac C s8 |j ddttjjid�}t|�}ttjj|�� v � dS )z test #7300r� �bar�Zschema_translate_mapN)�execution_optionsr& r r rK r r* r� r{ r8 r8 r9 �%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 rK r r* r� r) r{ r8 r8 r9 � test_has_schema_w_translate_map� s ��z7ComponentReflectionTest.test_has_schema_w_translate_mapc C s� t |�}td|�� v � t|�d�� |�td�� zVtd|�� v � t|�d�� |�� td|�� v � t|�d�� W |�td�� n|�td�� 0 d S )NZfoo_barzCREATE SCHEMA foo_barzDROP SCHEMA foo_bar)r r) r� r� �executer# rq r* r{ r8 r8 r9 �test_schema_cache� s z)ComponentReflectionTest.test_schema_cachec C s$ t �� }t|� t|jd�s J �d S )Nr+ )r r4 r �hasattrri )rl �enginer8 r8 r9 �test_dialect_initialize� s z/ComponentReflectionTest.test_dialect_initializec C s t |�}t|j|jj� d S r~ )r r r+ ri r{ r8 r8 r9 � test_get_default_schema_name� s z4ComponentReflectionTest.test_get_default_schema_name� foreign_key�order_byr� � use_schemac s� |r t j}nd }h d�� t|�}|r:dd� |�|�D �}n |�|�}� fdd�|D �}|dkrrg d�}t||� ng d�}tt|�|� d S )N> r$ r! r r r r& r c S s g | ]}|d r|d �qS )r r8 )rC Zrecr8 r8 r9 r} � s �z@ComponentReflectionTest.test_get_table_names.<locals>.<listcomp>c s g | ]}|� vr|�qS r8 r8 �rC �t�Z_ignore_tablesr8 r9 r} � r� r� r2 )r� r r� )r rK r Z get_sorted_table_and_fkc_names�get_table_namesr �sorted) rl r| r� r� rH rs r� � table_names�answerr8 r� r9 �test_get_table_names� s � z,ComponentReflectionTest.test_get_table_namesc C sl t |�}|rtj}nd }|�|�}tjjjrRtt |�ddg� t|� |�dg� ng d�}tt |�|� d S )NrN rO rM )rM rN rO ) r r rK �get_view_namesr rI r5 r2 r r� �get_materialized_view_names)rl r| r� rs rH r� r� r8 r8 r9 �test_get_view_names s z+ComponentReflectionTest.test_get_view_namesc C s, t |�}|�� }tt|�dtj� �g� d S rW )r Zget_temp_table_namesr r� r rY �rl r| rs rI r8 r8 r9 �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� r8 r8 r9 �test_get_temp_view_names s z0ComponentReflectionTest.test_get_temp_view_namesc C s | � |� d S r~ )�_test_get_comments�rl r| r8 r8 r9 �test_get_comments! s z)ComponentReflectionTest.test_get_commentsc C s | � |tjj� d S r~ )r� r r rK r� r8 r8 r9 � 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 )NrG r r� )r rT r r� r� r r\ )rl r| rH rs �exp�no_cstr8 r8 r9 r� * s& � � � �z*ComponentReflectionTest._test_get_comments)FFzuse_views,use_schemac C sj |r t j}nd }| jj| jj }}|r0g d�}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�|tjtjfv r�tj}tt t|j��|j��tj tj tjtjtj tj tj g��dkd |j |j| | d |f � |j!s�| | d d u s�J �q�qNd S ) N�rO rN rM r� r rG r r\ rV r4 z%s(%s), %s(%s)rW )"r rK r� r� r r �zipr� r* �len� enumerate�columnsr r\ � __class__rV r� r_ r Z TypeEnginer r7 � sql_types�Dater r6 �__mro__� intersectionr �NumericZTimer Z_BinaryrC )rl r| Z use_viewsr� rH r� � addressesr� rs re �tableZ schema_namerc �iro �ctypeZ ctype_defr8 r8 r9 r� B s\ � �������z(ComponentReflectionTest.test_get_columnsc C s6 | � � }| j| }t|t� |d�}| j||dd� d S )Nr� F)Zstrict_constraints)r[ r� r r Zassert_tables_equal)rl r| re rf Zreflected_user_tmpr8 r8 r9 � 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 r\ ) r[ r� r r� r* r� r� r� r r\ )rl r| re rf rs rc r� ro r8 r8 r9 �test_get_temp_table_columns� s z3ComponentReflectionTest.test_get_temp_table_columnsc C s. t |�}|�d�}tdd� |D �g d�� d S )Nr� c S s g | ] }|d �qS r� r8 �rC ro r8 r8 r9 r} � r� zFComponentReflectionTest.test_get_temp_view_columns.<locals>.<listcomp>)rA r\ r� )r r� r )rl r| rs rc r8 r8 r9 �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 d � n1 s�0 Y | jjj } | � |j| |d�g||| f g| j � d S )NrG ra r\ r )r r rK r� r� r r rf r� r\ � _check_listrg r rI rd �fail_ifr ) rl r| r� rH r� r� rs r� Z users_consZ addr_consZexp_colsr� r8 r8 r9 r� � s* �, �z.ComponentReflectionTest.test_get_pk_constraintc C s~ |r t j}nd }| jj| jj }}t|�}|}tjjj r�|j |j |d�}|d } tjj � � � t| d d� W d � n1 s�0 Y t| d |� t| d |j � t| d dg� t| d d g� |j |j |d�} | d } tjj� � � t| d d u� W d � n1 �s0 Y t| d |� t| d |j � t| d dg� t| d d g� | jjj } t|j | |d�g � d S ) NrG r r\ r� rl rm rk r� ra r� r )r rK r� r� r r r rI r) r2 r� r\ rq r� r � implicitly_named_constraintsr* r ) rl r| r� rH r� r� rs Zexpected_schemaZ users_fkeys�fkey1Z addr_fkeysr� r8 r8 r9 r� � s2 ,0 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 |jjfv � 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 rl rm rk rA ra r rG r ) r� ri r+ r r rK r r� r\ r r� r* ) rl r| r r r! rs Z local_fkeysr� Z remote_fkeysZfkey2r8 r8 r9 �"test_get_inter_schema_foreign_keys� s8 � ����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� rG ) r rK r r� r� r� r� r� r r\ )rl r| r� rH rs �indexesr� r� r8 r8 r9 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 rb r� r\ )rl r| �tnameZixnamers r� Zexpected_indexesr� r8 r8 r9 �test_get_noncol_index8 s z-ComponentReflectionTest.test_get_noncol_indexc C sB t |�}| �� }|�|�}| jdd�d |f }| �||| j� d S )NT)r� )r r[ r� r� r� r� )rl r| rs r\ � reflectedr� r8 r8 r9 �&test_get_temp_table_unique_constraintsN s z>ComponentReflectionTest.test_get_temp_table_unique_constraintsc C sn t |�}| �� }|�|�}|D ]}|�dd � q ddgdd�g}tjjjrVg |d d< tdd � |D �|� d S ) Nrx Fr� r1 )r rw r\ r ry c S s g | ]}|d dkr|�qS )r\ r1 r8 �rC r� r8 r8 r9 r} d r� zGComponentReflectionTest.test_get_temp_table_indexes.<locals>.<listcomp>) r r[ r� rY r rI � index_reflects_included_columnsr2 r )rl r| rs re r� �ind�expectedr8 r8 r9 �test_get_temp_table_indexesW s � �z3ComponentReflectionTest.test_get_temp_table_indexesc C s |r t j}nd }tddgd�dg d�d�dg d�d�dd d gd�d d gd�d dgd�gt�d�d�}td|tdt�d��td t�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 ]N\} } | �dd �} | �rP| �| � t| �dd �d � | �dd � t| | � �q,t� }td|||d�} dd� | jD �}d d� | jD ��dg�}|�|��r�J �| �r�t| |� t|t� � | jjj }t|j||d�g � d S ) NZunique_ar� )r\ rw Z unique_a_b_c)r� �br� Z unique_c_a_b)r� r� r� Zunique_asc_keyZascr� z i.have.dotsr� z i have spacesr� r\ �r� Ztesttblr r rG rw r� r� rx )r� rH c S s h | ] }|j �qS r8 r� r� r8 r8 r9 � <setcomp>� r� zFComponentReflectionTest.test_get_unique_constraints.<locals>.<setcomp>c S s h | ]}t |tj�r|j�qS r8 )r� r_ r� r\ )rC Zuqr8 r8 r9 r� � s �) r rK r� �operator� itemgetterr r r_ r r Zappend_constraintr� rp r r� r6 r r� r� rY rH r r� � constraints� differencer� r� r r\ )rl rQ r| r� rH Zuniquesr� r� rs r� Znames_that_duplicate_indexr~ ZreflZdupeZreflected_metadataZ idx_namesZuq_namesr� r8 r8 r9 r� h sz �� � � � � �� z3ComponentReflectionTest.test_get_unique_constraintsc C s@ |r t j}nd }t|�}dD ] }|j||d�}tt|�� q d S )Nr� rG )r rK r r� r* �bool)rl r| r� rH rs �viewrD r8 r8 r9 r� � s z0ComponentReflectionTest.test_get_view_definitionc C sp t |�}tt�� |�d� W d � n1 s00 Y tt�� |�d� W d � n1 sb0 Y d S )NZview_does_not_existr� )r r r! r� r{ r8 r8 r9 �'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 J �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� r8 r{ r8 r8 r9 rG � r� zBComponentReflectionTest.test_autoincrement_col.<locals>.<dictcomp>rU TN)r r� �get)rl r| rs r� �cnamerc Zid_r8 r8 r9 �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 �� n6t t �� |jd|d� W d � n1 s�0 Y d S )Nr� rG r )r r r6 rK r rI r� r2 r� r* r� r5 r r� )rl r� rs rH r� r8 r8 r9 r� � s z.ComponentReflectionTest.test_get_table_optionsc s� t tj�� tjjjrV|r tjnd �� j�d�}� �fdd�� j �d�D �}t ||� n0t t �� � �� W d � n1 s|0 Y d S )NrG c s i | ]}�|f� j |�d ��qS )rG )r� )rC r� �rs rH r8 r9 rG s �zHComponentReflectionTest.test_multi_get_table_options.<locals>.<dictcomp>) r r r6 r rI r� r2 rK �get_multi_table_optionsr� r r r� )rl r� r� r� r8 r� r9 � test_multi_get_table_options s � z4ComponentReflectionTest.test_multi_get_table_optionsc s � fdd�}|S )Nc s t � �}||d� ||d�}| r&| � } g }tj|v rB|�g d�� tj|v rZ|�ddg� tj|v rr|�ddg� | r~| |d< |r�||d< || |||�d�d �} |g} |tjkr�|� � } | � d � | � | � |tjkr�|� � } | � d � | � | � t � �| | fS ) Nr )r/ r� )r r� �does-not-existrN r� rM rH r� )rH r/ r� r� r/ r� ) r r r� r r� r� r� r r� �copyrY �append) rH r/ r� r� Zsingle_reflect_fnZ exp_methodrs rd r� r� �kwsZnkw�r| r8 r9 �provide_fixture sD � � z>ComponentReflectionTest.get_multi_exp.<locals>.provide_fixturer8 )rl r| r� r8 r� r9 � get_multi_exp s .z%ComponentReflectionTest.get_multi_expc C sL |||||t j| j�\}}}|D ]&} |�� |jf i | ��} t| |� q d S r~ )r r� rQ rq r� r � rl r� rH r/ r� r� rs r� r� rd �resultr8 r8 r9 �#test_multi_get_table_options_tablesF s � z;ComponentReflectionTest.test_multi_get_table_options_tablesc C sH |||||t j| j�\}}}|D ]"} |�� t|jf i | ��|� q d S r~ )r r� rT rq r Zget_multi_table_comment) rl r� rH r/ r� r� rs r� r� rd r8 r8 r9 � test_get_multi_table_commentX s � z4ComponentReflectionTest.test_get_multi_table_commentc sV t d�dd�� t|t�r8t� fdd�|�� D �||� nt� fdd�|D �||� d S )N�rR c S s t �dd| ��� S )Nz['\" ]r� )�re�subr� r� r8 r8 r9 �_cleanj s z:ComponentReflectionTest._check_expressions.<locals>._cleanc s i | ]\}}� |�|�qS r8 r8 )rC �erD �r� r8 r9 rG n r� z>ComponentReflectionTest._check_expressions.<locals>.<dictcomp>c s g | ] }� |��qS r8 r8 )rC r� r� r8 r9 r} p r� z>ComponentReflectionTest._check_expressions.<locals>.<listcomp>)r� r� r5 r rJ )rl r� r� �err_msgr8 r� r9 �_check_expressionsi s z*ComponentReflectionTest._check_expressionsc C s� |d u rt |||� n�t t|�t|�|� t||�D ]~\}}t|�t|�B D ]d}||v sh||v rL||v rL|� d|� d|� �}|dv r�| �|| || |� qLt || || |� qLq4d S )Nz - )rz ru )r r� r� r6 r� ) rl r� r� �req_keys�msg�rr� r� r� r8 r8 r9 r� r s z#ComponentReflectionTest._check_listc C s\ t t|�� �t|�� �� |D ]8}|| || }}|rF|g|g }}| �||||� q d S r~ )r r6 �keysr� )rl r� r� r� � make_listsr� r r� r8 r8 r9 �_check_table_dict� s z)ComponentReflectionTest._check_table_dictc C sR |||||t j| j�\}}}|D ],} |�� |jf i | ��} | �| || j� q d S r~ )r r� r^ rq �get_multi_columnsr r` r� r8 r8 r9 �test_get_multi_columns� s � z.ComponentReflectionTest.test_get_multi_columnsc C sV |||||t j| j�\}}}|D ]0} |�� |jf i | ��} | j| || jdd� q d S )NT)r )r r� rf rq Zget_multi_pk_constraintr rg r� r8 r8 r9 � 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 �dtjfv V qdS )r\ N)r� r+ r� )rC rD r8 r8 r9 � <genexpr>� s z7ComponentReflectionTest._adjust_sort.<locals>.<genexpr>r� )r rI r� r2 rK r� �any�sort)rl r� r� r� �objre r8 r8 r9 � _adjust_sort� s �z$ComponentReflectionTest._adjust_sortc C sd |||||t j| j�\}}}|D ]>} |�� |jf i | ��} | �| |dd� � | �| || j� q d S )Nc S s t | d �S )Nra ��tuple��dr8 r8 r9 r� � r� zEComponentReflectionTest.test_get_multi_foreign_keys.<locals>.<lambda>)r r� rs rq Zget_multi_foreign_keysr r rt r� r8 r8 r9 �test_get_multi_foreign_keys� s � �z3ComponentReflectionTest.test_get_multi_foreign_keysc C sR |||||t j| j�\}}}|D ],} |�� |jf i | ��} | �| || j� q d S r~ )r r� r� rq Zget_multi_indexesr r� r� r8 r8 r9 �test_get_multi_indexes� s � z.ComponentReflectionTest.test_get_multi_indexesc C sd |||||t j| j�\}}}|D ]>} |�� |jf i | ��} | �| |dd� � | �| || j� q d S )Nc S s t | d �S )Nrw r r r8 r8 r9 r� � r� zKComponentReflectionTest.test_get_multi_unique_constraints.<locals>.<lambda>)r r� r� rq Z get_multi_unique_constraintsr r r� r� r8 r8 r9 �!test_get_multi_unique_constraints� s � z9ComponentReflectionTest.test_get_multi_unique_constraintsc C sd |||||t j| j�\}}}|D ]>} |�� |jf i | ��} | �| |dd� � | �| || j� q d S )Nc S s t | d �S �Nr� r r r8 r8 r9 r� r� zJComponentReflectionTest.test_get_multi_check_constraints.<locals>.<lambda>)r r� r� rq Zget_multi_check_constraintsr r r� r� r8 r8 r9 � test_get_multi_check_constraints� s � z8ComponentReflectionTest.test_get_multi_check_constraintsr� r� r� r� r� r� r� r� �methodc C sF t |�}t||�}tt�� |d� W d � n1 s80 Y d S )NZtable_does_not_exists)r �getattrr r! )rl r r| rs r� r8 r8 r9 �test_not_existing_table s z/ComponentReflectionTest.test_not_existing_tablec s� t j� � fdd�}tj�t d|��R ttd��( t|��t dt � �d � W d � n1 s\0 Y W d � n1 sz0 Y d S )Nc s& |� di �}td�|d< � | i |��S )NZ unreflectable�err)N� some_table)� setdefaultr" )r� r� �ur�Zmcr8 r9 �patched$ s z;ComponentReflectionTest.test_unreflectable.<locals>.patchedr r r ) r r r+ �patch�objectr r" r Z reflect_tabler r )rl r| r r8 r r9 �test_unreflectable! s �z*ComponentReflectionTest.test_unreflectabler� c s� t � }|rtjnd � |j|� |dd� t|�}|�� �}|rp||�� �7 }z||�� �7 }W n tyn Y n0 � r�� fdd�|D �}t t |j �t |�� d S )NF)rH r� Z resolve_fksc s g | ]}� � d |� ��qS )r� r8 r� rG r8 r9 r} A r� z9ComponentReflectionTest.test_metadata.<locals>.<listcomp>) r r rK �reflectr r� r� r� r� r r� r� )rl r| r� r� �mrs r� r8 rG r9 � 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 試蛇ẟΩ✨rR c S s i | ]}|d |d �qS r� r8 r{ r8 r8 r9 rG U r� zAComponentReflectionTest.test_comments_unicode.<locals>.<dictcomp>)r& r' �r r r r� r r� r r� )rl r| rQ rs �tcrc �valuer� r8 r8 r9 �test_comments_unicodeD 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& 🎩🁰🝑🤷♀️🤷♂️rR r r\ r� r( )rl r| rQ rs r) r� r8 r8 r9 �test_comments_unicode_fullY s � z2ComponentReflectionTest.test_comments_unicode_full)N)NN)NF)mr; r< r= � run_inserts� run_deletesr� r> rR r� r[ rO rM r< r> rL r r� r rQ rT r^ �propertyr` rf rg rs rt r� r� r� r� r� r� r rI Zschema_reflectionr� r� r� r� Zschema_create_deleter� r� r� r� r� rJ r� r� rI r� rL rb 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, r8 r8 r8 r9 r� s� . ! -� !� &� ` � 0 � X � u � E � : �� #� �� A � � & $� � � X� � 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 �NrS )r r� �rl r| rQ r8 r8 r9 �table_no_columnso s z#TableNoColumnsTest.table_no_columnsc C s< t d|� t�|dtd�� t�|dtd�� |�|� d S )NrS rS z*CREATE VIEW empty_v AS SELECT * FROM emptyrT zDROP VIEW IF EXISTS empty_v)r r rU r# r� r5 r8 r8 r9 �view_no_columnst s � �z"TableNoColumnsTest.view_no_columnsc C s$ t dt� |d�}tt|j�g � d S )NrS r� �r r r rb r� )rl r| r6 �t2r8 r8 r9 � test_reflect_table_no_columns� s z0TableNoColumnsTest.test_reflect_table_no_columnsc C s2 t |�}t|�d�g � |�� }t|dg i� d S )NrS r4 )r r r� r )rl r| r6 rs �multir8 r8 r9 �!test_get_columns_table_no_columns� s z4TableNoColumnsTest.test_get_columns_table_no_columnsc C s* t � }|�|� t|j��dg�s&J �d S r4 )r r" r6 r� r� )rl r| r6 r# r8 r8 r9 �"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� r8 )rl r| r7 r9 r8 r8 r9 � 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� )rl r| r7 rs r; r8 r8 r9 � test_get_columns_view_no_columns� s z3TableNoColumnsTest.test_get_columns_view_no_columnsN)r; r< r= r� r� r r2 r6 r7 r: r< r= rI r� r? r@ r8 r8 r8 r9 r3 k s r3 c @ s� e Zd ZdZejddgd�dd� �Ze�� dd� �Zdd � Zej j d d � �Z ej j ej d d ddd�dd� ��Zej j ej ddddd�dd� ��Zej j dd� �Zej jdd� �Zej jdd � �Zd d � Zej jd d � �Zej jd!d"� �Zej jd#d$� �Zej dd%dej jfddd&ej jfi dd'ej jfi d'dej j fddd(ej j fdd(dej j fd)d�d*d+� �Z ej e e!�"d,�d-fe d,d-fe#e!�$� d.fe e!�"d/�d0ej j%fe e!�"d1�d2ej j%fe&e'�(� d3fe e!�)d4�e!�)d5� d0ej j%fd6d�ej j*d7d8� ��Z+dS )9� ComponentReflectionTestExtraTF)�paramsc C s |j r tjS d S d S r~ )�paramr rK )rl �requestr8 r8 r9 �use_schema_fixture� s z/ComponentReflectionTestExtra.use_schema_fixturec s t j� ��fdd��}|S )Nc 3 s �t � �fV ��� � d S r~ )r r� )r� �r| rQ rE r8 r9 �go� s z:ComponentReflectionTestExtra.inspect_for_table.<locals>.go)� contextlib�contextmanager)rl rQ r| rE rG r8 rF r9 �inspect_for_table� s z.ComponentReflectionTestExtra.inspect_for_tablec sD dd� � t � fdd�|D �dd� d�}t |dd� d�}t||� d S ) Nc S s d� t�d| �� tj��S )N� zand|\d|=|a|b|c|or|<|>)�joinr� �findallr� �I)r� r8 r8 r9 � normalize� s �z5ComponentReflectionTestExtra.ck_eq.<locals>.normalizec s" g | ]}|d � |d �d��qS )r\ r� �r\ r� r8 )rC �item�rO r8 r9 r} � s �z6ComponentReflectionTestExtra.ck_eq.<locals>.<listcomp>c S s | d S r r8 �rQ r8 r8 r9 r� � r� z4ComponentReflectionTestExtra.ck_eq.<locals>.<lambda>r� c S s | d S r r8 rS r8 r8 r9 r� � r� )r� r )rl r� r� r8 rR r9 �ck_eq� s ���z"ComponentReflectionTestExtra.ck_eqc C sb |d��0\}}t d|tdt�d��|d� W d � n1 s>0 Y | �|jd|d�g � d S )Nr rD r rG )r r r_ r rT r� )rl rQ rJ rH r� r8 r8 r9 �#test_check_constraint_no_constraint� s �$ �z@ComponentReflectionTestExtra.test_check_constraint_no_constraint� my_inlineZMyInlineN�constraint_namer� c C s� |d��R\}}t d|tdt� dd�tdt� tjd|d��tdtd ��|d � W d � n1 s`0 Y |jd|d �}| �||p�tj d d �g� d S ) N�sa_ccrA TrB r� �a > 1 AND a < 5r� rD rE rG �a > 1 and a < 5rP ) r r r r_ r� r r� rT r+ r� �rl rQ rJ rW rH r� r� r8 r8 r9 � test_check_constraint_inline� s. �� �$���z9ComponentReflectionTestExtra.test_check_constraint_inlineZ my_ck_constZ MyCkConstc C s| |d��8\}}t d|tdt� �tjd|d�|d� W d � n1 sF0 Y |jd|d�}| �||pltjdd�g� d S )NrX r� za = 1 OR (a > 2 AND a < 5)r� rG za = 1 or a > 2 and a < 5rP ) r r r r_ r� r� rT r+ r� r[ r8 r8 r9 � test_check_constraint_standalone� s$ ��$ ���z=ComponentReflectionTestExtra.test_check_constraint_standalonec C s� |d���\}}t d|tdt� dd�tdt� t�d��tdt� tjdd d ��td t� �td td ��tjd dd �tjddd �tjd dd �|d� W d � n1 s�0 Y |jd|d�}| �|ddd�d dd�t j dd�g� d S )NrX rA TrB r� rY r� zb > 1 AND b < 5rV r� r� rD rE Zsome_uqzc > 1 AND c < 5Zcc1Z some_c_uqrG zc > 1 and c < 5rP zb > 1 and b < 5rZ ) r r r r_ r� r r� r� rT r+ r� )rl rQ rJ rH r� r� r8 r8 r9 �test_check_constraint_mixed s4 � �$ ��z8ComponentReflectionTestExtra.test_check_constraint_mixedc 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�rrdg d�|d�d|d�gd d�} || � |�d| � dd g|d�� d��gd d�} || � |�| � t|�d�|� t� } t d| � d�} nNtd��4 t|�d�|� t� } t d| � d�} W d � n1 �s�0 Y | �| |� 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)r\ rw r rx c s: t jjjr*g | d< � jj� d�g i| d< n | �di � d S )Nry Z_includerx )r rI r� r2 r� r\ r )�entryr� r8 r9 � completeIndexX 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|v o d|v p d|v S )Nr� r_ r` �r� )rl r� �olr8 r8 r9 ri d s zbComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.lower_index_str.__eq__Nrj r8 r8 r8 r9 �lower_index_strc s rg c s e Zd Z� fdd�ZdS )z^ComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.coalesce_index_strc s d|� � v o� |v S )N�coalescere rh ��long_strr8 r9 ri j s zeComponentReflectionTestExtra.test_reflect_expression_based_indexes.<locals>.coalesce_index_str.__eq__Nrj r8 ri r8 r9 �coalesce_index_stri s rk )Nra Nzlower(x)zlower(y))r\ rw rz r z coalesce(x, 'z')r� z>Skipped unsupported reflection of expression-based index t_idx)r r r r$ r r� r� r_ ra r` rh r� r r� r rI Z reflect_indexes_with_expressionsr2 �insertr� r r� r r Z!compare_table_index_with_expectedr� r\ ) rl rQ r| r� rs r� rd rg rk Z expr_indexZexpr_index_longr� r9 r8 )r| rj r9 �%test_reflect_expression_based_indexes< sl �& �� �� �� �. �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� r_ r r` rb �includeF)r\ rw ry r rx r rx z %s_includer� )r r r r$ r� r_ rx r� r\ r� r r� r r+ r� r rb r� )rl rQ r| r� r� rs r� r9 r8 r8 r9 �test_reflect_covering_index� sD � ��� ����z8ComponentReflectionTestExtra.test_reflect_covering_indexc G sB t d|gdd� t|�D ��R � }|�|� dd� t|��d�D �S )Nr� c S s g | ]\}}t d | |��qS )zt%dr )rC r� �type_r8 r8 r9 r} � r� zAComponentReflectionTestExtra._type_round_trip.<locals>.<listcomp>c S s g | ] }|d �qS )rV r8 r{ r8 r8 r9 r} � r� )r r� rp r r� )rl r| rQ r r� r8 r8 r9 �_type_round_trip� s �� z-ComponentReflectionTestExtra._type_round_tripc C sH | � ||t�dd��D ],}t|tj�s*J �t|jd� t|jd� qd S )N� r� )rq r� r� r� r Z precisionZscale�rl r| rQ �typr8 r8 r9 �test_numeric_reflection� s � z4ComponentReflectionTestExtra.test_numeric_reflectionc C s8 | � ||t�d��d }t|tj�s(J �t|jd� d S )N�4 r )rq r� r r� r �lengthrs r8 r8 r9 �test_varchar_reflection� 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 )r\ r� r8 r� r8 r8 r9 rG � s �zIComponentReflectionTestExtra.test_nullable_reflection.<locals>.<dictcomp>)r� r� )r r r rp r r r� )rl r| rQ r� r8 r8 r9 �test_nullable_reflection� s � ��z5ComponentReflectionTestExtra.test_nullable_reflectionZCASCADEzSET NULLz NO ACTIONZRESTRICTzexpected,ondelete,onupdatec s" i }|r||d< |r ||d< |d u r(|}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�onupdater_ rA TrB r� r� Zx_idzx.id�xidr� �test� �userr\ rE Fr� �tidztable.idZmyfkr r0 c s i | ]}� | r|� | �qS r8 r8 )rC r� ��optsr8 r9 rG E r� zMComponentReflectionTestExtra.test_get_foreign_key_options.<locals>.<dictcomp>) r r r r r r_ r� r� r r� r )rl r| rQ r� rz r{ r0 rs r8 r� r9 � test_get_foreign_key_options� sT * � � ���� z9ComponentReflectionTestExtra.test_get_foreign_key_options�10z'?10'?z1|truez3 + 5z3\+5z(3 * 5)z3\*5z current_timestamp|now|getdate�3�5z datatype, default, expected_regc C sd t d|tdtdd�td||d��}|�|� t|��d�d d }t�d d |�}t||tj d � d S ) Nr� rA TrB Zthecol)Zserver_defaultr� rW z [\(\) \']r� )�flags) r r r rp r r� r� r� r � IGNORECASE) rl rQ r| �datatyperW Z expected_regr� r� Zreflected_sanitizedr8 r8 r9 �test_server_defaultsK s � z1ComponentReflectionTestExtra.test_server_defaults),r; r< r= r� r r2 rE rJ rT rI r� rU Z"inline_check_constraint_reflectionr� r\ r] r^ Zindexes_with_expressionsrm r� ro rq r1 ru rx ry 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_ rR r �trueZexpression_server_defaultsr r �nowZliteral_columnZserver_defaultsr� r8 r8 r8 r9 rA � s� � � Z * �������' 6 �� ��rA 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� rA rB r9 �t1idzt1.id)r r% r r r rP r8 r8 r9 rR y s � �z NormalizedNameTest.define_tablesc C s~ t � }ttddd�|tjd�}|jd }|jj�|jj �s>J �t � }|j tjdd� d� |jd jj�|jd jj �szJ �d S ) Nr9 Tr� r� r� c S s | � � dv S )N�r� r9 re )r\ r# r8 r8 r9 r� � r� zINormalizedNameTest.test_reflect_lowercase_forced_tables.<locals>.<lambda>)�only) r r r% r r6 r� r� r� r� rA r" )rl r� Zt2_refZt1_refZm3r8 r8 r9 �$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 v r|�qS )r� re r� r8 r8 r9 r} � s �z;NormalizedNameTest.test_get_table_names.<locals>.<listcomp>r r� )r r r6 r� r �upperr� )rl Z tablenamesr8 r8 r9 r� � s �z'NormalizedNameTest.test_get_table_namesN) r; r< r= r� r� r> rR r� r� r8 r8 r8 r9 r� u s r� 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 v � t|d d d � t|d d d � d S ) N�computed_default_tablec S s i | ]}|d |�qS r� r8 r{ r8 r8 r9 rG � r� zLComputedReflectionTest.test_computed_col_default_not_set.<locals>.<dictcomp>Z42� with_defaultrW �normal� computed_col)r r r6 r� r* r )rl rs rc Zcol_datar8 r8 r9 �!test_computed_col_default_not_set� s z8ComputedReflectionTest.test_computed_col_default_not_setc C s� t tj�}|�d�}dd� |D �}dD ]}td|| v� q&|d }td|v � td|d v � t| �|d d �d� td |d v tjj j � tjj j r�t|d d tjj j � d S ) Nr� c S s i | ]}|d |�qS r� r8 r{ r8 r8 r9 rG � r� zKComputedReflectionTest.test_get_column_returns_computed.<locals>.<dictcomp>)rA r� r� �computedr� r� � normal+42� persisted) r r r6 r� r* r rO r rI �"computed_columns_reflect_persistedr2 �"computed_columns_default_persisted)rl rs rc rD r� �compDatar8 r8 r9 � test_get_column_returns_computed� s$ � �z7ComputedReflectionTest.test_get_column_returns_computedc C sX t d|| v � || d }t| �|d �|� tjjjrTt d|v � t|d |� d S )Nr� r� r� )r* r rO r rI r� r2 r )rl rD �columnr� r� r� r8 r8 r9 � 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� r8 r{ r8 r8 r9 rG � r� zLComputedReflectionTest.test_get_column_returns_persisted.<locals>.<dictcomp>�computed_no_flagr� �computed_virtualznormal+2F�computed_storedz normal-42T) r r r6 r� r� r rI r� r2 �computed_columns_virtual�computed_columns_stored�rl rs rc rD r8 r8 r9 �!test_get_column_returns_persisted� 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� rG c S s i | ]}|d |�qS r� r8 r{ r8 r8 r9 rG � r� zXComputedReflectionTest.test_get_column_returns_persisted_with_schema.<locals>.<dictcomp>r� z normal/42r� znormal/2Fr� z normal*42T) r r r6 r� rK r� r rI r� r2 r� r� r� r8 r8 r9 �-test_get_column_returns_persisted_with_schema� s2 �� � �zDComputedReflectionTest.test_get_column_returns_persisted_with_schemaN) r; r< r= r� r� r� r� r rI rJ r� r8 r8 r8 r9 r� � s r� c @ sH e Zd Zd ZZdZdZedd� �Zdd� Z dd � Z e j j d d � �ZdS ) �IdentityReflectionTestNT)Zidentity_columnsr1 c C s| t d|tdt�tdtt� �� t d|tdttdddd d dd d ��� tjjjrxt d|tdt�tdttdd d��tj d� d S )Nr� r� �id1r9 r� Tr r ���r � ��always�start� increment�minvalue�maxvalue�cycle�cacher )r� r� rG ) r r r r r rI rJ r2 r rK rP r8 r8 r9 rR s> ���� �z$IdentityReflectionTest.define_tablesc C s� t jjjr�d}t|�D ]}||vr|�|� q|r�tt|�t|�� |D ]T}|dkrjt|| || k� qH|dv r�t|| || k� qHt|| || |� qHq�t||� n$t|d |d � t|d |d � d S )Nr� r� > r� r� r� r� ) r rI Zidentity_columns_standardr2 rb rY r r� r* )rl r* r� �approxZ common_keysr� r8 r8 r9 �check) s z IdentityReflectionTest.checkc C s t tj�}|�d�|�d� }|D ]�}|d dkr@td|v � q"|d dkr�d|v r`t|d � t|d d � td|v � | j|d td d d d d d d d �d d� q"|d dkr"d|v r�t|d � t|d d � td|v � | j|d td ddddd dd �d d� q"d S )Nr� r9 r\ r� �identityr� rU rW Fr� ��r� T�r� r� r r r� r r� ) r r r6 r� r) r* r r� r5 �rl rs rc ro r8 r8 r9 �test_reflect_identityF sR � � � �z,IdentityReflectionTest.test_reflect_identityc C s� t tj�}|jdtjd�}|D ]~}|d dkr<td|v � q |d dkr d|v r\t|d � t|d d � td|v � | j|d t d d d d d d d d�d d� q d S )Nr� rG r\ r� r� r� rU rW Tr r� r� Fr� r� ) r r r6 r� rK r) r* r r� r5 r� r8 r8 r9 � test_reflect_identity_schemar s. � �z3IdentityReflectionTest.test_reflect_identity_schema)r; r< r= r- r. r� r� r> rR r� r� r rI rJ r� r8 r8 r8 r9 r� 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��tjg d�|jj |jj |jj gdd�d dd � d S )N�tb1rA �attrr\ r Zpk_tb1r� Tr� �tb2rB �pid�pattr�pname�r� r� r� Zfk_tb1_name_id_attr) r r r r� ra r_ r� r� r� r\ rA r� )r7 rQ r� r8 r8 r9 rR � s2 � ��z(CompositeKeyReflectionTest.define_tablesc C s0 t |�}|�| jjj�}t|�d�g d�� d S )Nra �r\ rA r� )r r� r� r� r\ r r� )rl r| rs rC r8 r8 r9 �test_pk_column_order� s z/CompositeKeyReflectionTest.test_pk_column_orderc C sZ t |�}|�| jjj�}tt|�d� |d }t|�d�g d�� t|�d�g d�� d S )Nr� r rk r� ra r� )r r� r� r� r\ r r� r� )rl r| rs Z foreign_keysr� r8 r8 r9 �test_fk_column_order� s z/CompositeKeyReflectionTest.test_fk_column_orderN) r; r< r= r� r> rR r rI r0 r� r� r� r8 r8 r8 r9 r� � s r� ) r� rA r3 r� r� r? r� r� r� r� r� )GrH r� r� r3 r_ r� r r r r r r r r r Z provisionr r rH 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+ rQ r� Z TablesTestr, r? r� ZTestBaser� r� r� r� r3 rA r� Z ComputedReflectionFixtureTestr� r� r� �__all__r8 r8 r8 r9 �<module> s� M< [5 X+a 1
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????