qgssqlstatement.h

Go to the documentation of this file.

/***************************************************************************
                               qgssqlstatement.h
                             ---------------------
    begin                : April 2016
    copyright            : (C) 2011 by Martin Dobias
    copyright            : (C) 2016 by 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 QGSSQLSTATEMENT_H
#define QGSSQLSTATEMENT_H

#include <QCoreApplication>
#include <QMetaType>
#include <QStringList>
#include <QVariant>
#include <QList>
#include <QSet>

class CORE_EXPORT QgsSQLStatement
{
    Q_DECLARE_TR_FUNCTIONS( QgsSQLStatement )
  public:
    QgsSQLStatement( const QString& statement );

    QgsSQLStatement( const QgsSQLStatement& other );
    QgsSQLStatement& operator=( const QgsSQLStatement& other );
    ~QgsSQLStatement();

    bool hasParserError() const;
    QString parserErrorString() const;

    bool doBasicValidationChecks( QString& errorMsgOut ) const;

    class Node;

    const Node* rootNode() const;

    QString statement() const;

    QString dump() const;

    static QString quotedIdentifier( QString name );

    static QString quotedIdentifierIfNeeded( QString name );

    static QString stripQuotedIdentifier( QString text );

    static QString quotedString( QString text );

    enum UnaryOperator
    {
      uoNot,
      uoMinus,
    };

    enum BinaryOperator
    {
      // logical
      boOr,
      boAnd,

      // comparison
      boEQ,  // =
      boNE,  // <>
      boLE,  // <=
      boGE,  // >=
      boLT,  // <
      boGT,  // >
      boLike,
      boNotLike,
      boILike,
      boNotILike,
      boIs,
      boIsNot,

      // math
      boPlus,
      boMinus,
      boMul,
      boDiv,
      boIntDiv,
      boMod,
      boPow,

      // strings
      boConcat,
    };

    enum JoinType
    {
      jtDefault,
      jtLeft,
      jtLeftOuter,
      jtRight,
      jtRightOuter,
      jtCross,
      jtInner,
      jtFull
    };

    static const char* BinaryOperatorText[];

    static const char* UnaryOperatorText[];

    static const char* JoinTypeText[];


    class Visitor; // visitor interface is defined below

    enum NodeType
    {
      ntUnaryOperator,
      ntBinaryOperator,
      ntInOperator,
      ntBetweenOperator,
      ntFunction,
      ntLiteral,
      ntColumnRef,
      ntSelectedColumn,
      ntSelect,
      ntTableDef,
      ntJoin,
      ntColumnSorted,
      ntCast
    };

    class CORE_EXPORT Node
    {
      public:
        virtual ~Node() {}

        virtual NodeType nodeType() const = 0;

        virtual QString dump() const = 0;

        virtual Node* clone() const = 0;

        virtual void accept( Visitor& v ) const = 0;
    };

    class CORE_EXPORT NodeList
    {
      public:
        NodeList()  {}
        virtual ~NodeList() { qDeleteAll( mList ); }

        void append( Node* node ) { mList.append( node ); }

        QList<Node*> list() { return mList; }

        int count() const { return mList.count(); }

        void accept( Visitor& v ) const { Q_FOREACH ( Node* node, mList ) { node->accept( v ); } }

        NodeList* clone() const;

        virtual QString dump() const;

      protected:
        QList<Node*> mList;
    };

    class CORE_EXPORT NodeUnaryOperator : public Node
    {
      public:
        NodeUnaryOperator( UnaryOperator op, Node* operand ) : mOp( op ), mOperand( operand ) {}
        ~NodeUnaryOperator() { delete mOperand; }

        UnaryOperator op() const { return mOp; }

        Node* operand() const { return mOperand; }

        virtual NodeType nodeType() const override { return ntUnaryOperator; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;

      protected:
        UnaryOperator mOp;
        Node* mOperand;
    };

    class CORE_EXPORT NodeBinaryOperator : public Node
    {
      public:
        NodeBinaryOperator( BinaryOperator op, Node* opLeft, Node* opRight ) : mOp( op ), mOpLeft( opLeft ), mOpRight( opRight ) {}
        ~NodeBinaryOperator() { delete mOpLeft; delete mOpRight; }

        BinaryOperator op() const { return mOp; }

        Node* opLeft() const { return mOpLeft; }

        Node* opRight() const { return mOpRight; }

        virtual NodeType nodeType() const override { return ntBinaryOperator; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;

        int precedence() const;

        bool leftAssociative() const;

      protected:

        BinaryOperator mOp;
        Node* mOpLeft;
        Node* mOpRight;
    };

    class CORE_EXPORT NodeInOperator : public Node
    {
      public:
        NodeInOperator( Node* node, NodeList* list, bool notin = false ) : mNode( node ), mList( list ), mNotIn( notin ) {}
        virtual ~NodeInOperator() { delete mNode; delete mList; }

        Node* node() const { return mNode; }

        bool isNotIn() const { return mNotIn; }

        NodeList* list() const { return mList; }

        virtual NodeType nodeType() const override { return ntInOperator; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;

      protected:
        Node* mNode;
        NodeList* mList;
        bool mNotIn;
    };

    class CORE_EXPORT NodeBetweenOperator : public Node
    {
      public:
        NodeBetweenOperator( Node* node, Node* minVal, Node* maxVal, bool notBetween = false ) : mNode( node ), mMinVal( minVal ), mMaxVal( maxVal ), mNotBetween( notBetween ) {}
        virtual ~NodeBetweenOperator() { delete mNode; delete mMinVal; delete mMaxVal; }

        Node* node() const { return mNode; }

        bool isNotBetween() const { return mNotBetween; }

        Node* minVal() const { return mMinVal; }

        Node* maxVal() const { return mMaxVal; }

        virtual NodeType nodeType() const override { return ntBetweenOperator; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;

      protected:
        Node* mNode;
        Node* mMinVal;
        Node* mMaxVal;
        bool mNotBetween;
    };

    class CORE_EXPORT NodeFunction : public Node
    {
      public:
        NodeFunction( QString name, NodeList* args ) : mName( name ), mArgs( args ) {}
        virtual ~NodeFunction() { delete mArgs; }

        QString name() const { return mName; }

        NodeList* args() const { return mArgs; }

        virtual NodeType nodeType() const override { return ntFunction; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;

      protected:
        QString mName;
        NodeList* mArgs;

    };

    class CORE_EXPORT NodeLiteral : public Node
    {
      public:
        NodeLiteral( const QVariant& value ) : mValue( value ) {}

        inline QVariant value() const { return mValue; }

        virtual NodeType nodeType() const override { return ntLiteral; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;

      protected:
        QVariant mValue;
    };

    class CORE_EXPORT NodeColumnRef : public Node
    {
      public:
        NodeColumnRef( const QString& name, bool star ) : mName( name ), mDistinct( false ), mStar( star ) {}
        NodeColumnRef( const QString& tableName, const QString& name, bool star ) : mTableName( tableName ), mName( name ), mDistinct( false ), mStar( star ) {}

        void setDistinct( bool distinct = true ) { mDistinct = distinct; }

        QString tableName() const { return mTableName; }

        QString name() const { return mName; }

        bool star() const { return mStar; }

        bool distinct() const { return mDistinct; }

        virtual NodeType nodeType() const override { return ntColumnRef; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;
        NodeColumnRef* cloneThis() const;

      protected:
        QString mTableName;
        QString mName;
        bool mDistinct;
        bool mStar;
    };

    class CORE_EXPORT NodeSelectedColumn : public Node
    {
      public:
        NodeSelectedColumn( Node* node ) : mColumnNode( node ) {}
        virtual ~NodeSelectedColumn() { delete mColumnNode; }

        void setAlias( const QString& alias ) { mAlias = alias; }

        Node* column() const { return mColumnNode; }

        QString alias() const { return mAlias; }

        virtual NodeType nodeType() const override { return ntSelectedColumn; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;
        NodeSelectedColumn* cloneThis() const;

      protected:
        Node *mColumnNode;
        QString mAlias;
    };

    class CORE_EXPORT NodeCast : public Node
    {
      public:
        NodeCast( Node* node, const QString& type ) : mNode( node ), mType( type ) {}
        virtual ~NodeCast() { delete mNode; }

        Node* node() const { return mNode; }

        QString type() const { return mType; }

        virtual NodeType nodeType() const override { return ntCast; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;

      protected:
        Node *mNode;
        QString mType;
    };

    class CORE_EXPORT NodeTableDef : public Node
    {
      public:
        NodeTableDef( const QString& name ) : mName( name ) {}
        NodeTableDef( const QString& name, const QString& alias ) : mName( name ), mAlias( alias ) {}

        QString name() const { return mName; }

        QString alias() const { return mAlias; }

        virtual NodeType nodeType() const override { return ntTableDef; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;
        NodeTableDef* cloneThis() const;

      protected:
        QString mName;
        QString mAlias;
    };

    class CORE_EXPORT NodeJoin : public Node
    {
      public:
        NodeJoin( NodeTableDef* tabledef, Node* onExpr, JoinType type ) : mTableDef( tabledef ), mOnExpr( onExpr ), mType( type ) {}
        NodeJoin( NodeTableDef* tabledef, QList<QString> usingColumns, JoinType type ) : mTableDef( tabledef ), mOnExpr( nullptr ), mUsingColumns( usingColumns ), mType( type ) {}
        virtual ~NodeJoin() { delete mTableDef; delete mOnExpr; }

        NodeTableDef* tableDef() const { return mTableDef; }

        Node* onExpr() const { return mOnExpr; }

        QList<QString> usingColumns() const { return mUsingColumns; }

        JoinType type() const { return mType; }

        virtual NodeType nodeType() const override { return ntJoin; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;
        NodeJoin* cloneThis() const;

      protected:
        NodeTableDef* mTableDef;
        Node* mOnExpr;
        QList<QString> mUsingColumns;
        JoinType mType;
    };

    class CORE_EXPORT NodeColumnSorted : public Node
    {
      public:
        NodeColumnSorted( NodeColumnRef* column, bool asc ) : mColumn( column ), mAsc( asc ) {}
        ~NodeColumnSorted() { delete mColumn; }

        NodeColumnRef* column() const { return mColumn; }

        bool ascending() const { return mAsc; }

        virtual NodeType nodeType() const override { return ntColumnSorted; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;
        NodeColumnSorted* cloneThis() const;

      protected:
        NodeColumnRef* mColumn;
        bool mAsc;
    };

    class CORE_EXPORT NodeSelect : public Node
    {
      public:
        NodeSelect( QList<NodeTableDef*> tableList, QList<NodeSelectedColumn*> columns, bool distinct ) : mTableList( tableList ), mColumns( columns ), mDistinct( distinct ), mWhere( nullptr ) {}
        virtual ~NodeSelect() { qDeleteAll( mTableList ); qDeleteAll( mColumns ); qDeleteAll( mJoins ); delete mWhere; qDeleteAll( mOrderBy ); }

        void setJoins( QList<NodeJoin*> joins ) { qDeleteAll( mJoins ); mJoins = joins; }
        void appendJoin( NodeJoin* join ) { mJoins.append( join ); }
        void setWhere( Node* where ) { delete mWhere; mWhere = where; }
        void setOrderBy( QList<NodeColumnSorted*> orderBy ) { qDeleteAll( mOrderBy ); mOrderBy = orderBy; }

        QList<NodeTableDef*> tables() const { return mTableList; }
        QList<NodeSelectedColumn*> columns() const { return mColumns; }
        bool distinct() const { return mDistinct; }
        QList<NodeJoin*> joins() const { return mJoins; }
        Node* where() const { return mWhere; }
        QList<NodeColumnSorted*> orderBy() const { return mOrderBy; }

        virtual NodeType nodeType() const override { return ntSelect; }
        virtual QString dump() const override;

        virtual void accept( Visitor& v ) const override { v.visit( *this ); }
        virtual Node* clone() const override;

      protected:
        QList<NodeTableDef*> mTableList;
        QList<NodeSelectedColumn*> mColumns;
        bool mDistinct;
        QList<NodeJoin*> mJoins;
        Node* mWhere;
        QList<NodeColumnSorted*> mOrderBy;
    };


    class CORE_EXPORT Visitor
    {
      public:
        virtual ~Visitor() {}
        virtual void visit( const NodeUnaryOperator& n ) = 0;
        virtual void visit( const NodeBinaryOperator& n ) = 0;
        virtual void visit( const NodeInOperator& n ) = 0;
        virtual void visit( const NodeBetweenOperator& n ) = 0;
        virtual void visit( const NodeFunction& n ) = 0;
        virtual void visit( const NodeLiteral& n ) = 0;
        virtual void visit( const NodeColumnRef& n ) = 0;
        virtual void visit( const NodeSelectedColumn& n ) = 0;
        virtual void visit( const NodeTableDef& n ) = 0;
        virtual void visit( const NodeSelect& n ) = 0;
        virtual void visit( const NodeJoin& n ) = 0;
        virtual void visit( const NodeColumnSorted& n ) = 0;
        virtual void visit( const NodeCast& n ) = 0;
    };

    class CORE_EXPORT RecursiveVisitor: public QgsSQLStatement::Visitor
    {
      public:
        RecursiveVisitor() {}

        void visit( const QgsSQLStatement::NodeUnaryOperator& n ) override { n.operand()->accept( *this ); }
        void visit( const QgsSQLStatement::NodeBinaryOperator& n ) override { n.opLeft()->accept( *this ); n.opRight()->accept( *this ); }
        void visit( const QgsSQLStatement::NodeInOperator& n ) override { n.node()->accept( *this ); n.list()->accept( *this ); }
        void visit( const QgsSQLStatement::NodeBetweenOperator& n ) override { n.node()->accept( *this ); n.minVal()->accept( *this ); n.maxVal()->accept( *this ); }
        void visit( const QgsSQLStatement::NodeFunction& n ) override { n.args()->accept( *this ); }
        void visit( const QgsSQLStatement::NodeLiteral& ) override {}
        void visit( const QgsSQLStatement::NodeColumnRef& ) override { }
        void visit( const QgsSQLStatement::NodeSelectedColumn& n ) override { n.column()->accept( *this ); }
        void visit( const QgsSQLStatement::NodeTableDef& ) override {}
        void visit( const QgsSQLStatement::NodeSelect& n ) override;
        void visit( const QgsSQLStatement::NodeJoin& n ) override;
        void visit( const QgsSQLStatement::NodeColumnSorted& n ) override { n.column()->accept( *this ); }
        void visit( const QgsSQLStatement::NodeCast& n ) override { n.node()->accept( *this ); }
    };

    void acceptVisitor( Visitor& v ) const;

  protected:
    QgsSQLStatement::Node* mRootNode;
    QString mStatement;
    QString mParserErrorString;
};

Q_DECLARE_METATYPE( QgsSQLStatement::Node* )

#endif // QGSSQLSTATEMENT_H