modbot 0.5.3

Discord bot for https://mod.io. ModBot provides commands to search for mods and notifications about added & edited mods.
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

use diesel::prelude::*;
use diesel::sql_types::Text;

use super::types::GameId;
use super::{schema, DbPool, Result};

pub fn games_by_name(pool: &DbPool, value: &str) -> Result<Vec<(GameId, String)>> {
    use schema::games::dsl::*;

    let conn = &mut pool.get()?;

    let result = games
        .select((id, name))
        .filter(name.like(format!("{value}%")).and(autocomplete.eq(true)))
        .limit(25)
        .load(conn)?;

    Ok(result)
}

pub fn games_by_name_id(pool: &DbPool, value: &str) -> Result<Vec<(GameId, String)>> {
    use schema::games::dsl::*;

    let conn = &mut pool.get()?;

    let result = games
        .select((id, "@".into_sql::<Text>().concat(name_id)))
        .filter(name_id.like(format!("{value}%")).and(autocomplete.eq(true)))
        .limit(25)
        .load(conn)?;

    Ok(result)
}