librius 0.5.1

A personal library manager CLI written in Rust.
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

mod common;
use common::setup_temp_db;

#[test]
fn test_temporary_db_with_full_schema() {
    let conn = setup_temp_db("integration_schema");

    // Verifica che lo schema di produzione sia presente
    let count: i64 = conn
        .query_row(
            "SELECT COUNT(*) FROM pragma_table_info('books') WHERE name = 'isbn';",
            [],
            |r| r.get(0),
        )
        .unwrap();

    assert_eq!(count, 1, "La colonna 'isbn' non รจ presente nello schema");
}

#[test]
fn test_insert_and_read_book_full_schema() {
    let conn = setup_temp_db("insert_full");

    conn.execute(
        "INSERT INTO books (title, author, editor, year, isbn, language, pages, genre, summary, room, shelf, row, position, added_at)
         VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, datetime('now'))",
        (
            "Il Nome della Rosa",
            "Umberto Eco",
            "Bompiani",
            1980,
            "9788845254283",
            "it",
            512,
            "Romanzo storico",
            "Un romanzo ambientato in un monastero medievale...",
            "Studio",
            "A",
            "1",
            "3",
        ),
    ).unwrap();

    let mut stmt = conn
        .prepare("SELECT title, author, genre FROM books WHERE author = 'Umberto Eco'")
        .unwrap();
    let row = stmt
        .query_row([], |r| {
            Ok((
                r.get::<_, String>(0)?,
                r.get::<_, String>(1)?,
                r.get::<_, String>(2)?,
            ))
        })
        .unwrap();

    assert_eq!(row.0, "Il Nome della Rosa");
    assert_eq!(row.1, "Umberto Eco");
    assert_eq!(row.2, "Romanzo storico");
}