def my_view(self): """ """ try: one = DBSession.query(MyModel).filter(MyModel.name == 'one').first() except DBAPIError: return Response(conn_err_msg, content_type='text/plain', status_int=500) return {'one': one, 'project': 'alchemy_proj'}
def login(self): """ """ print "=====login========self.session========", self.session try: user = DBSession.query(User).filter(User.user_name == "saju").first() if user: self.session["vv"] = user.user_name ##SM:Check whether session allow to save object. self.session["ss"] = self self.session.changed()##Save except DBAPIError: return Response(conn_err_msg, content_type='text/plain', status_int=500) return {"success":True, "msg":"Login success"}
def transaction_test(self): """ """ msg = "" try: if self.request.params: name = self.request.params.get("name") trans = self.request.params.get("trans", "1") fst = DBSession.query(MyModel).filter(MyModel.name == name).first() if fst: msg = "row already exist with name:%s" %(name) else: d = MyModel() d.name = name d.value = "30" DBSession.add(d) msg = "Row successfully saved" if not int(trans):##Abort/Commit Transaction raise Exception("Abort Transaction") except DBAPIError: return Response(conn_err_msg, content_type='text/plain', status_int=500) return {"success":True, "msg":msg}