1 files changed, 12 insertions, 0 deletions

diff --git a/src/bin/client/database.rs b/src/bin/client/database.rs
index 55051fb..e1fa42d 100644
--- a/src/bin/client/database.rs
+++ b/src/bin/client/database.rs
@@ -104,3 +104,15 @@ pub fn forget_host(conn: &Connection, host: &str) -> Result<(), rusqlite::Error>
     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()
+}