#!/bin/bash
set -euo pipefail

# Run Database Migrations
NODE_IP="192.168.11.11"

# Order services migrations
for vmid in 10030 10040 10050 10060 10070 10080 10090 10091 10092; do
    echo "Running migrations for CT $vmid..."
    ssh root@${NODE_IP} "pct enter $vmid -- bash -c 'cd /opt/app && export PATH=/opt/bin:\$PATH && npm run migrate 2>&1 || echo \"No migrations found\"'"
done

# DBIS services migrations
for vmid in 10150 10151; do
    echo "Running Prisma migrations for CT $vmid..."
    ssh root@${NODE_IP} "pct enter $vmid -- bash -c 'cd /opt/dbis-core && export PATH=/opt/bin:\$PATH && npx prisma migrate deploy 2>&1 || echo \"Migrations pending\"'"
done