diff options
Diffstat (limited to 'sources/pyside6/tests/QtSql/qsqldatabaseandqueries_test.py')
| -rw-r--r-- | sources/pyside6/tests/QtSql/qsqldatabaseandqueries_test.py | 88 |
1 files changed, 34 insertions, 54 deletions
diff --git a/sources/pyside6/tests/QtSql/qsqldatabaseandqueries_test.py b/sources/pyside6/tests/QtSql/qsqldatabaseandqueries_test.py index 3123e027d..a3e70a3a7 100644 --- a/sources/pyside6/tests/QtSql/qsqldatabaseandqueries_test.py +++ b/sources/pyside6/tests/QtSql/qsqldatabaseandqueries_test.py @@ -1,36 +1,10 @@ #!/usr/bin/python - -############################################################################# -## -## Copyright (C) 2016 The Qt Company Ltd. -## Contact: https://www.qt.io/licensing/ -## -## This file is part of the test suite of Qt for Python. -## -## $QT_BEGIN_LICENSE:GPL-EXCEPT$ -## 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. -## -## GNU General Public License Usage -## Alternatively, this file may be used under the terms of the GNU -## General Public License version 3 as published by the Free Software -## Foundation with exceptions as appearing in the file LICENSE.GPL3-EXCEPT -## included in the packaging of this file. Please review the following -## information to ensure the GNU General Public License requirements will -## be met: https://www.gnu.org/licenses/gpl-3.0.html. -## -## $QT_END_LICENSE$ -## -############################################################################# +# Copyright (C) 2022 The Qt Company Ltd. +# SPDX-License-Identifier: LicenseRef-Qt-Commercial OR GPL-3.0-only WITH Qt-GPL-exception-1.0 '''Test cases for QtSql database creation, destruction and queries''' -import sys +import gc import os import sys import unittest @@ -40,66 +14,72 @@ sys.path.append(os.fspath(Path(__file__).resolve().parents[1])) from init_paths import init_test_paths init_test_paths(False) -from PySide6 import QtSql -from PySide6.QtCore import * -from PySide6.QtWidgets import * +from PySide6.QtSql import QSqlDatabase, QSqlQuery, QSqlTableModel +from PySide6.QtWidgets import QApplication, QWidget +from helper.usesqapplication import UsesQApplication + class Foo(QWidget): def __init__(self): - QWidget.__init__(self) - self.model = QtSql.QSqlTableModel() + super().__init__() + self.model = QSqlTableModel() -class SqlDatabaseCreationDestructionAndQueries(unittest.TestCase): + +class SqlDatabaseCreationDestructionAndQueries(UsesQApplication): '''Test cases for QtSql database creation, destruction and queries''' def setUp(self): - #Acquire resources - self.assertFalse(not QtSql.QSqlDatabase.drivers(), "installed Qt has no DB drivers") - self.assertTrue("QSQLITE" in QtSql.QSqlDatabase.drivers(), "\"QSQLITE\" driver not available in this Qt version") - self.db = QtSql.QSqlDatabase.addDatabase("QSQLITE") + # Acquire resources + super().setUp() + self.assertFalse(not QSqlDatabase.drivers(), "installed Qt has no DB drivers") + self.assertTrue("QSQLITE" in QSqlDatabase.drivers(), "\"QSQLITE\" driver not available in this Qt version") + self.db = QSqlDatabase.addDatabase("QSQLITE") self.db.setDatabaseName(":memory:") self.assertTrue(self.db.open()) def tearDown(self): - #Release resources + # Release resources self.db.close() - QtSql.QSqlDatabase.removeDatabase(":memory:") + QSqlDatabase.removeDatabase(":memory:") del self.db + # PYSIDE-535: Need to collect garbage in PyPy to trigger deletion + gc.collect() + super().tearDown() def testTableCreationAndDestruction(self): - #Test table creation and destruction - query = QtSql.QSqlQuery() - query.exec_("CREATE TABLE dummy(id int primary key, dummyfield varchar(20))") - query.exec_("DROP TABLE dummy") + # Test table creation and destruction + query = QSqlQuery() + query.exec("CREATE TABLE dummy(id int primary key, dummyfield varchar(20))") + query.exec("DROP TABLE dummy") query.clear() def testTableInsertionAndRetrieval(self): - #Test table creation, insertion and retrieval - query = QtSql.QSqlQuery() - query.exec_("CREATE TABLE person(id int primary key, " + # Test table creation, insertion and retrieval + query = QSqlQuery() + query.exec("CREATE TABLE person(id int primary key, " "firstname varchar(20), lastname varchar(20))") - query.exec_("INSERT INTO person VALUES(101, 'George', 'Harrison')") + query.exec("INSERT INTO person VALUES(101, 'George', 'Harrison')") query.prepare("INSERT INTO person (id, firstname, lastname) " "VALUES (:id, :firstname, :lastname)") query.bindValue(":id", 102) query.bindValue(":firstname", "John") query.bindValue(":lastname", "Lennon") - query.exec_() + query.exec() lastname = '' - query.exec_("SELECT lastname FROM person where id=101") + query.exec("SELECT lastname FROM person where id=101") self.assertTrue(query.isActive()) query.next() lastname = query.value(0) self.assertEqual(lastname, 'Harrison') def testTableModelDeletion(self): - app = QApplication([]) - bar = Foo() model = bar.model del bar - del app + # PYSIDE-535: Need to collect garbage in PyPy to trigger deletion + gc.collect() + if __name__ == '__main__': unittest.main() |