pub async fn reset_mempool_status(&mut self, transaction_hashes: &[H256]) -> DalResult<()> {
        // Convert H256 hashes into `&[u8]`
        let hashes: Vec<_> = transaction_hashes.iter().map(H256::as_bytes).collect();

        // Execute the UPDATE query
        let result = sqlx::query!(
            r#"
            UPDATE transactions
            SET
                in_mempool = FALSE
            WHERE
                hash = ANY($1)
            "#,
            &hashes as &[&[u8]]
        )
        .instrument("reset_mempool_status")
        .with_arg("transaction_hashes.len", &hashes.len())
        .execute(self.storage)
        .await?;

        // Log debug information about how many rows were affected
        tracing::debug!(
            "Updated {} transactions to in_mempool = false; provided hashes: {transaction_hashes:?}",
            result.rows_affected()
        );

        Ok(())
    }
Resets `in_mempool` to `FALSE` for the given transaction hashes.
core/lib/dal/src/transactions_dal.rs