database::query::condition_builder Class Reference

Builds WHERE clause conditions with proper precedence. More...

#include <condition_builder.h>

Collaboration diagram for database::query::condition_builder:

Classes
struct	condition_node

Public Member Functions
	condition_builder ()
condition_builder &	add (const condition &cond, logical_op op=logical_op::AND)
	Add a condition.
condition_builder &	add (const std::string &field, const std::string &operator_, const core::database_value &value, logical_op op=logical_op::AND)
	Add a simple condition.
condition_builder &	add_raw (const std::string &raw, logical_op op=logical_op::AND)
	Add a raw SQL condition.
condition_builder &	begin_group ()
	Begin a condition group (adds opening parenthesis)
condition_builder &	end_group ()
	End a condition group (adds closing parenthesis)
std::string	build (const value_formatter &formatter) const
	Build the WHERE clause.
bool	empty () const
	Check if builder is empty.
void	clear ()
	Clear all conditions.

Private Member Functions
std::string	format_condition (const condition &cond, const value_formatter &formatter) const
std::string	logical_op_to_string (logical_op op) const

Private Attributes
std::vector< condition_node >	nodes_
int	current_group_level_

Detailed Description

Builds WHERE clause conditions with proper precedence.

Features:

• Supports AND/OR logical operators
• Nested condition grouping with parentheses
• Raw SQL conditions
• Automatic precedence handling

Examples:

condition_builder builder;
 
// Simple condition: status = 'active'
builder.add({"status", "=", std::string("active")});
 
// Complex: status = 'active' AND (age > 18 OR verified = true)
builder.add({"status", "=", std::string("active")})
       .begin_group()
       .add({"age", ">", 18}, logical_op::AND)
       .add({"verified", "=", true}, logical_op::OR)
       .end_group();
 
// Build with formatter
value_formatter fmt(database_types::PostgreSQL);
std::string where_clause = builder.build(fmt);

Thread Safety:

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

Definition at line 70 of file condition_builder.h.

Constructor & Destructor Documentation

condition_builder()

database::query::condition_builder::condition_builder

(

)

Definition at line 10 of file condition_builder.cpp.

    : current_group_level_(0) {}

Member Function Documentation

add() [1/2]

condition_builder & database::query::condition_builder::add	(	const condition &	cond,
		logical_op	op = logical_op::AND )

Add a condition.

Parameters

cond	Condition to add
op	Logical operator (AND/OR)

Returns

Reference to this builder

Definition at line 13 of file condition_builder.cpp.

                                                                              {
    condition_node node;
    node.cond = cond;
    node.op = op;
    node.group_level = current_group_level_;
    node.is_group_start = false;
    node.is_group_end = false;
    nodes_.push_back(node);
    return *this;
}

References database::query::condition_builder::condition_node::cond, current_group_level_, database::query::condition_builder::condition_node::group_level, database::query::condition_builder::condition_node::is_group_end, database::query::condition_builder::condition_node::is_group_start, nodes_, and database::query::condition_builder::condition_node::op.

Referenced by add(), and add_raw().

Here is the caller graph for this function:

add() [2/2]

condition_builder & database::query::condition_builder::add	(	const std::string &	field,
		const std::string &	operator_,
		const core::database_value &	value,
		logical_op	op = logical_op::AND )

Add a simple condition.

Parameters

field	Field name
operator_	Comparison operator
value	Value to compare
op	Logical operator (AND/OR)

Returns

Reference to this builder

Definition at line 24 of file condition_builder.cpp.

                                                                                         {
    condition cond;
    cond.field = field;
    cond.op = operator_;
    cond.value = value;
    return add(cond, op);
}

References add(), database::query::condition::field, database::query::condition::op, and database::query::condition::value.

Here is the call graph for this function:

add_raw()

condition_builder & database::query::condition_builder::add_raw	(	const std::string &	raw,
		logical_op	op = logical_op::AND )

Add a raw SQL condition.

Parameters

raw	Raw SQL condition
op	Logical operator (AND/OR)

Returns

Reference to this builder

Definition at line 33 of file condition_builder.cpp.

                                                                                 {
    condition cond;
    cond.raw = raw;
    return add(cond, op);
}

References add(), and database::query::condition::raw.

Here is the call graph for this function:

begin_group()

condition_builder & database::query::condition_builder::begin_group

(

)

Begin a condition group (adds opening parenthesis)

Returns

Reference to this builder

