Go to the documentation of this file.00001 #include "columnlist.h"
00002
00003 ColumnList::ColumnList(QWidget *parent) :
00004 QListWidget(parent)
00005 {
00006 ico_col = QIcon("://icons/Icon_42.ico");
00007 ico_key = QIcon("://icons/key.ico");
00008 connect (this, SIGNAL(itemDoubleClicked(QListWidgetItem*)), this, SLOT(doubleC(QListWidgetItem*)));
00009 }
00010
00011 void ColumnList::doubleC(QListWidgetItem *item) {
00012 emit objectDoubleClicked(dbName, tableName, item->text());
00013 }
00014
00015 void ColumnList::loadColumns() {
00016 db.open();
00017 this->setWindowTitle(tr("%1.%2").arg(dbName, tableName));
00018 QListWidgetItem *newItem;
00019 newItem = new QListWidgetItem(this, 1);
00020 newItem->setText("*");
00021 this->insertItem(this->count(), newItem);
00022 QSqlQuery qu(db);
00023 if (qu.exec(tr("describe `%1`.`%2`").arg(dbName, tableName))) {
00024 while (qu.next()) {
00025 newItem = new QListWidgetItem(this, 1);
00026 newItem->setText(qu.value(0).toString());
00027 if (qu.value(3).toString() != "") {
00028 newItem->setIcon(ico_key);
00029 } else {
00030 newItem->setIcon(ico_col);
00031 }
00032 this->insertItem(this->count(), newItem);
00033 }
00034 }
00035 }
