1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94

use data_encoding::HEXLOWER;
use diesel::{prelude::*, Connection};
use tracing::{debug, info_span, span, Level};

#[derive(
    Clone, Debug, Eq, PartialEq, diesel::Queryable, diesel::Selectable, diesel::Insertable,
)]
#[diesel(table_name = crate::schema::sync_progress)]
pub struct SyncProgressTable {
    pub block_slot: i64,
    pub block_hash: Vec<u8>,
    pub processed: bool,
}

impl SyncProgressTable {
    pub fn new(block_slot: u64, block_hash: String) -> Result<SyncProgressTable, anyhow::Error> {
        Ok(SyncProgressTable {
            block_slot: block_slot as i64,
            block_hash: HEXLOWER.decode(block_hash.as_bytes())?,
            processed: false,
        })
    }

    /// Obtain the sync status of the DB
    pub fn get(conn: &mut diesel::PgConnection) -> Result<Option<Self>, diesel::result::Error> {
        use crate::schema::sync_progress::dsl::*;

        let span = info_span!("Get SyncProgress");
        let _entered = span.enter();
        // Get existing entity

        sync_progress
            .filter(processed.eq(true))
            .select(SyncProgressTable::as_select())
            .first(conn)
            .optional()
    }

    /// Save a new entity to the database.
    pub fn store(&self, conn: &mut diesel::PgConnection) -> Result<(), diesel::result::Error> {
        use crate::schema::sync_progress::{self, dsl::*};

        let span = span!(Level::INFO, "Store SyncProgress", ?self.block_slot);
        let _ = span.enter();

        // Find already stored unprocessed block to avoid progressing when the same block event is
        // emitted
        let already_stored = sync_progress
            .filter(processed.eq(false))
            .filter(block_slot.eq(self.block_slot))
            .select(SyncProgressTable::as_select())
            .first(conn)
            .optional()?;

        if already_stored.is_none() {
            conn.transaction::<_, diesel::result::Error, _>(|conn| {
                // Set finished block as processed
                diesel::delete(sync_progress.filter(processed.eq(true))).execute(conn)?;
                diesel::update(sync_progress.filter(processed.eq(false)))
                    .set(processed.eq(true))
                    .execute(conn)?;

                diesel::insert_into(sync_progress::table)
                    .values(self)
                    .execute(conn)?;

                Ok(())
            })?;
            debug!("Stored Sync Progress")
        } else {
            debug!("Duplicate Sync Progress event")
        }

        Ok(())
    }

    pub fn get_or(
        conn: &mut diesel::PgConnection,
        since_slot: Option<u64>,
        since_block: Option<String>,
    ) -> Result<Option<(u64, String)>, anyhow::Error> {
        let sync_status = Self::get(conn)?;

        Ok(sync_status
            .map(
                |Self {
                     block_slot,
                     block_hash,
                     ..
                 }| (block_slot as u64, HEXLOWER.encode(&block_hash)),
            )
            .or(since_slot.zip(since_block)))
    }
}