Deveel.Data.Sql.Expressions.ExpressionStringBuilder Class Reference

Inheritance diagram for Deveel.Data.Sql.Expressions.ExpressionStringBuilder:

Public Member Functions
	ExpressionStringBuilder ()
string	ToSqlString (SqlExpression expression)
override SqlExpression	VisitAssign (SqlAssignExpression assign)
override SqlExpression	VisitBinary (SqlBinaryExpression binaryEpression)
override SqlExpression	VisitCast (SqlCastExpression castExpression)
override SqlExpression	VisitConditional (SqlConditionalExpression conditional)
override SqlExpression	VisitConstant (SqlConstantExpression constant)
override SqlExpression	VisitFunctionCall (SqlFunctionCallExpression expression)
	Visits the expression that calls the function defined. More...
override SqlExpression	VisitQuery (SqlQueryExpression query)
override SqlExpression	VisitReference (SqlReferenceExpression reference)
override SqlExpression	VisitTuple (SqlTupleExpression expression)
override SqlExpression	VisitUnary (SqlUnaryExpression unary)
override SqlExpression	VisitVariableReference (SqlVariableReferenceExpression reference)
Public Member Functions inherited from Deveel.Data.Sql.Expressions.SqlExpressionVisitor
virtual SqlExpression	Visit (SqlExpression expression)
	Visits a given SQL expression. More...
virtual SqlExpression[]	VisitExpressionList (SqlExpression[] list)
	Visits a list of expressions given. More...

Private Member Functions
void	PrintQueryColumns (IEnumerable< SelectColumn > selectColumns)
void	PrintFromClause (FromClause fromClause)
string	GetUnaryOperatorString (SqlExpressionType unaryType)

Static Private Member Functions
static string	GetBinaryOperatorString (SqlExpressionType expressionType)

Private Attributes
readonly StringBuilder	builder
bool	rootQuery = true

Detailed Description

Definition at line 26 of file ExpressionStringBuilder.cs.

Constructor & Destructor Documentation

Deveel.Data.Sql.Expressions.ExpressionStringBuilder.ExpressionStringBuilder ( )

inline

Definition at line 30 of file ExpressionStringBuilder.cs.

                                         {
            builder = new StringBuilder();
        }

Member Function Documentation

static string Deveel.Data.Sql.Expressions.ExpressionStringBuilder.GetBinaryOperatorString ( SqlExpressionType  expressionType )

inlinestaticprivate

Definition at line 60 of file ExpressionStringBuilder.cs.

                                                                                        {
            switch (expressionType) {
                case SqlExpressionType.Add:
                    return "+";
                case SqlExpressionType.Subtract:
                    return "-";
                case SqlExpressionType.Divide:
                    return "/";
                case SqlExpressionType.Multiply:
                    return "*";
                case SqlExpressionType.Modulo:
                    return "%";
                case SqlExpressionType.Equal:
                    return "=";
                case SqlExpressionType.NotEqual:
                    return "<>";
                case SqlExpressionType.GreaterThan:
                    return ">";
                case SqlExpressionType.GreaterOrEqualThan:
                    return ">=";
                case SqlExpressionType.SmallerThan:
                    return "<";
                case SqlExpressionType.SmallerOrEqualThan:
                    return "<=";
                case SqlExpressionType.Is:
                    return "IS";
                case SqlExpressionType.IsNot:
                    return "IS NOT";
                case SqlExpressionType.Like:
                    return "LIKE";
                case SqlExpressionType.NotLike:
                    return "NOT LIKE";
                case SqlExpressionType.AllEqual:
                    return "= ALL";
                case SqlExpressionType.AllNotEqual:
                    return "<> ALL";
                case SqlExpressionType.AllGreaterThan:
                    return "> ALL";
                case SqlExpressionType.AllGreaterOrEqualThan:
                    return ">= ALL";
                case SqlExpressionType.AllSmallerThan:
                    return "< ALL";
                case SqlExpressionType.AllSmallerOrEqualThan:
                    return "<= ALL";
                case SqlExpressionType.AnyEqual:
                    return "= ANY";
                case SqlExpressionType.AnyNotEqual:
                    return "<> ANY";
                case SqlExpressionType.AnyGreaterThan:
                    return "> ANY";
                case SqlExpressionType.AnyGreaterOrEqualThan:
                    return ">= ANY";
                case SqlExpressionType.AnySmallerThan:
                    return "< ANY";
                case SqlExpressionType.AnySmallerOrEqualThan:
                    return "<= ANY";
                case SqlExpressionType.Or:
                    return "OR";
                case SqlExpressionType.And:
                    return "AND";
                case SqlExpressionType.XOr:
                    return "XOR";
                default:
                    throw new NotSupportedException();
            }
        }

