From 84cbb5c0e67ef2a1ae95f64fb4f2ebf4c4e61fe6 Mon Sep 17 00:00:00 2001
From: Thierry Parmentelat <thierry.parmentelat@inria.fr>
Date: Thu, 21 Nov 2024 10:53:22 +0100
Subject: [PATCH] plc.d/db was creating .sql.sql files when applying migrations

---
 plc.d/db | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

diff --git a/plc.d/db b/plc.d/db
index d046692c..49f177a2 100755
--- a/plc.d/db
+++ b/plc.d/db
@@ -115,7 +115,13 @@ DATE=$(date +"%Y-%m-%d-%H-%M-%S")
 
 # Dumps the database - optional argument to specify filename suffix
 function dump_planetlab_db() {
-	if [ -n "$1" ]; then suffix="-$1"; else suffix=""; fi
+	if [ -n "$1" ]; then
+		# avoid ending with .sql.sql
+		suffix=$(basename -- "$1" .sql)
+		suffix="-$suffix"
+	else
+		suffix=""
+	fi
 	dumpfile=/var/lib/pgsql/backups/$(date +"${PLC_DB_NAME}.${DATE}${suffix}.sql")
 	checkpoint_planetlab_db $dumpfile
 }
-- 
2.47.0