Class: QgsSQLStatement¶

Parses SQL statements.

List of all members, including inherited members

Class Hierarchy¶

Subclasses¶

QgsSQLStatementFragment

Parses fragments of SQL statements, such as an expression or where clause.

Classes

`Node`	Abstract node class for SQL statement nodes.
`NodeBetweenOperator`	An 'X BETWEEN y and z' operator.
`NodeBinaryOperator`	Binary logical/arithmetical operator (AND, OR, =, +, ...).
`NodeCast`	CAST operator.
`NodeColumnRef`	Reference to a column.
`NodeColumnSorted`	Column in a ORDER BY.
`NodeFunction`	Function with a name and arguments node.
`NodeInOperator`	An 'x IN (y, z)' operator.
`NodeJoin`	Join definition.
`NodeList`	A list of nodes.
`NodeLiteral`	Literal value (integer, integer64, double, string).
`NodeSelect`	SELECT node.
`NodeSelectedColumn`	Selected column.
`NodeTableDef`	Table definition.
`NodeUnaryOperator`	Unary logical/arithmetical operator ( NOT, - ).
`RecursiveVisitor`	A visitor that recursively explores all children.
`Visitor`	Support for visitor pattern - algorithms dealing with the statement may be implemented without modifying the Node classes.

Enums

`BinaryOperator`
`JoinType`
`NodeType`
`UnaryOperator`

Methods

`acceptVisitor`	Entry function for the visitor pattern
`doBasicValidationChecks`	Performs basic validity checks.
`dump`	Returns the statement string, constructed from the internal abstract syntax tree.
`hasParserError`	Returns `True` if an error occurred when parsing the input statement
`parserErrorString`	Returns parser error
`rootNode`	Returns the root node of the statement.
`statement`	Returns the original, unmodified statement string.

Static Methods

`quotedIdentifier`	Returns a quoted column reference (in double quotes)
`quotedIdentifierIfNeeded`	Returns a quoted column reference (in double quotes) if needed, or otherwise the original string.
`quotedString`	Returns a quoted version of a string (in single quotes)
`stripMsQuotedIdentifier`	Remove double quotes from an Microsoft style identifier.
`stripQuotedIdentifier`	Remove double quotes from an identifier.

class qgis.core.QgsSQLStatement[source]¶

Bases: object

__init__(statement: str | None)

Creates a new statement based on the provided string.

Parameters:: statement (Optional[str])

__init__(other: QgsSQLStatement)

Parameters:: other (QgsSQLStatement)

__init__(statement: str | None, allowFragments: bool)

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.

Added in version 3.16.

Parameters:

statement (Optional[str])
allowFragments (bool)

class BinaryOperator(*values)¶

Bases: IntEnum

boAnd = 1¶

boConcat = 21¶

boDiv = 17¶

boEQ = 2¶

boGE = 5¶

boGT = 7¶

boILike = 10¶

boIntDiv = 18¶

boIs = 12¶

boIsNot = 13¶

boLE = 4¶

boLT = 6¶

boLike = 8¶

boMinus = 15¶

boMod = 19¶

boMul = 16¶

boNE = 3¶

boNotILike = 11¶

boNotLike = 9¶

boOr = 0¶

boPlus = 14¶

boPow = 20¶

class JoinType(*values)¶

Bases: IntEnum

jtCross = 5¶

jtDefault = 0¶

jtFull = 7¶

jtInner = 6¶

jtLeft = 1¶

jtLeftOuter = 2¶

jtRight = 3¶

jtRightOuter = 4¶

class Node[source]¶

Bases: object

Abstract node class for SQL statement nodes.

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Support the visitor pattern.

For any implementation this should look like

v.visit(self)

Parameters:: v (QgsSQLStatement.Visitor) – A visitor that visits this node.

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Generate a clone of this node. Make sure that the clone does not contain any information which is generated in prepare and context related. Ownership is transferred to the caller.

Return type:: Optional[QgsSQLStatement.Node]
Returns:: a deep copy of this node.

abstract dump(self) → str[source]¶

Abstract virtual dump method

Return type:: str
Returns:: A statement which represents this node as string

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Abstract virtual that returns the type of this node.

