Mercurial > hg > orthanc-postgresql
view Core/PostgreSQLTransaction.cpp @ 162:c2ea17961dfc
Running transactions in "Serializable" isolation level
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 08 Mar 2018 12:27:20 +0100 (2018-03-08) |
parents | 5611e6b1ec14 |
children | 43d5a4e03e8d e6475ac42d41 |
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 "PostgreSQLException.h" namespace OrthancPlugins { PostgreSQLTransaction::PostgreSQLTransaction(PostgreSQLConnection& connection, bool open) : connection_(connection), isOpen_(false) { if (open) { Begin(); } } PostgreSQLTransaction::~PostgreSQLTransaction() { if (isOpen_) { connection_.Execute("ABORT"); } } void PostgreSQLTransaction::Begin() { if (isOpen_) { throw PostgreSQLException("PostgreSQL: Beginning a transaction twice!"); } connection_.Execute("BEGIN"); connection_.Execute("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE"); isOpen_ = true; } void PostgreSQLTransaction::Rollback() { if (!isOpen_) { throw PostgreSQLException("Attempting to rollback a nonexistent transaction. " "Did you remember to call Begin()?"); } connection_.Execute("ABORT"); isOpen_ = false; } void PostgreSQLTransaction::Commit() { if (!isOpen_) { throw PostgreSQLException("Attempting to roll back a nonexistent transaction. " "Did you remember to call Begin()?"); } connection_.Execute("COMMIT"); isOpen_ = false; } }