E:/sqlmaster/src/newconnection.cpp

Go to the documentation of this file.

#include "newconnection.h"
#include "ui_newconnection.h"
#include <QMessageBox>
#include <QInputDialog>
NewConnection::NewConnection(QWidget *parent) :
        QDialog(parent),
        ui(new Ui::NewConnection)
{
    ui->setupUi(this);
    //
    if (!createConnection())
        QMessageBox::critical(0, "Error", "SQL Lite Error: You will not be able to save connections.");
    //
    connect (ui->cmdNewConnection, SIGNAL(clicked()), this, SLOT(newConnection()));
    connect (ui->cmdSave, SIGNAL(clicked()), this, SLOT(saveConnection()));
    connect (ui->cmdDelete, SIGNAL(clicked()), this, SLOT(deleteConnection()));
    connect (ui->cmdRename, SIGNAL(clicked()), this, SLOT(renameConnection()));
    connect (this, SIGNAL(connectionChanged(bool)), ui->cmdSave, SLOT(setEnabled(bool)));
    connect (this, SIGNAL(connectionSelected(bool)), ui->cmdDelete, SLOT(setEnabled(bool)));
    connect (this, SIGNAL(connectionSelected(bool)), ui->txtPassword, SLOT(setEnabled(bool)));
    connect (this, SIGNAL(connectionSelected(bool)), ui->txtServerName, SLOT(setEnabled(bool)));
    connect (this, SIGNAL(connectionSelected(bool)), ui->txtUserName, SLOT(setEnabled(bool)));
    connect (this, SIGNAL(connectionSelected(bool)), ui->cmdRename, SLOT(setEnabled(bool)));
    emit connectionChanged(false);
    emit connectionSelected(false);

    loadConnections();
}
//--------------------------------------------------------------------------------
NewConnection::~NewConnection()
{
    delete ui;
}
//--------------------------------------------------------------------------------
void NewConnection::on_cmdConnect_clicked()
{
#ifndef QT_NO_CURSOR
    QApplication::setOverrideCursor(QCursor(Qt::WaitCursor));
#endif
    QSqlDatabase testDb = QSqlDatabase::addDatabase("QMYSQL", tr("%1 %2").arg(QDateTime::currentDateTime().toString(),
                                                                              QTime::currentTime().second()));
    testDb.setHostName(ui->txtServerName->text());
    testDb.setPort(3306);
    testDb.setUserName(ui->txtUserName->text());
    testDb.setPassword(ui->txtPassword->text());

    if (testDb.open()){
        if (ui->cmdSave->isEnabled()) {
#ifndef QT_NO_CURSOR
        QApplication::restoreOverrideCursor();
#endif
            if (QMessageBox::question(this, "Save Changes",
                                      tr("The details for this connection have changed.\n\nSave Changes?")
                                      , QMessageBox::Yes, QMessageBox::No) == QMessageBox::Yes)
                saveConnection();
        }
        db = testDb;
        testDb.close();
#ifndef QT_NO_CURSOR
        QApplication::restoreOverrideCursor();
#endif
        this->accept();
    }
    else {
#ifndef QT_NO_CURSOR
        QApplication::restoreOverrideCursor();
#endif
        QMessageBox::critical(this, "Connection Error",
                              tr("There was an error while connecting to the server %1\n\nError Message:\n\n%2").arg
                              (ui->txtServerName->text(),
                               testDb.lastError().text()));
    }
}
//--------------------------------------------------------------------------------
void NewConnection::on_cmdCancel_clicked()
{
    this->reject();
}
//--------------------------------------------------------------------------------
void NewConnection::newConnection() {
    QInputDialog inp(this);
    inp.setWindowTitle("New Connection");
    inp.setLabelText("Enter the new connection name");
    if (inp.exec()) {
        QString connName = inp.textValue();
        if (connName != "") {
            if (checkConnectionName(connName)) {
                QMessageBox::warning(this, "Error", "The name you entered is already in use.")  ;
                return;
            }
            QSqlQuery insertQuery;
            insertQuery.exec(tr("INSERT INTO connections (connectionName) VALUES ('%1')").arg(connName));
            loadConnections();
            ui->cboConnections->setCurrentIndex(ui->cboConnections->count() - 1);
        } else {
            QMessageBox::critical(this, "Error", "The connection name you entered is invalid. Please retry");
            newConnection();
        }
    }
}
//--------------------------------------------------------------------------------
void NewConnection::saveConnection() {
    QSqlQuery insertQuery;
    insertQuery.exec(tr("UPDATE connections SET "
                        "serverName =  '%1', "
                        "userName = '%2', "
                        "password = '%3' "
                        "WHERE connectionName = '%4'")
                     .arg(ui->txtServerName->text(),
                          ui->txtUserName->text(),
                          ui->txtPassword->text(),
                          ui->cboConnections->currentText()));
    emit connectionChanged(false);
}
//--------------------------------------------------------------------------------
void NewConnection::deleteConnection() {
    if (QMessageBox::question(this, "Confirm", tr("Are you sure you want to delete this connection?"), QMessageBox::Yes, QMessageBox::No) == QMessageBox::Yes) {
        QSqlQuery deleteQuery;
        QString connName = ui->cboConnections->currentText();
        deleteQuery.exec(tr("DELETE FROM connections WHERE connectionName = '%1'").arg(connName));
        loadConnections();
    }
}
//--------------------------------------------------------------------------------
void NewConnection::loadConnections() {
    ui->cboConnections->clear();
    ui->txtPassword->setText("");
    ui->txtPort->setText("3306");
    ui->txtServerName->setText("");
    ui->txtUserName->setText("");
    QSqlQuery query;
    query.exec("SELECT * FROM connections");
    while (query.next()) {
        QString connectionName = query.value(1).toString();
        ui->cboConnections->insertItem(ui->cboConnections->count(), connectionName);
    }
}
//--------------------------------------------------------------------------------
void NewConnection::on_cboConnections_currentIndexChanged(QString )
{
    if (ui->cboConnections->count() > 0) {
        emit connectionSelected(true);
        QString connectionName = ui->cboConnections->currentText();
        QSqlQuery selectQuery;
        selectQuery.exec(tr("SELECT * FROM connections WHERE connectionName = '%1'").arg(connectionName));
        if (selectQuery.lastError().isValid()) {

        } else {
            while (selectQuery.next()) {
                ui->txtServerName->setText(selectQuery.value(2).toString());
                ui->txtUserName->setText(selectQuery.value(3).toString());
                ui->txtPassword->setText(selectQuery.value(4).toString());
                ui->txtPort->setText("3306");
            }
        }
    } else {
        emit connectionSelected(false);
    }
}
//--------------------------------------------------------------------------------
void NewConnection::renameConnection() {
    QInputDialog inp(this);
    inp.setWindowTitle("Rename Connection");
    inp.setLabelText(tr("Enter the new connection name for '%1'").arg(ui->cboConnections->currentText()));
    if (inp.exec()) {
        QString connName = inp.textValue();
        if (connName != "") {
            if (checkConnectionName(connName)) {
                QMessageBox::warning(this, "Error", "The name you entered is already in use.")  ;
                return;
            }
            QSqlQuery insertQuery;
            insertQuery.exec(tr("UPDATE connections SET connectionName =  '%1' WHERE connectionName = '%2'").arg(connName, ui->cboConnections->currentText()));
            loadConnections();
            ui->cboConnections->setCurrentIndex(ui->cboConnections->count() - 1);
        } else {
            QMessageBox::critical(this, "Error", "The connection name you entered is invalid. Please retry");
            renameConnection();
        }
    }
}

//--------------------------------------------------------------------------------
void NewConnection::on_txtServerName_textEdited(QString )
{
    emit connectionChanged(true);
}
//--------------------------------------------------------------------------------
void NewConnection::on_txtUserName_textEdited(QString )
{
    emit connectionChanged(true);
}
//--------------------------------------------------------------------------------
void NewConnection::on_txtPassword_textEdited(QString )
{
    emit connectionChanged(true);
}
//--------------------------------------------------------------------------------
bool NewConnection::checkConnectionName(QString checkName) {
    QSqlQuery checkQuery;
    checkQuery.exec(tr("SELECT * FROM connections WHERE connectionName = '%1'").arg(checkName));
    //return !checkQuery.size() < 1;
    return false;
    //ToDO Incomplete

}
//--------------------------------------------------------------------------------