Return type:: QgsSQLStatement.NodeType
Returns:: The type of this node

class NodeBetweenOperator[source]¶

Bases: Node

An ‘X BETWEEN y and z’ operator.

__init__(node: QgsSQLStatement.Node | None, minVal: QgsSQLStatement.Node | None, maxVal: QgsSQLStatement.Node | None, notBetween: bool = False)

Constructor

Parameters:

node (Optional[QgsSQLStatement.Node])
minVal (Optional[QgsSQLStatement.Node])
maxVal (Optional[QgsSQLStatement.Node])
notBetween (bool = False)

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

abstract dump(self) → str[source]¶

Return type:: str

isNotBetween(self) → bool[source]¶

Whether this is a NOT BETWEEN operator

Return type:: bool

maxVal(self) → QgsSQLStatement.Node | None[source]¶

Maximum bound

Return type:: Optional[QgsSQLStatement.Node]

minVal(self) → QgsSQLStatement.Node | None[source]¶

Minimum bound

Return type:: Optional[QgsSQLStatement.Node]

node(self) → QgsSQLStatement.Node | None[source]¶

Variable at the left of BETWEEN

Return type:: Optional[QgsSQLStatement.Node]

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

class NodeBinaryOperator[source]¶

Bases: Node

Binary logical/arithmetical operator (AND, OR, =, +, …).

__init__(op: QgsSQLStatement.BinaryOperator, opLeft: QgsSQLStatement.Node | None, opRight: QgsSQLStatement.Node | None)

Constructor

Parameters:

op (QgsSQLStatement.BinaryOperator)
opLeft (Optional[QgsSQLStatement.Node])
opRight (Optional[QgsSQLStatement.Node])

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

abstract dump(self) → str[source]¶

Return type:: str

leftAssociative(self) → bool[source]¶

Is left associative ?

Return type:: bool

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

op(self) → QgsSQLStatement.BinaryOperator[source]¶

Operator

Return type:: QgsSQLStatement.BinaryOperator

opLeft(self) → QgsSQLStatement.Node | None[source]¶

Left operand

Return type:: Optional[QgsSQLStatement.Node]

opRight(self) → QgsSQLStatement.Node | None[source]¶

Right operand

Return type:: Optional[QgsSQLStatement.Node]

precedence(self) → int[source]¶

Precedence

Return type:: int

text(self) → str[source]¶

Returns a the name of this operator without the operands. I.e. “AND”, “OR”, …

Added in version 4.2.

Return type:: str

class NodeCast[source]¶

Bases: Node

CAST operator.

__init__(node: QgsSQLStatement.Node | None, type: str | None)

Constructor

Parameters:

node (Optional[QgsSQLStatement.Node])
type (Optional[str])

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

abstract dump(self) → str[source]¶

Return type:: str

node(self) → QgsSQLStatement.Node | None[source]¶

Node that is referred to

Return type:: Optional[QgsSQLStatement.Node]

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

type(self) → str[source]¶

Type

Return type:: str

class NodeColumnRef[source]¶

Bases: Node

Reference to a column.

__init__(name: str | None, star: bool)

Constructor with column name only

Parameters:

name (Optional[str])
star (bool)

__init__(tableName: str | None, name: str | None, star: bool)

Constructor with table and column name

Parameters:

tableName (Optional[str])
name (Optional[str])
star (bool)

__init__(a0: QgsSQLStatement.NodeColumnRef)

Parameters:: a0 (QgsSQLStatement.NodeColumnRef)

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

cloneThis(self) → QgsSQLStatement.NodeColumnRef | None[source]¶

Clone with same type return

Return type:: Optional[QgsSQLStatement.NodeColumnRef]

distinct(self) → bool[source]¶

Whether this is prefixed by DISTINCT

Return type:: bool

abstract dump(self) → str[source]¶

Return type:: str

name(self) → str[source]¶

The name of the column.

Return type:: str

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

setDistinct(self, distinct: bool = True)[source]¶

Sets whether this is prefixed by DISTINCT

Parameters:: distinct (bool = True)

star(self) → bool[source]¶

Whether this is the * column

Return type:: bool

tableName(self) → str[source]¶

The name of the table. May be empty.

Return type:: str

