def get(self): try: query = "SELECT * FROM %s WHERE frame_id=(SELECT MAX(frame_id) FROM %s);"%(hisTable,hisTable) data = query_all(query) self.write(json.dumps(BaseHandler.success_ret_with_data(data), default=decimal_default)) except Exception as e: self.write(json.dumps(BaseHandler.error_ret())) print("BTC_TransferFund error:%s", format(e))
async def post(self): ret = {'code': 100, 'data': None} try: async with AsyncMysqlConn("read") as conn: data =await conn.select_many("select * from t_course",) ret['data']=data except Exception as e: logging.exception(e) self.write(BaseHandler.error_ret()) else: self.write(BaseHandler.success_ret_with_data(ret))
def get(self): btc_rpc_connection = AuthServiceProxy(BTC_RPC_URL)#todo-junying-20180325 try: account = self.get_argument("account").decode("utf-8") if account is None or len(account) == 0: self.write(json.dumps(BaseHandler.error_ret())) return commands = [["getbalance", account]] data = btc_rpc_connection.batch_(commands) self.write(json.dumps(BaseHandler.success_ret_with_data(data), default=decimal_default)) except Exception as e: self.write(json.dumps(BaseHandler.error_ret_with_data("error: %s"%e))) print("BTC_GetAccountBalance error:{0} in {1}".format(e,get_linenumber()))
async def post(self): args = escape.json_decode(self.request.body) course_id = args.get("id", None) ret = {'code': 100, 'data': None} try: async with AsyncMysqlConn("read") as conn: data =await conn.select_one("select * from t_course_detail where course_id=%s",[course_id]) tmp = [] if data.get("recommend_courses"): for i in data["recommend_courses"].split(","): title = await conn.select_one_value("select title from t_course where id=%s",[int(i)]) tmp.append({"id":int(i),"title":title}) data["recommend_courses"]=tmp ret['data']=data except Exception as e: logging.exception(e) self.write(BaseHandler.error_ret()) else: self.write(BaseHandler.success_ret_with_data(ret))
async def post(self): print("new signup") args = escape.json_decode(self.request.body) print(args) login_method = args.get("signup_method", None) try: if login_method == "phone number": result = await SignupFunc.phone_login(args) elif login_method == "phone verify": result = await SignupFunc.sms_verify(args) elif login_method == "webchat": # 用户扫码登陆 result = await LoginFunc.wetcht_login(args) else: result = await SignupFunc.normal_login(args) except Exception as e: logging.exception(e) self.write(BaseHandler.error_ret()) else: self.write(BaseHandler.success_ret_with_data(result))