| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660 |
- # The PEP 484 type hints stub file for the QtSql module.
- #
- # Generated by SIP 6.15.3
- #
- # Copyright (c) 2026 Riverbank Computing Limited <info@riverbankcomputing.com>
- #
- # This file is part of PyQt6.
- #
- # This file may be used under the terms of the GNU General Public License
- # version 3.0 as published by the Free Software Foundation and appearing in
- # the file LICENSE included in the packaging of this file. Please review the
- # following information to ensure the GNU General Public License version 3.0
- # requirements will be met: http://www.gnu.org/copyleft/gpl.html.
- #
- # If you do not wish to use this file under the terms of the GPL version 3.0
- # then you may purchase a commercial license. For more information contact
- # info@riverbankcomputing.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 collections, re, typing, enum
- try:
- from warnings import deprecated
- except ImportError:
- pass
- import PyQt6.sip
- from PyQt6 import QtCore
- from PyQt6 import QtGui
- from PyQt6 import QtWidgets
- # Support for QDate, QDateTime and QTime.
- import datetime
- # Convenient type aliases.
- PYQT_SIGNAL = typing.Union[QtCore.pyqtSignal, QtCore.pyqtBoundSignal]
- PYQT_SLOT = typing.Union[collections.abc.Callable[..., Any], QtCore.pyqtBoundSignal]
- class QSqlDriverCreatorBase(PyQt6.sip.wrapper):
- @typing.overload
- def __init__(self) -> None: ...
- @typing.overload
- def __init__(self, a0: 'QSqlDriverCreatorBase') -> None: ...
- def createObject(self) -> 'QSqlDriver|None': ...
- class QSqlDatabase(PyQt6.sip.simplewrapper):
- @typing.overload
- def __init__(self) -> None: ...
- @typing.overload
- def __init__(self, other: 'QSqlDatabase') -> None: ...
- @typing.overload
- def __init__(self, type: str|None) -> None: ...
- @typing.overload
- def __init__(self, driver: 'QSqlDriver|None') -> None: ...
- def thread(self) -> QtCore.QThread|None: ...
- def moveToThread(self, targetThread: QtCore.QThread|None) -> bool: ...
- def numericalPrecisionPolicy(self) -> 'QSql.NumericalPrecisionPolicy': ...
- def setNumericalPrecisionPolicy(self, precisionPolicy: 'QSql.NumericalPrecisionPolicy') -> None: ...
- @staticmethod
- def isDriverAvailable(name: str|None) -> bool: ...
- @staticmethod
- def registerSqlDriver(name: str|None, creator: QSqlDriverCreatorBase|None) -> None: ...
- @staticmethod
- def connectionNames() -> list[str]: ...
- @staticmethod
- def drivers() -> list[str]: ...
- @staticmethod
- def contains(connectionName: str|None = ...) -> bool: ...
- @staticmethod
- def removeDatabase(connectionName: str|None) -> None: ...
- @staticmethod
- def database(connectionName: str|None = ..., open: bool = ...) -> 'QSqlDatabase': ...
- @typing.overload
- @staticmethod
- def cloneDatabase(other: 'QSqlDatabase', connectionName: str|None) -> 'QSqlDatabase': ...
- @typing.overload
- @staticmethod
- def cloneDatabase(other: str|None, connectionName: str|None) -> 'QSqlDatabase': ...
- @typing.overload
- @staticmethod
- def addDatabase(type: str|None, connectionName: str|None = ...) -> 'QSqlDatabase': ...
- @typing.overload
- @staticmethod
- def addDatabase(driver: 'QSqlDriver|None', connectionName: str|None = ...) -> 'QSqlDatabase': ...
- def driver(self) -> 'QSqlDriver|None': ...
- def connectionName(self) -> str: ...
- def connectOptions(self) -> str: ...
- def port(self) -> int: ...
- def driverName(self) -> str: ...
- def hostName(self) -> str: ...
- def password(self) -> str: ...
- def userName(self) -> str: ...
- def databaseName(self) -> str: ...
- def setConnectOptions(self, options: str|None = ...) -> None: ...
- def setPort(self, p: int) -> None: ...
- def setHostName(self, host: str|None) -> None: ...
- def setPassword(self, password: str|None) -> None: ...
- def setUserName(self, name: str|None) -> None: ...
- def setDatabaseName(self, name: str|None) -> None: ...
- def rollback(self) -> bool: ...
- def commit(self) -> bool: ...
- def transaction(self) -> bool: ...
- def isValid(self) -> bool: ...
- def lastError(self) -> 'QSqlError': ...
- def exec(self, query: str|None = ...) -> 'QSqlQuery': ...
- def record(self, tablename: str|None) -> 'QSqlRecord': ...
- def primaryIndex(self, tablename: str|None) -> 'QSqlIndex': ...
- def tables(self, type: 'QSql.TableType' = ...) -> list[str]: ...
- def isOpenError(self) -> bool: ...
- def isOpen(self) -> bool: ...
- def close(self) -> None: ...
- @typing.overload
- def open(self) -> bool: ...
- @typing.overload
- def open(self, user: str|None, password: str|None) -> bool: ...
- class QSqlDriver(QtCore.QObject):
- class DbmsType(enum.Enum):
- UnknownDbms = ... # type: QSqlDriver.DbmsType
- MSSqlServer = ... # type: QSqlDriver.DbmsType
- MySqlServer = ... # type: QSqlDriver.DbmsType
- PostgreSQL = ... # type: QSqlDriver.DbmsType
- Oracle = ... # type: QSqlDriver.DbmsType
- Sybase = ... # type: QSqlDriver.DbmsType
- SQLite = ... # type: QSqlDriver.DbmsType
- Interbase = ... # type: QSqlDriver.DbmsType
- DB2 = ... # type: QSqlDriver.DbmsType
- MimerSQL = ... # type: QSqlDriver.DbmsType
- class NotificationSource(enum.Enum):
- UnknownSource = ... # type: QSqlDriver.NotificationSource
- SelfSource = ... # type: QSqlDriver.NotificationSource
- OtherSource = ... # type: QSqlDriver.NotificationSource
- class IdentifierType(enum.Enum):
- FieldName = ... # type: QSqlDriver.IdentifierType
- TableName = ... # type: QSqlDriver.IdentifierType
- class StatementType(enum.Enum):
- WhereStatement = ... # type: QSqlDriver.StatementType
- SelectStatement = ... # type: QSqlDriver.StatementType
- UpdateStatement = ... # type: QSqlDriver.StatementType
- InsertStatement = ... # type: QSqlDriver.StatementType
- DeleteStatement = ... # type: QSqlDriver.StatementType
- class DriverFeature(enum.Enum):
- Transactions = ... # type: QSqlDriver.DriverFeature
- QuerySize = ... # type: QSqlDriver.DriverFeature
- BLOB = ... # type: QSqlDriver.DriverFeature
- Unicode = ... # type: QSqlDriver.DriverFeature
- PreparedQueries = ... # type: QSqlDriver.DriverFeature
- NamedPlaceholders = ... # type: QSqlDriver.DriverFeature
- PositionalPlaceholders = ... # type: QSqlDriver.DriverFeature
- LastInsertId = ... # type: QSqlDriver.DriverFeature
- BatchOperations = ... # type: QSqlDriver.DriverFeature
- SimpleLocking = ... # type: QSqlDriver.DriverFeature
- LowPrecisionNumbers = ... # type: QSqlDriver.DriverFeature
- EventNotifications = ... # type: QSqlDriver.DriverFeature
- FinishQuery = ... # type: QSqlDriver.DriverFeature
- MultipleResultSets = ... # type: QSqlDriver.DriverFeature
- def __init__(self, parent: QtCore.QObject|None = ...) -> None: ...
- def connectionName(self) -> str: ...
- def maximumIdentifierLength(self, type: 'QSqlDriver.IdentifierType') -> int: ...
- def dbmsType(self) -> 'QSqlDriver.DbmsType': ...
- def numericalPrecisionPolicy(self) -> 'QSql.NumericalPrecisionPolicy': ...
- def setNumericalPrecisionPolicy(self, precisionPolicy: 'QSql.NumericalPrecisionPolicy') -> None: ...
- def stripDelimiters(self, identifier: str|None, type: 'QSqlDriver.IdentifierType') -> str: ...
- def isIdentifierEscaped(self, identifier: str|None, type: 'QSqlDriver.IdentifierType') -> bool: ...
- notification: typing.ClassVar[QtCore.pyqtSignal]
- def subscribedToNotifications(self) -> list[str]: ...
- def unsubscribeFromNotification(self, name: str|None) -> bool: ...
- def subscribeToNotification(self, name: str|None) -> bool: ...
- def setLastError(self, e: 'QSqlError') -> None: ...
- def setOpenError(self, e: bool) -> None: ...
- def setOpen(self, o: bool) -> None: ...
- def open(self, db: str|None, user: str|None = ..., password: str|None = ..., host: str|None = ..., port: int = ..., options: str|None = ...) -> bool: ...
- def createResult(self) -> 'QSqlResult|None': ...
- def close(self) -> None: ...
- def hasFeature(self, f: 'QSqlDriver.DriverFeature') -> bool: ...
- def handle(self) -> typing.Any: ...
- def lastError(self) -> 'QSqlError': ...
- def sqlStatement(self, type: 'QSqlDriver.StatementType', tableName: str|None, rec: 'QSqlRecord', preparedStatement: bool) -> str: ...
- def escapeIdentifier(self, identifier: str|None, type: 'QSqlDriver.IdentifierType') -> str: ...
- def formatValue(self, field: 'QSqlField', trimStrings: bool = ...) -> str: ...
- def record(self, tableName: str|None) -> 'QSqlRecord': ...
- def primaryIndex(self, tableName: str|None) -> 'QSqlIndex': ...
- def tables(self, tableType: 'QSql.TableType') -> list[str]: ...
- def rollbackTransaction(self) -> bool: ...
- def commitTransaction(self) -> bool: ...
- def beginTransaction(self) -> bool: ...
- def isOpenError(self) -> bool: ...
- def isOpen(self) -> bool: ...
- class QSqlError(PyQt6.sip.simplewrapper):
- class ErrorType(enum.Enum):
- NoError = ... # type: QSqlError.ErrorType
- ConnectionError = ... # type: QSqlError.ErrorType
- StatementError = ... # type: QSqlError.ErrorType
- TransactionError = ... # type: QSqlError.ErrorType
- UnknownError = ... # type: QSqlError.ErrorType
- @typing.overload
- def __init__(self, driverText: str|None = ..., databaseText: str|None = ..., type: 'QSqlError.ErrorType' = ..., errorCode: str|None = ...) -> None: ...
- @typing.overload
- def __init__(self, other: 'QSqlError') -> None: ...
- def swap(self, other: 'QSqlError') -> None: ...
- def nativeErrorCode(self) -> str: ...
- def __ne__(self, other: object): ...
- def __eq__(self, other: object): ...
- def isValid(self) -> bool: ...
- def text(self) -> str: ...
- def type(self) -> 'QSqlError.ErrorType': ...
- def databaseText(self) -> str: ...
- def driverText(self) -> str: ...
- class QSqlField(PyQt6.sip.simplewrapper):
- class RequiredStatus(enum.Enum):
- Unknown = ... # type: QSqlField.RequiredStatus
- Optional = ... # type: QSqlField.RequiredStatus
- Required = ... # type: QSqlField.RequiredStatus
- @typing.overload
- def __init__(self, fieldName: str|None = ..., type: QtCore.QMetaType = ..., tableName: str|None = ...) -> None: ...
- @typing.overload
- def __init__(self, other: 'QSqlField') -> None: ...
- def swap(self, other: 'QSqlField') -> None: ...
- def setMetaType(self, type: QtCore.QMetaType) -> None: ...
- def metaType(self) -> QtCore.QMetaType: ...
- def tableName(self) -> str: ...
- def setTableName(self, tableName: str|None) -> None: ...
- def isValid(self) -> bool: ...
- def isGenerated(self) -> bool: ...
- def typeID(self) -> int: ...
- def defaultValue(self) -> typing.Any: ...
- def precision(self) -> int: ...
- def length(self) -> int: ...
- def requiredStatus(self) -> 'QSqlField.RequiredStatus': ...
- def setAutoValue(self, autoVal: bool) -> None: ...
- def setGenerated(self, gen: bool) -> None: ...
- def setSqlType(self, type: int) -> None: ...
- def setDefaultValue(self, value: typing.Any) -> None: ...
- def setPrecision(self, precision: int) -> None: ...
- def setLength(self, fieldLength: int) -> None: ...
- def setRequired(self, required: bool) -> None: ...
- def setRequiredStatus(self, status: 'QSqlField.RequiredStatus') -> None: ...
- def isAutoValue(self) -> bool: ...
- def clear(self) -> None: ...
- def isReadOnly(self) -> bool: ...
- def setReadOnly(self, readOnly: bool) -> None: ...
- def isNull(self) -> bool: ...
- def name(self) -> str: ...
- def setName(self, name: str|None) -> None: ...
- def value(self) -> typing.Any: ...
- def setValue(self, value: typing.Any) -> None: ...
- def __ne__(self, other: object): ...
- def __eq__(self, other: object): ...
- class QSqlRecord(PyQt6.sip.simplewrapper):
- @typing.overload
- def __init__(self) -> None: ...
- @typing.overload
- def __init__(self, other: 'QSqlRecord') -> None: ...
- def swap(self, other: 'QSqlRecord') -> None: ...
- def keyValues(self, keyFields: 'QSqlRecord') -> 'QSqlRecord': ...
- def __len__(self) -> int: ...
- def count(self) -> int: ...
- def clearValues(self) -> None: ...
- def clear(self) -> None: ...
- def contains(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> bool: ...
- def isEmpty(self) -> bool: ...
- def remove(self, pos: int) -> None: ...
- def insert(self, pos: int, field: QSqlField) -> None: ...
- def replace(self, pos: int, field: QSqlField) -> None: ...
- def append(self, field: QSqlField) -> None: ...
- @typing.overload
- def setGenerated(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None, generated: bool) -> None: ...
- @typing.overload
- def setGenerated(self, i: int, generated: bool) -> None: ...
- @typing.overload
- def isGenerated(self, i: int) -> bool: ...
- @typing.overload
- def isGenerated(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> bool: ...
- @typing.overload
- def field(self, i: int) -> QSqlField: ...
- @typing.overload
- def field(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> QSqlField: ...
- def fieldName(self, i: int) -> str: ...
- def indexOf(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> int: ...
- @typing.overload
- def isNull(self, i: int) -> bool: ...
- @typing.overload
- def isNull(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> bool: ...
- @typing.overload
- def setNull(self, i: int) -> None: ...
- @typing.overload
- def setNull(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> None: ...
- @typing.overload
- def setValue(self, i: int, val: typing.Any) -> None: ...
- @typing.overload
- def setValue(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None, val: typing.Any) -> None: ...
- @typing.overload
- def value(self, i: int) -> typing.Any: ...
- @typing.overload
- def value(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> typing.Any: ...
- def __ne__(self, other: object): ...
- def __eq__(self, other: object): ...
- class QSqlIndex(QSqlRecord):
- @typing.overload
- def __init__(self, cursorName: str|None = ..., name: str|None = ...) -> None: ...
- @typing.overload
- def __init__(self, other: 'QSqlIndex') -> None: ...
- def swap(self, other: 'QSqlIndex') -> None: ...
- def setDescending(self, i: int, desc: bool) -> None: ...
- def isDescending(self, i: int) -> bool: ...
- @typing.overload
- def append(self, field: QSqlField) -> None: ...
- @typing.overload
- def append(self, field: QSqlField, desc: bool) -> None: ...
- def name(self) -> str: ...
- def setName(self, name: str|None) -> None: ...
- def cursorName(self) -> str: ...
- def setCursorName(self, cursorName: str|None) -> None: ...
- class QSqlQuery(PyQt6.sip.simplewrapper):
- class BatchExecutionMode(enum.Enum):
- ValuesAsRows = ... # type: QSqlQuery.BatchExecutionMode
- ValuesAsColumns = ... # type: QSqlQuery.BatchExecutionMode
- @typing.overload
- def __init__(self, db: QSqlDatabase) -> None: ...
- @typing.overload
- def __init__(self, query: str|None = ..., db: QSqlDatabase = ...) -> None: ...
- @typing.overload
- def __init__(self, r: 'QSqlResult|None') -> None: ...
- @typing.overload
- def __init__(self, other: 'QSqlQuery') -> None: ...
- def isPositionalBindingEnabled(self) -> bool: ...
- def setPositionalBindingEnabled(self, enable: bool) -> None: ...
- def boundValueName(self, pos: int) -> str: ...
- def boundValueNames(self) -> list[str]: ...
- def swap(self, other: 'QSqlQuery') -> None: ...
- def nextResult(self) -> bool: ...
- def finish(self) -> None: ...
- def numericalPrecisionPolicy(self) -> 'QSql.NumericalPrecisionPolicy': ...
- def setNumericalPrecisionPolicy(self, precisionPolicy: 'QSql.NumericalPrecisionPolicy') -> None: ...
- def lastInsertId(self) -> typing.Any: ...
- def executedQuery(self) -> str: ...
- def boundValues(self) -> list[typing.Any]: ...
- @typing.overload
- def boundValue(self, placeholder: str|None) -> typing.Any: ...
- @typing.overload
- def boundValue(self, pos: int) -> typing.Any: ...
- def addBindValue(self, val: typing.Any, type: 'QSql.ParamTypeFlag' = ...) -> None: ...
- @typing.overload
- def bindValue(self, placeholder: str|None, val: typing.Any, type: 'QSql.ParamTypeFlag' = ...) -> None: ...
- @typing.overload
- def bindValue(self, pos: int, val: typing.Any, type: 'QSql.ParamTypeFlag' = ...) -> None: ...
- def prepare(self, query: str|None) -> bool: ...
- def execBatch(self, mode: 'QSqlQuery.BatchExecutionMode' = ...) -> bool: ...
- def clear(self) -> None: ...
- def last(self) -> bool: ...
- def first(self) -> bool: ...
- def previous(self) -> bool: ...
- def next(self) -> bool: ...
- def seek(self, index: int, relative: bool = ...) -> bool: ...
- @typing.overload
- def value(self, i: int) -> typing.Any: ...
- @typing.overload
- def value(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> typing.Any: ...
- @typing.overload
- def exec(self, query: str|None) -> bool: ...
- @typing.overload
- def exec(self) -> bool: ...
- def setForwardOnly(self, forward: bool) -> None: ...
- def record(self) -> QSqlRecord: ...
- def isForwardOnly(self) -> bool: ...
- def result(self) -> 'QSqlResult|None': ...
- def driver(self) -> QSqlDriver|None: ...
- def size(self) -> int: ...
- def isSelect(self) -> bool: ...
- def lastError(self) -> QSqlError: ...
- def numRowsAffected(self) -> int: ...
- def lastQuery(self) -> str: ...
- def at(self) -> int: ...
- @typing.overload
- def isNull(self, field: int) -> bool: ...
- @typing.overload
- def isNull(self, name: QtCore.QByteArray|bytes|bytearray|memoryview|str|None) -> bool: ...
- def isActive(self) -> bool: ...
- def isValid(self) -> bool: ...
- class QSqlQueryModel(QtCore.QAbstractTableModel):
- def __init__(self, parent: QtCore.QObject|None = ...) -> None: ...
- def refresh(self) -> None: ...
- def roleNames(self) -> dict[int, QtCore.QByteArray]: ...
- def endRemoveColumns(self) -> None: ...
- def beginRemoveColumns(self, parent: QtCore.QModelIndex, first: int, last: int) -> None: ...
- def endInsertColumns(self) -> None: ...
- def beginInsertColumns(self, parent: QtCore.QModelIndex, first: int, last: int) -> None: ...
- def endRemoveRows(self) -> None: ...
- def beginRemoveRows(self, parent: QtCore.QModelIndex, first: int, last: int) -> None: ...
- def endInsertRows(self) -> None: ...
- def beginInsertRows(self, parent: QtCore.QModelIndex, first: int, last: int) -> None: ...
- def endResetModel(self) -> None: ...
- def beginResetModel(self) -> None: ...
- def setLastError(self, error: QSqlError) -> None: ...
- def indexInQuery(self, item: QtCore.QModelIndex) -> QtCore.QModelIndex: ...
- def queryChange(self) -> None: ...
- def canFetchMore(self, parent: QtCore.QModelIndex = ...) -> bool: ...
- def fetchMore(self, parent: QtCore.QModelIndex = ...) -> None: ...
- def lastError(self) -> QSqlError: ...
- def clear(self) -> None: ...
- def query(self) -> QSqlQuery: ...
- @typing.overload
- def setQuery(self, query: QSqlQuery) -> None: ...
- @typing.overload
- def setQuery(self, query: str|None, db: QSqlDatabase = ...) -> None: ...
- def removeColumns(self, column: int, count: int, parent: QtCore.QModelIndex = ...) -> bool: ...
- def insertColumns(self, column: int, count: int, parent: QtCore.QModelIndex = ...) -> bool: ...
- def setHeaderData(self, section: int, orientation: QtCore.Qt.Orientation, value: typing.Any, role: int = ...) -> bool: ...
- def headerData(self, section: int, orientation: QtCore.Qt.Orientation, role: int = ...) -> typing.Any: ...
- def data(self, item: QtCore.QModelIndex, role: int = ...) -> typing.Any: ...
- @typing.overload
- def record(self) -> QSqlRecord: ...
- @typing.overload
- def record(self, row: int) -> QSqlRecord: ...
- def columnCount(self, parent: QtCore.QModelIndex = ...) -> int: ...
- def rowCount(self, parent: QtCore.QModelIndex = ...) -> int: ...
- class QSqlRelationalDelegate(QtWidgets.QStyledItemDelegate):
- def __init__(self, parent: QtCore.QObject|None = ...) -> None: ...
- def setModelData(self, editor: QtWidgets.QWidget|None, model: QtCore.QAbstractItemModel|None, index: QtCore.QModelIndex) -> None: ...
- def setEditorData(self, editor: QtWidgets.QWidget|None, index: QtCore.QModelIndex) -> None: ...
- def createEditor(self, parent: QtWidgets.QWidget|None, option: QtWidgets.QStyleOptionViewItem, index: QtCore.QModelIndex) -> QtWidgets.QWidget|None: ...
- class QSqlRelation(PyQt6.sip.simplewrapper):
- @typing.overload
- def __init__(self) -> None: ...
- @typing.overload
- def __init__(self, aTableName: str|None, indexCol: str|None, displayCol: str|None) -> None: ...
- @typing.overload
- def __init__(self, a0: 'QSqlRelation') -> None: ...
- def swap(self, other: 'QSqlRelation') -> None: ...
- def isValid(self) -> bool: ...
- def displayColumn(self) -> str: ...
- def indexColumn(self) -> str: ...
- def tableName(self) -> str: ...
- class QSqlTableModel(QSqlQueryModel):
- class EditStrategy(enum.Enum):
- OnFieldChange = ... # type: QSqlTableModel.EditStrategy
- OnRowChange = ... # type: QSqlTableModel.EditStrategy
- OnManualSubmit = ... # type: QSqlTableModel.EditStrategy
- def __init__(self, parent: QtCore.QObject|None = ..., db: QSqlDatabase = ...) -> None: ...
- def clearItemData(self, index: QtCore.QModelIndex) -> bool: ...
- @typing.overload
- def record(self) -> QSqlRecord: ...
- @typing.overload
- def record(self, row: int) -> QSqlRecord: ...
- def selectRow(self, row: int) -> bool: ...
- def primaryValues(self, row: int) -> QSqlRecord: ...
- def indexInQuery(self, item: QtCore.QModelIndex) -> QtCore.QModelIndex: ...
- def setPrimaryKey(self, key: QSqlIndex) -> None: ...
- def selectStatement(self) -> str: ...
- def orderByClause(self) -> str: ...
- def deleteRowFromTable(self, row: int) -> bool: ...
- def insertRowIntoTable(self, values: QSqlRecord) -> bool: ...
- def updateRowInTable(self, row: int, values: QSqlRecord) -> bool: ...
- beforeDelete: typing.ClassVar[QtCore.pyqtSignal]
- beforeUpdate: typing.ClassVar[QtCore.pyqtSignal]
- beforeInsert: typing.ClassVar[QtCore.pyqtSignal]
- primeInsert: typing.ClassVar[QtCore.pyqtSignal]
- def revertAll(self) -> None: ...
- def submitAll(self) -> bool: ...
- def revert(self) -> None: ...
- def submit(self) -> bool: ...
- def revertRow(self, row: int) -> None: ...
- def setRecord(self, row: int, record: QSqlRecord) -> bool: ...
- def insertRecord(self, row: int, record: QSqlRecord) -> bool: ...
- def insertRows(self, row: int, count: int, parent: QtCore.QModelIndex = ...) -> bool: ...
- def removeRows(self, row: int, count: int, parent: QtCore.QModelIndex = ...) -> bool: ...
- def removeColumns(self, column: int, count: int, parent: QtCore.QModelIndex = ...) -> bool: ...
- def rowCount(self, parent: QtCore.QModelIndex = ...) -> int: ...
- def setFilter(self, filter: str|None) -> None: ...
- def filter(self) -> str: ...
- def setSort(self, column: int, order: QtCore.Qt.SortOrder) -> None: ...
- def sort(self, column: int, order: QtCore.Qt.SortOrder) -> None: ...
- def fieldIndex(self, fieldName: str|None) -> int: ...
- def database(self) -> QSqlDatabase: ...
- def primaryKey(self) -> QSqlIndex: ...
- def editStrategy(self) -> 'QSqlTableModel.EditStrategy': ...
- def setEditStrategy(self, strategy: 'QSqlTableModel.EditStrategy') -> None: ...
- def clear(self) -> None: ...
- @typing.overload
- def isDirty(self, index: QtCore.QModelIndex) -> bool: ...
- @typing.overload
- def isDirty(self) -> bool: ...
- def headerData(self, section: int, orientation: QtCore.Qt.Orientation, role: int = ...) -> typing.Any: ...
- def setData(self, index: QtCore.QModelIndex, value: typing.Any, role: int = ...) -> bool: ...
- def data(self, idx: QtCore.QModelIndex, role: int = ...) -> typing.Any: ...
- def flags(self, index: QtCore.QModelIndex) -> QtCore.Qt.ItemFlag: ...
- def tableName(self) -> str: ...
- def setTable(self, tableName: str|None) -> None: ...
- def select(self) -> bool: ...
- class QSqlRelationalTableModel(QSqlTableModel):
- class JoinMode(enum.Enum):
- InnerJoin = ... # type: QSqlRelationalTableModel.JoinMode
- LeftJoin = ... # type: QSqlRelationalTableModel.JoinMode
- def __init__(self, parent: QtCore.QObject|None = ..., db: QSqlDatabase = ...) -> None: ...
- def setJoinMode(self, joinMode: 'QSqlRelationalTableModel.JoinMode') -> None: ...
- def insertRowIntoTable(self, values: QSqlRecord) -> bool: ...
- def orderByClause(self) -> str: ...
- def updateRowInTable(self, row: int, values: QSqlRecord) -> bool: ...
- def selectStatement(self) -> str: ...
- def removeColumns(self, column: int, count: int, parent: QtCore.QModelIndex = ...) -> bool: ...
- def revertRow(self, row: int) -> None: ...
- def relationModel(self, column: int) -> QSqlTableModel|None: ...
- def relation(self, column: int) -> QSqlRelation: ...
- def setRelation(self, column: int, relation: QSqlRelation) -> None: ...
- def setTable(self, tableName: str|None) -> None: ...
- def select(self) -> bool: ...
- def clear(self) -> None: ...
- def setData(self, item: QtCore.QModelIndex, value: typing.Any, role: int = ...) -> bool: ...
- def data(self, item: QtCore.QModelIndex, role: int = ...) -> typing.Any: ...
- class QSqlResult(PyQt6.sip.wrapper):
- class BindingSyntax(enum.Enum):
- PositionalBinding = ... # type: QSqlResult.BindingSyntax
- NamedBinding = ... # type: QSqlResult.BindingSyntax
- def __init__(self, db: QSqlDriver|None) -> None: ...
- def isPositionalBindingEnabled(self) -> bool: ...
- def setPositionalBindingEnabled(self, enable: bool) -> None: ...
- def boundValueNames(self) -> list[str]: ...
- def lastInsertId(self) -> typing.Any: ...
- def record(self) -> QSqlRecord: ...
- def numRowsAffected(self) -> int: ...
- def size(self) -> int: ...
- def fetchLast(self) -> bool: ...
- def fetchFirst(self) -> bool: ...
- def fetchPrevious(self) -> bool: ...
- def fetchNext(self) -> bool: ...
- def fetch(self, i: int) -> bool: ...
- def reset(self, sqlquery: str|None) -> bool: ...
- def isNull(self, i: int) -> bool: ...
- def data(self, i: int) -> typing.Any: ...
- def bindingSyntax(self) -> 'QSqlResult.BindingSyntax': ...
- def hasOutValues(self) -> bool: ...
- def clear(self) -> None: ...
- def boundValueName(self, pos: int) -> str: ...
- def executedQuery(self) -> str: ...
- def boundValues(self) -> list[typing.Any]: ...
- def boundValueCount(self) -> int: ...
- @typing.overload
- def bindValueType(self, placeholder: str|None) -> 'QSql.ParamTypeFlag': ...
- @typing.overload
- def bindValueType(self, pos: int) -> 'QSql.ParamTypeFlag': ...
- @typing.overload
- def boundValue(self, placeholder: str|None) -> typing.Any: ...
- @typing.overload
- def boundValue(self, pos: int) -> typing.Any: ...
- def addBindValue(self, val: typing.Any, type: 'QSql.ParamTypeFlag') -> None: ...
- @typing.overload
- def bindValue(self, pos: int, val: typing.Any, type: 'QSql.ParamTypeFlag') -> None: ...
- @typing.overload
- def bindValue(self, placeholder: str|None, val: typing.Any, type: 'QSql.ParamTypeFlag') -> None: ...
- def savePrepare(self, sqlquery: str|None) -> bool: ...
- def prepare(self, query: str|None) -> bool: ...
- def exec(self) -> bool: ...
- def setForwardOnly(self, forward: bool) -> None: ...
- def setSelect(self, s: bool) -> None: ...
- def setQuery(self, query: str|None) -> None: ...
- def setLastError(self, e: QSqlError) -> None: ...
- def setActive(self, a: bool) -> None: ...
- def setAt(self, at: int) -> None: ...
- def driver(self) -> QSqlDriver|None: ...
- def isForwardOnly(self) -> bool: ...
- def isSelect(self) -> bool: ...
- def isActive(self) -> bool: ...
- def isValid(self) -> bool: ...
- def lastError(self) -> QSqlError: ...
- def lastQuery(self) -> str: ...
- def at(self) -> int: ...
- def handle(self) -> typing.Any: ...
- class QSql(PyQt6.sip.simplewrapper):
- class NumericalPrecisionPolicy(enum.Enum):
- LowPrecisionInt32 = ... # type: QSql.NumericalPrecisionPolicy
- LowPrecisionInt64 = ... # type: QSql.NumericalPrecisionPolicy
- LowPrecisionDouble = ... # type: QSql.NumericalPrecisionPolicy
- HighPrecision = ... # type: QSql.NumericalPrecisionPolicy
- class TableType(enum.Enum):
- Tables = ... # type: QSql.TableType
- SystemTables = ... # type: QSql.TableType
- Views = ... # type: QSql.TableType
- AllTables = ... # type: QSql.TableType
- class ParamTypeFlag(enum.Flag):
- In = ... # type: QSql.ParamTypeFlag
- Out = ... # type: QSql.ParamTypeFlag
- InOut = ... # type: QSql.ParamTypeFlag
- Binary = ... # type: QSql.ParamTypeFlag
- class Location(enum.Enum):
- BeforeFirstRow = ... # type: QSql.Location
- AfterLastRow = ... # type: QSql.Location
|