Hi,
I've used slightly different approach:
sel="""SELECT table_name FROM all_tables WHERE owner='XXX'""" #
ORACLE
sel="show tables" # MySQL
sel="SELECT name FROM SQLITE_MASTER WHERE type='table'" # SQLite
con=dbengine.connect()
metadata=DynamicMetaData()
tList = con.execute(sel)
tables=[]
for t in tList:
tables.append(Table(t[0], metadata, autoload=True))
that will give you a list of auto-loaded Table objects.
Valentin.
On Mar 22, 3:59 pm, "Mando" <[EMAIL PROTECTED]> wrote:
> I launched it, but I receive this error message:
>
> Traceback (most recent call last):
> File "autocode.py", line 20, in <module>
> tbl = Table(tname, metadata, schema=schema, autoload=True);
> File "build/bdist.macosx-10.3-fat/egg/sqlalchemy/schema.py", line
> 143, in __call__
> File "build/bdist.macosx-10.3-fat/egg/sqlalchemy/engine/base.py",
> line 505, in reflecttable
> File "build/bdist.macosx-10.3-fat/egg/sqlalchemy/databases/
> postgres.py", line 385, in reflecttable
> KeyError: 'information_schema.cardinal_number'
>
> Somes ideas?
>
> thanks again!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
