diff options
Diffstat (limited to 'sources/pyside2/doc/codesnippets/examples/sql')
-rw-r--r-- | sources/pyside2/doc/codesnippets/examples/sql/querymodel/editablesqlmodel.cpp | 112 |
1 files changed, 0 insertions, 112 deletions
diff --git a/sources/pyside2/doc/codesnippets/examples/sql/querymodel/editablesqlmodel.cpp b/sources/pyside2/doc/codesnippets/examples/sql/querymodel/editablesqlmodel.cpp deleted file mode 100644 index 844ee7711..000000000 --- a/sources/pyside2/doc/codesnippets/examples/sql/querymodel/editablesqlmodel.cpp +++ /dev/null @@ -1,112 +0,0 @@ -/**************************************************************************** -** -** Copyright (C) 2016 The Qt Company Ltd. -** Contact: https://www.qt.io/licensing/ -** -** This file is part of the examples of the Qt Toolkit. -** -** $QT_BEGIN_LICENSE:BSD$ -** Commercial License Usage -** Licensees holding valid commercial Qt licenses may use this file in -** accordance with the commercial license agreement provided with the -** Software or, alternatively, in accordance with the terms contained in -** a written agreement between you and The Qt Company. For licensing terms -** and conditions see https://www.qt.io/terms-conditions. For further -** information use the contact form at https://www.qt.io/contact-us. -** -** BSD License Usage -** Alternatively, you may use this file under the terms of the BSD license -** as follows: -** -** "Redistribution and use in source and binary forms, with or without -** modification, are permitted provided that the following conditions are -** met: -** * Redistributions of source code must retain the above copyright -** notice, this list of conditions and the following disclaimer. -** * Redistributions in binary form must reproduce the above copyright -** notice, this list of conditions and the following disclaimer in -** the documentation and/or other materials provided with the -** distribution. -** * Neither the name of The Qt Company Ltd nor the names of its -** contributors may be used to endorse or promote products derived -** from this software without specific prior written permission. -** -** -** THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS -** "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT -** LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR -** A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT -** OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, -** SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT -** LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, -** DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY -** THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT -** (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE -** OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE." -** -** $QT_END_LICENSE$ -** -****************************************************************************/ - -#include <QtSql> - -#include "editablesqlmodel.h" - -EditableSqlModel::EditableSqlModel(QObject *parent) - : QSqlQueryModel(parent) -{ -} - -//! [0] -def flags(self, index): - flags = QSqlQueryModel.flags(index) - if index.column() == 1 or index.column() == 2: - flags |= Qt.ItemIsEditable - return flags -//! [0] - -//! [1] -def setData(self, index, value, role): - if index.column() < 1 or index.column() > 2: - return False - - primaryKeyIndex = QSqlQueryModel.index(index.row(), 0) - id = self.data(primaryKeyIndex).toInt() - - self.clear() - - ok = False - if index.column() == 1: - ok = self.setFirstName(id, value) - else: - ok = self.setLastName(id, value) - self.refresh() - return ok -} -//! [1] - -void EditableSqlModel::refresh() -{ - setQuery("select * from person"); - setHeaderData(0, Qt::Horizontal, QObject::tr("ID")); - setHeaderData(1, Qt::Horizontal, QObject::tr("First name")); - setHeaderData(2, Qt::Horizontal, QObject::tr("Last name")); -} - -//! [2] -def setFirstName(self, personId, firstName): - query = QSqlQuery() - query.prepare("update person set firstname = ? where id = ?") - query.addBindValue(firstName) - query.addBindValue(personId) - return query.exec() -//! [2] - -bool EditableSqlModel::setLastName(int personId, const QString &lastName) -{ - QSqlQuery query; - query.prepare("update person set lastname = ? where id = ?"); - query.addBindValue(lastName); - query.addBindValue(personId); - return query.exec(); -} |