o
    y¬´\
  ã                   @   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„ 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dS )ÚTableDDLTestTc              	   C   ó&   t d| jtdtddd�tdtdƒƒƒS )NÚ
test_tableÚidTF©Úprimary_keyÚautoincrementÚdataé2   ©r   Úmetadatar   r
   r   ©Úself© r   úS/var/www/html/env/lib/python3.10/site-packages/sqlalchemy/testing/suite/test_ddl.pyÚ_simple_fixture   ó   üzTableDDLTest._simple_fixturec              	   C   r   )NÚ_test_tabler   TFr   Ú_datar   r   r   r   r   r   Ú_underscore_fixture   r   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d� |jtjdd� d S r/   )r   r2   r   r#   Údropr3   r   r   r   Útest_drop_table.   s   zTableDDLTest.test_drop_tablec                 C   r.   r/   )r!   r2   r   r#   r-   r3   r   r   r   Útest_underscore_names5   r5   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 ©NFr0   z	a commentr   Útext)r   r2   r   r#   Úcommentr%   r   ÚSetTableCommentr   r	   Úget_table_commentr3   r   r   r   Útest_add_table_comment<   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   r2   r   r#   r;   r%   r   r<   ÚDropTableCommentr   r	   r=   r3   r   r   r   Útest_drop_table_commentH   s   z$TableDDLTest.test_drop_table_commentN)Ú__name__Ú
__module__Ú__qualname__Ú__backend__r   r!   r-   r   Úcreate_tabler   Úprovide_metadatar4   Ú
drop_tabler7   r8   Úcomment_reflectionr>   r@   r   r   r   r   r      s(    
r   )r   N)Ú r   r   r   Ú
assertionsr   r   r   r	   r
   r   r   r   ÚTestBaser   Ú__all__r   r   r   r   Ú<module>   s    E