Count: users from: pc activateDate: 本日
Count: events eventKey platform2:pc eventDate: 本日 device
Count: events eventKey platform2:pc eventDate: 本日 user
JI Hongfei ronfe
ronfe
/ event_cache.js
Created
December 14, 2015 13:15
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var deviceAttr = { | |
| device: {{deviceID}}, | |
| activateDate: ISODate, | |
| recentSession: ISODate, | |
| platform: [PC, Android, ios], | |
| users: [{{userID}}] | |
| } | |
| var userAttr = { | |
| user: {{userId}}, |
ronfe
/ cache_debug.py
Created
December 2, 2015 04:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from pymongo import MongoClient, DESCENDING | |
| import datetime | |
| import threading | |
| START_DATE = datetime.datetime(2015,7,20) | |
| END_DATE = datetime.datetime(2015, 7,31) | |
| NUM_OF_WORKERS = 10 | |
| db = MongoClient('10.8.8.111:27017')['yangcong-prod25'] | |
| user_attr = db['userAttr'] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // GA closure | |
| (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ | |
| (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), | |
| m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) | |
| })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); | |
| // ua-host mapping | |
| // Use the very first letter in window.location.hostname as key | |
| // TODO: replace with the right GA ua for m.yangcong and vs.yangcong |
ronfe
/ flight_log.csv
Last active
November 29, 2015 12:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Date | Flight No | Aircraft | Registration | Departure | Arrival | STD | STA | ATD | ATA | Cost | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20151129 | CA1283 | B738 | B-5177 | PEK | HLH | 0600+8 | 0801+8 | 0623+8 | 0758+8 | 1050 | |
| 20151129 | KN2287 | HLH | HLD | 1930+8 | 2020+8 | 1921+8 | 2015+8 | 238 | |||
| 20151129 | CN7102 | B738 | B-5482 | HLD | PEK | 2305+8 | 0120+8 | 1310 |
ronfe
/ cache_script.py
Last active
December 1, 2015 03:12
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from pymongo import MongoClient, DESCENDING | |
| import datetime | |
| import threading | |
| START_DATE = datetime.datetime(2015,11,1) | |
| END_DATE = datetime.datetime(2015, 11, 1,1) | |
| NUM_OF_WORKERS = 20 | |
| db = MongoClient('10.8.8.111:27017')['yangcong-prod25'] | |
| user_attr = db['userAttr'] |
ronfe
/ learning_module.csv
Created
November 27, 2015 01:09
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 1 column, instead of 3 in line 6.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 知识点页-点击学习模块|知识点页课前学习，点击“进入”|startLearning|course|所在知识点ID|topicId: ObjectId | |
| 视频页-开始|视频页，视频加载并开始播放|startVideo|video|视频ID|videoId: ObjectId | |
| 视频页-暂停|视频页，点击暂停按钮|pauseVideo|video|视频ID|videoId: ObjectId|用户暂停时的视频时间戳（毫秒单位，下同）|pauseTime: Number | |
| 视频页-恢复|视频页，暂停视频后，再次点击播放|resumeVideo|video|视频ID|videoId: ObjectId|用户点击播放时的视频时间戳|resumeTime: Number | |
| 视频页-回退|视频页，点击回退10秒|rollbackVideo|video|视频ID|videoId: ObjectId|用户回退钱所在的视频时间戳|rollbackIn: Number | |
| 视频页-全屏|视频页，点击全屏|fullSizeVideo|video|视频ID|videoId: ObjectId | |
| 视频页-分享|视频页，点击右上角分享按钮|shareVideo|site|视频ID|videoId: ObjectId|用户分享平台|sharePlatform: String, enum: ['qq', 'qzone'..] | |
| 视频页-交互|视频页，用户完成交互题|answerVideoInteraction|video|视频ID|videoId: ObjectId|交互题ID|interactionId: ObjectId|交互点弹出时刻|startTime: ISODate|用户答案|answer: String | |
| 视频页-拖动|视频页，用户拖动进度条|dragVideo|video|视频ID|videoId: ObjectId|拖动方向|dragDirection: String, enum: ['backward', 'forward']|拖动时视频时间戳|fromTimeStamp: Number|拖动至视频时间戳|toTimeStamp: Number | |
| 视频页-开始巩固|视频页，巩固页面开始|startEmpower|video|视频ID|videoId: ObjectId |
ronfe
/ how_to_calc_users.py
Last active
November 17, 2015 06:50
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| __author__ = 'ronfe' | |
| from pymongo import MongoClient | |
| from bson.objectid import ObjectId | |
| import datetime | |
| db = MongoClient('mongodb://localhost:27017')['yangcong-prod25'] | |
| points = db['points'] | |
| users = db['users'] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # _*_ coding: utf8 _*_ | |
| from pymongo import MongoClient | |
| from bson.objectid import ObjectId | |
| import datetime | |
| # link to db | |
| dbClient = MongoClient('mongodb://localhost:27017') | |
| db = dbClient['yangcong-prod25'] |