Submit
Path:
~
/
/
opt
/
alt
/
python37
/
lib64
/
python3.7
/
site-packages
/
sqlalchemy
/
testing
/
suite
/
__pycache__
/
File Content:
test_reflection.cpython-37.pyc
B ��4]\� � @ sf d dl Z d dlZd dlZddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm Z dd lm Z dd l m Z dd l mZ d d lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dl m Z d dl m Z d dl m Z d\Z Z!G dd � 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_)�Column)�Table� )�event)�exc)� ForeignKey)�inspect)�Integer)�MetaData)�String)�testing)�types)� Inspector)�DDL)�Index)� quoted_name)NNc @ s$ e Zd ZdZedd� �Zdd� ZdS )� HasTableTestTc C s& t d|tdtdd�tdtd��� d S )N� test_table�idT)� primary_key�data�2 )r r r r )�cls�metadata� r" �[/opt/alt/python37/lib64/python3.7/site-packages/sqlalchemy/testing/suite/test_reflection.py� define_tables# s zHasTableTest.define_tablesc C sB t j�� �.}t jj�|d�s t�t jj�|d�r4t�W d Q R X d S )Nr Znonexistent_table)r �dbZbegin�dialectZ has_table�AssertionError)�selfZconnr" r" r# �test_has_table, s zHasTableTest.test_has_tableN)�__name__� __module__� __qualname__� __backend__� classmethodr$ r) r" r" r" r# r s r 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 jjEddde� �ZIe jjEdfdg� �ZJe jjKe jdhdi� ��ZLe jjMdjdk� �ZNe jj/e jjMdldm� ��ZOe jj/dndo� �ZPe jjMe jj dpdq� ��ZQe jd�drds��ZRe jjSdtdu� �ZTe jjSe jj dvdw� ��ZUe jd�dxdy��ZVe jd�dzd{��ZWe jjd|d}� �ZXe jje jj d~d� ��ZYe �Zd�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 Z requirementsZindependent_connections�enabled� sqlalchemyr0 r �testing_engine�dictZ StaticPoolr% )r r0 r" r" r# � setup_bind7 s z"ComponentReflectionTest.setup_bindc C s* | � |d � tjjjr&| � |tjj� d S )N)�define_reflected_tablesr �requires�schemasr2 r � test_schema)r r! r" r" r# r$ B 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 k�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�}td2|j j�� � td3|j j�� � t jjj�r�| � ||� |�st jj j�r| � |� d S )4N�.� �users�user_idT)r �test1� F)�nullable�test2�parent_user_idz%susers.user_id� user_id_fk)�name)�schema� test_needs_fk� dingalings� dingaling_id� address_idz %semail_addresses.address_idr � �email_addresses�remote_user_idZ email_address� � email_ad_pk� comment_testr z id comment)r �commentzdata % comment)rQ �d2z)Comment types type speedily ' " \ '' Fun!z the test % ' " \ table comment)rF rQ � local_table� remote_idz%s.remote_table_2.id)rG rF � remote_table�local_idz%s.local_table.id�remote_table_2�noncol_idx_test_nopk�q)rG �noncol_idx_test_pk�noncol_idx_nopk� noncol_idx_pk) r r8 � self_referential_foreign_keysr2 r r �sa�INTZCHARZFloatr r r �cr> ZPrimaryKeyConstraint�cross_schema_fk_reflectionr r: r% r& �default_schema_name�index_reflection� define_indexr rY Zdesc�view_column_reflection� define_views�temp_table_reflection�define_temp_tables)r r! rF Z schema_prefixr= rX rZ r" r" r# r7 H s� z/ComponentReflectionTest.define_reflected_tablesc C s� t �d�rdgdd�}n ddgi}td|tdtjd d �td t�d ��td tj�tjd dd�t�dd �f|�}t j j j r�t j j j r�t �|dtd�� t �|dtd�� d S )N�oraclezGLOBAL TEMPORARYz PRESERVE ROWS)�prefixesZoracle_on_commitrj Z TEMPORARY�user_tmpr T)r rE r �foo� user_tmp_uq)rE � user_tmp_ix� after_createz:create temporary view user_tmp_v as select * from user_tmp� before_dropzdrop view user_tmp_v)r �againstr r r^ r_ ZVARCHAR�UniqueConstraintr r8 �view_reflectionr2 �temporary_viewsr �listenr )r r! �kwrk r" r" r# rh � s* 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? rB r> )r r! r= r" r" r# rd � s z$ComponentReflectionTest.define_indexc C sb x\dD ]T}|}|r d||f }|d }d||f }t �|dt|�� t �|dtd| �� qW d S )N)r= rL z%s.%sZ_vz"CREATE VIEW %s AS SELECT * FROM %sro rp z DROP VIEW %s)r ru r )r r! rF � table_name�fullnameZ view_nameZqueryr" r" r# rf � s z$ComponentReflectionTest.define_viewsc C s$ t tj�}| �tjj|�� k� d S )N)r r r% �assert_r r: Zget_schema_names)r( �inspr" r" r# �test_get_schema_names s z-ComponentReflectionTest.test_get_schema_namesc C s4 t �� }t|jd�rt�t|� t|jd�s0t�d S )Nrb )r r4 �hasattrr& r' r )r( Zenginer" r" r# �test_dialect_initialize s z/ComponentReflectionTest.test_dialect_initializec C s t tj�}t|jtjjj� d S )N)r r r% r rb r& )r( r| r" r" r# � test_get_default_schema_name s z4ComponentReflectionTest.test_get_default_schema_name�tablec s� ddddddg� | j }t|j�}|dkrR|�|�}|�� dd g}tt|�|� nl|rld d � |�|�D �}n |�|�}� fd d �|D �}|d kr�dddg}t||� ndddg}tt|�|� d S )NrP rZ rX rS rU rW �view�email_addresses_v�users_vc S s g | ]}|d r|d �qS )r r" )�.0�recr" r" r# � <listcomp>: s zAComponentReflectionTest._test_get_table_names.<locals>.<listcomp>c s g | ]}|� kr|�qS r" r" )r� �t)�_ignore_tablesr" r# r� @ s � foreign_keyr= rL rH ) r! r �bindZget_view_names�sortr �sortedZ get_sorted_table_and_fkc_names�get_table_names) r( rF � table_type�order_by�metar| � table_namesZanswer�tablesr" )r� r# �_test_get_table_names" s. z-ComponentReflectionTest._test_get_table_namesc C s& t | j�}|�� }tt|�dg� d S )Nrk )r r� Zget_temp_table_namesr r� )r( r| �temp_table_namesr" r" r# �test_get_temp_table_namesI 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� r" r" r# �test_get_temp_view_namesO s z0ComponentReflectionTest.test_get_temp_view_namesc C s | � � d S )N)r� )r( r" r" r# �test_get_table_namesW s z,ComponentReflectionTest.test_get_table_namesc C s | j dd� d S )Nr� )r� )r� )r( r" r" r# �test_get_table_names_fks[ s z0ComponentReflectionTest.test_get_table_names_fksc C s | � � d S )N)�_test_get_comments)r( r" r" r# �test_get_comments` s z)ComponentReflectionTest.test_get_commentsc C s | � tjj� d S )N)r� r r r: )r( r" r" r# � test_get_comments_with_schemad 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 )NrP )rF �textz the test % ' " \ table commentr= c S s g | ]}|d |d d��qS )rE rQ )rE rQ r" )r� r� r" r" r# r� u s z>ComponentReflectionTest._test_get_comments.<locals>.<listcomp>z id commentr )rQ rE zdata % commentr z)Comment types type speedily ' " \ '' Fun!rR )r r r% r Zget_table_comment� get_columns)r( rF r| r" r" r# r� i s z*ComponentReflectionTest._test_get_commentsc C s | � tjj� d S )N)r� r r r: )r( r" r" r# � 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" r# �test_get_view_names� s z+ComponentReflectionTest.test_get_view_namesc C s | j tjjdd� d S )Nr� )r� )r� r r r: )r( r" r" r# � test_get_view_names_with_schema� s z7ComponentReflectionTest.test_get_view_names_with_schemac C s | � � | j dd� d S )Nr� )r� )r� )r( r" r" r# �test_get_tables_and_views� s z1ComponentReflectionTest.test_get_tables_and_viewsc C sv t tj�}| jj| jj }}ddg}|dkr4ddg}t|j�}�x0t|||f�D �] \}} |} |j || d�} | � t | �dkt | �� x�t | j �D ]�\} } t| j| | d � | | d j}| j}t|tjj�r�|j}t�d �r�|tjtjfkr�tj}| � t t|j�� |j�� tj tj tjtjtj tj tj!g��dkd | j| j| | d |f � | j"s�| | d d ks�t#�q�W qPW d S ) Nr= rL r� r� r� )rF r rE �typeri z%s(%s), %s(%s)�default)$r r r% r� r= rL r r� �zipr� r{ �len� enumerate�columnsr rE � __class__r� � isinstancer^ r Z TypeEnginerq � sql_typesZDateZDateTime�set�__mro__� intersectionr �NumericZTimer Z_Binaryr r' )r( rF r� r� r= � addressesr� r| ry r� Z schema_name�cols�i�colZctypeZ ctype_defr" r" r# �_test_get_columns� sH z)ComponentReflectionTest._test_get_columnsc C s | � � d S )N)r� )r( r" r" r# �test_get_columns� s z(ComponentReflectionTest.test_get_columnsc G sD t d| jfdd� t|�D ��� }|�� dd� t| jj��d�D �S )Nr� c S s g | ]\}}t d | |��qS )zt%d)r )r� r� Ztype_r" r" r# r� � s z<ComponentReflectionTest._type_round_trip.<locals>.<listcomp>c S s g | ] }|d �qS )r� r" )r� r` r" r" r# r� � s )r r! r� �creater r� r� )r( r r� r" r" r# �_type_round_trip� s z(ComponentReflectionTest._type_round_tripc C sH xB| � t�dd��D ],}t|tj�s(t�t|jd� t|jd� qW d S )N� r@ )r� r� r� r� r' r Z precisionZscale)r( �typr" r" r# �test_numeric_reflection� s z/ComponentReflectionTest.test_numeric_reflectionc C s4 | � t�d��d }t|tj�s$t�t|jd� d S )N�4 r )r� r� r r� r' r �length)r( r� r" r" r# �test_varchar_reflection� s z/ComponentReflectionTest.test_varchar_reflectionc C s\ t d| jtdtdd�tdtdd��}|�� ttdd� t| jj�� d�D ��ddd �� d S ) Nr� �aT)rA �bFc s s | ]}|d |d fV qdS )rE rA Nr" )r� r� r" r" r# � <genexpr>� s zCComponentReflectionTest.test_nullable_reflection.<locals>.<genexpr>)r� r� ) r r! r r r� r r5 r r� r� )r( r� r" r" r# �test_nullable_reflection� s z0ComponentReflectionTest.test_nullable_reflectionc C s | j tjjd� d S )N)rF )r� r r r: )r( r" r" r# � test_get_columns_with_schema s z4ComponentReflectionTest.test_get_columns_with_schemac C sn t | j�}| jj}t|j�}|�d�}| �t|�dkt|�� x*t|j �D ] \}}t |j || d � qJW d S )Nrk r rE ) r r� r� rk r r� r{ r� r� r� r rE )r( r� rk r| r� r� r� r" r" r# �test_get_temp_table_columns s z3ComponentReflectionTest.test_get_temp_table_columnsc C s2 t | j�}|�d�}tdd� |D �dddg� d S )Nr� c S s g | ] }|d �qS )rE r" )r� r� r" r" r# r� s zFComponentReflectionTest.test_get_temp_view_columns.<locals>.<listcomp>r rE rl )r r� r� r )r( r| r� r" r" r# �test_get_temp_view_columns s z2ComponentReflectionTest.test_get_temp_view_columnsc C s | j dd� d S )Nr� )r� )r� )r( r" r" r# �test_get_view_columns s z-ComponentReflectionTest.test_get_view_columnsc C s | j tjjdd� d S )Nr� )rF r� )r� r r r: )r( r" r" r# �!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 Q R X d S )N)rF �constrained_columnsr> rJ rE rO ) r! r� r= rL r r� Zget_pk_constraintrE r r r8 Zreflects_pk_names�fail_if) r( rF r� r= r� r| Z users_consZ users_pkeysZ addr_consZ addr_pkeysr" r" r# �_test_get_pk_constraint% s z/ComponentReflectionTest._test_get_pk_constraintc C s | � � d S )N)r� )r( r" r" r# �test_get_pk_constraint6 s z.ComponentReflectionTest.test_get_pk_constraintc C s | j tjjd� d S )N)rF )r� r r r: )r( r" r" r# �"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_keysrE )r( r� r= r| r" r" r# � test_deprecated_get_primary_keys@ s z8ComponentReflectionTest.test_deprecated_get_primary_keysc C s: | j }| jj| jj }}t|j�}|}tjjj r�|j |j |d�}|d }tjj � � � t|d d� W d Q R X t|d |� t|d |j � t|d dg� tjjj r�t|d d g� |j |j |d�} | d }tjj� � � | �|d d k � W d Q R X t|d |� t|d |j � t|d dg� t|d d g� d S ) N)rF r rE rD �referred_schema�referred_table�referred_columnsr> r� rC rM )r! r� r= rL r r� r r8 r] r2 �get_foreign_keysrE Znamed_constraintsr� r Z implicitly_named_constraintsr{ ) r( rF r� r= r� r| Zexpected_schemaZ users_fkeys�fkey1Z addr_fkeysr" r" r# �_test_get_foreign_keysM s, z.ComponentReflectionTest._test_get_foreign_keysc C s | � � d S )N)r� )r( r" r" r# �test_get_foreign_keysn s z-ComponentReflectionTest.test_get_foreign_keysc C s | j tjjd� d S )N)rF )r� r r r: )r( r" r" r# �!test_get_foreign_keys_with_schemar 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 tjjjfks�t �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� rT )rF rV ) r� r r% r& rb r r: r r� rE r r� r' ) r( rS rU rW r| Z local_fkeysr� Z remote_fkeysZfkey2r" r" r# �"test_get_inter_schema_foreign_keysw s, z:ComponentReflectionTest.test_get_inter_schema_foreign_keysc C s | j dd� d S )NZCASCADE)Zondelete)� _test_get_foreign_key_options)r( r" r" r# �%test_get_foreign_key_options_ondelete� s z=ComponentReflectionTest.test_get_foreign_key_options_ondeletec C s | j dd� d S )NzSET NULL)Zonupdate)r� )r( r" r" r# �%test_get_foreign_key_options_onupdate� 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 T)r )rG r� Zx_idzx.idZxid)rE Ztest� �userrE r F)rA �tidztable.idZmyfkr r1 c 3 s" | ]}� | r|� | fV qd S )Nr" )r� �k)�optsr" r# r� � s zHComponentReflectionTest._test_get_foreign_key_options.<locals>.<genexpr>c 3 s" | ]}� | r|� | fV qd S )Nr" )r� r� )r� r" r# r� � s )r! r r r r^ r r ZForeignKeyConstraint� create_allr r� r� r r5 )r( r1 r� r| r" )r� r# r� � s8 z5ComponentReflectionTest._test_get_foreign_key_optionsc C sb dd� |D �}xN|D ]F}|d |ks(t �||�|d � }x |D ]}t|| || � q@W qW d S )Nc S s g | ] }|d �qS )rE r" )r� �dr" r" r# r� � s z@ComponentReflectionTest._assert_insp_indexes.<locals>.<listcomp>rE )r' �indexr )r( �indexes�expected_indexesZ index_namesZe_indexr� �keyr" r" r# �_assert_insp_indexes� s z,ComponentReflectionTest._assert_insp_indexesc C sP | j }t|j�}|jd|d�}dddgdd�ddddgd d�g}| �||� d S ) Nr= )rF Fr? rB rw )�unique� column_namesrE r> rx )r! r r� � get_indexesr� )r( rF r� r| r� r� r" r" r# �_test_get_indexes� s z)ComponentReflectionTest._test_get_indexesc C s | � � d S )N)r� )r( r" r" r# �test_get_indexes� s z(ComponentReflectionTest.test_get_indexesc C s | j tjjd� d S )N)rF )r� r r r: )r( r" r" r# � 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� rE )� autoload_withr� r ) r! r r� r� r� r r r� r� r �listr� rE )r( �tnameZixnamer� r| r� r� r� r" r" r# �_test_get_noncol_index� s z.ComponentReflectionTest._test_get_noncol_indexc C s | � dd� d S )NrX r[ )r� )r( r" r" r# �test_get_noncol_index_no_pk s z3ComponentReflectionTest.test_get_noncol_index_no_pkc C s | � dd� d S )NrZ r\ )r� )r( r" r" r# �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 Q R X d S ) Nr� r� rK �yro 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 )rE r� r� ) r r! r r r ru r r� r r� r r r� )r( r| r" r" r# �%test_reflect_expression_based_indexes s$ z=ComponentReflectionTest.test_reflect_expression_based_indexesc C s | � � d S )N)� _test_get_unique_constraints)r( r" r" r# �test_get_unique_constraints, s z3ComponentReflectionTest.test_get_unique_constraintsc C sF t | j�}|�d�}x|D ]}|�dd � qW t|dgdd�g� d S )Nrk �duplicates_indexrE rm )r� rE )r r� �get_unique_constraints�popr )r( r| � reflected�reflr" r" r# �&test_get_temp_table_unique_constraints0 s z>ComponentReflectionTest.test_get_temp_table_unique_constraintsc C sR t | j�}|�d�}x|D ]}|�dd � qW tdd� |D �ddgdd�g� d S ) Nrk Zdialect_optionsc S s g | ]}|d dkr|�qS )rE rn r" )r� �idxr" r" r# r� D s zGComponentReflectionTest.test_get_temp_table_indexes.<locals>.<listcomp>Frl rn )r� r� rE )r r� r� r� r )r( r| r� Zindr" r" r# �test_get_temp_table_indexes; s z3ComponentReflectionTest.test_get_temp_table_indexesc C s | j tjjd� d S )N)rF )r� r r r: )r( r" r" r# �'test_get_unique_constraints_with_schemaN s z?ComponentReflectionTest.test_get_unique_constraints_with_schemac C s� t ddgd�ddddgd�ddddgd�dd d gd�d dgd�d dgd�gt�d �d�}| j}td|tdt�d��tdt�d��tdtj�td t�d��td t�d��|d�}x*|D ]"}|� tj |d d |d i�� q�W |� � t |j �}t |jd|d�t�d �d�}t� }x>t||�D ]0\} } | �dd �} | �r>|�| � t| | � �qW t� } td| |j |d�}tdd� |jD ��} tdd� |jD ���dg�}| �|��r�t�|�r�t|| � t|t� � d S )NZunique_ar� )rE r� Z unique_a_b_cr� r` Z unique_c_a_bZunique_asc_keyZascr� z i.have.dotsz i have spacesrE )r� ZtesttblrN rK )rF r� r� )r� rF c S s g | ] }|j �qS r" )rE )r� r� r" r" r# r� � s zHComponentReflectionTest._test_get_unique_constraints.<locals>.<listcomp>c S s g | ]}t |tj�r|j�qS r" )r� r^ rr rE )r� Zuqr" r" r# r� � s )r� �operator� itemgetterr! r r r^ r r Zappend_constraintrr r� r r� r� r� r� r� �addr r r� Z constraints� differencer� r' )r( rF Zuniques� orig_metar� Zuc� inspectorr� Znames_that_duplicate_indexZorigr� ZdupeZreflected_metadataZ idx_namesZuq_namesr" r" r# r� S s^ z4ComponentReflectionTest._test_get_unique_constraintsc C s | � � d S )N)�_test_get_check_constraints)r( r" r" r# �test_get_check_constraints� s z2ComponentReflectionTest.test_get_check_constraintsc C s | j tjjd� d S )N)rF )r r r r: )r( r" r" r# �!test_get_check_constraints_schema� 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 < 5Zcc1)rE za = 1 OR (a > 2 AND a < 5)Zcc2)rF rE )r� c S s d� t�d| �� tj��S )N� zand|\d|=|a|or|<|>)�join�re�findall�lower�I)�sqltextr" r" r# � normalize� s zFComponentReflectionTest._test_get_check_constraints.<locals>.normalizec s" g | ]}|d � |d �d��qS )rE r )rE r r" )r� �item)r r" r# r� � s zGComponentReflectionTest._test_get_check_constraints.<locals>.<listcomp>za > 1 and a < 5)rE r za = 1 or a > 2 and a < 5)r! r r r r^ ZCheckConstraintr� r r� r� Zget_check_constraintsr r r )r( rF r r r� r" )r r# r � s( z3ComponentReflectionTest._test_get_check_constraintsc C sL | j }d}d}t|j�}|j||d�}| �|� |j||d�}| �|� d S )Nr� r� )rF )r! r r� Zget_view_definitionr{ )r( rF r� Z view_name1Z view_name2r| Zv1Zv2r" r" r# �_test_get_view_definition� s z1ComponentReflectionTest._test_get_view_definitionc C s | � � d S )N)r )r( r" r" r# �test_get_view_definition� s z0ComponentReflectionTest.test_get_view_definitionc C s | j tjjd� d S )N)rF )r r r r: )r( r" r" r# �$test_get_view_definition_with_schema� s z<ComponentReflectionTest.test_get_view_definition_with_schemaZ postgresqlzPG specific featurec C s0 | j }t|j�}|�||�}| �t|t�� d S )N)r! r r� Z get_table_oidr{ r� �int)r( ry rF r� r| Zoidr" r" r# �_test_get_table_oid� s z+ComponentReflectionTest._test_get_table_oidc C s | � d� d S )Nr= )r )r( r" r" r# �test_get_table_oid� s z*ComponentReflectionTest.test_get_table_oidc C s | j dtjjd� d S )Nr= )rF )r r r r: )r( r" r" r# � test_get_table_oid_with_schema� s z6ComponentReflectionTest.test_get_table_oid_with_schemac C sR | j }t|j�}x<dD ]4\}}|�|�}dd� |D �| }|�dd�st�qW 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> )rL rJ )rH rI c S s i | ]}||d �qS )rE r" )r� r` r" r" r# � <dictcomp> s zBComponentReflectionTest.test_autoincrement_col.<locals>.<dictcomp>Z autoincrementTN)r! r r� r� �getr' )r( r� r| r� Zcnamer� Zid_r" r" r# �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. r6 r$ r7 rh rd rf r r8 Zschema_reflectionr} r r� Zprovide_metadatar� r� r� rs rt r� Ztable_reflectionr� Z!foreign_key_constraint_reflectionr� Zcomment_reflectionr� r9 r� r� r� re r� r� r� r� r� r� r� r� r� r� rg r� r� r� r� r� Z!primary_key_constraint_reflectionr� r� r� r� r� r� ra r� Z1foreign_key_constraint_option_reflection_ondeleter� Z1foreign_key_constraint_option_reflection_onupdater� r� r� r� rc r� r� r� r� r� Zindexes_with_expressionsr� Z unique_constraint_reflectionr� r� r r r� Zcheck_constraint_reflectionr r r r r r Zonly_onr r r r r" r" r" r# r/ 2 s� $ % 8 "- N ' r/ 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)�quoter )r �t2�t1idzt1.id)r r r r r )r r! r" r" r# r$ s z NormalizedNameTest.define_tablesc C s� t tj�}ttddd�|dd�}|jd }|jj�|jj �s@t �t tj�}|j dd� d� |jd jj�|jd jj �s|t �d S ) Nr! T)r )Zautoloadr c S s | � � dkS )N)r r! )r )rE �mr" r" r# �<lambda>, � zINormalizedNameTest.test_reflect_lowercase_forced_tables.<locals>.<lambda>)Zonly) r r r% r r r� r` r" Z referencesr r' Zreflect)r( Zm2Zt2_refZt1_refZm3r" r" r# �$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 ))r r! )r )r� r� r" r" r# r� 1 s z;NormalizedNameTest.test_get_table_names.<locals>.<listcomp>r r� )r r r% r� r �upperr )r( Z tablenamesr" r" r# r� / s z'NormalizedNameTest.test_get_table_namesN) r* r+ r, Z __requires__r- r. r$ r& r� r" r" r" r# r s r )r/ r r )'r r r3 r^ r< r r r r r r r rF r r r r r� r r r r r r r r� Zengine.reflectionr r r Z sql.elementsr r! r= Z TablesTestr r/ r �__all__r" r" r" r# �<module> sH g(
Edit
Rename
Chmod
Delete
FILE
FOLDER
Name
Size
Permission
Action
__init__.cpython-37.opt-1.pyc
414 bytes
0644
__init__.cpython-37.pyc
414 bytes
0644
test_cte.cpython-37.opt-1.pyc
4903 bytes
0644
test_cte.cpython-37.pyc
4903 bytes
0644
test_ddl.cpython-37.opt-1.pyc
3330 bytes
0644
test_ddl.cpython-37.pyc
3330 bytes
0644
test_dialect.cpython-37.opt-1.pyc
4292 bytes
0644
test_dialect.cpython-37.pyc
4385 bytes
0644
test_insert.cpython-37.opt-1.pyc
8486 bytes
0644
test_insert.cpython-37.pyc
8731 bytes
0644
test_reflection.cpython-37.opt-1.pyc
31039 bytes
0644
test_reflection.cpython-37.pyc
31505 bytes
0644
test_results.cpython-37.opt-1.pyc
10607 bytes
0644
test_results.cpython-37.pyc
11039 bytes
0644
test_select.cpython-37.opt-1.pyc
22643 bytes
0644
test_select.cpython-37.pyc
22643 bytes
0644
test_sequence.cpython-37.opt-1.pyc
5210 bytes
0644
test_sequence.cpython-37.pyc
5210 bytes
0644
test_types.cpython-37.opt-1.pyc
29313 bytes
0644
test_types.cpython-37.pyc
29586 bytes
0644
test_update_delete.cpython-37.opt-1.pyc
1883 bytes
0644
test_update_delete.cpython-37.pyc
1987 bytes
0644
N4ST4R_ID | Naxtarrr
