SQL namespace. More...

Classes
class	ClausesBuilder
	SQL clauses builder. More...
class	FieldsBuilder
	Field builder. More...
class	FromBuilder
class	SelectBuilder
	Dynamic SQL select request builder. More...
class	SelectBuilderPart
	SQL select query part builder. More...
class	SQLQuery
	SQL query. More...
struct	SqlConnectionConfiguration
	SQL database connection configuration. More...
class	Connection
	SQL connection virtual class. More...
class	PreparedStatement
	SQL prepared statement. More...
class	ResultSet
	SQL result representation. More...
class	SqlConnectionFactory
	SQL connection factory. More...
class	SqlException
	SQL exception. More...
struct	SQLSharedLibrary
	SQL shared library data. More...
class	SQLSharedLibraries
	SQL shared libraries manager. More...
class	Date
	SQL date type. More...
class	Time
	SQL time type. More...
class	Timestamp
	SQL timestamp type. More...
class	MySQLConnection
	MySQL connection. More...
class	MySQLPreparedStatement
	MySQL prepared statement implementation. More...
class	MySQLPreparedStatementResultSet
	MySQL result set implementation for prepared statement ... shitty API. More...
class	MySQLResultSet
	MySQL result set implementation. More...
class	PostgreSQLConnection
	PostgreSQL connection. More...
class	PostgreSQLPreparedStatement
	PostgreSQL prepared statement implementation. More...
class	PostgreSQLResultSet
	PostgreSQL result set implementation. More...
class	SQLite3Connection
	SQLite3 connection. More...
class	SQLite3PreparedStatement
	SQLite3 prepared statement implementation. More...
class	SQLite3ResultSet
	SQLite3 result set implementation. More...

Typedefs
using	ClauseMaker = std::function<std::string(const std::string&)>
template<typename T>
using	ValueChecker = std::function<std::optional<std::string>(const T&)>
using	ClausesProvider = std::function<const anch::sql::ClausesBuilder&()>
using	SqlConnectionPool = anch::ResourcePool<Connection, SqlConnectionConfiguration, make_shared_connection>

Functions
std::string	notEquals (const std::string &column)
std::string	equals (const std::string &column)
std::string	greater (const std::string &column)
std::string	greaterEquals (const std::string &column)
std::string	lesser (const std::string &column)
std::string	lesserEquals (const std::string &column)
std::string	like (const std::string &column)
std::string	notLike (const std::string &column)
std::string	between (const std::string &column)
std::string	notBetween (const std::string &column)
std::string	in (const std::string &column)
std::string	notIn (const std::string &column)
std::string	exists (const std::string &column)
std::string	notExists (const std::string &column)
ClausesBuilder	clauses ()
template<typename T>
std::optional< std::string >	isValidValue (T &value)
SelectBuilder	select ()
template<typename T>
anch::sql::ClausesBuilder	clauses (anch::sql::ClauseMaker clause, T &value, anch::sql::ValueChecker< T > checker=anch::sql::isValidValue< T >)
template<typename T>
anch::sql::ClausesBuilder	clauses (const std::string &column, anch::sql::ClauseMaker clause, T &value, anch::sql::ValueChecker< T > checker=anch::sql::isValidValue< T >)
std::shared_ptr< Connection >	make_shared_connection (const SqlConnectionConfiguration &config)

Detailed Description

SQL namespace.

Provides abstraction layer for several SQL clients.
Supported SQL database are (for now):

SQLite3
MySQL/MariaDB
PostgreSQL

Typedef Documentation

◆ ClauseMaker

using anch::sql::ClauseMaker = std::function<std::string(const std::string&)>

Clause maker function.
The first (and only) parameter is the column (and the first operand). It returns the clause.

◆ ClausesProvider

using anch::sql::ClausesProvider = std::function<const anch::sql::ClausesBuilder&()>

Clauses provider

◆ SqlConnectionPool

using anch::sql::SqlConnectionPool = anch::ResourcePool<Connection, SqlConnectionConfiguration, make_shared_connection>

SQL connections pool definition

◆ ValueChecker

template<typename T>

using anch::sql::ValueChecker = std::function<std::optional<std::string>(const T&)>

Check if value is valid to add a clause

Function Documentation

◆ between()

std::string anch::sql::between ( const std::string & column )

Provides 'between' clause with BETWEEN operator

Parameters

column the column

Returns: clause request part

◆ clauses() [1/3]

