QSqlTableModel ¶

概要 ¶

详细描述 ¶

QSqlTableModel is a high-level interface for reading and writing database records from a single table. It is built on top of the lower-level QSqlQuery and can be used to provide data to view classes such as QTableView 。例如：

QSqlTableModel *model = new QSqlTableModel;
model->setTable("employee");
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
model->setHeaderData(0, Qt::Horizontal, tr("Name"));
model->setHeaderData(1, Qt::Horizontal, tr("Salary"));
QTableView *view = new QTableView;
view->setModel(model);
view->hideColumn(0); // don't show the ID
view->show();
											

We set the SQL table’s name and the edit strategy, then we set up the labels displayed in the view header. The edit strategy dictates when the changes done by the user in the view are actually applied to the database. The possible values are OnFieldChange , OnRowChange ，和 OnManualSubmit .

QSqlTableModel can also be used to access a database programmatically, without binding it to a view:

model = QSqlTableModel()
model.setTable("employee")
name = model.record(4).value("name")
											

The code snippet above extracts the salary field from record 4 in the result set of the query SELECT * from employee .

It is possible to set filters using setFilter() , or modify the sort order using setSort() . At the end, you must call select() to populate the model with data.

tablemodel example illustrates how to use QSqlTableModel as the data source for a QTableView .

QSqlTableModel provides no direct support for foreign keys. Use the QSqlRelationalTableModel and QSqlRelationalDelegate if you want to resolve foreign keys.

另请参阅

QSqlRelationalTableModel QSqlQuery 模型/视图编程 表格模型范例 Cached Table Example

class QSqlTableModel ( [ parent=None [ , db=QSqlDatabase() ] ] ) ¶

param parent

QObject

param db

QSqlDatabase

Creates an empty QSqlTableModel and sets the parent to parent and the database connection to db 。若 db is not valid, the default database connection will be used.

The default edit strategy is OnRowChange .

PySide2.QtSql.QSqlTableModel. EditStrategy ¶

This enum type describes which strategy to choose when editing values in the database.

常量	描述
QSqlTableModel.OnFieldChange	All changes to the model will be applied immediately to the database.
QSqlTableModel.OnRowChange	Changes to a row will be applied when the user selects a different row.
QSqlTableModel.OnManualSubmit	All changes will be cached in the model until either submitAll() or revertAll() 被调用。

Note: To prevent inserting only partly initialized rows into the database, OnFieldChange will behave like OnRowChange for newly inserted rows.

另请参阅

setEditStrategy()

PySide2.QtSql.QSqlTableModel. beforeDelete ( row ) ¶

参数

row – int

PySide2.QtSql.QSqlTableModel. beforeInsert ( record ) ¶

参数

record – QSqlRecord

PySide2.QtSql.QSqlTableModel. beforeUpdate ( row , record ) ¶

参数

• row – int

• record – QSqlRecord

PySide2.QtSql.QSqlTableModel. database ( ) ¶

返回类型

QSqlDatabase

Returns the model’s database connection.

PySide2.QtSql.QSqlTableModel. deleteRowFromTable ( row ) ¶

参数

row – int

返回类型

bool

Deletes the given row from the currently active database table.

This is a low-level method that operates directly on the database and should not be called directly. Use removeRow() or removeRows() to delete values. The model will decide depending on its edit strategy when to modify the database.

返回 true if the row was deleted; otherwise returns false .

另请参阅

removeRow() removeRows()

PySide2.QtSql.QSqlTableModel. editStrategy ( ) ¶

返回类型

EditStrategy

Returns the current edit strategy.

另请参阅

setEditStrategy()

PySide2.QtSql.QSqlTableModel. fieldIndex ( fieldName ) ¶

参数

fieldName – unicode

返回类型

int

Returns the index of the field fieldName , or -1 if no corresponding field exists in the model.

PySide2.QtSql.QSqlTableModel. filter ( ) ¶

返回类型

unicode

Returns the currently set filter.

另请参阅

setFilter() select()

PySide2.QtSql.QSqlTableModel. insertRecord ( row , record ) ¶

参数

• row – int

• record – QSqlRecord

返回类型

bool

插入 record 在位置 row 。若 row is negative, the record will be appended to the end. Calls insertRows() and setRecord() internally.

返回 true if the record could be inserted, otherwise false.

Changes are submitted immediately for OnFieldChange and OnRowChange . Failure does not leave a new row in the model.

另请参阅

insertRows() removeRows() setRecord()

PySide2.QtSql.QSqlTableModel. insertRowIntoTable ( values ) ¶

参数

values – QSqlRecord

返回类型

bool

Inserts the values values into the currently active database table.

This is a low-level method that operates directly on the database and should not be called directly. Use insertRow() and setData() to insert values. The model will decide depending on its edit strategy when to modify the database.

返回 true if the values could be inserted, otherwise false. Error information can be retrieved with lastError() .

另请参阅

lastError() insertRow() insertRows()

PySide2.QtSql.QSqlTableModel. isDirty ( ) ¶

返回类型

bool

这是重载函数。

返回 true if the model contains modified values that have not been committed to the database, otherwise false.

PySide2.QtSql.QSqlTableModel. isDirty ( index ) ¶

参数

index – QModelIndex

返回类型

bool

返回 true if the value at the index index is dirty, otherwise false. Dirty values are values that were modified in the model but not yet written into the database.

若 index is invalid or points to a non-existing row, false is returned.

PySide2.QtSql.QSqlTableModel. orderByClause ( ) ¶

