o
    E6d                     @   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)Z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 )NZ	unitable1   méilT)primary_key   測試)Ztest_needs_fku
   Unitéble2a)r   keyu   unitable1.méilb)r   Zsqlite	   測試_idF)r   Zautoincrement   unitable1_測試u   unitable1.測試   Unitéble2_bu   Unitéble2.b   測試_selfu   測試.測試_id)	r
   r	   r   t1r   t2r   Zagainstt3)clsmetadata r   C:\Users\jesus\OneDrive\Desktop\erpjis_fastapi\backend\jisbackend\Lib\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_insertS   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)r*   r+   rowr   r   r   test_col_targetingd   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"   )Zautoload_withr   r   r   )r2   r3   r#   )r2   r2   r$   r   )r2   r3   r2   r2   r%   )r&   r   r'   r   r   r   r
   namer   r(   Zorder_byr   r)   )r*   r+   metaZtt1Ztt2Z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)r*   r5   tr   r   r   	test_repr   s   zUnicodeSchemaTest.test_reprN)__name__
__module____qualname____requires__Z__backend__classmethodr   r,   r1   r6   r9   r   r   r   r   r      s    
?-r   N)Z
sqlalchemyr   r   r   r   r   Zsqlalchemy.testingr   r   Zsqlalchemy.testing.schemar	   r
   Z
TablesTestr   r   r   r   r   <module>   s   