join_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 "value_formatter.h"
#include <string>
#include <vector>
 
namespace database::query {
 
enum class join_type {
    inner,      
    left,       
    right,      
    full_outer, 
    cross       
};
 
struct join_spec {
    std::string table;       
    std::string condition;   
    join_type type;          
    std::string alias;       
};
 
class join_builder {
public:
    join_builder();
 
    join_builder& join(const std::string& table, const std::string& condition,
                       const std::string& alias = "");
 
    join_builder& left_join(const std::string& table, const std::string& condition,
                            const std::string& alias = "");
 
    join_builder& right_join(const std::string& table, const std::string& condition,
                             const std::string& alias = "");
 
    join_builder& full_outer_join(const std::string& table, const std::string& condition,
                                   const std::string& alias = "");
 
    join_builder& cross_join(const std::string& table, const std::string& alias = "");
 
    join_builder& add(const join_spec& spec);
 
    std::string build(const value_formatter& formatter) const;
 
    bool empty() const;
 
    void clear();
 
    size_t size() const;
 
private:
    std::vector<join_spec> joins_;
 
    std::string join_type_to_string(join_type type) const;
};
 
} // namespace database::query