QSqlRelationalTableModel

#include <QtSql/QSqlRelationalTableModel>

More information will be added here shortly. For now, you'll find more extensive information about this class in the Qt reference for QSqlRelationalTableModel

Overview

Inheritance

QAbstractItemModel
	QAbstractTableModel
		QSqlQueryModel
			QSqlTableModel
				QSqlRelationalTableModel

Public Types Index

enum JoinMode

InnerJoin, LeftJoin

enum EditStrategy

OnFieldChange, OnRowChange, OnManualSubmit

Public Functions Index

	QSqlRelationalTableModel (QObject *parent=0, QSqlDatabase db=QSqlDatabase())
virtual	~QSqlRelationalTableModel ()
virtual void	clear ()
virtual QVariant	data (const QModelIndex &item, int role=Qt::DisplayRole) const
QSqlRelation	relation (int column) const
virtual QSqlTableModel *	relationModel (int column) const
virtual bool	removeColumns (int column, int count, const QModelIndex &parent=QModelIndex())
virtual bool	select ()
virtual bool	setData (const QModelIndex &item, const QVariant &value, int role=Qt::EditRole)
void	setJoinMode (QSqlRelationalTableModel::JoinMode joinMode)
virtual void	setRelation (int column, const QSqlRelation &relation)
virtual void	setTable (const QString &tableName)
virtual QModelIndex	buddy (const QModelIndex &index) const
virtual bool	canFetchMore (const QModelIndex &parent=QModelIndex()) const
virtual int	columnCount (const QModelIndex &parent=QModelIndex()) const
QSqlDatabase	database () const
virtual bool	dropMimeData (const QMimeData *data, Qt::DropAction action, int row, int column, const QModelIndex &parent)
EditStrategy	editStrategy () const
virtual void	fetchMore (const QModelIndex &parent=QModelIndex())
int	fieldIndex (const QString &fieldName) const
QString	filter () const
virtual Qt::ItemFlags	flags (const QModelIndex &index) const
bool	hasIndex (int row, int column, const QModelIndex &parent=QModelIndex()) const
virtual QVariant	headerData (int section, Qt::Orientation orientation, int role=Qt::DisplayRole) const
virtual QModelIndex	index (int row, int column, const QModelIndex &parent=QModelIndex()) const
bool	insertColumn (int column, const QModelIndex &parent=QModelIndex())
virtual bool	insertColumns (int column, int count, const QModelIndex &parent=QModelIndex())
bool	insertRecord (int row, const QSqlRecord &record)
bool	insertRow (int row, const QModelIndex &parent=QModelIndex())
virtual bool	insertRows (int row, int count, const QModelIndex &parent=QModelIndex())
bool	isDirty (const QModelIndex &index) const
virtual QMap< int, QVariant >	itemData (const QModelIndex &index) const
QSqlError	lastError () const
virtual QModelIndexList	match (const QModelIndex &start, int role, const QVariant &value, int hits=1, Qt::MatchFlags flags=Qt::MatchFlags(Qt::MatchStartsWith\|Qt::MatchWrap)) const
virtual QMimeData *	mimeData (const QModelIndexList &indexes) const
virtual QStringList	mimeTypes () const
QSqlIndex	primaryKey () const
	QAbstractItemModel (QObject *parent=0)
	QAbstractTableModel (QObject *parent=0)
	QSqlQueryModel (QObject *parent=0)
	QSqlTableModel (QObject *parent=0, QSqlDatabase db=QSqlDatabase())
