Bash script to convert mtgjson's AllCards.json into a csv format

mtgjson to csv

# Download the database
wget https://mtgjson.com/json/AllCards.json.zip

# Unzip it
unzip AllCards.json.zip

# Convert to CSV
jq -r 'to_entries[] | [.key, (.value | tostring ) ] | @csv' AllCards.json > AllCards.csv

# Load into postgres
# Note that you'll need need to set the correct login details to the psql command (e.g. change it to `psql -U postgres`)
echo "CREATE TABLE IF NOT EXISTS mtgj(name text, data json); COPY mtgj(name, data) FROM '`pwd`/AllCards.csv' (FORMAT csv)" \
| psql