³ò œ›\Kc@skddkZddkZddkZdeifd„ƒYZd„Zd„Zedjo eƒndS(iÿÿÿÿNtCollationTestscBsGeZd„Zd„Zd„Zd„Zd„Zd„Zd„ZRS(cCsdS(N((tself((s(/usr/lib/python2.5/sqlite3/test/hooks.pytsetUpscCsdS(N((R((s(/usr/lib/python2.5/sqlite3/test/hooks.pyttearDownscCsctidƒ}y!|iddƒ|idƒWn,tj o }|i|iddƒnXdS(Ns:memory:tXi*sshould have raised a TypeErrorisparameter must be callable(tsqlitetconnecttcreate_collationtfailt TypeErrortfailUnlessEqualtargs(Rtconte((s(/usr/lib/python2.5/sqlite3/test/hooks.pytCheckCreateCollationNotCallable"s cCsOtidƒ}y!|idtƒ|idƒWntij o }nXdS(Ns:memory:scolläs%should have raised a ProgrammingError(RRRtcmpRtProgrammingError(RR R ((s(/usr/lib/python2.5/sqlite3/test/hooks.pytCheckCreateCollationNotAscii*s cCstidjodSnd„}tidƒ}|id|ƒd}|i|ƒiƒ}|ddd jp*|ddd jp|ddd jo|id ƒn|iddƒy&|i|ƒiƒ}|id ƒWn5tij o&}|i |i di ƒdƒnXdS(NiiicSst||ƒ S(N(R(txty((s(/usr/lib/python2.5/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(/usr/lib/python2.5/sqlite3/test/hooks.pytCheckCollationIsUsed2s  ?cCs†tidƒ}|idtƒ|idd„ƒ|idƒiƒ}|dddjp|dddjo|id ƒnd S( s„ Register two different collation functions under the same name. Verify that the last one is actually used. s:memory:RcSst||ƒ S((R(RR((s(/usr/lib/python2.5/sqlite3/test/hooks.pytVssi 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(/usr/lib/python2.5/sqlite3/test/hooks.pytCheckCollationRegisterTwiceOs*cCs”tidƒ}|idtƒ|iddƒy|idƒ|idƒWn@tij o1}|idi dƒp|idƒqnXdS( 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(/usr/lib/python2.5/sqlite3/test/hooks.pytCheckDeregisterCollation]s ( t__name__t __module__RRRRR R"R$(((s(/usr/lib/python2.5/sqlite3/test/hooks.pyRs      cCs"titdƒ}ti|fƒS(NtCheck(tunittestt makeSuiteRt TestSuite(tcollation_suite((s(/usr/lib/python2.5/sqlite3/test/hooks.pytsuitelscCs tiƒ}|itƒƒdS(N(R(tTextTestRunnertrunR,(trunner((s(/usr/lib/python2.5/sqlite3/test/hooks.pyttestps t__main__( tosR(tsqlite3RtTestCaseRR,R0R%(((s(/usr/lib/python2.5/sqlite3/test/hooks.pyss  Q