Function Example_extractMetadata

pkg/gosqlx/example_test.go:568–585

Example_extractMetadata demonstrates extracting comprehensive metadata from a query.

()

// Example_extractMetadata demonstrates extracting comprehensive metadata from a query.
func Example_extractMetadata() {
	sql := `SELECT u.name, COUNT(o.id) as order_count
		FROM users u
		LEFT JOIN orders o ON u.id = o.user_id
		WHERE u.active = true
		GROUP BY u.name
		HAVING COUNT(o.id) > 5`

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

	metadata := gosqlx.ExtractMetadata(ast)
	fmt.Printf("Tables: %d, Columns: %d, Functions: %d\n",
		len(metadata.Tables), len(metadata.Columns), len(metadata.Functions))
	// Output: Tables: 2, Columns: 4, Functions: 1
}

// Example_extractTablesQualified demonstrates extracting qualified table names.
func Example_extractTablesQualified() {