[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