     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

    /*
    * Copyright (C) 2021  Aravinth Manivannan <realaravinth@batsense.net>
    *
    * This program is free software: you can redistribute it and/or modify
    * it under the terms of the GNU Affero General Public License as
    * published by the Free Software Foundation, either version 3 of the
    * License, or (at your option) any later version.
    *
    * This program is distributed in the hope that it will be useful,
    * but WITHOUT ANY WARRANTY; without even the implied warranty of
    * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    * GNU Affero General Public License for more details.
    *
    * You should have received a copy of the GNU Affero General Public License
    * along with this program.  If not, see <https://www.gnu.org/licenses/>.
    */

    use sqlx::PgPool;

    /// record PoWConfig fetches
    #[inline]
    pub async fn record_fetch(key: &str, db: &PgPool) {
        let _ = sqlx::query!(
            "INSERT INTO mcaptcha_pow_fetched_stats
            (config_id) VALUES ((SELECT config_id FROM mcaptcha_config WHERE key = $1))",
            &key,
        )
        .execute(db)
        .await;
    }

    /// record PoWConfig solves
    #[inline]
    pub async fn record_solve(key: &str, db: &PgPool) {
        let _ = sqlx::query!(
            "INSERT INTO mcaptcha_pow_solved_stats
            (config_id) VALUES ((SELECT config_id FROM mcaptcha_config WHERE key = $1))",
            &key,
        )
        .execute(db)
        .await;
    }

    /// record PoWConfig confirms
    #[inline]
    pub async fn record_confirm(key: &str, db: &PgPool) {
        let _ = sqlx::query!(
            "INSERT INTO mcaptcha_pow_confirmed_stats
            (config_id) VALUES ((SELECT config_id FROM mcaptcha_config WHERE key = $1))",
            &key,
        )
        .execute(db)
        .await;
    }