hETSrSSSrSrSSKrSSKrSr"SS \R 5rg) aPython DB API 2.0 driver compliance unit test suite. This software is Public Domain and may be used without restrictions. "Now we have booze and barflies entering the discussion, plus rumours of DBAs on drugs... and I won't tell you what flashes through my mind each time I read the subject line with 'Anal Compliance' in it. All around this is turning out to be a thoroughly unwholesome unit test." -- Ian Bicking z$Revision: 1.15.0 $ z'Stuart Bishop NFch\rSrSrSrSrSr0rSrS\-r S\-r S\-r S \-r S r S rS rS rSrSrSrSrSrSrSrSrSrSrSrSrSrSrS rSr Sr!Sr"Sr#S r$S!r%/S"Qr&S#r'S$r(S%r)S&r*S'r+S(r,S)r-S*r.S+r/S,r0S-r1S.r2S/r3S0r4S1r5S2r6S3r7S4r8S5r9S6r:S7r;SrO>OPQ  4;;#?#?ARARST  4;;#=#=t{{?P?PQR  4;;#<#O>OPQ  4;;#?#?ARARST  4;;#@#@$++BSBSTUrcUR5nURnURURURL5 URURURL5 URUR UR L5 URUR UR L5 URURURL5 URURURL5 URURURL5 URURURL5 URURURL5 gr ) r r$rCrRr%rSrTrUrVrWrXrY)rr(drvs r%test_ExceptionsAsConnectionAttributes7DatabaseAPI20Test.test_ExceptionsAsConnectionAttributessmmokk  s{{23  SYY./ **c.@.@@A ))S->->>? ,,0D0DDE **c.@.@@A ))S->->>? ,,0D0DDE --1F1FFGrcUR5nUR5 UR5 g!UR5 f=fr )r r#r&r6s r test_commitDatabaseAPI20Test.test_commits.mmo  JJL IIKCIIK 3AcUR5n[US5(aUR5 gg!URRa gf=f)Nrollback)r hasattrrer$rYr6s r test_rollbackDatabaseAPI20Test.test_rollbacksMmmo 3 # #   $;;00  s5AAcUR5nUR5nUR5 g!UR5 f=fr )r rr&rr(r)s r test_cursorDatabaseAPI20Test.test_cursors0mmo **,C IIKCIIKrcc UR5nUR5nUR5nURU5 URSUR-5 URSUR-5 UR 5nUR [U5S5 UR [US5S5 UR USSS5 UR5 g!UR5 f=f)N.insert into %sbooze values ('Victoria Bitter')select name from %sboozer?rVictoria Bitter r rrr table_prefixfetchallr;lenr&)rr(cur1cur2boozes rtest_cursor_isolation'DatabaseAPI20Test.test_cursor_isolationsmmo ::Non-idempotent close is considered a bad thing by some people.) r rr& assertRaisesr$r%rr#TEST_FOR_NON_IDEMPOTENT_CLOSEskipTestrjs r test_closeDatabaseAPI20Test.test_closepsmmo **,C IIK $++++T-=-=sC $++++SZZ8 ) (   dkk// ; MMP  IIKs C!!C3cUR5nUR5nURU5 UR5 g!UR5 f=fr )r r _paraminsertr&rjs r test_executeDatabaseAPI20Test.test_executes>mmo **,C   c " IIKCIIKs !AAcURU5 URSUR-5 URURS;5 UR R S:Xa URSUR-S5 OUR R S:Xa URSUR-S5 OUR R S:Xa"URS UR-S S 05 OUR R S :Xa URS UR-S5 OMUR R S:Xa"URSUR-S S 05 OURS5 URURS;5 URSUR-5 UR5nUR[U5SS5 USSUSS/nUR5 URUSS S5 URUSSS5 SnURUSSUSUSS<SU<35 URUSSUSUSS<SU<35 g)NzSinsert into %sbarflys values ('Victoria Bitter', 'thi%%s :may ca%%(u)se? troub:1e')rrHzCinsert into %sbarflys values (?, 'thi%%s :may ca%%(u)se? troub:1e')Cooper'srIzDinsert into %sbarflys values (:1, 'thi%%s :may ca%%(u)se? troub:1e')rJzGinsert into %sbarflys values (:beer, 'thi%%s :may ca%%(u)se? troub:1e')beerrrKzEinsert into %sbarflys values (%%s, 'thi%%s :may ca%%(u)se? troub:1e')rLzKinsert into %sbarflys values (%%(beer)s, 'thi%%s :may ca%%(u)se? troub:1e')zInvalid paramstylez!select name, drink from %sbarflysr@z%cursor.fetchall returned too few rowsrr?zFcursor.fetchall retrieved incorrect data, or data inserted incorrectlyrpzthi%s :may ca%(u)se? troub:1ezLcursor.fetchall retrieved incorrect data, or data inserted incorrectly. Got=z , Expected=) rr rrrCrr$rMr2rsr;rtsort)rr)resbeerstroubles rrDatabaseAPI20Test._paraminserts  a   "   /0 ;; ! !W , KKU##$  [[ # #y 0 KKV##$  [[ # #w . KKY##$$  [[ # #x / KKW##$  [[ # #z 1 KK]##$$  II* +  /0 7$:K:KKLlln S1&MNQCF1I&   !H  T  !H  T 2  F1I  #Aq }K{ D  F1I  #Aq }K{ D rcUR5nUR5nURU5 SS/nSS0SS0/nURRS:Xa UR SUR -U5 OURRS:Xa UR S UR -U5 OURRS :Xa UR S UR -U5 OURRS :Xa UR S UR -U5 OKURRS:Xa UR SUR -U5 OURS5 URURS;SUR-5 URSUR -5 UR5nUR[U5SS5 USSUSS/nUR5 URUSSSUS-5 URUSSS5 UR5 g!UR5 f=f)Nr)Boag'srrrrHzinsert into %sbooze values (?)rIzinsert into %sbooze values (:1)rJz"insert into %sbooze values (:beer)rKz insert into %sbooze values (%%s)rLz&insert into %sbooze values (%%(beer)s)zUnknown paramstyle)rr@zIinsert using cursor.executemany set cursor.rowcount to incorrect value %rror@z2cursor.fetchall retrieved incorrect number of rowsrr?zincorrect data "%s" retrievedzincorrect data retrieved)r rrr$rM executemanyrrr2rCrr rsr;rtrr&)rr(r)largsmargsrrs rtest_executemany"DatabaseAPI20Test.test_executemanys#mmo- **,C   S !"K0Ej)FH+=>E{{%%04t7H7HH%''9458I8II5''7284;L;LLe''8369J9JJE'':5<@Q@QR  ./ OO '%'*||4  KK2T5F5FF G,,.C   C!Q VAYAq *E JJL   a($CeAh$N    U1Xz3M N IIKCIIKs H(I IcUR5nUR5nURURRUR 5 UR U5 URURRUR 5 URSUR-5 URUR 5SS5 URURS;5 URSUR-5 URURRUR 5 URSUR-5 UR 5nUR[U5SS5 URUSSS 5 URUR 5SS 5 URURS ;5 UR5 g!UR5 f=f) Nroz?cursor.fetchone should return None if a query retrieves no rowsrrnr?z2cursor.fetchone should have retrieved a single rowrrpz(cursor.fetchone retrieved incorrect dataz   S !   dkk// > KK2T5F5FF G    Q  OOCLLG3 4 KK@DDUDUV    dkk// > KK2T5F5FF G A   AO    !')S     N  OOCLLG3 4 IIKCIIKs G G..H)z Carlton Coldz Carlton Draftz Mountain GoatRedbackrpXXXXcnURVs/sHnSUR<SU<S3PM nnU$s snf)zCReturn a list of sql commands to setup the DB for the fetch tests. z insert into zbooze values ('z'))samplesrr)rspopulates r _populateDatabaseAPI20Test._populate?s? \\ !483D3Da H!    s2c.UR5nUR5nURURRUR S5 UR U5 UR5HnURU5 M URSUR-5 UR 5nUR[U5SS5 SUl UR S5nUR[U5SS5 UR S5nUR[U5SS5 UR S5nUR[U5S S 5 URURS ;5 SUl URSUR-5 UR 5nUR[U5SS 5 UR 5nUR[U5S5 UR 5nUR[U5S 5 URURS ;5 S Ul URSUR-5 UR 5nURURS ;5 UR[U5S 5 UR[U5S 5 UVs/sHoDS PM nnUR5 [!S S 5H%nURXVUR"US5 M' UR 5nUR[U5S S5 URURS ;5 UR%U5 URSUR-5 UR 5nUR[U5S S5 URURS;5 UR'5 gs snf!UR'5 f=f)Nror?zQcursor.fetchmany retrieved incorrect number of rows, default of arraysize is one. rAz3cursor.fetchmany retrieved incorrect number of rowsr@rzLcursor.fetchmany should return an empty sequence after results are exhaustedrz0cursor.arraysize not being honoured by fetchmanyrz,incorrect data retrieved by cursor.fetchmanyzfcursor.fetchmany should return an empty sequence if called after the whole result set has been fetchedselect name from %sbarflyszKcursor.fetchmany should return an empty sequence if query retrieved no rowsr)r rrr$r% fetchmanyrrr rrr;rt arraysizerCrrrangerrr&)rr(r)sqlr3rowsis rtest_fetchmany DatabaseAPI20Test.test_fetchmanyIsfmmoX **,C   dkk// B   S !~~' C ( KK2T5F5FF G A   A/  CM a A   AP  a A   AP  a A   A(  OOCLLG3 4CM KK2T5F5FF G A   AM  A   SVQ ' A   SVQ ' OOCLLG3 4CM KK2T5F5FF G==?D OOCLLG3 4   SY *   SY *"&'$QaD$D' IIK1a[  GLLOB!==?D   D E  OOCLLG3 4   S ! KK4t7H7HH I A   A*  OOCLLG3 4 IIKA(@ IIKsKPO="D P=PPctUR5nUR5nURURRUR 5 UR U5 UR5HnURU5 M URURRUR 5 URSUR-5 UR 5nURURS[UR54;5 UR[U5[UR5S5 UVs/sHoUSPM nnUR5 [!S[UR55H%nURXFURUS5 M' UR 5nUR[U5SS5 URURS[UR54;5 UR#U5 URSUR-5 UR 5nURURS;5 UR[U5SS 5 UR%5 gs snf!UR%5 f=f) Nrorz)cursor.fetchall did not retrieve all rowsrz(cursor.fetchall retrieved incorrect rowszacursor.fetchall should return an empty list if called after the whole result set has been fetchedrrzMcursor.fetchall should return an empty list if a select query returns no rows)r rrr$r%rsrrr rrrCrrtrr;rrrr&)rr(r)rrr3rs r test_fetchallDatabaseAPI20Test.test_fetchallsmmo2 **,C   dkk// >   S !~~' C (   dkk// > KK2T5F5FF G<<>D OOCLLRT\\1B,CC D   D DLL!;  #''$QaD$D' IIK1c$,,/0  GT\\!_.X1<<>D   D >  OOCLLRT\\1B,CC D   S ! KK4t7H7HH I<<>D OOCLLG3 4   D 1  IIK7(6 IIKsD=J%J D2J% J%%J7cUR5nUR5nURU5 UR5HnUR U5 M UR SUR -5 UR 5nURS5nUR 5nUR5nURURS;5 UR[U5SS5 UR[U5SS5 US/nURUSSUSS/5 URUS5 URUSSUSS/5 UR5 [!S[UR"55H%n URXUR"U S5 M' UR%5 g!UR%5 f=f) Nror@rz+fetchmany returned incorrect number of rowsz*fetchall returned incorrect number of rowsrr?z$incorrect data retrieved or inserted)r rrrr rrrrrsrCrr;rtextendappendrrrr&) rr(r)rrows1rows23rows4rows56rrs rtest_mixedfetch!DatabaseAPI20Test.test_mixedfetchsmmo **,C   S !~~' C ( KK2T5F5FF GLLNE]]1%FLLNE\\^F OOCLLG3 4   F Q M    F Q L !H:D KK1vay|4 5 KKa ! KK1vay|4 5 IIK1c$,,/0  GT\\!_.T1 IIKCIIKs F.GG#c[S5e)zShould create a procedure called deleteme that returns two result sets, first the number of rows in booze then "name from booze" Helper not implementedNotImplementedErrorrr)s rhelp_nextset_setUp$DatabaseAPI20Test.help_nextset_setUps "":;;rc[S5e)z*If cleaning up is needed after nextSetTestrrrs rhelp_nextset_tearDown'DatabaseAPI20Test.help_nextset_tearDown s!":;;rc[S5e)Nz"Drivers need to override this testrrs r test_nextsetDatabaseAPI20Test.test_nextsets!"FGGrcUR5nUR5nUR[US5S5 UR 5 g!UR 5 f=f)Nrz cursor.arraysize must be defined)r rrCrfr&rjs rtest_arraysize DatabaseAPI20Test.test_arraysizesKmmo **,C OO[)+M  IIKCIIKs ,AA!cUR5nUR5nURS5 URU5 UR 5 g!UR 5 f=f)N))r r setinputsizesrr&rjs rtest_setinputsizes$DatabaseAPI20Test.test_setinputsizessLmmo **,C   e $   c " IIKCIIKs 2AA'cUR5nUR5nURS5 URSS5 URU5 UR 5 g!UR 5 f=f)Niir)r r setoutputsizerr&rjs rtest_setoutputsize_basic*DatabaseAPI20Test.test_setoutputsize_basic's\mmo **,C   d #   dA &   c " IIKCIIKs AA''A9c[S5e)Nz#Driver needed to override this testrrs rtest_setoutputsize$DatabaseAPI20Test.test_setoutputsize2s!"GHHrcUR5nUR5nURU5 URSUR-5 URSUR-5 UR 5nUR [U5S5 UR [US5S5 UR USSSS5 UR5 g!UR5 f=f)Nz!insert into %sbooze values (NULL)ror?rzNULL value not returned as Nonerqrs r test_NoneDatabaseAPI20Test.test_None6smmo **,C   S ! KK;d>O>OO P KK2T5F5FF G A   SVQ '   S1Y *   QqT!Wd,M N IIKCIIKs B?C""C4cURRSSS5nURR[R"S55ng)N r) rrrrrrrrr)r$Date DateFromTickstimemktime)rd1d2s r test_DateDatabaseAPI20Test.test_DateDs8 [[  dB + [[ & &t{{3S'T UrcURRSSS5nURR[R"S55ng)N -) ir?r?rrrrrr)r$Time TimeFromTicksrrrt1t2s r test_TimeDatabaseAPI20Test.test_TimeJs8 [[  b"b ) [[ & &t{{3T'U VrcURRSSSSSS5nURR[R"S55ng)Nrrrrrr) rrrrrrrrr)r$ TimestampTimestampFromTicksrrrs rtest_Timestamp DatabaseAPI20Test.test_TimestampPsA [[ " "4RR < [[ + + KK; < rcpURRS5nURRS5ng)Ns Somethingr)r$Binary)rbs r test_BinaryDatabaseAPI20Test.test_BinaryXs* KK  | , KK  s #rcPUR[URS5S5 g)Nr~zmodule.STRING must be definedrCrfr$rs r test_STRINGDatabaseAPI20Test.test_STRING\s  X68WXrcPUR[URS5S5 g)NBINARYzmodule.BINARY must be defined.rrs r test_BINARYDatabaseAPI20Test.test_BINARY_  DKK *,L rcPUR[URS5S5 g)NNUMBERzmodule.NUMBER must be defined.rrs r test_NUMBERDatabaseAPI20Test.test_NUMBERdrrcPUR[URS5S5 g)NDATETIMEz module.DATETIME must be defined.rrs r test_DATETIMEDatabaseAPI20Test.test_DATETIMEis  DKK ,.P rcPUR[URS5S5 g)NROWIDzmodule.ROWID must be defined.rrs r test_ROWIDDatabaseAPI20Test.test_ROWIDns  W57VWr)=__name__ __module__ __qualname____firstlineno____doc__r$r/r0rrrrr!r" lowerfuncrrrr+r r7r<rDrNrZr^rargrkrxrrrrrrrrrrrrrrrrrrrrrrrrrr rrrrr"__static_attributes__rrrrrVsF.FLO!L 4| CD IL XD < /E "\ 1EI"" ,8< : VH&&)V DJ 0E N/b,\GZx4lB<< H  I V W  $Y   Xrr)r( __version__ __author__runittestrTestCaserrrrr/sB $Br* 6 !&BY X))Y Xr