class NodeColumnSorted[source]¶

Bases: Node

Column in a ORDER BY.

__init__(column: QgsSQLStatement.NodeColumnRef | None, asc: bool)

Constructor

Parameters:

column (Optional[QgsSQLStatement.NodeColumnRef])
asc (bool)

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

ascending(self) → bool[source]¶

Whether the column is sorted in ascending order

Return type:: bool

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

cloneThis(self) → QgsSQLStatement.NodeColumnSorted | None[source]¶

Clone with same type return

Return type:: Optional[QgsSQLStatement.NodeColumnSorted]

column(self) → QgsSQLStatement.NodeColumnRef | None[source]¶

The name of the column.

Return type:: Optional[QgsSQLStatement.NodeColumnRef]

abstract dump(self) → str[source]¶

Return type:: str

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

class NodeFunction[source]¶

Bases: Node

Function with a name and arguments node.

__init__(name: str | None, args: QgsSQLStatement.NodeList | None)

Constructor

Parameters:

name (Optional[str])
args (Optional[QgsSQLStatement.NodeList])

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

args(self) → QgsSQLStatement.NodeList | None[source]¶

Returns arguments

Return type:: Optional[QgsSQLStatement.NodeList]

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

abstract dump(self) → str[source]¶

Return type:: str

name(self) → str[source]¶

Returns function name

Return type:: str

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

class NodeInOperator[source]¶

Bases: Node

An ‘x IN (y, z)’ operator.

__init__(node: QgsSQLStatement.Node | None, list: QgsSQLStatement.NodeList | None, notin: bool = False)

Constructor

Parameters:

node (Optional[QgsSQLStatement.Node])
list (Optional[QgsSQLStatement.NodeList])
notin (bool = False)

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

abstract dump(self) → str[source]¶

Return type:: str

isNotIn(self) → bool[source]¶

Whether this is a NOT IN operator

Return type:: bool

list(self) → QgsSQLStatement.NodeList | None[source]¶

Values list

Return type:: Optional[QgsSQLStatement.NodeList]

node(self) → QgsSQLStatement.Node | None[source]¶

Variable at the left of IN

Return type:: Optional[QgsSQLStatement.Node]

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

class NodeJoin[source]¶

Bases: Node

Join definition.

__init__(tabledef: QgsSQLStatement.NodeTableDef | None, onExpr: QgsSQLStatement.Node | None, type: QgsSQLStatement.JoinType)

Constructor with table definition, ON expression

Parameters:

tabledef (Optional[QgsSQLStatement.NodeTableDef])
onExpr (Optional[QgsSQLStatement.Node])
type (QgsSQLStatement.JoinType)

__init__(tabledef: QgsSQLStatement.NodeTableDef | None, usingColumns: Iterable[str | None], type: QgsSQLStatement.JoinType)

Constructor with table definition and USING columns

Parameters:

tabledef (Optional[QgsSQLStatement.NodeTableDef])
usingColumns (Iterable[Optional[str]])
type (QgsSQLStatement.JoinType)

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

cloneThis(self) → QgsSQLStatement.NodeJoin | None[source]¶

Clone with same type return

Return type:: Optional[QgsSQLStatement.NodeJoin]

abstract dump(self) → str[source]¶

Return type:: str

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

onExpr(self) → QgsSQLStatement.Node | None[source]¶

On expression. Will be None if usingColumns() is not empty

Return type:: Optional[QgsSQLStatement.Node]

tableDef(self) → QgsSQLStatement.NodeTableDef | None[source]¶

Table definition

Return type:: Optional[QgsSQLStatement.NodeTableDef]

type(self) → QgsSQLStatement.JoinType[source]¶

Join type

Return type:: QgsSQLStatement.JoinType

usingColumns(self) → list[str]¶

Columns referenced by USING

Return type:: list[str]

class NodeList[source]¶

Bases: object

A list of nodes.

accept(self, v: QgsSQLStatement.Visitor)[source]¶

Accept visitor

Parameters:: v (QgsSQLStatement.Visitor)

append(self, node: QgsSQLStatement.Node | None)[source]¶

Takes ownership of the provided node

Parameters:: node (Optional[QgsSQLStatement.Node])

