public override void Visit(TSqlScript node) { var typesToUpcase = Constants.TSqlKeywords.Concat(Constants.TSqlDataTypes).ToArray(); for (var index = 0; index < node.ScriptTokenStream?.Count; index++) { var token = node.ScriptTokenStream[index]; if (!typesToUpcase.Contains(token.Text, StringComparer.CurrentCultureIgnoreCase)) { continue; } if (IsUpperCase(token.Text)) { continue; } var dynamicSQLAdjustment = AdjustColumnForDymamicSQL(token); // get a count of all tabs on the line that occur prior to the last token in this node var tabsOnLine = ColumnNumberCalculator.CountTabsBeforeToken(token.Line, index, node.ScriptTokenStream); var column = ColumnNumberCalculator.GetColumnNumberBeforeToken(tabsOnLine, token); errorCallback(RULE_NAME, RULE_TEXT, token.Line, column + dynamicSQLAdjustment); } }
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 (IsUpperCase(token.Text)) { continue; } // get a count of all tabs on the line that occur prior to the last token in this node var tabsOnLine = ColumnNumberCalculator.CountTabsBeforeToken(token.Line, index, node.ScriptTokenStream); var column = ColumnNumberCalculator.GetColumnNumberBeforeToken(tabsOnLine, token); ErrorCallback(RULE_NAME, RULE_TEXT, token.Line, column); } }
public override void Visit(TableReference node) { void ChildCallback(TSqlFragment childNode) { var tabsOnLine = ColumnNumberCalculator.CountTabsBeforeToken(childNode.StartLine, childNode.LastTokenIndex, childNode.ScriptTokenStream); var column = ColumnNumberCalculator.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); }