API generator

from flask import Flask, jsonify, request
import fdb

app = Flask(__name__)

con = fdb.connect(dsn='/home/trainee2/Desktop/ice', user='sysdba', password='trainee')
cur = con.cursor()


@app.route('/', methods=['GET'])
def get_root():
    datum = request.args.get('datum')
    if datum is not None:
        statement = "select * from ICEDATABASE where DATUM = CAST(? AS DATE)"
        cur.execute(statement, [datum])
    else:
        statement = "select * from ICEDATABASE"
        cur.execute(statement)
    people = {'datum': datum, 'attendees': []}
    for (ID, PRENAME, NAME, DATUM, PICTURELINKS, INOROUT) in cur:
        people['attendees'].append({'id': ID, 'prename': PRENAME, 'name': NAME, 'picture': PICTURELINKS, 'inOrOut': INOROUT})
    return jsonify(people)

@app.route('/database')
def database():
    statement = "select * from ICEDATABASE"
    people = {'attendees': []}
    cur.execute(statement)
    for (ID, PRENAME, NAME, DATUM, PICTURELINKS, INOROUT) in cur:
        people['attendees'].append({'name': NAME, 'prename': PRENAME, 'id' : ID, 'inorout': INOROUT, 'picture': PICTURELINKS, 'datum': DATUM})
    return jsonify(people)


@app.route('/lastperson')
def last():
    statement = "select * FROM ICEDATABASE where ID = (select MAX(ID) from ICEDATABASE)"
    cur.execute(statement)
    for (ID, PRENAME, NAME, DATUM, PICTURELINKS, INOROUT) in cur:
        people = ({'name': NAME, 'prename': PRENAME, 'id' : ID, 'inorout': INOROUT, 'picture': PICTURELINKS, 'datum': DATUM})
    return jsonify(people)

@app.route('/aantal')
def totaal():
    cur.execute("select (select count(INOROUT) from ICEDATABASE where INOROUT = 0) - (select count(INOROUT) from ICEDATABASE where INOROUT =1) from ICEDATABASE as Verschil")
    for (VERSCHIL) in cur:
        people=({'totaalAantalMensen': { 'verschil' : VERSCHIL}})
    return jsonify(people)



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