test_db.hpp

Go to the documentation of this file.

#pragma once
 
#include <sqlite.hpp>

namespace insitech::database::models {
struct Stat {
  std::string m_id;  // первичный ключ
  std::string m_date;
  int m_status{};
  int m_err_code{};
  std::string m_n_RFID;
  int m_mqtt_status{};
};
 
struct Info {
  std::string m_id;  // первичный ключ
  std::string m_date;
  std::string m_field;
  std::string m_value;
  int m_mqtt_status{};
};
 
struct Errors {
  std::string m_id;  // первичный ключ
  std::string m_date;
  int m_error{};   // underlying(BoardError)
  bool m_value{};  // хранится как INTEGER 0/1
  int m_mqtt_status{};
};
 
// Статическое словарное отображение: область ("error"/"status"), числовой
// код, описание и версия набора данных
struct Dictionary {
  int m_id{};
  std::string m_area;         // например, "error" или "status"
  int m_code{};               // числовой код (например, значение enum)
  std::string m_description;  // текст, понятный человеку
  std::string m_version;  // версия набора данных, для обновления при запуске
  auto operator==(const Dictionary& other) const -> bool {
    return m_area == other.m_area && m_code == other.m_code &&
           m_version == other.m_version && m_description == other.m_description;
  }
 
  auto operator!=(const Dictionary& other) const -> bool {
    return !(*this == other);
  }
};
}  // namespace insitech::database::models
 
// ===== GENERATED CODE (DO NOT EDIT) =====
namespace insitech::database::meta {
 
struct StatMeta {
  using Object = models::Stat;
  static constexpr auto K_TABLE_NAME = "stat";
  static constexpr auto fields() {
    return std::make_tuple(&Object::m_id, &Object::m_date, &Object::m_status,
                           &Object::m_err_code, &Object::m_n_RFID,
                           &Object::m_mqtt_status);
  }
  static constexpr std::array<const char*, 6> K_FIELD_NAMES{
      "id", "date", "status", "err_code", "n_RFID", "mqtt_status"};
};
 
struct InfoMeta {
  using Object = models::Info;
  static constexpr auto K_TABLE_NAME = "info";
  static constexpr auto fields() {
    return std::make_tuple(&Object::m_id, &Object::m_date, &Object::m_field,
                           &Object::m_value, &Object::m_mqtt_status);
  }
  static constexpr std::array<const char*, 5> K_FIELD_NAMES{
      "id", "date", "field", "value", "mqtt_status"};
};
 
struct ErrorsMeta {
  using Object = models::Errors;
  static constexpr auto K_TABLE_NAME = "errors";
  static constexpr auto fields() {
    return std::make_tuple(&Object::m_id, &Object::m_date, &Object::m_error,
                           &Object::m_value, &Object::m_mqtt_status);
  }
  static constexpr std::array<const char*, 5> K_FIELD_NAMES{
      "id", "date", "error", "value", "mqtt_status"};
};
 
struct DictionaryMeta {
  using Object = models::Dictionary;
  static constexpr auto K_TABLE_NAME = "dictionary";
  static constexpr auto fields() {
    return std::make_tuple(&Object::m_id, &Object::m_area, &Object::m_code,
                           &Object::m_description, &Object::m_version);
  }
  static constexpr std::array<const char*, 5> K_FIELD_NAMES{
      "id", "area", "code", "description", "version"};
};
 
}  // namespace insitech::database::meta
 
// ===== DATABASE WRAPPER =====
 
class TestDb : public insitech::database::ThreadSafeDB<
                   insitech::database::meta::StatMeta,
                   insitech::database::meta::InfoMeta,
                   insitech::database::meta::ErrorsMeta,
                   insitech::database::meta::DictionaryMeta> {
 public:
  using Base = insitech::database::ThreadSafeDB<
      insitech::database::meta::StatMeta, insitech::database::meta::InfoMeta,
      insitech::database::meta::ErrorsMeta,
      insitech::database::meta::DictionaryMeta>;
  explicit TestDb(const std::string& db_path) : Base(db_path) {}
 
  void reset_data_keep_schema() const {
    this->Base::reset_data_keep_schema<
        insitech::database::models::Stat, insitech::database::models::Info,
        insitech::database::models::Errors,
        insitech::database::models::Dictionary>();
  }
 
  void add_stat(const insitech::database::models::Stat& input) {
    this->write(input);
  }
 
  void add_info(const insitech::database::models::Info& input) {
    this->write(input);
  }
 
  void add_errors(const insitech::database::models::Errors& input) {
    this->write(input);
  }
 
  void add_dictionary(const insitech::database::models::Dictionary& input) {
    this->write(input);
  }
};
 
// ===== END GENERATED CODE =====