QSqlQuery	query () const
QSqlRecord	record (int row) const
QSqlRecord	record () const
bool	removeColumn (int column, const QModelIndex &parent=QModelIndex())
bool	removeRow (int row, const QModelIndex &parent=QModelIndex())
virtual bool	removeRows (int row, int count, const QModelIndex &parent=QModelIndex())
const QHash< int, QByteArray > &	roleNames () const
virtual int	rowCount (const QModelIndex &parent=QModelIndex()) const
virtual void	setEditStrategy (EditStrategy strategy)
virtual void	setFilter (const QString &filter)
virtual bool	setHeaderData (int section, Qt::Orientation orientation, const QVariant &value, int role=Qt::EditRole)
virtual bool	setItemData (const QModelIndex &index, const QMap< int, QVariant > &roles)
void	setQuery (const QString &query, const QSqlDatabase &db=QSqlDatabase())
bool	setRecord (int row, const QSqlRecord &record)
virtual void	setSort (int column, Qt::SortOrder order)
void	setSupportedDragActions (Qt::DropActions)
QModelIndex	sibling (int row, int column, const QModelIndex &idx) const
virtual void	sort (int column, Qt::SortOrder order)
virtual QSize	span (const QModelIndex &index) const
Qt::DropActions	supportedDragActions () const
virtual Qt::DropActions	supportedDropActions () const
QString	tableName () const

Protected Functions Index

virtual bool	insertRowIntoTable (const QSqlRecord &values)
virtual QString	orderByClause () const
virtual QString	selectStatement () const
virtual bool	updateRowInTable (int row, const QSqlRecord &values)
void	beginInsertColumns (const QModelIndex &parent, int first, int last)
void	beginInsertRows (const QModelIndex &parent, int first, int last)
bool	beginMoveColumns (const QModelIndex &sourceParent, int sourceFirst, int sourceLast, const QModelIndex &destinationParent, int destinationColumn)
bool	beginMoveRows (const QModelIndex &sourceParent, int sourceFirst, int sourceLast, const QModelIndex &destinationParent, int destinationRow)
void	beginRemoveColumns (const QModelIndex &parent, int first, int last)
void	beginRemoveRows (const QModelIndex &parent, int first, int last)
void	beginResetModel ()
void	changePersistentIndex (const QModelIndex &from, const QModelIndex &to)
void	changePersistentIndexList (const QModelIndexList &from, const QModelIndexList &to)
QModelIndex	createIndex (int row, int column, void *data=0) const
QModelIndex	createIndex (int row, int column, int id) const
QModelIndex	createIndex (int row, int column, quint32 id) const
bool	decodeData (int row, int column, const QModelIndex &parent, QDataStream &stream)
virtual bool	deleteRowFromTable (int row)
void	encodeData (const QModelIndexList &indexes, QDataStream &stream) const
void	endInsertColumns ()
void	endInsertRows ()
void	endMoveColumns ()
void	endMoveRows ()
void	endRemoveColumns ()
void	endRemoveRows ()
void	endResetModel ()
QModelIndex	indexInQuery (const QModelIndex &item) const
QModelIndexList	persistentIndexList () const
	QAbstractItemModel (QAbstractItemModelPrivate &dd, QObject *parent=0)
	QAbstractTableModel (QAbstractItemModelPrivate &dd, QObject *parent)
	QSqlQueryModel (QSqlQueryModelPrivate &dd, QObject *parent=0)
	QSqlTableModel (QSqlTableModelPrivate &dd, QObject *parent=0, QSqlDatabase db=QSqlDatabase())
virtual void	queryChange ()
void	reset ()
void	setLastError (const QSqlError &error)
void	setPrimaryKey (const QSqlIndex &key)
void	setQuery (const QSqlQuery &query)
void	setRoleNames (const QHash< int, QByteArray > &roleNames)

Public Slots Index

virtual void	revertRow (int row)
virtual void	revert ()
void	revertAll ()
virtual bool	submit ()
bool	submitAll ()

Signals Index

Only has inherited signals

void	beforeDelete (int row)
void	beforeInsert (QSqlRecord &record)
void	beforeUpdate (int row, QSqlRecord &record)
void	dataChanged (const QModelIndex &topLeft, const QModelIndex &bottomRight)
void	headerDataChanged (Qt::Orientation orientation, int first, int last)
void	layoutAboutToBeChanged ()
void	layoutChanged ()
void	primeInsert (int row, QSqlRecord &record)

Public Types

JoinMode

InnerJoin
LeftJoin

EditStrategy

OnFieldChange
OnRowChange
OnManualSubmit

Public Functions

QSqlRelationalTableModel (
QObject *parent,
QSqlDatabasedb )

virtual~QSqlRelationalTableModel ()

Destructor.

virtual void clear ()

