Class for parsing SQL statements. More...

#include <qgssqlstatement.h>

Inheritance diagram for QgsSQLStatement:

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 QgsSQLStatement &other)
	Create a copy of this statement. More...

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

virtual	~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	stripMsQuotedIdentifier (QString text)
	Remove double quotes from an Microsoft style identifier. 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 Member Functions
	QgsSQLStatement (const QString &statement, bool allowFragments)
	Constructor for QgsSQLStatement, with the specified statement. More...

Protected Attributes
bool	mAllowFragments = false

QString	mParserErrorString

QgsSQLStatement::Node *	mRootNode = nullptr

QString	mStatement

Detailed Description

Class for parsing SQL statements.

Since: QGIS 2.16

Definition at line 35 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 150 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 187 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 213 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 140 of file qgssqlstatement.h.

Constructor & Destructor Documentation

◆ QgsSQLStatement() [1/3]

QgsSQLStatement::QgsSQLStatement ( const QString & statement )

Creates a new statement based on the provided string.

Definition at line 130 of file qgssqlstatement.cpp.

◆ QgsSQLStatement() [2/3]

QgsSQLStatement::QgsSQLStatement ( const QgsSQLStatement & other )

Create a copy of this statement.

Definition at line 142 of file qgssqlstatement.cpp.

◆ ~QgsSQLStatement()

QgsSQLStatement::~QgsSQLStatement ( )

virtual

Definition at line 160 of file qgssqlstatement.cpp.

◆ QgsSQLStatement() [3/3]

QgsSQLStatement::QgsSQLStatement	(	const QString &	statement,
		bool	allowFragments
	)

protected

Constructor for QgsSQLStatement, with the specified statement.

If allowFragments is true then the parser will allow SQL fragments, such as a expression or filter where clause alone.

Since: QGIS 3.16

Definition at line 135 of file qgssqlstatement.cpp.

Member Function Documentation

◆ acceptVisitor()

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

Entry function for the visitor pattern.

Definition at line 169 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 250 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 63 of file qgssqlstatement.cpp.

◆ hasParserError()

bool QgsSQLStatement::hasParserError ( ) const

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

Definition at line 165 of file qgssqlstatement.cpp.

◆ operator=()

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

Create a copy of this statement.

Definition at line 148 of file qgssqlstatement.cpp.

◆ parserErrorString()

QString QgsSQLStatement::parserErrorString ( ) const

Returns parser error.

Definition at line 167 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 71 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 76 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 121 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 175 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 55 of file qgssqlstatement.cpp.

◆ stripMsQuotedIdentifier()

QString QgsSQLStatement::stripMsQuotedIdentifier ( QString text )

static

Remove double quotes from an Microsoft style identifier.

See also: quotedIdentifier()

Definition at line 111 of file qgssqlstatement.cpp.

◆ stripQuotedIdentifier()

QString QgsSQLStatement::stripQuotedIdentifier ( QString text )

static

Remove double quotes from an identifier.

See also: quotedIdentifier()

Definition at line 98 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 200 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 206 of file qgssqlstatement.h.

◆ mAllowFragments

bool QgsSQLStatement::mAllowFragments = false

protected

Definition at line 866 of file qgssqlstatement.h.

◆ mParserErrorString

QString QgsSQLStatement::mParserErrorString

protected

Definition at line 868 of file qgssqlstatement.h.

◆ mRootNode

QgsSQLStatement::Node* QgsSQLStatement::mRootNode = nullptr

protected

Definition at line 865 of file qgssqlstatement.h.

◆ mStatement

QString QgsSQLStatement::mStatement

protected

Definition at line 867 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 203 of file qgssqlstatement.h.

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

/build/qgis-3.26.3+32focal/src/core/qgssqlstatement.h
/build/qgis-3.26.3+32focal/src/core/qgssqlstatement.cpp

Classes

Public Types

Public Member Functions

Static Public Member Functions

Static Public Attributes

Protected Member Functions

Protected Attributes

Detailed Description

Member Enumeration Documentation

◆ BinaryOperator

◆ JoinType

◆ NodeType

◆ UnaryOperator

Constructor & Destructor Documentation

◆ QgsSQLStatement() [1/3]

◆ QgsSQLStatement() [2/3]

◆ ~QgsSQLStatement()

◆ QgsSQLStatement() [3/3]

Member Function Documentation

◆ acceptVisitor()

◆ doBasicValidationChecks()

◆ dump()

◆ hasParserError()

◆ operator=()

◆ parserErrorString()

◆ quotedIdentifier()

◆ quotedIdentifierIfNeeded()

◆ quotedString()

◆ rootNode()

◆ statement()

◆ stripMsQuotedIdentifier()

◆ stripQuotedIdentifier()

Member Data Documentation

◆ BINARY_OPERATOR_TEXT

◆ JOIN_TYPE_TEXT

◆ mAllowFragments

◆ mParserErrorString

◆ mRootNode

◆ mStatement

◆ UNARY_OPERATOR_TEXT