Function Example_analyzeQuery

pkg/gosqlx/example_test.go:602–631

Example_analyzeQuery demonstrates using extraction for query analysis.

()

// Example_analyzeQuery demonstrates using extraction for query analysis.
func Example_analyzeQuery() {
	sql := `SELECT
		u.username,
		COUNT(o.id) as total_orders,
		SUM(o.amount) as total_spent,
		UPPER(u.email) as email_upper
	FROM users u
	LEFT JOIN orders o ON u.id = o.user_id
	WHERE u.active = true AND o.status = 'completed'
	GROUP BY u.id, u.username, u.email
	HAVING COUNT(o.id) > 10
	ORDER BY total_spent DESC`

	ast, err := gosqlx.Parse(sql)
	if err != nil {
		log.Fatal(err)
	}

	metadata := gosqlx.ExtractMetadata(ast)

	fmt.Printf("Query Analysis:\n")
	fmt.Printf("- Joins %d tables\n", len(metadata.Tables))
	fmt.Printf("- References %d columns\n", len(metadata.Columns))
	fmt.Printf("- Uses %d functions\n", len(metadata.Functions))
	// Output:
	// Query Analysis:
	// - Joins 2 tables
	// - References 8 columns
	// - Uses 3 functions
}

// Example_extractFromCTE demonstrates extracting from queries with CTEs.
func Example_extractFromCTE() {