88b7f55db4
Full production-ready docker-compose stack (db, kong, auth, rest, realtime, storage, imgproxy, meta, functions, studio) targeting api.caterium.ru, plus bootstrap script for a fresh Cloud Server, Caddy reverse-proxy config (HTTPS, WebSocket, upload limits), and dump/restore/verify/storage-sync scripts for moving off the managed Supabase project (cksuehzcimitsxmeloes). Does not touch public/ or any live runtime behavior — frontend cutover is documented separately in frontend-cutover.md and only applied after Etap 8 verification. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
24 lines
875 B
SQL
24 lines
875 B
SQL
-- 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;
|