dbquota 0.3.1

enforces database quotas by toggling a read-only status
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

use clap::{App, Arg};
use dbquota::queries;
use std::{
    process, thread,
    time::{Duration, Instant},
};

fn main() {
    let matches = App::new(env!("CARGO_PKG_NAME"))
        .version(env!("CARGO_PKG_VERSION"))
        .arg(
            Arg::with_name("DSN")
                .env("DSN")
                .help("mysql://<username>:<password>@<host>:<port>/<database>")
                .long("dsn")
                .required(true)
                .short("d"),
        )
        .arg(
            Arg::with_name("every")
                .default_value("180")
                .help("run every N seconds")
                .long("every")
                .short("e")
                .validator(is_num),
        )
        .get_matches();

    let every = matches.value_of("every").unwrap().parse::<u64>().unwrap();
    let opts = mysql::Opts::from_url(matches.value_of("DSN").unwrap()).unwrap_or_else(|e| {
        eprintln!("verify the DSN: {}", e);
        process::exit(1);
    });
    let mut opts = mysql::OptsBuilder::from_opts(opts);
    opts.stmt_cache_size(0);
    let pool = mysql::Pool::new_manual(1, 10, opts).unwrap_or_else(|e| {
        eprintln!("Could not connect: {}", e);
        process::exit(1);
    });

    loop {
        let start = Instant::now();
        let wait_time = Duration::from_secs(every);
        let q = queries::new(&pool);

        // populate dbquota
        match q.update_db_size() {
            Err(e) => eprintln!("Error Updating db size: {}", e),
            Ok(_) => {}
        };

        // check for databased that exceeded the quota and revoke privileges
        match q.enforce_quota() {
            Err(e) => eprintln!("Error enforcing quota: {}", e),
            Ok(_) => {}
        };

        // check if database is below the defined quota and grant privileges
        match q.revoke_quota() {
            Err(e) => eprintln!("Error enforcing quota: {}", e),
            Ok(_) => {}
        };

        let runtime = start.elapsed();
        if let Some(remaining) = wait_time.checked_sub(runtime) {
            println!("sleeping for: {:?}", remaining);
            thread::sleep(remaining);
        }
    }
}

fn is_num(s: String) -> Result<(), String> {
    if let Err(..) = s.parse::<u64>() {
        return Err(String::from("Not a valid number!"));
    }
    Ok(())
}