Akonadi
querybuilder.h
106 void addJoin(JoinType joinType, const QString &table, const QString &col1, const QString &col2);
148 void addValueCondition(const QString &column, Query::CompareOperator op, const QVariant &value, ConditionType type = WhereCondition);
158 void addColumnCondition(const QString &column, Query::CompareOperator op, const QString &column2, ConditionType type = WhereCondition);
void setLimit(int limit, int offset=-1)
Limits the amount of retrieved rows.
Definition: querybuilder.cpp:610
void setForUpdate(bool forUpdate=true)
Indicate to the database to acquire an exclusive lock on the rows already during SELECT statement.
Definition: querybuilder.cpp:644
void addColumnCondition(const QString &column, Query::CompareOperator op, const QString &column2, ConditionType type=WhereCondition)
Add a WHERE or HAVING condition which compares a column with another column.
Definition: querybuilder.cpp:160
QString getTableWithColumn(const QString &column) const
Returns concatenated table name with column name.
Definition: querybuilder.cpp:654
JoinType
When the same table gets joined as both, Inner- and LeftJoin, it will be merged into a single InnerJo...
Definition: querybuilder.h:46
void setDistinct(bool distinct)
Specify whether duplicates should be included in the result.
Definition: querybuilder.cpp:605
void setColumnValue(const QString &column, const QVariant &value)
Sets a column to the given value (only valid for INSERT and UPDATE queries).
Definition: querybuilder.cpp:600
void setDatabaseType(DbType::Type type)
Sets the database which should execute the query.
Definition: querybuilder.cpp:128
void addJoin(JoinType joinType, const QString &table, const Query::Condition &condition)
Join a table to the query.
Definition: querybuilder.cpp:133
qint64 insertId()
Returns the ID of the newly created record (only valid for INSERT queries)
Definition: querybuilder.cpp:621
void addAggregation(const QString &col, const QString &aggregate)
Adds an aggregation statement.
Definition: querybuilder.cpp:495
QueryBuilder(const QString &table, QueryType type=Select)
Creates a new query builder.
Definition: querybuilder.cpp:91
QString getTable() const
Returns the name of the main table or subquery.
Definition: querybuilder.cpp:649
void addColumn(const QString &col)
Adds the given column to a select query.
Definition: querybuilder.cpp:483
void addValueCondition(const QString &column, Query::CompareOperator op, const QVariant &value, ConditionType type=WhereCondition)
Add a WHERE or HAVING condition which compares a column with a given value.
Definition: querybuilder.cpp:154
ConditionType
Defines the place at which a condition should be evaluated.
Definition: querybuilder.h:56
void setIdentificationColumn(const QString &column)
Sets the column used for identification in an INSERT statement.
Definition: querybuilder.cpp:616
void addGroupColumns(const QStringList &columns)
Add list of columns to GROUP BY.
Definition: querybuilder.cpp:594
@ HavingCondition
add condition to HAVING part of the query NOTE: only supported for SELECT queries
Definition: querybuilder.h:61
void addColumns(const QStringList &cols)
Adds the given columns to a select query.
Definition: querybuilder.cpp:478
void setSubQueryMode(Query::LogicOperator op, ConditionType type=WhereCondition)
Define how WHERE or HAVING conditions are combined.
Definition: querybuilder.cpp:571
void addCondition(const Query::Condition &condition, ConditionType type=WhereCondition)
Add a WHERE condition.
Definition: querybuilder.cpp:577
void addSortColumn(const QString &column, Query::SortOrder order=Query::Ascending)
Add sort column.
Definition: querybuilder.cpp:583
Helper class to construct arbitrary SQL queries.
Definition: querybuilder.h:31
Helper integration between Akonadi and Qt.
This file is part of the KDE documentation.
Documentation copyright © 1996-2023 The KDE developers.
Generated on Sat Jan 28 2023 03:59:22 by doxygen 1.8.17 written by Dimitri van Heesch, © 1997-2006
Documentation copyright © 1996-2023 The KDE developers.
Generated on Sat Jan 28 2023 03:59:22 by doxygen 1.8.17 written by Dimitri van Heesch, © 1997-2006
KDE's Doxygen guidelines are available online.