costa-rica: prod demo-inventory seed script (reversible, idempotent, Steve-approved) — TK-10346

2f728f52fc2e9e8790c0230895f914bfbd462abf · 2026-08-07 16:20:35 -0700 · Steve

Files touched

A scripts/seed_prod_demos.sql

Diff

commit 2f728f52fc2e9e8790c0230895f914bfbd462abf
Author: Steve <steve@designerwallcoverings.com>
Date:   Fri Aug 7 16:20:35 2026 -0700

    costa-rica: prod demo-inventory seed script (reversible, idempotent, Steve-approved) — TK-10346
---
 scripts/seed_prod_demos.sql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)

diff --git a/scripts/seed_prod_demos.sql b/scripts/seed_prod_demos.sql
new file mode 100644
index 0000000..c3120bd
--- /dev/null
+++ b/scripts/seed_prod_demos.sql
@@ -0,0 +1,25 @@
+-- Prod demo bookable inventory (Steve-approved 2026-08-07, "seed prod demos").
+-- Clearly labeled "Demo —" / source='seed-demo' so it's never mistaken for a
+-- real host listing. Idempotent (ON CONFLICT). Reversible:
+--   DELETE FROM place_booking WHERE place_id IN (SELECT id FROM places WHERE source='seed-demo');
+--   DELETE FROM places WHERE source='seed-demo';
+
+INSERT INTO places (slug,name,category,vertical,region_id,description,price_range,rating,source,status)
+SELECT d.slug,d.name,d.category,d.vertical,
+       (SELECT id FROM regions ORDER BY id LIMIT 1),
+       d.descr,d.pr,d.rating,'seed-demo','active'
+FROM (VALUES
+ ('demo-casa-tamarindo','Demo — Casa Tamarindo (Beachfront)','tourism','tourism_hotel','DEMO listing for app testing. Beachfront villa, 3BR.','$$$',4.8),
+ ('demo-arenal-lodge','Demo — Arenal Volcano Lodge','tourism','tourism_hotel','DEMO listing. Volcano-view rooms + hot springs.','$$$',4.7),
+ ('demo-ma-canopy-tour','Demo — Manuel Antonio Canopy Tour','tourism','tourism_tour','DEMO listing. 2.5h zipline + wildlife guide.','$$',4.9),
+ ('demo-nosara-surf','Demo — Nosara Surf & Yoga Retreat','tourism','tourism_tour','DEMO listing. Daily surf + yoga package.','$$',4.6)
+) AS d(slug,name,category,vertical,descr,pr,rating)
+ON CONFLICT (slug) DO UPDATE SET status='active';
+
+INSERT INTO place_booking (place_id, booking_type, currency, base_price, cleaning_fee, max_guests, min_nights, instant_book)
+SELECT id, CASE WHEN vertical='tourism_tour' THEN 'slot' ELSE 'nightly' END, 'USD',
+       CASE WHEN vertical='tourism_tour' THEN 6500 ELSE 18500 END,
+       CASE WHEN vertical='tourism_tour' THEN 0 ELSE 5000 END,
+       CASE WHEN vertical='tourism_tour' THEN 8 ELSE 6 END, 1, TRUE
+FROM places WHERE source='seed-demo'
+ON CONFLICT (place_id) DO UPDATE SET is_active=TRUE, base_price=EXCLUDED.base_price;

← 4e14aa3 costa-rica: Cody-gate fix — REAL consent bug: confirmBooking · back to Costa Rica · yoloforever: cycle 7 ledger — money-path tests, Cody found+f 3b42013 →