Skip to content
1        10        20        30        40        50        60        70        80        901use std::collections::HashMap;23use actix_session::storage::{LoadError, SaveError, SessionKey, SessionStore, UpdateError};4use actix_web::cookie::time::Duration;5use anyhow::anyhow;67use crate::db::Database;89#[derive(Clone)]10pub struct SqliteSessionStore {11    db: Database,12}1314impl SqliteSessionStore {15    pub fn new(db: Database) -> Self {16        Self { db }17    }1819    fn expires_at(ttl: &Duration) -> i64 {20        chrono::Utc::now()21            .timestamp()22            .saturating_add(ttl.whole_seconds())23    }24}2526impl SessionStore for SqliteSessionStore {27    async fn load(28        &self,29        session_key: &SessionKey,30    ) -> Result<Option<HashMap<String, String>>, LoadError> {31        let conn = self32            .db33            .conn()34            .await35            .map_err(|e| LoadError::Other(anyhow!(e)))?;36        let mut rows = conn37            .query(38                "SELECT state FROM sessions WHERE session_key = ?1 AND expires_at > ?2",39                turso::params![session_key.as_ref(), chrono::Utc::now().timestamp()],40            )41            .await42            .map_err(|e| LoadError::Other(anyhow!(e.to_string())))?;4344        let Some(row) = rows45            .next()46            .await47            .map_err(|e| LoadError::Other(anyhow!(e.to_string())))?48        else {49            return Ok(None);50        };5152        let state: String = row53            .get(0)54            .map_err(|e| LoadError::Other(anyhow!(e.to_string())))?;55        serde_json::from_str(&state)56            .map(Some)57            .map_err(|e| LoadError::Deserialization(anyhow!(e)))58    }5960    async fn save(61        &self,62        session_state: HashMap<String, String>,63        ttl: &Duration,64    ) -> Result<SessionKey, SaveError> {65        let session_key = uuid::Uuid::new_v4().to_string();66        let serialized = serde_json::to_string(&session_state)67            .map_err(|e| SaveError::Serialization(anyhow!(e)))?;68        let conn = self69            .db70            .conn()71            .await72            .map_err(|e| SaveError::Other(anyhow!(e)))?;73        let now = chrono::Utc::now().timestamp();74        conn.execute(75            "DELETE FROM sessions WHERE expires_at <= ?1",76            turso::params![now],77        )78        .await79        .map_err(|e| SaveError::Other(anyhow!(e.to_string())))?;80        conn.execute(81            "INSERT INTO sessions (session_key, state, expires_at) VALUES (?1, ?2, ?3)",82            turso::params![session_key.clone(), serialized, Self::expires_at(ttl)],83        )84        .await85        .map_err(|e| SaveError::Other(anyhow!(e.to_string())))?;8687        Ok(SessionKey::try_from(session_key).expect("UUID is a valid session key"))88    }8990    async fn update(91        &self,92        session_key: SessionKey,93        session_state: HashMap<String, String>,94        ttl: &Duration,95    ) -> Result<SessionKey, UpdateError> {96        let serialized = serde_json::to_string(&session_state)97            .map_err(|e| UpdateError::Serialization(anyhow!(e)))?;98        let updated = self99            .db100            .conn()101            .await102            .map_err(|e| UpdateError::Other(anyhow!(e)))?103            .execute(104                "UPDATE sessions SET state = ?1, expires_at = ?2 WHERE session_key = ?3",105                turso::params![serialized, Self::expires_at(ttl), session_key.as_ref()],106            )107            .await108            .map_err(|e| UpdateError::Other(anyhow!(e.to_string())))?;109        if updated == 0 {110            return self111                .save(session_state, ttl)112                .await113                .map_err(|err| match err {114                    SaveError::Serialization(err) => UpdateError::Serialization(err),115                    SaveError::Other(err) => UpdateError::Other(err),116                });117        }118        Ok(session_key)119    }120121    async fn update_ttl(122        &self,123        session_key: &SessionKey,124        ttl: &Duration,125    ) -> Result<(), anyhow::Error> {126        self.db127            .conn()128            .await129            .map_err(|e| anyhow!(e))?130            .execute(131                "UPDATE sessions SET expires_at = ?1 WHERE session_key = ?2",132                turso::params![Self::expires_at(ttl), session_key.as_ref()],133            )134            .await135            .map_err(|e| anyhow!(e.to_string()))?;136        Ok(())137    }138139    async fn delete(&self, session_key: &SessionKey) -> Result<(), anyhow::Error> {140        self.db141            .conn()142            .await143            .map_err(|e| anyhow!(e))?144            .execute(145                "DELETE FROM sessions WHERE session_key = ?1",146                turso::params![session_key.as_ref()],147            )148            .await149            .map_err(|e| anyhow!(e.to_string()))?;150        Ok(())151    }152}