DatabaseHelper.hpp

#pragma once

#include <nlohmann/json.hpp>
#include <range/v3/all.hpp>
#include <sqlite3.h>
#include <vector>

class Database {
  private:
  sqlite3* db;

  public:
  Database();

  ~Database();

  void create_table();

  std::vector<std::string> read_column_text(std::string query);

  std::vector<std::string> read_column_text_query(std::string table_name,
                                                  std::string column_name);

  std::vector<std::string>
  read_column_text_query_where(std::string table_name,
                               std::string column_name,
                               std::string where_column_name,
                               std::string where_value);

  nlohmann::json select_delphimodel_row(std::string modelId);

  nlohmann::json select_causemosasyncexperimentresult_row(std::string modelId);

  void insert(std::string insert_query);

  void insert_into_delphimodel(std::string id, std::string model);

  void insert_into_causemosasyncexperimentresult(std::string id,
                                                 std::string status,
                                                 std::string experimentType,
                                                 std::string results);

  void update_row(std::string table_name,
                  std::string column_name,
                  std::string value,
                  std::string where_column_name,
                  std::string where_value);

  void delete_rows(std::string table_name,
                   std::string where_column_name,
                   std::string where_value);
};