/**************************************************************************** | |
** | |
** Copyright (C) 2011 Nokia Corporation and/or its subsidiary(-ies). | |
** All rights reserved. | |
** Contact: Nokia Corporation (qt-info@nokia.com) | |
** | |
** This file is part of the QtSql module of the Qt Toolkit. | |
** | |
** $QT_BEGIN_LICENSE:LGPL$ | |
** GNU Lesser General Public License Usage | |
** 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. | |
** | |
** 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. | |
** | |
** Other Usage | |
** Alternatively, this file may be used in accordance with the terms and | |
** conditions contained in a signed written agreement between you and Nokia. | |
** | |
** | |
** | |
** | |
** | |
** $QT_END_LICENSE$ | |
** | |
****************************************************************************/ | |
#ifndef QSQLRELATIONALTABLEMODEL_H | |
#define QSQLRELATIONALTABLEMODEL_H | |
#include <QtSql/qsqltablemodel.h> | |
QT_BEGIN_HEADER | |
QT_BEGIN_NAMESPACE | |
QT_MODULE(Sql) | |
class Q_SQL_EXPORT QSqlRelation | |
{ | |
public: | |
QSqlRelation() {} | |
QSqlRelation(const QString &aTableName, const QString &indexCol, | |
const QString &displayCol) | |
: tName(aTableName), iColumn(indexCol), dColumn(displayCol) {} | |
inline QString tableName() const | |
{ return tName; } | |
inline QString indexColumn() const | |
{ return iColumn; } | |
inline QString displayColumn() const | |
{ return dColumn; } | |
inline bool isValid() const | |
{ return !(tName.isEmpty() || iColumn.isEmpty() || dColumn.isEmpty()); } | |
private: | |
QString tName, iColumn, dColumn; | |
}; | |
class QSqlRelationalTableModelPrivate; | |
class Q_SQL_EXPORT QSqlRelationalTableModel: public QSqlTableModel | |
{ | |
Q_OBJECT | |
public: | |
explicit QSqlRelationalTableModel(QObject *parent = 0, | |
QSqlDatabase db = QSqlDatabase()); | |
virtual ~QSqlRelationalTableModel(); | |
QVariant data(const QModelIndex &item, int role = Qt::DisplayRole) const; | |
bool setData(const QModelIndex &item, const QVariant &value, int role = Qt::EditRole); | |
bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex()); | |
void clear(); | |
bool select(); | |
void setTable(const QString &tableName); | |
virtual void setRelation(int column, const QSqlRelation &relation); | |
QSqlRelation relation(int column) const; | |
virtual QSqlTableModel *relationModel(int column) const; | |
public Q_SLOTS: | |
void revertRow(int row); | |
protected: | |
QString selectStatement() const; | |
bool updateRowInTable(int row, const QSqlRecord &values); | |
bool insertRowIntoTable(const QSqlRecord &values); | |
QString orderByClause() const; | |
private: | |
Q_DECLARE_PRIVATE(QSqlRelationalTableModel) | |
}; | |
QT_END_NAMESPACE | |
QT_END_HEADER | |
#endif // QSQLRELATIONALTABLEMODEL_H |