Inherited by Lightweight::SqlBasicSelectQueryBuilder< SqlAllFieldsQueryBuilder< Record, QueryOptions > >, Lightweight::SqlBasicSelectQueryBuilder< SqlAllFieldsQueryBuilder< std::tuple< FirstRecord, SecondRecord >, QueryOptions > >, Lightweight::SqlBasicSelectQueryBuilder< SqlSelectQueryBuilder >, and Lightweight::SqlBasicSelectQueryBuilder< Derived >.
|
| Derived & | And () noexcept |
| | Indicates, that the next WHERE clause should be AND-ed (default).
|
| |
| Derived & | Or () noexcept |
| | Indicates, that the next WHERE clause should be OR-ed.
|
| |
| Derived & | Not () noexcept |
| | Indicates, that the next WHERE clause should be negated.
|
| |
| Derived & | WhereRaw (std::string_view sqlConditionExpression) |
| | Constructs or extends a raw WHERE clause.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, T const &value) |
| | Constructs or extends a WHERE clause to test for a binary operation.
|
| |
template<typename ColumnName , typename SubSelectQuery >
requires (std::is_invocable_r_v<std::string, decltype(&SubSelectQuery::ToSql), SubSelectQuery const&>) |
| Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, SubSelectQuery const &value) |
| | Constructs or extends a WHERE clause to test for a binary operation for RHS as sub-select query.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | OrWhere (ColumnName const &columnName, std::string_view binaryOp, T const &value) |
| | Constructs or extends a WHERE/OR clause to test for a binary operation.
|
| |
|
template<typename ColumnName , std::size_t N> |
| Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, char const (&value)[N]) |
| | Constructs or extends a WHERE clause to test for a binary operation for RHS as string literal.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | Where (ColumnName const &columnName, T const &value) |
| | Constructs or extends a WHERE clause to test for equality.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | OrWhere (ColumnName const &columnName, T const &value) |
| | Constructs or extends an WHERE/OR clause to test for equality.
|
| |
template<typename Callable >
requires std::invocable<Callable, SqlWhereClauseBuilder<Derived>&> |
| Derived & | Where (Callable const &callable) |
| | Constructs or extends a WHERE/AND clause to test for a group of values.
|
| |
template<typename Callable >
requires std::invocable<Callable, SqlWhereClauseBuilder<Derived>&> |
| Derived & | OrWhere (Callable const &callable) |
| | Constructs or extends an WHERE/OR clause to test for a group of values.
|
| |
|
template<typename ColumnName , std::ranges::input_range InputRange> |
| Derived & | WhereIn (ColumnName const &columnName, InputRange const &values) |
| | Constructs or extends an WHERE/OR clause to test for a value, satisfying std::ranges::input_range.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | WhereIn (ColumnName const &columnName, std::initializer_list< T > const &values) |
| | Constructs or extends an WHERE/OR clause to test for a value, satisfying std::initializer_list.
|
| |
template<typename ColumnName , typename SubSelectQuery >
requires (std::is_invocable_r_v<std::string, decltype(&SubSelectQuery::ToSql), SubSelectQuery const&>) |
| Derived & | WhereIn (ColumnName const &columnName, SubSelectQuery const &subSelectQuery) |
| | Constructs or extends an WHERE/OR clause to test for a value, satisfying a sub-select query.
|
| |
|
template<typename ColumnName > |
| Derived & | WhereNull (ColumnName const &columnName) |
| | Constructs or extends an WHERE/OR clause to test for a value to be NULL.
|
| |
|
template<typename ColumnName > |
| Derived & | WhereNotNull (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being not null.
|
| |
|
template<typename ColumnName , typename T > |
| Derived & | WhereNotEqual (ColumnName const &columnName, T const &value) |
| | Constructs or extends a WHERE clause to test for a value being equal to another column.
|
| |
|
template<typename ColumnName > |
| Derived & | WhereTrue (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being true.
|
| |
|
template<typename ColumnName > |
| Derived & | WhereFalse (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being false.
|
| |
|
template<typename LeftColumn , typename RightColumn > |
| Derived & | WhereColumn (LeftColumn const &left, std::string_view binaryOp, RightColumn const &right) |
| | Construts or extends a WHERE clause to test for a binary operation between two columns.
|
| |
| Derived & | InnerJoin (TableName auto joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| |
| Derived & | InnerJoin (TableName auto joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn) |
| | Constructs an INNER JOIN clause.
|
| |
template<typename OnChainCallable >
requires std::invocable<OnChainCallable, SqlJoinConditionBuilder> |
| Derived & | InnerJoin (TableName auto joinTable, OnChainCallable const &onClauseBuilder) |
| | Constructs an INNER JOIN clause with a custom ON clause.
|
| |
| template<auto LeftField, auto RightField> |
| Derived & | InnerJoin () |
| |
| Derived & | LeftOuterJoin (TableName auto joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Constructs an LEFT OUTER JOIN clause.
|
| |
| Derived & | LeftOuterJoin (TableName auto joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn) |
| | Constructs an LEFT OUTER JOIN clause.
|
| |
template<typename OnChainCallable >
requires std::invocable<OnChainCallable, SqlJoinConditionBuilder> |
| Derived & | LeftOuterJoin (TableName auto joinTable, OnChainCallable const &onClauseBuilder) |
| | Constructs an LEFT OUTER JOIN clause with a custom ON clause.
|
| |
| Derived & | RightOuterJoin (TableName auto joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Constructs an RIGHT OUTER JOIN clause.
|
| |
| Derived & | RightOuterJoin (TableName auto joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn) |
| | Constructs an RIGHT OUTER JOIN clause.
|
| |
template<typename OnChainCallable >
requires std::invocable<OnChainCallable, SqlJoinConditionBuilder> |
| Derived & | RightOuterJoin (TableName auto joinTable, OnChainCallable const &onClauseBuilder) |
| | Constructs an RIGHT OUTER JOIN clause with a custom ON clause.
|
| |
| Derived & | FullOuterJoin (TableName auto joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn) |
| | Constructs an FULL OUTER JOIN clause.
|
| |
| Derived & | FullOuterJoin (TableName auto joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn) |
| | Constructs an FULL OUTER JOIN clause.
|
| |
template<typename OnChainCallable >
requires std::invocable<OnChainCallable, SqlJoinConditionBuilder> |
| Derived & | FullOuterJoin (TableName auto joinTable, OnChainCallable const &onClauseBuilder) |
| | Constructs an FULL OUTER JOIN clause with a custom ON clause.
|
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (ColumnName const &columnName, T const &value) |
| | Constructs or extends a WHERE clause to test for equality.
|
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | OrWhere (ColumnName const &columnName, T const &value) |
| | Constructs or extends a WHERE/OR clause to test for equality.
|
| |
template<typename Callable >
requires std::invocable<Callable, SqlWhereClauseBuilder<Derived>&> |
| LIGHTWEIGHT_FORCE_INLINE Derived & | OrWhere (Callable const &callable) |
| | Constructs or extends a WHERE/OR clause to test for a group of values.
|
| |
template<typename Callable >
requires std::invocable<Callable, SqlWhereClauseBuilder<Derived>&> |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (Callable const &callable) |
| | Constructs or extends a WHERE/AND clause to test for a group of values.
|
| |
| template<typename ColumnName , std::ranges::input_range InputRange> |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereIn (ColumnName const &columnName, InputRange const &values) |
| | Constructs or extends a WHERE IN clause with an input range.
|
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereIn (ColumnName const &columnName, std::initializer_list< T > const &values) |
| | Constructs or extends a WHERE IN clause with an initializer list.
|
| |
template<typename ColumnName , typename SubSelectQuery >
requires (std::is_invocable_r_v<std::string, decltype(&SubSelectQuery::ToSql), SubSelectQuery const&>) |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereIn (ColumnName const &columnName, SubSelectQuery const &subSelectQuery) |
| | Constructs or extends a WHERE IN clause with a sub-select query.
|
| |
| template<typename ColumnName > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereNotNull (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being not null.
|
| |
| template<typename ColumnName > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereNull (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being null.
|
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereNotEqual (ColumnName const &columnName, T const &value) |
| | Constructs or extends a WHERE clause to test for inequality.
|
| |
| template<typename ColumnName > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereTrue (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being true.
|
| |
| template<typename ColumnName > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereFalse (ColumnName const &columnName) |
| | Constructs or extends a WHERE clause to test for a value being false.
|
| |
| template<typename LeftColumn , typename RightColumn > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | WhereColumn (LeftColumn const &left, std::string_view binaryOp, RightColumn const &right) |
| | Constructs or extends a WHERE clause to compare two columns.
|
| |
| template<typename ColumnName , std::size_t N> |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, char const (&value)[N]) |
| | Constructs or extends a WHERE clause with a string literal value.
|
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, T const &value) |
| | Constructs or extends a WHERE clause to test for a binary operation.
|
| |
template<typename ColumnName , typename SubSelectQuery >
requires (std::is_invocable_r_v<std::string, decltype(&SubSelectQuery::ToSql), SubSelectQuery const&>) |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Where (ColumnName const &columnName, std::string_view binaryOp, SubSelectQuery const &value) |
| | Constructs or extends a WHERE clause with a sub-select query.
|
| |
| template<typename ColumnName , typename T > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | OrWhere (ColumnName const &columnName, std::string_view binaryOp, T const &value) |
| | Constructs or extends a WHERE/OR clause with a binary operation.
|
| |
template<typename ColumnName >
requires (std::same_as<ColumnName, SqlQualifiedTableColumnName> || std::convertible_to<ColumnName, std::string_view> || std::same_as<ColumnName, SqlRawColumnNameView> || std::convertible_to<ColumnName, std::string>) |
| LIGHTWEIGHT_FORCE_INLINE void | AppendColumnName (ColumnName const &columnName) |
| | Appends a column name to the WHERE condition.
|
| |
| template<typename LiteralType > |
| LIGHTWEIGHT_FORCE_INLINE void | AppendLiteralValue (LiteralType const &value) |
| | Appends a literal value to the WHERE condition.
|
| |
| template<typename LiteralType , typename TargetType > |
| LIGHTWEIGHT_FORCE_INLINE void | PopulateLiteralValueInto (LiteralType const &value, TargetType &target) |
| | Populates a literal value into the target string.
|
| |
| template<typename Callable > |
| LIGHTWEIGHT_FORCE_INLINE Derived & | Join (JoinType joinType, TableName auto joinTable, Callable const &onClauseBuilder) |
| | Constructs a JOIN clause with a custom ON clause builder.
|
| |
1.9.8