Public Member Functions | Public Attributes

IndexEditor Class Reference

#include <indexeditor.h>

List of all members.

Public Member Functions

 IndexEditor (QWidget *parent=0)
 ~IndexEditor ()
void newIndex ()
void editIndex ()

Public Attributes

QSqlDatabase db
QString dbName
QString tableName
QString indexName
bool isNew

Detailed Description

Definition at line 10 of file indexeditor.h.


Constructor & Destructor Documentation

IndexEditor::IndexEditor ( QWidget *  parent = 0 ) [explicit]

Definition at line 4 of file indexeditor.cpp.

                                        :
        QDialog(parent),
        ui(new Ui::IndexEditor)
{
    ui->setupUi(this);
}
IndexEditor::~IndexEditor (  )

Definition at line 11 of file indexeditor.cpp.

{
    delete ui;
}

Member Function Documentation

void IndexEditor::editIndex (  )

Definition at line 41 of file indexeditor.cpp.

References db, dbName, indexName, isNew, and tableName.

                            {
    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::newIndex (  )

Definition at line 35 of file indexeditor.cpp.

References isNew.

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

Member Data Documentation

QSqlDatabase IndexEditor::db

Definition at line 20 of file indexeditor.h.

Referenced by editIndex().

Definition at line 21 of file indexeditor.h.

Referenced by editIndex().

Definition at line 23 of file indexeditor.h.

Referenced by editIndex().

Definition at line 24 of file indexeditor.h.

Referenced by editIndex(), and newIndex().

Definition at line 22 of file indexeditor.h.

Referenced by editIndex().


The documentation for this class was generated from the following files: