class QSqlError

The QSqlError class provides SQL database error information. More

Synopsis

Methods

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 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.

__init__(other)
Parameters:

otherQSqlError

Creates a copy of other.

__init__([driverText=""[, databaseText=""[, type=QSqlError.ErrorType.NoError[, errorCode=""]]]])
Parameters:
  • driverText – str

  • databaseText – str

  • typeErrorType

  • errorCode – str

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

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()

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.

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()

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.

__ne__(other)
Parameters:

otherQSqlError

Return type:

bool

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

__eq__(other)
Parameters:

otherQSqlError

Return type:

bool

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

swap(other)
Parameters:

otherQSqlError

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

text()
Return type:

str

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

type()
Return type:

ErrorType

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