cashless2ecash

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

grant_privileges.sh (622B)

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