Mercurial > hg > orthanc-databases
view Framework/PostgreSQL/PostgreSQLTransaction.cpp @ 57:f4d5c2c70f98
Suggestion by Karsten Hilbert: CREATE EXTENSION IF NOT EXISTS pg_trgm
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Tue, 04 Sep 2018 08:56:42 +0200 |
parents | 6a574d810b98 |
children | 714c5d2bee76 |
line wrap: on
line source
/** * Orthanc - A Lightweight, RESTful DICOM Store * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics * Department, University Hospital of Liege, Belgium * Copyright (C) 2017-2018 Osimis S.A., Belgium * * This program is free software: you can redistribute it and/or * modify it under the terms of the GNU Affero General Public License * as published by the Free Software Foundation, either version 3 of * the License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, but * WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. **/ #include "PostgreSQLTransaction.h" #include "PostgreSQLStatement.h" #include <Core/Logging.h> #include <Core/OrthancException.h> namespace OrthancDatabases { PostgreSQLTransaction::PostgreSQLTransaction(PostgreSQLDatabase& database) : database_(database), isOpen_(false), readOnly_(true) { Begin(); } PostgreSQLTransaction::~PostgreSQLTransaction() { if (isOpen_) { LOG(WARNING) << "PostgreSQL: An active PostgreSQL transaction was dismissed"; try { database_.Execute("ABORT"); } catch (Orthanc::OrthancException&) { // Ignore possible exceptions due to connection loss } } } void PostgreSQLTransaction::Begin() { if (isOpen_) { LOG(ERROR) << "PostgreSQL: Beginning a transaction twice!"; throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); } database_.Execute("BEGIN"); database_.Execute("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE"); readOnly_ = true; isOpen_ = true; } void PostgreSQLTransaction::Rollback() { if (!isOpen_) { LOG(ERROR) << "PostgreSQL: Attempting to rollback a nonexistent transaction. " << "Did you remember to call Begin()?"; throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); } database_.Execute("ABORT"); isOpen_ = false; } void PostgreSQLTransaction::Commit() { if (!isOpen_) { LOG(ERROR) << "PostgreSQL: Attempting to roll back a nonexistent transaction. " << "Did you remember to call Begin()?"; throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); } database_.Execute("COMMIT"); isOpen_ = false; } IResult* PostgreSQLTransaction::Execute(IPrecompiledStatement& statement, const Dictionary& parameters) { std::auto_ptr<IResult> result(dynamic_cast<PostgreSQLStatement&>(statement).Execute(*this, parameters)); if (!statement.IsReadOnly()) { readOnly_ = false; } return result.release(); } void PostgreSQLTransaction::ExecuteWithoutResult(IPrecompiledStatement& statement, const Dictionary& parameters) { dynamic_cast<PostgreSQLStatement&>(statement).ExecuteWithoutResult(*this, parameters); if (!statement.IsReadOnly()) { readOnly_ = false; } } }