#include <xsqltablemodel.h>

Inheritance diagram for XSqlTableModel:

Public Types
enum	FormatFlags { Money, Qty, Curr, Percent, Cost, QtyPer, SalesPrice, PurchPrice, UOMRatio, ExtPrice, Weight }

enum	itemDataRole { FormatRole, EditorRole, MenuRole }

Properties
	objectName

Public Member Functions
	XSqlTableModel (QObject *parent=0)

	~XSqlTableModel ()

virtual Q_INVOKABLE void	appendChild (XSqlTableNode *child)

virtual Q_INVOKABLE XSqlTableNode *	appendChild (const QString &tableName, ParameterList &relations)

Q_INVOKABLE void	applyColumnRole (int column, int role, QVariant value)

Q_INVOKABLE void	applyColumnRoles ()

Q_INVOKABLE void	applyColumnRoles (int row)

void	beforeDelete (int row)

void	beforeInsert (QSqlRecord &record)

void	beforeUpdate (int row, QSqlRecord &record)

bool	blockSignals (bool block)

virtual Q_INVOKABLE QModelIndex	buddy (const QModelIndex &index) const

static::QString	buildFilter (ParameterList &params)

static::ParameterList	buildParams (XSqlTableModel *parent, int row, ParameterList relations)

virtual bool	canDropMimeData (const QMimeData *data, Qt::DropAction action, int row, int column, const QModelIndex &parent) const

virtual Q_INVOKABLE bool	canFetchMore (const QModelIndex &parent=QModelIndex()) const

virtual Q_INVOKABLE XSqlTableNode *	child (int index)

virtual Q_INVOKABLE XSqlTableNode *	child (const QString &tableName)

const QObjectList &	children () const

virtual Q_INVOKABLE QList< XSqlTableNode * >	children ()

virtual Q_INVOKABLE void	clear ()

virtual Q_INVOKABLE void	clearChildren ()

virtual Q_INVOKABLE int	columnCount (const QModelIndex &parent=QModelIndex()) const

void	columnsAboutToBeInserted (const QModelIndex &parent, int first, int last)

void	columnsAboutToBeMoved (const QModelIndex &sourceParent, int sourceStart, int sourceEnd, const QModelIndex &destinationParent, int destinationColumn)

void	columnsAboutToBeRemoved (const QModelIndex &parent, int first, int last)

void	columnsInserted (const QModelIndex &parent, int first, int last)

void	columnsMoved (const QModelIndex &parent, int start, int end, const QModelIndex &destination, int column)

void	columnsRemoved (const QModelIndex &parent, int first, int last)

QMetaObject::Connection	connect (const QObject sender, const char signal, const char *method, Qt::ConnectionType type) const

virtual Q_INVOKABLE QVariant	data (const QModelIndex &index, int role=Qt::DisplayRole) const

QSqlDatabase	database () const

void	dataChanged (const QModelIndex &topLeft, const QModelIndex &bottomRight, const QVector< int > &roles)

void	deleteLater ()

void	destroyed (QObject *obj)

bool	disconnect (const char signal, const QObject receiver, const char *method) const

bool	disconnect (const QObject receiver, const char method) const

virtual Q_INVOKABLE bool	dropMimeData (const QMimeData *data, Qt::DropAction action, int row, int column, const QModelIndex &parent)

void	dumpObjectInfo ()

void	dumpObjectTree ()

QList< QByteArray >	dynamicPropertyNames () const

EditStrategy	editStrategy () const

virtual bool	event (QEvent *e)

virtual bool	eventFilter (QObject watched, QEvent event)

virtual Q_INVOKABLE void	fetchMore (const QModelIndex &parent=QModelIndex())

int	fieldIndex (const QString &fieldName) const

QString	filter () const

T	findChild (const QString &name, Qt::FindChildOptions options) const

QList< T >	findChildren (const QString &name, Qt::FindChildOptions options) const

QList< T >	findChildren (const QRegularExpression &re, Qt::FindChildOptions options) const

QList< T >	findChildren (const QRegExp &regExp, Qt::FindChildOptions options) const

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

Q_INVOKABLE QVariant	formatValue (const QVariant &dataValue, const QVariant &formatValue) const

virtual bool	hasChildren (const QModelIndex &parent) const