返回类型

unicode

Returns an SQL ORDER BY clause based on the currently set sort order.

另请参阅

setSort() selectStatement()

PySide2.QtSql.QSqlTableModel. primaryKey ( ) ¶

返回类型

QSqlIndex

Returns the primary key for the current table, or an empty QSqlIndex if the table is not set or has no primary key.

另请参阅

setTable() setPrimaryKey() primaryIndex()

PySide2.QtSql.QSqlTableModel. primaryValues ( row ) ¶

参数

row – int

返回类型

QSqlRecord

Returns a record containing the fields represented in the primary key set to the values at row . If no primary key is defined, the returned record will contain all fields.

另请参阅

primaryKey()

PySide2.QtSql.QSqlTableModel. primeInsert ( row , record ) ¶

参数

• row – int

• record – QSqlRecord

PySide2.QtSql.QSqlTableModel. revertAll ( ) ¶

Reverts all pending changes.

另请参阅

revert() revertRow() submitAll()

PySide2.QtSql.QSqlTableModel. revertRow ( row ) ¶

参数

row – int

Reverts all changes for the specified row .

另请参阅

revert() revertAll() submit() submitAll()

PySide2.QtSql.QSqlTableModel. select ( ) ¶

返回类型

bool

Populates the model with data from the table that was set via setTable() , using the specified filter and sort condition, and returns true 若成功；否则返回 false .

注意

Calling will revert any unsubmitted changes and remove any inserted columns.

另请参阅

setTable() setFilter() selectStatement()

PySide2.QtSql.QSqlTableModel. selectRow ( row ) ¶

参数

row – int

返回类型

bool

Refreshes row in the model with values from the database table row matching on primary key values. Without a primary key, all column values must match. If no matching row is found, the model will show an empty row.

返回 true 若成功；否则返回 false .

另请参阅

select()

PySide2.QtSql.QSqlTableModel. selectStatement ( ) ¶

返回类型

unicode

Returns the SQL SELECT statement used internally to populate the model. The statement includes the filter and the ORDER BY 子句。

另请参阅

filter() orderByClause()

PySide2.QtSql.QSqlTableModel. setEditStrategy ( strategy ) ¶

参数

strategy – EditStrategy

Sets the strategy for editing values in the database to strategy .

This will revert any pending changes.

另请参阅

editStrategy() revertAll()

PySide2.QtSql.QSqlTableModel. setFilter ( filter ) ¶

参数

filter – unicode

Sets the current filter to filter .

The filter is a SQL WHERE clause without the keyword WHERE (for example, name='Josephine') .

If the model is already populated with data from a database, the model re-selects it with the new filter. Otherwise, the filter will be applied the next time select() 被调用。

另请参阅

filter() select() selectStatement() orderByClause()

PySide2.QtSql.QSqlTableModel. setPrimaryKey ( key ) ¶

参数

key – QSqlIndex

Protected method that allows subclasses to set the primary key to key .

Normally, the primary index is set automatically whenever you call setTable() .

另请参阅

primaryKey() primaryIndex()

PySide2.QtSql.QSqlTableModel. setRecord ( row , record ) ¶

参数

• row – int

• record – QSqlRecord

返回类型

bool

Applies values 到 row in the model. The source and target fields are mapped by field name, not by position in the record.

Note that the generated flags in values are preserved to determine whether the corresponding fields are used when changes are submitted to the database. By default, it is set to true for all fields in a QSqlRecord . You must set the flag to false 使用 setGenerated (false) for any value in values , to save changes back to the database.

For edit strategies OnFieldChange and OnRowChange , a row may receive a change only if no other row has a cached change. Changes are submitted immediately. Submitted changes are not reverted upon failure.

返回 true if all the values could be set; otherwise returns false.

另请参阅

record() editStrategy()

PySide2.QtSql.QSqlTableModel. setSort ( column , order ) ¶

参数

• column – int

• order – SortOrder

Sets the sort order for column to order . This does not affect the current data, to refresh the data using the new sort order, call select() .

另请参阅

sort() select() orderByClause()

PySide2.QtSql.QSqlTableModel. setTable ( tableName ) ¶

参数

tableName – unicode

Sets the database table on which the model operates to tableName . Does not select data from the table, but fetches its field information.

To populate the model with the table’s data, call select() .

Error information can be retrieved with lastError() .

另请参阅

select() setFilter() lastError()

PySide2.QtSql.QSqlTableModel. submitAll ( ) ¶

返回类型

bool

Submits all pending changes and returns true on success. Returns false on error, detailed error information can be obtained with lastError() .

在 OnManualSubmit , on success the model will be repopulated. Any views presenting it will lose their selections.

Note: In OnManualSubmit mode, already submitted changes won’t be cleared from the cache when fails. This allows transactions to be rolled back and resubmitted without losing data.

另请参阅

revertAll() lastError()

PySide2.QtSql.QSqlTableModel. tableName ( ) ¶

返回类型

unicode

Returns the name of the currently selected table.

PySide2.QtSql.QSqlTableModel. updateRowInTable ( row , values ) ¶

参数

• row – int

• values – QSqlRecord

返回类型

bool

Updates the given row in the currently active database table with the specified values 。返回 true 若成功；否则返回 false .

This is a low-level method that operates directly on the database and should not be called directly. Use setData() to update values. The model will decide depending on its edit strategy when to modify the database.

Note that only values that have the generated-flag set are updated. The generated-flag can be set with setGenerated() and tested with isGenerated() .

另请参阅

isGenerated() setData()