databasemanager.cpp

Go to the documentation of this file.

#include "databasemanager.h"
#include <QSettings>
#include <QSqlDatabase>
#include <QStringList>
 
 
DatabaseManager::DatabaseManager(Ui::MainWindow* UI_Window)
{
    // Save the Pointer to the Main Window & Pointer to Log
    ui = UI_Window;
 
    // Flag that there is no Current Database
    is_database = false;
    is_open = false;
 
    // Load the Availalbe Database Drivers
    LoadDatabaseDrivers(ui->DatabaseDriver);
 
    // Load the Default Dataabse Parameters
    LoadDefaultDBParameters();
 
    QObject::connect(ui->ReconnectDatabase, SIGNAL(pressed()), this, SLOT(ReconnectDatabase()));
    QObject::connect(ui->LoadDefaultDBParams, SIGNAL(pressed()), this, SLOT(LoadDefaultDBParameters()));
}
 
DatabaseManager::~DatabaseManager()
{
    // Remove Database, if it Exists
    RemoveDatabase();
 
    // Save the Database Settings, If Required
    if (ui->SaveDBParamsOnExit->isChecked())
    {
        QSettings settings( "brigadoon/netprojectmanager" );
        settings.setValue( "Database/DatabaseName", ui->DatabaseName->text());
        settings.setValue( "Log_Setup/DatabaseHost", ui->DatabaseHost->text());
        settings.setValue( "Log_Setup/DatabaseUser", ui->DatabaseUsername->text());
        settings.setValue( "Log_Setup/DatabasePassword", ui->DatabasePassword->text());
        settings.setValue( "Log_Setup/DatabaseDriver", ui->DatabaseDriver->currentText());
    }
}
 
void DatabaseManager::LoadDatabaseDrivers(QComboBox *DatabaseDriver)
{
    // Obtain the List of Available Drivers
    QStringList driver_list = QSqlDatabase::drivers();
    DatabaseDriver->addItems(driver_list);
 
    LogAdd(LOG_DEBUG, MODE_DATABASE, QString("%1 Database Drivers identified.").arg(QString::number(driver_list.count())));
}
 
void DatabaseManager::LoadDefaultDBParameters(void)
{
    // Open the Settings Data
    QSettings settings( "brigadoon/netprojectmanager" );
 
    QString database_driver_type = "QMARIADB";
 
    // Load Log Setup Parameters
    ui->DatabaseName->setText(settings.value( "Database/DatabaseName", "ProjectManager").toString());
    ui->DatabaseHost->setText(settings.value( "Log_Setup/DatabaseHost", "localhost").toString());
    ui->DatabaseUsername->setText(settings.value( "Log_Setup/DatabaseUser", "mark" ).toString());
    ui->DatabasePassword->setText(settings.value( "Log_Setup/DatabasePassword", "xg27QHUx%" ).toString());
    ui->DatabaseDriver->setCurrentText(settings.value( "Log_Setup/DatabaseDriver", database_driver_type ).toString());
 
    QString fake_password_string = "";
    if (ui->DatabasePassword->text().length() != 0) fake_password_string = "*******";
    LogAdd(LOG_DEBUG, MODE_DATABASE, QString("Default Database parameters loaded:- Database: %1,  Host: %2,  Driver: %3,  User: %4, Password: %5")
                                       .arg(ui->DatabaseName->text(), ui->DatabaseHost->text(), ui->DatabaseDriver->currentText(), ui->DatabaseUsername->text(), fake_password_string) );
}
 
void DatabaseManager::RemoveDatabase(void)
{
    QSqlDatabase db = QSqlDatabase::database();
 
    if (is_open)
    {
        db.close();
        is_open = CheckIfOpen(false);
    }
 
    // Give Up if there was no Database Existing
    if (!is_database) return;
 
    // Get the Name of the Current Database
    QString database_connection = db.connectionName();
    QSqlDatabase::removeDatabase(database_connection);
 
    LogAdd(LOG_INFO, MODE_DATABASE, "Database has been removed.");
}
bool DatabaseManager::Open(void)
{
    QSqlDatabase db = QSqlDatabase::addDatabase(ui->DatabaseDriver->currentText()); is_database = true;
 
    // Pass the Parameters to the Database
    db.setHostName(ui->DatabaseHost->text());
    db.setDatabaseName(ui->DatabaseName->text());
    db.setUserName(ui->DatabaseUsername->text());
    db.setPassword(ui->DatabasePassword->text());
 
    // Attempt to Open the Database
    is_open = CheckIfOpen(db.open());
    return(is_open);
}
 
void DatabaseManager::ReconnectDatabase()
{
    // Remove an existing Database & Attempt to Open a New One
    RemoveDatabase();
    Open();
}
 
bool DatabaseManager::CheckIfOpen(bool DatabaseOpen)
{
    QString selected_image;
 
    // Set the Database Open Graphic As Appropriate & Send a Log Message
    if (DatabaseOpen)
    {
        selected_image = "Debug.png";
        LogAdd(LOG_DEBUG, MODE_DATABASE, QString("Database %1 is OPEN.").arg(ui->DatabaseName->text()));
    }
    else
    {
        selected_image = "Alert.png";
        LogAdd(LOG_WARNING, MODE_DATABASE, QString("Database %1 is NOT OPEN.").arg(ui->DatabaseName->text()));
    }
    QPixmap the_pixmap( QString(":/Resources/") + selected_image );
    ui->DatabaseStatus->setPixmap(the_pixmap);
 
    return(DatabaseOpen);
}
 
void DatabaseManager::LogAdd(LOGGING_SEVERITY Severity, LOGGING_MODE Mode, QString Message)
{
    REMOTE_LOG_ENTRY log_entry;
    log_entry.Severity = Severity;
    log_entry.Mode = Mode;
    log_entry.Message = Message;
    emit SendLogEntry(log_entry);
}