Django学习笔记（三十五）:接入玩家信息发送接口

接入玩家信息发送接口，渠道方通过访问我们提供的接口，将玩家部分数据传递给我们，我们通过get方式将参数进行获取，

再将获取的参数通过服务器的数据库进行查询然后返回给渠道方。

@Route(r'^log/serverlist$')
@notauth
def query_server(request):
    '''
    查询服务器列表
    '''
    try:
        server = Server.objects.all()
        server_list = []
        for item in server:
            server_list.append({"name":item.name,"id":item.id})
        return HttpResponse(json.dumps({"code":200,"msg":server_list}))
    except BaseException as e:
        return HttpResponse(json.dumps({"code":404,"msg":e}))


@Route(r'^log/user$')
@notauth
def query_user(request):
    '''
    查询用户是否合法
    '''
    userid = int(request.GET.get("userid"))
    serverid = int(request.GET.get("serverid"))
    user_dict = {}
    try:
        conn = getConn(serverid)
        cur = conn.cursor()
        sql = ' select link_key,player_name,player_id,channel_id,lpc.f3 from player_%d as p LEFT JOIN (select f3,log_user FROM log_player_coin where f1 =1 and log_user = %d and log_time = (select max(log_time) FROM log_player_coin where f1 =1 and log_user = %d)) as lpc on lpc.log_user = p.player_id where player_id = %d ;' % (serverid,userid,userid,userid)
        cur.execute(sql)
        query_list = cur.fetchone()
        print query_list
        if query_list:
            user_dict["link_key"] = query_list[0]
            user_dict["player_name"] = query_list[1]
            user_dict["player_id"] = query_list[2]
            user_dict["channel_id"] = query_list[3]
            user_dict["gold"] = query_list[4]
            user_dict["server_id"] = serverid
            return HttpResponse(json.dumps({"code":200,"msg":user_dict}))
        else:
            return HttpResponse(json.dumps({"code":404,"msg":"userid or serverid error"}))
    except BaseException as e:
        return HttpResponse(json.dumps({"code":404,"msg":e}))


@Route(r'^log/orderlist$')
@notauth
def query_orderlist(request):
    '''
    订单
    '''
    userid = int(request.GET.get("userid"))
    time = int(request.GET.get("time"))
    try:
        conn = getConn()
        cur = conn.cursor()
        sql = 'select open_id,player_name,pay_user,server_id,channel_id,pay_gold,post_time,channel_key,pay_amount from pay_action where  post_time > FROM_UNIXTIME(%d) and pay_user = %d;'%(time,userid)
        cur.execute(sql)
        quert_list = cur.fetchall()
        user_list = []
        if quert_list:
            for item in quert_list:
                user_list.append({"open_id":item[0],"player_name":item[1],"pay_user":item[2],"server_id":item[3],"channel_id":item[4],"pay_gold":item[5],"post_time":str(item[6]),"channel_key":item[7],"pay_amount":item[8]})
            return HttpResponse(json.dumps({"code":200,"msg":user_list}))
        else:
            return HttpResponse(json.dumps({"code":200,"msg":"该时间戳节点后无该玩家充值数据"}))
    except BaseException as e:
        return HttpResponse(json.dumps({"code":404,"msg":e}))


@Route(r'^log/playermsg$')
@notauth
def query_playermsg(request):
    '''
    查询玩家id
    '''
    serverid = int(request.GET.get("serverid"))
    playername = request.GET.get("playername")
    playername = playername.decode("utf-8")
    print(serverid,playername,type(playername))
    try:
        conn = getConn(serverid)
        print(1111111)
        cur = conn.cursor()
        print(1122221)
        sql = ''' select player_id from player_%d where player_name = "%s" ''' % (serverid, playername)
        print(sql)
        cur.execute(sql)
        print(33333333333)
        query_list = cur.fetchone()
        print query_list
        if query_list:
            return HttpResponse(json.dumps({"code": 200, "playerid": query_list[0]}))
        else:
            return HttpResponse(json.dumps({"code": 404, "errormsg": "username or serverid error"}))
    except BaseException as e:
        return HttpResponse(json.dumps({"code": 404, "errormsg": e}))