def getToIdToken(self, aToId):
sqlObject = myqslOperation()
utlist = sqlObject.getUserToken(self.db, aToId)
strToken = None
if utlist:
strToken = utlist[0]["user_token"]
return strToken
def composeSendMsg(self, fromId, msg):
sqlObject = myqslOperation()
if fromId:
fromlist = sqlObject.querySQL(self.db, fromId)
fromNick = fromlist[0]["user_nick"]
msgContent = "您的YO友" + fromNick + "说:" + msg
return msgContent
def get(self):
str_userid=self.get_argument("user_id")
str_usernick=self.get_argument("user_nick",default="YOYO")
str_phonenum=self.get_argument("phone_num",default=1234)
sqlobjc=myqslOperation()
sqlobjc.update_user_info(self.db,str_userid,str_usernick,str_phonenum)
resultDict={"result":"ok"}
json_res=ApiCommonResult(resultDict)
self.write(json_res.to_json())
def get(self):
str_userid = self.get_argument("user_id")
str_usernick = self.get_argument("user_nick", default="YOYO")
str_phonenum = self.get_argument("phone_num", default=1234)
sqlobjc = myqslOperation()
sqlobjc.update_user_info(self.db, str_userid, str_usernick,
str_phonenum)
resultDict = {"result": "ok"}
json_res = ApiCommonResult(resultDict)
self.write(json_res.to_json())
def get(self):
#同意添加好友
str_from_id = self.get_argument("fromId")
str_to_id = self.get_argument("toId")
sqlobjc=myqslOperation()
is_update=sqlobjc.update_friend_releation(self.db,str_from_id,str_to_id,1)
if is_update:
self.write(ApiCommonResult(g_resdict).to_json())
else:
resultDict = {"result":"false"}
self.write(ApiCommonResult(resultDict).to_json())
def get(self):
strUserid = self.get_argument("userid")
mysql = myqslOperation()
list = mysql.querySQL(self.db,strUserid)
if list:
jsonRes = ApiCommonResult(list)
self.write(jsonRes.to_json())
else:
jsonRes = ApiCommonResult(list)
jsonRes.success=False
self.write(jsonRes.to_json())
def get(self):
#同意添加好友
str_from_id = self.get_argument("fromId")
str_to_id = self.get_argument("toId")
sqlobjc = myqslOperation()
is_update = sqlobjc.update_friend_releation(self.db, str_from_id,
str_to_id, 1)
if is_update:
self.write(ApiCommonResult(g_resdict).to_json())
else:
resultDict = {"result": "false"}
self.write(ApiCommonResult(resultDict).to_json())
def get(self):
str_device_token = self.get_argument("device_token")
str_userid = self.get_argument("user_id")
str_device_token = str_device_token.replace(" ","")
str_device_token = str_device_token.replace("<","")
str_device_token = str_device_token.replace(">","")
#保存token
sql_object = myqslOperation()
sql_object.inser_user_deviceToken(self.db,str_userid,str_device_token)
self.write('ok')
"""
def get(self):
#判断是否有还有添加我的消息
str_userid = self.get_argument("user_id")
sqlObjc = myqslOperation()
list = sqlObjc.get_is_have_addfriend_msg(self.db,str_userid)
res_dict = {"result":"ok"}
if list:
json_res = ApiCommonResult(res_dict)
self.write(json_res.to_json())
else:
res_dict["result"]="fail"
json_res = ApiCommonResult(res_dict)
self.write(json_res.to_json())
def get(self):
#判断是否有还有添加我的消息
str_userid = self.get_argument("user_id")
sqlObjc = myqslOperation()
list = sqlObjc.get_is_have_addfriend_msg(self.db, str_userid)
res_dict = {"result": "ok"}
if list:
json_res = ApiCommonResult(res_dict)
self.write(json_res.to_json())
else:
res_dict["result"] = "fail"
json_res = ApiCommonResult(res_dict)
self.write(json_res.to_json())
def get(self):
str_device_token = self.get_argument("device_token")
str_userid = self.get_argument("user_id")
str_device_token = str_device_token.replace(" ", "")
str_device_token = str_device_token.replace("<", "")
str_device_token = str_device_token.replace(">", "")
#保存token
sql_object = myqslOperation()
sql_object.inser_user_deviceToken(self.db, str_userid,
str_device_token)
self.write('ok')
"""
def get(self):
#获取好友
resultlist = None
if self.get_argument("userId"):
str_userid = self.get_argument("userId")
if self.get_argument("friTime"):
str_fritime = self.get_argument("friTime")
if str_userid:
sqlobjc=myqslOperation()
friendlist=sqlobjc.get_user_friend(self.db,str_userid, str_fritime)
packlist = self.packet_friend(friendlist,str_userid,sqlobjc)
if packlist:
resultlist = packlist[0]
currentTime = packlist[1]
self.write(ApiCommonResult(resultlist, cTime=currentTime).to_json())
def get(self):
#获取好友
resultlist = None
if self.get_argument("userId"):
str_userid = self.get_argument("userId")
if self.get_argument("friTime"):
str_fritime = self.get_argument("friTime")
if str_userid:
sqlobjc = myqslOperation()
friendlist = sqlobjc.get_user_friend(self.db, str_userid,
str_fritime)
packlist = self.packet_friend(friendlist, str_userid, sqlobjc)
if packlist:
resultlist = packlist[0]
currentTime = packlist[1]
self.write(ApiCommonResult(resultlist, cTime=currentTime).to_json())
def get(self):
str_userid = self.get_argument("user_id")
sqlObjc = myqslOperation()
list1 = sqlObjc.get_is_have_addfriend_msg(self.db,str_userid)
res_dict = {"result":None}
resultList=[]
if list1:
for msgDict in list1:
from_list=sqlObjc.querySQL(self.db,msgDict["from_id"])
resultDict = {"fromNick":from_list[0]["user_nick"],"fromId":msgDict["from_id"],"toNick":"","toId":msgDict["to_id"]}
resultList.append(resultDict)
json_res = ApiCommonResult(resultList)
self.write(json_res.to_json())
else:
json_res = ApiCommonResult(res_dict)
self.write(json_res.to_json())
def get(self):
strFromUserid = self.get_argument("fromUserid")
strToUserid = self.get_argument("toUserid")
sqlObjc = myqslOperation()
isAddRecord = sqlObjc.get_is_addrecord_relation(self.db,strFromUserid,strToUserid)
resDict = {"status":0}
if not isAddRecord:
to_from_list = sqlObjc.get_friend_relation(self.db,strToUserid)
if to_from_list:
for a in to_from_list:
if a.to_id == strFromUserid:#同时修改to-from的status值
sqlObjc.update_friend_releation(self.db,strToUserid,strFromUserid,1)
resDict = {"status":1}
break
else:
resDict={"status":2}
if resDict["status"]!=2:
sqlObjc.insertFriendRelation(strFromUserid,strToUserid,resDict["status"],self.db)
jsonRes = ApiCommonResult(resDict)
self.write(jsonRes.to_json())
def get(self):
str_userid = self.get_argument("user_id")
sqlObjc = myqslOperation()
list1 = sqlObjc.get_is_have_addfriend_msg(self.db, str_userid)
res_dict = {"result": None}
resultList = []
if list1:
for msgDict in list1:
from_list = sqlObjc.querySQL(self.db, msgDict["from_id"])
resultDict = {
"fromNick": from_list[0]["user_nick"],
"fromId": msgDict["from_id"],
"toNick": "",
"toId": msgDict["to_id"]
}
resultList.append(resultDict)
json_res = ApiCommonResult(resultList)
self.write(json_res.to_json())
else:
json_res = ApiCommonResult(res_dict)
self.write(json_res.to_json())
def get(self):
strFromUserid = self.get_argument("fromUserid")
strToUserid = self.get_argument("toUserid")
sqlObjc = myqslOperation()
isAddRecord = sqlObjc.get_is_addrecord_relation(
self.db, strFromUserid, strToUserid)
resDict = {"status": 0}
if not isAddRecord:
to_from_list = sqlObjc.get_friend_relation(self.db, strToUserid)
if to_from_list:
for a in to_from_list:
if a.to_id == strFromUserid: #同时修改to-from的status值
sqlObjc.update_friend_releation(
self.db, strToUserid, strFromUserid, 1)
resDict = {"status": 1}
break
else:
resDict = {"status": 2}
if resDict["status"] != 2:
sqlObjc.insertFriendRelation(strFromUserid, strToUserid,
resDict["status"], self.db)
jsonRes = ApiCommonResult(resDict)
self.write(jsonRes.to_json())
