Herunterladen als
root/src/query.cpp @ 77dbed04
38838b5b | Christian Ehringfeld | /*
|
|
* Copyright (C) 2015 Christian Ehringfeld <c.ehringfeld@t-online.de>
|
|||
*
|
|||
* This program is free software; you can redistribute it and/or modify it
|
|||
* under the terms of the GNU Lesser General Public License as published by
|
|||
* the Free Software Foundation.
|
|||
*
|
|||
* This program is distributed in the hope that it will be useful, but
|
|||
* WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
|
|||
* or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
|
|||
* for more details.
|
|||
*
|
|||
* You should have received a copy of the GNU Lesser General Public License
|
|||
* along with this program; if not, see <http://www.gnu.org/licenses/>.
|
|||
*/
|
|||
5d93390e | Christian Ehringfeld | #include "query.h"
|
|
using namespace CuteEntityManager;
|
|||
Query::Query() {
|
|||
}
|
|||
82442988 | Christian Ehringfeld | Query::~Query() {
|
|
}
|
|||
506067a2 | Christian Ehringfeld | Query::Query(QStringList from, QList<Expression> where, QList<Join> joins,
|
|
QHash<QString, QVariant> params, quint64 limit, quint64 offset,
|
|||
QList<Expression> select, QStringList groupBy, bool distinct,
|
|||
QList<Expression> having) {
|
|||
this->from = from;
|
|||
this->where = where;
|
|||
this->joins = joins;
|
|||
this->params = params;
|
|||
this->limit = limit;
|
|||
this->offset = offset;
|
|||
this->select = select;
|
|||
this->groupBy = groupBy;
|
|||
this->distinct = distinct;
|
|||
this->having = having;
|
|||
5d93390e | Christian Ehringfeld | }
|
|
28d2f01a | Christian Ehringfeld | Query::Query(QString from, Expression where, Join join,
|
|
QHash<QString, QVariant> params, quint64 limit, quint64 offset,
|
|||
Expression select, QString groupBy, bool distinct, QList<Expression> having) {
|
|||
this->from.append(from);
|
|||
this->where.append(where);
|
|||
this->joins.append(join);
|
|||
this->params = params;
|
|||
this->limit = limit;
|
|||
this->offset = offset;
|
|||
this->select.append(select);
|
|||
this->groupBy.append(groupBy);
|
|||
this->distinct = distinct;
|
|||
this->having = having;
|
|||
}
|
|||
506067a2 | Christian Ehringfeld | void Query::appendWhere(const QString &condition) {
|
|
this->where.append(Expression(condition));
|
|||
}
|
|||
void Query::appendWhere(const Expression &condition) {
|
|||
3160499c | Christian Ehringfeld | this->where.append(condition);
|
|
2ee5022f | Christian Ehringfeld | }
|
|
5d93390e | Christian Ehringfeld | ||
void Query::setSelect(const QStringList &value) {
|
|||
3160499c | Christian Ehringfeld | for (int var = 0; var < value.size(); ++var) {
|
|
this->appendSelect(value.at(var));
|
|||
}
|
|||
5d93390e | Christian Ehringfeld | }
|
|
3160499c | Christian Ehringfeld | ||
506067a2 | Christian Ehringfeld | QList<Expression> Query::getWhere() const {
|
|
return where;
|
|||
}
|
|||
void Query::setWhere(const QList<Expression> &value) {
|
|||
where = value;
|
|||
}
|
|||
QList<Expression> Query::getHaving() const {
|
|||
return having;
|
|||
}
|
|||
void Query::setHaving(const QList<Expression> &value) {
|
|||
having = value;
|
|||
}
|
|||
5d93390e | Christian Ehringfeld | QString Query::getSelectOption() const {
|
|
return selectOption;
|
|||
}
|
|||
void Query::setSelectOption(const QString &value) {
|
|||
selectOption = value;
|
|||
}
|
|||
3160499c | Christian Ehringfeld | ||
5d93390e | Christian Ehringfeld | bool Query::getDistinct() const {
|
|
return distinct;
|
|||
}
|
|||
void Query::setDistinct(bool value) {
|
|||
distinct = value;
|
|||
}
|
|||
3160499c | Christian Ehringfeld | ||
82442988 | Christian Ehringfeld | void Query::appendFrom(const QString &value) {
|
|
if (!this->from.contains(value)) {
|
|||
this->from.append(value);
|
|||
}
|
|||
}
|
|||
5d93390e | Christian Ehringfeld | QStringList Query::getFrom() const {
|
|
return from;
|
|||
}
|
|||
void Query::setFrom(const QStringList &value) {
|
|||
from = value;
|
|||
}
|
|||
3160499c | Christian Ehringfeld | ||
82442988 | Christian Ehringfeld | void Query::appendJoin(const Join &value) {
|
|
if (!this->joins.contains(value)) {
|
|||
this->joins.append(value);
|
|||
}
|
|||
}
|
|||
c9f21778 | Christian Ehringfeld | void Query::appendJoins(const QList<Join> &value) {
|
|
this->joins.append(value);
|
|||
}
|
|||
5d93390e | Christian Ehringfeld | QStringList Query::getGroupBy() const {
|
|
return groupBy;
|
|||
}
|
|||
void Query::setGroupBy(const QStringList &value) {
|
|||
groupBy = value;
|
|||
}
|
|||
3160499c | Christian Ehringfeld | ||
506067a2 | Christian Ehringfeld | QList<Expression> Query::getSelect() const {
|
|
return this->select;
|
|||
}
|
|||
3160499c | Christian Ehringfeld | void Query::appendSelect(const Expression &value) {
|
|
this->select.append(value);
|
|||
5d93390e | Christian Ehringfeld | }
|
|
3160499c | Christian Ehringfeld | void Query::appendSelect(const QString &value) {
|
|
this->select.append(Expression(value, true));
|
|||
5d93390e | Christian Ehringfeld | }
|
|
3160499c | Christian Ehringfeld | ||
5d93390e | Christian Ehringfeld | QList<Join> Query::getJoins() const {
|
|
return joins;
|
|||
}
|
|||
void Query::setJoins(const QList<Join> &value) {
|
|||
joins = value;
|
|||
}
|
|||
void Query::appendParam(const QString &column, QVariant value) {
|
|||
this->params.insert(column, value);
|
|||
}
|
|||
506067a2 | Christian Ehringfeld | void Query::appendParams(const QHash<QString, QVariant> ¶ms) {
|
|
for (auto i = params.constBegin(); i != params.constEnd(); ++i) {
|
|||
this->params.insert(i.key(), i.value());
|
|||
}
|
|||
}
|
|||
5d93390e | Christian Ehringfeld | QHash<QString, QVariant> Query::getParams() const {
|
|
return params;
|
|||
}
|
|||
void Query::setParams(const QHash<QString, QVariant> &value) {
|
|||
params = value;
|
|||
}
|
|||
506067a2 | Christian Ehringfeld | quint64 Query::getLimit() const {
|
|
5d93390e | Christian Ehringfeld | return limit;
|
|
}
|
|||
506067a2 | Christian Ehringfeld | void Query::setLimit(const quint64 &value) {
|
|
5d93390e | Christian Ehringfeld | limit = value;
|
|
}
|
|||
506067a2 | Christian Ehringfeld | quint64 Query::getOffset() const {
|
|
5d93390e | Christian Ehringfeld | return offset;
|
|
}
|
|||
506067a2 | Christian Ehringfeld | void Query::setOffset(const quint64 &value) {
|
|
5d93390e | Christian Ehringfeld | offset = value;
|
|
}
|
|||
3160499c | Christian Ehringfeld | ||
506067a2 | Christian Ehringfeld | void Query::appendHaving(const QString &condition) {
|
|
this->having.append(Expression(condition));
|
|||
3160499c | Christian Ehringfeld | }
|
|
506067a2 | Christian Ehringfeld | void Query::appendHaving(const Expression &condition) {
|
|
3160499c | Christian Ehringfeld | this->having.append(condition);
|
|
}
|
|||
void Query::appendOrderBy(const OrderBy &orderBy) {
|
|||
this->orderBy.append(orderBy);
|
|||
}
|
|||
void Query::appendOrderBy(const QString &column, const Direction &direction) {
|
|||
this->orderBy.append(OrderBy(column, direction));
|
|||
}
|
|||
QList<OrderBy> Query::getOrderBy() const {
|
|||
return orderBy;
|
|||
}
|
|||
void Query::setOrderBy(const QList<OrderBy> &value) {
|
|||
orderBy = value;
|
|||
}
|
|||
82442988 | Christian Ehringfeld | ||
void Query::appendGroupBy(const QString &value) {
|
|||
if (!this->groupBy.contains(value)) {
|
|||
this->groupBy.append(value);
|
|||
}
|
|||
}
|