1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
# Copyright (C) 2022 The Qt Company Ltd.
# SPDX-License-Identifier: LicenseRef-Qt-Commercial OR BSD-3-Clause
"""PySide6 port of the relationaltablemodel example from Qt v6.x"""
import sys
import connection
from PySide6.QtCore import QObject, Qt
from PySide6.QtSql import (QSqlQuery, QSqlRelation, QSqlRelationalDelegate,
QSqlRelationalTableModel)
from PySide6.QtWidgets import QApplication, QTableView
def initializeModel(model):
model.setTable("employee")
model.setEditStrategy(QSqlRelationalTableModel.OnManualSubmit)
model.setRelation(2, QSqlRelation("city", "id", "name"))
model.setRelation(3, QSqlRelation("country", "id", "name"))
model.setHeaderData(0, Qt.Horizontal, QObject().tr("ID"))
model.setHeaderData(1, Qt.Horizontal, QObject().tr("Name"))
model.setHeaderData(2, Qt.Horizontal, QObject().tr("City"))
model.setHeaderData(3, Qt.Horizontal, QObject().tr("Country"))
model.select()
def createView(title, model):
table_view = QTableView()
table_view.setModel(model)
table_view.setItemDelegate(QSqlRelationalDelegate(table_view))
table_view.setWindowTitle(title)
return table_view
def createRelationalTables():
query = QSqlQuery()
query.exec("create table employee(id int primary key, name varchar(20), city int, country int)")
query.exec("insert into employee values(1, 'Espen', 5000, 47)")
query.exec("insert into employee values(2, 'Harald', 80000, 49)")
query.exec("insert into employee values(3, 'Sam', 100, 1)")
query.exec("create table city(id int, name varchar(20))")
query.exec("insert into city values(100, 'San Jose')")
query.exec("insert into city values(5000, 'Oslo')")
query.exec("insert into city values(80000, 'Munich')")
query.exec("create table country(id int, name varchar(20))")
query.exec("insert into country values(1, 'USA')")
query.exec("insert into country values(47, 'Norway')")
query.exec("insert into country values(49, 'Germany')")
if __name__ == "__main__":
app = QApplication(sys.argv)
connection.createConnection()
createRelationalTables()
model = QSqlRelationalTableModel()
initializeModel(model)
title = "Relational Table Model"
window = createView(title, model)
window.resize(600, 200)
window.show()
sys.exit(app.exec())
|
