qgssqlcomposerdialog.h

Go to the documentation of this file.

/***************************************************************************
                qgssqlcomposerdialog.cpp
       Dialog to compose SQL queries
 
begin                : Apr 2016
copyright            : (C) 2016 Even Rouault
email                : even.rouault at spatialys.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 QGSSQLCOMPOSERDIALOG_H
#define QGSSQLCOMPOSERDIALOG_H
 
#include "ui_qgssqlcomposerdialogbase.h"
 
#include "qgis_gui.h"
#include "qgis_sip.h"
#include "qgsguiutils.h"
#include "qgssubsetstringeditorinterface.h"
 
#include <QPair>
#include <QSet>
#include <QStringList>
 
SIP_NO_FILE
 
class QgsVectorLayer;

class GUI_EXPORT QgsSQLComposerDialog : public QgsSubsetStringEditorInterface, private Ui::QgsSQLComposerDialogBase
{
    Q_OBJECT
 
  public:
    typedef QPair<QString, QString> PairNameTitle;

    typedef QPair<QString, QString> PairNameType;

    class GUI_EXPORT TableSelectedCallback
    {
      public:
        virtual ~TableSelectedCallback() = default;
        virtual void tableSelected( const QString &name ) = 0;
    };

    class GUI_EXPORT SQLValidatorCallback
    {
      public:
        virtual ~SQLValidatorCallback() = default;
        virtual bool isValid( const QString &sql, QString &errorReason, QString &warningMsg ) = 0;
    };

    struct Argument
    {
        QString name;
        QString type;

        Argument( const QString &nameIn = QString(), const QString &typeIn = QString() )
          : name( nameIn )
          , type( typeIn )
        {}
    };

    struct Function
    {
        QString name;
        QString returnType;
        int minArgs = -1;
        int maxArgs = -1;
        QList<Argument> argumentList;

        Function( const QString &nameIn, int args )
          : name( nameIn )
          , minArgs( args )
          , maxArgs( args )
        {}

        Function( const QString &nameIn, int minArgs, int maxArgsIn )
          : name( nameIn )
          , minArgs( minArgs )
          , maxArgs( maxArgsIn )
        {}
 
        Function() = default;
    };

    explicit QgsSQLComposerDialog( QWidget *parent = nullptr, Qt::WindowFlags fl = QgsGuiUtils::ModalDialogFlags );

    QgsSQLComposerDialog( QgsVectorLayer *layer, QWidget *parent = nullptr, Qt::WindowFlags fl = QgsGuiUtils::ModalDialogFlags );
 
    ~QgsSQLComposerDialog() override;

    void setSql( const QString &sql );

    QString sql() const;
 
    QString subsetString() const override { return sql(); }
    void setSubsetString( const QString &subsetString ) override { setSql( subsetString ); }

    void addTableNames( const QStringList &list );
    void addTableNames( const QList<PairNameTitle> &listNameTitle );
    void addColumnNames( const QStringList &list, const QString &tableName );
    void addColumnNames( const QList<PairNameType> &list, const QString &tableName );
    void addOperators( const QStringList &list );
    void addSpatialPredicates( const QStringList &list );
    void addSpatialPredicates( const QList<Function> &list );
    void addFunctions( const QStringList &list );
    void addFunctions( const QList<Function> &list );
    void addApis( const QStringList &list );

    void setSupportMultipleTables( bool bMultipleTables, const QString &mainTypename = QString() );

    void setTableSelectedCallback( TableSelectedCallback *tableSelectedCallback );

    void setSQLValidatorCallback( SQLValidatorCallback *sqlValidatorCallback );
 
  protected:
    bool eventFilter( QObject *obj, QEvent *event ) override;
 
  private slots:
    void accept() override;
 
    void mTablesCombo_currentIndexChanged( int );
    void mColumnsCombo_currentIndexChanged( int );
    void mSpatialPredicatesCombo_currentIndexChanged( int );
    void mFunctionsCombo_currentIndexChanged( int );
    void mOperatorsCombo_currentIndexChanged( int );
    void mAddJoinButton_clicked();
    void mRemoveJoinButton_clicked();
    void mTableJoins_itemSelectionChanged();
    void showHelp();
    void reset();
    void buildSQLFromFields();
    void splitSQLIntoFields();
 
  private:
    QgsVectorLayer *mLayer = nullptr;
    QStringList mApiList;
    QSet<QString> mAlreadySelectedTables;
    TableSelectedCallback *mTableSelectedCallback = nullptr;
    SQLValidatorCallback *mSQLValidatorCallback = nullptr;
    QObject *mFocusedObject = nullptr;
    bool mAlreadyModifyingFields = false;
    bool mDistinct = false;
    QString mResetSql;
    QMap<QString, QString> mapTableEntryTextToName;
    QMap<QString, QString> mapColumnEntryTextToName;
    QMap<QString, QString> mapSpatialPredicateEntryTextToName;
    QMap<QString, QString> mapFunctionEntryTextToName;
    QString lastSearchedText;
 
 
    void loadTableColumns( const QString &table );
    void functionCurrentIndexChanged( QComboBox *combo, const QMap<QString, QString> &mapEntryTextToName );
    void getFunctionList( const QList<Function> &list, QStringList &listApi, QStringList &listCombo, QMap<QString, QString> &mapEntryTextToName );
};
 
#endif