kych

OAuth 2.0 API for Swiyu to enable Taler integration of Swiyu for KYC (experimental)
Log | Files | Refs

install_db.sh (1097B)

      1 #!/bin/bash
      2 
      3 # install/setup the database of the oauth2_gateway with this script
      4 
      5 if [ -f .env ]; then
      6     export $(grep -v '^#' .env | xargs)
      7 else
      8     echo ".env file not found"
      9     echo ""
     10     echo "Using default DB config"
     11     echo ""
     12 fi
     13 
     14 DB_PORT=${DB_PORT:-5432}
     15 DB_NAME=${DB_NAME:-oauth2gw}
     16 DB_USER=${DB_USER:-oauth2gw}
     17 DB_PASS=${DB_PASS:-password}
     18 
     19 psql -d postgres -c "CREATE USER $DB_USER WITH PASSWORD '$DB_PASS';"
     20 psql -d postgres -c "CREATE DATABASE $DB_NAME OWNER $DB_USER;"
     21 
     22 psql -d $DB_NAME -f oauth2_gatewaydb/versioning.sql
     23 psql -d $DB_NAME -f oauth2_gatewaydb/oauth2gw-0001.sql
     24 
     25 psql -d $DB_NAME -c "GRANT USAGE ON SCHEMA oauth2gw TO $DB_USER;"
     26 psql -d $DB_NAME -c "GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA oauth2gw TO $DB_USER;"
     27 psql -d $DB_NAME -c "GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA oauth2gw TO $DB_USER;"
     28 psql -d $DB_NAME -c "ALTER DEFAULT PRIVILEGES IN SCHEMA oauth2gw GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO $DB_USER;"
     29 psql -d $DB_NAME -c "ALTER DEFAULT PRIVILEGES IN SCHEMA oauth2gw GRANT USAGE, SELECT ON SEQUENCES TO $DB_USER;"
     30