Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/site-packages/sqlalchemy/testing/suite/__pycache__/test_reflection.cpython-39.pyc
Ðазад
a _�h� � @ s� d dl Z d dlZd dlZddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm Z dd lm Z dd l m Z dd lmZ dd lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dl m Z d dlm Z d dlm Z d dl m!Z! d dlm"Z" d d lm#Z# d \Z$Z%G d d � d e j&�Z'G d d!� d!e j&�Z(G d"d#� d#e j&�Z)G d$d%� d%e j&�Z*G d&d'� d'e j+�Z,G d(d)� d)e j&�Z-d*Z.dS )+� N� )�assert_raises_message)�config)�engines)�eq_)�expect_warnings)�fixtures)�is_)�temp_table_keyword_args��Column)�Table� )�event)�exc)� ForeignKey)�inspect)�Integer)�MetaData)�String)�testing)�types)� Inspector)�DDL)�Index)� quoted_name)�is_false)�is_true)NNc @ s4 e Zd ZdZedd� �Zdd� Zejj dd� �Z dS ) � HasTableTestTc C sX t d|tdtdd�tdtd��� tjjjrTt d|tdtdd�tdtd��tj d� d S ) N� test_table�idT�� primary_key�data�2 � test_table_s��schema) r r r r r �requires�schemas�enabledr � test_schema��cls�metadata� r/ ��/root/rpmbuild/BUILDROOT/imh-python39-modules-3.9.7-92.el8.x86_64/opt/imh-python/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_reflection.py� define_tables& s � �zHasTableTest.define_tablesc C sj t j�� �L}tt jj�|d�� tt jj�|d�� tt jj�|d�� W d � n1 s\0 Y d S )Nr r% �nonexistent_table)r �db�beginr �dialect� has_tabler ��self�connr/ r/ r0 �test_has_table7 s zHasTableTest.test_has_tablec C s| t j�� �^}tt jjj|dt jd�� tt jjj|dt jd�� tt jjj|dt jd�� W d � n1 sn0 Y d S )Nr r& r% r2 )r r3 r4 r r5 r6 r+ r r7 r/ r/ r0 �test_has_table_schema= s ������z"HasTableTest.test_has_table_schemaN) �__name__� __module__� __qualname__� __backend__� classmethodr1 r: r r( r) r; r/ r/ r/ r0 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 t jjj�d | �t jjj�|�f }t�|d t|�� t�|d td t jjj�d | � �� �qHd S )!N� quote ' oner �namer$ r# Z related_idzpk quote ' one�rD zix quote ' onez uq quote' onez related.idzfk quote ' onez name != 'foo'zck quote ' onezquote ' one commentT)�comment� test_needs_fk� quote " twozpk quote " twozix quote " twoz uq quote" twozfk quote " twozck quote " two zquote " two comment�relatedr! �rG �"CREATE VIEW %s AS SELECT * FROM %s�view %s� after_create� before_drop� DROP VIEW %s)r r r r �sa�PrimaryKeyConstraintr �UniqueConstraint�ForeignKeyConstraint�CheckConstraintr r( �symbol_names_w_double_quoter* �view_column_reflectionr3 r5 Zidentifier_preparer�quoter �listenr )r- r. �namesrD �queryr/ r/ r0 r1 U s� � � � � � � � �� �� ����z$QuotedNameArgumentTest.define_tablesc C s t �ddt jjf�| �S )N)rC rH )r � combinationsr( rU )�fnr/ r/ r0 �quote_fixtures� s ��z%QuotedNameArgumentTest.quote_fixturesc C s t tj�}|�|� d S �N)r r r3 Zget_table_options�r8 rD �inspr/ r/ r0 �test_get_table_options� s z-QuotedNameArgumentTest.test_get_table_optionsc C s t tj�}|�d| �s J �d S )NrL )r r r3 �get_view_definitionr_ r/ r/ r0 �test_get_view_definition� s z/QuotedNameArgumentTest.test_get_view_definitionc C s t tj�}|�|�sJ �d S r^ )r r r3 � get_columnsr_ r/ r/ r0 �test_get_columns� s z'QuotedNameArgumentTest.test_get_columnsc C s t tj�}|�|�sJ �d S r^ )r r r3 �get_pk_constraintr_ r/ r/ r0 �test_get_pk_constraint� s z-QuotedNameArgumentTest.test_get_pk_constraintc C s t tj�}|�|�sJ �d S r^ )r r r3 �get_foreign_keysr_ r/ r/ r0 �test_get_foreign_keys� s z,QuotedNameArgumentTest.test_get_foreign_keysc C s t tj�}|�|�sJ �d S r^ )r r r3 � get_indexesr_ r/ r/ r0 �test_get_indexes� s z'QuotedNameArgumentTest.test_get_indexesc C s t tj�}|�|�sJ �d S r^ )r r r3 �get_unique_constraintsr_ r/ r/ r0 �test_get_unique_constraints� s z2QuotedNameArgumentTest.test_get_unique_constraintsc C s t tj�}|�|�sJ �d S r^ )r r r3 �get_table_commentr_ r/ r/ r0 �test_get_table_comment� s z-QuotedNameArgumentTest.test_get_table_commentc C s t tj�}|�|�sJ �d S r^ )r r r3 �get_check_constraintsr_ r/ r/ r0 �test_get_check_constraints� s z1QuotedNameArgumentTest.test_get_check_constraintsN)r< r= r> Zrun_create_tablesr? r@ r1 r] ra r r( rV rc re rg ri rk � unique_constraint_reflectionrm �comment_reflectionro �check_constraint_reflectionrq r/ r/ r/ r0 rA Q s6 S rA c @ s� e Zd Zd ZZdZedd� �Zedd� �Zedd� �Z ed d � �Z ed d � �Z ed d� �Z e jjdd� �Ze jjdd� �Ze jjdd� �Ze jd�dd��Ze jjdd� �Ze jje jje jjdd� ���Ze jjd d � �Ze jje jj d d � ��Z e jj d d!� �Z e jj e jj d"d#� ��Z!d�d$d%�Z"e jje jj d&d'� ��Z#e jj$d(d)� �Z%e jj$e jj d*d+� ��Z&e jje jj$d,d-� ��Z'd�d.d/�Z(e jjd0d1� �Z)e jd2d3� �Z*e jjd4d5� �Z+e jjd6d7� �Z,e jje jd8d9� ��Z-e jje jj d:d;� ��Z.e jj/d<d=� �Z0e jj/e jj$e jjd>d?� ���Z1e jj$d@dA� �Z2e jj$e jj dBdC� ��Z3e jd�dDdE��Z4e jj5dFdG� �Z6e jje jj5e jj dHdI� ���Z7e jje jdJdK� ��Z8e jd�dLdM��Z9e jj dNdO� �Z:e jj e jj dPdQ� ��Z;e jj<e jj dRdS� ��Z=e jj>dTdU� �Z?e jj@dVdW� �ZAe jdXdY� �ZBdZd[� ZCe jd�d\d]��ZDe jjEd^d_� �ZFe jjEe jj d`da� ��ZGe jdbdc� �ZHe jjEe jjIddde� ��ZJe jjEe jjIdfdg� ��ZKe jjLe jdhdi� ��ZMe jjNdjdk� �ZOe jj/e jjNdldm� ��ZPe jj/dndo� �ZQe jjNe jj dpdq� ��ZRe jd�drds��ZSe jjTdtdu� �ZUe jjTe jj dvdw� ��ZVe jd�dxdy��ZWe jd�dzd{��ZXe jjd|d}� �ZYe jje jj d~d� ��ZZe �[d�d��e jd�d�d����Z\d�d�� Z]e jj d�d�� �Z^e jje jd�d�� ��Z_dS )��ComponentReflectionTestNTc C s4 t jjjr*ddlm} tjt|j d�d�S t j S d S )Nr )�pool)Z poolclass)�options) r � requirementsZindependent_connectionsr* � sqlalchemyrv r �testing_engine�dictZ StaticPoolr3 )r- rv r/ r/ r0 � setup_bind� s �z"ComponentReflectionTest.setup_bindc C s* | � |d � tjjjr&| � |tjj� d S r^ )�define_reflected_tablesr r( r) r* r r+ r, r/ r/ r0 r1 � s z%ComponentReflectionTest.define_tablesc C s$ |r|d }nd}t jjjrztd|tdtjdd�tdt�d�d d �td t� d�d d �td tj tj d | dd��|dd�}nBtd|tdtjdd�tdt�d�d d �td t� d�d d �|dd�}td|tdtj dd�tdtj t� d| ��tdt� d��|dd� td|tdtj �tdtj t� |j j��tdt� d��tjddd�|dd� td |td tj dd d �tdt� d�d d!�td"t� d�d#d!�|d$d%� t jjj�rX|d u �r�td&|td tj dd�tdt� d��td't d(t jj ��dtjjjd)� nntd*|td tj dd�td+t d,tjjj ��tdt� d��|dd� td-|td tj dd�tdt� d��|dd� t jjj�r�| �||� |�s�td.|td/t� d��dd0�}td1|td tj dd�td/t� d��dd0�}t jjj�r�td2|j j�� � td3|j j�� � t jj j�r| � ||� |�s t jj j�r | � |� d S )4N�.� �users�user_idTr! �test1� F��nullable�test2�parent_user_idz%susers.user_id� user_id_fkrE �r' rG � dingalings� dingaling_id� address_idz %semail_addresses.address_idr# � �email_addresses�remote_user_idZ email_address� � email_ad_pk� comment_testr � id comment)r" rF �data % comment)rF �d2�)Comment types type speedily ' " \ '' Fun!� the test % ' " \ table comment)r' rF � local_table� remote_idz%s.remote_table_2.id)rG r' � remote_table�local_idz%s.local_table.id�remote_table_2�noncol_idx_test_nopk�qrJ �noncol_idx_test_pk�noncol_idx_nopk� noncol_idx_pk) r r( � self_referential_foreign_keysr* r r rP �INTZCHAR�Floatr r r �cr� rQ �cross_schema_fk_reflectionr r+ r3 r5 �default_schema_name�index_reflection� define_index�indexes_with_ascdescr r� �descrV � define_views�temp_table_reflection�define_temp_tables)r- r. r' Z schema_prefixr� r� r� r/ r/ r0 r} � s ���� �� � � �� �������� �� z/ComponentReflectionTest.define_reflected_tablesc C s� t ttj�}td|tdtjdd�tdt�d��tdtj�tjddd �t� d d�fi |��}t j j j r�t j jj r�t�|d td �� t�|d td�� d S )N�user_tmpr Tr! rD r$ �foo� user_tmp_uqrE � user_tmp_ixrM z:create temporary view user_tmp_v as select * from user_tmprN zdrop view user_tmp_v)r r r3 r r rP r� �VARCHARrR r r r( �view_reflectionr* �temporary_viewsr rX r )r- r. �kwr� r/ r/ r0 r� � s0 �� ����z*ComponentReflectionTest.define_temp_tablesc C s2 t d|jj|jj� t d|jj|jj|jj� d S )N� users_t_idx� users_all_idx)r r� r� r� r� )r- r. r� r/ r/ r0 r� � s z$ComponentReflectionTest.define_indexc C s^ dD ]T}|}|r d||f }|d }d||f }t �|dt|�� t �|dtd| �� qd S )N)r� r� z%s.%s�_vrK rM rN rO )r rX r )r- r. r' � table_name�fullnameZ view_namerZ r/ r/ r0 r� � s ��z$ComponentReflectionTest.define_viewsc C s$ t tj�}| �tjj|�� v � d S r^ )r r r3 �assert_r r+ Zget_schema_names�r8 r` r/ r/ r0 �test_get_schema_names� s z-ComponentReflectionTest.test_get_schema_namesc C s4 t �� }t|jd�rJ �t|� t|jd�s0J �d S )Nr� )r rz �hasattrr5 r )r8 Zenginer/ r/ r0 �test_dialect_initialize� s z/ComponentReflectionTest.test_dialect_initializec C s t tj�}t|jtjjj� d S r^ )r r r3 r r� r5 r� r/ r/ r0 � test_get_default_schema_name� s z4ComponentReflectionTest.test_get_default_schema_name�tablec s� g d�� | j }t|j�}|dkrJ|�|�}|�� ddg}tt|�|� nh|rddd� |�|�D �}n |�|�}� fdd�|D �}|dkr�g d �}t||� ng d �}tt|�|� d S ) N)r� r� r� r� r� r� �view�email_addresses_v�users_vc S s g | ]}|d r|d �qS )r r/ ��.0Zrecr/ r/ r0 � <listcomp>� s �zAComponentReflectionTest._test_get_table_names.<locals>.<listcomp>c s g | ]}|� vr|�qS r/ r/ �r� �t�Z_ignore_tablesr/ r0 r� � � � foreign_key)r� r� r� )r� r� r� ) r. r �bindZget_view_names�sortr �sortedZ get_sorted_table_and_fkc_names�get_table_names) r8 r' � table_type�order_by�metar` � table_namesZanswer�tablesr/ r� r0 �_test_get_table_names� s& � z-ComponentReflectionTest._test_get_table_namesc C s& t | j�}|�� }tt|�dg� d S )Nr� )r r� Zget_temp_table_namesr r� �r8 r` �temp_table_namesr/ r/ r0 �test_get_temp_table_names� s z1ComponentReflectionTest.test_get_temp_table_namesc C s& t | j�}|�� }tt|�dg� d S )N� user_tmp_v)r r� Zget_temp_view_namesr r� r� r/ r/ r0 �test_get_temp_view_names� s z0ComponentReflectionTest.test_get_temp_view_namesc C s | � � d S r^ �r� �r8 r/ r/ r0 �test_get_table_names s z,ComponentReflectionTest.test_get_table_namesc C s | j dd� d S )Nr� )r� r� r� r/ r/ r0 �test_get_table_names_fks s z0ComponentReflectionTest.test_get_table_names_fksc C s | � � d S r^ )�_test_get_commentsr� r/ r/ r0 �test_get_comments s z)ComponentReflectionTest.test_get_commentsc C s | � tjj� d S r^ )r� r r r+ r� r/ r/ r0 � test_get_comments_with_schema s z5ComponentReflectionTest.test_get_comments_with_schemac C st t tj�}t|jd|d�ddi� t|jd|d�dd i� tdd� |jd|d�D �dd d �d d d �d dd �g� d S )Nr� r& �textr� r� c S s g | ]}|d |d d��qS )rD rF )rD rF r/ r� r/ r/ r0 r� s �z>ComponentReflectionTest._test_get_comments.<locals>.<listcomp>r� r )rF rD r� r# r� r� )r r r3 r rn rd )r8 r' r` r/ r/ r0 r� s" � ����z*ComponentReflectionTest._test_get_commentsc C s | � tjj� d S r^ �r� r r r+ r� r/ r/ r0 � test_get_table_names_with_schema- s z8ComponentReflectionTest.test_get_table_names_with_schemac C s | j dd� d S �Nr� )r� r� r� r/ r/ r0 �test_get_view_names2 s z+ComponentReflectionTest.test_get_view_namesc C s | j tjjdd� d S r� r� r� r/ r/ r0 � test_get_view_names_with_schema6 s �z7ComponentReflectionTest.test_get_view_names_with_schemac C s | � � | j dd� d S r� r� r� r/ r/ r0 �test_get_tables_and_views= s z1ComponentReflectionTest.test_get_tables_and_viewsc C sl t tj�}| jj| jj }}ddg}|dkr4ddg}t|j�}t|||f�D �]\}} |} |j || d�} | � t | �dkt | �� t | j �D ]�\} } t| j| | d � | | d j}| j}t|tjj�r�|j}t�d �r�|tjtjfv r�tj}| � t t|j�� |j�� tj tj tjtjtj tj tj!g��dkd | j| j| | d |f � | j"s�| | d d u s�J �q�qLd S ) Nr� r� r� r� r� r& r rD �type�oraclez%s(%s), %s(%s)�default)#r r r3 r� r� r� r r� �ziprd r� �len� enumerate�columnsr rD � __class__r� � isinstancerP r Z TypeEngineZagainst� sql_types�Date�DateTime�set�__mro__� intersectionr �NumericZTimer Z_Binaryr" )r8 r' r� r� r� � addressesr� r` r� r� Z schema_name�cols�i�col�ctypeZ ctype_defr/ r/ r0 �_test_get_columnsC sX � �������z)ComponentReflectionTest._test_get_columnsc C s | � � d S r^ �r r� r/ r/ r0 re { s z(ComponentReflectionTest.test_get_columnsc G sF t d| jgdd� t|�D ��R � }|�� dd� t| jj��d�D �S )Nr� c S s g | ]\}}t d | |��qS )zt%dr )r� r� �type_r/ r/ r0 r� � r� z<ComponentReflectionTest._type_round_trip.<locals>.<listcomp>c S s g | ] }|d �qS )r� r/ �r� r� r/ r/ r0 r� � s )r r. r� �creater r� rd )r8 r r� r/ r/ r0 �_type_round_trip s ���z(ComponentReflectionTest._type_round_tripc C sD | � t�dd��D ],}t|tj�s&J �t|jd� t|jd� qd S )N� r� )r r� r� r� r � precision�scale�r8 �typr/ r/ r0 �test_numeric_reflection� s z/ComponentReflectionTest.test_numeric_reflectionc C s4 | � t�d��d }t|tj�s$J �t|jd� d S )N�4 r )r r� r r� r �lengthr r/ r/ r0 �test_varchar_reflection� s z/ComponentReflectionTest.test_varchar_reflectionc C s\ t d| jtdtdd�tdtdd��}|�� ttdd� t| jj�� d�D ��ddd �� d S ) Nr� �aTr� �bFc s s | ]}|d |d fV qdS )rD r� Nr/ �r� r� r/ r/ r0 � <genexpr>� s �zCComponentReflectionTest.test_nullable_reflection.<locals>.<genexpr>)r r ) r r. r r r r r{ r r� rd )r8 r� r/ r/ r0 �test_nullable_reflection� s ���z0ComponentReflectionTest.test_nullable_reflectionc C s | j tjjd� d S �Nr& �r r r r+ r� r/ r/ r0 � test_get_columns_with_schema� s z4ComponentReflectionTest.test_get_columns_with_schemac C sj t | j�}| jj}t|j�}|�d�}| �t|�dkt|�� t|j �D ] \}}t |j || d � qHd S )Nr� r rD ) r r� r� r� r rd r� r� r� r� r rD )r8 r� r� r` r� r� r� r/ r/ r0 �test_get_temp_table_columns� s z3ComponentReflectionTest.test_get_temp_table_columnsc C s0 t | j�}|�d�}tdd� |D �g d�� d S )Nr� c S s g | ] }|d �qS rE r/ r r/ r/ r0 r� � r� zFComponentReflectionTest.test_get_temp_view_columns.<locals>.<listcomp>)r rD r� )r r� rd r )r8 r` r� r/ r/ r0 �test_get_temp_view_columns� s z2ComponentReflectionTest.test_get_temp_view_columnsc C s | j dd� d S r� r r� r/ r/ r0 �test_get_view_columns� s z-ComponentReflectionTest.test_get_view_columnsc C s | j tjjdd� d S )Nr� )r' r� r r� r/ r/ r0 �!test_get_view_columns_with_schema� s �z9ComponentReflectionTest.test_get_view_columns_with_schemac C s� | j }| jj| jj }}t|j�}|j|j|d�}|d }t|dg� |j|j|d�}|d } t| dg� t j j � � � t|d d� W d � n1 s�0 Y d S )Nr& �constrained_columnsr� r� rD r� ) r. r� r� r� r r� rf rD r r r( Zreflects_pk_names�fail_if) r8 r' r� r� r� r` Z users_consZ users_pkeysZ addr_consZ addr_pkeysr/ r/ r0 �_test_get_pk_constraint� s z/ComponentReflectionTest._test_get_pk_constraintc C s | � � d S r^ )r r� r/ r/ r0 rg � s z.ComponentReflectionTest.test_get_pk_constraintc C s | j tjjd� d S r )r r r r+ r� r/ r/ r0 �"test_get_pk_constraint_with_schema� s z:ComponentReflectionTest.test_get_pk_constraint_with_schemac C s0 | j }| jj}t|j�}ttjd|j|j � d S )Nz+.*get_primary_keys\(\) method is deprecated) r. r� r� r r� r �sa_excZSADeprecationWarningZget_primary_keysrD )r8 r� r� r` r/ r/ r0 � test_deprecated_get_primary_keys� s �z8ComponentReflectionTest.test_deprecated_get_primary_keysc C sd | j }| jj| jj }}t|j�}|}tjjj r�|j |j |d�}|d }tjj � � � t|d d� W d � n1 sx0 Y t|d |� t|d |j � t|d dg� tjjj r�t|d d g� |j |j |d�} | d }tjj� � �" | �|d d u� W d � n1 �s0 Y t|d |� t|d |j � t|d dg� t|d d g� d S ) Nr& r rD r� �referred_schema�referred_table�referred_columnsr� r r� r� )r. r� r� r� r r� r r( r� r* rh rD Znamed_constraintsr r Z implicitly_named_constraintsr� ) r8 r' r� r� r� r` Zexpected_schemaZ users_fkeys�fkey1Z addr_fkeysr/ r/ r0 �_test_get_foreign_keys� s, , 2z.ComponentReflectionTest._test_get_foreign_keysc C s | � � d S r^ )r% r� r/ r/ r0 ri s z-ComponentReflectionTest.test_get_foreign_keysc C s | j tjjd� d S r )r% r r r+ r� r/ r/ r0 �!test_get_foreign_keys_with_schema s z9ComponentReflectionTest.test_get_foreign_keys_with_schemac C s | � dtjjj dtjj dtjj �\}}}ttj�}|�|j �}t t |�d� |d }t |d tjj� t |d |j � t |d d g� t |d d g� |j|j tjjd �}t t |�d� |d }|d d tjjjfv s�J �t |d |j � t |d d g� t |d d g� d S )Nz%s.local_tablez%s.remote_tablez%s.remote_table_2� r r! r" r# r r r� r& r� ) r� r r3 r5 r� r r+ r rh rD r r� ) r8 r� r� r� r` Z local_fkeysr$ Z remote_fkeysZfkey2r/ r/ r0 �"test_get_inter_schema_foreign_keys s2 � �� z:ComponentReflectionTest.test_get_inter_schema_foreign_keysc C s | j dd� d S )NZCASCADE)Zondelete�� _test_get_foreign_key_optionsr� r/ r/ r0 �%test_get_foreign_key_options_ondeleteC s z=ComponentReflectionTest.test_get_foreign_key_options_ondeletec C s | j dd� d S )NzSET NULL)Zonupdater) r� r/ r/ r0 �%test_get_foreign_key_options_onupdateG s z=ComponentReflectionTest.test_get_foreign_key_options_onupdatec s | j }td|tdtdd�dd� td|tdtdd�tdttjdd d ��td td ��dd� td |tdtdd�tdtd�dd�tdt�tjdgdgfddi|��dd� |�� t |j �}|� d�d d � t t � fdd�� D ��i � |� d �d d � t t � fdd�� D ��|� d S )N�xr Tr! rJ r� Zx_idzx.id�xidrE �test� �userrD r$ Fr� �tidztable.idZmyfkr rw c 3 s" | ]}� | r|� | fV qd S r^ r/ �r� �k��optsr/ r0 r s r� zHComponentReflectionTest._test_get_foreign_key_options.<locals>.<genexpr>c 3 s" | ]}� | r|� | fV qd S r^ r/ r3 r5 r/ r0 r v r� )r. r r r rP r r rS � create_allr r� rh r r{ )r8 rw r� r` r/ r5 r0 r* K sH � � ���� z5ComponentReflectionTest._test_get_foreign_key_optionsc C sZ dd� |D �}|D ]B}|d |v s&J �||� |d � }|D ]}t|| || � q<qd S )Nc S s g | ] }|d �qS rE r/ )r� �dr/ r/ r0 r� y r� z@ComponentReflectionTest._assert_insp_indexes.<locals>.<listcomp>rD )�indexr )r8 �indexes�expected_indexesZ index_namesZe_indexr9 �keyr/ r/ r0 �_assert_insp_indexesx s z,ComponentReflectionTest._assert_insp_indexesc C sN | j }t|j�}|jd|d�}dddgdd�dg d�d d�g}| �||� d S ) Nr� r& Fr� r� r� ��unique� column_namesrD )r� r� r� r� )r. r r� rj r= )r8 r' r� r` r: r; r/ r/ r0 �_test_get_indexes� s ��� z)ComponentReflectionTest._test_get_indexesc C s | � � d S r^ )rA r� r/ r/ r0 rk � s z(ComponentReflectionTest.test_get_indexesc C s | j tjjd� d S r )rA r r r+ r� r/ r/ r0 � test_get_indexes_with_schema� s z4ComponentReflectionTest.test_get_indexes_with_schemac C s� | j }t|j�}|�|�}d|d�g}| �||� t|||jd�}tt|j�d� t t |j�d j |� tt |j�d j |� d S )NF)r? rD )� autoload_withr' r ) r. r r� rj r= r r r� r: r �listr� rD )r8 �tnameZixnamer� r` r: r; r� r/ r/ r0 �_test_get_noncol_index� s z.ComponentReflectionTest._test_get_noncol_indexc C s | � dd� d S )Nr� r� �rF r� r/ r/ r0 �test_get_noncol_index_no_pk� s z3ComponentReflectionTest.test_get_noncol_index_no_pkc C s | � dd� d S )Nr� r� rG r� r/ r/ r0 �test_get_noncol_index_pk� s z0ComponentReflectionTest.test_get_noncol_index_pkc C s� t d| jtdtd��tdtd��� t�| jdtd�� t�| jdtd�� | j�� t| jj �}t d��, t |� d�d dgd d �g� W d � n1 s�0 Y d S ) Nr� r- r� �yrM z+CREATE INDEX t_idx ON t(lower(x), lower(y))z CREATE INDEX t_idx_2 ON t(x)z>Skipped unsupported reflection of expression-based index t_idxZt_idx_2r )rD r@ r? ) r r. r r r rX r r7 r r� r r rj r� r/ r/ r0 �%test_reflect_expression_based_indexes� s. �� � ��z=ComponentReflectionTest.test_reflect_expression_based_indexesc C s | � � d S r^ )� _test_get_unique_constraintsr� r/ r/ r0 rm � s z3ComponentReflectionTest.test_get_unique_constraintsc C sB t | j�}|�d�}|D ]}|�dd � qt|dgdd�g� d S )Nr� �duplicates_indexrD r� )r@ rD )r r� rl �popr )r8 r` � reflected�reflr/ r/ r0 �&test_get_temp_table_unique_constraints� s z>ComponentReflectionTest.test_get_temp_table_unique_constraintsc C sN t | j�}|�d�}|D ]}|�dd � qtdd� |D �ddgdd�g� d S ) Nr� Zdialect_optionsc S s g | ]}|d dkr|�qS )rD r� r/ �r� �idxr/ r/ r0 r� � r� zGComponentReflectionTest.test_get_temp_table_indexes.<locals>.<listcomp>Fr� r� r> )r r� rj rN r )r8 r` r: �indr/ r/ r0 �test_get_temp_table_indexes� s ���z3ComponentReflectionTest.test_get_temp_table_indexesc C s | j tjjd� d S r )rL r r r+ r� r/ r/ r0 �'test_get_unique_constraints_with_schema� s z?ComponentReflectionTest.test_get_unique_constraints_with_schemac C s� t ddgd�dg d�d�dg d�d�dd d gd�d d gd�d dgd�gt�d�d�}| j}td|tdt�d��td t�d��tdtj�td t�d��td t�d��|d�}|D ]"}|� tj |d d|d i�� q�|� � t |j �}t |jd|d�t�d�d�}t� }t||�D ]0\} } | �dd �} | �r4|�| � t| | � �qt� } td| |j |d�}tdd� |jD ��} tdd� |jD ���dg�}| �|��r�J �|�r�t|| � t|t� � d S )NZunique_ar )rD r@ Z unique_a_b_c)r r r� Z unique_c_a_b)r� r r Zunique_asc_key�ascr< z i.have.dotsr z i have spacesr� rD �r< Ztesttblr� r� r& r@ rM )rC r' c S s g | ] }|j �qS r/ rE rR r/ r/ r0 r� ? r� zHComponentReflectionTest._test_get_unique_constraints.<locals>.<listcomp>c S s g | ]}t |tj�r|j�qS r/ )r� rP rR rD )r� Zuqr/ r/ r0 r� A s �)r� �operator� itemgetterr. r r rP r r Zappend_constraintrR r7 r r� rl r� r� rN �addr r r: � constraints� differencer� )r8 r' Zuniques� orig_metar� Zuc� inspectorrO Znames_that_duplicate_index�origrP ZdupeZreflected_metadataZ idx_namesZuq_namesr/ r/ r0 rL � sp �� � � � � ��� z4ComponentReflectionTest._test_get_unique_constraintsc C s | � � d S r^ )�_test_get_check_constraintsr� r/ r/ r0 rq M s z2ComponentReflectionTest.test_get_check_constraintsc C s | j tjjd� d S r )ra r r r+ r� r/ r/ r0 �!test_get_check_constraints_schemaQ s z9ComponentReflectionTest.test_get_check_constraints_schemac s� | j }td|tdt� �tjddd�tjddd�|d� |�� t|j�}t |j d|d�t � d �d �}d d � � � fd d�|D �}t |ddd�ddd�g� d S )NZsa_ccr za > 1 AND a < 5Zcc1rE za = 1 OR (a > 2 AND a < 5)Zcc2r& rD rX c S s d� t�d| �� tj��S )N� zand|\d|=|a|or|<|>)�join�re�findall�lower�I)�sqltextr/ r/ r0 � normalizem s �zFComponentReflectionTest._test_get_check_constraints.<locals>.normalizec s" g | ]}|d � |d �d��qS )rD ri �rD ri r/ )r� �item�rj r/ r0 r� r s �zGComponentReflectionTest._test_get_check_constraints.<locals>.<listcomp>za > 1 and a < 5rk za = 1 or a > 2 and a < 5)r. r r r rP rT r7 r r� r� rp rY rZ r )r8 r' r^ r_ rO r/ rm r0 ra V s2 � � ���z3ComponentReflectionTest._test_get_check_constraintsc C sL | j }d}d}t|j�}|j||d�}| �|� |j||d�}| �|� d S )Nr� r� r& )r. r r� rb r� )r8 r' r� Z view_name1Z view_name2r` Zv1Zv2r/ r/ r0 �_test_get_view_definition~ s z1ComponentReflectionTest._test_get_view_definitionc C s | � � d S r^ )rn r� r/ r/ r0 rc � s z0ComponentReflectionTest.test_get_view_definitionc C s | j tjjd� d S r )rn r r r+ r� r/ r/ r0 �$test_get_view_definition_with_schema� s z<ComponentReflectionTest.test_get_view_definition_with_schema� postgresqlzPG specific featurec C s0 | j }t|j�}|�||�}| �t|t�� d S r^ )r. r r� Z get_table_oidr� r� �int)r8 r� r' r� r` �oidr/ r/ r0 �_test_get_table_oid� s z+ComponentReflectionTest._test_get_table_oidc C s | � d� d S )Nr� )rs r� r/ r/ r0 �test_get_table_oid� s z*ComponentReflectionTest.test_get_table_oidc C s | j dtjjd� d S )Nr� r& )rs r r r+ r� r/ r/ r0 � test_get_table_oid_with_schema� s z6ComponentReflectionTest.test_get_table_oid_with_schemac C sN | j }t|j�}dD ]4\}}|�|�}dd� |D �| }|�dd�sJ �qdS )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 rE r/ r r/ r/ r0 � <dictcomp>� r� zBComponentReflectionTest.test_autoincrement_col.<locals>.<dictcomp>� autoincrementTN)r. r r� rd �get)r8 r� r` rE �cnamer� Zid_r/ r/ r0 �test_autoincrement_col� s z.ComponentReflectionTest.test_autoincrement_col)Nr� N)N)Nr� )N)N)N)N)N)N)N)`r< r= r> Z run_insertsZ run_deletesr? r@ r| r1 r} r� r� r� r r( Zschema_reflectionr� r� r� �provide_metadatar� r� r� r� r� r� Ztable_reflectionr� �!foreign_key_constraint_reflectionr� rs r� r) r� r� r� rV r� r� r� r re r r r r r r� r r r r r �!primary_key_constraint_reflectionrg r r r% ri r& r� r( Z1foreign_key_constraint_option_reflection_ondeleter+ Z1foreign_key_constraint_option_reflection_onupdater, r* r= rA r� rk rB rF r� rH rI Zindexes_with_expressionsrK rr rm rQ rU rV rL rt rq rb ra rn rc ro Zonly_onrs rt ru rz r/ r/ r/ r0 ru � s> � & 8 ! , N ' ru c @ s0 e Zd ZdZdZedd� �Zdd� Zdd� Zd S ) �NormalizedNameTest)Zdenormalized_namesTc C sL t tddd�|tdtdd�� t tddd�|tdtdd�tdtd��� d S ) N�t1T�rW r r! �t2�t1idzt1.id)r r r r r r, r/ r/ r0 r1 � s � �z NormalizedNameTest.define_tablesc C s� t tj�}ttddd�|dd�}|jd }|jj�|jj �s@J �t tj�}|j dd� d� |jd jj�|jd jj �s|J �d S ) Nr� Tr� )Zautoloadr c S s | � � dv S )N�r r� �rg )rD �mr/ r/ r0 �<lambda>� r� zINormalizedNameTest.test_reflect_lowercase_forced_tables.<locals>.<lambda>)�only) r r r3 r r r� r� r� Z referencesr Zreflect)r8 �m2Zt2_refZt1_refZm3r/ r/ r0 �$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� r� r� r/ r/ r0 r� � s �z;NormalizedNameTest.test_get_table_names.<locals>.<listcomp>r r' )r r r3 r� r �upperrg )r8 Z tablenamesr/ r/ r0 r� � s �z'NormalizedNameTest.test_get_table_namesN) r< r= r> � __requires__r? r@ r1 r� r� r/ r/ r/ r0 r~ � s r~ c @ s< e Zd Zdd� Zdd� Zdd� Zdd� Zejj d d � �Z d S ) �ComputedReflectionTestc C sV t tj�}|�d�}|D ]8}|d dkr:td|d v � q|d st|d d � qd S )N�computed_column_tablerD � with_defaultZ42r� rw )r r r3 rd r r )r8 r` r� r� r/ r/ r0 �!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 ) NZcomputed_default_tablec S s i | ]}|d |�qS rE r/ r r/ r/ r0 rv � r� zKComputedReflectionTest.test_get_column_returns_computed.<locals>.<dictcomp>)r �normalr� �computedZ computed_colri � normal+42� persisted) r r r3 rd r r rj r r( �"computed_columns_reflect_persistedr* �"computed_columns_default_persisted)r8 r` r� r# r< �compDatar/ r/ r0 � 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� ri r� )r r rj r r( r� r* r )r8 r# �columnri r� r� r/ r/ r0 � 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 ) Nr� c S s i | ]}|d |�qS rE r/ r r/ r/ r0 rv r� zLComputedReflectionTest.test_get_column_returns_persisted.<locals>.<dictcomp>�computed_no_flagr� �computed_virtualznormal+2F�computed_storedz normal-42T) r r r3 rd r� r r( r� r* �computed_columns_virtual�computed_columns_stored�r8 r` r� r# r/ r/ r0 �!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� r& c S s i | ]}|d |�qS rE r/ r r/ r/ r0 rv / r� zXComputedReflectionTest.test_get_column_returns_persisted_with_schema.<locals>.<dictcomp>r� z normal/42r� znormal/2Fr� z normal*42T) r r r3 rd r+ r� r r( r� r* r� r� r� r/ r/ r0 �-test_get_column_returns_persisted_with_schema( s2 �� � �zDComputedReflectionTest.test_get_column_returns_persisted_with_schemaN) r< r= r> r� r� r� r� r r( r) r� r/ r/ r/ r0 r� � s r� c @ sH e Zd ZdZedd� �Zejjej dd� ��Z ejj ej 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�tb1r �attrrD r� Zpk_tb1rE Tr� �tb2r! �pid�pattr�pname�r� r� r� Zfk_tb1_name_id_attr) r r r r� r� rP rQ rS r� rD r r� )r- r. r� r/ r/ r0 r1 J s2 � ��z(CompositeKeyReflectionTest.define_tablesc C s8 | j }t|j�}|�| jjj�}t|�d�g d�� d S )Nr �rD r r� ) r. r r� rf r� r� rD r rx )r8 r� r` r" r/ r/ r0 �test_pk_column_orderf s z/CompositeKeyReflectionTest.test_pk_column_orderc C sb | j }t|j�}|�| jjj�}tt|�d� |d }t|� d�g d�� t|� d�g d�� d S )Nr' r r# r� r r� ) r. r r� rh r� r� rD r r� rx )r8 r� r` Z foreign_keysr$ r/ r/ r0 �test_fk_column_ordero s z/CompositeKeyReflectionTest.test_fk_column_orderN) r< r= r> r? r@ r1 r r( r} r{ r� r| r� r/ r/ r/ r0 r� G s r� )ru rA r r~ r� r� )/rY re ry rP r r r r r r r r Z provisionr r' r r r r r r r r r r r r r� Zengine.reflectionr r r Z sql.elementsr r r r. r� Z TablesTestr rA ru r~ Z ComputedReflectionFixtureTestr� r� �__all__r/ r/ r/ r0 �<module> sV . b(b5
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка