#!/bin/bash
# Fix Render Deployment Script
# This script helps you delete and recreate your Render services

echo "=================================="
echo "Render Deployment Fix Script"
echo "=================================="
echo ""
echo "PROBLEM: Your DATABASE_URL points to a deleted database (dpg-d50o9ge3jp1c73a9n9kg-a)"
echo ""
echo "SOLUTION OPTIONS:"
echo ""
echo "1. Use Blueprint (Easiest - Recommended)"
echo "   - Go to: https://dashboard.render.com/blueprints"
echo "   - Click 'New Blueprint'"
echo "   - Connect your GitHub repo: ecommerce"
echo "   - Render will automatically:"
echo "     • Create PostgreSQL database"
echo "     • Create Web service"
echo "     • Link them together"
echo ""
echo "2. Manual Fix (If you want to keep existing service)"
echo "   Step A: Create New Database"
echo "   - Go to: https://dashboard.render.com/select-repo?type=pserv"
echo "   - Click 'New PostgreSQL'"
echo "   - Name: ecommerce-postgres"
echo "   - Database: ecommerce_db"
echo "   - User: ecommerce_user"
echo "   - Click 'Create Database'"
echo ""
echo "   Step B: Update Web Service"
echo "   - Go to your web service dashboard"
echo "   - Click 'Environment' in sidebar"
echo "   - Find or add DATABASE_URL variable"
echo "   - Paste the Internal Database URL from new database"
echo "   - Save and trigger manual deploy"
echo ""
echo "3. Delete Everything and Start Fresh"
echo "   - Delete web service from: https://dashboard.render.com/"
echo "   - Delete old database"
echo "   - Use option 1 (Blueprint) to redeploy"
echo ""
echo "=================================="
echo "After deployment succeeds:"
echo "- Your site will be at: https://ecommerce-app.onrender.com"
echo "- Admin panel: https://ecommerce-app.onrender.com/admin/"
echo "- Default login: admin / admin123"
echo "=================================="