Method Analyze

pkg/advisor/optimizer.go:148–174

Analyze inspects all statements in the given AST and returns an OptimizationResult. Each configured rule is applied to every statement in the AST. The result includes all suggestions, a complexity classification, and an optimization score.

(tree *ast.AST)

// Each configured rule is applied to every statement in the AST. The result
// includes all suggestions, a complexity classification, and an optimization score.
func (o *Optimizer) Analyze(tree *ast.AST) *OptimizationResult {
	if tree == nil {
		return &OptimizationResult{
			Suggestions:     []Suggestion{},
			QueryComplexity: ComplexitySimple,
			Score:           100,
		}
	}

	var suggestions []Suggestion

	for _, stmt := range tree.Statements {
		for _, rule := range o.rules {
			ruleSuggestions := rule.Analyze(stmt)
			suggestions = append(suggestions, ruleSuggestions...)
		}
	}

	complexity := classifyComplexity(tree)
	score := calculateScore(suggestions)

	return &OptimizationResult{
		Suggestions:     suggestions,
		QueryComplexity: complexity,
		Score:           score,
	}
}

// AnalyzeSQL is a convenience method that parses the SQL string and analyzes it.
//