Mercurial > hg > orthanc-webviewer
annotate Plugin/Cache/CacheManager.cpp @ 146:3cde3e806abe
sync
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Wed, 09 Nov 2016 12:20:01 +0100 |
parents | 3809121c3290 |
children | 70d1fe6d6309 |
rev | line source |
---|---|
0 | 1 /** |
2 * Orthanc - A Lightweight, RESTful DICOM Store | |
122 | 3 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics |
0 | 4 * Department, University Hospital of Liege, Belgium |
5 * | |
6 * This program is free software: you can redistribute it and/or | |
7 * modify it under the terms of the GNU Affero General Public License | |
8 * as published by the Free Software Foundation, either version 3 of | |
9 * the License, or (at your option) any later version. | |
10 * | |
11 * This program is distributed in the hope that it will be useful, but | |
12 * WITHOUT ANY WARRANTY; without even the implied warranty of | |
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
14 * Affero General Public License for more details. | |
15 * | |
16 * You should have received a copy of the GNU Affero General Public License | |
17 * along with this program. If not, see <http://www.gnu.org/licenses/>. | |
18 **/ | |
19 | |
20 | |
21 #include "CacheManager.h" | |
22 | |
26 | 23 #include "../../Orthanc/Core/Uuid.h" |
24 #include "../../Orthanc/Core/SQLite/Transaction.h" | |
0 | 25 |
26 #include <boost/lexical_cast.hpp> | |
27 | |
28 | |
29 namespace OrthancPlugins | |
30 { | |
31 class CacheManager::Bundle | |
32 { | |
33 private: | |
34 uint32_t count_; | |
35 uint64_t space_; | |
36 | |
37 public: | |
38 Bundle() : count_(0), space_(0) | |
39 { | |
40 } | |
41 | |
42 Bundle(uint32_t count, | |
43 uint64_t space) : | |
44 count_(count), space_(space) | |
45 { | |
46 } | |
47 | |
48 uint32_t GetCount() const | |
49 { | |
50 return count_; | |
51 } | |
52 | |
53 uint64_t GetSpace() const | |
54 { | |
55 return space_; | |
56 } | |
57 | |
58 void Remove(uint64_t fileSize) | |
59 { | |
60 if (count_ == 0 || | |
61 space_ < fileSize) | |
62 { | |
63 throw std::runtime_error("Internal error"); | |
64 } | |
65 | |
66 count_ -= 1; | |
67 space_ -= fileSize; | |
68 } | |
69 | |
70 void Add(uint64_t fileSize) | |
71 { | |
72 count_ += 1; | |
73 space_ += fileSize; | |
74 } | |
75 }; | |
76 | |
77 | |
78 class CacheManager::BundleQuota | |
79 { | |
80 private: | |
81 uint32_t maxCount_; | |
82 uint64_t maxSpace_; | |
83 | |
84 public: | |
85 BundleQuota(uint32_t maxCount, | |
86 uint64_t maxSpace) : | |
87 maxCount_(maxCount), maxSpace_(maxSpace) | |
88 { | |
89 } | |
90 | |
91 BundleQuota() | |
92 { | |
93 // Default quota | |
94 maxCount_ = 0; // No limit on the number of files | |
95 maxSpace_ = 100 * 1024 * 1024; // Max 100MB per bundle | |
96 } | |
97 | |
98 uint32_t GetMaxCount() const | |
99 { | |
100 return maxCount_; | |
101 } | |
102 | |
103 uint64_t GetMaxSpace() const | |
104 { | |
105 return maxSpace_; | |
106 } | |
107 | |
108 bool IsSatisfied(const Bundle& bundle) const | |
109 { | |
110 if (maxCount_ != 0 && | |
111 bundle.GetCount() > maxCount_) | |
112 { | |
113 return false; | |
114 } | |
115 | |
116 if (maxSpace_ != 0 && | |
117 bundle.GetSpace() > maxSpace_) | |
118 { | |
119 return false; | |
120 } | |
121 | |
122 return true; | |
123 } | |
124 }; | |
125 | |
126 | |
127 struct CacheManager::PImpl | |
128 { | |
129 Orthanc::SQLite::Connection& db_; | |
130 Orthanc::FilesystemStorage& storage_; | |
131 | |
132 bool sanityCheck_; | |
133 Bundles bundles_; | |
134 BundleQuota defaultQuota_; | |
135 BundleQuotas quotas_; | |
136 | |
137 PImpl(Orthanc::SQLite::Connection& db, | |
138 Orthanc::FilesystemStorage& storage) : | |
139 db_(db), | |
140 storage_(storage), | |
141 sanityCheck_(false) | |
142 { | |
143 } | |
144 }; | |
145 | |
146 | |
147 const CacheManager::BundleQuota& CacheManager::GetBundleQuota(int bundleIndex) const | |
148 { | |
149 BundleQuotas::const_iterator found = pimpl_->quotas_.find(bundleIndex); | |
150 | |
151 if (found == pimpl_->quotas_.end()) | |
152 { | |
153 return pimpl_->defaultQuota_; | |
154 } | |
155 else | |
156 { | |
157 return found->second; | |
158 } | |
159 } | |
160 | |
161 | |
162 CacheManager::Bundle CacheManager::GetBundle(int bundleIndex) const | |
163 { | |
164 Bundles::const_iterator it = pimpl_->bundles_.find(bundleIndex); | |
165 | |
166 if (it == pimpl_->bundles_.end()) | |
167 { | |
168 return Bundle(); | |
169 } | |
170 else | |
171 { | |
172 return it->second; | |
173 } | |
174 } | |
175 | |
176 | |
177 void CacheManager::MakeRoom(Bundle& bundle, | |
178 std::list<std::string>& toRemove, | |
179 int bundleIndex, | |
180 const BundleQuota& quota) | |
181 { | |
182 using namespace Orthanc; | |
183 | |
184 toRemove.clear(); | |
185 | |
186 // Make room in the bundle | |
187 while (!quota.IsSatisfied(bundle)) | |
188 { | |
189 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT seq, fileUuid, fileSize FROM Cache WHERE bundle=? ORDER BY seq"); | |
190 s.BindInt(0, bundleIndex); | |
191 | |
192 if (s.Step()) | |
193 { | |
194 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE seq=?"); | |
195 t.BindInt64(0, s.ColumnInt64(0)); | |
196 t.Run(); | |
197 | |
198 toRemove.push_back(s.ColumnString(1)); | |
199 bundle.Remove(s.ColumnInt64(2)); | |
200 } | |
201 else | |
202 { | |
203 // Should never happen | |
204 throw std::runtime_error("Internal error"); | |
205 } | |
206 } | |
207 } | |
208 | |
209 | |
210 | |
211 void CacheManager::EnsureQuota(int bundleIndex, | |
212 const BundleQuota& quota) | |
213 { | |
214 using namespace Orthanc; | |
215 | |
216 // Remove the cached files that exceed the quota | |
217 std::auto_ptr<SQLite::Transaction> transaction(new SQLite::Transaction(pimpl_->db_)); | |
218 transaction->Begin(); | |
219 | |
220 Bundle bundle = GetBundle(bundleIndex); | |
221 | |
222 std::list<std::string> toRemove; | |
223 MakeRoom(bundle, toRemove, bundleIndex, quota); | |
224 | |
225 transaction->Commit(); | |
226 for (std::list<std::string>::const_iterator | |
227 it = toRemove.begin(); it != toRemove.end(); it++) | |
228 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
229 pimpl_->storage_.Remove(*it, Orthanc::FileContentType_Unknown); |
0 | 230 } |
231 | |
232 pimpl_->bundles_[bundleIndex] = bundle; | |
233 } | |
234 | |
235 | |
236 | |
237 void CacheManager::ReadBundleStatistics() | |
238 { | |
239 using namespace Orthanc; | |
240 | |
241 pimpl_->bundles_.clear(); | |
242 | |
243 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT bundle,COUNT(*),SUM(fileSize) FROM Cache GROUP BY bundle"); | |
244 while (s.Step()) | |
245 { | |
246 int index = s.ColumnInt(0); | |
247 Bundle bundle(static_cast<uint32_t>(s.ColumnInt(1)), | |
248 static_cast<uint64_t>(s.ColumnInt64(2))); | |
249 pimpl_->bundles_[index] = bundle; | |
250 } | |
251 } | |
252 | |
253 | |
254 | |
255 void CacheManager::SanityCheck() | |
256 { | |
257 if (!pimpl_->sanityCheck_) | |
258 { | |
259 return; | |
260 } | |
261 | |
262 using namespace Orthanc; | |
263 | |
264 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT bundle,COUNT(*),SUM(fileSize) FROM Cache GROUP BY bundle"); | |
265 while (s.Step()) | |
266 { | |
267 const Bundle& bundle = GetBundle(s.ColumnInt(0)); | |
268 if (bundle.GetCount() != static_cast<uint32_t>(s.ColumnInt(1)) || | |
269 bundle.GetSpace() != static_cast<uint64_t>(s.ColumnInt64(2))) | |
270 { | |
271 throw std::runtime_error("SANITY ERROR in cache: " + boost::lexical_cast<std::string>(bundle.GetCount()) | |
272 + "/" + boost::lexical_cast<std::string>(bundle.GetSpace()) | |
273 + " vs " + boost::lexical_cast<std::string>(s.ColumnInt(1)) + "/" | |
274 + boost::lexical_cast<std::string>(s.ColumnInt64(2))); | |
275 } | |
276 } | |
277 } | |
278 | |
279 | |
280 | |
281 CacheManager::CacheManager(Orthanc::SQLite::Connection& db, | |
282 Orthanc::FilesystemStorage& storage) : | |
283 pimpl_(new PImpl(db, storage)) | |
284 { | |
285 Open(); | |
286 ReadBundleStatistics(); | |
287 } | |
288 | |
289 | |
290 void CacheManager::SetSanityCheckEnabled(bool enabled) | |
291 { | |
292 pimpl_->sanityCheck_ = enabled; | |
293 } | |
294 | |
295 | |
296 void CacheManager::Open() | |
297 { | |
298 if (!pimpl_->db_.DoesTableExist("Cache")) | |
299 { | |
300 pimpl_->db_.Execute("CREATE TABLE Cache(seq INTEGER PRIMARY KEY, bundle INTEGER, item TEXT, fileUuid TEXT, fileSize INT);"); | |
301 pimpl_->db_.Execute("CREATE INDEX CacheBundles ON Cache(bundle);"); | |
302 pimpl_->db_.Execute("CREATE INDEX CacheIndex ON Cache(bundle, item);"); | |
303 } | |
304 | |
115
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
305 if (!pimpl_->db_.DoesTableExist("CacheProperties")) |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
306 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
307 pimpl_->db_.Execute("CREATE TABLE CacheProperties(property INTEGER PRIMARY KEY, value TEXT);"); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
308 } |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
309 |
0 | 310 // Performance tuning of SQLite with PRAGMAs |
311 // http://www.sqlite.org/pragma.html | |
312 pimpl_->db_.Execute("PRAGMA SYNCHRONOUS=OFF;"); | |
313 pimpl_->db_.Execute("PRAGMA JOURNAL_MODE=WAL;"); | |
314 pimpl_->db_.Execute("PRAGMA LOCKING_MODE=EXCLUSIVE;"); | |
315 } | |
316 | |
317 | |
318 void CacheManager::Store(int bundleIndex, | |
319 const std::string& item, | |
320 const std::string& content) | |
321 { | |
322 SanityCheck(); | |
323 | |
324 const BundleQuota quota = GetBundleQuota(bundleIndex); | |
325 | |
326 if (quota.GetMaxSpace() > 0 && | |
327 content.size() > quota.GetMaxSpace()) | |
328 { | |
329 // Cannot store such a large instance into the cache, forget about it | |
330 return; | |
331 } | |
332 | |
333 using namespace Orthanc; | |
334 | |
335 std::auto_ptr<SQLite::Transaction> transaction(new SQLite::Transaction(pimpl_->db_)); | |
336 transaction->Begin(); | |
337 | |
338 Bundle bundle = GetBundle(bundleIndex); | |
339 | |
340 std::list<std::string> toRemove; | |
341 bundle.Add(content.size()); | |
342 MakeRoom(bundle, toRemove, bundleIndex, quota); | |
343 | |
344 // Store the cached content on the disk | |
345 const char* data = content.size() ? &content[0] : NULL; | |
346 std::string uuid = Toolbox::GenerateUuid(); | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
347 pimpl_->storage_.Create(uuid, data, content.size(), Orthanc::FileContentType_Unknown); |
0 | 348 |
349 bool ok = true; | |
350 | |
351 // Remove the previous cached value. This might happen if the same | |
352 // item is accessed very quickly twice: Another factory could have | |
353 // been cached a value before the check for existence in Access(). | |
354 { | |
355 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT seq, fileUuid, fileSize FROM Cache WHERE bundle=? AND item=?"); | |
356 s.BindInt(0, bundleIndex); | |
357 s.BindString(1, item); | |
358 if (s.Step()) | |
359 { | |
360 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE seq=?"); | |
361 t.BindInt64(0, s.ColumnInt64(0)); | |
362 t.Run(); | |
363 | |
364 toRemove.push_back(s.ColumnString(1)); | |
365 bundle.Remove(s.ColumnInt64(2)); | |
366 } | |
367 } | |
368 | |
369 if (ok) | |
370 { | |
371 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "INSERT INTO Cache VALUES(NULL, ?, ?, ?, ?)"); | |
372 s.BindInt(0, bundleIndex); | |
373 s.BindString(1, item); | |
374 s.BindString(2, uuid); | |
375 s.BindInt64(3, content.size()); | |
376 | |
377 if (!s.Run()) | |
378 { | |
379 ok = false; | |
380 } | |
381 } | |
382 | |
383 if (!ok) | |
384 { | |
385 // Error: Remove the stored file | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
386 pimpl_->storage_.Remove(uuid, Orthanc::FileContentType_Unknown); |
0 | 387 } |
388 else | |
389 { | |
390 transaction->Commit(); | |
391 | |
392 pimpl_->bundles_[bundleIndex] = bundle; | |
393 | |
394 for (std::list<std::string>::const_iterator | |
395 it = toRemove.begin(); it != toRemove.end(); it++) | |
396 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
397 pimpl_->storage_.Remove(*it, Orthanc::FileContentType_Unknown); |
0 | 398 } |
399 } | |
400 | |
401 SanityCheck(); | |
402 } | |
403 | |
404 | |
405 | |
406 bool CacheManager::LocateInCache(std::string& uuid, | |
407 uint64_t& size, | |
408 int bundle, | |
409 const std::string& item) | |
410 { | |
411 using namespace Orthanc; | |
412 SanityCheck(); | |
413 | |
414 std::auto_ptr<SQLite::Transaction> transaction(new SQLite::Transaction(pimpl_->db_)); | |
415 transaction->Begin(); | |
416 | |
417 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT seq, fileUuid, fileSize FROM Cache WHERE bundle=? AND item=?"); | |
418 s.BindInt(0, bundle); | |
419 s.BindString(1, item); | |
420 if (!s.Step()) | |
421 { | |
422 return false; | |
423 } | |
424 | |
425 int64_t seq = s.ColumnInt64(0); | |
426 uuid = s.ColumnString(1); | |
427 size = s.ColumnInt64(2); | |
428 | |
429 // Touch the cache to fulfill the LRU scheme. | |
430 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE seq=?"); | |
431 t.BindInt64(0, seq); | |
432 if (t.Run()) | |
433 { | |
434 SQLite::Statement u(pimpl_->db_, SQLITE_FROM_HERE, "INSERT INTO Cache VALUES(NULL, ?, ?, ?, ?)"); | |
435 u.BindInt(0, bundle); | |
436 u.BindString(1, item); | |
437 u.BindString(2, uuid); | |
438 u.BindInt64(3, size); | |
439 if (u.Run()) | |
440 { | |
441 // Everything was OK. Commit the changes to the cache. | |
442 transaction->Commit(); | |
443 return true; | |
444 } | |
445 } | |
446 | |
447 return false; | |
448 } | |
449 | |
450 | |
451 bool CacheManager::IsCached(int bundle, | |
452 const std::string& item) | |
453 { | |
454 std::string uuid; | |
455 uint64_t size; | |
456 return LocateInCache(uuid, size, bundle, item); | |
457 } | |
458 | |
459 | |
460 bool CacheManager::Access(std::string& content, | |
461 int bundle, | |
462 const std::string& item) | |
463 { | |
464 std::string uuid; | |
465 uint64_t size; | |
466 if (!LocateInCache(uuid, size, bundle, item)) | |
467 { | |
468 return false; | |
469 } | |
470 | |
471 bool ok; | |
472 try | |
473 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
474 pimpl_->storage_.Read(content, uuid, Orthanc::FileContentType_Unknown); |
0 | 475 ok = (content.size() == size); |
476 } | |
477 catch (std::runtime_error&) | |
478 { | |
479 ok = false; | |
480 } | |
481 | |
482 if (ok) | |
483 { | |
484 return true; | |
485 } | |
486 else | |
487 { | |
488 throw std::runtime_error("Error in the filesystem"); | |
489 } | |
490 } | |
491 | |
492 | |
493 void CacheManager::Invalidate(int bundleIndex, | |
494 const std::string& item) | |
495 { | |
496 using namespace Orthanc; | |
497 SanityCheck(); | |
498 | |
499 std::auto_ptr<SQLite::Transaction> transaction(new SQLite::Transaction(pimpl_->db_)); | |
500 transaction->Begin(); | |
501 | |
502 Bundle bundle = GetBundle(bundleIndex); | |
503 | |
504 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT seq, fileUuid, fileSize FROM Cache WHERE bundle=? AND item=?"); | |
505 s.BindInt(0, bundleIndex); | |
506 s.BindString(1, item); | |
507 if (s.Step()) | |
508 { | |
509 int64_t seq = s.ColumnInt64(0); | |
510 const std::string uuid = s.ColumnString(1); | |
511 uint64_t expectedSize = s.ColumnInt64(2); | |
512 bundle.Remove(expectedSize); | |
513 | |
514 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE seq=?"); | |
515 t.BindInt64(0, seq); | |
516 if (t.Run()) | |
517 { | |
518 transaction->Commit(); | |
519 pimpl_->bundles_[bundleIndex] = bundle; | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
520 pimpl_->storage_.Remove(uuid, Orthanc::FileContentType_Unknown); |
0 | 521 } |
522 } | |
523 } | |
524 | |
525 | |
526 | |
527 void CacheManager::SetBundleQuota(int bundle, | |
528 uint32_t maxCount, | |
529 uint64_t maxSpace) | |
530 { | |
531 SanityCheck(); | |
532 | |
533 const BundleQuota quota(maxCount, maxSpace); | |
534 EnsureQuota(bundle, quota); | |
535 pimpl_->quotas_[bundle] = quota; | |
536 | |
537 SanityCheck(); | |
538 } | |
539 | |
540 void CacheManager::SetDefaultQuota(uint32_t maxCount, | |
541 uint64_t maxSpace) | |
542 { | |
543 using namespace Orthanc; | |
544 SanityCheck(); | |
545 | |
546 pimpl_->defaultQuota_ = BundleQuota(maxCount, maxSpace); | |
547 | |
548 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT DISTINCT bundle FROM Cache"); | |
549 while (s.Step()) | |
550 { | |
551 EnsureQuota(s.ColumnInt(0), pimpl_->defaultQuota_); | |
552 } | |
553 | |
554 SanityCheck(); | |
555 } | |
556 | |
557 | |
558 void CacheManager::Clear() | |
559 { | |
560 using namespace Orthanc; | |
561 SanityCheck(); | |
562 | |
563 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT fileUuid FROM Cache"); | |
564 while (s.Step()) | |
565 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
566 pimpl_->storage_.Remove(s.ColumnString(0), Orthanc::FileContentType_Unknown); |
0 | 567 } |
568 | |
569 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache"); | |
570 t.Run(); | |
571 | |
572 ReadBundleStatistics(); | |
573 SanityCheck(); | |
574 } | |
575 | |
576 | |
577 | |
578 void CacheManager::Clear(int bundle) | |
579 { | |
580 using namespace Orthanc; | |
581 SanityCheck(); | |
582 | |
583 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT fileUuid FROM Cache WHERE bundle=?"); | |
584 s.BindInt(0, bundle); | |
585 while (s.Step()) | |
586 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
587 pimpl_->storage_.Remove(s.ColumnString(0), Orthanc::FileContentType_Unknown); |
0 | 588 } |
589 | |
590 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE bundle=?"); | |
591 t.BindInt(0, bundle); | |
592 t.Run(); | |
593 | |
594 ReadBundleStatistics(); | |
595 SanityCheck(); | |
596 } | |
115
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
597 |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
598 |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
599 void CacheManager::SetProperty(CacheProperty property, |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
600 const std::string& value) |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
601 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
602 Orthanc::SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
603 "INSERT OR REPLACE INTO CacheProperties VALUES(?, ?)"); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
604 s.BindInt(0, property); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
605 s.BindString(1, value); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
606 s.Run(); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
607 } |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
608 |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
609 |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
610 bool CacheManager::LookupProperty(std::string& target, |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
611 CacheProperty property) |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
612 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
613 Orthanc::SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
614 "SELECT value FROM CacheProperties WHERE property=?"); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
615 s.BindInt(0, property); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
616 |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
617 if (!s.Step()) |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
618 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
619 return false; |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
620 } |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
621 else |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
622 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
623 target = s.ColumnString(0); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
624 return true; |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
625 } |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
626 } |
0 | 627 } |