rotki commits by prettyirrelevant (both stints)

rotki-commits.md

Rotki Commits by prettyirrelevant

1st Stint (Apr 2022 - Apr 2023)

1. decode curve deposits & withdrawals via curve zap deposit contracts
2. reset last_avatar_update column when avatars cache is cleared. The last_avatar_update column is no longer nullable.
3. feat: add cache invalidation for icons & avatars
4. add endpoint to get all evm chains
5. fix failed tests from bugfixes
6. change binance savings & kraken staking api response
7. add proxies to liquity staking & stability pool api responses
8. add support for filtering assets page using evm chain & address
9. fix uniswap v2 swap decoding edge case where an event can appear between a trade
10. fix compound failing tests
11. mock coingecko api responses for failing prices tests
12. feat: remotely update default rpc nodes
13. feat: add endpoint for binance savings & PnL calculation
14. feat: add decoder support for sai cdp migration
15. fix bug with pagination when ignored trades are filtered
16. fix: adjust websocket test to avoid failure in macos
17. refactor get_ignored_actions_id to return set instead of a list
18. Add support for including/excluding ignored trades in api response
19. add tests to verify pruned nodes are handled in queries properly
20. properly handle pruned nodes in queries and refactor methods typing
21. fix cassette directory path for mac
22. new endpoint to manually add evm transaction hash & relevant address
23. fix history debug import
24. address pr comments & refactor decoding interface
25. fix failing tests
26. update accountant module for sushiswap & uniswap
27. feat: add decoders for sushiswap liquidity addition and removal
28. feat: add decoder for uniswap v2 liquidity addition & removal
29. feat: add decoder support for uniswap v3 liquidity addition & removal
30. fix: adjust makerdao sai decoder test to not make network calls
31. add decoder for makerdao single collateral dai contracts
32. add missing changelog entry
33. remove unneeded geventwebsocket request upgrade debug logs
34. properly decode amm transactions with aggregators
35. use zero fval constant
36. feat: manage oracles order in runtime to penalize misbehaving ones
37. addressed more comments
38. address pr comments
39. add support for adjusted cost base method
40. add support for HIFO cost basis
41. fix test_yearn_vaults()
42. address pr comments
43. fallback to packaged global db when resolving constant assets
44. feat: enable ignoring of spam nfts
45. fix bug with weth decoder
46. Update docs to include note taking (#5011) - add usage guide for note taking, updated assets section of usage guide
47. add decoder for weth contract
48. assets mappings endpoint now skips invalid identifer(s)
49. fix: change price cache invalidation logic for manual prices
50. fix: latest usd prices are now returned for manual prices
51. add underlying tokens for evm tokens to assets/all endpoint
52. fix bug with invalidating price cache when manual prices are deleted
53. add custom_asset flags to assets search responses
54. fix bug when inquirer.find_usd_price() encounters non ethereum evm token
55. add custom_asset_type to assets mappings response
56. fix bug with sorting by custom_asset_type for custom_assets
57. remove threshold from levenshtein search
58. add is_custom_asset field to assets mapping response
59. improve get all assets endpoint filter by name/symbol
60. add filtering by chain for assets search & include chain in assets mapping
61. fix bug where ethereum was missing in asset search
62. feat: add support for custom assets
63. rename all occurences of *_custom_asset to *_user_asset
64. refactor old assets classes usage in the codebase
65. refactor asset classes
66. levenshtein searches return results that contain the search keyword
67. get all assets endpoint now returns list of dicts as response
68. handle search with assets not having name/symbol & treating eth2 as eth
69. support returning exact matches in assets search endpoint
70. add filtering by ignored & user owned assets to assets manager api
71. update docs for new asset manager api
72. paginated api for assets manager, api for asset autocomplete & mapping
73. fix minor typo in en.json
74. remove custom date format switch from custom import
75. decimals now defaults to 18 on query failure
76. update ignored assets to caip format
77. add collection name as fallback name for nft balances
78. allow mass deletion of trades & ledger actions
79. feat: add docs guide for generic csv import
80. use unix timestamp for generic trades
81. feat: add support for taproot btc addresses
82. feat: derive new addresses from xpubs when balances are refreshed
83. feat: enable generic data import for rotki
84. fix typo in data import components
85. feat: add sushiswap & balancer balances to snapshots
86. feat: add uniswap v2 lps balances to snapshot
87. show assets for non premium users
88. add uniswap v3 balances to nft balances
89. feat: added per user notes
90. enable sqlite vm instructions config in docker
91. refactor DBAssetBalance and maintain usd_value desc order
92. enable value distribution by asset respect eth=eth2 setting
93. update nexo importer to support new export format
94. update docs for bch & eth address book
95. add export pnl debug data guide
96. fix bugs with bch
97. chore: accept cashaddr format without the prefix for BCH
98. re enable transaction filtering in frontend
99. improve bytes event_identifier logic & improved tests

2nd Stint (Oct 2024 - Mar 2026)

1. add support for stkgho
2. suppress PermissionError in accounting rules download on Windows
3. send WS notification when no indexers are available for a chain
4. relax upload timestamp tolerance to fix flaky test on windows CI
5. handle os.replace PermissionError on Windows in accounting rules fixture
6. extend spam token marking to support solana tokens and improve _validate_address_with_blockchain for solana
7. preserve all transaction events when any event is customized
8. Allow ignoring false positives in customized event duplicate detection
9. repackage globaldb for v1.42
10. add monerium decoder support for Base chain
11. Fix matched history group pagination duplication
12. Include linked events when filtering by MATCHED
13. include exchange adjustment events in matched group sublist
14. Reset decoded evm and solana events in v50->v51 upgrade
15. Fix NOT NULL constraint error when deleting custom NFT price
16. Fix exchange adjustment subtype direction
17. repull all staking events when no filter is given and return new event count
18. Avoid auto-matching exchange movements to protocol events
19. restore matched events when purging exchange data
20. Add endpoint to refetch ETH staking events
21. add endpoint to enable/disable periodic tasks scheduler
22. Fix more false positives in customized event duplicate detection
23. Replace history events boolean filter flags with state_markers list
24. add tests to verify csv imported events have imported_from_csv marker
25. exclude gas events from duplicate detection unless customized
26. handle empty gasPrice in transactions and improve skipped transaction warnings
27. extract HistoryEventFilterSchema and simplify deletion with bulk delete
28. remove periodic background task for historical balance processing
29. Remove periodic task for asset movement matching
30. fix missing l1 fee for l2 chains
31. Add auto_create_profit_events setting and virtual_events_only filter
32. normalize balancer pool weights and allow empty asset symbols on import
33. Prevent duplicate events when customized onchain events are redecoded
34. Add multicall retry logic with gas error handling
35. Add script to find spam assets from global database
36. Track historical balances under swapped_for asset for token upgrades
37. fix flaky test_skip_if_running on macos
38. serialize location in negative balance message
39. add missing bucket field to negative balance ws notification
40. Use asset protocol bucket for protocol tokens in dual bucket events
41. Fix KeyError when processing protocol withdrawal without prior deposit
42. Fix suppress_missing_key_msg_services being reset when updating other settings
43. Create synthetic interest event when protocol withdrawal exceeds deposit
44. Add dual-bucket balance tracking for wrapped protocol assets
45. exclude EIP-7702 delegated accounts from Contract tag
46. add is_archive field to rpc nodes endpoint response
47. Add historical on-chain balance query endpoint via archive nodes
48. skip zero amounts in get_balances
49. Add DB upgrade for deposit/withdrawal subtype migration
50. fix: convert FVal to int for SQL bindings in historical balance filter
51. Allow transaction repulling for all chains when none specified
52. Migrate DeFi protocol deposits to DEPOSIT_TO_PROTOCOL/WITHDRAW_FROM_PROTOCOL
53. Include Solana in periodic transaction decoding task
54. Fix BlockchainField allow_only parameter not working
55. fix: use counterparty identifiers for protocol cache updates
56. Add location filter to historical balance endpoints
57. upgrade to velodrome/aerodrome sugar v3 contracts
58. fix possible race condition in skip_if_running
59. fix: improve historical balance tracking for skipped and neutral events
60. handle concurrent event modifications during balance processing
61. update alchemy api url to new endpoint format
62. Add support to retrieve historical net value as daily asset balances
63. perf: remove price queries from historical balance endpoints
64. Fix crash in get_prices_for_swap when fiat price query fails
65. ux and performance(using polars) improvements
66. use event_metrics table for get_asset_balance and get_assets_amounts
67. add reserved Contract tag for smart contract addresses
68. add periodic task for processing historical balances
69. add table for historical balance processing
70. Track earliest modified event timestamp for balance cache invalidation
71. Fix coverage artifact upload in nightly workflow
72. Fix optional fields handling in calendar API
73. Purge eth validators data cache in db migration
74. allow purging of eth validator data cache
75. Fix double-counting of rewards for exiting accumulating validators
76. improve levenshtein search when searching for fiat assets
77. fix thegraph staked balances
78. update thegraph decoder for horizon migration on arbitrum
79. Add support for Binance Convert trades via convert/tradeFlow endpoint
80. include nfts info in /assets/mappings for colibri
81. mass rename Inquirer.find_price(s) to Inquirer.find_main_currency_price(s)
82. migrate /nfts endpoint from price_usd -> price
83. fix: map frontend 'price' to db 'usd_price' column for NFT sorting
84. correct entries_total calculation for paginated report data queries
85. finish usd_value -> value migration
86. migrate nfts from usd_value to value
87. migrate blockchain balances from usd_value to value
88. migrate liquity stats, binance savings & kraken staking from usd_value to value
89. Inquirer._get_special_usd_prices now handles non-USD target currencies
90. remove liquity todo and fix changelog
91. decode yearn staking via zap
92. return queried events from Coinbase query_online_history_events
93. handle non-ERC20 conformant legacy beefy boosts
94. improve stakedao withdrawal decoding
95. handle beefy vaults with native underlying tokens
96. add support for Coinbase ED25519 API key format
97. migrate sushiswap and uniswap v2 balances to use value instead of usd_value
98. migrate liquity trove from usd_value -> value
99. migrate exchanges from usd_value to value
100. migrate /balances/manual to use value instead of usd_value
101. add balances and accountant for aura finance
102. prevent downstream jobs from running if typos check fails
103. fix: prevent false subscription expiry alerts on poor network
104. fix vcr
105. add aura finance decoders
106. refresh liquity icon
107. refresh cowswap icon
108. added balancer v2 accountant
109. add balancer v2 lp events and balances for supported evm chains
110. add balancer v1 decoder & lp balances for supported evm chains
111. add spellchecker
112. fix starknet price before 09/05/24
113. fix bug with creating bridging calendar reminder
114. add protocol balances for umami finance
115. improve scroll airdrop decoder
116. add calendar reminder for l2 bridging
117. decode superchain (op & base) bridge transactions