sqldatabase_snippet.cpp File Reference

Go to the source code of this file.

Classes
class	MyModel

Functions
model	setQuery ("SELECT name, salary FROM employee")
model	setHeaderData (0, Qt::Horizontal, tr("Name"))
model	setHeaderData (1, Qt::Horizontal, tr("Salary"))
view	setModel (model)
	[17] //! [18]
view	show ()
	[18] //! [19]
view	setEditTriggers (QAbstractItemView::NoEditTriggers)
	[16] //! [19] //! [20]
	Q_UNUSED (salary)
	for (int row=0;row< model.rowCount();++row)
	[3]
void	QSqlTableModel_snippets ()
int	main (int argc, char **argv)
	[0]

Variables
QSqlQueryModel *	model = new QSqlQueryModel
	[16]
QTableView *	view = new QTableView
	[17]
int	salary = model.record(4).value("salary").toInt()

Function Documentation

for()

for

(

)

[3]

[4]

Definition at line 30 of file sqldatabase_snippet.cpp.

References QSqlQueryModel::columnCount(), QSqlQueryModel::data(), QAbstractTableModel::index(), model, and qDebug.

Here is the call graph for this function:

main()

int main	(	int	argc,
		char **	argv
	)

[0]

[0]

[0]

[6]

[0]

[0]

[1]

[1]

[2]

[2]

[3]

[3]

[0]

[0]

[1]

[1]

[0]

[0]

[0]

[0]

Definition at line 72 of file sqldatabase_snippet.cpp.

References app, QSqlDatabase_snippets(), QSqlField_snippets(), QSqlQuery_snippets(), QSqlQueryModel_snippets(), and QSqlTableModel_snippets().

Here is the call graph for this function:

Q_UNUSED()

Q_UNUSED

(

salary

)

Initial value:

