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);
+  };
+}