ó ŚxxTc@s‚ddlZddlZddlZdejfd„ƒYZdejfd„ƒYZd„Zd„Ze dkr~eƒndS( i˙˙˙˙NtCollationTestscBsPeZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z RS(cCsdS(N((tself((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytsetUpscCsdS(N((R((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyttearDownscCsatjdƒ}y!|jddƒ|jdƒWn*tk r\}|j|jddƒnXdS(Ns:memory:tXi*sshould have raised a TypeErrorisparameter must be callable(tsqlitetconnecttcreate_collationtfailt TypeErrort assertEqualtargs(Rtconte((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckCreateCollationNotCallable"s cCsMtjdƒ}y!|jdtƒ|jdƒWntjk rH}nXdS(Ns:memory:scolläs%should have raised a ProgrammingError(RRRtcmpRtProgrammingError(RR R ((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckCreateCollationNotAscii*s cCstjdkrdSd„}tjdƒ}|jd|ƒd}|j|ƒjƒ}|ddd ks’|ddd ks’|ddd kr˘|jd ƒn|jddƒy&|j|ƒjƒ}|jd ƒWn3tjk r }|j |j dj ƒdƒnXdS(NiiicSst||ƒ S(N(R(txty((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytmycoll5ss:memory:RsÉ select x from ( select 'a' as x union select 'b' as x union select 'c' as x ) order by x collate mycoll itctbtas#the expected order was not returneds&should have raised an OperationalErrors"no such collation sequence: mycoll(iii( Rt version_infoRRtexecutetfetchallRtNonetOperationalErrorR R tlower(RRR tsqltresultR ((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckCollationIsUsed2s  <cCsfd„}tjdƒ}|jd|ƒd}|j|ƒjƒ}|j|d d d gdd ƒdS( NcSs||k||k dS(Nii l((RR((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyRPss:memory:RsÉ select x from ( select 'a' as x union select 'b' as x union select 'c' as x ) order by x collate mycoll RRRtmsgs#the expected order was not returned(R(R(R(RRRRRR (RRR RR((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyt!CheckCollationReturnsLargeIntegerOs  cCsƒtjdƒ}|jdtƒ|jdd„ƒ|jdƒjƒ}|dddkso|dddkr|jd ƒnd S( s„ Register two different collation functions under the same name. Verify that the last one is actually used. s:memory:RcSst||ƒ S(N(R(RR((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytissi select x from (select 'a' as x union select 'b' as x) order by x collate mycoll iRiRs wrong collation function is usedN(RRRRRRR(RR R((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckCollationRegisterTwicebs(cCstjdƒ}|jdtƒ|jddƒy|jdƒ|jdƒWn<tjk r‹}|jdj dƒsŒ|jdƒqŒnXdS( su Register a collation, then deregister it. Make sure an error is raised if we try to use it. s:memory:Rs?select 'a' as x union select 'b' as x order by x collate mycolls&should have raised an OperationalErrorisno such collation sequenceswrong OperationalError raisedN( RRRRRRRRR t startswith(RR R ((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckDeregisterCollationps ( t__name__t __module__RRRRR R"R$R&(((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyRs       t ProgressTestscBs,eZd„Zd„Zd„Zd„ZRS(csRtjdƒ}g‰‡fd†}|j|dƒ|jdƒ|jˆƒdS(sK Test that the progress handler is invoked once it is set. s:memory:csˆjdƒdS(Ni(tappendR((tprogress_calls(s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytprogress†s is0 create table foo(a, b) N(RRtset_progress_handlerRt assertTrue(RR R,((R+s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckProgressHandlerUsed€scsœtjdƒ}g‰‡fd†}|j|dƒ|jƒ}|jdƒtˆƒ}g‰|j|dƒ|jdƒtˆƒ}|j||ƒdS(s= Test that the opcode argument is respected. s:memory:csˆjdƒdS(Ni(R*R((R+(s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyR,–s is1 create table foo (a, b) is1 create table bar (a, b) N(RRR-tcursorRtlentassertGreaterEqual(RR R,tcurst first_countt second_count((R+s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckOpcodeCounts   cs]tjdƒ}g‰‡fd†}|j|dƒ|jƒ}|jtj|jdƒdS(sW Test that returning a non-zero value stops the operation in progress. s:memory:csˆjdƒdS(Ni(R*R((R+(s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyR,­s iscreate table bar (a, b)N(RRR-R0t assertRaisesRR(RR R,R3((R+s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckCancelOperation§s csttjdƒ}g‰‡fd†}|j|dƒ|jddƒ|jdƒjƒ|jtˆƒddƒdS(sc Test that setting the progress handler to None clears the previously set handler. s:memory:csˆjdƒdS(Nii(R*((taction(s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyR,˝s is&select 1 union select 2 union select 3is progress handler was not clearedN(RRR-RRRR R1(RR R,((R9s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytCheckClearHandlerˇs(R'R(R/R6R8R:(((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyR)s   cCs7tjtdƒ}tjtdƒ}tj||fƒS(NtCheck(tunittestt makeSuiteRR)t TestSuite(tcollation_suitetprogress_suite((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pytsuiteĹscCs tjƒ}|jtƒƒdS(N(R<tTextTestRunnertrunRA(trunner((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyttestĘs t__main__( tosR<tsqlite3RtTestCaseRR)RARER'(((s>/opt/xtal/ccp4-6.5-linux32/lib/python2.7/sqlite3/test/hooks.pyts dF