[Dehs-devel] r100 - trunk
atomo64-guest at alioth.debian.org
atomo64-guest at alioth.debian.org
Sun Jan 27 17:09:58 UTC 2008
Author: atomo64-guest
Date: 2008-01-27 17:09:58 +0000 (Sun, 27 Jan 2008)
New Revision: 100
Modified:
trunk/update_wwwal.sh
Log:
Fixed the generator of no_updated.txt so it does only list packages which aren't up to date (thanks to Stefano Zacchiroli for pointing that out)
Fixed updated_real_count* so it doesn't incorrectly work just like updated_count*
Modified: trunk/update_wwwal.sh
===================================================================
--- trunk/update_wwwal.sh 2008-01-25 23:56:03 UTC (rev 99)
+++ trunk/update_wwwal.sh 2008-01-27 17:09:58 UTC (rev 100)
@@ -12,7 +12,7 @@
php4 -q $WORKDIR/www/no_updated.php > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_updated.html
psql -A -q -d dehs -c "SELECT name || ': N/A' FROM pkgs WHERE watch IS NULL OR watch='' AND dist='unstable' ORDER BY name ASC;" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_watch.txt
psql -A -q -d dehs -c "SELECT name || ': Error' FROM pkgs WHERE up_version='' AND watch!='' AND dist='unstable' order by name asc;" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_upstream.txt
- psql -A -q -d dehs -c "SELECT name || ': ' || up_version FROM pkgs WHERE up_version!='' AND watch!='' AND dist='unstable' order by name asc;" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_updated.txt
+ psql -A -q -d dehs -c "SELECT name || ': ' || up_version FROM pkgs WHERE up_version!='' AND watch!='' AND dist='unstable' AND updated='0' order by name asc;" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/no_updated.txt
psql -A -q -d dehs -c "SELECT name || ': N/A' FROM pkgs WHERE watch IS NULL OR watch='' AND dist='unstable' UNION SELECT name || ': Error' FROM pkgs WHERE up_version='' AND watch!='' AND dist='unstable' UNION SELECT name || ': ' || up_version FROM pkgs WHERE up_version!='' AND watch!='' AND dist='unstable';" | egrep -v '\?column\?|rows\)' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/dehs_debianqa.txt
fi
@@ -49,11 +49,11 @@
echo -n 'updated_count_experimental:' >> $STATS.new
psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
echo -n 'updated_real_count:' >> $STATS.new
-psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND version!='';" | egrep -v '[^0-9]' >> $STATS.new
+psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND up_version!='';" | egrep -v '[^0-9]' >> $STATS.new
echo -n 'updated_real_count_unstable:' >> $STATS.new
-psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND version!='' AND dist='unstable';" | egrep -v '[^0-9]' >> $STATS.new
+psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND up_version!='' AND dist='unstable';" | egrep -v '[^0-9]' >> $STATS.new
echo -n 'updated_real_count_experimental:' >> $STATS.new
-psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND version!='' AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
+psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND up_version!='' AND dist='experimental';" | egrep -v '[^0-9]' >> $STATS.new
echo -n 'updated_wwiz_count:' >> $STATS.new
psql -A -q -d dehs -c "SELECT COUNT(id) FROM pkgs WHERE updated='1' AND wwiz_type='watch';" | egrep -v '[^0-9]' >> $STATS.new
echo -n 'updated_wwiz_count_unstable:' >> $STATS.new
More information about the Dehs-devel
mailing list