U
    x^6                     @   s   d dl mZ d dl mZ d dl mZ d dlmZ d dlmZ ddl mZ ddl mZ dd	l m	Z	 dd
l m
Z
 ddl mZ ddl mZ G dd dejZdZdS )   )config)fixtures)util)eq_)requirements   )Column)inspect)Integerschema)String)Tablec                   @   s   e Zd ZdZdddZdd Zdd Zeje	j
d	d
 Zeje	j
dd Zeje	j
dd Zeje	j
dd Zeje	j
dd Zeje	j
dd ZdS )TableDDLTestTNc              	   C   s*   t d| jtdtdddtdtd|dS )	N
test_tableidTFZprimary_keyZautoincrementdata2   r   r   metadatar   r
   r   )selfr    r   I/tmp/pip-install-dq5v43_d/SQLAlchemy/sqlalchemy/testing/suite/test_ddl.py_simple_fixture   s    zTableDDLTest._simple_fixturec              	   C   s&   t d| jtdtdddtdtdS )NZ_test_tabler   TFr   _datar   r   )r   r   r   r   _underscore_fixture   s    z TableDDLTest._underscore_fixturec              	   C   sJ   t j 6}|| d || }t| d W 5 Q R X d S )N)   z	some data)	r   dbbeginexecuteinsertvaluesselectr   first)r   tableconnresultr   r   r   _simple_roundtrip"   s    zTableDDLTest._simple_roundtripc                 C   s&   |   }|jtjdd | | d S NFZ
checkfirst)r   creater   r   r(   r   r%   r   r   r   test_create_table(   s    zTableDDLTest.test_create_tablec                 C   s,   | j tjd}|jtjdd | | d S )Nr   Fr*   )r   r   Ztest_schemar+   r   r(   r,   r   r   r   test_create_table_schema/   s    z%TableDDLTest.test_create_table_schemac                 C   s,   |   }|jtjdd |jtjdd d S r)   )r   r+   r   r   Zdropr,   r   r   r   test_drop_table6   s    zTableDDLTest.test_drop_tablec                 C   s&   |   }|jtjdd | | d S r)   )r   r+   r   r   r(   r,   r   r   r   test_underscore_names=   s    z"TableDDLTest.test_underscore_namesc                 C   sN   |   }|jtjdd d|_tjt| tt	tj
dddi d S NFr*   z	a commentr   text)r   r+   r   r   commentr    r   SetTableCommentr   r	   get_table_commentr,   r   r   r   test_add_table_commentD   s    z#TableDDLTest.test_add_table_commentc                 C   s`   |   }|jtjdd d|_tjt| tjt| t	t
tjddd i d S r1   )r   r+   r   r   r3   r    r   r4   ZDropTableCommentr   r	   r5   r,   r   r   r   test_drop_table_commentP   s    z$TableDDLTest.test_drop_table_comment)N)__name__
__module____qualname__Z__backend__r   r   r(   r   Zcreate_tabler   Zprovide_metadatar-   r.   Z
drop_tabler/   r0   Zcomment_reflectionr6   r7   r   r   r   r   r      s,   
	
r   )r   N) r   r   r   Z
assertionsr   r   r   r	   r
   r   r   r   ZTestBaser   __all__r   r   r   r   <module>   s   M