use crate::errors::{AuthError, Result, StorageError};
use crate::storage::core::{AuthStorage, SessionData};
use crate::tokens::AuthToken;
use sqlx::{Row, SqlitePool};
use std::time::Duration;
const PAGE: i64 = 500;
#[derive(Debug, Clone, Default, PartialEq, Eq)]
pub struct MigrationReport {
pub tokens: u64,
pub sessions: u64,
pub kv_entries: u64,
pub skipped_expired: u64,
}
fn read_err(table: &str, error: impl std::fmt::Display) -> AuthError {
AuthError::Storage(StorageError::operation_failed(format!(
"migration: reading {table} failed: {error}"
)))
}
pub async fn migrate_sqlite_to_storage<T: AuthStorage + ?Sized>(
source: &SqlitePool,
target: &T,
) -> Result<MigrationReport> {
let now = chrono::Utc::now().timestamp();
let mut report = MigrationReport::default();
let mut after = String::new();
loop {
let rows = sqlx::query(
"SELECT token_id, data, expires_at FROM auth_tokens WHERE token_id > ? ORDER BY token_id LIMIT ?",
)
.bind(&after)
.bind(PAGE)
.fetch_all(source)
.await
.map_err(|e| read_err("auth_tokens", e))?;
let Some(last) = rows.last() else { break };
after = last.get("token_id");
for row in &rows {
if row.get::<i64, _>("expires_at") < now {
report.skipped_expired += 1;
continue;
}
let data: String = row.get("data");
let token: AuthToken = serde_json::from_str(&data)
.map_err(|e| read_err("auth_tokens", format!("a token does not decode: {e}")))?;
target.store_token(&token).await?;
report.tokens += 1;
}
}
let mut after = String::new();
loop {
let rows = sqlx::query(
"SELECT session_id, data, expires_at FROM sessions WHERE session_id > ? ORDER BY session_id LIMIT ?",
)
.bind(&after)
.bind(PAGE)
.fetch_all(source)
.await
.map_err(|e| read_err("sessions", e))?;
let Some(last) = rows.last() else { break };
after = last.get("session_id");
for row in &rows {
if row.get::<i64, _>("expires_at") < now {
report.skipped_expired += 1;
continue;
}
let session_id: String = row.get("session_id");
let data: String = row.get("data");
let session: SessionData = serde_json::from_str(&data)
.map_err(|e| read_err("sessions", format!("a session does not decode: {e}")))?;
target.store_session(&session_id, &session).await?;
report.sessions += 1;
}
}
let mut after = String::new();
loop {
let rows = sqlx::query(
"SELECT key, value, expires_at FROM kv_store WHERE key > ? ORDER BY key LIMIT ?",
)
.bind(&after)
.bind(PAGE)
.fetch_all(source)
.await
.map_err(|e| read_err("kv_store", e))?;
let Some(last) = rows.last() else { break };
after = last.get("key");
for row in &rows {
let expires_at: Option<i64> = row.get("expires_at");
let ttl = match expires_at {
Some(at) if at < now => {
report.skipped_expired += 1;
continue;
}
Some(at) => Some(Duration::from_secs((at - now) as u64 + 1)),
None => None,
};
let key: String = row.get("key");
let value: Vec<u8> = row.get("value");
target.store_kv(&key, &value, ttl).await?;
report.kv_entries += 1;
}
}
Ok(report)
}