database::query::join_builder Class Reference

Builds JOIN clauses for SQL queries. More...

#include <join_builder.h>

Collaboration diagram for database::query::join_builder:

Public Member Functions
	join_builder ()
join_builder &	join (const std::string &table, const std::string &condition, const std::string &alias="")
	Add an INNER JOIN.
join_builder &	left_join (const std::string &table, const std::string &condition, const std::string &alias="")
	Add a LEFT JOIN.
join_builder &	right_join (const std::string &table, const std::string &condition, const std::string &alias="")
	Add a RIGHT JOIN.
join_builder &	full_outer_join (const std::string &table, const std::string &condition, const std::string &alias="")
	Add a FULL OUTER JOIN.
join_builder &	cross_join (const std::string &table, const std::string &alias="")
	Add a CROSS JOIN.
join_builder &	add (const join_spec &spec)
	Add a join with explicit type.
std::string	build (const value_formatter &formatter) const
	Build the JOIN clauses.
bool	empty () const
	Check if builder is empty.
void	clear ()
	Clear all joins.
size_t	size () const
	Get number of joins.

Private Member Functions
std::string	join_type_to_string (join_type type) const

Private Attributes
std::vector< join_spec >	joins_

Detailed Description

Builds JOIN clauses for SQL queries.

Features:

• Multiple JOIN types (INNER, LEFT, RIGHT, FULL OUTER, CROSS)
• Table aliasing
• Multiple joins chaining

Example:

join_builder builder;
 
// Simple join
builder.join("orders", "users.id = orders.user_id");
 
// Left join with alias
builder.left_join("products", "orders.product_id = products.id", "p");
 
// Build the JOIN clauses
value_formatter fmt(database_types::postgres);
std::string joins = builder.build(fmt);
// Result: "INNER JOIN orders ON users.id = orders.user_id
//          LEFT JOIN products AS p ON orders.product_id = products.id"

Thread Safety:

• NOT thread-safe (stateful builder pattern)
• Each thread should use separate instance

Definition at line 65 of file join_builder.h.

Constructor & Destructor Documentation

join_builder()

database::query::join_builder::join_builder ( )

default

References add(), build(), clear(), cross_join(), empty(), full_outer_join(), join(), join_builder(), left_join(), right_join(), and size().

Referenced by join_builder().

Here is the call graph for this function:

Here is the caller graph for this function:

Member Function Documentation

add()

join_builder & database::query::join_builder::add

(

const join_spec &

spec

)

Add a join with explicit type.

Parameters

spec	Join specification

Returns

Reference to this builder

Definition at line 41 of file join_builder.cpp.

                                                     {
    joins_.push_back(spec);
    return *this;
}

References joins_.

Referenced by join_builder().

Here is the caller graph for this function:

build()

std::string database::query::join_builder::build

(

const value_formatter &

formatter

)

const

Build the JOIN clauses.

Parameters

formatter

Value formatter for escaping identifiers

Returns

SQL JOIN clauses

Definition at line 46 of file join_builder.cpp.

                                                                    {
    if (joins_.empty()) {
        return "";
    }
 
    std::ostringstream oss;
    for (size_t i = 0; i < joins_.size(); ++i) {
        const auto& join = joins_[i];
 
        if (i > 0) {
            oss << " ";
        }
 
        oss << join_type_to_string(join.type) << " JOIN ";
        oss << formatter.escape_identifier(join.table);
 
        if (!join.alias.empty()) {
            oss << " AS " << formatter.escape_identifier(join.alias);
        }
 
        if (join.type != join_type::cross && !join.condition.empty()) {
            oss << " ON " << join.condition;
        }
    }
 
    return oss.str();
}

References database::query::cross, empty(), database::query::value_formatter::escape_identifier(), join(), join_type_to_string(), and joins_.

Referenced by join_builder().

Here is the call graph for this function:

Here is the caller graph for this function:

clear()

void database::query::join_builder::clear

(

)

Clear all joins.

Definition at line 78 of file join_builder.cpp.

                         {
    joins_.clear();
}

References joins_.

Referenced by join_builder().

Here is the caller graph for this function:

cross_join()

