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
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

use librius::commands::handle_list;
use rusqlite::Connection;
use std::error::Error;

#[test]
fn exercise_list_handler() -> Result<(), Box<dyn Error>> {
    let conn = Connection::open_in_memory()?;
    conn.execute(
        "CREATE TABLE books (
            id INTEGER PRIMARY KEY,
            title TEXT NOT NULL,
            author TEXT NOT NULL,
            editor TEXT NOT NULL,
            year INTEGER NOT NULL,
            isbn TEXT NOT NULL,
            language TEXT,
            pages INTEGER,
            genre TEXT,
            summary TEXT,
            room TEXT,
            shelf TEXT,
            row TEXT,
            position TEXT,
            added_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        );",
        [],
    )?;

    conn.execute(
        "INSERT INTO books (title, author, editor, year, isbn, added_at)
         VALUES (?1, ?2, ?3, ?4, ?5, ?6);",
        [
            "Test Book",
            "Author",
            "Editor",
            "2025",
            "978-88823145698",
            "2020-01-01 12:00:00",
        ],
    )?;

    handle_list(&conn, false, None, false, false)?;
    Ok(())
}

#[test]
fn exercise_list_handler_short() -> Result<(), Box<dyn Error>> {
    let conn = Connection::open_in_memory()?;
    conn.execute(
        "CREATE TABLE books (
            id INTEGER PRIMARY KEY,
            title TEXT NOT NULL,
            author TEXT NOT NULL,
            editor TEXT NOT NULL,
            year INTEGER NOT NULL,
            isbn TEXT NOT NULL,
            language TEXT,
            pages INTEGER,
            genre TEXT,
            summary TEXT,
            room TEXT,
            shelf TEXT,
            row TEXT,
            position TEXT,
            added_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        );",
        [],
    )?;

    conn.execute(
        "INSERT INTO books (title, author, editor, year, isbn, added_at)
         VALUES (?1, ?2, ?3, ?4, ?5, ?6);",
        [
            "Short Test",
            "Author",
            "Editor",
            "2022",
            "978-0000000000",
            "2020-01-01 12:00:00",
        ],
    )?;

    handle_list(&conn, true, None, false, false)?;
    Ok(())
}