immutable_query_builder.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 "../database_types.h"
#include "../query_builder.h"
#include <string>
#include <vector>
#include <map>
#include <optional>
#include <memory>
 
namespace database
{
    class immutable_query_builder
    {
    public:
        explicit immutable_query_builder(const std::string& table);
 
        immutable_query_builder select(std::vector<std::string> fields) const;
 
        immutable_query_builder where(const std::string& field, const std::string& op, const core::database_value& value) const;
 
        immutable_query_builder where(const query_condition& condition) const;
 
        immutable_query_builder order_by(const std::string& field, sort_order order = sort_order::asc) const;
 
        immutable_query_builder limit(uint32_t count) const;
 
        immutable_query_builder offset(uint32_t count) const;
 
        immutable_query_builder join(const std::string& table, const std::string& condition, join_type type = join_type::inner) const;
 
        immutable_query_builder group_by(std::vector<std::string> fields) const;
 
        immutable_query_builder having(const std::string& condition) const;
 
        std::string build() const;
 
        std::string build_for_database(database_types db_type) const;
 
    private:
        // All fields are const - immutable state
        const std::string table_;
        const std::vector<std::string> select_fields_;
        const std::vector<query_condition> conditions_;
        const std::vector<std::pair<std::string, sort_order>> order_by_;
        const std::optional<uint32_t> limit_;
        const std::optional<uint32_t> offset_;
        const std::vector<std::tuple<std::string, std::string, join_type>> joins_;
        const std::vector<std::string> group_by_fields_;
        const std::string having_clause_;
 
        // Private constructor for internal use (copy with modification)
        immutable_query_builder(
            std::string table,
            std::vector<std::string> select_fields,
            std::vector<query_condition> conditions,
            std::vector<std::pair<std::string, sort_order>> order_by,
            std::optional<uint32_t> limit,
            std::optional<uint32_t> offset,
            std::vector<std::tuple<std::string, std::string, join_type>> joins,
            std::vector<std::string> group_by_fields,
            std::string having_clause
        );
 
        // Helper methods
        std::string escape_identifier(const std::string& identifier, database_types db_type) const;
        std::string format_value(const core::database_value& value, database_types db_type) const;
        std::string join_type_to_string(join_type type) const;
    };
 
} // namespace database