#!/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')