Mercurial > hg > orthanc-webviewer
annotate Plugin/Cache/CacheManager.cpp @ 115:c8ca47a67bf3
automatic clearing of the cache
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Mon, 07 Dec 2015 17:08:51 +0100 |
parents | a6492d20b2a8 |
children | 3dc81012e76a |
rev | line source |
---|---|
0 | 1 /** |
2 * Orthanc - A Lightweight, RESTful DICOM Store | |
3 * Copyright (C) 2012-2015 Sebastien Jodogne, Medical Physics | |
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 printf("ICI\n"); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
308 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
|
309 } |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
310 |
0 | 311 // Performance tuning of SQLite with PRAGMAs |
312 // http://www.sqlite.org/pragma.html | |
313 pimpl_->db_.Execute("PRAGMA SYNCHRONOUS=OFF;"); | |
314 pimpl_->db_.Execute("PRAGMA JOURNAL_MODE=WAL;"); | |
315 pimpl_->db_.Execute("PRAGMA LOCKING_MODE=EXCLUSIVE;"); | |
316 } | |
317 | |
318 | |
319 void CacheManager::Store(int bundleIndex, | |
320 const std::string& item, | |
321 const std::string& content) | |
322 { | |
323 SanityCheck(); | |
324 | |
325 const BundleQuota quota = GetBundleQuota(bundleIndex); | |
326 | |
327 if (quota.GetMaxSpace() > 0 && | |
328 content.size() > quota.GetMaxSpace()) | |
329 { | |
330 // Cannot store such a large instance into the cache, forget about it | |
331 return; | |
332 } | |
333 | |
334 using namespace Orthanc; | |
335 | |
336 std::auto_ptr<SQLite::Transaction> transaction(new SQLite::Transaction(pimpl_->db_)); | |
337 transaction->Begin(); | |
338 | |
339 Bundle bundle = GetBundle(bundleIndex); | |
340 | |
341 std::list<std::string> toRemove; | |
342 bundle.Add(content.size()); | |
343 MakeRoom(bundle, toRemove, bundleIndex, quota); | |
344 | |
345 // Store the cached content on the disk | |
346 const char* data = content.size() ? &content[0] : NULL; | |
347 std::string uuid = Toolbox::GenerateUuid(); | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
348 pimpl_->storage_.Create(uuid, data, content.size(), Orthanc::FileContentType_Unknown); |
0 | 349 |
350 bool ok = true; | |
351 | |
352 // Remove the previous cached value. This might happen if the same | |
353 // item is accessed very quickly twice: Another factory could have | |
354 // been cached a value before the check for existence in Access(). | |
355 { | |
356 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT seq, fileUuid, fileSize FROM Cache WHERE bundle=? AND item=?"); | |
357 s.BindInt(0, bundleIndex); | |
358 s.BindString(1, item); | |
359 if (s.Step()) | |
360 { | |
361 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE seq=?"); | |
362 t.BindInt64(0, s.ColumnInt64(0)); | |
363 t.Run(); | |
364 | |
365 toRemove.push_back(s.ColumnString(1)); | |
366 bundle.Remove(s.ColumnInt64(2)); | |
367 } | |
368 } | |
369 | |
370 if (ok) | |
371 { | |
372 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "INSERT INTO Cache VALUES(NULL, ?, ?, ?, ?)"); | |
373 s.BindInt(0, bundleIndex); | |
374 s.BindString(1, item); | |
375 s.BindString(2, uuid); | |
376 s.BindInt64(3, content.size()); | |
377 | |
378 if (!s.Run()) | |
379 { | |
380 ok = false; | |
381 } | |
382 } | |
383 | |
384 if (!ok) | |
385 { | |
386 // Error: Remove the stored file | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
387 pimpl_->storage_.Remove(uuid, Orthanc::FileContentType_Unknown); |
0 | 388 } |
389 else | |
390 { | |
391 transaction->Commit(); | |
392 | |
393 pimpl_->bundles_[bundleIndex] = bundle; | |
394 | |
395 for (std::list<std::string>::const_iterator | |
396 it = toRemove.begin(); it != toRemove.end(); it++) | |
397 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
398 pimpl_->storage_.Remove(*it, Orthanc::FileContentType_Unknown); |
0 | 399 } |
400 } | |
401 | |
402 SanityCheck(); | |
403 } | |
404 | |
405 | |
406 | |
407 bool CacheManager::LocateInCache(std::string& uuid, | |
408 uint64_t& size, | |
409 int bundle, | |
410 const std::string& item) | |
411 { | |
412 using namespace Orthanc; | |
413 SanityCheck(); | |
414 | |
415 std::auto_ptr<SQLite::Transaction> transaction(new SQLite::Transaction(pimpl_->db_)); | |
416 transaction->Begin(); | |
417 | |
418 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT seq, fileUuid, fileSize FROM Cache WHERE bundle=? AND item=?"); | |
419 s.BindInt(0, bundle); | |
420 s.BindString(1, item); | |
421 if (!s.Step()) | |
422 { | |
423 return false; | |
424 } | |
425 | |
426 int64_t seq = s.ColumnInt64(0); | |
427 uuid = s.ColumnString(1); | |
428 size = s.ColumnInt64(2); | |
429 | |
430 // Touch the cache to fulfill the LRU scheme. | |
431 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE seq=?"); | |
432 t.BindInt64(0, seq); | |
433 if (t.Run()) | |
434 { | |
435 SQLite::Statement u(pimpl_->db_, SQLITE_FROM_HERE, "INSERT INTO Cache VALUES(NULL, ?, ?, ?, ?)"); | |
436 u.BindInt(0, bundle); | |
437 u.BindString(1, item); | |
438 u.BindString(2, uuid); | |
439 u.BindInt64(3, size); | |
440 if (u.Run()) | |
441 { | |
442 // Everything was OK. Commit the changes to the cache. | |
443 transaction->Commit(); | |
444 return true; | |
445 } | |
446 } | |
447 | |
448 return false; | |
449 } | |
450 | |
451 | |
452 bool CacheManager::IsCached(int bundle, | |
453 const std::string& item) | |
454 { | |
455 std::string uuid; | |
456 uint64_t size; | |
457 return LocateInCache(uuid, size, bundle, item); | |
458 } | |
459 | |
460 | |
461 bool CacheManager::Access(std::string& content, | |
462 int bundle, | |
463 const std::string& item) | |
464 { | |
465 std::string uuid; | |
466 uint64_t size; | |
467 if (!LocateInCache(uuid, size, bundle, item)) | |
468 { | |
469 return false; | |
470 } | |
471 | |
472 bool ok; | |
473 try | |
474 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
475 pimpl_->storage_.Read(content, uuid, Orthanc::FileContentType_Unknown); |
0 | 476 ok = (content.size() == size); |
477 } | |
478 catch (std::runtime_error&) | |
479 { | |
480 ok = false; | |
481 } | |
482 | |
483 if (ok) | |
484 { | |
485 return true; | |
486 } | |
487 else | |
488 { | |
489 throw std::runtime_error("Error in the filesystem"); | |
490 } | |
491 } | |
492 | |
493 | |
494 void CacheManager::Invalidate(int bundleIndex, | |
495 const std::string& item) | |
496 { | |
497 using namespace Orthanc; | |
498 SanityCheck(); | |
499 | |
500 std::auto_ptr<SQLite::Transaction> transaction(new SQLite::Transaction(pimpl_->db_)); | |
501 transaction->Begin(); | |
502 | |
503 Bundle bundle = GetBundle(bundleIndex); | |
504 | |
505 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT seq, fileUuid, fileSize FROM Cache WHERE bundle=? AND item=?"); | |
506 s.BindInt(0, bundleIndex); | |
507 s.BindString(1, item); | |
508 if (s.Step()) | |
509 { | |
510 int64_t seq = s.ColumnInt64(0); | |
511 const std::string uuid = s.ColumnString(1); | |
512 uint64_t expectedSize = s.ColumnInt64(2); | |
513 bundle.Remove(expectedSize); | |
514 | |
515 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE seq=?"); | |
516 t.BindInt64(0, seq); | |
517 if (t.Run()) | |
518 { | |
519 transaction->Commit(); | |
520 pimpl_->bundles_[bundleIndex] = bundle; | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
521 pimpl_->storage_.Remove(uuid, Orthanc::FileContentType_Unknown); |
0 | 522 } |
523 } | |
524 } | |
525 | |
526 | |
527 | |
528 void CacheManager::SetBundleQuota(int bundle, | |
529 uint32_t maxCount, | |
530 uint64_t maxSpace) | |
531 { | |
532 SanityCheck(); | |
533 | |
534 const BundleQuota quota(maxCount, maxSpace); | |
535 EnsureQuota(bundle, quota); | |
536 pimpl_->quotas_[bundle] = quota; | |
537 | |
538 SanityCheck(); | |
539 } | |
540 | |
541 void CacheManager::SetDefaultQuota(uint32_t maxCount, | |
542 uint64_t maxSpace) | |
543 { | |
544 using namespace Orthanc; | |
545 SanityCheck(); | |
546 | |
547 pimpl_->defaultQuota_ = BundleQuota(maxCount, maxSpace); | |
548 | |
549 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT DISTINCT bundle FROM Cache"); | |
550 while (s.Step()) | |
551 { | |
552 EnsureQuota(s.ColumnInt(0), pimpl_->defaultQuota_); | |
553 } | |
554 | |
555 SanityCheck(); | |
556 } | |
557 | |
558 | |
559 void CacheManager::Clear() | |
560 { | |
561 using namespace Orthanc; | |
562 SanityCheck(); | |
563 | |
564 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT fileUuid FROM Cache"); | |
565 while (s.Step()) | |
566 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
567 pimpl_->storage_.Remove(s.ColumnString(0), Orthanc::FileContentType_Unknown); |
0 | 568 } |
569 | |
570 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache"); | |
571 t.Run(); | |
572 | |
573 ReadBundleStatistics(); | |
574 SanityCheck(); | |
575 } | |
576 | |
577 | |
578 | |
579 void CacheManager::Clear(int bundle) | |
580 { | |
581 using namespace Orthanc; | |
582 SanityCheck(); | |
583 | |
584 SQLite::Statement s(pimpl_->db_, SQLITE_FROM_HERE, "SELECT fileUuid FROM Cache WHERE bundle=?"); | |
585 s.BindInt(0, bundle); | |
586 while (s.Step()) | |
587 { | |
23
7a0af291cc90
Synchronization with Orthanc mainline
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
588 pimpl_->storage_.Remove(s.ColumnString(0), Orthanc::FileContentType_Unknown); |
0 | 589 } |
590 | |
591 SQLite::Statement t(pimpl_->db_, SQLITE_FROM_HERE, "DELETE FROM Cache WHERE bundle=?"); | |
592 t.BindInt(0, bundle); | |
593 t.Run(); | |
594 | |
595 ReadBundleStatistics(); | |
596 SanityCheck(); | |
597 } | |
115
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 |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
600 void CacheManager::SetProperty(CacheProperty property, |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
601 const std::string& value) |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
602 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
603 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
|
604 "INSERT OR REPLACE INTO CacheProperties VALUES(?, ?)"); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
605 s.BindInt(0, property); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
606 s.BindString(1, value); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
607 s.Run(); |
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 |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
611 bool CacheManager::LookupProperty(std::string& target, |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
612 CacheProperty property) |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
613 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
614 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
|
615 "SELECT value FROM CacheProperties WHERE property=?"); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
616 s.BindInt(0, property); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
617 |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
618 if (!s.Step()) |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
619 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
620 return false; |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
621 } |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
622 else |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
623 { |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
624 target = s.ColumnString(0); |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
625 return true; |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
626 } |
c8ca47a67bf3
automatic clearing of the cache
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
26
diff
changeset
|
627 } |
0 | 628 } |