o ª›hE‚ã@s>dZddd…ZdZddlZddlZdZGdd „d ejƒZdS) a¬Python 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 éNFc@s°eZdZdZdZdZiZdZdeZdeZ deZ deZ d Z d d „Z d d „Zdd„Zdd„Zdd„Zdd„Zdd„Zdd„Zdd„Zdd„Zdd„Zd d!„Zd"d#„Zd$d%„Zd&d'„Zd(d)„Zd*d+„Zd Zd,d-„Zd.d/„Z d0d1„Z!d2d3„Z"d4d5„Z#d6d7„Z$gd8¢Z%d9d:„Z&d;d<„Z'd=d>„Z(d?d@„Z)dAdB„Z*dCdD„Z+dEdF„Z,dGdH„Z-dIdJ„Z.dKdL„Z/dMdN„Z0dOdP„Z1dQdR„Z2dSdT„Z3dUdV„Z4dWdX„Z5dYdZ„Z6d[d\„Z7d]d^„Z8d_d`„Z9dadb„Z:dS)cÚDatabaseAPI20Testa Test a database self.driver for DB API 2.0 compatibility. This implementation tests Gadfly, but the TestCase is structured so that other self.drivers can subclass this test case to ensure compiliance with the DB-API. It is expected that this TestCase may be expanded in the future if ambiguities or edge conditions are discovered. The 'Optional Extensions' are not yet being tested. self.drivers should subclass this test, overriding setUp, tearDown, self.driver, connect_args and connect_kw_args. Class specification should be as follows: import dbapi20 class mytest(dbapi20.DatabaseAPI20Test): [...] Don't 'import DatabaseAPI20Test from dbapi20', or you will confuse the unit tester - just 'import dbapi20'. N©Z dbapi20test_z'create table %sbooze (name varchar(20))zr?r@rA)r rÚdrvrrrÚ%test_ExceptionsAsConnectionAttributesÓsz7DatabaseAPI20Test.test_ExceptionsAsConnectionAttributescCs*| ¡}z | ¡W| ¡dS| ¡wr)rrrr&rrrÚ test_commitæs zDatabaseAPI20Test.test_commitcCs>| ¡}t|dƒrz| ¡WdS|jjyYdSwdS)NÚrollback)rÚhasattrrFrrAr&rrrÚ test_rollbackîs ÿýzDatabaseAPI20Test.test_rollbackcCs*| ¡}z | ¡}W| ¡dS| ¡wr)rr r©r rrrrrÚ test_cursorøs zDatabaseAPI20Test.test_cursorcCsœ| ¡}zD| ¡}| ¡}| |¡| d|j¡| d|j¡| ¡}| t|ƒd¡| t|dƒd¡| |ddd¡W| ¡dS| ¡w)Nú.insert into %sbooze values ('Victoria Bitter')úselect name from %sboozer,rúVictoria Bitter© rr rr Ú table_prefixÚfetchallr)Úlenr)r rZcur1Zcur2ZboozerrrÚtest_cursor_isolationÿs ÿz'DatabaseAPI20Test.test_cursor_isolationcCsà| ¡}zf| ¡}| |¡| |jdd¡| d|j¡| t|jƒdd¡| t|jdƒdd¡| |jdd ¡dd ¡| |jdd|j j d |jdd¡|  |¡| |jdd ¡W|  ¡dS|  ¡w) Nzccursor.description should be none after executing a statement that can return no rows (such as DDL)rLr,z-cursor.description describes too many columnsréz1cursor.description[x] tuples must have 7 elementsÚnamez0cursor.description[x][0] must return column namez8cursor.description[x][1] must return column type. Got %rzVcursor.description not being set to None when executing no-result statements (eg. DDL)) rr rr)Ú descriptionr rOrQrrÚSTRINGrrrIrrrÚtest_descriptionsJ ý ÿ ýý  ÿý ýz"DatabaseAPI20Test.test_descriptioncCs¤| ¡}zH| ¡}| |¡| |jdvd¡| d|j¡| |jdvd¡| d|j¡| |jdvd¡| |¡| |jdd ¡W|  ¡dS|  ¡w) N©éÿÿÿÿrzFcursor.rowcount should be -1 or 0 after executing no-result statementsrK©rYr,zccursor.rowcount should == number or rows inserted, or set to -1 after executing an insert statementrLzbcursor.rowcount should == number of rows returned, or set to -1 after executing a select statementrYzJcursor.rowcount not being reset to -1 after executing no-result statements) rr rr0Úrowcountr rOrr)rrIrrrÚ test_rowcount=s6 þÿþþ ýzDatabaseAPI20Test.test_rowcountcCsÊ| ¡}z[| ¡}|jrRt|dƒrY| |jd¡}| t|ƒd¡| |dd¡| ¡}| t|ƒdd¡| t|dƒdd¡| |dddd ¡W| ¡dSW| ¡dSW| ¡dS| ¡w) NÚcallproc)ÚFOOr,rr^zcallproc produced no result setz$callproc produced invalid result setZfooz!callproc produced invalid results) rr Ú lower_funcrGr]r)rQrPr©r rrr%rrrÚ test_callprocas  ÷ ÷ zDatabaseAPI20Test.test_callproccCsv| ¡}z | ¡}W| ¡n| ¡w| |jj|j|¡| |jj|j¡tr4| |jj|j¡dS|  d¡dS)Nz>Non-idempotent close is considered a bad thing by some people.) rr rÚ assertRaisesrrrrÚTEST_FOR_NON_IDEMPOTENT_CLOSEZskipTestrIrrrÚ test_closeps ÿzDatabaseAPI20Test.test_closecCs4| ¡}z| ¡}| |¡W| ¡dS| ¡wr)rr Ú _paraminsertrrIrrrÚ test_executeˆs  zDatabaseAPI20Test.test_executecCs¶| |¡| d|j¡| |jdv¡|jjdkr%| d|jd¡nI|jjdkr5| d|jd¡n9|jjdkrG| d |jd d i¡n'|jjd krW| d |jd¡n|jjdkri| d|jd d i¡n| d¡| |jdv¡| d|j¡| ¡}|  t |ƒdd¡|dd|ddg}|  ¡|  |dd d¡|  |ddd¡d}|  |dd|d|dd›d|›¡|  |dd|d|dd›d|›¡dS)NzSinsert into %sbarflys values ('Victoria Bitter', 'thi%%s :may ca%%(u)se? troub:1e')rZr2zCinsert into %sbarflys values (?, 'thi%%s :may ca%%(u)se? troub:1e')©úCooper'sr3zDinsert into %sbarflys values (:1, 'thi%%s :may ca%%(u)se? troub:1e')r4zGinsert into %sbarflys values (:beer, 'thi%%s :may ca%%(u)se? troub:1e')Úbeerrhr5zEinsert into %sbarflys values (%%s, 'thi%%s :may ca%%(u)se? troub:1e')r6zKinsert 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 incorrectlyrMzthi%s :may ca%(u)se? troub:1ezLcursor.fetchall retrieved incorrect data, or data inserted incorrectly. Got=z , Expected=) rr rOr0r[rr7r$rPr)rQÚsort)r rÚresÚbeersZtroublerrrresœ ÿÿ ÿý ÿý ÿý ÿý ÿý ýý  ÿÿý  ÿÿýzDatabaseAPI20Test._paraminsertcCs„| ¡}z¸| ¡}| |¡ddg}ddiddig}|jjdkr*| d|j|¡nE|jjdkr:| d |j|¡n5|jjd krJ| d |j|¡n%|jjd krZ| d |j|¡n|jjdkrj| d|j|¡n| d¡| |j dvd|j ¡|  d|j¡|  ¡}|  t |ƒdd¡|dd|ddg}| ¡|  |ddd|d¡|  |ddd¡W| ¡dS| ¡w)Nrg)úBoag'srirhrmr2zinsert into %sbooze values (?)r3zinsert into %sbooze values (:1)r4z"insert into %sbooze values (:beer)r5z insert into %sbooze values (%%s)r6z&insert into %sbooze values (%%(beer)s)zUnknown paramstyle)rYr-zIinsert using cursor.executemany set cursor.rowcount to incorrect value %rrLr-z2cursor.fetchall retrieved incorrect number of rowsrr,zincorrect data "%s" retrievedzincorrect data retrieved)rr rrr7Z executemanyrOr$r0r[r rPr)rQrjr)r rrÚlargsZmargsrkrlrrrÚtest_executemany×s\   ÿ  ÿ  ÿ  ÿ þ ÿþ ÿÿz"DatabaseAPI20Test.test_executemanycCs | ¡}z{| ¡}| |jj|j¡| |¡| |jj|j¡| d|j¡|  | ¡dd¡|  |j dv¡| d|j¡| |jj|j¡| d|j¡| ¡}|  t |ƒdd¡|  |ddd ¡|  | ¡dd ¡|  |j d v¡W|  ¡dS|  ¡w) NrLz?cursor.fetchone should return None if a query retrieves no rowsrXrKr,z2cursor.fetchone should have retrieved a single rowrrMz(cursor.fetchone retrieved incorrect datazCs ÿÿz/DatabaseAPI20Test._populate..)Úsamples)r ZpopulaterrrÚ _populate?s þzDatabaseAPI20Test._populatecCs`| ¡}z%| ¡}| |jj|jd¡| |¡| ¡D]}| |¡q| d|j ¡| ¡}|  t |ƒdd¡d|_ | d¡}|  t |ƒdd¡| d¡}|  t |ƒdd¡| d¡}|  t |ƒd d ¡|  |jd v¡d|_ | d|j ¡| ¡}|  t |ƒdd ¡| ¡}|  t |ƒd¡| ¡}|  t |ƒd ¡|  |jd v¡d |_ | d|j ¡| ¡}|  |jd v¡|  t |ƒd ¡|  t |ƒd ¡dd„|Dƒ}| ¡td d ƒD]}|  |||j|d¡qÞ| ¡}|  t |ƒd d¡|  |jd v¡| |¡| d|j ¡| ¡}|  t |ƒd d¡|  |jdv¡W| ¡dS| ¡w)NérLr,zQcursor.fetchmany retrieved incorrect number of rows, default of arraysize is one.é r.z3cursor.fetchmany retrieved incorrect number of rowsr-rzLcursor.fetchmany should return an empty sequence after results are exhausted©rYéz0cursor.arraysize not being honoured by fetchmanyrzcSóg|]}|d‘qS©rr©rrr%rrrrtƒóz4DatabaseAPI20Test.test_fetchmany..z,incorrect data retrieved by cursor.fetchmanyzfcursor.fetchmany should return an empty sequence if called after the whole result set has been fetchedúselect name from %sbarflyszKcursor.fetchmany should return an empty sequence if query retrieved no rowsrX)rr rbrrÚ fetchmanyrrvr rOr)rQÚ arraysizer0r[rjÚrangerurr)r rrÚsqlr%ÚrowsÚirrrÚtest_fetchmanyIs   ý  ÿ  ÿ ý ÿýý ýz DatabaseAPI20Test.test_fetchmanycCsv| ¡}z±| ¡}| |jj|j¡| |¡| ¡D]}| |¡q| |jj|j¡| d|j ¡| ¡}|  |j dt |j ƒfv¡| t |ƒt |j ƒd¡dd„|Dƒ}| ¡tdt |j ƒƒD]}| |||j |d¡qd| ¡}| t |ƒdd¡|  |j dt |j ƒfv¡| |¡| d |j ¡| ¡}|  |j d v¡| t |ƒdd ¡W| ¡dS| ¡w) NrLrYz)cursor.fetchall did not retrieve all rowscSr{r|rr}rrrrt¾r~z3DatabaseAPI20Test.test_fetchall..rz(cursor.fetchall retrieved incorrect rowszacursor.fetchall should return an empty list if called after the whole result set has been fetchedrrXzMcursor.fetchall should return an empty list if a select query returns no rows)rr rbrrrPrrvr rOr0r[rQrur)rjr‚rr)r rrrƒr„r…rrrÚ test_fetchall¥sN   ýÿý ýzDatabaseAPI20Test.test_fetchallc Cs<| ¡}z”| ¡}| |¡| ¡D]}| |¡q| d|j¡| ¡}| d¡}| ¡}| ¡}|  |j dv¡|  t |ƒdd¡|  t |ƒdd¡|dg}|  |dd|ddg¡| |d¡|  |dd|ddg¡| ¡tdt |jƒƒD]} |  || |j| d¡qƒW| ¡dS| ¡w) NrLr-ryz+fetchmany returned incorrect number of rowsz*fetchall returned incorrect number of rowsrr,z$incorrect data retrieved or inserted)rr rrvr rOrpr€rPr0r[r)rQÚextendÚappendrjr‚rur) r rrrƒZrows1Zrows23Zrows4Zrows56r„r…rrrÚtest_mixedfetchÛs:     ÿ ÿ ÿÿz!DatabaseAPI20Test.test_mixedfetchcCótdƒ‚)z™Should create a procedure called deleteme that returns two result sets, first the number of rows in booze then "name from booze" úHelper not implemented©ÚNotImplementedError©r rrrrÚhelp_nextset_setUpüsz$DatabaseAPI20Test.help_nextset_setUpcCr‹)z*If cleaning up is needed after nextSetTestrŒrrrrrÚhelp_nextset_tearDown óz'DatabaseAPI20Test.help_nextset_tearDowncCr‹)Nz"Drivers need to override this testrrrrrÚ test_nextsetszDatabaseAPI20Test.test_nextsetcCs<| ¡}z| ¡}| t|dƒd¡W| ¡dS| ¡w)Nrz cursor.arraysize must be defined)rr r0rGrrIrrrÚtest_arraysizes ÿz DatabaseAPI20Test.test_arraysizecCs>| ¡}z| ¡}| d¡| |¡W| ¡dS| ¡w)N)é)rr Z setinputsizesrerrIrrrÚtest_setinputsizess   z$DatabaseAPI20Test.test_setinputsizescCsJ| ¡}z| ¡}| d¡| dd¡| |¡W| ¡dS| ¡w)NièiÐr)rr Z setoutputsizererrIrrrÚtest_setoutputsize_basic's   z*DatabaseAPI20Test.test_setoutputsize_basiccCr‹)Nz#Driver needed to override this testrrrrrÚtest_setoutputsize2r’z$DatabaseAPI20Test.test_setoutputsizecCs–| ¡}zA| ¡}| |¡| d|j¡| d|j¡| ¡}| t|ƒd¡| t|dƒd¡| |dddd¡W| ¡dS| ¡w)Nz!insert into %sbooze values (NULL)rLr,rzNULL value not returned as NonerNr`rrrÚ test_None6s zDatabaseAPI20Test.test_NonecCó&|j ddd¡}|j t d¡¡}dS)NéÒé r•) r›rœr•rrrrrr)rÚDateZ DateFromTicksÚtimeÚmktime)r Zd1Zd2rrrÚ test_DateDózDatabaseAPI20Test.test_DatecCrš)Né é-é) iÑr,r,r¢r£r¤rrr)rZTimeZ TimeFromTicksržrŸ©r Út1Út2rrrÚ test_TimeJr¡zDatabaseAPI20Test.test_TimecCs,|j dddddd¡}|j t d¡¡}dS)Nr›rœr•r¢r£r¤) r›rœr•r¢r£r¤rrr)rÚ TimestampZTimestampFromTicksržrŸr¥rrrÚtest_TimestampPsÿz DatabaseAPI20Test.test_TimestampcCs|j d¡}|j d¡}dS)Ns Somethingó)rÚBinary)r ÚbrrrÚ test_BinaryXs zDatabaseAPI20Test.test_BinarycCó| t|jdƒd¡dS)NrVzmodule.STRING must be defined©r0rGrrrrrÚ test_STRING\ózDatabaseAPI20Test.test_STRINGcCr¯)NÚBINARYzmodule.BINARY must be defined.r°rrrrÚ test_BINARY_ó ÿzDatabaseAPI20Test.test_BINARYcCr¯)NÚNUMBERzmodule.NUMBER must be defined.r°rrrrÚ test_NUMBERdrµzDatabaseAPI20Test.test_NUMBERcCr¯)NZDATETIMEz module.DATETIME must be defined.r°rrrrÚ test_DATETIMEirµzDatabaseAPI20Test.test_DATETIMEcCr¯)NZROWIDzmodule.ROWID must be defined.r°rrrrÚ test_ROWIDnr²zDatabaseAPI20Test.test_ROWID);Ú__name__Ú __module__Ú __qualname__Ú__doc__rr!r"rOr rrrZ lowerfuncrrrrrr'r*r1r8rBrDrErHrJrRrWr\r_rardrfrerorqrurvr†r‡rŠrr‘r“r”r–r—r˜r™r r¨rªr®r±r´r·r¸r¹rrrrrVsr     +"G1.  \6!    r)r½Ú __version__Ú __author__ržZunittestrcZTestCaserrrrrÚs A