[DB-SIG] Oracle+SQLA: Where are my tables?
John W. Shipman
john at nmt.edu
Wed Nov 20 18:46:59 CET 2013
On Wed, 20 Nov 2013, Michael Bayer wrote:
+--
| For SQLAlchemy questions, come on over to our list at
| https://groups.google.com/forum/#!forum/sqlalchemy .
+--
Thanks, I'll bookmark that!
Your suggestion of using echo='debug' got me through the logjam.
My coworker came up with the right value for the schema argument
to .reflect(), and I can see the tables now.
Here are the relevant lines that worked:
================================================================
eng=engine.create_engine(dsn)
meta=schema.MetaData(bind=eng)
meta.reflect(schema='foo')
----------------------------------------------------------------
The meta.tables.keys() values have the form u'foo.TABLE', but
that's no problem.
Thank you very much! If you hadn't helped me, I wouldn't
have known where to turn next.
With gratitude,
John Shipman, Web Developer, National Radio Astronomy Observatories;
john at nmt.edu, http://www.nmt.edu/~shipman/
More information about the DB-SIG
mailing list