sqldatabase_snippet.cpp File Reference

(69d4ecd6ef9057cb3703178277042ff7a7411459)

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(), QQuickToolTipAttached::setVisible(), 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(), QSortFilterProxyModelPrivate::_q_sourceColumnsInserted(), QSortFilterProxyModelPrivate::_q_sourceColumnsRemoved(), QAbstractProxyModelPrivate::_q_sourceModelColumnsAboutToBeInserted(), QAbstractProxyModelPrivate::_q_sourceModelColumnsRemoved(), QAbstractProxyModelPrivate::_q_sourceModelRowsAboutToBeInserted(), QAbstractProxyModelPrivate::_q_sourceModelRowsRemoved(), QTreeViewPrivate::accessibleTable2Index(), QQmlDelegateModelGroup::addGroups(), applyToModels(), boxBoundsRecursive(), checkSqlQueryModel(), QSSGRhiContextPrivate::cleanupDrawCallData(), cleanupResourcesImpl(), QConcatenateTablesProxyModelPrivate::columnCountAfterChange(), QQmlTableModel::columns_append(), QQmlTableModel::columns_at(), QQmlTableModel::columns_clear(), QQmlTableModel::columns_count(), QQmlTableModel::columns_removeLast(), QQmlTableModel::columns_replace(), QItemSelectionModelPrivate::columnsAboutToBeInserted(), QItemSelectionModelPrivate::columnsAboutToBeRemoved(), QConcatenateTablesProxyModelPrivate::computeRowsPrior(), QQmlPartsModel::count(), QPersistentModelIndexData::create(), QQmlDelegateModelGroup::create(), QSortFilterProxyModelPrivate::create_mapping(), VDMObjectDelegateDataType::createItem(), QPersistentModelIndexData::destroy(), QtAndroid::deviceName(), QItemDelegate::editorEvent(), QStyledItemDelegate::editorEvent(), QComboMenuDelegate::editorEvent(), 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(), QSSGModelHelpers::getGlobalOpacity(), QSSGModelHelpers::getGlobalOpacity(), QSSGLayerRenderData::getGlobalOpacity(), QSSGModelHelpers::getGlobalTransform(), QSSGLayerRenderData::getGlobalTransform(), QSSGModelHelpers::getLocalOpacity(), QSSGModelHelpers::getLocalTransform(), 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(), QSSGRhiContextPrivate::instanceBufferData(), QSSGRendererPrivate::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(), QItemSelectionModelPrivate::layoutAboutToBeChanged(), QItemSelectionModelPrivate::layoutChanged(), QSSGLightmapper::lightmapAssetPathForLoad(), QSSGLightmapper::lightmapAssetPathForSave(), QListViewPrivate::listViewItemToIndex(), QSSGBufferManager::loadLightmap(), QSSGBufferManager::loadMesh(), main(), main(), QAbstractProxyModelPrivate::mapDropCoordinatesToSource(), QQmlDelegateModelAttachedMetaObject::metaCall(), QItemSelectionModelPrivate::modelDestroyed(), QListViewPrivate::modelIndex(), QQmlDelegateModelGroup::move(), VDMObjectDelegateDataType::notify(), QQmlPartsModel::object(), prepareModelMaterialsImpl(), QSSGLayerRenderData::prepareModelsForRender(), QSSGParticleRenderer::prepareParticlesForModel(), DynamicRoleModelNodeMetaObject::propertyWrite(), QSortFilterProxyModelPrivate::proxy_intervals_for_source_items_to_add(), QSortFilterProxyModelPrivate::proxy_to_source(), proxyModelSetter(), QSqlQueryModel_snippets(), QSqlTableModel_snippets(), qt_mac_toQBrush(), qt_mac_toQColor(), QSortFilterProxyModelPrivate::recursiveChildAcceptsRow(), QQuick3DParticleSystem::registerParticle(), QQmlPartsModel::release(), QQmlDelegateModelGroup::remove(), QQmlDelegateModelGroup::removeGroups(), QQmlDelegateModelGroup::resolve(), VDMObjectDelegateDataType::rowCount(), QItemSelectionModelPrivate::rowsAboutToBeInserted(), QItemSelectionModelPrivate::rowsAboutToBeRemoved(), QItemSelectionModel::selectedRows(), QQuickFontDialogImplAttached::selectFontInListViews(), QPdfWriter::setColorModel(), QTreeWidgetItem::setData(), QListWidgetItem::setData(), QTableWidgetItem::setData(), QSpatialSound::setDistanceModel(), QQuick3DSpatialSound::setDistanceModel(), QTreeWidgetItem::setExpanded(), QUrlModel::setFileSystemModel(), QTreeWidgetItem::setFirstColumnSpanned(), QListWidgetItem::setFlags(), QTableWidgetItem::setFlags(), QSSGModelHelpers::setGlobalOpacity(), QSSGLayerRenderData::setGlobalOpacity(), QSSGModelHelpers::setGlobalTransform(), QSSGLayerRenderData::setGlobalTransform(), QQmlDelegateModelGroup::setGroups(), QTreeWidgetItem::setHidden(), QCompleter::setModel(), SpinBoxDelegate::setModelData(), QItemDelegate::setModelData(), QStyledItemDelegate::setModelData(), QSSGModelHelpers::setModelMaterials(), QSSGLayerRenderData::setModelMaterials(), QListWidgetItem::setSelected(), QTableWidgetItem::setSelected(), QTreeWidgetItem::setSelected(), QComboBoxDelegate::setSeparator(), QQmlPartsModel::setWatchedRoles(), QConcatenateTablesProxyModelPrivate::slotColumnsAboutToBeInserted(), QConcatenateTablesProxyModelPrivate::slotColumnsAboutToBeRemoved(), QConcatenateTablesProxyModelPrivate::slotRowsAboutToBeInserted(), QConcatenateTablesProxyModelPrivate::slotRowsAboutToBeRemoved(), QSortFilterProxyModelPrivate::sort_source_rows(), QTreeWidgetItemPrivate::sortChildren(), QSortedModelEngine::sortOrder(), QSortFilterProxyModelPrivate::source_items_inserted(), QSortFilterProxyModelPrivate::source_to_proxy(), QIdentityProxyModelPrivate::sourceColumnsAboutToBeInserted(), QIdentityProxyModelPrivate::sourceColumnsAboutToBeMoved(), QIdentityProxyModelPrivate::sourceColumnsAboutToBeRemoved(), QIdentityProxyModelPrivate::sourceColumnsInserted(), QIdentityProxyModelPrivate::sourceColumnsMoved(), QIdentityProxyModelPrivate::sourceColumnsRemoved(), QIdentityProxyModelPrivate::sourceDataChanged(), QConcatenateTablesProxyModelPrivate::sourceModelForRow(), QIdentityProxyModelPrivate::sourceRowsAboutToBeInserted(), QIdentityProxyModelPrivate::sourceRowsAboutToBeMoved(), QIdentityProxyModelPrivate::sourceRowsAboutToBeRemoved(), QIdentityProxyModelPrivate::sourceRowsInserted(), QIdentityProxyModelPrivate::sourceRowsMoved(), QIdentityProxyModelPrivate::sourceRowsRemoved(), 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().