Re: (semi-)automatic unclaim of packages with more than 2 weeks of inactivity (and missing DLAs on www.do)

[Holger Levsen]

Hi Jeremiah,

On Mon, Sep 06, 2021 at 08:57:04PM -0400, Jeremiah C. Foster wrote:
> > (Jeremiah, shall I explain how to gather this data?)

so there are three very simple scripts involved, which are attached and which
I used to run every Monday and then I massaged them into one email, where I 
basically
just resend the same but edited mail every week.

These scripts expect that you have clones of the security-tracker.git repo as 
well
as the extented-security-tracker.git repo and the webwml.git repo checked out in
these directories:
 ~/Projects/security-tracker
 ~/Projects/extended-security-tracker
 ~/Projects/debian-www/webwml 

I didn't sent that mail yesterday as I planned to send these instructions 
instead.
if you have any further questions, please ask.


-- 
cheers,
        Holger

 ⢀⣴⠾⠻⢶⣦⠀
 ⣾⠁⢠⠒⠀⣿⡁  holger@(debian|reproducible-builds|layer-acht).org
 ⢿⡄⠘⠷⠚⠋⠀  OpenPGP: B8BF54137B09D35CF026FE9D 091AB856069AAA1C
 ⠈⠳⣄

„Guten Tag, ich rufe Sie an, um Ihnen mitzuteilen, dass Ihre Tochter seit
geraumer Zeit die schulischen Abläufe erheblich stört.“ - „Entschuldigen Sie,
meine Tochter ist 54 und Ministerin für Schule und Bildung in NRW.“ - „Gut,
dann wissen Sie also, von wem ich rede.“        - Germany, early 2021

#!/bin/sh
# WTF licenced, copyright 2019 Holger Levsen

_unclaim(){
        TARGET=$1
        DIR=$2
        figlet $TARGET
        cd $DIR
        git status
        git pull
        git status
        ./bin/review-update-needed --$TARGET --unclaim 1209600 --exclude linux 
linux-4.9 linux-4.19 xen
        git commit -a -s -m 'semi-automatic unclaim after 2 weeks of inactivity'
        git log -p -1
        echo
        echo "Don't forget to push..."
        echo
        git status
        bash
}

unclaim_lts(){
        _unclaim lts ~/Projects/security-tracker
}

unclaim_elts(){
        _unclaim elts ~/Projects/extended-security-tracker
}

if [ -z "$1" ] ; then
        xterm -e "$0 unclaim_lts" &
        xterm -e "$0 unclaim_elts" &
else
        $1
fi



#!/bin/bash

# WTF licenced, copyright 2020-2021 Holger Levsen

TRESHOLD=4

cd ~/Projects/security-tracker
git pull
echo

DLANEEDED=~/Projects/security-tracker/data/dla-needed.txt 
TMPFILE=$(mktemp)
egrep '^[A-Za-z0-9]+\ \(.*\)'  $DLANEEDED | cut -d ' ' -f2-| sort | tr -d 
'('|tr -d ')' | sort -u > $TMPFILE
WARNING=$(mktemp)

echo "Current number of package claims in LTS:"
echo "========================================"
( while IFS= read -r  LINE ; do
        HITS=$(grep -v '^ ' $DLANEEDED | grep -c "$LINE")
        PACKAGES=$(grep -v '^ ' $DLANEEDED | grep "$LINE" | cut -d ' ' -f1 | 
xargs echo)
        echo "$HITS: $LINE"
        if [ $HITS -ge $TRESHOLD ] ; then
                echo "Warning: $LINE probably claimed too many: $HITS packages: 
$PACKAGES" >> $WARNING
        fi 
 done < $TMPFILE ) |sort -nr

echo
if [ -s $WARNING ] ; then
        cat $WARNING | sort
else
        echo "Nice, noone claimed $TRESHOLD packages or more."
fi
echo

rm $TMPFILE $WARNING

#!/bin/bash

# WTF licenced, copyright 2020 Holger Levsen

cd ~/Projects/security-tracker
git pull
cd ~/Projects/debian-www/webwml 
git pull
./english/security/find-missing-advisories --mode DLA --tracker 
../../security-tracker/ 2>&1

signature.asc
Description: PGP signature