virtual Q_INVOKABLE bool	hasIndex (int row, int column, const QModelIndex &parent=QModelIndex()) const

virtual QVariant	headerData (int section, Qt::Orientation orientation, int role) const

void	headerDataChanged (Qt::Orientation orientation, int first, int last)

virtual Q_INVOKABLE QModelIndex	index (int row, int column, const QModelIndex &parent=QModelIndex()) const

bool	inherits (const char *className) const

virtual Q_INVOKABLE bool	insertColumn (int column, const QModelIndex &parent=QModelIndex())

virtual Q_INVOKABLE bool	insertColumns (int column, int count, const QModelIndex &parent=QModelIndex())

bool	insertRecord (int row, const QSqlRecord &record)

virtual Q_INVOKABLE bool	insertRow (int row, const QModelIndex &parent=QModelIndex())

virtual Q_INVOKABLE bool	insertRows (int row, int count, const QModelIndex &parent=QModelIndex())

void	installEventFilter (QObject *filterObj)

bool	isDirty (const QModelIndex &index) const

bool	isDirty () const

bool	isWidgetType () const

bool	isWindowType () const

virtual Q_INVOKABLE QMap< int, QVariant >	itemData (const QModelIndex &index) const

void	killTimer (int id)

virtual Q_INVOKABLE QSqlError	lastError () const

void	layoutAboutToBeChanged (const QList< QPersistentModelIndex > &parents, QAbstractItemModel::LayoutChangeHint hint)

void	layoutChanged (const QList< QPersistentModelIndex > &parents, QAbstractItemModel::LayoutChangeHint hint)

virtual Q_INVOKABLE void	load (int row)

virtual Q_INVOKABLE void	loadAll ()

virtual Q_INVOKABLE QModelIndexList	match (const QModelIndex &start, int role, const QVariant &value, int hits=1, Qt::MatchFlags flags=Qt::MatchFlags(Qt::MatchStartsWith\|Qt::MatchWrap)) const

virtual const QMetaObject *	metaObject () const

virtual Q_INVOKABLE QMimeData *	mimeData (const QModelIndexList &indexes) const

virtual Q_INVOKABLE QStringList	mimeTypes () const

void	modelAboutToBeReset ()

void	modelReset ()

bool	moveColumn (const QModelIndex &sourceParent, int sourceColumn, const QModelIndex &destinationParent, int destinationChild)

virtual bool	moveColumns (const QModelIndex &sourceParent, int sourceColumn, int count, const QModelIndex &destinationParent, int destinationChild)

bool	moveRow (const QModelIndex &sourceParent, int sourceRow, const QModelIndex &destinationParent, int destinationChild)

virtual bool	moveRows (const QModelIndex &sourceParent, int sourceRow, int count, const QModelIndex &destinationParent, int destinationChild)

void	moveToThread (QThread *targetThread)

virtual Q_INVOKABLE int	nodeCount () const

QString	objectName () const

void	objectNameChanged (const QString &objectName)

virtual Q_INVOKABLE ParameterList	parameters ()

QObject *	parent () const

virtual QModelIndex	parent (const QModelIndex &index) const =0

QSqlIndex	primaryKey () const

void	primeInsert (int row, QSqlRecord &record)

QVariant	property (const char *name) const

virtual Q_INVOKABLE QSqlQuery	query () const

QSqlRecord	record () const

QSqlRecord	record (int row) const

virtual Q_INVOKABLE QSqlRelation	relation (int column) const

virtual Q_INVOKABLE QSqlTableModel *	relationModel (int column) const

virtual Q_INVOKABLE void	removeChild (int index)

virtual Q_INVOKABLE bool	removeColumn (int column, const QModelIndex &parent=QModelIndex())

virtual bool	removeColumns (int column, int count, const QModelIndex &parent)

void	removeEventFilter (QObject *obj)

bool	removeRow (int row, const QModelIndex &parent)

virtual bool	removeRows (int row, int count, const QModelIndex &parent)

virtual void	revert ()

void	revertAll ()

virtual void	revertRow (int row)

virtual QHash< int, QByteArray >	roleNames () const

virtual int	rowCount (const QModelIndex &parent) const

void	rowsAboutToBeInserted (const QModelIndex &parent, int start, int end)

