Comparison of test support by several DB-API implementations.
| Test Name | psycopg2 | pysqlite2 | mysqldb |
| Required exceptions are in the defined heirachy. | Pass | Pass | Pass |
| Driver defines apilevel | Pass | Pass | Pass |
| Can connect to database | Pass | Pass | Pass |
| Driver defines paramstyle | Pass | Pass | Pass |
| Driver defines threadsafety | Pass | Pass | Pass |
| Module defines BINARY | Pass | Fail | Pass |
| Module supports Binary | Pass | Pass | Pass |
| Module defines DATETIME | Pass | Fail | Pass |
| Module supports Date and DateFromTicks | Pass | Pass | Pass |
| Module supports DateFromTicks | Pass | Pass | Pass |
| Module defines NUMBER | Pass | Fail | Pass |
| Module defines ROWID | Pass | Fail | Pass |
| Module defines STRING | Pass | Fail | Pass |
| Module supports Time and TimeFromTicks | Pass | Pass | Pass |
| Module supports TimeFromTicks | Pass | Pass | Pass |
| Module supports Timestamp and TimestampFromTicks | Pass | Pass | Pass |
| Module supports TimestampFromTicks | Pass | Pass | Pass |
| Module's date is equivalent to datetime's date | Pass | Pass | Pass |
| Module's time attribute is equivalent to datetime's time | Pass | Pass | Pass |
| Module's Timestamp attribute is equivalent to datetime's datetime | Pass | Pass | Pass |
| Connection objects should include the exceptions as attributes (optional) | Pass | Pass | Pass |
| Connection should fail using bogus database | Pass | Fail | Pass |
| Connection should fail using bogus password | Pass | Fail | Pass |
| Connection should fail using bogus username | Pass | Fail | Pass |
| Can't commit, execute, or close a closed connection | Pass | Fail | Pass |
| Can't close a closed connection | Pass | Fail | Pass |
| Can't commit a closed connection | Pass | Pass | Pass |
| Commit must be defined, even if it doesn't do anything | Pass | Pass | Pass |
| Consecutive commits should be successfull | Pass | Pass | Pass |
| Connections need to be able to create cursors | Pass | Pass | Pass |
| Connection should fail using blank password | Pass | Fail | Pass |
| Rollback must work or throw NotSupportedError. | Pass | Pass | Pass |
| Consecutive rollbacks should be successfull | Pass | Pass | Pass |
| Successful connect and close | Pass | Pass | Pass |
| Fetchmany works with BLOBs. | Pass | Pass | Pass |
| Cursor must define arraysize | Pass | Pass | Pass |
| BLOB (file) | Fail | Fail | Fail |
| Connections must have cursor method | Pass | Pass | Pass |
| A cursor can read it's own uncommited data | Pass | Pass | Pass |
| Cursor description describes columns correctly | Pass | Pass | Pass |
| Fetch methods should raise Error if no query issued | Pass | Fail | Fail |
| Insert multiple rows using executemany | Pass | Pass | Pass |
| Fetchall retrieves rows & sets rowcount | Pass | Pass | Pass |
| Fetchall returns accurate data | Pass | Pass | Pass |
| Fetchmany retrieves rows & sets rowcount | Pass | Pass | Pass |
| Fetchone retrieves row & sets rowcount | Pass | Pass | Pass |
| Can mix fetchone, fetchmany, and fetchall | Pass | Pass | Pass |
| Rowcount matches the number of rows inserted | Pass | Pass | Pass |
| Rowcount should be 1 after singleton insert | Pass | Pass | Pass |
| Insert works with cursor.setinputsize | Pass | Pass | Pass |
| Insert works with cursor.setoutputsize | Pass | Pass | Fail |
| Handle Python's None as a database null | Pass | Pass | Pass |
| Insert a multitude of date/time datatypes in one statement using datetime | Pass | Fail | Pass |
| Insert a multitude of date/time datatypes in one statement using strings | Pass | Pass | Pass |
| Insert dates using datetime dates | Pass | Pass | Pass |
| Insert dates using strings | Pass | Pass | Pass |
| Insert time using datetime's time | Pass | Fail | Fail |
| Insert time using string | Pass | Pass | Pass |
| Insert time with subsecond precision using datetime's time | Pass | Fail | Pass |
| Insert time with subsecond precision using string | Pass | Pass | Pass |
| Insert timestamp using datetime's datetime | Pass | Pass | Pass |
| Insert timestamp with subsecond precision using strings | Pass | Pass | Fail |
| Stored procedure calls return result sets | Fail | Fail | Fail |
Sign in to add a comment
