[chronojump] Sqlite session SelectAll can be uniqueID ASC or DESC

[Xavier de Blas <xaviblas src gnome org>]

commit b7986cdca57f38af62c1636fa4a24449c783d09d
Author: Xavier de Blas <xaviblas gmail com>
Date:   Thu Apr 15 16:42:59 2021 +0200

    Sqlite session SelectAll can be uniqueID ASC or DESC

 src/sqlite/jump.cs    | 6 +++---
 src/sqlite/session.cs | 8 ++++++--
 2 files changed, 9 insertions(+), 5 deletions(-)
---
diff --git a/src/sqlite/jump.cs b/src/sqlite/jump.cs
index 7baba9ae..86285f9b 100644
--- a/src/sqlite/jump.cs
+++ b/src/sqlite/jump.cs
@@ -206,7 +206,7 @@ class SqliteJump : Sqlite
        {
          //jumps previous to DB 1.82 have no datetime on jump
          //find session datetime for that jumps
-         List<Session> session_l = SqliteSession.SelectAll();
+         List<Session> session_l = SqliteSession.SelectAll(Sqlite.Orders_by.DEFAULT);
 
          //for personNameInComment
          List<Person> person_l =
@@ -453,7 +453,7 @@ class SqliteJump : Sqlite
        {
          //jumps previous to DB 1.82 have no datetime on jump
          //find session datetime for that jumps
-         List<Session> session_l = SqliteSession.SelectAll();
+         List<Session> session_l = SqliteSession.SelectAll(Sqlite.Orders_by.DEFAULT);
 
          string personID = pID.ToString();
          string sessionID = sID.ToString();
@@ -501,7 +501,7 @@ class SqliteJump : Sqlite
        {
          //jumps previous to DB 1.82 have no datetime on jump
          //find session datetime for that jumps
-         List<Session> session_l = SqliteSession.SelectAll();
+         List<Session> session_l = SqliteSession.SelectAll(Sqlite.Orders_by.DEFAULT);
 
          string personID = pID.ToString();
          string sessionID = sID.ToString();
diff --git a/src/sqlite/session.cs b/src/sqlite/session.cs
index 0577fc1b..fa67844d 100644
--- a/src/sqlite/session.cs
+++ b/src/sqlite/session.cs
@@ -271,9 +271,13 @@ class SqliteSession : Sqlite
                //return (Session) selectDo(dbcmd)[0];
                return session_l[0];
        }
-       public static List<Session> SelectAll()
+       public static List<Session> SelectAll(Orders_by orderBy)
        {
-               dbcmd.CommandText = "SELECT * FROM " + Constants.SessionTable;
+               string orderByStr = " ORDER BY uniqueID";
+               if(orderBy == Orders_by.ID_DESC)
+                       orderByStr += " DESC";
+
+               dbcmd.CommandText = "SELECT * FROM " + Constants.SessionTable + orderByStr;
                return selectDo(dbcmd);
        }
        private static List<Session> selectDo(SqliteCommand mydbcmd)