Function analyzeWithRule

pkg/advisor/advisor_advanced_test.go:26–36

analyzeWithRule parses sql and runs a single Rule against the first statement.

(t *testing.T, sql string, rule Rule)

// analyzeWithRule parses sql and runs a single Rule against the first statement.
func analyzeWithRule(t *testing.T, sql string, rule Rule) []Suggestion {
	t.Helper()
	tree, err := gosqlx.Parse(sql)
	if err != nil {
		t.Fatalf("Parse(%q): %v", sql, err)
	}
	if len(tree.Statements) == 0 {
		t.Fatal("no statements parsed")
	}
	return rule.Analyze(tree.Statements[0])
}

// ---------------------------------------------------------------------------
// OPT-009: Correlated Subquery in SELECT List