moosicbox_scan 0.1.0

MoosicBox scan package
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

use moosicbox_core::sqlite::db::DbError;
use moosicbox_database::{profiles::LibraryDatabase, query::*};
use moosicbox_json_utils::ToValueType;

use crate::ScanOrigin;

use self::models::ScanLocation;

pub mod models;

#[cfg(feature = "local")]
pub async fn add_scan_path(db: &LibraryDatabase, path: &str) -> Result<(), DbError> {
    db.upsert("scan_locations")
        .where_eq("origin", ScanOrigin::Local.as_ref())
        .where_eq("path", path)
        .value("origin", ScanOrigin::Local.as_ref())
        .value("path", path)
        .execute(db)
        .await?;

    Ok(())
}

#[cfg(feature = "local")]
pub async fn remove_scan_path(db: &LibraryDatabase, path: &str) -> Result<(), DbError> {
    db.delete("scan_locations")
        .where_eq("origin", ScanOrigin::Local.as_ref())
        .where_eq("path", path)
        .execute(db)
        .await?;

    Ok(())
}

pub async fn enable_scan_origin(db: &LibraryDatabase, origin: ScanOrigin) -> Result<(), DbError> {
    db.upsert("scan_locations")
        .where_eq("origin", origin.as_ref())
        .value("origin", origin.as_ref())
        .execute(db)
        .await?;

    Ok(())
}

pub async fn disable_scan_origin(db: &LibraryDatabase, origin: ScanOrigin) -> Result<(), DbError> {
    db.delete("scan_locations")
        .where_eq("origin", origin.as_ref())
        .execute(db)
        .await?;

    Ok(())
}

pub async fn get_enabled_scan_origins(db: &LibraryDatabase) -> Result<Vec<ScanOrigin>, DbError> {
    Ok(db
        .select("scan_locations")
        .distinct()
        .columns(&["origin"])
        .execute(db)
        .await?
        .to_value_type()?)
}

pub async fn get_scan_locations(db: &LibraryDatabase) -> Result<Vec<ScanLocation>, DbError> {
    Ok(db
        .select("scan_locations")
        .execute(db)
        .await?
        .to_value_type()?)
}
pub async fn get_scan_locations_for_origin(
    db: &LibraryDatabase,
    origin: ScanOrigin,
) -> Result<Vec<ScanLocation>, DbError> {
    Ok(db
        .select("scan_locations")
        .where_eq("origin", origin.as_ref())
        .execute(db)
        .await?
        .to_value_type()?)
}