holochain_sqlite 0.7.0-dev.17

Abstractions for persistence of Holochain state via SQLite
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

//! nonce sql logic
use crate::prelude::*;
use crate::sql::sql_conductor;
use holo_hash::AgentPubKey;
use holochain_nonce::Nonce256Bits;
use holochain_zome_types::prelude::Timestamp;
use rusqlite::*;

pub fn nonce_already_seen(
    txn: &Transaction<'_>,
    agent: &AgentPubKey,
    nonce: Nonce256Bits,
    now: Timestamp,
) -> DatabaseResult<bool> {
    let mut statement = txn
        .prepare(sql_conductor::SELECT_NONCE)
        .map_err(|e| rusqlite::Error::ToSqlConversionFailure(e.into()))?;

    Ok(statement
        .query_row(
            named_params! {":agent": agent, ":nonce": nonce.into_inner(), ":now": now },
            |row| Ok(row.get_ref(0)?.as_i64()?),
        )
        .optional()?
        .is_some())
}