string Deveel.Data.Sql.Expressions.ExpressionStringBuilder.GetUnaryOperatorString ( SqlExpressionType  unaryType )

inlineprivate

Definition at line 339 of file ExpressionStringBuilder.cs.

                                                                           {
            switch (unaryType) {
                case SqlExpressionType.UnaryPlus:
                    return "+";
                case SqlExpressionType.Negate:
                    return "-";
                case SqlExpressionType.Not:
                    return "NOT";
                default:
                    throw new NotSupportedException();
            }
        }

void Deveel.Data.Sql.Expressions.ExpressionStringBuilder.PrintFromClause ( FromClause  fromClause )

inlineprivate

Definition at line 260 of file ExpressionStringBuilder.cs.

                                                            {
            if (fromClause == null || fromClause.IsEmpty)
                return;

            builder.Append("FROM ");

            var tables = fromClause.AllTables.ToList();
            for (int i = 0; i < tables.Count; i++) {
                var source = tables[i];

                JoinPart joinPart = null;

                if (i > 0) {
                    joinPart = fromClause.GetJoinPart(i - 1);
                    if (joinPart != null) {
                        if (joinPart.JoinType == JoinType.Inner) {
                            builder.Append(" INNER JOIN ");
                        } else if (joinPart.JoinType == JoinType.Right) {
                            builder.Append(" RIGHT OUTER JOIN ");
                        } else if (joinPart.JoinType == JoinType.Left) {
                            builder.Append(" LEFT OUTER JOIN ");
                        } else if (joinPart.JoinType == JoinType.Full) {
                            builder.Append(" FULL OUTER JOINT ");
                        }
                    }
                }

                if (source.IsSubQuery) {
                    builder.Append("(");
                    Visit(source.SubQuery);
                    builder.Append(")");
                } else {
                    builder.Append(source.Name);
                }

                if (!String.IsNullOrEmpty(source.Alias)) {
                    builder.Append(" AS ");
                    builder.Append(source.Alias);
                }

                if (i < tables.Count - 1) {
                    if (joinPart == null) {
                        builder.Append(", ");
                    } else {
                        builder.Append(" ON ");
                        Visit(joinPart.OnExpression);
                    }
                }
            }
        }

void Deveel.Data.Sql.Expressions.ExpressionStringBuilder.PrintQueryColumns ( IEnumerable< SelectColumn >  selectColumns )

inlineprivate

Definition at line 195 of file ExpressionStringBuilder.cs.

                                                                                {
            var columns = selectColumns.ToArray();
            var sz = columns.Length;
            for (int i = 0; i < sz; i++) {
                var column = columns[i];

                if (column.IsGlob) {
                    if (column.IsAll) {
                        builder.Append("*");
                    } else {
                        builder.AppendFormat("{0}.*", column.TableName);
                    }
                } else {
                    Visit(column.Expression);
                }

                if (!String.IsNullOrEmpty(column.Alias))
                    builder.AppendFormat(" AS {0}", column.Alias);

                if (i < sz - 1)
                    builder.Append(", ");
            }
        }

string Deveel.Data.Sql.Expressions.ExpressionStringBuilder.ToSqlString ( SqlExpression  expression )

inline

