QSqlError#

The QSqlError class provides SQL database error information. More

Synopsis#

Functions#

Note

This documentation may contain snippets that were automatically translated from C++ to Python. We always welcome contributions to the snippet translation. If you see an issue with the translation, you can also let us know by creating a ticket on https:/bugreports.qt.io/projects/PYSIDE

Detailed Description#

A QSqlError object can provide database-specific error data, including the driverText() and databaseText() messages (or both concatenated together as text() ), and the nativeErrorCode() and type() .

class PySide6.QtSql.QSqlError(other)#

PySide6.QtSql.QSqlError([driverText=””[, databaseText=””[, type=QSqlError.ErrorType.NoError[, errorCode=””]]]])

Parameters:

Creates a copy of other.

Constructs an error containing the driver error text driverText, the database-specific error text databaseText, the type type and the error code code.

PySide6.QtSql.QSqlError.ErrorType#

This enum type describes the context in which the error occurred, e.g., a connection error, a statement error, etc.

Constant

Description

QSqlError.NoError

No error occurred.

QSqlError.ConnectionError

Connection error.

QSqlError.StatementError

SQL statement syntax error.

QSqlError.TransactionError

Transaction failed error.

QSqlError.UnknownError

Unknown error.

PySide6.QtSql.QSqlError.databaseText()#
Return type:

str

Returns the text of the error as reported by the database. This may contain database-specific descriptions; it may be empty.

See also

driverText() text()

PySide6.QtSql.QSqlError.driverText()#
Return type:

str

Returns the text of the error as reported by the driver. This may contain database-specific descriptions. It may also be empty.

PySide6.QtSql.QSqlError.isValid()#
Return type:

bool

Warning

This section contains snippets that were automatically translated from C++ to Python and may contain errors.

Returns true if an error is set, otherwise false.

Example:

model = QSqlQueryModel()
model.setQuery("select * from myTable")
if model.lastError().isValid():
    print(model.lastError())

See also

type()

PySide6.QtSql.QSqlError.nativeErrorCode()#
Return type:

str

Returns the database-specific error code, or an empty string if it cannot be determined.

Note

Some drivers (like DB2 or ODBC) may return more than one error code. When this happens, ; is used as separator between the error codes.

PySide6.QtSql.QSqlError.__ne__(other)#
Parameters:

otherPySide6.QtSql.QSqlError

Return type:

bool

Compare the other error’s type() and nativeErrorCode() to this error and returns true if it is not equal.

PySide6.QtSql.QSqlError.__eq__(other)#
Parameters:

otherPySide6.QtSql.QSqlError

Return type:

bool

Compare the other error’s type() and nativeErrorCode() to this error and returns true, if it equal.

PySide6.QtSql.QSqlError.swap(other)#
Parameters:

otherPySide6.QtSql.QSqlError

Swaps error other with this error. This operation is very fast and never fails.

PySide6.QtSql.QSqlError.text()#
Return type:

str

This is a convenience function that returns databaseText() and driverText() concatenated into a single string.

PySide6.QtSql.QSqlError.type()#
Return type:

ErrorType

Returns the error type, or -1 if the type cannot be determined.