<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en_US" lang="en_US">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Qt 4.8: connectionwidget.cpp Example File (demos/sqlbrowser/connectionwidget.cpp)</title>
<link rel="stylesheet" type="text/css" href="style/style.css" />
<script src="scripts/jquery.js" type="text/javascript"></script>
<script src="scripts/functions.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="style/superfish.css" />
<link rel="stylesheet" type="text/css" href="style/narrow.css" />
<!--[if IE]>
<meta name="MSSmartTagsPreventParsing" content="true">
<meta http-equiv="imagetoolbar" content="no">
<![endif]-->
<!--[if lt IE 7]>
<link rel="stylesheet" type="text/css" href="style/style_ie6.css">
<![endif]-->
<!--[if IE 7]>
<link rel="stylesheet" type="text/css" href="style/style_ie7.css">
<![endif]-->
<!--[if IE 8]>
<link rel="stylesheet" type="text/css" href="style/style_ie8.css">
<![endif]-->
<script src="scripts/superfish.js" type="text/javascript"></script>
<script src="scripts/narrow.js" type="text/javascript"></script>
</head>
<body class="" onload="CheckEmptyAndLoadList();">
<div class="header" id="qtdocheader">
<div class="content">
<div id="nav-logo">
<a href="index.html">Home</a></div>
<a href="index.html" class="qtref"><span>Qt Reference Documentation</span></a>
<div id="narrowsearch"></div>
<div id="nav-topright">
<ul>
<li class="nav-topright-home"><a href="http://qt.digia.com/">Qt HOME</a></li>
<li class="nav-topright-dev"><a href="http://qt-project.org/">DEV</a></li>
<li class="nav-topright-doc nav-topright-doc-active"><a href="http://qt-project.org/doc/">
DOC</a></li>
<li class="nav-topright-blog"><a href="http://blog.qt.digia.com/">BLOG</a></li>
</ul>
</div>
<div id="shortCut">
<ul>
<li class="shortCut-topleft-inactive"><span><a href="index.html">Qt 4.8</a></span></li>
<li class="shortCut-topleft-active"><a href="http://qt-project.org/doc/">ALL VERSIONS </a></li>
</ul>
</div>
<ul class="sf-menu" id="narrowmenu">
<li><a href="#">API Lookup</a>
<ul>
<li><a href="classes.html">Class index</a></li>
<li><a href="functions.html">Function index</a></li>
<li><a href="modules.html">Modules</a></li>
<li><a href="namespaces.html">Namespaces</a></li>
<li><a href="qtglobal.html">Global Declarations</a></li>
<li><a href="qdeclarativeelements.html">QML elements</a></li>
</ul>
</li>
<li><a href="#">Qt Topics</a>
<ul>
<li><a href="qt-basic-concepts.html">Programming with Qt</a></li>
<li><a href="qtquick.html">Device UIs & Qt Quick</a></li>
<li><a href="qt-gui-concepts.html">UI Design with Qt</a></li>
<li><a href="supported-platforms.html">Supported Platforms</a></li>
<li><a href="technology-apis.html">Qt and Key Technologies</a></li>
<li><a href="best-practices.html">How-To's and Best Practices</a></li>
</ul>
</li>
<li><a href="#">Examples</a>
<ul>
<li><a href="all-examples.html">Examples</a></li>
<li><a href="tutorials.html">Tutorials</a></li>
<li><a href="demos.html">Demos</a></li>
<li><a href="qdeclarativeexamples.html">QML Examples</a></li>
</ul>
</li>
</ul>
</div>
</div>
<div class="wrapper">
<div class="hd">
<span></span>
</div>
<div class="bd group">
<div class="sidebar">
<div class="searchlabel">
Search index:</div>
<div class="search" id="sidebarsearch">
<form id="qtdocsearch" action="" onsubmit="return false;">
<fieldset>
<input type="text" name="searchstring" id="pageType" value="" />
<div id="resultdialog">
<a href="#" id="resultclose">Close</a>
<p id="resultlinks" class="all"><a href="#" id="showallresults">All</a> | <a href="#" id="showapiresults">API</a> | <a href="#" id="showarticleresults">Articles</a> | <a href="#" id="showexampleresults">Examples</a></p>
<p id="searchcount" class="all"><span id="resultcount"></span><span id="apicount"></span><span id="articlecount"></span><span id="examplecount"></span> results:</p>
<ul id="resultlist" class="all">
</ul>
</div>
</fieldset>
</form>
</div>
<div class="box first bottombar" id="lookup">
<h2 title="API Lookup"><span></span>
API Lookup</h2>
<div id="list001" class="list">
<ul id="ul001" >
<li class="defaultLink"><a href="classes.html">Class index</a></li>
<li class="defaultLink"><a href="functions.html">Function index</a></li>
<li class="defaultLink"><a href="modules.html">Modules</a></li>
<li class="defaultLink"><a href="namespaces.html">Namespaces</a></li>
<li class="defaultLink"><a href="qtglobal.html">Global Declarations</a></li>
<li class="defaultLink"><a href="qdeclarativeelements.html">QML elements</a></li>
</ul>
</div>
</div>
<div class="box bottombar" id="topics">
<h2 title="Qt Topics"><span></span>
Qt Topics</h2>
<div id="list002" class="list">
<ul id="ul002" >
<li class="defaultLink"><a href="qt-basic-concepts.html">Programming with Qt</a></li>
<li class="defaultLink"><a href="qtquick.html">Device UIs & Qt Quick</a></li>
<li class="defaultLink"><a href="qt-gui-concepts.html">UI Design with Qt</a></li>
<li class="defaultLink"><a href="supported-platforms.html">Supported Platforms</a></li>
<li class="defaultLink"><a href="technology-apis.html">Qt and Key Technologies</a></li>
<li class="defaultLink"><a href="best-practices.html">How-To's and Best Practices</a></li>
</ul>
</div>
</div>
<div class="box" id="examples">
<h2 title="Examples"><span></span>
Examples</h2>
<div id="list003" class="list">
<ul id="ul003">
<li class="defaultLink"><a href="all-examples.html">Examples</a></li>
<li class="defaultLink"><a href="tutorials.html">Tutorials</a></li>
<li class="defaultLink"><a href="demos.html">Demos</a></li>
<li class="defaultLink"><a href="qdeclarativeexamples.html">QML Examples</a></li>
</ul>
</div>
</div>
</div>
<div class="wrap">
<div class="toolbar">
<div class="breadcrumb toolblock">
<ul>
<li class="first"><a href="index.html">Home</a></li>
<!-- Breadcrumbs go here -->
</ul>
</div>
<div class="toolbuttons toolblock">
<ul>
<li id="smallA" class="t_button">A</li>
<li id="medA" class="t_button active">A</li>
<li id="bigA" class="t_button">A</li>
<li id="print" class="t_button"><a href="javascript:this.print();">
<span>Print</span></a></li>
</ul>
</div>
</div>
<div class="content mainContent">
<h1 class="title">connectionwidget.cpp Example File</h1>
<span class="small-subtitle">demos/sqlbrowser/connectionwidget.cpp</span>
<!-- $$$demos/sqlbrowser/connectionwidget.cpp-description -->
<div class="descr"> <a name="details"></a>
<pre class="cpp"> <span class="comment">/****************************************************************************
**
** Copyright (C) 2013 Digia Plc and/or its subsidiary(-ies).
** Contact: http://www.qt-project.org/legal
**
** This file is part of the demonstration applications of the Qt Toolkit.
**
** $QT_BEGIN_LICENSE:LGPL$
** Commercial License Usage
** Licensees holding valid commercial Qt licenses may use this file in
** accordance with the commercial license agreement provided with the
** Software or, alternatively, in accordance with the terms contained in
** a written agreement between you and Digia. For licensing terms and
** conditions see http://qt.digia.com/licensing. For further information
** use the contact form at http://qt.digia.com/contact-us.
**
** GNU Lesser General Public License Usage
** Alternatively, this file may be used under the terms of the GNU Lesser
** General Public License version 2.1 as published by the Free Software
** Foundation and appearing in the file LICENSE.LGPL included in the
** packaging of this file. Please review the following information to
** ensure the GNU Lesser General Public License version 2.1 requirements
** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
**
** In addition, as a special exception, Digia gives you certain additional
** rights. These rights are described in the Digia Qt LGPL Exception
** version 1.1, included in the file LGPL_EXCEPTION.txt in this package.
**
** GNU General Public License Usage
** Alternatively, this file may be used under the terms of the GNU
** General Public License version 3.0 as published by the Free Software
** Foundation and appearing in the file LICENSE.GPL included in the
** packaging of this file. Please review the following information to
** ensure the GNU General Public License version 3.0 requirements will be
** met: http://www.gnu.org/copyleft/gpl.html.
**
**
** $QT_END_LICENSE$
**
****************************************************************************/</span>
<span class="preprocessor">#include "connectionwidget.h"</span>
<span class="preprocessor">#include <QtGui></span>
<span class="preprocessor">#include <QtSql></span>
ConnectionWidget<span class="operator">::</span>ConnectionWidget(<span class="type"><a href="qwidget.html">QWidget</a></span> <span class="operator">*</span>parent)
: <span class="type"><a href="qwidget.html">QWidget</a></span>(parent)
{
<span class="type"><a href="qvboxlayout.html">QVBoxLayout</a></span> <span class="operator">*</span>layout <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qvboxlayout.html">QVBoxLayout</a></span>(<span class="keyword">this</span>);
tree <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qtreewidget.html">QTreeWidget</a></span>(<span class="keyword">this</span>);
tree<span class="operator">-</span><span class="operator">></span>setObjectName(QLatin1String(<span class="string">"tree"</span>));
tree<span class="operator">-</span><span class="operator">></span>setHeaderLabels(<span class="type"><a href="qstringlist.html">QStringList</a></span>(tr(<span class="string">"database"</span>)));
tree<span class="operator">-</span><span class="operator">></span>header()<span class="operator">-</span><span class="operator">></span>setResizeMode(<span class="type"><a href="qheaderview.html">QHeaderView</a></span><span class="operator">::</span>Stretch);
<span class="type"><a href="qaction.html">QAction</a></span> <span class="operator">*</span>refreshAction <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qaction.html">QAction</a></span>(tr(<span class="string">"Refresh"</span>)<span class="operator">,</span> tree);
metaDataAction <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qaction.html">QAction</a></span>(tr(<span class="string">"Show Schema"</span>)<span class="operator">,</span> tree);
connect(refreshAction<span class="operator">,</span> SIGNAL(triggered())<span class="operator">,</span> SLOT(refresh()));
connect(metaDataAction<span class="operator">,</span> SIGNAL(triggered())<span class="operator">,</span> SLOT(showMetaData()));
tree<span class="operator">-</span><span class="operator">></span>addAction(refreshAction);
tree<span class="operator">-</span><span class="operator">></span>addAction(metaDataAction);
tree<span class="operator">-</span><span class="operator">></span>setContextMenuPolicy(<span class="type"><a href="qt.html">Qt</a></span><span class="operator">::</span>ActionsContextMenu);
layout<span class="operator">-</span><span class="operator">></span>addWidget(tree);
<span class="type"><a href="qmetaobject.html">QMetaObject</a></span><span class="operator">::</span>connectSlotsByName(<span class="keyword">this</span>);
}
ConnectionWidget<span class="operator">::</span><span class="operator">~</span>ConnectionWidget()
{
}
<span class="keyword">static</span> <span class="type"><a href="qstring.html">QString</a></span> qDBCaption(<span class="keyword">const</span> <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span> <span class="operator">&</span>db)
{
<span class="type"><a href="qstring.html">QString</a></span> nm <span class="operator">=</span> db<span class="operator">.</span>driverName();
nm<span class="operator">.</span>append(QLatin1Char(<span class="char">':'</span>));
<span class="keyword">if</span> (<span class="operator">!</span>db<span class="operator">.</span>userName()<span class="operator">.</span>isEmpty())
nm<span class="operator">.</span>append(db<span class="operator">.</span>userName())<span class="operator">.</span>append(QLatin1Char(<span class="char">'@'</span>));
nm<span class="operator">.</span>append(db<span class="operator">.</span>databaseName());
<span class="keyword">return</span> nm;
}
<span class="type">void</span> ConnectionWidget<span class="operator">::</span>refresh()
{
tree<span class="operator">-</span><span class="operator">></span>clear();
<span class="type"><a href="qstringlist.html">QStringList</a></span> connectionNames <span class="operator">=</span> <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>connectionNames();
<span class="type">bool</span> gotActiveDb <span class="operator">=</span> <span class="keyword">false</span>;
<span class="keyword">for</span> (<span class="type">int</span> i <span class="operator">=</span> <span class="number">0</span>; i <span class="operator"><</span> connectionNames<span class="operator">.</span>count(); <span class="operator">+</span><span class="operator">+</span>i) {
<span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span> <span class="operator">*</span>root <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span>(tree);
<span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span> db <span class="operator">=</span> <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>database(connectionNames<span class="operator">.</span>at(i)<span class="operator">,</span> <span class="keyword">false</span>);
root<span class="operator">-</span><span class="operator">></span>setText(<span class="number">0</span><span class="operator">,</span> qDBCaption(db));
<span class="keyword">if</span> (connectionNames<span class="operator">.</span>at(i) <span class="operator">=</span><span class="operator">=</span> activeDb) {
gotActiveDb <span class="operator">=</span> <span class="keyword">true</span>;
setActive(root);
}
<span class="keyword">if</span> (db<span class="operator">.</span>isOpen()) {
<span class="type"><a href="qstringlist.html">QStringList</a></span> tables <span class="operator">=</span> db<span class="operator">.</span>tables();
<span class="keyword">for</span> (<span class="type">int</span> t <span class="operator">=</span> <span class="number">0</span>; t <span class="operator"><</span> tables<span class="operator">.</span>count(); <span class="operator">+</span><span class="operator">+</span>t) {
<span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span> <span class="operator">*</span>table <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span>(root);
table<span class="operator">-</span><span class="operator">></span>setText(<span class="number">0</span><span class="operator">,</span> tables<span class="operator">.</span>at(t));
}
}
}
<span class="keyword">if</span> (<span class="operator">!</span>gotActiveDb) {
activeDb <span class="operator">=</span> connectionNames<span class="operator">.</span>value(<span class="number">0</span>);
setActive(tree<span class="operator">-</span><span class="operator">></span>topLevelItem(<span class="number">0</span>));
}
tree<span class="operator">-</span><span class="operator">></span>doItemsLayout(); <span class="comment">// HACK</span>
}
<span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span> ConnectionWidget<span class="operator">::</span>currentDatabase() <span class="keyword">const</span>
{
<span class="keyword">return</span> <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>database(activeDb);
}
<span class="keyword">static</span> <span class="type">void</span> qSetBold(<span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span> <span class="operator">*</span>item<span class="operator">,</span> <span class="type">bool</span> bold)
{
<span class="type"><a href="qfont.html">QFont</a></span> font <span class="operator">=</span> item<span class="operator">-</span><span class="operator">></span>font(<span class="number">0</span>);
font<span class="operator">.</span>setBold(bold);
item<span class="operator">-</span><span class="operator">></span>setFont(<span class="number">0</span><span class="operator">,</span> font);
}
<span class="type">void</span> ConnectionWidget<span class="operator">::</span>setActive(<span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span> <span class="operator">*</span>item)
{
<span class="keyword">for</span> (<span class="type">int</span> i <span class="operator">=</span> <span class="number">0</span>; i <span class="operator"><</span> tree<span class="operator">-</span><span class="operator">></span>topLevelItemCount(); <span class="operator">+</span><span class="operator">+</span>i) {
<span class="keyword">if</span> (tree<span class="operator">-</span><span class="operator">></span>topLevelItem(i)<span class="operator">-</span><span class="operator">></span>font(<span class="number">0</span>)<span class="operator">.</span>bold())
qSetBold(tree<span class="operator">-</span><span class="operator">></span>topLevelItem(i)<span class="operator">,</span> <span class="keyword">false</span>);
}
<span class="keyword">if</span> (<span class="operator">!</span>item)
<span class="keyword">return</span>;
qSetBold(item<span class="operator">,</span> <span class="keyword">true</span>);
activeDb <span class="operator">=</span> <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>connectionNames()<span class="operator">.</span>value(tree<span class="operator">-</span><span class="operator">></span>indexOfTopLevelItem(item));
}
<span class="type">void</span> ConnectionWidget<span class="operator">::</span>on_tree_itemActivated(<span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span> <span class="operator">*</span>item<span class="operator">,</span> <span class="type">int</span> <span class="comment">/* column */</span>)
{
<span class="keyword">if</span> (<span class="operator">!</span>item)
<span class="keyword">return</span>;
<span class="keyword">if</span> (<span class="operator">!</span>item<span class="operator">-</span><span class="operator">></span>parent()) {
setActive(item);
} <span class="keyword">else</span> {
setActive(item<span class="operator">-</span><span class="operator">></span>parent());
<span class="keyword">emit</span> tableActivated(item<span class="operator">-</span><span class="operator">></span>text(<span class="number">0</span>));
}
}
<span class="type">void</span> ConnectionWidget<span class="operator">::</span>showMetaData()
{
<span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span> <span class="operator">*</span>cItem <span class="operator">=</span> tree<span class="operator">-</span><span class="operator">></span>currentItem();
<span class="keyword">if</span> (<span class="operator">!</span>cItem <span class="operator">|</span><span class="operator">|</span> <span class="operator">!</span>cItem<span class="operator">-</span><span class="operator">></span>parent())
<span class="keyword">return</span>;
setActive(cItem<span class="operator">-</span><span class="operator">></span>parent());
<span class="keyword">emit</span> metaDataRequested(cItem<span class="operator">-</span><span class="operator">></span>text(<span class="number">0</span>));
}
<span class="type">void</span> ConnectionWidget<span class="operator">::</span>on_tree_currentItemChanged(<span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span> <span class="operator">*</span>current<span class="operator">,</span> <span class="type"><a href="qtreewidgetitem.html">QTreeWidgetItem</a></span> <span class="operator">*</span>)
{
metaDataAction<span class="operator">-</span><span class="operator">></span>setEnabled(current <span class="operator">&</span><span class="operator">&</span> current<span class="operator">-</span><span class="operator">></span>parent());
}</pre>
</div>
<!-- @@@demos/sqlbrowser/connectionwidget.cpp -->
</div>
</div>
</div>
<div class="ft">
<span></span>
</div>
</div>
<div class="footer">
<p>
<acronym title="Copyright">©</acronym> 2013 Digia Plc and/or its
subsidiaries. Documentation contributions included herein are the copyrights of
their respective owners.</p>
<br />
<p>
The documentation provided herein is licensed under the terms of the
<a href="http://www.gnu.org/licenses/fdl.html">GNU Free Documentation
License version 1.3</a> as published by the Free Software Foundation.</p>
<p>
Documentation sources may be obtained from <a href="http://www.qt-project.org">
www.qt-project.org</a>.</p>
<br />
<p>
Digia, Qt and their respective logos are trademarks of Digia Plc
in Finland and/or other countries worldwide. All other trademarks are property
of their respective owners. <a title="Privacy Policy"
href="http://en.gitorious.org/privacy_policy/">Privacy Policy</a></p>
</div>
<script src="scripts/functions.js" type="text/javascript"></script>
</body>
</html>
