from flask import Flask, request, jsonify
from flaskext.mysql import MySQL

app = Flask(__name__)
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
app.config['MYSQL_DATABASE_USER'] = 'wws'
app.config['MYSQL_DATABASE_PASSWORD'] = '17kLo99Fn7922'
app.config['MYSQL_DATABASE_DB'] = 'OPCUA-Test'

#app.config['MYSQL_DATABASE_HOST'] = 'rdbms.strato.de'
#app.config['MYSQL_DATABASE_USER'] = 'dbu848833'
#app.config['MYSQL_DATABASE_PASSWORD'] = '17kLo99@Fn7922'
#app.config['MYSQL_DATABASE_DB'] = 'dbs1715754'

mysql = MySQL(app)
mysql.init_app(app)


@app.route('/')
def hello():
    return 'Hello, World'


@app.route('/3', methods=['GET'])
def get_rbl_rm():
    cursor = mysql.get_db().cursor()

    cursor.execute("SELECT Value FROM Esszimmer WHERE ID = %(Node_ID)s",
                   {'Node_ID': 1})
    mysql_result = cursor.fetchall()

    for row in mysql_result:
        return jsonify(EZ_RBL=row[0])


@app.route('/4', methods=['GET'])
def get_trigger_rbl():
    cursor = mysql.get_db().cursor()

    cursor.execute("UPDATE Esszimmer SET Value = %(value_trig)s WHERE ID = %(id)s",
                   {'value_trig': 1, 'id': 2})
    mysql.get_db().commit()

    return jsonify(TrigRBL=True)


@app.route('/5', methods=['GET'])
def get_trigger_rbl_ku():
    cursor = mysql.get_db().cursor()

    cursor.execute("UPDATE Kueche SET Value = %(value_trig)s WHERE ID = %(id)s",
                   {'value_trig': 1, 'id': 2})
    mysql.get_db().commit()

    return jsonify(TrigRBLKu=True)


@app.route('/hallo', methods=['GET'])
def post_selected_rm():
    cursor = mysql.get_db().cursor()

    cursor.execute("SELECT Value FROM Kueche WHERE ID = %(username)s",
                   {'username': 1})
    mysql_result = cursor.fetchall()

    for row in mysql_result:
        return jsonify(Value=row[0])


if __name__ == '__main__':
    app.run(debug=True)