wanzb_v3_api/src/tools/player_to_usermatch.py

#coding:utf-8
import os
import time
import datetime
import sys
import django
from django.core.cache import cache
from django.db import connection

sys.path.append('/mnt/wzbapi/src')
os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
django.setup()

import common.models as cm
import common.common_control as ccc
import common.common_functions as ccf

def player_to_usermatch():
    """选手转用户赛事关联
    """
    players = cm.Player.objects.all()
    for item in players:
        user_id = item.user_id
        signup_name = item.username
        match_id = item.match_id
        match_group = item.match_group
        fund = item.fund
        match_status = item.match_status

        obj,flag = cm.UserMatch.objects.get_or_create(
            user_id = user_id,
            match_id = match_id,
            match_group = match_group
        )
        obj.signup_name = signup_name
        obj.fund = fund
        obj.match_status = match_status
        obj.save()


def user_follow():
    """选手转用户赛事关联
    """
    players = cm.UserFollows.objects.all()
    for item in players:
        player_id = item.user_id
        player = cm.Player.objects.filter(id=player_id).first()
        if player:
            user_id = player.user_id

            item.user_id = user_id
            item.save()

if __name__ == "__main__":
    print "start update group rank..."
    st = time.time()
    #player_to_usermatch()
    user_follow()
    print "time cost:",time.time()-st