Class for parsing SQL statements. More...

#include <qgssqlstatement.h>

Classes
class	Node
	Abstract node class. More...

class	NodeBetweenOperator
	'X BETWEEN y and z' operator More...

class	NodeBinaryOperator
	Binary logical/arithmetical operator (AND, OR, =, +, ...) More...

class	NodeCast
	CAST operator. More...

class	NodeColumnRef
	Reference to a column. More...

class	NodeColumnSorted
	Column in a ORDER BY. More...

class	NodeFunction
	Function with a name and arguments node. More...

class	NodeInOperator
	'x IN (y, z)' operator More...

class	NodeJoin
	Join definition. More...

class	NodeList
	A list of nodes. More...

class	NodeLiteral
	Literal value (integer, integer64, double, string) More...

class	NodeSelect
	SELECT node. More...

class	NodeSelectedColumn
	Selected column. More...

class	NodeTableDef
	Table definition. More...

class	NodeUnaryOperator
	Unary logicial/arithmetical operator ( NOT, - ) More...

class	RecursiveVisitor
	A visitor that recursively explores all children. More...

class	Visitor
	Support for visitor pattern - algorithms dealing with the statement may be implemented without modifying the Node classes. More...

Public Types
enum	BinaryOperator { boOr, boAnd, boEQ, boNE, boLE, boGE, boLT, boGT, boLike, boNotLike, boILike, boNotILike, boIs, boIsNot, boPlus, boMinus, boMul, boDiv, boIntDiv, boMod, boPow, boConcat }
	list of binary operators More...

enum	JoinType { jtDefault, jtLeft, jtLeftOuter, jtRight, jtRightOuter, jtCross, jtInner, jtFull }
	list of join types More...

enum	NodeType { ntUnaryOperator, ntBinaryOperator, ntInOperator, ntBetweenOperator, ntFunction, ntLiteral, ntColumnRef, ntSelectedColumn, ntSelect, ntTableDef, ntJoin, ntColumnSorted, ntCast }
	Node type. More...

enum	UnaryOperator { uoNot, uoMinus }
	list of unary operators More...

Public Member Functions
	QgsSQLStatement (const QString &statement)
	Creates a new statement based on the provided string. More...

	QgsSQLStatement (const QgsSQLStatement &other)
	Create a copy of this statement. More...

	~QgsSQLStatement ()

void	acceptVisitor (QgsSQLStatement::Visitor &v) const
	Entry function for the visitor pattern. More...

bool	doBasicValidationChecks (QString &errorMsgOut) const
	Performs basic validity checks. More...

QString	dump () const
	Returns the statement string, constructed from the internal abstract syntax tree. More...

bool	hasParserError () const
	Returns `true` if an error occurred when parsing the input statement. More...

QgsSQLStatement &	operator= (const QgsSQLStatement &other)
	Create a copy of this statement. More...

QString	parserErrorString () const
	Returns parser error. More...

const QgsSQLStatement::Node *	rootNode () const
	Returns the root node of the statement. More...

QString	statement () const
	Returns the original, unmodified statement string. More...

Static Public Member Functions
static QString	quotedIdentifier (QString name)
	Returns a quoted column reference (in double quotes) More...

static QString	quotedIdentifierIfNeeded (const QString &name)
	Returns a quoted column reference (in double quotes) if needed, or otherwise the original string. More...

static QString	quotedString (QString text)
	Returns a quoted version of a string (in single quotes) More...

static QString	stripQuotedIdentifier (QString text)
	Remove double quotes from an identifier. More...

Static Public Attributes
static const char *	BINARY_OPERATOR_TEXT []

static const char *	JOIN_TYPE_TEXT []

static const char *	UNARY_OPERATOR_TEXT []

Protected Attributes
QString	mParserErrorString

QgsSQLStatement::Node *	mRootNode = nullptr

QString	mStatement

Detailed Description

Class for parsing SQL statements.

Since: QGIS 2.16

Definition at line 36 of file qgssqlstatement.h.

Member Enumeration Documentation

◆ BinaryOperator

