tx_indexer/database/diesel/
sync_progress.rs

1use data_encoding::HEXLOWER;
2use diesel::{prelude::*, Connection};
3use tracing::{debug, info_span, span, Level};
4
5#[derive(
6    Clone, Debug, Eq, PartialEq, diesel::Queryable, diesel::Selectable, diesel::Insertable,
7)]
8#[diesel(table_name = crate::schema::sync_progress)]
9pub struct SyncProgressTable {
10    pub block_slot: i64,
11    pub block_hash: Vec<u8>,
12    pub processed: bool,
13}
14
15impl SyncProgressTable {
16    pub fn new(block_slot: u64, block_hash: String) -> Result<SyncProgressTable, anyhow::Error> {
17        Ok(SyncProgressTable {
18            block_slot: block_slot as i64,
19            block_hash: HEXLOWER.decode(block_hash.as_bytes())?,
20            processed: false,
21        })
22    }
23
24    /// Obtain the sync status of the DB
25    pub fn get(conn: &mut diesel::PgConnection) -> Result<Option<Self>, diesel::result::Error> {
26        use crate::schema::sync_progress::dsl::*;
27
28        let span = info_span!("Get SyncProgress");
29        let _entered = span.enter();
30        // Get existing entity
31
32        sync_progress
33            .filter(processed.eq(true))
34            .select(SyncProgressTable::as_select())
35            .first(conn)
36            .optional()
37    }
38
39    /// Save a new entity to the database.
40    pub fn store(&self, conn: &mut diesel::PgConnection) -> Result<(), diesel::result::Error> {
41        use crate::schema::sync_progress::{self, dsl::*};
42
43        let span = span!(Level::INFO, "Store SyncProgress", ?self.block_slot);
44        let _ = span.enter();
45
46        // Find already stored unprocessed block to avoid progressing when the same block event is
47        // emitted
48        let already_stored = sync_progress
49            .filter(processed.eq(false))
50            .filter(block_slot.eq(self.block_slot))
51            .select(SyncProgressTable::as_select())
52            .first(conn)
53            .optional()?;
54
55        if already_stored.is_none() {
56            conn.transaction::<_, diesel::result::Error, _>(|conn| {
57                // Set finished block as processed
58                diesel::delete(sync_progress.filter(processed.eq(true))).execute(conn)?;
59                diesel::update(sync_progress.filter(processed.eq(false)))
60                    .set(processed.eq(true))
61                    .execute(conn)?;
62
63                diesel::insert_into(sync_progress::table)
64                    .values(self)
65                    .execute(conn)?;
66
67                Ok(())
68            })?;
69            debug!("Stored Sync Progress")
70        } else {
71            debug!("Duplicate Sync Progress event")
72        }
73
74        Ok(())
75    }
76
77    pub fn get_or(
78        conn: &mut diesel::PgConnection,
79        since_slot: Option<u64>,
80        since_block: Option<String>,
81    ) -> Result<Option<(u64, String)>, anyhow::Error> {
82        let sync_status = Self::get(conn)?;
83
84        Ok(sync_status
85            .map(
86                |Self {
87                     block_slot,
88                     block_hash,
89                     ..
90                 }| (block_slot as u64, HEXLOWER.encode(&block_hash)),
91            )
92            .or(since_slot.zip(since_block)))
93    }
94}
tx_indexer/database/diesel/sync_progress.rs

tx_indexer/database/diesel/
sync_progress.rs
