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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
#!/bin/env python
############################################################################
##
## Copyright (C) 2004-2005 Trolltech AS. All rights reserved.
##
## This file is part of the example classes of the Qt Toolkit.
##
## This file may be used under the terms of the GNU General Public
## License version 2.0 as published by the Free Software Foundation
## and appearing in the file LICENSE.GPL included in the packaging of
## this file. Please review the following information to ensure GNU
## General Public Licensing requirements will be met:
## http://www.trolltech.com/products/qt/opensource.html
##
## If you are unsure which license is appropriate for your use, please
## review the following information:
## http://www.trolltech.com/products/qt/licensing.html or contact the
## sales department at sales@trolltech.com.
##
## This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE
## WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
##
############################################################################
import sys
from PyQt4 import QtCore, QtGui, QtSql
import connection
class CustomSqlModel(QtSql.QSqlQueryModel):
def data(self, index, role):
value = QtSql.QSqlQueryModel.data(self, index, role)
if value.isValid() and role == QtCore.Qt.DisplayRole:
if index.column() == 0:
return QtCore.QVariant(value.toString().prepend("#"))
elif index.column() == 2:
return QtCore.QVariant(value.toString().toUpper())
if role == QtCore.Qt.TextColorRole and index.column() == 1:
return QtCore.QVariant(QtGui.QColor(QtCore.Qt.blue))
return value
class EditableSqlModel(QtSql.QSqlQueryModel):
def flags(self, index):
flags = QtSql.QSqlQueryModel.flags(self, index)
if index.column() == 1 or index.column() == 2:
flags |= QtCore.Qt.ItemIsEditable
return flags
def setData(self, index, value, role):
if index.column() < 1 or index.column() > 2:
return False
primaryKeyIndex = QtSql.QSqlQueryModel.index(self, index.row(), 0)
id = self.data(primaryKeyIndex).toInt()[0]
self.clear()
if index.column() == 1:
ok = self.setFirstName(id, value.toString())
else:
ok = self.setLastName(id, value.toString())
self.refresh()
return ok
def refresh(self):
self.setQuery("select * from person")
self.setHeaderData(0, QtCore.Qt.Horizontal,
QtCore.QVariant(QtCore.QObject.tr(self, "ID")))
self.setHeaderData(1, QtCore.Qt.Horizontal,
QtCore.QVariant(QtCore.QObject.tr(self, "First name")))
self.setHeaderData(2, QtCore.Qt.Horizontal,
QtCore.QVariant(QtCore.QObject.tr(self, "Last name")))
def setFirstName(self, personId, firstName):
query = QtSql.QSqlQuery()
query.prepare("update person set firstname = ? where id = ?")
query.addBindValue(QtCore.QVariant(firstName))
query.addBindValue(QtCore.QVariant(personId))
return query.exec_()
def setLastName(self, personId, lastName):
query = QtSql.QSqlQuery()
query.prepare("update person set lastname = ? where id = ?")
query.addBindValue(QtCore.QVariant(lastName))
query.addBindValue(QtCore.QVariant(personId))
return query.exec_()
def initializeModel(model):
model.setQuery("select * from person")
model.setHeaderData(0, QtCore.Qt.Horizontal,
QtCore.QVariant(QtCore.QObject.tr(model, "ID")))
model.setHeaderData(1, QtCore.Qt.Horizontal,
QtCore.QVariant(QtCore.QObject.tr(model, "First name")))
model.setHeaderData(2, QtCore.Qt.Horizontal,
QtCore.QVariant(QtCore.QObject.tr(model, "Last name")))
offset = 0
views = []
def createView(title, model):
global offset, views
view = QtGui.QTableView()
views.append(view)
view.setModel(model)
view.setWindowTitle(title)
view.move(100 + offset, 100 + offset)
offset += 20
view.show()
if __name__ == "__main__":
app = QtGui.QApplication(sys.argv)
if not connection.createConnection():
sys.exit(1)
plainModel = QtSql.QSqlQueryModel()
editableModel = EditableSqlModel()
customModel = CustomSqlModel()
initializeModel(plainModel)
initializeModel(editableModel)
initializeModel(customModel)
createView(QtCore.QObject.tr(plainModel, "Plain Query Model"), plainModel)
createView(QtCore.QObject.tr(editableModel, "Editable Query Model"), editableModel)
createView(QtCore.QObject.tr(customModel, "Custom Query Model"), customModel)
sys.exit(app.exec_())
|
