$ pnpm -s db:test && pnpm --filter @zoen/db -s test
# cwd /Users/king/Desktop/Workspace/SRO/zoen
# exit 0

/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 .. ok
/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
All tests successful.
Files=13, Tests=132, 56 wallclock secs ( 1.53 usr  0.49 sys +  0.72 cusr  0.95 csys =  3.69 CPU)
Result: PASS
TAP version 13
# Subtest: owner bootstrap
ok 1 - owner bootstrap
  ---
  duration_ms: 4086.076042
  type: 'test'
  ...
# Subtest: a signed publish webhook verifies; tampering, wrong secrets, old timestamps and bad tags are refused
ok 2 - a signed publish webhook verifies; tampering, wrong secrets, old timestamps and bad tags are refused
  ---
  duration_ms: 4.035042
  type: 'test'
  ...
# Stopped services: [supabase_realtime_zoen supabase_imgproxy_zoen supabase_edge_runtime_zoen supabase_analytics_zoen supabase_vector_zoen supabase_pooler_zoen]
# Subtest: anon key reaches api.health as anon
ok 3 - anon key reaches api.health as anon
  ---
  duration_ms: 453.437625
  type: 'test'
  ...
# Subtest: site_server and job_worker JWTs run as those roles
ok 4 - site_server and job_worker JWTs run as those roles
  ---
  duration_ms: 60.774542
  type: 'test'
  ...
# Subtest: a token signed with the wrong secret is rejected
ok 5 - a token signed with the wrong secret is rejected
  ---
  duration_ms: 20.339416
  type: 'test'
  ...
# Subtest: site_server cannot read staff tables
ok 6 - site_server cannot read staff tables
  ---
  duration_ms: 44.257584
  type: 'test'
  ...
# Subtest: pre-registration needs an e-mail, a platform and consent
ok 7 - pre-registration needs an e-mail, a platform and consent
  ---
  duration_ms: 24.852208
  type: 'test'
  ...
# Subtest: ban reviews need the ban id; bug reports trim optional fields
ok 8 - ban reviews need the ban id; bug reports trim optional fields
  ---
  duration_ms: 17.297208
  type: 'test'
  ...
# Subtest: site settings accept only https socials on known networks and a Steam url when enabled
ok 9 - site settings accept only https socials on known networks and a Steam url when enabled
  ---
  duration_ms: 5.672083
  type: 'test'
  ...
# Subtest: credentials can never use the NEXT_PUBLIC_ prefix
ok 10 - credentials can never use the NEXT_PUBLIC_ prefix
  ---
  duration_ms: 0.888958
  type: 'test'
  ...
# Subtest: config keys come from rulesets.json: one per multiplier, max = largest ruleset value, seed is fresh
ok 11 - config keys come from rulesets.json: one per multiplier, max = largest ruleset value, seed is fresh
  ---
  duration_ms: 125.585125
  type: 'test'
  ...
# Subtest: public sign-up is closed
ok 12 - public sign-up is closed
  ---
  duration_ms: 114.233084
  type: 'test'
  ...
# Subtest: every seeded role reaches AAL2 and sees exactly its own role
ok 13 - every seeded role reaches AAL2 and sees exactly its own role
  ---
  duration_ms: 30110.138375
  type: 'test'
  ...
# Subtest: reset refuses while a non-test account exists
ok 14 - reset refuses while a non-test account exists
  ---
  duration_ms: 3354.132583
  type: 'test'
  ...
1..14
# tests 14
# suites 0
# pass 14
# fail 0
# cancelled 0
# skipped 0
# todo 0
# duration_ms 36553.498167
Connecting to local database...