#!/bin/bash

URL="https://relational-pipes.globalcode.info/v_0/implementation.xhtml";

# or we can use wget, if curl is missing or we like wget more:

# curl() { wget -O - "$1"; }

curl "$URL" \

	| relpipe-in-xmltable \

		--namespace "h" "http://www.w3.org/1999/xhtml" \

		--relation "implementation" \

			--records "//h:table[1]/h:tbody/h:tr" \

			--attribute "name"     string "h:td[1]" \

			--attribute "type"     string "h:td[2]" \

			--attribute "subtype"  string "h:td[3]" \

	| relpipe-tr-sql \

		--relation \

			"relpipe_commands" \

			"SELECT

				subtype AS type,

				count(*) AS count

			FROM implementation

			WHERE type = 'executable'

			GROUP BY type, subtype

			ORDER BY count DESC" \

	| relpipe-out-tabular