Revision 3160499c
Von Christian Ehringfeld vor mehr als 8 Jahren hinzugefügt
src/queryinterpreter.h | ||
---|---|---|
|
||
#include <QSqlQuery>
|
||
#include <QSharedPointer>
|
||
#include <QRegularExpressionMatchIterator>
|
||
namespace CuteEntityManager {
|
||
class Query;
|
||
class QueryBuilder;
|
||
class Condition;
|
||
class Join;
|
||
class OrderBy;
|
||
class Expression;
|
||
class QueryInterpreter {
|
||
public:
|
||
QueryInterpreter(QSharedPointer<QueryBuilder> builder);
|
||
QSqlQuery interpretQuery(Query &q);
|
||
QSqlQuery build(const Query &q);
|
||
|
||
protected:
|
||
QString buildSelect(const QList<Expression> &columns, const bool &distinct = false,
|
||
const QString &selectOption = "") const;
|
||
QString buildFrom(const QStringList &from) const;
|
||
QString buildJoin(const QList<Join> &joins) const;
|
||
QString buildWhere(const QList<Condition> &conditions) const;
|
||
QString buildGroupBy(const QStringList &groupBy) const;
|
||
QString buildHaving(const QList<Condition> &conditions) const;
|
||
QString buildOrderByAndLimit(QString sql, const QList<OrderBy> &orderBy,
|
||
const quint64 &limit, const quint64 &offset) const;
|
||
QString buildOrderBy(const QList<OrderBy> &columns) const;
|
||
QString buildCondition(const QList<Condition> &conditions) const;
|
||
QString buildCondition(const Condition &conditions) const;
|
||
|
||
private:
|
||
QSharedPointer<QueryBuilder> builder;
|
||
|
||
};
|
||
|
||
|
||
|
||
|
||
//QStringList select;
|
||
//QString selectOption = QStringLiteral("");
|
||
//bool distinct = false;
|
||
//QStringList from;
|
||
//QStringList groupBy;
|
||
//QStringList orderBy;
|
||
//QLinkedList<Condition> conditions;
|
||
//QList<Join> joins;
|
||
//QHash<QString, QVariant> params;
|
||
//uint limit = 0;
|
||
//uint offset = 0;
|
||
|
||
|
||
|
||
//protected $conditionBuilders = [
|
||
// 'NOT' => 'buildNotCondition',
|
||
// 'AND' => 'buildAndCondition',
|
||
// 'OR' => 'buildAndCondition',
|
||
// 'BETWEEN' => 'buildBetweenCondition',
|
||
// 'NOT BETWEEN' => 'buildBetweenCondition',
|
||
// 'IN' => 'buildInCondition',
|
||
// 'NOT IN' => 'buildInCondition',
|
||
// 'LIKE' => 'buildLikeCondition',
|
||
// 'NOT LIKE' => 'buildLikeCondition',
|
||
// 'OR LIKE' => 'buildLikeCondition',
|
||
// 'OR NOT LIKE' => 'buildLikeCondition',
|
||
// 'EXISTS' => 'buildExistsCondition',
|
||
// 'NOT EXISTS' => 'buildExistsCondition',
|
||
// ];
|
||
|
||
|
||
}
|
||
|
||
#endif // QUERYINTERPRETER_H
|
Auch abrufbar als: Unified diff
queryinterpreter/builder wip