A Bash Script which uses Doctrine to create a update.sql file and executes the query into mysql

update.sh

#!/bin/bash

# Name: Doctrine Update Bash Script
# Description: Updates the MySQL database automatically with one script with doctrine!


echo "Creating the update.sql file.....\n"
./vendor/bin/doctrine-module orm:schema-tool:update --dump-sql >> ./scripts/db/update.sql

#Checking if the file exists
if [ -f ./scripts/db/update.sql ]; then
    echo "SUCCESS! File successfully created!\n"
    echo "Executing the query\n"
    #To use this run this before using this script:
    # mysql_config_editor set --login-path=local --hostname=localhost --user=[ENTER USER HERE] --password
    # NOTE: This will ask for the mysql password after you hit enter on this command
    # mysql_config_editor manpages: https://docs.oracle.com/cd/E53394_01/html/E54763/mysql-config-editor-1.html
    mysql --login-path=local [dbname here] < ./scripts/db/update.sql
    rm ./scripts/db/update.sql
    echo "Query successfully updated!!"
else
    echo "ERROR: UNABLE TO CREATE update.sql file"
fi