tlog.rs 93.5%

87 of 93 lines run, 18 of 36 functions · run #474 on main · run missed

//! The transparency log's index (migration 0076): which entry logged which
//! object. The log itself is files (`crate::tlog`).

use super::Pool;
use sqlx::FromRow;

#[derive(Clone, Debug, FromRow)]
pub struct Logged {
    pub idx: i64,
    pub object: String,
    pub kind: String,
    pub repo_id: Option<i64>,
    pub received_ms: i64,
}

/// The entry that logged `object` as `kind`, if one did.
pub async fn entry_of(pool: &Pool, object: &str, kind: &str) -> sqlx::Result<Option<i64>> {
    sqlx::query_scalar("SELECT idx FROM tlog_entries WHERE object = $1 AND kind = $2").bind(object).bind(kind).fetch_optional(pool).await
}

pub async fn record(pool: &Pool, idx: i64, object: &str, kind: &str, repo_id: Option<i64>, received_ms: i64) -> sqlx::Result<()> {
    sqlx::query("INSERT INTO tlog_entries (idx, object, kind, repo_id, received_ms) VALUES ($1, $2, $3, $4, $5) ON CONFLICT DO NOTHING")
        .bind(idx)
        .bind(object)
        .bind(kind)
        .bind(repo_id)
        .bind(received_ms)
        .execute(pool)
        .await?;
    Ok(())
}

/// The newest entries, newest first; of one repository when given.
pub async fn recent(pool: &Pool, repo_id: Option<i64>, limit: i64) -> sqlx::Result<Vec<Logged>> {
    match repo_id {
        Some(r) => {
            sqlx::query_as("SELECT * FROM tlog_entries WHERE repo_id = $1 ORDER BY idx DESC LIMIT $2")
                .bind(r)
                .bind(limit)
                .fetch_all(pool)
                .await
        }
        None => sqlx::query_as("SELECT * FROM tlog_entries ORDER BY idx DESC LIMIT $1").bind(limit).fetch_all(pool).await,
    }
}

/// The last checkpoint this hub cosigned for log `origin`: its size and
/// root (hex).
pub async fn witnessed(pool: &Pool, origin: &str) -> sqlx::Result<Option<(i64, String)>> {
    sqlx::query_as("SELECT size, root FROM tlog_witnessed WHERE origin = $1").bind(origin).fetch_optional(pool).await
}

/// Move what this hub cosigned for `origin` from `old` entries (none when
/// zero) to `size` with `root`; false when another request moved it first.
pub async fn witness_advance(pool: &Pool, origin: &str, old: i64, size: i64, root: &str) -> sqlx::Result<bool> {
    let now = super::now_ms();
    let r = if old == 0 {
        sqlx::query(
            "INSERT INTO tlog_witnessed (origin, size, root, updated_ms) VALUES ($1, $2, $3, $4) \
             ON CONFLICT (origin) DO UPDATE SET size = $2, root = $3, updated_ms = $4 WHERE tlog_witnessed.size = 0",
        )
        .bind(origin)
        .bind(size)
        .bind(root)
        .bind(now)
        .execute(pool)
        .await?
    } else {
        sqlx::query("UPDATE tlog_witnessed SET size = $1, root = $2, updated_ms = $3 WHERE origin = $4 AND size = $5")
            .bind(size)
            .bind(root)
            .bind(now)
            .bind(origin)
            .bind(old)
            .execute(pool)
            .await?
    };
    Ok(r.rows_affected() == 1)
}

/// How far witness `name` has cosigned this hub's log.
pub async fn cosigned_size(pool: &Pool, name: &str) -> sqlx::Result<i64> {
    Ok(sqlx::query_scalar("SELECT size FROM tlog_cosigned WHERE witness = $1").bind(name).fetch_optional(pool).await?.unwrap_or(0))
}

