[DB-SIG] DB-API unittests
mal at egenix.com
Thu Dec 1 11:07:07 CET 2005
Andrew Chambers wrote:
> Hi All,
> I've been doing some work on some unittests for the Python DB-API.
I wonder whether you are aware of the existing test suite
for DB-API 2.0 by Stuart Bishop:
In particular, it tests psycopg.
> So far, I've created tests for...
> - Attempt to connect using invalid dbname should raise Error
> - Attempt to divide by zero should raise DataError
> - Attempt to violate foreign/primery key should raise IntegrityError
> - Attempt to create identical tables should raise ProgrammingError
> - Connection object should have minimum set of methods
> - Cursor object should have minimum set of methods
> - Simple select query should result in expected description/rowcount
> - Type_codes in description attr should evaluate to corresponding
> It only works for postgresql drivers since it connects to template1
> which should be present on most postgresql databases
> It raises a few points (these may have been discussed here before but
> googling the archives didn't reveal them.
> - Evidently there is ambiguity about the way that dates should be entered.
> pgdb - curs.execute("select '%s'" % Date(2005, 01, 01))
> psycopg - curs.execute("select %s" % Date(2005, 01, 01))
> Don't know about the others - I don't have them installed
psycopg is doing the right thing here - whatever Date() returns
should be directly usable with the %s parameter marker.
> - Exceptions. My interpretation of the API seems to deviate from that
> of psycopg and pgdb. Does anyone have any views on which is correct?
> I wrote the tests without having any existing implementation in mind
> just going from the spec. Are the tests at fault?
Hard to tell... what are your views ?
> I'd also be interested in what else you think should be tested. I've
> started to write some performance tests that simply query the pg_type
> table for a fixed time period (30 secs). These need more work though.
> I'll post if anyone asks.
> Finally, I couldn't think of a way to run these tests across a number of
> modules without duplicating the code (although to be honest I haven't
> given it much thought yet. If anyone has any ideas I'd be interested to
> hear those too.
Professional Python Services directly from the Source (#1, Dec 01 2005)
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
More information about the DB-SIG