relpipe-data/examples/atom-xmltable.sh
author František Kučera <franta-hg@frantovo.cz>
Sat, 12 Sep 2020 13:20:21 +0200
branchv_0
changeset 315 d4c2968a391f
parent 263 8bf13358a50a
permissions -rwxr-xr-x
roadmap: relpipe-tr-sql already uses ODBC

#!/bin/bash

get_atom() {
	wget --quiet --output-document - https://blog.frantovo.cz/agregace/c/?p=10
	# wget --quiet --output-document - https://blog.frantovo.cz/agregace/k/
	# cat atom.xml
}

get_atom \
	| relpipe-in-xmltable \
		--namespace "a" "http://www.w3.org/2005/Atom" \
		--relation "/a:feed/a:title" --name-is-xpath \
			--records "//a:entry" \
			--attribute "published" string "a:published" \
			--attribute "title" string "a:title" \
			--attribute "url" string "a:link/@href" \
		--relation "metadata" \
			--records "." \
			--attribute "id" string "a:id" \
			--attribute "subtitle" string "a:subtitle" \
	| relpipe-out-tabular