[chronojump] DB:1.99 Updated 3L3R tracks fixedValue (just affected description)



commit 61542d470f8633292757ea9f49a1455c52efc6e4
Author: Xavier de Blas <xaviblas gmail com>
Date:   Fri Oct 2 10:32:52 2020 +0200

    DB:1.99 Updated 3L3R tracks fixedValue (just affected description)

 src/sqlite/main.cs    | 12 +++++++++++-
 src/sqlite/runType.cs |  2 +-
 2 files changed, 12 insertions(+), 2 deletions(-)
---
diff --git a/src/sqlite/main.cs b/src/sqlite/main.cs
index e068649d..1ed09369 100644
--- a/src/sqlite/main.cs
+++ b/src/sqlite/main.cs
@@ -129,7 +129,7 @@ class Sqlite
        /*
         * Important, change this if there's any update to database
         */
-       static string lastChronojumpDatabaseVersion = "1.98";
+       static string lastChronojumpDatabaseVersion = "1.99";
 
        public Sqlite()
        {
@@ -2755,6 +2755,14 @@ class Sqlite
                                SqlitePreferences.Insert (SqlitePreferences.ColorBackgroundOsColor, "False");
                                currentVersion = updateVersion("1.98");
                        }
+                       if(currentVersion == "1.98")
+                       {
+                               LogB.SQL("Updated 3L3R tracks fixedValue (just affected description)");
+                               Update(true, Constants.RunIntervalTypeTable, "fixedValue",
+                                               "", "2",
+                                               "name", "Agility-3L3R");
+                               currentVersion = updateVersion("1.99");
+                       }
 
                        /*
                        if(currentVersion == "1.79")
@@ -2970,6 +2978,7 @@ class Sqlite
 //just testing: 1.79 - 1.80 Converted DB to 1.80 Created table ForceSensorElasticBandGlue and moved 
stiffnessString records there
 
 
+               //1.98 - 1.99 Converted DB to 1.99 Updated 3L3R tracks fixedValue (just affected description)
                //1.97 - 1.98 Converted DB to 1.98 Inserted into preferences: colorBackgroundOsColor
                //1.96 - 1.97 Converted DB to 1.97 Inserted into preferences: loadLastSessionAtStart, 
lastSessionID, loadLastModAtStart, lastMode
                //1.95 - 1.96 Converted DB to 1.96 Inserted into preferences: jumpsFVProfileOnlyBestInWeight, 
jumpsFVProfileShowFullGraph, jumpsEvolutionOnlyBestInSession
@@ -3947,6 +3956,7 @@ LogB.SQL("5" + tableName);
        }
 
        //if we want to use the condition2 but not the searchValue, leave this as ""
+       //note that eg. newValue could be an int or others
        public static void Update(
                        bool dbconOpened, string tableName, string columnName, 
                        string searchValue, string newValue, 
diff --git a/src/sqlite/runType.cs b/src/sqlite/runType.cs
index 056f66db..1754c820 100644
--- a/src/sqlite/runType.cs
+++ b/src/sqlite/runType.cs
@@ -403,7 +403,7 @@ class SqliteRunIntervalType : SqliteRunType
                        "7m30seconds:7:0:30:0:Make max laps in 30 seconds:",    //only in more runs
                        "20m endurance:20:0:0:1:Continue running in 20m distance:",     //only in more runs
                        "MTGUG:-1:1:3:0:Modified time Getup and Go test:1-7-19",
-                       "Agility-3L3R:-1:1:3:0:Turn left three times and turn right three times:24.14-24.14"
+                       "Agility-3L3R:-1:1:2:0:Turn left three times and turn right three times:24.14-24.14"
                };
                
                using(SqliteTransaction tr = dbcon.BeginTransaction())


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