,h><SSKJr SSKrSSKrSSKrSSKrSSKrSSKJ r SSK J r SSK J r SSK Jr SS K Jr SS KJr SS KJr S S K Jr S SK Jr S SKJr S SKJr S SKJr "SS\ 5r"SS5r"SS5r"SS\5r"SS5rSSjrg)) annotationsN)TestBase)config)mock)eq_)ne_)adict)drop_all_tables_from_metadata)event)util)sort_tables_and_constraints)visitors) ClauseElementcj\rSrSrSrSrSrSrSrSr Sr Sr Sr Sr Sr\R "SSS9S5r\R "SS S9S 5r\S 5r\S 5r\S 5r\S5rSrSrSr\S5r\S5r\S5r\S5r\S5r \S5r!Sr"Sr#\S5r$Sr%g) TablesTestonceeachNTclassautousescopec## URnUR5 UR5 UR5 Sv UR 5 g7fN) __class__ _init_class_setup_once_tables_setup_once_inserts_teardown_once_metadata_bind)selfclss W/var/www/auris/envauris/lib/python3.13/site-packages/sqlalchemy/testing/fixtures/sql.py_setup_tables_test_class#TablesTest._setup_tables_test_class7s?nn    !  ((*sAAfunctionc#t# UR5 UR5 Sv UR5 g7fr)_setup_each_tables_setup_each_inserts_teardown_each_tablesr#s r%_setup_tables_test_instance&TablesTest._setup_tables_test_instanceDs, !   "  ""$s68cUR$r)_tables_metadatar-s r%tables_test_metadataTablesTest.tables_test_metadataMs$$$c.URS:Xa)URS:XaSUlURS;de[5Ul[5Ul[5UlUR5Ul[R"5Ul g)Nrr)rN) run_define_tablesrun_create_tables run_insertsr othertables sequences setup_bindbindsaMetaDatar1r$s r%rTablesTest._init_classQso  F *$$.(.%??n4 44G W  >>#!{{}r4cURS:XaEUR5 URR5nUR U5 SSS5 gg!,(df  g=fNrr8_load_fixturesr=begin insert_data)r$conns r%r!TablesTest._setup_once_inserts_sJ ??f $    !T%"! %!! A A%cURS:XaURUR5 URS:Xa%URR UR 5 UR RURR 5 URRURR5 ggrC r6 define_tablesr1r7 create_allr=r:updater; _sequencesr@s r%r TablesTest._setup_once_tablesfs  F *   c22 3$$.$$//9 JJ  c2299 : MM !5!5!@!@ A +r4cURS:XaURUR5 URS:Xa%URR UR 5 UR RURR 5 URRURR5 gURS:Xa&URR UR 5 ggNrrLr-s r%r*TablesTest._setup_each_tablesos  ! !V +   t44 5%%/%%00; KK  t44;; < NN ! !$"7"7"B"B C  # #v -  ! ! , ,TYY 7.r4cURS:XaEUR5 URR5nUR U5 SSS5 gg!,(df  g=frSrD)r#rHs r%r+TablesTest._setup_each_insertsysN   v %    !"d  &#" &""rJc URS:XaeURR5 URS:Xa [ UR UR 5 UR R5 O0URS:Xa [ UR UR 5 [[RSS5nU(a URnURS:waURS:waURS:XaUR R5n[[UR RR55VVs/sH up4UcM UPM snn5HdnU(a:UR!5 UR#UR%55 SSS5 MEUR#UR%55 Mf SSS5 ggggs snnf!,(df  M=f![&R(R*a+n[-SU<SU<3[.R0S9 SnAMSnAff=f!,(df  g=f)Nr savepointsFzError emptying table z: )file)r6r:clearr7r r1r=getattrr requirementsenabled run_deletesrFreversedrvalues begin_nestedexecutedeleter>exc DBAPIErrorprintsysstderr)r#rXrHtfkstableexs r%r, TablesTest._teardown_each_tabless  ! !V + KK   %%/-d.C.CTYYO  ! ! ' ' )  # #v - )$*?*? KV00,F #++J  " "f ,&&&0  F*"d%)D 1188??A))HQ )E %!%!2!2!4 $ U\\^ <"5!4!LL8#"+1 - "5!466,,>CRH!$!#"s~6I G# !G# ' I3G; G)*G;2I4G;I#I) G8 3G;6I8G;;I H?9I?II IcUR(a [URUR5 URS:XaUR UR5 SURlUR bSUlggrC)r7r r1r=run_dispose_bind dispose_bindrun_setup_bindr@s r%r"'TablesTest._teardown_once_metadata_bindse  )#*>*> I   6 )   SXX &$(!    )CH *r4c"[R$r)rdbr@s r%r<TablesTest.setup_binds yyr4c[US5(aUR5 g[US5(aUR5 gg)Ndisposeclose)hasattrrwrx)r$r=s r%rpTablesTest.dispose_binds3 4 # # LLN T7 # # JJL$r4cgr)r$metadatas r%rMTablesTest.define_tables r4c0$rr|r@s r%fixturesTablesTest.fixturess r4cgrr|)r$ connections r%rGTablesTest.insert_datarr4c<URURX!5 gr)assert_sql_countr=)r#countfns r% sql_count_TablesTest.sql_count_s dii3r4c<URURX5 gr) assert_sqlr=)r# callable_ statementss r%sql_eq_TablesTest.sql_eq_s  99r4cf00p!UR5R5HHup4[U5S:aM[U[5(aUR UnUSX'USSX#'MJ [ URR R55H|up5UcM X1;aMURR5nURUR5X#Vs/sHn[[XU55PM sn5 SSS5 M~ gs snf!,(df  M=f)z4Insert rows as represented by the fixtures() method.rrrN)ritemslen isinstancestrr:rr1r`r=rFrbinsertdictzip)r$headersrowsrkdatarjrH column_valuess r%rETablesTest._load_fixturess B<<>//1KE4y1}%%% 5)!!WGNqr(DK 26  ' ' . . 0 JE}#!T LLN.2[-8MS?@-8"! "!s!D!'!DD!D!! D0 r|)&__name__ __module__ __qualname____firstlineno__rqr6r7r8r^ror=r1r:r9r;rfixturer&r.propertyr2 classmethodrr!r r*r+r,r"r<rprMrrGrrrE__static_attributes__r|r4r%rrs{NKK D F EI ^^D0 +1 + ^^D 3%4%%% - -&& BB8' 'R       4:r4rcB\rSrSr\R "SSS9S5rSrg)NoCacheTr(rc## [RRnS[RlSv U[Rlg7fr)rrt_compiled_cache)r#_caches r%_disable_cacheNoCache._disable_caches/**$( ! $* !sA A r|N)rrrrrrrrr|r4r%rrs ^^D 3+4+r4rcl\rSrSr\R S5rSr\R"SSS9S5r Sr g ) RemovesEventsc[5$r)setr-s r% _event_fnsRemovesEvents._event_fnss u r4c nURRXU45 [R"XU40UD6 gr)raddrlisten)r#targetnamerkws r% event_listenRemovesEvents.event_listens, V2./ V2,,r4Tr(rc#`# Sv URHn[R"U6 M g7fr)rrremove)r#keys r%_remove_eventsRemovesEvents._remove_eventss" ??C LL# #s,.r|N) rrrrrmemoized_propertyrrrrrrr|r4r%rrs> - ^^D 34r4rc^\rSrSrS=rrSrSr\R"S5r Sr \ S5r Srg) ComputedReflectionFixtureTestiNT)computed_columnstable_reflectionz[\[\]\(\)\s`'\"]*cVURRSU5R5$)N)regexpsublower)r#texts r% normalize'ComputedReflectionFixtureTest.normalizes {{r4(..00r4c SSKJn SSKJn SSKJn SSKJn SSKJn U"SUU"SUS S 9U"S U5U"S X%"S 55U"SUSS95 U"SUU"SUS S 9U"S U5U"SX%"S 555nURRR(a3U"SUU"SUS S 9U"S U5U"SX%"S55[RS9nURRR(aaURU"SUU"SSS955 URRR(aWRU"SUU"SSS955 URRR(acURU"SUU"SS S955 URRR(aWRU"SUU"SS S955 ggg)Nr )Integer)testing)Column)Computed)Tablecomputed_default_tableidT) primary_keynormal computed_colz normal + 42 with_default42)server_defaultcomputed_column_tablecomputed_no_flagz normal / 42)schemacomputed_virtualz normal + 2F) persistedz normal / 2computed_storedz normal - 42z normal * 42)rrrrrrrrequiresschemasr]r test_schemacomputed_columns_virtual append_columncomputed_columns_stored) r$r}rrrrrrit2s r%rM+ComputedReflectionFixtureTest.define_tabless$&# $  4d 3 8W % >7H],C D >74 @    #  4d 3 8W % %w0G H      # # + +'tW$7x))7H]4KL)) B    4 4 < < OO&\U; ''//  * ?    3 3 ; ; OO%]d; ''//  ) $?0 >%%i00 00= =|  599 % UYYeii 1$'(8(8%:J:J$K wNNNN%L|r4c bU"5nU"5n[R"[[U55S5GHsupVXV:Xa UR X5XFU5upxUcM)GOX5R 5nXFR 5nUbUcPUc$X5R RS5(deUc$XFR RS5(deMURUR:Xa`[URUR5HupU RXS9(aM OC [URUR5 O [URUR5 [X5[5(dGMY[XF[5(dGMs/n /n [R "X55H&n U R"S:XdMU R%U 5 M( [R "XF5H&n U R"S:XdMU R%U 5 M( ['[)URSS9[)[*R,"U 5SS95 ['[)URSS9[)[*R,"U 5S S95 GMv g) Nrrr bindparamcUR$rrrs r%8CacheKeyFixture._run_cache_key_fixture..155r4rcUR$rrrs r%r r r4cUR$rrrs r%r r r r4cUR$rrrs r%r r r r4) itertoolscombinations_with_replacementrangerrrrrrrrrr rrriterate__visit_name__appendr sortedr unique_list)r#rrcase_acase_brrrrrrassert_a_paramsassert_b_paramselems r%_run_cache_key_fixture&CacheKeyFixture._run_cache_key_fixturehsT;; #f+  DAv#22Ivy.  =! 557 557=EM}%y5599)DDDD}%y5599)DDDD99 ),/((%*:*:-( '# /  " -EIIuyy1 599- &)]33  =99#%"$$,,VY7D**k9'..t48%,,VY7D**k9'..t485++A((9 5++A((9A r4cU"5nU"5n[R"[[U55S5HupVUR X5XFU5 M g)Nr)rrrrr)r#rrrrrrs r%_run_cache_key_equal_fixture,CacheKeyFixture._run_cache_key_equal_fixturesM;; #f+  DA    69n E r4r|N)rrrrrrr rr|r4r%rrWs IVFr4rc^^^^^^URnURmURm"SS5mUUUU4SjmUU4SjnX@lg)Nc4\rSrSrSrSr\S5rSrSr g).insertmanyvalues_fixture..RandomCursoricursorcXlgrr%)r#r&s r%__init__7insertmanyvalues_fixture..RandomCursor.__init__s Kr4c.URR$r)r& descriptionr-s r%r+:insertmanyvalues_fixture..RandomCursor.descriptions;;** *r4c|URR5n[U5n[R"U5 U$r)r&fetchalllistrandomshuffle)r#rs r%r.7insertmanyvalues_fixture..RandomCursor.fetchalls.;;'')D:D NN4 Kr4N) rrrr __slots__r(rr+r.rr|r4r% RandomCursorr$s%  !  +  + r4r4c3># T (aT"U5nT"UUUUUU5H5nT (a'UR(a[R"S5 Uv M7 g7f)Nz)Batches were downgraded for sorted INSERT) is_downgradedrwarn) rr& statement parametersgeneric_setinputsizescontextbatchr4 orig_dialectrandomize_rowswarn_on_downgradeds r%!_deliver_insertmanyvalues_batchesCinsertmanyvalues_fixture.._deliver_insertmanyvalues_batchessU !&)F!     !   E"e&9&9 EFK sAAc>[RRUSTS9 T"X5sSSS5 $!,(df  g=f)Nr@)new)rpatchobject)dialectr;r@ orig_conns r%_exec_insertmany_context:insertmanyvalues_fixture.._exec_insertmany_contexts= ZZ    /1 W.    s 3 A)rFr@rH) rr>r?rFrHr4r@rGr=s `` @@@@r%insertmanyvalues_fixturerJsH  G<baserrrr assertionsr r rr r rrrsqlr sql.elementsrrrrrrrJr|r4r%rQs# 01)MM`++   MJM`cFcFN:?:Cr4