QSqlRelation

The QSqlRelation class stores information about an SQL foreign key. More…

Synopsis

Functions

• def displayColumn ()

• def indexColumn ()

• def isValid ()

• def swap (other)

• def tableName ()

Detailed Description

QSqlRelation is a helper class for QSqlRelationalTableModel . See setRelation() and relation() for details.

See also

QSqlRelationalTableModel QSqlRelationalDelegate Relational Table Model Example

class PySide2.QtSql.QSqlRelation

PySide2.QtSql.QSqlRelation(QSqlRelation)

PySide2.QtSql.QSqlRelation(aTableName, indexCol, displayCol)

param QSqlRelation:

PySide2.QtSql.QSqlRelation

param aTableName:

str

param indexCol:

str

param displayCol:

str

Constructs an invalid QSqlRelation object.

For such an object, the tableName() , indexColumn() , and displayColumn() functions return an empty string.

See also

isValid()

Constructs a QSqlRelation object, where tableName is the SQL table name to which a foreign key refers, indexColumn is the foreign key, and displayColumn is the field that should be presented to the user.

See also

tableName() indexColumn() displayColumn()

PySide2.QtSql.QSqlRelation.displayColumn()

Return type:

str

Returns the column from table tableName() that should be presented to the user instead of a foreign key.

PySide2.QtSql.QSqlRelation.indexColumn()

Return type:

str

Returns the index column from table tableName() to which a foreign key refers.

PySide2.QtSql.QSqlRelation.isValid()

Return type:

bool

Returns true if the QSqlRelation object is valid; otherwise returns false .

PySide2.QtSql.QSqlRelation.swap(other)

Parameters:

other – PySide2.QtSql.QSqlRelation

Swaps this with other .

PySide2.QtSql.QSqlRelation.tableName()

Return type:

str

Returns the name of the table to which a foreign key refers.