search

near / near-indexer-for-explorer

Watch NEAR network and store all the data from NEAR blockchain to PostgreSQL database
https://near-indexers.io/docs/projects/near-indexer-for-explorer
GNU General Public License v3.0
123 stars 56 forks source link

Store the info about collided transaction in `transaction_actions` and `account_changes` tables #214

Open telezhnaya opened 2 years ago

telezhnaya commented 2 years ago

Continuing the work on issue #84

Info about related receipts is stored fine, but we miss the info for transaction_actions and account_changes. We have a plan to get rid of transaction_actions #176, so I suggest just to ignore this part. The only reader of account_changes is me 😄 , so this issue is not urgent, but anyway it's better to fix it in one day.

 – 2 entries
 select * from receipts
 where receipts.originated_from_transaction_hash = 'AUh97Kbbg962AfqnQTnmM7tSSy5rnczZ99xXNjAxkctL_issue84_35056813'; 
 – 0 entries
 select * from account_changes
 where account_changes.caused_by_transaction_hash = 'AUh97Kbbg962AfqnQTnmM7tSSy5rnczZ99xXNjAxkctL_issue84_35056813';
 – 0 entries
 select * from transaction_actions
 where transaction_actions.transaction_hash = 'AUh97Kbbg962AfqnQTnmM7tSSy5rnczZ99xXNjAxkctL_issue84_35056813';
khorolets commented 2 years ago

I don't recall who, but I definitely hear from someone except you who looks into that table. I hope they will ping here