
    -hO                         S r SSKJr  SSKJr  SSKJr  SSKJr  SSKJr  SSKJr  SSKJ	r	  SS	KJ
r
  SS
KJr  SSKJr  SSKJr  SSKJr   " S S\
R"                  5      rg)z*verrrrry basic unicode column name testing    )desc)
ForeignKey)Integer)MetaData)testing)util)eq_)fixtures)Column)Table)u)uec                   D    \ rS rSrSrSr\S 5       rS rS r	S r
S rS	rg
)UnicodeSchemaTest   )unicode_ddlTc                    [        [        S5      U[        [        S5      [        SS9[        [	        S5      [        5      SS9q[        [        S5      U[        [        S5      [        SSS	9[        [	        S5      [        [        [        S
5      5      SS9SS9q[        R                  " S5      (       a  [        [	        S5      U[        [	        S5      [        SSS9[        [	        S5      [        [        [	        S5      5      5      [        [        S5      [        [        [        S5      5      5      [        [	        S5      [        [        [	        S5      5      5      SS9q
g [        [	        S5      U[        [	        S5      [        SSS9[        [	        S5      [        5      [        [        S5      [        5      [        [	        S5      [        5      SS9q
g )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   r   r   t1r   t2r   againstt3)clsmetadatas     ~C:\Users\ROHAN GUPTA\OneDrive\Desktop\mathbuddy-assessment\venv\Lib\site-packages\sqlalchemy/testing/suite/test_unicode_ddl.pydefine_tablesUnicodeSchemaTest.define_tables   s    kN1W:wD92n%w/
 lO1W:wDcB>"1./0	 
 ??8$$>"() $"'	 /0r":;<
 n%w
1^;L0M *+r"@AB
 #-B2 >"() $"'	 r23W=q('2r-.8"B    c                    UR                  [        R                  5       [        S5      S[	        S5      S05        UR                  [
        R                  5       [        S5      S[        S5      S05        UR                  [        R                  5       [	        S5      S[	        S5      S[        S	5      S[	        S
5      S05        [        UR                  [        R                  5       5      R                  5       S/5        [        UR                  [
        R                  5       5      R                  5       S/5        [        UR                  [        R                  5       5      R                  5       S/5        g )Nr      r      r   r   r   r   r    r!   r-   r.   r-   r-   r-   r.   r-   r-   )
executer"   insertr   r   r#   r%   r	   selectfetchall)self
connections     r(   test_insertUnicodeSchemaTest.test_insert^   s   299;7Q>8JA(NO299;3AcFA(>?IIK$%q+,a.!1&'		
 	Jryy{+446AJryy{+446AJryy{+446Gr+   c                    UR                  [        R                  5       [        S5      S[	        S5      S05        UR                  [
        R                  5       [        S5      S[        S5      S05        UR                  [        R                  5       [	        S5      S[	        S5      S[        S	5      S[	        S
5      S05        UR                  [        R                  5       5      R                  5       n[        UR                  [        R                  [        S5            S5        [        UR                  [        R                  [	        S5            S5        UR                  [
        R                  5       5      R                  5       n[        UR                  [
        R                  [        S5            S5        [        UR                  [
        R                  [        S5            S5        UR                  [        R                  5       5      R                  5       n[        UR                  [        R                  [	        S5            S5        [        UR                  [        R                  [	        S5            S5        [        UR                  [        R                  [        S	5            S5        [        UR                  [        R                  [	        S
5            S5        g )Nr   r-   r   r.   r   r   r   r   r    r!   )r2   r"   r3   r   r   r#   r%   r4   firstr	   _mappingc)r6   r7   rows      r(   test_col_targeting$UnicodeSchemaTest.test_col_targetingo   s   299;7Q>8JA(NO299;3AcFA(>?IIK$%q+,a.!1&'		
   -335CLLaj)*A.CLLb012A6  -335CLLaf&*CLLaf&*  -335CLLb!2345q9CLLb!9:;<a@CLLa/0115CLLb!4567;r+   c                    UR                  [        R                  5       [        S5      S[	        S5      S05        UR                  [
        R                  5       [        S5      S[        S5      S05        UR                  [        R                  5       [	        S5      S[	        S5      S[        S	5      S[	        S
5      S05        [        5       n[        [        R                  X!S9n[        [
        R                  X!S9n[        [        R                  X!S9nUR                  UR                  5       [        S5      S[	        S5      S05        UR                  UR                  5       [        S5      S[	        S5      S05        UR                  UR                  5       [	        S5      S[	        S5      S[        S	5      S[	        S
5      S05        [        UR                  UR                  5       R                  [        [        S5      5      5      5      R                  5       SS/5        [        UR                  UR                  5       R                  [        [        S5      5      5      5      R                  5       SS/5        [        UR                  UR                  5       R                  [        [	        S5      5      5      5      R                  5       SS/5        g )Nr      r      r   r   r   r   r    r!   )autoload_withr-   r.   )rB   rC   r/   )rB   rB   r0   )rB   rC   rB   rB   r1   )r2   r"   r3   r   r   r#   r%   r   r   namer	   r4   order_byr   r5   )r6   r7   metatt1tt2tt3s         r(   test_reflectUnicodeSchemaTest.test_reflect   s6   299;7Q>8JA(NO299;3AcFA(>?IIK$%q+,a.!1&'		
 zBGGT<BGGT<BGGT<3::<!G*aN9KQ)OP3::<!G*aN9KQ)OPJJL$%q+,a.!1&'		
 	

%%d1W:&67hjV		
 	

%%d1W:&67hjV		
 	

%%d2.?+@&ABhj<(		
r+   c           	          [        5       n[        [        S5      U[        [        S5      [        5      5      n[
        R                  (       a  [        [        U5      S5        g [        [        U5      S5        g )Nr   r   ud   Table('\u6e2c\u8a66', MetaData(), Column('\u6e2c\u8a66_id', Integer(), table=<測試>), schema=None)uX   Table('測試', MetaData(), Column('測試_id', Integer(), table=<測試>), schema=None))	r   r   r   r   r   r   py2kr	   repr)r6   rG   ts      r(   	test_reprUnicodeSchemaTest.test_repr   s_    z~fR0A-BG&L
 99Q# Q#r+    N)__name__
__module____qualname____firstlineno____requires____backend__classmethodr)   r8   r?   rK   rQ   __static_attributes__rS   r+   r(   r   r      s5    #LK? ?BH"<6/
br+   r   N)__doc__
sqlalchemyr   r   r   r   r   r   sqlalchemy.testingr	   r
   sqlalchemy.testing.schemar   r   sqlalchemy.utilr   r   
TablesTestr   rS   r+   r(   <module>rb      sB    1  !     " ' , +  |++ |r+   