1
/****************************************************************************
3
** Copyright (C) 1992-2005 Trolltech AS. All rights reserved.
5
** This file is part of the sql module of the Qt Toolkit.
7
** This file may be distributed under the terms of the Q Public License
8
** as defined by Trolltech AS of Norway and appearing in the file
9
** LICENSE.QPL included in the packaging of this file.
11
** This file may be distributed and/or modified under the terms of the
12
** GNU General Public License version 2 as published by the Free Software
13
** Foundation and appearing in the file LICENSE.GPL included in the
14
** packaging of this file.
16
** See http://www.trolltech.com/pricing.html or email sales@trolltech.com for
17
** information about Qt Commercial License Agreements.
18
** See http://www.trolltech.com/qpl/ for QPL licensing information.
19
** See http://www.trolltech.com/gpl/ for GPL licensing information.
21
** Contact info@trolltech.com if any conditions of this licensing are
24
** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
25
** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
27
****************************************************************************/
29
#ifndef QSQLTABLEMODEL_H
30
#define QSQLTABLEMODEL_H
32
#include "QtSql/qsqldatabase.h"
33
#include "QtSql/qsqlquerymodel.h"
35
class QSqlTableModelPrivate;
40
class Q_SQL_EXPORT QSqlTableModel: public QSqlQueryModel
43
Q_DECLARE_PRIVATE(QSqlTableModel)
46
enum EditStrategy {OnFieldChange, OnRowChange, OnManualSubmit};
48
explicit QSqlTableModel(QObject *parent = 0, QSqlDatabase db = QSqlDatabase());
49
virtual ~QSqlTableModel();
51
virtual bool select();
53
virtual void setTable(const QString &tableName);
54
QString tableName() const;
56
Qt::ItemFlags flags(const QModelIndex &index) const;
58
QVariant data(const QModelIndex &idx, int role = Qt::DisplayRole) const;
59
bool setData(const QModelIndex &index, const QVariant &value, int role = Qt::EditRole);
61
QVariant headerData(int section, Qt::Orientation orientation, int role = Qt::DisplayRole) const;
63
bool isDirty(const QModelIndex &index) const;
66
virtual void setEditStrategy(EditStrategy strategy);
67
EditStrategy editStrategy() const;
69
QSqlIndex primaryKey() const;
70
QSqlDatabase database() const;
71
int fieldIndex(const QString &fieldName) const;
73
void sort(int column, Qt::SortOrder order);
74
virtual void setSort(int column, Qt::SortOrder order);
76
QString filter() const;
77
virtual void setFilter(const QString &filter);
79
int rowCount(const QModelIndex &parent = QModelIndex()) const;
81
bool removeColumns(int column, int count, const QModelIndex &parent = QModelIndex());
82
bool removeRows(int row, int count, const QModelIndex &parent = QModelIndex());
83
bool insertRows(int row, int count, const QModelIndex &parent = QModelIndex());
85
bool insertRecord(int row, const QSqlRecord &record);
86
bool setRecord(int row, const QSqlRecord &record);
88
virtual void revertRow(int row);
98
void primeInsert(int row, QSqlRecord &record);
100
void beforeInsert(QSqlRecord &record);
101
void beforeUpdate(int row, QSqlRecord &record);
102
void beforeDelete(int row);
105
QSqlTableModel(QSqlTableModelPrivate &dd, QObject *parent = 0, QSqlDatabase db = QSqlDatabase());
107
virtual bool updateRowInTable(int row, const QSqlRecord &values);
108
virtual bool insertRowIntoTable(const QSqlRecord &values);
109
virtual bool deleteRowFromTable(int row);
110
virtual QString orderByClause() const;
111
virtual QString selectStatement() const;
113
void setPrimaryKey(const QSqlIndex &key);
114
void setQuery(const QSqlQuery &query);
115
QModelIndex indexInQuery(const QModelIndex &item) const;
118
#endif // QSQLTABLEMODEL_H