`scripts/seed-demo.js`

91 lines
#!/usr/bin/env node
// v0.1 demo seed: 30 plausible-but-fictional businesses across 8 verticals on
// Ventura Blvd from Sherman Oaks → Woodland Hills. NOT real businesses — these
// are demo placeholders so the site renders meaningfully on first page load.
// Phase 2 swaps these for real public-records ingestion (LA County DBA + GoogleMyBusiness scrape).

require('dotenv').config({ path: require('path').resolve(__dirname, '..', '.env') });
const slugify = require('slugify');
const db = require('../lib/db');

const HOODS = [
  { city: 'Sherman Oaks',   neighborhood: 'Sherman Oaks',   zip: '91423' },
  { city: 'Sherman Oaks',   neighborhood: 'Sherman Oaks',   zip: '91403' },
  { city: 'Studio City',    neighborhood: 'Studio City',    zip: '91604' },
  { city: 'Encino',         neighborhood: 'Encino',         zip: '91436' },
  { city: 'Tarzana',        neighborhood: 'Tarzana',        zip: '91356' },
  { city: 'Woodland Hills', neighborhood: 'Woodland Hills', zip: '91364' }
];

const SEED = [
  // food (5)
  { vertical: 'food', business_name: 'Olive & Salt Trattoria', headline: 'Wood-fired Italian on the Boulevard, family-run since 1998.', tier: 'standard', claim_status: 'self', verified: true, hood: 0, street: '14823 Ventura Blvd' },
  { vertical: 'food', business_name: 'Boulevard Bagels', headline: 'NY-style hand-rolled bagels and house-cured lox, open 6am.', tier: 'starter', claim_status: 'self', hood: 1, street: '13900 Ventura Blvd' },
  { vertical: 'food', business_name: 'Pho Encino', headline: 'Hand-pulled noodles, 14-hour bone broth, Vietnamese coffee on tap.', tier: 'free', claim_status: 'unclaimed', hood: 3, street: '17207 Ventura Blvd' },
  { vertical: 'food', business_name: 'The Studio City Tap', headline: 'Neighborhood gastropub with 32 California taps and weekend brunch.', tier: 'premier', claim_status: 'claimed', verified: true, hood: 2, street: '12060 Ventura Pl' },
  { vertical: 'food', business_name: 'Tarzana Taqueria', headline: 'Family-recipe carnitas, hand-pressed tortillas, salsa flight on the side.', tier: 'starter', claim_status: 'self', hood: 4, street: '18568 Ventura Blvd' },

  // beauty (5)
  { vertical: 'beauty', business_name: 'Gilt Hair Studio', headline: 'Balayage, color correction, Olaplex specialists. Bilingual stylists.', tier: 'premier', claim_status: 'claimed', verified: true, hood: 0, street: '15300 Ventura Blvd' },
  { vertical: 'beauty', business_name: 'Brow Bar Studio City', headline: 'Threading, lamination, tinting — drop-in welcome.', tier: 'standard', claim_status: 'self', hood: 2, street: '12200 Ventura Blvd' },
  { vertical: 'beauty', business_name: 'Lacquer Nail Lounge', headline: 'Non-toxic gel manicures, lashes, paraffin treatments.', tier: 'starter', claim_status: 'self', hood: 1, street: '14025 Ventura Blvd' },
  { vertical: 'beauty', business_name: 'Encino Barbers', headline: 'Old-school cuts, hot-towel shaves, walk-in friendly.', tier: 'free', claim_status: 'unclaimed', hood: 3, street: '16101 Ventura Blvd' },
  { vertical: 'beauty', business_name: 'WHL Skincare Studio', headline: 'Custom facials, microcurrent, hydrafacial. Licensed estheticians.', tier: 'standard', claim_status: 'self', verified: true, hood: 5, street: '21100 Ventura Blvd' },

  // retail (4)
  { vertical: 'retail', business_name: 'Boulevard Books', headline: 'Independent bookstore — staff picks, signed first editions, weekly readings.', tier: 'standard', claim_status: 'self', verified: true, hood: 2, street: '12148 Ventura Blvd' },
  { vertical: 'retail', business_name: 'Sherman Oaks Vintage', headline: '70s and 80s mid-century furniture, lighting, ceramics — restored in-house.', tier: 'starter', claim_status: 'self', hood: 0, street: '14529 Ventura Blvd' },
  { vertical: 'retail', business_name: 'Cactus & Cane Plants', headline: 'Curated houseplants, hand-thrown pots, plant-care workshops.', tier: 'free', claim_status: 'unclaimed', hood: 4, street: '18712 Ventura Blvd' },
  { vertical: 'retail', business_name: 'The Linen Closet', headline: 'Bedding, towels, table linens — small-batch from Italy and Portugal.', tier: 'premier', claim_status: 'claimed', verified: true, hood: 3, street: '17118 Ventura Blvd' },

  // fitness (4)
  { vertical: 'fitness', business_name: 'Encino Pilates Reformer', headline: 'Classical pilates, semi-private and private. Beginner-friendly.', tier: 'standard', claim_status: 'self', hood: 3, street: '16410 Ventura Blvd' },
  { vertical: 'fitness', business_name: 'Studio City Yoga Collective', headline: 'Vinyasa, restorative, and prenatal classes seven days a week.', tier: 'standard', claim_status: 'self', verified: true, hood: 2, street: '11900 Ventura Blvd' },
  { vertical: 'fitness', business_name: 'Ironclad Strength', headline: 'Small-group barbell coaching. No mirrors, no music — just lifts.', tier: 'starter', claim_status: 'self', hood: 0, street: '14710 Ventura Blvd' },
  { vertical: 'fitness', business_name: 'WHL Dance Academy', headline: 'Adult ballet, jazz, hip-hop — drop-in and 10-class packs.', tier: 'free', claim_status: 'unclaimed', hood: 5, street: '20801 Ventura Blvd' },

  // pet_services (3)
  { vertical: 'pet_services', business_name: 'Boulevard Bark', headline: 'Dog daycare, grooming, and pickup/dropoff service.', tier: 'standard', claim_status: 'self', verified: true, hood: 0, street: '14828 Ventura Blvd' },
  { vertical: 'pet_services', business_name: 'Studio City Dog Walk', headline: 'Two-walk minimum, midday relief, GPS tracked. Insured.', tier: 'starter', claim_status: 'self', hood: 2, street: '12050 Ventura Blvd' },
  { vertical: 'pet_services', business_name: 'The Cat Spa Tarzana', headline: 'Stress-free cat-only grooming. Mobile or in-shop.', tier: 'free', claim_status: 'unclaimed', hood: 4, street: '18900 Ventura Blvd' },

  // auto_detail (3)
  { vertical: 'auto_detail', business_name: 'Sherman Auto Detail', headline: 'Hand wash, paint correction, ceramic coating. Same-day appointments.', tier: 'standard', claim_status: 'self', verified: true, hood: 0, street: '14400 Ventura Blvd' },
  { vertical: 'auto_detail', business_name: 'Boulevard Window Tint', headline: 'Lifetime-warranty ceramic tint, 3M certified.', tier: 'starter', claim_status: 'self', hood: 4, street: '18230 Ventura Blvd' },
  { vertical: 'auto_detail', business_name: 'Mobile Detail by Marco', headline: 'We come to you — luxury detail at home, office, or hotel.', tier: 'premier', claim_status: 'claimed', verified: true, hood: 3, street: '16322 Ventura Blvd' },

  // cleaning (3)
  { vertical: 'cleaning', business_name: 'White Glove Home', headline: 'Weekly, biweekly, or one-time deep clean. Eco-friendly products.', tier: 'standard', claim_status: 'self', hood: 1, street: '14010 Ventura Blvd' },
  { vertical: 'cleaning', business_name: 'NeatNest Organizers', headline: 'Closet, kitchen, garage — hands-on professional organizing.', tier: 'starter', claim_status: 'self', hood: 2, street: '12450 Ventura Blvd' },
  { vertical: 'cleaning', business_name: 'Tarzana Move Helpers', headline: 'Two-person small-move team. In-home shuffle, donation runs, packing.', tier: 'free', claim_status: 'unclaimed', hood: 4, street: '18550 Ventura Blvd' },

  // creative (3)
  { vertical: 'creative', business_name: 'Studio City Florist', headline: 'Daily fresh-cut bouquets, weddings, weekly office subscriptions.', tier: 'standard', claim_status: 'self', verified: true, hood: 2, street: '11815 Ventura Blvd' },
  { vertical: 'creative', business_name: 'Boulevard Photo Co.', headline: 'Family portraits, headshots, real-estate photography. Studio + on-location.', tier: 'starter', claim_status: 'self', hood: 0, street: '14945 Ventura Blvd' },
  { vertical: 'creative', business_name: 'Encino Event Pros', headline: 'Birthdays, bar/bat mitzvahs, corporate. Full-service planning.', tier: 'premier', claim_status: 'claimed', verified: true, hood: 3, street: '16133 Ventura Blvd' }
];

