[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] 2 commits: reproducible Debian: turn builtin-pho's SQL output into useful HTML links

[Holger Levsen]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
ae70d31a by Holger Levsen at 2020-02-27T17:36:09+01:00
reproducible Debian: turn builtin-pho's SQL output into useful HTML links

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -
c6c12d9e by Holger Levsen at 2020-02-27T17:38:21+01:00
reproducible Debian: simplefy sed a tiny bit. help on how to remove the 2nd tr call much welcome

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


1 changed file:

- bin/reproducible_html_builtin-pho.sh


Changes:

=====================================
bin/reproducible_html_builtin-pho.sh
=====================================
@@ -23,7 +23,7 @@ query_builtin_pho_db() {
 		local SUITE=$SUITE
 	fi
  
-	psql buildinfo <<EOF > $DUMMY_FILE
+	psql --tuples-only buildinfo <<EOF > $DUMMY_FILE
 SELECT DISTINCT p.source,p.version
 FROM
       binary_packages p
@@ -50,11 +50,15 @@ create_buildinfo_page() {
 	echo "$(date -u) - starting to write $PAGE page for $SUITE/$ARCH."
 	write_page_header $VIEW "Overview of various statistics about .buildinfo files for $SUITE/$ARCH"
 	write_page "<p>Packages without .buildinfo files in $SUITE/$ARCH:"
-	write_page "<br/><small>ToDo: turn package names/versions into useful links</small>"
+	write_page "<br/><small>ToDo: include count at top</small>"
+	write_page "<br/><small>ToDo: graph that count</small>"
+	write_page "<br/><small>ToDo: trigger rsync job on success</small>"
+	write_page "<br/><small>ToDo: link these pages from navigation</small>"
+	write_page "<br/><small>ToDo: make buildinfo-pool links work with server side redirects</small>"
 	write_page "</p>"
 	query_builtin_pho_db
 	write_page "<pre>"
-	cat $DUMMY_FILE >> $PAGE
+	cat $DUMMY_FILE | tr -d ' '  | sed -E "s/([^|]*)(.*)/<a href=\"https:\/\/tracker.debian.org\/\1\">\1<\/a> <a href=\"https:\/\/packages.debian.org\/$SUITE\/\1\">binaries (\2)<\/a> <a href=\"https:\/\/buildinfos.debian.net\/\1\">.buildinfo<\/a>/g" | tr -d '|' >> $PAGE
 	write_page "</pre>"
 	# the end
 	write_page_footer
@@ -62,7 +66,7 @@ create_buildinfo_page() {
 	mkdir -p ~jenkins/builtin-pho-html/debian/$SUITE/$ARCH
 	echo "$(date -u) - $(cp -v $PAGE ~jenkins/builtin-pho-html/debian/$SUITE/$ARCH/)"
 	rm $PAGE
-	echo "$(date -u) - $REPRODUCIBLE_URL/debian/$SUITE/$ARCH/$PAGE will be updated (via rsync) in 10min roughly..."
+	echo "$(date -u) - $REPRODUCIBLE_URL/debian/$SUITE/$ARCH/$PAGE will be updated (via rsync) after this job succeeded..."
 }
 
 #



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/8b9eecf390bf29810df60a2085bdfaa167737c0e...c6c12d9e59a5d54b7acda73655d5142ebfc8d042

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/8b9eecf390bf29810df60a2085bdfaa167737c0e...c6c12d9e59a5d54b7acda73655d5142ebfc8d042
You're receiving this email because of your account on salsa.debian.org.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20200227/4cda74ad/attachment-0001.html>