[chronojump] News show last 10 products

[Xavier de Blas <xaviblas src gnome org>]

commit 96a2eb5eee37ced4c15a0538d5646254eb580f5d
Author: Xavier de Blas <xaviblas gmail com>
Date:   Wed Dec 30 13:23:30 2020 +0100

    News show last 10 products

 src/gui/app1/chronojump.cs | 4 ++--
 src/sqlite/news.cs         | 5 +++--
 2 files changed, 5 insertions(+), 4 deletions(-)
---
diff --git a/src/gui/app1/chronojump.cs b/src/gui/app1/chronojump.cs
index 5c105a61..7c52a762 100644
--- a/src/gui/app1/chronojump.cs
+++ b/src/gui/app1/chronojump.cs
@@ -715,7 +715,7 @@ public partial class ChronoJumpWindow
                {
                        LogB.Information("Ping thread will start");
 
-                       newsAtDB_l = SqliteNews.Select(false, -1);
+                       newsAtDB_l = SqliteNews.Select(false, -1, 10);
                        pingThread = new Thread (new ThreadStart (pingAndNewsAtStart));
                        GLib.Idle.Add (new GLib.IdleHandler (pulsePingAndNewsGTK));
                        pingThread.Start();
@@ -6790,7 +6790,7 @@ LogB.Debug("mc finished 5");
                        }
 
                        // 2) update newsAtDB_l
-                       newsAtDB_l = SqliteNews.Select(false, -1);
+                       newsAtDB_l = SqliteNews.Select(false, -1, 10);
 
                        // 3) if there are news (locally is not 0), make it sensitive
                        if(newsAtDB_l.Count > 0)
diff --git a/src/sqlite/news.cs b/src/sqlite/news.cs
index 97201be7..c8587a53 100644
--- a/src/sqlite/news.cs
+++ b/src/sqlite/news.cs
@@ -83,7 +83,8 @@ class SqliteNews : Sqlite
        }
 
        //code -1 (select all)
-       public static List<News> Select (bool dbconOpened, int code)
+       //limit is 10 by default on show news
+       public static List<News> Select (bool dbconOpened, int code, int limit)
        {
                openIfNeeded(dbconOpened);
 
@@ -91,7 +92,7 @@ class SqliteNews : Sqlite
                if(code != -1)
                        codeStr = " WHERE code = " + code;
 
-               dbcmd.CommandText = "SELECT * FROM " + table + codeStr + " ORDER BY code DESC";
+               dbcmd.CommandText = "SELECT * FROM " + table + codeStr + " ORDER BY code DESC LIMIT " + 
limit.ToString();
 
                LogB.SQL(dbcmd.CommandText.ToString());
                dbcmd.ExecuteNonQuery();