コード例 #1
0
def make_file(split_date, server_id):
    new_log_lst = read_one_day_data(
        "USER_DETAIL",
        split_date,
        'tables',
        server_id,
    )

    user_num_dict = dict()
    lost_user_num_dict = dict()
    for dat in new_log_lst:
        for value in dat.values():
            cur_lv = value['level']
            if split_date == value['install']:
                user_num_dict[cur_lv] = user_num_dict.get(cur_lv, 0) + 1

    next_split_date = split_date + datetime.timedelta(days=1)
    next_day_log_lst = read_one_day_data(
        "USER_DETAIL",
        next_split_date,
        'tables',
        server_id,
    )
    #这里再查第二天的new_log_lst
    for dat in next_day_log_lst:
        for value in dat.values():
            cur_lv = value['level']
            if split_date == value['install'] and value['last_play_time'].date(
            ) == value['install']:
                lost_user_num_dict[cur_lv] = lost_user_num_dict.get(cur_lv,
                                                                    0) + 1

    num_total = 0
    for _table_lv in xrange(1, 121):
        num_total += user_num_dict.get(_table_lv, 0)

    # 遍历全部等级
    table_row_lst = []
    for _table_lv in xrange(1, 121):
        # 停留人数
        user_num = user_num_dict.get(_table_lv, 0)
        # 流失人数
        lost_num = lost_user_num_dict.get(int(_table_lv), 0)
        # 留存人数
        stand_num = user_num - lost_num
        # 等级比率
        level_rate = str(_get_rate(user_num, num_total) * 100) + "%"
        # 留存人数比率
        level_lost_rate = str(_get_rate(stand_num, num_total) * 100) + "%"
        # 等级	停留人数	留存人数比率	等级流存率
        content = [_table_lv, user_num, level_rate, level_lost_rate]
        table_row_lst.append(content)
    return table_row_lst
コード例 #2
0
def make_action_file(search_date, server_id):
    table_lst = []
    computle = set()
    all_uid_count = set()
    try:
        all_list = dat_log_util.read_one_day_data(
            'EVENT_ACTION_ACTIVITY_TIME_LIMITED_SHIFT_SHOP', search_date,
            'all_action', server_id)[0]
    except:
        print 'EVENT_ACTION_ACTIVITY_TIME_LIMITED_SHIFT_SHOP 不存在 或为空'
    try:
        rqui = dat_log_util.read_one_day_data('EVENT_ACTION_ROLE_LOGIN',
                                              search_date, 'all_action',
                                              server_id)[0]
    except:
        print 'EVENT_ACTION_ROLE_LOGIN 不存在 或为空'

    for _num in rqui:
        computle.add(_num['dev_id'])
    computle = len(computle)
    result_dict = dict()
    for _lst in all_list:
        # 循环 出物品名字
        if len(_lst['add_item_list']):
            item_tid = game_config.get_item_config(
                int(_lst['add_item_list'][0]))['name']
            user_uid = _lst['uid']
            all_uid_count.add(_lst['uid'])
            if item_tid in result_dict:
                result_dict[item_tid]['item_num'] += 1
                result_dict[item_tid]['user_set'].add(user_uid)
            else:
                result_dict[item_tid] = {'item_num': 1, 'user_set': {user_uid}}
    for _val in result_dict.values():
        user_num = len(_val['user_set'])
        _val['user_num'] = user_num
        _val.pop('user_set')
        _val['ex_pre'] = str(
            round(float(_val['user_num']) / float(computle), 3)) + '%'
        _val['person_pre'] = str(
            round(float(_val['user_num']) / float(len(all_uid_count)))) + '%'

    for key in result_dict:
        table_lst.append([
            key,
            result_dict[key]['item_num'],
            result_dict[key]['user_num'],
            result_dict[key]['ex_pre'],
            result_dict[key]['person_pre'],
        ])
    return table_lst
