editablesqlmodel.cpp Example File

Find this file on Gitorious.

  1. /****************************************************************************
  2. **
  3. ** Copyright (C) 2011 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 examples of the Qt Toolkit.
  8. **
  9. ** $QT_BEGIN_LICENSE:BSD$
  10. ** You may use this file under the terms of the BSD license as follows:
  11. **
  12. ** "Redistribution and use in source and binary forms, with or without
  13. ** modification, are permitted provided that the following conditions are
  14. ** met:
  15. **   * Redistributions of source code must retain the above copyright
  16. **     notice, this list of conditions and the following disclaimer.
  17. **   * Redistributions in binary form must reproduce the above copyright
  18. **     notice, this list of conditions and the following disclaimer in
  19. **     the documentation and/or other materials provided with the
  20. **     distribution.
  21. **   * Neither the name of Nokia Corporation and its Subsidiary(-ies) nor
  22. **     the names of its contributors may be used to endorse or promote
  23. **     products derived from this software without specific prior written
  24. **     permission.
  25. **
  26. ** THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  27. ** "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  28. ** LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
  29. ** A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
  30. ** OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  31. ** SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  32. ** LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
  33. ** DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
  34. ** THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  35. ** (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
  36. ** OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE."
  37. ** $QT_END_LICENSE$
  38. **
  39. ****************************************************************************/
  40.  
  41. #include <QtSql>
  42.  
  43. #include "editablesqlmodel.h"
  44.  
  45. EditableSqlModel::EditableSqlModel(QObject *parent)
  46.     : QSqlQueryModel(parent)
  47.  {
  48. }
  49.  
  50. Qt::ItemFlags EditableSqlModel::flags(
  51.         const QModelIndex &index) const
  52.  {
  53.     Qt::ItemFlags flags = QSqlQueryModel::flags(index);
  54.     if (index.column() == 1 || index.column() == 2)
  55.         flags |= Qt::ItemIsEditable;
  56.     return flags;
  57. }
  58.  
  59. bool EditableSqlModel::setData(const QModelIndex &index, const QVariant &value, int /* role */)
  60.  {
  61.     if (index.column() < 1 || index.column() > 2)
  62.         return false;
  63.  
  64.     QModelIndex primaryKeyIndex = QSqlQueryModel::index(index.row(), 0);
  65.     int id = data(primaryKeyIndex).toInt();
  66.  
  67.     clear();
  68.  
  69.     bool ok;
  70.     if (index.column() == 1)  {
  71.         ok = setFirstName(id, value.toString());
  72.     } else  {
  73.         ok = setLastName(id, value.toString());
  74.     }
  75.     refresh();
  76.     return ok;
  77. }
  78.  
  79. void EditableSqlModel::refresh()
  80.  {
  81.     setQuery("select * from person");
  82.     setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
  83.     setHeaderData(1, Qt::Horizontal, QObject::tr("First name"));
  84.     setHeaderData(2, Qt::Horizontal, QObject::tr("Last name"));
  85. }
  86.  
  87. bool EditableSqlModel::setFirstName(int personId, const QString &firstName)
  88.  {
  89.     QSqlQuery query;
  90.     query.prepare("update person set firstname = ? where id = ?");
  91.     query.addBindValue(firstName);
  92.     query.addBindValue(personId);
  93.     return query.exec();
  94. }
  95.  
  96. bool EditableSqlModel::setLastName(int personId, const QString &lastName)
  97.  {
  98.     QSqlQuery query;
  99.     query.prepare("update person set lastname = ? where id = ?");
  100.     query.addBindValue(lastName);
  101.     query.addBindValue(personId);
  102.     return query.exec();
  103. }
Notes provided by the Qt Community

No notes