#!/bin/sh

# Configuration
DB_NAME="hobes_fms"
DB_USER="postgres"
DB_HOST="localhost"
DB_PORT="5432"
SOURCE_SCHEMA="public"
TARGET_SCHEMA="fms_bhasika"

# Optional: export password (better to use .pgpass for security)
PGPASSWORD="postgres_123"

echo "Dumping schema $SOURCE_SCHEMA..."

pg_dump \
  --host=$DB_HOST \
  --port=$DB_PORT \
  --username=$DB_USER \
  --schema=$SOURCE_SCHEMA \
  --no-owner \
  --format=plain \
  $DB_NAME > source_schema.sql

if [ $? -ne 0 ]; then
  echo "Error dumping source schema."
  exit 1
fi

echo "Replacing schema name from $SOURCE_SCHEMA to $TARGET_SCHEMA..."
sed "s/$SOURCE_SCHEMA/$TARGET_SCHEMA/g" source_schema.sql > target_schema.sql

echo "Creating target schema $TARGET_SCHEMA (if not exists)..."
psql \
  --host=$DB_HOST \
  --port=$DB_PORT \
  --username=$DB_USER \
  --dbname=$DB_NAME \
  -c "CREATE SCHEMA IF NOT EXISTS $TARGET_SCHEMA;"

echo "Importing into target schema $TARGET_SCHEMA..."
psql \
  --host=$DB_HOST \
  --port=$DB_PORT \
  --username=$DB_USER \
  --dbname=$DB_NAME \
  -f target_schema.sql

echo "✅ Schema copy completed successfully."