Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899use crate::db::{DatabaseBackend, adapt_sql};use crate::error::AppError;use crate::spaces::types::{OplogAction, OplogEntry};
pub async fn append_op( pool: &sqlx::AnyPool, backend: DatabaseBackend, entry: &OplogEntry,) -> Result<(), AppError> { let sql = adapt_sql( "INSERT INTO happyview_space_record_oplog (id, space_id, author_did, rev, idx, action, collection, rkey, cid, prev, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", backend, ); sqlx::query(&sql) .bind(&entry.id) .bind(&entry.space_id) .bind(&entry.author_did) .bind(&entry.rev) .bind(entry.idx) .bind(entry.action.as_str()) .bind(&entry.collection) .bind(&entry.rkey) .bind(&entry.cid) .bind(&entry.prev) .bind(&entry.created_at) .execute(pool) .await .map_err(|e| AppError::Internal(format!("failed to append oplog entry: {e}")))?; Ok(())}
pub async fn list_ops( pool: &sqlx::AnyPool, backend: DatabaseBackend, space_id: &str, author_did: &str, since_rev: Option<&str>, limit: i64,) -> Result<Vec<OplogEntry>, AppError> { let sql = if since_rev.is_some() { adapt_sql( "SELECT id, space_id, author_did, rev, idx, action, collection, rkey, cid, prev, created_at FROM happyview_space_record_oplog WHERE space_id = ? AND author_did = ? AND rev > ? ORDER BY rev, idx LIMIT ?", backend, ) } else { adapt_sql( "SELECT id, space_id, author_did, rev, idx, action, collection, rkey, cid, prev, created_at FROM happyview_space_record_oplog WHERE space_id = ? AND author_did = ? ORDER BY rev, idx LIMIT ?", backend, ) };
type OplogRow = ( String, String, String, String, i32, String, String, String, Option<String>, Option<String>, String, );
let mut query = sqlx::query_as::<_, OplogRow>(&sql) .bind(space_id) .bind(author_did); if let Some(rev) = since_rev { query = query.bind(rev); } query = query.bind(limit);
let rows = query .fetch_all(pool) .await .map_err(|e| AppError::Internal(format!("failed to list oplog entries: {e}")))?;
rows.into_iter() .map(|r| { let action = OplogAction::parse(&r.5) .ok_or_else(|| AppError::Internal(format!("invalid oplog action: {}", r.5)))?; Ok(OplogEntry { id: r.0, space_id: r.1, author_did: r.2, rev: r.3, idx: r.4, action, collection: r.6, rkey: r.7, cid: r.8, prev: r.9, created_at: r.10, }) }) .collect()}