Query builder for building DELETE FROM ... queries. More...

#include <Delete.hpp>

Inheritance diagram for SqlDeleteQueryBuilder:

Public Member Functions
	SqlDeleteQueryBuilder (SqlQueryFormatter const &formatter, std::string table, std::string tableAlias) noexcept

SqlSearchCondition &	SearchCondition () noexcept

SqlQueryFormatter const &	Formatter () const noexcept

std::string	ToSql () const

Public Member Functions inherited from SqlWhereClauseBuilder< SqlDeleteQueryBuilder >
SqlDeleteQueryBuilder &	And () noexcept
	Indicates, that the next WHERE clause should be AND-ed (default).

SqlDeleteQueryBuilder &	Or () noexcept
	Indicates, that the next WHERE clause should be OR-ed.

SqlDeleteQueryBuilder &	Not () noexcept
	Indicates, that the next WHERE clause should be negated.

SqlDeleteQueryBuilder &	WhereRaw (std::string_view sqlConditionExpression)
	Constructs or extends a raw WHERE clause.

SqlDeleteQueryBuilder &	Where (ColumnName const &columnName, std::string_view binaryOp, T const &value)
	Constructs or extends a WHERE clause to test for a binary operation.

SqlDeleteQueryBuilder &	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.

SqlDeleteQueryBuilder &	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.

SqlDeleteQueryBuilder &	Where (ColumnName const &columnName, T const &value)
	Constructs or extends a WHERE clause to test for equality.

SqlDeleteQueryBuilder &	Where (Callable const &callable)
	Constructs or extends a WHERE/AND clause to test for a group of values.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	Where (ColumnName const &columnName, T const &value)

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	Where (Callable const &callable)

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	Where (ColumnName const &columnName, std::string_view binaryOp, char const(&value)[N])

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	Where (ColumnName const &columnName, std::string_view binaryOp, T const &value)

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	Where (ColumnName const &columnName, std::string_view binaryOp, SubSelectQuery const &value)

SqlDeleteQueryBuilder &	OrWhere (ColumnName const &columnName, std::string_view binaryOp, T const &value)
	Constructs or extends a WHERE/OR clause to test for a binary operation.

SqlDeleteQueryBuilder &	OrWhere (ColumnName const &columnName, T const &value)
	Constructs or extends an WHERE/OR clause to test for equality.

SqlDeleteQueryBuilder &	OrWhere (Callable const &callable)
	Constructs or extends an WHERE/OR clause to test for a group of values.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	OrWhere (ColumnName const &columnName, T const &value)

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	OrWhere (Callable const &callable)

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	OrWhere (ColumnName const &columnName, std::string_view binaryOp, T const &value)

SqlDeleteQueryBuilder &	WhereIn (ColumnName const &columnName, InputRange const &values)
	Constructs or extends an WHERE/OR clause to test for a value, satisfying std::ranges::input_range.

SqlDeleteQueryBuilder &	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.

SqlDeleteQueryBuilder &	WhereIn (ColumnName const &columnName, SubSelectQuery const &subSelectQuery)
	Constructs or extends an WHERE/OR clause to test for a value, satisfying a sub-select query.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereIn (ColumnName const &columnName, InputRange const &values)

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereIn (ColumnName const &columnName, std::initializer_list< T > const &values)

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereIn (ColumnName const &columnName, SubSelectQuery const &subSelectQuery)

SqlDeleteQueryBuilder &	WhereNull (ColumnName const &columnName)
	Constructs or extends an WHERE/OR clause to test for a value to be NULL.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereNull (ColumnName const &columnName)

SqlDeleteQueryBuilder &	WhereNotNull (ColumnName const &columnName)
	Constructs or extends a WHERE clause to test for a value being not null.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereNotNull (ColumnName const &columnName)

SqlDeleteQueryBuilder &	WhereNotEqual (ColumnName const &columnName, T const &value)
	Constructs or extends a WHERE clause to test for a value being equal to another column.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereNotEqual (ColumnName const &columnName, T const &value)

