[Dehs-devel] r104 - trunk
atomo64-guest at alioth.debian.org
atomo64-guest at alioth.debian.org
Fri Feb 1 23:03:22 UTC 2008
Author: atomo64-guest
Date: 2008-02-01 23:03:22 +0000 (Fri, 01 Feb 2008)
New Revision: 104
Modified:
trunk/update_wwwal.sh
Log:
Only list packages in unstable on the ddpomail.txt file
Modified: trunk/update_wwwal.sh
===================================================================
--- trunk/update_wwwal.sh 2008-01-29 23:15:55 UTC (rev 103)
+++ trunk/update_wwwal.sh 2008-02-01 23:03:22 UTC (rev 104)
@@ -14,7 +14,7 @@
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' 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
- psql -A -q -d dehs -c "SELECT name,version,up_version,lastupvsdebsync FROM pkgs WHERE up_version!='' AND up_version IS NOT NULL AND watch!='' AND watch IS NOT NULL AND updated='0'" | egrep -v '\?column\?|rows\)' | grep -v 'name|version|up_version|lastupvsdebsync' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/ddpomail.txt
+ psql -A -q -d dehs -c "SELECT name,version,up_version,lastupvsdebsync FROM pkgs WHERE up_version!='' AND up_version IS NOT NULL AND watch!='' AND watch IS NOT NULL AND updated='0' AND dist='unstable'" | egrep -v '\?column\?|rows\)' | grep -v 'name|version|up_version|lastupvsdebsync' > /org/alioth.debian.org/chroot/home/groups/dehs/htdocs/ddpomail.txt
fi
STATS=/org/alioth.debian.org/chroot/home/groups/dehs/htdocs/stats.txt
More information about the Dehs-devel
mailing list