clone(self) → QgsSQLStatement.NodeList | None[source]¶

Creates a deep copy of this list. Ownership is transferred to the caller

Return type:: Optional[QgsSQLStatement.NodeList]

count(self) → int[source]¶

Returns the number of nodes in the list.

Return type:: int

virtual dump(self) → str[source]¶

Dump list

Return type:: str

list(self) → list[QgsSQLStatement.Node]¶

Returns list

Return type:: list[QgsSQLStatement.Node]

class NodeLiteral[source]¶

Bases: Node

Literal value (integer, integer64, double, string).

__init__(value: Any)

Constructor

Parameters:: value (Any)

__init__(a0: QgsSQLStatement.NodeLiteral)

Parameters:: a0 (QgsSQLStatement.NodeLiteral)

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

abstract dump(self) → str[source]¶

Return type:: str

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

value(self) → Any[source]¶

The value of the literal.

Return type:: Any

valueAsString(self) → str[source]¶

Returns a string representation of the node’s literal value.

Added in version 4.2.

Return type:: str

class NodeSelect[source]¶

Bases: Node

SELECT node.

__init__(tableList: Iterable[QgsSQLStatement.NodeTableDef], columns: Iterable[QgsSQLStatement.NodeSelectedColumn], distinct: bool)

Constructor

Parameters:

tableList (Iterable[QgsSQLStatement.NodeTableDef])
columns (Iterable[QgsSQLStatement.NodeSelectedColumn])
distinct (bool)

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

appendJoin(self, join: QgsSQLStatement.NodeJoin | None)[source]¶

Append a join

Parameters:: join (Optional[QgsSQLStatement.NodeJoin])

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

columns(self) → list[QgsSQLStatement.NodeSelectedColumn]¶

Returns the list of columns

Return type:: list[QgsSQLStatement.NodeSelectedColumn]

distinct(self) → bool[source]¶

Returns if the SELECT is DISTINCT

Return type:: bool

abstract dump(self) → str[source]¶

Return type:: str

joins(self) → list[QgsSQLStatement.NodeJoin]¶

Returns the list of joins

Return type:: list[QgsSQLStatement.NodeJoin]

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

orderBy(self) → list[QgsSQLStatement.NodeColumnSorted]¶

Returns the list of order by columns

Return type:: list[QgsSQLStatement.NodeColumnSorted]

setJoins(self, joins: Iterable[QgsSQLStatement.NodeJoin])[source]¶

Sets joins

Parameters:: joins (Iterable[QgsSQLStatement.NodeJoin])

setOrderBy(self, orderBy: Iterable[QgsSQLStatement.NodeColumnSorted])[source]¶

Sets order by columns

Parameters:: orderBy (Iterable[QgsSQLStatement.NodeColumnSorted])

setWhere(self, where: QgsSQLStatement.Node | None)[source]¶

Sets where clause

Parameters:: where (Optional[QgsSQLStatement.Node])

tables(self) → list[QgsSQLStatement.NodeTableDef]¶

Returns the list of tables

Return type:: list[QgsSQLStatement.NodeTableDef]

where(self) → QgsSQLStatement.Node | None[source]¶

Returns the where clause

Return type:: Optional[QgsSQLStatement.Node]

class NodeSelectedColumn[source]¶

Bases: Node

Selected column.

__init__(node: QgsSQLStatement.Node | None)

Constructor

Parameters:: node (Optional[QgsSQLStatement.Node])

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

alias(self) → str[source]¶

Alias name

Return type:: str

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

cloneThis(self) → QgsSQLStatement.NodeSelectedColumn | None[source]¶

Clone with same type return

Return type:: Optional[QgsSQLStatement.NodeSelectedColumn]

column(self) → QgsSQLStatement.Node | None[source]¶

Column that is referred to

Return type:: Optional[QgsSQLStatement.Node]

abstract dump(self) → str[source]¶

Return type:: str

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

setAlias(self, alias: str | None)[source]¶

Sets alias name

Parameters:: alias (Optional[str])

class NodeTableDef[source]¶

Bases: Node

Table definition.

__init__(name: str | None)

Constructor with table name

Parameters:: name (Optional[str])

__init__(name: str | None, alias: str | None)

