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}