8 #ifndef GETBALANCEREQUEST_H
9 #define GETBALANCEREQUEST_H
47 QJsonObject
execute(
const QJsonObject& jsonObj, QMutex& m)
override
49 QMutexLocker locker(&m);
56 response.insert(
"Response", 3);
59 if (jsonObj.contains(
"Data"))
61 QJsonObject dataObj = jsonObj[
"Data"].toObject();
63 if (dataObj.contains(
"account_number"))
65 accountNumber = dataObj.value(
"account_number").toInt();
70 qCritical() <<
"Data not found";
81 dbManager->
select(
"balance")->
table(
"Accounts")->
where(
"account_number =", accountNumber)->
exec();
88 QJsonObject obj = result.
first();
90 data.insert(
"status",
int(
true));
91 data.insert(
"message",
"Balance fetched successfully");
92 data.insert(
"balance", obj.value(
"balance").toDouble());
94 response.insert(
"Data", data);
98 QJsonDocument responseDoc(response);
99 QByteArray responseData = responseDoc.toJson();
102 qDebug().noquote() <<
"<-- GetBalance::Response :\n" << responseDoc.toJson(QJsonDocument::Indented);
This file contains the declaration of the Request class, which is an abstract base class for handling...
Manages database connections and SQL operations.
Definition: db.h:80
DatabaseManager * table(const QString &value)
Sets the table for the query.
Definition: db.cpp:115
DatabaseManager * where(const QString &value, const QVariant &val=QVariant())
Adds a WHERE clause to the query.
Definition: db.cpp:121
DbResult exec()
Executes the built query.
Definition: db.cpp:266
DatabaseManager * select(const QString &value)
Selects columns for the query.
Definition: db.cpp:107
The DbResult class represents a result set returned from a database query.
Definition: dbresult.h:24
QJsonObject first() const
Retrieves the first item in the result set.
Definition: dbresult.cpp:25
bool isEmpty() const
Checks if the result set is empty.
Definition: dbresult.cpp:20
The GetBalanceRequest class handles the retrieval of account balances.
Definition: GetBalanceRequest.h:21
QJsonObject execute(const QJsonObject &jsonObj, QMutex &m) override
Executes the request to get the account balance.
Definition: GetBalanceRequest.h:47
GetBalanceRequest()
Constructor for the GetBalanceRequest class.
Definition: GetBalanceRequest.h:31
The Request class is an abstract base class for handling different types of requests.
Definition: Request.h:25
QJsonObject CreateErrorResponse(QJsonObject &response, QJsonObject &dataObj, QString message)
Creates a generic error JSON response.
Definition: Request.h:90
QJsonObject CreateDBConnectionError(QJsonObject &response, QJsonObject &dataObj)
Creates a JSON response indicating a database connection error.
Definition: Request.h:65
bool isDBConnectionValid(DB::DatabaseManager *dbManager)
Checks if the database connection is valid.
Definition: Request.h:36
Database management classes for handling database connections and operations.