// constructor used when the query builder must make its own // connection to the database QgsQueryBuilder::QgsQueryBuilder( QgsVectorLayer *layer, QWidget *parent, Qt::WindowFlags fl ) : QDialog( parent, fl ) , mPreviousFieldRow( -1 ) , mLayer( layer ) { setupUi( this ); QSettings settings; restoreGeometry( settings.value( QStringLiteral( "/Windows/QueryBuilder/geometry" ) ).toByteArray() ); QPushButton *pbn = new QPushButton( tr( "&Test" ) ); buttonBox->addButton( pbn, QDialogButtonBox::ActionRole ); connect( pbn, SIGNAL( clicked() ), this, SLOT( test() ) ); pbn = new QPushButton( tr( "&Clear" ) ); buttonBox->addButton( pbn, QDialogButtonBox::ActionRole ); connect( pbn, SIGNAL( clicked() ), this, SLOT( clear() ) ); setupGuiViews(); mOrigSubsetString = layer->subsetString(); mUseUnfilteredLayer->setDisabled( mLayer->subsetString().isEmpty() ); lblDataUri->setText( tr( "Set provider filter on %1" ).arg( layer->name() ) ); txtSQL->setText( mOrigSubsetString ); populateFields(); }
// constructor used when the query builder must make its own // connection to the database SaQueryBuilder::SaQueryBuilder( QgsVectorLayer *layer, QWidget *parent, Qt::WFlags fl ) : QDialog( parent, fl ), mLayer( layer ) { setupUi( this ); connect( buttonBox, SIGNAL( helpRequested() ), this, SLOT( helpClicked() ) ); QPushButton *pbn = new QPushButton( tr( "&Test" ) ); buttonBox->addButton( pbn, QDialogButtonBox::ActionRole ); connect( pbn, SIGNAL( clicked() ), this, SLOT( test() ) ); pbn = new QPushButton( tr( "&Clear" ) ); buttonBox->addButton( pbn, QDialogButtonBox::ActionRole ); connect( pbn, SIGNAL( clicked() ), this, SLOT( clear() ) ); // remove the ILIKE button since ILIKE is a PostgreSQL special // not supported by SQL Anywhere btnILike->setVisible( false ); setupGuiViews(); mOrigSubsetString = layer->subsetString(); lblDataUri->setText( layer->publicSource() ); txtSQL->setText( mOrigSubsetString ); populateFields(); }
// constructor used when the query builder must make its own // connection to the database QgsQueryBuilder::QgsQueryBuilder( QgsVectorLayer *layer, QWidget *parent, Qt::WindowFlags fl ) : QDialog( parent, fl ) , mPreviousFieldRow( -1 ) , mLayer( layer ) { setupUi( this ); connect( btnEqual, &QPushButton::clicked, this, &QgsQueryBuilder::btnEqual_clicked ); connect( btnLessThan, &QPushButton::clicked, this, &QgsQueryBuilder::btnLessThan_clicked ); connect( btnGreaterThan, &QPushButton::clicked, this, &QgsQueryBuilder::btnGreaterThan_clicked ); connect( btnPct, &QPushButton::clicked, this, &QgsQueryBuilder::btnPct_clicked ); connect( btnIn, &QPushButton::clicked, this, &QgsQueryBuilder::btnIn_clicked ); connect( btnNotIn, &QPushButton::clicked, this, &QgsQueryBuilder::btnNotIn_clicked ); connect( btnLike, &QPushButton::clicked, this, &QgsQueryBuilder::btnLike_clicked ); connect( btnILike, &QPushButton::clicked, this, &QgsQueryBuilder::btnILike_clicked ); connect( lstFields, &QListView::clicked, this, &QgsQueryBuilder::lstFields_clicked ); connect( lstFields, &QListView::doubleClicked, this, &QgsQueryBuilder::lstFields_doubleClicked ); connect( lstValues, &QListView::doubleClicked, this, &QgsQueryBuilder::lstValues_doubleClicked ); connect( btnLessEqual, &QPushButton::clicked, this, &QgsQueryBuilder::btnLessEqual_clicked ); connect( btnGreaterEqual, &QPushButton::clicked, this, &QgsQueryBuilder::btnGreaterEqual_clicked ); connect( btnNotEqual, &QPushButton::clicked, this, &QgsQueryBuilder::btnNotEqual_clicked ); connect( btnAnd, &QPushButton::clicked, this, &QgsQueryBuilder::btnAnd_clicked ); connect( btnNot, &QPushButton::clicked, this, &QgsQueryBuilder::btnNot_clicked ); connect( btnOr, &QPushButton::clicked, this, &QgsQueryBuilder::btnOr_clicked ); connect( btnGetAllValues, &QPushButton::clicked, this, &QgsQueryBuilder::btnGetAllValues_clicked ); connect( btnSampleValues, &QPushButton::clicked, this, &QgsQueryBuilder::btnSampleValues_clicked ); connect( buttonBox, &QDialogButtonBox::helpRequested, this, &QgsQueryBuilder::showHelp ); QgsSettings settings; restoreGeometry( settings.value( QStringLiteral( "Windows/QueryBuilder/geometry" ) ).toByteArray() ); QPushButton *pbn = new QPushButton( tr( "&Test" ) ); buttonBox->addButton( pbn, QDialogButtonBox::ActionRole ); connect( pbn, &QAbstractButton::clicked, this, &QgsQueryBuilder::test ); pbn = new QPushButton( tr( "&Clear" ) ); buttonBox->addButton( pbn, QDialogButtonBox::ActionRole ); connect( pbn, &QAbstractButton::clicked, this, &QgsQueryBuilder::clear ); setupGuiViews(); mOrigSubsetString = layer->subsetString(); mUseUnfilteredLayer->setDisabled( mLayer->subsetString().isEmpty() ); lblDataUri->setText( tr( "Set provider filter on %1" ).arg( layer->name() ) ); txtSQL->setText( mOrigSubsetString ); mFilterLineEdit->setShowSearchIcon( true ); mFilterLineEdit->setPlaceholderText( tr( "Search…" ) ); connect( mFilterLineEdit, &QgsFilterLineEdit::textChanged, this, &QgsQueryBuilder::onTextChanged ); populateFields(); }