pub async fn set_cosigned(pool: &Pool, name: &str, size: i64) -> sqlx::Result<()> {
    sqlx::query(
        "INSERT INTO tlog_cosigned (witness, size, updated_ms) VALUES ($1, $2, $3) \
         ON CONFLICT (witness) DO UPDATE SET size = $2, updated_ms = $3",
    )
    .bind(name)
    .bind(size)
    .bind(super::now_ms())
    .execute(pool)
    .await?;
    Ok(())
}

/// Keep the cosigned checkpoint of `size` entries, with every cosignature
/// it has gathered so far (#240).
pub async fn keep_cosigned_note(pool: &Pool, size: i64, note: &str) -> sqlx::Result<()> {
    sqlx::query(
        "INSERT INTO tlog_cosigned_notes (size, note, updated_ms) VALUES ($1, $2, $3) \
         ON CONFLICT (size) DO UPDATE SET note = $2, updated_ms = $3",
    )
    .bind(size)
    .bind(note)
    .bind(super::now_ms())
    .execute(pool)
    .await?;
    Ok(())
}

/// The first `n` cosigned checkpoints that hold entry `index`: (size, note).
pub async fn cosigned_notes_after(pool: &Pool, index: i64, n: i64) -> sqlx::Result<Vec<(i64, String)>> {
    sqlx::query_as("SELECT size, note FROM tlog_cosigned_notes WHERE size > $1 ORDER BY size LIMIT $2")
        .bind(index)
        .bind(n)
        .fetch_all(pool)
        .await
}

