Path: csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Nick Sabalausky Newsgroups: comp.lang.python Subject: SQLAlchemy: How to do Table Reflection and MySQL? Date: Sat, 20 Oct 2012 19:24:16 -0400 Organization: A noiseless patient Spider Lines: 12 Message-ID: <20121020192416.000023b6@unknown> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Injection-Info: mx04.eternal-september.org; posting-host="af24a2e39430ccc7e48f52be5dd29248"; logging-data="15869"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18R+kxIj10pwnXgoBg8KUy+L6cEDcUxO48=" X-Newsreader: Claws Mail 3.8.0cvs30 (GTK+ 2.16.6; i586-pc-mingw32msvc) Cancel-Lock: sha1:nusFBkkIbcF9yd9PzAYd3tNOCzo= Xref: csiph.com comp.lang.python:31825 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?