#!/bin/sh

set -eu

TIMESTAMP=$(date -u +%Y-%m-%dT%H%M%SZ)

BUCKET="${R2_BUCKET:-andromeda-backups}"

RETENTION_DAYS="${RETENTION_DAYS:-30}"

DBS="jotts:/data/jotts/jotts.sqlite sipp:/data/sipp/sipp.sqlite cellar:/data/cellar/cellar.sqlite posts:/data/posts/posts.sqlite feeds:/data/feeds/feeds.sqlite library:/data/library/library.sqlite bookmarks:/data/bookmarks/bookmarks.sqlite parcels:/data/parcels/parcels.db easel:/data/easel/easel.sqlite"

for entry in $DBS; do

  name="${entry%%:*}"

  path="${entry#*:}"

  if [ ! -f "$path" ]; then

    echo "WARN: $path not found, skipping $name"

    continue

  fi

  backup_file="/tmp/${name}-${TIMESTAMP}.sqlite"

  echo "$(date -u) Backing up $name..."

  sqlite3 "$path" ".backup '$backup_file'"

  gzip "$backup_file"

  aws s3 cp "${backup_file}.gz" "s3://${BUCKET}/${name}/${TIMESTAMP}.sqlite.gz" \

    --endpoint-url "${R2_ENDPOINT}"

  rm -f "${backup_file}.gz"

  echo "$(date -u) OK: $name uploaded"

done

# Prune old backups

cutoff=$(date -u -d "-${RETENTION_DAYS} days" +%Y-%m-%d 2>/dev/null || date -u -v-${RETENTION_DAYS}d +%Y-%m-%d)

for name in jotts sipp cellar posts feeds library bookmarks parcels easel; do

  aws s3 ls "s3://${BUCKET}/${name}/" --endpoint-url "${R2_ENDPOINT}" 2>/dev/null | while read -r line; do

    filedate=$(echo "$line" | awk '{print $1}')

    filename=$(echo "$line" | awk '{print $4}')

    if [ -n "$filename" ] && [ "$filedate" \< "$cutoff" ]; then

      aws s3 rm "s3://${BUCKET}/${name}/${filename}" --endpoint-url "${R2_ENDPOINT}"

      echo "$(date -u) Pruned: ${name}/${filename}"

    fi

  done

done

echo "$(date -u) Backup complete"