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)
		varID = ID
		varVoornaam = PRENAME
		varAchternaam = NAME
		varLink = PICTURELINKS
		people['attendees'].append({'id' : varID, 'prename' : varVoornaam, 'name' : varAchternaam, 'picture' : varLink})
		print 'forloop'
	people.update({'datum' : datumA})
	return jsonify(people)
@app.route('/bydate')
def datum():
	date = request.args.get('datum')
	print "args: " + str(request.args)
	print "Ingegeven invoer: " + str(date)
	statement = "select * from ICEDATABASE where DATUM = %s" % (str(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)