[chronojump] Compujump: faster DB on client at upadate old tests

[Xavier de Blas <xaviblas src gnome org>]

commit fde6b5a2386e1dfcc37fc45b280decf5bc56a3f4
Author: Xavier de Blas <xaviblas gmail com>
Date:   Tue Feb 27 13:01:55 2018 +0100

    Compujump: faster DB on client at upadate old tests

 src/gui/networks.cs |   14 ++++++++++----
 src/sqlite/json.cs  |    4 ++--
 2 files changed, 12 insertions(+), 6 deletions(-)
---
diff --git a/src/gui/networks.cs b/src/gui/networks.cs
index 56bf229..dfcea43 100644
--- a/src/gui/networks.cs
+++ b/src/gui/networks.cs
@@ -568,8 +568,11 @@ public partial class ChronoJumpWindow
 
                //----- Start upload temp tests
                //select UploadTemp tests (have not been uploaded by network errors)
-               List<UploadEncoderDataFullObject> listEncoderTemp = SqliteJson.SelectTempEncoder(false);
-               List<UploadSprintDataObject> listSprintTemp = SqliteJson.SelectTempSprint(false);
+
+               Sqlite.Open(); // ---------------->
+
+               List<UploadEncoderDataFullObject> listEncoderTemp = SqliteJson.SelectTempEncoder(true);
+               List<UploadSprintDataObject> listSprintTemp = SqliteJson.SelectTempSprint(true);
 
                //Upload them
                if(listEncoderTemp.Count > 0)
@@ -579,7 +582,7 @@ public partial class ChronoJumpWindow
                                bool success = json.UploadEncoderData(uedfo);
                                LogB.Information(json.ResultMessage);
                                if(success)
-                                       SqliteJson.DeleteTempEncoder(false, uedfo.uniqueId); //delete the 
record
+                                       SqliteJson.DeleteTempEncoder(true, uedfo.uniqueId); //delete the 
record
                        }
                }
                if(listSprintTemp.Count > 0)
@@ -589,9 +592,12 @@ public partial class ChronoJumpWindow
                                bool success = json.UploadSprintData(usdo);
                                LogB.Information(json.ResultMessage);
                                if(success)
-                                       SqliteJson.DeleteTempSprint(false, usdo.uniqueId); //delete the record
+                                       SqliteJson.DeleteTempSprint(true, usdo.uniqueId); //delete the record
                        }
                }
+
+               Sqlite.Close(); // <----------------
+
                //----- End upload temp tests
 
 
diff --git a/src/sqlite/json.cs b/src/sqlite/json.cs
index 70b3bce..4576a12 100644
--- a/src/sqlite/json.cs
+++ b/src/sqlite/json.cs
@@ -92,7 +92,7 @@ class SqliteJson : Sqlite
        {
                openIfNeeded(dbconOpened);
 
-               dbcmd.CommandText = "SELECT * FROM " + tableEncoder;
+               dbcmd.CommandText = "SELECT * FROM " + tableEncoder + " ORDER BY uniqueID";
                LogB.SQL(dbcmd.CommandText.ToString());
                dbcmd.ExecuteNonQuery();
 
@@ -188,7 +188,7 @@ class SqliteJson : Sqlite
        {
                openIfNeeded(dbconOpened);
 
-               dbcmd.CommandText = "SELECT * FROM " + tableSprint;
+               dbcmd.CommandText = "SELECT * FROM " + tableSprint + " ORDER BY uniqueID";
                LogB.SQL(dbcmd.CommandText.ToString());
                dbcmd.ExecuteNonQuery();