Function Example_validationWithExtraction

pkg/gosqlx/example_test.go:651–676

Example_validationWithExtraction demonstrates combining validation with metadata extraction.

()

// Example_validationWithExtraction demonstrates combining validation with metadata extraction.
func Example_validationWithExtraction() {
	userSQL := "SELECT u.id, u.name FROM users u WHERE u.status = 'active'"

	// First validate
	if err := gosqlx.Validate(userSQL); err != nil {
		fmt.Println("Invalid SQL")
		return
	}

	// Parse and extract metadata
	ast, err := gosqlx.Parse(userSQL)
	if err != nil {
		log.Fatal(err)
	}

	metadata := gosqlx.ExtractMetadata(ast)

	// Check if accessing sensitive tables
	sensitiveTable := "users"
	for _, table := range metadata.Tables {
		if table == sensitiveTable {
			fmt.Printf("Query accesses sensitive table: %s\n", sensitiveTable)
		}
	}
	// Output: Query accesses sensitive table: users
}

// Example_extractWindowFunctions demonstrates extracting window functions.
func Example_extractWindowFunctions() {