Connecting to the database
A database connection is represented by the PySide.QtSql.QSqlDatabase
class. This class provides an interface to access a database through the connection. The connection is accomplished through Qt's supported database drivers, which are derived from the PySide.QtSql.QSqlDriver
class. The QSqlDriver
class is an abstract base class to access specific SQL Databases and should be used with QSqlDatabase
. As with any other PySide feature that supports customization, it is also possible to create our own SQL drivers by subclassing the QSqlDriver
class and reimplementing its virtual functions.
Before explaining the concept of connecting to databases, we will look at the types of database access that is provided by PySide. The access is provided at two levels, a high-level access using QSqlTableModel
or QSqlRelationalTableModel
, and a low-level access using QSqlQuery
. The former one uses model/view architecture and provides a high-level interface from which to read and write...