[chronojump/chronojump-importer] Imports ReactionTime.
- From: Carles Pina i Estany <carlespina src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [chronojump/chronojump-importer] Imports ReactionTime.
- Date: Thu, 1 Sep 2016 21:11:42 +0000 (UTC)
commit dd7ca17cde6813327332d24f7f8d8930dae3d5c9
Author: Carles Pina i Estany <carles pina cat>
Date: Thu Sep 1 16:27:10 2016 +0100
Imports ReactionTime.
src/chronojump-importer/chronojump-importer.py | 25 ++++++++++++++++++++++++
1 files changed, 25 insertions(+), 0 deletions(-)
---
diff --git a/src/chronojump-importer/chronojump-importer.py b/src/chronojump-importer/chronojump-importer.py
index 89f2c95..a1d42b8 100755
--- a/src/chronojump-importer/chronojump-importer.py
+++ b/src/chronojump-importer/chronojump-importer.py
@@ -257,6 +257,29 @@ def import_person_session_77(source_db, destination_db, source_session, destinat
insert_person_session_77(destination_db, row)
+def import_reaction_time(source_db, destination_db, new_session_id):
+ """ ... """
+ source_cursor = source_db.cursor()
+ destination_db = destination_db.cursor()
+
+ columns = get_column_names(source_db, "ReactionTime")
+ columns = columns[1:]
+ sql = create_select("ReactionTime", columns, "SessionID={}".format(new_session_id))
+
+ source_cursor.execute(sql)
+
+ results = source_cursor.fetchall()
+
+ for row in results:
+ new_row = list(row)
+
+ new_person_id = get_person_id(source_db, destination_db, new_row[0])
+
+ new_row[0] = new_person_id
+
+ create_insert("ReactionTime", columns, new_row)
+
+
def insert_person_session_77(destination_db, row):
""" Inserts row into PersonSession77 and returns the uniqueID"""
destination_cursor = destination_db.cursor()
@@ -288,6 +311,8 @@ def import_database(source_db, destination_db, source_session):
new_jump_rj_ids = import_jump_rj(source_db, destination_db, source_session, new_session_id)
print("new_jump_rj_ids:", new_jump_rj_ids)
+ import_reaction_time(source_db, destination_db, new_session_id)
+
# import_session(source_db, destination_db, source_session)
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]