feat(indexer): new JRPC method to list substates

[mrnaveira]

Description

• Added new columns template_address, module_name and timestamp to the substates SQLite table.
• Added new column timestamp to the events SQLite table. For now it's populated but not used by any method yet.
• The event_scanner fetches and stores in database the values for all the new fields in substates and events
• New JPRC method list_substates
• Updated TypeScript bindings related with the new indexer method
• Removed old logic for event storing in the event_manager, it's all now done only on the event_scanner and controlled by the event filter in the indexer config

Motivation and Context

On https://github.com/tari-project/tari-dan/pull/1043 we refactored the Indexer to automatically store all substates related to events. This PR follows on that work and adds a new JRPC method list_substates that allows to fetch and filter all the substates stored in the Indexer database. It also adds some metadata (template_address, module_name, timestamp) to substates.

The new method JRPC method list_substates has the following optional parameters:

• filter_by_template: String with the template address of the components that we want to filter
• filter_by_type: String with the only type of substate that we want. Possible vaules are "Component", "Resource", "Vault", "UnclaimedConfidentialOutput", "NonFungible", "TransactionReceipt" and "FeeClaim"
• limit: u64 value for the maximum number of results that we want (intended for pagination)
• offset: u64 with the position of the first result that we want (intended for pagination)

How Has This Been Tested?

Manually by:

• Spawning a local network using tari_swarm
• Performing some transactions to generate events and substates
• Inspecting the Indexer database and also querying the new list_substate method

What process can a PR reviewer use to test or verify this change?

See previous section

Breaking Changes

• [x] None
• [ ] Requires data directory to be deleted
• [ ] Other - Please specify

[github-actions[bot]]

Test Results (CI)

538 tests  +4   538 :white_check_mark: +4   1h 49m 7s :stopwatch: + 6m 47s  64 suites ±0     0 :zzz: ±0    2 files   ±0     0 :x: ±0 

Results for commit c185e76a. ± Comparison against base commit ba41514f.

:recycle: This comment has been updated with latest results.

[sdbondi]

LGTM - looks like a graphQL test is missing the timestamp field or it should be optional