fix: resolve \ir relative paths in single file pg_tap tests by 7ttp · Pull Request #4845 · supabase/cli

In `@internal/db/test/test.go`:
- Line 30: The regex in var irPattern currently anchors to line start so
indented \ir directives are missed; update the regular expression in var
irPattern (the compiled pattern used to find `\ir` directives) to allow optional
leading whitespace before the backslash (e.g. add `\s*` after the `^`), keeping
the rest of the capture group intact so filenames are still captured the same
way.
- Around line 34-66: The multi-dir failure is caused by always reducing
dockerPath to path.Base for test files; change the logic in the loop over
allFiles (the block that sets workingDir, computes dockerPath, and appends to
cmd/binds) so that path.Base(dockerPath) is used only when the directory of
dockerPath equals the chosen workingDir (which is set from the first file); for
files from other directories keep the full dockerPath when appending to cmd (so
pg_prove can find them) and still add the corresponding binds entry; update the
code around traverseImports, testFiles, allFiles, cmd, workingDir, and binds to
reflect this conditional basename behavior.