Mercurial > hg > orthanc
annotate OrthancServer/Plugins/Samples/DelayedDeletion/PendingDeletionsDatabase.cpp @ 5839:7aef730c0859 default tip
cont
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Wed, 16 Oct 2024 19:34:42 +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 } |