author | Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> |
Fri, 19 Feb 2010 23:40:16 +0200 | |
branch | RCL_3 |
changeset 4 | 3b1da2848fc7 |
parent 0 | 1918ee327afb |
permissions | -rw-r--r-- |
0 | 1 |
/**************************************************************************** |
2 |
** |
|
4
3b1da2848fc7
Revision: 201003
Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
parents:
0
diff
changeset
|
3 |
** Copyright (C) 2010 Nokia Corporation and/or its subsidiary(-ies). |
0 | 4 |
** All rights reserved. |
5 |
** Contact: Nokia Corporation (qt-info@nokia.com) |
|
6 |
** |
|
7 |
** This file is part of the QtSql module of the Qt Toolkit. |
|
8 |
** |
|
9 |
** $QT_BEGIN_LICENSE:LGPL$ |
|
10 |
** No Commercial Usage |
|
11 |
** This file contains pre-release code and may not be distributed. |
|
12 |
** You may use this file in accordance with the terms and conditions |
|
13 |
** contained in the Technology Preview License Agreement accompanying |
|
14 |
** this package. |
|
15 |
** |
|
16 |
** GNU Lesser General Public License Usage |
|
17 |
** Alternatively, this file may be used under the terms of the GNU Lesser |
|
18 |
** General Public License version 2.1 as published by the Free Software |
|
19 |
** Foundation and appearing in the file LICENSE.LGPL included in the |
|
20 |
** packaging of this file. Please review the following information to |
|
21 |
** ensure the GNU Lesser General Public License version 2.1 requirements |
|
22 |
** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. |
|
23 |
** |
|
24 |
** In addition, as a special exception, Nokia gives you certain additional |
|
25 |
** rights. These rights are described in the Nokia Qt LGPL Exception |
|
26 |
** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. |
|
27 |
** |
|
28 |
** If you have questions regarding the use of this file, please contact |
|
29 |
** Nokia at qt-info@nokia.com. |
|
30 |
** |
|
31 |
** |
|
32 |
** |
|
33 |
** |
|
34 |
** |
|
35 |
** |
|
36 |
** |
|
37 |
** |
|
38 |
** $QT_END_LICENSE$ |
|
39 |
** |
|
40 |
****************************************************************************/ |
|
41 |
||
42 |
#ifndef QSQLTABLEMODEL_H |
|
43 |
#define QSQLTABLEMODEL_H |
|
44 |
||
45 |
#include <QtSql/qsqldatabase.h> |
|
46 |
#include <QtSql/qsqlquerymodel.h> |
|
47 |
||
48 |
QT_BEGIN_HEADER |
|
49 |
||
50 |
QT_BEGIN_NAMESPACE |
|
51 |
||
52 |
QT_MODULE(Sql) |
|
53 |
||
54 |
class QSqlTableModelPrivate; |
|
55 |
class QSqlRecord; |
|
56 |
class QSqlField; |
|
57 |
class QSqlIndex; |
|
58 |
||
59 |
class Q_SQL_EXPORT QSqlTableModel: public QSqlQueryModel |
|
60 |
{ |
|
61 |
Q_OBJECT |
|
62 |
Q_DECLARE_PRIVATE(QSqlTableModel) |
|
63 |
||
64 |
public: |
|
65 |
enum EditStrategy {OnFieldChange, OnRowChange, OnManualSubmit}; |
|
66 |
||
67 |
explicit QSqlTableModel(QObject *parent = 0, QSqlDatabase db = QSqlDatabase()); |
|
68 |
virtual ~QSqlTableModel(); |
|
69 |
||
70 |
virtual bool select(); |
|
71 |
||
72 |
virtual void setTable(const QString &tableName); |
|
73 |
QString tableName() const; |
|
74 |
||
75 |
Qt::ItemFlags flags(const QModelIndex &index) const; |
|
76 |
||
77 |
QVariant data(const QModelIndex &idx, int role = Qt::DisplayRole) const; |
|
78 |
bool setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole); |
|
79 |
||
80 |
QVariant headerData(int section, Qt::Orientation orientation, int role = Qt::DisplayRole) const; |
|
81 |
||
82 |
bool isDirty(const QModelIndex &index) const; |
|
83 |
void clear(); |
|
84 |
||
85 |
virtual void setEditStrategy(EditStrategy strategy); |
|
86 |
EditStrategy editStrategy() const; |
|
87 |
||
88 |
QSqlIndex primaryKey() const; |
|
89 |
QSqlDatabase database() const; |
|
90 |
int fieldIndex(const QString &fieldName) const; |
|
91 |
||
92 |
void sort(int column, Qt::SortOrder order); |
|
93 |
virtual void setSort(int column, Qt::SortOrder order); |
|
94 |
||
95 |
QString filter() const; |
|
96 |
virtual void setFilter(const QString &filter); |
|
97 |
||
98 |
int rowCount(const QModelIndex &parent = QModelIndex()) const; |
|
99 |
||
100 |
bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex()); |
|
101 |
bool removeRows(int row, int count, const QModelIndex &parent = QModelIndex()); |
|
102 |
bool insertRows(int row, int count, const QModelIndex &parent = QModelIndex()); |
|
103 |
||
104 |
bool insertRecord(int row, const QSqlRecord &record); |
|
105 |
bool setRecord(int row, const QSqlRecord &record); |
|
106 |
||
107 |
virtual void revertRow(int row); |
|
108 |
||
109 |
public Q_SLOTS: |
|
110 |
bool submit(); |
|
111 |
void revert(); |
|
112 |
||
113 |
bool submitAll(); |
|
114 |
void revertAll(); |
|
115 |
||
116 |
Q_SIGNALS: |
|
117 |
void primeInsert(int row, QSqlRecord &record); |
|
118 |
||
119 |
void beforeInsert(QSqlRecord &record); |
|
120 |
void beforeUpdate(int row, QSqlRecord &record); |
|
121 |
void beforeDelete(int row); |
|
122 |
||
123 |
protected: |
|
124 |
QSqlTableModel(QSqlTableModelPrivate &dd, QObject *parent = 0, QSqlDatabase db = QSqlDatabase()); |
|
125 |
||
126 |
virtual bool updateRowInTable(int row, const QSqlRecord &values); |
|
127 |
virtual bool insertRowIntoTable(const QSqlRecord &values); |
|
128 |
virtual bool deleteRowFromTable(int row); |
|
129 |
virtual QString orderByClause() const; |
|
130 |
virtual QString selectStatement() const; |
|
131 |
||
132 |
void setPrimaryKey(const QSqlIndex &key); |
|
133 |
void setQuery(const QSqlQuery &query); |
|
134 |
QModelIndex indexInQuery(const QModelIndex &item) const; |
|
135 |
}; |
|
136 |
||
137 |
QT_END_NAMESPACE |
|
138 |
||
139 |
QT_END_HEADER |
|
140 |
||
141 |
#endif // QSQLTABLEMODEL_H |