to_do_cli 0.1.2

Feature-rich command-line todo app with SQLite storage
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

// Binary to seed the database with mock data
// Run with: cargo run --bin seed

use rusqlite::Connection;

// Import the seed module
mod seed_data {
    include!("../seed.rs");
}

fn main() -> rusqlite::Result<()> {
    println!("Opening database connection...");
    let conn = Connection::open("todo.db")?;

    // Create table if it doesn't exist
    println!("Initializing database schema...");
    conn.execute_batch(
        "
        CREATE TABLE IF NOT EXISTS tasks (
            id              INTEGER PRIMARY KEY AUTOINCREMENT,
            title           TEXT NOT NULL,
            status          TEXT NOT NULL,
            created_at      TEXT NOT NULL,
            updated_at      TEXT,
            completed_at    TEXT,
            deleted_at      TEXT,
            due_at          TEXT,
            priority        TEXT,
            notes           TEXT
        );
        ",
    )?;

    println!("Seeding database with mock data...");
    seed_data::seed_database(&conn, false)?;

    println!("Done! Use 'cargo run' to start the todo app and view the tasks.");
    Ok(())
}