Mercurial > hg > orthanc-databases
annotate Framework/Common/DatabaseManager.cpp @ 18:c7c54993a92e
fix sqlite
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Tue, 10 Jul 2018 10:40:39 +0200 |
parents | 41543239072d |
children | b2ff1cd2907a |
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 | |
5 * Copyright (C) 2017-2018 Osimis S.A., Belgium | |
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 "DatabaseManager.h" | |
23 | |
24 #include <Core/Logging.h> | |
25 #include <Core/OrthancException.h> | |
26 | |
27 #include <boost/thread.hpp> | |
28 | |
29 namespace OrthancDatabases | |
30 { | |
31 IDatabase& DatabaseManager::GetDatabase() | |
32 { | |
33 static const unsigned int MAX_CONNECTION_ATTEMPTS = 10; // TODO: Parameter | |
34 | |
35 unsigned int count = 0; | |
36 | |
37 while (database_.get() == NULL) | |
38 { | |
39 transaction_.reset(NULL); | |
40 | |
41 try | |
42 { | |
43 database_.reset(factory_->Open()); | |
44 } | |
45 catch (Orthanc::OrthancException& e) | |
46 { | |
47 if (e.GetErrorCode() == Orthanc::ErrorCode_DatabaseUnavailable) | |
48 { | |
49 count ++; | |
50 | |
51 if (count <= MAX_CONNECTION_ATTEMPTS) | |
52 { | |
53 LOG(WARNING) << "Database is currently unavailable, retrying..."; | |
54 boost::this_thread::sleep(boost::posix_time::seconds(1)); | |
55 continue; | |
56 } | |
57 else | |
58 { | |
59 LOG(ERROR) << "Timeout when connecting to the database, giving up"; | |
60 } | |
61 } | |
62 | |
63 throw; | |
64 } | |
65 } | |
66 | |
67 if (database_.get() == NULL || | |
68 database_->GetDialect() != dialect_) | |
69 { | |
70 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); | |
71 } | |
72 else | |
73 { | |
74 return *database_; | |
75 } | |
76 } | |
77 | |
78 | |
79 void DatabaseManager::Close() | |
80 { | |
81 LOG(TRACE) << "Closing the connection to the database"; | |
82 | |
83 // Rollback active transaction, if any | |
84 transaction_.reset(NULL); | |
85 | |
86 // Delete all the cached statements (must occur before closing | |
87 // the database) | |
88 for (CachedStatements::iterator it = cachedStatements_.begin(); | |
89 it != cachedStatements_.end(); ++it) | |
90 { | |
91 assert(it->second != NULL); | |
92 delete it->second; | |
93 } | |
94 | |
95 cachedStatements_.clear(); | |
96 | |
97 // Close the database | |
98 database_.reset(NULL); | |
99 | |
100 LOG(TRACE) << "Connection to the database is closed"; | |
101 } | |
102 | |
103 | |
104 void DatabaseManager::CloseIfUnavailable(Orthanc::ErrorCode e) | |
105 { | |
106 if (e != Orthanc::ErrorCode_Success) | |
107 { | |
108 transaction_.reset(NULL); | |
109 } | |
110 | |
111 if (e == Orthanc::ErrorCode_DatabaseUnavailable) | |
112 { | |
113 LOG(ERROR) << "The database is not available, closing the connection"; | |
114 Close(); | |
115 } | |
116 } | |
117 | |
118 | |
119 IPrecompiledStatement* DatabaseManager::LookupCachedStatement(const StatementLocation& location) const | |
120 { | |
121 CachedStatements::const_iterator found = cachedStatements_.find(location); | |
122 | |
123 if (found == cachedStatements_.end()) | |
124 { | |
125 return NULL; | |
126 } | |
127 else | |
128 { | |
129 assert(found->second != NULL); | |
130 return found->second; | |
131 } | |
132 } | |
133 | |
134 | |
135 IPrecompiledStatement& DatabaseManager::CacheStatement(const StatementLocation& location, | |
136 const Query& query) | |
137 { | |
138 LOG(TRACE) << "Caching statement from " << location.GetFile() << ":" << location.GetLine(); | |
139 | |
140 std::auto_ptr<IPrecompiledStatement> statement(GetDatabase().Compile(query)); | |
141 | |
142 IPrecompiledStatement* tmp = statement.get(); | |
143 if (tmp == NULL) | |
144 { | |
145 throw Orthanc::OrthancException(Orthanc::ErrorCode_InternalError); | |
146 } | |
147 | |
148 assert(cachedStatements_.find(location) == cachedStatements_.end()); | |
149 cachedStatements_[location] = statement.release(); | |
150 | |
151 return *tmp; | |
152 } | |
153 | |
154 | |
155 ITransaction& DatabaseManager::GetTransaction() | |
156 { | |
157 if (transaction_.get() == NULL) | |
158 { | |
159 LOG(TRACE) << "Automatically creating a database transaction"; | |
160 | |
161 try | |
162 { | |
163 transaction_.reset(GetDatabase().CreateTransaction()); | |
164 } | |
165 catch (Orthanc::OrthancException& e) | |
166 { | |
167 CloseIfUnavailable(e.GetErrorCode()); | |
168 throw; | |
169 } | |
170 } | |
171 | |
172 assert(transaction_.get() != NULL); | |
173 return *transaction_; | |
174 } | |
175 | |
176 | |
177 DatabaseManager::DatabaseManager(IDatabaseFactory* factory) : // Takes ownership | |
178 factory_(factory) | |
179 { | |
180 if (factory == NULL) | |
181 { | |
182 throw Orthanc::OrthancException(Orthanc::ErrorCode_NullPointer); | |
183 } | |
184 | |
185 dialect_ = factory->GetDialect(); | |
186 } | |
187 | |
188 | |
189 void DatabaseManager::StartTransaction() | |
190 { | |
191 boost::recursive_mutex::scoped_lock lock(mutex_); | |
192 | |
193 try | |
194 { | |
195 if (transaction_.get() != NULL) | |
196 { | |
197 #if 0 | |
198 // TODO: This should be the right implementation | |
199 if (transaction_->IsReadOnly()) | |
200 { | |
201 LOG(TRACE) << "Rollback of an uncommitted read-only transaction to start another transaction"; | |
202 transaction_->Rollback(); | |
203 transaction_.reset(NULL); | |
204 } | |
205 else | |
206 { | |
207 LOG(ERROR) << "Cannot rollback an uncommitted write transaction to start another transaction"; | |
208 throw Orthanc::OrthancException(Orthanc::ErrorCode_Database); | |
209 } | |
210 #else | |
211 LOG(INFO) << "Committing an uncommitted transaction to start another transaction"; | |
212 transaction_->Commit(); | |
213 transaction_.reset(NULL); | |
214 #endif | |
215 } | |
216 | |
217 transaction_.reset(GetDatabase().CreateTransaction()); | |
218 } | |
219 catch (Orthanc::OrthancException& e) | |
220 { | |
221 CloseIfUnavailable(e.GetErrorCode()); | |
222 throw; | |
223 } | |
224 } | |
225 | |
226 | |
227 void DatabaseManager::CommitTransaction() | |
228 { | |
229 boost::recursive_mutex::scoped_lock lock(mutex_); | |
230 | |
231 if (transaction_.get() == NULL) | |
232 { | |
233 LOG(ERROR) << "Cannot commit a non-existing transaction"; | |
234 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); | |
235 } | |
236 else | |
237 { | |
238 try | |
239 { | |
240 transaction_->Commit(); | |
241 transaction_.reset(NULL); | |
242 } | |
243 catch (Orthanc::OrthancException& e) | |
244 { | |
245 CloseIfUnavailable(e.GetErrorCode()); | |
246 throw; | |
247 } | |
248 } | |
249 } | |
250 | |
251 | |
252 void DatabaseManager::RollbackTransaction() | |
253 { | |
254 boost::recursive_mutex::scoped_lock lock(mutex_); | |
255 | |
256 if (transaction_.get() == NULL) | |
257 { | |
258 LOG(ERROR) << "Cannot rollback a non-existing transaction"; | |
259 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); | |
260 } | |
261 else | |
262 { | |
263 try | |
264 { | |
265 transaction_->Rollback(); | |
266 transaction_.reset(NULL); | |
267 } | |
268 catch (Orthanc::OrthancException& e) | |
269 { | |
270 CloseIfUnavailable(e.GetErrorCode()); | |
271 throw; | |
272 } | |
273 } | |
274 } | |
275 | |
276 | |
277 IResult& DatabaseManager::CachedStatement::GetResult() const | |
278 { | |
279 if (result_.get() == NULL) | |
280 { | |
281 LOG(ERROR) << "Accessing the results of a statement without having executed it"; | |
282 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); | |
283 } | |
284 | |
285 return *result_; | |
286 } | |
287 | |
288 | |
12
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
289 void DatabaseManager::CachedStatement::Setup(const char* sql) |
0 | 290 { |
12
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
291 statement_ = manager_.LookupCachedStatement(location_); |
0 | 292 |
293 if (statement_ == NULL) | |
294 { | |
295 query_.reset(new Query(sql)); | |
296 } | |
297 else | |
298 { | |
299 LOG(TRACE) << "Reusing cached statement from " | |
12
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
300 << location_.GetFile() << ":" << location_.GetLine(); |
0 | 301 } |
302 } | |
303 | |
12
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
304 |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
305 DatabaseManager::CachedStatement::CachedStatement(const StatementLocation& location, |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
306 DatabaseManager& manager, |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
307 const char* sql) : |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
308 lock_(manager.mutex_), |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
309 manager_(manager), |
18 | 310 database_(manager_.GetDatabase()), |
12
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
311 location_(location), |
18 | 312 transaction_(manager_.GetTransaction()) |
12
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
313 { |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
314 Setup(sql); |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
315 } |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
316 |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
317 |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
318 DatabaseManager::CachedStatement::CachedStatement(const StatementLocation& location, |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
319 Transaction& transaction, |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
320 const char* sql) : |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
321 lock_(manager_.mutex_), |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
322 manager_(transaction.GetManager()), |
18 | 323 database_(manager_.GetDatabase()), |
12
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
324 location_(location), |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
325 transaction_(manager_.GetTransaction()) |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
326 { |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
327 Setup(sql); |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
328 } |
41543239072d
transactions for storage area
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
0
diff
changeset
|
329 |
0 | 330 |
331 void DatabaseManager::CachedStatement::SetReadOnly(bool readOnly) | |
332 { | |
333 if (query_.get() != NULL) | |
334 { | |
335 query_->SetReadOnly(readOnly); | |
336 } | |
337 } | |
338 | |
339 | |
340 void DatabaseManager::CachedStatement::SetParameterType(const std::string& parameter, | |
341 ValueType type) | |
342 { | |
343 if (query_.get() != NULL) | |
344 { | |
345 query_->SetType(parameter, type); | |
346 } | |
347 } | |
348 | |
349 | |
350 void DatabaseManager::CachedStatement::Execute() | |
351 { | |
352 Dictionary parameters; | |
353 Execute(parameters); | |
354 } | |
355 | |
356 | |
357 void DatabaseManager::CachedStatement::Execute(const Dictionary& parameters) | |
358 { | |
359 if (result_.get() != NULL) | |
360 { | |
361 LOG(ERROR) << "Cannot execute twice a statement"; | |
362 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); | |
363 } | |
364 | |
365 try | |
366 { | |
367 if (query_.get() != NULL) | |
368 { | |
369 // Register the newly-created statement | |
370 assert(statement_ == NULL); | |
371 statement_ = &manager_.CacheStatement(location_, *query_); | |
372 query_.reset(NULL); | |
373 } | |
374 | |
375 assert(statement_ != NULL); | |
376 result_.reset(transaction_.Execute(*statement_, parameters)); | |
377 } | |
378 catch (Orthanc::OrthancException& e) | |
379 { | |
380 manager_.CloseIfUnavailable(e.GetErrorCode()); | |
381 throw; | |
382 } | |
383 } | |
384 | |
385 | |
386 bool DatabaseManager::CachedStatement::IsDone() const | |
387 { | |
388 try | |
389 { | |
390 return GetResult().IsDone(); | |
391 } | |
392 catch (Orthanc::OrthancException& e) | |
393 { | |
394 manager_.CloseIfUnavailable(e.GetErrorCode()); | |
395 throw; | |
396 } | |
397 } | |
398 | |
399 | |
400 void DatabaseManager::CachedStatement::Next() | |
401 { | |
402 try | |
403 { | |
404 GetResult().Next(); | |
405 } | |
406 catch (Orthanc::OrthancException& e) | |
407 { | |
408 manager_.CloseIfUnavailable(e.GetErrorCode()); | |
409 throw; | |
410 } | |
411 } | |
412 | |
413 | |
414 size_t DatabaseManager::CachedStatement::GetResultFieldsCount() const | |
415 { | |
416 try | |
417 { | |
418 return GetResult().GetFieldsCount(); | |
419 } | |
420 catch (Orthanc::OrthancException& e) | |
421 { | |
422 manager_.CloseIfUnavailable(e.GetErrorCode()); | |
423 throw; | |
424 } | |
425 } | |
426 | |
427 | |
428 void DatabaseManager::CachedStatement::SetResultFieldType(size_t field, | |
429 ValueType type) | |
430 { | |
431 try | |
432 { | |
433 if (!GetResult().IsDone()) | |
434 { | |
435 GetResult().SetExpectedType(field, type); | |
436 } | |
437 } | |
438 catch (Orthanc::OrthancException& e) | |
439 { | |
440 manager_.CloseIfUnavailable(e.GetErrorCode()); | |
441 throw; | |
442 } | |
443 } | |
444 | |
445 | |
446 const IValue& DatabaseManager::CachedStatement::GetResultField(size_t index) const | |
447 { | |
448 try | |
449 { | |
450 return GetResult().GetField(index); | |
451 } | |
452 catch (Orthanc::OrthancException& e) | |
453 { | |
454 manager_.CloseIfUnavailable(e.GetErrorCode()); | |
455 throw; | |
456 } | |
457 } | |
458 } |