python - Flask Pagination Error - AttributeError: 'list' object has no attribute 'paginate'

Question

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

Answer 1

Waitting for answers