truncate_core_id.sh

#!/usr/bin/env bash

VDATA=$(vault read -format=json secret/core/core-id/staging/us-east-1/rds)
PW=$(echo $VDATA | jq -r .data.password)
USER=$(echo $VDATA | jq -r .data.username) 
DBNAME=$(echo $VDATA | jq -r .data.dbname) 
HOST=$(echo $VDATA | jq -r .data.endpoint)

tables="Users,AccessToken,AuthorizationCode,Client,ClientCredentials,IdStore,InitialAccessToken,RefreshToken,RegistrationAccessToken,Session"

PGPASSWORD=$PW psql \
  -h $HOST \
  -p 5432 \
  -U $USER \
  -d $DBNAME \
  -c "TRUNCATE TABLE $tables"