The great thing about standards is there are so many of them to pick 
from! I don't recall who originally said that but it is sort of apt here :-)

I'm using http://stuartbishop.net/Software/DBAPI20TestSuite/ which is 
the original that Vernon was referring to. Vernon is your Launchpad 
project only for Python 3.x?

There is also http://code.google.com/p/acute-dbapi/ (note I've not used 
it, I've not had chance to check it out). I get the impression this 
builds on http://stuartbishop.net/Software/DBAPI20TestSuite/ based on 
the credits

SQL Alchemy has some more advanced tests (e.g. checks behavior on close 
of a connection with an attempted use on a cursor) BUT they are not 
generic as you need to write a driver wrapper.

So in summary I'd suggest http://stuartbishop.net/Software/DBAPI20TestSuite/

If you could report any findings here I would appreciate it! If we can 
all agree on which test to use we can be in the same state as Java with 
a definitive test suite.

Chris

Vernon Cole wrote:
>  There is such a test, written by Stuart Bishop. I was supposed to have 
>  contributed some Python 3000 patches to it, but got sidetracked. I 
>  will repent shortly.  In the meantime, if you are using a version 2x 
>  Python you do not want my changes anyway...
>  https://launchpad.net/dbapi-compliance
>   Main branch is lp:dbapi-compliance
>  --
>  Vernon Cole
> 
>  On Wed, Oct 28, 2009 at 2:28 AM, Julian Scheid 
>  <julians37@[...].com <mailto:julians37@[...].com>> wrote:
> 
>      Hi,
> 
>      is there a test suite I can run to test conformance of a driver
>      implementation to the DB-API 2.0 spec?
> 
>      JDBC, for example, has this:
>      http://java.sun.com/products/jdbc/jdbctestsuite-1_3_1.html
> 
>      Thank you
> 
>      Julian
>      _______________________________________________
>      DB-SIG maillist  -  DB-SIG@[...].org <mailto:DB-SIG@[...].org>
>      http://mail.python.org/mailman/listinfo/db-sig
> 
> 
>  ------------------------------------------------------------------------
> 
>  _______________________________________________
>  DB-SIG maillist  -  DB-SIG@[...].org
>  http://mail.python.org/mailman/listinfo/db-sig
>    

_______________________________________________
DB-SIG maillist  -  DB-SIG@[...].org
http://mail.python.org/mailman/listinfo/db-sig