Load_Test_Data.sh

#!/bin/bash

# Get encrypted password from MySQL Octopus variable set
octopus_pwd=$(get_octopusvariable "octopus_pwd")

# Use the directory where the package was pushed to in the previous deploy step
OctopusDrop=$(get_octopusvariable "Octopus.Action[Push seed script package].Output.Octopus.Action.Package.InstallationDirectoryPath")
echo "Drop: $OctopusDrop"

echo "Updating DataWarehouse DB"
mysql -h localhost -u ServiceAccountName -p$octopus_pwd DataWarehouse < "$OctopusDrop/SQLScript1.sql" 
mysql -h localhost -u ServiceAccountName -p$octopus_pwd DataWarehouse < "$OctopusDrop/SQLScript2.sql" 
mysql -h localhost -u ServiceAccountName -p$octopus_pwd DataWarehouse < "$OctopusDrop/SQLScript3.sql"