enum QgsSQLStatement::BinaryOperator

list of binary operators

Note: if any change is made here, the definition of QgsSQLStatement::BinaryOperatorText[] must be adapted.

Enumerator
boOr
boAnd
boEQ
boNE
boLE
boGE
boLT
boGT
boLike
boNotLike
boILike
boNotILike
boIs
boIsNot
boPlus
boMinus
boMul
boDiv
boIntDiv
boMod
boPow
boConcat

Definition at line 131 of file qgssqlstatement.h.

◆ JoinType

enum QgsSQLStatement::JoinType

list of join types

Note: if any change is made here, the definition of QgsSQLStatement::JoinTypeText[] must be adapted.

Enumerator
jtDefault
jtLeft
jtLeftOuter
jtRight
jtRightOuter
jtCross
jtInner
jtFull

Definition at line 168 of file qgssqlstatement.h.

◆ NodeType

enum QgsSQLStatement::NodeType

Node type.

Enumerator
ntUnaryOperator
ntBinaryOperator
ntInOperator
ntBetweenOperator
ntFunction
ntLiteral
ntColumnRef
ntSelectedColumn
ntSelect
ntTableDef
ntJoin
ntColumnSorted
ntCast

Definition at line 194 of file qgssqlstatement.h.

◆ UnaryOperator

enum QgsSQLStatement::UnaryOperator

list of unary operators

Note: if any change is made here, the definition of QgsSQLStatement::UnaryOperatorText[] must be adapted.

Enumerator
uoNot
uoMinus

Definition at line 121 of file qgssqlstatement.h.

Constructor & Destructor Documentation

◆ QgsSQLStatement() [1/2]

QgsSQLStatement::QgsSQLStatement ( const QString & statement )

Creates a new statement based on the provided string.

Definition at line 118 of file qgssqlstatement.cpp.

◆ QgsSQLStatement() [2/2]

QgsSQLStatement::QgsSQLStatement ( const QgsSQLStatement & other )

Create a copy of this statement.

Definition at line 124 of file qgssqlstatement.cpp.

◆ ~QgsSQLStatement()

QgsSQLStatement::~QgsSQLStatement ( )

Definition at line 142 of file qgssqlstatement.cpp.

Member Function Documentation

◆ acceptVisitor()

void QgsSQLStatement::acceptVisitor ( QgsSQLStatement::Visitor & v ) const

Entry function for the visitor pattern.

Definition at line 151 of file qgssqlstatement.cpp.

◆ doBasicValidationChecks()

bool QgsSQLStatement::doBasicValidationChecks ( QString & errorMsgOut ) const

Performs basic validity checks.

Basically checking that columns referencing a table, references a specified table. Returns true if the validation is successful

Definition at line 232 of file qgssqlstatement.cpp.

◆ dump()

QString QgsSQLStatement::dump ( ) const

Returns the statement string, constructed from the internal abstract syntax tree.

This does not contain any nice whitespace formatting or comments. In general it is preferable to use statement() instead.

Definition at line 62 of file qgssqlstatement.cpp.

◆ hasParserError()

bool QgsSQLStatement::hasParserError ( ) const

Returns true if an error occurred when parsing the input statement.

Definition at line 147 of file qgssqlstatement.cpp.

◆ operator=()

QgsSQLStatement & QgsSQLStatement::operator= ( const QgsSQLStatement & other )

Create a copy of this statement.

Definition at line 130 of file qgssqlstatement.cpp.

◆ parserErrorString()

QString QgsSQLStatement::parserErrorString ( ) const

Returns parser error.

Definition at line 149 of file qgssqlstatement.cpp.

◆ quotedIdentifier()

QString QgsSQLStatement::quotedIdentifier ( QString name )

static

Returns a quoted column reference (in double quotes)

See also: quotedString(), quotedIdentifierIfNeeded()

Definition at line 70 of file qgssqlstatement.cpp.

◆ quotedIdentifierIfNeeded()

QString QgsSQLStatement::quotedIdentifierIfNeeded ( const QString & name )

static

