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