*--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)zm pysqlite would crash with older SQLite versions unless a workaround is implemented. create table foo(bar)drop table fooNr rrs r2test_workaround_for_buggy_sqlite_transfer_bindingszBRegressionTests.test_workaround_for_buggy_sqlite_transfer_bindingsksO 0111 )*** 011111rc:|jddS)z pysqlite used to segfault with SQLite versions 3.5.x. These return NULL for "no-operation" statements NrIrs rtest_empty_statementz$RegressionTests.test_empty_statementts rcd}tjdtj}|}|d|dt jf|||d|d|d||d S) z pysqlite until 2.4.1 did not rebuild the row_cast_map when recompiling a statement. This test exhibits the problem. zselect * from foor rzcreate table foo(bar timestamp)zinsert into foo(bar) values (?)rHzcreate table foo(bar integer)insert into foo(bar) values (5)N)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[srXrWs.       rr`rr rz$create table foo(bar X, baz integer)z'insert into foo(bar, baz) values (?, ?))r r rPr assertRaises IndexError)rr`r 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) rar 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:cT|ttjiddS)z! See issue 3312. N)ra TypeErrorr register_adapterrs rtest_register_adapterz%RegressionTests.test_register_adapters' )V%.CustomStrcdSrr'rs rupperzARegressionTests.test_set_isolation_level..CustomStr.upperstrcd_dS)NrLisolation_levelrDs r__del__zCRegressionTests.test_set_isolation_level..CustomStr.__del__s&(###rN)r]r^r_rvrz)r sr CustomStrrts=    ) ) ) ) ) ) )rr{r )rLDEFERRED IMMEDIATE EXCLUSIVE)levelr|rabczIMMEDIATEEXCLUSIVEé) r=r r rysubTestlower capitalizero ValueErrorrar7)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# cGddtj}tjd}||}|tj5|ddddn #1swxYwY|tjd5|ddddS#1swxYwYdS)zd Verifies that cursor methods check whether base class __init__ was called. ceZdZdZdS)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+5Nz$^Base Cursor\.__init__ not called\.$) r rr raProgrammingErrorrfetchallassertRaisesRegexr)rrr rs r"test_cursor_constructor_call_checkz2RegressionTests.test_cursor_constructor_call_checksg      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  BB6CCCcvGddt}|jd|dfdS)za The Python 3.0 port of the module didn't cope with values of subclasses of str. ceZdZdS)0RegressionTests.test_str_subclass..MyStrN)r]r^r_r'rrMyStrrsrrzselect ?rN)r=r r)rrs rtest_str_subclassz!RegressionTests.test_str_subclasssF C eeEll_55555rcGddtj}|d}|tj5|}ddddS#1swxYwYdS)zh Verifies that connection methods check whether base class __init__ was called. ceZdZdZdS)JRegressionTests.test_connection_constructor_call_check..ConnectioncdSrr')rnames rrzSRegressionTests.test_connection_constructor_call_check..Connection.__init__rrNrr'rr Connectionrrrrr N)r rrarr)rrr rs r&test_connection_constructor_call_checkz6RegressionTests.test_connection_constructor_call_checks      *   j$$   v6 7 7  **,,C                  sA%%A),A)c2tjdd}dS)z Verifies that creating a connection in autocommit mode works. 2.5.3 introduced a regression so that these could no longer be created. r Nrx)r r rDs rtest_auto_commitz RegressionTests.test_auto_commits nZ>>>rc|j}|d|d|d|}dS)z Verifies that running a PRAGMA statement that does an autocommit does work. This did not work in 2.5.3/2.5.4. rGrOzpragma page_sizeN)r rrrh)rrrows rtest_pragma_autocommitz&RegressionTests.test_pragma_autocommits_ hoo +,,, 5666 &'''llnnrcH|t|jddS)z} Call a connection with a non-string SQL request: check error handling of the statement constructor. sselect 1N)raror rs rtest_connection_callz$RegressionTests.test_connection_calls$ )TX{;;;;;rcZd}|t|jjd|dS)NcdS)Nrr')abs r collation_cbz4RegressionTests.test_collation..collation_cbs1ru)raUnicodeEncodeErrorr create_collation)rrs rtest_collationzRegressionTests.test_collationsB    ,dh.G l $ $ $ $ $rcvtjd}|ddfd}|tj5dd|DddddS#1swxYwYdS)z http://bugs.python.org/issue10811 Recursively using a cursor, such as when reusing it from a generator led to segfaults. Now we catch recursive cursor usage and raise a ProgrammingError. r 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$11aaT111111rN)r r rrrarr1)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 3s8)B..B25B2c tjdtj}|}|d|d|d|dd|D}||tjdd d d d d d tjdd d d d d dgdS)z http://bugs.python.org/issue14720 The microsecond parsing of convert_timestamp() should pad with zeros, since the microsecond string "456" actually represents "456000". r 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@N)r r rPrrrr7rQ)rr rvaluess r*test_convert_timestamp_microsecond_paddingz:RegressionTests.test_convert_timestamp_microsecond_padding!snZf6LMMMjjll 2333 JKKK PQQQ %&&&// ///   dAq"aF ; ;  dAq"aF ; ;"      rcV|ttjdddS)Nr {rx)raror 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 rarrrr!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)rrlcxlimcusqls 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. 1D. cd}tjd}tj|}tj||}||~~t jdS)zm The interpreter shouldn't crash in case Cursor.__init__() is called more than once. cdSrr')argss rcallbackz/RegressionTests.test_bpo31770..callbacks Drr N)r r rweakrefrefrr gc_collect)rrr rrs r test_bpo31770zRegressionTests.test_bpo31770sm    nZ((mC  k#x(( S  rcz|t5|j`ddddS#1swxYwYdSr)raAttributeErrorr ryrs 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 rrhr7)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<<<rrrzselect dup(t) from tr)rrr1r0rAcreate_function)rrrr 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>rErJrMrTrcrmrqrrrrrrrrrrrrrrrrrrrrrr 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 convertersrrrrrlrrconvs` 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)rrhr<)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_rlrrr+r0r5r'rrrrsd 0C33366666666666rr__main__)rQunittestsqlite3r rrtestr unittest.mockrtest.test_sqlite3.test_dbapirrTestCaserrr]mainr'rrr>s.BBBBBBBBAAAAAh'AAAF#6#6#6#6#6H-#6#6#6L zHMOOOOOr