#!/bin/bash

(
# Set PGPASSWORD
source ../../.env

# Target database connection info - replace with your target DB

# DB_NAME="db.gxbejryrwhsmuailcdur.supabase.co" # dev
DB_NAME="db.lltoaluoavlzrgjplire.supabase.co" # prod
DB_USER="postgres"
PORT="5432"

psql -U $DB_USER -d postgres -h $DB_NAME -p $PORT -w \
-f ./love-stars-dump.sql \


# psql -U $DB_USER -d postgres -h $DB_NAME -p $PORT -w \
# -c 'drop table temp_users cascade;'

# psql -U $DB_USER -d postgres -h $DB_NAME -p $PORT -w \
# -f ./temp-users-dump.sql \

# psql -U $DB_USER -d postgres -h $DB_NAME -p $PORT -w \
# -f ../supabase/private_users.sql \
# -f ../supabase/users.sql

# psql -U $DB_USER -d postgres -h $DB_NAME -p $PORT -w \
# -f './import-love-finalize.sql'

echo "Done"
)