3 ms·
The example works on my MacBook if I replace gunzip with funzip. Also, I like to see the value. So: curl -s https://www.ecb.europa.eu/stats/eurofxref/eurof
by gniv 3y ago
The example works on my MacBook if I replace gunzip with funzip. Also, I like to see the value. So:
curl -s https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.zip | funzip | sqlite3 -csv ':memory:' '.import /dev/stdin stdin' "select Date,USD from stdin order by USD asc limit 1;"
- xomodo 3y agoThx. I have extended a bit as a script: # !/bin/bash ARG1=${1:-'select Date from stdin order by USD asc limit 1;'} curl -o - -Ls https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.zip \ | funzip | sqlite3 -csv ':memory:' '.import /dev/stdin stdin' "${ARG1}" # Usage: $ ./run.sh 'select * from stdin limit 1;'