virtualQVariant data (
const QModelIndex &item,
introle )

QSqlRelation relation (
intcolumn)

virtualQSqlTableModel * relationModel (
intcolumn)

virtual bool removeColumns (
intcolumn,
intcount,
const QModelIndex &parent )

virtual bool select ()

virtual bool setData (
const QModelIndex &item,
const QVariant &value,
introle )

void setJoinMode (
QSqlRelationalTableModel::JoinModejoinMode)

virtual void setRelation (
intcolumn,
const QSqlRelation &relation )

virtual void setTable (
const QString &tableName)

virtualQModelIndex buddy (
const QModelIndex &index)

virtual bool canFetchMore (
const QModelIndex &parent)

virtual int columnCount (
const QModelIndex &parent)

QSqlDatabase database ()

virtual bool dropMimeData (
const QMimeData *data,
Qt::DropActionaction,
introw,
intcolumn,
const QModelIndex &parent )

EditStrategy editStrategy ()

virtual void fetchMore (
const QModelIndex &parent)

int fieldIndex (
const QString &fieldName)

QString filter ()

virtual Qt::ItemFlags flags (
const QModelIndex &index)

bool hasIndex (
introw,
intcolumn,
const QModelIndex &parent )

virtualQVariant headerData (
intsection,
Qt::Orientationorientation,
introle )

virtualQModelIndex index (
introw,
intcolumn,
const QModelIndex &parent )

bool insertColumn (
intcolumn,
const QModelIndex &parent )

virtual bool insertColumns (
intcolumn,
intcount,
const QModelIndex &parent )

bool insertRecord (
introw,
const QSqlRecord &record )

bool insertRow (
introw,
const QModelIndex &parent )

virtual bool insertRows (
introw,
intcount,
const QModelIndex &parent )

bool isDirty (
const QModelIndex &index)

virtualQMap< int, QVariant > itemData (
const QModelIndex &index)

QSqlError lastError ()

virtualQModelIndexList match (
const QModelIndex &start,
introle,
const QVariant &value,
inthits,
Qt::MatchFlagsflags )

virtualQMimeData * mimeData (
const QModelIndexList &indexes)

virtualQStringList mimeTypes ()

QSqlIndex primaryKey ()

QAbstractItemModel (
QObject *parent)

QAbstractTableModel (
QObject *parent)

QSqlQueryModel (
QObject *parent)

QSqlTableModel (
QObject *parent,
QSqlDatabasedb )

QSqlQuery query ()

QSqlRecord record (
introw)

QSqlRecord record ()

bool removeColumn (
intcolumn,
const QModelIndex &parent )

bool removeRow (
introw,
const QModelIndex &parent )

virtual bool removeRows (
introw,
intcount,
const QModelIndex &parent )

const QHash< int, QByteArray > & roleNames ()

virtual int rowCount (
const QModelIndex &parent)

virtual void setEditStrategy (
EditStrategystrategy)

virtual void setFilter (
const QString &filter)

virtual bool setHeaderData (
intsection,
Qt::Orientationorientation,
const QVariant &value,
introle )

virtual bool setItemData (
const QModelIndex &index,
const QMap< int, QVariant > &roles )

void setQuery (
const QString &query,
const QSqlDatabase &db )

bool setRecord (
introw,
const QSqlRecord &record )

virtual void setSort (
intcolumn,
Qt::SortOrderorder )

void setSupportedDragActions (
Qt::DropActions)

QModelIndex sibling (
introw,
intcolumn,
const QModelIndex &idx )

virtual void sort (
intcolumn,
Qt::SortOrderorder )

virtualQSize span (
const QModelIndex &index)

Qt::DropActions supportedDragActions ()

virtual Qt::DropActions supportedDropActions ()

QString tableName ()

Protected Functions

virtual bool insertRowIntoTable (
const QSqlRecord &values)

virtualQString orderByClause ()

virtualQString selectStatement ()

virtual bool updateRowInTable (
introw,
const QSqlRecord &values )

void beginInsertColumns (
const QModelIndex &parent,
intfirst,
intlast )

void beginInsertRows (
const QModelIndex &parent,
intfirst,
intlast )

