Beispiel #1
0
        public override void Visit(TSqlStatement node)
        {
            if (TypesToSkip.Contains(node.GetType()))
            {
                return;
            }

            var lastToken = node.ScriptTokenStream[node.LastTokenIndex];

            if (lastToken.TokenType == TSqlTokenType.Semicolon)
            {
                return;
            }

            // get a count of all tabs on the line that occur prior to the last token in this node
            var tabsOnLine = ColumnNumberCounter.CountTabsOnLine(lastToken.Line, node.LastTokenIndex, node.ScriptTokenStream);
            var column     = ColumnNumberCounter.GetColumnNumberAfterToken(tabsOnLine, lastToken);

            ErrorCallback(RULE_NAME, RULE_TEXT, lastToken.Line, column);
        }
Beispiel #2
0
        public override void Visit(TableReference node)
        {
            Action <TSqlFragment> ChildCallback = delegate(TSqlFragment childNode) {
                var tabsOnLine = ColumnNumberCounter.CountTabsOnLine(childNode.StartLine, childNode.LastTokenIndex, childNode.ScriptTokenStream);
                var column     = ColumnNumberCounter.GetColumnNumberBeforeToken(tabsOnLine, childNode.ScriptTokenStream[childNode.FirstTokenIndex]);
                ErrorCallback(RULE_NAME, RULE_TEXT, childNode.StartLine, column);
            };

            var childTableJoinVisitor = new ChildTableJoinVisitor();

            node.AcceptChildren(childTableJoinVisitor);

            if (!childTableJoinVisitor.TableJoined)
            {
                return;
            }

            var childTableAliasVisitor = new ChildTableAliasVisitor(ChildCallback, CteNames);

            node.AcceptChildren(childTableAliasVisitor);
        }
Beispiel #3
0
        public override void Visit(TSqlScript node)
        {
            for (var index = 0; index < node.ScriptTokenStream.Count; index++)
            {
                var token = node.ScriptTokenStream[index];
                if (!Constants.TSqlKeywords.Contains(token.Text, StringComparer.CurrentCultureIgnoreCase))
                {
                    continue;
                }

                if (IsAllUpper(token.Text))
                {
                    continue;
                }

                // get a count of all tabs on the line that occur prior to the last token in this node
                var tabsOnLine = ColumnNumberCounter.CountTabsOnLine(token.Line, index, node.ScriptTokenStream);
                var column     = ColumnNumberCounter.GetColumnNumberBeforeToken(tabsOnLine, token);

                ErrorCallback(RULE_NAME, RULE_TEXT, token.Line, column);
            }
        }