from flask import Flask, jsonify, request
from xmpp import cli
from function import query_select, query_insert, query_delete, query_update
import jwt

app = Flask(__name__)

@app.route('/auth', methods=['POST'])
def post_auth():
    request_data = request.get_json()
    result = query_select('''
    SELECT FROM rest_user 
    WHERE ();
    ''', ())

    return jsonify(result), 201

@app.route('/adduser', methods=['POST'])
def get_add():
    request_data = request.get_json()
    result = query_insert('''
    INSERT INTO rest_user (name, birthday, lastlogintime, insys, idrole) 
    VALUES (%s, %s, %s, %s, %s)
    RETURNING id;
    ''', \
        (request_data['name'], request_data['reg_date'],\
             request_data['log_time'], request_data['in_sys'],\
                  request_data['role_id']))

    return jsonify(result), 201

@app.route('/user/<int:id>', methods=['GET'])
def get_user(id):
    return jsonify(query_select('''
    SELECT * FROM rest_user WHERE id = %s;
    ''', (id,), True)), 200

@app.route('/users', methods=['GET'])
def get_show_user():
    result = query_select('''
    SELECT rest_user.id, rest_user.name, rest_user.birthday, rest_user.insys, rest_role.name AS role_name, rest_user.lastlogintime 
    FROM rest_user, rest_role
    WHERE rest_user.idrole = rest_role.id
    ORDER BY id ASC;
    ''', (), False)
    return jsonify(result), 200

@app.route('/deleteuser', methods=['POST'])
def delete_user():
    request_data = request.get_json()
    result = query_delete('''
    DELETE FROM rest_user
    WHERE id = %s;
    ''', (request_data['id'],))
    if(result):
        return "Успешное удаление!", 200
    else:
        return "Ошибка", 500

@app.route('/updateuser', methods=['POST'])
def test_api():
    try:
        request_data = request.get_json()
        result = query_update(f'''
        UPDATE rest_user
        SET name = %s
        WHERE id = %s;
        ''', (request_data['name'], request_data['id']))
        if(result):
            return "Успешное изменение!", 200
        else:
            return "Ошибка", 400
    except:
        return "Ошибка", 500


@app.route('/testmessage', methods=['POST'])
def send_mess():
    try:
        request_data = request.get_json()
        cli.send_message(request_data['from'], request_data['password'], request_data['to'], request_data['message'])
        return "Успешное изменение!", 200
    except:
        return "Ошибка", 500


if __name__ == '__main__':
    #from waitress import serve
    #serve(app, host='127.0.0.2', port='8080')
    app.run(host='127.0.0.2', port='8080', debug=True, load_dotenv=True )