Participer au site avec un Tip
Rechercher
 
Bug Suggérer des Améliorations / Corrections
Share Partager sur Facebook Partager sur Twitter
Links Notre chaîne YouTube Notre discord

Améliorations / Corrections

Vous avez des améliorations (ou des corrections) à proposer pour ce document : je vous remerçie par avance de m'en faire part, cela m'aide à améliorer le site.

Emplacement :

Description des améliorations :

Module « PySide6.QtSql »

Classe « QSqlTableModel »

Informations générales

Héritage

builtins.object
    Object
        QObject
            QAbstractItemModel
                QAbstractTableModel
                    QSqlQueryModel
                        QSqlTableModel

Définition

class QSqlTableModel(QSqlQueryModel):

Description [extrait de QSqlTableModel.__doc__]

QSqlTableModel(self, parent: Optional[PySide6.QtCore.QObject] = None, db: PySide6.QtSql.QSqlDatabase = Default(QSqlDatabase)) -> None

Constructeur(s)

Signature du constructeur Description
__new__(*args, **kwargs) Create and return a new object. See help(type) for accurate signature. [extrait de __new__.__doc__]
__init__(self, parent: Optional[PySide6.QtCore.QObject] = None, db: PySide6.QtSql.QSqlDatabase = Default(QSqlDatabase)) -> None __init__(self, parent: Optional[PySide6.QtCore.QObject] = None, db: PySide6.QtSql.QSqlDatabase = Default(QSqlDatabase)) -> None [extrait de __init__.__doc__]

Liste des attributs statiques

Nom de l'attribut Valeur
HorizontalSortHintPySide6.QtCore.QAbstractItemModel.LayoutChangeHint.HorizontalSortHint
NoLayoutChangeHintPySide6.QtCore.QAbstractItemModel.LayoutChangeHint.NoLayoutChangeHint
OnFieldChangePySide6.QtSql.QSqlTableModel.EditStrategy.OnFieldChange
OnManualSubmitPySide6.QtSql.QSqlTableModel.EditStrategy.OnManualSubmit
OnRowChangePySide6.QtSql.QSqlTableModel.EditStrategy.OnRowChange
staticMetaObject<PySide6.QtCore.QMetaObject object at 0x7f40db159b00>
VerticalSortHintPySide6.QtCore.QAbstractItemModel.LayoutChangeHint.VerticalSortHint

Liste des opérateurs

Opérateurs hérités de la classe object

__eq__, __ge__, __gt__, __le__, __lt__, __ne__

Liste des méthodes

