Mercurial > hg > orthanc-databases
view PostgreSQL/Plugins/PostgreSQLStorageArea.cpp @ 395:a7a029043670 db-protobuf
integration mainline->db-protobuf
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Wed, 05 Apr 2023 14:53:57 +0200 |
parents | 3d6886f3e5b3 |
children | ecd0b719cff5 |
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-2023 Osimis S.A., Belgium * Copyright (C) 2021-2023 Sebastien Jodogne, ICTEAM UCLouvain, 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 "PostgreSQLStorageArea.h" #include "PostgreSQLDefinitions.h" #include "../../Framework/PostgreSQL/PostgreSQLTransaction.h" #include "../../Resources/Orthanc/Plugins/OrthancPluginCppWrapper.h" #include <Compatibility.h> // For std::unique_ptr<> #include <Logging.h> namespace OrthancDatabases { void PostgreSQLStorageArea::ConfigureDatabase(PostgreSQLDatabase& db, const PostgreSQLParameters& parameters, bool clearAll) { if (parameters.HasLock()) { db.AdvisoryLock(POSTGRESQL_LOCK_STORAGE); } { PostgreSQLDatabase::TransientAdvisoryLock lock(db, POSTGRESQL_LOCK_DATABASE_SETUP); if (clearAll) { db.ClearAll(); } { PostgreSQLTransaction t(db, TransactionType_ReadWrite); if (!db.DoesTableExist("StorageArea")) { db.ExecuteMultiLines("CREATE TABLE IF NOT EXISTS StorageArea(" "uuid VARCHAR NOT NULL PRIMARY KEY," "content OID NOT NULL," "type INTEGER NOT NULL)"); // Automatically remove the large objects associated with the table db.ExecuteMultiLines("CREATE OR REPLACE RULE StorageAreaDelete AS ON DELETE " "TO StorageArea DO SELECT lo_unlink(old.content);"); } t.Commit(); } } } PostgreSQLStorageArea::PostgreSQLStorageArea(const PostgreSQLParameters& parameters, bool clearAll) : StorageBackend(PostgreSQLDatabase::CreateDatabaseFactory(parameters), parameters.GetMaxConnectionRetries()) { { AccessorBase accessor(*this); PostgreSQLDatabase& database = dynamic_cast<PostgreSQLDatabase&>(accessor.GetManager().GetDatabase()); ConfigureDatabase(database, parameters, clearAll); } } }