22 static const QRegExp IDENTIFIER_RE(
"^[A-Za-z_\x80-\xff][A-Za-z0-9_\x80-\xff]*$" );
34 "=",
"<>",
"<=",
">=",
"<",
">",
"LIKE",
"NOT LIKE",
"ILIKE",
"NOT ILIKE",
"IS",
"IS NOT",
35 "+",
"-",
"*",
"/",
"//",
"%",
"^",
48 "",
"LEFT",
"LEFT OUTER",
"RIGHT",
"RIGHT OUTER",
"CROSS",
"INNER",
"FULL" 64 return tr(
"(no root)" );
71 return QStringLiteral(
"\"%1\"" ).arg( name.replace(
'\"', QLatin1String(
"\"\"" ) ) );
77 static const char *
const RESERVED_KEYWORDS[] =
79 "AND",
"OR",
"NOT",
"LIKE",
"IN",
"IS",
"BETWEEN",
"NULL",
"SELECT",
"ALL",
"DISTINCT",
"CAST",
"AS",
80 "FROM",
"JOIN",
"ON",
"USING",
"WHERE",
"ORDER",
"BY",
"ASC",
"DESC",
81 "LEFT",
"RIGHT",
"INNER",
"OUTER",
"CROSS",
"FULL",
"NATURAL",
"UNION",
82 "OFFSET",
"LIMIT",
"GROUP",
"HAVING" 85 for (
size_t i = 0; i <
sizeof( RESERVED_KEYWORDS ) /
sizeof( RESERVED_KEYWORDS[0] ); ++i )
87 if ( name.compare( QString( RESERVED_KEYWORDS[i] ), Qt::CaseInsensitive ) == 0 )
97 if ( text.length() >= 2 && text[0] ==
'"' && text[text.length() - 1] ==
'"' )
100 text = text.mid( 1, text.length() - 2 );
103 text.replace( QLatin1String(
"\"\"" ), QLatin1String(
"\"" ) );
110 text.replace(
'\'', QLatin1String(
"''" ) );
111 text.replace(
'\\', QLatin1String(
"\\\\" ) );
112 text.replace(
'\n', QLatin1String(
"\\n" ) );
113 text.replace(
'\t', QLatin1String(
"\\t" ) );
114 return QStringLiteral(
"'%1'" ).arg( text );
131 if ( &other !=
this )
223 tableNamesDeclared.insert( n.
alias().isEmpty() ? n.
name() : n.
alias() );
232 errorMsgOut = tr(
"No root node" );
242 if ( !errorMsgOut.isEmpty() )
243 errorMsgOut += QLatin1String(
" " );
244 errorMsgOut += QString( tr(
"Table %1 is referenced by column %2, but not selected in FROM / JOIN." ) ).arg( pair.first, pair.second );
248 return errorMsgOut.isEmpty();
257 Q_FOREACH (
Node *node, mList )
269 Q_FOREACH (
Node *n, mList )
271 if ( !first ) msg += QLatin1String(
", " );
334 Q_ASSERT(
false &&
"unexpected binary operator" );
369 Q_ASSERT(
false &&
"unexpected binary operator" );
379 QString rdump( mOpRight->dump() );
384 rdump.prepend(
'(' ).append(
')' );
388 if ( leftAssociative() )
390 fmt += lOp && ( lOp->
precedence() < precedence() ) ?
"(%1)" :
"%1";
391 fmt += QLatin1String(
" %2 " );
392 fmt += rOp && ( rOp->
precedence() <= precedence() ) ?
"(%3)" :
"%3";
396 fmt += lOp && ( lOp->
precedence() <= precedence() ) ?
"(%1)" :
"%1";
397 fmt += QLatin1String(
" %2 " );
398 fmt += rOp && ( rOp->
precedence() < precedence() ) ?
"(%3)" :
"%3";
413 return QStringLiteral(
"%1 %2IN (%3)" ).arg( mNode->dump(), mNotIn ?
"NOT " :
"", mList->dump() );
418 return new NodeInOperator( mNode->clone(), mList->clone(), mNotIn );
425 return QStringLiteral(
"%1 %2BETWEEN %3 AND %4" ).arg( mNode->dump(), mNotBetween ?
"NOT " :
"", mMinVal->dump(), mMaxVal->dump() );
430 return new NodeBetweenOperator( mNode->clone(), mMinVal->clone(), mMaxVal->clone(), mNotBetween );
437 return QStringLiteral(
"%1(%2)" ).arg( mName, mArgs ? mArgs->dump() : QString() );
442 return new NodeFunction( mName, mArgs ? mArgs->clone() : nullptr );
449 if ( mValue.isNull() )
450 return QStringLiteral(
"NULL" );
452 switch ( mValue.type() )
455 return QString::number( mValue.toInt() );
456 case QVariant::LongLong:
457 return QString::number( mValue.toLongLong() );
458 case QVariant::Double:
459 return QString::number( mValue.toDouble() );
460 case QVariant::String:
463 return mValue.toBool() ?
"TRUE" :
"FALSE";
465 return tr(
"[unsupported type: %1; value: %2]" ).arg( mValue.typeName(), mValue.toString() );
480 ret += QLatin1String(
"DISTINCT " );
481 if ( !mTableName.isEmpty() )
507 ret += mColumnNode->dump();
508 if ( !mAlias.isEmpty() )
510 ret += QLatin1String(
" AS " );
533 if ( !mAlias.isEmpty() )
535 ret += QLatin1String(
" AS " );
555 qDeleteAll( mTableList );
556 qDeleteAll( mColumns );
557 qDeleteAll( mJoins );
559 qDeleteAll( mOrderBy );
564 QString ret = QStringLiteral(
"SELECT " );
566 ret += QLatin1String(
"DISTINCT " );
567 bool bFirstColumn =
true;
571 ret += QLatin1String(
", " );
572 bFirstColumn =
false;
573 ret += column->
dump();
575 ret += QLatin1String(
" FROM " );
576 bool bFirstTable =
true;
580 ret += QLatin1String(
", " );
582 ret += table->
dump();
591 ret += QLatin1String(
" WHERE " );
592 ret += mWhere->dump();
594 if ( !mOrderBy.isEmpty() )
596 ret += QLatin1String(
" ORDER BY " );
601 ret += QLatin1String(
", " );
603 ret += orderBy->
dump();
611 QList<QgsSQLStatement::NodeSelectedColumn *> newColumnList;
614 newColumnList.push_back( column->
cloneThis() );
616 QList<QgsSQLStatement::NodeTableDef *> newTableList;
619 newTableList.push_back( table->
cloneThis() );
628 newSelect->
setWhere( mWhere->clone() );
630 QList<QgsSQLStatement::NodeColumnSorted *> newOrderByList;
633 newOrderByList.push_back( columnSorted->
cloneThis() );
647 ret += QLatin1String(
" " );
649 ret += QLatin1String(
"JOIN " );
650 ret += mTableDef->dump();
653 ret += QLatin1String(
" ON " );
654 ret += mOnExpr->dump();
658 ret += QLatin1String(
" USING (" );
660 Q_FOREACH ( QString column, mUsingColumns )
663 ret += QLatin1String(
", " );
667 ret += QLatin1String(
")" );
680 return new NodeJoin( mTableDef->cloneThis(), mOnExpr->clone(), mType );
682 return new NodeJoin( mTableDef->cloneThis(), mUsingColumns, mType );
690 ret = mColumn->dump();
692 ret += QLatin1String(
" DESC" );
710 QString ret( QStringLiteral(
"CAST(" ) );
711 ret += mNode->dump();
712 ret += QLatin1String(
" AS " );
720 return new NodeCast( mNode->clone(), mType );
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
QgsSQLStatement::NodeTableDef * cloneThis() const
Clone with same type return.
static const char * JOIN_TYPE_TEXT[]
QgsSQLStatement::Node * onExpr() const
On expression. Will be nullptr if usingColumns() is not empty.
bool leftAssociative() const
Is left associative ?
void appendJoin(QgsSQLStatement::NodeJoin *join)
Append a join.
Function with a name and arguments node.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
QgsSQLStatement::NodeList * clone() const
Creates a deep copy of this list. Ownership is transferred to the caller.
QgsSQLStatement::NodeTableDef * tableDef() const
Table definition.
QgsSQLStatement::Node * where() const
Return the where clause.
QString dump() const override
Abstract virtual dump method.
QgsSQLStatement::NodeSelectedColumn * cloneThis() const
Clone with same type return.
static const char * BINARY_OPERATOR_TEXT[]
void visit(const QgsSQLStatement::NodeColumnRef &n) override
Visit NodeColumnRef.
QString dump() const override
Abstract virtual dump method.
QString statement() const
Return the original, unmodified statement string.
Binary logical/arithmetical operator (AND, OR, =, +, ...)
static QString quotedString(QString text)
Returns a quoted version of a string (in single quotes)
QString dump() const override
Abstract virtual dump method.
QList< QgsSQLStatement::NodeSelectedColumn * > columns() const
Return the list of columns.
bool hasParserError() const
Returns true if an error occurred when parsing the input statement.
QgsSQLStatement::Node * mRootNode
void accept(QgsSQLStatement::Visitor &v) const override
Support the visitor pattern.
void setWhere(QgsSQLStatement::Node *where)
Set where clause.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
A visitor that recursively explores all children.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
void accept(QgsSQLStatement::Visitor &v) const override
Support the visitor pattern.
Class for parsing SQL statements.
QString dump() const override
Abstract virtual dump method.
virtual QString dump() const
Dump list.
QPair< QString, QString > TableColumnPair
QString name() const
Table name.
QString alias() const
Table alias.
virtual QString dump() const =0
Abstract virtual dump method.
virtual QgsSQLStatement::Node * clone() const =0
Generate a clone of this node.
void accept(QgsSQLStatement::Visitor &v) const override
Support the visitor pattern.
QString dump() const override
Abstract virtual dump method.
void setOrderBy(const QList< QgsSQLStatement::NodeColumnSorted *> &orderBy)
Set order by columns.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
Literal value (integer, integer64, double, string)
QString name() const
The name of the column.
QList< QgsSQLStatement::NodeTableDef * > tables() const
Return the list of tables.
QString dump() const override
Abstract virtual dump method.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
void setAlias(const QString &alias)
Set alias name.
Unary logicial/arithmetical operator ( NOT, - )
const QgsSQLStatement::Node * rootNode() const
Returns root node of the statement. Root node is null is parsing has failed.
QgsSQLStatement::NodeJoin * cloneThis() const
Clone with same type return.
QString dump() const override
Abstract virtual dump method.
QString dump() const override
Abstract virtual dump method.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
QSet< TableColumnPair > tableNamesReferenced
QList< QgsSQLStatement::NodeColumnSorted * > orderBy() const
Return the list of order by columns.
QString parserErrorString() const
Returns parser error.
'X BETWEEN y and z' operator
QgsSQLStatement::NodeColumnRef * cloneThis() const
Clone with same type return.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
QList< QgsSQLStatement::NodeJoin * > joins() const
Return the list of joins.
void accept(QgsSQLStatement::Visitor &v) const override
Support the visitor pattern.
void acceptVisitor(QgsSQLStatement::Visitor &v) const
Entry function for the visitor pattern.
QString dump() const
Return statement string, constructed from the internal abstract syntax tree.
bool doBasicValidationChecks(QString &errorMsgOut) const
Performs basic validity checks.
QgsSQLStatement & operator=(const QgsSQLStatement &other)
Create a copy of this statement.
static QString stripQuotedIdentifier(QString text)
Remove double quotes from an identifier.
int precedence() const
Precedence.
virtual void accept(QgsSQLStatement::Visitor &v) const =0
Support the visitor pattern.
QgsSQLStatement::NodeColumnSorted * cloneThis() const
Clone with same type return.
QString dump() const override
Abstract virtual dump method.
void setDistinct(bool distinct=true)
Set whether this is prefixed by DISTINCT.
QString dump() const override
Abstract virtual dump method.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
static QString quotedIdentifierIfNeeded(const QString &name)
Returns a quoted column reference (in double quotes) if needed, or otherwise the original string...
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
void visit(const QgsSQLStatement::NodeUnaryOperator &n) override
Visit NodeUnaryOperator.
static const char * UNARY_OPERATOR_TEXT[]
Support for visitor pattern - algorithms dealing with the statement may be implemented without modify...
QSet< QString > tableNamesDeclared
QString tableName() const
The name of the table. May be empty.
QString dump() const override
Abstract virtual dump method.
QgsSQLStatement::Node * clone() const override
Generate a clone of this node.
QString dump() const override
Abstract virtual dump method.
QgsSQLStatement::UnaryOperator op() const
Operator.
QString dump() const override
Abstract virtual dump method.
static QString quotedIdentifier(QString name)
Returns a quoted column reference (in double quotes)
QgsSQLStatement::Node * parse(const QString &str, QString &parserErrorMsg)
'x IN (y, z)' operator
QgsSQLStatement(const QString &statement)
Creates a new statement based on the provided string.
QString mParserErrorString