#include <manageindexes.h>

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"));
            }
        }
    }
}