Function TestIntegrationAnalyzeSQL

pkg/advisor/optimizer_test.go:1059–1089

--------------------------------------------------------------------------- Integration test with AnalyzeSQL ---------------------------------------------------------------------------

(t *testing.T)

// ---------------------------------------------------------------------------

func TestIntegrationAnalyzeSQL(t *testing.T) {
	opt := New()

	t.Run("SELECT * produces OPT-001", func(t *testing.T) {
		result := mustAnalyze(t, opt, "SELECT * FROM users")
		if !hasSuggestion(result, "OPT-001") {
			t.Error("expected OPT-001 for SELECT *")
		}
	})

	t.Run("UPDATE without WHERE produces OPT-002", func(t *testing.T) {
		result := mustAnalyze(t, opt, "UPDATE users SET name = 'test'")
		if !hasSuggestion(result, "OPT-002") {
			t.Error("expected OPT-002 for UPDATE without WHERE")
		}
	})

	t.Run("DELETE without WHERE produces OPT-002", func(t *testing.T) {
		result := mustAnalyze(t, opt, "DELETE FROM users")
		if !hasSuggestion(result, "OPT-002") {
			t.Error("expected OPT-002 for DELETE without WHERE")
		}
	})

	t.Run("DISTINCT produces OPT-004", func(t *testing.T) {
		result := mustAnalyze(t, opt, "SELECT DISTINCT name FROM users")
		if !hasSuggestion(result, "OPT-004") {
			t.Error("expected OPT-004 for SELECT DISTINCT")
		}
	})
}

func contains(s, substr string) bool {
	return len(s) >= len(substr) && containsSubstring(s, substr)