Constructor with table name and alias

Parameters:

name (Optional[str])
alias (Optional[str])

__init__(schema: str | None, name: str | None, alias: str | None)

Constructor with schema, table name and alias

Added in version 3.28.

Parameters:

schema (Optional[str])
name (Optional[str])
alias (Optional[str])

__init__(a0: QgsSQLStatement.NodeTableDef)

Parameters:: a0 (QgsSQLStatement.NodeTableDef)

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

alias(self) → str[source]¶

Table alias

Return type:: str

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

cloneThis(self) → QgsSQLStatement.NodeTableDef | None[source]¶

Clone with same type return

Return type:: Optional[QgsSQLStatement.NodeTableDef]

abstract dump(self) → str[source]¶

Return type:: str

name(self) → str[source]¶

Table name

Return type:: str

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

schema(self) → str[source]¶

Returns the schema name.

Added in version 3.28.

Return type:: str

class NodeType(*values)¶

Bases: IntEnum

ntBetweenOperator = 3¶

ntBinaryOperator = 1¶

ntCast = 12¶

ntColumnRef = 6¶

ntColumnSorted = 11¶

ntFunction = 4¶

ntInOperator = 2¶

ntJoin = 10¶

ntLiteral = 5¶

ntSelect = 8¶

ntSelectedColumn = 7¶

ntTableDef = 9¶

ntUnaryOperator = 0¶

class NodeUnaryOperator[source]¶

Bases: Node

Unary logical/arithmetical operator ( NOT, - ).

__init__(op: QgsSQLStatement.UnaryOperator, operand: QgsSQLStatement.Node | None)

Constructor

Parameters:

op (QgsSQLStatement.UnaryOperator)
operand (Optional[QgsSQLStatement.Node])

abstract accept(self, v: QgsSQLStatement.Visitor)[source]¶

Parameters:: v (QgsSQLStatement.Visitor)

abstract clone(self) → QgsSQLStatement.Node | None[source]¶

Return type:: Optional[QgsSQLStatement.Node]

abstract dump(self) → str[source]¶

Return type:: str

abstract nodeType(self) → QgsSQLStatement.NodeType[source]¶

Return type:: QgsSQLStatement.NodeType

op(self) → QgsSQLStatement.UnaryOperator[source]¶

Operator

Return type:: QgsSQLStatement.UnaryOperator

operand(self) → QgsSQLStatement.Node | None[source]¶

Operand

Return type:: Optional[QgsSQLStatement.Node]

text(self) → str[source]¶

Returns a the name of this operator without the operands. I.e. “NOT” or “-”

Added in version 4.2.

Return type:: str

class RecursiveVisitor[source]¶

Bases: Visitor

A visitor that recursively explores all children.

abstract visit(self, n: QgsSQLStatement.NodeUnaryOperator)[source]¶

abstract visit(self, n: QgsSQLStatement.NodeBinaryOperator)

abstract visit(self, n: QgsSQLStatement.NodeInOperator)

abstract visit(self, n: QgsSQLStatement.NodeBetweenOperator)

abstract visit(self, n: QgsSQLStatement.NodeFunction)

abstract visit(self, a0: QgsSQLStatement.NodeLiteral)

abstract visit(self, a0: QgsSQLStatement.NodeColumnRef)

abstract visit(self, n: QgsSQLStatement.NodeSelectedColumn)

abstract visit(self, a0: QgsSQLStatement.NodeTableDef)

abstract visit(self, n: QgsSQLStatement.NodeSelect)

abstract visit(self, n: QgsSQLStatement.NodeJoin)

abstract visit(self, n: QgsSQLStatement.NodeColumnSorted)

abstract visit(self, n: QgsSQLStatement.NodeCast)

Parameters:: n (QgsSQLStatement.NodeUnaryOperator)

class UnaryOperator(*values)¶

Bases: IntEnum

uoMinus = 1¶

uoNot = 0¶

class Visitor[source]¶

Bases: object

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

abstract visit(self, n: QgsSQLStatement.NodeUnaryOperator)[source]¶

Visit NodeUnaryOperator

visit(self, n: QgsSQLStatement.NodeBinaryOperator) Visit NodeBinaryOperator

