| /**************************************************************************** |
| ** |
| ** Copyright (C) 2015 The Qt Company Ltd. |
| ** Contact: http://www.qt.io/licensing/ |
| ** |
| ** This file is part of the QtSql module of the Qt Toolkit. |
| ** |
| ** $QT_BEGIN_LICENSE:LGPL21$ |
| ** Commercial License Usage |
| ** Licensees holding valid commercial Qt licenses may use this file in |
| ** accordance with the commercial license agreement provided with the |
| ** Software or, alternatively, in accordance with the terms contained in |
| ** a written agreement between you and The Qt Company. For licensing terms |
| ** and conditions see http://www.qt.io/terms-conditions. For further |
| ** information use the contact form at http://www.qt.io/contact-us. |
| ** |
| ** GNU Lesser General Public License Usage |
| ** Alternatively, this file may be used under the terms of the GNU Lesser |
| ** General Public License version 2.1 or version 3 as published by the Free |
| ** Software Foundation and appearing in the file LICENSE.LGPLv21 and |
| ** LICENSE.LGPLv3 included in the packaging of this file. Please review the |
| ** following information to ensure the GNU Lesser General Public License |
| ** requirements will be met: https://www.gnu.org/licenses/lgpl.html and |
| ** http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. |
| ** |
| ** As a special exception, The Qt Company gives you certain additional |
| ** rights. These rights are described in The Qt Company LGPL Exception |
| ** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. |
| ** |
| ** $QT_END_LICENSE$ |
| ** |
| ****************************************************************************/ |
| |
| #ifndef QSQLTABLEMODEL_H |
| #define QSQLTABLEMODEL_H |
| |
| #include <QtSql/qsqldatabase.h> |
| #include <QtSql/qsqlquerymodel.h> |
| |
| QT_BEGIN_NAMESPACE |
| |
| |
| 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 void setTable(const QString &tableName); |
| QString tableName() const; |
| |
| Qt::ItemFlags flags(const QModelIndex &index) const Q_DECL_OVERRIDE; |
| |
| QSqlRecord record() const; |
| QSqlRecord record(int row) const; |
| QVariant data(const QModelIndex &idx, int role = Qt::DisplayRole) const Q_DECL_OVERRIDE; |
| bool setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole) Q_DECL_OVERRIDE; |
| |
| QVariant headerData(int section, Qt::Orientation orientation, int role = Qt::DisplayRole) const Q_DECL_OVERRIDE; |
| |
| bool isDirty() const; |
| bool isDirty(const QModelIndex &index) const; |
| |
| void clear() Q_DECL_OVERRIDE; |
| |
| 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) Q_DECL_OVERRIDE; |
| virtual void setSort(int column, Qt::SortOrder order); |
| |
| QString filter() const; |
| virtual void setFilter(const QString &filter); |
| |
| int rowCount(const QModelIndex &parent = QModelIndex()) const Q_DECL_OVERRIDE; |
| |
| bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex()) Q_DECL_OVERRIDE; |
| bool removeRows(int row, int count, const QModelIndex &parent = QModelIndex()) Q_DECL_OVERRIDE; |
| bool insertRows(int row, int count, const QModelIndex &parent = QModelIndex()) Q_DECL_OVERRIDE; |
| |
| bool insertRecord(int row, const QSqlRecord &record); |
| bool setRecord(int row, const QSqlRecord &record); |
| |
| virtual void revertRow(int row); |
| |
| public Q_SLOTS: |
| virtual bool select(); |
| virtual bool selectRow(int row); |
| |
| bool submit() Q_DECL_OVERRIDE; |
| void revert() Q_DECL_OVERRIDE; |
| |
| 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 Q_DECL_OVERRIDE; |
| QSqlRecord primaryValues(int row) const; |
| }; |
| |
| QT_END_NAMESPACE |
| |
| #endif // QSQLTABLEMODEL_H |