SqliteConnector.h

Go to the documentation of this file.

// --------------------------------------------------------------------------
//                   OpenMS -- Open-Source Mass Spectrometry
// --------------------------------------------------------------------------
// Copyright The OpenMS Team -- Eberhard Karls University Tuebingen,
// ETH Zurich, and Freie Universitaet Berlin 2002-2020.
//
// This software is released under a three-clause BSD license:
//  * Redistributions of source code must retain the above copyright
//    notice, this list of conditions and the following disclaimer.
//  * Redistributions in binary form must reproduce the above copyright
//    notice, this list of conditions and the following disclaimer in the
//    documentation and/or other materials provided with the distribution.
//  * Neither the name of any author or any participating institution
//    may be used to endorse or promote products derived from this software
//    without specific prior written permission.
// For a full list of authors, refer to the file AUTHORS.
// --------------------------------------------------------------------------
// THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
// AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
// IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
// ARE DISCLAIMED. IN NO EVENT SHALL ANY OF THE AUTHORS OR THE CONTRIBUTING
// INSTITUTIONS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
// EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
// PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
// OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
// WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
// OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
// ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
//
// --------------------------------------------------------------------------
// $Maintainer: Hannes Roest $
// $Authors: Hannes Roest $
// --------------------------------------------------------------------------
 
#pragma once
 
#include <OpenMS/KERNEL/StandardTypes.h>
#include <OpenMS/DATASTRUCTURES/String.h>
#include <OpenMS/CONCEPT/Exception.h>
 
#include <iostream>
#include <sstream>
 
// forward declarations
struct sqlite3;
struct sqlite3_stmt;
 
namespace OpenMS
{
  class OPENMS_DLLAPI SqliteConnector
  {
public:
 
    SqliteConnector();
 
    explicit SqliteConnector(const String& filename)
    {
      openDatabase(filename);
    }
 
    ~SqliteConnector();
 
    sqlite3* getDB()
    {
      return db_;
    }
 
    bool tableExists(const String& tablename)
    {
      return tableExists(db_, tablename);
    }
 
    bool columnExists(const String& tablename, const String& colname)
    {
      return columnExists(db_, tablename, colname);
    }
 
    void executeStatement(const std::stringstream& statement)
    {
      executeStatement(db_, statement);
    }
 
    void executeStatement(const String& statement)
    {
      executeStatement(db_, statement);
    }
 
    void executeBindStatement(const String& prepare_statement, const std::vector<String>& data)
    {
      executeBindStatement(db_, prepare_statement, data);
    }
 
    void prepareStatement(sqlite3_stmt** stmt, const String& prepare_statement)
    {
      prepareStatement(db_, stmt, prepare_statement);
    }
 
    static bool tableExists(sqlite3* db, const String& tablename);
 
    static bool columnExists(sqlite3* db, const String& tablename, const String& colname);
 
    static void executeStatement(sqlite3* db, const std::stringstream& statement);
 
    static void executeStatement(sqlite3* db, const String& statement);
 
    static void prepareStatement(sqlite3* db, sqlite3_stmt** stmt, const String& prepare_statement);
 
 
    static void executeBindStatement(sqlite3* db, const String& prepare_statement, const std::vector<String>& data);
 
protected:
 
    void openDatabase(const String& filename);
 
protected:
    sqlite3 *db_;
 
  };
 
  namespace Internal
  {
    namespace SqliteHelper
    {
 
      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<String>(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(String* dst, sqlite3_stmt* stmt, int pos);
 
    }
  }
 
 
} // namespace OpenMS