§ <«گe؟2مَê—ddlZddlZddlZddlmZmZddlmZm Z ddl mZGd„dej¦«Z Gd„dej¦«ZGd „d ej¦«Zedkrej¦«dSdS)éN)عTESTFNعunlink)عmemory_databaseعcx_limit)عwith_tracebackscَ>—eZdZd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d S) عCollationTestscَآ—tjd¦«}| t¦«5| dd„¦«ddd¦«dS#1swxYwYdS)Nْ:memory:cَ—||k||kz S©N©©عxعys ْ3/usr/lib/python3.11/test/test_sqlite3/test_hooks.pyْzACollationTests.test_create_collation_not_string..%َ€°Q¸²U¸qہ1؛uر4E€َ)عsqliteعconnectعassertRaisesع TypeErrorعcreate_collation©عselfعcons rع test_create_collation_not_stringz/CollationTests.test_create_collation_not_string"s·€فŒnکZر(ش(ˆط × ز ‌yر )ش )ً Gً Gط× ز ذ'Eذ'EرFشFذFً Gً Gً Gٌ Gô Gً Gً Gً Gً Gً Gً Gً Gًّّّ Gً Gً Gً Gً Gً Gs¯AءAءAcَ—tjd¦«}| t¦«5}| dd¦«ddd¦«n#1swxYwY| t |j¦«d¦«dS)NrعXé*zparameter must be callable)rrrrrعassertEqualعstrع exception©rrعcms rع"test_create_collation_not_callablez1CollationTests.test_create_collation_not_callable's´€فŒnکZر(ش(ˆط × ز ‌yر )ش )ً *¨Rط× ز bر)ش)ذ)ً *ً *ً *ٌ *ô *ً *ً *ً *ً *ً *ً *ًّّّ *ً *ً *ً *à×ز‌کRœ\ر*ش*ذ,HرIشIذIذIذIs¯AءAءAcَ\—tjd¦«}| dd„¦«dS)Nrucollأ¤cَ—||k||kz Sr rrs rrz@CollationTests.test_create_collation_not_ascii../rr)rrrrs rعtest_create_collation_not_asciiz.CollationTests.test_create_collation_not_ascii-s1€فŒnکZر(ش(ˆط×زکXذ'Eذ'EرFشFذFذFذFrcَn—Gd„dt¦«}tjd¦«}d„}| |d¦«|¦«| d¦« ¦«}| |ddd¦«| |d dd ¦«dS)Ncَ—eZdZd„ZdS)ْCCollationTests.test_create_collation_bad_upper..BadUpperStrcَ—dSr r©rs rعupperzICollationTests.test_create_collation_bad_upper..BadUpperStr.upper3s€طگtrN)ع__name__ع __module__ع__qualname__r0rrrعBadUpperStrr-2s#€€€€€ً ً ً ً ً rr4rcَ—||k||kz Sr rrs rrz@CollationTests.test_create_collation_bad_upper..6s€ Q¢¨1¨qھ5ر 1ذ2€rعmycollz› select x from ( select 'a' as x union select 'b' as x ) order by x collate mycoll rعbéعa)r#rrrعexecuteعfetchallr")rr4rr6عresults rعtest_create_collation_bad_upperz.CollationTests.test_create_collation_bad_upper1sد€ً ً ً ً ً ‌#ٌ ô ً ُŒnکZر(ش(ˆط2ذ2ˆط×زک[ک[¨ر2ش2°Fر;ش;ذ;ط—’ًٌô÷’‘”ً ً ×زک œ 1œ sر+ش+ذ+ط×زک œ 1œ sر+ش+ذ+ذ+ذ+rcَ—d„}tjd¦«}| d|¦«d}| |¦« ¦«}| |gd¢d¬¦«| dd¦«| tj¦«5}| |¦« ¦«}ddd¦«n#1swxYwY| t|j ¦«d¦«dS) Ncَ—||k||kz Sr rrs rr6z5CollationTests.test_collation_is_used..mycollCs€àک!’e A¢ر&ذ'ذ'rrr6ْة select x from ( select 'a' as x union select 'b' as x union select 'c' as x ) order by x collate mycoll ©)عc)r7)r9ْ#the expected order was not returned©عmsgْ"no such collation sequence: mycoll) rrrr:r;r"rعOperationalErrorr#r$)rr6rعsqlr<r&s rعtest_collation_is_usedz%CollationTests.test_collation_is_usedBsQ€ً (ً (ً (ُŒnکZر(ش(ˆط×زکX vر.ش.ذ.ًˆً—’کSر!ش!×*ز*ر,ش,ˆط×زکذ!9ذ!9ذ!9طBً ٌ Dô Dً Dً ×زکX tر,ش,ذ,ط × ز ‌vش6ر 7ش 7ً 1¸2ط—[’[ ر%ش%×.ز.ر0ش0ˆFً 1ً 1ً 1ٌ 1ô 1ً 1ً 1ً 1ً 1ً 1ً 1ًّّّ 1ً 1ً 1ً 1à×ز‌کRœ\ر*ش*ذ,PرQشQذQذQذQsآ&(CأCأ!Ccَو—d„}tjd¦«}| d|¦«d}| |¦« ¦«}| |gd¢d¬¦«dS)Ncَ$—||k||kz dzS)Nlrrs rr6zCCollationTests.test_collation_returns_large_integer..mycoll\s€àک!’e A¢ر&ذ'¨%ر/ذ/rrr6r@rArCrD©rrrr:r;r")rr6rrHr<s rع$test_collation_returns_large_integerz3CollationTests.test_collation_returns_large_integer[sک€ً 0ً 0ً 0ُŒnکZر(ش(ˆط×زکX vر.ش.ذ.ًˆً—’کSر!ش!×*ز*ر,ش,ˆط×زکذ!9ذ!9ذ!9طBً ٌ Dô Dً Dً Dً Drcَ`—tjd¦«}| dd„¦«| dd„¦«| d¦« ¦«}| |ddd¦«| |ddd ¦«d S)z„ Register two different collation functions under the same name. Verify that the last one is actually used. rr6cَ—||k||kz Sr rrs rrz>CollationTests.test_collation_register_twice..trrcَ—||k||kz Sr rrs rrz>CollationTests.test_collation_register_twice..us€°q¸1²uہہQآر6Gذ4H€rzi select x from (select 'a' as x union select 'b' as x) order by x collate mycoll rr7r8r9NrL)rrr<s rعtest_collation_register_twicez,CollationTests.test_collation_register_twicens¯€ُ ŒnکZر(ش(ˆط×زکXذ'Eذ'EرFشFذFط×زکXذ'Hذ'HرIشIذIط—’ًٌôç’‘”ً ً ×زک œ 1œ sر+ش+ذ+ط×زک œ 1œ sر+ش+ذ+ذ+ذ+rcَp—tjd¦«}| dd„¦«| dd¦«| tj¦«5}| d¦«ddd¦«n#1swxYwY| t|j¦«d¦«dS)zu Register a collation, then deregister it. Make sure an error is raised if we try to use it. rr6cَ—||k||kz Sr rrs rrz:CollationTests.test_deregister_collation..‚rrNz?select 'a' as x union select 'b' as x order by x collate mycollrF) rrrrrGr:r"r#r$r%s rعtest_deregister_collationz(CollationTests.test_deregister_collation|sِ€ُ ŒnکZر(ش(ˆط×زکXذ'Eذ'EرFشFذFط×زکX tر,ش,ذ,ط × ز ‌vش6ر 7ش 7ً [¸2طڈKٹKذYرZشZذZً [ً [ً [ٌ [ô [ً [ً [ً [ً [ً [ً [ًّّّ [ً [ً [ً [à×ز‌کRœ\ر*ش*ذ,PرQشQذQذQذQsء!BآBآ BN)r1r2r3rr'r*r=rIrMrQrTrrrr r !s €€€€€ًGًGًGً JًJًJًGًGًGً,ً,ً,ً"RًRًRً2DًDًDً&,ً,ً,ً Rً Rً Rً Rً Rrr cَ~—eZdZd„Zd„Zd„Zd„Zeed¬¦«d„¦«Z eed¬¦«d„¦«Z d S) ع ProgressTestscَ¾‡—tjd¦«}gٹˆfd„}| |d¦«| d¦«| ‰¦«dS)zK Test that the progress handler is invoked once it is set. rcَ2•—‰ d¦«dS©Nr©عappend©عprogress_callss€rعprogressz:ProgressTests.test_progress_handler_used..progressڈَّ€ط×!ز! $ر'ش'ذ'طگ1rr8z0 create table foo(a, b) N)rrعset_progress_handlerr:ع assertTrue)rrr^r]s @rعtest_progress_handler_usedz(ProgressTests.test_progress_handler_used‰sّ€ُŒnکZر(ش(ˆطˆً ً ً ً ً ً × ز ¨1ر-ش-ذ-طڈٹًٌ ô ً ً ڈٹکر'ش'ذ'ذ'ذ'rcَ~‡—tjd¦«}gٹˆfd„}| |d¦«| ¦«}| d¦«t‰¦«}gٹ| |d¦«| d¦«t‰¦«}| ||¦«dS)z= Test that the opcode argument is respected. rcَ2•—‰ d¦«dSrYrZr\s€rr^z1ProgressTests.test_opcode_count..progress‍r_rr8z1 create table foo (a, b) éz1 create table bar (a, b) N)rrr`عcursorr:عlenعassertGreaterEqual)rrr^عcursعfirst_countعsecond_countr]s @rعtest_opcode_countzProgressTests.test_opcode_countکsâّ€ُŒnکZر(ش(ˆطˆً ً ً ً ً ً × ز ¨1ر-ش-ذ-طڈzٹz‰|Œ|ˆطڈٹًٌ ô ً ُک.ر)ش)ˆطˆط× ز ¨1ر-ش-ذ-طڈٹًٌ ô ً ُک>ر*ش*ˆط×ز ¨\ر:ش:ذ:ذ:ذ:rcَش—tjd¦«}d„}| |d¦«| ¦«}| tj|jd¦«dS)zW Test that returning a non-zero value stops the operation in progress. rcَ—dS)Nr8rrrrr^z5ProgressTests.test_cancel_operation..progress´s€طگ1rr8zcreate table bar (a, b)N)rrr`rfrrGr:)rrr^ris rعtest_cancel_operationz#ProgressTests.test_cancel_operation¯su€ُŒnکZر(ش(ˆً ً ً à× ز ¨1ر-ش-ذ-طڈzٹz‰|Œ|ˆط×زفش#طŒLط%ٌ 'ô 'ً 'ً 'ً 'rcَ‡—tjd¦«}dٹˆfd„}| |d¦«| dd¦«| d¦« ¦«| ‰dd¦«dS)zc Test that setting the progress handler to None clears the previously set handler. rrcَ•—dٹdS©Nr8rr)عactions€rr^z2ProgressTests.test_clear_handler..progressأs ّ€àˆFطگ1rr8Nz&select 1 union select 2 union select 3z progress handler was not cleared)rrr`r:r;r")rrr^rss @rعtest_clear_handlerz ProgressTests.test_clear_handler½s‍ّ€ُŒnکZر(ش(ˆطˆً ً ً ً ً ً × ز ¨1ر-ش-ذ-ط× ز qر)ش)ذ)طڈٹذ<ر=ش=×FزFرHشHذHط×زک ذ$FرGشGذGذGذGrعbad_progress)عnamecَْ—tjd¦«}d„}| |d¦«| tj¦«5| d¦«ddd¦«dS#1swxYwYdS)Nrcَ—ddzdSrrrrrrruzBProgressTests.test_error_in_progress_handler..bad_progressدs€ط گ‰EˆEˆEˆErr8ْ8 create table foo(a, b) ©rrr`rrGr:)rrrus rعtest_error_in_progress_handlerz,ProgressTests.test_error_in_progress_handlerجsج€هŒnکZر(ش(ˆً ً ً à× ز ¨qر1ش1ذ1ط × ز ‌vش6ر 7ش 7ً ً طڈKٹKًٌ ô ً ً ً ً ٌ ô ً ً ً ً ً ً ً ًّّّ ً ً ً ً ً sء A0ء0A4ء7A4cَ‡—tjd¦«}Gd„d¦«ٹˆfd„}| |d¦«| tj¦«5| d¦«ddd¦«dS#1swxYwYdS)Nrcَ—eZdZd„ZdS)ْDProgressTests.test_error_in_progress_handler_result..BadBoolcَ—ddzdSrrrr/s rع__bool__zMProgressTests.test_error_in_progress_handler_result..BadBool.__bool__غs€طگA‘گگگrN)r1r2r3r€rrrعBadBoolr~عs#€€€€€ً ً ً ً ً rrپcَ•—‰¦«Sr r)rپs€rruzIProgressTests.test_error_in_progress_handler_result..bad_progressفsّ€طگ7‘9”9ذrr8ryrz)rrrurپs @rع%test_error_in_progress_handler_resultz3ProgressTests.test_error_in_progress_handler_result×sےّ€هŒnکZر(ش(ˆً ً ً ً ً ٌ ô ً ً ً ً ً ً à× ز ¨qر1ش1ذ1ط × ز ‌vش6ر 7ش 7ً ً طڈKٹKًٌ ô ً ً ً ً ٌ ô ً ً ً ً ً ً ً ًّّّ ً ً ً ً ً sءBآBآBN)r1r2r3rbrlrortrعZeroDivisionErrorr{rƒrrrrVrVˆs«€€€€€ً (ً (ً (ً;ً;ً;ً.'ً'ً'ً Hً Hً Hً€_ذ&¨^ذ<ر<ش<ًًٌ=ش<ًً€_ذ&¨^ذ<ر<ش<ًًٌ=ش<ًًًrrVcَ®—eZdZejd„¦«Zd„Zd„Zd„Zd„Z d„Z eej d¬¦«d „¦«Zeed ¬¦«d„¦«ZdS) عTraceCallbackTestsc#َ‡K— gٹ| ˆfd„¦«dV—| ‰|¦«| d¦«dS#| ‰|¦«| d¦«wxYw)Ncَ.•—‰ |¦«Sr rZ)عstmtعtraceds €rrz5TraceCallbackTests.check_stmt_trace..ësّ€¨v¯}ھ}¸Tر/Bش/B€r)عset_trace_callbackr")rعcxعexpectedrٹs @rعcheck_stmt_tracez#TraceCallbackTests.check_stmt_traceçs›ّèè€ً (طˆFط×!ز!ذ"Bذ"Bذ"Bذ"BرCشCذCطˆEˆEˆEà×زکV Xر.ش.ذ.ط×!ز! $ر'ش'ذ'ذ'ذ'ًّ ×زکV Xر.ش.ذ.ط×!ز! $ر'ش'ذ'ذ'ّّّs…Aء-A=cَ‡—tjd¦«}gٹˆfd„}| |¦«| d¦«| ‰¦«| td„‰D¦«¦«¦«dS)zI Test that the trace callback is invoked once it is set. rcَ2•—‰ |¦«dSr rZ©ع statementعtraced_statementss €rعtracez:TraceCallbackTests.test_trace_callback_used..trace÷َّ€ط×$ز$ Yر/ش/ذ/ذ/ذ/rْcreate table foo(a, b)c3َK—|]}d|vV—Œ dS)zcreate table fooNr)ع.0r‰s rْ z>TraceCallbackTests.test_trace_callback_used..üs(èè€ذUذU¸4ذ.°$ذ6ذUذUذUذUذUذUrN)rrr‹r:raعany©rrr”r“s @rعtest_trace_callback_usedz+TraceCallbackTests.test_trace_callback_usedٌs‌ّ€ُŒnکZر(ش(ˆطذً 0ً 0ً 0ً 0ً 0à×زکuر%ش%ذ%طڈٹذ,ر-ش-ذ-طڈٹذ)ر*ش*ذ*طڈٹ‌ذUذUذCTذUرUشUرUشUرVشVذVذVذVrcَè‡—tjd¦«}gٹˆfd„}| |¦«| d¦«| d¦«| ‰d¦«dS)zb Test that setting the trace callback to None clears the previously set callback. rcَ2•—‰ |¦«dSr rZr‘s €rr”z;TraceCallbackTests.test_clear_trace_callback..tracer•rNr–ztrace callback was not cleared)rrr‹r:عassertFalser›s @rعtest_clear_trace_callbackz,TraceCallbackTests.test_clear_trace_callback‏sŒّ€ُŒnکZر(ش(ˆطذً 0ً 0ً 0ً 0ً 0à×زکuر%ش%ذ%ط×زکtر$ش$ذ$طڈٹذ,ر-ش-ذ-ط×زذ*ذ,LرMشMذMذMذMrcَہ‡‡—dٹtjd¦«}gٹˆfd„}| |¦«| d¦«| d‰z¦«| ¦«| t ˆfd„‰D¦«¦«dt‰¦«›dd tt‰¦«¦«›‌¦«d S)zG Test that the statement can contain unicode literals. uأ¶أ¤أ¼أ–أ„أœأںâ‚¬rcَ2•—‰ |¦«dSr rZr‘s €rr”z6TraceCallbackTests.test_unicode_content..tracer•rْcreate table foo(x)z insert into foo(x) values ('%s')c3َ •K—|]}‰|vV—Œ dSr r)rکr‰ع unicode_values €rr™z:TraceCallbackTests.test_unicode_content..s(ّèè€ذPذP°dکM¨Tذ1ذPذPذPذPذPذPrz Unicode data z garbled in trace callback: z, N) rrr‹r:عcommitrarڑعasciiعjoinعmap)rrr”r“r¥s @@rعtest_unicode_contentz'TraceCallbackTests.test_unicode_contentsّّ€ً=ˆ فŒnکZر(ش(ˆطذً 0ً 0ً 0ً 0ً 0à×زکuر%ش%ذ%طڈٹذ)ر*ش*ذ*طڈٹذ6¸رFرGشGذGطڈ ٹ ‰Œˆطڈٹ‌ذPذPذPذPذ>OذPرPشPرPشPذPه ر/ش/ذ/ذ/°·²½3½uذFWر;Xش;Xر1Yش1Yذ1Yً[ٌ \ô \ً \ً \ً \rcَˆ‡—gٹˆfd„}ddg}| tt¦«tjtd¬¦«}tjt¦«} | |¦«| ¦«}| |d¦«| d¦«| |d¦«| ¦«| ¦«n-#| ¦«| ¦«wxYw| ‰|¦«dS)Ncَ2•—‰ |¦«dSr rZr‘s €rr”z=TraceCallbackTests.test_trace_callback_content..tracer•rr£zinsert into foo(x) values(1))عisolation_levelrzcreate table bar(x)r8) ع addCleanuprrrrr‹rfr:عcloser")rr”عqueriesعcon1عcon2عcurr“s @rعtest_trace_callback_contentz.TraceCallbackTests.test_trace_callback_contents(ّ€àذً 0ً 0ً 0ً 0ً 0ً)ط1ً3ˆàڈٹ‌¥ر'ش'ذ'فŒ~‌f°dذ;ر;ش;ˆفŒ~‌fر%ش%ˆً ط×#ز# Eر*ش*ذ*ط—+’+‘-”-ˆCطڈKٹKک œ ر#ش#ذ#طڈLٹLذ.ر/ش/ذ/طڈKٹKک œ ر#ش#ذ#àڈJٹJ‰LŒLˆLطڈJٹJ‰LŒLˆLˆLًّ ڈJٹJ‰LŒLˆLطڈJٹJ‰LŒLˆLˆLّّّط×زذ*¨Gر4ش4ذ4ذ4ذ4s ء"A4C?أ?*D)c َp—gd¢}t¦«5}| ||¦«5|5| d¦«| dd„t d¦«D¦«¦«ddd¦«n#1swxYwYddd¦«n#1swxYwYddd¦«dS#1swxYwYdS)N)ْcreate table t(t)zBEGIN zinsert into t values(0)zinsert into t values(1)zinsert into t values(2)عCOMMITr¶zinsert into t values(?)c3َK—|]}|fV—ŒdSr r)rکعvs rr™z=TraceCallbackTests.test_trace_expanded_sql..>s$èè€ذ:Rذ:RہA¸A¸4ذ:Rذ:Rذ:Rذ:Rذ:Rذ:Rré)rrژr:عexecutemanyعrange)rrچrŒs rعtest_trace_expanded_sqlz*TraceCallbackTests.test_trace_expanded_sql2s¹€ً ً ً ˆُر ش ً T " d×&;ز&;¸Bہر&Iش&Iً Tً Tطً Tً Tط— ’ ذ.ر/ش/ذ/ط—’ذ8ذ:Rذ:Rحبqةجذ:Rر:Rش:RرSشSذSً Tً Tً Tٌ Tô Tً Tً Tً Tً Tً Tً Tًّّّ Tً Tً Tً Tً Tً Tً Tٌ Tô Tً Tً Tً Tً Tً Tً Tًّّّ Tً Tً Tً Tً Tً Tً Tٌ Tô Tً Tً Tً Tً Tً Tً Tً Tًّّّ Tً Tً Tً Tً Tً TsX“B+ھBAA<ء0Bء.]s €¨q°©s€rzselect 1)rr‹r:)rrŒs rعtest_trace_bad_handlerz)TraceCallbackTests.test_trace_bad_handlerZs™€ه ر ش ً # "ط×!ز!ذ"2ذ"2ر3ش3ذ3طڈJٹJگzر"ش"ذ"ً #ً #ً #ٌ #ô #ً #ً #ً #ً #ً #ً #ً #ًّّّ #ً #ً #ً #ً #ً #sڈ,AءAءAN)r1r2r3ع contextlibعcontextmanagerrژrœr rھr´r½rrع DataErrorrجr„rذrrrr†r†وsî€€€€€طشً(ً(ٌشً(ًWًWًWًNًNًNً\ً\ً\ً"5ً5ً5ً,TًTًTً€_طشطEًٌôً:ً:ٌ ôً:ً,€_ذ&ذ.@ذAرAشAً#ً#ٌBشAً#ً#ً#rr†ع__main__)rرعsqlite3rعunittestعtest.support.os_helperrrعtest.test_sqlite3.test_dbapirrع$test.test_sqlite3.test_userfunctionsrعTestCaser rVr†r1عmainrrrْrـs:ًً.ذذذطذذذط€€€à1ذ1ذ1ذ1ذ1ذ1ذ1ذ1àBذBذBذBذBذBذBذBط@ذ@ذ@ذ@ذ@ذ@ًeRًeRًeRًeRًeRگXش&ٌeRôeRًeRًN[ً[ً[ً[ً[گHش%ٌ[ô[ً[ً|x#ًx#ًx#ًx#ًx#کش*ٌx#ôx#ًx#ًvˆzزذط€H„MپO„O€O€O€Oًذr