join_builder & database::query::join_builder::cross_join	(	const std::string &	table,
		const std::string &	alias = "" )

Add a CROSS JOIN.

Parameters

table	Table to join
alias	Optional table alias

Returns

Reference to this builder

Definition at line 36 of file join_builder.cpp.

                                                                                     {
    joins_.push_back({table, "", join_type::cross, alias});
    return *this;
}

References database::query::cross, and joins_.

Referenced by join_builder().

Here is the caller graph for this function:

empty()

bool database::query::join_builder::empty

(

)

const

Check if builder is empty.

Returns

true if no joins added

Definition at line 74 of file join_builder.cpp.

                               {
    return joins_.empty();
}

References joins_.

Referenced by build(), and join_builder().

Here is the caller graph for this function:

full_outer_join()

join_builder & database::query::join_builder::full_outer_join	(	const std::string &	table,
		const std::string &	condition,
		const std::string &	alias = "" )

Add a FULL OUTER JOIN.

Parameters

table	Table to join
condition	ON condition
alias	Optional table alias

Returns

Reference to this builder

Definition at line 30 of file join_builder.cpp.

                                                                     {
    joins_.push_back({table, condition, join_type::full_outer, alias});
    return *this;
}

References database::query::full_outer, and joins_.

Referenced by join_builder().

Here is the caller graph for this function:

join()

join_builder & database::query::join_builder::join	(	const std::string &	table,
		const std::string &	condition,
		const std::string &	alias = "" )

Add an INNER JOIN.

Parameters

table	Table to join
condition	ON condition
alias	Optional table alias

Returns

Reference to this builder

Definition at line 12 of file join_builder.cpp.

                                                          {
    joins_.push_back({table, condition, join_type::inner, alias});
    return *this;
}

References database::query::inner, and joins_.

Referenced by build(), and join_builder().

Here is the caller graph for this function:

join_type_to_string()

std::string database::query::join_builder::join_type_to_string ( join_type type ) const

private

Definition at line 86 of file join_builder.cpp.

                                                                {
    switch (type) {
        case join_type::inner:
            return "INNER";
        case join_type::left:
            return "LEFT";
        case join_type::right:
            return "RIGHT";
        case join_type::full_outer:
            return "FULL OUTER";
        case join_type::cross:
            return "CROSS";
        default:
            return "INNER";
    }
}

References database::query::cross, database::query::full_outer, database::query::inner, database::query::left, and database::query::right.

Referenced by build().

Here is the caller graph for this function:

left_join()

join_builder & database::query::join_builder::left_join	(	const std::string &	table,
		const std::string &	condition,
		const std::string &	alias = "" )

Add a LEFT JOIN.

Parameters

table	Table to join
condition	ON condition
alias	Optional table alias

Returns

Reference to this builder

Definition at line 18 of file join_builder.cpp.

                                                               {
    joins_.push_back({table, condition, join_type::left, alias});
    return *this;
}

References joins_, and database::query::left.

Referenced by join_builder().

Here is the caller graph for this function:

right_join()

join_builder & database::query::join_builder::right_join	(	const std::string &	table,
		const std::string &	condition,
		const std::string &	alias = "" )

Add a RIGHT JOIN.

Parameters

table	Table to join
condition	ON condition
alias	Optional table alias

Returns

Reference to this builder

Definition at line 24 of file join_builder.cpp.

                                                                {
    joins_.push_back({table, condition, join_type::right, alias});
    return *this;
}

References joins_, and database::query::right.

Referenced by join_builder().

Here is the caller graph for this function:

size()

size_t database::query::join_builder::size

(

)

const

Get number of joins.

Returns

Number of joins added

Definition at line 82 of file join_builder.cpp.

                                {
    return joins_.size();
}

References joins_.

Referenced by join_builder().

Here is the caller graph for this function:

Member Data Documentation

joins_

std::vector<join_spec> database::query::join_builder::joins_

private

Definition at line 149 of file join_builder.h.

Referenced by add(), build(), clear(), cross_join(), empty(), full_outer_join(), join(), left_join(), right_join(), and size().

---

The documentation for this class was generated from the following files:

• database/query_builder/join_builder.h
• database/query_builder/join_builder.cpp