aspirecloud/meta/bin/reset-testing-database
Chuck Adams 061b5d7c8a
minor gardening in meta/bin scripts
Signed-off-by: Chuck Adams <chaz@chaz.works>
2026-05-04 08:16:17 -06:00

12 lines
478 B
Bash
Executable file

#!/bin/bash
here=$(dirname "$0") && source "$here"/_prelude.bash
. .env
[[ -r .env.testing ]] && . .env.testing
export PGPASSWORD=$DB_ROOT_PASSWORD
psql -U "$DB_ROOT_USERNAME" -h "$DB_HOST" -c 'drop database if exists aspirecloud'
psql -U "$DB_ROOT_USERNAME" -h "$DB_HOST" -c "create database aspirecloud owner $DB_USERNAME"
psql -U "$DB_ROOT_USERNAME" -h "$DB_HOST" -c "create extension if not exists pg_trgm"
php artisan migrate --force --no-interaction
php artisan db:seed