flask_sql

@app.route("/history_sensor")
def history_sensor():
   #query= request.args['query']
   print(query)
   database=sqlite3.connect('d.db')
   database.row_factory = dict_factory
   cursor=database.cursor()
   cursor.execute(query) #zapytanie query
   readings = cursor.fetchall()
   return render_template('history_sensor.html', readings=readings)
   
    
@app.route("/history",methods=['GET', 'POST'])
def history():
    if request.method == 'GET':
        return render_template('history.html')
    elif request.method == 'POST':
        if request.form['hihi'] == 'hihi':
            #query = json.dumps({"SELECT * FROM sensoreadings ORDER BY id DESC LIMIT 2"})
            #session['query'] = query
            query="SELECT * FROM sensoreadings ORDER BY id DESC LIMIT 2"
            return redirect(url_for('history_sensor'),query=query)
        return redirect(url_for('history'))