[DB-SIG] What DB-API compliant interfaces are there?

[Bill Tutt]

It certainly sounds reasonable to me... 
Oh btw, the current list of exceptions for the PythonWin DBI code is:
noError, opError, progError, integrityError, dataError, internalError

noError is generally ment to be thrown when you have a warning i.e. Data
truncated that you should know about.
opError is an operational error i.e. being disconnected,  data source
name not found, etc....
progError is a programming error i.e. table already exists, table not
found, etc...
integrityError is an integirity error in the database's relational
integerity i.e. a foreign key check fails
dataError is a data error, i.e. Numeric value out of range, division by
zero, etc...
internalError is an interntal Database error, i.e. Invalid cursor state,
invalid transaction state, etc...

Bill

> -----Original Message-----
> From:	Andrew Kuchling [SMTP:amk@magnet.com]
> Sent:	Tuesday, September 09, 1997 1:48 PM
> To:	db-sig@python.org
> Subject:	Re: [DB-SIG] What DB-API compliant interfaces are there?
> 
> Bill Tutt <billtut@microsoft.com> wrote:
> >So getting the SOLID ODBC code to work with say, MySQL's Unix odbc
> >interface, or mSQL's Unix odbc interface should
> >be trivial.
> 
> 	Neat!  I may have to try that later...  Wouldn't it then be
> reasonable to repackage the module as a Unix OBDC module for
> Solid/mSQL/MySQL/GNU SQL/whatever, and have small #ifdef's only to get
> the names of the header files right for the various databases?
> 
> >Documentation is always the last thing to get updated.... :)
> 
> 	True enough, but it's something of a pity.  It's really cool
> if Python presents identical interfaces to different databases, but
> the capability isn't really advertised very much.  (It would also help
> if the mSQL module, which is probably the most common, obeyed the
> DB-API.)
> 
> 
> 	Andrew Kuchling
> 	amk@magnet.com
> 	http://starship.skyport.net/crew/amk/
> 
> _______________
> DB-SIG  - SIG on Tabular Databases in Python
> 
> send messages to: db-sig@python.org
> administrivia to: db-sig-request@python.org
> _______________

_______________
DB-SIG  - SIG on Tabular Databases in Python

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