coven_database/
file_pins.rs1use crate::sqlite::StoreSql;
8use crate::DbError;
9use coven_foundation::{files::StagedName, id_source::FileId};
10use sqlive::rusqlite::params;
11
12#[derive(Clone, Debug, PartialEq, Eq)]
14pub struct PinRequest {
15 pub id: i64,
18 pub file: FileId,
20 pub copy: Option<StagedName>,
23 pub retry: Option<crate::RetryWait>,
25}
26
27pub(crate) fn request(db: &StoreSql, file: FileId) -> Result<(), DbError> {
29 db.execute(
30 "INSERT INTO _coven_pin_requests(file,copy)
31 SELECT ?1,(SELECT path FROM _coven_device_files WHERE file=?1)
32 ON CONFLICT DO NOTHING",
33 params![file],
34 )?;
35 Ok(())
36}
37
38pub(crate) fn end(db: &StoreSql, file: FileId) -> Result<bool, DbError> {
42 let ended =
43 db.query("DELETE FROM _coven_pin_requests WHERE file=?1 RETURNING copy", [file], |r| {
44 r.get::<_, Option<String>>(0)
45 })?;
46 release(db, ended)
47}
48
49pub(crate) fn end_request(db: &StoreSql, id: i64) -> Result<bool, DbError> {
52 let ended =
53 db.query("DELETE FROM _coven_pin_requests WHERE id=?1 RETURNING copy", [id], |r| {
54 r.get::<_, Option<String>>(0)
55 })?;
56 release(db, ended)
57}
58
59fn release(db: &StoreSql, mut ended: Vec<Option<String>>) -> Result<bool, DbError> {
62 let Some(copy) = ended.pop() else {
63 return Ok(false);
64 };
65 if let Some(copy) = copy {
66 crate::file_queue::release_copy(db, ©)?;
67 }
68 Ok(true)
69}
70
71pub(crate) fn drop_copy(db: &StoreSql, id: i64) -> Result<(), DbError> {
75 let copy = db
76 .query("SELECT copy FROM _coven_pin_requests WHERE id=?1", [id], |r| {
77 r.get::<_, Option<String>>(0)
78 })?
79 .pop()
80 .flatten();
81 let Some(copy) = copy else {
82 return Ok(());
83 };
84 db.execute("UPDATE _coven_pin_requests SET copy=NULL WHERE id=?1", [id])?;
85 crate::file_queue::release_copy(db, ©)
86}
87
88pub(crate) fn read(db: &StoreSql) -> Result<Vec<PinRequest>, DbError> {
90 db.query("SELECT id,file,copy FROM _coven_pin_requests ORDER BY file", [], |r| {
91 Ok((r.get::<_, i64>(0)?, r.get::<_, FileId>(1)?, r.get::<_, Option<String>>(2)?))
92 })?
93 .into_iter()
94 .map(|(id, file, copy)| {
95 Ok(PinRequest {
96 id,
97 file,
98 copy: copy
99 .map(|copy| StagedName::parse(©).ok_or(DbError::DamagedDatabase))
100 .transpose()?,
101 retry: crate::retry::find(db, crate::RetrySubject::Pin(id))?,
102 })
103 })
104 .collect()
105}
106
107#[cfg(test)]
108#[path = "file_pins_tests.rs"]
109pub(crate) mod tests;