indexer1 0.2.19

A library that is used to collect events from EVM compatible blockchain
Documentation 
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

use alloy::rpc::types::{Filter, Log};
use anyhow::bail;
use sqlx::{Pool, Row, Sqlite};

use crate::indexer1::{filter_id, Processor};

use super::LogStorage;

impl LogStorage for Pool<Sqlite> {
    type Transaction = sqlx::Transaction<'static, Sqlite>;

    async fn insert_logs<P: Processor<Self::Transaction>>(
        &self,
        chain_id: u64,
        logs: &[Log],
        filter_id: &str,
        prev_saved_block: u64,
        new_saved_block: u64,
        log_processor: &mut P,
    ) -> anyhow::Result<()> {
        let mut transaction = self.begin().await?;

        let prev_saved_block = prev_saved_block - 1;

        let rows = sqlx::query(include_str!("sql/update_filter.sql"))
            .bind::<i64>(new_saved_block.try_into()?)
            .bind::<i64>(prev_saved_block.try_into()?)
            .bind(filter_id)
            .execute(&mut *transaction)
            .await?;
        if rows.rows_affected() != 1 {
            bail!(
                "Inconsistency in block commitement prev block {}, new block {}",
                prev_saved_block,
                new_saved_block
            );
        }

        log_processor
            .process(
                logs,
                &mut transaction,
                prev_saved_block,
                new_saved_block,
                chain_id,
            )
            .await?;

        transaction.commit().await.map_err(Into::into)
    }

    async fn get_or_create_filter(
        &self,
        filter: &Filter,
        chain_id: u64,
    ) -> anyhow::Result<(u64, String)> {
        sqlx::query(include_str!("sql/create_filter.sql"))
            .execute(self)
            .await?;

        let filter_id = filter_id(filter, chain_id);
        let last_observed_block = sqlx::query(include_str!("sql/get_filter.sql"))
            .bind(&filter_id)
            .fetch_optional(self)
            .await?
            .map(|row| {
                row.get::<i64, _>(0)
                    .try_into()
                    .map(|v| (v, filter_id.clone()))
            })
            .transpose()?;
        match last_observed_block {
            Some((block, filter_id)) => Ok((block, filter_id)),
            None => sqlx::query(include_str!("sql/insert_filter.sql"))
                .bind(&filter_id)
                .bind::<i64>(filter.get_from_block().unwrap_or(1).try_into()?)
                .bind(serde_json::to_value(filter)?)
                .execute(self)
                .await
                .map_err(Into::into)
                .map(|_| (filter.get_from_block().unwrap_or(1), filter_id)),
        }
    }
}