Revision 584721e5
Von Christian Ehringfeld vor mehr als 8 Jahren hinzugefügt
| src/query.h | ||
|---|---|---|
|
enum class JokerPosition {
|
||
|
FRONT, // e.g. "%foo"
|
||
|
BEHIND, // e.g. "foo%"
|
||
|
BOTH // e.g. "%foo%"
|
||
|
BOTH, // e.g. "%foo%"
|
||
|
NONE
|
||
|
};
|
||
|
|
||
|
|
||
| src/querybuilder.cpp | ||
|---|---|---|
|
return QString(superMeta->className()).toLower();
|
||
|
}
|
||
|
|
||
|
QString QueryBuilder::addWildcard(QVariant var, JokerPosition jp,
|
||
|
QChar jokerChar) const {
|
||
|
QString val = var.toString();
|
||
|
if (!val.isEmpty()) {
|
||
|
switch (jp) {
|
||
|
case JokerPosition::BEHIND:
|
||
|
val += jokerChar;
|
||
|
break;
|
||
|
case JokerPosition::BOTH:
|
||
|
val = jokerChar + val + jokerChar;
|
||
|
break;
|
||
|
case JokerPosition::FRONT:
|
||
|
val = jokerChar + val;
|
||
|
break;
|
||
|
case JokerPosition::NONE:
|
||
|
break;
|
||
|
default:
|
||
|
break;
|
||
|
}
|
||
|
}
|
||
|
return val;
|
||
|
}
|
||
|
|
||
|
QString QueryBuilder::joinSuperClasses(const QSharedPointer<Entity> &entity)
|
||
|
const {
|
||
|
auto classes = EntityHelper::superClasses(entity.data(), true);
|
||
| ... | ... | |
|
QString QueryBuilder::countFunction(const QString &distinctColumn) const {
|
||
|
return QString(this->countKeyword() + "(" + (distinctColumn.isEmpty() ? "*" :
|
||
|
(this->distinct() +
|
||
|
this->schema->quoteColumnName(distinctColumn))) + ")");
|
||
|
this->schema->quoteColumnName(distinctColumn))) + ")");
|
||
|
}
|
||
|
|
||
|
QString QueryBuilder::distinct() const {
|
||
| ... | ... | |
|
this->placeHolder(valName2) + ")";
|
||
|
}
|
||
|
|
||
|
QString QueryBuilder::likeKeyword() const {
|
||
|
return "LIKE";
|
||
|
}
|
||
|
|
||
|
QString QueryBuilder::limitKeyword() const {
|
||
|
return "LIMIT";
|
||
|
}
|
||
|
|
||
|
QString QueryBuilder::offsetKeyword() const {
|
||
|
return "OFFSET";
|
||
|
}
|
||
|
|
||
|
QString QueryBuilder::appendNot(bool notOp) {
|
||
|
return (notOp ? (this->notKeyword() + " ") : "");
|
||
|
}
|
||
| ... | ... | |
|
QString QueryBuilder::limit(const qint64 &limit, const qint64 &offset) const {
|
||
|
QString s = "";
|
||
|
if (limit > 0) {
|
||
|
s.append(" LIMIT ").append(QString::number(limit));
|
||
|
s.append(" " + this->limitKeyword() + " ").append(QString::number(limit));
|
||
|
}
|
||
|
if (offset > 0) {
|
||
|
s.append(" OFFSET ").append(QString::number(offset));
|
||
|
s.append(" " + this->offsetKeyword() + " ").append(QString::number(offset));
|
||
|
}
|
||
|
return s;
|
||
|
}
|
||
| ... | ... | |
|
if (m.size() == 0 || (ignoreID && m.contains(primaryKey) && m.size() == 1)) {
|
||
|
return "";
|
||
|
}
|
||
|
return (withKeyword ? " WHERE " : "") + this->attributes(m, conjunction, ignoreID, primaryKey);
|
||
|
return (withKeyword ? " WHERE " : "") + this->attributes(m, conjunction,
|
||
|
ignoreID, primaryKey);
|
||
|
}
|
||
|
|
||
|
QString QueryBuilder::attributes(const QHash<QString, QVariant> &m,
|
||
| ... | ... | |
|
|
||
|
void QueryBuilder::arbitraryOperator(Query &query, QString op, QString column,
|
||
|
QVariant value) {
|
||
|
query.appendCondition(column + " " + op + this->placeHolder(column));
|
||
|
query.appendCondition(this->schema->quoteColumnName(column) + " " + op + " " +
|
||
|
this->placeHolder(column));
|
||
|
query.appendParam(column, value);
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::isNull(Query &query, QString column) {
|
||
|
query.appendCondition(this->schema->quoteColumnName(column) + " IS NULL");
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::isNotNull(Query &query, QString column) {
|
||
|
query.appendCondition(this->schema->quoteColumnName(column) + " IS " +
|
||
|
this->notKeyword() + " NULL");
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::plainOr(Query &query) {
|
||
|
query.appendCondition(this->orKeyword());
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::plainNor(Query &query) {
|
||
|
query.appendCondition(this->notKeyword() + " " + this->orKeyword());
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::plainAnd(Query &query) {
|
||
|
query.appendCondition(this->andKeyword());
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::plainNand(Query &query) {
|
||
|
query.appendCondition(this->notKeyword() + " " + this->andKeyword());
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::like(Query &query, QString column, QVariant value,
|
||
|
JokerPosition jp, QChar wildcard) {
|
||
|
this->arbitraryOperator(query, this->likeKeyword(), column,
|
||
|
this->addWildcard(value, jp, wildcard));
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::like(Query &query, QHash<QString, QVariant> conditions,
|
||
|
QString conjunction,
|
||
|
JokerPosition jp, QChar wildcard) {
|
||
|
QString condition = "(";
|
||
|
if (!conditions.isEmpty()) {
|
||
|
bool first = true;
|
||
|
for (auto i = conditions.constBegin(); i != conditions.constEnd(); ++i) {
|
||
|
if (first) {
|
||
|
first = false;
|
||
|
} else {
|
||
|
condition += conjunction;
|
||
|
}
|
||
|
condition += this->schema->quoteColumnName(i.key()) + " " + this->likeKeyword()
|
||
|
+ " " +
|
||
|
this->placeHolder(i.key());
|
||
|
QString newVal = this->addWildcard(i.value(), jp, wildcard);
|
||
|
query.appendParam(i.key(), newVal.isEmpty() ? i.value() : newVal);
|
||
|
}
|
||
|
condition += ")";
|
||
|
query.appendCondition(condition);
|
||
|
}
|
||
|
}
|
||
|
|
||
|
QSqlQuery QueryBuilder::generateQuery(const Query &query) const {
|
||
|
|
||
|
}
|
||
|
|
||
|
|
||
|
void QueryBuilder::where(Query &query, QString column, QVariant value) {
|
||
|
QString placeholder = column + "_where";
|
||
| ... | ... | |
|
}
|
||
|
|
||
|
void QueryBuilder::where(Query &query, QHash<QString, QVariant> conditions,
|
||
|
QString concat) {
|
||
|
QString condition = this->where(conditions,concat,false,"id",false);
|
||
|
QString conjunction) {
|
||
|
QString condition = this->where(conditions, conjunction, false, "id", false);
|
||
|
for (auto i = conditions.constBegin(); i != conditions.constEnd(); ++i) {
|
||
|
query.appendParam(i.key(),i.value());
|
||
|
query.appendParam(i.key(), i.value());
|
||
|
}
|
||
|
query.appendCondition(condition);
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::where(Query &query, QString condition,
|
||
|
QHash<QString, QVariant> values) {
|
||
|
query.appendCondition(condition);
|
||
|
for (auto i = values.constBegin(); i != values.constEnd(); ++i) {
|
||
|
query.appendParam(i.key(), i.value());
|
||
|
}
|
||
|
}
|
||
|
|
||
|
void QueryBuilder::between(Query &query, QString column, QVariant firstValue,
|
||
|
QVariant secondValue) {
|
||
|
QString firstPh = column + "_bet1";
|
||
| ... | ... | |
|
} else {
|
||
|
condition += " " + this->orKeyword() + " ";
|
||
|
}
|
||
|
condition += this->schema->quoteColumnName(i.key()) + (like ? " LIKE " : "=") +
|
||
|
condition += this->schema->quoteColumnName(i.key()) + (like ? " " +
|
||
|
this->likeKeyword() + " " : "=") +
|
||
|
this->placeHolder(i.key());
|
||
|
query.appendParam(i.key(), i.value());
|
||
|
}
|
||
| ... | ... | |
|
QString QueryBuilder::where(const QSharedPointer<Entity> &entity,
|
||
|
QString conjunction,
|
||
|
bool ignoreID) const {
|
||
|
return this->where(EntityHelper::getEntityAttributes(EntityHelper::getMetaProperties(
|
||
|
entity.data()),
|
||
|
entity),
|
||
|
return this->where(EntityHelper::getEntityAttributes(
|
||
|
EntityHelper::getMetaProperties(
|
||
|
entity.data()),
|
||
|
entity),
|
||
|
conjunction, ignoreID, entity->getPrimaryKey());
|
||
|
}
|
||
| src/querybuilder.h | ||
|---|---|---|
|
void bindValue(const QString &key, const QVariant &value, QSqlQuery &q) const;
|
||
|
virtual QString placeHolder(const QString &key) const;
|
||
|
void where(Query &query, QString column, QVariant value);
|
||
|
/**
|
||
|
* @brief where
|
||
|
* @param query
|
||
|
* @param conditions
|
||
|
* @param conjunction its AND or OR
|
||
|
*/
|
||
|
void where(Query &query, QHash<QString, QVariant> conditions,
|
||
|
QString concat = "AND");
|
||
|
QString conjunction = "AND");
|
||
|
void where(Query &query, QString condition,QHash<QString, QVariant> values= QHash<QString, QVariant>());
|
||
|
//void where(Query &query,QHash<QString, QList<QVariant>> conditions, QString concat="AND");
|
||
|
void between(Query &query, QString column, QVariant firstValue,
|
||
|
QVariant secondValue);
|
||
| ... | ... | |
|
void orOperator(Query &query, QHash<QString, QVariant> conditions,
|
||
|
bool like = false);
|
||
|
void andOperator(Query &query, QHash<QString, QVariant> conditions);
|
||
|
/**
|
||
|
* @brief arbitraryOperator
|
||
|
* @param query
|
||
|
* @param op can be = | != | <> | > | < | >= | <= | !< | !> @see http://www.tutorialspoint.com/sql/sql-operators.htm comparison operators
|
||
|
* @param column
|
||
|
* @param value
|
||
|
*/
|
||
|
void arbitraryOperator(Query &query, QString op, QString column,
|
||
|
QVariant value);
|
||
|
void isNull(Query &query, QString column);
|
||
|
void isNotNull(Query &query, QString column);
|
||
|
|
||
|
void plainOr(Query &query); //adds a simple OR to condition
|
||
|
void plainNor(Query &query);
|
||
|
void plainAnd(Query &query); //add a simple AND to condition
|
||
|
void plainNand(Query &query);
|
||
|
/**
|
||
|
* Generates 'foo' LIKE "%bar%"
|
||
|
* @brief like
|
||
|
* @param column
|
||
|
* @param value
|
||
|
*/
|
||
|
void like(QString column, QString value, JokerPosition = JokerPosition::BOTH);
|
||
|
void like(Query &q, QString column, QVariant value, JokerPosition jp = JokerPosition::BOTH, QChar wildcard ='%');
|
||
|
/**
|
||
|
* @brief like
|
||
|
* @param condition
|
||
|
* @param concat
|
||
|
*/
|
||
|
void like(QHash<QString, QVariant> conditions, QString concat = "AND",
|
||
|
JokerPosition = JokerPosition::BOTH);
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
void like(Query &query, QHash<QString, QVariant> conditions, QString conjunction = "AND",
|
||
|
JokerPosition jp= JokerPosition::BOTH, QChar wildcard ='%');
|
||
|
|
||
|
protected:
|
||
|
class ClassAttributes {
|
||
| ... | ... | |
|
QString pk;
|
||
|
QHash<QString, QVariant> attributes;
|
||
|
};
|
||
|
QSqlQuery generateQuery(const Query &query) const;
|
||
|
|
||
|
QSqlQuery find(const qint64 &id, const QString &tableName) const;
|
||
|
QSqlQuery find(const qint64 &id, const QSharedPointer<Entity> &entity,
|
||
| ... | ... | |
|
QString leftJoin(const QString &foreignTable, const QString &tableName,
|
||
|
const QString &foreignKey = "id", const QString &primaryKey = "id") const;
|
||
|
QString superClassColumnName(const QMetaObject *&superMeta) const;
|
||
|
QString addWildcard(QVariant var, JokerPosition jp, QChar jokerChar = '%') const;
|
||
|
|
||
|
QString joinSuperClasses(const QSharedPointer<Entity> &entity) const;
|
||
|
virtual QString selectBase(const QStringList &tables,
|
||
| ... | ... | |
|
bool notOp = false);
|
||
|
virtual QString between(QString colName, QString valName1, QString valName2,
|
||
|
bool notOp = false);
|
||
|
virtual QString likeKeyword() const;
|
||
|
virtual QString limitKeyword() const;
|
||
|
virtual QString offsetKeyword() const;
|
||
|
QString appendNot(bool notOp);
|
||
|
virtual void appendCondition(Query &q, QString ph1, QString ph2, QVariant val1,
|
||
|
QVariant val2, QString condition);
|
||
Auch abrufbar als: Unified diff
query stuff