#4977 Get the latest english-only realses's URL

[Szépe Viktor]

Up to now it was possible to parse SF's RSS feed and get the latest english ZIP.
Could you please advise how to get that URL now?

[Szépe Viktor]

wget -qO- "https://www.phpmyadmin.net/downloads/"|grep -m1 -o 'href="https://files.phpmyadmin.net/phpMyAdmin/.*/phpMyAdmin-.*-english.tar.xz"'|cut -d'"' -f2

It is not the most beautiful piece of code.

[Michal Čihař]

There is https://www.phpmyadmin.net/files/feed/

Or if you are looking just for version number, you can use same backend as phpMyAdmin uses: https://www.phpmyadmin.net/home_page/version.json

[Szépe Viktor]

Thank you Michal!

I am sorry to report that https://www.phpmyadmin.net/files/feed/ contains no URL-s.
One would end up parsing a HTML page again: https://www.phpmyadmin.net/files/*/

As for the JSON file: Do you mean that https://files.phpmyadmin.net/phpMyAdmin/${VERSION}/phpMyAdmin-${VERSION}-english.tar.xz will be available in every upcoming release?

[Szépe Viktor]

Based on the JSON file this is my current shell solution:

https://github.com/szepeviktor/debian-server-tools/blob/master/package/phpmyadmin-get.sh#L20-L25

[Michal Čihař]

I can add the file URLs as well, are you aware of some standard way to do that?

For shell parsing, the .txt format is probably better than JSON: https://www.phpmyadmin.net/home_page/version.txt

[Michal Čihař]

Ah, and we have DOAP and PAD files as well, which might actually suit even better your purpose:

https://www.phpmyadmin.net/home_page/phpmyadmin-doap.xml

https://www.phpmyadmin.net/home_page/phpmyadmin.xml

Overview of all machine readable files is at https://www.phpmyadmin.net/about-website/

[Szépe Viktor]

My second choice is the GitHub API in JSON also. But it contains no English-only release file.
https://api.github.com/repos/phpmyadmin/phpmyadmin/tags

Thank you very much for the text version.
Would it be possible to list all release files in it? E.g. the English-only one.

[Michal Čihař]

We can not add other files there as it's consumed by script which does not handle anything else than this one. But I think DOAP is probably best, it has everything you need.

[Szépe Viktor]

Thank you.
Only the namespace should be altered, then:

sed '0,/xmlns=/s//xmlns:doap=/' phpmyadmin-doap.xml \
| xmlstarlet sel -t -v '(/Project/release/Version/file-release[contains(@rdf:resource,"-english.tar.xz")]/@rdf:resource)[1]'

[Szépe Viktor]

Or

sed -n '0,/^.*<file-release rdf:resource="\(\S\+-english.zip\)" \/>.*$/s//\1/p' phpmyadmin-doap.xml