term_keep 1.2.1

Terminal-based Google Keep clone. Can be used as a note taking / To-Do list app on a server.
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

use crate::errors::not_found_by_field_error::NotFoundByFieldError;
use crate::errors::row_not_changed_error::RowNotChangedError;
use crate::models::template::Template;
use crate::services::db::change_row;
use crate::services::db::rows_to_vec;
use crate::services::db::single_row;

#[must_use]
pub fn find_all() -> Vec<Template> {
  rows_to_vec(
    "SELECT id, name, content FROM template",
    rusqlite::params![],
  )
}

pub fn find_one(name: &str) -> Result<Template, NotFoundByFieldError> {
  single_row::<Template>(
    "SELECT id, name, content FROM template WHERE name = ?",
    rusqlite::params![name],
  )
  .ok_or_else(|| NotFoundByFieldError::new::<Template>("name".to_owned(), name.to_owned()))
}

pub fn create(name: &str, content: &str) -> Result<(), RowNotChangedError> {
  change_row::<Template>(
    "INSERT INTO template (name, content) VALUES (?, ?)",
    rusqlite::params![name, content],
  )
}

pub fn update(id: u32, content: &str) -> Result<(), RowNotChangedError> {
  change_row::<Template>(
    "UPDATE template SET content = ? WHERE id = ?",
    rusqlite::params![content, id],
  )
}

pub fn remove(id: u32) -> Result<(), RowNotChangedError> {
  change_row::<Template>("DELETE FROM template WHERE id = ?", rusqlite::params![id])
}