- Main Page
- Related Pages
- Modules
- Namespaces
- Classes
- Files
- Directories
- Examples

- File List
- File Members

# qsqlrelationaltablemodel.h

Go to the documentation of this file.

    00001 /****************************************************************************
    00002 **
    00003 ** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies).
    00004 ** All rights reserved.
    00005 ** Contact: Nokia Corporation (qt-info@nokia.com)
    00006 **
    00007 ** This file is part of the QtSql module of the Qt Toolkit.
    00008 **
    00009 ** $QT_BEGIN_LICENSE:LGPL$
    00010 ** Commercial Usage
    00011 ** Licensees holding valid Qt Commercial licenses may use this file in
    00012 ** accordance with the Qt Commercial License Agreement provided with the
    00013 ** Software or, alternatively, in accordance with the terms contained in
    00014 ** a written agreement between you and Nokia.
    00015 **
    00016 ** GNU Lesser General Public License Usage
    00017 ** Alternatively, this file may be used under the terms of the GNU Lesser
    00018 ** General Public License version 2.1 as published by the Free Software
    00019 ** Foundation and appearing in the file LICENSE.LGPL included in the
    00020 ** packaging of this file.  Please review the following information to
    00021 ** ensure the GNU Lesser General Public License version 2.1 requirements
    00022 ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
    00023 **
    00024 ** In addition, as a special exception, Nokia gives you certain additional
    00025 ** rights.  These rights are described in the Nokia Qt LGPL Exception
    00026 ** version 1.1, included in the file LGPL_EXCEPTION.txt in this module.
    00027 **
    00028 ** GNU General Public License Usage
    00029 ** Alternatively, this file may be used under the terms of the GNU
    00030 ** General Public License version 3.0 as published by the Free Software
    00031 ** Foundation and appearing in the file LICENSE.GPL included in the
    00032 ** packaging of this file.  Please review the following information to
    00033 ** ensure the GNU General Public License version 3.0 requirements will be
    00034 ** met: http://www.gnu.org/copyleft/gpl.html.
    00035 **
    00036 ** If you have questions regarding the use of this file, please contact
    00037 ** Nokia at qt-info@nokia.com.
    00038 ** $QT_END_LICENSE$
    00039 **
    00040 ****************************************************************************/
    00041
    00042 #ifndef QSQLRELATIONALTABLEMODEL_H
    00043 #define QSQLRELATIONALTABLEMODEL_H
    00044
    00045 #include <QtSql/qsqltablemodel.h>
    00046
    00047 QT_BEGIN_HEADER
    00048
    00049 QT_BEGIN_NAMESPACE
    00050
    00051 QT_MODULE(Sql)
    00052
    00053 class Q_SQL_EXPORT QSqlRelation
    00054 {
    00055 public:
    00056     QSqlRelation() {}
    00057     QSqlRelation(const QString &aTableName, const QString &indexCol,
    00058                const QString &displayCol)
    00059         : tName(aTableName), iColumn(indexCol), dColumn(displayCol) {}
    00060     inline QString tableName() const
    00061     { return tName; }
    00062     inline QString indexColumn() const
    00063     { return iColumn; }
    00064     inline QString displayColumn() const
    00065     { return dColumn; }
    00066     inline bool isValid() const
    00067     { return !(tName.isEmpty() || iColumn.isEmpty() || dColumn.isEmpty()); }
    00068 private:
    00069     QString tName, iColumn, dColumn;
    00070 };
    00071
    00072 class QSqlRelationalTableModelPrivate;
    00073
    00074 class Q_SQL_EXPORT QSqlRelationalTableModel: public QSqlTableModel
    00075 {
    00076     Q_OBJECT
    00077
    00078 public:
    00079     explicit QSqlRelationalTableModel(QObject *parent = 0,
    00080                                       QSqlDatabase db = QSqlDatabase());
    00081     virtual ~QSqlRelationalTableModel();
    00082
    00083     QVariant data(const QModelIndex &item, int role = Qt::DisplayRole) const;
    00084     bool setData(const QModelIndex &item, const QVariant &value, int role = Qt::EditRole);
    00085     bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex());
    00086
    00087     void clear();
    00088     bool select();
    00089
    00090     void setTable(const QString &tableName);
    00091     virtual void setRelation(int column, const QSqlRelation &relation);
    00092     QSqlRelation relation(int column) const;
    00093     virtual QSqlTableModel *relationModel(int column) const;
    00094
    00095 public Q_SLOTS:
    00096     void revertRow(int row);
    00097
    00098 protected:
    00099     QString selectStatement() const;
    00100     bool updateRowInTable(int row, const QSqlRecord &values);
    00101     bool insertRowIntoTable(const QSqlRecord &values);
    00102     QString orderByClause() const;
    00103
    00104 private:
    00105     Q_DECLARE_PRIVATE(QSqlRelationalTableModel)
    00106 };
    00107
    00108 QT_END_NAMESPACE
    00109
    00110 QT_END_HEADER
    00111
    00112 #endif // QSQLRELATIONALTABLEMODEL_H