#!/usr/bin/env bash
set -euo pipefail

APP_DIR="${GRANO_APP_DIR:-/opt/grano-pos}"
BACKUP_DIR="${GRANO_BACKUP_DIR:-/var/backups/grano-pos}"
DATABASE="${APP_DIR}/pos-central.sqlite3"
STAMP="$(date +%Y%m%d-%H%M%S)"

if [[ ! -f "${DATABASE}" ]]; then
  echo "No existe la base ${DATABASE}."
  exit 1
fi

install -d -m 0750 "${BACKUP_DIR}"
sqlite3 "${DATABASE}" ".backup '${BACKUP_DIR}/grano-pos-${STAMP}.sqlite3'"
find "${BACKUP_DIR}" -type f -name 'grano-pos-*.sqlite3' -mtime +30 -delete
echo "Respaldo creado: ${BACKUP_DIR}/grano-pos-${STAMP}.sqlite3"