Query builder for building SELECT ... queries. More...

#include <Select.hpp>

Inherits SqlBasicSelectQueryBuilder< Derived >.

Public Types
using	SelectType = detail::SelectType

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

constexpr LIGHTWEIGHT_FORCE_INLINE SqlSelectQueryBuilder &	Varying () noexcept
	Sets the builder mode to Varying, allowing varying final query types.

template<typename... MoreFields>
SqlSelectQueryBuilder &	Fields (std::string_view const &firstField, MoreFields &&... moreFields)
	Adds a sequence of columns to the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	Field (std::string_view const &fieldName)
	Adds a single column to the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	Field (SqlQualifiedTableColumnName const &fieldName)
	Adds a single column to the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	Field (SqlFieldExpression const &fieldExpression)
	Adds an aggregate function call to the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	As (std::string_view alias)
	Aliases the last added field (a column or an aggregate call) in the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	Fields (std::vector< std::string_view > const &fieldNames)
	Adds a sequence of columns to the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	Fields (std::vector< std::string_view > const &fieldNames, std::string_view tableName)
	Adds a sequence of columns from the given table to the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	Fields (std::initializer_list< std::string_view > const &fieldNames, std::string_view tableName)

template<typename FirstRecord , typename... MoreRecords>
SqlSelectQueryBuilder &	Fields ()
	Adds a sequence of columns from the given tables to the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	FieldAs (std::string_view const &fieldName, std::string_view const &alias)
	Adds a single column with an alias to the SELECT clause.

LIGHTWEIGHT_API SqlSelectQueryBuilder &	FieldAs (SqlQualifiedTableColumnName const &fieldName, std::string_view const &alias)
	Adds a single column with an alias to the SELECT clause.

template<typename Callable >
SqlSelectQueryBuilder &	Build (Callable const &callable)

LIGHTWEIGHT_API ComposedQuery	Count ()
	Finalizes building the query as SELECT COUNT(*) ... query.

LIGHTWEIGHT_API ComposedQuery	All ()
	Finalizes building the query as SELECT field names FROM ... query.

LIGHTWEIGHT_API ComposedQuery	First (size_t count=1)
	Finalizes building the query as SELECT TOP n field names FROM ... query.

LIGHTWEIGHT_API ComposedQuery	Range (std::size_t offset, std::size_t limit)
	Finalizes building the query as SELECT field names FROM ... query with a range.

LIGHTWEIGHT_FORCE_INLINE SqlSearchCondition &	SearchCondition () noexcept

LIGHTWEIGHT_FORCE_INLINE SqlQueryFormatter const &	Formatter () const noexcept

template<typename Callable >
LIGHTWEIGHT_FORCE_INLINE SqlSelectQueryBuilder &	Build (Callable const &callable)

template<typename FirstRecord , typename... MoreRecords>
LIGHTWEIGHT_FORCE_INLINE SqlSelectQueryBuilder &	Fields ()

Detailed Description

Query builder for building SELECT ... queries.

See also: SqlQueryBuilder

Definition at line 80 of file Select.hpp.

Member Typedef Documentation

◆ SelectType

using SqlSelectQueryBuilder::SelectType = detail::SelectType

Definition at line 83 of file Select.hpp.

Constructor & Destructor Documentation

◆ SqlSelectQueryBuilder()

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

inlineexplicitnoexcept

Definition at line 85 of file Select.hpp.

Member Function Documentation

◆ Varying()

constexpr LIGHTWEIGHT_FORCE_INLINE SqlSelectQueryBuilder & SqlSelectQueryBuilder::Varying ( )

inlineconstexprnoexcept

Sets the builder mode to Varying, allowing varying final query types.

Definition at line 98 of file Select.hpp.

◆ Fields() [1/2]

template<typename... MoreFields>

SqlSelectQueryBuilder & SqlSelectQueryBuilder::Fields	(	std::string_view const &	firstField,
		MoreFields &&...	moreFields
	)

Adds a sequence of columns to the SELECT clause.

Definition at line 175 of file Select.hpp.

◆ SearchCondition()

LIGHTWEIGHT_FORCE_INLINE SqlSearchCondition & SqlSelectQueryBuilder::SearchCondition ( )

inlinenoexcept

Definition at line 158 of file Select.hpp.

◆ Formatter()

LIGHTWEIGHT_FORCE_INLINE SqlQueryFormatter const & SqlSelectQueryBuilder::Formatter ( ) const

inlinenoexcept

Definition at line 163 of file Select.hpp.

◆ Build()

template<typename Callable >

LIGHTWEIGHT_FORCE_INLINE SqlSelectQueryBuilder & SqlSelectQueryBuilder::Build ( Callable const & callable )

inline

Definition at line 194 of file Select.hpp.

◆ Fields() [2/2]

template<typename FirstRecord , typename... MoreRecords>

LIGHTWEIGHT_FORCE_INLINE SqlSelectQueryBuilder & SqlSelectQueryBuilder::Fields ( )