id<ddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z dd lmZdd lm Z dd lm Z dd lm Z GddejZGdde jejZGddejZdS))config)fixtures)eq_) requirements)Column)Table)Integer)MetaDataschema)Sequence)String)testingceZdZdZdZdZedZdZdZ dZ e j dZ d Zd Zejd d d ejjdZejjdZdS) SequenceTest sequencesTeachc td|tdttddtdt dtd|tdttdd dtdt dtd |tdttd dtdt dd t jjjrktd|tdttdtj dtdt dd tj dSdS)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 ) rrr rrrrequiresschemasenabledr test_schema)clsmetadatas [/opt/cloudlinux/venv/lib/python3.11/site-packages/sqlalchemy/testing/suite/test_sequence.py define_tableszSequenceTest.define_tabless   4(<"8"8d K K K 66":: & &        555     66":: & &     ((     66":: & &$    # +  &/8JKKK $  vvbzz**#()        ctj|jjd||jjtjdSN some datar)rdbexecutetablesrinsert_assert_round_tripselfs r,test_insert_roundtripz"SequenceTest.test_insert_roundtripFsQ $+,3355KHHH  2FI>>>>>r.ctj|jjd}t |jdgdSNr1r2)rr3r4r5rr6rinserted_primary_keyr9rs r,test_insert_lastrowidz"SequenceTest.test_insert_lastrowidJsH I  dk07799  L L A "QC(((((r.ctj|jjjjj}t|ddS)Nr=) rr3r4r5rcrdefaultrr?s r,test_nextval_directz SequenceTest.test_nextval_directNs6 I  dk025= > > Aq r.ctj|jjd}t |jdgdSr<)rr3r4r5rr6rr>r?s r,test_optional_seqzSequenceTest.test_optional_seqRsQ I   K " ) ) + ++    A "QC(((((r.c||}t|ddS)N)r=r1)r4selectfirstr)r9tableconnrows r,r7zSequenceTest._assert_round_tripYs>ll5<<>>**0022 C!"""""r.c||jjt d||jj|dSr0)r4r5r r6dictr7)r9 connections r,+test_insert_roundtrip_no_implicit_returningz8SequenceTest.test_insert_roundtrip_no_implicit_returning]s^ K ( / / 1 14[3I3I3I     >LK>, 99999r.rceZdZdZdZdZdS)SequenceCompilerTestrTc tdttdtt dtdt}|d}tjj dtjj  t d}| |d|d d tjj dS) Nxyy_seqq)rn) statementrZzINSERT INTO x (y, q) VALUES (z, 5)T) literal_bindsrZ) rr rr rr6valuesrr3rZstatement_compilervisit_sequenceassert_compile)r9rKstmt seq_nextvals r,!test_literal_binds_inline_compilez6SequenceCompilerTest.test_literal_binds_inline_compiles  JJ 3'!2!2 3 3 3   ||~~$$q$))j(;;GJ$6<  .'** + +   D5@[[ BJ&      r.N)r^r_r`rarbrxrgr.r,riris-!LK     r.riceZdZdZdZdZejjdZ dZ ejjdZ ejjdZ ejjdZ d S) HasSequenceTestrTctd}tjt j| t tjjtjddtjt j |dS#tjt j |wxYw)N user_id_seqT) rrr3r4r CreateSequencerrZ has_sequence DropSequencer9s1s r,test_has_sequencez!HasSequenceTest.test_has_sequences m $ $ 6044555 8  "// MJJ    J  v2266 7 7 7 7 7GJ  v2266 7 7 7 7s =B223C%ctdtj}tjt j| ttjj tjdtjdtjt j |dS#tjt j |wxYw)Nr|r T rrr)rr3r4r r}rrZr~rrs r,test_has_sequence_schemaz(HasSequenceTest.test_has_sequence_schemas mF,> ? ? ? 6044555 8  "//J f6H0     J  v2266 7 7 7 7 7GJ  v2266 7 7 7 7s A C 3C=cttjjtjdddS)Nr|F)rrr3rZr~r8s r,test_has_sequence_negz%HasSequenceTest.test_has_sequence_negs/ GJ  + +GJ F FNNNNNr.cttjjtjdt jddSNr|r F)rrr3rZr~rr)r8s r,test_has_sequence_schemas_negz-HasSequenceTest.test_has_sequence_schemas_negsL J  + + M&2D ,         r.ctd}tjt j| t tjjtjdtj dtjt j |dS#tjt j |wxYwr) rrr3r4r r}rrZr~rr)rrs r,'test_has_sequence_default_not_in_remotez7HasSequenceTest.test_has_sequence_default_not_in_remotes m $ $ 6044555 8  "//J f6H0     J  v2266 7 7 7 7 7GJ  v2266 7 7 7 7s A B>>3C1ctdtj}tjt j| ttjj tjddtjt j |dS#tjt j |wxYwrrrs r,'test_has_sequence_remote_not_in_defaultz7HasSequenceTest.test_has_sequence_remote_not_in_defaults mF,> ? ? ? 6044555 8  "// MJJ    J  v2266 7 7 7 7 7GJ  v2266 7 7 7 7s =B>>3C1N)r^r_r`rarbrrr&r'rrrrrrgr.r,rzrzs!LK 8 8 8  8 8 8OOO      8 8 8  8 8 8 8 8r.rzN)rr assertionsrrr rrr r rrr TablesTestrAssertsCompiledSQLTestBaserirzrgr.r,rs!!!!!!t9t9t9t9t98&t9t9t9n     75x7H   2A8A8A8A8A8h'A8A8A8A8A8r.