/
app.py
97 lines (78 loc) · 2.39 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
from flask import Flask,render_template
import sqlite3
import json
app = Flask(__name__)
@app.route('/')
def index():
return render_template("index.html")
@app.route('/index')
def home():
#return render_template("index.html")
return index()
@app.route('/movie')
def movie():
datalist = []
con = sqlite3.connect("movie.db")
cur = con.cursor()
sql = "select * from movie250"
data = cur.execute(sql)
for item in data:
datalist.append(item)
cur.close()
con.close()
# print(datalist)
return render_template("movie.html",movies = datalist)
@app.route('/score')
def score():
score = [] # 评分
num = [] # 每个评分所统计出的电影数量
score2 = [] # 评分
num2 = [] # 每个评分所统计出的电影数量
res={}
con = sqlite3.connect("movie.db")
cur = con.cursor()
sql = "select score,count(score) from movie250 group by score"
data = cur.execute(sql)
for item in data:
score.append(str(item[0]))
num.append(item[1])
for k, v in zip(score, num):
res.update({k: v, },)
sql2="select year_release,count(year_release) from movie250 group by year_release"
data2 = cur.execute(sql2)
for item2 in data2:
score2.append(str(item2[0]))
num2.append(item2[1])
#print(num2)
cur.close()
con.close()
return render_template("score.html",score=score,num=num,res=res,num2=num2,score2=score2)
# return render_template("testshanxing.html",score=score,num=num,res=res,num2=num2,score2=score2)
@app.route('/word')
def word():
return render_template("cloud.html")
@app.route('/team')
def team():
return render_template("team.html")
@app.route('/aboutMe')
def aboutMe():
return render_template("aboutMe.html")
def combine(keys,values):
res=[]
if len(keys)!=len(values):
return None
for ind,key in enumerate(keys):
dict_temp={}
dict_temp[key]=values[ind]
res.append(dict_temp)
return res
def mycombine(key,value):
data = {}
# keys与values分别为该数据的键数组,值的数组。这里循环为字典添加对应键值
for k, v in zip(key, value):
data.update({k: v, }, )
# 最后将数据打包成json格式以字典的方式传送到前端
# return render(request, 'index.html', {'data': json.dumps(data)})
return data
if __name__ == '__main__':
app.run()