SqlDeleteQueryBuilder &	WhereTrue (ColumnName const &columnName)
	Constructs or extends a WHERE clause to test for a value being true.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereTrue (ColumnName const &columnName)

SqlDeleteQueryBuilder &	WhereFalse (ColumnName const &columnName)
	Constructs or extends a WHERE clause to test for a value being false.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereFalse (ColumnName const &columnName)

SqlDeleteQueryBuilder &	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.

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	WhereColumn (LeftColumn const &left, std::string_view binaryOp, RightColumn const &right)

SqlDeleteQueryBuilder &	InnerJoin (std::string_view joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn)
	Constructs an INNER JOIN clause.

SqlDeleteQueryBuilder &	InnerJoin (std::string_view joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn)
	Constructs an INNER JOIN clause.

SqlDeleteQueryBuilder &	InnerJoin (std::string_view joinTable, OnChainCallable const &onClauseBuilder)
	Constructs an INNER JOIN clause with a custom ON clause.

SqlDeleteQueryBuilder &	LeftOuterJoin (std::string_view joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn)
	Constructs an LEFT OUTER JOIN clause.

SqlDeleteQueryBuilder &	LeftOuterJoin (std::string_view joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn)
	Constructs an LEFT OUTER JOIN clause.

SqlDeleteQueryBuilder &	LeftOuterJoin (std::string_view joinTable, OnChainCallable const &onClauseBuilder)
	Constructs an LEFT OUTER JOIN clause with a custom ON clause.

SqlDeleteQueryBuilder &	RightOuterJoin (std::string_view joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn)
	Constructs an RIGHT OUTER JOIN clause.

SqlDeleteQueryBuilder &	RightOuterJoin (std::string_view joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn)
	Constructs an RIGHT OUTER JOIN clause.

SqlDeleteQueryBuilder &	RightOuterJoin (std::string_view joinTable, OnChainCallable const &onClauseBuilder)
	Constructs an RIGHT OUTER JOIN clause with a custom ON clause.

SqlDeleteQueryBuilder &	FullOuterJoin (std::string_view joinTable, std::string_view joinColumnName, SqlQualifiedTableColumnName onOtherColumn)
	Constructs an FULL OUTER JOIN clause.

SqlDeleteQueryBuilder &	FullOuterJoin (std::string_view joinTable, std::string_view joinColumnName, std::string_view onMainTableColumn)
	Constructs an FULL OUTER JOIN clause.

SqlDeleteQueryBuilder &	FullOuterJoin (std::string_view joinTable, OnChainCallable const &onClauseBuilder)
	Constructs an FULL OUTER JOIN clause with a custom ON clause.

LIGHTWEIGHT_FORCE_INLINE void	AppendColumnName (ColumnName const &columnName)

LIGHTWEIGHT_FORCE_INLINE void	AppendLiteralValue (LiteralType const &value)

LIGHTWEIGHT_FORCE_INLINE SqlDeleteQueryBuilder &	Join (JoinType joinType, std::string_view joinTable, Callable const &onClauseBuilder)

Detailed Description

Query builder for building DELETE FROM ... queries.

Definition at line 12 of file Delete.hpp.

Constructor & Destructor Documentation

◆ SqlDeleteQueryBuilder()

SqlDeleteQueryBuilder::SqlDeleteQueryBuilder	(	SqlQueryFormatter const &	formatter,
		std::string	table,
		std::string	tableAlias
	)

inlineexplicitnoexcept

Definition at line 15 of file Delete.hpp.

Member Function Documentation

◆ SearchCondition()

SqlSearchCondition & SqlDeleteQueryBuilder::SearchCondition ( )

inlinenoexcept

Definition at line 25 of file Delete.hpp.

◆ Formatter()

SqlQueryFormatter const & SqlDeleteQueryBuilder::Formatter ( ) const

inlinenoexcept

Definition at line 30 of file Delete.hpp.

◆ ToSql()

LIGHTWEIGHT_FORCE_INLINE std::string SqlDeleteQueryBuilder::ToSql ( ) const

inline

Definition at line 43 of file Delete.hpp.

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

Lightweight/SqlQuery/Delete.hpp