|  | Home · All Classes · Main Classes · Grouped Classes · Modules · Functions |

# relationaltablemodel.cpp Example File
sql/relationaltablemodel/relationaltablemodel.cpp

        /****************************************************************************
        **
        ** Copyright (C) 2004-2006 Trolltech ASA. All rights reserved.
        **
        ** This file is part of the example classes of the Qt Toolkit.
        **
        ** Licensees holding valid Qt Preview licenses may use this file in
        ** accordance with the Qt Preview License Agreement provided with the
        ** Software.
        **
        ** See http://www.trolltech.com/pricing.html or email sales@trolltech.com for
        ** information about Qt Commercial License Agreements.
        **
        ** Contact info@trolltech.com if any conditions of this licensing are
        ** not clear to you.
        **
        ** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
        ** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
        **
        ****************************************************************************/

        #include <QtGui>
        #include <QtSql>

        #include "../connection.h"

        void initializeModel(QSqlRelationalTableModel *model)
        {
            model->setTable("employee");

            model->setEditStrategy(QSqlTableModel::OnManualSubmit);
            model->setRelation(2, QSqlRelation("city", "id", "name"));
            model->setRelation(3, QSqlRelation("country", "id", "name"));

            model->setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
            model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
            model->setHeaderData(2, Qt::Horizontal, QObject::tr("City"));
            model->setHeaderData(3, Qt::Horizontal, QObject::tr("Country"));

            model->select();
        }

        QTableView *createView(const QString &title, QSqlTableModel *model)
        {
            QTableView *view = new QTableView;
            view->setModel(model);
            view->setItemDelegate(new QSqlRelationalDelegate(view));
            view->setWindowTitle(title);
            return view;
        }

        void createRelationalTables()
        {
            QSqlQuery query;
            query.exec("create table employee(id int, name varchar(20), city int, country int)");
            query.exec("insert into employee values(1, 'Espen', 5000, 47)");
            query.exec("insert into employee values(2, 'Harald', 80000, 49)");
            query.exec("insert into employee values(3, 'Sam', 100, 1)");

            query.exec("create table city(id int, name varchar(20))");
            query.exec("insert into city values(100, 'San Jose')");
            query.exec("insert into city values(5000, 'Oslo')");
            query.exec("insert into city values(80000, 'Munich')");

            query.exec("create table country(id int, name varchar(20))");
            query.exec("insert into country values(1, 'USA')");
            query.exec("insert into country values(47, 'Norway')");
            query.exec("insert into country values(49, 'Germany')");
        }

        int main(int argc, char *argv[])
        {
            QApplication app(argc, argv);
            if (!createConnection())
                return 1;
            createRelationalTables();

            QSqlRelationalTableModel model;

            initializeModel(&model);

            QTableView *view = createView(QObject::tr("Relational Table Model"), &model);
            view->show();

            return app.exec();
        }