cashless2ecash

cashless2ecash: pay with cards for digital cash (experimental)
Log | Files | Refs | README

wipe_db.sh (509B)

      1 #!/bin/bash
      2 
      3 if [ "$#" -ne 3 ]; then
      4     echo "Usage: $0 <db-username> <db-password> <db-name>"
      5     exit 1
      6 fi
      7 
      8 DB_USERNAME=$1
      9 DB_PASSWORD=$2
     10 DB_NAME=$3
     11 
     12 SQL_SCRIPTS=(
     13     "./../c2ec/db/drop.sql"
     14 )
     15 
     16 execute_sql_scripts() {
     17     for script in "${SQL_SCRIPTS[@]}"; do
     18         PGPASSWORD=$DB_PASSWORD psql -U $DB_USERNAME -d $DB_NAME -f "$script"
     19         if [ $? -ne 0 ]; then
     20             echo "Failed to execute SQL script: $script"
     21             exit 1
     22         fi
     23     done
     24     PGPASSWORD=""
     25 }
     26 
     27 execute_sql_scripts