Add provider function to return a list of all stages and their progress

[mattsse]

Describe the feature

with alloy-rs/alloy#1079 we can now emit an list of stages and their processed blocks

which can be obtained from the

reth/crates/storage/storage-api/src/stage_checkpoint.rs

Lines 5 to 9 in 9e68516

	/// The trait for fetching stage checkpoint related data.
	#[auto_impl::auto_impl(&, Arc)]
	pub trait StageCheckpointReader: Send + Sync {
	/// Fetch the checkpoint for the given stage.
	fn get_stage_checkpoint(&self, id: StageId) -> ProviderResult<Option<StageCheckpoint>>;

we need a new function here that returns a list of all checkpoints in that table:

we need to iterate over this table and decode its keys to string and the checkpoint

reth/crates/storage/provider/src/providers/database/provider.rs

Lines 2507 to 2509 in 9e68516

	fn get_stage_checkpoint(&self, id: StageId) -> ProviderResult<Option<StageCheckpoint>> {
	Ok(self.tx.get::<tables::StageCheckpoints>(id.to_string())?)
	}

TODO

• add get_all_checkpoints function to trait

this can be done via

reth/crates/storage/db-api/src/transaction.rs

Line 22 in 9e68516

fn cursor_read<T: Table>(&self) -> Result<Self::Cursor<T>, DatabaseError>;

and then walk

reth/crates/storage/db-api/src/cursor.rs

Line 40 in 9e68516

fn walk(&mut self, start_key: Option<T::Key>) -> Result<Walker<'_, T, Self>, DatabaseError>

FYI @loocapro

Additional context

No response

[loocapro]

Happy to get it!