QSql ¶

详细描述 ¶

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

常量	描述
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. This is the default policy.
QSql.HighPrecision	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.

PySide.QtSql.QSql. 定位 ¶

This enum type describes special SQL navigation locations:

常量	描述
QSql.BeforeFirstRow	Before the first record.
QSql.AfterLastRow	After the last record.

另请参阅

QSqlQuery.at()

PySide.QtSql.QSql. ParamTypeFlag ¶

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

常量	描述
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.

PySide.QtSql.QSql. TableType ¶

This enum type describes types of SQL tables.

常量	描述
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.