#!/bin/bash

if [ ! -f .env ]; then
    echo ".env not found"
    cp .env.example .env
    echo "created .env file"
fi

case "$1" in
"-sqlite")

	# sqlite
	sed -i '' 's/^\(DB_CONNECTION=\).*/\1sqlite/' ".env"

	sed -i '' '/DB_HOST/ s/^#*/#/' ".env"
	sed -i '' '/DB_PORT/ s/^#*/#/' ".env"
	sed -i '' '/DB_DATABASE/ s/^#*/#/' ".env"
	sed -i '' '/DB_USERNAME/ s/^#*/#/' ".env"
	sed -i '' '/DB_PASSWORD/ s/^#*/#/' ".env"

	if [ ! -f database/database.sqlite ]; then
		echo "sqlite database not found"
		touch database/database.sqlite
		echo "created sqlite database file"
	fi
;;

* | "-mysql")

	# mysql
	if [ $(awk -F "=" '/DB_HOST/{print $NF}' ".env") ]
		then default_host="$(awk -F "=" '/DB_HOST/{print $NF}' ".env")"
		else default_host="127.0.0.1"
	fi
	echo "Type the MySQL host address you wish to use [$default_host]:"
	read host
	host=${host:-$default_host}

	if [ $(awk -F "=" '/DB_PORT/{print $NF}' ".env") ]
		then default_port="$(awk -F "=" '/DB_PORT/{print $NF}' ".env")"
		else default_port="3306"
	fi
	echo "Type the MySQL port you wish to use [$default_port]:"
	read port
	port=${port:-$default_port}

	if [ $(awk -F "=" '/DB_DATABASE/{print $NF}' ".env") ]
		then default_database="$(awk -F "=" '/DB_DATABASE/{print $NF}' ".env")"
	fi
	echo "Type the name of the MySQL database you wish to use [$default_database]:"
	read database
	database=${database:-$default_database}

	if [ $(awk -F "=" '/DB_USERNAME/{print $NF}' ".env") ]
		then default_username="$(awk -F "=" '/DB_USERNAME/{print $NF}' ".env")"
		else default_username="root"
	fi
	echo "Type the MySQL username you wish to use [$default_username]:"
	read username
	username=${username:-$default_username}

	if [ $(awk -F "=" '/DB_PASSWORD/{print $NF}' ".env") ]
		then default_password="$(awk -F "=" '/DB_PASSWORD/{print $NF}' ".env")"
	fi
	echo "Type the MySQL password you wish to use [$default_password]:"
	read password
	password=${password:-$default_password}

	sed -i '' 's/^\(DB_CONNECTION=\).*/\1mysql/' ".env"

	sed -i '' 's/^#DB_HOST=/DB_HOST=/g' ".env"
	sed -i '' 's/^\(DB_HOST=\).*/\1'$host'/' ".env"

	sed -i '' 's/^#DB_PORT=/DB_PORT=/g' ".env"
	sed -i '' 's/^\(DB_PORT=\).*/\1'$port'/' ".env"

	sed -i '' 's/^#DB_DATABASE=/DB_DATABASE=/g' ".env"
	sed -i '' 's/^\(DB_DATABASE=\).*/\1'$database'/' ".env"

	sed -i '' 's/^#DB_USERNAME=/DB_USERNAME=/g' ".env"
	sed -i '' 's/^\(DB_USERNAME=\).*/\1'$username'/' ".env"

	sed -i '' 's/^#DB_PASSWORD=/DB_PASSWORD=/g' ".env"
	sed -i '' 's/^\(DB_PASSWORD=\).*/\1'$password'/' ".env"
;;

esac

php artisan config:clear
php artisan config:cache

php artisan migrate