Public Member Functions | Public Attributes

ManageIndexes Class Reference

#include <manageindexes.h>

List of all members.

Public Member Functions

 ManageIndexes (QWidget *parent=0)
 ~ManageIndexes ()
void refreshIndexes ()

Public Attributes

QSqlDatabase db
QString dbName
QString tableName

Detailed Description

Definition at line 11 of file manageindexes.h.


Constructor & Destructor Documentation

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

Definition at line 4 of file manageindexes.cpp.

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

Definition at line 11 of file manageindexes.cpp.

{
    delete ui;
}

Member Function Documentation

void ManageIndexes::refreshIndexes (  )

Definition at line 16 of file manageindexes.cpp.

References db, dbName, and tableName.

                                   {
    db.open();
    if (db.isOpen()) {
        QSqlQuery qu(db);
        ui->lineEdit->setText(dbName);
        ui->lineEdit_2->setText(tableName);
        ui->treeWidget->clear();
        if (qu.exec(tr("show keys from `%1`.`%2`").arg(dbName, tableName))) {
            while (qu.next()) {
                QSqlRecord rec = qu.record();
                QString indName = rec.value("Key_name").toString();
                QString cols = rec.value("Column_name").toString();
                QTreeWidgetItem *it = new QTreeWidgetItem(ui->treeWidget);
                it->setText(0, indName);
                it->setText(1, cols);
                it->setIcon(0, QIcon("://icons/Icon_43.ico"));
            }
        }
    }
}

Member Data Documentation

QSqlDatabase ManageIndexes::db

Definition at line 18 of file manageindexes.h.

Referenced by refreshIndexes().

Definition at line 19 of file manageindexes.h.

Referenced by refreshIndexes().

Definition at line 20 of file manageindexes.h.

Referenced by refreshIndexes().


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