[chronojump-server] main.oy GetTasks can get parametrized tasks
- From: Xavier de Blas <xaviblas src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [chronojump-server] main.oy GetTasks can get parametrized tasks
- Date: Mon, 26 Jun 2017 15:28:34 +0000 (UTC)
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")))
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]