o
    [hP                     @   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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   /home/ubuntu/experiments/live_experiments/Pythonexperiments/Otree/venv/lib/python3.10/site-packages/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   s`   t j !}|| d || }t| d W d    d S 1 s)w   Y  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   &   |   }|jtjdd | | d S NFZ
checkfirst)r   creater   r   r(   r   r%   r   r   r   test_create_table(      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_table7   s   zTableDDLTest.test_drop_tablec                 C   r)   r*   )r   r,   r   r   r(   r-   r   r   r   test_underscore_names>   r/   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_commentE   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 r3   )r   r,   r   r   r5   r    r   r6   ZDropTableCommentr   r	   r7   r-   r   r   r   test_drop_table_commentQ   s   z$TableDDLTest.test_drop_table_comment)N)__name__
__module____qualname__Z__backend__r   r   r(   r   Zcreate_tabler   Zprovide_metadatar.   Zschemasr0   Z
drop_tabler1   r2   Zcomment_reflectionr8   r9   r   r   r   r   r      s0    
	
r   )r   N) r   r   r   Z
assertionsr   r   r   r	   r
   r   r   r   ZTestBaser   __all__r   r   r   r   <module>   s    N