[chronojump-server] uploadEncoderData adds current datetime



commit 7e0de3e98469658cca6aa3dfe978f0b63835b8fe
Author: Xavier de Blas <xaviblas gmail com>
Date:   Thu Jun 29 09:12:53 2017 +0200

    uploadEncoderData adds current datetime

 main.py |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)
---
diff --git a/main.py b/main.py
index be68664..deb5928 100755
--- a/main.py
+++ b/main.py
@@ -228,11 +228,11 @@ def uploadEncoderData():
     (con, cur) = connect_db()
 
     cur.execute("INSERT INTO resultEncoder " +
-            "(personId, stationId, exerciseId, resistance, repetitions, " +
+            "(dt, personId, stationId, exerciseId, resistance, repetitions, " +
             "lossBySpeed, numBySpeed, rangeBySpeed, vmeanBySpeed, vmaxBySpeed, pmeanBySpeed, pmaxBySpeed, " +
             "lossByPower, numByPower, rangeByPower, vmeanByPower, vmaxByPower, pmeanByPower, pmaxByPower) " +
-            "VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
-            (personId, stationId, exerciseId, resistance, repetitions,
+            "VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
+            (datetime.datetime.now(), personId, stationId, exerciseId, resistance, repetitions,
                 lossBySpeed, numBySpeed, rangeBySpeed, vmeanBySpeed, vmaxBySpeed, pmeanBySpeed, pmaxBySpeed,
                 lossByPower, numByPower, rangeByPower, vmeanByPower, vmaxByPower, pmeanByPower, pmaxByPower,
                 ))


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]