Definition at line 34 of file ExpressionStringBuilder.cs.

                                                            {
            rootQuery = expression is SqlQueryExpression;

            Visit(expression);
            return builder.ToString();
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitAssign ( SqlAssignExpression  assign )

inlinevirtual

Parameters

assign

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 41 of file ExpressionStringBuilder.cs.

                                                                              {
            Visit(assign.ReferenceExpression);
            builder.Append(" = ");
            Visit(assign.ValueExpression);

            return assign;
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitBinary ( SqlBinaryExpression  binaryEpression )

inlinevirtual

Parameters

binaryEpression

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 49 of file ExpressionStringBuilder.cs.

                                                                                       {
            Visit(binaryEpression.Left);

            var binaryOpString = GetBinaryOperatorString(binaryEpression.ExpressionType);
            builder.AppendFormat(" {0} ", binaryOpString);

            Visit(binaryEpression.Right);

            return binaryEpression;
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitCast ( SqlCastExpression  castExpression )

inlinevirtual

Parameters

castExpression

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 127 of file ExpressionStringBuilder.cs.

                                                                                  {
            builder.Append("CAST ");
            Visit(castExpression.Value);
            builder.Append(" AS ");
            builder.Append(castExpression.SqlType);

            return base.VisitCast(castExpression);
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitConditional ( SqlConditionalExpression  conditional )

inlinevirtual

Parameters

conditional

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 136 of file ExpressionStringBuilder.cs.

                                                                                             {
            return base.VisitConditional(conditional);
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitConstant ( SqlConstantExpression  constant )

inlinevirtual

Parameters

constant

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 140 of file ExpressionStringBuilder.cs.

                                                                                    {
            var value = constant.Value;
            if (value.Type is QueryType) {
                // TODO: convert to sql string also a QUERY PLAN
                builder.Append("({QUERY})");
            } else if (value.Type is ArrayType) {
                var array = (SqlArray) value.Value;
                if (array.IsNull) {
                    builder.Append("NULL");
                } else {
                    builder.Append("(");
                    var sz = array.Length;
                    for (int i = 0; i < sz; i++) {
                        Visit(array[i]);

                        if (i < sz - 1)
                            builder.Append(", ");
                    }
                    builder.Append(")");
                }
            } else if (value.Type is NullType) {
                builder.Append("NULL");
            } else if (value.Type.IsPrimitive) {
                if (value.IsNull) {
                    builder.Append("NULL");
                } else {
                    builder.Append(value.Value);
                }
            }

            return constant;
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitFunctionCall ( SqlFunctionCallExpression  expression )

inlinevirtual

Visits the expression that calls the function defined.

Parameters

expression

The SqlFunctionCallExpression to visit.

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 173 of file ExpressionStringBuilder.cs.

                                                                                              {
            builder.Append(expression.FunctioName);
            builder.Append("(");

            if (expression.Arguments != null &&
                expression.Arguments.Length > 0) {
                var args = expression.Arguments;
                var argc = args.Length;

                for (int i = 0; i < argc; i++) {
                    Visit(args[i]);

                    if (i < argc - 1)
                        builder.Append(", ");
                }
            }

            builder.Append(")");

            return expression;
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitQuery ( SqlQueryExpression  query )

inlinevirtual

Parameters

query

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 219 of file ExpressionStringBuilder.cs.

                                                                           {
            if (!rootQuery)
                builder.Append("(");

            builder.Append("SELECT ");
            if (query.Distinct)
                builder.Append("DISTINCT ");

            PrintQueryColumns(query.SelectColumns);
            builder.Append(" ");

            PrintFromClause(query.FromClause);

            if (query.WhereExpression != null) {
                builder.Append(" WHERE ");
                Visit(query.WhereExpression);
            }

            if (query.GroupBy != null) {
                builder.Append(" GROUP BY ");
                VisitExpressionList(query.GroupBy.ToArray());

                if (query.HavingExpression != null) {
                    builder.Append(" HVAING ");
                    Visit(query.HavingExpression);
                }
            }

            if (query.GroupMax != null) {
                builder.Append(" GROUP MAX ");
                builder.Append(query.GroupMax.FullName);
            }

            // TODO: COMPOSITE ...

            if (!rootQuery)
                builder.Append(")");

            return query;
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitReference ( SqlReferenceExpression  reference )

inlinevirtual

Parameters

reference

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 311 of file ExpressionStringBuilder.cs.

                                                                                       {
            builder.Append(reference.ReferenceName);
            return reference;
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitTuple ( SqlTupleExpression  expression )

inlinevirtual

Parameters

expression

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 316 of file ExpressionStringBuilder.cs.

                                                                                {
            builder.Append("(");

            var sz = expression.Expressions.Length;
            for (int i = 0; i < sz; i++) {
                Visit(expression.Expressions[i]);
                if (i < sz - 1)
                    builder.Append(", ");
            }

            builder.Append(")");
            return expression;
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitUnary ( SqlUnaryExpression  unary )

inlinevirtual

Parameters

unary

Returns

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 330 of file ExpressionStringBuilder.cs.

                                                                           {
            var unaryOpString = GetUnaryOperatorString(unary.ExpressionType);
            builder.Append(unaryOpString);
            builder.Append(" ");
            Visit(unary.Operand);

            return unary;
        }

override SqlExpression Deveel.Data.Sql.Expressions.ExpressionStringBuilder.VisitVariableReference ( SqlVariableReferenceExpression  reference )

inlinevirtual

Reimplemented from Deveel.Data.Sql.Expressions.SqlExpressionVisitor.

Definition at line 352 of file ExpressionStringBuilder.cs.

                                                                                                       {
            builder.AppendFormat(":{0}", reference.VariableName);
            return reference;
        }

Member Data Documentation

readonly StringBuilder Deveel.Data.Sql.Expressions.ExpressionStringBuilder.builder

private

Definition at line 27 of file ExpressionStringBuilder.cs.

bool Deveel.Data.Sql.Expressions.ExpressionStringBuilder.rootQuery = true

private

Definition at line 28 of file ExpressionStringBuilder.cs.

---

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

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data.Sql.Expressions/ExpressionStringBuilder.cs