#!/bin/bash
# Wakelai Database Initialization Script

set -e

echo "Initializing Wakelai database..."

# Check if running as postgres user or with sudo
if [ "$USER" = "postgres" ] || [ -n "$SUDO_USER" ]; then
    PSQL="sudo -u postgres psql"
else
    PSQL="psql -U postgres"
fi

# Create database if it doesn't exist
echo "Creating database..."
$PSQL -tc "SELECT 1 FROM pg_database WHERE datname='wakelai'" | grep -q 1 || \
    $PSQL -c "CREATE DATABASE wakelai"

echo "Running migrations..."
$PSQL -d wakelai -f /home/ashraffarid2010/wakelai.com/migrations/001_init.sql

echo "Database initialized successfully!"
echo ""
echo "To create an admin user, run:"
echo "  python run.py create-admin"