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
|
use rusqlite::Connection;
pub fn init_db() -> Connection {
let conn = Connection::open("client.db").unwrap();
conn.execute(
"CREATE TABLE IF NOT EXISTS hosts (
host TEXT PRIMARY KEY,
last_used DATETIME DEFAULT CURRENT_TIMESTAMP
)",
[],
).unwrap();
conn.execute(
"CREATE TABLE IF NOT EXISTS credentials (
host TEXT PRIMARY KEY,
username TEXT NOT NULL,
password TEXT NOT NULL
)",
[],
).unwrap();
conn
}
pub fn get_last_host(conn: &Connection) -> Option<String> {
let mut stmt = conn.prepare("SELECT host FROM hosts ORDER BY last_used DESC LIMIT 1").unwrap();
let mut rows = stmt.query([]).unwrap();
if let Ok(Some(row)) = rows.next() {
row.get(0).ok()
} else {
None
}
}
pub fn save_host(conn: &Connection, host: &str) {
conn.execute(
"INSERT OR REPLACE INTO hosts (host, last_used) VALUES (?1, CURRENT_TIMESTAMP)",
[host],
).unwrap();
}
pub fn save_credentials(conn: &Connection, host: &str, username: &str, password: &str) -> Result<(), Box<dyn std::error::Error>> {
conn.execute(
"INSERT OR REPLACE INTO credentials (host, username, password) VALUES (?1, ?2, ?3)",
(host, username, password),
)?;
Ok(())
}
pub fn get_credentials(conn: &Connection, host: &str) -> Option<(String, String)> {
let mut stmt = conn.prepare("SELECT username, password FROM credentials WHERE host = ?1").unwrap();
let mut rows = stmt.query([host]).unwrap();
if let Ok(Some(row)) = rows.next() {
let username: String = row.get(0).unwrap();
let password: String = row.get(1).unwrap();
Some((username, password))
} else {
None
}
}
|
