File indexing completed on 2024-05-12 05:02:00

 /*
    SPDX-FileCopyrightText: 2023-2024 Laurent Montel <montel.org>
 
    SPDX-License-Identifier: LGPL-2.0-or-later
 */
 
 #include "localaccountdatabase.h"
 #include "config-ruqola.h"
 #include "localdatabaseutils.h"
 #include "ruqola_database_debug.h"
 #include <QSqlDatabase>
 #include <QSqlError>
 #include <QSqlQuery>
 #include <QSqlRecord>
 
 static const char s_schemaAccountDataBase[] = "CREATE TABLE ACCOUNT (accountName TEXT PRIMARY KEY NOT NULL, json TEXT)";
 enum class AccountFields {
     AccountName,
     TimeStamp,
     Json,
 }; // in the same order as the table
 
 LocalAccountDatabase::LocalAccountDatabase()
     : LocalDatabaseBase(LocalDatabaseUtils::localAccountDatabasePath(), LocalDatabaseBase::DatabaseType::Account)
 {
 }
 
 LocalAccountDatabase::~LocalAccountDatabase() = default;
 
 QString LocalAccountDatabase::schemaDataBase() const
 {
     return QString::fromLatin1(s_schemaAccountDataBase);
 }
 
 void LocalAccountDatabase::updateAccount(const QString &accountName, const QByteArray &ba)
 {
     QSqlDatabase db;
     if (initializeDataBase(accountName, db)) {
         QSqlQuery query(LocalDatabaseUtils::updateAccount(), db);
         query.addBindValue(accountName);
         query.addBindValue(ba);
         if (!query.exec()) {
             qCWarning(RUQOLA_DATABASE_LOG) << "Couldn't insert-or-replace in ACCOUNT table" << db.databaseName() << query.lastError();
         }
     }
 }
 
 void LocalAccountDatabase::deleteAccount(const QString &accountName)
 {
     QSqlDatabase db;
     if (!checkDataBase(accountName, db)) {
         return;
     }
     QSqlQuery query(LocalDatabaseUtils::deleteAccount(), db);
     query.addBindValue(accountName);
     if (!query.exec()) {
         qCWarning(RUQOLA_DATABASE_LOG) << "Couldn't insert-or-replace in ACCOUNT table" << db.databaseName() << query.lastError();
     }
 }
 
 QByteArray LocalAccountDatabase::jsonAccount(const QString &accountName)
 {
     QSqlDatabase db;
     if (!initializeDataBase(accountName, db)) {
         return {};
     }
     QSqlQuery query(QStringLiteral("SELECT json FROM ACCOUNT WHERE accountName = \"%1\"").arg(accountName), db);
     QByteArray value;
     // We have one element
     if (query.first()) {
         value = query.value(0).toByteArray();
     }
     return value;
 }