Esempio n. 1
0
        public TSQLSetOperatorClause Parse(ITSQLTokenizer tokenizer)
        {
            TSQLSetOperatorClause set = null;

            if (tokenizer.Current.IsKeyword(TSQLKeywords.UNION))
            {
                set = new TSQLUnionClause();

                set.Tokens.Add(tokenizer.Current);

                if (tokenizer.MoveNext() &&
                    tokenizer.Current.IsKeyword(TSQLKeywords.ALL))
                {
                    set.Tokens.Add(tokenizer.Current);

                    tokenizer.MoveNext();
                }
            }
            else if (tokenizer.Current.IsKeyword(TSQLKeywords.EXCEPT))
            {
                set = new TSQLExceptClause();

                set.Tokens.Add(tokenizer.Current);

                tokenizer.MoveNext();
            }
            else if (tokenizer.Current.IsKeyword(TSQLKeywords.INTERSECT))
            {
                set = new TSQLIntersectClause();

                set.Tokens.Add(tokenizer.Current);

                tokenizer.MoveNext();
            }

            TSQLSelectStatement select = new TSQLLimitedSelectStatementParser(tokenizer).Parse();

            set.Select = select;

            set.Tokens.AddRange(select.Tokens);

            return(set);
        }
        public TSQLSetOperatorClause Parse(ITSQLTokenizer tokenizer)
        {
            TSQLSetOperatorClause set = null;

            if (tokenizer.Current.IsKeyword(TSQLKeywords.UNION))
            {
                set = new TSQLUnionClause();

                set.Tokens.Add(tokenizer.Current);

                if (tokenizer.MoveNext() &&
                    tokenizer.Current.IsKeyword(TSQLKeywords.ALL))
                {
                    set.Tokens.Add(tokenizer.Current);

                    tokenizer.MoveNext();
                }
            }
            else if (tokenizer.Current.IsKeyword(TSQLKeywords.EXCEPT))
            {
                set = new TSQLExceptClause();

                set.Tokens.Add(tokenizer.Current);

                tokenizer.MoveNext();
            }
            else if (tokenizer.Current.IsKeyword(TSQLKeywords.INTERSECT))
            {
                set = new TSQLIntersectClause();

                set.Tokens.Add(tokenizer.Current);

                tokenizer.MoveNext();
            }

            int level = 0;

            while (tokenizer.Current.IsCharacter(TSQLCharacters.OpenParentheses))
            {
                set.Tokens.Add(tokenizer.Current);

                level++;

                tokenizer.MoveNext();
            }

            TSQLSelectStatement select = new TSQLLimitedSelectStatementParser(tokenizer).Parse();

            set.Select = select;

            set.Tokens.AddRange(select.Tokens);

            while (level > 0 && tokenizer.Current.IsCharacter(TSQLCharacters.CloseParentheses))
            {
                set.Tokens.Add(tokenizer.Current);

                level--;

                tokenizer.MoveNext();
            }

            return(set);
        }