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

[Holger Levsen <holger@layer-acht.org>]

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

Attachment: signature.asc
Description: PGP signature