Query Builder for search strings. More...

#include <qgssearchquerybuilder.h>

Collaboration diagram for QgsSearchQueryBuilder:

Public Slots
void	on_btnEqual_clicked ()
void	on_btnOk_clicked ()
void	on_btnLessThan_clicked ()
void	on_btnGreaterThan_clicked ()
void	on_btnLike_clicked ()
void	on_btnILike_clicked ()
void	on_btnPct_clicked ()
void	on_btnIn_clicked ()
void	on_btnNotIn_clicked ()
void	on_lstFields_doubleClicked (const QModelIndex &index)
void	on_lstValues_doubleClicked (const QModelIndex &index)
void	on_btnLessEqual_clicked ()
void	on_btnGreaterEqual_clicked ()
void	on_btnNotEqual_clicked ()
void	on_btnAnd_clicked ()
void	on_btnNot_clicked ()
void	on_btnOr_clicked ()
void	on_btnClear_clicked ()
void	on_btnTest_clicked ()
void	on_btnGetAllValues_clicked ()
void	on_btnSampleValues_clicked ()
void	on_buttonBox_helpRequested ()
void	saveQuery ()
void	loadQuery ()

Public Member Functions
	QgsSearchQueryBuilder (QgsVectorLayer layer, QWidget parent=0, Qt::WFlags fl=QgisGui::ModalDialogFlags)
	Constructor - takes pointer to vector layer as a parameter.
	~QgsSearchQueryBuilder ()
QString	searchString ()
	returns newly created search string
void	setSearchString (QString searchString)
	change search string shown in text field

Private Member Functions
void	populateFields ()
void	setupListViews ()
long	countRecords (QString sql)
void	getFieldValues (int limit)

Private Attributes
QgsVectorLayer *	mLayer
	Layer for which is the query builder opened.
QMap< QString, int >	mFieldMap
	Map that holds field information, keyed by field name.
QStandardItemModel *	mModelFields
	Model for fields ListView.
QStandardItemModel *	mModelValues
	Model for values ListView.

Detailed Description

Query Builder for search strings.

Definition at line 36 of file qgssearchquerybuilder.h.

Constructor & Destructor Documentation

QgsSearchQueryBuilder::QgsSearchQueryBuilder	(	QgsVectorLayer *	layer,
		QWidget *	parent = `0`,
		Qt::WFlags	fl = `QgisGui::ModalDialogFlags`
	)

Constructor - takes pointer to vector layer as a parameter.

Definition at line 33 of file qgssearchquerybuilder.cpp.

References loadQuery(), QgsMapLayer::name(), on_btnClear_clicked(), on_btnTest_clicked(), populateFields(), saveQuery(), setupListViews(), and tr.

QgsSearchQueryBuilder::~QgsSearchQueryBuilder ( )

Definition at line 65 of file qgssearchquerybuilder.cpp.

Member Function Documentation

long QgsSearchQueryBuilder::countRecords ( QString sql )

private

Get the number of records that would be returned by the current SQL

Returns: Number of records or -1 if an error was encountered

Definition at line 186 of file qgssearchquerybuilder.cpp.

References QgsExpression::evalErrorString(), QgsExpression::evaluate(), QgsVectorLayer::getFeatures(), QgsExpression::hasEvalError(), QgsExpression::hasParserError(), mLayer, QgsExpression::needsGeometry(), QgsFeatureIterator::nextFeature(), QgsFeatureRequest::NoFlags, QgsFeatureRequest::NoGeometry, QgsExpression::parserErrorString(), QgsVectorLayer::pendingFields(), QgsExpression::prepare(), and tr.

Referenced by on_btnOk_clicked(), and on_btnTest_clicked().

void QgsSearchQueryBuilder::getFieldValues ( int limit )

private

populates list box with values of selected field

Parameters

limit if not zero, inserts only this count of values

MH: keep already inserted values in a set. Querying is much faster compared to QStandardItemModel::findItems

Definition at line 105 of file qgssearchquerybuilder.cpp.

References QgsFeature::attribute(), QgsVectorLayer::getFeatures(), mFieldMap, mLayer, mModelFields, mModelValues, QgsFeatureIterator::nextFeature(), QgsFeatureRequest::NoGeometry, QgsVectorLayer::pendingFields(), and QgsField::type().

Referenced by on_btnGetAllValues_clicked(), and on_btnSampleValues_clicked().

void QgsSearchQueryBuilder::loadQuery ( )

slot

Definition at line 396 of file qgssearchquerybuilder.cpp.

References QgsExpression::hasParserError(), mFieldMap, QgsExpression::parserErrorString(), and tr.

Referenced by QgsSearchQueryBuilder().

void QgsSearchQueryBuilder::on_btnAnd_clicked ( )

slot

Definition at line 335 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnClear_clicked ( )

slot

Definition at line 350 of file qgssearchquerybuilder.cpp.

Referenced by QgsSearchQueryBuilder().

void QgsSearchQueryBuilder::on_btnEqual_clicked ( )

slot

Definition at line 265 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnGetAllValues_clicked ( )

slot

Get all distinct values for the field. Values are inserted into the value list box

Definition at line 169 of file qgssearchquerybuilder.cpp.

References getFieldValues().

void QgsSearchQueryBuilder::on_btnGreaterEqual_clicked ( )

slot

Definition at line 325 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnGreaterThan_clicked ( )

slot

Definition at line 275 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnILike_clicked ( )

slot

Definition at line 355 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnIn_clicked ( )

slot

Definition at line 285 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnLessEqual_clicked ( )

slot

Definition at line 320 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnLessThan_clicked ( )

slot

Definition at line 270 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnLike_clicked ( )

slot

Definition at line 295 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnNot_clicked ( )

slot

Definition at line 340 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnNotEqual_clicked ( )

slot

Definition at line 330 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnNotIn_clicked ( )

slot

Definition at line 290 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnOk_clicked ( )

slot

Definition at line 239 of file qgssearchquerybuilder.cpp.

References countRecords(), and tr.

void QgsSearchQueryBuilder::on_btnOr_clicked ( )

slot

Definition at line 345 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnPct_clicked ( )

slot

Definition at line 280 of file qgssearchquerybuilder.cpp.

void QgsSearchQueryBuilder::on_btnSampleValues_clicked ( )

slot

Get sample distinct values for the selected field. The sample size is limited to an arbitrary value (currently set to 25). The values are inserted into the values list box.

Definition at line 164 of file qgssearchquerybuilder.cpp.

References getFieldValues().

void QgsSearchQueryBuilder::on_btnTest_clicked ( )

slot

Test the constructed search string to see if it's correct. The number of rows that would be returned is displayed in a message box.

Definition at line 174 of file qgssearchquerybuilder.cpp.

References countRecords(), and tr.

Referenced by QgsSearchQueryBuilder().

void QgsSearchQueryBuilder::on_buttonBox_helpRequested ( )

inlineslot

Definition at line 92 of file qgssearchquerybuilder.h.

References QgsContextHelp::run().