configs_collection/scripts/db_dropper
2024-11-02 14:05:10 +03:00

40 lines
1.4 KiB
Bash
Executable file

#!/bin/bash
# Database details
DBS=("console_db" "logs_db")
DB_OWNER="console_user"
# Drop and create databases
for DB in "${DBS[@]}"; do
sudo -u postgres -H -- psql -c "DROP DATABASE IF EXISTS $DB"
sudo -u postgres -H -- psql -c "CREATE DATABASE $DB OWNER $DB_OWNER"
done
PROJECT_DIR="/home/t0xa/Documents/backend"
VENV_DIR="$PROJECT_DIR/.venv"
cd "$PROJECT_DIR" || { echo "Project directory not found!"; exit 1; }
source "$VENV_DIR/bin/activate"
git clean -xf */migrations/
python3 manage.py makemigrations
python3 manage.py migrate
python3 manage.py migrate --database logs
python3 manage.py shell -c "
from django.contrib.auth import get_user_model;
User = get_user_model();
if not User.objects.filter(email='a@a.ru').exists():
User.objects.create_superuser('a@a.ru', password='T1Rules@123')
"
deactivate
# sudo -u postgres -H -- psql -c "DROP DATABASE console_db"
# sudo -u postgres -H -- psql -c "DROP DATABASE logs_db"
# sudo -u postgres -H -- psql -c "CREATE DATABASE console_db OWNER console_user"
# sudo -u postgres -H -- psql -c "CREATE DATABASE logs_db OWNER console_user"
# cd /home/t0xa/Documents/backend
# source .venv/bin/activate
# # python3 manage.py makemigrations
# python3 manage.py migrate
# python3 manage.py shell -c "from django.contrib.auth import get_user_model; User = get_user_model(); User.objects.create_superuser('a@a.ru', password='T1Rules@123')"
# deactivate