(async () => {
  let inserted = 0, skipped = 0;
  for (const s of SEED) {
    const hood = HOODS[s.hood];
    const slug = slugify(`${s.business_name} ${hood.neighborhood}`, { lower: true, strict: true });
    const description = `${s.business_name} is a ${s.vertical.replace('_', ' ')} business serving the ${hood.neighborhood} neighborhood and the wider Ventura Blvd corridor. ${s.headline}`;

    const r = await db.query(`
      INSERT INTO businesses
        (slug, business_name, vertical, headline, description, street, city, state, zip, neighborhood,
         tier, claim_status, verified, status, source)
      VALUES ($1, $2, $3, $4, $5, $6, $7, 'CA', $8, $9, $10, $11, $12, 'active', 'seed')
      ON CONFLICT (slug) DO NOTHING
      RETURNING id
    `, [slug, s.business_name, s.vertical, s.headline, description, s.street, hood.city, hood.zip, hood.neighborhood,
        s.tier || 'free', s.claim_status || 'unclaimed', !!s.verified]);

    if (r.rowCount > 0) inserted++;
    else skipped++;
  }
  console.log(`[seed] inserted=${inserted} skipped=${skipped} (already present)`);
  await db.pool.end();
})().catch(err => { console.error('[seed] FATAL', err.message); process.exit(1); });