Hey David -
I have to apologize, I did the "autoload" support in MySQL in the
quickest way possible, which is to use the "information_schema" code
from Postgres, but that only works in MySQL 5. Using whatever method
Mysql 3/4 has is a TODO.
if anyone wants to give me a freebie and show me the best way to
query for table columns in Mysql 3/4 maybe we can fasttrack getting
this one done !
On Jan 1, 2006, at 12:15 PM, David Geller wrote:
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
-------------------------------------------------------
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
