o
    g                     @   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 G d
d dejZdS )    )desc)
ForeignKey)Integer)MetaData)testing)eq_)fixtures)Column)Tablec                   @   s@   e Zd ZdZdZedd Zdd Zdd Zd	d
 Z	dd Z
dS )UnicodeSchemaTest)unicode_ddlTc                 C   s   t d|tdtddtdtddat d|tdtddd	tdttd
ddddatdrRt d|tdtdddtdttdtdttdtdttdddad S t d|tdtdddtdttdttdtddad S )N	unitable1   méilT)primary_key   測試)test_needs_fku
   Unitéble2a)r   keyu   unitable1.méilb)r   sqlite	   測試_idF)r   autoincrement   unitable1_測試u   unitable1.測試   Unitéble2_bu   Unitéble2.b   測試_selfu   測試.測試_id)	r
   r	   r   t1r   t2r   againstt3)clsmetadata r!   c/var/www/html/api-tag/env/lib/python3.10/site-packages/sqlalchemy/testing/suite/test_unicode_ddl.pydefine_tables   sp   


zUnicodeSchemaTest.define_tablesc                 C   s   | t ddd | t ddd | t ddddd t| t  dg t| t  dg t| t  dg d S )	N      r   r   r   r   r   r   r   r   r$   r%   r$   r$   r$   r%   r$   r$   )executer   insertr   r   r   selectfetchall)self
connectionr!   r!   r"   test_insertY   s   
zUnicodeSchemaTest.test_insertc                 C   s0  | t ddd | t ddd | t ddddd | t  }t|jtj	d  d t|jtj	d  d | t  }t|jtj	d  d t|jtj	d	  d | t  }t|jtj	d
  d t|jtj	d  d t|jtj	d  d t|jtj	d  d d S )Nr$   r%   r&   r'   r(   r   r   r   r   r   r   r   r   )
r,   r   r-   r   r   r.   firstr   _mappingc)r0   r1   rowr!   r!   r"   test_col_targetingj   s*   
z$UnicodeSchemaTest.test_col_targetingc                 C   s8  | t ddd | t ddd | t ddddd t }ttj||d}ttj||d}ttj||d}| | ddd | | ddd | | ddddd t| |	 
td	 d
dg t| |	 
td	 ddg t| |	 
td ddg d S )N      r&   r'   r(   )autoload_withr$   r%   r   )r8   r9   r)   )r8   r8   r*   r   )r8   r9   r8   r8   r+   )r,   r   r-   r   r   r   r
   namer   r.   order_byr   r/   )r0   r1   metatt1tt2tt3r!   r!   r"   test_reflect   sN   

zUnicodeSchemaTest.test_reflectc                 C   s*   t  }td|tdt}tt|d d S )Nr   r   uX   Table('測試', MetaData(), Column('測試_id', Integer(), table=<測試>), schema=None))r   r
   r	   r   r   repr)r0   r=   tr!   r!   r"   	test_repr   s   zUnicodeSchemaTest.test_reprN)__name__
__module____qualname____requires____backend__classmethodr#   r2   r7   rA   rD   r!   r!   r!   r"   r      s    
?-r   N)
sqlalchemyr   r   r   r   r   sqlalchemy.testingr   r   sqlalchemy.testing.schemar	   r
   
TablesTestr   r!   r!   r!   r"   <module>   s   	