Mercurial > hg > orthanc
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) :