Projekt

Allgemein

Profil

Herunterladen als
Herunterladen (4,08 KB) Statistiken
| Zweig: | Revision:
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
#ifndef QUERY_H
#define QUERY_H
#include <QString>
#include <QHash>
#include <QVariant>
#include <QLinkedList>
#include "join.h"
3160499c Christian Ehringfeld
#include "expression.h"
ae331910 Christian Ehringfeld
#include "orderby.h"
5d93390e Christian Ehringfeld
namespace CuteEntityManager {
2ee5022f Christian Ehringfeld
class Condition;
3160499c Christian Ehringfeld
class OrderBy;
enum class Direction;
2ee5022f Christian Ehringfeld
class Query {
public:
5d93390e Christian Ehringfeld
Query();
82442988 Christian Ehringfeld
~Query();
28d2f01a Christian Ehringfeld
explicit Query(QStringList from, QList<Expression> where = QList<Expression>(),
QList<Join> joins = QList<Join>(),
QHash<QString, QVariant> params = QHash<QString, QVariant>(), quint64 limit = 0,
quint64 offset = 0,
QList<Expression> select = QList<Expression>(),
QStringList groupBy = QStringList(), bool distinct = false,
QList<Expression> having = QList<Expression>());

explicit Query(QString from, Expression where = Expression(),
Join join = Join(),
QHash<QString, QVariant> params = QHash<QString, QVariant>(), quint64 limit = 0,
quint64 offset = 0,
Expression select = Expression(),
QString groupBy = "", bool distinct = false,
QList<Expression> having = QList<Expression>());
5d93390e Christian Ehringfeld
QString getSelectOption() const;
void setSelectOption(const QString &value);

bool getDistinct() const;
void setDistinct(bool value);

82442988 Christian Ehringfeld
void appendFrom(const QString &value);
5d93390e Christian Ehringfeld
QStringList getFrom() const;
void setFrom(const QStringList &value);

82442988 Christian Ehringfeld
void appendJoin(const Join &value);
c9f21778 Christian Ehringfeld
void appendJoins(const QList<Join> &value);
5d93390e Christian Ehringfeld
QList<Join> getJoins() const;
void setJoins(const QList<Join> &value);

void appendParam(const QString &column, QVariant value);
506067a2 Christian Ehringfeld
void appendParams(const QHash<QString, QVariant> &params);
5d93390e Christian Ehringfeld
QHash<QString, QVariant> getParams() const;
void setParams(const QHash<QString, QVariant> &value);

506067a2 Christian Ehringfeld
quint64 getLimit() const;
void setLimit(const quint64 &value);
5d93390e Christian Ehringfeld
506067a2 Christian Ehringfeld
quint64 getOffset() const;
void setOffset(const quint64 &value);
5d93390e Christian Ehringfeld
3160499c Christian Ehringfeld
void appendOrderBy(const OrderBy &orderBy);
void appendOrderBy(const QString &column, const Direction &direction);
QList<OrderBy> getOrderBy() const;
void setOrderBy(const QList<OrderBy> &value);

82442988 Christian Ehringfeld
void appendGroupBy(const QString &value);
3160499c Christian Ehringfeld
QStringList getGroupBy() const;
void setGroupBy(const QStringList &value);

QList<Expression> getSelect() const;
void appendSelect(const Expression &value);
void appendSelect(const QString &value);
void setSelect(const QList<Expression> &value);
void setSelect(const QStringList &value);
5d93390e Christian Ehringfeld
82442988 Christian Ehringfeld
void appendWhere(const QString &condition);
void appendWhere(const Expression &condition);
506067a2 Christian Ehringfeld
QList<Expression> getWhere() const;
void setWhere(const QList<Expression> &value);

82442988 Christian Ehringfeld
void appendHaving(const QString &condition);
void appendHaving(const Expression &condition);
506067a2 Christian Ehringfeld
QList<Expression> getHaving() const;
void setHaving(const QList<Expression> &value);

38838b5b Christian Ehringfeld
private:
3160499c Christian Ehringfeld
QList<Expression> select;
5d93390e Christian Ehringfeld
QString selectOption = QStringLiteral("");
bool distinct = false;
QStringList from;
QStringList groupBy;
3160499c Christian Ehringfeld
QList<OrderBy> orderBy;
506067a2 Christian Ehringfeld
QList<Expression> where;
QList<Expression> having;
5d93390e Christian Ehringfeld
QList<Join> joins;
QHash<QString, QVariant> params;
506067a2 Christian Ehringfeld
quint64 limit = 0;
quint64 offset = 0;
5d93390e Christian Ehringfeld
};

enum class JokerPosition {
FRONT, // e.g. "%foo"
BEHIND, // e.g. "foo%"
584721e5 Christian Ehringfeld
BOTH, // e.g. "%foo%"
NONE
5d93390e Christian Ehringfeld
};


}

#endif // QUERY_H