@echo off
REM WhatsApp CRM SQLite Backup Script
REM Schedule this daily via Windows Task Scheduler

set BACKUP_DIR=C:\Users\talat\WhatsAppCRM_Backups
set DB_PATH=C:\Users\talat\Downloads\whatsapp\database\database.sqlite
set TIMESTAMP=%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%_%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%
set TIMESTAMP=%TIMESTAMP: =0%

if not exist "%BACKUP_DIR%" mkdir "%BACKUP_DIR%"

copy "%DB_PATH%" "%BACKUP_DIR%\database_%TIMESTAMP%.sqlite" >nul
echo [%DATE% %TIME%] Backup created: database_%TIMESTAMP%.sqlite >> "%BACKUP_DIR%\backup.log"

REM Keep only last 30 backups
forfiles /p "%BACKUP_DIR%" /m database_*.sqlite /d -30 /c "cmd /c del @file" >nul 2>&1

echo Backup complete: %BACKUP_DIR%\database_%TIMESTAMP%.sqlite
echo To schedule: Windows Task Scheduler > daily backup.cmd