Update Script (bash) for my Part-DB, bare metal

[tkuschel]

I would like to provide my update script below:

Prerequisite:

• Native installation (Bare-metal deployment), e.g. Debian,
• The user can execute programs with root privileges via sudo,
• The directories require write permissions for the web user; therefore, the PartDB directories must be accessible and writable by the web server user.

upd_partdb_git.sh

#!/bin/bash

# Configuration - adjust these paths if necessary
PARTDB_PATH="/var/www/partdb"
BACKUP_DIR="/var/www/partdb_backup"
WEB_USER="www-data"

# Ensure backup directory exists
mkdir -p "$BACKUP_DIR"

# Function for Yes/No prompts
ask_confirmation() {
    while true; do
        read -p "$1 (y/n): " yn
        case $yn in
            [Yy]* ) return 0;;
            [Nn]* ) return 1;;
            * ) echo "Please answer yes or no.";;
        esac
    done
}

echo "--- Starting Part-DB Maintenance Script ---"

# Step 1: Backup
if ask_confirmation "1. Do you want to backup the whole Part-DB?"; then
    TIMESTAMP=$(date +%Y%m%d_%H%M%S)
    BACKUP_FILE="$BACKUP_DIR/partdb_full_$TIMESTAMP.zip"
    echo "Running backup..."
    sudo -u "$WEB_USER" php "$PARTDB_PATH/bin/console" partdb:backup --full "$BACKUP_FILE"
    echo "Backup saved to: $BACKUP_FILE"
else
    echo "Skipping backup."
fi

# Step 2: Git Update
if ask_confirmation "2. Do you want to pull the latest updates from Git?"; then
    echo "Pulling updates..."
    cd "$PARTDB_PATH" || exit
    sudo -u "$WEB_USER" git pull origin master
else
    echo "Skipping Git update."
fi

# Step 3: Clear Cache
if ask_confirmation "3. Do you want to clear the Part-DB cache?"; then
    echo "Clearing cache..."
    sudo -u "$WEB_USER" php "$PARTDB_PATH/bin/console" cache:clear
    echo "Cache cleared successfully."
else
    echo "Skipping cache clear."
fi

echo "--- Maintenance Complete ---"