Пример #1
0
        protected override void Visit(LikeOperator op, bool not)
        {
            if (op.Right is PatternList pat)
            {
                var pattern = default(StringLiteral);
                var isRegex = false;
                try
                {
                    pattern = new StringLiteral(Oracle.Render(pat));
                }
                catch (NotSupportedException)
                {
                    var writer = new RegexWriter();
                    pat.Visit(writer);
                    pattern = new StringLiteral(writer.ToString());
                    isRegex = true;
                }

                AddParenthesesIfNeeded(op, () =>
                {
                    if (isRegex)
                    {
                        if (not)
                        {
                            Writer.Write(" not ");
                        }
                        Writer.Write("regexp_like(");
                        op.Left.Visit(this);
                        Writer.Write(",");
                        pattern.Visit(this);
                        Writer.Write(", 'i')");
                    }
                    else
                    {
                        op.Left.Visit(this);
                        Writer.Write((not ? " not" : "") + " like ");
                        pattern.Visit(this);
                    }
                });
            }
            else
            {
                base.Visit(op, not);
            }
        }