debugggggg.py
7.53 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import uuid
def create_app_use_record(user_id, device_number):
study_apps = [{'app_name':"百度英语资料大全", 'app_pid':'com.sailang.EnglishBook','category_id':'25', \
'source_id':'1','time_spent': 100, 'user_id': user_id, 'device_number': device_number},
{'app_name': '开心大学士', 'app_pid': 'com.ksense.study','category_id':'26', 'source_id':'1', \
'time_spent': 200, },
{'app_name': '驾考宝典', 'app_pid': 'com.handsgo.jiakao.android' ,'category_id':'27', 'source_id':'1', \
'time_spent': 300 },
{'app_name': '我爱汉字', 'app_pid': 'com.cronlygames.hanzi' ,'category_id':'28', 'source_id':'1',\
'time_spent': 400},
{'app_name': '拖拖乐3', 'app_pid': 'cn.com.wiisoft.tuotuo' ,'category_id':'57', 'source_id':'1', \
'time_spent': 100}]
for j in range(0,2):
for i in range(0, 2):
time_end_1 = {'time_end': 28800 + i * 1000, 'id':str(uuid.uuid4()).replace('-', '')}
study_app = study_apps[i]
study_app.update(time_end_1)
mm = study_app
ll = len(study_app['app_name'])
ss = study_app['app_name']
################################################
def create_app_use_record_2(user_id, device_number):
study_apps = [{'app_name':'百度英语资料大全', 'app_pid':'com.sailang.EnglishBook','category_id':'25', 'source_id':'1', \
'time_spent': 100, 'user_id': user_id, 'device_number': device_number}
# {'app_name': '开心大学士', 'app_pid': 'com.ksense.study','category_id':'26', 'source_id':'1', \
# 'time_spent': 200, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '驾考宝典', 'app_pid': 'com.handsgo.jiakao.android' ,'category_id':'27', 'source_id':'1', \
# 'time_spent': 300, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '我爱汉字', 'app_pid': 'com.cronlygames.hanzi' ,'category_id':'28', 'source_id':'1',\
# 'time_spent': 400, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '拖拖乐3', 'app_pid': 'cn.com.wiisoft.tuotuo' ,'category_id':'57', 'source_id':'1', \
# 'time_spent': 100, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '幼儿数字算数学习', 'app_pid': 'com.syhrobert1991.infantlearning' ,'category_id':'25', \
# 'source_id':'1', 'time_spent': 200, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '轻松背单词之初中英语', 'app_pid': 'petpestzx.wordroid.model' ,'category_id':'26', \
# 'source_id':'2', 'time_spent': 300, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '有谱－爱学习（数理化）', 'app_pid': 'com.emingren.youpu' ,'category_id':'27', 'source_id':'2', \
# 'time_spent': 400, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '疯狂音标', 'app_pid': 'com.neo.crazyphonetic' ,'category_id':'28', 'source_id':'2', \
# 'time_spent': 100, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '互动作业V3.18.6', 'app_pid': 'com.v.study' ,'category_id':'57', 'source_id':'2', \
# 'time_spent': 250, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '发音背单词', 'app_pid': 'org.liberty.android.fantastischmemo' ,'category_id':'57', \
# 'source_id':'2', 'time_spent': 350, 'user_id': user_id, 'device_number': device_number},
# {'app_name': '语文100', 'app_pid': 'com.kk.kkyuwen' ,'category_id':'57', 'source_id':'2', \
# 'time_spent': 450, 'user_id': user_id, 'device_number': device_number}
]
game_apps = [{'app_name': '小伴龙新', 'app_pid': 'com.xiaobanlong.main' ,'category_id':'37', 'source_id':'1',\
'time_spent': 100, 'user_id': user_id, 'device_number': device_number},
{'app_name': '三国群英传', 'app_pid': 'com.tencent.tmgp.sgqyz' ,'category_id':'38', 'source_id':'1', \
'time_spent': 200, 'user_id': user_id, 'device_number': device_number},
{'app_name': '童言童语', 'app_pid': 'com.lingshi.kids' ,'category_id':'39', 'source_id':'2', \
'time_spent': 300, 'user_id': user_id, 'device_number': device_number},
{'app_name': '从前啊', 'app_pid': 'com.mojie.longlongago' ,'category_id':'37', 'source_id':'2', \
'time_spent': 400, 'user_id': user_id, 'device_number': device_number},
{'app_name': '永恒纪元', 'app_pid': 'com.m37.dtszj.uc' ,'category_id':'38', 'source_id':'2', \
'time_spent': 100, 'user_id': user_id, 'device_number': device_number},
{'app_name': '我的世界新', 'app_pid': 'com.netease.mc.aligames' ,'category_id':'39', 'source_id':'2', \
'time_spent': 200, 'user_id': user_id, 'device_number': device_number},
{'app_name': '球球大作战', 'app_pid': 'com.ztgame.bob', 'category_id': '37', 'source_id': '2', \
'time_spent': 300, 'user_id': user_id, 'device_number': device_number},
{'app_name': '葫芦侠我的世界', 'app_pid': 'com.huluxia.mctool', 'category_id': '38', 'source_id': '2',\
'time_spent': 400, 'user_id': user_id, 'device_number': device_number},
{'app_name': 'QQ游戏V6.8.7', 'app_pid': 'com.tencent.qqgame', 'category_id': '39', 'source_id': '2',\
'time_spent': 100, 'user_id': user_id, 'device_number': device_number},
{'app_name': '99围棋最新', 'app_pid': 'com.r99weiqi.dvd', 'category_id': '37', 'source_id': '2', \
'time_spent': 50, 'user_id': user_id, 'device_number': device_number},
{'app_name': '凯蒂环球之旅', 'app_pid': 'com.tencent.HelloKitty', 'category_id': '37', 'source_id': '2',\
'time_spent': 150, 'user_id': user_id, 'device_number': device_number},
{'app_name': '贪吃蛇大作战', 'app_pid': 'com.wepie.snake.qihoo', 'category_id': '100', 'source_id': '2',\
'time_spent': 250, 'user_id': user_id, 'device_number': device_number}
]
# get date of the last 7 days(include today)
days = ['111111','222222','333333'] # the day should insert app records
for day in days:
for i in range(0, 12):
time_end_1 = {'time_end': int(day) + 28800 + i * 1000, 'id':str(uuid.uuid4()).replace('-', '')}
time_end_2 = {'time_end': int(day) + 29800 + i * 500, 'id':str(uuid.uuid4()).replace('-', '')}
#study_apps[i].update(time_end_1)
#game_apps[i].update(time_end_2)
study_app = study_apps[0]
study_app.update(time_end_1)
ll = len(study_app['app_name'])
ss = study_app['app_name']
game_app = game_apps[i]
game_app.update(time_end_2)
#db.insert('analytics.app_record_copy', study_app)
# db.insert('analytics.app_record_copy', game_app)
if __name__ == '__main__':
create_app_use_record_2('556600', 'HJKKJ1223123')