From ea5e7d336719571e51ef14478ab603e71126e3d8 Mon Sep 17 00:00:00 2001
From: salmonik <salmonik@tuta.io>
Date: Wed, 28 Oct 2026 22:28:05 +0100
Subject: v0.2.2: split client/server logic into the library

---
 src/bin/client/database.rs | 118 ---------------------------------------------
 1 file changed, 118 deletions(-)
 delete mode 100644 src/bin/client/database.rs

(limited to 'src/bin/client/database.rs')

diff --git a/src/bin/client/database.rs b/src/bin/client/database.rs
deleted file mode 100644
index e1fa42d..0000000
--- a/src/bin/client/database.rs
+++ /dev/null
@@ -1,118 +0,0 @@
-use rusqlite::Connection;
-
-pub fn init_db(conn: &Connection) {
-    conn.execute(
-        "CREATE TABLE IF NOT EXISTS hosts (
-            host TEXT PRIMARY KEY,
-            last_used DATETIME DEFAULT CURRENT_TIMESTAMP,
-            fingerprint TEXT
-        )",
-        [],
-    )
-    .unwrap();
-    // Migration for databases created before TOFU trust.
-    let _ = conn.execute("ALTER TABLE hosts ADD COLUMN fingerprint TEXT", []);
-    conn.execute(
-        "CREATE TABLE IF NOT EXISTS credentials (
-            host TEXT PRIMARY KEY,
-            username TEXT NOT NULL,
-            password TEXT NOT NULL
-        )",
-        [],
-    )
-    .unwrap();
-}
-
-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 INTO hosts (host) VALUES (?1)
-         ON CONFLICT(host) DO UPDATE SET last_used = 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
-    }
-}
-
-/// SHA-256 SPKI fingerprint of a host's certificate, if trusted.
-pub fn get_fingerprint(conn: &Connection, host: &str) -> Option<String> {
-    let mut stmt = conn
-        .prepare("SELECT fingerprint FROM hosts WHERE host = ?1")
-        .ok()?;
-    let mut rows = stmt.query([host]).ok()?;
-    match rows.next() {
-        Ok(Some(row)) => row.get(0).ok(),
-        _ => None,
-    }
-}
-
-pub fn save_fingerprint(
-    conn: &Connection,
-    host: &str,
-    fingerprint: &str,
-) -> Result<(), rusqlite::Error> {
-    // Hosts may not exist yet (fingerprint can be saved before first
-    // successful connect completes save_host).
-    conn.execute("INSERT OR IGNORE INTO hosts (host) VALUES (?1)", [host])?;
-    conn.execute(
-        "UPDATE hosts SET fingerprint = ?2 WHERE host = ?1",
-        (host, fingerprint),
-    )?;
-    Ok(())
-}
-
-/// Remove all trust and credentials for a host ("forget this host").
-pub fn forget_host(conn: &Connection, host: &str) -> Result<(), rusqlite::Error> {
-    conn.execute("DELETE FROM hosts WHERE host = ?1", [host])?;
-    conn.execute("DELETE FROM credentials WHERE host = ?1", [host])?;
-    Ok(())
-}
-
-/// List all remembered hosts with their fingerprints.
-pub fn get_all_hosts(conn: &Connection) -> Vec<(String, Option<String>)> {
-    let mut stmt = conn
-        .prepare("SELECT host, fingerprint FROM hosts ORDER BY last_used DESC")
-        .unwrap();
-    let rows = stmt.query_map([], |row| {
-        Ok((row.get(0)?, row.get(1)?))
-    })
-    .unwrap();
-    rows.filter_map(|r| r.ok()).collect()
-}
-- 
cgit v1.2.3