QSqlIndex

PyQt5.QtSql.QSqlIndex

Inherits from QSqlRecord.

Description

The QSqlIndex class provides functions to manipulate and describe database indexes.

An index refers to a single table or view in a database. Information about the fields that comprise the index can be used to generate SQL statements.

Methods

__init__(QSqlIndex)

Constructs a copy of other.

---

__init__(cursorName: str = '', name: str = '')

Constructs an empty index using the cursor name cursorname and index name name.

---

append(QSqlField)

Appends the field field to the list of indexed fields. The field is appended with an ascending sort order.

---

append(QSqlField, bool)

This is an overloaded function.

Appends the field field to the list of indexed fields. The field is appended with an ascending sort order, unless desc is true.

---

cursorName() → str

See also

setCursorName().

---

isDescending(int) → bool

Returns true if field i in the index is sorted in descending order; otherwise returns false.

---

name() → str

See also

setName().

---

setCursorName(str)

Sets the name of the cursor that the index is associated with to cursorName.

See also

cursorName().

---

setDescending(int, bool)

If desc is true, field i is sorted in descending order. Otherwise, field i is sorted in ascending order (the default). If the field does not exist, nothing happens.

See also

isDescending().

---

setName(str)

Sets the name of the index to name.

See also

name().