db_functions.h

// (c) Copyright 2022 CERN for the benefit of the LHCb Collaboration.
//
// This software is distributed under the terms of the GNU General Public
// Licence version 3 (GPL Version 3), copied verbatim in the file "LICENCE".
//
// In applying this licence, CERN does not waive the privileges and immunities
// granted to it by virtue of its status as an Intergovernmental Organization
// or submit itself to any jurisdiction.
 
 
#pragma once
#include <memory>
#include <string>
#include "sqlite3.h"
 
namespace SQLamarr
{
  typedef std::unique_ptr<sqlite3, void(*)(sqlite3*)> SQLite3DB;
 
  SQLite3DB make_database (
      std::string filename,
      int flags = SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_URI,
      std::string init = std::string()
      );
 
  sqlite3_stmt* prepare_statement (SQLite3DB& db, const std::string& query);
 
  std::string dump_table(SQLite3DB& db, const std::string& query);
 
  float read_as_float(sqlite3_stmt*, int);
 
  void validate_token(const std::string& token);
 
  void update_db_connection(
      SQLite3DB& old_db, 
      const std::string& db_uri, 
      int flags = SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_URI
      );
}