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 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
-~----------~----~----~----~------~----~------~--~---
