-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Pyside GUI Application Development- Second Edition - Second Edition
By :
This section is devoted to explaining the representation of data in a form view or a table view. But, before that, we can look at some examples of accessing databases through high-level model classes. The following classes are available in Qt for this purpose.
QSqlQueryModel: This provides a read-only data model for SQL result sets
QSqlTableModel: This provides an editable data model for a single database table
QSqlRelationalTableModel: This provides an editable data model for a single database table with foreign key support
Let's view some quick examples of each of these classes.
This model aims at providing a high-level interface to execute SQL queries and traverse the result set. This class is built on top of the QSqlQuery class and can be used to provide data to view classes, such as QTableView, which we are going to discuss in the forthcoming sections. A sample program using QSqlQueryModel is given as follows:
model = QSqlQueryModel() model.setQuery(...
Change the font size
Change margin width
Change background colour