telemetry_repository.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_REPOSITORY_HPP
#define ORES_TELEMETRY_REPOSITORY_TELEMETRY_REPOSITORY_HPP
 
#include <string>
#include <vector>
#include <optional>
#include <boost/uuid/uuid.hpp>
#include <sqlgen/postgres.hpp>
#include "ores.logging/make_logger.hpp"
#include "ores.database/domain/context.hpp"
#include "ores.telemetry/domain/telemetry_log_entry.hpp"
#include "ores.telemetry/domain/telemetry_query.hpp"
#include "ores.telemetry/domain/telemetry_stats.hpp"
#include "ores.telemetry/domain/telemetry_batch.hpp"
#include "ores.telemetry/domain/nats_server_sample.hpp"
#include "ores.telemetry/domain/nats_stream_sample.hpp"
#include "ores.telemetry/domain/nats_samples_query.hpp"
#include "ores.telemetry/domain/service_sample.hpp"
 
namespace ores::telemetry::database::repository {
 
class telemetry_repository {
private:
    inline static std::string_view logger_name =
        "ores.telemetry.repository.telemetry_repository";
 
    [[nodiscard]] static auto& lg() {
        using namespace ores::logging;
        static auto instance = make_logger(logger_name);
        return instance;
    }
 
public:
    using context = ores::database::context;
 
    std::string sql();
 
    void create(context ctx, const domain::telemetry_log_entry& entry);
 
    std::size_t create_batch(context ctx, const domain::telemetry_batch& batch);
 
    std::vector<domain::telemetry_log_entry> query(context ctx,
        const domain::telemetry_query& q);
 
    std::uint64_t count(context ctx, const domain::telemetry_query& q);
 
    std::vector<domain::telemetry_log_entry> read_by_session(context ctx,
        const boost::uuids::uuid& session_id,
        std::uint32_t limit = 1000);
 
    std::vector<domain::telemetry_log_entry> read_by_account(context ctx,
        const boost::uuids::uuid& account_id,
        const std::chrono::system_clock::time_point& start,
        const std::chrono::system_clock::time_point& end,
        std::uint32_t limit = 1000);
 
    std::vector<domain::telemetry_stats> read_hourly_stats(context ctx,
        const domain::telemetry_stats_query& q);
 
    std::vector<domain::telemetry_stats> read_daily_stats(context ctx,
        const domain::telemetry_stats_query& q);
 
    domain::telemetry_summary get_summary(context ctx, std::uint32_t hours = 24);
 
    std::uint64_t count_errors(context ctx, const std::string& source_name,
        std::uint32_t hours = 1);
 
    std::uint64_t delete_old_logs(context ctx,
        const std::chrono::system_clock::time_point& older_than);
 
    void insert_server_sample(context ctx,
        const domain::nats_server_sample& sample);
 
    void insert_stream_samples(context ctx,
        const std::vector<domain::nats_stream_sample>& samples);
 
    std::vector<domain::nats_server_sample> query_server_samples(context ctx,
        const domain::nats_server_samples_query& q);
 
    std::vector<domain::nats_stream_sample> query_stream_samples(context ctx,
        const domain::nats_stream_samples_query& q);
 
    void insert_service_sample(context ctx,
        const domain::service_sample& sample);
 
    std::vector<domain::service_sample> list_service_samples(context ctx);
};
 
}
 
#endif