I'm trying to paginate some results from SQLite database in my @app.route
but I'm getting this error
schools = db.execute("SELECT * FROM schools ORDER BY id").paginate(page, pages, error_out=False)
AttributeError: 'list' object has no attribute 'paginate'.
@app.route('/search', methods=['GET', 'POST'], defaults={"page": 1})
@app.route('/search/<int:page>', methods=['GET', 'POST'])
def search(page):
if request.method == "GET":
page = page
pages = 10
schools = db.execute("SELECT * FROM schools ORDER BY id").paginate(page, pages, error_out=False)
return render_template("search.html", schools=schools)
Is there another way I can implement pagination?
question from:
https://stackoverflow.com/questions/65906575/flask-pagination-error-attributeerror-list-object-has-no-attribute-paginat 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…