[Lsb-messages] /var/www/bzr/lsb/devel/specdb-aux-scripts r17: Check refspecurls, as well

[Denis Silakov]

------------------------------------------------------------
revno: 17
committer: Denis Silakov <denis.silakov at rosalab.ru>
branch nick: specdb-aux-scripts
timestamp: Mon 2014-05-12 14:25:52 +0400
message:
  Check refspecurls, as well
modified:
  url_checker.sh
-------------- next part --------------
=== modified file 'url_checker.sh'
--- a/url_checker.sh	2008-12-23 11:39:12 +0000
+++ b/url_checker.sh	2014-05-12 10:25:52 +0000
@@ -11,17 +11,30 @@
 
 # Note: we currently ignore anchors in cxxabi.html due to its incorrect layout
 # We also don't check arch-specific LSB urls
-mysql $LSBDB -u $LSBUSER $passwd_option -e "SELECT concat(Sbaselink,'/',ISurl), ISurl 
-		FROM IntStd JOIN Standard ON Sid=ISsid 
-		WHERE ISurl > '' 
-		AND ISurl NOT LIKE '%cxxabi%' 
-		AND ISurl NOT LIKE '%\$arch%'
-		AND ISwithdrawnin IS NULL 
-		UNION 
+mysql $LSBDB -u $LSBUSER $passwd_option -e "SELECT concat(Sbaselink,'/',ISurl), ISurl
+		FROM IntStd JOIN Standard ON Sid=ISsid
+		WHERE ISurl > ''
+		AND ISurl NOT LIKE '%cxxabi%'
+		AND ISurl NOT LIKE '%\$arch%
+		AND ISwithdrawnin IS NULL
+		UNION
 		SELECT replace(concat(Sbaselink,'/',CSurl),'functions','utilities'), CSurl AS ISurl
-		FROM CmdStd JOIN Standard ON Sid=CSsid 
-		WHERE CSurl > '' 
-		AND CSwithdrawnin IS NULL" | grep -v NULL |grep -v ISurl | \
+		FROM CmdStd JOIN Standard ON Sid=CSsid
+		WHERE CSurl > ''
+		AND CSwithdrawnin IS NULL
+		UNION
+                SELECT concat(Sbaselink,'/',ISrefspecurl), ISrefspecurl AS ISurl
+		FROM IntStd JOIN Standard ON Sid=ISrefspec
+		WHERE ISrefspecurl > ''
+		AND ISrefspecurl NOT LIKE '%cxxabi%'
+		AND ISrefspecurl NOT LIKE '%\$arch%'
+		AND ISwithdrawnin IS NULL
+		UNION
+		SELECT replace(concat(Sbaselink,'/',CSrefspecurl),'functions','utilities'), CSrefspecurl AS ISurl
+		FROM CmdStd JOIN Standard ON Sid=CSrefspec
+		WHERE CSrefspecurl > ''
+		AND CSwithdrawnin IS NULL
+		" | grep -v NULL |grep -v ISurl | \
 while read url isurl
 do
     http_present=`echo "$isurl" | grep http:// `