LINE1 10 20 30 40 50 60 70 80 901use anyhow::Result;2use rusqlite::{Connection, OptionalExtension, params};3use uuid::Uuid;45use crate::auth::{Principal, Scope};6use crate::db::now;78const SESSION_DAYS: i64 = 30;9101112pub fn create(connection: &Connection, user_id: &str, secret_hash: &str) -> Result<()> {13 let created_at = now();14 let expires_at = (chrono::Utc::now() + chrono::TimeDelta::days(SESSION_DAYS))15 .to_rfc3339_opts(chrono::SecondsFormat::Millis, true);16 connection.execute(17 "INSERT INTO sessions (id, user_id, token_hash, created_at, expires_at)18 VALUES (?1, ?2, ?3, ?4, ?5)",19 params![20 Uuid::new_v4().to_string(),21 user_id,22 secret_hash,23 created_at,24 expires_at25 ],26 )?;27 Ok(())28}293031pub fn find(connection: &Connection, secret_hash: &str) -> Result<Option<Principal>> {32 let username: Option<String> = connection33 .query_row(34 "SELECT u.username35 FROM sessions s JOIN users u ON u.id = s.user_id36 WHERE s.token_hash = ?1 AND s.expires_at > ?2",37 params![secret_hash, now()],38 |row| row.get(0),39 )40 .optional()?;41 42 Ok(username.map(|name| Principal {43 token_id: "session".to_string(),44 name,45 scopes: vec![Scope::Read, Scope::Write],46 }))47}4849pub fn delete(connection: &Connection, secret_hash: &str) -> Result<()> {50 connection.execute(51 "DELETE FROM sessions WHERE token_hash = ?1",52 params![secret_hash],53 )?;54 Ok(())55}5657#[cfg(test)]58mod tests {59 use super::*;60 use crate::db::open_in_memory;61 use crate::users;6263 #[test]64 fn a_session_resolves_until_it_is_deleted_or_expires() {65 let connection = open_in_memory().unwrap();66 let user = users::create(&connection, "silen", "a long enough password").unwrap();67 create(&connection, &user.id, "hash-1").unwrap();6869 let principal = find(&connection, "hash-1").unwrap().unwrap();70 assert_eq!(principal.name, "silen");71 assert!(principal.allows(Scope::Write));72 assert!(find(&connection, "unknown").unwrap().is_none());7374 connection75 .execute(76 "UPDATE sessions SET expires_at = '2000-01-01T00:00:00.000Z'",77 [],78 )79 .unwrap();80 assert!(find(&connection, "hash-1").unwrap().is_none());8182 delete(&connection, "hash-1").unwrap();83 assert!(find(&connection, "hash-1").unwrap().is_none());84 }85}