bool beginMoveColumns (
const QModelIndex &sourceParent,
intsourceFirst,
intsourceLast,
const QModelIndex &destinationParent,
intdestinationColumn )

bool beginMoveRows (
const QModelIndex &sourceParent,
intsourceFirst,
intsourceLast,
const QModelIndex &destinationParent,
intdestinationRow )

void beginRemoveColumns (
const QModelIndex &parent,
intfirst,
intlast )

void beginRemoveRows (
const QModelIndex &parent,
intfirst,
intlast )

void beginResetModel ()

void changePersistentIndex (
const QModelIndex &from,
const QModelIndex &to )

void changePersistentIndexList (
const QModelIndexList &from,
const QModelIndexList &to )

QModelIndex createIndex (
introw,
intcolumn,
void *data )

QModelIndex createIndex (
introw,
intcolumn,
intid )

QModelIndex createIndex (
introw,
intcolumn,
quint32id )

bool decodeData (
introw,
intcolumn,
const QModelIndex &parent,
QDataStream &stream )

virtual bool deleteRowFromTable (
introw)

void encodeData (
const QModelIndexList &indexes,
QDataStream &stream )

void endInsertColumns ()

void endInsertRows ()

void endMoveColumns ()

void endMoveRows ()

void endRemoveColumns ()

void endRemoveRows ()

void endResetModel ()

QModelIndex indexInQuery (
const QModelIndex &item)

QModelIndexList persistentIndexList ()

QAbstractItemModel (
QAbstractItemModelPrivate &dd,
QObject *parent )

QAbstractTableModel (
QAbstractItemModelPrivate &dd,
QObject *parent )

QSqlQueryModel (
QSqlQueryModelPrivate &dd,
QObject *parent )

QSqlTableModel (
QSqlTableModelPrivate &dd,
QObject *parent,
QSqlDatabasedb )

virtual void queryChange ()

void reset ()

void setLastError (
const QSqlError &error)

void setPrimaryKey (
const QSqlIndex &key)

void setQuery (
const QSqlQuery &query)

void setRoleNames (
const QHash< int, QByteArray > &roleNames)

Public Slots

virtual void revertRow (
introw)

virtual void revert ()

void revertAll ()

virtual bool submit ()

bool submitAll ()

Signals

(Only has inherited signals)

void beforeDelete (
introw)

void beforeInsert (
QSqlRecord &record)

void beforeUpdate (
introw,
QSqlRecord &record )

void dataChanged (
const QModelIndex &topLeft,
const QModelIndex &bottomRight )

void headerDataChanged (
Qt::Orientationorientation,
intfirst,
intlast )

void layoutAboutToBeChanged ()

void layoutChanged ()

void primeInsert (
introw,
QSqlRecord &record )

The documentation provided herein is licensed under the terms of the GNU Free Documentation License version 1.3 as published by the Free Software Foundation.

Documentation sources may be obtained from www.qt-project.org.

Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide. All other trademarks are property of their respective owners. Privacy Policy

QSqlRelationalTableModel

Overview

Inheritance

Public Types Index

enum JoinMode

enum EditStrategy

Public Functions Index

Protected Functions Index

Public Slots Index

Signals Index

Public Types

JoinMode

EditStrategy

Public Functions

QSqlRelationalTableModel (QObject *parent, QSqlDatabasedb )

virtual~QSqlRelationalTableModel ()

virtual void clear ()

virtualQVariant data (const QModelIndex &item, introle )

QSqlRelation relation (intcolumn)

virtualQSqlTableModel * relationModel (intcolumn)

virtual bool removeColumns (intcolumn, intcount, const QModelIndex &parent )

virtual bool select ()

virtual bool setData (const QModelIndex &item, const QVariant &value, introle )

void setJoinMode (QSqlRelationalTableModel::JoinModejoinMode)

virtual void setRelation (intcolumn, const QSqlRelation &relation )

virtual void setTable (const QString &tableName)

virtualQModelIndex buddy (const QModelIndex &index)

virtual bool canFetchMore (const QModelIndex &parent)

virtual int columnCount (const QModelIndex &parent)