view Core/PostgreSQLTransaction.cpp @ 163:43d5a4e03e8d readonly-mode

added Readonly mode to try to improve transactions isolation
author amazy
date Tue, 13 Mar 2018 11:26:46 +0100 (2018-03-13)
parents c2ea17961dfc
children
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!");
    }

    if (connection_.IsReadOnly())
    {
      connection_.Execute("BEGIN TRANSACTION READ ONLY");
    }
    else
    {
      connection_.Execute("BEGIN 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;
  }
}