rz'threadsafety is %d, should be 0, 1 or 3)assertInr threadsafetyr.s rtest_thread_safetyzModuleTests.test_thread_safety?s; f)999?)* + + + + +r cb|tjddtjzdS)Nqmarkz%paramstyle is '%s', should be 'qmark')r,r paramstyler.s rtest_param_stylezModuleTests.test_param_styleDs9 *G@*+ , , , , ,r cl|ttjtddS)Nz&Warning is not a subclass of Exception) assertTrue issubclassrWarning Exceptionr.s r test_warningzModuleTests.test_warningIs3  6>9=== ? ? ? ? ?r cl|ttjtddS)Nz$Error is not a subclass of Exception)r<r=rErrorr?r.s r test_errorzModuleTests.test_errorMs8  6<;;> @ @ @ @ @r cv|ttjtjddS)Nz)InterfaceError is not a subclass of Error)r<r=rInterfaceErrorrBr.s rtest_interface_errorz ModuleTests.test_interface_errorQs;  6#8&,GGC E E E E Er cv|ttjtjddS)Nz(DatabaseError is not a subclass of Error)r<r=r DatabaseErrorrBr.s rtest_database_errorzModuleTests.test_database_errorUs;  6#7FFB D D D D Dr cv|ttjtjddS)Nz,DataError is not a subclass of DatabaseError)r<r=r DataErrorrHr.s rtest_data_errorzModuleTests.test_data_errorYs<  6#3V5IJJF H H H H Hr cv|ttjtjddS)Nz3OperationalError is not a subclass of DatabaseError)r<r=rOperationalErrorrHr.s rtest_operational_errorz"ModuleTests.test_operational_error]<  6#:F> #"r""" # # # # # # # # # # # # # # # A   Q/ : : : OOA.99:KLL M M M  N N N N N N N N N N N N N N N N N Ns7 !C2*B ? C2 B C2B AC22C69C6rzRequires SQLite 3.7.16 or newerct5}|5|ddddn #1swxYwYd}|tj|5}|ddddn #1swxYwY|j}||jtj||j dddddS#1swxYwYdS)Nz&create table t(t integer check(t > 0))zconstraint failedzinsert into t values(-1)r) rexecuterrrRrr,rrr)r/conerrmsgrexcs r%test_extended_error_code_on_exceptionz1ModuleTests.test_extended_error_code_on_exceptionBs   N# F F DEEE F F F F F F F F F F F F F F F(F''(=vFF 8" 6777 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8,C   S1#; = = =   S13L M M M N N N N N N N N N N N N N N N N N NsQC"4 C"8 C"8 %C"!B7 C"B C" B A C""C&)C&darwinz#shared cache is deprecated on macOScdD]c}|t5}tj|dddn #1swxYwY|d|jddS)N)TFzdbapi.py) assertWarnsDeprecationWarningrenable_shared_cacher4filename)r/enablers rtest_shared_cache_deprecatedz(ModuleTests.test_shared_cache_deprecatedRs# 3 3F!!"455 3*6222 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 MM*bk 2 2 2 2 3 3sAA A ctjd}t|t|dt|tjdS)Nrselect 1)rrrtypeBlobr/rs rtest_disallow_instantiationz'ModuleTests.test_disallow_instantiationYsI ^J ' '$T4:+?+?@@@$T6;77777r c|tjd|tjddS)Nzselect tzcreate table t(t);) assertFalsercomplete_statementr<r.s rtest_complete_statementz#ModuleTests.test_complete_statement^sE 2:>>??? 12FGGHHHHHr N)__name__ __module__ __qualname__r0r6r:r@rCrFrIrLrOrSrVrYr\rrunittestskipIfrr r%rrr-r3r7r rr*r*:sLLL+++ ,,, ???@@@EEEDDDHHHOOOMMMLLLOOOPPP @8@8@8D N N NX_V/:=688 N N88 NX_S\X-/TUU33VU3 888 IIIIIr r*ceZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdS)ConnectionTestsctjd|_|j}|d|dddS)Nrz4create table test(id integer primary key, name text)!insert into test(name) values (?)foo)rrrcursorr!r/cus rsetUpzConnectionTests.setUpesR.,, W^^   IJJJ 6AAAAAr c8|jdSr#rcloser.s rtearDownzConnectionTests.tearDownk  r c8|jdSr#rcommitr.s r test_commitzConnectionTests.test_commitns r cj|j|jdS)zV A commit should also work when no changes were made to the database. NrNr.s rtest_commit_after_no_changesz,ConnectionTests.test_commit_after_no_changesqs.  r c8|jdSr#rrollbackr.s r test_rollbackzConnectionTests.test_rollbackxs r cj|j|jdS)zX A rollback should also work when no changes were made to the database. NrTr.s rtest_rollback_after_no_changesz.ConnectionTests.test_rollback_after_no_changes{s2  r c8|j}dSr#rrDrEs r test_cursorzConnectionTests.test_cursors W^^  r cd}|tj5tj|ddddS#1swxYwYdS)Nz/foo/bar/bla/23534/mydb.db) assertRaisesrrNr)r/YOU_CANNOT_OPEN_THISs rtest_failed_openz ConnectionTests.test_failed_opens;   v6 7 7 1 1 N/ 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1sAA Ac8|jdSr#rIr.s r test_closezConnectionTests.test_closerLr c,d}|j}||}|j|t j|j|t j|j||t j|j|g|t j|j ||t j|jj||t j|jj|g|t j|jj ||t j|jj ddd|t j|jj|t j5|j5 dddn #1swxYwYddddS#1swxYwYdS)Nr/tr2c|Sr#r=xs rz6ConnectionTests.test_use_after_close..sQr ) rrDr!rJr]rrXfetchall executemany executescriptcreate_function)r/sqlrFress rtest_use_after_closez$ConnectionTests.test_use_after_closes; W^^  jjoo   &13<@@@ &12:sCCC &12>3KKK &123CSIII &147?CHHH &1'-sB 8 8 8 &1473H#NNN &1'13;; H H H &147>BBB   v6 7 7                                     s6H #G1% H 1G5 5H 8G5 9H  H H cN||jjtj||jjtj||jjtj||jjtj||jjtj||jjtj||jj tj ||jj tj ||jj tj ||jj tj dSr#) r,rr>rrBrErHrKrNrRrUrXr[r.s rtest_exceptionszConnectionTests.test_exceptionss0 &.999  555 /1FGGG .0DEEE *F,<=== 163JKKK /1FGGG .0DEEE 163JKKK 2F4LMMMMMr ctjd}|}||jd|d||jd|dd||jd|ddg|}||jd|||jd|ddg|}||jddS) NrFz?create table transactiontest(id integer primary key, name text)z,insert into transactiontest(name) values (?)rBTz-select name from transactiontest where name=?rC)rrrDr,in_transactionr!fetchonerO)r/rrFrows rtest_in_transactionz#ConnectionTests.test_in_transactions7 ^J ' ' YY[[ *E222 TUUU *E222 A8LLL *D111 BUGLLLkkmm *D111  *E222 BUGLLLkkmm *E22222r c|t5d|j_ddddS#1swxYwYdS)NT)r]AttributeErrorrrrr.s rtest_in_transaction_roz&ConnectionTests.test_in_transaction_ros   ~ . . * *%)DG " * * * * * * * * * * * * * * * * * *s 599c <gd}|D]}||5|t|j||t t |t |j|dddn #1swxYwYdS)N) rKrHrBrRrEr[rNrXr>)r$)r r<r rassertIsgetattrr)r/ exceptionsr$s rtest_connection_exceptionsz*ConnectionTests.test_connection_exceptionss     K KC#&& K K 5 5666 gfc22GDGS4I4IJJJ K K K K K K K K K K K K K K K K KsA%BB B ctjd}||tj5|ddddS#1swxYwYdSr)rrrJr]rX interruptr2s rtest_interrupt_on_closed_dbz+ConnectionTests.test_interrupt_on_closed_dbs ^J ' '    v6 7 7   LLNNN                  A**A.1A.c^||jdSr#) assertIsNonerrr.s rtest_interruptzConnectionTests.test_interrupts* $'++--.....r ctdD]M}|jd|}||d|NdS)Nizselect r)rangerr!r,rs)r/nrFs rtest_drop_unused_refsz%ConnectionTests.test_drop_unused_refss`s 2 2A1//B   R[[]]1-q 1 1 1 1 2 2r ctj}|j|} d}|j||}|||||j||d}|tj||jjd|j||dS#|j||wxYw)Nrquery string is too largezselect 1 as '16') rrrgetlimitr$r,rrKr!)r/r% saved_limit new_limit prev_limitmsgs rtest_connection_limitsz&ConnectionTests.test_connection_limitss1g&&x00  4I))(I>>J   [* 5 5 5   TW--h77 C C C-C  " "6#3S#'7?4F H H H G  X{ 3 3 3 3 3DG  X{ 3 3 3 3s BCC1cd}d}|tj||jj||tj||jj|ddS)Nz'category' is out of boundsiWr)rrrXrrr$)r/rcats r"test_connection_bad_limit_categoryz2ConnectionTests.test_connection_bad_limit_categorysj+ v6#w/ 6 6 6 v6#w/a 9 9 9 9 9r c d}d}|D]}||5|t|5t|dddn #1swxYwYt5}|t|5||_dddn #1swxYwY||jddddn #1swxYwYdddn #1swxYwYdS)NzJisolation_level string must be '', 'DEFERRED', 'IMMEDIATE', or 'EXCLUSIVE')BOGUS DEFERREIMMEDIATEXCLUSIV DEFERREDS IMMEDIATES EXCLUSIVESlevelisolation_level)r r ValueErrorrrr,)r/rlevelsrrs r(test_connection_init_bad_isolation_levelz8ConnectionTests.test_connection_init_bad_isolation_levels     = =EE** = =++J<<;;#E::::;;;;;;;;;;;;;;;$&&="// C@@33-2*333333333333333$$R%7<<< =============== = = = = = = = = = = = = = = = = =s|C*A C*A C*A C*1C B!  C!B% %C(B% )C C*C C*C C**C. 1C. cdD]}||5t|5}||j|dddn #1swxYwYt5}||jd||_||j|dddn #1swxYwYdddn #1swxYwYdS)N)rDEFERRED IMMEDIATE EXCLUSIVENrrr)r rr,r)r/rrs r*test_connection_init_good_isolation_levelsz:ConnectionTests.test_connection_init_good_isolation_levelssE @ @EE** @ @$U;;;@r$$R%7???@@@@@@@@@@@@@@@$&&@"$$R%7<<<).B&$$R%7???@@@@@@@@@@@@@@@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @sXCA CA CA C->B7+ C7B; ;C>B; ?CC C cd}tj|}t|_tj|_|}|d|ddtdD|dd| dD}| td |D| d |Dd d g|||d|dd dDd|D}| td|D| d|DddgdS)Nrzcreate table foo (bar)z insert into foo (bar) values (?)c36K|]}t|fVdSr#)str.0vs r z9ConnectionTests.test_connection_reinit..$s*44aQ 444444r zselect bar from foocg|]}|Sr=r=rrs r z:ConnectionTests.test_connection_reinit..'s+++a+++r rc3JK|]}t|tjVdSr# isinstancerRowrs rrz9ConnectionTests.test_connection_reinit..(.DD!Jq&*55DDDDDDr cg|] }|d Srr=rs rrz:ConnectionTests.test_connection_reinit..)---1!A$---r 01c3K|]}|fVdSr#r=rs rrz9ConnectionTests.test_connection_reinit...s$;;;;;;;;r )abcdcg|]}|Sr=r=rs rrz:ConnectionTests.test_connection_reinit..1s)))a)))r c3JK|]}t|tjVdSr#rrs rrz9ConnectionTests.test_connection_reinit..2rr cg|] }|d Srr=rs rrz:ConnectionTests.test_connection_reinit..3rr 23)rrbytes text_factoryr row_factoryrDr!rir fetchmanyr<allr,__init__rh)r/rrrFrowss rtest_connection_reinitz&ConnectionTests.test_connection_reinits  ^B   YY[[ +,,, 944588444 6 6 6 ()))++2<<??+++ DDtDDDDDEEE -----d|<<< B +,,, 9;;&:;;; = = =*)2;;==))) DDtDDDDDEEE -----Sz:::::r c tjd}|5|ddddn #1swxYwYt5}|tjd|j||tjd|jddtdDddddS#1swxYwYdS)Nrcreate table t(t)r#Base Connection.__init__ not calledzinsert into t values(?)c3K|]}|fVdSr#r=rs rrz=ConnectionTests.test_connection_bad_reinit..@s$#;#;QQD#;#;#;#;#;#;r r3) rrr!rrrNrrXrir)r/rrs rtest_connection_bad_reinitz*ConnectionTests.test_connection_bad_reinit5sR ^J ' '  , , JJ* + + + , , , , , , , , , , , , , , , ZZ =2  " "6#:#A#%; 4 4 4  " "6#:#H#%>3L#;#;%((#;#;#; = = =  = = = = = = = = = = = = = = = = = =s 9==A'CC  C N)r8r9r:rGrKrPrRrVrXr[r_rarnrprurxr}rrrrrrrrrr=r rr?r?csyBBB 111 ( N N N333$***KKK" ///222 4 4 4999===2@@@;;;2 = = = = =r r?ceZdZdZdZdS)UninitialisedConnectionTestscbtjtj|_dSr#)r Connection__new__rr.s rrGz"UninitialisedConnectionTests.setUpDs!#++F,=>>r cfdfdfdfdfdfdf}|D]Q}|5tjd|dddn #1swxYwYRdS) NcjjSr#)rrr.srrgzEUninitialisedConnectionTests.test_uninit_operations..Is DG+r cjjSr#)r total_changesr.srrgzEUninitialisedConnectionTests.test_uninit_operations..Js DG)r cjjSr#)rrrr.srrgzEUninitialisedConnectionTests.test_uninit_operations..Ks DG*r c6jSr#)riterdumpr.srrgzEUninitialisedConnectionTests.test_uninit_operations..LsDG$$&&r c6jSr#rZr.srrgzEUninitialisedConnectionTests.test_uninit_operations..MsDGNN$$r c6jSr#rIr.srrgzEUninitialisedConnectionTests.test_uninit_operations..NsDGMMOOr )funcr)r rrrX)r/funcsrs` rtest_uninit_operationsz3UninitialisedConnectionTests.test_uninit_operationsGs + + + + ) ) ) ) * * * * & & & & $ $ $ $ # # # #   - -D4(( - -&&v'>'L'+--- - - - - - - - - - - - - - - - - -s"A$$A( +A( N)r8r9r:rGrr=r rrrCs2??? - - - - -r r serializezNeeds SQLite serialize APIceZdZdZdZdZejej dkde ddd d Z d S) SerializeTestsc*t5}|5|ddddn #1swxYwY|}|5|ddddn #1swxYwYd}|tj|5|ddddn #1swxYwY|||dddddS#1swxYwYdS)Nrz drop table tz no such tablezselect t from t)rr!rrrrN deserialize)r/rdataregexs rtest_serialize_deserializez)SerializeTests.test_serialize_deserializeZs    *" 0 0 ./// 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0<<>>D + + >*** + + + + + + + + + + + + + + +#E''(?GG . . ,--- . . . . . . . . . . . . . . . NN4 JJ( ) ) ) * * * * * * * * * * * * * * * * * *stD4 D8 D8 DA7+ D7A; ;D>A; ?%D$C: DC D C -DD D chttddddftgftdftdff}|D]v\}}|||5t 5}|||j|dddn #1swxYwYdddn #1swxYwYwdS)Nsblobrr2)r$arg) BufferError memoryview TypeErrorr rr]r)r/datasetr$rrs rtest_deserialize_wrong_argsz*SerializeTests.test_deserialize_wrong_argsksb *W--ccc2 3 O N       @ @HC#3// @ @$&&@"%%c2>3???@@@@@@@@@@@@@@@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @s6B&&B B&B B&B B&&B* -B* ct5}d}|tj|5|d|ddddn #1swxYwYddddS#1swxYwYdS)Nzfile is not a databaseszcreate table fail(f))rrrrHrr!)r/rrs r!test_deserialize_corrupt_databasez0SerializeTests.test_deserialize_corrupt_databasews     3",E''( > "" OOBGNN400 1 1 1 JJty ! ! ! " " " " " " " " " " " " " " " " " "s1A D  DDct}|t|d|z}|tj|tjtj |d5}| tj|| |j ddddS#1swxYwYdSr)rrrr5rrr rrrrr<r!r rs rtest_open_unquoted_uriz OpenTests.test_open_unquoted_uris %%%n --...  s = = = > > "" OOBGNN400 1 1 1 JJty ! ! ! " " " " " " " " " " " " " " " " " "sA CC #C ct}|t|dtjt j|zdz}|t j || tj 5tj|ddddn #1swxYwY|t j |tj||t j |t#jtj|d5}| tj 5||jdddn #1swxYwYddddS#1swxYwYdS)Nrz?mode=roTr)rrrrrrrrr5rr r]rrNrrJr<rrr!r rs rtest_open_uri_readonlyz OpenTests.test_open_uri_readonlysF %%% **2;t+<+<=== J --...   v6 7 7 * * N3D ) ) ) ) * * * * * * * * * * * * * * * --...t""$$$ t,,---  s = = = > > &"""6#:;; & & 49%%% & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & &sH+CCC G*+G G*G G*G G**G.1G.c t}|t|dtj|z}|tj |tj tj |d5}|tj |||jddddS#1swxYwYdSr)rrrrrrr5rrr rrrrr<r!r rs rtest_open_undecodable_uriz#OpenTests.test_open_undecodable_uris " %%% **4000 --...  s = = = > > "" OOBGNN400 1 1 1 JJty ! ! ! " " " " " " " " " " " " " " " " " "sA C99C=C=cHfd}ttjtttttjtfD]B}dt j||||CdS)Nc2|tjdg|Ri|Sr)rr)databaserr database_args rfactoryz4OpenTests.test_factory_database_arg..factorys)#L$ZA$AAA&AA Ar )r%)rrrrrrrJr,)r/r%r#r$s @rtest_factory_database_argz#OpenTests.test_factory_database_args B B B B B  V!4!4!&))8BK4G4G+H+HJ 5 5HL N8W 5 5 5 ; ; = = =   \8 4 4 4 4  5 5r ctjtjd5}|t |tjddddS#1swxYwYdS)Nr)r#)rrrrr,r0rr2s rtest_database_keywordzOpenTests.test_database_keywords   C C C D D :   T"XXv'8 9 9 9 : : : : : : : : : : : : : : : : : :s.A##A'*A'N)r8r9r:r r r;r<rrrrrrrrrrr r&r(r=r rrrs *D"""X_S\W,.BCCX_S\X-/ABBX_]-g/QRRX+-XYY""ZYSRCBDC"""""""&&& X_S\W,.BCCX_S\X-/ABBX_]-g/QRRX+-XYY""ZYSRCBDC" 5 5 5:::::r rceZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZej e!j"dkddZ#d Z$d!Z%d"Z&d#Z'd$Z(d%Z)d&Z*d'Z+d(Z,d)Z-d*Z.d+Z/d,Z0d-Z1d.Z2d/Z3d0Z4d1Z5d2Z6d3Z7d4Z8d5Z9d6Z:d7Z;d8Zd;S)< CursorTestsctjd|_|j|_|jd|jdddS)Nrz\create table test(id integer primary key, name text, income number, unique_test text unique)rArBrrrrDrFr!r.s rrGzCursorTests.setUpsb.,,'..""  6    ;XFFFFFr cj|j|jdSr#rFrJrr.s rrKzCursorTests.tearDown$    r c:|jddS)Ndelete from testrFr!r.s rtest_execute_no_argsz CursorTests.test_execute_no_argss *+++++r c|tj5|jdddddS#1swxYwYdS)Nz select asdf)r]rrNrFr!r.s rtest_execute_illegal_sqlz$CursorTests.test_execute_illegal_sqls   v6 7 7 + + GOOM * * * + + + + + + + + + + + + + + + + + +AA A cd}d}|D]}||5|tj|5|j|dddn #1swxYwYdddn #1swxYwYdS)Nz,You can only execute one statement at a time) zselect 1; select 2z)select 1; // c++ comments are not allowedzselect 1; *not a commentzselect 1; -*not a commentzselect 1; /* */ azselect 1; /**/az select 1; -z select 1; /zselect 1; - - select 2zHselect 1; -- comment select 2 query)r rrrXrFr!)r/rrr9s r test_execute_multiple_statementsz,CursorTests.test_execute_multiple_statementss<  + +EE** + +++F,CSII++GOOE***+++++++++++++++ + + + + + + + + + + + + + + + + +s5!A>A' A>'A+ +A>.A+ /A>>B B cd}|D]J}||5|j|dddn #1swxYwYKdS)N)zselect 1; -- foo barz select 1; --z select 1; /*zT select 5+4; /* foo */ r8)r rFr!)r/rr9s r#test_execute_with_appended_commentsz/CursorTests.test_execute_with_appended_comments s   ' 'EE** ' '&&& ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' 'sAA A c|t5|jdddddS#1swxYwYdSN*)r]rrFr!r.s rtest_execute_wrong_sql_argz&CursorTests.test_execute_wrong_sql_args   y ) )  GOOB                     sAA Ac<|jdddS)Ninsert into test(id) values (?))r?r2r.s rtest_execute_arg_intz CursorTests.test_execute_arg_int!s 95AAAAAr c<|jdddS)N#insert into test(income) values (?))gq= ף@r2r.s rtest_execute_arg_floatz"CursorTests.test_execute_arg_float$s =zJJJJJr c<|jdddS)NrA)Hugor2r.s rtest_execute_arg_stringz#CursorTests.test_execute_arg_string's ;YGGGGGr c|jdd|jd|jjf|j}||dddS)NrA)Hugoz select name from test where id=?rrK)rFr! lastrowidrsr,r/rts r&test_execute_arg_string_with_zero_bytez2CursorTests.test_execute_arg_string_with_zero_byte*sk ;]KKK :TW=N > > ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?r6c|tj5|jdddddS#1swxYwYdSrVrSr.s rtest_execute_wrong_no_of_args3z*CursorTests.test_execute_wrong_no_of_args3@rXr6c|jd|jddg|j}||dddS)N%insert into test(name) values ('foo')"select name from test where name=?rCrrFr!rsr,rMs rtest_execute_param_listz#CursorTests.test_execute_param_listEsc ?@@@ .LcdS)Nr2r=r.s r__len__z:CursorTests.test_execute_param_sequence..L.__len__Msqr c|dksJdS)NrrCr=r/rfs r __getitem__z>CursorTests.test_execute_param_sequence..L.__getitem__OsAvvvvur Nr8r9r:rdrgr=r rLrbLs2        r rir\r]rrCr^)r/rirts rtest_execute_param_sequencez'CursorTests.test_execute_param_sequenceKs         ?@@@ .Lcddz dS)Nr2rr=r.s rrdzBCursorTests.test_execute_param_sequence_bad_len..L.__len__[s!r ctr#)AssertionError)slfrfs rrgzFCursorTests.test_execute_param_sequence_bad_len..L.__getitem__]s$$r Nrhr=r rrirmZs2    % % % % %r rir\r])rFr!r]ZeroDivisionError)r/ris r#test_execute_param_sequence_bad_lenz/CursorTests.test_execute_param_sequence_bad_lenXs % % % % % % % % ?@@@   0 1 1 G G GOO@!!## F F F G G G G G G G G G G G G G G G G G Gs$A33A7:A7c^tj}d}t|j|d5|jdd|tj|5|jdddddn #1swxYwYddddS#1swxYwYdS)Nztoo many SQL variablesr2)r%r&zselect * from test where id=?r2z(select * from test where id!=? and id!=?)r2r)rrr(rrFr!rrN)r/r%rs rtest_execute_too_many_paramsz(CursorTests.test_execute_too_many_paramsds-6& dg : : : ( ( GOO;T B B B''(?EE ( ( J &((( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( (s5 B" B B"B B""B&)B&c|jd|jdddi|j}||dddS)Nr\&select name from test where name=:namenamerCrr^rMs rtest_execute_dict_mappingz%CursorTests.test_execute_dict_mappingmse ?@@@ @65/RRRg   Q'''''r cGddt}|jd|jd||j}||dddS)NceZdZdZdS)8CursorTests.test_execute_dict_mapping_mapping..DcdSNrCr=)r/keys r __missing__zDCursorTests.test_execute_dict_mapping_mapping..D.__missing__usur N)r8r9r:rr=r rDr}ts#     r rr\rxrrC)dictrFr!rsr,)r/rrts r!test_execute_dict_mapping_mappingz-CursorTests.test_execute_dict_mapping_mappingss         ?@@@ @!!##FFFg   Q'''''r c|jd|tj5|jdddiddddS#1swxYwYdS)Nr\z1select name from test where name=:name and id=:idryrCrFr!r]rrXr.s r)test_execute_dict_mapping_too_little_argsz5CursorTests.test_execute_dict_mapping_too_little_args}s ?@@@   v6 7 7 b b GOOORXZ_Q` a a a b b b b b b b b b b b b b b b b b bA%%A),A)c|jd|tj5|jdddddS#1swxYwYdS)Nr\rxrr.s r!test_execute_dict_mapping_no_argsz-CursorTests.test_execute_dict_mapping_no_argss ?@@@   v6 7 7 F F GOOD E E E F F F F F F F F F F F F F F F F F FA""A&)A&c|jd|tj5|jdddiddddS#1swxYwYdS)Nr\r]ryrCrr.s r!test_execute_dict_mapping_unnamedz-CursorTests.test_execute_dict_mapping_unnameds ?@@@   v6 7 7 S S GOO@65/ R R R S S S S S S S S S S S S S S S S S Src8|jdSr#)rFrJr.s rrazCursorTests.test_closerLr c|jd|jd|jd|jd||jjddS)Nr1r\zupdate test set name='bar'rrFr!r,rowcountr.s rtest_rowcount_executez!CursorTests.test_rowcount_executesw *+++ ?@@@ ?@@@ 4555 )1-----r cz|jd||jjddS)z pysqlite does not know the rowcount of SELECT statements, because we don't fetch all rows after executing the select statement. The rowcount has thus to be -1. zselect 5 union select 6Nrr.s rtest_rowcount_selectz CursorTests.test_rowcount_selects: 1222 )2.....r c|jd|jdgd||jjddS)Nr1rAru)rr3r3)rFr!rir,rr.s rtest_rowcount_executemanyz%CursorTests.test_rowcount_executemanysX *+++ ?ASASASTTT )1-----r )r3#rzRequires SQLite 3.35.0 or newerc|jd||jdd||jjddS)Nz7update test set name='bar' where name='foo' returning 1rr2)rFr!r,rsrr.s rtest_rowcount_update_returningz*CursorTests.test_rowcount_update_returningsc QRRR ))++A.222 )1-----r cb|jd||jjd|jd||jjd|jd||jjddS)NzW -- foo insert into test(name) values ('foo'), ('foo') rz /* -- messy *r /* /* ** *- *-- */ /* one more */ insert into test(name) values ('messy') r2z5/* bar */ update test set name='bar' where name='foo'r3rr.s r#test_rowcount_prefixed_with_commentz/CursorTests.test_rowcount_prefixed_with_comments      )1---     )1--- OPPP )1-----r c&d}|jd|||jjd|j|jd||jjddS)Nrz"insert into test(income) values(?)r3vacuumr)rFrir,rrrOr!)r/rs rtest_rowcount_vaccuumz!CursorTests.test_rowcount_vaccuums! @$GGG )1---  !!! )2.....r c|jd|jd|d|jjddS)Nr\rz"total changes reported wrong value)r)rFr! assertLessrrr.s rtest_total_changeszCursorTests.test_total_changessP ?@@@ ?@@@ 4706Z[[[[[r cl|jddtddDdS)NrEcg|]}|fSr=r=)rrfs rrz:CursorTests.test_execute_many_sequence..sCbCbCbQQDCbCbCbr dn)rFrirr.s rtest_execute_many_sequencez&CursorTests.test_execute_many_sequences= ACbCbRWX[]`RaRaCbCbCbcccccr cfGdd}|jd|dS)Nc eZdZdZdZdZdS)6CursorTests.test_execute_many_iterator..MyItercd|_dSN)valuer.s rrz?CursorTests.test_execute_many_iterator..MyIter.__init__s  r c|Sr#r=r.s r__iter__z?CursorTests.test_execute_many_iterator..MyIter.__iter__s r cV|jdkrt|xjdz c_|jfS)Nrr2)r StopIterationr.s r__next__z?CursorTests.test_execute_many_iterator..MyIter.__next__s.:##''JJ!OJJ J=(r N)r8r9r:rrrr=r rMyIterrsA       ) ) ) ) )r rrErFri)r/rs rtest_execute_many_iteratorz&CursorTests.test_execute_many_iteratorsQ ) ) ) ) ) ) ) ) A6688LLLLLr cRd}|jd|dS)Nc38KtdD]}|fVdSr)r)is rmygenz6CursorTests.test_execute_many_generator..mygens21XX  d   r rEr)r/rs rtest_execute_many_generatorz'CursorTests.test_execute_many_generators8    A5577KKKKKr c|t5|jddgddddS#1swxYwYdS)Nr?rr]rrFrir.s rtest_execute_many_wrong_sql_argz+CursorTests.test_execute_many_wrong_sql_args   y ) ) , , G  TF + + + , , , , , , , , , , , , , , , , , ,sAA  A c|tj5|jddgddddS#1swxYwYdS)Nzselect ?r)r]rrXrFrir.s rtest_execute_many_selectz$CursorTests.test_execute_many_selects   v6 7 7 4 4 G   TF 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4sA  AAc|t5|jddddddS#1swxYwYdS)NrEr?rr.s rtest_execute_many_not_iterablez*CursorTests.test_execute_many_not_iterables   y ) ) K K G   Er J J J K K K K K K K K K K K K K K K K K KsAA Ac|jd|jdd|jdd|jdg}|jD]}||d||dd||dd dS) Nr1rB)r)zselect id from test order by idrrr2r)rFr!r r,)r/lstrts rtest_fetch_iterzCursorTests.test_fetch_iters *+++ 94@@@ 94@@@ 9:::7  C JJs1v     Q### Q#####r c|jd|j}||dd|j}||ddS)Nselect name from testrrCr^rMs r test_fetchonezCursorTests.test_fetchoness /000g   Q'''g   d#####r c|j}|}||ddSr#)rrDrsr,)r/currts rtest_fetchone_no_statementz&CursorTests.test_fetchone_no_statements<gnnllnn d#####r c||jjdd|j_|jd|jd|jd|jd|jd|j}|t |ddS)Nr2rr1z#insert into test(name) values ('A')z#insert into test(name) values ('B')z#insert into test(name) values ('C')r)r,rF arraysizer!rlenr/rms rtest_array_sizezCursorTests.test_array_size s *A... *+++ =>>> =>>> =>>> /000g!! S1%%%%%r c|jd|jd}|t |d|jd}||gdS)Nrrr2rFr!rr,rrs rtest_fetchmanyzCursorTests.test_fetchmanysy /000g$$ S1%%%g$$ b!!!!!r c|jd|jd}|t |ddS)z0Checks if fetchmany works with keyword argumentsrr)rr2Nrrs rtest_fetchmany_kw_argz!CursorTests.test_fetchmany_kw_arg$sQ /000gS)) S1%%%%%r c|jd|j}|t |d|j}||gdS)Nrr2)rFr!rhr,rrs r test_fetchallzCursorTests.test_fetchall*su /000g   S1%%%g   b!!!!!r c>|jgddS)N)r3rr)rF setinputsizesr.s rtest_setinputsizeszCursorTests.test_setinputsizes1s" iii(((((r c<|jdddS)NrrrF setoutputsizer.s rtest_setoutputsizezCursorTests.test_setoutputsize4s  a#####r c:|jddSr>rr.s rtest_setoutputsize_no_columnz(CursorTests.test_setoutputsize_no_column7s b!!!!!r cP||jj|jdSr#)r,rF connectionrr.s rtest_cursor_connectionz"CursorTests.test_cursor_connection:s% +TW55555r c|t5d}|j|}ddddS#1swxYwYdS)NcdSr#r=r=r rfz1CursorTests.test_wrong_cursor_callable..f@r )r]rrrD)r/rrs rtest_wrong_cursor_callablez&CursorTests.test_wrong_cursor_callable>s   y ) ) $ $ MM'..##C $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $sAA  A cGdd}|}|t5tj|}ddddS#1swxYwYdS)NceZdZdS)0CursorTests.test_cursor_wrong_class..FooNr8r9r:r=r rFoorDsr r)r]rrCursor)r/rrCrs rtest_cursor_wrong_classz#CursorTests.test_cursor_wrong_classCscee   y ) ) % %-$$C % % % % % % % % % % % % % % % % % %sAAAc d}dD]~}||5|j||d||jjddddn #1swxYwYdS)zV INSERT OR REPLACE and REPLACE INTO should produce the same behavior. z+{} INTO test(id, unique_test) VALUES (?, ?))zINSERT OR REPLACEREPLACE statement)r2rCr2N)r rFr!formatr,rL)r/rlrs rtest_last_row_id_on_replacez'CursorTests.test_last_row_id_on_replaceIs<9 7 7I 22 7 7 9 5 5zBBB  !2A666 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7sAA88A< ?A< c|jdd||jjd|jdd||jjddS)Nz2insert or ignore into test(unique_test) values (?))testr)rFr!r,rLr.s rtest_last_row_id_on_ignorez&CursorTests.test_last_row_id_on_ignoreSs~  @     *A...  @     *A.....r cg}dD]}d}|d|5|j|||f|||jjf|tj5|j|||fdddn #1swxYwY|||jjfdddn #1swxYwYgd}| ||dS)N)FAILABORTROLLBACKz.INSERT OR {} INTO test(unique_test) VALUES (?)z INSERT OR {}r)rrrrr3rrrr) r rrFr!r rLr]rrRr,)r/resultsrrlexpecteds rtest_last_row_id_insert_o_rz'CursorTests.test_last_row_id_insert_o_r]s6 ? ?IBC(=(=i(H(HII ? ? 9 5 5 |DDD 47+<=>>>&&v'<==IIGOOCJJy$9$9I<HHHIIIIIIIIIIIIIII 47+<=>>>  ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?     (+++++s6A0D#0C DC# #D&C# '$DD D c(d}|j|}t|j}|jd|j|}t|j}|||z ddS)Nzselect * from testzalter table test add newcolr2)rFr!r descriptionr,)r/selectrm old_count new_counts rtest_column_countzCursorTests.test_column_countns%goof%%((  5666goof%%((  Y.22222r cfdtdD}|D]+}|dg,dS)NcDg|]}jdS)r/)rr!)r_r/s rrzCCursorTests.test_same_query_in_multiple_cursors..zs'AAA147??:..AAAr r3ru)rr,rh)r/cursorsrFs` r#test_same_query_in_multiple_cursorsz/CursorTests.test_same_query_in_multiple_cursorsys^AAAAaAAA 4 4B   R[[]]TF 3 3 3 3 4 4r N)?r8r9r:rGrKr3r5r:r<r@rCrFrIrNrPrTrWrZr_rjrsrvrzrrrrrarrrr;r<rr rrrrrrrrrrrrrrrrrrrrrrrrrrr rr=r rr*r*sGGG,,,++++++,'''"   BBBKKKHHH---RRR MMM ??? ??? ((( ( ( ( G G G(((((( (((bbb FFF SSS ...///... X_V/*<688..88. ... ///\\\dddMMM"LLL,,,444KKK $ $ $$$$$$$ &&&""""&&& """)))$$$"""666$$$ %%% 777///,,," 3 3 344444r r*ceZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!d Z"d!Z#d"Z$d#Z%d$Z&d%Z'd&Z(d'Z)d(Z*d)S)* BlobTestsctjd|_|jdd|_|jd|jf|jddd|_dS)Nrcreate table test(b blob)s2this blob data string is exactly fifty bytes long!zinsert into test(b) values (?)rrr2)rrrr!rblobopenblobr.s rrGzBlobTests.setUpsi.,, 3444I  849,GGGG$$VS!44 r cj|j|jdSr#)rrJrr.s rrKzBlobTests.tearDowns'   r cP||jtjdSr#)assertIsInstancerrr1r.s rtest_blob_is_a_blobzBlobTests.test_blob_is_a_blobs" di55555r cb|jd||jd|jdt||jd|jdt ||jd|jdt ||jddS)Nr()rseekr,tellr r rr.s rtest_blob_seek_and_tellz!BlobTests.test_blob_seek_and_tells r ))2... r8$$$ ))2... r8$$$ ))2... sH%%% ))2.....r cd}d}d}t|fdft|fdft|fdft|fdff}|D]M\}}}|||5|||dddn #1swxYwYNjd t t |5jttdddn #1swxYwYt |5jttddddS#1swxYwYdS) Nzoffset out of blob rangez;'origin' should be os.SEEK_SET, os.SEEK_CUR, or os.SEEK_ENDzseek offset results in overflowc8jdS)Nrrr.srrgz0BlobTests.test_blob_seek_error..s$)..*>*>r c8jdS)Nrr%r.srrgz0BlobTests.test_blob_seek_error..s$)..*=*=r c:jddS)Nrrr%r.srrgz0BlobTests.test_blob_seek_error..s49>>"b+A+Ar c:jddS)Nrr3r%r.srrgz0BlobTests.test_blob_seek_error..s49>>"a+@+@r )r$rfnr2) rr rrrr rr r r)r/msg_oormsg_origmsg_ofrr$rr)s` rtest_blob_seek_errorzBlobTests.test_blob_seek_errors1,P2">">">"> ? "="="="= > #A#A#A#A B #@#@#@#@ A   $ 5 5LCb#3266 5 5&&sC444 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 q(###  # #M6 : : . . INN7H - - - . . . . . . . . . . . . . . .  # #M6 : : . . INN7H - - - . . . . . . . . . . . . . . . . . .s6A>>B B &C77C;>C;&EEEcn|j}|||jdSr#)rreadr,rr/bufs rtest_blob_readzBlobTests.test_blob_reads1inn di(((((r c|jt|jdz}|||jdS)Nr)rr/rrr,r0s rtest_blob_read_oversizedz"BlobTests.test_blob_read_oversizeds@innS^^a/00 di(((((r cd}|j|}|||jd|||j|dS)Nr)rr/r,rr )r/rr1s rtest_blob_read_advance_offsetz'BlobTests.test_blob_read_advance_offsetsb innQ dim,,, ))1-----r c|jd||jd|jdddS)Nrr)rrr,r/rr.s rtest_blob_read_at_offsetz"BlobTests.test_blob_read_at_offsetsK r ++TYr"u-=>>>>>r c|jd|tj5|jddddS#1swxYwYdS)N&update test set b='aaaa' where rowid=1)rr!r]rrNrr/r.s r test_blob_read_error_row_changedz*BlobTests.test_blob_read_error_row_changeds @AAA   v6 7 7   INN                     sA!!A%(A%cdd}|j||jd}||d|dS)Nsnew data2select b from testr)ljustrwriterr!rsr,r/new_datarts rtest_blob_writezBlobTests.test_blob_writesi$$R(( !!!goo233<<>> Q*****r c"d}|jd|j||jd}||d|jdd|zdS)Nscccccccccccccccccccccccccrr>r)rrr@rr!rsr,rrAs rtest_blob_write_at_offsetz#BlobTests.test_blob_write_at_offsets~ r !!!goo233<<>> Q3B3(!:;;;;;r c|jd||jddS)Ns ddddddddddr)rr@r,r r.s rtest_blob_write_advance_offsetz(BlobTests.test_blob_write_advance_offsets>     ))2.....r c|td5|jddddn #1swxYwY|jdt t |j}|jd|dz z|jd|td5|jdddddS#1swxYwYdS)Nzdata longer than blobaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaarar2)rrrr@rr r)r/rs rtest_blob_write_error_lengthz&BlobTests.test_blob_write_error_lengthsf  # #J0G H H ) ) IOOK ( ( ( ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) q(###  NN ! %%%   # #J0G H H " " IOOD ! ! ! " " " " " " " " " " " " " " " " " "s#AA AC??DDc|jd|tj5|jdddddS#1swxYwYdS)Nr:aaa)rr!r]rrNrr@r.s r!test_blob_write_error_row_changedz+BlobTests.test_blob_write_error_row_changeds @AAA   v6 7 7 $ $ IOOF # # # $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $rc|jdddd}|tjd5|ddddn #1swxYwY|dS)Nrrr2T)readonlyrPrM)rrrrrNr@rJ)r/ro_blobs rtest_blob_write_error_readonlyz(BlobTests.test_blob_write_error_readonlys'""63D"AA  # #F$;Z H H " " MM& ! ! ! " " " " " " " " " " " " " " " sA!!A%(A%c,dddifdifdifdiff}d}|D]~\}}|||5|tj|5|jj|i|dddn #1swxYwYdddn #1swxYwYdS) N)rrr2ry notexisting)rTrr2)rrTr2)rrrzno such)rkwds)r rrrNrr)r/rrrrUs rtest_blob_open_errorzBlobTests.test_blob_open_errorsF  6 7 $b ) ' , r "   ! 4 4JD$4d33 4 4++F,CUKK44$DG$d3d333444444444444444 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4s5!BA1% B1A5 5B8A5 9BB B cV|t|jddS)Nr=)r,rrr.s rtest_blob_lengthzBlobTests.test_blob_lengths& TY,,,,,r c||jdtd||jdtd||jdtd||jdtd||jdtd dS) Nrrrlrorr!)r,rordr.s rtest_blob_get_itemzBlobTests.test_blob_get_items 1s3xx000 1s3xx000 1s3xx000 1s3xx000 2C11111r ctd|jd<d|jddz}|jdd}|||dS)Nrrrr2r>)r]rrrr!rsr,r/ractuals rtest_blob_set_itemzBlobTests.test_blob_set_itemsh3xx ! $)ABB-'!566??AA!D *****r c|jdt||jdt d|jd<t d|jd<|jdt d}||j|dS)Nrr T.rs2This blob data string is exactly fifty bytes long.)rrrr,r/r]r )r/rs rtest_blob_set_item_with_offsetz(BlobTests.test_blob_set_item_with_offset s q(### ))3///3xx ! C "  q(###H ))844444r cxddlm}td|jdd<||jdddt d|jdd<||jddd|dgd|jdd<||jddddS) Nr)array12345rs23456r)r2rr3rrs)rhrrr, bytearray)r/rhs r!test_blob_set_slice_buffer_objectz+BlobTests.test_blob_set_slice_buffer_objects#H-- !A# 1Q3222"8,, !A# 1Q3222sOOO44 !A# 1Q3)@AAAAAr c\d|jd<||jdddS)Nr)rr,r.s r!test_blob_set_item_negative_indexz+BlobTests.test_blob_set_item_negative_index s/ "  2,,,,,r cL||jddddS)Nrrs blob datar,rr.s rtest_blob_get_slicezBlobTests.test_blob_get_slice$s( 1R4,77777r cL||jddddS)Nrr rpr.s rtest_blob_get_empty_slicez#BlobTests.test_blob_get_empty_slice's( 1Q3-----r cf||jdd|jdddS)Nr)r,rrr.s r"test_blob_get_slice_negative_indexz,BlobTests.test_blob_get_slice_negative_index*s2 1R4$)AbD/:::::r cN||jdddddS)Nrrrsti lbrpr.s rtest_blob_get_slice_with_skipz'BlobTests.test_blob_get_slice_with_skip-s+ 1R6*H55555r cd|jdd<d|jddz}|jdd}|||dS)Nrirrr>)rrrr!rsr,r`s rtest_blob_set_slicezBlobTests.test_blob_set_slice0sf! !A#dim+!566??AA!D *****r cnd|jdd<||jdd|jdS)Nr r)rr,rr.s rtest_blob_set_empty_slicez#BlobTests.test_blob_set_empty_slice6s9 !A# 111ty11111r cd|jddd<|jdd}d|jddz}|||dS)Nrirrrr>s 1h2s3b4o5 )rrr!rsrr,)r/rars rtest_blob_set_slice_with_skipz'BlobTests.test_blob_set_slice_with_skip:si$ !Bq&!566??AA!D 49RSS>1 *****r cd}|t|5|jdddddn #1swxYwY|t|5|jddddn #1swxYwY|t|5d|jd<ddddS#1swxYwYdS)Nzindices must be integersrg@g?rrrrr)r/rs r$test_blob_mapping_invalid_index_typez.BlobTests.test_blob_mapping_invalid_index_type@s~(  # #Is 3 3   Iae                   # #Is 3 3   IcNN                 # #Is 3 3 " "!DIcN " " " " " " " " " " " " " " " " " "s1:>> A::A>A> B88B<?B<cbt|jddg}|D]p}||5|td5|j|dddn #1swxYwYdddn #1swxYwYq|td5|jt dddn #1swxYwY|jd|tj 5|jdddddS#1swxYwYdS)Nii)idxzindex out of rangezcannot fit 'int'r:r) rrr r IndexErrorr rr!r]rrN)r/rrs rtest_blob_get_item_errorz"BlobTests.test_blob_get_item_errorIsty>>3- # #C#&& # #++J8LMM##IcNN############### # # # # # # # # # # # # # # # # #J0B C C " " Ij ! ! " " " " " " " " " " " " " " " @AAA   v6 7 7   IaLL                  sYA?A( A?(A, ,A?/A, 0A??B B &CC  C  D$$D(+D(c|td5d|jd<dddn #1swxYwY|td5d|jd<dddn #1swxYwY|td5td|jd<dddn #1swxYwY|td5|jd=dddn #1swxYwY|td5d|jd<dddn #1swxYwY|t d5d |jd<dddn #1swxYwY|t d5d |jd<dddn #1swxYwY|t d5d d z|jd<ddddS#1swxYwYdS) Nzcannot be interpretedsmultiplerrdoesn't support.*deletionzBlob index out of ranger$zmust be in rangerrA)rrrrjrrr.s rtest_blob_set_item_errorz"BlobTests.test_blob_set_item_errorWs  # #I/F G G ' '&DIaL ' ' ' ' ' ' ' ' ' ' ' ' ' ' '  # #I/F G G  DIaL                # #I/F G G + +$T??DIaL + + + + + + + + + + + + + + +  # #I/J K K   !                  # #J0I J J  DIdO                # #J0B C C  DIaL                 # #J0B C C  DIaL                # #J0B C C ! !b5DIaL ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! !s 377 A00A47A4B::B>B> C55C9<C9 D22D69D6 E//E36E3 F,,F03F0G--G14G1c|td5d|jdd<dddn #1swxYwY|td5d|jdd<dddn #1swxYwY|td5|jdd=dddn #1swxYwY|td5d|jddd <dddn #1swxYwY|t 5td ddd |jdd<ddddS#1swxYwYdS) Nz wrong sizerJrrrIrzstep cannot be zerorirsabcder)rrrrrr]rrr.s rtest_blob_set_slice_errorz#BlobTests.test_blob_set_slice_errorjs  # #J = = # #"DIadO # # # # # # # # # # # # # # #  # #J = = * *)DIadO * * * * * * * * * * * * * * *  # #I/J K K   !B$                # #J0E F F ) ) (DIa1f  ) ) ) ) ) ) ) ) ) ) ) ) ) ) )   { + + 8 8(2233Q37DIadO 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8sT 599 A44A8;A8 B11B58B5C11C58C5#EE  E c~|td5|j|jzdddn #1swxYwY|td5|jdzdddn #1swxYwY|td5d|jvddddS#1swxYwYdS)Nzunsupported operandrzis not iterablerJrr.s r test_blob_sequence_not_supportedz*BlobTests.test_blob_sequence_not_supportedvs|  # #I/D E E " " I ! ! " " " " " " " " " " " " " " "  # #I/D E E   IMM                 # #I/@ A A   DI                    s08<< A55A9<A9 B22B69B6cd}|jddd5}||dddn #1swxYwY|jdd}||||tjd5| ddddS#1swxYwYdS)Ns2aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaarrr2r>rz closed blob) rrr@r!rsr,rrrXr/)r/rrras rtest_blob_context_managerz#BlobTests.test_blob_context_manager~sL W  fc1 - -  JJt                  !566??AA!D &&& # #F$;] K K   IIKKK                  s#AAA4CCCcGddt}||d5|jddd5}|d#1swxYwY ddddS#1swxYwYdS)NceZdZdS)NBlobTests.test_blob_context_manager_reraise_exceptions..DummyExceptionNrr=r rDummyExceptionrs Dr rreraisedrrr2)r?rrr)r/rrs r,test_blob_context_manager_reraise_exceptionsz6BlobTests.test_blob_context_manager_reraise_exceptionss     Y     # #NJ ? ? 1 1!!&#q11 1T$nZ000 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1s/A, AA A,A A,,A03A0ct5}|d|d|ddd}|d}|t j|5|dddn #1swxYwY|t j|5|ddddn #1swxYwY|t j|5| ddddn #1swxYwY|t j|5| dddn #1swxYwY|t j|5| dddn #1swxYwY|t j|5| ddddddn #1swxYwY|t j|5t|dddn #1swxYwY|t j|5|ddddn #1swxYwY|t j|5|dddddn #1swxYwY|t j|5d|d<dddn #1swxYwYddddS#1swxYwYdS) Nrz'insert into test values (zeroblob(100))rrr2zCannot operate on a closed blobr r)rr!rrJrrrXr/r@rr  __enter____exit__r)r/rrrs rtest_blob_closedzBlobTests.test_blob_closeds    " JJ2 3 3 3 JJ@ A A A;;vsA..D JJLLL3C''(?EE                  ''(?EE   3               ''(?EE   !                ''(?EE                  ''(?EE ! !    ! ! ! ! ! ! ! ! ! ! ! ! ! ! !''(?EE 0 0 dD$/// 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0''(?EE  D                ''(?EE  Q               ''(?EE  QqS                ''(?EE  Q               3                  szA8MB( M(B, ,M/B, 0#MC5) M5C9 9M<C9 =#M E6 ME M E #M-F MF MF #M9G MG M!G "#MH) M)H- -M0H- 1#MI0$ M0I4 4M7I4 8#M J0$ M0J4 4M7J4 8#M K2& M2K6 6M9K6 :#ML/# M/L3 3M6L3 7MM M cJt5}|d|d|ddd}||t jd|jddddS#1swxYwYdS)Nrz*insert into test(b) values (zeroblob(100))rrr2z#Cannot operate on a closed database)rr!rrJrrrXr/)r/rrs rtest_blob_closed_db_readz"BlobTests.test_blob_closed_db_reads    ." JJ2 3 3 3 JJC D D D;;vsA..D HHJJJ  " "6#:#H#'9 . . .  . . . . . . . . . . . . . . . . . .sA*--8??$$ ?@@@ GHHHHHr cj|j|jdSr#)rrJr"r.s rrKzThreadTests.tearDowns,  r cfd}g}tj|d|i}|||r*|d|dSdS)Nc i|ddS#tj$rYdS|dYdSxYw)Nzdid not raise ProgrammingErrorzraised wrong exception)r rrX)errrr)rUs rrunz"ThreadTests._run_test..runsw 5D!D!!! ;<<<<<*    5 3444444s"A A rtargetr ) threadingThreadstartjoinfail)r/r)rrUrrrcs ``` r _run_testzThreadTests._run_tests 5 5 5 5 5 5 5  C = = =     & IIdiinn % % % % % & &r c fdfdfdfdfdfdfdfdfd fd g }ttjd r0|fd |fd tjdkr|fd|D]E}|5|dddn #1swxYwYFdS)Nc6jSr#)r"rDr.srrgz:ThreadTests.test_check_connection_thread..DHOO%%r c6jSr#)r"rOr.srrgz:ThreadTests.test_check_connection_thread..rr c6jSr#)r"rUr.srrgz:ThreadTests.test_check_connection_thread..DH%%''r c6jSr#)r"rJr.srrgz:ThreadTests.test_check_connection_thread..DHNN$$r c8jdSr#)r"set_trace_callbackr.srrgz:ThreadTests.test_check_connection_thread..sDH//55r c8jdSr#)r"set_authorizerr.srrgz:ThreadTests.test_check_connection_thread..sDH++D11r c:jddSr)r"create_collationr.srrgz:ThreadTests.test_check_connection_thread..sDH--eT::r cNjtjdS)Nr)r"r$rrr.srrgz:ThreadTests.test_check_connection_thread..sDH%%f&@"EEr cLjtjSr#)r"rrrr.srrgz:ThreadTests.test_check_connection_thread..sDH%%f&@AAr c<jdddS)Nrrr2)r"rr.srrgz:ThreadTests.test_check_connection_thread..sDH%%fc155r rc6jSr#)r"rr.srrgz:ThreadTests.test_check_connection_thread..stx1133r c8jdS)Nr )r"rr.srrgz:ThreadTests.test_check_connection_thread..stx33C88r rc<jdddS)NrCr)r"create_window_functionr.srrgz:ThreadTests.test_check_connection_thread..stx>>uaNNr r))r rrr r r rr/fnsr)s` rtest_check_connection_threadz(ThreadTests.test_check_connection_threads % % % % % % % % ' ' ' ' $ $ $ $ 5 5 5 5 1 1 1 1 : : : : E E E E A A A A 5 5 5 5   6$k 2 2 : JJ3333 4 4 4 JJ8888 9 9 9  % 3 3 JJNNNN O O O # #B$$ # #r""" # # # # # # # # # # # # # # # # #s8CC !C cfdfdfdfdg}|D]E}|5|dddn #1swxYwYFdS)Nc8jdS)Nz"insert into test(name) values('a')rr!r.srrgz6ThreadTests.test_check_cursor_thread..sDH$$%IJJr c6jSr#)rrJr.srrgz6ThreadTests.test_check_cursor_thread..rr c8jdS)Nrrr.srrgz6ThreadTests.test_check_cursor_thread..sDH$$%<==r c6jSr#)rrsr.srrgz6ThreadTests.test_check_cursor_thread..rr r)r rrs` rtest_check_cursor_threadz$ThreadTests.test_check_cursor_threads J J J J $ $ $ $ = = = = ' ' ' '    # #B$$ # #r""" # # # # # # # # # # # # # # # # #sAA A c,d}tjdd}g}tj|||d}|||t|dd|dS) Nc |ddS#tj$r|dYdSwxYw)Nr/zmulti-threading not allowed)r!rrBr r"rs rrz4ThreadTests.test_dont_check_same_thread..runsX : J'''''< : : : 8999999 :s$AArF)check_same_threadrrrr)rrrrrrr,r)r/rr"rrcs rtest_dont_check_same_threadz'ThreadTests.test_dont_check_same_threads : : : nZ5AAA  CC0H0H I I I    S1diinn55555r N) r8r9r:rGrKr reap_threadsrrrrr=r rrrsIII "&&#"&"###. # # #" 6 6#" 6 6 6r rc8eZdZdZdZdZdZdZdZdZ dS) ConstructorTestsc2tjddd}dS)Nr)rDater/rs r test_datezConstructorTests.test_dates Kb" % %r c2tjddd}dS)N 'r)rTimer/rcs r test_timezConstructorTests.test_times KB # #r c8tjdddddd}dS)Nrrrrrr)r Timestampr/tss rtest_timestampzConstructorTests.test_timestamps  dBBB 7 7r c.tjd}dSr>)r DateFromTicksrs rtest_date_from_ticksz%ConstructorTests.test_date_from_ticks   $ $r c.tjd}dSr>)r TimeFromTicksrs rtest_time_from_ticksz%ConstructorTests.test_time_from_ticksrr c.tjd}dSr>)rTimestampFromTicksrs rtest_timestamp_from_ticksz*ConstructorTests.test_timestamp_from_ticks"s  &r * *r c.tjd}dS)Ns')rBinary)r/rs r test_binaryzConstructorTests.test_binary%s M& ! !r N) r8r9r:rrrrrrrr=r rrrs}&&&$$$888%%%%%%+++"""""r rcPeZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d S) ExtensionTestsc tjd}|}|d|d|d}||ddS)Nrz -- bla bla /* a stupid comment */ create table a(i); insert into a(i) values (5); zselect i from arr)rrrDrjr!rsr,)r/r"rrms rtest_script_string_sqlz%ExtensionTests.test_script_string_sql)s~nZ((jjll     %&&&llnnQ a     r ctjd}|}|tj5|dddddS#1swxYwYdS)Nrz1create table test(x); asdf; create table test2(x)rrrDr]rNrjr/r"rs rtest_script_syntax_errorz'ExtensionTests.test_script_syntax_error6snZ((jjll   v6 7 7 S S   Q R R R S S S S S S S S S S S S S S S S S SA++A/2A/ctjd}|}|tj5|dddddS#1swxYwYdS)Nrz5create table test(sadfsadfdsa); select foo from hurz;rrs rtest_script_error_normalz'ExtensionTests.test_script_error_normal<snZ((jjll   v6 7 7 W W   U V V V W W W W W W W W W W W W W W W W W Wrctjd}|}|t5|dddddS#1swxYwYdS)Nrs9create table test(foo); insert into test(foo) values (5);)rrrDr]rrjrs r"test_cursor_executescript_as_bytesz1ExtensionTests.test_cursor_executescript_as_bytesBsnZ((jjll   y ) ) \ \   Z [ [ [ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \A&&A*-A*ctjd}|}|t5|dddddS#1swxYwYdS)Nrzb create table a(i); insert into a(i) values (5); )rrrDr]rrjrs r.test_cursor_executescript_with_null_charactersz=ExtensionTests.test_cursor_executescript_with_null_charactersHsnZ((jjll   z * *                          rctjd}|}|t5|dddddS#1swxYwYdS)Nrue create table a(s); insert into a(s) values (''); )rrrDr]UnicodeEncodeErrorrjrs r)test_cursor_executescript_with_surrogatesz8ExtensionTests.test_cursor_executescript_with_surrogatesQsnZ((jjll   1 2 2                          rc d}t5}t|5}|d||t j|5|d|dzdddn #1swxYwYdddn #1swxYwYddddS#1swxYwYdS)Nrzselect 'almost too large'zselect 'too large'r2)rr(rjr?rrrK)r/rrlims r*test_cursor_executescript_too_large_scriptz9ExtensionTests.test_cursor_executescript_too_large_scriptZs)    D"hrll Dc   8>>sCC D D D''(8#>> D D  !5!;!;CE!B!BCCC D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D D DsYCA B9*,B" B9"B& &B9)B& *B9- C9B= =CB= CCCctjd}|d||j|d||jdS)Nrbeginr/)rrr!r<rrrjr5r/r"s r$test_cursor_executescript_tx_controlz3ExtensionTests.test_cursor_executescript_tx_controlasinZ(( G *+++ *%%% +,,,,,r ctjd}|dd}||dddS)Nrzselect 5rrz Basic test of Connection.execute)rrr!rsr,r/r"results rtest_connection_executez&ExtensionTests.test_connection_executehsRnZ((Z((1133A6 $FGGGGGr cbtjd}|d|dddg|d}||dddd ||d dd d dS) Nrzcreate table test(foo)z insert into test(foo) values (?)rrz!select foo from test order by foorr3z$Basic test of Connection.executemanyr2r)rrr!rirhr,rs rtest_connection_executemanyz*ExtensionTests.test_connection_executemanymsnZ(( ,--- :T4LIII@AAJJLL 1q*PQQQ 1q*PQQQQQr ctjd}|d|dd}||dddS)Nrz9create table test(foo); insert into test(foo) values (5);zselect foo from testrrz&Basic test of Connection.executescript)rrrjr!rsr,rs rtest_connection_executescriptz,ExtensionTests.test_connection_executescriptushnZ(( UVVV344==??B $LMMMMMr N)r8r9r:rrrrrr r rrrrr=r rrr(s ! ! !SSS WWW \\\ DDD---HHH RRRNNNNNr rcDeZdZdZdZdZdZdZdZdZ dZ d Z d S) ClosedConTestsctjd}||tj5|}ddddS#1swxYwYdSr)rrrJr]rXrDrs rtest_closed_con_cursorz%ClosedConTests.test_closed_con_cursor|snZ((   v6 7 7  **,,C                  rctjd}||tj5|ddddS#1swxYwYdSr)rrrJr]rXrOrs rtest_closed_con_commitz%ClosedConTests.test_closed_con_commitsnZ((   v6 7 7   JJLLL                  rctjd}||tj5|ddddS#1swxYwYdSr)rrrJr]rXrUrs rtest_closed_con_rollbackz'ClosedConTests.test_closed_con_rollbacksnZ((   v6 7 7   LLNNN                  rctjd}|}||tj5|dddddS#1swxYwYdS)Nrzselect 4)rrrDrJr]rXr!rs rtest_closed_cur_executez&ClosedConTests.test_closed_cur_executesnZ((jjll   v6 7 7 $ $ KK # # # $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $sA??BBctjd}|d}|tj5|dd|ddddS#1swxYwYdS)NrcdSNrr=res rrz5ClosedConTests.test_closed_create_function..fsr rCr2)rrrJr]rXrk)r/r"rs rtest_closed_create_functionz*ClosedConTests.test_closed_create_functionsnZ((    v6 7 7 - -   q! , , , - - - - - - - - - - - - - - - - - -s A00A47A4ctjd}|Gdd}|tj5|dd|ddddS#1swxYwYdS)Nrc eZdZdZdZdZdS)8ClosedConTests.test_closed_create_aggregate..AggcdSr#r=r.s rrzAClosedConTests.test_closed_create_aggregate..Agg.__init__r cdSr#r=rfs rstepz=ClosedConTests.test_closed_create_aggregate..Agg.stepr-r cdSr'r=r.s rfinalizezAClosedConTests.test_closed_create_aggregate..Agg.finalizesrr N)r8r9r:rr/r1r=r rAggr+sA           r r2rCr2)rrrJr]rXcreate_aggregate)r/r"r2s rtest_closed_create_aggregatez+ClosedConTests.test_closed_create_aggregatesnZ((           v6 7 7 0 0  3 / / / 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0sA::A>A>ctjd}|d}|tj5||ddddS#1swxYwYdS)NrctjSr#)rDENY)rs r authorizerz=ClosedConTests.test_closed_set_authorizer..authorizers ; r )rrrJr]rXr)r/r"r8s rtest_closed_set_authorizerz)ClosedConTests.test_closed_set_authorizersnZ((       v6 7 7 + +   z * * * + + + + + + + + + + + + + + + + + +s A..A25A2ctjd}|d}|tj5||dddddS#1swxYwYdS)NrcdSr#r=r=r rprogresszBClosedConTests.test_closed_set_progress_callback..progressrr r)rrrJr]rXset_progress_handler)r/r"r<s r!test_closed_set_progress_callbackz0ClosedConTests.test_closed_set_progress_callbacksnZ((    v6 7 7 4 4  $ $Xs 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4s A//A36A3ctjd}||tj5|ddddS#1swxYwYdSr)rrrJr]rXrs rtest_closed_callzClosedConTests.test_closed_callsnZ((   v6 7 7   CEEE                  s A  A$'A$N) r8r9r:rr r"r$r(r4r9r>r@r=r rrr{s   $$$--- 0 0 0+++444r rceZdZdZdS)ClosedCurTestscLtjd}|}|dD]d}|dvrd}n|dkrdddgf}ng}|tj5t ||}||dddn #1swxYwYedS) Nr)r!rirjrhrrs)r!rj)zselect 4 union select 5rizinsert into foo(bar) values (?)rr)rrrDrJr]rXr{)r/r"r method_nameparamsmethods r test_closedzClosedCurTests.test_closedsnZ((jjll k K:::5 --;dD\J""6#:;;   k22                s6BB B N)r8r9r:rGr=r rrBrBs#     r rBcHeZdZdZdZdZdZdZdZdZ dZ d Z d Z d S) SqliteOnConflictTestszz Tests for SQLite's "insert on conflict" feature. See https://www.sqlite.org/lang_conflict.html for details. ctjd|_|j|_|jddS)Nrzz CREATE TABLE test( id INTEGER PRIMARY KEY, name TEXT, unique_name TEXT UNIQUE ); r,r.s rrGzSqliteOnConflictTests.setUpsM.,,'..""       r cj|j|jdSr#r.r.s rrKzSqliteOnConflictTests.tearDownr/r cXd|j_|j|_|jd|jd|jd|t j5|jddddn #1swxYwY|j|jd| |j gdS)NBEGIN,INSERT INTO test(name) VALUES ('abort_test')8INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')z"SELECT name, unique_name from test rrrDrFr!r]rrRrOr,rhr.s r3test_on_conflict_rollback_with_explicit_transactionzISqliteOnConflictTests.test_on_conflict_rollback_with_explicit_transactionsB"&'..""     FGGG RSSS   v4 5 5 X X GOOV W W W X X X X X X X X X X X X X X X  <=== ))++R00000B??CCc\d|j_|j|_|jd|jd|jd|t j5|jddddn #1swxYwY|j|jd| |j ddgdS)NrMrN5INSERT OR ABORT INTO test(unique_name) VALUES ('foo')"SELECT name, unique_name FROM test abort_testNrrPr.s r8test_on_conflict_abort_raises_with_explicit_transactionszNSqliteOnConflictTests.test_on_conflict_abort_raises_with_explicit_transactionssH#''..""     FGGG OPPP   v4 5 5 U U GOOS T T T U U U U U U U U U U U U U U U  <=== ))++.BN-STTTTTrRc|jd|jd|tj5|jddddn #1swxYwY|jd||jgdS)NrNrOrUrFr!r]rrRr,rhr.s r-test_on_conflict_rollback_without_transactionzCSqliteOnConflictTests.test_on_conflict_rollback_without_transactions FGGG RSSS   v4 5 5 X X GOOV W W W X X X X X X X X X X X X X X X <=== ))++R00000A;;A?A?c|jd|jd|tj5|jddddn #1swxYwY|jd||jddgdS)NrNrTrUrVrrZr.s r2test_on_conflict_abort_raises_without_transactionszHSqliteOnConflictTests.test_on_conflict_abort_raises_without_transactionss FGGG OPPP   v4 5 5 U U GOOS T T T U U U U U U U U U U U U U U U <=== ))++.BN-STTTTTr\c6|jd|tj5|jddddn #1swxYwY||jgdS)Nz4INSERT OR FAIL INTO test(unique_name) VALUES ('foo')rZr.s rtest_on_conflict_failz+SqliteOnConflictTests.test_on_conflict_fails NOOO   v4 5 5 T T GOOR S S S T T T T T T T T T T T T T T T ))++R00000sA!!A%(A%c|jd|jd|jd||jdgdS)Nz6INSERT OR IGNORE INTO test(unique_name) VALUES ('foo')zSELECT unique_name FROM testrBrFr!r,rhr.s rtest_on_conflict_ignorez-SqliteOnConflictTests.test_on_conflict_ignoresm PQQQ PQQQ 6777 ))++hZ88888r c|jd|jd|jd||jdgdS)NzFINSERT OR REPLACE INTO test(name, unique_name) VALUES ('Data!', 'foo')zUINSERT OR REPLACE INTO test(name, unique_name) VALUES ('Very different data!', 'foo')rU)zVery different data!rCrbr.s rtest_on_conflict_replacez.SqliteOnConflictTests.test_on_conflict_replace&so `aaa oppp <=== ))++.M-NOOOOOr N) r8r9r:__doc__rGrKrQrXr[r^r`rcrer=r rrIrIs     1 1 1UUU 111 U U U111 999PPPPPr rIc$eZdZedz ZdZdZdS)MultiprocessTestsg@@c.ttdSr#)rrr.s rrKzMultiprocessTests.tearDown2svr c(dtd|jd}tjtjd|gddtjtj}||j| d|j tjt|j } |5|d dddn #1swxYwY|jd nC#tj$r1}|jt'|Yd}~nd}~wwxYw|n#|wxYw||j |d t. n<#tj$r*||wxYw| |jddS)Nzif 1: import sqlite3 def wait(): print("started") assert "database is locked" in input() cx = sqlite3.connect("z ", timeout=a) cx.create_function("wait", 0, wait) with cx: cx.execute("create table t(t)") try: # execute two transactions; both will try to lock the db cx.executescript(''' -- start a transaction and wait for parent begin transaction; select * from t; select wait(); rollback; -- start a new transaction; would fail if parent holds lock begin transaction; select * from t; rollback; ''') finally: cx.close() z-czutf-8r)encodingbufsizestdinstdoutstarted)timeoutzinsert into t values('test')zno errorend)inputrp)rCONNECTION_TIMEOUT subprocessPopenr executablePIPEr communicater,rnreadlinestriprrr!rmr@rNrrJr returncoderTimeoutExpiredkill)r/SCRIPTprocrr$s r&test_ctx_mgr_rollback_if_commit_failedz8MultiprocessTests.test_ctx_mgr_rollback_if_commit_failed5s] $*   7;6M    : ^T6 */?     ())) DK$8$8$:$:$@$@$B$BCCC ^FD,C D D D  ; ; 9::: ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; J  Z ( ( ( (& ' ' ' J  SXX & & & & & & & & ' HHJJJJBHHJJJJ $/***    5-  @ @ @ @(    IIKKK         !,,,,,s`D C, D,C00D3C04D7E*E!'E E* EE**FF;;9G4N)r8r9r:rrsrKrr=r rrhrh.s=&.>->->->->-r rh__main__)7rrsqlite3rrtrrr; urllib.parser test.supportrrrrrrr _testcapir r r r rtest.support.os_helperrrrrrrcontextmanagerrr(TestCaser*r?rrr rrrr*rrequires_working_threadingrrrrrBrIrhr8mainr=r rrs.  *)))))))))))))++++++++++YYYYYYYYYYYYYY"""   8%%%%fIfIfIfIfI(#fIfIfIR ]=]=]=]=]=h']=]=]=@-----8#4---(WWV. <<133,,,,,,,,,,X&,,,,33,,^V:V:V:V:V:!V:V:V:r[4[4[4[4[4(#[4[4[4| )))))!)))D -,..M6M6M6M6M6(#M6M6/.M6`"""""x(""",QNQNQNQNQNX&QNQNQNfAAAAAX&AAAF     X&   &ZPZPZPZPZPH-ZPZPZPzD-D-D-D-D-)D-D-D-N zHMOOOOOr