void	rowsAboutToBeMoved (const QModelIndex &sourceParent, int sourceStart, int sourceEnd, const QModelIndex &destinationParent, int destinationRow)

void	rowsAboutToBeRemoved (const QModelIndex &parent, int first, int last)

void	rowsInserted (const QModelIndex &parent, int first, int last)

void	rowsMoved (const QModelIndex &parent, int start, int end, const QModelIndex &destination, int row)

void	rowsRemoved (const QModelIndex &parent, int first, int last)

virtual Q_INVOKABLE bool	save ()

Q_INVOKABLE bool	select ()

virtual bool	selectRow (int row)

virtual Q_INVOKABLE QString	selectStatement () const

virtual Q_INVOKABLE void	set (ParameterList params)

Q_INVOKABLE void	setColumnRole (int column, int role, QVariant value)

Q_INVOKABLE bool	setData (const QModelIndex &index, const QVariant &value, int role=Qt::EditRole)

virtual void	setEditStrategy (EditStrategy strategy)

virtual void	setFilter (const QString &filter)

virtual Q_INVOKABLE bool	setHeaderData (int section, Qt::Orientation orientation, const QVariant &value, int role=Qt::EditRole)

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

void	setJoinMode (QSqlRelationalTableModel::JoinMode joinMode)

Q_INVOKABLE void	setKeys (int keyColumns)

void	setObjectName (const QString &name)

void	setParent (QObject *parent)

bool	setProperty (const char *name, const QVariant &value)

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

bool	setRecord (int row, const QSqlRecord &values)

virtual Q_INVOKABLE void	setRelation (int column, const QSqlRelation &relation)

virtual void	setSort (int column, Qt::SortOrder order)

void	setSupportedDragActions (Qt::DropActions actions)

virtual void	setTable (const QString &table)

virtual Q_INVOKABLE void	setTable (const QString &tableName, int keyColumns)

virtual Q_INVOKABLE QModelIndex	sibling (int row, int column, const QModelIndex &index) const

bool	signalsBlocked () const

virtual void	sort (int column, Qt::SortOrder order)

virtual Q_INVOKABLE QSize	span (const QModelIndex &index) const

int	startTimer (int interval, Qt::TimerType timerType)

virtual bool	submit ()

bool	submitAll ()

virtual Q_INVOKABLE Qt::DropActions	supportedDragActions () const

virtual Q_INVOKABLE Qt::DropActions	supportedDropActions () const

QString	tableName () const

QThread *	thread () const

virtual Q_INVOKABLE QString	toString () const

Static Public Member Functions
QMetaObject::Connection	connect (const QObject sender, const char signal, const QObject receiver, const char method, Qt::ConnectionType type)

QMetaObject::Connection	connect (const QObject sender, const QMetaMethod &signal, const QObject receiver, const QMetaMethod &method, Qt::ConnectionType type)

QMetaObject::Connection	connect (const QObject sender, PointerToMemberFunction signal, const QObject receiver, PointerToMemberFunction method, Qt::ConnectionType type)

QMetaObject::Connection	connect (const QObject *sender, PointerToMemberFunction signal, Functor functor)

QMetaObject::Connection	connect (const QObject sender, PointerToMemberFunction signal, const QObject context, Functor functor, Qt::ConnectionType type)

bool	disconnect (const QMetaObject::Connection &connection)

bool	disconnect (const QObject sender, const char signal, const QObject receiver, const char method)

bool	disconnect (const QObject sender, PointerToMemberFunction signal, const QObject receiver, PointerToMemberFunction method)

bool	disconnect (const QObject sender, const QMetaMethod &signal, const QObject receiver, const QMetaMethod &method)

QString	tr (const char sourceText, const char disambiguation, int n)

QString	trUtf8 (const char sourceText, const char disambiguation, int n)

Protected Member Functions
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 destinationChild)

bool	beginMoveRows (const QModelIndex &sourceParent, int sourceFirst, int sourceLast, const QModelIndex &destinationParent, int destinationChild)

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)

virtual void	childEvent (QChildEvent *event)

virtual void	connectNotify (const QMetaMethod &signal)

QModelIndex	createIndex (int row, int column, void *ptr) const

QModelIndex	createIndex (int row, int column, quintptr id) const

virtual void	customEvent (QEvent *event)

virtual bool	deleteRowFromTable (int row)

