[chronojump] DB: 2.11 Inserted prefs: clientNewsDatetime

[Xavier de Blas <xaviblas src gnome org>]

commit b1f8b85e38a225181150991ce06cf2c57d982152
Author: Xavier de Blas <xaviblas gmail com>
Date:   Tue Jan 19 12:03:17 2021 +0100

    DB: 2.11 Inserted prefs: clientNewsDatetime

 src/preferences.cs        |  6 +++++-
 src/sqlite/main.cs        | 11 ++++++++++-
 src/sqlite/preferences.cs |  9 +++++++++
 3 files changed, 24 insertions(+), 2 deletions(-)
---
diff --git a/src/preferences.cs b/src/preferences.cs
index 45c42f77..6a29e085 100644
--- a/src/preferences.cs
+++ b/src/preferences.cs
@@ -195,7 +195,11 @@ public class Preferences
        public string machineID;
        public Constants.MultimediaStorage multimediaStorage;
        public string databaseVersion;
-       public bool newsLanguageEs;
+
+       //news
+       public bool newsLanguageEs;             // on SQL
+       public string serverNewsDatetime;       // NOT on SQL
+       public string clientNewsDatetime;       // on SQL
 
        //jumps
        public bool jumpsFVProfileOnlyBestInWeight;
diff --git a/src/sqlite/main.cs b/src/sqlite/main.cs
index 2adbb681..d1ba085e 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 = "2.10";
+       static string lastChronojumpDatabaseVersion = "2.11";
 
        public Sqlite()
        {
@@ -2861,6 +2861,14 @@ class Sqlite
 
                                currentVersion = updateVersion("2.10");
                        }
+                       if(currentVersion == "2.10")
+                       {
+                               LogB.SQL("Inserted prefs: clientNewsDatetime");
+
+                               SqlitePreferences.Insert (SqlitePreferences.ClientNewsDatetime, "");
+
+                               currentVersion = updateVersion("2.11");
+                       }
 
                        /*
                        if(currentVersion == "1.79")
@@ -3079,6 +3087,7 @@ class Sqlite
 //just testing: 1.79 - 1.80 Converted DB to 1.80 Created table ForceSensorElasticBandGlue and moved 
stiffnessString records there
 
 
+               //2.10 - 2.11 Converted DB to 2.11 Inserted prefs: clientNewsDatetime
                //2.09 - 2.10 Converted DB to 2.10 Inserted prefs: encoderCaptureShowLoss, runEncoderPPS
                //2.08 - 2.09 Converted DB to 2.09 Inserted into preferences: 
forceSensorAnalyzeABSliderIncrement
                //2.07 - 2.08 Converted DB to 2.08 Create table news and insert newsLanguageEs on preferences
diff --git a/src/sqlite/preferences.cs b/src/sqlite/preferences.cs
index 1d0f616c..fcdd6cd7 100644
--- a/src/sqlite/preferences.cs
+++ b/src/sqlite/preferences.cs
@@ -35,7 +35,11 @@ class SqlitePreferences : Sqlite
        public const string FontsOnGraphs = "fontsOnGraphs";
        public const string RestTimeMinutes = "restTimeMinutes";
        public const string RestTimeSeconds = "restTimeSeconds";
+
+       //news stuff
        public const string NewsLanguageEs = "newsLanguageEs";
+       public const string ServerNewsDatetime = "serverNewsDatetime"; // NOT stored on SQL. string of last 
news in server, obtained on pingAtNewsAtStart
+       public const string ClientNewsDatetime = "clientNewsDatetime"; // stored on SQL. string of last news 
local, when user clicks on getNews(), if this is diff than server... news are downloaded and this is updated
 
        //contacts
        public const string JumpsFVProfileOnlyBestInWeight = "jumpsFVProfileOnlyBestInWeight";
@@ -315,7 +319,10 @@ class SqlitePreferences : Sqlite
                                Insert ("email", "", dbcmdTr);
                                Insert ("muteLogs", "False", dbcmdTr);
                                Insert (ImporterPythonVersion, 
Preferences.pythonVersionEnum.Python3.ToString(), dbcmdTr);
+
+                               //news
                                Insert (NewsLanguageEs, "False", dbcmdTr);
+                               Insert (ClientNewsDatetime, "", dbcmdTr);
 
                                //session
                                Insert (LoadLastSessionAtStart, "True", dbcmdTr);
@@ -457,6 +464,8 @@ class SqlitePreferences : Sqlite
                        }
                        else if(reader[0].ToString() == NewsLanguageEs )
                                preferences.newsLanguageEs = reader[1].ToString() == "True"; //bool
+                       else if(reader[0].ToString() == ClientNewsDatetime )
+                               preferences.clientNewsDatetime = reader[1].ToString();
                        else if(reader[0].ToString() == UnitsStr)
                                preferences.units = (Preferences.UnitsEnum)
                                        Enum.Parse(typeof(Preferences.UnitsEnum), reader[1].ToString());