-- Run against both OLD_DB_URL and the new self-hosted DB, compare results.
-- psql "$OLD_DB_URL" -f 03-verify-counts.sql
-- psql "$NEW_DB_URL" -f 03-verify-counts.sql
--
-- Expected (Etap 8):
--   auth.users                  14
--   sun_v17_orders               11
--   sun_v17_order_items          53
--   sun_v17_clients              52
--   sun_v17_catalog_items       460
--   storage.objects              18
select 'auth.users' as table_name, count(*) as row_count from auth.users
union all
select 'sun_v17_orders', count(*) from public.sun_v17_orders
union all
select 'sun_v17_order_items', count(*) from public.sun_v17_order_items
union all
select 'sun_v17_clients', count(*) from public.sun_v17_clients
union all
select 'sun_v17_catalog_items', count(*) from public.sun_v17_catalog_items
union all
select 'storage.objects', count(*) from storage.objects
order by 1;