[Answered ]-What's a Good Way to Commit All MySQL Settings Needed to Get a Django App Running?

by

2👍

✅

Use mysql-python and write a python script to create the database or alter my shell script to make it suit your needs.

#!/bin/bash

function pre_checks() {

    if [[ "$1" -ne 3 ]]; then
        echo "Usage: $0 [DATABASE NAME] [USERNAME] [HOST]"
        return 1
    fi

    if ! command -v /usr/bin/mysql >/dev/null 2>&1; then
        echo "Mysql is not installed."
        return 1
    fi

    echo -n "Create the database '${2}' and the user '${3}' now? (y/n) "
    read ANSWER

    case "$ANSWER" in
        "y"|"Y")
            echo -n "Password for ${3}: "
            read -s USER_PW
            echo
            return 0 ;;
        "n"|"N"| *)
            echo "Bye."
            return 1 ;;
    esac
}

function create_db() {
    Q1="CREATE DATABASE IF NOT EXISTS ${1} CHARACTER SET utf8;"
    Q2="GRANT ALL ON *.* TO '${2}'@'${3}' IDENTIFIED BY '$USER_PW';"
    Q3="FLUSH PRIVILEGES;"
    Q4="SHOW DATABASES;"
    SQL="${Q1} ${Q2} ${Q3} ${Q4}"

    echo "Query:"
    echo "${SQL}"
    echo -n "Run query now? (y/n) "
    read ANSWER

    case "$ANSWER" in
        "y" | "Y" )
            /usr/bin/mysql -uroot -p -e "$SQL" || echo "Failure."
            ;;
        "n" | "N" | *)
            echo "Bye."
            return 1
            ;;
    esac
}

pre_checks "$#" "$1" "$2" && create_db "$1" "$2" "$3"
👤eminor

Leave a comment