![]() |
QxOrm
1.2.3
C++ Object Relational Mapping library
|
qx::QxSqlQuery : define a user SQL query added to default SQL query builded by QxOrm library, and used by qx::dao::xxx functions to filter elements fetched from database More...
#include <QxSqlQuery.h>
Public Member Functions | |
QxSqlQuery () | |
QxSqlQuery (const QString &sQuery) | |
QxSqlQuery (const char *sQuery) | |
virtual | ~QxSqlQuery () |
QString | query () |
bool | isEmpty () const |
bool | isDistinct () const |
void | clear () |
void | resolve (QSqlQuery &query) const |
void | postProcess (QString &sql) const |
QxSqlQuery & | query (const QString &sQuery) |
QxSqlQuery & | bind (const QVariant &vValue) |
QxSqlQuery & | bind (const QString &sKey, const QVariant &vValue) |
QxSqlQuery & | distinct () |
QxSqlQuery & | where (const QString &column) |
QxSqlQuery & | where_OpenParenthesis (const QString &column) |
QxSqlQuery & | and_ (const QString &column) |
QxSqlQuery & | and_OpenParenthesis (const QString &column) |
QxSqlQuery & | or_ (const QString &column) |
QxSqlQuery & | or_OpenParenthesis (const QString &column) |
QxSqlQuery & | openParenthesis () |
QxSqlQuery & | closeParenthesis () |
QxSqlQuery & | orderAsc (const QStringList &columns) |
QxSqlQuery & | orderAsc (const QString &col1) |
QxSqlQuery & | orderAsc (const QString &col1, const QString &col2) |
QxSqlQuery & | orderAsc (const QString &col1, const QString &col2, const QString &col3) |
QxSqlQuery & | orderAsc (const QString &col1, const QString &col2, const QString &col3, const QString &col4) |
QxSqlQuery & | orderAsc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5) |
QxSqlQuery & | orderAsc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6) |
QxSqlQuery & | orderAsc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7) |
QxSqlQuery & | orderAsc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7, const QString &col8) |
QxSqlQuery & | orderAsc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7, const QString &col8, const QString &col9) |
QxSqlQuery & | orderDesc (const QStringList &columns) |
QxSqlQuery & | orderDesc (const QString &col1) |
QxSqlQuery & | orderDesc (const QString &col1, const QString &col2) |
QxSqlQuery & | orderDesc (const QString &col1, const QString &col2, const QString &col3) |
QxSqlQuery & | orderDesc (const QString &col1, const QString &col2, const QString &col3, const QString &col4) |
QxSqlQuery & | orderDesc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5) |
QxSqlQuery & | orderDesc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6) |
QxSqlQuery & | orderDesc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7) |
QxSqlQuery & | orderDesc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7, const QString &col8) |
QxSqlQuery & | orderDesc (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7, const QString &col8, const QString &col9) |
QxSqlQuery & | groupBy (const QStringList &columns) |
QxSqlQuery & | groupBy (const QString &col1) |
QxSqlQuery & | groupBy (const QString &col1, const QString &col2) |
QxSqlQuery & | groupBy (const QString &col1, const QString &col2, const QString &col3) |
QxSqlQuery & | groupBy (const QString &col1, const QString &col2, const QString &col3, const QString &col4) |
QxSqlQuery & | groupBy (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5) |
QxSqlQuery & | groupBy (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6) |
QxSqlQuery & | groupBy (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7) |
QxSqlQuery & | groupBy (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7, const QString &col8) |
QxSqlQuery & | groupBy (const QString &col1, const QString &col2, const QString &col3, const QString &col4, const QString &col5, const QString &col6, const QString &col7, const QString &col8, const QString &col9) |
QxSqlQuery & | limit (int rowsCount, int startRow=0) |
QxSqlQuery & | like (const QString &val) |
QxSqlQuery & | notLike (const QString &val) |
QxSqlQuery & | startsWith (const QString &val) |
QxSqlQuery & | endsWith (const QString &val) |
QxSqlQuery & | containsString (const QString &val) |
QxSqlQuery & | isEqualTo (const QVariant &val) |
QxSqlQuery & | isNotEqualTo (const QVariant &val) |
QxSqlQuery & | isGreaterThan (const QVariant &val) |
QxSqlQuery & | isGreaterThanOrEqualTo (const QVariant &val) |
QxSqlQuery & | isLessThan (const QVariant &val) |
QxSqlQuery & | isLessThanOrEqualTo (const QVariant &val) |
QxSqlQuery & | in (const QVariantList &values) |
QxSqlQuery & | in (const QVariant &val1) |
QxSqlQuery & | in (const QVariant &val1, const QVariant &val2) |
QxSqlQuery & | in (const QVariant &val1, const QVariant &val2, const QVariant &val3) |
QxSqlQuery & | in (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4) |
QxSqlQuery & | in (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5) |
QxSqlQuery & | in (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5, const QVariant &val6) |
QxSqlQuery & | in (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5, const QVariant &val6, const QVariant &val7) |
QxSqlQuery & | in (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5, const QVariant &val6, const QVariant &val7, const QVariant &val8) |
QxSqlQuery & | in (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5, const QVariant &val6, const QVariant &val7, const QVariant &val8, const QVariant &val9) |
QxSqlQuery & | notIn (const QVariantList &values) |
QxSqlQuery & | notIn (const QVariant &val1) |
QxSqlQuery & | notIn (const QVariant &val1, const QVariant &val2) |
QxSqlQuery & | notIn (const QVariant &val1, const QVariant &val2, const QVariant &val3) |
QxSqlQuery & | notIn (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4) |
QxSqlQuery & | notIn (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5) |
QxSqlQuery & | notIn (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5, const QVariant &val6) |
QxSqlQuery & | notIn (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5, const QVariant &val6, const QVariant &val7) |
QxSqlQuery & | notIn (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5, const QVariant &val6, const QVariant &val7, const QVariant &val8) |
QxSqlQuery & | notIn (const QVariant &val1, const QVariant &val2, const QVariant &val3, const QVariant &val4, const QVariant &val5, const QVariant &val6, const QVariant &val7, const QVariant &val8, const QVariant &val9) |
QxSqlQuery & | in_Select (const QString &sql) |
QxSqlQuery & | notIn_Select (const QString &sql) |
QxSqlQuery & | isNull () |
QxSqlQuery & | isNotNull () |
QxSqlQuery & | isBetween (const QVariant &val1, const QVariant &val2) |
QxSqlQuery & | isNotBetween (const QVariant &val1, const QVariant &val2) |
QxSqlQuery & | freeText (const QString &text) |
Protected Attributes | |
QString | m_sQuery |
Query SQL with place-holder. | |
QxCollection< QString, QVariant > | m_lstValue |
Bind value in this array. | |
qx::dao::detail::IxSqlElement_ptr | m_pSqlElementTemp |
Temporary SQL element. | |
QList < qx::dao::detail::IxSqlElement_ptr > | m_lstSqlElement |
List of all SQL elements to build SQL query. | |
int | m_iSqlElementIndex |
Current index of SQL element. | |
int | m_iParenthesisCount |
Current parenthesis count. | |
bool | m_bDistinct |
Replace SELECT by SELECT DISTINCT in SQL query. | |
Private Member Functions | |
void | verifyQuery () const |
QxSqlQuery & | addSqlExpression (const QString &column, qx::dao::detail::QxSqlExpression::type type) |
QxSqlQuery & | addSqlCompare (const QVariant &val, qx::dao::detail::QxSqlCompare::type type) |
QxSqlQuery & | addSqlSort (const QStringList &columns, qx::dao::detail::QxSqlSort::type type) |
QxSqlQuery & | addSqlIn (const QVariantList &values, qx::dao::detail::QxSqlIn::type type) |
QxSqlQuery & | addSqlIsNull (qx::dao::detail::QxSqlIsNull::type type) |
QxSqlQuery & | addSqlIsBetween (const QVariant &val1, const QVariant &val2, qx::dao::detail::QxSqlIsBetween::type type) |
qx::QxSqlQuery : define a user SQL query added to default SQL query builded by QxOrm library, and used by qx::dao::xxx functions to filter elements fetched from database
The class qx::QxSqlQuery (or its typedef qx_query) is used to communicate with database (to filter, to sort, etc.) in two different ways :
With the first method (writing manually SQL query), you can use some optimizations specific for each database. The second method (using C++ code to build SQL query) binds automatically SQL parameters without using qx::QxSqlQuery::bind() function.
Here is an example with qx::QxSqlQuery class writing manually a SQL query :
// Build a SQL query to fetch only 'author' of type 'female' qx::QxSqlQuery query("WHERE author.sex = :sex"); query.bind(":sex", author::female); QList<author> list_of_female; QSqlError daoError = qx::dao::fetch_by_query(query, list_of_female); // Here we can work with the collection provided by database for (long l = 0; l < list_of_female.count(); l++) { ; }
QxOrm library provides 3 styles to write SQL parameters. This style can be modified for a project using the following method qx::QxSqlDatabase::getSingleton()->setSqlPlaceHolderStyle() :
Here is the same example using C++ code of the class qx::QxSqlQuery (or its typedef qx_query) to build query automatically :
// Build a SQL query to fetch only 'author' of type 'female' qx_query query; query.where("author.sex").isEqualTo(author::female); QList<author> list_of_female; QSqlError daoError = qx::dao::fetch_by_query(query, list_of_female); // Here we can work with the collection provided by database for (long l = 0; l < list_of_female.count(); l++) { ; }
With C++ methods of qx::QxSqlQuery class, you don't have to bind any SQL parameter, and the syntax is similar to real SQL. All SQL parameters will be provided to database automatically with the following style : qx::QxSqlDatabase::getSingleton()->getSqlPlaceHolderStyle().
Here is an example with many methods of qx::QxSqlQuery class (or its typedef qx_query) :
qx_query query; query.where("sex").isEqualTo(author::female) .and_("age").isGreaterThan(38) .or_("last_name").isNotEqualTo("Dupont") .or_("first_name").like("Alfred") .and_OpenParenthesis("id").isLessThanOrEqualTo(999) .and_("birth_date").isBetween(date1, date2) .closeParenthesis() .or_("id").in(50, 999, 11, 23, 78945) .and_("is_deleted").isNotNull() .orderAsc("last_name", "first_name", "sex") .limit(50, 150);
This code will produce following SQL for MySQL, PostgreSQL and SQLite databases (for Oracle and SQLServer, there is a specific process for limit() method) :
WHERE sex = :sex_1_0 AND age > :age_3_0 OR last_name <> :last_name_5_0 OR first_name LIKE :first_name_7_0 AND ( id <= :id_10_0 AND birth_date BETWEEN :birth_date_12_0_1 AND :birth_date_12_0_2 ) OR id IN (:id_15_0_0, :id_15_0_1, :id_15_0_2, :id_15_0_3, :id_15_0_4) AND is_deleted IS NOT NULL ORDER BY last_name ASC, first_name ASC, sex ASC LIMIT :limit_rows_count_19_0 OFFSET :offset_start_row_19_0
Here is the list of all functions available to use qx::QxSqlQuery class (or its typedef qx_query) :
// with functions into namespace qx::dao qx::dao::count<T>() qx::dao::fetch_by_query<T>() qx::dao::update_by_query<T>() qx::dao::delete_by_query<T>() qx::dao::destroy_by_query<T>() qx::dao::fetch_by_query_with_relation<T>() qx::dao::fetch_by_query_with_all_relation<T>() qx::dao::update_by_query_with_relation<T>() qx::dao::update_by_query_with_all_relation<T>() qx::dao::update_optimized_by_query<T>() // with qx::QxSession class qx::QxSession::count<T>() qx::QxSession::fetchByQuery<T>() qx::QxSession::update<T>() qx::QxSession::deleteByQuery<T>() qx::QxSession::destroyByQuery<T>() // with qx::QxRepository<T> class qx::QxRepository<T>::count() qx::QxRepository<T>::fetchByQuery() qx::QxRepository<T>::update() qx::QxRepository<T>::deleteByQuery() qx::QxRepository<T>::destroyByQuery()
Note : those functions have 2 other optionals parameters :
Definition at line 156 of file QxSqlQuery.h.
qx::QxSqlQuery::QxSqlQuery | ( | ) | [inline] |
Definition at line 171 of file QxSqlQuery.h.
qx::QxSqlQuery::QxSqlQuery | ( | const QString & | sQuery | ) | [inline] |
Definition at line 172 of file QxSqlQuery.h.
qx::QxSqlQuery::QxSqlQuery | ( | const char * | sQuery | ) | [inline] |
Definition at line 173 of file QxSqlQuery.h.
virtual qx::QxSqlQuery::~QxSqlQuery | ( | ) | [inline, virtual] |
Definition at line 174 of file QxSqlQuery.h.
QxSqlQuery& qx::QxSqlQuery::addSqlCompare | ( | const QVariant & | val, |
qx::dao::detail::QxSqlCompare::type | type | ||
) | [private] |
QxSqlQuery& qx::QxSqlQuery::addSqlExpression | ( | const QString & | column, |
qx::dao::detail::QxSqlExpression::type | type | ||
) | [private] |
QxSqlQuery& qx::QxSqlQuery::addSqlIn | ( | const QVariantList & | values, |
qx::dao::detail::QxSqlIn::type | type | ||
) | [private] |
QxSqlQuery& qx::QxSqlQuery::addSqlIsBetween | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
qx::dao::detail::QxSqlIsBetween::type | type | ||
) | [private] |
QxSqlQuery& qx::QxSqlQuery::addSqlIsNull | ( | qx::dao::detail::QxSqlIsNull::type | type | ) | [private] |
QxSqlQuery& qx::QxSqlQuery::addSqlSort | ( | const QStringList & | columns, |
qx::dao::detail::QxSqlSort::type | type | ||
) | [private] |
QxSqlQuery& qx::QxSqlQuery::and_ | ( | const QString & | column | ) |
QxSqlQuery& qx::QxSqlQuery::and_OpenParenthesis | ( | const QString & | column | ) |
QxSqlQuery& qx::QxSqlQuery::bind | ( | const QVariant & | vValue | ) |
QxSqlQuery& qx::QxSqlQuery::bind | ( | const QString & | sKey, |
const QVariant & | vValue | ||
) |
void qx::QxSqlQuery::clear | ( | ) |
QxSqlQuery& qx::QxSqlQuery::closeParenthesis | ( | ) |
QxSqlQuery& qx::QxSqlQuery::containsString | ( | const QString & | val | ) |
QxSqlQuery& qx::QxSqlQuery::distinct | ( | ) |
QxSqlQuery& qx::QxSqlQuery::endsWith | ( | const QString & | val | ) |
QxSqlQuery& qx::QxSqlQuery::freeText | ( | const QString & | text | ) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QStringList & | columns | ) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1 | ) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1, |
const QString & | col2 | ||
) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3 | ||
) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4 | ||
) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5 | ||
) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6 | ||
) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7 | ||
) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7, | ||
const QString & | col8 | ||
) |
QxSqlQuery& qx::QxSqlQuery::groupBy | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7, | ||
const QString & | col8, | ||
const QString & | col9 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariantList & | values | ) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1 | ) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1, |
const QVariant & | val2 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5, | ||
const QVariant & | val6 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5, | ||
const QVariant & | val6, | ||
const QVariant & | val7 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5, | ||
const QVariant & | val6, | ||
const QVariant & | val7, | ||
const QVariant & | val8 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5, | ||
const QVariant & | val6, | ||
const QVariant & | val7, | ||
const QVariant & | val8, | ||
const QVariant & | val9 | ||
) |
QxSqlQuery& qx::QxSqlQuery::in_Select | ( | const QString & | sql | ) |
QxSqlQuery& qx::QxSqlQuery::isBetween | ( | const QVariant & | val1, |
const QVariant & | val2 | ||
) |
bool qx::QxSqlQuery::isDistinct | ( | ) | const |
bool qx::QxSqlQuery::isEmpty | ( | ) | const |
QxSqlQuery& qx::QxSqlQuery::isEqualTo | ( | const QVariant & | val | ) |
QxSqlQuery& qx::QxSqlQuery::isGreaterThan | ( | const QVariant & | val | ) |
QxSqlQuery& qx::QxSqlQuery::isGreaterThanOrEqualTo | ( | const QVariant & | val | ) |
QxSqlQuery& qx::QxSqlQuery::isLessThan | ( | const QVariant & | val | ) |
QxSqlQuery& qx::QxSqlQuery::isLessThanOrEqualTo | ( | const QVariant & | val | ) |
QxSqlQuery& qx::QxSqlQuery::isNotBetween | ( | const QVariant & | val1, |
const QVariant & | val2 | ||
) |
QxSqlQuery& qx::QxSqlQuery::isNotEqualTo | ( | const QVariant & | val | ) |
QxSqlQuery& qx::QxSqlQuery::isNotNull | ( | ) |
QxSqlQuery& qx::QxSqlQuery::isNull | ( | ) |
QxSqlQuery& qx::QxSqlQuery::like | ( | const QString & | val | ) |
QxSqlQuery& qx::QxSqlQuery::limit | ( | int | rowsCount, |
int | startRow = 0 |
||
) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariantList & | values | ) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1 | ) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1, |
const QVariant & | val2 | ||
) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3 | ||
) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4 | ||
) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5 | ||
) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5, | ||
const QVariant & | val6 | ||
) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5, | ||
const QVariant & | val6, | ||
const QVariant & | val7 | ||
) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5, | ||
const QVariant & | val6, | ||
const QVariant & | val7, | ||
const QVariant & | val8 | ||
) |
QxSqlQuery& qx::QxSqlQuery::notIn | ( | const QVariant & | val1, |
const QVariant & | val2, | ||
const QVariant & | val3, | ||
const QVariant & | val4, | ||
const QVariant & | val5, | ||
const QVariant & | val6, | ||
const QVariant & | val7, | ||
const QVariant & | val8, | ||
const QVariant & | val9 | ||
) |
QxSqlQuery& qx::QxSqlQuery::notIn_Select | ( | const QString & | sql | ) |
QxSqlQuery& qx::QxSqlQuery::notLike | ( | const QString & | val | ) |
QxSqlQuery& qx::QxSqlQuery::openParenthesis | ( | ) |
QxSqlQuery& qx::QxSqlQuery::or_ | ( | const QString & | column | ) |
QxSqlQuery& qx::QxSqlQuery::or_OpenParenthesis | ( | const QString & | column | ) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QStringList & | columns | ) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1 | ) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1, |
const QString & | col2 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7, | ||
const QString & | col8 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderAsc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7, | ||
const QString & | col8, | ||
const QString & | col9 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QStringList & | columns | ) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1 | ) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1, |
const QString & | col2 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7, | ||
const QString & | col8 | ||
) |
QxSqlQuery& qx::QxSqlQuery::orderDesc | ( | const QString & | col1, |
const QString & | col2, | ||
const QString & | col3, | ||
const QString & | col4, | ||
const QString & | col5, | ||
const QString & | col6, | ||
const QString & | col7, | ||
const QString & | col8, | ||
const QString & | col9 | ||
) |
void qx::QxSqlQuery::postProcess | ( | QString & | sql | ) | const |
QString qx::QxSqlQuery::query | ( | ) |
QxSqlQuery& qx::QxSqlQuery::query | ( | const QString & | sQuery | ) |
void qx::QxSqlQuery::resolve | ( | QSqlQuery & | query | ) | const |
QxSqlQuery& qx::QxSqlQuery::startsWith | ( | const QString & | val | ) |
void qx::QxSqlQuery::verifyQuery | ( | ) | const [private] |
QxSqlQuery& qx::QxSqlQuery::where | ( | const QString & | column | ) |
QxSqlQuery& qx::QxSqlQuery::where_OpenParenthesis | ( | const QString & | column | ) |
bool qx::QxSqlQuery::m_bDistinct [protected] |
Replace SELECT by SELECT DISTINCT in SQL query.
Definition at line 167 of file QxSqlQuery.h.
int qx::QxSqlQuery::m_iParenthesisCount [protected] |
Current parenthesis count.
Definition at line 166 of file QxSqlQuery.h.
int qx::QxSqlQuery::m_iSqlElementIndex [protected] |
Current index of SQL element.
Definition at line 165 of file QxSqlQuery.h.
QList<qx::dao::detail::IxSqlElement_ptr> qx::QxSqlQuery::m_lstSqlElement [protected] |
List of all SQL elements to build SQL query.
Definition at line 164 of file QxSqlQuery.h.
QxCollection<QString, QVariant> qx::QxSqlQuery::m_lstValue [protected] |
Bind value in this array.
Definition at line 162 of file QxSqlQuery.h.
Temporary SQL element.
Definition at line 163 of file QxSqlQuery.h.
QString qx::QxSqlQuery::m_sQuery [protected] |
Query SQL with place-holder.
Definition at line 161 of file QxSqlQuery.h.