diff OrthancServer/DatabaseWrapper.cpp @ 190:b6cef9d45cc3

getallpublicids
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 13 Nov 2012 11:20:50 +0100
parents ccbc2cf64a0d
children c56dc32266e0
line wrap: on
line diff
--- a/OrthancServer/DatabaseWrapper.cpp	Mon Nov 12 18:03:48 2012 +0100
+++ b/OrthancServer/DatabaseWrapper.cpp	Tue Nov 13 11:20:50 2012 +0100
@@ -469,6 +469,19 @@
     return static_cast<uint64_t>(s.ColumnInt64(0));
   }
 
+  void DatabaseWrapper::GetAllPublicIds(Json::Value& target,
+                                        ResourceType resourceType)
+  {
+    SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT publicId FROM Resources WHERE resourceType=?");
+    s.BindInt(0, resourceType);
+
+    target = Json::arrayValue;
+    while (s.Step())
+    {
+      target.append(s.ColumnString(0));
+    }
+  }
+
 
   DatabaseWrapper::DatabaseWrapper(const std::string& path,
                                    IServerIndexListener& listener) :