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);
}