$ pnpm db:test
# cwd /Users/king/Desktop/Workspace/SRO/zoen
# exit 1


> zoen@0.1.0 db:test /Users/king/Desktop/Workspace/SRO/zoen
> pnpm --filter @zoen/db sb test db


> @zoen/db@0.1.0 sb /Users/king/Desktop/Workspace/SRO/zoen/packages/db
> node scripts/sb.mjs test db

/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/010_surface.sql ........ ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/020_rbac.sql ........... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/030_audit.sql .......... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/040_admin_aux.sql ...... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/050_cms.sql ............ ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/060_community.sql ...... 
Dubious, test returned 3 (wstat 768, 0x300)
Failed 20/21 subtests 
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/070_analytics.sql ...... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/080_quality.sql ........ ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/090_staff.sql .......... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/100_push.sql ........... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/110_approvals.sql ...... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/120_sessions.sql ....... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/130_ops.sql ............ ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/140_ai.sql ............. ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/150_support.sql ........ ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/160_releases.sql ....... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/170_game_demo.sql ...... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/180_site_switches.sql .. ok

Test Summary Report
-------------------
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/060_community.sql    (Wstat: 768 (exited 3) Tests: 1 Failed: 0)
  Non-zero exit status: 3
  Parse errors: Bad plan.  You planned 21 tests but ran 1.
Files=18, Tests=174,  1 wallclock secs ( 0.03 usr  0.02 sys +  0.07 cusr  0.03 csys =  0.15 CPU)
Result: FAIL
/Users/king/Desktop/Workspace/SRO/zoen/packages/db:
 ERR_PNPM_RECURSIVE_RUN_FIRST_FAIL  @zoen/db@0.1.0 sb: `node scripts/sb.mjs test db`
Exit status 1
 ELIFECYCLE  Command failed with exit code 1.
Connecting to local database...
psql:/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/060_community.sql:19: ERROR:  invalid input syntax for type json
LINE 1: tg_table_name = 'bug_reports' and new.source = 'site' and pr...
                                                       ^
DETAIL:  Token "site" is invalid.
QUERY:  tg_table_name = 'bug_reports' and new.source = 'site' and private.site_switch_blocked('bug_reports')
CONTEXT:  JSON data, line 1: site
PL/pgSQL function private.guard_site_switches() line 6 at IF
SQL statement "insert into community.preregistrations (email, platforms, region, discord_name, testing_pref, source, consent_version, status, ip_hash)
  values (e, coalesce(p_platforms, '{}'), nullif(p_region, ''), nullif(btrim(p_discord), ''), nullif(p_testing, ''), coalesce(p_source, '{}'::jsonb),
          p_consent_version, 'pending', private.hash_ip(p_ip))
  on conflict (email) do update set platforms = excluded.platforms, region = excluded.region, discord_name = excluded.discord_name,
    testing_pref = excluded.testing_pref, consent_version = excluded.consent_version, consent_at = now(),
    status = case when community.preregistrations.status = 'unsubscribed' then 'pending' else community.preregistrations.status end"
PL/pgSQL function api.preregister(text,text[],text,text,text,jsonb,text,text) line 14 at SQL statement
error running container: exit 1