
Untitled
By: a guest on
Jul 29th, 2012 | syntax:
None | size: 0.85 KB | hits: 14 | expires: Never
Sqlalchemy query not consistent between multi tornado instances
topics = self.db.query(Topic).order_by(Topic.updated_at.desc()).limit(20)
class Application(tornado.web.Application):
def __init__(self):
# setup app
from urls import handlers,ui_modules
settings = dict(
debug = options.debug,
static_path = os.path.join(root_dir, "static"),
xsrf_cookies = True,
cookie_secret = "nzjxcjasduuqwheazmu293nsadhaslzkci9023nsadnua9sdads/Vo=",
ui_modules = ui_modules,
)
tornado.web.Application.__init__(self, handlers, **settings)
self.db = scoped_session(sessionmaker(bind=engine,autocommit=False,autoflush=False))
class BaseHandler(web.RequestHandler):
@property
def db(self):
return self.application.db
topic = Topic()
topic.title = u'abcdefg'
self.db.add(topic)
self.db.commit()