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())