#!/bin/bash
# Initialize OPC database in PostgreSQL

set -e

echo "Initializing OPC database..."

# Connect to PostgreSQL and create OPC database
ssh nas "/volume1/@appstore/ContainerManager/usr/bin/docker exec -i gitea-db psql -U gitea -d postgres" << 'EOF'
-- Create OPC database if it doesn't exist
SELECT 'CREATE DATABASE opc'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'opc')\gexec

-- Grant permissions to gitea user
GRANT ALL PRIVILEGES ON DATABASE opc TO gitea;
EOF

echo "OPC database created successfully!"
echo ""
echo "Next steps:"
echo "1. The dashboard will auto-initialize tables on startup"
echo "2. Push your changes to trigger CI/CD deployment"
echo "3. Access OPC at https://nas.jimmygan.com/opc"