analyzer

type AnalysisJob struct {
	ID    string
	Query string
	Stmt  parser.Statement
}

type AnalysisResult struct {
	ID       string
	Analysis QueryAnalysis
	Error    error
}

type Analyzer struct {
	// contains filtered or unexported fields
}

type ColumnInfo struct {
	Table string `json:"table,omitempty"`
	Name  string `json:"name"`
	Usage string `json:"usage"` // SELECT, WHERE, JOIN, ORDER_BY, GROUP_BY
}

type ConcurrentAnalyzer struct {
	// contains filtered or unexported fields
}

type ConditionInfo struct {
	Column   string `json:"column"`
	Operator string `json:"operator"`
	Value    string `json:"value"`
	Table    string `json:"table,omitempty"`
}

type EnhancedOptimizationSuggestion struct {
	Type          string `json:"type"`
	Description   string `json:"description"`
	Severity      string `json:"severity"`
	Category      string `json:"category"`
	Rule          string `json:"rule"`
	Line          int    `json:"line,omitempty"`
	Column        int    `json:"column,omitempty"`
	Table         string `json:"table,omitempty"`
	ColumnName    string `json:"column_name,omitempty"`
	Suggestion    string `json:"suggestion"`
	Impact        string `json:"impact"` // HIGH, MEDIUM, LOW
	Dialect       string `json:"dialect,omitempty"`
	AutoFixable   bool   `json:"auto_fixable"`
	FixSuggestion string `json:"fix_suggestion,omitempty"`
}

type JoinInfo struct {
	Type       string `json:"type"`
	LeftTable  string `json:"left_table"`
	RightTable string `json:"right_table"`
	Condition  string `json:"condition"`
}

type OptimizationEngine struct {
	// contains filtered or unexported fields
}

type OptimizationRule struct {
	ID          string
	Name        string
	Description string
	Category    string // PERFORMANCE, SECURITY, MAINTAINABILITY, BEST_PRACTICE
	Severity    string // INFO, WARNING, ERROR, CRITICAL
	Enabled     bool
	CheckFunc   func(*OptimizationEngine, parser.Statement) []EnhancedOptimizationSuggestion
}

type OptimizationSuggestion struct {
	Type        string `json:"type"`
	Description string `json:"description"`
	Severity    string `json:"severity"`
	Line        int    `json:"line,omitempty"`
}

type PerformanceMetrics struct {
	EstimatedRows        int64    `json:"estimated_rows"`
	EstimatedCost        float64  `json:"estimated_cost"`
	JoinComplexity       int      `json:"join_complexity"`
	IndexRecommendations []string `json:"index_recommendations"`
	RiskLevel            string   `json:"risk_level"` // LOW, MEDIUM, HIGH
}

type QueryAnalysis struct {
	Tables     []TableInfo     `json:"tables"`
	Columns    []ColumnInfo    `json:"columns"`
	Joins      []JoinInfo      `json:"joins"`
	Conditions []ConditionInfo `json:"conditions"`
	QueryType  string          `json:"query_type"`
	Complexity int             `json:"complexity"`
	// Performance metrics
	Performance *PerformanceMetrics `json:"performance,omitempty"`
	// Enhanced optimization suggestions
	EnhancedSuggestions []EnhancedOptimizationSuggestion `json:"enhanced_suggestions,omitempty"`
	// Legacy suggestions for backward compatibility
	Suggestions []OptimizationSuggestion `json:"suggestions,omitempty"`
}

type TableInfo struct {
	Schema string `json:"schema,omitempty"`
	Name   string `json:"name"`
	Alias  string `json:"alias,omitempty"`
	Usage  string `json:"usage"` // SELECT, UPDATE, DELETE, INSERT
}