Back (Current repo: scraps)

commit 096922025cf501266f312d32b38e1c848a573ecf
parent ece80255195dd6c3ef68bed57c9c1bb8e67d9e48
Author: root <root>
Date:   Thu,  5 Jun 2025 19:03:22 +0200

fix accidental nonsense

Diffstat:
M
bash/funcs/daily_range_partition.sh
 | 
4
++--

1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/bash/funcs/daily_range_partition.sh b/bash/funcs/daily_range_partition.sh
@@ -8,12 +8,12 @@ MARIADB="mysql -u root -A "
 echo "ALTER TABLE some_table DROP PARTITION pFuture; ALTER TABLE some_table ADD PARTITION (PARTITION p$(date -d "$DD" +%Y%m%d) VALUES LESS THAN (TO_DAYS('$TD')), PARTITION pFuture VALUES LESS THAN MAXVALUE);" | $MARIADB
 
 #drop old partitions
-OLD_PART=$(date -d "$DD - 6 months" +%Y%m%d)
+OLD_PART=$(date -d "$DD - 6 months" +%s)
 
 for PART in $(echo "SELECT partition_name FROM information_schema.partitions WHERE table_name = 'some_table' AND partition_method = 'RANGE';" | $MARIADB --skip-column-names | grep -v Future)
 do
     PART_DATE="${PART:1}" #drop prefix p to extract date portion
-    PART_DATE_TEMP="${PART_DATE:0:4}-${PART_DATE:4:2}-${PART_DATE:6:2}"
+    PART_DATE_TEMP=$(date -d "${PART_DATE:0:4}-${PART_DATE:4:2}-${PART_DATE:6:2}" +%s)
 
     if [[ "$OLD_PART" > "$PART_DATE_TEMP" ]]; then
         echo "ALTER TABLE some_table DROP PARTITION ${PART};" | $MARIADB