*--c8|jdSN)r closers rtearDownzRegressionTests.tearDown&s rcb|j}|ddS)Nzpragma user_version)r cursorexecutercurs rtest_pragma_user_versionz(RegressionTests.test_pragma_user_version)s,hoo )*****rcNtjdtj} |j}|d||dS#||wxYw)Nr  detect_typeszpragma schema_version)r r PARSE_COLNAMESr rrrrr rs rtest_pragma_schema_versionz*RegressionTests.test_pragma_schema_version.snZf6KLLL (//##C KK/ 0 0 0 IIKKK IIKKKKK IIKKK IIKKKKs .A::*B$ctjddfdtdD}|ddtdD]5}|ddd tdD6tdD]#}||d |zd z$dS) Nr )cached_statementsc8g|]}S)r).0xr s r z8RegressionTests.test_statement_reset..=s!222A3::<<222rrzcreate table test(x) insert into test(x) values (?)cg|]}|fSr'r'r(r)s rr*z8RegressionTests.test_statement_reset..@sE^E^E^qqdE^E^E^r zselect x from test)r r ranger executemanyrollback)rcursorsir s @rtest_statement_resetz$RegressionTests.test_statement_reset8snZ1===2222q222 1222r ` `A AJ " "#CE^E^TYZ\T]T]E^E^E^ _ _ _ _q ? ?A AJ  sQw)== > > > > rc(|j}|d||jddd|d||jddddS)Nz select 1 as "foo bar [datetime]"rzfoo bar [datetime]zselect 1 as "foo baz"zfoo baz)r rr assertEqual descriptionrs rtest_column_name_with_spacesz,RegressionTests.test_column_name_with_spacesGshoo 6777 +A.0DEEE +,,, +A. :::::rctjd}g}tdD]P}|}|||dt |zQ|dS)Nr izselect 1 x union select )r r r0rappendrstrr)rr r3r4rs r'test_statement_finalization_on_close_dbz7RegressionTests.test_statement_finalization_on_close_dbOs~ nZ((s = =A**,,C NN3    KK2SVV; < < < < rctjd}|d|d |dn#tj$rYnwxYw|d |dS#tj$r|dYdSwxYw)Nr z3create table foo(x, unique(x) on conflict rollback)zinsert into foo(x) values (1)zinsert into foo(x) values (2)z1pysqlite knew nothing about the implicit ROLLBACK)r r r DatabaseErrorcommitOperationalErrorfailrr s rtest_on_conflict_rollbackz)RegressionTests.test_on_conflict_rollback]snZ(( IJJJ 3444  KK7 8 8 8 8#    D  3444 K JJLLLLL& K K K III J J J J J J Ks$AA('A(B$B?>B?c |jd|jd|jddS)Ncreate table foo(bar)drop table foor rrs r2test_workaround_for_buggy_sqlite_transfer_bindingszBRegressionTests.test_workaround_for_buggy_sqlite_transfer_bindingsksT  0111 )*** 011111rc< |jddSNrIrs rtest_empty_statementz$RegressionTests.test_empty_statementts%  rc d}tjdtj}|}|d|dt jf|||d|d|d||dS) Nzselect * from foor rzcreate table foo(bar timestamp)zinsert into foo(bar) values (?)rHzcreate table foo(bar integer)insert into foo(bar) values (5))r r PARSE_DECLTYPESrrdatetimenow)rSELECTr rs rtest_type_map_usagez#RegressionTests.test_type_map_usage{s %nZV5KLLLjjll 5666 58I8M8M8O8O7QRRR F $%%% 3444 5666 Frc:Gfdd}|dgtjdtj}|d|t 5|dddddS#1swxYwYdS)NceZdZfdZdS)2RegressionTests.test_bind_mutating_list..Xc0dS)Nz...)clear)rprotocol parameterss r __conform__z>RegressionTests.test_bind_mutating_list..X.__conform__s  """urN)__name__ __module__ __qualname__r])r\srXrXs.       rrarr rz$create table foo(bar X, baz integer)z'insert into foo(bar, baz) values (?, ?))r r rQr assertRaises IndexError)rrar r\s @rtest_bind_mutating_listz'RegressionTests.test_bind_mutating_lists          acc1X nZV5KLLL :;;;   z * * O O KKA: N N N O O O O O O O O O O O O O O O O O Os,BBBc Z|tj5}|jdt t dgfdddn #1swxYwYd}||t|j dS)Nz"select 'xxx' || ? || 'yyy' colnamez9Could not decode to UTF-8 column 'colname' with text 'xxx) rbr rBr rbytes bytearrayfetchoneassertInr= exception)rcmmsgs rtest_error_msg_decode_errorz+RegressionTests.test_error_msg_decode_errors  v6 7 7 D2 H  A#Ise$4$4557 9 99A D D D D D D D D D D D D D D DJ c3r|,,-----sA A66A:=A:cV |ttjiddSr)rb TypeErrorr register_adapterrs rtest_register_adapterz%RegressionTests.test_register_adapters,  )V%.CustomStrcdSrr'rs rupperzARegressionTests.test_set_isolation_level..CustomStr.upperstrcd_dSrLisolation_levelrDs r__del__zCRegressionTests.test_set_isolation_level..CustomStr.__del__s&(###rN)r^r_r`rwr{)r sr CustomStrrus=    ) ) ) ) ) ) )rr|r )rMDEFERRED IMMEDIATE EXCLUSIVE)levelr}rabczIMMEDIATEEXCLUSIVEé) r=r r rzsubTestlower capitalizerp ValueErrorrbr7)rr|rpairsvalueexcr s @rtest_set_isolation_levelz(RegressionTests.test_set_isolation_levelsl ) ) ) ) ) ) ) ) ) ) nZ(("= 7 7EE** 7 7&+#&+kkmm#&+&6&6&8&8#&/i&6&6#  7 7 7 7 7 7 7 7 7 7 7 7 7 7 7#(  NS),uj.A #Z 06:2F   B BJE3E** B B&&s++00*/C'000000000000000  !4jAAA B B B B B B B B B B B B B B B B BsI A B""B& )B& ED-! E-D1 1E4D1 5EE# &E# c Gddtj}tjd}||}|tj5|ddddn #1swxYwY|tjd5|ddddS#1swxYwYdS)NceZdZdZdS)BRegressionTests.test_cursor_constructor_call_check..CursorcdSrr'rDs r__init__zKRegressionTests.test_cursor_constructor_call_check..Cursor.__init__rNr^r_r`rr'rrCursorr#     rrr z select 4+5z$^Base Cursor\.__init__ not called\.$) r rr rbProgrammingErrorrfetchallassertRaisesRegexr)rrr rs r"test_cursor_constructor_call_checkz2RegressionTests.test_cursor_constructor_call_checksl      V]   nZ((fSkk   v6 7 7 1 1 KK % % . . 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1  # #F$;$KMM   IIKKK                  s$(B  BB7CC Ccx Gddt}|jd|dfdS)NceZdZdS)0RegressionTests.test_str_subclass..MyStrN)r^r_r`r'rrMyStrrsrrzselect ?r)r=r r)rrs rtest_str_subclassz!RegressionTests.test_str_subclasssK  C eeEll_55555rc Gddtj}|d}|tj5|}ddddS#1swxYwYdS)NceZdZdZdS)JRegressionTests.test_connection_constructor_call_check..ConnectioncdSrr')rnames rrzSRegressionTests.test_connection_constructor_call_check..Connection.__init__rrNrr'rr Connectionrrrrr )r rrbrr)rrr rs r&test_connection_constructor_call_checkz6RegressionTests.test_connection_constructor_call_checks      *   j$$   v6 7 7  **,,C                  sA&&A*-A*c4 tjdd}dS)Nr ry)r r rDs rtest_auto_commitz RegressionTests.test_auto_commits! nZ>>>rc |j}|d|d|d|}dS)NrGrPzpragma page_size)r rrri)rrrows rtest_pragma_autocommitz&RegressionTests.test_pragma_autocommitsd hoo +,,, 5666 &'''llnnrcJ |t|jddS)Nsselect 1)rbrpr rs rtest_connection_callz$RegressionTests.test_connection_calls)  )TX{;;;;;rcZd}|t|jjd|dS)NcdS)Nrr')abs r collation_cbz4RegressionTests.test_collation..collation_cbs1ru)rbUnicodeEncodeErrorr create_collation)rrs rtest_collationzRegressionTests.test_collationsB    ,dh.G l $ $ $ $ $rcx tjd}|ddfd}|tj5dd|DddddS#1swxYwYdS)Nr zcreate table a (bar)zcreate table b (baz)c3@KdddVdS)Nzinsert into a (bar) values (?))rrr)rsrfooz6RegressionTests.test_recursive_cursor_use..foos) KK8$ ? ? ?GGGGGrzinsert into b (baz) values (?)c3K|]}|fVdSrr')r(r4s r z.s$11aaT111111r)r r rrrbrr1)rr rrs @rtest_recursive_cursor_usez)RegressionTests.test_recursive_cursor_use s nZ((jjll *+++ *+++       v6 7 7 3 3 OO<113355111 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3s9)B//B36B3c  tjdtj}|}|d|d|d|dd|D}||tjdd d d d d d tjdd d d d d dgdS)Nr rzCREATE TABLE t (x TIMESTAMP)z4INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.456')z:INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.123456789')zSELECT * FROM tcg|] }|d S)rr'r.s rr*zNRegressionTests.test_convert_timestamp_microsecond_padding..4s///1!A$///riri@i@)r r rQrrrr7rR)rr rvaluess r*test_convert_timestamp_microsecond_paddingz:RegressionTests.test_convert_timestamp_microsecond_padding!s nZf6LMMMjjll 2333 JKKK PQQQ %&&&// ///   dAq"aF ; ;  dAq"aF ; ;"      rcV|ttjdddS)Nr {ry)rbrpr r rs r!test_invalid_isolation_level_typez1RegressionTests.test_invalid_isolation_level_type;s9 ) .*c  K K K K Krc|j}ddg}|D]}||5|tjd|jj|dddn #1swxYwY||5|tjd|j|dddn #1swxYwYdS)Nz select 1z select 1)queryz null char)r rrrr rr)rrqueriesrs rtest_null_characterz#RegressionTests.test_null_characterAsnhoo. ; ;EE** @ @&&v'> '+x'7@@@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @E** ; ;&&v'> '*{E;;; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;  ; ;s#-A11A5 8A5 (CC C cJtjd}|t|d|t|d|}|t|jd|t|jddS)Nr u select ''u select '')r r rbrrrr!s rtest_surrogateszRegressionTests.test_surrogatesMsnZ(( ,c3DEEE ,c3DEEEjjll ,ck;LMMM ,ck;LMMMMMrcd}t5}t|5}|}|d||d|d|dz}|t j||||t j||j|dddn #1swxYwYddddS#1swxYwYdS)Nzquery string is too largeselect 1zselect 2zselect 3r)rrrljustrrr DataError)rrmcxlimcusqls rtest_large_sqlzRegressionTests.test_large_sqlUs)    K"hrll KcB Bz$$ % % % JJz'',, - - -""3q5))C  " "6#3S"c B B B  " "6#3S"*c J J J K K K K K K K K K K K K K K K K K K K K K K K K K K K K K K K K Ks5DB >??  FAss++   :QDAAA a<<$$SVQ////\\$$SVQ////\\$$SVQ///1                 !%NOOOOOsBD++D/ 2D/ c d}tjd}tj|}tj||}||~~t jdS)NcdSrr')argss rcallbackz/RegressionTests.test_bpo31770..callbacks Drr )r r rweakrefrefrr gc_collect)rrr rrs r test_bpo31770zRegressionTests.test_bpo31770sr    nZ((mC  k#x(( S  rcz|t5|j`ddddS#1swxYwYdSr)rbAttributeErrorr rzrs r!test_del_isolation_level_segfaultz1RegressionTests.test_del_isolation_level_segfaults   ~ . . ) )( ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) )s 044c2Gdd}|jjtj|jjd|jjfD]Q}|}||j||j|jd|dRdS)NceZdZdZdS).RegressionTests.test_bpo37347..PrinterctjSr)r SQLITE_OK)rrs rlogz2RegressionTests.test_bpo37347..Printer.logs ''rN)r^r_r`rr'rrPrinterrs# ( ( ( ( (rrr)nr)r set_trace_callback functoolspartialset_progress_handlerset_authorizerrr)rrmethodprinter_instances r test_bpo37347zRegressionTests.test_bpo37347s ( ( ( ( ( ( ( (x2 ()F!LLLx.0  F 'wyy  F#' ( ( ( F#' ( ( ( H  Z ( ( ( F4LLLL  rc|jd}|d}||ddS)Nz select X''rr)r rrir7)rrvals rtest_return_empty_bytestringz,RegressionTests.test_return_empty_bytestringsEh|,,llnnQ c"""""rct5}|}|d|ddt dD||d|d|ddddS#1swxYwYdS)Ncreate table t(t)insert into t values(?)c3K|]}|fVdSrr'r(vs rrzFRegressionTests.test_table_lock_cursor_replace_stmt..$44aaT444444rr$select t from t drop table t)rrrr1r0rAr!s r#test_table_lock_cursor_replace_stmtz3RegressionTests.test_table_lock_cursor_replace_stmts    #**,,C KK+ , , , OO544588444 6 6 6 JJLLL KK) * * * KK ' ' ' JJLLL                  sB)CC  C c~t5}|d|ddtdD||d}~|d|ddddS#1swxYwYdS)Nrrc3K|]}|fVdSrr'rs rrzARegressionTests.test_table_lock_cursor_dealloc..rrr$rr)rrr1r0rAr!s rtest_table_lock_cursor_deallocz.RegressionTests.test_table_lock_cursor_deallocs    # KK+ , , , OO544588444 6 6 6 JJLLL++/00C KK ' ' ' JJLLL                  sBB22B69B6ct5dddtdDfd}dd|d}~d ddddS#1swxYwYdS) Nrrc3K|]}|fVdSrr'rs rrzMRegressionTests.test_table_lock_cursor_non_readonly_select..rrr$c6d|fdS)Nrr)rr s rdupzGRegressionTests.test_table_lock_cursor_non_readonly_select..dups 5t<<<rr rzselect dup(t) from tr)rrr1r0rAcreate_function)rr rr s @r*test_table_lock_cursor_non_readonly_selectz:RegressionTests.test_table_lock_cursor_non_readonly_selects'    # KK+ , , , OO544588444 6 6 6 JJLLL        q# . . .++455C KK ' ' ' JJLLL                  sB2CCCct5}dtdD}|5|d|d|dddn #1swxYwYg|ddfd|d||ddddS#1swxYwYdS) Ncg|]}|fSr'r'rs rr*zJRegressionTests.test_executescript_step_through_select..s---qqd---rr$rrsteprc0|fSr)r<)r)stepss rzHRegressionTests.test_executescript_step_through_select..sU\\1$5G5Grzselect step(t) from t)rr0rr1r rr7)rr rrs @r&test_executescript_step_through_selectz6RegressionTests.test_executescript_step_through_selectsq    ,#--E!HH---F C C /000 96BBB C C C C C C C C C C C C C C CE   +G+G+G+G H H H   5 6 6 6   UF + + + , , , , , , , , , , , , , , , , , ,s5C,A$ C$A( (C+A( ,A CC CcGddtj}t5}||}|~ddddS#1swxYwYdS)NceZdZfdZxZS)JRegressionTests.test_custom_cursor_object_crash_gh_99886..MyCursorcHtj|i|d|_dSr)superr some_attr)rrkwargs __class__s rrzSRegressionTests.test_custom_cursor_object_crash_gh_99886..MyCursor.__init__s*  $1&111!%r)r^r_r`r __classcell__)rs@rMyCursorrs8 & & & & & & & & &rr)r rrrr)rrr rs r(test_custom_cursor_object_crash_gh_99886z8RegressionTests.test_custom_cursor_object_crash_gh_99886s & & & & &v} & & &    #**X&&C IIKKK                  s+AA#&A#N))r^r_r`rrrr"r5r9r>rErJrNrUrdrnrrrrrrrrrrrrrrrrrrrrrrrr rrr'rrrr"sf...+++    ;;;    K K K222 O O O...HHH BBB<"666   ???   <<<$$$333*   4KKK ; ; ;NNN K K KPPP> )))   ###          , , ,     rrc0eZdZdZdZdZdZdZdZdS)RecursiveUseOfCursorsz$Recursive use of cursors not allowedctjdtj|_|j|_|jd|jdddgdS)Nr rzcreate table test(x foo)r,)r)bar)r r r r rrrr1rs rrzRecursiveUseOfCursors.setUps~>*/5/DFFF8??$$ 3444 =&1 3 3 3 3 3rcj|j|jdSr)rrr rs rrzRecursiveUseOfCursors.tearDowns,  rcfd}tjtjd|i5jdtjjjj ddddS#1swxYwYdS)NcBjjSr)rrr r)rs rrzBRecursiveUseOfCursors.test_recursive_cursor_init..s**4844rINITz#select x as "x [INIT]", x from test rdictr convertersrrrrrmrrconvs` rtest_recursive_cursor_initz0RecursiveUseOfCursors.test_recursive_cursor_inits4444 Z)FD> : : 6 6 H  C D D D  " "6#:DH#'8#4 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6A BBBcfd}tjtjd|i5jdtjjjj ddddS#1swxYwYdS)Nc6jSr)rrr%s rrzCRecursiveUseOfCursors.test_recursive_cursor_close..s))rCLOSEz$select x as "x [CLOSE]", x from testr'r*s` rtest_recursive_cursor_closez1RecursiveUseOfCursors.test_recursive_cursor_closes)))) Z)GT? ; ; 6 6 H  D E E E  " "6#:DH#'8#4 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6r-cgffd }tjtjd|i5jdtjjjj ddddS#1swxYwYdS)Ncd|rjn|dSr)rrir<)r)lrs rrzBRecursiveUseOfCursors.test_recursive_cursor_iter..s)aKtx00222QXXd^^rITERz#select x as "x [ITER]", x from testr'r*s` rtest_recursive_cursor_iterz0RecursiveUseOfCursors.test_recursive_cursor_itersKKKKK Z)FD> : : 6 6 H  C D D D  " "6#:DH#'8#4 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6sA BB BN) r^r_r`rmrrr,r1r6r'rrrrsd 0C33366666666666rr__main__)rRunittestsqlite3r rrtestr unittest.mockrtest.test_sqlite3.test_dbapirrTestCaserrr^mainr'rrr?s.BBBBBBBBAAAAAh'AAAF#6#6#6#6#6H-#6#6#6L zHMOOOOOr