=GE?C d dl Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ dd lmZ dd
l m
Z
d d lm Z d d
lm Z d dlm
Z
d dlmZ d dlmZ d dlmZ d dlm Z d dlmZ d dlmZ G d dej Z G d dej ZdZdS ) N )testing )config)fixtures)util)eq_) requirements)Table )CheckConstraint)Column)ForeignKeyConstraint)Index)inspect)Integerschema)String)UniqueConstraintc e Zd ZdZd dZd Zd Zej e j
d Z ej ej e j
d Z
ej e j
d Zej e j
d Zej e j
d
Zej e j
d ZdS )
TableDDLTestTNc t d| j t dt dd t dt d | S ) N
test_tableidTF primary_key
autoincrementdata2 r r metadatar r r )selfr s u/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/testing/suite/test_ddl.py_simple_fixturez TableDDLTest._simple_fixture sK M 4d% H H H 66":: & &
c t d| j t dt dd t dt d S )N _test_tabler TFr _datar r! )r# s r$ _underscore_fixturez TableDDLTest._underscore_fixture! sC M 4d% H H H 7F2JJ ' '
r& c z t j 5 }| | d | | }t | d d d d d S # 1 swxY w Y d S )N)r z some data) r dbbeginexecuteinsertvaluesselectr first)r# tableconnresults r$ _simple_roundtripz TableDDLTest._simple_roundtrip) s
Y__
2$ LL ../?@@ A A A\\%,,..11F 0 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2s BB00B47B4c | }| t j d | | d S NF
checkfirst)r% creater r, r6 r# r3 s r$ test_create_tablez TableDDLTest.test_create_table/ sG $$&&
VY5 111 u%%%%%r& c | t j }| t j d | | d S )Nr Fr9 )r% r test_schemar; r, r6 r< s r$ test_create_table_schemaz%TableDDLTest.test_create_table_schema6 sO $$F,>$??
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&