this approach should work for now, but will need some small
modifications in the next release of SA (i.e. it should be easier):
from sqlalchemy import *
class FakeDBAPI(object):
def __init__(self):
self.paramstyle = 'named'
e = create_engine('oracle://', module=FakeDBAPI()) # or
postgres://, mysql://, etc.
def proxy(statement, params):
print statement
gen = e.dialect.schemagenerator(e, proxy, None)
m = MetaData()
t = Table('table1', m, Column('id', Integer, primary_key=True))
t2 = Table('table2', m, Column('id', Integer, primary_key=True),
Column('t1id', Integer, ForeignKey('table1.id')))
m.accept_visitor(gen)
On Mar 30, 2007, at 4:34 AM, ml wrote:
>
> Hi!
>
> I want meta.create_all() to generate and print the SQL only and don't
> query the DB. Is there any way?
>
> Thanks for advices.
>
> David
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
