#FIELDS REQUIRED: email, plan_id
@app.route('/set_user_plan', methods=['POST'])
def set_user_plan(email, plan_id):
    try:
        email = request.form['email']
        plan_id = request.form['plan_id']
        conn = MySQLdb.connect(host='localhost', user='muscle', password='some_pass')
        c = conn.cursor()
        c.execute("UPDATE USER SET Plan_id = {} WHERE Email = '{}'").format(plan_id, email)
        conn.commit()
        c.close()
        conn.close()

        return "Plan " + str(plan_id) + " atribuited to " + str(email)
    except Exception as e:
        return str(e)

#FIELDS REQUIRED: email
@app.route('/user_exists', methods=['POST'])
def user_exists(email):
    try:
        email = request.form['email']
        conn = MySQLdb.connect(host='localhost', user='muscle', password='some_pass')
        c = conn.cursor(MySQLdb.cursors.DictCursor)
        c.execute('USE muscle')

        c.execute("SELECT * FROM USER WHERE Email = '{}'".format(email))

        fetched = c.fetchall()

        c.close()
        conn.close()
        if fetched:
            return "True"

        return "False"
    except Exception as e:
        return str(e)

#FIELDS REQUIRED: email, password
@app.route('/user_login', methods=['POST'])
def user_login(email, password):
    try:
        email = request.form['email']
        password = request.form['password']
        conn = MySQLdb.connect(host='localhost', user='muscle', password='some_pass')
        c = conn.cursor(MySQLdb.cursors.DictCursor)
        c.execute('USE muscle')


        c.execute("SELECT Password FROM USER WHERE Email = '{}'".format(email))
        fetched = c.fetchall();
        c.close()
        conn.close()
        if not fetched:
            return "User does not exist"

        return str(pbkdf2_sha256.verify(password, fetched[0]['Password']))

    except Exception as e:
        return str(e)