![]() |
QxOrm
1.4.2
C++ Object Relational Mapping library
|
qx::IxSqlQueryBuilder : common interface to build SQL queries to communicate with database More...
#include <IxSqlQueryBuilder.h>
Public Types | |
typedef QPair< QString, QString > | type_id |
typedef QHash< type_id, void * > | type_ptr_by_id |
typedef qx_shared_ptr < type_ptr_by_id > | type_ptr_by_id_ptr |
typedef QList< type_ptr_by_id_ptr > | type_lst_ptr_by_id |
typedef qx_shared_ptr < type_lst_ptr_by_id > | type_lst_ptr_by_id_ptr |
Public Member Functions | |
IxSqlQueryBuilder () | |
IxSqlQueryBuilder (const QString &sql) | |
virtual | ~IxSqlQueryBuilder ()=0 |
QxCollection< QString, IxDataMember * > * | getLstDataMember () const |
IxSqlRelationX * | getLstRelation () const |
qx::dao::detail::IxDao_Helper * | getDaoHelper () const |
void | setDaoHelper (qx::dao::detail::IxDao_Helper *p) |
void | setSqlQuery (const QString &sql) |
void | setHashRelation (const QString &s) |
void | setCartesianProduct (bool b) |
QString | getSqlQuery () const |
QString | getHashRelation () const |
QString | table () const |
QxSoftDelete | getSoftDelete () const |
bool | getCartesianProduct () const |
long | getDataCount () const |
long | getRelationCount () const |
IxDataMember * | getDataId () const |
IxDataMember * | nextData (long &l) const |
IxSqlRelation * | nextRelation (long &l) const |
void | initIdX (long lAllRelationCount) |
bool | insertIdX (long lIndex, const QVariant &idOwner, const QVariant &idData, void *ptr) |
void * | existIdX (long lIndex, const QVariant &idOwner, const QVariant &idData) |
void | addSqlQueryAlias (const QString &sql, const QString &sqlAlias) |
bool | getAddAutoIncrementIdToUpdateQuery () const |
void | replaceSqlQueryAlias (QString &sql) const |
void | displaySqlQuery (int time_ms=-1) const |
virtual void | init ()=0 |
virtual IxDataMemberX * | getDataMemberX () const =0 |
virtual IxSqlQueryBuilder & | count ()=0 |
virtual IxSqlQueryBuilder & | exist ()=0 |
virtual IxSqlQueryBuilder & | fetchAll ()=0 |
virtual IxSqlQueryBuilder & | fetchById ()=0 |
virtual IxSqlQueryBuilder & | insert ()=0 |
virtual IxSqlQueryBuilder & | update ()=0 |
virtual IxSqlQueryBuilder & | deleteAll ()=0 |
virtual IxSqlQueryBuilder & | softDeleteAll ()=0 |
virtual IxSqlQueryBuilder & | deleteById ()=0 |
virtual IxSqlQueryBuilder & | softDeleteById ()=0 |
virtual IxSqlQueryBuilder & | createTable ()=0 |
virtual IxSqlQueryBuilder & | fetchAll (const QStringList &columns)=0 |
virtual IxSqlQueryBuilder & | fetchById (const QStringList &columns)=0 |
virtual IxSqlQueryBuilder & | update (const QStringList &columns)=0 |
virtual IxSqlQueryBuilder & | fetchAll_WithRelation (QxSqlRelationLinked *pRelationX)=0 |
virtual IxSqlQueryBuilder & | fetchById_WithRelation (QxSqlRelationLinked *pRelationX)=0 |
Static Public Member Functions | |
static QString | addSqlCondition (const QString &sql) |
Protected Attributes | |
QxCollection< QString, IxDataMember * > * | m_lstDataMemberPtr |
Collection of 'IxDataMember' to build sql query. | |
IxSqlRelationX * | m_lstSqlRelationPtr |
Collection of 'IxSqlRelation' to build sql query. | |
IxDataMember * | m_pDataMemberId |
Data member id for sql query. | |
QString | m_sSqlQuery |
Current sql query. | |
QString | m_sTableName |
Sql table name of current object. | |
QString | m_sHashRelation |
Optimization : hash to retrieve sql query with relation. | |
bool | m_bCartesianProduct |
Recordset can return cartesian product => same id in multiple records. | |
type_lst_ptr_by_id_ptr | m_pIdX |
Collection of id (and pointer associated) to avoid multiple fetch on same id (cartesian product) | |
QxSoftDelete | m_oSoftDelete |
Soft delete (or logical delete) behavior. | |
QHash< QString, QString > | m_lstSqlQueryAlias |
List of sql alias to replace into sql query. | |
qx::dao::detail::IxDao_Helper * | m_pDaoHelper |
Pointer to the dao helper class associated to the builder. |
qx::IxSqlQueryBuilder : common interface to build SQL queries to communicate with database
Definition at line 68 of file IxSqlQueryBuilder.h.
typedef QPair<QString, QString> qx::IxSqlQueryBuilder::type_id |
Definition at line 73 of file IxSqlQueryBuilder.h.
typedef QList<type_ptr_by_id_ptr> qx::IxSqlQueryBuilder::type_lst_ptr_by_id |
Definition at line 76 of file IxSqlQueryBuilder.h.
typedef qx_shared_ptr<type_lst_ptr_by_id> qx::IxSqlQueryBuilder::type_lst_ptr_by_id_ptr |
Definition at line 77 of file IxSqlQueryBuilder.h.
typedef QHash<type_id, void *> qx::IxSqlQueryBuilder::type_ptr_by_id |
Definition at line 74 of file IxSqlQueryBuilder.h.
typedef qx_shared_ptr<type_ptr_by_id> qx::IxSqlQueryBuilder::type_ptr_by_id_ptr |
Definition at line 75 of file IxSqlQueryBuilder.h.
qx::IxSqlQueryBuilder::IxSqlQueryBuilder | ( | ) | [inline] |
Definition at line 95 of file IxSqlQueryBuilder.h.
qx::IxSqlQueryBuilder::IxSqlQueryBuilder | ( | const QString & | sql | ) | [inline] |
Definition at line 96 of file IxSqlQueryBuilder.h.
virtual qx::IxSqlQueryBuilder::~IxSqlQueryBuilder | ( | ) | [pure virtual] |
static QString qx::IxSqlQueryBuilder::addSqlCondition | ( | const QString & | sql | ) | [inline, static] |
Definition at line 145 of file IxSqlQueryBuilder.h.
void qx::IxSqlQueryBuilder::addSqlQueryAlias | ( | const QString & | sql, |
const QString & | sqlAlias | ||
) |
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::count | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::createTable | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::deleteAll | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::deleteById | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
void qx::IxSqlQueryBuilder::displaySqlQuery | ( | int | time_ms = -1 | ) | const |
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::exist | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
void* qx::IxSqlQueryBuilder::existIdX | ( | long | lIndex, |
const QVariant & | idOwner, | ||
const QVariant & | idData | ||
) |
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::fetchAll | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::fetchAll | ( | const QStringList & | columns | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::fetchAll_WithRelation | ( | QxSqlRelationLinked * | pRelationX | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::fetchById | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::fetchById | ( | const QStringList & | columns | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::fetchById_WithRelation | ( | QxSqlRelationLinked * | pRelationX | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
bool qx::IxSqlQueryBuilder::getAddAutoIncrementIdToUpdateQuery | ( | ) | const |
bool qx::IxSqlQueryBuilder::getCartesianProduct | ( | ) | const [inline] |
Definition at line 111 of file IxSqlQueryBuilder.h.
qx::dao::detail::IxDao_Helper* qx::IxSqlQueryBuilder::getDaoHelper | ( | ) | const [inline] |
Definition at line 101 of file IxSqlQueryBuilder.h.
long qx::IxSqlQueryBuilder::getDataCount | ( | ) | const [inline] |
Definition at line 112 of file IxSqlQueryBuilder.h.
IxDataMember* qx::IxSqlQueryBuilder::getDataId | ( | ) | const [inline] |
Definition at line 114 of file IxSqlQueryBuilder.h.
virtual IxDataMemberX* qx::IxSqlQueryBuilder::getDataMemberX | ( | ) | const [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
QString qx::IxSqlQueryBuilder::getHashRelation | ( | ) | const [inline] |
Definition at line 108 of file IxSqlQueryBuilder.h.
QxCollection<QString, IxDataMember *>* qx::IxSqlQueryBuilder::getLstDataMember | ( | ) | const [inline] |
Definition at line 99 of file IxSqlQueryBuilder.h.
IxSqlRelationX* qx::IxSqlQueryBuilder::getLstRelation | ( | ) | const [inline] |
Definition at line 100 of file IxSqlQueryBuilder.h.
long qx::IxSqlQueryBuilder::getRelationCount | ( | ) | const [inline] |
Definition at line 113 of file IxSqlQueryBuilder.h.
QxSoftDelete qx::IxSqlQueryBuilder::getSoftDelete | ( | ) | const [inline] |
Definition at line 110 of file IxSqlQueryBuilder.h.
QString qx::IxSqlQueryBuilder::getSqlQuery | ( | ) | const [inline] |
Definition at line 107 of file IxSqlQueryBuilder.h.
virtual void qx::IxSqlQueryBuilder::init | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
void qx::IxSqlQueryBuilder::initIdX | ( | long | lAllRelationCount | ) |
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::insert | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
bool qx::IxSqlQueryBuilder::insertIdX | ( | long | lIndex, |
const QVariant & | idOwner, | ||
const QVariant & | idData, | ||
void * | ptr | ||
) |
IxDataMember* qx::IxSqlQueryBuilder::nextData | ( | long & | l | ) | const [inline] |
Definition at line 115 of file IxSqlQueryBuilder.h.
IxSqlRelation* qx::IxSqlQueryBuilder::nextRelation | ( | long & | l | ) | const [inline] |
Definition at line 116 of file IxSqlQueryBuilder.h.
void qx::IxSqlQueryBuilder::replaceSqlQueryAlias | ( | QString & | sql | ) | const |
void qx::IxSqlQueryBuilder::setCartesianProduct | ( | bool | b | ) | [inline] |
Definition at line 106 of file IxSqlQueryBuilder.h.
void qx::IxSqlQueryBuilder::setDaoHelper | ( | qx::dao::detail::IxDao_Helper * | p | ) | [inline] |
Definition at line 102 of file IxSqlQueryBuilder.h.
void qx::IxSqlQueryBuilder::setHashRelation | ( | const QString & | s | ) | [inline] |
Definition at line 105 of file IxSqlQueryBuilder.h.
void qx::IxSqlQueryBuilder::setSqlQuery | ( | const QString & | sql | ) | [inline] |
Definition at line 104 of file IxSqlQueryBuilder.h.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::softDeleteAll | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::softDeleteById | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
QString qx::IxSqlQueryBuilder::table | ( | ) | const [inline] |
Definition at line 109 of file IxSqlQueryBuilder.h.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::update | ( | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
virtual IxSqlQueryBuilder& qx::IxSqlQueryBuilder::update | ( | const QStringList & | columns | ) | [pure virtual] |
Implemented in qx::QxSqlQueryBuilder< T >.
bool qx::IxSqlQueryBuilder::m_bCartesianProduct [protected] |
Recordset can return cartesian product => same id in multiple records.
Definition at line 87 of file IxSqlQueryBuilder.h.
QxCollection<QString, IxDataMember *>* qx::IxSqlQueryBuilder::m_lstDataMemberPtr [protected] |
Collection of 'IxDataMember' to build sql query.
Definition at line 81 of file IxSqlQueryBuilder.h.
QHash<QString, QString> qx::IxSqlQueryBuilder::m_lstSqlQueryAlias [protected] |
List of sql alias to replace into sql query.
Definition at line 90 of file IxSqlQueryBuilder.h.
IxSqlRelationX* qx::IxSqlQueryBuilder::m_lstSqlRelationPtr [protected] |
Collection of 'IxSqlRelation' to build sql query.
Definition at line 82 of file IxSqlQueryBuilder.h.
QxSoftDelete qx::IxSqlQueryBuilder::m_oSoftDelete [protected] |
Soft delete (or logical delete) behavior.
Definition at line 89 of file IxSqlQueryBuilder.h.
Pointer to the dao helper class associated to the builder.
Definition at line 91 of file IxSqlQueryBuilder.h.
IxDataMember* qx::IxSqlQueryBuilder::m_pDataMemberId [protected] |
Data member id for sql query.
Definition at line 83 of file IxSqlQueryBuilder.h.
type_lst_ptr_by_id_ptr qx::IxSqlQueryBuilder::m_pIdX [protected] |
Collection of id (and pointer associated) to avoid multiple fetch on same id (cartesian product)
Definition at line 88 of file IxSqlQueryBuilder.h.
QString qx::IxSqlQueryBuilder::m_sHashRelation [protected] |
Optimization : hash to retrieve sql query with relation.
Definition at line 86 of file IxSqlQueryBuilder.h.
QString qx::IxSqlQueryBuilder::m_sSqlQuery [protected] |
Current sql query.
Definition at line 84 of file IxSqlQueryBuilder.h.
QString qx::IxSqlQueryBuilder::m_sTableName [protected] |
Sql table name of current object.
Definition at line 85 of file IxSqlQueryBuilder.h.