Mobile-Data-Analytics/app.py at master · oss/Mobile-Data-Analytics · GitHub

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
from flask import Flask, render_template
import json
import MySQLdb
import datetime
import config
from calendar import monthrange

app = Flask(__name__)

db = MySQLdb.connect(config.host,
		    config.user,
		    config.passwd,
		    config.db)

cur = db.cursor()

app.route("/")
def index():
    return render_template("index.html")

app.route("/test")
def test():
    return "test"

def monthly_unique_users():
    cur.execute("SELECT COUNT(DISTINCT uuid) from analytics")
    print "monthly active"
    for row in cur.fetchall():
	print row[0]

def weekly_unique_users():
    weeks = ["2014-07-01", "2014-07-08", "2014-07-15", "2014-07-22", "2014-07-31"]
    print "start","end","\t","active"
    print "-----","---","\t","------"
    for w in xrange(len(weeks)-1):
	start = weeks[w]
	end = weeks[w+1]
	cur.execute("SELECT COUNT(DISTINCT uuid) from analytics where date between %s and %s", (start,end,))
	for row in cur.fetchall():
	    print start,end,"\t",row[0]


def daily_unique_users():
    print "start","end","\t","active"
    print "-----","---","\t","------"
    for w in xrange(30):
	start = "2014-07-"+str(w)
	end = "2014-07-"+str(w+1)
	cur.execute("SELECT COUNT(DISTINCT uuid) from analytics where date between %s and %s", (start,end,))
	for row in cur.fetchall():
	    print start,end,"\t",row[0]

def monthly_active_users(k):
    """
	k = minimum events to count as active
    """
    pass

def daily_active_users(k):
    print "actives with more than ",k,"events"
    print "start\t","end","\t","active"
    print "-----\t","---","\t","------"
    for w in xrange(30):
	users = {}
	daily_count = 0
	uniques = {}
	start = "2014-07-"+str(w+1)
	end = "2014-07-"+str(w+2)
	cur.execute("SELECT uuid, handle from analytics where date between %s and %s", (start,end,))
	for row in cur.fetchall():
	    if row[0] not in users:
		users[row[0]] = 0
	    users[row[0]] += 1

	    if users[row[0]] > k:
		if row[0] not in uniques:
		    uniques[row[0]] = True

	print start, "\t", end, "\t", str(len(uniques))

# daily_active_users(3)


if __name__ == "__main__":
    app.run(host='0.0.0.0', port=5000, debug=True)