Ejemplo n.º 1
0
        public static QsiDataDeleteActionNode VisitDeleteStatement(DeleteStatementContext context)
        {
            var partitionRestriction = context.partitionRestriction();
            var whereClause          = context.whereClause();
            var hintClause           = context.hintClause();

            QsiTableNode tableNode = new HanaTableReferenceNode
            {
                Identifier = context.tableName().qqi
            };

            if (partitionRestriction != null)
            {
                ((HanaTableReferenceNode)tableNode).Partition.Value = TreeHelper.Fragment(partitionRestriction.GetInputText());
            }

            if (whereClause != null || hintClause != null)
            {
                var derivedTableNode = new HanaDerivedTableNode
                {
                    Columns = { Value = TreeHelper.CreateAllColumnsDeclaration() },
                    Source  = { Value = tableNode }
                };

                if (whereClause != null)
                {
                    derivedTableNode.Where.Value = ExpressionVisitor.VisitWhereClause(whereClause);
                }

                if (hintClause != null)
                {
                    derivedTableNode.Hint.Value = TreeHelper.Fragment(hintClause.GetInputText());
                }

                tableNode = derivedTableNode;
            }

            var node = new QsiDataDeleteActionNode
            {
                Target = { Value = tableNode }
            };

            HanaTree.PutContextSpan(node, context);

            return(node);
        }
Ejemplo n.º 2
0
        public static QsiTableNode VisitSelectStatement(SelectStatementContext context)
        {
            var withClause = context.withClause();
            var subquery   = context.subquery();
            var forClause  = context.forClause();
            var timeTravel = context.timeTravel();
            var hintClause = context.hintClause();

            var subqueryNode = VisitSubquery(subquery);

            if (withClause is null && forClause is null && timeTravel is null && hintClause is null)
            {
                return(subqueryNode);
            }

            if (subqueryNode is not HanaDerivedTableNode derivedTableNode)
            {
                derivedTableNode = new HanaDerivedTableNode
                {
                    Columns = { Value = TreeHelper.CreateAllColumnsDeclaration() },
                    Source  = { Value = subqueryNode }
                };
            }

            if (withClause is not null)
            {
                derivedTableNode.Directives.SetValue(VisitWithClause(withClause));
            }

            if (forClause is not null)
            {
                derivedTableNode.Behavior.SetValue(VisitForClause(forClause));
            }

            if (timeTravel is not null)
            {
                derivedTableNode.TimeTravel.SetValue(TreeHelper.Fragment(timeTravel.GetInputText()));
            }

            if (hintClause is not null)
            {
                derivedTableNode.Hint.SetValue(TreeHelper.Fragment(hintClause.GetInputText()));
            }

            return(derivedTableNode);
        }