WIP: Download and import a drupal database from pantheon cli (Terminus)

pantheon-get-db

#!/usr/bin/env bash

EMAIL="[email protected]"
SITE="mypantheonsite"
ENVIRONMENT="live"

terminus auth login $EMAIL
terminus site backup create --site=$SITE --env=$ENVIRONMENT --element=database
DUMPURL=`terminus site backup get --site=$SITE --env=$ENVIRONMENT --element=database --latest`

echo "Fetching $SITE database"
curl -o $SITE.sql.gz $DUMPURL
gunzip $SITE.sql.gz
mysql -uroot -e "DROP SCHEMA $SITE; CREATE SCHEMA $SITE"
mysql -uroot $SITE < $SITE.sql
mysql -uroot -e "USE $SITE; UPDATE users SET mail = CONCAT(mail, '.test')"

terminus auth logout