e>V@ d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ ddl m Z dd l m
Z
dd
l mZ dd l m Z dd l m Z dd
l m
Z
G d dej Z G d de
j ej Z G d dej ZdS ) )config)fixtures)eq_) requirements)Column)Table )Integer)MetaDataschema)Sequence)String)testingc e Zd ZdZdZdZed Zd Zd Z d Z
e j d Z
d Zd
Z ej d d d
ej j d Zej j d ZdS ) SequenceTest sequencesTeachc t d|t dt t d d t dt d t d|t dt t dd d t dt d t d
|t dt t d d t dt d d
t
j j j rkt d|t dt t dt j
d t dt d d t j
d S d S )Nseq_pkid
tab_id_seqT primary_keydata2
seq_opt_pk)optionalseq_no_returning noret_id_seqF)implicit_returningseq_no_returning_schnoret_sch_id_seqr r" r
) r r r
r r r requiresschemasenabledr test_schema)clsmetadatas z/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/testing/suite/test_sequence.py
define_tableszSequenceTest.define_tables s
4(<"8"8d K K K 66":: & &
555
66":: & &
((
66":: & & $
# +
& /8JKKK $ vvbzz**#( )
c t j | j j d | | j j t j d S N some datar )r dbexecutetablesr insert_assert_round_tripselfs r, test_insert_roundtripz"SequenceTest.test_insert_roundtripF sQ $+,3355KHHH 2FI>>>>>r. c t j | j j d }t
|j dg d S Nr1 r2 )r r3 r4 r5 r r6 r inserted_primary_keyr9 rs r, test_insert_lastrowidz"SequenceTest.test_insert_lastrowidJ sH I dk 0 7 7 9 9 L L A "QC(((((r. c t j | j j j j j }t |d d S )Nr= ) r r3 r4 r5 r cr defaultr r? s r, test_nextval_directz SequenceTest.test_nextval_directN s6 I dk 0 2 5 = > > Aq r. c t j | j j d }t
|j dg d S r< )r r3 r4 r5 r r6 r r> r? s r, test_optional_seqz SequenceTest.test_optional_seqR sQ I K " ) ) + ++
A "QC(((((r. c | | }t |d d S )N)r= r1 )r4 selectfirstr )r9 tableconnrows r, r7 z SequenceTest._assert_round_tripY s> ll5<<>>**0022 C!"""""r. c | | j j t d | | j j | d S r0 )r4 r5 r r6 dictr7 )r9
connections r, +test_insert_roundtrip_no_implicit_returningz8SequenceTest.test_insert_roundtrip_no_implicit_returning] s^ K ( / / 1 14[3I3I3I
> LK>,
9 9 9 9 9r. r c e Zd ZdZdZd ZdS )SequenceCompilerTestr Tc t dt t dt t d t dt }| d }t j j
d t j j t d }| |d|d d
t j j d S ) Nxyy_seqq )rn ) statementrZ z INSERT INTO x (y, q) VALUES (z, 5)T)
literal_bindsrZ )
r r r r
r r6 valuesr r3 rZ statement_compilervisit_sequenceassert_compile)r9 rK stmt seq_nextvals r, !test_literal_binds_inline_compilez6SequenceCompilerTest.test_literal_binds_inline_compile s JJ 3'!2!2 3 3 3
||~~$$q$)) j(;;GJ$6 <
.'**
+
+
D5@[[ B J&
r. N)r^ r_ r` ra rb rx rg r. r, ri ri s- !LK
r. ri c e Zd ZdZdZd Zej j d Z d Z
ej j d Z ej j d Z ej j d Z
d S )
HasSequenceTestr Tc t d }t j t j | t
t j j t j d d t j t j | d S # t j t j | w xY w)N user_id_seqT)
r r r3 r4 r
CreateSequencer rZ has_sequence DropSequencer9 s1s r, test_has_sequencez!HasSequenceTest.test_has_sequence s
m
$
$
6044555 8
"//
MJJ
J v 22 6 6 7 7 7 7 7GJ v 22 6 6 7 7 7 7s =B2 23C%c t dt j }t j t
j | t t j j
t j dt j d t j t
j | d S # t j t
j | w xY w)Nr| r T r r r) r r3 r4 r
r} r rZ r~ r r s r, test_has_sequence_schemaz(HasSequenceTest.test_has_sequence_schema s
mF,>
?
?
?
6044555 8
"//J
f6H 0
J v 22 6 6 7 7 7 7 7GJ v 22 6 6 7 7 7 7s
A C
3C=c t t j j t j d d d S )Nr| F)r r r3 rZ r~ r8 s r, test_has_sequence_negz%HasSequenceTest.test_has_sequence_neg s/ GJ + +GJ
F FNNNNNr. c t t j j t j dt
j d d S Nr| r F)r r r3 rZ r~ r r) r8 s r, test_has_sequence_schemas_negz-HasSequenceTest.test_has_sequence_schemas_neg sL J + +
M&2D
,
r. c t d }t j t j | t
t j j t j dt j
d t j t j | d S # t j t j | w xY wr ) r r r3 r4 r
r} r rZ r~ r r) r r s r, 'test_has_sequence_default_not_in_remotez7HasSequenceTest.test_has_sequence_default_not_in_remote s
m
$
$
6044555 8
"//J
f6H 0
J v 22 6 6 7 7 7 7 7GJ v 22 6 6 7 7 7 7s
A B> >3C1c t dt j }t j t
j | t t j j
t j d d t j t
j | d S # t j t
j | w xY wr r r s r, 'test_has_sequence_remote_not_in_defaultz7HasSequenceTest.test_has_sequence_remote_not_in_default s
mF,>
?
?
?
6044555 8
"//
MJJ
J v 22 6 6 7 7 7 7 7GJ v 22 6 6 7 7 7 7s =B> >3C1N)r^ r_ r` ra rb r r r& r' r r r r r rg r. r, rz rz s !LK 8 8 8
8 8 8O O O
8 8 8
8 8 8 8 8r. rz N) r r
assertionsr r r
r r r
r r r r
TablesTestr AssertsCompiledSQLTestBaseri rz rg r. r, r s ! ! ! ! ! ! t9 t9 t9 t9 t98& t9 t9 t9n
75x7H
2A8 A8 A8 A8 A8h' A8 A8 A8 A8 A8r.