from flask import Flask, jsonify, request
from DP1.DP1Database import Database
from flask_cors import CORS

app = Flask(__name__)
CORS(app)

conn = Database(app=app, user = 'root', password='root', db='vliegtuigen')

# Custom endpoint
endpoint = '/api/v1'


# # ROUTES
@app.route(endpoint + '/klanten', methods=['GET', 'POST'])
def klanten():
    if request.method == 'GET':
        klanten = conn.get_data('SELECT * FROM tblklant')
        return jsonify(klanten)
    elif request.method == 'POST':
        nieuwe_klant = conn.set_data("INSERT INTO tblklant (FNaam, Vnaam, Straat, Nummer, Postcode, Gemeente) VALUES (%s, %s, %s, %s, %s, %s)", [request.form['FNaam'], request.form['VNaam'], request.form['Straat'], request.form['Nummer'], request.form['Postcode'], request.form['Gemeente']])
        return jsonify(nieuwe_klant)

@app.route(endpoint + '/klanten_json', methods= ['GET', 'POST','PUT', 'DELETE'])
def klanten_json():
    if request.method == 'GET':
        klant = conn.get_data('SELECT * FROM tblklant WHERE KlantID = %s', klant_id)
        return jsonify(klant)
    elif request.method == 'PUT':
        js = request.get_json()
        update_klant = conn.set_data("UPDATE tblklant SET FNaam = %s, VNaam = %s, Straat = %s, Nummer = %s, Postcode = %s, Gemeente = %s WHERE KlantID = %s", [js['FNaam'], js['VNaam'], js['Straat'], js['Nummer'], js['Postcode'], js['Gemeente'], klant_id])
        return jsonify(update_klant)
    elif request.method == 'DELETE':
        verwijderde_klant = conn.delete_data('DELETE FROM tblklant WHERE KlantID = %s', klant_id)
        return jsonify(verwijderde_klant)
    elif request.method == 'POST':
        js = request.get_json()
        nieuwe_klant = conn.set_data("INSERT INTO tblklant (FNaam, Vnaam, Straat, Nummer, Postcode, Gemeente) VALUES (%s, %s, %s, %s, %s, %s)", [js['FNaam'], js['VNaam'], js['Straat'], js['Nummer'], js['Postcode'], js['Gemeente']])
        return jsonify(nieuwe_klant)


@app.route(endpoint + '/klanten/<klant_id>', methods= ['GET', 'PUT', 'DELETE'])
def klant(klant_id):
    if request.method == 'GET':
        klant = conn.get_data('SELECT * FROM tblklant WHERE KlantID = %s', klant_id)
        return jsonify(klant)
    elif request.method == 'PUT':
        update_klant = conn.set_data("UPDATE tblklant SET FNaam = %s, VNaam = %s, Straat = %s, Nummer = %s, Postcode = %s, Gemeente = %s WHERE KlantID = %s", [request.form['FNaam'], request.form['VNaam'], request.form['Straat'], request.form['Nummer'], request.form['Postcode'], request.form['Gemeente'], klant_id])
        return jsonify(update_klant)
    elif request.method == 'DELETE':
        verwijderde_klant = conn.delete_data('DELETE FROM tblklant WHERE KlantID = %s', klant_id)
        return jsonify(verwijderde_klant)

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