im not familiar with what "__metada__" is and this seems to be an
elixir specific issue. metadata.drop_all()/create_all() always do
what they say.
On Jun 19, 2008, at 2:01 PM, lilo wrote:
>
> I have tried this command:
> a.a_metadata.drop_all(bind=db)
> a.a_metadata.create_all(bind=db)
>
> and they don't create any tables and I don't get any error at all.
>
> With, setup_all(True, bind=db), creates table A and B on each engine.
> I just want table A on m1,m2 and table B on n1,n2. I have spent quite
> some time searching and going over the docs but I can't figure out the
> problem is.
>
> =================================================================
> ### file c.py
>
> #!/usr/bin/env python
>
> from sqlalchemy import create_engine
>
> import b
> import a
>
> m1 = create_engine("mysql://m1:[EMAIL PROTECTED]:3306/m1", echo=True)
> m2 = create_engine("mysql://m2:[EMAIL PROTECTED]:3306/m2", echo=True)
>
> n1 = create_engine("mysql://n1:[EMAIL PROTECTED]:3306/n1", echo=True)
> n2 = create_engine("mysql://n2:[EMAIL PROTECTED]:3306/n2", echo=True)
>
> # create tables
> for db in (m1, m2):
> a.a_metadata.drop_all(bind=db)
> a.a_metadata.create_all(bind=db)
>
> #setup_all(True, bind=db)
>
> for db in (n1, n2):
> # setup_all(True, bind=db)
> b.b_metadata.drop_all(bind=db)
> b.b_metadata.create_all(bind=db)
>
> =======================================================
> ### file a.py
>
> from elixir import *
>
> from datetime import datetime
>
> a_metadata = metadata
> __metada__ = a_metadata
>
> class A(Entity):
> using_options(tablename='a', auto_primarykey = False)
> aname = Field(String(30), primary_key = True, nullable = False,
> unique=True)
>
> =========================================================
> ### file b.py
>
> from elixir import *
>
> from datetime import datetime
>
> b_metadata = metadata
> __metada__ = b_metadata
>
> class B(Entity):
> using_options(tablename='b', auto_primarykey = False)
> bname = Field(String(30), primary_key = True, nullable = False,
> unique=True)
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
