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))
