def comment_page():
coms = Comments(app.config['dsn'])
nes = News(app.config['dsn'])
if request.method == 'GET':
now = datetime.datetime.now()
comlist = coms.get_commentlist()
nelist = nes.get_newlist()
return render_template('comments.html', CommentList = comlist, NewList = nelist, current_time=now.ctime())
elif 'comments_to_delete' in request.form:
id_comments = request.form.getlist('comments_to_delete')
for id_comment in id_comments:
coms.delete_comment(id_comment)
return redirect(url_for('comment_page'))
elif 'comments_to_add' in request.form:
id_comments = request.form.getlist('comments_to_add')
for id_comment in id_comments:
coms.add_comment(request.form['name'],request.form['article'],id_comment)
return redirect(url_for('comment_page'))
elif 'comments_to_update' in request.form:
coms.update_comment(request.form['id_comment'], request.form['name'],request.form['article'])
return redirect(url_for('comment_page'))
elif 'comments_to_search' in request.form:
searchList = coms.search_comment(request.form['name']);
now = datetime.datetime.now()
comlist = coms.get_commentlist()
nelist = nes.get_newlist()
return render_template('comments.html', CommentList = comlist, NewList = nelist, SearchList = searchList, current_time=now.ctime())
def new_page():
nes = News(app.config['dsn'])
if request.method == 'GET':
now = datetime.datetime.now()
nelist = nes.get_newlist()
return render_template('news.html', NewList = nelist, current_time=now.ctime())
elif 'news_to_delete' in request.form:
id_news = request.form.getlist('news_to_delete')
for id_new in id_news:
nes.delete_new(id_new)
return redirect(url_for('new_page'))
elif 'news_to_add' in request.form:
nes.add_new(request.form['title'],request.form['content'],request.form['country'])
return redirect(url_for('new_page'))
elif 'news_to_update' in request.form:
nes.update_new(request.form['id_new'], request.form['title'],request.form['content'])
return redirect(url_for('new_page'))
elif 'news_to_search' in request.form:
searchList = nes.search_new(request.form['name']);
now = datetime.datetime.now()
nelist = nes.get_newlist()
return render_template('news.html', NewList = nelist, SearchList = searchList, current_time=now.ctime())
