The following macros are intended to be used to create and maintain various models. These macros can be accessed via version >=v1.0.0 of the fsc-evm package. Please see the fsc-evm installation instructions in the README for more details on how to access and utilize this macro effectively.

Usage of these macros automates the process of re-requesting data from the nodes, and are typically referenced in Streamline Requests models. Please verify usage prior to implementing.

---

retry_missing_txs

Usage

This macro identifies missing transactions by comparing the current transaction positions within a block. It retrieves block numbers where the difference between the current and previous transaction positions is not equal to one, indicating missing transactions.

fsc_evm.retry_missing_txs

Parameters

Note: Parameters with default values must be ordered after non-default parameters.

This macro does not have any parameters.

Example:

{{ fsc_evm.retry_missing_txs() }}

retry_missing_receipts

Usage

This macro finds block numbers with missing receipts by performing a left join between transactions and receipts. It selects distinct block numbers where the transaction hash in the receipts is null, indicating that the receipt for the transaction is missing.

fsc_evm.retry_missing_receipts

Parameters

Note: Parameters with default values must be ordered after non-default parameters.

This macro does not have any parameters.

Example:

{{ fsc_evm.retry_missing_receipts() }}

retry_missing_traces

Usage

This macro identifies block numbers with missing traces by joining transactions with traces. It selects distinct block numbers where the transaction hash in the traces is null, indicating that the trace for the transaction is missing.

fsc_evm.retry_missing_traces

Parameters

Note: Parameters with default values must be ordered after non-default parameters.

This macro does not have any parameters.

Example:

{{ fsc_evm.retry_missing_traces() }}

retry_unconfirmed_blocks

Usage

This macro retrieves block numbers that are unconfirmed by checking for missing transactions in confirmed blocks. It selects distinct block numbers where the transaction hash is null, indicating that the block has not been confirmed due to missing transactions.

fsc_evm.retry_unconfirmed_blocks

Parameters

Note: Parameters with default values must be ordered after non-default parameters.

This macro does not have any parameters.

Example:

{{ fsc_evm.retry_unconfirmed_blocks() }}