#!/bin/bash
# MySQL Backup Cleanup Script
# Generated: 2025-12-18

GDRIVE_PATH="GDrive-Karmanye:Karmanye/DevOpsYes/ServerBackup/5.9.111.147/MySQLDump"
LOG_FILE="/tmp/deletion_log_$(date +%Y%m%d_%H%M%S).log"
SUCCESS_COUNT=0
FAIL_COUNT=0
TOTAL=$(wc -l < /tmp/remove_filenames.txt)

echo "Starting deletion of $TOTAL files at $(date)" | tee "$LOG_FILE"
echo "================================================" | tee -a "$LOG_FILE"

while IFS= read -r filename; do
    if [ -n "$filename" ]; then
        echo -n "Deleting: $filename ... " | tee -a "$LOG_FILE"
        if rclone delete "$GDRIVE_PATH/$filename" 2>&1; then
            echo "OK" | tee -a "$LOG_FILE"
            ((SUCCESS_COUNT++))
        else
            echo "FAILED" | tee -a "$LOG_FILE"
            ((FAIL_COUNT++))
        fi
        echo "Progress: $((SUCCESS_COUNT + FAIL_COUNT))/$TOTAL" 
    fi
done < /tmp/remove_filenames.txt

echo "================================================" | tee -a "$LOG_FILE"
echo "Completed at $(date)" | tee -a "$LOG_FILE"
echo "Success: $SUCCESS_COUNT, Failed: $FAIL_COUNT" | tee -a "$LOG_FILE"
echo "Log saved to: $LOG_FILE"