How to do pagination in flask

Solution
@app.route('/home')
def home():
    if 'loggedin' in session:
        page = request.args.get('page', 1)
        elem_to_display = 10
        offset = (page - 1) * elem_to_display
        cur = mysql.connection.cursor()
        cur.execute("SELECT  * FROM ml_process_status LIMIT %s OFFSET %s", (elem_to_display, offset,))
        data = cur.fetchall()

        return render_template('home.html', username=session['username'], items=data)

    return redirect(url_for('login'))