-
Notifications
You must be signed in to change notification settings - Fork 0
/
LogsProject.py
60 lines (50 loc) · 1.12 KB
/
LogsProject.py
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
#!/usr/bin/python3
import psycopg2
DBNAME = "news"
def popular_articles():
query = """
SELECT title, x
FROM articles4, shortened2
WHERE articles4.concat = shortened2.path
ORDER BY x DESC;
"""
db = psycopg2.connect(database=DBNAME)
c = db.cursor()
c.execute(query)
results = c.fetchall()
for r in results:
print r[0], "--", r[1], "views"
print ""
db.close()
def popular_authors():
query = """
SELECT name, sum(number_of_views)
AS number_of_views
FROM z, y
WHERE z.concat = y.path
GROUP BY name
ORDER BY number_of_views desc;
"""
db = psycopg2.connect(database=DBNAME)
c = db.cursor()
c.execute(query)
results = c.fetchall()
for r in results:
print r[0], "--", r[1], "views"
print ""
db.close()
def errors():
query = """SELECT date,
CONCAT(round(percentage::decimal, 2),'%')
FROM divide
WHERE percentage > 1;"""
db = psycopg2.connect(database=DBNAME)
c = db.cursor()
c.execute(query)
results = c.fetchall()
for r in results:
print r[0], "--", r[1], "views"
db.close()
popular_articles()
popular_authors()
errors()