from flask import Flask, Markup, request,jsonify
import json
import fdb
import time

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

app = Flask(__name__)

@app.route('/')
def hello_world():
    statement = "select * from ICEDATABASE where DATUM = cast('NOW' as date)"
    cur.execute(statement)
    datumAlleen = " "
    people = {'datum' : datumAlleen, 'attendees' : []}
    datumDb = ''
    for (ID,PRENAME,NAME,DATUM,PICTURELINKS) in cur:
        datumA = DATUM
        datumDb = str(datumA)[:-8]
        varID = ID
        varVoornaam = PRENAME
        varAchternaam = NAME
        varLink = PICTURELINKS

        people['attendees'].append({'id' : varID, 'prename' : varVoornaam, 'name' : varAchternaam, 'picture' : varLink})
        print 'forloop'
    people.update({'datum' : datumDb})
    return jsonify(people)
@app.route('')