• Intro
• Downloads
• Community
• Development
• News
• TALK

User:Aapo/Waemo/Status

After flash, before updating anything, run this shell-script (doesn't need bash. sqlite3 is installed by default):

sqlite3 packages.sqlite "CREATE table packages(name TEXT, maemo_version TEXT, wheezy_version TEXT);"

for p in `cat goal.txt`
do
        m=`apt-cache policy $p | head -n 2 | tail -n 1 | awk {'print $2'}`
        sqlite3 packages.sqlite "INSERT into packages values('$p','$m','0');"
done

After upgrade, run this:

#if version differs, bump wheezy-version
for p in `cat goal.txt`
do
   w=`apt-cache policy $p | head -n 2 | tail -n 1 | awk {'print $2'}`
   sqlite3 packages.sqlite "UPDATE packages SET wheezy_version='$w' WHERE  name='$p' AND maemo_version!='$w'"
done

Then print results on wiki-format with this:

#!/bin/sh
#this doesn't need bash.

#header of table
echo "{| class="wikitable sortable"
! Name !! Maemo-version !! Waemo-version !! Issues 
|-"

#loop over each package
for p in `cat goal.txt`
do
m=`sqlite3 packages.sqlite "SELECT maemo_version  FROM packages WHERE name='$p';"`
w=`sqlite3 packages.sqlite "SELECT wheezy_version FROM packages WHERE name='$p';"`

echo -n "| $p ||"
echo -n $m
echo -n " || "
if [ "$w" == "0" ]; then
    echo " - || Some issue"
else
    echo "$w || none"
fi

echo "|-"
done

#footer of table
echo "}"

And it should produce skeleton (without hand filled issues)