# HG changeset patch
# User Pierre-Yves David <pierre-yves.david@octobus.net>
# Date 1731411923 -3600
# Node ID 77b38c86915d3b9380d30ce5c6ad1cf99f5dfca0
# Parent  085cc409847d8fca3abbbcd21ec5540eabb4e108
ci: add a small script one can run to purge older pipeline

We have over ten thousands old pipeline that take a huge space and that I
suspect to be the source of some slowdown in merge request.

However it seems that the only way to clear them is manually and through the
API, so lets do it.

The script was run today.

diff -r 085cc409847d -r 77b38c86915d contrib/cleanup-pipeline.sh
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/contrib/cleanup-pipeline.sh	Tue Nov 12 12:45:23 2024 +0100
@@ -0,0 +1,36 @@
+#!/bin/bash
+# A small script to cleanup old CI-pipeline that accumulate over time
+
+
+d="`date -d '-1 month' --iso-8601`T00:00:00Z"
+
+PROJECT_ID=22
+
+token=$1
+
+if [ -z $token ]; then
+    echo "USAGE: $0 GITLAB_TOKEN" >&2
+    exit 64
+fi
+
+get_ids() {
+    curl --silent "https://foss.heptapod.net/api/v4/projects/$PROJECT_ID/pipelines?updated_before=$d&per_page=100" | python3 -m json.tool | grep -E '"\bid": ([0-9]+),' | grep -oE '[0-9]+'
+}
+
+ids=`get_ids`
+while [ -n "$ids" ]; do
+    echo '#########'
+    for pipeline_id  in $ids; do
+        echo "deleting pipeline #$pipeline_id"
+        url="https://foss.heptapod.net/api/v4/projects/$PROJECT_ID/pipelines/$pipeline_id"
+        echo $url
+        curl \
+            --header "PRIVATE-TOKEN: $token"\
+            --request "DELETE"\
+            $url
+    done
+    ids=`get_ids`
+    if [ -n "$ids" ]; then
+        sleep 1
+    fi
+done