| /**************************************************************************** |
| ** |
| ** Copyright (C) 2016 The Qt Company Ltd. |
| ** Contact: https://www.qt.io/licensing/ |
| ** |
| ** This file is part of the QtSql module of the Qt Toolkit. |
| ** |
| ** $QT_BEGIN_LICENSE:LGPL$ |
| ** 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 https://www.qt.io/terms-conditions. For further |
| ** information use the contact form at https://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 3 as published by the Free Software |
| ** Foundation and appearing in the file LICENSE.LGPL3 included in the |
| ** packaging of this file. Please review the following information to |
| ** ensure the GNU Lesser General Public License version 3 requirements |
| ** will be met: https://www.gnu.org/licenses/lgpl-3.0.html. |
| ** |
| ** GNU General Public License Usage |
| ** Alternatively, this file may be used under the terms of the GNU |
| ** General Public License version 2.0 or (at your option) the GNU General |
| ** Public license version 3 or any later version approved by the KDE Free |
| ** Qt Foundation. The licenses are as published by the Free Software |
| ** Foundation and appearing in the file LICENSE.GPL2 and LICENSE.GPL3 |
| ** included in the packaging of this file. Please review the following |
| ** information to ensure the GNU General Public License requirements will |
| ** be met: https://www.gnu.org/licenses/gpl-2.0.html and |
| ** https://www.gnu.org/licenses/gpl-3.0.html. |
| ** |
| ** $QT_END_LICENSE$ |
| ** |
| ****************************************************************************/ |
| |
| #ifndef QSQLTABLEMODEL_H |
| #define QSQLTABLEMODEL_H |
| |
| #include <QtSql/qtsqlglobal.h> |
| #include <QtSql/qsqldatabase.h> |
| #include <QtSql/qsqlquerymodel.h> |
| |
| QT_REQUIRE_CONFIG(sqlmodel); |
| |
| 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 = nullptr, QSqlDatabase db = QSqlDatabase()); |
| virtual ~QSqlTableModel(); |
| |
| virtual void setTable(const QString &tableName); |
| QString tableName() const; |
| |
| Qt::ItemFlags flags(const QModelIndex &index) const override; |
| |
| QSqlRecord record() const; |
| QSqlRecord record(int row) const; |
| QVariant data(const QModelIndex &idx, int role = Qt::DisplayRole) const override; |
| bool setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole) override; |
| #if QT_VERSION >= QT_VERSION_CHECK(6, 0, 0) |
| bool clearItemData(const QModelIndex &index) override; |
| #endif |
| |
| QVariant headerData(int section, Qt::Orientation orientation, int role = Qt::DisplayRole) const override; |
| |
| bool isDirty() const; |
| bool isDirty(const QModelIndex &index) const; |
| |
| void clear() 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) 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 override; |
| |
| bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex()) override; |
| bool removeRows(int row, int count, const QModelIndex &parent = QModelIndex()) override; |
| bool insertRows(int row, int count, const QModelIndex &parent = QModelIndex()) 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() override; |
| void revert() 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 = nullptr, 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 override; |
| QSqlRecord primaryValues(int row) const; |
| }; |
| |
| QT_END_NAMESPACE |
| |
| #endif // QSQLTABLEMODEL_H |