[Dehs-devel] r159 - trunk
atomo64-guest at alioth.debian.org
atomo64-guest at alioth.debian.org
Thu Sep 25 01:24:55 UTC 2008
Author: atomo64-guest
Date: 2008-09-25 01:24:54 +0000 (Thu, 25 Sep 2008)
New Revision: 159
Modified:
trunk/update_wwwal.sh
Log:
What used to be no_upstream.txt is now no_upstream.real.txt.
The former now only include packages with watch files that failed more than two
continuous times.
Modified: trunk/update_wwwal.sh
===================================================================
--- trunk/update_wwwal.sh 2008-09-01 02:35:12 UTC (rev 158)
+++ trunk/update_wwwal.sh 2008-09-25 01:24:54 UTC (rev 159)
@@ -23,7 +23,8 @@
php4 -q $WORKDIR/www/no_upstream.php > ./no_upstream.html
php4 -q $WORKDIR/www/no_updated.php > ./no_updated.html
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.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 || ': 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
More information about the Dehs-devel
mailing list