E:/sqlmaster/src/indexeditor.cpp

Go to the documentation of this file.

#include "indexeditor.h"
#include "ui_indexeditor.h"
#include <QMessageBox>
IndexEditor::IndexEditor(QWidget *parent) :
        QDialog(parent),
        ui(new Ui::IndexEditor)
{
    ui->setupUi(this);
}

IndexEditor::~IndexEditor()
{
    delete ui;
}

void IndexEditor::loadColumns() {
    db.open();
    ui->txtTableName->setText(tableName);
    ui->txtIndexName->setText(indexName);
    if (db.open()) {
        QSqlQuery qu(db);
        if (qu.exec(tr("show full fields from `%1`.`%2`").arg(dbName, tableName))) {
            while (qu.next()) {
                QSqlRecord rec = qu.record();
                QTreeWidgetItem *it = new QTreeWidgetItem(ui->lstColumns);
                it->setText(0, rec.value("Field").toString());
                it->setText(1, rec.value("Type").toString());
                it->setCheckState(0, Qt::Unchecked);
                it->setIcon(0, QIcon("://icons/Icon_42.ico"));
            }
        }
    }
}

void IndexEditor::newIndex() {
    loadColumns();
    isNew = true;
    ui->txtIndexName->setText("New Index");
}

void IndexEditor::editIndex() {
    loadColumns();
    isNew = false;
    ui->txtIndexName->setReadOnly(true);
    QTreeWidgetItem *par = ui->lstColumns->invisibleRootItem();
    for (int i = 0; i < par->childCount(); i++) {
        QTreeWidgetItem *it = par->child(i);
        QSqlQuery qu(db);
        if (qu.exec(tr("show keys from `%1`.`%2`").arg(dbName, tableName))) {
            while (qu.next()) {
                QSqlRecord rec = qu.record();
                if (rec.value("Key_name") == indexName && rec.value("Column_name") == it->text(0)) {
                    it->setCheckState(0, Qt::Checked);
                }
            }
        }
    }
}

void IndexEditor::on_cmdApplyChanges_clicked()
{
    if (isNew) {
        QString keyType = "index";
        if (ui->chkFullText->isChecked())
            keyType = "fulltext";
        if (ui->chkUnique->isChecked())
            keyType = "unique";
        QString  mainquery = tr("alter table `%1`.`%2` add %4 `%3` (")
                             .arg(dbName, tableName, ui->txtIndexName->text(), keyType);
        QString subQuery = "";
        QTreeWidgetItem *par = ui->lstColumns->invisibleRootItem();
        for (int i = 0; i < par->childCount(); i++) {
            QTreeWidgetItem *it = par->child(i);
            if (it->checkState(0) == Qt::Checked) {
                subQuery.append(tr("`%1`,").arg(it->text(0)));
            }
        }
        if (subQuery.length() == 0) {
            QMessageBox::critical(this, "No columns Selected", "You have not selected any columns.");
            return;
        } else {
            subQuery = subQuery.left(subQuery.length() - 1);
            mainquery.append(subQuery);
            mainquery.append(")");
            QSqlQuery save(db);
            if (save.exec(mainquery)) {
                QMessageBox::information(this, "Success", "The index was successfully saved.");
                this->accept();
            } else
            {
                QMessageBox::critical(this, "Error", tr("There was an error while saving the index.\n\n%1").arg(save.lastError().text()));
                return;
            }
        }

    } else {
        QString keyType = "index";
        if (ui->chkFullText->isChecked())
            keyType = "fulltext";
        if (ui->chkUnique->isChecked())
            keyType = "unique";
        QString  mainquery = tr("alter table `%1`.`%2` drop key `%3`, add %4 `%3` (")
                             .arg(dbName, tableName, indexName, keyType);
        QString subQuery = "";
        QTreeWidgetItem *par = ui->lstColumns->invisibleRootItem();
        for (int i = 0; i < par->childCount(); i++) {
            QTreeWidgetItem *it = par->child(i);
            if (it->checkState(0) == Qt::Checked) {
                subQuery.append(tr("`%1`,").arg(it->text(0)));
            }
        }
        if (subQuery.length() == 0) {
            QMessageBox::critical(this, "No columns Selected", "You have not selected any columns.");
            return;
        } else {
            subQuery = subQuery.left(subQuery.length() - 1);
            mainquery.append(subQuery);
            mainquery.append(")");
            QSqlQuery save(db);
            if (save.exec(mainquery)) {
                QMessageBox::information(this, "Success", "The index was successfully modified.");
                this->accept();
            } else
            {
                QMessageBox::critical(this, "Error", tr("There was an error while saving the index.\n\n%1").arg(save.lastError().text()));
                return;
            }
        }
    }
}