github.com/shyftnetwork/go-empyrean@v1.8.3-0.20191127201940-fbfca9338f04/shyft-config/shyft-cli/shyftTestDbClean.sh (about)

     1  #!/bin/bash
     2  
     3  for dbname in $(psql -X -c "copy (select datname from pg_database where datname like '%shyftdbtest_%') to stdout") ; do
     4      echo "$dbname"
     5      echo "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity where pg_stat_activity.datname='${dbname}';" | psql -X -U postgres -w
     6      # drop the DB
     7      echo "DROP DATABASE ${dbname};" | psql -X -U postgres -w
     8  done