Akonadi::Server::SelectQueryBuilder
Akonadi::Server::SelectQueryBuilder< T > Class Template Reference
#include <selectquerybuilder.h>
Inheritance diagram for Akonadi::Server::SelectQueryBuilder< T >:
Public Member Functions | |
SelectQueryBuilder () | |
SelectQueryBuilder (DataStore *store) | |
QList< T > | result () |
Public Member Functions inherited from Akonadi::Server::QueryBuilder | |
QueryBuilder (const QSqlQuery &tableQuery, const QString &tableQueryAlias) | |
QueryBuilder (const QString &table, QueryType type=Select) | |
QueryBuilder (DataStore *store, const QSqlQuery &tableQuery, const QString &tableQueryAlias) | |
QueryBuilder (DataStore *store, const QString &table, QueryType type=Select) | |
QueryBuilder (QueryBuilder &&) noexcept | |
void | addAggregation (const QString &col, const QString &aggregate) |
void | addAggregation (const Query::Case &caseStmt, const QString &aggregate) |
void | addColumn (const QString &col) |
void | addColumn (const Query::Case &caseStmt) |
void | addColumnCondition (const QString &column, Query::CompareOperator op, const QString &column2, ConditionType type=WhereCondition) |
void | addColumns (const QStringList &cols) |
void | addCondition (const Query::Condition &condition, ConditionType type=WhereCondition) |
void | addGroupColumn (const QString &column) |
void | addGroupColumns (const QStringList &columns) |
void | addJoin (JoinType joinType, const QString &table, const QString &col1, const QString &col2) |
void | addJoin (JoinType joinType, const QString &table, const Query::Condition &condition) |
void | addSortColumn (const QString &column, Query::SortOrder order=Query::Ascending) |
void | addValueCondition (const QString &column, Query::CompareOperator op, const QList< qint64 > &value, ConditionType type=WhereCondition) |
void | addValueCondition (const QString &column, Query::CompareOperator op, const QSet< qint64 > &value, ConditionType type=WhereCondition) |
void | addValueCondition (const QString &column, Query::CompareOperator op, const QVariant &value, ConditionType type=WhereCondition) |
bool | exec () |
QString | getTable () const |
QString | getTableWithColumn (const QString &column) const |
qint64 | insertId () |
QueryBuilder & | operator= (QueryBuilder &&) noexcept |
QSqlQuery & | query () |
void | setColumnValue (const QString &column, const QVariant &value) |
template<typename T > | |
void | setColumnValues (const QString &column, const QList< T > &values) |
void | setDatabaseType (DbType::Type type) |
void | setDistinct (bool distinct) |
void | setForUpdate (bool forUpdate=true) |
void | setIdentificationColumn (const QString &column) |
void | setLimit (int limit, int offset=-1) |
void | setSubQueryMode (Query::LogicOperator op, ConditionType type=WhereCondition) |
Additional Inherited Members | |
Public Types inherited from Akonadi::Server::QueryBuilder | |
enum | ConditionType { WhereCondition , HavingCondition , NUM_CONDITIONS } |
enum | JoinType { InnerJoin , LeftJoin , LeftOuterJoin } |
enum | QueryType { Select , Insert , Update , Delete } |
Protected Member Functions inherited from Akonadi::Server::QueryBuilder | |
DataStore * | dataStore () const |
Detailed Description
template<typename T>
class Akonadi::Server::SelectQueryBuilder< T >
class Akonadi::Server::SelectQueryBuilder< T >
Helper class for creating and executing database SELECT queries.
Definition at line 20 of file selectquerybuilder.h.
Constructor & Destructor Documentation
◆ SelectQueryBuilder() [1/2]
template<typename T >
|
inline |
Creates a new query builder.
Definition at line 26 of file selectquerybuilder.h.
◆ SelectQueryBuilder() [2/2]
template<typename T >
|
inlineexplicit |
Definition at line 31 of file selectquerybuilder.h.
Member Function Documentation
◆ result()
template<typename T >
|
inline |
Returns the result of this SELECT query.
Definition at line 40 of file selectquerybuilder.h.
The documentation for this class was generated from the following file:
This file is part of the KDE documentation.
Documentation copyright © 1996-2024 The KDE developers.
Generated on Mon Nov 18 2024 12:08:30 by doxygen 1.12.0 written by Dimitri van Heesch, © 1997-2006
Documentation copyright © 1996-2024 The KDE developers.
Generated on Mon Nov 18 2024 12:08:30 by doxygen 1.12.0 written by Dimitri van Heesch, © 1997-2006
KDE's Doxygen guidelines are available online.