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.execu
I launched it, but I receive this error message:
Traceback (most recent call last):
File "autocode.py", line 20, in
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
An example of a working script that uses this technique is here:
http://www.sqlalchemy.org/trac/attachment/wiki/UsageRecipes/AutoCode/autocode.py
Paul
On 3/21/07, Mando <[EMAIL PROTECTED]> wrote:
>
>
> > select([information_schema.tables.c.table_name,
> > information_schema.tables.c.tabl
> select([information_schema.tables.c.table_name,
> information_schema.tables.c.table_schema])
Sorry, but I don't undestand how.
I saw that information_schema is a module inside sqlalchemy/databases/
information_schema.py, but I don't know how call it.
I've tried to do something like th
Hi,
The metadata only knows about the tables defined in SA. To get all the
tables in the db, do a query like:
select([information_schema.tables.c.table_name,
information_schema.tables.c.table_schema])
Paul
>but I've received only a empty dict.
>What's the right method?
>
>
--~--~-