Главная · Все классы · Основные классы · Классы по группам · Модули · Функции

QSqlRelationalTableModel Class Reference
[модуль QtSql]

The QSqlRelationalTableModel class provides an editable data model for a single database table, with foreign key support. Далее...

 #include <QSqlRelationalTableModel>

Inherits QSqlTableModel.

Открытые функции

Дополнительные унаследованные члены


Подробное описание

The QSqlRelationalTableModel class provides an editable data model for a single database table, with foreign key support.

QSqlRelationalTableModel acts like QSqlTableModel, but allows columns to be set as foreign keys into other database tables.

Левый скриншот показывает QSqlTableModel в QTableView. Внешние ключи (city и country) не представлены удобочитаемыми значениями. The screenshot on the right shows a QSqlRelationalTableModel, with foreign keys resolved into human-readable text strings.

The following code snippet shows how the QSqlRelationalTableModel was set up:

     model->setTable("employee");

     model->setRelation(2, QSqlRelation("city", "id", "name"));
     model->setRelation(3, QSqlRelation("country", "id", "name"));

The setRelation() function calls establish a relationship between two tables. The first call specifies that column 2 in table employee is a foreign key that maps with field id of table city, and that the view should present the city's name field to the user. The second call does something similar with column 3.

If you use a read-write QSqlRelationalTableModel, you probably want to use QSqlRelationalDelegate on the view. Unlike the default delegate, QSqlRelationalDelegate provides a combobox for fields that are foreign keys into other tables. To use the class, simply call QAbstractItemView::setItemDelegate() on the view with an instance of QSqlRelationalDelegate:

     QTableView *view = new QTableView;
     view->setModel(model);
     view->setItemDelegate(new QSqlRelationalDelegate(view));

The sql/relationaltablemodel example illustrates how to use QSqlRelationalTableModel in conjunction with QSqlRelationalDelegate to provide tables with foreigh key support.

Примечания:

See also QSqlRelation, QSqlRelationalDelegate, and Relational Table Model Example.


Описание функций-членов

QSqlRelationalTableModel::QSqlRelationalTableModel ( QObject * parent = 0, QSqlDatabase db = QSqlDatabase() )

Creates an empty QSqlRelationalTableModel and sets the parent to parent and the database connection to db. Если db не является корректным, используется соединение по умолчанию.

QSqlRelationalTableModel::~QSqlRelationalTableModel ()   [virtual]

Удаляет объект и освобождает все выделенные ему ресурсы.

QSqlRelation QSqlRelationalTableModel::relation ( int column ) const

Returns the relation for the column column, or an invalid relation if no relation is set.

See also setRelation() and QSqlRelation::isValid().

QSqlTableModel * QSqlRelationalTableModel::relationModel ( int column ) const   [virtual]

Returns a QSqlTableModel object for accessing the table for which column is a foreign key, or 0 if there is no relation for the given column.

The returned object is owned by the QSqlRelationalTableModel.

See also setRelation() and relation().

bool QSqlRelationalTableModel::setData ( const QModelIndex & index, const QVariant & value, int role = Qt::EditRole )   [virtual]

Sets the data for the role in the item with the specified index to the value given. Depending on the edit strategy, the value might be applied to the database at once, or it may be cached in the model.

Returns true if the value could be set, or false on error (for example, if index is out of bounds).

For relational columns, value must be the index, not the display value.

Переопределено из QAbstractItemModel.

See also editStrategy(), data(), submit(), and revertRow().

void QSqlRelationalTableModel::setRelation ( int column, const QSqlRelation & relation )   [virtual]

Lets the specified column be a foreign index specified by relation.

Пример:

     model->setTable("employee");

     model->setRelation(2, QSqlRelation("city", "id", "name"));

The setRelation() call specifies that column 2 in table employee is a foreign key that maps with field id of table city, and that the view should present the city's name field to the user.

Note: The table's primary key may not contain a relation to another table.

See also relation().


Copyright © 2008 Trolltech Торговые марки
Qt 4.3.5