QSqlRecord ¶

概要 ¶

详细描述 ¶

QSqlRecord class encapsulates the functionality and characteristics of a database record (usually a row in a table or view within the database). QSqlRecord supports adding and removing fields as well as setting and retrieving field values.

The values of a record’s fields can be set by name or position with setValue() ; if you want to set a field to null use setNull() . To find the position of a field by name use indexOf() , and to find the name of a field at a particular position use fieldName() 。使用 field() to retrieve a QSqlField object for a given field. Use contains() to see if the record contains a particular field name.

When queries are generated to be executed on the database only those fields for which isGenerated() is true are included in the generated SQL.

A record can have fields added with append() or insert() , replaced with replace() , and removed with remove() . All the fields can be removed with clear() . The number of fields is given by count() ; all their values can be cleared (to null) using clearValues() .

另请参阅

QSqlField record()

class QSqlRecord ¶

QSqlRecord(other)

param other

QSqlRecord

Constructs an empty record.

另请参阅

isEmpty() append() insert()

构造副本为 other .

QSqlRecord is 隐式共享 . This means you can make copies of a record in constant time .

PySide2.QtSql.QSqlRecord. append ( field ) ¶

参数

field – QSqlField

Append a copy of field field to the end of the record.

另请参阅

insert() replace() remove()

PySide2.QtSql.QSqlRecord. clear ( ) ¶

Removes all the record’s fields.

另请参阅

clearValues() isEmpty()

PySide2.QtSql.QSqlRecord. clearValues ( ) ¶

Clears the value of all fields in the record and sets each field to null.

另请参阅

setValue()

PySide2.QtSql.QSqlRecord. contains ( name ) ¶

参数

name – unicode

返回类型

bool

返回 true if there is a field in the record called name ；否则返回 false .

PySide2.QtSql.QSqlRecord. count ( ) ¶

返回类型

int

Returns the number of fields in the record.

另请参阅

isEmpty()

PySide2.QtSql.QSqlRecord. field ( name ) ¶

参数

name – unicode

返回类型

QSqlField

PySide2.QtSql.QSqlRecord. field ( i ) ¶

参数

i – int

返回类型

QSqlField

Returns the field at position index 。若 index is out of range, function returns a 默认构造值 .

PySide2.QtSql.QSqlRecord. fieldName ( i ) ¶

参数

i – int

返回类型

unicode

Returns the name of the field at position index . If the field does not exist, an empty string is returned.

另请参阅

indexOf()

PySide2.QtSql.QSqlRecord. indexOf ( name ) ¶

参数

name – unicode

返回类型

int

Returns the position of the field called name within the record, or -1 if it cannot be found. Field names are not case-sensitive. If more than one field matches, the first one is returned.

另请参阅

fieldName()

PySide2.QtSql.QSqlRecord. insert ( pos , field ) ¶

参数

• pos – int

• field – QSqlField

Inserts the field field 在位置 pos in the record.

另请参阅

append() replace() remove()

PySide2.QtSql.QSqlRecord. isEmpty ( ) ¶

返回类型

bool

返回 true if there are no fields in the record; otherwise returns false .

另请参阅

append() insert() clear()

PySide2.QtSql.QSqlRecord. isGenerated ( name ) ¶

参数

name – unicode

返回类型

bool

PySide2.QtSql.QSqlRecord. isGenerated ( i ) ¶

参数

i – int

返回类型

bool

这是重载函数。

返回 true if the record has a field at position index and this field is to be generated (the default); otherwise returns false .

另请参阅

setGenerated()

PySide2.QtSql.QSqlRecord. isNull ( name ) ¶

参数

name – unicode

返回类型

bool

PySide2.QtSql.QSqlRecord. isNull ( i ) ¶

参数

i – int

返回类型

bool

这是重载函数。

返回 true if the field index is null or if there is no field at position index ；否则返回 false .

PySide2.QtSql.QSqlRecord. keyValues ( keyFields ) ¶

参数

keyFields – QSqlRecord

返回类型

QSqlRecord

Returns a record containing the fields represented in keyFields set to values that match by field name.

PySide2.QtSql.QSqlRecord. __ne__ ( other ) ¶

参数

other – QSqlRecord

返回类型

bool

返回 true if this object is not identical to other ；否则返回 false .

另请参阅

operator==()

PySide2.QtSql.QSqlRecord. __eq__ ( other ) ¶

参数

other – QSqlRecord

返回类型

bool

返回 true if this object is identical to other (i.e., has the same fields in the same order); otherwise returns false .

另请参阅

operator!=()

PySide2.QtSql.QSqlRecord. remove ( pos ) ¶

参数

pos – int

Removes the field at position pos 。若 pos is out of range, nothing happens.

另请参阅

append() insert() replace()

PySide2.QtSql.QSqlRecord. replace ( pos , field ) ¶

参数

• pos – int

• field – QSqlField

Replaces the field at position pos 采用给定 field 。若 pos is out of range, nothing happens.

另请参阅

append() insert() remove()

PySide2.QtSql.QSqlRecord. setGenerated ( name , generated ) ¶

参数

• name – unicode

• generated – bool

PySide2.QtSql.QSqlRecord. setGenerated ( i , generated ) ¶

参数

• i – int

• generated – bool

这是重载函数。

Sets the generated flag for the field index to generated .

另请参阅

isGenerated()

PySide2.QtSql.QSqlRecord. setNull ( name ) ¶

参数

name – unicode

PySide2.QtSql.QSqlRecord. setNull ( i ) ¶

参数

i – int

Sets the value of field index to null. If the field does not exist, nothing happens.

另请参阅

isNull() setValue()

PySide2.QtSql.QSqlRecord. setValue ( name , val ) ¶

参数

• name – unicode

• val – object

PySide2.QtSql.QSqlRecord. setValue ( i , val ) ¶

参数

• i – int

• val – object

PySide2.QtSql.QSqlRecord. value ( name ) ¶

参数

name – unicode

返回类型

object

PySide2.QtSql.QSqlRecord. value ( i ) ¶

参数

i – int

返回类型

object

Returns the value of the field located at position index in the record. If index is out of bounds, an invalid QVariant 被返回。

另请参阅

setValue() fieldName() isNull()