[Dehs-devel] r164 - trunk

[atomo64-guest at alioth.debian.org]

Author: atomo64-guest
Date: 2008-11-23 02:39:08 +0000 (Sun, 23 Nov 2008)
New Revision: 164

Modified:
   trunk/update_wwwal.sh
Log:
Exclude packages from no_updated.txt if they have a version in experimental and is up to date


Modified: trunk/update_wwwal.sh
===================================================================
--- trunk/update_wwwal.sh	2008-10-31 01:07:17 UTC (rev 163)
+++ trunk/update_wwwal.sh	2008-11-23 02:39:08 UTC (rev 164)
@@ -25,7 +25,7 @@
     psql -A -q -c "SELECT name || ': N/A' FROM pkgs WHERE watch IS NULL OR watch=''  AND dist='unstable' ORDER BY name ASC;" | egrep -v '\?column\?|rows\)'  > ./no_watch.txt
     psql -A -q -c "SELECT name || ': Error' FROM pkgs WHERE up_version='' AND watch!='' AND dist='unstable' AND watch_warn !='' order by name asc;" | egrep -v '\?column\?|rows\)'  > ./no_upstream.real.txt
     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' order by name asc;" | egrep -v '\?column\?|rows\)'  > ./no_updated.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
 fi