[chronojump] DB:1.99 Updated 3L3R tracks fixedValue (just affected description)
- From: Xavier de Blas <xaviblas src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [chronojump] DB:1.99 Updated 3L3R tracks fixedValue (just affected description)
- Date: Fri, 2 Oct 2020 08:50:12 +0000 (UTC)
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]