Akonadi::Server::SelectQueryBuilder

Search for usage in LXR

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 ()
 
QueryBuilderoperator= (QueryBuilder &&) noexcept
 
QSqlQueryquery ()
 
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
DataStoredataStore () const
 

Detailed Description

template<typename 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 >
Akonadi::Server::SelectQueryBuilder< T >::SelectQueryBuilder ( )
inline

Creates a new query builder.

Definition at line 26 of file selectquerybuilder.h.

◆ SelectQueryBuilder() [2/2]

template<typename T >
Akonadi::Server::SelectQueryBuilder< T >::SelectQueryBuilder ( DataStore * store)
inlineexplicit

Definition at line 31 of file selectquerybuilder.h.

Member Function Documentation

◆ result()

template<typename T >
QList< T > Akonadi::Server::SelectQueryBuilder< T >::result ( )
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

KDE's Doxygen guidelines are available online.