qsqltablemodel.h 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. /****************************************************************************
  2. **
  3. ** Copyright (C) 2016 The Qt Company Ltd.
  4. ** Contact: https://www.qt.io/licensing/
  5. **
  6. ** This file is part of the QtSql module of the Qt Toolkit.
  7. **
  8. ** $QT_BEGIN_LICENSE:LGPL$
  9. ** Commercial License Usage
  10. ** Licensees holding valid commercial Qt licenses may use this file in
  11. ** accordance with the commercial license agreement provided with the
  12. ** Software or, alternatively, in accordance with the terms contained in
  13. ** a written agreement between you and The Qt Company. For licensing terms
  14. ** and conditions see https://www.qt.io/terms-conditions. For further
  15. ** information use the contact form at https://www.qt.io/contact-us.
  16. **
  17. ** GNU Lesser General Public License Usage
  18. ** Alternatively, this file may be used under the terms of the GNU Lesser
  19. ** General Public License version 3 as published by the Free Software
  20. ** Foundation and appearing in the file LICENSE.LGPL3 included in the
  21. ** packaging of this file. Please review the following information to
  22. ** ensure the GNU Lesser General Public License version 3 requirements
  23. ** will be met: https://www.gnu.org/licenses/lgpl-3.0.html.
  24. **
  25. ** GNU General Public License Usage
  26. ** Alternatively, this file may be used under the terms of the GNU
  27. ** General Public License version 2.0 or (at your option) the GNU General
  28. ** Public license version 3 or any later version approved by the KDE Free
  29. ** Qt Foundation. The licenses are as published by the Free Software
  30. ** Foundation and appearing in the file LICENSE.GPL2 and LICENSE.GPL3
  31. ** included in the packaging of this file. Please review the following
  32. ** information to ensure the GNU General Public License requirements will
  33. ** be met: https://www.gnu.org/licenses/gpl-2.0.html and
  34. ** https://www.gnu.org/licenses/gpl-3.0.html.
  35. **
  36. ** $QT_END_LICENSE$
  37. **
  38. ****************************************************************************/
  39. #ifndef QSQLTABLEMODEL_H
  40. #define QSQLTABLEMODEL_H
  41. #include <QtSql/qsqldatabase.h>
  42. #include <QtSql/qsqlquerymodel.h>
  43. QT_BEGIN_NAMESPACE
  44. class QSqlTableModelPrivate;
  45. class QSqlRecord;
  46. class QSqlField;
  47. class QSqlIndex;
  48. class Q_SQL_EXPORT QSqlTableModel: public QSqlQueryModel
  49. {
  50. Q_OBJECT
  51. Q_DECLARE_PRIVATE(QSqlTableModel)
  52. public:
  53. enum EditStrategy {OnFieldChange, OnRowChange, OnManualSubmit};
  54. explicit QSqlTableModel(QObject *parent = Q_NULLPTR, QSqlDatabase db = QSqlDatabase());
  55. virtual ~QSqlTableModel();
  56. virtual void setTable(const QString &tableName);
  57. QString tableName() const;
  58. Qt::ItemFlags flags(const QModelIndex &index) const Q_DECL_OVERRIDE;
  59. QSqlRecord record() const;
  60. QSqlRecord record(int row) const;
  61. QVariant data(const QModelIndex &idx, int role = Qt::DisplayRole) const Q_DECL_OVERRIDE;
  62. bool setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole) Q_DECL_OVERRIDE;
  63. QVariant headerData(int section, Qt::Orientation orientation, int role = Qt::DisplayRole) const Q_DECL_OVERRIDE;
  64. bool isDirty() const;
  65. bool isDirty(const QModelIndex &index) const;
  66. void clear() Q_DECL_OVERRIDE;
  67. virtual void setEditStrategy(EditStrategy strategy);
  68. EditStrategy editStrategy() const;
  69. QSqlIndex primaryKey() const;
  70. QSqlDatabase database() const;
  71. int fieldIndex(const QString &fieldName) const;
  72. void sort(int column, Qt::SortOrder order) Q_DECL_OVERRIDE;
  73. virtual void setSort(int column, Qt::SortOrder order);
  74. QString filter() const;
  75. virtual void setFilter(const QString &filter);
  76. int rowCount(const QModelIndex &parent = QModelIndex()) const Q_DECL_OVERRIDE;
  77. bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex()) Q_DECL_OVERRIDE;
  78. bool removeRows(int row, int count, const QModelIndex &parent = QModelIndex()) Q_DECL_OVERRIDE;
  79. bool insertRows(int row, int count, const QModelIndex &parent = QModelIndex()) Q_DECL_OVERRIDE;
  80. bool insertRecord(int row, const QSqlRecord &record);
  81. bool setRecord(int row, const QSqlRecord &record);
  82. virtual void revertRow(int row);
  83. public Q_SLOTS:
  84. virtual bool select();
  85. virtual bool selectRow(int row);
  86. bool submit() Q_DECL_OVERRIDE;
  87. void revert() Q_DECL_OVERRIDE;
  88. bool submitAll();
  89. void revertAll();
  90. Q_SIGNALS:
  91. void primeInsert(int row, QSqlRecord &record);
  92. void beforeInsert(QSqlRecord &record);
  93. void beforeUpdate(int row, QSqlRecord &record);
  94. void beforeDelete(int row);
  95. protected:
  96. QSqlTableModel(QSqlTableModelPrivate &dd, QObject *parent = Q_NULLPTR, QSqlDatabase db = QSqlDatabase());
  97. virtual bool updateRowInTable(int row, const QSqlRecord &values);
  98. virtual bool insertRowIntoTable(const QSqlRecord &values);
  99. virtual bool deleteRowFromTable(int row);
  100. virtual QString orderByClause() const;
  101. virtual QString selectStatement() const;
  102. void setPrimaryKey(const QSqlIndex &key);
  103. void setQuery(const QSqlQuery &query);
  104. QModelIndex indexInQuery(const QModelIndex &item) const Q_DECL_OVERRIDE;
  105. QSqlRecord primaryValues(int row) const;
  106. };
  107. QT_END_NAMESPACE
  108. #endif // QSQLTABLEMODEL_H