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.h>
#include <qgisgui.h>
#include "qgscontexthelp.h"

#include <QPair>
#include <QStringList>
#include <QSet>

class GUI_EXPORT QgsSQLComposerDialog : public QDialog, private Ui::QgsSQLComposerDialogBase
{
    Q_OBJECT

  public:

    typedef QPair<QString, QString> PairNameTitle;

    typedef QPair<QString, QString> PairNameType;

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

    class GUI_EXPORT SQLValidatorCallback
    {
      public:
        virtual ~SQLValidatorCallback();
        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;
      int maxArgs;
      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() : minArgs( -1 ), maxArgs( -1 ) {}
    };

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

    void setSql( const QString& sql );

    QString sql() const;

    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, 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 on_mTablesCombo_currentIndexChanged( int );
    void on_mColumnsCombo_currentIndexChanged( int );
    void on_mSpatialPredicatesCombo_currentIndexChanged( int );
    void on_mFunctionsCombo_currentIndexChanged( int );
    void on_mOperatorsCombo_currentIndexChanged( int );
    void on_mAddJoinButton_clicked();
    void on_mRemoveJoinButton_clicked();
    void on_mTableJoins_itemSelectionChanged();

    void on_mButtonBox_helpRequested() { QgsContextHelp::run( metaObject()->className() ); }

    void reset();
    void buildSQLFromFields();
    void splitSQLIntoFields();

  private:
    QStringList mApiList;
    QSet<QString> mAlreadySelectedTables;
    TableSelectedCallback* mTableSelectedCallback;
    SQLValidatorCallback* mSQLValidatorCallback;
    QObject* mFocusedObject;
    bool mAlreadyModifyingFields;
    bool mDistinct;
    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