|
| | SqlJoinConditionBuilder (std::string_view referenceTable, SqlSearchCondition *searchCondition, SqlQueryFormatter const *formatter) noexcept |
| |
| SqlJoinConditionBuilder & | On (std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Adds an AND join condition.
|
| |
| SqlJoinConditionBuilder & | OrOn (std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Adds an OR join condition.
|
| |
| SqlJoinConditionBuilder & | Operator (std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn, std::string_view op) |
| | Adds a join condition with a custom operator.
|
| |
| template<typename T > |
| SqlJoinConditionBuilder & | OnValue (std::string_view joinColumnName, T const &value) |
| |
| template<typename T > |
| SqlJoinConditionBuilder & | OnValue (std::string_view joinColumnName, std::string_view binaryOp, T const &value) |
| | Adds an AND join condition testing the joined column against value with binaryOp.
|
| |
| template<typename T > |
| SqlJoinConditionBuilder & | OrOnValue (std::string_view joinColumnName, T const &value) |
| | Adds an OR join condition testing the joined column against value for equality.
|
| |
| template<typename T > |
| SqlJoinConditionBuilder & | OrOnValue (std::string_view joinColumnName, std::string_view binaryOp, T const &value) |
| | Adds an OR join condition testing the joined column against value with binaryOp.
|
| |
| SqlJoinConditionBuilder & | OnNull (std::string_view joinColumnName) |
| | Adds an AND join condition testing the joined column for NULL.
|
| |
| SqlJoinConditionBuilder & | OnNotNull (std::string_view joinColumnName) |
| | Adds an AND join condition testing the joined column for NOT NULL.
|
| |
| SqlJoinConditionBuilder & | OrOnNull (std::string_view joinColumnName) |
| | Adds an OR join condition testing the joined column for NULL.
|
| |
| SqlJoinConditionBuilder & | OrOnNotNull (std::string_view joinColumnName) |
| | Adds an OR join condition testing the joined column for NOT NULL.
|
| |
template<typename Callable >
requires std::invocable<Callable, SqlJoinConditionBuilder&> |
| SqlJoinConditionBuilder & | OnGroup (Callable const &build) |
| |
template<typename Callable >
requires std::invocable<Callable, SqlJoinConditionBuilder&> |
| SqlJoinConditionBuilder & | OrOnGroup (Callable const &build) |
| | Adds an OR group of join conditions, in parentheses.
|
| |
Query builder for building JOIN conditions.
An ON clause can say what a WHERE clause can: compare the joined table's column against another table's column or against a value, test it for null, and group terms in parentheses. The distinction matters for an outer join, where moving a term from the ON clause to the WHERE clause turns the join into an inner one.
Definition at line 170 of file Core.hpp.
1.9.8