Toutes les méthodes Méthodes d'instance Méthodes statiques Méthodes dépréciées
Signature de la méthodeDescription
__delattr__(self, name) Implement delattr(self, name). [extrait de __delattr__.__doc__]
__setattr__(self, name, value) Implement setattr(self, name, value). [extrait de __setattr__.__doc__]
beforeDelete
beforeInsert
beforeUpdate
clear(self) -> None clear(self) -> None [extrait de clear.__doc__]
clearItemData(self, index: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex]) -> bool clearItemData(self, index: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex]) -> bool [extrait de clearItemData.__doc__]
columnsAboutToBeInserted
columnsAboutToBeMoved
columnsAboutToBeRemoved
columnsInserted
columnsMoved
columnsRemoved
data(self, idx: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex], role: int = PySide6.QtCore.Qt.ItemDataRole.DisplayRole) -> Any data(self, idx: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex], role: int = PySide6.QtCore.Qt.ItemDataRole.DisplayRole) -> Any [extrait de data.__doc__]
database(self) -> PySide6.QtSql.QSqlDatabase database(self) -> PySide6.QtSql.QSqlDatabase [extrait de database.__doc__]
dataChanged
deleteRowFromTable(self, row: int) -> bool deleteRowFromTable(self, row: int) -> bool [extrait de deleteRowFromTable.__doc__]
destroyed
EditStrategy
editStrategy(self) -> PySide6.QtSql.QSqlTableModel.EditStrategy editStrategy(self) -> PySide6.QtSql.QSqlTableModel.EditStrategy [extrait de editStrategy.__doc__]
fieldIndex(self, fieldName: str) -> int fieldIndex(self, fieldName: str) -> int [extrait de fieldIndex.__doc__]
filter(self) -> str filter(self) -> str [extrait de filter.__doc__]
flags(self, index: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex]) -> PySide6.QtCore.Qt.ItemFlags flags(self, index: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex]) -> PySide6.QtCore.Qt.ItemFlags [extrait de flags.__doc__]
headerData(self, section: int, orientation: PySide6.QtCore.Qt.Orientation, role: int = PySide6.QtCore.Qt.ItemDataRole.DisplayRole) -> Any headerData(self, section: int, orientation: PySide6.QtCore.Qt.Orientation, role: int = PySide6.QtCore.Qt.ItemDataRole.DisplayRole) -> Any [extrait de headerData.__doc__]
headerDataChanged
indexInQuery(self, item: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex]) -> PySide6.QtCore.QModelIndex indexInQuery(self, item: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex]) -> PySide6.QtCore.QModelIndex [extrait de indexInQuery.__doc__]
insertRecord(self, row: int, record: PySide6.QtSql.QSqlRecord) -> bool insertRecord(self, row: int, record: PySide6.QtSql.QSqlRecord) -> bool [extrait de insertRecord.__doc__]
insertRowIntoTable(self, values: PySide6.QtSql.QSqlRecord) -> bool insertRowIntoTable(self, values: PySide6.QtSql.QSqlRecord) -> bool [extrait de insertRowIntoTable.__doc__]
insertRows(self, row: int, count: int, parent: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex] = Invalid(PySide6.QtCore.QModelIndex)) -> bool insertRows(self, row: int, count: int, parent: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex] = Invalid(PySide6.QtCore.QModelIndex)) -> bool [extrait de insertRows.__doc__]
isDirty isDirty(self) -> bool [extrait de isDirty.__doc__]
layoutAboutToBeChanged
layoutChanged
modelAboutToBeReset
modelReset
objectNameChanged
orderByClause(self) -> str orderByClause(self) -> str [extrait de orderByClause.__doc__]
primaryKey(self) -> PySide6.QtSql.QSqlIndex primaryKey(self) -> PySide6.QtSql.QSqlIndex [extrait de primaryKey.__doc__]
primaryValues(self, row: int) -> PySide6.QtSql.QSqlRecord primaryValues(self, row: int) -> PySide6.QtSql.QSqlRecord [extrait de primaryValues.__doc__]
primeInsert
record record(self) -> PySide6.QtSql.QSqlRecord [extrait de record.__doc__]
removeColumns(self, column: int, count: int, parent: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex] = Invalid(PySide6.QtCore.QModelIndex)) -> bool removeColumns(self, column: int, count: int, parent: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex] = Invalid(PySide6.QtCore.QModelIndex)) -> bool [extrait de removeColumns.__doc__]
removeRows(self, row: int, count: int, parent: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex] = Invalid(PySide6.QtCore.QModelIndex)) -> bool removeRows(self, row: int, count: int, parent: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex] = Invalid(PySide6.QtCore.QModelIndex)) -> bool [extrait de removeRows.__doc__]
revert(self) -> None revert(self) -> None [extrait de revert.__doc__]
revertAll(self) -> None revertAll(self) -> None [extrait de revertAll.__doc__]
revertRow(self, row: int) -> None revertRow(self, row: int) -> None [extrait de revertRow.__doc__]
rowCount(self, parent: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex] = Invalid(PySide6.QtCore.QModelIndex)) -> int rowCount(self, parent: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex] = Invalid(PySide6.QtCore.QModelIndex)) -> int [extrait de rowCount.__doc__]
rowsAboutToBeInserted
rowsAboutToBeMoved
rowsAboutToBeRemoved
rowsInserted
rowsMoved
rowsRemoved
select(self) -> bool select(self) -> bool [extrait de select.__doc__]
selectRow(self, row: int) -> bool selectRow(self, row: int) -> bool [extrait de selectRow.__doc__]
selectStatement(self) -> str selectStatement(self) -> str [extrait de selectStatement.__doc__]
setData(self, index: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex], value: Any, role: int = PySide6.QtCore.Qt.ItemDataRole.EditRole) -> bool setData(self, index: Union[PySide6.QtCore.QModelIndex, PySide6.QtCore.QPersistentModelIndex], value: Any, role: int = PySide6.QtCore.Qt.ItemDataRole.EditRole) -> bool [extrait de setData.__doc__]
setEditStrategy(self, strategy: PySide6.QtSql.QSqlTableModel.EditStrategy) -> None setEditStrategy(self, strategy: PySide6.QtSql.QSqlTableModel.EditStrategy) -> None [extrait de setEditStrategy.__doc__]
setFilter(self, filter: str) -> None setFilter(self, filter: str) -> None [extrait de setFilter.__doc__]
setPrimaryKey(self, key: PySide6.QtSql.QSqlIndex) -> None setPrimaryKey(self, key: PySide6.QtSql.QSqlIndex) -> None [extrait de setPrimaryKey.__doc__]
setQuery(self, query: PySide6.QtSql.QSqlQuery) -> None setQuery(self, query: PySide6.QtSql.QSqlQuery) -> None [extrait de setQuery.__doc__]
setRecord(self, row: int, record: PySide6.QtSql.QSqlRecord) -> bool setRecord(self, row: int, record: PySide6.QtSql.QSqlRecord) -> bool [extrait de setRecord.__doc__]
setSort(self, column: int, order: PySide6.QtCore.Qt.SortOrder) -> None setSort(self, column: int, order: PySide6.QtCore.Qt.SortOrder) -> None [extrait de setSort.__doc__]
setTable(self, tableName: str) -> None setTable(self, tableName: str) -> None [extrait de setTable.__doc__]
sort(self, column: int, order: PySide6.QtCore.Qt.SortOrder) -> None sort(self, column: int, order: PySide6.QtCore.Qt.SortOrder) -> None [extrait de sort.__doc__]
submit(self) -> bool submit(self) -> bool [extrait de submit.__doc__]
submitAll(self) -> bool submitAll(self) -> bool [extrait de submitAll.__doc__]
tableName(self) -> str tableName(self) -> str [extrait de tableName.__doc__]
tr
updateRowInTable(self, row: int, values: PySide6.QtSql.QSqlRecord) -> bool updateRowInTable(self, row: int, values: PySide6.QtSql.QSqlRecord) -> bool [extrait de updateRowInTable.__doc__]

