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)"
    varDatum = ""
    varID = ""
    varVoornaam = ""
    varAchternaam = ""
    varLink = ""
    outputCom = " "
    people = {'datum' : varDatum}

    cur.execute(statement)
    for (ID,PRENAME,NAME,DATUM,PICTURELINKS) in cur:
        datumA = DATUM
        datumAlleen = str(datumA)[:-8]
        #varDatum = ""'"date"'" : "'"%s"'",<br> "'"attendees"'" :   ["  % (datumAlleen)
        varID = ID
        varVoornaam = PRENAME
        varAchternaam = NAME
        varLink = PICTURELINKS
        #output = "<br>{<br>"'"ID"'" : "'"%s"'",    <br>"'"prename"'" : "'"%s"'", <br>"'"name"'" : "'"%s"'",    <br>"'"picture"'" : "'"%s"'"<br>}" %        (varID,varVoornaam,varAchternaam,varLink)

        people.update({'id' : varID, 'prename' : varVoornaam, 'name' : varAchternaam, 'picture' : varLink})
        #outputCom+=output + "\n"
    #print outputCom

        return jsonify(people)