Home · All Classes · Modules

QSql Class Reference
[QtSql module]

The QSql namespace contains miscellaneous identifiers used throughout the Qt SQL library. More...

Types


Detailed Description

The QSql namespace contains miscellaneous identifiers used throughout the Qt SQL library.


Type Documentation

QSql.Location

This enum type describes special SQL navigation locations:

Constant Value Description
QSql.BeforeFirstRow -1 Before the first record.
QSql.AfterLastRow -2 After the last record.

See also QSqlQuery.at().

QSql.NumericalPrecisionPolicy

Numerical values in a database can have precisions greater than their corresponding C++ types. This enum lists the policies for representing such values in the application.

Constant Value Description
QSql.LowPrecisionInt32 0x01 Force 32bit integer values. In case of floating point numbers, the fractional part is silently discarded.
QSql.LowPrecisionInt64 0x02 Force 64bit integer values. In case of floating point numbers, the fractional part is silently discarded.
QSql.LowPrecisionDouble 0x04 Force double values. This is the default policy.
QSql.HighPrecision 0 Strings will be used to preserve precision.

Note: The actual behaviour if an overflow occurs is driver specific. The Oracle database just returns an error in this case.

QSql.ParamTypeFlag

This enum is used to specify the type of a bind parameter.

Constant Value Description
QSql.In 0x00000001 The bind parameter is used to put data into the database.
QSql.Out 0x00000002 The bind parameter is used to receive data from the database.
QSql.InOut In | Out The bind parameter is used to put data into the database; it will be overwritten with output data on executing a query.
QSql.Binary 0x00000004 This must be OR'd with one of the other flags if you want to indicate that the data being transferred is raw binary data.

The ParamType type is a typedef for QFlags<ParamTypeFlag>. It stores an OR combination of ParamTypeFlag values.

QSql.TableType

This enum type describes types of SQL tables.

Constant Value Description
QSql.Tables 0x01 All the tables visible to the user.
QSql.SystemTables 0x02 Internal tables used by the database.
QSql.Views 0x04 All the views visible to the user.
QSql.AllTables 0xff All of the above.

PyQt 4.12.1 for X11Copyright © Riverbank Computing Ltd and The Qt Company 2015Qt 4.8.7