from flask import Flask, Markup, request
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 = " "
    cur.execute(statement)
    for (ID,PRENAME,NAME,DATUM,PICTURELINKS) in cur:
        datumA = DATUM
        datumAlleen = str(datumA)[:-8]
        varDatum = ""'"date"'" : "'"%s"'","'"attendees"'" :     ["  % (datumAlleen)
        varID = ID
        varVoornaam = PRENAME
        varAchternaam = NAME
        varLink = PICTURELINKS

        output = "{"'"ID"'" : "'"%s"'", "'"prename"'" : "'"%s"'","'"name"'" : "'"%s"'","'"picture"'" : "'"%s"'"}" %     (varID,varVoornaam,varAchternaam,varLink)

        outputCom+=output + "\n"
    print outputCom
    return "{<br>" + varDatum + outputCom + "]}"