virtual void	disconnectNotify (const QMetaMethod &signal)

void	endInsertColumns ()

void	endInsertRows ()

void	endMoveColumns ()

void	endMoveRows ()

void	endRemoveColumns ()

void	endRemoveRows ()

void	endResetModel ()

virtual QModelIndex	indexInQuery (const QModelIndex &item) const

virtual bool	insertRowIntoTable (const QSqlRecord &values)

bool	isSignalConnected (const QMetaMethod &signal) const

virtual QString	orderByClause () const

QModelIndexList	persistentIndexList () const

QSqlRecord	primaryValues (int row) const

virtual void	queryChange ()

int	receivers (const char *signal) const

void	reset ()

void	resetInternalData ()

QObject *	sender () const

int	senderSignalIndex () const

void	setLastError (const QSqlError &error)

void	setPrimaryKey (const QSqlIndex &key)

void	setQuery (const QSqlQuery &query)

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

virtual void	timerEvent (QTimerEvent *event)

virtual bool	updateRowInTable (int row, const QSqlRecord &values)

Member Enumeration Documentation

enum XSqlTableModel::FormatFlags

Enumerator
Money
Qty
Curr
Percent
Cost
QtyPer
SalesPrice
PurchPrice
UOMRatio
ExtPrice
Weight

enum XSqlTableModel::itemDataRole

Enumerator
FormatRole
EditorRole
MenuRole

Constructor & Destructor Documentation

XSqlTableModel::XSqlTableModel ( QObject * parent = 0 )

XSqlTableModel::~XSqlTableModel ( )

Member Function Documentation

void XSqlTableModel::appendChild ( XSqlTableNode * child )

virtual

XSqlTableNode * XSqlTableModel::appendChild	(	const QString &	tableName,
		ParameterList &	relations
	)

virtual

void XSqlTableModel::applyColumnRole	(	int	column,
		int	role,
		QVariant	value
	)

void XSqlTableModel::applyColumnRoles ( )

void XSqlTableModel::applyColumnRoles ( int row )

QModelIndex XSqlTableModel::buddy ( const QModelIndex & index ) const

virtual

Reimplemented from QAbstractItemModel.

QString XSqlTableModel::buildFilter ( ParameterList & params )

ParameterList XSqlTableModel::buildParams	(	XSqlTableModel *	parent,
		int	row,
		ParameterList	relations
	)

bool XSqlTableModel::canFetchMore ( const QModelIndex & parent = QModelIndex() ) const

virtual

Reimplemented from QSqlQueryModel.

XSqlTableNode * XSqlTableModel::child ( int index )

virtual

XSqlTableNode * XSqlTableModel::child ( const QString & tableName )

virtual

QList< XSqlTableNode * > XSqlTableModel::children ( )

virtual

void XSqlTableModel::clear ( )

virtual

Reimplemented from QSqlRelationalTableModel.

void XSqlTableModel::clearChildren ( )

virtual

int XSqlTableModel::columnCount ( const QModelIndex & parent = QModelIndex() ) const

virtual

Reimplemented from QSqlQueryModel.

QVariant XSqlTableModel::data	(	const QModelIndex &	index,
		int	role = `Qt::DisplayRole`
	)		const

virtual

Reimplemented from QSqlRelationalTableModel.

bool XSqlTableModel::dropMimeData	(	const QMimeData *	data,
		Qt::DropAction	action,
		int	row,
		int	column,
		const QModelIndex &	parent
	)

virtual

Reimplemented from QAbstractTableModel.

void XSqlTableModel::fetchMore ( const QModelIndex & parent = QModelIndex() )

virtual

Reimplemented from QSqlQueryModel.

QVariant XSqlTableModel::formatValue	(	const QVariant &	dataValue,
		const QVariant &	formatValue
	)		const

bool XSqlTableModel::hasIndex	(	int	row,
		int	column,
		const QModelIndex &	parent = `QModelIndex()`
	)		const

virtual

QModelIndex XSqlTableModel::index	(	int	row,
		int	column,
		const QModelIndex &	parent = `QModelIndex()`
	)		const

virtual

Reimplemented from QAbstractTableModel.

bool XSqlTableModel::insertColumn	(	int	column,
		const QModelIndex &	parent = `QModelIndex()`
	)

virtual

