monochromium 0.4.3

A fast, local-first CLI note-taking app for developers
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

use super::Database;
use crate::types::NoteTypes;
use chrono::NaiveDateTime;
use rusqlite::params;

impl Database {
    pub fn add_row(
        &self,
        title: String,
        note_type: NoteTypes,
        content: String,
        date: NaiveDateTime,
    ) -> Result<u32, rusqlite::Error> {
        let note_type = note_type.as_str();
        let date = date.to_string();

        let id: u32 = self.conn.query_row(
            "INSERT INTO notes (title, type, content, date)
         VALUES (?1, ?2, ?3, ?4)
         RETURNING id",
            params![title, note_type, content, date],
            |row| row.get(0),
        )?;

        Ok(id)
    }
}