bitemporal_operations.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_DATABASE_REPOSITORY_BITEMPORAL_OPERATIONS_HPP
#define ORES_DATABASE_REPOSITORY_BITEMPORAL_OPERATIONS_HPP
 
#include <map>
#include <optional>
#include <vector>
#include <sqlgen/postgres.hpp>
#include "ores.logging/make_logger.hpp"
#include "ores.database/domain/context.hpp"
#include "ores.database/repository/helpers.hpp"
 
namespace ores::database::repository {
 
template<typename EntityType, typename DomainType, typename QueryType, typename MapperFunc>
std::vector<DomainType> execute_read_query(context ctx, const QueryType& query,
    MapperFunc&& mapper, logging::logger_t& lg, const std::string& operation_desc) {
 
    using namespace ores::logging;
    using namespace sqlgen;
 
    BOOST_LOG_SEV(lg, debug) << operation_desc << ".";
 
    const auto r = session(ctx.connection_pool()).and_then(query);
    ensure_success(r, lg);
 
    BOOST_LOG_SEV(lg, debug) << operation_desc << ". Total: " << r->size();
    return std::forward<MapperFunc>(mapper)(*r);
}
 
template<typename EntityType>
void execute_write_query(context ctx, const EntityType& entity,
    logging::logger_t& lg, const std::string& operation_desc) {
 
    using namespace ores::logging;
    using namespace sqlgen;
 
    BOOST_LOG_SEV(lg, debug) << operation_desc << ".";
 
    const auto r = session(ctx.connection_pool())
        .and_then(begin_transaction)
        .and_then(insert(entity))
        .and_then(commit);
    ensure_success(r, lg);
 
    BOOST_LOG_SEV(lg, debug) << "Finished " << operation_desc << ".";
}
 
template<typename QueryType>
void execute_delete_query(context ctx, const QueryType& query,
    logging::logger_t& lg, const std::string& operation_desc) {
 
    using namespace ores::logging;
    using namespace sqlgen;
 
    BOOST_LOG_SEV(lg, debug) << operation_desc << ".";
 
    const auto r = session(ctx.connection_pool())
        .and_then(begin_transaction)
        .and_then(query)
        .and_then(commit);
    ensure_success(r, lg);
 
    BOOST_LOG_SEV(lg, debug) << "Finished " << operation_desc << ".";
}
 
std::vector<std::string> execute_raw_string_query(context ctx,
    const std::string& sql, logging::logger_t& lg,
    const std::string& operation_desc);
 
std::map<std::string, std::vector<std::string>> execute_raw_grouped_query(
    context ctx, const std::string& sql, logging::logger_t& lg,
    const std::string& operation_desc);
 
std::vector<std::vector<std::optional<std::string>>> execute_raw_multi_column_query(
    context ctx, const std::string& sql, logging::logger_t& lg,
    const std::string& operation_desc);
 
void execute_raw_command(context ctx, const std::string& sql,
    logging::logger_t& lg, const std::string& operation_desc);
 
std::vector<std::string> execute_parameterized_string_query(context ctx,
    const std::string& sql, const std::vector<std::string>& params,
    logging::logger_t& lg, const std::string& operation_desc);
 
std::vector<std::string> execute_parameterized_string_query(
    const sqlgen::postgres::Credentials& creds,
    const std::string& sql, const std::vector<std::string>& params,
    logging::logger_t& lg, const std::string& operation_desc);
 
std::vector<std::vector<std::optional<std::string>>> execute_raw_multi_column_query(
    const sqlgen::postgres::Credentials& creds,
    const std::string& sql, logging::logger_t& lg,
    const std::string& operation_desc);
 
void execute_parameterized_command(context ctx, const std::string& sql,
    const std::vector<std::string>& params, logging::logger_t& lg,
    const std::string& operation_desc);
 
std::vector<std::vector<std::optional<std::string>>> execute_parameterized_multi_column_query(
    context ctx, const std::string& sql, const std::vector<std::string>& params,
    logging::logger_t& lg, const std::string& operation_desc);
 
}
 
#endif