endjine 0.0.2

Accessing the Engine DJ library database.
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

// SPDX-FileCopyrightText: The endjine authors
// SPDX-License-Identifier: MPL-2.0

#![expect(rustdoc::invalid_rust_codeblocks)] // Do not interpret code blocks, e.g. license comments.
#![doc = include_str!("../README.md")]

use sqlx::SqlitePool;

mod models;
pub use self::models::*;

mod batch;
pub use self::batch::{BatchOutcome, shrink_album_art};

pub async fn delete_orphaned_album_art(pool: &SqlitePool) -> sqlx::Result<u64> {
    let result =
        sqlx::query(r"DELETE FROM AlbumArt WHERE id NOT IN (SELECT albumArtId FROM Track)")
            .execute(pool)
            .await?;
    Ok(result.rows_affected())
}

pub async fn optimize_database(pool: &SqlitePool) -> sqlx::Result<()> {
    sqlx::query(r"VACUUM").execute(pool).await?;
    sqlx::query(r"ANALYZE").execute(pool).await?;
    Ok(())
}