chest-rs 0.2.0

A multiplatform CLI command organizer
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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148

use crate::{dirs::db_path, AppResult};

use super::shell_command::ShellCommand;

mod db;

use async_std::task;
pub use db::Database;
use log::{debug, error};
use sqlx::{
    migrate,
    sqlite::{SqliteConnectOptions, SqlitePoolOptions},
    Error, SqlitePool,
};

pub trait Engine: Sized {
    fn init() -> AppResult<Self>;
    fn search_commands(&self, search_term: &str) -> Vec<ShellCommand>;
    fn search_commands_strict(&self, name: &str) -> Option<ShellCommand>;
    fn get_command(&self, name: &str) -> Option<ShellCommand>;
    fn add_command(&self, command: ShellCommand) -> AppResult<()>;
    fn update_command(&self, command: ShellCommand) -> AppResult<()>;
    fn remove_command(&self, name: &str) -> AppResult<()>;
}

fn create_database_connection() -> Result<SqlitePool, Error> {
    task::block_on(async {
        let options = SqliteConnectOptions::new()
            .filename(db_path())
            .create_if_missing(true)
            .optimize_on_close(true, None);
        let connection = SqlitePoolOptions::new()
            .connect_with(options)
            .await
            .map_err(|error| {
                error!(
                    "Unable to open or create database at path : {}",
                    db_path().display()
                );
                debug!("{}", error);
                error
            })?;

        migrate!().run(&connection).await.map_err(|error| {
            error!("Unable to migrate database");
            debug!("{}", error);
            error
        })?;

        Ok(connection)
    })
}

fn get_all_commands(db: &SqlitePool) -> Vec<ShellCommand> {
    task::block_on(async {
        sqlx::query_as::<_, ShellCommand>("SELECT * FROM Commands ORDER BY name")
            .fetch_all(db)
            .await
            .unwrap_or_else(|error| {
                error!("Error while searching for commands without search_term",);
                debug!("{}", error);
                Vec::new()
            })
    })
}

fn get_filtered_commands(db: &SqlitePool, search_term: &str) -> Vec<ShellCommand> {
    task::block_on(async {
        sqlx::query_as::<_, ShellCommand>(
            "SELECT * FROM Commands WHERE Commands MATCH $1 ORDER BY rank",
        )
        .bind(search_term)
        .fetch_all(db)
        .await
        .unwrap_or_else(|error| {
            error!(
                "Error while searching for commands with search_term {}",
                search_term
            );
            debug!("{}", error);
            Vec::new()
        })
    })
}

fn get_filtered_commands_name(db: &SqlitePool, name: &str) -> Option<ShellCommand> {
    task::block_on(async {
        sqlx::query_as::<_, ShellCommand>(
            "SELECT * FROM Commands WHERE name MATCH $1 ORDER BY rank",
        )
        .bind(name)
        .fetch_optional(db)
        .await
        .unwrap_or_else(|error| {
            error!("Error while searching for commands with name {}", name);
            debug!("{}", error);
            None
        })
    })
}

fn get_command(db: &SqlitePool, name: &str) -> Option<ShellCommand> {
    task::block_on(async {
        sqlx::query_as::<_, ShellCommand>("SELECT * FROM Commands WHERE name = $1")
            .bind(name)
            .fetch_optional(db)
            .await
            .unwrap_or_else(|error| {
                error!("Error while searching for a command with name {}", name);
                debug!("{}", error);
                None
            })
    })
}

fn add_command(db: &SqlitePool, command: ShellCommand) -> AppResult<()> {
    Ok(task::block_on(async {
        sqlx::query("INSERT INTO Commands (name, command_text, description) VALUES ($1, $2, $3);")
            .bind(command.name)
            .bind(command.command_text)
            .bind(command.description)
            .execute(db)
            .await
            .map(|_ok| ())
    })?)
}

fn update_command(db: &SqlitePool, command: ShellCommand) -> AppResult<()> {
    Ok(task::block_on(async {
        sqlx::query("UPDATE Commands SET command_text=$2, description=$3 WHERE name=$1;")
            .bind(command.name)
            .bind(command.command_text)
            .bind(command.description)
            .execute(db)
            .await
            .map(|_ok| ())
    })?)
}

fn remove_command(db: &SqlitePool, name: &str) -> AppResult<()> {
    Ok(task::block_on(async {
        sqlx::query("DELETE FROM Commands WHERE name = $1")
            .bind(name)
            .execute(db)
            .await
            .map(|_ok| ())
    })?)
}