コード例 #3
0
def make_file(split_date, server_id):
    new_log_lst = read_one_day_data("USER_DETAIL", split_date, "tables", server_id)

    user_num_dict = dict()
    lost_user_num_dict = dict()
    for dat in new_log_lst:
        for value in dat.values():
            cur_lv = value["level"]
            if split_date == value["install"]:
                user_num_dict[cur_lv] = user_num_dict.get(cur_lv, 0) + 1

    next_split_date = split_date + datetime.timedelta(days=1)
    next_day_log_lst = read_one_day_data("USER_DETAIL", next_split_date, "tables", server_id)
    # 这里再查第二天的new_log_lst
    for dat in next_day_log_lst:
        for value in dat.values():
            cur_lv = value["level"]
            if split_date == value["install"] and value["last_play_time"].date() == value["install"]:
                lost_user_num_dict[cur_lv] = lost_user_num_dict.get(cur_lv, 0) + 1

    num_total = 0
    for _table_lv in xrange(1, 121):
        num_total += user_num_dict.get(_table_lv, 0)

    # 遍历全部等级
    table_row_lst = []
    for _table_lv in xrange(1, 121):
        # 停留人数
        user_num = user_num_dict.get(_table_lv, 0)
        # 流失人数
        lost_num = lost_user_num_dict.get(int(_table_lv), 0)
        # 留存人数
        stand_num = user_num - lost_num
        # 等级比率
        level_rate = str(_get_rate(user_num, num_total) * 100) + "%"
        # 留存人数比率
        level_lost_rate = str(_get_rate(stand_num, num_total) * 100) + "%"
        # 等级	停留人数	留存人数比率	等级流存率
        content = [_table_lv, user_num, level_rate, level_lost_rate]
        table_row_lst.append(content)
    return table_row_lst
コード例 #4
0
ファイル: max_will.py プロジェクト: bestainan/GameLogParse
def make_action_file(search_date,server_id):
    global first, second, third, fourth,fifth,sixth,seventh    # 取事件的文件
    table_lst = []
    seven_lv_data = dat_log_util.read_one_day_data('',search_date,'all_action',server_id)
    for _server_list in seven_lv_data:
        for _action_dict in _server_list:
            log_time = _action_dict['log_time'].strftime('%Y-%m-%d')
            if _action_dict['recharge_sum_id']   == 1  :   first += 1
            elif _action_dict['recharge_sum_id'] == 2  :   second += 1
            elif _action_dict['recharge_sum_id'] == 3  :   third += 1
            elif _action_dict['recharge_sum_id'] == 4  :   fourth += 1

            row = [log_time,first, second, third, fourth]
        table_lst.append(row)
    return table_lst
コード例 #5
0
ファイル: max_will.py プロジェクト: cash2one/GameLogParse
def make_action_file(search_date, server_id):
    global first, second, third, fourth, fifth, sixth, seventh  # 取事件的文件
    table_lst = []
    seven_lv_data = dat_log_util.read_one_day_data('', search_date,
                                                   'all_action', server_id)
    for _server_list in seven_lv_data:
        for _action_dict in _server_list:
            log_time = _action_dict['log_time'].strftime('%Y-%m-%d')
            if _action_dict['recharge_sum_id'] == 1: first += 1
            elif _action_dict['recharge_sum_id'] == 2: second += 1
            elif _action_dict['recharge_sum_id'] == 3: third += 1
            elif _action_dict['recharge_sum_id'] == 4: fourth += 1

            row = [log_time, first, second, third, fourth]
        table_lst.append(row)
    return table_lst
コード例 #6
0
def make_action_file(search_date,server_id):
    global first, second, third, fourth   # 取事件的文件
    row = []
    table_lst = []
    seven_lv_data = dat_log_util.read_one_day_data('EVENT_ACTION_ACTIVITY_SEVEN_POWER_REWARD',search_date,'all_action',server_id)
    for _server_list in seven_lv_data:
        for _action_dict in _server_list:
            log_time = _action_dict['log_time'].strftime('%Y-%m-%d')
            if _action_dict['seven_power_id']   == 1  :   first += 1
            elif _action_dict['seven_power_id'] == 2  :   second += 1
            elif _action_dict['seven_power_id'] == 3  :   third += 1
            elif _action_dict['seven_power_id'] == 4  :   fourth += 1

            row = [log_time,first, second, third, fourth]
        table_lst.append(row)
    return table_lst