{
    int salary = model.data(model.index(4, 1)).toInt()

QSqlTableModel_snippets()

void QSqlTableModel_snippets

(

)

[24]

[24]

Definition at line 54 of file sqldatabase_snippet.cpp.

References QTableView::hideColumn(), Qt::Horizontal, model, QSqlTableModel::OnManualSubmit, QSqlQueryModel::setHeaderData(), QTableView::setModel(), tr, and view.

Referenced by main().

Here is the call graph for this function:

Here is the caller graph for this function:

setEditTriggers()

view setEditTriggers

(

QAbstractItemView::NoEditTriggers

)

[16] //! [19] //! [20]

setHeaderData() [1/2]

model setHeaderData	(	0	,
		Qt::Horizontal	,
		tr("Name")
	)

setHeaderData() [2/2]

model setHeaderData	(	1	,
		Qt::Horizontal	,
		tr("Salary")
	)

setModel()

view setModel

(

model

)

[17] //! [18]

setQuery()

model setQuery	(	"SELECT	name,
		salary FROM employee"
	)

show()

view show

(

)

[18] //! [19]

Referenced by QtAndroidDialogHelpers::QAndroidPlatformMessageDialogHelper::exec(), if(), QSplitterPrivate::insertWidget_helper(), QTreeView::setRootIsDecorated(), QListView::setSelectionRectVisible(), FileInfoThread::setShowDirsFirst(), FileInfoThread::setShowFiles(), QTableView::setShowGrid(), QHeaderView::setSortIndicatorShown(), and QtPrivate::QCalendarModel::setWeekNumbersShown().

Here is the caller graph for this function:

Variable Documentation

model

QSqlQueryModel model = new QSqlQueryModel

[16]

[20]

Definition at line 5 of file sqldatabase_snippet.cpp.

Referenced by MutableModelIterator::MutableModelIterator(), QCompleter::QCompleter(), QListWidgetItem::QListWidgetItem(), QListWidgetItem::QListWidgetItem(), QListWidgetItem::QListWidgetItem(), QQmlDelegateModelGroup::QQmlDelegateModelGroup(), QTreeWidgetItem::QTreeWidgetItem(), QTreeWidgetItem::QTreeWidgetItem(), QTreeWidgetItem::QTreeWidgetItem(), QTreeWidgetItemIterator::QTreeWidgetItemIterator(), QTreeWidgetItemIterator::QTreeWidgetItemIterator(), Widget::Widget(), QListWidgetItem::~QListWidgetItem(), QTableWidgetItem::~QTableWidgetItem(), QTreeWidgetItem::~QTreeWidgetItem(), QItemSelectionModelPrivate::_q_columnsAboutToBeInserted(), QItemSelectionModelPrivate::_q_columnsAboutToBeRemoved(), QItemSelectionModelPrivate::_q_layoutAboutToBeChanged(), QItemSelectionModelPrivate::_q_layoutChanged(), QItemSelectionModelPrivate::_q_modelDestroyed(), QItemSelectionModelPrivate::_q_rowsAboutToBeInserted(), QItemSelectionModelPrivate::_q_rowsAboutToBeRemoved(), QConcatenateTablesProxyModelPrivate::_q_slotColumnsAboutToBeInserted(), QConcatenateTablesProxyModelPrivate::_q_slotColumnsAboutToBeRemoved(), QConcatenateTablesProxyModelPrivate::_q_slotRowsAboutToBeInserted(), QConcatenateTablesProxyModelPrivate::_q_slotRowsAboutToBeRemoved(), QIdentityProxyModelPrivate::_q_sourceColumnsAboutToBeInserted(), QIdentityProxyModelPrivate::_q_sourceColumnsAboutToBeMoved(), QIdentityProxyModelPrivate::_q_sourceColumnsAboutToBeRemoved(), QIdentityProxyModelPrivate::_q_sourceColumnsInserted(), QSortFilterProxyModelPrivate::_q_sourceColumnsInserted(), QIdentityProxyModelPrivate::_q_sourceColumnsMoved(), QIdentityProxyModelPrivate::_q_sourceColumnsRemoved(), QSortFilterProxyModelPrivate::_q_sourceColumnsRemoved(), QIdentityProxyModelPrivate::_q_sourceDataChanged(), QAbstractProxyModelPrivate::_q_sourceModelColumnsAboutToBeInserted(), QAbstractProxyModelPrivate::_q_sourceModelColumnsRemoved(), QAbstractProxyModelPrivate::_q_sourceModelRowsAboutToBeInserted(), QAbstractProxyModelPrivate::_q_sourceModelRowsRemoved(), QIdentityProxyModelPrivate::_q_sourceRowsAboutToBeInserted(), QIdentityProxyModelPrivate::_q_sourceRowsAboutToBeMoved(), QIdentityProxyModelPrivate::_q_sourceRowsAboutToBeRemoved(), QIdentityProxyModelPrivate::_q_sourceRowsInserted(), QIdentityProxyModelPrivate::_q_sourceRowsMoved(), QIdentityProxyModelPrivate::_q_sourceRowsRemoved(), QTreeViewPrivate::accessibleTable2Index(), QQmlDelegateModelGroup::addGroups(), applyToModels(), boxBoundsRecursive(), checkSqlQueryModel(), QSSGRhiContext::cleanupDrawCallData(), cleanupResourcesImpl(), QConcatenateTablesProxyModelPrivate::columnCountAfterChange(), QQmlTableModel::columns_append(), QQmlTableModel::columns_at(), QQmlTableModel::columns_clear(), QQmlTableModel::columns_count(), QQmlTableModel::columns_removeLast(), QQmlTableModel::columns_replace(), QConcatenateTablesProxyModelPrivate::computeRowsPrior(), QQmlPartsModel::count(), QPersistentModelIndexData::create(), QQmlDelegateModelGroup::create(), QSortFilterProxyModelPrivate::create_mapping(), VDMObjectDelegateDataType::createItem(), QPersistentModelIndexData::destroy(), QtAndroid::deviceName(), QItemDelegate::editorEvent(), QStyledItemDelegate::editorEvent(), QComboMenuDelegate::editorEvent(), emitHeaderDataChanged(), QQmlPartsModel::emitModelUpdated(), QItemSelectionModelPrivate::expandSelection(), MyModel::fetchModel(), QSortedModelEngine::filter(), QUnsortedModelEngine::filter(), QCompletionEngine::filter(), QUnsortedModelEngine::filterOnDemand(), QSortFilterProxyModelPrivate::find_source_sort_column(), findFamilyInModel(), findStyleInModel(), for(), QQmlDelegateModelGroup::get(), QSSGRenderNode::getBounds(), QSSGBufferManager::getMeshForPicking(), QSSGBufferManager::getModelBounds(), QQuickViewTestUtils::ListRange::getModelDataValues(), ListModel::getOrCreateModelObject(), QQmlPartsModel::incubationStatus(), QSortedModelEngine::indexHint(), QV4::Heap::ModelObject::init(), VDMObjectDelegateDataType::initializeMetaType(), QItemSelectionModelPrivate::initModel(), QQmlDelegateModelGroup::insert(), QTreeWidgetItem::insertChild(), QTreeWidgetItem::insertChildren(), QSSGRhiContext::instanceBufferData(), QSSGRenderer::intersectRayWithSubsetRenderable(), QItemSelectionRange::intersects(), QTableViewPrivate::isCellEnabled(), QTreeWidgetItem::isExpanded(), QTreeWidgetItem::isFirstColumnSpanned(), QTreeWidgetItem::isHidden(), QListViewPrivate::isHidden(), QAbstractItemViewPrivate::isIndexEnabled(), QAbstractItemViewPrivate::isIndexSelectable(), QAbstractItemViewPrivate::isIndexValid(), QAbstractItemViewPrivate::isPersistent(), QListWidgetItem::isSelected(), QTableWidgetItem::isSelected(), QSSGLightmapper::lightmapAssetPathForLoad(), QSSGLightmapper::lightmapAssetPathForSave(), QListViewPrivate::listViewItemToIndex(), QSSGBufferManager::loadLightmap(), QSSGBufferManager::loadMesh(), main(), main(), QAbstractProxyModelPrivate::mapDropCoordinatesToSource(), QQmlDelegateModelAttachedMetaObject::metaCall(), QListViewPrivate::modelIndex(), QQmlDelegateModelGroup::move(), VDMObjectDelegateDataType::notify(), QQmlPartsModel::object(), QSSGLayerRenderData::prepareModelsForRender(), QSSGParticleRenderer::prepareParticlesForModel(), DynamicRoleModelNodeMetaObject::propertyWrite(), QSortFilterProxyModelPrivate::proxy_intervals_for_source_items_to_add(), QSortFilterProxyModelPrivate::proxy_to_source(), proxyModelSetter(), QPhysicsWorld::Q_REVISION(), QSqlQueryModel_snippets(), QSqlTableModel_snippets(), qt_mac_toQBrush(), qt_mac_toQColor(), QSortFilterProxyModelPrivate::recursiveChildAcceptsRow(), QQuick3DParticleSystem::registerParticle(), QQmlPartsModel::release(), QQmlDelegateModelGroup::remove(), QQmlDelegateModelGroup::removeGroups(), QQmlDelegateModelGroup::resolve(), VDMObjectDelegateDataType::rowCount(), QItemSelectionModel::selectedRows(), QQuickFontDialogImplAttached::selectFontInListViews(), QTreeWidgetItem::setData(), QListWidgetItem::setData(), QTableWidgetItem::setData(), QSpatialSound::setDistanceModel(), QQuick3DSpatialSound::setDistanceModel(), QTreeWidgetItem::setExpanded(), QUrlModel::setFileSystemModel(), QTreeWidgetItem::setFirstColumnSpanned(), QListWidgetItem::setFlags(), QTableWidgetItem::setFlags(), QQmlDelegateModelGroup::setGroups(), QTreeWidgetItem::setHidden(), QCompleter::setModel(), QItemDelegate::setModelData(), QStyledItemDelegate::setModelData(), QListWidgetItem::setSelected(), QTableWidgetItem::setSelected(), QTreeWidgetItem::setSelected(), QComboBoxDelegate::setSeparator(), QQmlPartsModel::setWatchedRoles(), QSortFilterProxyModelPrivate::sort_source_rows(), QTreeWidgetItemPrivate::sortChildren(), QSortedModelEngine::sortOrder(), QSortFilterProxyModelPrivate::source_items_inserted(), QSortFilterProxyModelPrivate::source_to_proxy(), QConcatenateTablesProxyModelPrivate::sourceModelForRow(), QItemSelection::split(), sql_intro_snippets(), QTreeWidgetItem::takeChild(), QTreeWidgetItem::takeChildren(), QTestPrivate::testDataGuiRoles(), QQuick3DParticleSystem::unRegisterParticle(), QQuick3DSceneManager::updateBoundingBoxes(), QSortFilterProxyModelPrivate::updateChildrenMapping(), QQmlDelegateModelPrivate::updateFilterGroup(), QQmlPartsModel::updateFilterGroup(), QTreeWidgetItemPrivate::updateHiddenStatus(), QQuick3DParticleModelBlendParticle::updateSpatialNode(), QSSGParticleRenderer::updateUniformsForParticleModel(), VDMObjectDelegateDataType::value(), QQmlDelegateModelPrivate::variantValue(), src_gui_itemviews_qstandarditemmodel::wrapper0(), src_gui_itemviews_qstandarditemmodel::wrapper1(), and QSSGQmlUtilities::writeQml().

salary

int salary = model.record(4).value("salary").toInt()

Definition at line 22 of file sqldatabase_snippet.cpp.

Referenced by QSqlQueryModel_snippets(), QSqlTableModel_snippets(), and sql_intro_snippets().

view

QTableView* view = new QTableView

[17]

Definition at line 10 of file sqldatabase_snippet.cpp.

Referenced by QSqlTableModel_snippets().