FM / scripts

/home/techb158/balavpn.abdallabala.com/scripts/

/home/techb158/balavpn.abdallabala.com/scripts

Name	Size	Mode	Actions
auto-deploy.sh	2145	0644	edit dl rm
backup-db.sh	1103	0644	edit dl rm
check-config.js	1081	0644	edit dl rm
create-users.js	1728	0644	edit dl rm
deploy-prod.sh	2709	0644	edit dl rm
monitor-health.sh	1485	0644	edit dl rm
run-scheduled-reports.js	1724	0644	edit dl rm
setup-backup-cron.sh	1189	0644	edit dl rm
setup-monitoring-cron.sh	592	0644	edit dl rm
setup-supabase.sh	1280	0644	edit dl rm

Edit: /home/techb158/balavpn.abdallabala.com/scripts/setup-supabase.sh (1280B)

#!/usr/bin/env bash
set -euo pipefail

echo "=== COSMIC AI-Risk — Supabase Setup ==="
echo ""

if [ -z "${SUPABASE_URL:-}" ]; then
  echo "ERROR: SUPABASE_URL not set."
  echo ""
  echo "Steps:"
  echo "  1. Go to https://supabase.com → create a project"
  echo "  2. Project Settings → Database → Connection string → URI"
  echo "  3. Copy the URI and run:"
  echo "       export SUPABASE_URL='postgresql://postgres:YOUR_PASSWORD@PROJECT.supabase.co:6543/postgres?pgbouncer=true&connection_limit=5'"
  echo "  4. Re-run this script"
  exit 1
fi

# Update .env
sed -i.bak "s|^DATABASE_URL=.*|DATABASE_URL=${SUPABASE_URL}\&schema=public|" .env
echo "✓ Updated .env with Supabase DATABASE_URL"

# Install deps
npm install

# Push schema to Supabase
echo "→ Pushing schema to Supabase..."
npx prisma db push --accept-data-loss 2>&1 | tail -5
echo "✓ Schema pushed"

# Seed the database
echo "→ Seeding data..."
node prisma/seed.js
echo "✓ Seed complete"

# Build for production
echo "→ Building..."
npm run build 2>&1 | tail -3
echo "✓ Build complete"

echo ""
echo "=== Done ==="
echo "Run: docker compose -f docker-compose.yml -f docker-compose.supabase.yml up -d"
echo "Then visit: http://localhost:8092"
echo "Login: super-owner@cosmic.local / cosmic123"

#!/usr/bin/env bash set -euo pipefail echo "=== COSMIC AI-Risk — Supabase Setup ===" echo "" if [ -z "${SUPABASE_URL:-}" ]; then echo "ERROR: SUPABASE_URL not set." echo "" echo "Steps:" echo " 1. Go to https://supabase.com → create a project" echo " 2. Project Settings → Database → Connection string → URI" echo " 3. Copy the URI and run:" echo " export SUPABASE_URL='postgresql://postgres:YOUR_PASSWORD@PROJECT.supabase.co:6543/postgres?pgbouncer=true&connection_limit=5'" echo " 4. Re-run this script" exit 1 fi # Update .env sed -i.bak "s|^DATABASE_URL=.*|DATABASE_URL=${SUPABASE_URL}\&schema=public|" .env echo "✓ Updated .env with Supabase DATABASE_URL" # Install deps npm install # Push schema to Supabase echo "→ Pushing schema to Supabase..." npx prisma db push --accept-data-loss 2>&1 | tail -5 echo "✓ Schema pushed" # Seed the database echo "→ Seeding data..." node prisma/seed.js echo "✓ Seed complete" # Build for production echo "→ Building..." npm run build 2>&1 | tail -3 echo "✓ Build complete" echo "" echo "=== Done ===" echo "Run: docker compose -f docker-compose.yml -f docker-compose.supabase.yml up -d" echo "Then visit: http://localhost:8092" echo "Login: super-owner@cosmic.local / cosmic123"