You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Querying the epoch_param
A query will do a multi table join. In particulare, starting from a stake_registration (pool_update for pools) it will find its tx through stake_registration.tx_id. From the referenced tx it will find its block through tx.block_id. From the block it will find the epoch block.epoch_no. From this it will find the relevant params, epoch_param.epoch_no. From this the related key_deposit (pool_deposit for pools).
Using the genesis, since this value could not change until Conway. This option is only viable if this is released before Conway HF.
The text was updated successfully, but these errors were encountered:
When https://github.com/orgs/IntersectMBO/projects/8/views/5?pane=issue&itemId=55734154 is done, there are 2 new field
stake_registration.deposit
andpool_update.deposit
. When doing an upgrade from an already populated db-sync, these fields will remain NULL. We want to query, that updates all the NULL values.There are 2 ways to do it:
Querying the
epoch_param
A query will do a multi table join. In particulare, starting from a
stake_registration
(pool_update for pools) it will find its tx throughstake_registration.tx_id
. From the referenced tx it will find its block throughtx.block_id
. From the block it will find the epochblock.epoch_no
. From this it will find the relevant params,epoch_param.epoch_no
. From this the relatedkey_deposit
(pool_deposit
for pools).Using the genesis, since this value could not change until Conway. This option is only viable if this is released before Conway HF.
The text was updated successfully, but these errors were encountered: