SqliteConnector.h

Go to the documentation of this file.

// Copyright (c) 2002-present, OpenMS Inc. -- EKU Tuebingen, ETH Zurich, and FU Berlin
// SPDX-License-Identifier: BSD-3-Clause
//
// --------------------------------------------------------------------------
// $Maintainer: Hannes Roest $
// $Authors: Hannes Roest $
// --------------------------------------------------------------------------
 
#pragma once
 
#include <OpenMS/KERNEL/StandardTypes.h>
#include <OpenMS/DATASTRUCTURES/StringUtils.h>
#include <OpenMS/CONCEPT/Exception.h>
 
#include <type_traits> // for is_same
 
// forward declarations
struct sqlite3;
struct sqlite3_stmt;
 
namespace OpenMS
{
  class OPENMS_DLLAPI SqliteConnector
  {
  public:
 
    enum class SqlOpenMode
    {
      READ_ONLY,  
#ifndef READONLY
      READONLY = READ_ONLY, 
#endif
      READWRITE, 
      READWRITE_OR_CREATE 
    };
 
    SqliteConnector() = delete;
 
    explicit SqliteConnector(const std::string& filename, const SqlOpenMode mode = SqlOpenMode::READWRITE_OR_CREATE);
 
    ~SqliteConnector();
 
    sqlite3* getDB()
    {
      return db_;
    }
 
    bool tableExists(const std::string& tablename)
    {
      return tableExists(db_, tablename);
    }
 
    Size countTableRows(const std::string& table_name);
 
    bool columnExists(const std::string& tablename, const std::string& colname)
    {
      return columnExists(db_, tablename, colname);
    }
 
    void executeStatement(const std::string& statement)
    {
      executeStatement(db_, statement);
    }
 
    void executeBindStatement(const std::string& prepare_statement, const std::vector<std::string>& data)
    {
      executeBindStatement(db_, prepare_statement, data);
    }
 
    void prepareStatement(sqlite3_stmt** stmt, const std::string& prepare_statement)
    {
      prepareStatement(db_, stmt, prepare_statement);
    }
 
    static bool tableExists(sqlite3* db, const std::string& tablename);
 
    static bool columnExists(sqlite3* db, const std::string& tablename, const std::string& colname);
 
    static void executeStatement(sqlite3* db, const std::stringstream& statement);
 
    static void executeStatement(sqlite3* db, const std::string& statement);
 
    static void prepareStatement(sqlite3* db, sqlite3_stmt** stmt, const std::string& prepare_statement);
 
 
    static void executeBindStatement(sqlite3* db, const std::string& prepare_statement, const std::vector<std::string>& data);
 
  protected:
 
    void openDatabase_(const std::string& filename, const SqlOpenMode mode);
 
  protected:
    sqlite3* db_ = nullptr;
 
  };
 
  namespace Internal
  {
    namespace SqliteHelper
    {
      template <typename T>
      UInt64 clearSignBit(T /*value*/)
      {
        static_assert(std::is_same<T, std::false_type>::value, "Wrong input type to clearSignBit(). Please pass unsigned 64bit ints!");
        return 0;
      };
      template <>
      inline UInt64 clearSignBit(UInt64 value) {
        return value & ~(1ULL << 63);
      }
 
 
      enum class SqlState
      {
        SQL_ROW,
        SQL_DONE,
        SQL_ERROR 
      };
 
      SqlState nextRow(sqlite3_stmt* stmt, SqlState current = SqlState::SQL_ROW);
 
 
      template <typename ValueType>
      bool extractValue(ValueType* /* dst */, sqlite3_stmt* /* stmt */, int /* pos */)
      {
        throw Exception::IllegalArgument(__FILE__, __LINE__, OPENMS_PRETTY_FUNCTION,
          "Not implemented");
      }
 
      template <> bool extractValue<double>(double* dst, sqlite3_stmt* stmt, int pos); //explicit specialization
 
      template <> bool extractValue<int>(int* dst, sqlite3_stmt* stmt, int pos); //explicit specialization
      template <> bool extractValue<Int64>(Int64* dst, sqlite3_stmt* stmt, int pos); //explicit specialization
 
      template <> bool extractValue<std::string>(std::string* dst, sqlite3_stmt* stmt, int pos); //explicit specialization
 
      template <> bool extractValue<std::string>(std::string* dst, sqlite3_stmt* stmt, int pos); //explicit specialization
 
      bool extractValueIntStr(std::string* dst, sqlite3_stmt* stmt, int pos);
 
      double extractDouble(sqlite3_stmt* stmt, int pos);
      float extractFloat(sqlite3_stmt* stmt, int pos); 
      int extractInt(sqlite3_stmt* stmt, int pos);
      Int64 extractInt64(sqlite3_stmt* stmt, int pos);
      std::string extractString(sqlite3_stmt* stmt, int pos);
      char extractChar(sqlite3_stmt* stmt, int pos);
      bool extractBool(sqlite3_stmt* stmt, int pos);
    }
  }
 
 
} // namespace OpenMS