Mercurial > hg > orthanc-databases
annotate Framework/Plugins/IndexBackend.cpp @ 221:73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
| author | Sebastien Jodogne <s.jodogne@gmail.com> |
|---|---|
| date | Tue, 30 Mar 2021 10:40:34 +0200 |
| parents | 492aa3edf572 |
| children | c8e06b41feec |
| rev | line source |
|---|---|
| 0 | 1 /** |
| 2 * Orthanc - A Lightweight, RESTful DICOM Store | |
| 3 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics | |
| 4 * Department, University Hospital of Liege, Belgium | |
|
193
3236894320d6
upgrade to year 2021
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
157
diff
changeset
|
5 * Copyright (C) 2017-2021 Osimis S.A., Belgium |
| 0 | 6 * |
| 7 * This program is free software: you can redistribute it and/or | |
| 8 * modify it under the terms of the GNU Affero General Public License | |
| 9 * as published by the Free Software Foundation, either version 3 of | |
| 10 * the License, or (at your option) any later version. | |
| 11 * | |
| 12 * This program is distributed in the hope that it will be useful, but | |
| 13 * WITHOUT ANY WARRANTY; without even the implied warranty of | |
| 14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
| 15 * Affero General Public License for more details. | |
| 16 * | |
| 17 * You should have received a copy of the GNU Affero General Public License | |
| 18 * along with this program. If not, see <http://www.gnu.org/licenses/>. | |
| 19 **/ | |
| 20 | |
| 21 | |
| 22 #include "IndexBackend.h" | |
| 23 | |
| 152 | 24 #include "../../Resources/Orthanc/Databases/ISqlLookupFormatter.h" |
| 0 | 25 #include "../Common/BinaryStringValue.h" |
| 26 #include "../Common/Integer64Value.h" | |
| 27 #include "../Common/Utf8StringValue.h" | |
|
213
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
28 #include "DatabaseBackendAdapterV2.h" |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
29 #include "DatabaseBackendAdapterV3.h" |
| 0 | 30 #include "GlobalProperties.h" |
| 31 | |
|
157
275e14f57f1e
replacing deprecated std::auto_ptr by std::unique_ptr
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
152
diff
changeset
|
32 #include <Compatibility.h> // For std::unique_ptr<> |
| 152 | 33 #include <Logging.h> |
| 34 #include <OrthancException.h> | |
| 0 | 35 |
| 36 | |
| 37 namespace OrthancDatabases | |
| 38 { | |
| 39 static std::string ConvertWildcardToLike(const std::string& query) | |
| 40 { | |
| 41 std::string s = query; | |
| 42 | |
| 43 for (size_t i = 0; i < s.size(); i++) | |
| 44 { | |
| 45 if (s[i] == '*') | |
| 46 { | |
| 47 s[i] = '%'; | |
| 48 } | |
| 49 else if (s[i] == '?') | |
| 50 { | |
| 51 s[i] = '_'; | |
| 52 } | |
| 53 } | |
| 54 | |
| 65 | 55 // TODO Escape underscores and percents |
| 56 | |
| 0 | 57 return s; |
| 58 } | |
| 59 | |
| 60 | |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
61 int64_t IndexBackend::ReadInteger64(const DatabaseManager::StatementBase& statement, |
| 0 | 62 size_t field) |
| 63 { | |
| 64 if (statement.IsDone()) | |
| 65 { | |
| 66 throw Orthanc::OrthancException(Orthanc::ErrorCode_Database); | |
| 67 } | |
| 68 | |
| 69 const IValue& value = statement.GetResultField(field); | |
| 70 | |
| 71 switch (value.GetType()) | |
| 72 { | |
| 73 case ValueType_Integer64: | |
| 74 return dynamic_cast<const Integer64Value&>(value).GetValue(); | |
| 75 | |
| 76 default: | |
| 77 //LOG(ERROR) << value.Format(); | |
| 78 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); | |
| 79 } | |
| 80 } | |
| 81 | |
| 82 | |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
83 int32_t IndexBackend::ReadInteger32(const DatabaseManager::StatementBase& statement, |
| 0 | 84 size_t field) |
| 85 { | |
| 86 if (statement.IsDone()) | |
| 87 { | |
| 88 throw Orthanc::OrthancException(Orthanc::ErrorCode_Database); | |
| 89 } | |
| 90 | |
| 91 int64_t value = ReadInteger64(statement, field); | |
| 92 | |
| 93 if (value != static_cast<int64_t>(static_cast<int32_t>(value))) | |
| 94 { | |
| 95 LOG(ERROR) << "Integer overflow"; | |
| 96 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); | |
| 97 } | |
| 98 else | |
| 99 { | |
| 100 return static_cast<int32_t>(value); | |
| 101 } | |
| 102 } | |
| 103 | |
| 104 | |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
105 std::string IndexBackend::ReadString(const DatabaseManager::StatementBase& statement, |
| 0 | 106 size_t field) |
| 107 { | |
| 108 const IValue& value = statement.GetResultField(field); | |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
109 |
| 0 | 110 switch (value.GetType()) |
| 111 { | |
| 112 case ValueType_BinaryString: | |
| 113 return dynamic_cast<const BinaryStringValue&>(value).GetContent(); | |
| 114 | |
| 115 case ValueType_Utf8String: | |
| 116 return dynamic_cast<const Utf8StringValue&>(value).GetContent(); | |
| 117 | |
| 118 default: | |
| 119 //LOG(ERROR) << value.Format(); | |
| 120 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); | |
| 121 } | |
| 122 } | |
| 123 | |
| 124 | |
| 125 template <typename T> | |
| 126 void IndexBackend::ReadListOfIntegers(std::list<T>& target, | |
| 127 DatabaseManager::CachedStatement& statement, | |
| 128 const Dictionary& args) | |
| 129 { | |
| 130 statement.Execute(args); | |
| 131 | |
| 132 target.clear(); | |
| 133 | |
| 134 if (!statement.IsDone()) | |
| 135 { | |
| 136 if (statement.GetResultFieldsCount() != 1) | |
| 137 { | |
| 138 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); | |
| 139 } | |
| 140 | |
| 141 statement.SetResultFieldType(0, ValueType_Integer64); | |
| 142 | |
| 143 while (!statement.IsDone()) | |
| 144 { | |
| 145 target.push_back(static_cast<T>(ReadInteger64(statement, 0))); | |
| 146 statement.Next(); | |
| 147 } | |
| 148 } | |
| 149 } | |
| 150 | |
| 151 | |
| 152 void IndexBackend::ReadListOfStrings(std::list<std::string>& target, | |
| 153 DatabaseManager::CachedStatement& statement, | |
| 154 const Dictionary& args) | |
| 155 { | |
| 156 statement.Execute(args); | |
| 157 | |
| 158 target.clear(); | |
| 159 | |
| 160 if (!statement.IsDone()) | |
| 161 { | |
| 162 if (statement.GetResultFieldsCount() != 1) | |
| 163 { | |
| 164 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); | |
| 165 } | |
| 166 | |
| 167 while (!statement.IsDone()) | |
| 168 { | |
| 169 target.push_back(ReadString(statement, 0)); | |
| 170 statement.Next(); | |
| 171 } | |
| 172 } | |
| 173 } | |
| 174 | |
| 175 | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
176 void IndexBackend::ReadChangesInternal(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
177 bool& done, |
| 0 | 178 DatabaseManager::CachedStatement& statement, |
| 179 const Dictionary& args, | |
| 180 uint32_t maxResults) | |
| 181 { | |
| 182 statement.Execute(args); | |
| 183 | |
| 184 uint32_t count = 0; | |
| 185 | |
| 186 while (count < maxResults && | |
| 187 !statement.IsDone()) | |
| 188 { | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
189 output.AnswerChange( |
| 0 | 190 ReadInteger64(statement, 0), |
| 191 ReadInteger32(statement, 1), | |
| 192 static_cast<OrthancPluginResourceType>(ReadInteger32(statement, 3)), | |
| 193 GetPublicId(ReadInteger64(statement, 2)), | |
| 194 ReadString(statement, 4)); | |
| 195 | |
| 196 statement.Next(); | |
| 197 count++; | |
| 198 } | |
| 199 | |
| 200 done = (count < maxResults || | |
| 201 statement.IsDone()); | |
| 202 } | |
| 203 | |
| 204 | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
205 void IndexBackend::ReadExportedResourcesInternal(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
206 bool& done, |
| 0 | 207 DatabaseManager::CachedStatement& statement, |
| 208 const Dictionary& args, | |
| 209 uint32_t maxResults) | |
| 210 { | |
| 211 statement.Execute(args); | |
| 212 | |
| 213 uint32_t count = 0; | |
| 214 | |
| 215 while (count < maxResults && | |
| 216 !statement.IsDone()) | |
| 217 { | |
| 218 int64_t seq = ReadInteger64(statement, 0); | |
| 219 OrthancPluginResourceType resourceType = | |
| 220 static_cast<OrthancPluginResourceType>(ReadInteger32(statement, 1)); | |
| 221 std::string publicId = ReadString(statement, 2); | |
| 222 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
223 output.AnswerExportedResource(seq, |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
224 resourceType, |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
225 publicId, |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
226 ReadString(statement, 3), // modality |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
227 ReadString(statement, 8), // date |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
228 ReadString(statement, 4), // patient ID |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
229 ReadString(statement, 5), // study instance UID |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
230 ReadString(statement, 6), // series instance UID |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
231 ReadString(statement, 7)); // sop instance UID |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
232 |
| 0 | 233 statement.Next(); |
| 234 count++; | |
| 235 } | |
| 236 | |
| 237 done = (count < maxResults || | |
| 238 statement.IsDone()); | |
| 239 } | |
| 240 | |
| 241 | |
| 242 void IndexBackend::ClearDeletedFiles() | |
| 243 { | |
| 244 DatabaseManager::CachedStatement statement( | |
| 245 STATEMENT_FROM_HERE, manager_, | |
| 246 "DELETE FROM DeletedFiles"); | |
| 247 | |
| 248 statement.Execute(); | |
| 249 } | |
| 250 | |
| 251 | |
| 252 void IndexBackend::ClearDeletedResources() | |
| 253 { | |
| 254 DatabaseManager::CachedStatement statement( | |
| 255 STATEMENT_FROM_HERE, manager_, | |
| 256 "DELETE FROM DeletedResources"); | |
| 257 | |
| 258 statement.Execute(); | |
| 259 } | |
| 260 | |
| 261 | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
262 void IndexBackend::SignalDeletedFiles(IDatabaseBackendOutput& output) |
| 0 | 263 { |
| 264 DatabaseManager::CachedStatement statement( | |
| 265 STATEMENT_FROM_HERE, manager_, | |
| 266 "SELECT * FROM DeletedFiles"); | |
| 267 | |
| 268 statement.SetReadOnly(true); | |
| 269 statement.Execute(); | |
| 270 | |
| 271 while (!statement.IsDone()) | |
| 272 { | |
| 273 std::string a = ReadString(statement, 0); | |
| 274 std::string b = ReadString(statement, 5); | |
| 275 std::string c = ReadString(statement, 6); | |
| 276 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
277 output.SignalDeletedAttachment(a.c_str(), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
278 ReadInteger32(statement, 1), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
279 ReadInteger64(statement, 3), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
280 b.c_str(), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
281 ReadInteger32(statement, 4), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
282 ReadInteger64(statement, 2), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
283 c.c_str()); |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
284 |
| 0 | 285 statement.Next(); |
| 286 } | |
| 287 } | |
| 288 | |
| 289 | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
290 void IndexBackend::SignalDeletedResources(IDatabaseBackendOutput& output) |
| 0 | 291 { |
| 292 DatabaseManager::CachedStatement statement( | |
| 293 STATEMENT_FROM_HERE, manager_, | |
| 294 "SELECT * FROM DeletedResources"); | |
| 295 | |
| 296 statement.SetReadOnly(true); | |
| 297 statement.Execute(); | |
| 298 | |
| 299 while (!statement.IsDone()) | |
| 300 { | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
301 output.SignalDeletedResource( |
| 0 | 302 ReadString(statement, 1), |
| 303 static_cast<OrthancPluginResourceType>(ReadInteger32(statement, 0))); | |
| 304 | |
| 305 statement.Next(); | |
| 306 } | |
| 307 } | |
| 308 | |
| 309 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
310 IndexBackend::IndexBackend(OrthancPluginContext* context, |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
311 IDatabaseFactory* factory) : |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
312 context_(context), |
| 0 | 313 manager_(factory) |
| 314 { | |
| 315 } | |
| 316 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
317 |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
318 void IndexBackend::SetOutputFactory(IDatabaseBackendOutput::IFactory* factory) |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
319 { |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
320 if (factory == NULL) |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
321 { |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
322 throw Orthanc::OrthancException(Orthanc::ErrorCode_NullPointer); |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
323 } |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
324 else if (outputFactory_.get() != NULL) |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
325 { |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
326 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
327 } |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
328 else |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
329 { |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
330 outputFactory_.reset(factory); |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
331 } |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
332 } |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
333 |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
334 |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
335 IDatabaseBackendOutput* IndexBackend::CreateOutput() |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
336 { |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
337 if (outputFactory_.get() == NULL) |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
338 { |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
339 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
340 } |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
341 else |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
342 { |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
343 return outputFactory_->CreateOutput(); |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
344 } |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
345 } |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
346 |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
347 |
| 0 | 348 void IndexBackend::AddAttachment(int64_t id, |
| 349 const OrthancPluginAttachment& attachment) | |
| 350 { | |
| 351 DatabaseManager::CachedStatement statement( | |
| 352 STATEMENT_FROM_HERE, manager_, | |
| 353 "INSERT INTO AttachedFiles VALUES(${id}, ${type}, ${uuid}, " | |
| 354 "${compressed}, ${uncompressed}, ${compression}, ${hash}, ${hash-compressed})"); | |
| 355 | |
| 356 statement.SetParameterType("id", ValueType_Integer64); | |
| 357 statement.SetParameterType("type", ValueType_Integer64); | |
| 358 statement.SetParameterType("uuid", ValueType_Utf8String); | |
| 359 statement.SetParameterType("compressed", ValueType_Integer64); | |
| 360 statement.SetParameterType("uncompressed", ValueType_Integer64); | |
| 361 statement.SetParameterType("compression", ValueType_Integer64); | |
| 362 statement.SetParameterType("hash", ValueType_Utf8String); | |
| 363 statement.SetParameterType("hash-compressed", ValueType_Utf8String); | |
| 364 | |
| 365 Dictionary args; | |
| 366 args.SetIntegerValue("id", id); | |
| 367 args.SetIntegerValue("type", attachment.contentType); | |
| 368 args.SetUtf8Value("uuid", attachment.uuid); | |
| 369 args.SetIntegerValue("compressed", attachment.compressedSize); | |
| 370 args.SetIntegerValue("uncompressed", attachment.uncompressedSize); | |
| 371 args.SetIntegerValue("compression", attachment.compressionType); | |
| 372 args.SetUtf8Value("hash", attachment.uncompressedHash); | |
| 373 args.SetUtf8Value("hash-compressed", attachment.compressedHash); | |
| 374 | |
| 375 statement.Execute(args); | |
| 376 } | |
| 377 | |
| 378 | |
| 379 void IndexBackend::AttachChild(int64_t parent, | |
| 380 int64_t child) | |
| 381 { | |
| 382 DatabaseManager::CachedStatement statement( | |
| 383 STATEMENT_FROM_HERE, manager_, | |
| 384 "UPDATE Resources SET parentId = ${parent} WHERE internalId = ${child}"); | |
| 385 | |
| 386 statement.SetParameterType("parent", ValueType_Integer64); | |
| 387 statement.SetParameterType("child", ValueType_Integer64); | |
| 388 | |
| 389 Dictionary args; | |
| 390 args.SetIntegerValue("parent", parent); | |
| 391 args.SetIntegerValue("child", child); | |
| 392 | |
| 393 statement.Execute(args); | |
| 394 } | |
| 395 | |
| 396 | |
| 397 void IndexBackend::ClearChanges() | |
| 398 { | |
| 399 DatabaseManager::CachedStatement statement( | |
| 400 STATEMENT_FROM_HERE, manager_, | |
| 401 "DELETE FROM Changes"); | |
| 402 | |
| 403 statement.Execute(); | |
| 404 } | |
| 405 | |
| 406 | |
| 407 void IndexBackend::ClearExportedResources() | |
| 408 { | |
| 409 DatabaseManager::CachedStatement statement( | |
| 410 STATEMENT_FROM_HERE, manager_, | |
| 411 "DELETE FROM ExportedResources"); | |
| 412 | |
| 413 statement.Execute(); | |
| 414 } | |
| 415 | |
| 416 | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
417 void IndexBackend::DeleteAttachment(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
418 int64_t id, |
| 0 | 419 int32_t attachment) |
| 420 { | |
| 421 ClearDeletedFiles(); | |
| 422 | |
| 423 { | |
| 424 DatabaseManager::CachedStatement statement( | |
| 425 STATEMENT_FROM_HERE, manager_, | |
| 426 "DELETE FROM AttachedFiles WHERE id=${id} AND fileType=${type}"); | |
| 427 | |
| 428 statement.SetParameterType("id", ValueType_Integer64); | |
| 429 statement.SetParameterType("type", ValueType_Integer64); | |
| 430 | |
| 431 Dictionary args; | |
| 432 args.SetIntegerValue("id", id); | |
| 433 args.SetIntegerValue("type", static_cast<int>(attachment)); | |
| 434 | |
| 435 statement.Execute(args); | |
| 436 } | |
| 437 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
438 SignalDeletedFiles(output); |
| 0 | 439 } |
| 440 | |
| 441 | |
| 442 void IndexBackend::DeleteMetadata(int64_t id, | |
| 443 int32_t metadataType) | |
| 444 { | |
| 445 DatabaseManager::CachedStatement statement( | |
| 446 STATEMENT_FROM_HERE, manager_, | |
| 447 "DELETE FROM Metadata WHERE id=${id} and type=${type}"); | |
| 448 | |
| 449 statement.SetParameterType("id", ValueType_Integer64); | |
| 450 statement.SetParameterType("type", ValueType_Integer64); | |
| 451 | |
| 452 Dictionary args; | |
| 453 args.SetIntegerValue("id", id); | |
| 454 args.SetIntegerValue("type", static_cast<int>(metadataType)); | |
| 455 | |
| 456 statement.Execute(args); | |
| 457 } | |
| 458 | |
| 459 | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
460 void IndexBackend::DeleteResource(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
461 int64_t id) |
| 0 | 462 { |
|
1
d17b2631bb67
starting StorageBackend
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
463 assert(manager_.GetDialect() != Dialect_MySQL); |
| 0 | 464 |
| 465 ClearDeletedFiles(); | |
| 466 ClearDeletedResources(); | |
| 467 | |
| 468 { | |
| 469 DatabaseManager::CachedStatement statement( | |
| 470 STATEMENT_FROM_HERE, GetManager(), | |
| 471 "DELETE FROM RemainingAncestor"); | |
| 472 | |
| 473 statement.Execute(); | |
| 474 } | |
| 475 | |
| 476 { | |
| 477 DatabaseManager::CachedStatement statement( | |
| 478 STATEMENT_FROM_HERE, GetManager(), | |
| 479 "DELETE FROM Resources WHERE internalId=${id}"); | |
| 480 | |
| 481 statement.SetParameterType("id", ValueType_Integer64); | |
| 482 | |
| 483 Dictionary args; | |
| 484 args.SetIntegerValue("id", id); | |
| 485 | |
| 486 statement.Execute(args); | |
| 487 } | |
| 488 | |
| 489 | |
| 490 { | |
| 491 DatabaseManager::CachedStatement statement( | |
| 492 STATEMENT_FROM_HERE, GetManager(), | |
| 493 "SELECT * FROM RemainingAncestor"); | |
| 494 | |
| 495 statement.Execute(); | |
| 496 | |
| 497 if (!statement.IsDone()) | |
| 498 { | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
499 output.SignalRemainingAncestor( |
| 0 | 500 ReadString(statement, 1), |
| 501 static_cast<OrthancPluginResourceType>(ReadInteger32(statement, 0))); | |
| 502 | |
| 503 // There is at most 1 remaining ancestor | |
| 504 assert((statement.Next(), statement.IsDone())); | |
| 505 } | |
| 506 } | |
| 507 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
508 SignalDeletedFiles(output); |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
509 SignalDeletedResources(output); |
| 0 | 510 } |
| 511 | |
| 512 | |
| 513 void IndexBackend::GetAllInternalIds(std::list<int64_t>& target, | |
| 514 OrthancPluginResourceType resourceType) | |
| 515 { | |
| 516 DatabaseManager::CachedStatement statement( | |
| 517 STATEMENT_FROM_HERE, manager_, | |
| 518 "SELECT internalId FROM Resources WHERE resourceType=${type}"); | |
| 519 | |
| 520 statement.SetReadOnly(true); | |
| 521 statement.SetParameterType("type", ValueType_Integer64); | |
| 522 | |
| 523 Dictionary args; | |
| 524 args.SetIntegerValue("type", static_cast<int>(resourceType)); | |
| 525 | |
| 526 ReadListOfIntegers<int64_t>(target, statement, args); | |
| 527 } | |
| 528 | |
| 529 | |
| 530 void IndexBackend::GetAllPublicIds(std::list<std::string>& target, | |
| 531 OrthancPluginResourceType resourceType) | |
| 532 { | |
| 533 DatabaseManager::CachedStatement statement( | |
| 534 STATEMENT_FROM_HERE, manager_, | |
| 535 "SELECT publicId FROM Resources WHERE resourceType=${type}"); | |
| 536 | |
| 537 statement.SetReadOnly(true); | |
| 538 statement.SetParameterType("type", ValueType_Integer64); | |
| 539 | |
| 540 Dictionary args; | |
| 541 args.SetIntegerValue("type", static_cast<int>(resourceType)); | |
| 542 | |
| 543 ReadListOfStrings(target, statement, args); | |
| 544 } | |
| 545 | |
| 546 | |
| 547 void IndexBackend::GetAllPublicIds(std::list<std::string>& target, | |
| 548 OrthancPluginResourceType resourceType, | |
| 549 uint64_t since, | |
| 550 uint64_t limit) | |
| 551 { | |
| 552 DatabaseManager::CachedStatement statement( | |
| 553 STATEMENT_FROM_HERE, manager_, | |
| 554 "SELECT publicId FROM (SELECT publicId FROM Resources " | |
| 555 "WHERE resourceType=${type}) AS tmp " | |
| 556 "ORDER BY tmp.publicId LIMIT ${limit} OFFSET ${since}"); | |
| 557 | |
| 558 statement.SetReadOnly(true); | |
| 559 statement.SetParameterType("type", ValueType_Integer64); | |
| 560 statement.SetParameterType("limit", ValueType_Integer64); | |
| 561 statement.SetParameterType("since", ValueType_Integer64); | |
| 562 | |
| 563 Dictionary args; | |
| 564 args.SetIntegerValue("type", static_cast<int>(resourceType)); | |
| 565 args.SetIntegerValue("limit", limit); | |
| 566 args.SetIntegerValue("since", since); | |
| 567 | |
| 568 ReadListOfStrings(target, statement, args); | |
| 569 } | |
| 570 | |
| 571 | |
| 572 /* Use GetOutput().AnswerChange() */ | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
573 void IndexBackend::GetChanges(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
574 bool& done /*out*/, |
| 0 | 575 int64_t since, |
| 576 uint32_t maxResults) | |
| 577 { | |
| 578 DatabaseManager::CachedStatement statement( | |
| 579 STATEMENT_FROM_HERE, manager_, | |
| 580 "SELECT * FROM Changes WHERE seq>${since} ORDER BY seq LIMIT ${limit}"); | |
| 581 | |
| 582 statement.SetReadOnly(true); | |
| 583 statement.SetParameterType("limit", ValueType_Integer64); | |
| 584 statement.SetParameterType("since", ValueType_Integer64); | |
| 585 | |
| 586 Dictionary args; | |
| 587 args.SetIntegerValue("limit", maxResults + 1); | |
| 588 args.SetIntegerValue("since", since); | |
| 589 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
590 ReadChangesInternal(output, done, statement, args, maxResults); |
| 0 | 591 } |
| 592 | |
| 593 | |
| 594 void IndexBackend::GetChildrenInternalId(std::list<int64_t>& target /*out*/, | |
| 595 int64_t id) | |
| 596 { | |
| 597 DatabaseManager::CachedStatement statement( | |
| 598 STATEMENT_FROM_HERE, manager_, | |
| 599 "SELECT a.internalId FROM Resources AS a, Resources AS b " | |
| 600 "WHERE a.parentId = b.internalId AND b.internalId = ${id}"); | |
| 601 | |
| 602 statement.SetReadOnly(true); | |
| 603 statement.SetParameterType("id", ValueType_Integer64); | |
| 604 | |
| 605 Dictionary args; | |
| 606 args.SetIntegerValue("id", id); | |
| 607 | |
| 608 ReadListOfIntegers<int64_t>(target, statement, args); | |
| 609 } | |
| 610 | |
| 611 | |
| 612 void IndexBackend::GetChildrenPublicId(std::list<std::string>& target /*out*/, | |
| 613 int64_t id) | |
| 614 { | |
| 615 DatabaseManager::CachedStatement statement( | |
| 616 STATEMENT_FROM_HERE, manager_, | |
| 617 "SELECT a.publicId FROM Resources AS a, Resources AS b " | |
| 618 "WHERE a.parentId = b.internalId AND b.internalId = ${id}"); | |
| 619 | |
| 620 statement.SetReadOnly(true); | |
| 621 statement.SetParameterType("id", ValueType_Integer64); | |
| 622 | |
| 623 Dictionary args; | |
| 624 args.SetIntegerValue("id", id); | |
| 625 | |
| 626 ReadListOfStrings(target, statement, args); | |
| 627 } | |
| 628 | |
| 629 | |
| 630 /* Use GetOutput().AnswerExportedResource() */ | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
631 void IndexBackend::GetExportedResources(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
632 bool& done /*out*/, |
| 0 | 633 int64_t since, |
| 634 uint32_t maxResults) | |
| 635 { | |
| 636 DatabaseManager::CachedStatement statement( | |
| 637 STATEMENT_FROM_HERE, manager_, | |
| 638 "SELECT * FROM ExportedResources WHERE seq>${since} ORDER BY seq LIMIT ${limit}"); | |
| 639 | |
| 640 statement.SetReadOnly(true); | |
| 641 statement.SetParameterType("limit", ValueType_Integer64); | |
| 642 statement.SetParameterType("since", ValueType_Integer64); | |
| 643 | |
| 644 Dictionary args; | |
| 645 args.SetIntegerValue("limit", maxResults + 1); | |
| 646 args.SetIntegerValue("since", since); | |
| 647 | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
648 ReadExportedResourcesInternal(output, done, statement, args, maxResults); |
| 0 | 649 } |
| 650 | |
| 651 | |
| 652 /* Use GetOutput().AnswerChange() */ | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
653 void IndexBackend::GetLastChange(IDatabaseBackendOutput& output) |
| 0 | 654 { |
| 655 DatabaseManager::CachedStatement statement( | |
| 656 STATEMENT_FROM_HERE, manager_, | |
| 657 "SELECT * FROM Changes ORDER BY seq DESC LIMIT 1"); | |
| 658 | |
| 659 statement.SetReadOnly(true); | |
| 660 | |
| 661 Dictionary args; | |
| 662 | |
| 663 bool done; // Ignored | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
664 ReadChangesInternal(output, done, statement, args, 1); |
| 0 | 665 } |
| 666 | |
| 667 | |
| 668 /* Use GetOutput().AnswerExportedResource() */ | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
669 void IndexBackend::GetLastExportedResource(IDatabaseBackendOutput& output) |
| 0 | 670 { |
| 671 DatabaseManager::CachedStatement statement( | |
| 672 STATEMENT_FROM_HERE, manager_, | |
| 673 "SELECT * FROM ExportedResources ORDER BY seq DESC LIMIT 1"); | |
| 674 | |
| 675 statement.SetReadOnly(true); | |
| 676 | |
| 677 Dictionary args; | |
| 678 | |
| 679 bool done; // Ignored | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
680 ReadExportedResourcesInternal(output, done, statement, args, 1); |
| 0 | 681 } |
| 682 | |
| 683 | |
| 684 /* Use GetOutput().AnswerDicomTag() */ | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
685 void IndexBackend::GetMainDicomTags(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
686 int64_t id) |
| 0 | 687 { |
| 688 DatabaseManager::CachedStatement statement( | |
| 689 STATEMENT_FROM_HERE, manager_, | |
| 690 "SELECT * FROM MainDicomTags WHERE id=${id}"); | |
| 691 | |
| 692 statement.SetReadOnly(true); | |
| 693 statement.SetParameterType("id", ValueType_Integer64); | |
| 694 | |
| 695 Dictionary args; | |
| 696 args.SetIntegerValue("id", id); | |
| 697 | |
| 698 statement.Execute(args); | |
| 699 | |
| 700 while (!statement.IsDone()) | |
| 701 { | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
702 output.AnswerDicomTag(static_cast<uint16_t>(ReadInteger64(statement, 1)), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
703 static_cast<uint16_t>(ReadInteger64(statement, 2)), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
704 ReadString(statement, 3)); |
| 0 | 705 statement.Next(); |
| 706 } | |
| 707 } | |
| 708 | |
| 709 | |
| 710 std::string IndexBackend::GetPublicId(int64_t resourceId) | |
| 711 { | |
| 712 DatabaseManager::CachedStatement statement( | |
| 713 STATEMENT_FROM_HERE, manager_, | |
| 714 "SELECT publicId FROM Resources WHERE internalId=${id}"); | |
| 715 | |
| 716 statement.SetReadOnly(true); | |
| 717 statement.SetParameterType("id", ValueType_Integer64); | |
| 718 | |
| 719 Dictionary args; | |
| 720 args.SetIntegerValue("id", resourceId); | |
| 721 | |
| 722 statement.Execute(args); | |
| 723 | |
| 724 if (statement.IsDone()) | |
| 725 { | |
| 726 throw Orthanc::OrthancException(Orthanc::ErrorCode_UnknownResource); | |
| 727 } | |
| 728 else | |
| 729 { | |
| 730 return ReadString(statement, 0); | |
| 731 } | |
| 732 } | |
| 733 | |
| 734 | |
| 209 | 735 uint64_t IndexBackend::GetResourcesCount(OrthancPluginResourceType resourceType) |
| 0 | 736 { |
|
157
275e14f57f1e
replacing deprecated std::auto_ptr by std::unique_ptr
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
152
diff
changeset
|
737 std::unique_ptr<DatabaseManager::CachedStatement> statement; |
| 0 | 738 |
|
1
d17b2631bb67
starting StorageBackend
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
739 switch (manager_.GetDialect()) |
| 0 | 740 { |
| 741 case Dialect_MySQL: | |
| 742 statement.reset(new DatabaseManager::CachedStatement( | |
| 743 STATEMENT_FROM_HERE, GetManager(), | |
| 744 "SELECT CAST(COUNT(*) AS UNSIGNED INT) FROM Resources WHERE resourceType=${type}")); | |
| 745 break; | |
| 746 | |
| 747 case Dialect_PostgreSQL: | |
| 748 statement.reset(new DatabaseManager::CachedStatement( | |
|
75
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
749 STATEMENT_FROM_HERE, GetManager(), |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
750 "SELECT CAST(COUNT(*) AS BIGINT) FROM Resources WHERE resourceType=${type}")); |
| 0 | 751 break; |
| 752 | |
| 753 case Dialect_SQLite: | |
| 754 statement.reset(new DatabaseManager::CachedStatement( | |
|
75
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
755 STATEMENT_FROM_HERE, GetManager(), |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
756 "SELECT COUNT(*) FROM Resources WHERE resourceType=${type}")); |
| 0 | 757 break; |
| 758 | |
| 759 default: | |
| 760 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); | |
| 761 } | |
| 762 | |
| 763 statement->SetReadOnly(true); | |
| 764 statement->SetParameterType("type", ValueType_Integer64); | |
| 765 | |
| 766 Dictionary args; | |
| 767 args.SetIntegerValue("type", resourceType); | |
| 768 | |
| 769 statement->Execute(args); | |
| 770 | |
| 771 return static_cast<uint64_t>(ReadInteger64(*statement, 0)); | |
| 772 } | |
| 773 | |
| 774 | |
| 775 OrthancPluginResourceType IndexBackend::GetResourceType(int64_t resourceId) | |
| 776 { | |
| 777 DatabaseManager::CachedStatement statement( | |
| 778 STATEMENT_FROM_HERE, manager_, | |
| 779 "SELECT resourceType FROM Resources WHERE internalId=${id}"); | |
| 780 | |
| 781 statement.SetReadOnly(true); | |
| 782 statement.SetParameterType("id", ValueType_Integer64); | |
| 783 | |
| 784 Dictionary args; | |
| 785 args.SetIntegerValue("id", resourceId); | |
| 786 | |
| 787 statement.Execute(args); | |
| 788 | |
| 789 if (statement.IsDone()) | |
| 790 { | |
| 791 throw Orthanc::OrthancException(Orthanc::ErrorCode_UnknownResource); | |
| 792 } | |
| 793 else | |
| 794 { | |
| 795 return static_cast<OrthancPluginResourceType>(ReadInteger32(statement, 0)); | |
| 796 } | |
| 797 } | |
| 798 | |
| 799 | |
| 800 uint64_t IndexBackend::GetTotalCompressedSize() | |
| 801 { | |
|
157
275e14f57f1e
replacing deprecated std::auto_ptr by std::unique_ptr
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
152
diff
changeset
|
802 std::unique_ptr<DatabaseManager::CachedStatement> statement; |
| 0 | 803 |
| 804 // NB: "COALESCE" is used to replace "NULL" by "0" if the number of rows is empty | |
| 805 | |
|
1
d17b2631bb67
starting StorageBackend
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
806 switch (manager_.GetDialect()) |
| 0 | 807 { |
| 808 case Dialect_MySQL: | |
| 809 statement.reset(new DatabaseManager::CachedStatement( | |
| 810 STATEMENT_FROM_HERE, GetManager(), | |
| 811 "SELECT CAST(COALESCE(SUM(compressedSize), 0) AS UNSIGNED INTEGER) FROM AttachedFiles")); | |
| 812 break; | |
| 813 | |
| 814 case Dialect_PostgreSQL: | |
| 815 statement.reset(new DatabaseManager::CachedStatement( | |
| 816 STATEMENT_FROM_HERE, GetManager(), | |
| 817 "SELECT CAST(COALESCE(SUM(compressedSize), 0) AS BIGINT) FROM AttachedFiles")); | |
| 818 break; | |
| 819 | |
| 820 case Dialect_SQLite: | |
| 821 statement.reset(new DatabaseManager::CachedStatement( | |
| 822 STATEMENT_FROM_HERE, GetManager(), | |
| 823 "SELECT COALESCE(SUM(compressedSize), 0) FROM AttachedFiles")); | |
| 824 break; | |
| 825 | |
| 826 default: | |
| 827 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); | |
| 828 } | |
| 829 | |
| 830 statement->SetReadOnly(true); | |
| 831 statement->Execute(); | |
| 832 | |
| 833 return static_cast<uint64_t>(ReadInteger64(*statement, 0)); | |
| 834 } | |
| 835 | |
| 836 | |
| 837 uint64_t IndexBackend::GetTotalUncompressedSize() | |
| 838 { | |
|
157
275e14f57f1e
replacing deprecated std::auto_ptr by std::unique_ptr
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
152
diff
changeset
|
839 std::unique_ptr<DatabaseManager::CachedStatement> statement; |
| 0 | 840 |
| 841 // NB: "COALESCE" is used to replace "NULL" by "0" if the number of rows is empty | |
| 842 | |
|
1
d17b2631bb67
starting StorageBackend
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
843 switch (manager_.GetDialect()) |
| 0 | 844 { |
| 845 case Dialect_MySQL: | |
| 846 statement.reset(new DatabaseManager::CachedStatement( | |
| 847 STATEMENT_FROM_HERE, GetManager(), | |
| 848 "SELECT CAST(COALESCE(SUM(uncompressedSize), 0) AS UNSIGNED INTEGER) FROM AttachedFiles")); | |
| 849 break; | |
| 850 | |
| 851 case Dialect_PostgreSQL: | |
| 852 statement.reset(new DatabaseManager::CachedStatement( | |
| 853 STATEMENT_FROM_HERE, GetManager(), | |
| 854 "SELECT CAST(COALESCE(SUM(uncompressedSize), 0) AS BIGINT) FROM AttachedFiles")); | |
| 855 break; | |
| 856 | |
| 857 case Dialect_SQLite: | |
| 858 statement.reset(new DatabaseManager::CachedStatement( | |
| 859 STATEMENT_FROM_HERE, GetManager(), | |
| 860 "SELECT COALESCE(SUM(uncompressedSize), 0) FROM AttachedFiles")); | |
| 861 break; | |
| 862 | |
| 863 default: | |
| 864 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); | |
| 865 } | |
| 866 | |
| 867 statement->SetReadOnly(true); | |
| 868 statement->Execute(); | |
| 869 | |
| 870 return static_cast<uint64_t>(ReadInteger64(*statement, 0)); | |
| 871 } | |
| 872 | |
| 873 | |
| 874 bool IndexBackend::IsExistingResource(int64_t internalId) | |
| 875 { | |
| 876 DatabaseManager::CachedStatement statement( | |
| 877 STATEMENT_FROM_HERE, manager_, | |
| 878 "SELECT * FROM Resources WHERE internalId=${id}"); | |
| 879 | |
| 880 statement.SetReadOnly(true); | |
| 881 statement.SetParameterType("id", ValueType_Integer64); | |
| 882 | |
| 883 Dictionary args; | |
| 884 args.SetIntegerValue("id", internalId); | |
| 885 | |
| 886 statement.Execute(args); | |
| 887 | |
| 888 return !statement.IsDone(); | |
| 889 } | |
| 890 | |
| 891 | |
| 892 bool IndexBackend::IsProtectedPatient(int64_t internalId) | |
| 893 { | |
| 894 DatabaseManager::CachedStatement statement( | |
| 895 STATEMENT_FROM_HERE, manager_, | |
| 896 "SELECT * FROM PatientRecyclingOrder WHERE patientId = ${id}"); | |
| 897 | |
| 898 statement.SetReadOnly(true); | |
| 899 statement.SetParameterType("id", ValueType_Integer64); | |
| 900 | |
| 901 Dictionary args; | |
| 902 args.SetIntegerValue("id", internalId); | |
| 903 | |
| 904 statement.Execute(args); | |
| 905 | |
| 906 return statement.IsDone(); | |
| 907 } | |
| 908 | |
| 909 | |
| 910 void IndexBackend::ListAvailableMetadata(std::list<int32_t>& target /*out*/, | |
| 911 int64_t id) | |
| 912 { | |
| 913 DatabaseManager::CachedStatement statement( | |
| 914 STATEMENT_FROM_HERE, manager_, | |
| 915 "SELECT type FROM Metadata WHERE id=${id}"); | |
| 916 | |
| 917 statement.SetReadOnly(true); | |
| 918 statement.SetParameterType("id", ValueType_Integer64); | |
| 919 | |
| 920 Dictionary args; | |
| 921 args.SetIntegerValue("id", id); | |
| 922 | |
| 923 ReadListOfIntegers<int32_t>(target, statement, args); | |
| 924 } | |
| 925 | |
| 926 | |
| 927 void IndexBackend::ListAvailableAttachments(std::list<int32_t>& target /*out*/, | |
| 928 int64_t id) | |
| 929 { | |
| 930 DatabaseManager::CachedStatement statement( | |
| 931 STATEMENT_FROM_HERE, manager_, | |
| 932 "SELECT fileType FROM AttachedFiles WHERE id=${id}"); | |
| 933 | |
| 934 statement.SetReadOnly(true); | |
| 935 statement.SetParameterType("id", ValueType_Integer64); | |
| 936 | |
| 937 Dictionary args; | |
| 938 args.SetIntegerValue("id", id); | |
| 939 | |
| 940 ReadListOfIntegers<int32_t>(target, statement, args); | |
| 941 } | |
| 942 | |
| 943 | |
| 209 | 944 void IndexBackend::LogChange(int32_t changeType, |
| 945 int64_t resourceId, | |
| 946 OrthancPluginResourceType resourceType, | |
| 947 const char* date) | |
| 0 | 948 { |
| 949 DatabaseManager::CachedStatement statement( | |
| 950 STATEMENT_FROM_HERE, manager_, | |
| 951 "INSERT INTO Changes VALUES(${}, ${changeType}, ${id}, ${resourceType}, ${date})"); | |
| 952 | |
| 953 statement.SetParameterType("changeType", ValueType_Integer64); | |
| 954 statement.SetParameterType("id", ValueType_Integer64); | |
| 955 statement.SetParameterType("resourceType", ValueType_Integer64); | |
| 956 statement.SetParameterType("date", ValueType_Utf8String); | |
| 957 | |
| 958 Dictionary args; | |
| 209 | 959 args.SetIntegerValue("changeType", changeType); |
| 960 args.SetIntegerValue("id", resourceId); | |
| 961 args.SetIntegerValue("resourceType", resourceType); | |
| 962 args.SetUtf8Value("date", date); | |
| 0 | 963 |
| 964 statement.Execute(args); | |
| 965 } | |
| 966 | |
| 967 | |
| 968 void IndexBackend::LogExportedResource(const OrthancPluginExportedResource& resource) | |
| 969 { | |
| 970 DatabaseManager::CachedStatement statement( | |
| 971 STATEMENT_FROM_HERE, manager_, | |
| 972 "INSERT INTO ExportedResources VALUES(${}, ${type}, ${publicId}, " | |
| 973 "${modality}, ${patient}, ${study}, ${series}, ${instance}, ${date})"); | |
| 974 | |
| 975 statement.SetParameterType("type", ValueType_Integer64); | |
| 976 statement.SetParameterType("publicId", ValueType_Utf8String); | |
| 977 statement.SetParameterType("modality", ValueType_Utf8String); | |
| 978 statement.SetParameterType("patient", ValueType_Utf8String); | |
| 979 statement.SetParameterType("study", ValueType_Utf8String); | |
| 980 statement.SetParameterType("series", ValueType_Utf8String); | |
| 981 statement.SetParameterType("instance", ValueType_Utf8String); | |
| 982 statement.SetParameterType("date", ValueType_Utf8String); | |
| 983 | |
| 984 Dictionary args; | |
| 985 args.SetIntegerValue("type", resource.resourceType); | |
| 986 args.SetUtf8Value("publicId", resource.publicId); | |
| 987 args.SetUtf8Value("modality", resource.modality); | |
| 988 args.SetUtf8Value("patient", resource.patientId); | |
| 989 args.SetUtf8Value("study", resource.studyInstanceUid); | |
| 990 args.SetUtf8Value("series", resource.seriesInstanceUid); | |
| 991 args.SetUtf8Value("instance", resource.sopInstanceUid); | |
| 992 args.SetUtf8Value("date", resource.date); | |
| 993 | |
| 994 statement.Execute(args); | |
| 995 } | |
| 996 | |
| 997 | |
| 998 /* Use GetOutput().AnswerAttachment() */ | |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
999 bool IndexBackend::LookupAttachment(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1000 int64_t id, |
| 0 | 1001 int32_t contentType) |
| 1002 { | |
| 1003 DatabaseManager::CachedStatement statement( | |
| 1004 STATEMENT_FROM_HERE, manager_, | |
| 1005 "SELECT uuid, uncompressedSize, compressionType, compressedSize, " | |
| 1006 "uncompressedHash, compressedHash FROM AttachedFiles WHERE id=${id} AND fileType=${type}"); | |
| 1007 | |
| 1008 statement.SetReadOnly(true); | |
| 1009 statement.SetParameterType("id", ValueType_Integer64); | |
| 1010 statement.SetParameterType("type", ValueType_Integer64); | |
| 1011 | |
| 1012 Dictionary args; | |
| 1013 args.SetIntegerValue("id", id); | |
| 1014 args.SetIntegerValue("type", static_cast<int>(contentType)); | |
| 1015 | |
| 1016 statement.Execute(args); | |
| 1017 | |
| 1018 if (statement.IsDone()) | |
| 1019 { | |
| 1020 return false; | |
| 1021 } | |
| 1022 else | |
| 1023 { | |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1024 output.AnswerAttachment(ReadString(statement, 0), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1025 contentType, |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1026 ReadInteger64(statement, 1), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1027 ReadString(statement, 4), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1028 ReadInteger32(statement, 2), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1029 ReadInteger64(statement, 3), |
|
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1030 ReadString(statement, 5)); |
| 0 | 1031 return true; |
| 1032 } | |
| 1033 } | |
| 1034 | |
| 1035 | |
| 1036 bool IndexBackend::LookupGlobalProperty(std::string& target /*out*/, | |
|
221
73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
220
diff
changeset
|
1037 const char* serverIdentifier, |
| 0 | 1038 int32_t property) |
| 1039 { | |
|
221
73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
220
diff
changeset
|
1040 return ::OrthancDatabases::LookupGlobalProperty(target, manager_, serverIdentifier, |
|
73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
220
diff
changeset
|
1041 static_cast<Orthanc::GlobalProperty>(property)); |
| 0 | 1042 } |
| 1043 | |
| 1044 | |
| 1045 void IndexBackend::LookupIdentifier(std::list<int64_t>& target /*out*/, | |
| 1046 OrthancPluginResourceType resourceType, | |
| 1047 uint16_t group, | |
| 1048 uint16_t element, | |
| 1049 OrthancPluginIdentifierConstraint constraint, | |
| 1050 const char* value) | |
| 1051 { | |
|
157
275e14f57f1e
replacing deprecated std::auto_ptr by std::unique_ptr
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
152
diff
changeset
|
1052 std::unique_ptr<DatabaseManager::CachedStatement> statement; |
| 0 | 1053 |
| 1054 std::string header = | |
| 1055 "SELECT d.id FROM DicomIdentifiers AS d, Resources AS r WHERE " | |
| 1056 "d.id = r.internalId AND r.resourceType=${type} AND d.tagGroup=${group} " | |
| 1057 "AND d.tagElement=${element} AND "; | |
| 1058 | |
| 1059 switch (constraint) | |
| 1060 { | |
| 1061 case OrthancPluginIdentifierConstraint_Equal: | |
| 1062 header += "d.value = ${value}"; | |
| 1063 statement.reset(new DatabaseManager::CachedStatement( | |
| 1064 STATEMENT_FROM_HERE, manager_, header.c_str())); | |
| 1065 break; | |
| 1066 | |
| 1067 case OrthancPluginIdentifierConstraint_SmallerOrEqual: | |
| 1068 header += "d.value <= ${value}"; | |
| 1069 statement.reset(new DatabaseManager::CachedStatement( | |
| 1070 STATEMENT_FROM_HERE, manager_, header.c_str())); | |
| 1071 break; | |
| 1072 | |
| 1073 case OrthancPluginIdentifierConstraint_GreaterOrEqual: | |
| 1074 header += "d.value >= ${value}"; | |
| 1075 statement.reset(new DatabaseManager::CachedStatement( | |
| 1076 STATEMENT_FROM_HERE, manager_, header.c_str())); | |
| 1077 break; | |
| 1078 | |
| 1079 case OrthancPluginIdentifierConstraint_Wildcard: | |
| 1080 header += "d.value LIKE ${value}"; | |
| 1081 statement.reset(new DatabaseManager::CachedStatement( | |
| 1082 STATEMENT_FROM_HERE, manager_, header.c_str())); | |
| 1083 break; | |
| 1084 | |
| 1085 default: | |
| 1086 throw Orthanc::OrthancException(Orthanc::ErrorCode_Database); | |
| 1087 } | |
| 1088 | |
| 1089 statement->SetReadOnly(true); | |
| 1090 statement->SetParameterType("type", ValueType_Integer64); | |
| 1091 statement->SetParameterType("group", ValueType_Integer64); | |
| 1092 statement->SetParameterType("element", ValueType_Integer64); | |
| 1093 statement->SetParameterType("value", ValueType_Utf8String); | |
| 1094 | |
| 1095 Dictionary args; | |
| 1096 args.SetIntegerValue("type", resourceType); | |
| 1097 args.SetIntegerValue("group", group); | |
| 1098 args.SetIntegerValue("element", element); | |
| 1099 | |
| 1100 if (constraint == OrthancPluginIdentifierConstraint_Wildcard) | |
| 1101 { | |
| 1102 args.SetUtf8Value("value", ConvertWildcardToLike(value)); | |
| 1103 } | |
| 1104 else | |
| 1105 { | |
| 1106 args.SetUtf8Value("value", value); | |
| 1107 } | |
| 1108 | |
| 1109 statement->Execute(args); | |
| 1110 | |
| 1111 target.clear(); | |
| 1112 while (!statement->IsDone()) | |
| 1113 { | |
| 1114 target.push_back(ReadInteger64(*statement, 0)); | |
| 1115 statement->Next(); | |
| 1116 } | |
| 1117 } | |
| 1118 | |
| 1119 | |
| 1120 void IndexBackend::LookupIdentifierRange(std::list<int64_t>& target /*out*/, | |
| 1121 OrthancPluginResourceType resourceType, | |
| 1122 uint16_t group, | |
| 1123 uint16_t element, | |
| 1124 const char* start, | |
| 1125 const char* end) | |
| 1126 { | |
| 1127 DatabaseManager::CachedStatement statement( | |
| 1128 STATEMENT_FROM_HERE, manager_, | |
| 1129 "SELECT d.id FROM DicomIdentifiers AS d, Resources AS r WHERE " | |
| 1130 "d.id = r.internalId AND r.resourceType=${type} AND d.tagGroup=${group} " | |
| 1131 "AND d.tagElement=${element} AND d.value>=${start} AND d.value<=${end}"); | |
| 1132 | |
| 1133 statement.SetReadOnly(true); | |
| 1134 statement.SetParameterType("type", ValueType_Integer64); | |
| 1135 statement.SetParameterType("group", ValueType_Integer64); | |
| 1136 statement.SetParameterType("element", ValueType_Integer64); | |
| 1137 statement.SetParameterType("start", ValueType_Utf8String); | |
| 1138 statement.SetParameterType("end", ValueType_Utf8String); | |
| 1139 | |
| 1140 Dictionary args; | |
| 1141 args.SetIntegerValue("type", resourceType); | |
| 1142 args.SetIntegerValue("group", group); | |
| 1143 args.SetIntegerValue("element", element); | |
| 1144 args.SetUtf8Value("start", start); | |
| 1145 args.SetUtf8Value("end", end); | |
| 1146 | |
| 1147 statement.Execute(args); | |
| 1148 | |
| 1149 target.clear(); | |
| 1150 while (!statement.IsDone()) | |
| 1151 { | |
| 1152 target.push_back(ReadInteger64(statement, 0)); | |
| 1153 statement.Next(); | |
| 1154 } | |
| 1155 } | |
| 1156 | |
| 1157 | |
| 1158 bool IndexBackend::LookupMetadata(std::string& target /*out*/, | |
| 1159 int64_t id, | |
| 1160 int32_t metadataType) | |
| 1161 { | |
| 1162 DatabaseManager::CachedStatement statement( | |
| 1163 STATEMENT_FROM_HERE, manager_, | |
| 1164 "SELECT value FROM Metadata WHERE id=${id} and type=${type}"); | |
| 1165 | |
| 1166 statement.SetReadOnly(true); | |
| 1167 statement.SetParameterType("id", ValueType_Integer64); | |
| 1168 statement.SetParameterType("type", ValueType_Integer64); | |
| 1169 | |
| 1170 Dictionary args; | |
| 1171 args.SetIntegerValue("id", id); | |
| 1172 args.SetIntegerValue("type", metadataType); | |
| 1173 | |
| 1174 statement.Execute(args); | |
| 1175 | |
| 1176 if (statement.IsDone()) | |
| 1177 { | |
| 1178 return false; | |
| 1179 } | |
| 1180 else | |
| 1181 { | |
| 1182 target = ReadString(statement, 0); | |
| 1183 return true; | |
| 1184 } | |
| 1185 } | |
| 1186 | |
| 1187 | |
| 1188 bool IndexBackend::LookupParent(int64_t& parentId /*out*/, | |
| 1189 int64_t resourceId) | |
| 1190 { | |
| 1191 DatabaseManager::CachedStatement statement( | |
| 1192 STATEMENT_FROM_HERE, manager_, | |
| 1193 "SELECT parentId FROM Resources WHERE internalId=${id}"); | |
| 1194 | |
| 1195 statement.SetReadOnly(true); | |
| 1196 statement.SetParameterType("id", ValueType_Integer64); | |
| 1197 | |
| 1198 Dictionary args; | |
| 1199 args.SetIntegerValue("id", resourceId); | |
| 1200 | |
| 1201 statement.Execute(args); | |
| 1202 | |
| 1203 if (statement.IsDone() || | |
| 1204 statement.GetResultField(0).GetType() == ValueType_Null) | |
| 1205 { | |
| 1206 return false; | |
| 1207 } | |
| 1208 else | |
| 1209 { | |
| 1210 parentId = ReadInteger64(statement, 0); | |
| 1211 return true; | |
| 1212 } | |
| 1213 } | |
| 1214 | |
| 1215 | |
| 1216 bool IndexBackend::LookupResource(int64_t& id /*out*/, | |
| 1217 OrthancPluginResourceType& type /*out*/, | |
| 1218 const char* publicId) | |
| 1219 { | |
| 1220 DatabaseManager::CachedStatement statement( | |
| 1221 STATEMENT_FROM_HERE, manager_, | |
| 1222 "SELECT internalId, resourceType FROM Resources WHERE publicId=${id}"); | |
| 1223 | |
| 1224 statement.SetReadOnly(true); | |
| 1225 statement.SetParameterType("id", ValueType_Utf8String); | |
| 1226 | |
| 1227 Dictionary args; | |
| 1228 args.SetUtf8Value("id", publicId); | |
| 1229 | |
| 1230 statement.Execute(args); | |
| 1231 | |
| 1232 if (statement.IsDone()) | |
| 1233 { | |
| 1234 return false; | |
| 1235 } | |
| 1236 else | |
| 1237 { | |
| 1238 id = ReadInteger64(statement, 0); | |
| 1239 type = static_cast<OrthancPluginResourceType>(ReadInteger32(statement, 1)); | |
| 1240 return true; | |
| 1241 } | |
| 1242 } | |
| 1243 | |
| 1244 | |
| 1245 bool IndexBackend::SelectPatientToRecycle(int64_t& internalId /*out*/) | |
| 1246 { | |
| 1247 DatabaseManager::CachedStatement statement( | |
| 1248 STATEMENT_FROM_HERE, manager_, | |
| 1249 "SELECT patientId FROM PatientRecyclingOrder ORDER BY seq ASC LIMIT 1"); | |
| 1250 | |
| 1251 statement.SetReadOnly(true); | |
| 1252 statement.Execute(); | |
| 1253 | |
| 1254 if (statement.IsDone()) | |
| 1255 { | |
| 1256 return false; | |
| 1257 } | |
| 1258 else | |
| 1259 { | |
| 1260 internalId = ReadInteger64(statement, 0); | |
| 1261 return true; | |
| 1262 } | |
| 1263 } | |
| 1264 | |
| 1265 | |
| 1266 bool IndexBackend::SelectPatientToRecycle(int64_t& internalId /*out*/, | |
| 1267 int64_t patientIdToAvoid) | |
| 1268 { | |
| 1269 DatabaseManager::CachedStatement statement( | |
| 1270 STATEMENT_FROM_HERE, manager_, | |
| 1271 "SELECT patientId FROM PatientRecyclingOrder " | |
| 1272 "WHERE patientId != ${id} ORDER BY seq ASC LIMIT 1"); | |
| 1273 | |
| 1274 statement.SetReadOnly(true); | |
| 1275 statement.SetParameterType("id", ValueType_Integer64); | |
| 1276 | |
| 1277 Dictionary args; | |
| 1278 args.SetIntegerValue("id", patientIdToAvoid); | |
| 1279 | |
| 1280 statement.Execute(args); | |
| 1281 | |
| 1282 if (statement.IsDone()) | |
| 1283 { | |
| 1284 return false; | |
| 1285 } | |
| 1286 else | |
| 1287 { | |
| 1288 internalId = ReadInteger64(statement, 0); | |
| 1289 return true; | |
| 1290 } | |
| 1291 } | |
| 1292 | |
| 1293 | |
|
221
73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
220
diff
changeset
|
1294 void IndexBackend::SetGlobalProperty(const char* serverIdentifier, |
|
73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
220
diff
changeset
|
1295 int32_t property, |
| 0 | 1296 const char* value) |
| 1297 { | |
|
221
73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
220
diff
changeset
|
1298 return ::OrthancDatabases::SetGlobalProperty( |
|
73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
220
diff
changeset
|
1299 manager_, serverIdentifier, static_cast<Orthanc::GlobalProperty>(property), value); |
| 0 | 1300 } |
| 1301 | |
| 1302 | |
| 1303 static void ExecuteSetTag(DatabaseManager::CachedStatement& statement, | |
| 1304 int64_t id, | |
| 1305 uint16_t group, | |
| 1306 uint16_t element, | |
| 1307 const char* value) | |
| 1308 { | |
| 1309 statement.SetParameterType("id", ValueType_Integer64); | |
| 1310 statement.SetParameterType("group", ValueType_Integer64); | |
| 1311 statement.SetParameterType("element", ValueType_Integer64); | |
| 1312 statement.SetParameterType("value", ValueType_Utf8String); | |
| 1313 | |
| 1314 Dictionary args; | |
| 1315 args.SetIntegerValue("id", id); | |
| 1316 args.SetIntegerValue("group", group); | |
| 1317 args.SetIntegerValue("element", element); | |
| 1318 args.SetUtf8Value("value", value); | |
| 1319 | |
| 1320 statement.Execute(args); | |
| 1321 } | |
| 1322 | |
| 1323 | |
| 1324 void IndexBackend::SetMainDicomTag(int64_t id, | |
| 1325 uint16_t group, | |
| 1326 uint16_t element, | |
| 1327 const char* value) | |
| 1328 { | |
| 1329 DatabaseManager::CachedStatement statement( | |
| 1330 STATEMENT_FROM_HERE, manager_, | |
| 1331 "INSERT INTO MainDicomTags VALUES(${id}, ${group}, ${element}, ${value})"); | |
| 1332 | |
| 1333 ExecuteSetTag(statement, id, group, element, value); | |
| 1334 } | |
| 1335 | |
| 1336 | |
| 1337 void IndexBackend::SetIdentifierTag(int64_t id, | |
| 1338 uint16_t group, | |
| 1339 uint16_t element, | |
| 1340 const char* value) | |
| 1341 { | |
| 1342 DatabaseManager::CachedStatement statement( | |
| 1343 STATEMENT_FROM_HERE, manager_, | |
| 1344 "INSERT INTO DicomIdentifiers VALUES(${id}, ${group}, ${element}, ${value})"); | |
| 1345 | |
| 1346 ExecuteSetTag(statement, id, group, element, value); | |
| 1347 } | |
| 1348 | |
| 1349 | |
| 1350 void IndexBackend::SetMetadata(int64_t id, | |
| 1351 int32_t metadataType, | |
| 1352 const char* value) | |
| 1353 { | |
|
1
d17b2631bb67
starting StorageBackend
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
1354 if (manager_.GetDialect() == Dialect_SQLite) |
| 0 | 1355 { |
| 1356 DatabaseManager::CachedStatement statement( | |
| 1357 STATEMENT_FROM_HERE, manager_, | |
| 1358 "INSERT OR REPLACE INTO Metadata VALUES (${id}, ${type}, ${value})"); | |
| 1359 | |
| 1360 statement.SetParameterType("id", ValueType_Integer64); | |
| 1361 statement.SetParameterType("type", ValueType_Integer64); | |
| 1362 statement.SetParameterType("value", ValueType_Utf8String); | |
| 1363 | |
| 1364 Dictionary args; | |
| 1365 args.SetIntegerValue("id", id); | |
| 1366 args.SetIntegerValue("type", metadataType); | |
| 1367 args.SetUtf8Value("value", value); | |
| 1368 | |
| 1369 statement.Execute(args); | |
| 1370 } | |
| 1371 else | |
| 1372 { | |
| 1373 { | |
| 1374 DatabaseManager::CachedStatement statement( | |
| 1375 STATEMENT_FROM_HERE, manager_, | |
| 1376 "DELETE FROM Metadata WHERE id=${id} AND type=${type}"); | |
| 1377 | |
| 1378 statement.SetParameterType("id", ValueType_Integer64); | |
| 1379 statement.SetParameterType("type", ValueType_Integer64); | |
| 1380 | |
| 1381 Dictionary args; | |
| 1382 args.SetIntegerValue("id", id); | |
| 1383 args.SetIntegerValue("type", metadataType); | |
| 1384 | |
| 1385 statement.Execute(args); | |
| 1386 } | |
| 1387 | |
| 1388 { | |
| 1389 DatabaseManager::CachedStatement statement( | |
| 1390 STATEMENT_FROM_HERE, manager_, | |
| 1391 "INSERT INTO Metadata VALUES (${id}, ${type}, ${value})"); | |
| 1392 | |
| 1393 statement.SetParameterType("id", ValueType_Integer64); | |
| 1394 statement.SetParameterType("type", ValueType_Integer64); | |
| 1395 statement.SetParameterType("value", ValueType_Utf8String); | |
| 1396 | |
| 1397 Dictionary args; | |
| 1398 args.SetIntegerValue("id", id); | |
| 1399 args.SetIntegerValue("type", metadataType); | |
| 1400 args.SetUtf8Value("value", value); | |
| 1401 | |
| 1402 statement.Execute(args); | |
| 1403 } | |
| 1404 } | |
| 1405 } | |
| 1406 | |
| 1407 | |
| 1408 void IndexBackend::SetProtectedPatient(int64_t internalId, | |
| 1409 bool isProtected) | |
| 1410 { | |
| 1411 if (isProtected) | |
| 1412 { | |
| 1413 DatabaseManager::CachedStatement statement( | |
| 1414 STATEMENT_FROM_HERE, manager_, | |
| 1415 "DELETE FROM PatientRecyclingOrder WHERE patientId=${id}"); | |
| 1416 | |
| 1417 statement.SetParameterType("id", ValueType_Integer64); | |
| 1418 | |
| 1419 Dictionary args; | |
| 1420 args.SetIntegerValue("id", internalId); | |
| 1421 | |
| 1422 statement.Execute(args); | |
| 1423 } | |
| 1424 else if (IsProtectedPatient(internalId)) | |
| 1425 { | |
| 1426 DatabaseManager::CachedStatement statement( | |
| 1427 STATEMENT_FROM_HERE, manager_, | |
| 1428 "INSERT INTO PatientRecyclingOrder VALUES(${}, ${id})"); | |
| 1429 | |
| 1430 statement.SetParameterType("id", ValueType_Integer64); | |
| 1431 | |
| 1432 Dictionary args; | |
| 1433 args.SetIntegerValue("id", internalId); | |
| 1434 | |
| 1435 statement.Execute(args); | |
| 1436 } | |
| 1437 else | |
| 1438 { | |
| 1439 // Nothing to do: The patient is already unprotected | |
| 1440 } | |
| 1441 } | |
| 1442 | |
| 1443 | |
| 1444 uint32_t IndexBackend::GetDatabaseVersion() | |
| 1445 { | |
|
220
492aa3edf572
use read-only, explicit transaction in IndexBackend::GetDatabaseVersion()
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
219
diff
changeset
|
1446 // Create a read-only, explicit transaction to read the database |
|
492aa3edf572
use read-only, explicit transaction in IndexBackend::GetDatabaseVersion()
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
219
diff
changeset
|
1447 // version (this was a read-write, implicit transaction in |
|
492aa3edf572
use read-only, explicit transaction in IndexBackend::GetDatabaseVersion()
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
219
diff
changeset
|
1448 // PostgreSQL plugin <= 3.3 and MySQL plugin <= 3.0) |
|
492aa3edf572
use read-only, explicit transaction in IndexBackend::GetDatabaseVersion()
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
219
diff
changeset
|
1449 DatabaseManager::Transaction transaction(GetManager(), TransactionType_ReadOnly); |
|
492aa3edf572
use read-only, explicit transaction in IndexBackend::GetDatabaseVersion()
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
219
diff
changeset
|
1450 |
| 0 | 1451 std::string version = "unknown"; |
| 1452 | |
|
221
73cc85f3d9c1
implementation of the "serverIdentifier" information for global properties
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
220
diff
changeset
|
1453 if (LookupGlobalProperty(version, MISSING_SERVER_IDENTIFIER, Orthanc::GlobalProperty_DatabaseSchemaVersion)) |
| 0 | 1454 { |
| 1455 try | |
| 1456 { | |
| 1457 return boost::lexical_cast<unsigned int>(version); | |
| 1458 } | |
| 1459 catch (boost::bad_lexical_cast&) | |
| 1460 { | |
| 1461 } | |
| 1462 } | |
| 1463 | |
| 1464 LOG(ERROR) << "The database is corrupted. Drop it manually for Orthanc to recreate it"; | |
| 1465 throw Orthanc::OrthancException(Orthanc::ErrorCode_Database); | |
| 1466 } | |
| 1467 | |
| 1468 | |
| 1469 /** | |
| 1470 * Upgrade the database to the specified version of the database | |
| 1471 * schema. The upgrade script is allowed to make calls to | |
| 1472 * OrthancPluginReconstructMainDicomTags(). | |
| 1473 **/ | |
| 1474 void IndexBackend::UpgradeDatabase(uint32_t targetVersion, | |
| 1475 OrthancPluginStorageArea* storageArea) | |
| 1476 { | |
| 1477 LOG(ERROR) << "Upgrading database is not implemented by this plugin"; | |
| 1478 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); | |
| 1479 } | |
| 1480 | |
| 1481 | |
| 1482 void IndexBackend::ClearMainDicomTags(int64_t internalId) | |
| 1483 { | |
| 1484 { | |
| 1485 DatabaseManager::CachedStatement statement( | |
| 1486 STATEMENT_FROM_HERE, manager_, | |
| 1487 "DELETE FROM MainDicomTags WHERE id=${id}"); | |
| 1488 | |
| 1489 statement.SetParameterType("id", ValueType_Integer64); | |
| 1490 | |
| 1491 Dictionary args; | |
| 1492 args.SetIntegerValue("id", internalId); | |
| 1493 | |
| 1494 statement.Execute(args); | |
| 1495 } | |
| 1496 | |
| 1497 { | |
| 1498 DatabaseManager::CachedStatement statement( | |
| 1499 STATEMENT_FROM_HERE, manager_, | |
| 1500 "DELETE FROM DicomIdentifiers WHERE id=${id}"); | |
| 1501 | |
| 1502 statement.SetParameterType("id", ValueType_Integer64); | |
| 1503 | |
| 1504 Dictionary args; | |
| 1505 args.SetIntegerValue("id", internalId); | |
| 1506 | |
| 1507 statement.Execute(args); | |
| 1508 } | |
| 1509 } | |
| 1510 | |
| 1511 | |
| 1512 // For unit testing only! | |
| 209 | 1513 uint64_t IndexBackend::GetAllResourcesCount() |
| 0 | 1514 { |
|
157
275e14f57f1e
replacing deprecated std::auto_ptr by std::unique_ptr
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
152
diff
changeset
|
1515 std::unique_ptr<DatabaseManager::CachedStatement> statement; |
| 0 | 1516 |
|
1
d17b2631bb67
starting StorageBackend
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
1517 switch (manager_.GetDialect()) |
| 0 | 1518 { |
| 1519 case Dialect_MySQL: | |
| 1520 statement.reset(new DatabaseManager::CachedStatement( | |
| 1521 STATEMENT_FROM_HERE, GetManager(), | |
| 1522 "SELECT CAST(COUNT(*) AS UNSIGNED INT) FROM Resources")); | |
| 1523 break; | |
| 1524 | |
| 1525 case Dialect_PostgreSQL: | |
| 1526 statement.reset(new DatabaseManager::CachedStatement( | |
| 1527 STATEMENT_FROM_HERE, GetManager(), | |
| 1528 "SELECT CAST(COUNT(*) AS BIGINT) FROM Resources")); | |
| 1529 break; | |
| 1530 | |
| 1531 case Dialect_SQLite: | |
| 1532 statement.reset(new DatabaseManager::CachedStatement( | |
| 1533 STATEMENT_FROM_HERE, GetManager(), | |
| 1534 "SELECT COUNT(*) FROM Resources")); | |
| 1535 break; | |
| 1536 | |
| 1537 default: | |
| 1538 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); | |
| 1539 } | |
| 1540 | |
| 1541 statement->SetReadOnly(true); | |
| 1542 statement->Execute(); | |
| 1543 | |
| 1544 return static_cast<uint64_t>(ReadInteger64(*statement, 0)); | |
| 1545 } | |
| 1546 | |
| 1547 | |
| 1548 // For unit testing only! | |
| 1549 uint64_t IndexBackend::GetUnprotectedPatientsCount() | |
| 1550 { | |
|
157
275e14f57f1e
replacing deprecated std::auto_ptr by std::unique_ptr
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
152
diff
changeset
|
1551 std::unique_ptr<DatabaseManager::CachedStatement> statement; |
| 0 | 1552 |
|
1
d17b2631bb67
starting StorageBackend
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
1553 switch (manager_.GetDialect()) |
| 0 | 1554 { |
| 1555 case Dialect_MySQL: | |
| 1556 statement.reset(new DatabaseManager::CachedStatement( | |
| 1557 STATEMENT_FROM_HERE, GetManager(), | |
| 1558 "SELECT CAST(COUNT(*) AS UNSIGNED INT) FROM PatientRecyclingOrder")); | |
| 1559 break; | |
| 1560 | |
| 1561 case Dialect_PostgreSQL: | |
| 1562 statement.reset(new DatabaseManager::CachedStatement( | |
| 1563 STATEMENT_FROM_HERE, GetManager(), | |
| 1564 "SELECT CAST(COUNT(*) AS BIGINT) FROM PatientRecyclingOrder")); | |
| 1565 break; | |
| 1566 | |
| 1567 case Dialect_SQLite: | |
| 1568 statement.reset(new DatabaseManager::CachedStatement( | |
| 1569 STATEMENT_FROM_HERE, GetManager(), | |
| 1570 "SELECT COUNT(*) FROM PatientRecyclingOrder")); | |
| 1571 break; | |
| 1572 | |
| 1573 default: | |
| 1574 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); | |
| 1575 } | |
| 1576 | |
| 1577 statement->SetReadOnly(true); | |
| 1578 statement->Execute(); | |
| 1579 | |
| 1580 return static_cast<uint64_t>(ReadInteger64(*statement, 0)); | |
| 1581 } | |
| 1582 | |
| 1583 | |
| 1584 // For unit testing only! | |
| 1585 bool IndexBackend::GetParentPublicId(std::string& target, | |
| 1586 int64_t id) | |
| 1587 { | |
| 1588 DatabaseManager::CachedStatement statement( | |
| 1589 STATEMENT_FROM_HERE, GetManager(), | |
| 1590 "SELECT a.publicId FROM Resources AS a, Resources AS b " | |
| 1591 "WHERE a.internalId = b.parentId AND b.internalId = ${id}"); | |
| 1592 | |
| 1593 statement.SetReadOnly(true); | |
| 1594 statement.SetParameterType("id", ValueType_Integer64); | |
| 1595 | |
| 1596 Dictionary args; | |
| 1597 args.SetIntegerValue("id", id); | |
| 1598 | |
| 1599 statement.Execute(args); | |
| 1600 | |
| 1601 if (statement.IsDone()) | |
| 1602 { | |
| 1603 return false; | |
| 1604 } | |
| 1605 else | |
| 1606 { | |
| 1607 target = ReadString(statement, 0); | |
| 1608 return true; | |
| 1609 } | |
| 1610 } | |
| 1611 | |
| 1612 | |
| 1613 // For unit tests only! | |
| 1614 void IndexBackend::GetChildren(std::list<std::string>& childrenPublicIds, | |
| 1615 int64_t id) | |
| 1616 { | |
| 1617 DatabaseManager::CachedStatement statement( | |
| 1618 STATEMENT_FROM_HERE, GetManager(), | |
| 1619 "SELECT publicId FROM Resources WHERE parentId=${id}"); | |
| 1620 | |
| 1621 statement.SetReadOnly(true); | |
| 1622 statement.SetParameterType("id", ValueType_Integer64); | |
| 1623 | |
| 1624 Dictionary args; | |
| 1625 args.SetIntegerValue("id", id); | |
| 1626 | |
| 1627 ReadListOfStrings(childrenPublicIds, statement, args); | |
| 1628 } | |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1629 |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1630 |
| 78 | 1631 #if ORTHANC_PLUGINS_HAS_DATABASE_CONSTRAINT == 1 |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1632 class IndexBackend::LookupFormatter : public Orthanc::ISqlLookupFormatter |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1633 { |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1634 private: |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1635 Dialect dialect_; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1636 size_t count_; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1637 Dictionary dictionary_; |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1638 |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1639 static std::string FormatParameter(size_t index) |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1640 { |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1641 return "p" + boost::lexical_cast<std::string>(index); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1642 } |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1643 |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1644 public: |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1645 LookupFormatter(Dialect dialect) : |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1646 dialect_(dialect), |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1647 count_(0) |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1648 { |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1649 } |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1650 |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1651 virtual std::string GenerateParameter(const std::string& value) |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1652 { |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1653 const std::string key = FormatParameter(count_); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1654 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1655 count_ ++; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1656 dictionary_.SetUtf8Value(key, value); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1657 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1658 return "${" + key + "}"; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1659 } |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1660 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1661 virtual std::string FormatResourceType(Orthanc::ResourceType level) |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1662 { |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1663 return boost::lexical_cast<std::string>(Orthanc::Plugins::Convert(level)); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1664 } |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1665 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1666 virtual std::string FormatWildcardEscape() |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1667 { |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1668 switch (dialect_) |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1669 { |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1670 case Dialect_SQLite: |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1671 case Dialect_PostgreSQL: |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1672 return "ESCAPE '\\'"; |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1673 |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1674 case Dialect_MySQL: |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1675 return "ESCAPE '\\\\'"; |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1676 |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1677 default: |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1678 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1679 } |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1680 } |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1681 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1682 void PrepareStatement(DatabaseManager::StandaloneStatement& statement) const |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1683 { |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1684 statement.SetReadOnly(true); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1685 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1686 for (size_t i = 0; i < count_; i++) |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1687 { |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1688 statement.SetParameterType(FormatParameter(i), ValueType_Utf8String); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1689 } |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1690 } |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1691 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1692 const Dictionary& GetDictionary() const |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1693 { |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1694 return dictionary_; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1695 } |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1696 }; |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1697 #endif |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1698 |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1699 |
| 78 | 1700 #if ORTHANC_PLUGINS_HAS_DATABASE_CONSTRAINT == 1 |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1701 // New primitive since Orthanc 1.5.2 |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
1702 void IndexBackend::LookupResources(IDatabaseBackendOutput& output, |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1703 const std::vector<Orthanc::DatabaseConstraint>& lookup, |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1704 OrthancPluginResourceType queryLevel, |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1705 uint32_t limit, |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1706 bool requestSomeInstance) |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1707 { |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1708 LookupFormatter formatter(manager_.GetDialect()); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1709 |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1710 std::string sql; |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1711 Orthanc::ISqlLookupFormatter::Apply(sql, formatter, lookup, |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1712 Orthanc::Plugins::Convert(queryLevel), limit); |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1713 |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1714 if (requestSomeInstance) |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1715 { |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1716 // Composite query to find some instance if requested |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1717 switch (queryLevel) |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1718 { |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1719 case OrthancPluginResourceType_Patient: |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1720 sql = ("SELECT patients.publicId, MIN(instances.publicId) FROM (" + sql + ") patients " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1721 "INNER JOIN Resources studies ON studies.parentId = patients.internalId " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1722 "INNER JOIN Resources series ON series.parentId = studies.internalId " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1723 "INNER JOIN Resources instances ON instances.parentId = series.internalId " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1724 "GROUP BY patients.publicId"); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1725 break; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1726 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1727 case OrthancPluginResourceType_Study: |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1728 sql = ("SELECT studies.publicId, MIN(instances.publicId) FROM (" + sql + ") studies " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1729 "INNER JOIN Resources series ON series.parentId = studies.internalId " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1730 "INNER JOIN Resources instances ON instances.parentId = series.internalId " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1731 "GROUP BY studies.publicId"); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1732 break; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1733 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1734 case OrthancPluginResourceType_Series: |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1735 sql = ("SELECT series.publicId, MIN(instances.publicId) FROM (" + sql + ") series " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1736 "INNER JOIN Resources instances ON instances.parentId = series.internalId " |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1737 "GROUP BY series.publicId"); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1738 break; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1739 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1740 case OrthancPluginResourceType_Instance: |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1741 sql = ("SELECT instances.publicId, instances.publicId FROM (" + sql + ") instances"); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1742 break; |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1743 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1744 default: |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1745 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1746 } |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1747 } |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1748 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1749 DatabaseManager::StandaloneStatement statement(GetManager(), sql); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1750 formatter.PrepareStatement(statement); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1751 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1752 statement.Execute(formatter.GetDictionary()); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1753 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1754 while (!statement.IsDone()) |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1755 { |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1756 if (requestSomeInstance) |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1757 { |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1758 output.AnswerMatchingResource(ReadString(statement, 0), ReadString(statement, 1)); |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1759 } |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1760 else |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1761 { |
|
201
42990b2dd51b
create IDatabaseBackendOutput only if needed
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
1762 output.AnswerMatchingResource(ReadString(statement, 0)); |
|
70
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1763 } |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1764 |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1765 statement.Next(); |
|
e6c13ddd26d9
all integration tests passing with LookupResources extension
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
69
diff
changeset
|
1766 } |
|
69
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1767 } |
|
19764fc60ade
compatibility with Orthanc SDDK 0.9.5
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
67
diff
changeset
|
1768 #endif |
|
75
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1769 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1770 |
| 78 | 1771 #if ORTHANC_PLUGINS_HAS_DATABASE_CONSTRAINT == 1 |
|
75
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1772 static void ExecuteSetResourcesContentTags( |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1773 DatabaseManager& manager, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1774 const std::string& table, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1775 const std::string& variablePrefix, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1776 uint32_t count, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1777 const OrthancPluginResourcesContentTags* tags) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1778 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1779 std::string sql; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1780 Dictionary args; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1781 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1782 for (uint32_t i = 0; i < count; i++) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1783 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1784 std::string name = variablePrefix + boost::lexical_cast<std::string>(i); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1785 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1786 args.SetUtf8Value(name, tags[i].value); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1787 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1788 std::string insert = ("(" + boost::lexical_cast<std::string>(tags[i].resource) + ", " + |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
1789 boost::lexical_cast<std::string>(tags[i].group) + ", " + |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
1790 boost::lexical_cast<std::string>(tags[i].element) + ", " + |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
1791 "${" + name + "})"); |
|
75
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1792 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1793 if (sql.empty()) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1794 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1795 sql = "INSERT INTO " + table + " VALUES " + insert; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1796 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1797 else |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1798 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1799 sql += ", " + insert; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1800 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1801 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1802 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1803 if (!sql.empty()) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1804 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1805 DatabaseManager::StandaloneStatement statement(manager, sql); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1806 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1807 for (uint32_t i = 0; i < count; i++) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1808 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1809 statement.SetParameterType(variablePrefix + boost::lexical_cast<std::string>(i), |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1810 ValueType_Utf8String); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1811 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1812 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1813 statement.Execute(args); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1814 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1815 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1816 #endif |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1817 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1818 |
| 78 | 1819 #if ORTHANC_PLUGINS_HAS_DATABASE_CONSTRAINT == 1 |
|
75
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1820 static void ExecuteSetResourcesContentMetadata( |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1821 DatabaseManager& manager, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1822 uint32_t count, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1823 const OrthancPluginResourcesContentMetadata* metadata) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1824 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1825 std::string sqlRemove; // To overwrite |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1826 std::string sqlInsert; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1827 Dictionary args; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1828 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1829 for (uint32_t i = 0; i < count; i++) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1830 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1831 std::string name = "m" + boost::lexical_cast<std::string>(i); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1832 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1833 args.SetUtf8Value(name, metadata[i].value); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1834 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1835 std::string insert = ("(" + boost::lexical_cast<std::string>(metadata[i].resource) + ", " + |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1836 boost::lexical_cast<std::string>(metadata[i].metadata) + ", " + |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
1837 "${" + name + "})"); |
|
75
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1838 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1839 std::string remove = ("(id=" + boost::lexical_cast<std::string>(metadata[i].resource) + |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1840 " AND type=" + boost::lexical_cast<std::string>(metadata[i].metadata) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1841 + ")"); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1842 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1843 if (sqlInsert.empty()) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1844 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1845 sqlInsert = "INSERT INTO Metadata VALUES " + insert; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1846 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1847 else |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1848 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1849 sqlInsert += ", " + insert; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1850 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1851 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1852 if (sqlRemove.empty()) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1853 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1854 sqlRemove = "DELETE FROM Metadata WHERE " + remove; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1855 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1856 else |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1857 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1858 sqlRemove += " OR " + remove; |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1859 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1860 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1861 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1862 if (!sqlRemove.empty()) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1863 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1864 DatabaseManager::StandaloneStatement statement(manager, sqlRemove); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1865 statement.Execute(); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1866 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1867 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1868 if (!sqlInsert.empty()) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1869 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1870 DatabaseManager::StandaloneStatement statement(manager, sqlInsert); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1871 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1872 for (uint32_t i = 0; i < count; i++) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1873 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1874 statement.SetParameterType("m" + boost::lexical_cast<std::string>(i), |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1875 ValueType_Utf8String); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1876 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1877 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1878 statement.Execute(args); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1879 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1880 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1881 #endif |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1882 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1883 |
| 78 | 1884 #if ORTHANC_PLUGINS_HAS_DATABASE_CONSTRAINT == 1 |
|
75
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1885 // New primitive since Orthanc 1.5.2 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1886 void IndexBackend::SetResourcesContent( |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1887 uint32_t countIdentifierTags, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1888 const OrthancPluginResourcesContentTags* identifierTags, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1889 uint32_t countMainDicomTags, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1890 const OrthancPluginResourcesContentTags* mainDicomTags, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1891 uint32_t countMetadata, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1892 const OrthancPluginResourcesContentMetadata* metadata) |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1893 { |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1894 /** |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1895 * TODO - PostgreSQL doesn't allow multiple commands in a prepared |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1896 * statement, so we execute 3 separate commands (for identifiers, |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1897 * main tags and metadata). Maybe MySQL does not suffer from the |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1898 * same limitation, to check. |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1899 **/ |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1900 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1901 ExecuteSetResourcesContentTags(GetManager(), "DicomIdentifiers", "i", |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1902 countIdentifierTags, identifierTags); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1903 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1904 ExecuteSetResourcesContentTags(GetManager(), "MainDicomTags", "t", |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1905 countMainDicomTags, mainDicomTags); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1906 |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1907 ExecuteSetResourcesContentMetadata(GetManager(), countMetadata, metadata); |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1908 } |
|
52c70007bb87
new extension implemented for PostgreSQL: SetResourcesContent
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
74
diff
changeset
|
1909 #endif |
|
76
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1910 |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1911 |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1912 // New primitive since Orthanc 1.5.2 |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1913 void IndexBackend::GetChildrenMetadata(std::list<std::string>& target, |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1914 int64_t resourceId, |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1915 int32_t metadata) |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1916 { |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1917 DatabaseManager::CachedStatement statement( |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1918 STATEMENT_FROM_HERE, manager_, |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1919 "SELECT value FROM Metadata WHERE type=${metadata} AND " |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1920 "id IN (SELECT internalId FROM Resources WHERE parentId=${id})"); |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1921 |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1922 statement.SetReadOnly(true); |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1923 statement.SetParameterType("id", ValueType_Integer64); |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1924 statement.SetParameterType("metadata", ValueType_Integer64); |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1925 |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1926 Dictionary args; |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1927 args.SetIntegerValue("id", static_cast<int>(resourceId)); |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1928 args.SetIntegerValue("metadata", static_cast<int>(metadata)); |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1929 |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1930 ReadListOfStrings(target, statement, args); |
|
a1c6238b26f8
new extension implemented for PostgreSQL: GetChildrenMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
75
diff
changeset
|
1931 } |
|
88
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1932 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1933 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1934 // New primitive since Orthanc 1.5.2 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1935 void IndexBackend::TagMostRecentPatient(int64_t patient) |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1936 { |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1937 int64_t seq; |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1938 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1939 { |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1940 DatabaseManager::CachedStatement statement( |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1941 STATEMENT_FROM_HERE, manager_, |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1942 "SELECT * FROM PatientRecyclingOrder WHERE seq >= " |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1943 "(SELECT seq FROM PatientRecyclingOrder WHERE patientid=${id}) ORDER BY seq LIMIT 2"); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1944 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1945 statement.SetReadOnly(true); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1946 statement.SetParameterType("id", ValueType_Integer64); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1947 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1948 Dictionary args; |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1949 args.SetIntegerValue("id", patient); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1950 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1951 statement.Execute(args); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1952 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1953 if (statement.IsDone()) |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1954 { |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1955 // The patient is protected, don't add it to the recycling order |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1956 return; |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1957 } |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1958 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1959 seq = ReadInteger64(statement, 0); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1960 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1961 statement.Next(); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1962 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1963 if (statement.IsDone()) |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1964 { |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1965 // The patient is already at the end of the recycling order |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1966 // (because of the "LIMIT 2" above), no need to modify the table |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1967 return; |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1968 } |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1969 } |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1970 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1971 // Delete the old position of the patient in the recycling order |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1972 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1973 { |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1974 DatabaseManager::CachedStatement statement( |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1975 STATEMENT_FROM_HERE, manager_, |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1976 "DELETE FROM PatientRecyclingOrder WHERE seq=${seq}"); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1977 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1978 statement.SetParameterType("seq", ValueType_Integer64); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1979 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1980 Dictionary args; |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1981 args.SetIntegerValue("seq", seq); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1982 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1983 statement.Execute(args); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1984 } |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1985 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1986 // Add the patient to the end of the recycling order |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1987 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1988 { |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1989 DatabaseManager::CachedStatement statement( |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1990 STATEMENT_FROM_HERE, manager_, |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1991 "INSERT INTO PatientRecyclingOrder VALUES(${}, ${id})"); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1992 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1993 statement.SetParameterType("id", ValueType_Integer64); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1994 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1995 Dictionary args; |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1996 args.SetIntegerValue("id", patient); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1997 |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1998 statement.Execute(args); |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
1999 } |
|
eb08ec14fb04
new extension implemented: TagMostRecentPatient
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
85
diff
changeset
|
2000 } |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2001 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2002 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2003 #if defined(ORTHANC_PLUGINS_VERSION_IS_ABOVE) // Macro introduced in 1.3.1 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2004 # if ORTHANC_PLUGINS_VERSION_IS_ABOVE(1, 5, 4) |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2005 // New primitive since Orthanc 1.5.4 |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2006 bool IndexBackend::LookupResourceAndParent(int64_t& id, |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2007 OrthancPluginResourceType& type, |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2008 std::string& parentPublicId, |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2009 const char* publicId) |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2010 { |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2011 DatabaseManager::CachedStatement statement( |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2012 STATEMENT_FROM_HERE, manager_, |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2013 "SELECT resource.internalId, resource.resourceType, parent.publicId " |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2014 "FROM Resources AS resource LEFT JOIN Resources parent ON parent.internalId=resource.parentId " |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2015 "WHERE resource.publicId=${id}"); |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2016 |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2017 statement.SetParameterType("id", ValueType_Utf8String); |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2018 |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2019 Dictionary args; |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2020 args.SetUtf8Value("id", publicId); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2021 |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2022 statement.Execute(args); |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2023 |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2024 if (statement.IsDone()) |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2025 { |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2026 return false; |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2027 } |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2028 else |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2029 { |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2030 if (statement.GetResultFieldsCount() != 3) |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2031 { |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2032 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2033 } |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2034 |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2035 statement.SetResultFieldType(0, ValueType_Integer64); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2036 statement.SetResultFieldType(1, ValueType_Integer64); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2037 statement.SetResultFieldType(2, ValueType_Utf8String); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2038 |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2039 id = ReadInteger64(statement, 0); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2040 type = static_cast<OrthancPluginResourceType>(ReadInteger32(statement, 1)); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2041 |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2042 const IValue& value = statement.GetResultField(2); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2043 |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2044 switch (value.GetType()) |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2045 { |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2046 case ValueType_Null: |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2047 parentPublicId.clear(); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2048 break; |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2049 |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2050 case ValueType_Utf8String: |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2051 parentPublicId = dynamic_cast<const Utf8StringValue&>(value).GetContent(); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2052 break; |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2053 |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2054 default: |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2055 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2056 } |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2057 |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2058 assert((statement.Next(), statement.IsDone())); |
|
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2059 return true; |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2060 } |
|
203
2089d4071408
moving classes out of OrthancPlugins namespace, to OrthancDatabases
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
201
diff
changeset
|
2061 } |
|
117
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2062 # endif |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2063 #endif |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2064 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2065 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2066 #if defined(ORTHANC_PLUGINS_VERSION_IS_ABOVE) // Macro introduced in 1.3.1 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2067 # if ORTHANC_PLUGINS_VERSION_IS_ABOVE(1, 5, 4) |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2068 // New primitive since Orthanc 1.5.4 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2069 void IndexBackend::GetAllMetadata(std::map<int32_t, std::string>& result, |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2070 int64_t id) |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2071 { |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2072 DatabaseManager::CachedStatement statement( |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2073 STATEMENT_FROM_HERE, manager_, |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2074 "SELECT type, value FROM Metadata WHERE id=${id}"); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2075 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2076 statement.SetReadOnly(true); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2077 statement.SetParameterType("id", ValueType_Integer64); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2078 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2079 Dictionary args; |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2080 args.SetIntegerValue("id", id); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2081 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2082 statement.Execute(args); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2083 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2084 result.clear(); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2085 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2086 if (!statement.IsDone()) |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2087 { |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2088 if (statement.GetResultFieldsCount() != 2) |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2089 { |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2090 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2091 } |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2092 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2093 statement.SetResultFieldType(0, ValueType_Integer64); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2094 statement.SetResultFieldType(1, ValueType_Utf8String); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2095 |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2096 while (!statement.IsDone()) |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2097 { |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2098 result[ReadInteger32(statement, 0)] = ReadString(statement, 1); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2099 statement.Next(); |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2100 } |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2101 } |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2102 } |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2103 # endif |
|
ca0ecd412988
Implementation of new extensions: LookupResourceAndParent and GetAllMetadata
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
88
diff
changeset
|
2104 #endif |
|
210
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2105 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2106 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2107 void IndexBackend::CreateInstanceGeneric(OrthancPluginCreateInstanceResult& result, |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2108 const char* hashPatient, |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2109 const char* hashStudy, |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2110 const char* hashSeries, |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2111 const char* hashInstance) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2112 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2113 // Check out "OrthancServer/Sources/Database/Compatibility/ICreateInstance.cpp" |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2114 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2115 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2116 OrthancPluginResourceType type; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2117 int64_t tmp; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2118 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2119 if (LookupResource(tmp, type, hashInstance)) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2120 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2121 // The instance already exists |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2122 assert(type == OrthancPluginResourceType_Instance); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2123 result.instanceId = tmp; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2124 result.isNewInstance = false; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2125 return; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2126 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2127 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2128 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2129 result.instanceId = CreateResource(hashInstance, OrthancPluginResourceType_Instance); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2130 result.isNewInstance = true; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2131 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2132 result.isNewPatient = false; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2133 result.isNewStudy = false; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2134 result.isNewSeries = false; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2135 result.patientId = -1; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2136 result.studyId = -1; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2137 result.seriesId = -1; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2138 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2139 // Detect up to which level the patient/study/series/instance |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2140 // hierarchy must be created |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2141 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2142 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2143 OrthancPluginResourceType dummy; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2144 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2145 if (LookupResource(result.seriesId, dummy, hashSeries)) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2146 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2147 assert(dummy == OrthancPluginResourceType_Series); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2148 // The patient, the study and the series already exist |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2149 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2150 bool ok = (LookupResource(result.patientId, dummy, hashPatient) && |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2151 LookupResource(result.studyId, dummy, hashStudy)); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2152 (void) ok; // Remove warning about unused variable in release builds |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2153 assert(ok); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2154 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2155 else if (LookupResource(result.studyId, dummy, hashStudy)) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2156 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2157 assert(dummy == OrthancPluginResourceType_Study); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2158 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2159 // New series: The patient and the study already exist |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2160 result.isNewSeries = true; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2161 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2162 bool ok = LookupResource(result.patientId, dummy, hashPatient); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2163 (void) ok; // Remove warning about unused variable in release builds |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2164 assert(ok); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2165 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2166 else if (LookupResource(result.patientId, dummy, hashPatient)) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2167 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2168 assert(dummy == OrthancPluginResourceType_Patient); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2169 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2170 // New study and series: The patient already exist |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2171 result.isNewStudy = true; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2172 result.isNewSeries = true; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2173 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2174 else |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2175 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2176 // New patient, study and series: Nothing exists |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2177 result.isNewPatient = true; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2178 result.isNewStudy = true; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2179 result.isNewSeries = true; |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2180 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2181 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2182 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2183 // Create the series if needed |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2184 if (result.isNewSeries) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2185 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2186 result.seriesId = CreateResource(hashSeries, OrthancPluginResourceType_Series); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2187 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2188 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2189 // Create the study if needed |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2190 if (result.isNewStudy) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2191 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2192 result.studyId = CreateResource(hashStudy, OrthancPluginResourceType_Study); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2193 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2194 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2195 // Create the patient if needed |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2196 if (result.isNewPatient) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2197 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2198 result.patientId = CreateResource(hashPatient, OrthancPluginResourceType_Patient); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2199 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2200 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2201 // Create the parent-to-child links |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2202 AttachChild(result.seriesId, result.instanceId); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2203 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2204 if (result.isNewSeries) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2205 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2206 AttachChild(result.studyId, result.seriesId); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2207 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2208 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2209 if (result.isNewStudy) |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2210 { |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2211 AttachChild(result.patientId, result.studyId); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2212 } |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2213 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2214 TagMostRecentPatient(result.patientId); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2215 |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2216 // Sanity checks |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2217 assert(result.patientId != -1); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2218 assert(result.studyId != -1); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2219 assert(result.seriesId != -1); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2220 assert(result.instanceId != -1); |
|
a0c095a4ba7d
all the integration tests pass on SQLite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
209
diff
changeset
|
2221 } |
|
213
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2222 |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2223 |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2224 void IndexBackend::Register(IndexBackend& backend) |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2225 { |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2226 bool hasLoadedV3 = false; |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2227 |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2228 #if defined(ORTHANC_PLUGINS_VERSION_IS_ABOVE) // Macro introduced in Orthanc 1.3.1 |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2229 # if ORTHANC_PLUGINS_VERSION_IS_ABOVE(1, 9, 2) |
|
219
dd6cfc250747
removed useless class StorageAreaBuffer
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
213
diff
changeset
|
2230 if (OrthancPluginCheckVersionAdvanced(backend.GetContext(), 1, 9, 2) == 1) |
|
213
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2231 { |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2232 OrthancDatabases::DatabaseBackendAdapterV3::Register(backend); |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2233 hasLoadedV3 = true; |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2234 } |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2235 # endif |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2236 #endif |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2237 |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2238 if (!hasLoadedV3) |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2239 { |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2240 LOG(WARNING) << "Performance warning: Your version of Orthanc doesn't support multiple readers/writers"; |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2241 OrthancDatabases::DatabaseBackendAdapterV2::Register(backend); |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2242 } |
|
c2e4a909de0e
added IndexBackend::Register() to be used in all the index plugins
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
210
diff
changeset
|
2243 } |
| 0 | 2244 } |