Function Example_extractWindowFunctions

pkg/gosqlx/example_test.go:679–695

Example_extractWindowFunctions demonstrates extracting window functions.

()

// Example_extractWindowFunctions demonstrates extracting window functions.
func Example_extractWindowFunctions() {
	sql := `SELECT
		name,
		salary,
		ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) as rank,
		AVG(salary) OVER (PARTITION BY department) as dept_avg
	FROM employees`

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

	functions := gosqlx.ExtractFunctions(ast)
	fmt.Printf("Window functions found: %d\n", len(functions))
	// Output: Window functions found: 2
}