helpers.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_HELPERS_HPP
#define ORES_DATABASE_REPOSITORY_HELPERS_HPP
 
#include <string>
#include <format>
#include <boost/exception/diagnostic_information.hpp>
#include <sqlgen/postgres.hpp>
#include "ores.utility/log/make_logger.hpp"
#include "ores.database/repository/repository_exception.hpp"
 
namespace ores::database::repository {
 
inline constexpr const char* MAX_TIMESTAMP = "9999-12-31 23:59:59";
 
template<typename T>
void ensure_success(const T& result, utility::log::logger_t& lg) {
    using namespace ores::utility::log;
 
    if (!result) {
        BOOST_LOG_SEV(lg, error) << result.error().what();
        BOOST_THROW_EXCEPTION(
            repository_exception(std::format("Repository error: {}",
                    result.error().what())));
    }
}
 
inline auto make_timestamp(const std::string& s, utility::log::logger_t& lg) {
    using namespace ores::utility::log;
 
    const auto r = sqlgen::Timestamp<"%Y-%m-%d %H:%M:%S">::from_string(s);
    if (!r) {
        BOOST_LOG_SEV(lg, error) << "Error converting timestamp: '" << s
                                 << "'. Error: " << r.error().what();
        BOOST_THROW_EXCEPTION(
            repository_exception(
                std::format("Timestamp conversion error: {}", s)));
    }
    return r;
}
 
template<typename EntityType>
std::string generate_create_table_sql(utility::log::logger_t& lg) {
    using namespace ores::utility::log;
    using namespace sqlgen;
 
    const auto query = create_table<EntityType> | if_not_exists;
    const auto sql = postgres::to_sql(query);
 
    BOOST_LOG_SEV(lg, debug) << sql;
 
    return sql;
}
 
}
 
#endif