-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
139 lines (114 loc) · 3.7 KB
/
app.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
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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
from bs4 import BeautifulSoup
from urllib2 import urlopen
from flask import Flask , render_template
from flask import abort
from flask.ext.sqlalchemy import SQLAlchemy
import os
app = Flask(__name__)
#config
app.config.from_object(os.environ['APP_SETTINGS'])
# import sqlite3
#exception error handler
@app.errorhandler(404)
def page_not_found(e):
return render_template('404.html'), 404
#add personalised watchlist for each user
@app.route('/watchlist/<username>')
def watchlist(username):
return render_template('watchlist.html' , username = username)
@app.route('/users/<username>')
def users(username):
if username == "dhruv":
return "<h1> Hello " + username + "</h1>"
abort(404)
@app.route('/about_me')
def about_me():
return render_template('about_me.html')
@app.route('/new')
def new():
with sqlite3.connect('imdb.db') as connection:
c = connection.cursor()
cur = c.execute(' SELECT * from movies ')
all_movies = [dict(title = row[0] , rating = row[1]) for row in cur.fetchall()]
return render_template('new.html' , all_movies = all_movies)
@app.route('/seen')
def seen():
with sqlite3.connect('imdb.db') as connection:
c = connection.cursor()
cur = c.execute(' SELECT * from movies ')
all_movies = [dict(title = row[0] , rating = row[1]) for row in cur.fetchall()]
return render_template('seen.html' , all_movies = all_movies)
@app.route('/series')
def series():
url = urlopen("http://www.imdb.com/chart/toptv/?ref_=nv_tvv_250_3")
soup = BeautifulSoup(url)
name = []
for link in soup.find_all('td' , class_ = 'titleColumn'):
name.append(link.a.string)
rating = []
for link in soup.find_all('td' , class_ = 'ratingColumn imdbRating'):
rating.append(link.strong.string)
with sqlite3.connect("imdb.db") as connection:
c = connection.cursor()
cur = c.execute("""SELECT * from series """ )
all_names = [dict(title=row[0], rating=row[1]) for row in cur.fetchall()]
# print "currently in database"
# for i in range(len(all_names)):
# print all_names[i]['title']
for i in range(len(name)):
show_name = name[i]
found = False
for j in range(len(all_names)):
if show_name == all_names[j]['title']:
found = True
break
if not found:
print "New series in top 250"
print name[i],
print rating[i]
c.execute("INSERT INTO series VALUES(? , ?)", (name[i] , rating[i]) )
return "series"
@app.route('/movies')
def movies():
url = urlopen("http://www.imdb.com/chart/top?ref_=nv_mv_250_6")
soup = BeautifulSoup(url)
name = []
for link in soup.find_all('td' , class_ = 'titleColumn'):
name.append(link.a.string)
rating = []
for link in soup.find_all('td' , class_ = 'ratingColumn imdbRating'):
rating.append(link.strong.string)
with sqlite3.connect("imdb.db") as connection:
c = connection.cursor()
cur = c.execute("""SELECT * from movies """ )
all_names = [dict(title=row[0], rating=row[1]) for row in cur.fetchall()]
# print "currently in database"
# for i in range(len(all_names)):
# print all_names[i]['title']
new_movies = []
for i in range(len(name)):
show_name = name[i]
found = False
for j in range(len(all_names)):
if show_name == all_names[j]['title']:
found = True
break
if not found:
new_movies.append(name[i])
print "New movie in top 250"
print name[i],
print rating[i]
c.execute("INSERT INTO movies VALUES(? , ?)", (name[i] , rating[i]) )
return render_template('new.html' , new_movies = new_movies)
@app.route('/')
def welcome():
return render_template('welcome.html') # render a template
if __name__ == '__main__':
app.run()
# series()
# movies()
# database = connect_db()
# c = database.cursor()
# for i in range(10):
# print "executing"
# c.execute('INSERT INTO imdb VALUES(1 , 1)')