3.q5 d dl mZ d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlm Z dd l m
Z
dd
l m Z dd l m Z dd l m
Z
dd
l mZ G d dej Z G d dej Z G d dej ZdZdS ) )config)engines)fixtures)eq_) requirements)Column)Table )Integer)literal)literal_column)select)Stringc j e Zd ZdZdZdZddiZed Zd Z d Z
d Z e j
d
Zd S )
LastrowidTesteachT)implements_get_lastrowidautoincrement_insertimplicit_returningFc t d|t dt dd t dt d t d|t dt dd t dt d d S )
N
autoinc_pkidT primary_keytest_needs_autoincrementdata2 manual_pkFr
autoincrementr r r r clsmetadatas x/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/testing/suite/test_insert.py
define_tableszLastrowidTest.define_tables s
g4$
66":: & &
4d% H H H 66":: & &
c | | }t |t j j j df d S N some dataexecuter firstr r dbdialectdefault_sequence_baseselftableconnrows r% _assert_round_tripz LastrowidTest._assert_round_trip* J ll5<<>>**0022 C&)#9;GHHHHHr' c t j | j j d | | j j t j d S Nr* r r r. r, tablesr insertr6 r2 s r% test_autoincrement_on_insertz*LastrowidTest.test_autoincrement_on_insert. Q $+07799 LLL 6 BBBBBr' c . t j | j j d }t j t | j j j j g }t |j |g d S r9 r r. r, r< r r= scalarr cr r inserted_primary_keyr2 rpks r% test_last_inserted_idz#LastrowidTest.test_last_inserted_id3 | I K " ) ) + ++
Y
fdk&<&>&A%B C C
D
D A "RD)))))r' c 0 t j | j j d }|j }t j t | j j j j
g }t || d S r9 ) r r. r, r< r r= lastrowidrC r rD r r )r2 rG rL rH s r% test_native_lastrowid_autoincz+LastrowidTest.test_native_lastrowid_autoinc? s~ I K " ) ) + ++
K
Y
fdk&<&>&A%B C C
D
D Irr' N)__name__
__module__ __qualname__ run_deletes __backend__ __requires____engine_options__ classmethodr& r6 r? rI r dbapi_lastrowidrM r' r% r r s KKEL.6
[
"I I IC C C
* * * ! "! r' r c e Zd ZdZdZed Zd Zej d Z
ej d Z ej
d Zej
d Zej
d Zej
d
Zd S ) InsertBehaviorTestr Tc 8 t d|t dt dd t dt d t d|t dt dd t dt d t d
|t dt dd t dt d t d t d
t dt t dt t d z
d S )Nr r Tr r r r Fr includes_defaultsx )defaulty2)type_r )r r r r r
r r" s r% r& z InsertBehaviorTest.define_tablesM s$
g4$
66":: & &
4d% H H H 66":: & &
g4$
66":: & & 3 + + + &s':::WQZZG
r' c v t j j rt j ddi }n t
j }| 5 }| | j j
d }d d d n # 1 swxY w Y |j sJ |j
rJ |j sJ |j rJ d S )Nr F)optionsr* r: )r returningenabledr testing_enginer r. beginr, r< r r= _soft_closedclosed is_insert returns_rows)r2 enginer4 rG s r% test_autoclose_on_insertz+InsertBehaviorTest.test_autoclose_on_insertl s ! ) +-u5 FF YF
\\^^ Pt T[ 3 : : < <; OOA P P P P P P P P P P P P P P P~ ~8|{{>!!!!!s
4B
BBc t j | j j d }|j sJ |j rJ |j sJ |j rJ d S r9 )
r r. r, r< r r= rh ri rj rk r2 rG s r% +test_autoclose_on_insert_implicit_returningz>InsertBehaviorTest.test_autoclose_on_insert_implicit_returning{ sq I K " ) ) + ++
~ ~8|{{>!!!!!r' c t j | j j }|j sJ |j rJ t j | j j | j j j
j d k }t |
sJ d S )N)r r. r, r< r r= rh ri r whererD r lenfetchallro s r% test_empty_insertz$InsertBehaviorTest.test_empty_insert s I dk 4 ; ; = = > >~ ~8| I K " ) ) + + 1 1 &(+t3
1::<< r' c 4 | j j }| j j }t j | t dd t dd t dd g t j | dt |j
j g |j
j
ddg }t |j d g t j t |j
j g |j
j }t | d d
g d S ) N data1r r r data2r
data3r: rz r{ )r< r r r r. r, r= dict from_selectr rD r rr in_r rE order_byrt r2 src_table
dest_tableresults r% test_insert_from_select_autoincz2InsertBehaviorTest.test_insert_from_select_autoinc sh K) [+
(((((((((
"" + + ()**00 K$(('7);<<
F '$000"" JL%& ' ' 0 0 1B C C
FOO
J 788888r' c l | j j }| j j }t j | dt |j j
g |j j
ddg }t |j d g t j t |j j
g |j j
}t | g d S )Nr: rz r{ )r< r r r r. r, r= r r rD r rr r r rE r rt r s r% 'test_insert_from_select_autoinc_no_rowsz:InsertBehaviorTest.test_insert_from_select_autoinc_no_rows s K) [+
"" + + ()**00 K$(('7);<<
F '$000"" JL%& ' ' 0 0 1B C C
FOO r"""""r' c | j j }t j | t
dd t
dd t
dd g t j | d dt |j j
d
z |j j g |j j
ddg t t j t |j j g |j j g d d S ) Nrw rx ry r rz r
r{ Tinliner] ))rx r| r| r} r} )r< r r r. r, r= r~ r r rD r r rr r r r rt r2 r3 s r% test_insert_from_selectz*InsertBehaviorTest.test_insert_from_select sT % LLNN(((((((((
LLL % % 1 1
Q 566<<GL$$gw%788
I ~&&// ==
hjj H H H
r' c | j j }t j | t
dd t
dd t
dd g t j | d dt |j j
d
z |j j g |j j
ddg t t j t |g |j j |j j
g d d S ) Nrw rx ry r rz r
r{ Tr r] ))rw rx r] )r rz r] r ) rz r] r )r
r{ r] r ) r{ r] r )r< r[ r r. r, r= r~ r r rD r r rr r r r rt r s r% %test_insert_from_select_with_defaultsz8InsertBehaviorTest.test_insert_from_select_with_defaults sZ - LLNN(((((((((
LLL % % 1 1
Q 566<<GL$$gw%788
I w(( uwzBB
hjj
r' N)rN rO rP rQ rR rU r& rm r rd rp
empty_insertsru insert_from_selectr r r r rW r' r% rY rY I s KK
[
<
"
"
" " " " ! ! ! $9 9 %$98 $# # %$#( $
%$
6 $
%$
r' rY c p e Zd ZdZdZdZddiZd Zed Z e
j d Z d Z
d Zd
Zd S )
ReturningTestr )rd r Tr c | | }t |t j j j df d S r) r+ r1 s r% r6 z ReturningTest._assert_round_trip r7 r' c t d|t dt dd t dt d d S )Nr r Tr r r r! r" s r% r& zReturningTest.define_tables sT
g4$
66":: & &
r' c t j }| j j }| 5 }| | |j j d }d d d n # 1 swxY w Y |
d }t j t |j j g }t || d S Nr* r: r r. r< r rg r, r= rd rD r r- rC r r r2 rl r3 r4 rG rH
fetched_pks r% %test_explicit_returning_pk_autocommitz3ReturningTest.test_explicit_returning_pk_autocommit s &
\\^^ t ((44; A WWYYq\Y%%fegj\&:&:;;
Js AB BBc t j }| j j }| 5 }| | |j j d }|
d }d d d n # 1 swxY w Y t j t |j j g }t || d S r r r s r% (test_explicit_returning_pk_no_autocommitz6ReturningTest.test_explicit_returning_pk_no_autocommit& s &
\\^^ t ((44; A 1 B
Y%%fegj\&:&:;;
Js A!BB !B c t j | j j d | | j j t j d S r9 r; r> s r% /test_autoincrement_on_insert_implicit_returningz=ReturningTest.test_autoincrement_on_insert_implicit_returning1 r@ r' c . t j | j j d }t j t | j j j j g }t |j |g d S r9 rB rF s r% (test_last_inserted_id_implicit_returningz6ReturningTest.test_last_inserted_id_implicit_returning6 rJ r' N)rN rO rP run_create_tablesrS rR rT r6 rU r& r fetch_rows_post_commitr r r r rW r' r% r r s 6LK.5I I I
[
( )( C C C
* * * * *r' r )r rY r N) r r r
assertionsr r schemar r r r r
r r
TablesTestr rY r __all__rW r' r% r s{ ! ! ! ! ! ! 7 7 7 7 7H' 7 7 7tx
x
x
x
x
, x
x
x
v8* 8* 8* 8* 8*H' 8* 8* 8*v Cr'