Kc@skddkZddkZddkZdeifdYZdZdZedjo endS(iNtRegressionTestscBseZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZRS(cCstid|_dS(Ns:memory:(tsqlitetconnecttcon(tself((s-scripts/common/Lib/sqlite3/test/regression.pytsetUpscCs|iidS(N(Rtclose(R((s-scripts/common/Lib/sqlite3/test/regression.pyttearDown scCs |ii}|iddS(Nspragma user_version(Rtcursortexecute(Rtcur((s-scripts/common/Lib/sqlite3/test/regression.pytCheckPragmaUserVersion#scCsTtiddti}z |ii}|idWd|i|iXdS(Ns:memory:t detect_typesspragma schema_version(RRtPARSE_COLNAMESRRR R(RRR ((s-scripts/common/Lib/sqlite3/test/regression.pytCheckPragmaSchemaVersion(s  c Cstiddd}g}tdD]}||iq&~}|didxLtdD]>}|didg}tdD]}||fq~q`Wx-tdD]}||id|d qW|idS( Ns:memory:tcached_statementsiiscreate table test(x)i sinsert into test(x) values (?)t sselect x from test(RRtxrangeRR tranget executemanytrollback(RRt_[1]txtcursorstit_[2]((s-scripts/common/Lib/sqlite3/test/regression.pytCheckStatementReset2s- < cCsc|ii}|id|i|iddd|id|i|iddddS(Ns select 1 as "foo bar [datetime]"isfoo barsselect 1 as "foo baz"sfoo baz(RRR tfailUnlessEqualt description(RR ((s-scripts/common/Lib/sqlite3/test/regression.pytCheckColumnNameWithSpacesAs   cCsStiddti}|i}|id|i|i|idS(Ns:memory:R sselect 4 union select 5(RRtPARSE_DECLTYPESRR Rtfetchone(RRR ((s-scripts/common/Lib/sqlite3/test/regression.pytCheckStatementAvailableIs     cCsjtid}g}xDtdD]6}|i}|i||idt|q"W|idS(Ns:memory:iisselect 1 x union select (RRRRtappendR tstrR(RRRRR ((s-scripts/common/Lib/sqlite3/test/regression.pyt#CheckStatementFinalizationOnCloseDbSs   cCstidjodStid}|id|idy|idWntij onX|idy|iWn#tij o|idnXdS( Niis:memory:s3create table foo(x, unique(x) on conflict rollback)sinsert into foo(x) values (1)sinsert into foo(x) values (2)s1pysqlite knew nothing about the implicit ROLLBACK(iii(Rtsqlite_version_infoRR t DatabaseErrortcommittOperationalErrortfail(RR((s-scripts/common/Lib/sqlite3/test/regression.pytCheckOnConflictRollbackas   cCs4|iid|iid|iiddS(sm pysqlite would crash with older SQLite versions unless a workaround is implemented. screate table foo(bar)sdrop table fooN(RR (R((s-scripts/common/Lib/sqlite3/test/regression.pyt-CheckWorkaroundForBuggySqliteTransferBindingsqscCs|iiddS(s pysqlite used to segfault with SQLite versions 3.5.x. These return NULL for "no-operation" statements tN(RR (R((s-scripts/common/Lib/sqlite3/test/regression.pytCheckEmptyStatementzscCstid}|idS(s  With pysqlite 2.4.0 you needed to use a string or a APSW connection object for opening database connections. Formerly, both bytestrings and unicode strings used to work. Let's make sure unicode strings work in the future. u:memory:N(RRR(RR((s-scripts/common/Lib/sqlite3/test/regression.pytCheckUnicodeConnects cCsd}tiddti}|id|idtiif|i||id|id|id|i|d S( s pysqlite until 2.4.1 did not rebuild the row_cast_map when recompiling a statement. This test exhibits the problem. sselect * from foos:memory:R screate table foo(bar timestamp)sinsert into foo(bar) values (?)sdrop table fooscreate table foo(bar integer)sinsert into foo(bar) values (5)N(RRRR tdatetimetnow(RtSELECTR((s-scripts/common/Lib/sqlite3/test/regression.pytCheckTypeMapUsages     cCs|ittihddS(s! See issue 3312. N(t assertRaisest TypeErrorRtregister_adaptertNone(R((s-scripts/common/Lib/sqlite3/test/regression.pytCheckRegisterAdapterscCs,tid}|itt|dddS(s! See issue 3312. s:memory:tisolation_leveluéN(RRR2tUnicodeEncodeErrortsetattr(RR((s-scripts/common/Lib/sqlite3/test/regression.pytCheckSetIsolationLevels(t__name__t __module__RRR RRRR R#R)R*R,R-R1R6R:(((s-scripts/common/Lib/sqlite3/test/regression.pyRs          cCs"titd}ti|fS(NtCheck(tunittestt makeSuiteRt TestSuite(tregression_suite((s-scripts/common/Lib/sqlite3/test/regression.pytsuitescCs ti}|itdS(N(R>tTextTestRunnertrunRB(trunner((s-scripts/common/Lib/sqlite3/test/regression.pyttests t__main__( R.R>tsqlite3RtTestCaseRRBRFR;(((s-scripts/common/Lib/sqlite3/test/regression.pyts