File indexing completed on 2024-04-14 04:39:39

 #include "accountsdb.h"
 
 #include <QUuid>
 #include <QStandardPaths>
 
 #ifdef Q_OS_ANDROID
 #include "mauiandroid.h"
 #endif
 
 const static QUrl DBDir = QUrl::fromLocalFile(QStandardPaths::writableLocation(QStandardPaths::GenericDataLocation) + "/maui/");
 const static QString DBName = "accounts.db";
 const static QUrl DBPath = QUrl(DBDir.toString()+"/"+DBName);
 
 AccountsDB::AccountsDB(QObject *parent)
     : QObject(parent)
 {
     // get permissions to read and write
 #ifdef Q_OS_ANDROID
     MAUIAndroid::checkRunTimePermissions({"android.permission.WRITE_EXTERNAL_STORAGE"});
 #endif
 
     QDir collectionDBPath_dir(DBDir.toLocalFile());
     if (!collectionDBPath_dir.exists())
         collectionDBPath_dir.mkpath(".");
 
     this->name = QUuid::createUuid().toString();
     if (!FMH::fileExists(DBPath)) {
         this->openDB(this->name);
         this->prepareCollectionDB();
     } else
         this->openDB(this->name);
 }
 
 AccountsDB::~AccountsDB()
 {
     this->m_db.close();
 }
 
 void AccountsDB::openDB(const QString &name)
 {
     if (!QSqlDatabase::contains(name)) {
         this->m_db = QSqlDatabase::addDatabase(QStringLiteral("QSQLITE"), name);
         this->m_db.setDatabaseName(DBPath.toLocalFile());
     }
 
     if (!this->m_db.isOpen()) {
         if (!this->m_db.open())
             qDebug() << "ERROR OPENING DB" << this->m_db.lastError().text() << m_db.connectionName();
     }
     auto query = this->getQuery("PRAGMA synchronous=OFF");
     query.exec();
 }
 
 void AccountsDB::prepareCollectionDB() const
 {
     QSqlQuery query(this->m_db);
 
     QFile file(":/accounts/script.sql");
 
     if (!file.exists()) {
         QString log = QStringLiteral("Fatal error on build database. The file '");
         log.append(file.fileName() + QStringLiteral("' for database and tables creation query cannot be not found!"));
         qDebug() << log;
         return;
     }
 
     if (!file.open(QIODevice::ReadOnly)) {
         qDebug() << QStringLiteral("Fatal error on try to create database! The file with sql queries for database creation cannot be opened!");
         return;
     }
 
     bool hasText;
     QString line;
     QByteArray readLine;
     QString cleanedLine;
     QStringList strings;
 
     while (!file.atEnd()) {
         hasText = false;
         line = "";
         readLine = "";
         cleanedLine = "";
         strings.clear();
         while (!hasText) {
             readLine = file.readLine();
             cleanedLine = readLine.trimmed();
             strings = cleanedLine.split("--");
             cleanedLine = strings.at(0);
             if (!cleanedLine.startsWith("--") && !cleanedLine.startsWith("DROP") && !cleanedLine.isEmpty())
                 line += cleanedLine;
             if (cleanedLine.endsWith(";"))
                 break;
             if (cleanedLine.startsWith("COMMIT"))
                 hasText = true;
         }
         if (!line.isEmpty()) {
             if (!query.exec(line)) {
                 qDebug() << "exec failed" << query.lastQuery() << query.lastError();
             }
 
         } else
             qDebug() << "exec wrong" << query.lastError();
     }
     file.close();
 }
 
 bool AccountsDB::checkExistance(const QString &tableName, const QString &searchId, const QString &search)
 {
     auto queryStr = QString("SELECT %1 FROM %2 WHERE %3 = \"%4\"").arg(searchId, tableName, searchId, search);
     auto query = this->getQuery(queryStr);
 
     if (query.exec()) {
         if (query.next())
             return true;
     } else
         qDebug() << query.lastError().text();
 
     return false;
 }
 
 bool AccountsDB::checkExistance(const QString &queryStr)
 {
     auto query = this->getQuery(queryStr);
 
     if (query.exec()) {
         if (query.next())
             return true;
     } else
         qDebug() << query.lastError().text();
 
     return false;
 }
 
 QSqlQuery AccountsDB::getQuery(const QString &queryTxt)
 {
     QSqlQuery query(queryTxt, this->m_db);
     return query;
 }
 
 bool AccountsDB::insert(const QString &tableName, const QVariantMap &insertData)
 {
     if (tableName.isEmpty()) {
         qDebug() << QStringLiteral("Fatal error on insert! The table name is empty!");
         return false;
 
     } else if (insertData.isEmpty()) {
         qDebug() << QStringLiteral("Fatal error on insert! The insertData is empty!");
         return false;
     }
 
     QStringList strValues;
     QStringList fields = insertData.keys();
     QVariantList values = insertData.values();
     int totalFields = fields.size();
     for (int i = 0; i < totalFields; ++i)
         strValues.append("?");
 
     QString sqlQueryString = "INSERT INTO " + tableName + " (" + QString(fields.join(",")) + ") VALUES(" + QString(strValues.join(",")) + ")";
     QSqlQuery query(this->m_db);
     query.prepare(sqlQueryString);
 
     int k = 0;
     for (const QVariant &value : values)
         query.bindValue(k++, value);
 
     return query.exec();
 }
 
 bool AccountsDB::update(const QString &tableName, const FMH::MODEL &updateData, const QVariantMap &where)
 {
     if (tableName.isEmpty()) {
         qDebug() << QStringLiteral("Fatal error on insert! The table name is empty!");
         return false;
     } else if (updateData.isEmpty()) {
         qDebug() << QStringLiteral("Fatal error on insert! The insertData is empty!");
         return false;
     }
 
     QStringList set;
     const auto updateKeys = updateData.keys();
     for (const auto &key : updateKeys)
         set.append(FMH::MODEL_NAME[key] + " = '" + updateData[key] + "'");
 
     QStringList condition;
     const auto keys = where.keys();
     for (const auto &key : keys)
         condition.append(key + " = '" + where[key].toString() + "'");
 
     QString sqlQueryString = "UPDATE " + tableName + " SET " + QString(set.join(",")) + " WHERE " + QString(condition.join(","));
     auto query = this->getQuery(sqlQueryString);
     qDebug() << sqlQueryString;
     return query.exec();
 }
 
 bool AccountsDB::update(const QString &table, const QString &column, const QVariant &newValue, const QVariant &op, const QString &id)
 {
     auto queryStr = QString("UPDATE %1 SET %2 = \"%3\" WHERE %4 = \"%5\"").arg(table, column, newValue.toString().replace("\"", "\"\""), op.toString(), id);
     auto query = this->getQuery(queryStr);
     return query.exec();
 }
 
 bool AccountsDB::remove(const QString &tableName, const FMH::MODEL &removeData)
 {
     if (tableName.isEmpty()) {
         qDebug() << QStringLiteral("Fatal error on removing! The table name is empty!");
         return false;
 
     } else if (removeData.isEmpty()) {
         qDebug() << QStringLiteral("Fatal error on insert! The removeData is empty!");
         return false;
     }
 
     QString strValues;
     auto i = 0;
     const auto keys = removeData.keys();
     for (const auto &key : keys) {
         strValues.append(QString("%1 = \"%2\"").arg(FMH::MODEL_NAME[key], removeData[key]));
         i++;
 
         if (keys.size() > 1 && i < keys.size())
         {
              strValues.append(" AND ");
         }
     }
 
     QString sqlQueryString = "DELETE FROM " + tableName + " WHERE " + strValues;
     qDebug() << sqlQueryString;
 
     return this->getQuery(sqlQueryString).exec();
 }