server_update.sh 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. #!/bin/bash
  2. # Скрипт автоматического обновления сайта
  3. PROJECT_DIR="/var/www/radionica3d"
  4. echo "==== DEPLOY STARTING: $(date) ===="
  5. cd $PROJECT_DIR
  6. # 1. Забираем код
  7. echo "git pull..."
  8. git checkout package-lock.json # Force clean lockfile to avoid conflicts
  9. git pull origin master
  10. # 2. Собираем фронтенд
  11. echo "building frontend..."
  12. npm install --legacy-peer-deps
  13. # 2. Собираем фронтенд
  14. echo "building frontend..."
  15. rm -rf dist/ # Clean old build
  16. npm install --legacy-peer-deps
  17. bash build_frontend.sh
  18. # 3. Обновляем бэкенд
  19. echo "updating backend..."
  20. ./backend/venv/bin/pip install -r backend/requirements.txt
  21. echo "running database migrations..."
  22. # Create backup before migrating
  23. mkdir -p backups
  24. echo "Backing up database to backups/ folder..."
  25. # If you use a .env file for DB credentials, source it here:
  26. # [ -f .env ] && export $(grep -v '^#' .env | xargs)
  27. mysqldump --no-tablespaces -h ${DB_HOST:-localhost} -u ${DB_USER:-radionica} -p${DB_PASS:-NY9B9VLifDC9ehZ} ${DB_NAME:-radionica3d} > backups/db_pre_migration_$(date +%Y%m%d_%H%M%S).sql
  28. ./backend/venv/bin/python3 backend/run_migrations.py
  29. # 4. Перезапуск
  30. echo "restarting services..."
  31. sudo chown -R www-data:www-data $PROJECT_DIR
  32. sudo systemctl restart radionica-backend
  33. cp /var/www/radionica3d/nginx.conf /etc/nginx/sites-available/radionica3d
  34. sudo systemctl reload nginx
  35. echo "==== DEPLOY FINISHED: $(date) ===="