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

/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,  5 wallclock secs ( 0.37 usr  0.02 sys +  0.24 cusr  0.22 csys =  0.85 CPU)
Result: PASS
TAP version 13
# Subtest: owner bootstrap
ok 1 - owner bootstrap
  ---
  duration_ms: 11943.11025
  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: 11.257208
  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: 153.984542
  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: 45.019
  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: 14.900167
  type: 'test'
  ...
# Subtest: site_server cannot read staff tables
ok 6 - site_server cannot read staff tables
  ---
  duration_ms: 16.283333
  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: 54.566625
  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: 16.117916
  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: 7.497584
  type: 'test'
  ...
# Subtest: credentials can never use the NEXT_PUBLIC_ prefix
ok 10 - credentials can never use the NEXT_PUBLIC_ prefix
  ---
  duration_ms: 0.540417
  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: 876.08825
  type: 'test'
  ...
# Subtest: public sign-up is closed
ok 12 - public sign-up is closed
  ---
  duration_ms: 137.187584
  type: 'test'
  ...
# Subtest: every seeded role reaches AAL2 and sees exactly its own role
not ok 13 - every seeded role reaches AAL2 and sees exactly its own role
  ---
  duration_ms: 29435.297792
  type: 'test'
  location: '/Users/king/Desktop/Workspace/SRO/zoen/packages/db/tests/staff.int.test.mjs:23:1'
  failureType: 'testCodeFailure'
  error: 'marketing@zoen.test: no TOTP factor'
  code: 'ERR_TEST_FAILURE'
  stack: |-
    signInAal2 (file:///Users/king/Desktop/Workspace/SRO/zoen/packages/db/scripts/seed-staff.mjs:33:22)
    process.processTicksAndRejections (node:internal/process/task_queues:103:5)
    async TestContext.<anonymous> (file:///Users/king/Desktop/Workspace/SRO/zoen/packages/db/tests/staff.int.test.mjs:25:15)
    async Test.run (node:internal/test_runner/test:1054:7)
    async Test.processPendingSubtests (node:internal/test_runner/test:744:7)
  ...
# Subtest: reset refuses while a non-test account exists
ok 14 - reset refuses while a non-test account exists
  ---
  duration_ms: 21681.604833
  type: 'test'
  ...
1..14
# tests 14
# suites 0
# pass 13
# fail 1
# cancelled 0
# skipped 0
# todo 0
# duration_ms 63431.809875
Connecting to local database...