#!/bin/bash

redis-cli flushall

# Setup mysql:
DB_DATABASE=$(awk 'BEGIN {FS="=";} /^DB_DATABASE/ {print $2;}' .env)
DB_USERNAME=$(awk 'BEGIN {FS="=";} /^DB_USERNAME/ {print $2;}' .env)
DB_PASSWORD=$(awk 'BEGIN {FS="=";} /^DB_PASSWORD/ {print $2;}' .env)

if [ -z $DB_DATABASE ] || [ -z $DB_USERNAME ]; then
    echo ".env file does not contain mysql credentials!";
    exit;
fi

mysql -u$DB_USERNAME --password="$DB_PASSWORD" -e "DROP DATABASE IF EXISTS $DB_DATABASE"
mysql -u$DB_USERNAME --password="$DB_PASSWORD" -e "CREATE DATABASE $DB_DATABASE"

php artisan migrate --seed