qgsquerybuilder.h

Go to the documentation of this file.

/***************************************************************************
    qgsquerybuilder.h - query builder
     --------------------------------------
    Date                 : 2004-11-19
    Copyright            : (C) 2004 by Gary E.Sherman
    Email                : sherman at mrcc.com
 ***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/
#ifndef QGSQUERYBUILDER_H
#define QGSQUERYBUILDER_H
#include "ui_qgsquerybuilderbase.h"
 
#include <map>
#include <vector>
 
#include "qgis_gui.h"
#include "qgis_sip.h"
#include "qgsguiutils.h"
#include "qgssubsetstringeditorinterface.h"
 
#include <QModelIndex>
#include <QSortFilterProxyModel>
#include <QStandardItem>
#include <QStandardItemModel>
 
class QgsVectorLayer;
class QgsCodeEditor;
class QgsFieldProxyModel;

class GUI_EXPORT QgsQueryBuilder : public QgsSubsetStringEditorInterface, private Ui::QgsQueryBuilderBase
{
    Q_OBJECT
  public:
    QgsQueryBuilder( QgsVectorLayer *layer, QWidget *parent SIP_TRANSFERTHIS = nullptr, Qt::WindowFlags fl = QgsGuiUtils::ModalDialogFlags );
 
    void showEvent( QShowEvent *event ) override;

    QString sql() const;

    void setSql( const QString &sqlStatement );
 
    QString subsetString() const override { return sql(); }
    void setSubsetString( const QString &subsetString ) override { setSql( subsetString ); }
 
#ifdef SIP_RUN
    SIP_IF_FEATURE( HAVE_QSCI_SIP )
 
    
    QgsCodeEditor *codeEditorWidget() const;
    SIP_END
    SIP_IF_FEATURE( !HAVE_QSCI_SIP )
 
    
    QWidget *codeEditorWidget() const;
    SIP_END
#else

    QgsCodeEditor *codeEditorWidget() const { return mTxtSql; }
#endif

    static bool saveQueryToFile( const QString &subset );

    static bool loadQueryFromFile( QString &subset );
 
  public slots:
    void accept() override;
    void reject() override;
    void clear();

    virtual void test();

    void saveQuery();

    void loadQuery();
 
    void setDatasourceDescription( const QString &uri );
 
  private slots:
    void btnEqual_clicked();
    void btnLessThan_clicked();
    void btnGreaterThan_clicked();
    void btnPct_clicked();
    void btnIn_clicked();
    void btnNotIn_clicked();
    void btnLike_clicked();
    void btnILike_clicked();
    void lstFields_clicked( const QModelIndex &index );
    void lstFields_doubleClicked( const QModelIndex &index );
    void lstValues_doubleClicked( const QModelIndex &index );
    void btnLessEqual_clicked();
    void btnGreaterEqual_clicked();
    void btnNotEqual_clicked();
    void btnAnd_clicked();
    void btnNot_clicked();
    void btnOr_clicked();
    void onTextChanged( const QString &text );
    void layerSubsetStringChanged();

    void btnGetAllValues_clicked();

    void btnSampleValues_clicked();
 
  private:
    void showHelp();

    void setupGuiViews();
    void fillValues( const QString &field, int limit );
 
    // private members
    QgsFieldProxyModel *mModelFields = nullptr;
    QStandardItemModel *mModelValues = nullptr;
    QSortFilterProxyModel *mProxyValues = nullptr;
    int mPreviousFieldRow = -1;

    QgsVectorLayer *mLayer = nullptr;

    QString mOrigSubsetString;

    bool mIgnoreLayerSubsetStringChangedSignal = false;
 
    friend class TestQgsQueryBuilder;
};
#endif //QGSQUERYBUILDER_H