diff -r 000000000000 -r 1918ee327afb examples/sql/sqlwidgetmapper/window.cpp --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/examples/sql/sqlwidgetmapper/window.cpp Mon Jan 11 14:00:40 2010 +0000 @@ -0,0 +1,159 @@ +/**************************************************************************** +** +** Copyright (C) 2009 Nokia Corporation and/or its subsidiary(-ies). +** All rights reserved. +** Contact: Nokia Corporation (qt-info@nokia.com) +** +** This file is part of the examples of the Qt Toolkit. +** +** $QT_BEGIN_LICENSE:LGPL$ +** No Commercial Usage +** This file contains pre-release code and may not be distributed. +** You may use this file in accordance with the terms and conditions +** contained in the Technology Preview License Agreement accompanying +** this package. +** +** 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, Nokia gives you certain additional +** rights. These rights are described in the Nokia Qt LGPL Exception +** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. +** +** If you have questions regarding the use of this file, please contact +** Nokia at qt-info@nokia.com. +** +** +** +** +** +** +** +** +** $QT_END_LICENSE$ +** +****************************************************************************/ + +#include +#include + +#include "window.h" + +//! [Set up widgets] +Window::Window(QWidget *parent) + : QWidget(parent) +{ + setupModel(); + + nameLabel = new QLabel(tr("Na&me:")); + nameEdit = new QLineEdit(); + addressLabel = new QLabel(tr("&Address:")); + addressEdit = new QTextEdit(); + typeLabel = new QLabel(tr("&Type:")); + typeComboBox = new QComboBox(); + nextButton = new QPushButton(tr("&Next")); + previousButton = new QPushButton(tr("&Previous")); + + nameLabel->setBuddy(nameEdit); + addressLabel->setBuddy(addressEdit); + typeLabel->setBuddy(typeComboBox); +//! [Set up widgets] + +//! [Set up the mapper] + QSqlTableModel *relModel = model->relationModel(typeIndex); + typeComboBox->setModel(relModel); + typeComboBox->setModelColumn(relModel->fieldIndex("description")); + + mapper = new QDataWidgetMapper(this); + mapper->setModel(model); + mapper->setItemDelegate(new QSqlRelationalDelegate(this)); + mapper->addMapping(nameEdit, model->fieldIndex("name")); + mapper->addMapping(addressEdit, model->fieldIndex("address")); + mapper->addMapping(typeComboBox, typeIndex); +//! [Set up the mapper] + +//! [Set up connections and layouts] + connect(previousButton, SIGNAL(clicked()), + mapper, SLOT(toPrevious())); + connect(nextButton, SIGNAL(clicked()), + mapper, SLOT(toNext())); + connect(mapper, SIGNAL(currentIndexChanged(int)), + this, SLOT(updateButtons(int))); + + QGridLayout *layout = new QGridLayout(); + layout->addWidget(nameLabel, 0, 0, 1, 1); + layout->addWidget(nameEdit, 0, 1, 1, 1); + layout->addWidget(previousButton, 0, 2, 1, 1); + layout->addWidget(addressLabel, 1, 0, 1, 1); + layout->addWidget(addressEdit, 1, 1, 2, 1); + layout->addWidget(nextButton, 1, 2, 1, 1); + layout->addWidget(typeLabel, 3, 0, 1, 1); + layout->addWidget(typeComboBox, 3, 1, 1, 1); + setLayout(layout); + + setWindowTitle(tr("SQL Widget Mapper")); + mapper->toFirst(); +} +//! [Set up connections and layouts] + +//! [Set up the main table] +void Window::setupModel() +{ + QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); + db.setDatabaseName(":memory:"); + if (!db.open()) { + QMessageBox::critical(0, tr("Cannot open database"), + tr("Unable to establish a database connection.\n" + "This example needs SQLite support. Please read " + "the Qt SQL driver documentation for information how " + "to build it."), QMessageBox::Cancel); + return; + } + + QSqlQuery query; + query.exec("create table person (id int primary key, " + "name varchar(20), address varchar(200), typeid int)"); + query.exec("insert into person values(1, 'Alice', " + "'123 Main Street
Market Town
', 101)"); + query.exec("insert into person values(2, 'Bob', " + "'PO Box 32
Mail Handling Service" + "
Service City
', 102)"); + query.exec("insert into person values(3, 'Carol', " + "'The Lighthouse
Remote Island
', 103)"); + query.exec("insert into person values(4, 'Donald', " + "'47338 Park Avenue
Big City
', 101)"); + query.exec("insert into person values(5, 'Emma', " + "'Research Station
Base Camp
" + "Big Mountain
', 103)"); +//! [Set up the main table] + +//! [Set up the address type table] + query.exec("create table addresstype (id int, description varchar(20))"); + query.exec("insert into addresstype values(101, 'Home')"); + query.exec("insert into addresstype values(102, 'Work')"); + query.exec("insert into addresstype values(103, 'Other')"); + + model = new QSqlRelationalTableModel(this); + model->setTable("person"); + model->setEditStrategy(QSqlTableModel::OnManualSubmit); + + typeIndex = model->fieldIndex("typeid"); + + model->setRelation(typeIndex, + QSqlRelation("addresstype", "id", "description")); + model->select(); +} +//! [Set up the address type table] + +//! [Slot for updating the buttons] +void Window::updateButtons(int row) +{ + previousButton->setEnabled(row > 0); + nextButton->setEnabled(row < model->rowCount() - 1); +} +//! [Slot for updating the buttons]