コード例 #7
0
def make_action_file(search_date,server_id):
    global first, second, third, fourth   # 取事件的文件
    row = []
    table_lst = []
    seven_lv_data = dat_log_util.read_one_day_data('EVENT_ACTION_ACTIVITY_SEVEN_LEVEL_REWARD',search_date,'all_action',server_id)
    for _server_list in seven_lv_data:
        for _action_dict in _server_list:
            log_time = _action_dict['log_time'].strftime('%Y-%m-%d')
            if _action_dict['seven_level_id']   == 1  :   first += 1
            elif _action_dict['seven_level_id'] == 2  :   second += 1
            elif _action_dict['seven_level_id'] == 3  :   third += 1
            elif _action_dict['seven_level_id'] == 4  :   fourth += 1

            row = [log_time,first, second, third, fourth]
        table_lst.append(row)
    return table_lst
コード例 #8
0
def make_action_file(search_date,server_id):
    global first, second, third, fourth,fifth,sixth,seventh    # 取事件的文件
    table_lst = []
    row = []
    all_dict = dat_log_util.read_one_day_data('EVENT_ACTION_ACTIVITY_STONE_CONSUMPTION_REWARD',search_date,'all_action',server_id)
    for _server_list in all_dict:
        for _action_dict in _server_list:
            log_time = _action_dict['log_time'].strftime('%Y-%m-%d')
            if _action_dict['activity_tid']   == 1  :   first += 1
            elif _action_dict['activity_tid'] == 2  :   second += 1
            elif _action_dict['activity_tid'] == 3  :   third += 1
            elif _action_dict['activity_tid'] == 4  :   fourth += 1
            elif _action_dict['activity_tid'] == 5  :   fifth += 1
            elif _action_dict['activity_tid'] == 6  :   sixth += 1
            elif _action_dict['activity_tid'] == 7  :   seventh += 1

            row = [log_time,first, second, third, fourth,fifth,sixth,seventh]
        table_lst.append(row)
    return table_lst
コード例 #9
0
def make_action_file(search_date, server_id):
    global first, second, third, fourth, fifth, sixth, seventh  # 取事件的文件
    table_lst = []
    row = []
    all_dict = dat_log_util.read_one_day_data(
        'EVENT_ACTION_ACTIVITY_STONE_CONSUMPTION_REWARD', search_date,
        'all_action', server_id)
    for _server_list in all_dict:
        for _action_dict in _server_list:
            log_time = _action_dict['log_time'].strftime('%Y-%m-%d')
            if _action_dict['activity_tid'] == 1: first += 1
            elif _action_dict['activity_tid'] == 2: second += 1
            elif _action_dict['activity_tid'] == 3: third += 1
            elif _action_dict['activity_tid'] == 4: fourth += 1
            elif _action_dict['activity_tid'] == 5: fifth += 1
            elif _action_dict['activity_tid'] == 6: sixth += 1
            elif _action_dict['activity_tid'] == 7: seventh += 1

            row = [
                log_time, first, second, third, fourth, fifth, sixth, seventh
            ]
        table_lst.append(row)
    return table_lst
コード例 #10
0
def make_action_file(search_date, server_id):

    new_log_lst = dat_log_util.read_one_day_data("USER_DETAIL", search_date,
                                                 'tables', server_id)

    print len(new_log_lst)
コード例 #11
0
def make_action_file(search_date, server_id):

    new_log_lst = dat_log_util.read_one_day_data("USER_DETAIL",search_date,'tables',server_id)

    print len(new_log_lst)