Mercurial > hg > orthanc-databases
diff Framework/Odbc/OdbcDatabase.h @ 329:b5fb8b77ce4d
initial commit of ODBC framework
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Tue, 10 Aug 2021 20:08:53 +0200 |
parents | |
children | 16aac0287485 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/Framework/Odbc/OdbcDatabase.h Tue Aug 10 20:08:53 2021 +0200 @@ -0,0 +1,82 @@ +/** + * Orthanc - A Lightweight, RESTful DICOM Store + * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics + * Department, University Hospital of Liege, Belgium + * Copyright (C) 2017-2021 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/>. + **/ + + +#pragma once + +#include "OdbcEnvironment.h" + +#include "../Common/IDatabaseFactory.h" + +#include <Compatibility.h> + +#include <set> + + +namespace OrthancDatabases +{ + class OdbcDatabase : public IDatabase + { + private: + class OdbcImplicitTransaction; + class OdbcExplicitTransaction; + + SQLHDBC handle_; + Dialect dialect_; + unsigned int dbmsMajorVersion_; + + public: + OdbcDatabase(OdbcEnvironment& environment, + const std::string& connectionString); + + virtual ~OdbcDatabase(); + + SQLHDBC GetHandle() + { + return handle_; + } + + std::string FormatError(); + + void ListTables(std::set<std::string>& target); + + // "name" must be in lower-case + bool DoesTableExist(const std::string& name); + + void ExecuteMultiLines(const std::string& query); + + virtual Dialect GetDialect() const ORTHANC_OVERRIDE + { + return dialect_; + } + + virtual IPrecompiledStatement* Compile(const Query& query) ORTHANC_OVERRIDE; + + virtual ITransaction* CreateTransaction(TransactionType type) ORTHANC_OVERRIDE; + + // https://en.wikipedia.org/wiki/History_of_Microsoft_SQL_Server + unsigned int GetDbmsMajorVersion() const; + + static IDatabaseFactory* CreateDatabaseFactory(unsigned int maxConnectionRetries, + unsigned int connectionRetryInterval, + const std::string& connectionString, + bool checkEncodings); + }; +}