[chronojump/chronojump-importer] Starts importing persons77 based on jump and jump_rj.

[Carles Pina i Estany <carlespina src gnome org>]

commit c9141b6d594c30f8a0066e137c7068da2a2f03e5
Author: Carles Pina i Estany <carles pina cat>
Date:   Mon Sep 5 12:51:51 2016 +0100

    Starts importing persons77 based on jump and jump_rj.
    
    A bit more of work is required to change the IDs.

 src/chronojump-importer/chronojump_importer.py     |   34 ++++++++++++++++++++
 .../chronojump_importer_test.py                    |    2 +-
 2 files changed, 35 insertions(+), 1 deletions(-)
---
diff --git a/src/chronojump-importer/chronojump_importer.py b/src/chronojump-importer/chronojump_importer.py
index 44e131c..16429ec 100755
--- a/src/chronojump-importer/chronojump_importer.py
+++ b/src/chronojump-importer/chronojump_importer.py
@@ -405,6 +405,17 @@ def insert_person_session_77(destination_db, row):
     return new_id
 
 
+def update_persons77_ids(table, persons77_list):
+    result = copy.deepcopy(table)
+
+    for row in table:
+        old_person_id = row['personID']
+        for persons77 in persons77_list:
+            if persons77['unique_id'] == old_person_id:
+                row['personID'] = persons77['new_unique_id']
+
+    return result
+
 def import_database(source_path, destination_path, source_session):
     """ Imports the session source_session from source_db into destination_db """
 
@@ -440,6 +451,29 @@ def import_database(source_path, destination_path, source_session):
     # new_session_id = import_session(source_db, destination_db, source_session)
     print("Imported sessionId:", new_session_id)
 
+    persons77_jump_rj = return_data_from_table(database=source_db, table_name="Person77",
+                                       where_condition="JumpRj.sessionID={}".format(source_session),
+                                       skip_columns=["uniqueID"],
+                                       join_clause="LEFT JOIN JumpRj ON Person77.uniqueID=JumpRj.personID")
+
+    persons77_jump_rj = insert_data(database=destination_db, table_name="Person77", data=persons77_jump_rj,
+                            matches_columns=["name"])
+
+    persons77_jump = return_data_from_table(database=source_db, table_name="Person77",
+                                       where_condition="Jump.sessionID={}".format(source_session),
+                                       skip_columns=["uniqueID"],
+                                       join_clause="LEFT JOIN Jump ON Person77.uniqueID=Jump.personID")
+
+    persons77_jump = insert_data(database=destination_db, table_name="Person77", data=persons77_jump,
+                            matches_columns=["name"])
+
+
+    jump_rj = return_data_from_table(database=source_db, table_name="JumpRj",
+                           where_condition="JumpRj.sessionID={}".format(source_session),
+                           skip_columns=["uniqueID"])
+
+    update_persons77_ids(jump_rj, persons77_jump_rj)
+
     ### Continue from here
 
     # import_person_session_77(source_db, destination_db, source_session, new_session_id)
diff --git a/src/chronojump-importer/chronojump_importer_test.py 
b/src/chronojump-importer/chronojump_importer_test.py
index 25c6d5b..c7d09ac 100755
--- a/src/chronojump-importer/chronojump_importer_test.py
+++ b/src/chronojump-importer/chronojump_importer_test.py
@@ -18,7 +18,7 @@ class TestImporter(unittest.TestCase):
     def test_importerGeneric(self):
 
         # lists the names. They will expand to generic-destination-X.sqlite / generic-source-X.sqlite / 
generic-expected-X.sqlite
-        generic_tests = ["a", "b"]
+        generic_tests = ["a"]
 
         for generic_test in generic_tests:
             source_file_name = "generic-source-{}.sqlite".format(generic_test)