1
/****************************************************************************
3
** Copyright (C) 2004-2005 Trolltech AS. All rights reserved.
5
** This file is part of the example classes of the Qt Toolkit.
7
** This file may be distributed under the terms of the Q Public License
8
** as defined by Trolltech AS of Norway and appearing in the file
9
** LICENSE.QPL included in the packaging of this file.
11
** This file may be distributed and/or modified under the terms of the
12
** GNU General Public License version 2 as published by the Free Software
13
** Foundation and appearing in the file LICENSE.GPL included in the
14
** packaging of this file.
16
** See http://www.trolltech.com/pricing.html or email sales@trolltech.com for
17
** information about Qt Commercial License Agreements.
18
** See http://www.trolltech.com/qpl/ for QPL licensing information.
19
** See http://www.trolltech.com/gpl/ for GPL licensing information.
21
** Contact info@trolltech.com if any conditions of this licensing are
24
** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
25
** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
27
****************************************************************************/
32
#include "../connection.h"
34
void initializeModel(QSqlRelationalTableModel *model)
36
model->setTable("employee");
38
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
39
model->setRelation(2, QSqlRelation("city", "id", "name"));
40
model->setRelation(3, QSqlRelation("country", "id", "name"));
42
model->setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
43
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
44
model->setHeaderData(2, Qt::Horizontal, QObject::tr("City"));
45
model->setHeaderData(3, Qt::Horizontal, QObject::tr("Country"));
50
QTableView *createView(const QString &title, QSqlTableModel *model)
52
QTableView *view = new QTableView;
53
view->setModel(model);
54
view->setItemDelegate(new QSqlRelationalDelegate(view));
55
view->setWindowTitle(title);
59
void createRelationalTables()
62
query.exec("create table employee(id int, name varchar(20), city int, country int)");
63
query.exec("insert into employee values(1, 'Espen', 5000, 47)");
64
query.exec("insert into employee values(2, 'Harald', 80000, 49)");
65
query.exec("insert into employee values(3, 'Sam', 100, 1)");
67
query.exec("create table city(id int, name varchar(20))");
68
query.exec("insert into city values(100, 'San Jose')");
69
query.exec("insert into city values(5000, 'Oslo')");
70
query.exec("insert into city values(80000, 'Munich')");
72
query.exec("create table country(id int, name varchar(20))");
73
query.exec("insert into country values(1, 'USA')");
74
query.exec("insert into country values(47, 'Norway')");
75
query.exec("insert into country values(49, 'Germany')");
78
int main(int argc, char *argv[])
80
QApplication app(argc, argv);
81
if (!createConnection())
83
createRelationalTables();
85
QSqlRelationalTableModel model;
87
initializeModel(&model);
89
QTableView *view = createView(QObject::tr("Relational Table Model"), &model);