diff OrthancServer/Database/SQLiteDatabaseWrapper.cpp @ 3105:2e1711f80f74 db-changes

More consistent handling of the "Last" field returned by the "/changes" URI
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 10 Jan 2019 18:02:34 +0100
parents 2e1808b6146a
children 0fa7181ac4e5
line wrap: on
line diff
--- a/OrthancServer/Database/SQLiteDatabaseWrapper.cpp	Mon Jan 07 17:23:04 2019 +0100
+++ b/OrthancServer/Database/SQLiteDatabaseWrapper.cpp	Thu Jan 10 18:02:34 2019 +0100
@@ -1270,4 +1270,23 @@
       }
     }
   }
+
+
+  int64_t SQLiteDatabaseWrapper::GetLastChangeIndex()
+  {
+    SQLite::Statement s(db_, SQLITE_FROM_HERE, 
+                        "SELECT seq FROM sqlite_sequence WHERE name='Changes'");
+
+    if (s.Step())
+    {
+      int64_t c = s.ColumnInt(0);
+      assert(!s.Step());
+      return c;
+    }
+    else
+    {
+      // No change has been recorded so far in the database
+      return 0;
+    }
+  }
 }