1 /****************************************************************************

     2 **

     3 ** Copyright (C) 2009 Nokia Corporation and/or its subsidiary(-ies).

     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