Akonadi::Server::CountQueryBuilder

Search for usage in LXR

Akonadi::Server::CountQueryBuilder Class Reference

#include <countquerybuilder.h>

Inheritance diagram for Akonadi::Server::CountQueryBuilder:

Public Types

enum  CountMode { All, Distinct }
 
- Public Types inherited from Akonadi::Server::QueryBuilder
enum  ConditionType { WhereCondition, HavingCondition, NUM_CONDITIONS }
 
enum  JoinType { InnerJoin, LeftJoin }
 
enum  QueryType { Select, Insert, Update, Delete }
 

Public Member Functions

 CountQueryBuilder (const QString &table)
 
 CountQueryBuilder (const QString &table, const QString &column, CountMode mode)
 
int result ()
 
- Public Member Functions inherited from Akonadi::Server::QueryBuilder
 QueryBuilder (const QSqlQuery &tableQuery, const QString &tableQueryAlias)
 
 QueryBuilder (const QString &table, QueryType type=Select)
 
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 QVariant &value, ConditionType type=WhereCondition)
 
bool exec ()
 
QString getTable () const
 
QString getTableWithColumn (const QString &column) const
 
qint64 insertId ()
 
QSqlQueryquery ()
 
void setColumnValue (const QString &column, const QVariant &value)
 
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)
 

Detailed Description

Helper class for creating queries to count elements in a database.

Definition at line 22 of file countquerybuilder.h.

Constructor & Destructor Documentation

◆ CountQueryBuilder() [1/2]

Akonadi::Server::CountQueryBuilder::CountQueryBuilder ( const QString table)
inlineexplicit

Creates a new query builder that counts all entries in table.

Definition at line 33 of file countquerybuilder.h.

◆ CountQueryBuilder() [2/2]

Akonadi::Server::CountQueryBuilder::CountQueryBuilder ( const QString table,
const QString column,
CountMode  mode 
)
inline

Creates a new query builder that counts entries in column of table.

If mode is set to Distinct, duplicate entries in that column are ignored.

Definition at line 43 of file countquerybuilder.h.

Member Function Documentation

◆ result()

int Akonadi::Server::CountQueryBuilder::result ( )
inline

Returns the result of this query.

Returns
-1 on error.

Definition at line 61 of file countquerybuilder.h.


The documentation for this class was generated from the following file:
This file is part of the KDE documentation.
Documentation copyright © 1996-2022 The KDE developers.
Generated on Fri Aug 12 2022 04:00:09 by doxygen 1.8.17 written by Dimitri van Heesch, © 1997-2006

KDE's Doxygen guidelines are available online.