[Dehs-devel] r172 - trunk
Raphael Geissert
geissert at alioth.debian.org
Fri Jul 10 16:42:49 UTC 2009
Author: geissert
Date: 2009-07-10 16:42:48 +0000 (Fri, 10 Jul 2009)
New Revision: 172
Modified:
trunk/update_wwwal.sh
Log:
Don't include in ddpomail.txt packages which are up to date in experimental
Modified: trunk/update_wwwal.sh
===================================================================
--- trunk/update_wwwal.sh 2009-05-17 03:28:30 UTC (rev 171)
+++ trunk/update_wwwal.sh 2009-07-10 16:42:48 UTC (rev 172)
@@ -27,7 +27,7 @@
psql -A -q -c "SELECT name || ': Error' FROM pkgs WHERE up_version='' AND watch!='' AND dist='unstable' AND watch_warn !='' AND failures_count > 2 order by name asc;" | egrep -v '\?column\?|rows\)' > ./no_upstream.txt
psql -A -q -c "SELECT name || ': ' || up_version FROM pkgs WHERE up_version!='' AND watch!='' AND dist='unstable' AND updated='0' AND name NOT IN (SELECT name FROM pkgs WHERE dist='experimental' AND up_version!='' AND watch!='' AND updated!='0') order by name asc;" | egrep -v '\?column\?|rows\)' > ./no_updated.txt
psql -A -q -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\)' > ./dehs_debianqa.txt
- psql -A -q -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' > ./ddpomail.txt
+ psql -A -q -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' AND name NOT IN (SELECT name FROM pkgs WHERE dist='experimental' AND up_version!='' AND watch!='' AND updated!='0')" | egrep -v '\?column\?|rows\)' | grep -v 'name|version|up_version|lastupvsdebsync' > ./ddpomail.txt
fi
STATS=./stats.txt
More information about the Dehs-devel
mailing list