1		//! The transparency log's index (migration 0076): which entry logged which
2		//! object. The log itself is files (`crate::tlog`).
3
4		use super::Pool;
5		use sqlx::FromRow;
6
7		#[derive(Clone, Debug, FromRow)]
8		pub struct Logged {
9		pub idx: i64,
10		pub object: String,
11		pub kind: String,
12		pub repo_id: Option<i64>,
13		pub received_ms: i64,
14		}
15
16		/// The entry that logged `object` as `kind`, if one did.
17	385×	pub async fn entry_of(pool: &Pool, object: &str, kind: &str) -> sqlx::Result<Option<i64>> {
18	385×	sqlx::query_scalar("SELECT idx FROM tlog_entries WHERE object = $1 AND kind = $2").bind(object).bind(kind).fetch_optional(pool).await
19	385×	}
20
21	195×	pub async fn record(pool: &Pool, idx: i64, object: &str, kind: &str, repo_id: Option<i64>, received_ms: i64) -> sqlx::Result<()> {
22	195×	sqlx::query("INSERT INTO tlog_entries (idx, object, kind, repo_id, received_ms) VALUES ($1, $2, $3, $4, $5) ON CONFLICT DO NOTHING")
23	195×	.bind(idx)
24	195×	.bind(object)
25	195×	.bind(kind)
26	195×	.bind(repo_id)
27	195×	.bind(received_ms)
28	195×	.execute(pool)
29	195×	.await?;
30	195×	Ok(())
31	195×	}
32
33		/// The newest entries, newest first; of one repository when given.
34	1×	pub async fn recent(pool: &Pool, repo_id: Option<i64>, limit: i64) -> sqlx::Result<Vec<Logged>> {
35	1×	match repo_id {
36	0×	Some(r) => {
37	0×	sqlx::query_as("SELECT * FROM tlog_entries WHERE repo_id = $1 ORDER BY idx DESC LIMIT $2")
38	0×	.bind(r)
39	0×	.bind(limit)
40	0×	.fetch_all(pool)
41	0×	.await
42		}
43	1×	None => sqlx::query_as("SELECT * FROM tlog_entries ORDER BY idx DESC LIMIT $1").bind(limit).fetch_all(pool).await,
44		}
45	1×	}
46
47		/// The last checkpoint this hub cosigned for log `origin`: its size and
48		/// root (hex).
49	4×	pub async fn witnessed(pool: &Pool, origin: &str) -> sqlx::Result<Option<(i64, String)>> {
50	4×	sqlx::query_as("SELECT size, root FROM tlog_witnessed WHERE origin = $1").bind(origin).fetch_optional(pool).await
51	4×	}
52
53		/// Move what this hub cosigned for `origin` from `old` entries (none when
54		/// zero) to `size` with `root`; false when another request moved it first.
55	2×	pub async fn witness_advance(pool: &Pool, origin: &str, old: i64, size: i64, root: &str) -> sqlx::Result<bool> {
56	2×	let now = super::now_ms();
57	2×	let r = if old == 0 {
58	1×	sqlx::query(
59	1×	"INSERT INTO tlog_witnessed (origin, size, root, updated_ms) VALUES ($1, $2, $3, $4) \
60	1×	ON CONFLICT (origin) DO UPDATE SET size = $2, root = $3, updated_ms = $4 WHERE tlog_witnessed.size = 0",
61	1×	)
62	1×	.bind(origin)
63	1×	.bind(size)
64	1×	.bind(root)
65	1×	.bind(now)
66	1×	.execute(pool)
67	1×	.await?
68		} else {
69	1×	sqlx::query("UPDATE tlog_witnessed SET size = $1, root = $2, updated_ms = $3 WHERE origin = $4 AND size = $5")
70	1×	.bind(size)
71	1×	.bind(root)
72	1×	.bind(now)
73	1×	.bind(origin)
74	1×	.bind(old)
75	1×	.execute(pool)
76	1×	.await?
77		};
78	2×	Ok(r.rows_affected() == 1)
79	2×	}
80
81		/// How far witness `name` has cosigned this hub's log.
82	2×	pub async fn cosigned_size(pool: &Pool, name: &str) -> sqlx::Result<i64> {
83	2×	Ok(sqlx::query_scalar("SELECT size FROM tlog_cosigned WHERE witness = $1").bind(name).fetch_optional(pool).await?.unwrap_or(0))
84	2×	}
85
86	2×	pub async fn set_cosigned(pool: &Pool, name: &str, size: i64) -> sqlx::Result<()> {
87	2×	sqlx::query(
88	2×	"INSERT INTO tlog_cosigned (witness, size, updated_ms) VALUES ($1, $2, $3) \
89	2×	ON CONFLICT (witness) DO UPDATE SET size = $2, updated_ms = $3",
90	2×	)
91	2×	.bind(name)
92	2×	.bind(size)
93	2×	.bind(super::now_ms())
94	2×	.execute(pool)
95	2×	.await?;
96	2×	Ok(())
97	2×	}
98
99		/// Keep the cosigned checkpoint of `size` entries, with every cosignature
100		/// it has gathered so far (#240).
101	2×	pub async fn keep_cosigned_note(pool: &Pool, size: i64, note: &str) -> sqlx::Result<()> {
102	2×	sqlx::query(
103	2×	"INSERT INTO tlog_cosigned_notes (size, note, updated_ms) VALUES ($1, $2, $3) \
104	2×	ON CONFLICT (size) DO UPDATE SET note = $2, updated_ms = $3",
105	2×	)
106	2×	.bind(size)
107	2×	.bind(note)
108	2×	.bind(super::now_ms())
109	2×	.execute(pool)
110	2×	.await?;
111	2×	Ok(())
112	2×	}
113
114		/// The first `n` cosigned checkpoints that hold entry `index`: (size, note).
115	25×	pub async fn cosigned_notes_after(pool: &Pool, index: i64, n: i64) -> sqlx::Result<Vec<(i64, String)>> {
116	25×	sqlx::query_as("SELECT size, note FROM tlog_cosigned_notes WHERE size > $1 ORDER BY size LIMIT $2")
117	25×	.bind(index)
118	25×	.bind(n)
119	25×	.fetch_all(pool)
120	25×	.await
121	25×	}

`/`	Search
`g` `c`	Code
`g` `h`	History
`g` `b`	Bookmarks
`g` `t`	Trust
`y`	Permalink to this state (files and trees)
`?`	This sheet

Coverage / crates/hub/src/db/tlog.rs 93.5%

Keyboard