void ConnectionWidget::refresh()
{
tree->clear();
QStringList connectionNames = QSqlDatabase::connectionNames();
bool gotActiveDb = false;
for (int i = 0; i < connectionNames.count(); ++i) {
QTreeWidgetItem *root = new QTreeWidgetItem(tree);
QSqlDatabase db = QSqlDatabase::database(connectionNames.at(i), false);
root->setText(0, qDBCaption(db));
if (connectionNames.at(i) == activeDb) {
gotActiveDb = true;
setActive(root);
}
if (db.isOpen()) {
QStringList tables = db.tables();
for (int t = 0; t < tables.count(); ++t) {
QTreeWidgetItem *table = new QTreeWidgetItem(root);
table->setText(0, tables.at(t));
}
}
}
if (!gotActiveDb) {
activeDb = connectionNames.value(0);
setActive(tree->topLevelItem(0));
}
emit tableActivated(nomTable);
tree->doItemsLayout();
}
void ConnectionWidget::on_tree_itemActivated(QTreeWidgetItem *item, int /* column */)
{
if (!item)
return;
if (!item->parent()) {
setActive(item);
} else {
setActive(item->parent());
emit tableActivated(item->text(0));
}
}
ConnectionWidget::ConnectionWidget(QWidget *parent,QString nom)
: QWidget(parent),nomTable(nom)
{
QVBoxLayout *layout = new QVBoxLayout(this);
tree = new QTreeWidget(this);
tree->setObjectName(QLatin1String("tree"));
tree->setHeaderLabels(QStringList(tr("database")));
tree->header()->setSectionResizeMode(QHeaderView::Stretch);
QAction *refreshAction = new QAction(tr("Refresh"), tree);
metaDataAction = new QAction(tr("Show Schema"), tree);
connect(refreshAction, SIGNAL(triggered()), SLOT(refresh()));
connect(metaDataAction, SIGNAL(triggered()), SLOT(showMetaData()));
tree->addAction(refreshAction);
tree->addAction(metaDataAction);
tree->setContextMenuPolicy(Qt::ActionsContextMenu);
layout->addWidget(tree);
emit tableActivated(nomTable);
QMetaObject::connectSlotsByName(this);
}
