Mercurial > hg > orthanc
annotate OrthancServer/Plugins/Samples/DelayedDeletion/PendingDeletionsDatabase.cpp @ 5677:dc96401dbe88 find-refactoring tip
starting the refactoring of /tools/find
| author | Sebastien Jodogne <s.jodogne@gmail.com> |
|---|---|
| date | Mon, 08 Jul 2024 19:03:23 +0200 |
| parents | f7adfb22e20e |
| children |
| rev | line source |
|---|---|
|
5264
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
1 /** |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
2 * Orthanc - A Lightweight, RESTful DICOM Store |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
3 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
4 * Department, University Hospital of Liege, Belgium |
|
5640
f7adfb22e20e
updated copyright, as Orthanc Team now replaces Osimis
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5485
diff
changeset
|
5 * Copyright (C) 2017-2023 Osimis S.A., Belgium |
|
f7adfb22e20e
updated copyright, as Orthanc Team now replaces Osimis
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5485
diff
changeset
|
6 * Copyright (C) 2024-2024 Orthanc Team SRL, Belgium |
|
5485
48b8dae6dc77
upgrade to year 2024
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5264
diff
changeset
|
7 * Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium |
|
5264
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
8 * |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
9 * This program is free software: you can redistribute it and/or |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
10 * modify it under the terms of the GNU General Public License as |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
11 * published by the Free Software Foundation, either version 3 of the |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
12 * License, or (at your option) any later version. |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
13 * |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
14 * This program is distributed in the hope that it will be useful, but |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
15 * WITHOUT ANY WARRANTY; without even the implied warranty of |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
17 * General Public License for more details. |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
18 * |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
19 * You should have received a copy of the GNU General Public License |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
20 * along with this program. If not, see <http://www.gnu.org/licenses/>. |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
21 **/ |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
22 |
|
99751c5a7cfe
added missing copyrights
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5024
diff
changeset
|
23 |
| 5024 | 24 #include "PendingDeletionsDatabase.h" |
| 25 | |
| 26 #include "../../../../OrthancFramework/Sources/SQLite/Statement.h" | |
| 27 #include "../../../../OrthancFramework/Sources/SQLite/Transaction.h" | |
| 28 | |
| 29 void PendingDeletionsDatabase::Setup() | |
| 30 { | |
| 31 // Performance tuning of SQLite with PRAGMAs | |
| 32 // http://www.sqlite.org/pragma.html | |
| 33 db_.Execute("PRAGMA SYNCHRONOUS=NORMAL;"); | |
| 34 db_.Execute("PRAGMA JOURNAL_MODE=WAL;"); | |
| 35 db_.Execute("PRAGMA LOCKING_MODE=EXCLUSIVE;"); | |
| 36 db_.Execute("PRAGMA WAL_AUTOCHECKPOINT=1000;"); | |
| 37 | |
| 38 { | |
| 39 Orthanc::SQLite::Transaction t(db_); | |
| 40 t.Begin(); | |
| 41 | |
| 42 if (!db_.DoesTableExist("Pending")) | |
| 43 { | |
| 44 db_.Execute("CREATE TABLE Pending(uuid TEXT, type INTEGER)"); | |
| 45 } | |
| 46 | |
| 47 t.Commit(); | |
| 48 } | |
| 49 } | |
| 50 | |
| 51 | |
| 52 PendingDeletionsDatabase::PendingDeletionsDatabase(const std::string& path) | |
| 53 { | |
| 54 db_.Open(path); | |
| 55 Setup(); | |
| 56 } | |
| 57 | |
| 58 | |
| 59 void PendingDeletionsDatabase::Enqueue(const std::string& uuid, | |
| 60 Orthanc::FileContentType type) | |
| 61 { | |
| 62 boost::mutex::scoped_lock lock(mutex_); | |
| 63 | |
| 64 Orthanc::SQLite::Transaction t(db_); | |
| 65 t.Begin(); | |
| 66 | |
| 67 { | |
| 68 Orthanc::SQLite::Statement s(db_, SQLITE_FROM_HERE, "INSERT INTO Pending VALUES(?, ?)"); | |
| 69 s.BindString(0, uuid); | |
| 70 s.BindInt(1, type); | |
| 71 s.Run(); | |
| 72 } | |
| 73 | |
| 74 t.Commit(); | |
| 75 } | |
| 76 | |
| 77 | |
| 78 bool PendingDeletionsDatabase::Dequeue(std::string& uuid, | |
| 79 Orthanc::FileContentType& type) | |
| 80 { | |
| 81 bool ok = false; | |
| 82 | |
| 83 boost::mutex::scoped_lock lock(mutex_); | |
| 84 | |
| 85 Orthanc::SQLite::Transaction t(db_); | |
| 86 t.Begin(); | |
| 87 | |
| 88 { | |
| 89 Orthanc::SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT uuid, type FROM Pending LIMIT 1"); | |
| 90 | |
| 91 if (s.Step()) | |
| 92 { | |
| 93 uuid = s.ColumnString(0); | |
| 94 type = static_cast<Orthanc::FileContentType>(s.ColumnInt(1)); | |
| 95 | |
| 96 Orthanc::SQLite::Statement s(db_, SQLITE_FROM_HERE, "DELETE FROM Pending WHERE uuid=?"); | |
| 97 s.BindString(0, uuid); | |
| 98 s.Run(); | |
| 99 | |
| 100 ok = true; | |
| 101 } | |
| 102 } | |
| 103 | |
| 104 t.Commit(); | |
| 105 | |
| 106 return ok; | |
| 107 } | |
| 108 | |
| 109 | |
| 110 unsigned int PendingDeletionsDatabase::GetSize() | |
| 111 { | |
| 112 boost::mutex::scoped_lock lock(mutex_); | |
| 113 | |
| 114 unsigned int value = 0; | |
| 115 | |
| 116 Orthanc::SQLite::Transaction t(db_); | |
| 117 t.Begin(); | |
| 118 | |
| 119 { | |
| 120 Orthanc::SQLite::Statement s(db_, SQLITE_FROM_HERE, "SELECT COUNT(*) FROM Pending"); | |
| 121 | |
| 122 if (s.Step()) | |
| 123 { | |
| 124 int tmp = s.ColumnInt(0); | |
| 125 if (tmp > 0) | |
| 126 { | |
| 127 value = static_cast<unsigned int>(tmp); | |
| 128 } | |
| 129 } | |
| 130 } | |
| 131 | |
| 132 t.Commit(); | |
| 133 | |
| 134 return value; | |
| 135 } |