aven-core 0.1.32

Core library for the Aven local-first task manager
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112

use std::collections::{BTreeSet, HashMap};

use anyhow::{Result, bail};
use sqlx::{Row, SqliteConnection};

use crate::ids::{TaskId, WorkspaceId};
use crate::recurrence::RecurrenceSeriesId;

use super::fields::normalize_metadata_key;
use super::{
    MAX_METADATA_TOTAL_BYTES, MAX_METADATA_VALUE_BYTES, MAX_METADATA_VALUES, TaskMetadataInput,
};

pub(crate) fn validate_metadata_update(set: &[TaskMetadataInput], remove: &[String]) -> Result<()> {
    if set.len() > MAX_METADATA_VALUES {
        bail!("error too-many-metadata-values limit={MAX_METADATA_VALUES}");
    }
    let mut keys = BTreeSet::new();
    let mut total_bytes = 0usize;
    for input in set {
        let key = normalize_metadata_key(&input.key)?;
        if !keys.insert(key) {
            bail!("error duplicate-metadata-key");
        }
        if input.value.len() > MAX_METADATA_VALUE_BYTES {
            bail!("error metadata-value-too-large limit={MAX_METADATA_VALUE_BYTES}");
        }
        total_bytes = total_bytes.saturating_add(input.value.len());
    }
    if total_bytes > MAX_METADATA_TOTAL_BYTES {
        bail!("error metadata-values-too-large limit={MAX_METADATA_TOTAL_BYTES}");
    }
    for input in remove {
        let key = normalize_metadata_key(input)?;
        if !keys.insert(key) {
            bail!("error overlapping-metadata-key");
        }
    }
    Ok(())
}

pub(super) fn validate_metadata_result_limits(
    existing: impl IntoIterator<Item = (String, String)>,
    set: &[TaskMetadataInput],
    remove: &[String],
) -> Result<()> {
    let mut values = existing.into_iter().collect::<HashMap<_, _>>();
    for key in remove {
        values.remove(&normalize_metadata_key(key)?);
    }
    for input in set {
        values.insert(normalize_metadata_key(&input.key)?, input.value.clone());
    }
    if values.len() > MAX_METADATA_VALUES {
        bail!("error too-many-metadata-values limit={MAX_METADATA_VALUES}");
    }
    let total_bytes = values.values().map(String::len).sum::<usize>();
    if total_bytes > MAX_METADATA_TOTAL_BYTES {
        bail!("error metadata-values-too-large limit={MAX_METADATA_TOTAL_BYTES}");
    }
    Ok(())
}

pub(crate) async fn validate_recurrence_metadata_result(
    conn: &mut SqliteConnection,
    workspace_id: &WorkspaceId,
    series_id: &RecurrenceSeriesId,
    set: &[TaskMetadataInput],
    remove: &[String],
) -> Result<()> {
    validate_metadata_update(set, remove)?;
    let rows = sqlx::query(
        "SELECT f.key, m.value FROM recurrence_series_metadata m
         JOIN metadata_fields f ON f.workspace_id = m.workspace_id AND f.id = m.field_id
         WHERE m.workspace_id = ? AND m.series_id = ?",
    )
    .bind(workspace_id)
    .bind(series_id)
    .fetch_all(&mut *conn)
    .await?;
    validate_metadata_result_limits(
        rows.into_iter()
            .map(|row| (row.get::<String, _>("key"), row.get::<String, _>("value"))),
        set,
        remove,
    )
}

pub(crate) async fn validate_task_metadata_result(
    conn: &mut SqliteConnection,
    workspace_id: &WorkspaceId,
    task_id: &TaskId,
    set: &[TaskMetadataInput],
    remove: &[String],
) -> Result<()> {
    validate_metadata_update(set, remove)?;
    let rows = sqlx::query(
        "SELECT f.key, m.value FROM task_metadata m
         JOIN metadata_fields f ON f.workspace_id = m.workspace_id AND f.id = m.field_id
         WHERE m.workspace_id = ? AND m.task_id = ?",
    )
    .bind(workspace_id)
    .bind(task_id)
    .fetch_all(&mut *conn)
    .await?;
    validate_metadata_result_limits(
        rows.into_iter()
            .map(|row| (row.get::<String, _>("key"), row.get::<String, _>("value"))),
        set,
        remove,
    )
}