Bash script to reinstall SuperV cleanly

reset.sh

#!/bin/bash

# Get database name from .env file
#
DB_DATABASE=$(grep DB_DATABASE .env | cut -d '=' -f 2-)

if [ -z $DB_DATABASE ]; then
 echo 'Could not read database name from .env file'
 exit
fi

# Drop all tables
#
echo $DB_DATABASE | xargs -I {} sh -c "mysql -Nse 'show tables' {}| xargs -I[] mysql -e 'SET FOREIGN_KEY_CHECKS=0; drop table []' {}" || exit 255

# Set SV_INSTALLED back to false
# (Sed works slightly different in macOS)
#
if [[ "$OSTYPE" == "darwin"* ]]; then
    sed -i '' 's/^SV_INSTALLED=true/SV_INSTALLED=false/g' .env
else
    sed -i 's/^SV_INSTALLED=true/SV_INSTALLED=false/g' .env
fi


php artisan migrate --force
php artisan cache:clear
php artisan superv:install