#!/bin/bash
# Database Schema Synchronization Script
# This script ensures the database schema is up-to-date during deployment

set -e

echo "=========================================="
echo "Database Schema Synchronization"
echo "=========================================="

# Check if .env file exists
if [ ! -f .env ]; then
    echo "Error: .env file not found"
    exit 1
fi

# Load environment variables
export $(cat .env | grep -v '^#' | xargs)

# Check if DATABASE_URL is set
if [ -z "$DATABASE_URL" ]; then
    echo "Error: DATABASE_URL not set in .env"
    exit 1
fi

echo "Environment: ${NODE_ENV:-development}"
echo "Database: ${DATABASE_URL}"

# Run TypeORM schema sync
echo ""
echo "Synchronizing database schema..."
npm run typeorm schema:sync -- -d src/config/typeorm.config.ts

if [ $? -eq 0 ]; then
    echo "✅ Database schema synchronized successfully"
else
    echo "❌ Database schema synchronization failed"
    exit 1
fi

echo "=========================================="
echo "Schema Synchronization Complete"
echo "=========================================="