telemetry_entity.hpp

/* -*- mode: c++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*-
 *
 * Copyright (C) 2025 Marco Craveiro <marco.craveiro@gmail.com>
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License as published by the Free Software
 * Foundation; either version 3 of the License, or (at your option) any later
 * version.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
 * details.
 *
 * You should have received a copy of the GNU General Public License along with
 * this program; if not, write to the Free Software Foundation, Inc., 51
 * Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
 *
 */
#ifndef ORES_TELEMETRY_REPOSITORY_TELEMETRY_ENTITY_HPP
#define ORES_TELEMETRY_REPOSITORY_TELEMETRY_ENTITY_HPP
 
#include <string>
#include <cstdint>
#include <iosfwd>
#include "sqlgen/Timestamp.hpp"
#include "sqlgen/PrimaryKey.hpp"
 
namespace ores::telemetry::database::repository {
 
struct telemetry_entity {
    constexpr static const char* schema = "public";
    constexpr static const char* tablename = "ores_telemetry_logs_tbl";
 
    sqlgen::PrimaryKey<std::string> id;
 
    std::string tenant_id;
 
    sqlgen::PrimaryKey<sqlgen::Timestamp<"%Y-%m-%d %H:%M:%S">> timestamp;
 
    std::string source;
 
    std::string source_name;
 
    std::optional<std::string> session_id;
 
    std::optional<std::string> account_id;
 
    std::string level;
 
    std::string component;
 
    std::string message;
 
    std::string tag;
 
    sqlgen::Timestamp<"%Y-%m-%d %H:%M:%S"> recorded_at;
};
 
std::ostream& operator<<(std::ostream& s, const telemetry_entity& v);
 
struct telemetry_stats_hourly_entity {
    constexpr static const char* schema = "public";
    constexpr static const char* tablename = "ores_telemetry_stats_hourly_vw";
 
    std::string hour;
    std::string source;
    std::string source_name;
    std::string level;
    std::int64_t log_count = 0;
    std::int64_t unique_sessions = 0;
    std::int64_t unique_accounts = 0;
};
 
std::ostream& operator<<(std::ostream& s, const telemetry_stats_hourly_entity& v);
 
struct telemetry_stats_daily_entity {
    constexpr static const char* schema = "public";
    constexpr static const char* tablename = "ores_telemetry_stats_daily_vw";
 
    std::string day;
    std::string source;
    std::string source_name;
    std::string component;
    std::string level;
    std::int64_t log_count = 0;
    std::int64_t unique_sessions = 0;
    std::int64_t unique_accounts = 0;
};
 
std::ostream& operator<<(std::ostream& s, const telemetry_stats_daily_entity& v);
 
struct nats_server_sample_entity {
    constexpr static const char* schema = "public";
    constexpr static const char* tablename = "ores_telemetry_nats_server_samples_tbl";
 
    sqlgen::PrimaryKey<sqlgen::Timestamp<"%Y-%m-%d %H:%M:%S">> sampled_at;
    sqlgen::PrimaryKey<std::string> tenant_id;
    std::int64_t in_msgs{0};
    std::int64_t out_msgs{0};
    std::int64_t in_bytes{0};
    std::int64_t out_bytes{0};
    int connections{0};
    std::int64_t mem_bytes{0};
    int slow_consumers{0};
};
 
struct service_sample_entity {
    constexpr static const char* schema = "public";
    constexpr static const char* tablename = "ores_telemetry_service_samples_tbl";
 
    sqlgen::PrimaryKey<sqlgen::Timestamp<"%Y-%m-%d %H:%M:%S">> sampled_at;
    sqlgen::PrimaryKey<std::string> service_name;
    sqlgen::PrimaryKey<std::string> instance_id;
    std::string version;
};
 
struct nats_stream_sample_entity {
    constexpr static const char* schema = "public";
    constexpr static const char* tablename = "ores_telemetry_nats_stream_samples_tbl";
 
    sqlgen::PrimaryKey<sqlgen::Timestamp<"%Y-%m-%d %H:%M:%S">> sampled_at;
    sqlgen::PrimaryKey<std::string> tenant_id;
    sqlgen::PrimaryKey<std::string> stream_name;
    std::int64_t messages{0};
    std::int64_t bytes{0};
    int consumer_count{0};
};
 
}
 
#endif