U a@sdZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z dd l m Z dd l m Z dd lmZdd lmZGddde jZdS)z*verrrrry basic unicode column name testing)desc) ForeignKey)Integer)MetaData)testing)util)eq_)fixtures)Column)Table)u)uec@s@eZdZdZdZeddZddZddZd d Z d d Z d S)UnicodeSchemaTest)Z unicode_ddlTc Cs*ttd|ttdtddttdtddattd|ttdtddd ttdtttd d d ddat d rttd|ttdtdddttdtttdttdtttdttdtttddda nHttd|ttdtdddttdtttdtttdtdda dS)NZ unitable1méilT) primary_key測試)Z test_needs_fku Unitéble2a)rkeyuunitable1.méilb)rZsqlite 測試_idF)rZ autoincrementunitable1_測試uunitable1.測試 Unitéble2_bu Unitéble2.b 測試_selfu測試.測試_id) r r r rr t1rt2rZagainstt3)clsmetadatarjC:\Users\vtejo\AppData\Local\Temp\pip-unpacked-wheel-nyjtotrf\sqlalchemy\testing\suite\test_unicode_ddl.py define_tablessx         zUnicodeSchemaTest.define_tablesc Cs|ttddtddi|ttddtddi|ttddtddtd dtd dit|t d gt|t d gt|t d gdS)Nrrrrrrrrr!r"r!r!r!r"r!r!) executerinsertr r rrrselectfetchall)self connectionrrr test_insertXs"   zUnicodeSchemaTest.test_insertc Csz|ttddtddi|ttddtddi|ttddtddtd dtd di|t}t |j tj tddt |j tj tdd|t}t |j tj tddt |j tj tdd|t}t |j tj tddt |j tj tddt |j tj td dt |j tj td ddS) Nrr!rr"rrrrrr) r&rr'r r rrr(firstr_mappingc)r*r+rowrrrtest_col_targetingis2   z$UnicodeSchemaTest.test_col_targetingc Cs|ttddtddi|ttddtddi|ttddtddtd dtd dit}ttj ||d }ttj ||d }ttj ||d }||tdd tdd i||tdd tdd i||tdd tdd td d td d it || t tdddgt || t tdddgt || t tdddgdS)Nrrrrrrrr)Z autoload_withr!r")r2r3r#)r2r2r$)r2r3r2r2r%)r&rr'r r rrrr namerr(Zorder_byrr))r*r+metaZtt1Ztt2Ztt3rrr test_reflectsd      zUnicodeSchemaTest.test_reflectcCsHt}ttd|ttdt}tjr6tt|dntt|ddS)NrrudTable('\u6e2c\u8a66', MetaData(), Column('\u6e2c\u8a66_id', Integer(), table=<測試>), schema=None)uXTable('測試', MetaData(), Column('測試_id', Integer(), table=<測試>), schema=None)) rr r r rrZpy2krrepr)r*r5trrr test_reprs  zUnicodeSchemaTest.test_reprN) __name__ __module__ __qualname__ __requires__Z __backend__ classmethodr r,r1r6r9rrrrrs A1rN)__doc__Z sqlalchemyrrrrrrZsqlalchemy.testingrr Zsqlalchemy.testing.schemar r Zsqlalchemy.utilr r Z TablesTestrrrrrs