On 10/2/15 9:44 AM, Massimiliano della Rovere wrote:
cx-Oracle==5.2
SQLAlchemy==1.0.8
I'm in the weird situation of dealing with an Oracle database with
lowercase identifiers (they were created by another software that
escapes always table/schema/index identifiers).
I get a "NoSuchTableError" whenever I issue a
MetaData(bind=engine, reflect=True)
or a
Table(
"tablename",
metadata,
schema="SCHEMA",
autoload=True,
extend_existing=True,
quote=True)
statement and it doesn't change whether the "quote" parameter is added
or not.
Is there a way to make SQLAlchemy escape identifiers always, without
case mangling?
you get NoSuchTable on straight MetaData(reflect=True)? Please post a
bug report with the full table def I'd have to test that.
using quoted_name will definitely quote the value:
http://docs.sqlalchemy.org/en/rel_1_0/core/sqlelement.html?highlight=quoted#sqlalchemy.sql.elements.quoted_name
Thanks
--
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
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 http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
