[Zope-DB] SQL exception handling questions
Luis Mariano Luporini
Mon, 17 Mar 2003 12:57:16 -0300
I'm trying to learn more about Zope/Python. I think it's a really
Now my situation:
I'm using Zope 2.6.1 w/ Python 2.1.3, z/psycopg 1.1.2 and
Postgres 7.3 on Gentoo Linux.
I have a connection open to the pg server, I can
select/delete/insert/update without problems.
I have now a ZSql method that performs an insert and I have a
Python Script that calls it. I'd like to check if the execution of the
insert operation was succesful and if not, the reason.
Now the questions:
1) I've read about try/except and StandarError.
if I use something like:
except StandardError, e:
I got a whole string containing the sql executed an a description
of the error. So what is e really? Can I get an error number,
description and more information out of e? If not how can i do it?
2) Trying to specialize the exception treated I changed
StandardError for IntegrityError/DatabaseError but in both cases i got:
*Error Type: NameError*
Error Value: global name 'DatabaseError/IntegrityError' is not
Then i added to the script "import psycopg", with the same
results and finally tried "import psycopg.Error" and got
*Error Type: ImportError*
Error Value: import of "psycopg.Error" is unauthorized
So which way I have to go?
Thanks in advance.
¡Internet GRATIS es Yahoo! Conexión!
Usuario "yahoo", contraseña "yahoo".
Desde Buenos Aires, 4004-1010.
Otras ciudades: http://conexion.yahoo.com.ar/avanzados.html