QxOrm  1.2.8
C++ Object Relational Mapping library

qx::IxSqlQueryBuilder : common interface to build SQL queries to communicate with database More...

#include <IxSqlQueryBuilder.h>

Inheritance diagram for qx::IxSqlQueryBuilder:
qx::QxSqlQueryBuilder< T >

List of all members.

Public Types

typedef QPair< QString, QString > type_id
typedef QHash< type_id, void * > type_ptr_by_id
typedef boost::shared_ptr
< type_ptr_by_id
type_ptr_by_id_ptr
typedef QList< type_ptr_by_id_ptrtype_lst_ptr_by_id
typedef boost::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
IxSqlRelationXgetLstRelation () const
qx::dao::detail::IxDao_HelpergetDaoHelper () 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
IxDataMembergetDataId () const
IxDataMembernextData (long &l) const
IxSqlRelationnextRelation (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 IxDataMemberXgetDataMemberX () const =0
virtual IxSqlQueryBuildercount ()=0
virtual IxSqlQueryBuilderexist ()=0
virtual IxSqlQueryBuilderfetchAll ()=0
virtual IxSqlQueryBuilderfetchById ()=0
virtual IxSqlQueryBuilderinsert ()=0
virtual IxSqlQueryBuilderupdate ()=0
virtual IxSqlQueryBuilderdeleteAll ()=0
virtual IxSqlQueryBuildersoftDeleteAll ()=0
virtual IxSqlQueryBuilderdeleteById ()=0
virtual IxSqlQueryBuildersoftDeleteById ()=0
virtual IxSqlQueryBuildercreateTable ()=0
virtual IxSqlQueryBuilderfetchAll (const QStringList &columns)=0
virtual IxSqlQueryBuilderfetchById (const QStringList &columns)=0
virtual IxSqlQueryBuilderupdate (const QStringList &columns)=0
virtual IxSqlQueryBuilderfetchAll_WithRelation (QxSqlRelationLinked *pRelationX)=0
virtual IxSqlQueryBuilderfetchById_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.
IxSqlRelationXm_lstSqlRelationPtr
 Collection of 'IxSqlRelation' to build sql query.
IxDataMemberm_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_Helperm_pDaoHelper
 Pointer to the dao helper class associated to the builder.

Detailed Description

qx::IxSqlQueryBuilder : common interface to build SQL queries to communicate with database

Definition at line 68 of file IxSqlQueryBuilder.h.


Member Typedef Documentation

typedef QPair<QString, QString> qx::IxSqlQueryBuilder::type_id

Definition at line 73 of file IxSqlQueryBuilder.h.

Definition at line 77 of file IxSqlQueryBuilder.h.

Definition at line 74 of file IxSqlQueryBuilder.h.

Definition at line 75 of file IxSqlQueryBuilder.h.


Constructor & Destructor Documentation

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]

Member Function Documentation

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


Member Data Documentation

Recordset can return cartesian product => same id in multiple records.

Definition at line 87 of file IxSqlQueryBuilder.h.

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.

Collection of 'IxSqlRelation' to build sql query.

Definition at line 82 of file IxSqlQueryBuilder.h.

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.

Data member id for sql query.

Definition at line 83 of file IxSqlQueryBuilder.h.

Collection of id (and pointer associated) to avoid multiple fetch on same id (cartesian product)

Definition at line 88 of file IxSqlQueryBuilder.h.

Optimization : hash to retrieve sql query with relation.

Definition at line 86 of file IxSqlQueryBuilder.h.

Current sql query.

Definition at line 84 of file IxSqlQueryBuilder.h.

Sql table name of current object.

Definition at line 85 of file IxSqlQueryBuilder.h.


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