Hi,
This is my first crack at sqlalchemy.
I am trying to use reflection to create metadata objects from existing
tables, like so:
t = Table("existing_table", db, autoload=True)
However, I am getting an exception:
_mysql_exceptions.ProgrammingError: (1146, "Table
'information_schema.columns' doesn't exist")
(mysql is version 4.1.12, sqlalchemy is latest from svn).
I tried this with the "blogs" table from the zblog example, which
produced this sql, but the same error:
SELECT columns.table_schema, columns.table_name, columns.column_name,
columns.is_nullable, columns.data_type, columns.ordinal_position,
columns.character_maximum_length, columns.numeric_precision,
columns.numeric_scale
FROM information_schema.columns
WHERE columns.table_name = %s AND columns.table_schema = %s ORDER BY
columns.ordinal_position
['blogs', 'zblog1']
What I would *like* to do, is reflect from my existing database, and
create python code for the metadata description, so I will have
something to work with for future database tweaking, in source form.
Thanks!
David Geller
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
