- opening balance: "person 2 owes person 1" was stored the wrong way round - retour param: reject backslash/control chars (open redirect) - backup: pipefail + check dump completeness, failed dumps no longer logged OK - deleting a recurring occurrence marks it skipped so sync does not recreate it - editing a charge regenerates future occurrences of incomes allocated to it - settlements (incl. opening balance) listed in settings and deletable Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
29 lines
1.0 KiB
Bash
29 lines
1.0 KiB
Bash
#!/bin/bash
|
|
# Sauvegarde quotidienne de la base (03:00, heure de Paris), rétention 30 jours.
|
|
set -u -o pipefail
|
|
|
|
dump() {
|
|
local file="/backups/finances-$(date +%F_%H%M).sql.gz"
|
|
# pipefail : un échec de mariadb-dump fait échouer le pipeline ; la dernière ligne confirme un dump complet.
|
|
if mariadb-dump -h db -u root -p"$MARIADB_ROOT_PASSWORD" --single-transaction --routines finances | gzip > "$file.tmp" && gunzip -c "$file.tmp" | tail -n 1 | grep -q "Dump completed"; then
|
|
mv "$file.tmp" "$file"
|
|
echo "$(date '+%F %T') sauvegarde OK : $file"
|
|
else
|
|
rm -f "$file.tmp"
|
|
echo "$(date '+%F %T') ÉCHEC de la sauvegarde" >&2
|
|
fi
|
|
find /backups -name 'finances-*.sql.gz' -mtime +30 -delete
|
|
}
|
|
|
|
# Attend que la base réponde, puis une première sauvegarde au démarrage.
|
|
until mariadb-admin ping -h db -u root -p"$MARIADB_ROOT_PASSWORD" --silent; do sleep 5; done
|
|
dump
|
|
|
|
while true; do
|
|
now=$(date +%s)
|
|
next=$(date -d "tomorrow 03:00" +%s)
|
|
[ "$(date +%H)" -lt 3 ] && next=$(date -d "today 03:00" +%s)
|
|
sleep $((next - now))
|
|
dump
|
|
done
|