o
    iP                     @   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primary_keyautoincrementdata2   r   r   metadatar   r
   r   )selfr    r   \/var/www/edux/Edux_v2/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 )N_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
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   test_schemar0   r!   r+   r1   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   r0   r   r!   dropr1   r   r   r   test_drop_table7   s   zTableDDLTest.test_drop_tablec                 C   r,   r-   )r   r0   r   r!   r+   r1   r   r   r   test_underscore_names>   r3   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   r0   r   r!   commentr#   r   SetTableCommentr   r	   get_table_commentr1   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 r9   )r   r0   r   r!   r;   r#   r   r<   DropTableCommentr   r	   r=   r1   r   r   r   test_drop_table_commentQ   s   z$TableDDLTest.test_drop_table_comment)N)__name__
__module____qualname____backend__r   r   r+   r   create_tabler   provide_metadatar2   schemasr5   
drop_tabler7   r8   comment_reflectionr>   r@   r   r   r   r   r      s0    
	
r   )r   N) r   r   r   
assertionsr   r   r   r	   r
   r   r   r   TestBaser   __all__r   r   r   r   <module>   s    N