Function Example_extractFunctions

pkg/gosqlx/example_test.go:554–565

Example_extractFunctions demonstrates extracting function names from a query.

()

// Example_extractFunctions demonstrates extracting function names from a query.
func Example_extractFunctions() {
	sql := "SELECT COUNT(*), AVG(salary), UPPER(name) FROM employees"

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

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

// Example_extractMetadata demonstrates extracting comprehensive metadata from a query.
func Example_extractMetadata() {