aboutsummaryrefslogtreecommitdiff
path: root/src/db/utils.rs
blob: 7c359aba772468b2f5d293fd4647294d6f3dd7f4 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
pub fn format_key_for_search(value: &str) -> String {
    // Lower doesn’t work on accentuated letters, hence the need to remove manually accents for
    // uppercase letters as well.
    format!(
        "replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(lower({}), 'à', 'a'), 'â', 'a'), 'ç', 'c'), 'è', 'e'), 'é', 'e'), 'ê', 'e'), 'ë', 'e'), 'î', 'i'), 'ï', 'i'), 'ô', 'o'), 'ù', 'u'), 'û', 'u'), 'ü', 'u'), 'À', 'A'), 'Â', 'A'), 'Ç', 'C'), 'È', 'E'), 'É', 'E'), 'Ê', 'E'), 'Ë', 'E'), 'Î', 'I'), 'Ï', 'I'), 'Ô', 'O'), 'Ù', 'U'), 'Û', 'U'), 'Ü', 'U')",
        value
    )
}

pub fn one<A, I: Iterator<Item = Result<A, rusqlite::Error>>>(
    mut iter: I,
) -> Result<A, rusqlite::Error> {
    match iter.next() {
        Some(Ok(user)) => Ok(user),
        Some(Err(err)) => Err(err),
        None => Err(rusqlite::Error::QueryReturnedNoRows),
    }
}