Method put

event-svc/src/store/sql/root.rs:29–44

Store tx_hash, root, and timestamp in roots.

(
        &self,
        tx_hash: &[u8],
        root: &[u8],
        block_hash: String, // 0xhex_hash
        timestamp: i64,
    )

    /// Store tx_hash, root, and timestamp in roots.
    pub async fn put(
        &self,
        tx_hash: &[u8],
        root: &[u8],
        block_hash: String, // 0xhex_hash
        timestamp: i64,
    ) -> Result<()> {
        let _ = sqlx::query(PUT_QUERY)
            .bind(tx_hash)
            .bind(root)
            .bind(block_hash)
            .bind(timestamp)
            .execute(self.pool.writer())
            .await?;
        Ok(())
    }

    /// Get the transaction timestamp from the roots table.
    pub async fn get(&self, tx_hash: &[u8]) -> Result<Option<i64>> {