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
|
use rusqlite::{params, Connection, Result};
use crate::db::tables::SerialNumbers;
#[repr(i32)] #[derive(Debug, PartialEq)]
enum AccountStatus {
AccountInactive = 0,
AccountActive = 1,
}
fn modify_account_status(username: &str, status: AccountStatus) -> Result<()> {
let connection = Connection::open("worlds.db")?;
// language=SQLite
connection.execute(
"UPDATE user_registration \
SET account_status = (?1) \
where username = '(?2)'",
params![status as i32, username]
)?;
Ok(())
}
fn delete_account(username: &str) -> Result<()> {
let connection = Connection::open("worlds.db")?;
// Get serial_number from `username`'s row.
// language=SQLite
connection.query_row(
"SELECT * FROM serial_numbers WHERE username = '(?1)'",
params![username],
|row| row.get(0)
);
let mut row = connection.prepare(
"SELECT * \
FROM serial_numbers \
WHERE username = '(?1)';"
)?;
let row_iter = row.query_map(params![username], |row| {
Ok(SerialNumbers {
serial_number: row.get(0)?,
user_name: row.get(1)?,
serial_status: row.get(2)?,
})
})?;
// Reset serial number so it can be reused.
// language=SQLite
connection.execute(
"UPDATE serial_numbers \
SET username = 'none', serial_status = 0 \
WHERE serial_number = '(?1)'",
params![row_iter.]
)?;
Ok(())
}
fn set_account_host() { }
fn modify_account_vip() { }
|