bool XSqlTableModel::insertColumns	(	int	column,
		int	count,
		const QModelIndex &	parent = `QModelIndex()`
	)

virtual

Reimplemented from QSqlQueryModel.

bool XSqlTableModel::insertRow	(	int	row,
		const QModelIndex &	parent = `QModelIndex()`
	)

virtual

bool XSqlTableModel::insertRows	(	int	row,
		int	count,
		const QModelIndex &	parent = `QModelIndex()`
	)

virtual

Reimplemented from QSqlTableModel.

QMap< int, QVariant > XSqlTableModel::itemData ( const QModelIndex & index ) const

virtual

Reimplemented from QAbstractItemModel.

QSqlError XSqlTableModel::lastError ( ) const

virtual

void XSqlTableModel::load ( int row )

virtual

void XSqlTableModel::loadAll ( )

virtual

QModelIndexList XSqlTableModel::match	(	const QModelIndex &	start,
		int	role,
		const QVariant &	value,
		int	hits = `1`,
		Qt::MatchFlags	flags = `Qt::MatchFlags(Qt::MatchStartsWith \| Qt::MatchWrap)`
	)		const

virtual

Reimplemented from QAbstractItemModel.

QMimeData * XSqlTableModel::mimeData ( const QModelIndexList & indexes ) const

virtual

Reimplemented from QAbstractItemModel.

QStringList XSqlTableModel::mimeTypes ( ) const

virtual

Reimplemented from QAbstractItemModel.

int XSqlTableModel::nodeCount ( ) const

virtual

ParameterList XSqlTableModel::parameters ( )

virtual

QSqlQuery XSqlTableModel::query ( ) const

virtual

QSqlRelation XSqlTableModel::relation ( int column ) const

virtual

QSqlTableModel * XSqlTableModel::relationModel ( int column ) const

virtual

Reimplemented from QSqlRelationalTableModel.

void XSqlTableModel::removeChild ( int index )

virtual

bool XSqlTableModel::removeColumn	(	int	column,
		const QModelIndex &	parent = `QModelIndex()`
	)

virtual

bool XSqlTableModel::save ( )

virtual

Saves the current model and all of it's child node models to the database where a\ transact wraps all submissions in a database transaction.

bool XSqlTableModel::select ( )

virtual

Reimplemented from QSqlRelationalTableModel.

QString XSqlTableModel::selectStatement ( ) const

virtual

Reimplemented from QSqlRelationalTableModel.

void XSqlTableModel::set ( ParameterList params )

virtual

void XSqlTableModel::setColumnRole	(	int	column,
		int	role,
		QVariant	value
	)

bool XSqlTableModel::setData	(	const QModelIndex &	index,
		const QVariant &	value,
		int	role = `Qt::EditRole`
	)

virtual

Reimplemented from QSqlRelationalTableModel.

bool XSqlTableModel::setHeaderData	(	int	section,
		Qt::Orientation	orientation,
		const QVariant &	value,
		int	role = `Qt::EditRole`
	)

virtual

Reimplemented from QSqlQueryModel.

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

virtual

Reimplemented from QAbstractItemModel.

void XSqlTableModel::setKeys ( int keyColumns )

void XSqlTableModel::setRelation	(	int	column,
		const QSqlRelation &	relation
	)

virtual

Reimplemented from QSqlRelationalTableModel.

void XSqlTableModel::setTable	(	const QString &	tableName,
		int	keyColumns
	)

virtual

QModelIndex XSqlTableModel::sibling	(	int	row,
		int	column,
		const QModelIndex &	index
	)		const

virtual

Reimplemented from QAbstractTableModel.

QSize XSqlTableModel::span ( const QModelIndex & index ) const

virtual

Reimplemented from QAbstractItemModel.

Qt::DropActions XSqlTableModel::supportedDragActions ( ) const

virtual

Reimplemented from QAbstractItemModel.

Qt::DropActions XSqlTableModel::supportedDropActions ( ) const

virtual

Reimplemented from QAbstractItemModel.

QString XSqlTableModel::toString ( ) const

virtual

The documentation for this class was generated from the following files:

xsqltablemodel.h
xsqltablemodel.cpp

Public Types

Properties

Public Member Functions

Static Public Member Functions

Protected Member Functions

Member Enumeration Documentation

Constructor & Destructor Documentation

Member Function Documentation