setup_db.sh

#!/bin/bash

# PostgreSQL connection details
DB_NAME="smartresume"
DB_USER="postgres"
DB_PASSWORD=""  # Change this if your PostgreSQL setup requires a password

# Check if psql is available
if ! command -v psql &> /dev/null; then
    echo "PostgreSQL client (psql) is not installed. Please install PostgreSQL first."
    exit 1
fi

# Check if the database already exists
if psql -lqt | cut -d \| -f 1 | grep -qw "$DB_NAME"; then
    echo "Database $DB_NAME already exists"
else
    # Create database
    if [ -z "$DB_PASSWORD" ]; then
        createdb "$DB_NAME"
    else
        PGPASSWORD="$DB_PASSWORD" createdb -U "$DB_USER" "$DB_NAME"
    fi
    
    if [ $? -eq 0 ]; then
        echo "Database $DB_NAME created successfully"
    else
        echo "Failed to create database $DB_NAME"
        exit 1
    fi
fi

# Update Django settings with database credentials
cat > backend/.env << EOL
DEBUG=True
SECRET_KEY=your-secret-key-here
DB_NAME=$DB_NAME
DB_USER=$DB_USER
DB_PASSWORD=$DB_PASSWORD
DB_HOST=localhost
DB_PORT=5432
ALLOWED_HOSTS=localhost,127.0.0.1
CORS_ORIGIN_WHITELIST=http://localhost:8080
EOL

echo "Database configuration complete!"