Kc@s ddkZddkZddkZddkZdeifdYZdeifdYZdeifdYZdeifd YZ d eifd YZ d eifd YZ deifdYZ dZ dZedjo endS(iNt ModuleTestscBs}eZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d ZRS( cCs!|itiddtidS(Ns2.0sapilevel is %s, should be 2.0(t assertEqualtsqlitetapilevel(tself((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckAPILevelscCs!|itiddtidS(Nisthreadsafety is %d, should be 1(RRt threadsafety(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckThreadSafety"scCs!|itiddtidS(Ntqmarks%paramstyle is '%s', should be 'qmark'(RRt paramstyle(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckParamStyle&scCs |ittitddS(Ns*Warning is not a subclass of StandardError(tassert_t issubclassRtWarningt StandardError(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckWarning+scCs |ittitddS(Ns(Error is not a subclass of StandardError(t failUnlessR RtErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckError/scCs#|ittitiddS(Ns)InterfaceError is not a subclass of Error(RR RtInterfaceErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckInterfaceError3scCs#|ittitiddS(Ns(DatabaseError is not a subclass of Error(RR Rt DatabaseErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckDatabaseError7scCs#|ittitiddS(Ns,DataError is not a subclass of DatabaseError(RR Rt DataErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckDataError;scCs#|ittitiddS(Ns3OperationalError is not a subclass of DatabaseError(RR RtOperationalErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckOperationalError?scCs#|ittitiddS(Ns1IntegrityError is not a subclass of DatabaseError(RR RtIntegrityErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckIntegrityErrorCscCs#|ittitiddS(Ns0InternalError is not a subclass of DatabaseError(RR Rt InternalErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckInternalErrorGscCs#|ittitiddS(Ns3ProgrammingError is not a subclass of DatabaseError(RR RtProgrammingErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckProgrammingErrorKscCs#|ittitiddS(Ns4NotSupportedError is not a subclass of DatabaseError(RR RtNotSupportedErrorR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckNotSupportedErrorOs (t__name__t __module__RRR RRRRRRRRR R"(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRs            tConnectionTestscBsbeZdZdZdZdZdZdZdZdZ dZ d Z RS( cCsBtid|_|ii}|id|idddS(Ns:memory:s4create table test(id integer primary key, name text)s!insert into test(name) values (?)tfoo(sfoo(Rtconnecttcxtcursortexecute(Rtcu((s(scripts/common/Lib/sqlite3/test/dbapi.pytsetUpUs cCs|iidS(N(R(tclose(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyttearDown[scCs|iidS(N(R(tcommit(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckCommit^scCs|ii|iidS(sV A commit should also work when no changes were made to the database. N(R(R/(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckCommitAfterNoChangesas cCs|iidS(N(R(trollback(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckRollbackhscCs|ii|iidS(sX A rollback should also work when no changes were made to the database. N(R(R2(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckRollbackAfterNoChangesks cCs|ii}dS(N(R(R)(RR+((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckCursorrscCsDd}yti|}Wntij odSX|iddS(Ns/foo/bar/bla/23534/mydb.dbs&should have raised an OperationalError(RR'Rtfail(RtYOU_CANNOT_OPEN_THIStcon((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckFailedOpenus cCs|iidS(N(R(R-(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckClose}scCs|i|iiti|i|iiti|i|iiti|i|iiti|i|iiti|i|iiti|i|ii ti |i|ii ti |i|ii ti |i|ii ti dS(N( tfailUnlessEqualR(R RRRRRRRRRR!(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExceptionss( R#R$R,R.R0R1R3R4R5R9R:R<(((s(scripts/common/Lib/sqlite3/test/dbapi.pyR%Ts         t CursorTestscBseZdZdZdZdZdZdZdZdZ 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)Z+d*Z,d+Z-d,Z.RS(-cCsKtid|_|ii|_|iid|iidddS(Ns:memory:sCcreate table test(id integer primary key, name text, income number)s!insert into test(name) values (?)R&(sfoo(RR'R(R)R+R*(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyR,scCs|ii|iidS(N(R+R-R((R((s(scripts/common/Lib/sqlite3/test/dbapi.pyR.s cCs|iiddS(Nsdelete from test(R+R*(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteNoArgsscCsRy!|iid|idWn*tij odS|idnXdS(Ns select asdfs&should have raised an OperationalErrorsraised wrong exception(R+R*R6RR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteIllegalSqlscCsRy!|iid|idWn*tij odS|idnXdS(Nsselect 5+4; select 4+5sshould have raised a Warningsraised wrong exception(R+R*R6RR (R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteTooMuchSqlscCs|iiddS(Nsselect 5+4; -- foo bar(R+R*(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteTooMuchSql2scCs|iiddS(NsT select 5+4; /* foo */ (R+R*(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteTooMuchSql3s cCsOy!|iid|idWn'tj odS|idnXdS(Ni*sshould have raised a ValueErrorsraised wrong exception.(R+R*R6t ValueError(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteWrongSqlArgscCs|iidddS(Nsinsert into test(id) values (?)i*(i*(R+R*(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteArgIntscCs|iidddS(Ns#insert into test(income) values (?)gq= ף@(gq= ף@(R+R*(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteArgFloatscCs|iidddS(Ns!insert into test(name) values (?)tHugo(RG(R+R*(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteArgStringscCsAy$|iidd|idWntij onXdS(Nsinsert into test(id) values (?)itEgons#should have raised ProgrammingError(iRI(R+R*R6RR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteWrongNoOfArgs1s cCs>y!|iid|idWntij onXdS(Nsinsert into test(id) values (?)s#should have raised ProgrammingError(R+R*R6RR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteWrongNoOfArgs2s cCs>y!|iid|idWntij onXdS(Nsinsert into test(id) values (?)s#should have raised ProgrammingError(R+R*R6RR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteWrongNoOfArgs3s cCsM|iid|iiddg|ii}|i|dddS(Ns%insert into test(name) values ('foo')s"select name from test where name=?R&i(R+R*tfetchoneR;(Rtrow((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteParamListscCscdtfdY}|iid|iid||ii}|i|dddS(NtLcBseZdZdZRS(cSsdS(Ni((R((s(scripts/common/Lib/sqlite3/test/dbapi.pyt__len__scSs|djptdS(NiR&(tAssertionError(Rtx((s(scripts/common/Lib/sqlite3/test/dbapi.pyt __getitem__s(R#R$RQRT(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRPs s%insert into test(name) values ('foo')s"select name from test where name=?iR&(tobjectR+R*RMR;(RRPRN((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteParamSequences cCsQ|iid|iidhdd6|ii}|i|dddS(Ns%insert into test(name) values ('foo')s&select name from test where name=:nameR&tnamei(R+R*RMR;(RRN((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteDictMappingscCsxtid jodSdtfdY}|iid|iid||ii}|i|dddS( NiiitDcBseZdZRS(cSsdS(NR&((Rtkey((s(scripts/common/Lib/sqlite3/test/dbapi.pyt __missing__s(R#R$R[(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRYss%insert into test(name) values ('foo')s&select name from test where name=:nameR&(iii(tsyst version_infotdictR+R*RMR;(RRYRN((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteDictMapping_MappingscCsX|iidy+|iidhdd6|idWntij onXdS(Ns%insert into test(name) values ('foo')s1select name from test where name=:name and id=:idR&RWs#should have raised ProgrammingError(R+R*R6RR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyt$CheckExecuteDictMappingTooLittleArgs s cCsN|iidy!|iid|idWntij onXdS(Ns%insert into test(name) values ('foo')s&select name from test where name=:names#should have raised ProgrammingError(R+R*R6RR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteDictMappingNoArgss cCsX|iidy+|iidhdd6|idWntij onXdS(Ns%insert into test(name) values ('foo')s"select name from test where name=?R&RWs#should have raised ProgrammingError(R+R*R6RR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteDictMappingUnnameds cCs|iidS(N(R+R-(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyR:"scCsZ|iid|iid|iid|iid|i|iiddS(Nsdelete from tests%insert into test(name) values ('foo')supdate test set name='bar'i(R+R*R;trowcount(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckRowcountExecute%s cCs*|iid|i|iiddS(s 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. sselect 5 union select 6iN(R+R*R;Rc(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckRowcountSelect,scCsF|iid|iiddddg|i|iiddS( Nsdelete from tests!insert into test(name) values (?)iii(i(i(i(R+R*t executemanyR;Rc(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckRowcountExecutemany5scCsH|iid|iid|iidjo|idndS(Ns%insert into test(name) values ('foo')is"total changes reported wrong value(R+R*R(t total_changesR6(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckTotalChanges:scCs>|iidg}tddD]}||fq ~dS(Ns#insert into test(income) values (?)idin(R+Rftrange(Rt_[1]RS((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteManySequenceDscCs-dddY}|iid|dS(NtMyItercBseZdZdZRS(cSs d|_dS(Ni(tvalue(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyt__init__IscSs7|idjo tn|id7_|ifSdS(Ni i(Rnt StopIteration(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytnextLs (R#R$RoRq(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRmHs s#insert into test(income) values (?)((R+Rf(RRm((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteManyIteratorGs cCs#d}|iid|dS(Ncss#xtdD]}|fVq WdS(Ni(Rj(ti((s(scripts/common/Lib/sqlite3/test/dbapi.pytmygenVs s#insert into test(income) values (?)(R+Rf(RRt((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteManyGeneratorUs cCsUy'|iiddg|idWn'tj odS|idnXdS(Ni*isshould have raised a ValueErrorsraised wrong exception.(i(R+RfR6RC(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteManyWrongSqlArg\scCsXy'|iiddg|idWn*tij odS|idnXdS(Nsselect ?is%should have raised a ProgrammingErrorsraised wrong exception.(i(R+RfR6RR(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteManySelectescCsly$|iidd|idWnAtj odStj o"}dG|iGH|idnXdS(Ns#insert into test(income) values (?)i*sshould have raised a TypeErrortraisedsraised wrong exception.(R+RfR6t TypeErrort Exceptiont __class__(Rte((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckExecuteManyNotIterablens cCs|iid|iidd|iidd |iidg}x"|iD]}|i|dqVW|i|dd|i|dddS( Nsdelete from testsinsert into test(id) values (?)iisselect id from test order by idii(i(i(R+R*tappendR;(RtlstRN((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckFetchIterxs cCsV|iid|ii}|i|dd|ii}|i|ddS(Nsselect name from testiR&(R+R*RMR;tNone(RRN((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckFetchones cCs/|ii}|i}|i|ddS(N(R(R)RMR;R(RtcurRN((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckFetchoneNoStatements cCs|i|iidd|i_|iid|iid|iid|iid|iid|ii}|it|ddS(Niisdelete from tests#insert into test(name) values ('A')s#insert into test(name) values ('B')s#insert into test(name) values ('C')sselect name from test(R;R+t arraysizeR*t fetchmanytlen(Rtres((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckArraySizes cCs^|iid|iid}|it|d|iid}|i|gdS(Nsselect name from testidi(R+R*RR;R(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckFetchmanys cCs?|iid|iidd}|it|ddS(s0Checks if fetchmany works with keyword argumentssselect name from testtsizeidiN(R+R*RR;R(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckFetchmanyKwArgscCsX|iid|ii}|it|d|ii}|i|gdS(Nsselect name from testi(R+R*tfetchallR;R(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckFetchalls cCs|iidddgdS(Niii(R+t setinputsizes(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckSetinputsizesscCs|iidddS(Nii(R+t setoutputsize(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckSetoutputsizescCs|iiddS(Ni*(R+R(R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckSetoutputsizeNoColumnscCs|i|ii|idS(N(R;R+t connectionR((R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckCursorConnectionscCsTy,d}|ii|}|idWntj odSX|iddS(NcSsdS(N((((s(scripts/common/Lib/sqlite3/test/dbapi.pytfssshould have raised a TypeErrorsshould have raised a ValueError(R(R)R6Ry(RRR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckWrongCursorCallables cCsVdddY}|}y ti|}|idWntj onXdS(NtFoocBseZRS((R#R$(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRssshould have raised a ValueError((RtCursorR6Ry(RRR&R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckCursorWrongClasss (/R#R$R,R.R>R?R@RARBRDRERFRHRJRKRLRORVRXR_R`RaRbR:RdReRgRiRlRrRuRvRwR}RRRRRRRRRRRRR(((s(scripts/common/Lib/sqlite3/test/dbapi.pyR=sZ                                 t ThreadTestscBsbeZdZdZdZdZdZdZdZdZ dZ d Z RS( cCs8tid|_|ii|_|iiddS(Ns:memory:s\create table test(id integer primary key, name text, bin binary, ratio number, ts timestamp)(RR'R8R)RR*(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyR,scCs|ii|iidS(N(RR-R8(R((s(scripts/common/Lib/sqlite3/test/dbapi.pyR.s cCs}d}g}tid|dh|id6|d6}|i|it|djo|idi|ndS(NcSsRy!|i}|iddSWn*tij odS|idnXdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R)R~RR(R8terrorsR((s(scripts/common/Lib/sqlite3/test/dbapi.pytruns  ttargettkwargsR8Ris (t threadingtThreadR8tstarttjoinRR6(RRRtt((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckConCursors )  cCs}d}g}tid|dh|id6|d6}|i|it|djo|idi|ndS(NcSsPy|i|iddSWn*tij odS|idnXdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R/R~RR(R8R((s(scripts/common/Lib/sqlite3/test/dbapi.pyRs  RRR8Ris (RRR8RRRR6(RRRR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckConCommits )  cCs}d}g}tid|dh|id6|d6}|i|it|djo|idi|ndS(NcSsPy|i|iddSWn*tij odS|idnXdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R2R~RR(R8R((s(scripts/common/Lib/sqlite3/test/dbapi.pyRs  RRR8Ris (RRR8RRRR6(RRRR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckConRollbacks )  cCs}d}g}tid|dh|id6|d6}|i|it|djo|idi|ndS(NcSsPy|i|iddSWn*tij odS|idnXdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R-R~RR(R8R((s(scripts/common/Lib/sqlite3/test/dbapi.pyRs  RRR8Ris (RRR8RRRR6(RRRR((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckConCloses )  cCs}d}g}tid|dh|id6|d6}|i|it|djo|idi|ndS(NcSsSy"|id|iddSWn*tij odS|idnXdS(Ns#insert into test(name) values ('a')sdid not raise ProgrammingErrorsraised wrong exception(R*R~RR(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pyR's  RRRRis (RRRRRRR6(RRRR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckCurImplicitBegin&s )  cCs}d}g}tid|dh|id6|d6}|i|it|djo|idi|ndS(NcSsPy|i|iddSWn*tij odS|idnXdS(Nsdid not raise ProgrammingErrorsraised wrong exception(R-R~RR(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pyR9s  RRRRis (RRRRRRR6(RRRR((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckCurClose8s )  cCsd}g}|iidtid|dh|id6|d6}|i|it|djo|idi|ndS( NcSsSy"|id|iddSWn*tij odS|idnXdS(Nsselect name from testsdid not raise ProgrammingErrorsraised wrong exception(R*R~RR(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pyRKs  s#insert into test(name) values ('a')RRRRis (RR*RRRRRR6(RRRR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckCurExecuteJs )  cCsd}g}|iid|iidtid|dh|id6|d6}|i|it|djo|id i|ndS( NcSsRy!|i}|iddSWn*tij odS|idnXdS(Nsdid not raise ProgrammingErrorsraised wrong exception(RMR~RR(RRRN((s(scripts/common/Lib/sqlite3/test/dbapi.pyR^s  s#insert into test(name) values ('a')sselect name from testRRRRis (RR*RRRRRR6(RRRR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckCurIterNext]s )  ( R#R$R,R.RRRRRRRR(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRs         tConstructorTestscBsGeZdZdZdZdZdZdZdZRS(cCstiddd}dS(Nii i(RtDate(Rtd((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckDaterscCstiddd}dS(Ni i'i#(RtTime(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckTimeuscCs"tidddddd}dS(Nii ii i'i#(Rt Timestamp(Rtts((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckTimestampxscCstid}dS(Ni*(Rt DateFromTicks(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckDateFromTicks{scCstid}dS(Ni*(Rt TimeFromTicks(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckTimeFromTicks~scCstid}dS(Ni*(RtTimestampFromTicks(RR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckTimestampFromTicksscCstitdd}dS(Nit'(RtBinarytchr(Rtb((s(scripts/common/Lib/sqlite3/test/dbapi.pyt CheckBinarys( R#R$RRRRRRR(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRqs      tExtensionTestscBsGeZdZdZdZdZdZdZdZRS(cCsYtid}|i}|id|id|id}|i|ddS(Ns:memory:s -- bla bla /* a stupid comment */ create table a(i); insert into a(i) values (5); sselect i from aii(RR'R)t executescriptR*RMR;(RR8RR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckScriptStringSqls  cCsYtid}|i}|id|id|id}|i|ddS(Ns:memory:u create table a(i); insert into a(i) values (5); select i from a; delete from a; insert into a(i) values (6); sselect i from aii(RR'R)RR*RMR;(RR8RR((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckScriptStringUnicodes  cCshtid}|i}t}y|idWntij o t}nX|i|tddS(Ns:memory:screate table test(sadfsadfdsasshould have raised an exception(RR'R)tFalseRRtTrueR;(RR8RRx((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckScriptErrorIncompletes  cCshtid}|i}t}y|idWntij o t}nX|i|tddS(Ns:memory:s5create table test(sadfsadfdsa); select foo from hurz;sshould have raised an exception(RR'R)RRRRR;(RR8RRx((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckScriptErrorNormals  cCs?tid}|idid}|i|dddS(Ns:memory:sselect 5iis Basic test of Connection.execute(RR'R*RMR;(RR8tresult((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckConnectionExecutescCstid}|id|idd d g|idi}|i|dddd|i|d ddddS( Ns:memory:screate table test(foo)s insert into test(foo) values (?)iis!select foo from test order by foois$Basic test of Connection.executemanyi(i(i(RR'R*RfRR;(RR8R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckConnectionExecutemanys  cCsLtid}|id|idid}|i|dddS(Ns:memory:s9create table test(foo); insert into test(foo) values (5);sselect foo from testiis&Basic test of Connection.executescript(RR'RR*RMR;(RR8R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckConnectionExecutescripts ( R#R$RRRRRRR(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRs   t ClosedTestscBs>eZdZdZdZdZdZdZRS(cCsdS(N((R((s(scripts/common/Lib/sqlite3/test/dbapi.pyR,scCsdS(N((R((s(scripts/common/Lib/sqlite3/test/dbapi.pyR.scCsftid}|iy|i}|idWn)tij on|idnXdS(Ns:memory:s%Should have raised a ProgrammingError(RR'R-R)R6R(RR8R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckClosedConCursors  cCsdtid}|iy|i|idWn)tij on|idnXdS(Ns:memory:s%Should have raised a ProgrammingError(RR'R-R/R6R(RR8((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckClosedConCommits  cCsdtid}|iy|i|idWn)tij on|idnXdS(Ns:memory:s%Should have raised a ProgrammingError(RR'R-R2R6R(RR8((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckClosedConRollbacks  cCsstid}|i}|iy|id|idWn)tij on|idnXdS(Ns:memory:sselect 4s%Should have raised a ProgrammingError(RR'R)R-R*R6R(RR8R((s(scripts/common/Lib/sqlite3/test/dbapi.pytCheckClosedCurExecutes   (R#R$R,R.RRRR(((s(scripts/common/Lib/sqlite3/test/dbapi.pyRs    cCstitd}titd}titd}titd}titd}titd}titd}ti |||||||fS(NtCheck( tunittestt makeSuiteRR%R=RRRRt TestSuite(t module_suitetconnection_suitet cursor_suitet thread_suitetconstructor_suitet ext_suitet closed_suite((s(scripts/common/Lib/sqlite3/test/dbapi.pytsuitescCs ti}|itdS(N(RtTextTestRunnerRR(trunner((s(scripts/common/Lib/sqlite3/test/dbapi.pyttests t__main__(RR\Rtsqlite3RtTestCaseRR%R=RRRRRRR#(((s(scripts/common/Lib/sqlite3/test/dbapi.pyts    79HC4