2026-03-02 11:37:34 -08:00
|
|
|
#!/usr/bin/env bash
|
2026-02-12 15:46:57 -08:00
|
|
|
set -euo pipefail
|
|
|
|
|
|
|
|
|
|
# Load IP configuration
|
|
|
|
|
SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
|
|
|
|
|
PROJECT_ROOT="$(cd "$SCRIPT_DIR/.." && pwd)"
|
|
|
|
|
source "${PROJECT_ROOT}/config/ip-addresses.conf" 2>/dev/null || true
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# Run Database Migrations
|
|
|
|
|
NODE_IP="${PROXMOX_HOST_R630_01}"
|
|
|
|
|
|
|
|
|
|
# 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
|
