def register():
# username = request.form['username']
# password = request.form['password']
username = request.form.get('username')
password = request.form.get('password')
sql = "INSERT INTO `flask_db`.`user` (`id`, `username`, `password`) VALUES (NULL, '{}', '{}')".format(
username,
md5(password).hexdigest())
try:
# 执行sql语句
db_session.execute(sql)
# 提交到数据库执行
db_session.commit()
except LookupError:
# 发生错误时回滚
db_session.rollback()
# data = sql.fetchone()
# title = u'登录成功'
db_session.commit()
db_session.close()
return redirect(
url_for('hello_world')) # render_template('login.html', title=title)
def get(self):
stmt = text(
"SELECT categroy,group_concat(numid) FROM categroyMovieTable GROUP BY categroy ORDER BY categroy DESC"
)
groups = db_session.execute(stmt).fetchall()
all_list = []
for group in groups:
dict1 = {'group_name': group[0], 'child': []}
numids = group[1].split(sep=',')
for numid in numids:
cate = CategoryMovie.query.filter_by(numid=numid).first()
dict1['child'].append({
'numid': cate.numid,
'title': cate.title,
'url': cate.url
})
all_list.append(dict1)
# 电影网格列表
rp = reqparse.RequestParser()
rp.add_argument('page', type=int, location=['args'], default=1)
rp.add_argument('pagesize', type=int, location=['args'], default=30)
params = rp.parse_args()
pagesize = params.pagesize
offset = (params.page - 1) * pagesize
# movies = MovieTable.query.order_by(MovieTable.score.desc()).offset(offset).limit(pagesize).all()
movies = MovieTable.query.offset(offset).limit(pagesize).all()
total = len(MovieTable.query.all())
if total % pagesize == 0:
total_page = total / pagesize
else:
total_page = total / pagesize + 1
return render_template('movielist.html',
cates=all_list,
movies=movies,
total=total,
page_num=params.page,
total_page=int(total_page))
def login():
username = request.form['username']
password = md5(request.form['password']).hexdigest()
# db_session.execute("SELECT * FROM table_name WHERE column_name = %s", "column_value")
sql = db_session.execute(
"select username, password from user where username = '******' and password = '******'"
.format(username, password))
data = sql.fetchone()
# for i in data:
# print i
if data:
# title = u'登录成功'
# print data
session['username'] = data[0]
session.permanent = True
db_session.close()
return redirect(url_for(
'hello_world')) # render_template('login.html', title=title)
else:
title = u'登录失败'
fail = True
db_session.close()
return render_template('login.html', title=title, fail=fail)
def get(self):
rp = reqparse.RequestParser()
rp.add_argument('movieid', location='args', default=896)
rp.add_argument('playhtml', location='args')
params = rp.parse_args()
movie_id = params.movieid
movie_id = 896
stmt = text(
"SELECT md.id,mt.moviename,mt.score,md.director,md.categroy,md.keyword,md.des,group_concat(mp.performer) AS perman,group_concat(mp.role) AS role \
FROM movietable AS mt INNER JOIN (moviedetailtable AS md,movieperformertable AS mp) ON \
mt.id = md.id AND mt.id = mp.id AND md.id = mp.id \
WHERE md.id =:x GROUP BY md.id")
groups = db_session.execute(stmt, params={'x': movie_id}).first()
pers = groups[7].split(sep=',')
roles = groups[8].split(sep=',')
per_role = []
for i in range(len(pers)):
per_role.append({'per': pers[i], 'role': roles[i]})
movie_detail = {
'movieid': groups[0],
'moviename': groups[1],
'score': groups[2],
'director': groups[3],
'categroy': groups[4],
'keyword': groups[5],
'des': groups[6],
'per_role': per_role
}
# return movie_detail
return render_template('movieplay.html', movie_detail=movie_detail)
def db():
"""Testing database connections"""
result = db_session.execute("SELECT * FROM departments")
names = [row[0] for row in result]
return "<HTML><body><div>{}</div></body></HTML>".format("<br>".join(names))