| /**************************************************************************** |
| ** |
| ** 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_P_H |
| #define QSQLTABLEMODEL_P_H |
| |
| // |
| // W A R N I N G |
| // ------------- |
| // |
| // This file is not part of the Qt API. It exists for the convenience |
| // of qsql*model.h . This header file may change from version to version |
| // without notice, or even be removed. |
| // |
| // We mean it. |
| // |
| |
| #include "private/qsqlquerymodel_p.h" |
| #include "QtSql/qsqlindex.h" |
| #include "QtCore/qmap.h" |
| |
| QT_BEGIN_NAMESPACE |
| |
| class QSqlTableModelPrivate: public QSqlQueryModelPrivate |
| { |
| Q_DECLARE_PUBLIC(QSqlTableModel) |
| |
| public: |
| QSqlTableModelPrivate() |
| : sortColumn(-1), |
| sortOrder(Qt::AscendingOrder), |
| strategy(QSqlTableModel::OnRowChange), |
| busyInsertingRows(false) |
| {} |
| void clear(); |
| virtual void clearCache(); |
| QSqlRecord record(const QVector<QVariant> &values) const; |
| |
| bool exec(const QString &stmt, bool prepStatement, |
| const QSqlRecord &rec, const QSqlRecord &whereValues); |
| virtual void revertCachedRow(int row); |
| virtual int nameToIndex(const QString &name) const; |
| QString strippedFieldName(const QString &name) const; |
| int insertCount(int maxRow = -1) const; |
| void initRecordAndPrimaryIndex(); |
| |
| QSqlDatabase db; |
| |
| int sortColumn; |
| Qt::SortOrder sortOrder; |
| |
| QSqlTableModel::EditStrategy strategy; |
| bool busyInsertingRows; |
| |
| QSqlQuery editQuery; |
| QSqlIndex primaryIndex; |
| QString tableName; |
| QString filter; |
| QString autoColumn; |
| |
| enum Op { None, Insert, Update, Delete }; |
| |
| class ModifiedRow |
| { |
| public: |
| inline ModifiedRow(Op o = None, const QSqlRecord &r = QSqlRecord()) |
| : m_op(None), m_db_values(r), m_insert(o == Insert) |
| { setOp(o); } |
| inline Op op() const { return m_op; } |
| inline void setOp(Op o) |
| { |
| if (o == None) |
| m_submitted = true; |
| if (o == m_op) |
| return; |
| m_submitted = (o != Insert && o != Delete); |
| m_op = o; |
| m_rec = m_db_values; |
| setGenerated(m_rec, m_op == Delete); |
| } |
| inline QSqlRecord rec() const { return m_rec; } |
| inline QSqlRecord& recRef() { return m_rec; } |
| inline void setValue(int c, const QVariant &v) |
| { |
| m_submitted = false; |
| m_rec.setValue(c, v); |
| m_rec.setGenerated(c, true); |
| } |
| inline bool submitted() const { return m_submitted; } |
| inline void setSubmitted() |
| { |
| m_submitted = true; |
| setGenerated(m_rec, false); |
| if (m_op == Delete) { |
| m_rec.clearValues(); |
| } |
| else { |
| m_op = Update; |
| m_db_values = m_rec; |
| setGenerated(m_db_values, true); |
| } |
| } |
| inline void refresh(bool exists, const QSqlRecord& newvals) |
| { |
| m_submitted = true; |
| if (exists) { |
| m_op = Update; |
| m_db_values = newvals; |
| m_rec = newvals; |
| setGenerated(m_rec, false); |
| } else { |
| m_op = Delete; |
| m_rec.clear(); |
| m_db_values.clear(); |
| } |
| } |
| inline bool insert() const { return m_insert; } |
| inline void revert() |
| { |
| if (m_submitted) |
| return; |
| if (m_op == Delete) |
| m_op = Update; |
| m_rec = m_db_values; |
| setGenerated(m_rec, false); |
| m_submitted = true; |
| } |
| inline QSqlRecord primaryValues(const QSqlRecord& pi) const |
| { |
| if (m_op == None || m_op == Insert) |
| return QSqlRecord(); |
| |
| return m_db_values.keyValues(pi); |
| } |
| private: |
| inline static void setGenerated(QSqlRecord& r, bool g) |
| { |
| for (int i = r.count() - 1; i >= 0; --i) |
| r.setGenerated(i, g); |
| } |
| Op m_op; |
| QSqlRecord m_rec; |
| QSqlRecord m_db_values; |
| bool m_submitted; |
| bool m_insert; |
| }; |
| |
| typedef QMap<int, ModifiedRow> CacheMap; |
| CacheMap cache; |
| }; |
| |
| class QSqlTableModelSql: public QSqlQueryModelSql |
| { |
| public: |
| }; |
| |
| QT_END_NAMESPACE |
| |
| #endif // QSQLTABLEMODEL_P_H |