The QSql namespace contains miscellaneous identifiers used throughout the Qt SQL library.
See also
QtSql Module
This enum type describes at which precision levels numercial values are read from a database.
Some databases support numerical values with a precision that is not storable in a C++ basic data type. The default behavior is to bind these values as a PySide.QtCore.QString . This enum can be used to override this behavior.
| Constant | Description |
|---|---|
| QSql.LowPrecisionInt32 | Force 32bit integer values. In case of floating point numbers, the fractional part is silently discarded. |
| QSql.LowPrecisionInt64 | Force 64bit integer values. In case of floating point numbers, the fractional part is silently discarded. |
| QSql.LowPrecisionDouble | Force double values. |
| QSql.HighPrecision | The default behavior - try to preserve maximum precision. |
Note: The actual behaviour if an overflow occurs is driver specific. The Oracle database just returns an error in this case.
This enum type describes special SQL navigation locations:
| Constant | Description |
|---|---|
| QSql.BeforeFirstRow | Before the first record. |
| QSql.AfterLastRow | After the last record. |
See also
This enum is used to specify the type of a bind parameter.
| Constant | Description |
|---|---|
| QSql.In | The bind parameter is used to put data into the database. |
| QSql.Out | The bind parameter is used to receive data from the database. |
| QSql.InOut | The bind parameter is used to put data into the database; it will be overwritten with output data on executing a query. |
| QSql.Binary | 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. |
This enum type describes types of SQL tables.
| Constant | Description |
|---|---|
| QSql.Tables | All the tables visible to the user. |
| QSql.SystemTables | Internal tables used by the database. |
| QSql.Views | All the views visible to the user. |
| QSql.AllTables | All of the above. |