; "Ic@shddlZddlZddlZGddejZdZdZedko endS(iNcBs|EeZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdS(cCstjd|_dS(Nu:memory:(usqliteuconnectucon(uself((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyusetUpscCs|jjdS(N(uconuclose(uself((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyutearDown scCs |jj}|jddS(Nupragma user_version(uconucursoruexecute(uselfucur((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckPragmaUserVersion#scCsTtjddtj}z |jj}|jdWd|j|jXdS(Nu:memory:u detect_typesupragma schema_version(usqliteuconnectuPARSE_COLNAMESuconucursoruexecuteuclose(uselfuconucur((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckPragmaSchemaVersion(s  cstjdddfdtdD}|djdx8tdD]*}|djdd tdDqOWx-tdD]}||jd |d qWjdS( Nu:memory:ucached_statementsics!g}|]}|jq S((ucursor(u.0u_[1]ux(ucon(u4/mit/python/lib/python3.0/sqlite3/test/regression.pyu 7s iucreate table test(x)i uinsert into test(x) values (?)cSsg}|]}||fq S(((u.0u_[1]ux((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyu :s u uselect x from test(usqliteuconnecturangeuexecuteu executemanyurollback(uselfucursorsui((uconu4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckStatementReset2s ( cCsc|jj}|jd|j|jddd|jd|j|jddddS(Nu select 1 as "foo bar [datetime]"iufoo baruselect 1 as "foo baz"ufoo baz(uconucursoruexecuteufailUnlessEqualu description(uselfucur((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckColumnNameWithSpacesAs   cCsStjddtj}|j}|jd|j|j|jdS(Nu:memory:u detect_typesuselect 4 union select 5(usqliteuconnectuPARSE_DECLTYPESucursoruexecuteucloseufetchone(uselfuconucur((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckStatementAvailableIs     cCsjtjd}g}xDtdD]6}|j}|j||jdt|q"W|jdS(Nu:memory:iiuselect 1 x union select (usqliteuconnecturangeucursoruappenduexecuteustruclose(uselfuconucursorsuiucur((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyu#CheckStatementFinalizationOnCloseDbSs   cCstjdkodStjd}|jd|jdy|jdWntjk oYnX|jdy|jWn$tjk o|jdYnXdS( Niiu:memory:u3create table foo(x, unique(x) on conflict rollback)uinsert into foo(x) values (1)uinsert into foo(x) values (2)u1pysqlite knew nothing about the implicit ROLLBACK(iii(usqliteusqlite_version_infouconnectuexecuteu DatabaseErrorucommituOperationalErrorufail(uselfucon((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckOnConflictRollbackas   cCs4|jjd|jjd|jjddS(um pysqlite would crash with older SQLite versions unless a workaround is implemented. ucreate table foo(bar)udrop table fooN(uconuexecute(uself((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyu-CheckWorkaroundForBuggySqliteTransferBindingsqscCs|jjddS(u pysqlite used to segfault with SQLite versions 3.5.x. These return NULL for "no-operation" statements uN(uconuexecute(uself((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckEmptyStatementzscCsd}tjddtj}|jd|jdtjjf|j||jd|jd|jd|j|d S( u pysqlite until 2.4.1 did not rebuild the row_cast_map when recompiling a statement. This test exhibits the problem. uselect * from foou:memory:u detect_typesucreate table foo(bar timestamp)uinsert into foo(bar) values (?)udrop table fooucreate table foo(bar integer)uinsert into foo(bar) values (5)N(usqliteuconnectuPARSE_DECLTYPESuexecuteudatetimeunow(uselfuSELECTucon((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckTypeMapUsages     c Csd}y5|jjdttdgfjd}WnQtjk oB}z,|jd}|j dp d}nWYdd}~XnX|o|j |ndS(Nu"select 'xxx' || ? || 'yyy' colnameiu@should have raised an OperationalError with detailed descriptioniu9Could not decode to UTF-8 column 'colname' with text 'xxxu7OperationalError did not have expected description text( uNoneuconuexecuteubytesu bytearrayufetchoneusqliteuOperationalErroruargsu startswithufail(uselfufailureueumsg((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckErrorMsgDecodeErrors   cCs|jttjiddS(u! See issue 3312. N(u assertRaisesu TypeErrorusqliteuregister_adapteruNone(uself((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckRegisterAdapterscCs#tjd}t|dddS(u! See issue 3312. u:memory:uisolation_leveluéN(usqliteuconnectusetattr(uselfucon((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckSetIsolationLevelscCs3Gddt}|jjd|dfdS(ua The Python 3.0 port of the module didn't cope with values of subclasses of str. cBs|EeZdS(N(u__name__u __module__(u __locals__((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuMyStrs uMyStruselect ?uabcN(ustruconuexecute(uselfuMyStr((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuCheckStrSubclasssN(u__name__u __module__usetUputearDownuCheckPragmaUserVersionuCheckPragmaSchemaVersionuCheckStatementResetuCheckColumnNameWithSpacesuCheckStatementAvailableu#CheckStatementFinalizationOnCloseDbuCheckOnConflictRollbacku-CheckWorkaroundForBuggySqliteTransferBindingsuCheckEmptyStatementuCheckTypeMapUsageuCheckErrorMsgDecodeErroruCheckRegisterAdapteruCheckSetIsolationLeveluCheckStrSubclass(u __locals__((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyuRegressionTestss             uRegressionTestscCs"tjtd}tj|fS(NuCheck(uunittestu makeSuiteuRegressionTestsu TestSuite(uregression_suite((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyusuitescCs tj}|jtdS(N(uunittestuTextTestRunnerurunusuite(urunner((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyutests u__main__( udatetimeuunittestusqlite3usqliteuTestCaseuRegressionTestsusuiteutestu__name__(((u4/mit/python/lib/python3.0/sqlite3/test/regression.pyus