w$??
VY5 111 u%%%%%r& c | }| t j d | t j d d S r8 )r% r; r r, dropr< s r$ test_drop_tablez TableDDLTest.test_drop_table> sK $$&&
VY5 111
69
/////r& c | }| t j d | | d S r8 )r* r; r r, r6 r< s r$ test_underscore_namesz"TableDDLTest.test_underscore_namesE sG ((**
VY5 111 u%%%%%r& c X | }| t j d d|_ t j t
j | t t t j
d ddi d S NFr9 z a commentr text) r% r; r r, commentr. r SetTableCommentr r get_table_commentr< s r$ test_add_table_commentz#TableDDLTest.test_add_table_commentL s $$&&
VY5 111#
&077888 FI 0 0 > >
[ !
r& c | }| t j d d|_ t j t
j | t j t
j | t t t j d dd i d S rG ) r% r; r r, rI r. r rJ DropTableCommentr r rK r< s r$ test_drop_table_commentz$TableDDLTest.test_drop_table_commentX s $$&&
VY5 111#
&077888 &1%88999 GFI 0 0 > >OOOOOr& )N)__name__
__module__ __qualname__ __backend__r% r* r6 r
create_tabler provide_metadatar= schemasr@
drop_tablerC rE comment_reflectionrL rO r& r$ r r sl K
2 2 2 & & &
& & &
0 0 0
& & &
$
%$
$ P P %$P P Pr& r c e Zd ZdZdZd Zd Zd Zd Zd Z e
j dd d
d e
j j
fd e
j j fd
e
j d ZdS )LongNameBlowoutTestzjtest the creation of a variety of DDL structures and ensure
label length limits pass on backends
Tc ddd d t d D z i}||_ t d|t dt
d d
t
d gd g }t d
|t d |d
|j }| | t j
j j r6t | }| d
}|d d }||fS |d fS )NfkzGforeign_key_%(table_name)s_%(column_0_N_name)s_%(referred_table_name)s__c 3 n K | ]0}d d t d D V 1dS ) c 3 > K | ]}t j d V dS abcdefNrandomchoice.0js r$ z3LongNameBlowoutTest.fk...r , GGFM( 3 3GGGGGGr& Njoinrangerh is r$ rj z)LongNameBlowoutTest.fk..q W GGGGU2YYGGGGG r&
a_things_with_stuffid_long_column_nameTr )
test_needs_fkaidz'a_things_with_stuff.id_long_column_nameb_related_things_of_valuer name)rn ro naming_conventionr r r r rz
create_allr requires&foreign_key_constraint_name_reflectionenabledr get_foreign_keys) r# r"
connection
conventioncons actual_nameinspfksreflected_names r$ r] zLongNameBlowoutTest.fkk sM ' "2YY
&0"
! ('t D D D
$
G?@
'
i J''' B J %:&&D''(CDDC VF^N . . $ $r& c
ddd d t d D z i}||_ t d|t dt
d t d
t
d }|j }|j }| | t | }|
d }|d } || fS ) Npkz.primary_key_%(table_name)s_%(column_0_N_name)sr^ c 3 n K | ]0}d d t d D V 1dS )r` c 3 > K | ]}t j d V dS rb rd rg s r$ rj z3LongNameBlowoutTest.pk... rk r& Nrm rp s r$ rj z)LongNameBlowoutTest.pk.. rr r& rs rt ru Trv id_another_long_namerz ) rn ro r{ r r r r rz r| r get_pk_constraint)
r# r" r r ar r r r r s
r$ r zLongNameBlowoutTest.pk s " "2YY
&0" ! ('t D D D )7 E E E
}i J'''z""
#
#$9
:
:FN**r& c ddd d t d D z i}||_ t d|t dt
d t d
t
}t
d |j j |j j }|j
}| | t | }|
d }|d d } || fS )
Nixz(index_%(table_name)s_%(column_0_N_name)sr^ c 3 n K | ]0}d d t d D V 1dS )r` c 3 > K | ]}t j d V dS rb rd rg s r$ rj z3LongNameBlowoutTest.ix... rk r& r Nrm rp s r$ rj z)LongNameBlowoutTest.ix.. rr r& rs rt ru Trv r r rz )rn ro r{ r r r r cru r rz r| r get_indexes)
r# r" r r r r r r r r s
r$ r zLongNameBlowoutTest.ix s " "2YY
&0" ! ('t D D D )7 3 3
T132AC4LMMi J'''z""
3
4
4Av N**r& c ddd d t d D z i}||_ t dd }t d|t dt d
t dt | |j }| | t | }|
d }|d d }||fS )
Nuqz4unique_constraint_%(table_name)s_%(column_0_N_name)sr^ c 3 n K | ]0}d d t d D V 1dS )r` c 3 > K | ]}t j d V dS rb rd rg s r$ rj z3LongNameBlowoutTest.uq... rk r& r Nrm rp s r$ rj z)LongNameBlowoutTest.uq.. rr r& rs ru r rt Trv r rz ) rn ro r{ r r r r rz r| r get_unique_constraints) r# r" r r r r r r r s r$ r zLongNameBlowoutTest.uq s " "2YY
&0" 57MNN
! ('t D D D )7 3 3
i J'''z""
(
()>
?
?Av N**r& c ddd d t d D z i}||_ t d }t d|t dt d
t d t | |j }| | t | }|
d }|d d
}||fS )Nckz check_constraint_%(table_name)sr^ c 3 n K | ]0}d d t d D V 1dS )r` c 3 > K | ]}t j d V dS rb rd rg s r$ rj z3LongNameBlowoutTest.ck... rk r& r Nrm rp s r$ rj z)LongNameBlowoutTest.ck.. rr r& rs zsome_long_column_name > 5rt ru Trv some_long_column_namer rz ) rn ro r{ r
r r r rz r| r get_check_constraints) r# r" r r r r r r r s r$ r zLongNameBlowoutTest.ck s 3 "2YY
&0" :;;
! ('t D D D *G 4 4
i J'''z""
'
'(=
>
>Av N**r& )r] )r )r r r type_)argnamesc r | j } t | | || \ }}t | dk sJ |{|dt | }t | t | k r2t |dd |dt | dz
d S t || d S d S )N r )r" getattrlenr )r# r r r" r r overlaps r$ test_long_convention_namez-LongNameBlowoutTest.test_long_convention_name
s =&:gdE&:&: j'
'
# ^ ; #%%%% %!!c.&9&9"9:G7||c+ . ...GAbDM>!c'llQ6F2F#GHHHHHG^,,,,, & %r& N)rP rQ rR __doc__rS r] r r r r r combinationsr} check_constraint_reflectionas_skips unique_constraint_reflectionrU r rY r& r$ r[ r[ c s
K,% ,% ,%\+ + +8+ + +8+ + +:+ + +8 W
w ;DDFFG
w <EEGGH
- - - - -r& r[ )r r[ )re r` r r r r
assertionsr r
r r r
r r r r r r r TestBaser r[ __all__rY r& r$ r s
! ! ! ! ! ! $ $ $ $ $ $ KP KP KP KP KP8$ KP KP KP\~- ~- ~- ~- ~-(+ ~- ~- ~-B 2r&