python展示数据库视图_python – 每个视图更改数据库并访问每个视图的多个数据库...

为每个请求配置和连接对我来说似乎很多工作.我将在我的模型模块中创建四个会话处理程序,并从中进行选择.

例：

models/__init__.py

DBSession1 = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))

DBSession2 = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))

DBSession3 = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))

DBSession4 = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))

metadata1 = MetaData()

metadata2 = MetaData()

metadata3 = MetaData()

metadata4 = MetaData()

def initialize_sql(engines, drop_db=False):

DBSession1.configure(bind=engine[0])

DBSession2.configure(bind=engine[1])

DBSession3.configure(bind=engine[2])

DBSession4.configure(bind=engine[3])

metadata1.bind = engine[0]

metadata2.bind = engine[1]

metadata3.bind = engine[2]

metadata4.bind = engine[3]

然后在你看来：

from mypackage.models import DBSession1, DBSession2, DBSession3, DBSession4

def site_orders(request)

site = request.matchdict['site']

dbsession = globals().get("DBSession%d" % site)

orders = dbsession.query(Order).order_by(Order.cdate.desc())[:100]

return dict(orders=orders, pagetitle=(site+" Orders"))