1  #! /bin/sh
2  
3  cp rotki-assets/databases/v9_global.db rotki_db.db
4  
5  for update in $(jq '.updates | to_entries[] | select(.value.max_schema_version == 9) | .key | tonumber' rotki-assets/updates/info.json); do
6    sed "s/\"/'/g" rotki-assets/updates/$update/* | grep -v "^*$" | sqlite3 rotki_db.db
7  done
8  
9  sqlite3 rotki_db.db "SELECT 'DROP TABLE ' || name || ';' FROM sqlite_master WHERE type = 'table' AND name NOT IN ('evm_tokens', 'common_asset_details');" | xargs -i sqlite3 rotki_db.db "{}"