Exports a database from a symfony production environment and imports it in a test environment using the database strings declared in the .env files.

importProdSfDbToTest

#!/bin/bash


prodDbString=$(grep "DATABASE_URL" //httpdocs/prodEnv/releases/current/.env.local)
testDbString=$(grep "DATABASE_URL" //httpdocs/testEnv/releases/current/.env)

function readDbCredentials {
        user=$(grep -oP "(?<=mysql\:\/\/)\w+(?=\:)" <<< $1)
        pw=$(grep -oP "(?<=mysql\:\/\/$user\:).*(?=\@)" <<< $1)
        db=$(grep -oP "\w+$" <<< $1)
}

readDbCredentials $prodDbString
mysqldump --port 3306 -h 127.0.0.1 -u "$user" -p"$pw" "$db" > prodDb.sql

readDbCredentials $testDbString
mysql --port 3306 -h 127.0.0.1 -u "$user" -p"$pw" "$db" < prodDb.sql
rm prodDb.sql