/// <summary>
/// Performs analysis and returns a list of problems detected
/// </summary>
/// <param name="ruleExecutionContext">Contains the schema model and model element to analyze</param>
/// <returns>
/// The problems detected by the rule in the given element
/// </returns>
public override IList <SqlRuleProblem> Analyze(SqlRuleExecutionContext ruleExecutionContext)
{
var problems = new List <SqlRuleProblem>();
var sqlObj = ruleExecutionContext.ModelElement;
if (sqlObj == null || sqlObj.IsWhiteListed())
{
return(problems);
}
var fragment = ruleExecutionContext.ScriptFragment.GetFragment(ProgrammingSchemaTypes);
var visitor = new SelectStatementVisitor();
fragment.Accept(visitor);
var offenders =
from s in visitor.NotIgnoredStatements(RuleId)
let tn = s.Into == null ? "" : s.Into.Identifiers?.LastOrDefault()?.Value
where s.Into != null && !(tn.StartsWith("#") || !tn.StartsWith("@"))
select s.Into;
problems.AddRange(offenders.Select(s => new SqlRuleProblem(Message, sqlObj, s)));
return(problems);
}
/// <summary>
/// Performs analysis and returns a list of problems detected
/// </summary>
/// <param name="ruleExecutionContext">Contains the schema model and model element to analyze</param>
/// <returns>
/// The problems detected by the rule in the given element
/// </returns>
public override IList <SqlRuleProblem> Analyze(SqlRuleExecutionContext ruleExecutionContext)
{
var problems = new List <SqlRuleProblem>();
var sqlObj = ruleExecutionContext.ModelElement;
if (sqlObj == null || sqlObj.IsWhiteListed())
{
return(problems);
}
var name = sqlObj.Name.GetName();
var fragment = ruleExecutionContext.ScriptFragment.GetFragment(typeof(CreateProcedureStatement));
if (fragment.ScriptTokenStream == null)
{
return(problems);
}
var parameterVisitor = new ParameterVisitor();
var selectVisitor = new SelectStatementVisitor();
fragment.Accept(parameterVisitor);
fragment.Accept(selectVisitor);
if (parameterVisitor.Count == 0 || selectVisitor.Count == 0)
{
return(problems);
}
var setVisitor = new SetVariableStatementVisitor();
fragment.Accept(setVisitor);
foreach (var param in parameterVisitor.Statements.Select(p => p.VariableName.Value))
{
var selectsUsingParam = selectVisitor.Statements.GetSelectsUsingParameterInWhere(param).ToList();
if (!selectsUsingParam.Any())
{
continue;
}
var selectStartLine = selectsUsingParam.FirstOrDefault()?.StartLine;
var getAssignmentSelects = selectVisitor.NotIgnoredStatements(RuleId)
.GetSelectsSettingParameterValue(param).Where(sel => sel.StartLine < selectStartLine);
var setStatements = setVisitor.NotIgnoredStatements(RuleId)
.Where(set => _comparer.Equals(set.Variable.Name, param) && set.StartLine < selectStartLine);
problems.AddRange(getAssignmentSelects.Select(x => new SqlRuleProblem(Message, sqlObj, x)));
problems.AddRange(setStatements.Select(x => new SqlRuleProblem(Message, sqlObj, x)));
}
return(problems);
}
public override IList <SqlRuleProblem> Analyze(SqlRuleExecutionContext ruleExecutionContext)
{
var problems = new List <SqlRuleProblem>();
var candidates = new List <StatementWithCtesAndXmlNamespaces>();
var sqlObj = ruleExecutionContext.ModelElement;
if (sqlObj == null)
{
return(problems);
}
var fragment = ruleExecutionContext.ScriptFragment.GetFragment(ProgrammingSchemaTypes);
List <StatementWithCtesAndXmlNamespaces> statements = new List <StatementWithCtesAndXmlNamespaces>();
var selectVisitor = new SelectStatementVisitor();
fragment.Accept(selectVisitor);
statements.AddRange(selectVisitor.NotIgnoredStatements(RuleId));
var actionStatementVisitor = new ActionStatementVisitor();
fragment.Accept(actionStatementVisitor);
statements.AddRange(actionStatementVisitor.NotIgnoredStatements(RuleId));
if (statements.Count() > 1)
{
statements.ForEach(statement =>
{
if (DoesStatementHaveDateFunction(statement))
{
candidates.Add(statement);
}
});
}
problems.AddRange(candidates.Select(s => new SqlRuleProblem(Message, sqlObj, s)));
return(problems);
}
/// <summary>
/// Performs analysis and returns a list of problems detected
/// </summary>
/// <param name="ruleExecutionContext">Contains the schema model and model element to analyze</param>
/// <returns>
/// The problems detected by the rule in the given element
/// </returns>
public override IList <SqlRuleProblem> Analyze(SqlRuleExecutionContext ruleExecutionContext)
{
var problems = new List <SqlRuleProblem>();
var sqlObj = ruleExecutionContext.ModelElement;
if (sqlObj == null || sqlObj.IsWhiteListed())
{
return(problems);
}
var fragment = ruleExecutionContext.ScriptFragment.GetFragment(
typeof(CreateTriggerStatement)
);
var selectVisitor = new SelectStatementVisitor();
fragment.Accept(selectVisitor);
problems.AddRange(selectVisitor.NotIgnoredStatements(RuleId).Select(t => new SqlRuleProblem(Message, sqlObj, t)));
return(problems);
}