[Dehs-devel] r173 - trunk

[Raphael Geissert]

Author: atomo64-guest
Date: 2009-07-24 10:19:42 +0000 (Fri, 24 Jul 2009)
New Revision: 173

Modified:
   trunk/update_wwwal.sh
Log:
Export some data for UDD, as part of the Debcamp/Debconf work


Modified: trunk/update_wwwal.sh
===================================================================
--- trunk/update_wwwal.sh	2009-07-10 16:42:48 UTC (rev 172)
+++ trunk/update_wwwal.sh	2009-07-24 10:19:42 UTC (rev 173)
@@ -28,6 +28,7 @@
     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' 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
+    psql -At -q -c "SELECT COALESCE(u.name, e.name) AS source, u.up_version AS unstable_upstream, e.up_version AS experimental_upstream, u.version AS unstable_version, e.version AS experimental_version, u.dversionmangled AS unstable_parsed_version, e.dversionmangled AS experimental_parsed_version, u.updated AS unstable_uptodate, e.updated AS experimental_uptodate, u.watch_warn <> '' AS  unstable_failed, e.watch_warn <> '' AS experimental_failed FROM (select * from pkgs where dist='unstable' AND watch IS NOT NULL) AS u FULL JOIN (select * from pkgs where dist='experimental' AND watch IS NOT NULL) AS e ON u.name=e.name WHERE (u.dist='unstable' OR u.dist IS NULL) AND (e.dist='experimental' OR e.dist IS NULL);" > ./udd_dump.txt
 fi
 
 STATS=./stats.txt