[PYTHON DB-SIG] Python Database API

Anthony Baxter Anthony Baxter <arb@connect.com.au>
Tue, 15 Apr 1997 14:30:44 +1000

>>> Greg Stein wrote
> The API is stable and has not changed since then. There are some changes
> to DBI (as mentioned) that have not been documented yet. The "spec" for
> that can be found via the code of the various other modules (odbc,
> oracle, informix).

FWIW, I'd like to fill in a few of the "not well defined yet" bits - I'm
currently rewriting the oracle module (amongst other things, to get more
than one row at a time, and to use the thread-safe interfaces of Oracle 7.3)

As far as I can see, there's no spec for the DBI stuff. I'd like to
be able to specify creation of dbiDates, using either a delta, or a
7-tuple, as produced by time.gmtime() and friends. The current oracle
module forces everything to be done in terms of localtime, which is bad.

Other things: currently the spec says connection.close() should render
the connection unusable, and any attempts to use the connection should
raise an exception. Should this also apply to any cursors created from
the connection?
What about cursor.close()? Should that just nuke the current cursor, or
the connection it's attached to? 

Has anyone done anything with connection.callproc() at all?


DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org