Hi,
I need access to MySQLdb.connection.error() and MySQLdb.connection.errno(), as
we have a database which is throwing custom error codes that are higher than
CR_MAX_ERROR (for reference:
https://github.com/PyMySQL/mysqlclient-python/blob/master/_mysql.c#L124)
My actual code looks like something along these lines:
from sqlalchemy import create_engine, text
engine = create_engine(url)
sql = "SELECT... "
try:
conn = engine.connect()
rows = conn.execute(text(sql))
except Exception as e:
if hasattr(conn.connection, "error"):
print(conn.connection.errno())
print(conn.connection.error())
I've also tried:
err_conn = conn._branch()
try:
err_conn = engine.connect()
rows = err_conn.execute(text(sql))
except Exception as e:
if hasattr(err_conn.connection, "error"):
print(err_conn.connection.errno())
print(err_conn.connection.error())
with no luck.
I'm not sure how to write a minimal test that just uses vanilla MySQL, because
I'm not sure how to trigger an error with a errno > CR_MAX_ERROR other than in
our system.
I'm losing the information somehow, via a connection being closed/reopened or
something? I'm not really sure. What might be the a way to handle this without
just using raw_connection or writing a new dialect?
Thanks,
Brian
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
