AUI Framework  master
Cross-platform base for C++ UI apps
Loading...
Searching...
No Matches
ASqlBuilder Class Reference

Classes#

class  Delete
 
class  Insert
 
class  Select
 
class  Statement
 
class  Update
 
class  WhereStatement
 

Public Member Functions#

 ASqlBuilder (const AString &tableName)
 
Insert insert (const AStringVector &columnNames)
 Does the INSERT query to DB.
 
template<typename... Args>
Insert ins (Args &&... args)
 Does the INSERT query to DB.
 
Select select (const AStringVector &columnNames={})
 Does the SELECT query to DB.
 
template<typename... Args>
Select sel (Args &&... args)
 Does the SELECT query to DB.
 
Update update (const AMap< AString, AVariant > &data={})
 Does the UPDATE query to DB.
 
Delete remove ()
 Does the DELETE query to DB.
 
template<typename Model>
id_t insertORM (const Model &model)
 Inserts ORM object.
 
template<typename Model>
void updateORM (const Model &model)
 Updates ORM object.
 
template<typename Model>
void removeORM (const Model &model)
 Removes ORM object.
 

Member Function Documentation#

◆ ins()#

template<typename... Args>
Insert ASqlBuilder::ins ( Args &&... args)
inline
Parameters
argscolumn names
Returns
helper object for adding rows

◆ insert()#

Insert ASqlBuilder::insert ( const AStringVector & columnNames)
Parameters
columnNamescolumn names
Returns
helper object for adding rows

◆ insertORM()#

template<typename Model>
id_t ASqlBuilder::insertORM ( const Model & model)
inline
Template Parameters
ModelORM
Parameters
modelORM
Returns
row id

◆ remove()#

Delete ASqlBuilder::remove ( )
Returns
helper object for WHERE condition

◆ removeORM()#

template<typename Model>
void ASqlBuilder::removeORM ( const Model & model)
inline
Template Parameters
ModelORM
Parameters
modelORM

◆ sel()#

template<typename... Args>
Select ASqlBuilder::sel ( Args &&... args)
inline
Parameters
argscolumn names
Returns
helper object for retrieving rows

◆ select()#

Select ASqlBuilder::select ( const AStringVector & columnNames = {})
Parameters
columnNamescolumn names
Returns
helper object for retrieving rows

◆ update()#

Update ASqlBuilder::update ( const AMap< AString, AVariant > & data = {})
Parameters
datadata pairs {key, value}
Returns
helper object for adding data (additional data)

◆ updateORM()#

template<typename Model>
void ASqlBuilder::updateORM ( const Model & model)
inline
Template Parameters
ModelORM
Parameters
modelORM