[chronojump-server] main.oy GetTasks can get parametrized tasks

[Xavier de Blas <xaviblas src gnome org>]

commit 579e16aa3dfa2aad3b7ca8d75808100cdbd34570
Author: Xavier de Blas <xaviblas gmail com>
Date:   Mon Jun 26 17:27:50 2017 +0200

    main.oy GetTasks can get parametrized tasks

 main.py |   13 ++++++++-----
 1 files changed, 8 insertions(+), 5 deletions(-)
---
diff --git a/main.py b/main.py
index 008a97a..32164b0 100755
--- a/main.py
+++ b/main.py
@@ -1,5 +1,5 @@
 from flask import Flask, request, url_for, Response
-from flask.ext.autodoc import Autodoc
+from flask_autodoc import Autodoc
 import ConfigParser
 import datetime
 import hashlib
@@ -127,9 +127,10 @@ def getTasks():
 
     personId  = content.get('personId', "")
 
-    (con, cur) = connect_db()
+    (con, cur) = connect_db(cursorclass=MySQLdb.cursors.DictCursor)
 
-    cur.execute("SELECT task.id, task.comment FROM task, person WHERE person.id = %s AND person.id = 
task.personId AND done = 0", (personId, ))
+    #select everything exept datetime because is not serializable
+    cur.execute("SELECT task.id, task.type, task.personId, task.stationId, task.exerciseId, task.sets, 
task.nreps, task.load, task.speed, task.percentMaxSpeed, task.laterality, task.comment, task.done FROM task, 
person WHERE person.id = %s AND person.id = task.personId AND done = 0", (personId, ))
     print(cur._last_executed)
     tasks = cur.fetchall()
 
@@ -137,7 +138,9 @@ def getTasks():
 #        print(task[0])
 #        task[0] = unicode(task[0], errors='replace')
 
-    return Response(json.dumps(tasks))
+    assert len(tasks) >= 1
+
+    return Response(json.dumps(tasks[0])) #TODO: download n tasks
 
 @app.route("/updateTask", methods=['POST'])
 @auto.doc()
@@ -226,4 +229,4 @@ def index():
     return auto.html()
 
 if __name__ == "__main__":
-    app.run(host="0.0.0.0",port=int(config.get("api","port")))
+    app.run(host="127.0.0.1",port=int(config.get("api","port")))