| /**************************************************************************** |
| ** |
| ** 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 QSQLTABLEMODEL_H |
| #define QSQLTABLEMODEL_H |
| |
| #include <QtSql/qsqldatabase.h> |
| #include <QtSql/qsqlquerymodel.h> |
| |
| QT_BEGIN_HEADER |
| |
| QT_BEGIN_NAMESPACE |
| |
| QT_MODULE(Sql) |
| |
| class QSqlTableModelPrivate; |
| class QSqlRecord; |
| class QSqlField; |
| class QSqlIndex; |
| |
| class Q_SQL_EXPORT QSqlTableModel: public QSqlQueryModel |
| { |
| Q_OBJECT |
| Q_DECLARE_PRIVATE(QSqlTableModel) |
| |
| public: |
| enum EditStrategy {OnFieldChange, OnRowChange, OnManualSubmit}; |
| |
| explicit QSqlTableModel(QObject *parent = 0, QSqlDatabase db = QSqlDatabase()); |
| virtual ~QSqlTableModel(); |
| |
| virtual bool select(); |
| |
| virtual void setTable(const QString &tableName); |
| QString tableName() const; |
| |
| Qt::ItemFlags flags(const QModelIndex &index) const; |
| |
| QVariant data(const QModelIndex &idx, int role = Qt::DisplayRole) const; |
| bool setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole); |
| |
| QVariant headerData(int section, Qt::Orientation orientation, int role = Qt::DisplayRole) const; |
| |
| bool isDirty(const QModelIndex &index) const; |
| void clear(); |
| |
| virtual void setEditStrategy(EditStrategy strategy); |
| EditStrategy editStrategy() const; |
| |
| QSqlIndex primaryKey() const; |
| QSqlDatabase database() const; |
| int fieldIndex(const QString &fieldName) const; |
| |
| void sort(int column, Qt::SortOrder order); |
| virtual void setSort(int column, Qt::SortOrder order); |
| |
| QString filter() const; |
| virtual void setFilter(const QString &filter); |
| |
| int rowCount(const QModelIndex &parent = QModelIndex()) const; |
| |
| bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex()); |
| bool removeRows(int row, int count, const QModelIndex &parent = QModelIndex()); |
| bool insertRows(int row, int count, const QModelIndex &parent = QModelIndex()); |
| |
| bool insertRecord(int row, const QSqlRecord &record); |
| bool setRecord(int row, const QSqlRecord &record); |
| |
| virtual void revertRow(int row); |
| |
| public Q_SLOTS: |
| bool submit(); |
| void revert(); |
| |
| bool submitAll(); |
| void revertAll(); |
| |
| Q_SIGNALS: |
| void primeInsert(int row, QSqlRecord &record); |
| |
| void beforeInsert(QSqlRecord &record); |
| void beforeUpdate(int row, QSqlRecord &record); |
| void beforeDelete(int row); |
| |
| protected: |
| QSqlTableModel(QSqlTableModelPrivate &dd, QObject *parent = 0, QSqlDatabase db = QSqlDatabase()); |
| |
| virtual bool updateRowInTable(int row, const QSqlRecord &values); |
| virtual bool insertRowIntoTable(const QSqlRecord &values); |
| virtual bool deleteRowFromTable(int row); |
| virtual QString orderByClause() const; |
| virtual QString selectStatement() const; |
| |
| void setPrimaryKey(const QSqlIndex &key); |
| void setQuery(const QSqlQuery &query); |
| QModelIndex indexInQuery(const QModelIndex &item) const; |
| }; |
| |
| QT_END_NAMESPACE |
| |
| QT_END_HEADER |
| |
| #endif // QSQLTABLEMODEL_H |