@app.route('/', methods=['GET']) def article_list(): context = {} rows = max(Article.query.count() - 5, 5) context['article_list'] = Article.query.order_by( desc(Article.date_created)).limit(rows) return render_template('home.html', context=context, active_tab='timeline') @app.route('/more') def article_more(): last_article_id = request.args.get('last_article_id', 0, type=int) article_list = Article.query.filter(Article.id < last_article_id).order_by( desc(Article.date_created)).limit(5) article_result = [] for article in article_list: article_result.append({'id': article.id, 'title': article.title, 'content': article.content, 'author': article.author, 'category': article.category, 'date_created': article.date_created, }) return jsonify(article_list=article_result, count=article_list.count())