getsinglevalue.cpp

Go to the documentation of this file.

/*
 * Copyright (C) 2018-2024 QuasarApp.
 * Distributed under the lgplv3 software license, see the accompanying
 * Everyone is permitted to copy and distribute verbatim copies
 * of this license document, but changing it is not allowed.
*/
 
#include "getsinglevalue.h"
 
#include <QSqlQuery>
 
namespace QH {
 
 
namespace PKG {
 
GetSingleValue::GetSingleValue(const DbAddress& address,
                               const QString& field,
                               const QString& primaryKey) {
 
    _table = address.table();
    _primaryValue = address.id();
    _field = field;
    _primaryKey = primaryKey;
}
 
QVariant GetSingleValue::value() const {
    return _value;
}
 
DBObject *GetSingleValue::createDBObject() const {
    return create<GetSingleValue>(dbAddress(), _field);
}
 
PrepareResult GetSingleValue::prepareSelectQuery(QSqlQuery &q) const {
    QString queryString = "SELECT %0 FROM %1 WHERE %2=:%2";
    queryString = queryString.arg(_field, table(), _primaryKey);
 
    if (!q.prepare(queryString)) {
        return PrepareResult::Fail;
    }
 
    q.bindValue(":" + _primaryKey, _primaryValue);
 
    return PrepareResult::Success;
}
 
bool GetSingleValue::fromSqlRecord(const QSqlRecord &q) {
    _value = q.value(0);
 
    return true;
}
 
bool GetSingleValue::isCached() const {
    return false;
}
 
QString GetSingleValue::table() const {
    return _table;
}
 
QString GetSingleValue::primaryKey() const {
    return _primaryKey;
}
 
QVariant GetSingleValue::primaryValue() const {
    return _primaryValue;
}
 
}
}