setup_local_db.sh

#!/bin/bash

# Check if Docker is installed
if ! command -v docker &> /dev/null; then
    echo "Docker is not installed. Please install Docker and try again."
    exit 1
fi

# Check if Prisma CLI is installed
if ! command -v prisma &> /dev/null; then
    echo "Prisma CLI is not installed. Installing it now..."
    npm install -g prisma
fi

# Set up environment variables
DB_NAME="pokeapi"
DB_USER="postgres"
DB_PASSWORD="postgres"
DB_PORT="5432"
DB_HOST="localhost"

# Construct the connection string
CONNECTION_STRING="postgresql://$DB_USER:$DB_PASSWORD@$DB_HOST:$DB_PORT/$DB_NAME?schema=public"

# Update .env file
echo "Updating .env file..."
cat << EOF > .env
VERCEL_ENV=development
POSTGRES_URL="$CONNECTION_STRING"
EOF

echo ".env file updated with POSTGRES_URL"

# Start PostgreSQL container
echo "Starting PostgreSQL container..."
docker run --name pokeapi-postgres -e POSTGRES_DB=$DB_NAME -e POSTGRES_USER=$DB_USER -e POSTGRES_PASSWORD=$DB_PASSWORD -p $DB_PORT:5432 -d postgres:14

# Wait for the container to be ready
echo "Waiting for PostgreSQL to be ready..."
sleep 10

# Import the SQL dump
echo "Importing SQL dump..."
docker exec -i pokeapi-postgres psql -U $DB_USER -d $DB_NAME < pokeapi_dump.sql

echo "Local development environment setup complete!"