Skip to content
1        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;910/// Stores a session for a user, keyed by the hash of its secret. The secret itself lives11/// only in the browser's cookie.12pub 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}2930/// The principal for a live session. Expired and unknown sessions are `None`.31pub 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    // Signed-in people manage the archive themselves, so a session has full access.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}