#!/bin/bash

XMLNS_H="http://www.w3.org/1999/xhtml" 

# If we set xmlns_h="…", we can omit: --option xmlns_h "$XMLNS_H"
# because XML namespaces can be provided either as an option or as an environmental variable.
# Options have precedence.

findFiles() {
	find -print0;
}

fetchAttributes() {
	relpipe-in-filesystem \
		--parallel 8 \
		--file name \
		--streamlet xpath \
			--option xmlns_h "$XMLNS_H" \
			--option attribute '.' --option mode boolean --as 'valid_xml'  \
			--option attribute 'namespace-uri()'         --as 'root_xmlns' \
			--option attribute '/h:html/h:head/h:title'  --as 'title' \
			--option attribute 'count(//h:h1)'           --as 'h1_count' \
			--option attribute 'count(//h:h2)'           --as 'h2_count' \
			--option attribute 'count(//h:h3)'           --as 'h3_count'
}

filterAndOrder() {
	relpipe-tr-sql \
		--relation "pages" \
			"SELECT
				name,
				title,
				h1_count,
				h2_count,
				h3_count
			FROM filesystem WHERE root_xmlns = ?
			ORDER BY h1_count + h2_count + h3_count DESC
			LIMIT 5" \
			--type-cast 'h1_count' integer \
			--type-cast 'h2_count' integer \
			--type-cast 'h3_count' integer \
			--parameter "$XMLNS_H";
}

findFiles | fetchAttributes | filterAndOrder | relpipe-out-gui -title "Pages and titles"