Function TestSQLAnalyzer_IssueDetails

cmd/gosqlx/cmd/sql_analyzer_test.go:168–258

(t *testing.T)

}

func TestSQLAnalyzer_IssueDetails(t *testing.T) {
	testCases := []struct {
		name            string
		sql             string
		expectedIssueID string
		checkFields     func(t *testing.T, issue AnalysisIssue)
	}{
		{
			name:            "SELECT_STAR issue details",
			sql:             "SELECT * FROM users",
			expectedIssueID: "SELECT_STAR",
			checkFields: func(t *testing.T, issue AnalysisIssue) {
				if issue.Category != IssueCategoryPerformance {
					t.Errorf("Expected performance category, got %s", issue.Category)
				}
				if issue.Severity != IssueSeverityMedium {
					t.Errorf("Expected medium severity, got %s", issue.Severity)
				}
				if !strings.Contains(issue.Description, "SELECT *") {
					t.Error("Description should mention SELECT *")
				}
				if issue.Suggestion == "" {
					t.Error("Suggestion should not be empty")
				}
			},
		},
		{
			name:            "FUNCTION_IN_WHERE issue details",
			sql:             "SELECT name FROM users WHERE UPPER(name) = 'TEST'",
			expectedIssueID: "FUNCTION_IN_WHERE",
			checkFields: func(t *testing.T, issue AnalysisIssue) {
				if issue.Category != IssueCategoryPerformance {
					t.Errorf("Expected performance category, got %s", issue.Category)
				}
				if issue.Severity != IssueSeverityMedium {
					t.Errorf("Expected medium severity, got %s", issue.Severity)
				}
				if !strings.Contains(strings.ToLower(issue.Description), "function") {
					t.Errorf("Description should mention function, got: %s", issue.Description)
				}
			},
		},
	}

	for _, tc := range testCases {
		t.Run(tc.name, func(t *testing.T) {
			// Parse and analyze
			tkz := tokenizer.GetTokenizer()
			defer tokenizer.PutTokenizer(tkz)

			tokens, err := tkz.Tokenize([]byte(tc.sql))
			if err != nil {
				t.Fatalf("Tokenization failed: %v", err)
			}

			p := parser.NewParser()
			astObj := ast.NewAST()
			defer ast.ReleaseAST(astObj)