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
40#ifndef QSQLQUERYMODEL_H
41#define QSQLQUERYMODEL_H
42
43#include <QtSql/qtsqlglobal.h>
44#include <QtCore/qabstractitemmodel.h>
45#include <QtSql/qsqldatabase.h>
46
47QT_REQUIRE_CONFIG(sqlmodel);
48
49QT_BEGIN_NAMESPACE
50
51class QSqlQueryModelPrivate;
52class QSqlError;
53class QSqlRecord;
54class QSqlQuery;
55
56class Q_SQL_EXPORT QSqlQueryModel: public QAbstractTableModel
57{
58 Q_OBJECT
59 Q_DECLARE_PRIVATE(QSqlQueryModel)
60
61public:
62 explicit QSqlQueryModel(QObject *parent = nullptr);
63 virtual ~QSqlQueryModel();
64
65 int rowCount(const QModelIndex &parent = QModelIndex()) const override;
66 int columnCount(const QModelIndex &parent = QModelIndex()) const override;
67 QSqlRecord record(int row) const;
68 QSqlRecord record() const;
69
70 QVariant data(const QModelIndex &item, int role = Qt::DisplayRole) const override;
71 QVariant headerData(int section, Qt::Orientation orientation,
72 int role = Qt::DisplayRole) const override;
73 bool setHeaderData(int section, Qt::Orientation orientation, const QVariant &value,
74 int role = Qt::EditRole) override;
75
76 bool insertColumns(int column, int count, const QModelIndex &parent = QModelIndex()) override;
77 bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex()) override;
78
79 void setQuery(const QSqlQuery &query);
80 void setQuery(const QString &query, const QSqlDatabase &db = QSqlDatabase());
81 QSqlQuery query() const;
82
83 virtual void clear();
84
85 QSqlError lastError() const;
86
87 void fetchMore(const QModelIndex &parent = QModelIndex()) override;
88 bool canFetchMore(const QModelIndex &parent = QModelIndex()) const override;
89
90 QHash<int, QByteArray> roleNames() const override;
91
92protected:
93 void beginInsertRows(const QModelIndex &parent, int first, int last);
94 void endInsertRows();
95
96 void beginRemoveRows(const QModelIndex &parent, int first, int last);
97 void endRemoveRows();
98
99 void beginInsertColumns(const QModelIndex &parent, int first, int last);
100 void endInsertColumns();
101
102 void beginRemoveColumns(const QModelIndex &parent, int first, int last);
103 void endRemoveColumns();
104
105 void beginResetModel();
106 void endResetModel();
107 virtual void queryChange();
108
109 virtual QModelIndex indexInQuery(const QModelIndex &item) const;
110 void setLastError(const QSqlError &error);
111 QSqlQueryModel(QSqlQueryModelPrivate &dd, QObject *parent = nullptr);
112};
113
114QT_END_NAMESPACE
115
116#endif // QSQLQUERYMODEL_H
117