w r r+ r, r@ r4 r2 r r # sf K [ M M M
r4 r c e Zd ZdZdZed Zd Zed Zee j
j d Z ed Z
ed Zed Zed
Zee j
j d Zee j
j d Zee j
j d
ZdS )QuotedNameArgumentTestonceTc 0 t d|t dt t dt d t dt d t dt t j dd t j d d t j dd
t j dgd gd t j d
d dd
t j j j
rt d|t dt t dt d t dt d t dt t j dd t j dd t j dd t j dgd gd t j d
d dd
t d|t dt d t dt d t j j j
rt j j j
rddg}ndg}|D ]}d t j j j d |z d t j j j | }t' j |d t+ | t' j |d t+ d!t j j j d |z z d S d S )"N quote ' oner# namer' r&
related_idzpk quote ' onerL zix quote ' onez
uq quote' onez
related.idzfk quote ' onez
name != 'foo'zck quote ' onezquote ' one commentT)comment
test_needs_fk quote " twozpk quote " twozix quote " twoz
uq quote" twozfk quote " twozck quote " two zquote " two commentrelatedr$ rP CREATE VIEW view %s AS SELECT * FROM after_create before_drop DROP VIEW %s)r r
r r saPrimaryKeyConstraintr UniqueConstraintForeignKeyConstraintCheckConstraintr r+ symbol_names_w_double_quoter- view_column_reflectionr7 r9 identifier_preparerquoter listenr )r0 r1 namesrL querys r2 r3 z$QuotedNameArgumentTest.define_tablesU s7
4 ! ! 66":: & & 66":: & & < ) ) #D/? @ @ @ H%v . . $
# -=
5E F F F. %
* 7 ? tW%%vvbzz**vvbzz**|W--'3CDDD)622#( 'F\N1A "?9JKKK2 "%
* 4d 3 3 3 9g & &
2 : ;C
!! "
J&:@@!D( J&:@@FFF X~s5zzBBB !&!*,@FF % , )
r4 c ` t j ddt j j f | S )N)rK rQ )r combinationsr+ r_ )fns r2 quote_fixturesz%QuotedNameArgumentTest.quote_fixtures s;
w#
G , H I
r4 c b t t j }| | d S N)r r r7 get_table_optionsr< rL insps r2 test_get_table_optionsz-QuotedNameArgumentTest.test_get_table_options s+ wz"" t$$$$$r4 c l t t j }| d|z sJ d S )NrU )r r r7 get_view_definitionrm s r2 test_get_view_definitionz/QuotedNameArgumentTest.test_get_view_definition s8 wz""'' D(89999999r4 c f t t j }| | sJ d S rk )r r r7 get_columnsrm s r2 test_get_columnsz'QuotedNameArgumentTest.test_get_columns 1 wz"" %%%%%%%r4 c f t t j }| | sJ d S rk )r r r7 get_pk_constraintrm s r2 test_get_pk_constraintz-QuotedNameArgumentTest.test_get_pk_constraint s1 wz""%%d+++++++r4 c f t t j }| | sJ d S rk )r r r7 get_foreign_keysrm s r2 test_get_foreign_keysz,QuotedNameArgumentTest.test_get_foreign_keys s1 wz""$$T*******r4 c f t t j }| | sJ d S rk )r r r7 get_indexesrm s r2 test_get_indexesz'QuotedNameArgumentTest.test_get_indexes rv r4 c f t t j }| | sJ d S rk )r r r7 get_unique_constraintsrm s r2 test_get_unique_constraintsz2QuotedNameArgumentTest.test_get_unique_constraints s3 wz""**40000000r4 c f t t j }| | sJ d S rk )r r r7 get_table_commentrm s r2 test_get_table_commentz-QuotedNameArgumentTest.test_get_table_comment s3 wz""%%d+++++++r4 c f t t j }| | sJ d S rk )r r r7 get_check_constraintsrm s r2 test_get_check_constraintsz1QuotedNameArgumentTest.test_get_check_constraints s3 wz""))$///////r4 N)rA rB rC run_create_tablesrD rE r3 ri ro r r+ r` rr ru ry r| r unique_constraint_reflectionr comment_reflectionr check_constraint_reflectionr rF r4 r2 rH rH Q s KQ Q [Qf % % ^%
,: : -, ^: & & ^& , , ^, + + ^+ & & ^& 21 1 32 ^1 (, , )( ^, 10 0 21 ^0 0 0r4 rH c <
e Zd ZdxZZdZed Zed Zed Z ed Z
ed Z ed Z e
j j d Ze
j j d
Ze
j j d Ze
j dHd
Ze
j j d Ze
j j e
j j e
j j d Ze
j j d Ze
j j e
j j d Z e
j j d Z e
j j e
j j d Z!dIdZ"e
j j e
j j d Z#e
j j$ d Z%e
j j$ e
j j d Z&e
j j e
j j$ d Z'dJdZ(e
j j d Z)e
j d Z*e
j j d Z+e
j j d Z,e
j j e
j d Z-e
j j e
j j d Z.e
j j/ d Z0e
j j/ e
j j$ e
j j d! Z1e
j j$ d" Z2e
j j$ e
j j d# Z3e
j dId$ Z4e
j j5 d% Z6e
j j e
j j5 e
j j d& Z7e
j j e
j d' Z8e
j dId( Z9e
j j d) Z:e
j j e
j j d* Z;e
j j< e
j j d+ Z=e
j j> d, Z?e
j j@ d- ZAe
j d. ZBd/ ZCe
j dId0 ZDe
j jE d1 ZFe
j jE e
j j d2 ZGe
j d3 ZHe
j jE e
j jI d4 ZJe
j jE e
j jI d5 ZKe
j jL e
j d6 ZMe
j jN d7 ZOe
j j/ e
j jN d8 ZPe
j j/ d9 ZQe
j jN e
j j d: ZRe
j dId; ZSe
j jT d< ZUe
j jT e
j j d= ZVe
j dId> ZWe
j dId? ZXe
j j d@ ZYe
j j e
j j dA ZZ e
j[ dBdC e
j dIdD Z\dE Z]e
j j dF Z^e
j j e
j dG Z_dS )KComponentReflectionTestNTc t j j j r.ddlm} t
j t |j S t j
S )Nr )pool) poolclass)options) r requirementsindependent_connectionsr-
sqlalchemyr r testing_enginedict
StaticPoolr7 )r0 r s r2
setup_bindz"ComponentReflectionTest.setup_bind sY 6 > ' ' ' ' ' ') t777
9 r4 c | |d t j j j r'| |t j j d S d S rk )define_reflected_tablesr r+ r, r- r r. r/ s r2 r3 z%ComponentReflectionTest.define_tables sW ##Hd333 # + N ' ''.2L M M M M M N Nr4 c ~ |r|dz }nd}t j j j rt d|t dt j d t dt
j d d
t d t
j d d
t d t j
t
j d
|z d |d }ntt d|t dt j d t dt
j d d
t d t
j d d
|d }t d|t dt j
d t dt j
t
j d|z t dt
j d |d t d|t dt j
t dt j
t
j |j
j t dt
j d t
j dd |d t d |t d t j
dd t dt
j d d ! t d"t
j d d#! |d$% t j j j re|t d&|t d t j
d t dt
j d t d't d(t j j z dt" j j j ) nt d*|t d t j
d t d+t d,t" j j j z t dt
j d |d t d-|t d t j
d t dt
j d |d t j j j r| || |st d.|t d/t
j d d0 }t d1|t d t j
d t d/t
j d d0 }t j j j rXt3 d2|j
j t3 d3|j
j t j j j r| || |s-t j j j r| | d S d S d S )4N. usersuser_idTr$ test1 Fnullabletest2parent_user_idz%susers.user_id
user_id_fkrN r* rP
dingalings dingaling_id
address_idz %semail_addresses.address_idr& email_addressesremote_user_id
email_address email_ad_pk comment_testr#
id comment)r% rO data % comment)rO d2)Comment types type speedily ' " \ '' Fun! the test % ' " \ table comment)r* rO local_table remote_idz%s.remote_table_2.id)rP r* remote_tablelocal_idz%s.local_table.idremote_table_2noncol_idx_test_nopkqrS noncol_idx_test_pknoncol_idx_nopk
noncol_idx_pk) r r+ self_referential_foreign_keysr- r r
rZ INTCHARFloatr r r cr r[ cross_schema_fk_reflectionr r. r7 r9 default_schema_nameindex_reflection define_indexindexes_with_ascdescr r descr` define_viewstemp_table_reflectiondefine_temp_tables)r0 r1 r*
schema_prefixr r r s r2 r z/ComponentReflectionTest.define_reflected_tables s "SLMM M 9 A y"&d;;;w
U;;;w e<<<$JM)M9 " EE" y"&d;;;w
U;;;w e<<< " E >2:4 @ @ @
<} LMM
629R== ) )
< , , "*bmEGO.L.L
?BIbMM 2 2 #L} E E E
4| L L L 629R==2B C C C "
H
9
6 > ' ~! 4>>>629R==11#" 2W^5O O #'!9,@
" 4>>>"" / $i / C D 629R==11!"& $ 4>>>629R==11!"&
, 4 J Xu - - -
J',* 3 ! --"& ( ( ($ &+( 4>>>3 ! --"& & & &" #8@ J+-A-C-E-J-J-L-LMMM/+=+?+A+F+F+H+HIII 2 : / Xv . . . -'*@H - " "8 , , , , , - - - -r4 c H t t t j }t d|t dt
j d t dt j d t dt
j t j dd t j d
d fi |}t j j j
r^t j j j
rJt j |d t# d t j |d
t# d d S d S d S )Nuser_tmpr# Tr$ rL r' foo user_tmp_uqrN user_tmp_ixrW z:create temporary view user_tmp_v as select * from user_tmprX zdrop view user_tmp_v)r r r7 r r
rZ r VARCHARr\ r r r+ view_reflectionr- temporary_viewsr rc r )r0 r1 kwr s r2 r z*ComponentReflectionTest.define_temp_tables s"
$VVY
7
7 4T 2 2 2 62:b>> * * 5"& ! ! ] ; ; ; H]E * *
, 4 O 08 O
L -
L=#6L2M2M N N N N N O O O Or4 c t d|j j |j j t d|j j |j j |j j d S )N users_t_idx
users_all_idx)r r r r r )r0 r1 r s r2 r z$ComponentReflectionTest.define_index sB
mUW]EGM:::
ouw
uw}MMMMMr4 c dD ]c}|}|r|d|}|dz }d|d|}t j |dt | t j |dt d|z dd S ) N)r r r _vrT rV rW rX rY )r rc r )r0 r1 r*
table_namefullname view_namere s r2 r z$ComponentReflectionTest.define_views s 6
J!H
:&,ffjj9 4II E
L>3u:: > > > L-^i-G)H)H
r4 c t t j }| t j j | v d S rk )r r r7 assert_r r. get_schema_namesr< rn s r2 test_get_schema_namesz-ComponentReflectionTest.test_get_schema_names s? wz"" W^/43H3H3J3JJKKKKKr4 c t j }t |j d rJ t | t |j d sJ d S )Nr )r r hasattrr9 r )r< engines r2 test_dialect_initializez/ComponentReflectionTest.test_dialect_initialize sS '))6>+@AAAAAv~'<=======r4 c t t j }t |j t j j j d S rk )r r r7 r r r9 r s r2 test_get_default_schema_namez4ComponentReflectionTest.test_get_default_schema_name s2 wz"" D $gj&8&LMMMMMr4 tablec g d | j }t |j }|dk rL| | }| ddg}t t
| | d S |r d | | D }n| | } fd|D }|dk rg d}t || d S g d }t t
| | d S )
N)r r r r r r viewemail_addresses_vusers_vc . g | ]}|d
|d S )r rF .0recs r2
zAComponentReflectionTest._test_get_table_names.. s6 1vF r4 c g | ]}|v| S rF rF )r t_ignore_tabless r2 r zAComponentReflectionTest._test_get_table_names.. s# HHH 0G0G10G0G0Gr4 foreign_key)r r r )r r r ) r1 r bindget_view_namessortr sorted get_sorted_table_and_fkc_namesget_table_names)
r< r*
table_typeorder_bymetarn table_namesanswertablesr s
@r2 _test_get_table_namesz-ComponentReflectionTest._test_get_table_names s=
}ty!! --f55K )95F {##V , , , , ,
6 # B B6 J J --f55HHHHfHHHK=((CCCK(((((CCCF;''00000r4 c t | j }| }t t | dg d S )Nr )r r get_temp_table_namesr r r< rn temp_table_namess r2 test_get_temp_table_namesz1ComponentReflectionTest.test_get_temp_table_names sD ty!! 4466 F# $ $zl33333r4 c t | j }| }t t | dg d S )N
user_tmp_v)r r get_temp_view_namesr r r
s r2 test_get_temp_view_namesz0ComponentReflectionTest.test_get_temp_view_names sF ty!! 3355 F# $ $|n55555r4 c . | d S rk r r< s r2 test_get_table_namesz,ComponentReflectionTest.test_get_table_names s ""$$$$$r4 c 2 | d d S )Nr )r r r s r2 test_get_table_names_fksz0ComponentReflectionTest.test_get_table_names_fks s!
""M":::::r4 c . | d S rk )_test_get_commentsr s r2 test_get_commentsz)ComponentReflectionTest.test_get_comments s !!!!!r4 c N | t j j d S rk )r r r r. r s r2 test_get_comments_with_schemaz5ComponentReflectionTest.test_get_comments_with_schema
s#
:;;;;;r4 c J t t j }t | d| ddi t | d| dd i t d | d| D ddd d
d d d d
d g d S )Nr r) textr r c 0 g | ]}|d |d dS )rL rO )rL rO rF r s r2 r z>ComponentReflectionTest._test_get_comments.. s8
VY @@
r4 r r# )rO rL r r& r r )r r r7 r r rt )r< r* rn s r2 r z*ComponentReflectionTest._test_get_comments s wz"" " ">& " A A
: ;
D " "76 " : :VTNKKK
++N6+JJ
)$77 ,f== I
r4 c N | t j j d S rk r r r r. r s r2 test_get_table_names_with_schemaz8ComponentReflectionTest.test_get_table_names_with_schema- s#
""7>#=>>>>>r4 c 2 | d d S Nr )r r r s r2 test_get_view_namesz+ComponentReflectionTest.test_get_view_names2 s ""f"55555r4 c R | t j j d d S r# r r s r2 test_get_view_names_with_schemaz7ComponentReflectionTest.test_get_view_names_with_schema6 s5
"" N &6 #
r4 c Z | | d d S r# r r s r2 test_get_tables_and_viewsz1ComponentReflectionTest.test_get_tables_and_views= s3
""$$$ ""f"55555r4 c t t j }| j j | j j }}ddg}|dk rddg}t
|j }t |||f D ]\ }} |}
| ||
} |
t | dk t | t | j
D ]\ } }
t |
j | | d | | d j }|
j }t% |t& j j r|j }t j d
r&|t. j t. j fv r t. j }|
t t5 |j |j t. j t. j t. j t. j t. j t. j t. j! g dk |
j d |
j d | | d d |d
|
j" s| | d J d S )Nr r r r r r) r rL typeoracle(z), )default)#r r r7 r r r r r ziprt r len enumeratecolumnsr rL __class__r*
isinstancerZ r
TypeEngineagainst sql_typesDateDateTimeset__mro__ intersectionr NumericTimer _Binaryr% )r< r* r r r addressesr rn r r schema_namecolsicolctype ctype_defs r2 _test_get_columnsz)ComponentReflectionTest._test_get_columnsC sG
## K -t{/Jy 12 $&9:Kty!!!$[5)2D!E!E / 6 / 6 J K##J{#CCD LLTQ D 2 2 2 $EM22 (
6 (
63CHd1gfo... Q1 H i)<== 4 ) 3I ?8,, / N &? 2 2 !*I
EM**% i&788% ) 1 ) 1 ) 2 ) ) ) 0 ) 1
" xxx476???EEEC# * 6 79-555Q(
6/ 6 / 6r4 c . | d S rk rG r s r2 ru z(ComponentReflectionTest.test_get_columns{ r4 c t d| j gd t | D R }| d t | j j d D S )Nr c : g | ]\ }}t d |z | S )zt%dr )r rC type_s r2 r z. s*
H
H
H81efUQY&&
H
H
Hr4 c g | ]
}|d S )r* rF r r s r2 r z. s)
AfI
r4 )r r1 r1 creater r rt )r< r r s r2 _type_round_tripz(ComponentReflectionTest._type_round_trip s M
I
Hy7G7G
H
H
H
&t}'9 : : F Fs K K
r4 c | t j dd D ]H}t |t j sJ t |j d t |j d Id S )N r )rQ r7 r= r4 r precisionscaler< typs r2 test_numeric_reflectionz/ComponentReflectionTest.test_numeric_reflection sv (():2q)A)ABB C c9#455 5 55
r " " " 1 r4 c | t j d d }t |t j sJ t |j d d S )N4 r )rQ r7 r r4 r lengthrV s r2 test_varchar_reflectionz/ComponentReflectionTest.test_varchar_reflection sV ##I$4R$8$899!<#y /00000 CJr4 c
X t d| j t dt d t dt d }| t t
d t | j j d D ddd d S ) Nr aTr bFc 3 6 K | ]}|d |d fV dS )rL r NrF r rD s r2 zCComponentReflectionTest.test_nullable_reflection.. sC Vc*o. r4 )r^ r_ )
r r1 r
r rP r r r r rt )r< r s r2 test_nullable_reflectionz0ComponentReflectionTest.test_nullable_reflection s
M 3$ / / / 3% 0 0 0
"4=#566BB3GG
U # #
r4 c P | t j j d S Nr) rG r r r. r s r2 test_get_columns_with_schemaz4ComponentReflectionTest.test_get_columns_with_schema &
gn&@ AAAAAr4 c v t | j }| j j }t |j }| d }| t | dk t | t |j D ]&\ }}t |j || d 'd S )Nr r rL ) r r r r r rt r r0 r1 r2 r rL )r< r r rn rB rC rD s r2 test_get_temp_table_columnsz3ComponentReflectionTest.test_get_temp_table_columns s "";'ty!!
++ SYY]CII... 011 + +FAs $q'&/ * * * * + +r4 c t | j }| d }t d |D g d d S )Nr c g | ]
}|d S rN rF ra s r2 r zFComponentReflectionTest.test_get_temp_view_columns.. s ) ) )SS[ ) ) )r4 )r# rL r )r r rt r )r< rn rB s r2 test_get_temp_view_columnsz2ComponentReflectionTest.test_get_temp_view_columns sR ty!! -- ) )D ) ) )+@+@+@AAAAAr4 c 2 | d d S r# rI r s r2 test_get_view_columnsz-ComponentReflectionTest.test_get_view_columns s & 11111r4 c R | t j j d d S )Nr )r* r rf r s r2 !test_get_view_columns_with_schemaz9ComponentReflectionTest.test_get_view_columns_with_schema s5
>-&
r4 c | j }| j j | j j }}t |j }| |j | }|d }t |dg | |j | }|d } t | dg t j
j 5 t |d d d d d d S # 1 swxY w Y d S )Nr) constrained_columnsr r rL r )
r1 r r r r r rx rL r r r+ reflects_pk_namesfail_if)
r< r* r r r@ rn
users_cons users_pkeys addr_cons
addr_pkeyss
r2 _test_get_pk_constraintz/ComponentReflectionTest._test_get_pk_constraint s* } ;,dk.Iyty!!++EJv+FF
!67 K)%%%**9>&*II 45
J '''
/
7
7
9
9 2 2 &!= 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2s C%%C),C)c . | d S rk )rz r s r2 ry z.ComponentReflectionTest.test_get_pk_constraint s $$&&&&&r4 c P | t j j d S re )rz r r r. r s r2 "test_get_pk_constraint_with_schemaz:ComponentReflectionTest.test_get_pk_constraint_with_schema s&
$$GN,F$GGGGGr4 c | j }| j j }t |j }t t j d|j |j d S )Nz+.*get_primary_keys\(\) method is deprecated)
r1 r r r r r sa_excSADeprecationWarningget_primary_keysrL )r< r r rn s r2 test_deprecated_get_primary_keysz8ComponentReflectionTest.test_deprecated_get_primary_keys sT } !## ' : ! J
r4 c & | j }| j j | j j }}t |j }|}t j j j r|
|j | }|d }t j j
5 t |d d d d d n # 1 swxY w Y t |d | t |d |j t |d dg t j j j rt |d d
g |
|j | } | d }t j j
5 | |d d u d d d n # 1 swxY w Y t |d | t |d |j t |d dg t |d d g d S ) Nr) r rL r referred_schemareferred_tablereferred_columnsr rs r r )r1 r r r r r r r+ r r- r{ rL named_constraintsru r implicitly_named_constraintsr )
r< r* r r r@ rn expected_schema users_fkeysfkey1
addr_fkeyss
r2 _test_get_foreign_keysz.ComponentReflectionTest._test_get_foreign_keys sq } K -t{/Jyty!! 9 A F //
6/JJK NE!3;;==
1
1E&M<000
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
'(/ : : : &' 4 4 4 ()I; 7 7 7 =E
FE/03C2DEEE **9>&*II
1
:
B
B
D
D 4 4 LLv d2 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 E# $o666 E" #UZ000 E$ % {333 E' (+;*<=====s$ B66B:=B:= F''F+.F+c . | d S rk )r r s r2 r| z-ComponentReflectionTest.test_get_foreign_keys s ##%%%%%r4 c P | t j j d S re )r r r r. r s r2 !test_get_foreign_keys_with_schemaz9ComponentReflectionTest.test_get_foreign_keys_with_schema s&
##7>+E#FFFFFr4 c | dt j j j z dt j j z dt j j z \ }}}t t
j }| |j }t t | d |d }t |d t j j t |d |j t |d d g t |d
d g | |j t j j }t t | d |d }|d d t j j j fv sJ t |d |j t |d d g t |d
d
g d S )Nz%s.local_tablez%s.remote_tablez%s.remote_table_2 r r r r r# rs r r) r ) r r r7 r9 r r r. r r{ rL r r0 ) r< r r r rn local_fkeysr remote_fkeysfkey2s r2 "test_get_inter_schema_foreign_keysz:ComponentReflectionTest.test_get_inter_schema_foreign_keys s 59KK wz 1 E E : : '."< <5
5
1 \> vy!!++K,<== C a A E# $gn&@AAA E" #^%8999 E$ %v... E' (;-888,, gn&@ -
C q!!! Q&' J 2,
E" #[%5666 E$ %v... E' (:,77777r4 c 2 | d d S )NCASCADE)ondelete _test_get_foreign_key_optionsr s r2 %test_get_foreign_key_options_ondeletez=ComponentReflectionTest.test_get_foreign_key_options_ondeleteC s **I*>>>>>r4 c 2 | d d S )NzSET NULL)onupdater r s r2 %test_get_foreign_key_options_onupdatez=ComponentReflectionTest.test_get_foreign_key_options_onupdateG s **J*?????r4 c
| j }t d|t dt d d t d|t dt d t dt t j dd
t d t
d d t d
|t dt d t dt
d d t dt t j dgdgfddi|d | t |j
}| d d d t t fdD i | d
d d t t fdD | d S )Nxr# Tr$ rS r x_idzx.idxidrN test
userrL r' Fr tidztable.idmyfkr r c 3 < K | ]}|
|| fV d S rk rF r koptss r2 rb zHComponentReflectionTest._test_get_foreign_key_options..s 4 77!tAw7!T!W 777777r4 c 3 < K | ]}|
|| fV d S rk rF r s r2 rb zHComponentReflectionTest._test_get_foreign_key_options..v r r4 )r1 r r
r rZ r r r]
create_allr r r{ r r )r< r r rn r s @r2 r z5ComponentReflectionTest._test_get_foreign_key_optionsK s }
4d 3 3 3
4d 3 3 3 67BM&u$E$E$E F F 66":: & &
4d 3 3 3 66":: 6 6 6 5' " " #*
,2
6=
ty!! $$W--a0; D7777t777 7 7<<<$$V,,Q/ : D7777t777 7 7AAAAAr4 c d |D }|D ]P}|d |v sJ || |d }|D ] }t || || Qd S )Nc g | ]
}|d S rN rF )r ds r2 r z@ComponentReflectionTest._assert_insp_indexes..y s 222Qqy222r4 rL )indexr )r< indexesexpected_indexes index_namese_indexr keys r2 _assert_insp_indexesz,ComponentReflectionTest._assert_insp_indexesx s 22'222 ' . .G6?k1111K - -gfo > >?E
.
.GCL%*----
. . .r4 c | j }t |j }| d| }dddgdddg dd dg}| || d S )
Nr r) Fr r r unique column_namesrL )r r r r )r1 r r r~ r )r< r* r rn r r s r2 _test_get_indexesz)ComponentReflectionTest._test_get_indexes s } ty!!""76":: !(' 2%
= = ='
!!'+;<<<< !!'+;<<< %TY 7 7 7 C NNA DOOA $a((( DOOA #V,,,,,r4 c 2 | dd d S )Nr r r r s r2 test_get_noncol_index_no_pkz3ComponentReflectionTest.test_get_noncol_index_no_pk s"
##$:Skipped unsupported reflection of expression-based index t_idxt_idx_2r )rL r r )
r r1 r
r r rc r r r r r r r~ r s r2 %test_reflect_expression_based_indexesz=ComponentReflectionTest.test_reflect_expression_based_indexes sl M 3r
# # 3r
# #
M = > >
M>3/M+N+N
"""t})**
L
%%#cUaHHI
s *DD Dc . | d S rk ) _test_get_unique_constraintsr s r2 r z3ComponentReflectionTest.test_get_unique_constraints s ))+++++r4 c t | j }| d }|D ]}| dd t |dgddg d S )Nr duplicates_indexrL r )r rL )r r r popr )r< rn reflectedrefls r2 &test_get_temp_table_unique_constraintsz>ComponentReflectionTest.test_get_temp_table_unique_constraints sr ty!!//
;; / /D
HH' . . . . I&=IIJKKKKKr4 c t | j }| d }|D ]}| dd t d |D ddgddg d S )Nr dialect_optionsc * g | ]}|d dk |S )rL r rF r idxs r2 r zGComponentReflectionTest.test_get_temp_table_indexes.. s& D D DSs6{m'C'CS'C'C'Cr4 Fr r r )r r r~ r r )r< rn r inds r2 test_get_temp_table_indexesz3ComponentReflectionTest.test_get_temp_table_indexes s ty!!"":.. - -C GG%t , , , ,
E DG D D D $%*G )
r4 c P | t j j d S re )r r r r. r s r2 'test_get_unique_constraints_with_schemaz?ComponentReflectionTest.test_get_unique_constraints_with_schema s&
)) 1K)LLLLLr4 c ` t ddgddg dddg dddd d
gdd d gdd
dgdgt j d }| j }t d|t dt
j d t d t
j d t dt j t d t
j d t d
t
j d | }|D ]2}| t
j
|d d|d i 3| t |j
}t | d| t j d }t }t! || D ]B\ } }
|
dd } | r| | t' | |
Ct) } t d| |j
| }t d |j D }
t d |j D dg }|
| rJ |r.t' ||
t' |t d S d S )Nunique_ar^ )rL r unique_a_b_c)r^ r_ r unique_c_a_b)r r^ r_ unique_asc_keyascr z i.have.dotsr_ z
i have spacesr rL r testtblr r r) r r )r r* c g | ] }|j
S rF rN r s r2 r zHComponentReflectionTest._test_get_unique_constraints..? s ???c???r4 c P g | ]#}t |t j |j $S rF )r4 rZ r\ rL )r uqs r2 r zHComponentReflectionTest._test_get_unique_constraints..A s=
b""566
r4 )r operator
itemgetterr1 r r
rZ r r append_constraintr\ r r r r r: r/ r addr r r constraints
differencer< )r< r* uniques orig_metar uc inspectorr names_that_duplicate_indexorigr dupereflected_metadata idx_namesuq_namess r2 r z4ComponentReflectionTest._test_get_unique_constraints s #cU;;' II' II)E5>JJ&>>(3%@@
#F++
M 3 "
& & 3 "
& & 3
# # 5")B-- ( ( 5")B-- ( (
B # ##R%7IbjII
IN++ , ,Yv , F F#F++
&)UU" gy11 JD$ 88 .55D
5*..t444 dOOOO %ZZ #.
??Y->???@@
#/
*n%
&
&
))(33333 % ! *I 6 6 6 #%% ! !r4 c . | d S rk )_test_get_check_constraintsr s r2 r z2ComponentReflectionTest.test_get_check_constraintsM s ((*****r4 c P | t j j d S re )r r r r. r s r2 !test_get_check_constraints_schemaz9ComponentReflectionTest.test_get_check_constraints_schemaQ s&
((0J(KKKKKr4 c
| j }t d|t dt t j dd t j dd | | t |j }t |
d| t j d
}d fd |D }t |dd
ddddg d S )Nsa_ccr^ za > 1 AND a < 5cc1rN za = 1 OR (a > 2 AND a < 5)cc2r) rL r c d t j d| t j S )N zand|\d|=|a|or|<|>)joinrefindalllowerI)sqltexts r2 normalizezFComponentReflectionTest._test_get_check_constraints..normalizem s4 88
/ "$GG
r4 c D g | ] }|d |d d S )rL r rL r rF )r itemr
s r2 r zGComponentReflectionTest._test_get_check_constraints..r sC
&\iiY.H.H I I
r4 za > 1 and a < 5r za = 1 or a > 2 and a < 5)r1 r r
r rZ r^ r r r r r r r r )r< r* r r r r
s @r2 r z3ComponentReflectionTest._test_get_check_constraintsV s3 M
3 " " 0u = = = ;% H H H
IN++ + +GF + C C#F++
!
+<== +EFF
r4 c | j }d}d}t |j }| || }| | | || }| | d S )Nr r r) )r1 r r rq r )r< r* r
view_name1
view_name2rn v1v2s r2 _test_get_view_definitionz1ComponentReflectionTest._test_get_view_definition~ s| }
(
ty!!
%
%j
%
@
@ R
%
%j
%
@
@ Rr4 c . | d S rk )r r s r2 rr z0ComponentReflectionTest.test_get_view_definition s &&(((((r4 c P | t j j d S re )r r r r. r s r2 $test_get_view_definition_with_schemazzBComponentReflectionTest.test_autoincrement_col.. s ...A1V9a...r4
autoincrementTN)r1 r r rt get)r< r rn r cnamerB id_s r2 test_autoincrement_colz.ComponentReflectionTest.test_autoincrement_col s }ty!!
2 2LE5
##E**D.....u5C77?D11 1 11 1 2 2r4 )Nr Nrk )Nr )`rA rB rC run_inserts run_deletesrD rE r r3 r r r r r r+ schema_reflectionr r r provide_metadatar r r r r r table_reflectionr !foreign_key_constraint_reflectionr r r r, r r r! r` r$ r& r( rG ru rQ rX r\ rc rg r rj rm ro rq rz !primary_key_constraint_reflectionry r} r r r| r r r 1foreign_key_constraint_option_reflection_ondeleter 1foreign_key_constraint_option_reflection_onupdater r r r r r r r r r r indexes_with_expressionsr r r r r r r r r r r r rr r only_onr r! r# r+ rF r4 r2 r r s
$$K+K [ N N [N
M- M- [M-^ O O [O4 N N [N [
'L L ('L
'> > ('>
'N N ('N
8<$1 $1 $1 $1L
&4 4 '&4
% & %6 6 &% '& &%6
&% % '&%
& 7; ; 87 '&;
(" " )("
( < < )(<
6
& ? ? '&?
,6 6 -,6
,
-,
& ,6 6 -, '&666 66 66 66p
&! ! '&!
& '&
& '&
&
'&
& B B '&B
++ + ,++
+ , %B B &% -, ,+B
,2 2 -,2
,
-,
2 2 2 2
7' ' 87'
& 7 H H 87 '&H
&
'&
> > > >@
7& & 87&
7 G G 87G
0 8 8 10 8B
G? ? HG?
G@ @ HG@
*B *B *BX. . .
= = = =*
&! ! '&!
& B B '&B
- - -
& *O O +* '&O
& *K K +* '&K
. /.6
2, , 32,
+ 2L L 32 ,+L
+
,+
$
2 M M 32M
L! L! L! L!\
1+ + 21+
1 L L 21L
%
%
%
%
N
%) ) &%)
% J J &%J W_\#899 + + + :9+ * * *
M M M
& 2 2 '&2 2 2r4 r c 8 e Zd ZdZdZed Zd Zd ZdS )NormalizedNameTest)denormalized_namesTc t t dd |t dt d t t dd |t dt d t dt d d S ) Nt1Trb r# r$ t2t1idzt1.id)r r r
r r r/ s r2 r3 z NormalizedNameTest.define_tables s
D ) ) ) 4d 3 3 3
D ) ) ) 4d 3 3 3 6:g.. / /
r4 c t t j }t t dd |d }|j d }|j j |j j sJ t t j }|
d |j d j j |j d j j sJ d S )Nr= Tr< )autoloadr; c . | dv S )Nr; r= r
)rL ms r2 zINormalizedNameTest.test_reflect_lowercase_forced_tables.. s
(D r4 )only) r r r7 r r r r r>
referencesr# reflect)r< m2t2_reft1_refm3s r2 $test_reflect_lowercase_forced_tablesz7NormalizedNameTest.test_reflect_lowercase_forced_tables s
gj
!
!{4t444b4HHH4 x}'' 44444
gj
!
!
DD
EEEy %004 1B1EFFFFFFFr4 c p d t t j D }t |d |d t |d |d d S )Nc > g | ]}| d v |S )rB rC )r r s r2 r z;NormalizedNameTest.test_get_table_names.. s5
wwyyL((
(((r4 r r )r r r7 r r upperr
)r<
tablenamess r2 r z'NormalizedNameTest.test_get_table_names s
WZ((88::
JqM ! !:a=#6#6#8#8999 JqM ! !:a=#6#6#8#899999r4 N) rA rB rC __requires__rD rE r3 rM r rF r4 r2 r8 r8 sX *LK
[
G G G: : : : :r4 r8 c P e Zd Zd Zd Zd Zd Zej j d Z
dS )ComputedReflectionTestc t t j }| d }|D ]D}|d dk rt d|d v &|d st |d d Ed S )Ncomputed_column_tablerL with_default42r. r' )r r r7 rt r r
)r< rn rB rD s r2 !test_computed_col_default_not_setz8ComputedReflectionTest.test_computed_col_default_not_set s vy!! 788 * *C6{n,,I.//// )
*C ND))) * *r4 c X t t j }| d }d |D }dD ]}t d|| v |d }t d|v t d|d v t | |d d d t d|d v t j j j
t j j j
r2t |d d t j j j
d S d S ) Ncomputed_default_tablec i | ] }|d | S rN rF rO s r2 r& zKComputedReflectionTest.test_get_column_returns_computed.. +++& 1+++r4 )r# normalrW computed computed_colr normal+42 persisted) r r r7 rt r r r
r r+ "computed_columns_reflect_persistedr- "computed_columns_default_persisted)r< rn rB r& r compDatas r2 test_get_column_returns_computedz7ComputedReflectionTest.test_get_column_returns_computed s9 vy!! 899++d+++3 1 1C Jd3i/ 0 0 0 0'
h&''' Xj 11222 DNN8J/ : ; ;[III 8J/ / ? G
> F $[1 CK
r4 c t d|| v || d }t | |d | t j j j r)t d|v t |d | d S d S )Nr_ r rb )r r r
r r+ rc r- r
)r< r& columnr rb re s r2 check_columnz#ComputedReflectionTest.check_column s
d6l*+++<
+ DNN8I. / /999 > F 2 K8+ , , , %y 1 1 1 1 1 2 2r4 c t t j }| d }d |D }| |ddt
j j j t
j j j r| |ddd t
j j
j r| |dd d
d S d S ) NrV c i | ] }|d | S rN rF rO s r2 r& zLComputedReflectionTest.test_get_column_returns_persisted.. r] r4 computed_no_flagra computed_virtualznormal+2Fcomputed_storedz normal-42T) r r r7 rt ri r r+ rd r- computed_columns_virtualcomputed_columns_storedr< rn rB r& s r2 !test_get_column_returns_persistedz8ComputedReflectionTest.test_get_column_returns_persisted
s vy!! 788++d+++ ? G
4 < "
3 ; !
r4 c t t j }| dt j }d |D }| |ddt j j j t j j
j r| |ddd t j j j r| |d d
d d S d S ) NrV r) c i | ] }|d | S rN rF rO s r2 r& zXComputedReflectionTest.test_get_column_returns_persisted_with_schema../ r] r4 rl z normal/42rm znormal/2Frn z normal*42T) r r r7 rt r. ri r r+ rd r- ro rp rq s r2 -test_get_column_returns_persisted_with_schemazDComputedReflectionTest.test_get_column_returns_persisted_with_schema( s vy!! #F,>
,+d+++ ? G
4 < "
3 ; !
r4 N) rA rB rC rY rf ri rr r r+ r, ru rF r4 r2 rT rT sr * * * *2 2 2 6
r4 rT c e Zd ZdZed Zej j ej d Z
ej j ej d Z dS )CompositeKeyReflectionTestTc B t d|t dt t dt t dt j d t j dddd d d }t d
|t dt d t d t t d
t t dt j d t j g d|j j |j j
|j j gd d d d S )Ntb1r# attrrL r pk_tb1rN Tr tb2r$ pidpattrpnamer r} r~ fk_tb1_name_id_attr) r r
r r7 r rZ r[ r] r rL r# rz )r0 r1 ry s r2 r3 z(CompositeKeyReflectionTest.define_tablesJ s 4 ! ! 67 # # 69,R00 1 1 #FD&x H H H
4d 3 3 3 5' " " 7G $ $ 7I -b 1 1 2 2 #)))SUXsuz2*
r4 c | j }t |j }| | j j j }t | d g d d S )Nrs rL r# rz ) r1 r r rx r ry rL r r( )r< r rn r% s r2 test_pk_column_orderz/CompositeKeyReflectionTest.test_pk_column_orderf s^ }ty!!,,T[_-ABB KOO 1 2 24J4J4JKKKKKr4 c b | j }t |j }| | j j j }t t | d |d }t | d g d t | d g d d S )Nr r r r rs r )
r1 r r r{ r r| rL r r0 r( )r< r rn foreign_keysr s r2 test_fk_column_orderz/CompositeKeyReflectionTest.test_fk_column_ordero s }ty!!,,T[_-ABB C q!!! Q EII( ) )+A+A+ABBB EII+ , ,.G.G.GHHHHHr4 N)
rA rB rC rD rE r3 r r+ r2 r/ r r1 r rF r4 r2 rw rw G s K
[
6
7 L L 87L
7 I I 87I I Ir4 rw )r rH r r8 rT rw )/r r r rZ r r r r r r r r
provisionr r* r
r r r r r r r r r r r r7 engine.reflectionr r r sql.elementsr r r r1 r
TablesTestr rH r r8 ComputedReflectionFixtureTestrT rw __all__rF r4 r2 r s/ $ $ $ $ $ $ / / / / / / " " " " " " * * * * * * ' ' ' ' ' ' %+ + + + +8& + + +\N0 N0 N0 N0 N0X 0 N0 N0 N0bX2 X2 X2 X2 X2h 1 X2 X2 X2v %: %: %: %: %:, %: %: %:P_ _ _ _ _X C _ _ _D2I 2I 2I 2I 2I!4 2I 2I 2Ij r4