Méthodes héritées de la classe QSqlQueryModel

__init_subclass__, __subclasshook__, beginInsertColumns, beginInsertRows, beginRemoveColumns, beginRemoveRows, beginResetModel, canFetchMore, columnCount, endInsertColumns, endInsertRows, endRemoveColumns, endRemoveRows, endResetModel, fetchMore, insertColumns, lastError, query, queryChange, roleNames, setHeaderData, setLastError

Méthodes héritées de la classe QAbstractTableModel

__init_subclass__, __subclasshook__, dropMimeData, hasChildren, index, parent, sibling

Méthodes héritées de la classe QAbstractItemModel

__init_subclass__, __subclasshook__, beginInsertColumns, beginInsertRows, beginMoveColumns, beginMoveRows, beginRemoveColumns, beginRemoveRows, beginResetModel, buddy, canDropMimeData, canFetchMore, changePersistentIndex, changePersistentIndexList, checkIndex, CheckIndexOption, CheckIndexOptions, columnCount, createIndex, decodeData, dropMimeData, encodeData, endInsertColumns, endInsertRows, endMoveColumns, endMoveRows, endRemoveColumns, endRemoveRows, endResetModel, fetchMore, hasChildren, hasIndex, index, insertColumn, insertColumns, insertRow, itemData, LayoutChangeHint, match, mimeData, mimeTypes, moveColumn, moveColumns, moveRow, moveRows, parent, persistentIndexList, removeColumn, removeRow, resetInternalData, roleNames, setHeaderData, setItemData, sibling, span, supportedDragActions, supportedDropActions

Méthodes héritées de la classe QObject

__getattribute__, __init_subclass__, __repr__, __subclasshook__, blockSignals, childEvent, children, connect, connectNotify, customEvent, deleteLater, disconnect, disconnectNotify, dumpObjectInfo, dumpObjectTree, dynamicPropertyNames, emit, event, eventFilter, findChild, findChildren, inherits, installEventFilter, isSignalConnected, isWidgetType, isWindowType, killTimer, metaObject, moveToThread, objectName, parent, property, receivers, removeEventFilter, sender, senderSignalIndex, setObjectName, setParent, setProperty, signalsBlocked, startTimer, thread, timerEvent

Méthodes héritées de la classe Object

__getattribute__, __init_subclass__, __subclasshook__

Méthodes héritées de la classe object

__dir__, __format__, __hash__, __reduce__, __reduce_ex__, __repr__, __sizeof__, __str__




Le tutoriel Python complet (Text+Vidéos)
Le tutoriel Python en vidéos
Evaluez vos compétences en Python