Returns a quoted column reference (in double quotes) if needed, or otherwise the original string.

See also: quotedString(), quotedIdentifier()

Definition at line 75 of file qgssqlstatement.cpp.

◆ quotedString()

QString QgsSQLStatement::quotedString ( QString text )

static

Returns a quoted version of a string (in single quotes)

See also: quotedIdentifier(), quotedIdentifierIfNeeded()

Definition at line 109 of file qgssqlstatement.cpp.

◆ rootNode()

const QgsSQLStatement::Node * QgsSQLStatement::rootNode ( ) const

Returns the root node of the statement.

The root node is nullptr if parsing has failed.

Definition at line 157 of file qgssqlstatement.cpp.

◆ statement()

QString QgsSQLStatement::statement ( ) const

Returns the original, unmodified statement string.

If there was none supplied because it was constructed by sole API calls, dump() will be used to create one instead.

Definition at line 54 of file qgssqlstatement.cpp.

◆ stripQuotedIdentifier()

QString QgsSQLStatement::stripQuotedIdentifier ( QString text )

static

Remove double quotes from an identifier.

See also: quotedIdentifier()

Definition at line 96 of file qgssqlstatement.cpp.

Member Data Documentation

◆ BINARY_OPERATOR_TEXT

const char * QgsSQLStatement::BINARY_OPERATOR_TEXT

static

Initial value:

=
{
  
  "OR", "AND",
  "=", "<>", "<=", ">=", "<", ">", "LIKE", "NOT LIKE", "ILIKE", "NOT ILIKE", "IS", "IS NOT",
  "+", "-", "*", "/", "//", "%", "^",
  "||"
}

Note: not available in Python bindings

Definition at line 181 of file qgssqlstatement.h.

◆ JOIN_TYPE_TEXT

const char * QgsSQLStatement::JOIN_TYPE_TEXT

static

Initial value:

=
{
  
  "", "LEFT", "LEFT OUTER", "RIGHT", "RIGHT OUTER", "CROSS", "INNER", "FULL"
}

Note: not available in Python bindings

Definition at line 187 of file qgssqlstatement.h.

◆ mParserErrorString

QString QgsSQLStatement::mParserErrorString

protected

Definition at line 834 of file qgssqlstatement.h.

◆ mRootNode

QgsSQLStatement::Node* QgsSQLStatement::mRootNode = nullptr

protected

Definition at line 832 of file qgssqlstatement.h.

◆ mStatement

QString QgsSQLStatement::mStatement

protected

Definition at line 833 of file qgssqlstatement.h.

◆ UNARY_OPERATOR_TEXT

const char * QgsSQLStatement::UNARY_OPERATOR_TEXT

static

Initial value:

=
{
  
  "NOT", "-"
}

Note: not available in Python bindings

Definition at line 184 of file qgssqlstatement.h.

The documentation for this class was generated from the following files:

/build/qgis-3.10.0+15buster/src/core/qgssqlstatement.h
/build/qgis-3.10.0+15buster/src/core/qgssqlstatement.cpp

Classes

Public Types

Public Member Functions

Static Public Member Functions

Static Public Attributes

Protected Attributes

Detailed Description

Member Enumeration Documentation

◆ BinaryOperator

◆ JoinType

◆ NodeType

◆ UnaryOperator

Constructor & Destructor Documentation

◆ QgsSQLStatement() [1/2]

◆ QgsSQLStatement() [2/2]

◆ ~QgsSQLStatement()

Member Function Documentation

◆ acceptVisitor()

◆ doBasicValidationChecks()

◆ dump()

◆ hasParserError()

◆ operator=()

◆ parserErrorString()

◆ quotedIdentifier()

◆ quotedIdentifierIfNeeded()

◆ quotedString()

◆ rootNode()

◆ statement()

◆ stripQuotedIdentifier()

Member Data Documentation

◆ BINARY_OPERATOR_TEXT

◆ JOIN_TYPE_TEXT

◆ mParserErrorString

◆ mRootNode

◆ mStatement

◆ UNARY_OPERATOR_TEXT