database_manager.h

Go to the documentation of this file.

// BSD 3-Clause License
// Copyright (c) 2025, 🍀☀🌕🌥 🌊
// See the LICENSE file in the project root for full license information.
 
#pragma once
 
#include <memory>
#include <mutex>
 
// Use unified Result<T> implementation from common_system
#include <kcenon/common/patterns/result.h>
#include "core/database_context.h"
#include "core/database_backend.h"
#include "core/backend_registry.h"
 
#include "query_builder.h"
 
 
namespace database
{
    class database_manager
    {
    public:
        explicit database_manager(std::shared_ptr<database_context> context);
 
        virtual ~database_manager();
 
        bool set_mode(const database_types& database_type);
 
        database_types database_type(void);
 
 
        query_builder create_query_builder();
 
        query_builder create_query_builder(database_types db_type);
 
        kcenon::common::VoidResult connect_result(const std::string& connect_string);
 
        kcenon::common::VoidResult disconnect_result();
 
        kcenon::common::VoidResult create_query_result(const std::string& query_string);
 
        // Result-based query methods
 
        kcenon::common::Result<core::database_result> select_query_result(const std::string& query_string);
 
        kcenon::common::VoidResult execute_query_result(const std::string& query_string);
 
        // Transaction support (new API)
 
        kcenon::common::VoidResult begin_transaction();
 
        kcenon::common::VoidResult commit_transaction();
 
        kcenon::common::VoidResult rollback_transaction();
 
        bool in_transaction() const;
 
        std::string last_error() const;
 
        std::map<std::string, std::string> connection_info() const;
 
    private:
        bool connected_; 
        std::unique_ptr<core::database_backend>
            database_;   
        std::shared_ptr<database_context> context_; 
        std::string connect_string_; 
 
    };
} // namespace database