Quantum GIS API Documentation
1.8
|
Query Builder for layers. More...
#include <qgsquerybuilder.h>
Public Slots | |
void | accept () |
void | reject () |
void | clear () |
void | on_btnEqual_clicked () |
void | on_btnLessThan_clicked () |
void | on_btnGreaterThan_clicked () |
void | on_btnPct_clicked () |
void | on_btnIn_clicked () |
void | on_btnNotIn_clicked () |
void | on_btnLike_clicked () |
void | on_btnILike_clicked () |
QString | sql () |
void | setSql (QString sqlStatement) |
void | on_lstFields_clicked (const QModelIndex &index) |
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_buttonBox_helpRequested () |
void | test () |
void | on_btnGetAllValues_clicked () |
void | on_btnSampleValues_clicked () |
void | setDatasourceDescription (QString uri) |
Public Member Functions | |
QgsQueryBuilder (QString tableName, QWidget *parent=0, Qt::WFlags fl=QgisGui::ModalDialogFlags) | |
QgsQueryBuilder (QgsVectorLayer *layer, QWidget *parent=0, Qt::WFlags fl=QgisGui::ModalDialogFlags) | |
~QgsQueryBuilder () | |
Private Member Functions | |
void | populateFields () |
void | setupGuiViews () |
void | setupLstFieldsModel () |
void | fillValues (int idx, int limit) |
Private Attributes | |
QStandardItemModel * | mModelFields |
Model for fields ListView. | |
QStandardItemModel * | mModelValues |
Model for values ListView. | |
int | mPreviousFieldRow |
Previous field row to delete model. | |
QgsVectorLayer * | mLayer |
vector layer | |
QString | mOrigSubsetString |
original subset string |
Query Builder for layers.
The query builder allows interactive creation of a SQL for limiting the features displayed in a database layer. The fields in the table are displayed and sample values (or all values) can be viewed to aid in constructing the query. A test function returns the number of features that will be returned.
Definition at line 40 of file qgsquerybuilder.h.
QgsQueryBuilder::QgsQueryBuilder | ( | QString | tableName, |
QWidget * | parent = 0 , |
||
Qt::WFlags | fl = QgisGui::ModalDialogFlags |
||
) |
Constructor which takes the table name. This constructor is used when adding layers to the map since the query builder connection as the layer selection dialog.
tableName | Name of the table being queried |
parent | Parent widget |
fl | dialog flags |
QgsQueryBuilder::QgsQueryBuilder | ( | QgsVectorLayer * | layer, |
QWidget * | parent = 0 , |
||
Qt::WFlags | fl = QgisGui::ModalDialogFlags |
||
) |
This constructor is used when the query builder is called from the vector layer properties dialog
layer | existing vector layer |
parent | Parent widget |
fl | dialog flags |
Definition at line 27 of file qgsquerybuilder.cpp.
References clear(), mOrigSubsetString, QgsMapLayer::name(), populateFields(), setupGuiViews(), QgsVectorLayer::subsetString(), and test().
Definition at line 56 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::accept | ( | ) | [slot] |
Definition at line 182 of file qgsquerybuilder.cpp.
References QgsVectorDataProvider::clearErrors(), QgsVectorLayer::dataProvider(), QgsVectorDataProvider::errors(), QgsVectorDataProvider::hasErrors(), mLayer, and QgsVectorLayer::setSubsetString().
void QgsQueryBuilder::clear | ( | ) | [slot] |
Definition at line 318 of file qgsquerybuilder.cpp.
References mLayer, and QgsVectorLayer::setSubsetString().
Referenced by QgsQueryBuilder().
void QgsQueryBuilder::fillValues | ( | int | idx, |
int | limit | ||
) | [private] |
Definition at line 99 of file qgsquerybuilder.cpp.
References isNull(), mLayer, mModelValues, QgsDebugMsg, and QgsVectorLayer::uniqueValues().
Referenced by on_btnGetAllValues_clicked(), and on_btnSampleValues_clicked().
void QgsQueryBuilder::on_btnAnd_clicked | ( | ) | [slot] |
Definition at line 303 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnEqual_clicked | ( | ) | [slot] |
Definition at line 214 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnGetAllValues_clicked | ( | ) | [slot] |
Get all distinct values for the field. Values are inserted into the value list box
Definition at line 139 of file qgsquerybuilder.cpp.
References fillValues(), mModelFields, and mModelValues.
void QgsQueryBuilder::on_btnGreaterEqual_clicked | ( | ) | [slot] |
Definition at line 293 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnGreaterThan_clicked | ( | ) | [slot] |
Definition at line 224 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnILike_clicked | ( | ) | [slot] |
Definition at line 324 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnIn_clicked | ( | ) | [slot] |
Definition at line 234 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnLessEqual_clicked | ( | ) | [slot] |
Definition at line 288 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnLessThan_clicked | ( | ) | [slot] |
Definition at line 219 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnLike_clicked | ( | ) | [slot] |
Definition at line 244 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnNot_clicked | ( | ) | [slot] |
Definition at line 308 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnNotEqual_clicked | ( | ) | [slot] |
Definition at line 298 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnNotIn_clicked | ( | ) | [slot] |
Definition at line 239 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnOr_clicked | ( | ) | [slot] |
Definition at line 313 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::on_btnPct_clicked | ( | ) | [slot] |
Definition at line 229 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::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 123 of file qgsquerybuilder.cpp.
References fillValues(), mModelFields, and mModelValues.
void QgsQueryBuilder::on_buttonBox_helpRequested | ( | ) | [inline, slot] |
Definition at line 89 of file qgsquerybuilder.h.
References QgsContextHelp::run().
void QgsQueryBuilder::on_lstFields_clicked | ( | const QModelIndex & | index | ) | [slot] |
Definition at line 259 of file qgsquerybuilder.cpp.
References mModelValues, and mPreviousFieldRow.
void QgsQueryBuilder::on_lstFields_doubleClicked | ( | const QModelIndex & | index | ) | [slot] |
Definition at line 272 of file qgsquerybuilder.cpp.
References mLayer, mModelFields, and QgsVectorLayer::pendingFields().
void QgsQueryBuilder::on_lstValues_doubleClicked | ( | const QModelIndex & | index | ) | [slot] |
Definition at line 277 of file qgsquerybuilder.cpp.
References mModelValues.
void QgsQueryBuilder::populateFields | ( | ) | [private] |
Populate the field list for the selected table
Definition at line 62 of file qgsquerybuilder.cpp.
References mLayer, mModelFields, QgsVectorLayer::pendingFields(), and setupLstFieldsModel().
Referenced by QgsQueryBuilder().
void QgsQueryBuilder::reject | ( | ) | [slot] |
Definition at line 206 of file qgsquerybuilder.cpp.
References mLayer, mOrigSubsetString, QgsVectorLayer::setSubsetString(), and QgsVectorLayer::subsetString().
void QgsQueryBuilder::setDatasourceDescription | ( | QString | uri | ) | [slot] |
Definition at line 328 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::setSql | ( | QString | sqlStatement | ) | [slot] |
Definition at line 254 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::setupGuiViews | ( | ) | [private] |
Setup models for listviews
Definition at line 81 of file qgsquerybuilder.cpp.
References mModelFields, and mModelValues.
Referenced by QgsQueryBuilder().
void QgsQueryBuilder::setupLstFieldsModel | ( | ) | [private] |
Definition at line 76 of file qgsquerybuilder.cpp.
References mModelFields.
Referenced by populateFields().
QString QgsQueryBuilder::sql | ( | ) | [slot] |
Definition at line 249 of file qgsquerybuilder.cpp.
void QgsQueryBuilder::test | ( | ) | [slot] |
Test the constructed sql statement to see if the database likes it. The number of rows that would be returned is displayed in a message box. The test uses a "select count(*) from ..." query to test the SQL statement.
Definition at line 154 of file qgsquerybuilder.cpp.
References QgsVectorDataProvider::clearErrors(), QgsVectorLayer::dataProvider(), QgsVectorDataProvider::errors(), QgsVectorLayer::featureCount(), QgsVectorDataProvider::hasErrors(), mLayer, and QgsVectorLayer::setSubsetString().
Referenced by QgsQueryBuilder().
QgsVectorLayer* QgsQueryBuilder::mLayer [private] |
vector layer
Definition at line 133 of file qgsquerybuilder.h.
Referenced by accept(), clear(), fillValues(), on_lstFields_doubleClicked(), populateFields(), reject(), and test().
QStandardItemModel* QgsQueryBuilder::mModelFields [private] |
Model for fields ListView.
Definition at line 126 of file qgsquerybuilder.h.
Referenced by on_btnGetAllValues_clicked(), on_btnSampleValues_clicked(), on_lstFields_doubleClicked(), populateFields(), setupGuiViews(), and setupLstFieldsModel().
QStandardItemModel* QgsQueryBuilder::mModelValues [private] |
Model for values ListView.
Definition at line 128 of file qgsquerybuilder.h.
Referenced by fillValues(), on_btnGetAllValues_clicked(), on_btnSampleValues_clicked(), on_lstFields_clicked(), on_lstValues_doubleClicked(), and setupGuiViews().
QString QgsQueryBuilder::mOrigSubsetString [private] |
original subset string
Definition at line 136 of file qgsquerybuilder.h.
Referenced by QgsQueryBuilder(), and reject().
int QgsQueryBuilder::mPreviousFieldRow [private] |
Previous field row to delete model.
Definition at line 130 of file qgsquerybuilder.h.
Referenced by on_lstFields_clicked().