SQLAlchemy: How to do Table Reflection and MySQL?

darnold darnold992000 at yahoo.com
Mon Oct 22 17:35:23 EDT 2012


On Oct 20, 6:24 pm, Nick Sabalausky
<SeeWebsiteToContac... at semitwist.com> wrote:
> Hi, I'm fairly new to Python, and I'm trying to figure out how to use
> SQLAlchemy to connect to a MySQL DB and use table reflection to set up
> SQLAlchemy's tables. But the  SQLAlchemy documentation is gigantic and
> frankly kinda making my head spin, so I'm having trouble even finding
> any information on how to use its table reflection, mostly just that it
> exists and *can* be done, but not so much "how". My web searching has
> just been turning up examples of SQLite and manually describing the
> tables in Python and having SQLAlchemy create the tables, which isn't
> what I'm looking for.
>
> Is there a simple way to do this somehow? To just connect to a MySQL DB
> and use table reflection?

i'm not brave enough to dig too deeply into SQLAlchemy, but maybe this
will help? :

http://kashififtikhar.blogspot.com/2010/07/using-sqlalchemy-reflection-with-pylons.html

that came up from googling "sqlalchemy table reflection tutorial".



More information about the Python-list mailing list