$ test "$(docker exec supabase_db_zoen psql -U postgres -tAc "select count(*) from cms.posts where state <> 'draft'")" = 0 && test "$(docker exec supabase_db_zoen psql -U postgres -tAc 'select count(*) from cms.faqs')" = 11 && 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 ...... 
Dubious, test returned 3 (wstat 768, 0x300)
Failed 10/10 subtests 
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/040_admin_aux.sql .. 
Dubious, test returned 3 (wstat 768, 0x300)
Failed 9/9 subtests 
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/050_cms.sql ........ 
Dubious, test returned 3 (wstat 768, 0x300)
Failed 17/17 subtests 
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/060_community.sql .. 
Dubious, test returned 3 (wstat 768, 0x300)
Failed 21/21 subtests 
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/070_analytics.sql .. 
Dubious, test returned 3 (wstat 768, 0x300)
Failed 7/7 subtests 

Test Summary Report
-------------------
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/030_audit.sql    (Wstat: 768 (exited 3) Tests: 0 Failed: 0)
  Non-zero exit status: 3
  Parse errors: Bad plan.  You planned 10 tests but ran 0.
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/040_admin_aux.sql (Wstat: 768 (exited 3) Tests: 0 Failed: 0)
  Non-zero exit status: 3
  Parse errors: Bad plan.  You planned 9 tests but ran 0.
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/050_cms.sql      (Wstat: 768 (exited 3) Tests: 0 Failed: 0)
  Non-zero exit status: 3
  Parse errors: Bad plan.  You planned 17 tests but ran 0.
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/060_community.sql (Wstat: 768 (exited 3) Tests: 0 Failed: 0)
  Non-zero exit status: 3
  Parse errors: Bad plan.  You planned 21 tests but ran 0.
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/070_analytics.sql (Wstat: 768 (exited 3) Tests: 0 Failed: 0)
  Non-zero exit status: 3
  Parse errors: Bad plan.  You planned 7 tests but ran 0.
Files=7, Tests=19,  2 wallclock secs ( 0.15 usr  0.10 sys +  0.22 cusr  0.16 csys =  0.63 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/030_audit.sql:5: ERROR:  duplicate key value violates unique constraint "users_email_partial_key"
DETAIL:  Key (email)=(owner@zoen.test) already exists.
psql:/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/040_admin_aux.sql:6: ERROR:  duplicate key value violates unique constraint "users_email_partial_key"
DETAIL:  Key (email)=(owner@zoen.test) already exists.
psql:/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/050_cms.sql:8: ERROR:  duplicate key value violates unique constraint "users_email_partial_key"
DETAIL:  Key (email)=(owner@zoen.test) already exists.
psql:/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/060_community.sql:6: ERROR:  duplicate key value violates unique constraint "users_email_partial_key"
DETAIL:  Key (email)=(owner@zoen.test) already exists.
psql:/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/070_analytics.sql:5: ERROR:  duplicate key value violates unique constraint "users_email_partial_key"
DETAIL:  Key (email)=(analyst@zoen.test) already exists.
error running container: exit 1