Function TestExtractMetadata_Comprehensive

pkg/gosqlx/extract_test.go:566–606

(t *testing.T)

}

func TestExtractMetadata_Comprehensive(t *testing.T) {
	sql := `SELECT u.name, COUNT(o.id) as order_count, UPPER(u.email)
		FROM users u
		LEFT JOIN orders o ON u.id = o.user_id
		WHERE u.active = true
		GROUP BY u.name, u.email
		HAVING COUNT(o.id) > 5
		ORDER BY order_count DESC`

	astNode, err := Parse(sql)
	if err != nil {
		t.Fatalf("Failed to parse SQL: %v", err)
	}

	metadata := ExtractMetadata(astNode)

	// Check tables
	expectedTables := []string{"users", "orders"}
	if !stringSlicesEqual(metadata.Tables, expectedTables) {
		t.Errorf("Expected tables %v, got %v", expectedTables, metadata.Tables)
	}

	// Check columns
	if !contains(metadata.Columns, "name") || !contains(metadata.Columns, "id") ||
		!contains(metadata.Columns, "email") || !contains(metadata.Columns, "active") ||
		!contains(metadata.Columns, "user_id") {
		t.Errorf("Missing expected columns in: %v", metadata.Columns)
	}

	// Check functions
	expectedFunctions := []string{"COUNT", "UPPER"}
	if !stringSlicesEqual(metadata.Functions, expectedFunctions) {
		t.Errorf("Expected functions %v, got %v", expectedFunctions, metadata.Functions)
	}

	// Check String() method
	str := metadata.String()
	if str == "" {
		t.Error("Expected non-empty string from Metadata.String()")
	}
}

func TestExtractMetadata_WithCTE(t *testing.T) {
	sql := `WITH active_users AS (