committing to insanityHEADmaster

2 files changed, 113 insertions, 0 deletions

diff --git a/src/db/mod.rs b/src/db/mod.rs
new file mode 100644
index 0000000..cbee57f
--- /dev/null
+++ b/src/db/mod.rs
@@ -0,0 +1,3 @@
+pub mod pool;
+
+pub use pool::{Database, DatabaseInitError};
diff --git a/src/db/pool.rs b/src/db/pool.rs
new file mode 100644
index 0000000..4390739
--- /dev/null
+++ b/src/db/pool.rs
@@ -0,0 +1,110 @@
+// Database connection pool module
+use crate::config::DatabaseConfig;
+use anyhow::{Context, Result as AnyResult};
+use sqlx::{Error as SqlxError, MySqlPool};
+use std::sync::{
+    atomic::{AtomicBool, Ordering},
+    Arc,
+};
+
+#[derive(Debug)]
+pub enum DatabaseInitError {
+    Fatal(anyhow::Error),
+    Retryable(anyhow::Error),
+}
+
+impl DatabaseInitError {
+    fn fatal(err: anyhow::Error) -> Self {
+        Self::Fatal(err)
+    }
+
+    fn retryable(err: anyhow::Error) -> Self {
+        Self::Retryable(err)
+    }
+}
+
+#[derive(Clone)]
+pub struct Database {
+    pool: MySqlPool,
+    availability: Arc<AtomicBool>,
+}
+
+impl Database {
+    pub async fn new(config: &DatabaseConfig) -> Result<Self, DatabaseInitError> {
+        let database_url = format!(
+            "mysql://{}:{}@{}:{}/{}",
+            config.username, config.password, config.host, config.port, config.database
+        );
+
+        let pool = sqlx::mysql::MySqlPoolOptions::new()
+            .min_connections(config.min_connections)
+            .max_connections(config.max_connections)
+            .acquire_timeout(std::time::Duration::from_secs(
+                config.connection_timeout_seconds,
+            ))
+            .connect(&database_url)
+            .await
+            .map_err(|err| map_sqlx_error(err, "Failed to connect to database"))?;
+
+        // Test the connection
+        sqlx::query("SELECT 1")
+            .execute(&pool)
+            .await
+            .map_err(|err| map_sqlx_error(err, "Failed to test database connection"))?;
+
+        Ok(Database {
+            pool,
+            availability: Arc::new(AtomicBool::new(true)),
+        })
+    }
+
+    pub fn pool(&self) -> &MySqlPool {
+        &self.pool
+    }
+
+    pub fn is_available(&self) -> bool {
+        self.availability.load(Ordering::Relaxed)
+    }
+
+    pub fn mark_available(&self) {
+        self.availability.store(true, Ordering::Relaxed);
+    }
+
+    pub fn mark_unavailable(&self) {
+        self.availability.store(false, Ordering::Relaxed);
+    }
+
+    pub async fn set_current_user(&self, user_id: i32) -> AnyResult<()> {
+        sqlx::query("SET @current_user_id = ?")
+            .bind(user_id)
+            .execute(&self.pool)
+            .await
+            .context("Failed to set current user ID")?;
+
+        Ok(())
+    }
+
+    pub async fn close(&self) {
+        self.pool.close().await;
+    }
+}
+
+fn map_sqlx_error(err: SqlxError, context: &str) -> DatabaseInitError {
+    let retryable = is_retryable_sqlx_error(&err);
+    let wrapped = anyhow::Error::new(err).context(context.to_string());
+    if retryable {
+        DatabaseInitError::retryable(wrapped)
+    } else {
+        DatabaseInitError::fatal(wrapped)
+    }
+}
+
+fn is_retryable_sqlx_error(err: &SqlxError) -> bool {
+    matches!(
+        err,
+        SqlxError::Io(_)
+            | SqlxError::PoolTimedOut
+            | SqlxError::PoolClosed
+            | SqlxError::WorkerCrashed
+    )
+}