Definition at line 39 of file condition_builder.cpp.

                                                  {
    condition_node node;
    node.group_level = current_group_level_;
    node.is_group_start = true;
    node.is_group_end = false;
    node.op = logical_op::AND;  // Default, will be overridden
    nodes_.push_back(node);
 
    current_group_level_++;
    return *this;
}

References database::query::AND, current_group_level_, database::query::condition_builder::condition_node::group_level, database::query::condition_builder::condition_node::is_group_end, database::query::condition_builder::condition_node::is_group_start, nodes_, and database::query::condition_builder::condition_node::op.

build()

std::string database::query::condition_builder::build

(

const value_formatter &

formatter

)

const

Build the WHERE clause.

Parameters

formatter

Value formatter for this database

Returns

SQL WHERE clause (without "WHERE" keyword)

Definition at line 65 of file condition_builder.cpp.

                                                                         {
    if (nodes_.empty()) {
        return "";
    }
 
    std::ostringstream oss;
    bool first = true;
 
    for (const auto& node : nodes_) {
        if (node.is_group_start) {
            if (!first) {
                oss << " " << logical_op_to_string(node.op) << " ";
            }
            oss << "(";
            first = true;
            continue;
        }
 
        if (node.is_group_end) {
            oss << ")";
            first = false;
            continue;
        }
 
        if (!first) {
            oss << " " << logical_op_to_string(node.op) << " ";
        }
 
        oss << format_condition(node.cond, formatter);
        first = false;
    }
 
    return oss.str();
}

References format_condition(), logical_op_to_string(), and nodes_.

Here is the call graph for this function:

clear()

void database::query::condition_builder::clear

(

)

Clear all conditions.

Definition at line 104 of file condition_builder.cpp.

                              {
    nodes_.clear();
    current_group_level_ = 0;
}

References current_group_level_, and nodes_.

empty()

bool database::query::condition_builder::empty

(

)

const

Check if builder is empty.

Returns

true if no conditions added

Definition at line 100 of file condition_builder.cpp.

                                    {
    return nodes_.empty();
}

References nodes_.

end_group()

condition_builder & database::query::condition_builder::end_group

(

)

End a condition group (adds closing parenthesis)

Returns

Reference to this builder

Definition at line 51 of file condition_builder.cpp.

                                                {
    if (current_group_level_ > 0) {
        current_group_level_--;
 
        condition_node node;
        node.group_level = current_group_level_;
        node.is_group_start = false;
        node.is_group_end = true;
        node.op = logical_op::AND;
        nodes_.push_back(node);
    }
    return *this;
}

References database::query::AND, current_group_level_, database::query::condition_builder::condition_node::group_level, database::query::condition_builder::condition_node::is_group_end, database::query::condition_builder::condition_node::is_group_start, nodes_, and database::query::condition_builder::condition_node::op.

format_condition()

std::string database::query::condition_builder::format_condition ( const condition & cond, const value_formatter & formatter ) const

private

Definition at line 109 of file condition_builder.cpp.

                                                                                       {
    if (cond.is_raw()) {
        return cond.raw;
    }
 
    std::ostringstream oss;
    oss << formatter.escape_identifier(cond.field) << " " << cond.op << " ";
 
    // Handle special operators
    if (cond.op == "IS NULL" || cond.op == "IS NOT NULL") {
        // No value needed
        return formatter.escape_identifier(cond.field) + " " + cond.op;
    }
 
    oss << formatter.format(cond.value);
    return oss.str();
}

References database::query::value_formatter::escape_identifier(), database::query::condition::field, database::query::value_formatter::format(), database::query::condition::is_raw(), database::query::condition::op, database::query::condition::raw, and database::query::condition::value.

Referenced by build().

Here is the call graph for this function:

Here is the caller graph for this function:

logical_op_to_string()

std::string database::query::condition_builder::logical_op_to_string ( logical_op op ) const

private

Definition at line 128 of file condition_builder.cpp.

                                                                     {
    switch (op) {
        case logical_op::AND:
            return "AND";
        case logical_op::OR:
            return "OR";
        default:
            return "AND";
    }
}

References database::query::AND, and database::query::OR.

Referenced by build().

Here is the caller graph for this function:

Member Data Documentation

current_group_level_

int database::query::condition_builder::current_group_level_

private

Definition at line 141 of file condition_builder.h.

Referenced by add(), begin_group(), clear(), and end_group().

nodes_

std::vector<condition_node> database::query::condition_builder::nodes_

private

Definition at line 140 of file condition_builder.h.

Referenced by add(), begin_group(), build(), clear(), empty(), and end_group().

---

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

• database/query_builder/condition_builder.h
• database/query_builder/condition_builder.cpp