anch::sql::ClausesBuilder anch::sql::clauses ( )

extern

Initialize a new ClausesBuilder

Returns: the new ClausesBuilder

◆ clauses() [2/3]

template<typename T>

anch::sql::ClausesBuilder anch::sql::clauses	(	anch::sql::ClauseMaker	clause,
		T &	value,
		anch::sql::ValueChecker< T >	checker = anch::sql::isValidValue<T> )

Initialize a new ClausesBuilder

Returns: the new ClausesBuilder

Here is the call graph for this function:

◆ clauses() [3/3]

template<typename T>

anch::sql::ClausesBuilder anch::sql::clauses	(	const std::string &	column,
		anch::sql::ClauseMaker	clause,
		T &	value,
		anch::sql::ValueChecker< T >	checker = anch::sql::isValidValue<T> )

Initialize a new ClausesBuilder

Returns: the new ClausesBuilder

Here is the call graph for this function:

◆ equals()

std::string anch::sql::equals ( const std::string & column )

Provides 'equals' clause with = operator

Parameters

column the column

Returns: clause request part

◆ exists()

std::string anch::sql::exists ( const std::string & column )

Provides 'exists' clause with EXISTS operator.

Parameters

column the column

Returns: clause request part

◆ greater()

std::string anch::sql::greater ( const std::string & column )

Provides 'greater' clause with > operator

Parameters

column the column

Returns: clause request part

◆ greaterEquals()

std::string anch::sql::greaterEquals ( const std::string & column )

Provides 'greater or equals' clause with >= operator

Parameters

column the column

Returns: clause request part

◆ in()

std::string anch::sql::in ( const std::string & column )

Provides 'in' clause with IN operator.

Parameters

column the column

Returns: clause request part

◆ isValidValue()

template<typename T>

std::optional< std::string > anch::sql::isValidValue ( T & value )

Default value checker

Parameters

value the value to check

Returns: true if value is valid, false otherwise

◆ lesser()

std::string anch::sql::lesser ( const std::string & column )

Provides 'lesser' clause with < operator

Parameters

column the column

Returns: clause request part

◆ lesserEquals()

std::string anch::sql::lesserEquals ( const std::string & column )

Provides 'lesser or equals' clause with <= operator

Parameters

column the column

Returns: clause request part

◆ like()

std::string anch::sql::like ( const std::string & column )

Provides 'like' clause with LIKE operator

Parameters

column the column

Returns: clause request part

◆ make_shared_connection()

std::shared_ptr< Connection > anch::sql::make_shared_connection ( const SqlConnectionConfiguration & config )

extern

Create a new shared pointer on SQL connection.

Parameters

config the SQL database configuration

Returns: the connection

Exceptions

SqlException any error

◆ notBetween()

std::string anch::sql::notBetween ( const std::string & column )

Provides 'not between' clause with NOT BETWEEN operator

Parameters

column the column

Returns: clause request part

◆ notEquals()

std::string anch::sql::notEquals ( const std::string & column )

Provides 'not equals' clause with <> operator

Parameters

column the column

Returns: clause request part

◆ notExists()

std::string anch::sql::notExists ( const std::string & column )

Provides 'not exists' clause with NOT EXISTS operator.

Parameters

column the column

Returns: clause request part

◆ notIn()

std::string anch::sql::notIn ( const std::string & column )

Provides 'not in' clause with NOT IN operator.

Parameters

column the column

Returns: clause request part

◆ notLike()

std::string anch::sql::notLike ( const std::string & column )

Provides 'not like' clause with NOT LIKE operator

Parameters

column the column

Returns: clause request part

◆ select()

anch::sql::SelectBuilder anch::sql::select ( )

extern

Initialize a new SelectBuilder

Returns: the new SelectBuilder

Classes

Typedefs

Functions

Detailed Description

Typedef Documentation

◆ ClauseMaker

◆ ClausesProvider

◆ SqlConnectionPool

◆ ValueChecker

Function Documentation

◆ between()

◆ clauses() [1/3]

◆ clauses() [2/3]

◆ clauses() [3/3]

◆ equals()

◆ exists()

◆ greater()

◆ greaterEquals()

◆ in()

◆ isValidValue()

◆ lesser()

◆ lesserEquals()

◆ like()

◆ make_shared_connection()

◆ notBetween()

◆ notEquals()

◆ notExists()

◆ notIn()

◆ notLike()

◆ select()