telegram-raf 0.1.3

RaF (Refer a Friend): bot for creating referral-based contests for your Telegram channels, groups and supergroups
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

// Copyright 2021 Paolo Galeone <nessuno@nerdz.eu>
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//    http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

use rusqlite::params;
use telexide_fork::prelude::*;

use crate::persistence::types::{DBKey, User};

/// Returns the `User` with the specified `id`, if any.
///
/// # Arguments
/// * `ctx` - Telexide context
/// * `id` - The user ud
///
/// # Panics
/// Panics if the connection to the db fails.
#[must_use]
pub fn get(ctx: &Context, id: i64) -> Option<User> {
    let guard = ctx.data.read();
    let map = guard.get::<DBKey>().expect("db");
    let conn = map.get().unwrap();
    let mut stmt = conn
        .prepare("SELECT first_name, last_name, username FROM users WHERE id = ?")
        .unwrap();
    let mut iter = stmt
        .query_map(params![id], |row| {
            Ok(User {
                id,
                first_name: row.get(0)?,
                last_name: row.get(1)?,
                username: row.get(2)?,
            })
        })
        .unwrap();
    if let Some(user) = iter.next() {
        return match user {
            Ok(user) => Some(user),
            Err(_) => None,
        };
    }
    None
}

/// Returns the complete list of owners. Owners are the users who registered a channel/group.
///
/// # Arguments
/// * `ctx` - Telexide context
///
/// # Panics
/// Panics if the connection to the db fails.
#[must_use]
pub fn owners(ctx: &Context) -> Vec<User> {
    let guard = ctx.data.read();
    let map = guard.get::<DBKey>().expect("db");
    let conn = map.get().unwrap();
    let mut stmt = conn
        .prepare(
            "SELECT DISTINCT users.id, users.first_name, users.last_name, users.username \
        FROM users INNER JOIN channels ON users.id = channels.registered_by \
        ORDER BY users.id",
        )
        .unwrap();

    let users = stmt
        .query_map(params![], |row| {
            Ok(User {
                id: row.get(0)?,
                first_name: row.get(1)?,
                last_name: row.get(2)?,
                username: row.get(3)?,
            })
        })
        .unwrap()
        .map(Result::unwrap)
        .collect();
    users
}