visit(self, n: QgsSQLStatement.NodeInOperator) Visit NodeInOperator

visit(self, n: QgsSQLStatement.NodeBetweenOperator) Visit NodeBetweenOperator

visit(self, n: QgsSQLStatement.NodeFunction) Visit NodeFunction

visit(self, n: QgsSQLStatement.NodeLiteral) Visit NodeLiteral

visit(self, n: QgsSQLStatement.NodeColumnRef) Visit NodeColumnRef

visit(self, n: QgsSQLStatement.NodeSelectedColumn) Visit NodeSelectedColumn

visit(self, n: QgsSQLStatement.NodeTableDef) Visit NodeTableDef

visit(self, n: QgsSQLStatement.NodeSelect) Visit NodeSelect

visit(self, n: QgsSQLStatement.NodeJoin) Visit NodeJoin

visit(self, n: QgsSQLStatement.NodeColumnSorted) Visit NodeColumnSorted

visit(self, n: QgsSQLStatement.NodeCast) Visit NodeCast

Parameters:: n (QgsSQLStatement.NodeUnaryOperator)

acceptVisitor(self, v: QgsSQLStatement.Visitor)[source]¶

Entry function for the visitor pattern

Parameters:: v (QgsSQLStatement.Visitor)

boAnd = 1¶

boConcat = 21¶

boDiv = 17¶

boEQ = 2¶

boGE = 5¶

boGT = 7¶

boILike = 10¶

boIntDiv = 18¶

boIs = 12¶

boIsNot = 13¶

boLE = 4¶

boLT = 6¶

boLike = 8¶

boMinus = 15¶

boMod = 19¶

boMul = 16¶

boNE = 3¶

boNotILike = 11¶

boNotLike = 9¶

boOr = 0¶

boPlus = 14¶

boPow = 20¶

doBasicValidationChecks(self)[source]¶

Performs basic validity checks. Basically checking that columns referencing a table, references a specified table. Returns True if the validation is successful

Return type:: (bool, str)

dump(self) → str[source]¶

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.

Return type:: str

hasParserError(self) → bool[source]¶

Returns True if an error occurred when parsing the input statement

Return type:: bool

jtCross = 5¶

jtDefault = 0¶

jtFull = 7¶

jtInner = 6¶

jtLeft = 1¶

jtLeftOuter = 2¶

jtRight = 3¶

jtRightOuter = 4¶

ntBetweenOperator = 3¶

ntBinaryOperator = 1¶

ntCast = 12¶

ntColumnRef = 6¶

ntColumnSorted = 11¶

ntFunction = 4¶

ntInOperator = 2¶

ntJoin = 10¶

ntLiteral = 5¶

ntSelect = 8¶

ntSelectedColumn = 7¶

ntTableDef = 9¶

ntUnaryOperator = 0¶

parserErrorString(self) → str[source]¶

Returns parser error

Return type:: str

static quotedIdentifier(name: str | None) → str[source]¶

Returns a quoted column reference (in double quotes)

See also

quotedString()

See also

quotedIdentifierIfNeeded()

Parameters:: name (Optional[str])
Return type:: str

static quotedIdentifierIfNeeded(name: str | None) → str[source]¶

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

See also

quotedString()

See also

quotedIdentifier()

Parameters:: name (Optional[str])
Return type:: str

static quotedString(text: str | None) → str[source]¶

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

See also

quotedIdentifier()

See also

quotedIdentifierIfNeeded()

Parameters:: text (Optional[str])
Return type:: str

rootNode(self) → QgsSQLStatement.Node | None[source]¶

Returns the root node of the statement. The root node is None if parsing has failed.

Return type:: Optional[QgsSQLStatement.Node]

statement(self) → str[source]¶

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.

Return type:: str

static stripMsQuotedIdentifier(text: str | None) → str[source]¶

Remove double quotes from an Microsoft style identifier.

See also

quotedIdentifier()

Parameters:: text (Optional[str])
Return type:: str

static stripQuotedIdentifier(text: str | None) → str[source]¶

Remove double quotes from an identifier.

See also

quotedIdentifier()

Parameters:: text (Optional[str])
Return type:: str

uoMinus = 1¶

uoNot = 0¶