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