use crate::error::BaseError;
use std::sync::OnceLock;
use yang_db::{Database, DatabaseConfig, QueryBuilder, Transaction};
static GLOBAL_DB: OnceLock<Database> = OnceLock::new();
pub struct GlobalDatabase;
impl GlobalDatabase {
pub async fn init(url: &str, config: DatabaseConfig) -> Result<(), BaseError> {
let db = Database::connect_with_config(url, config)
.await
.map_err(|e| BaseError::DatabaseConnectionFailed(e.to_string()))?;
GLOBAL_DB
.set(db)
.map_err(|_| BaseError::DatabaseAlreadyInitialized)?;
log::info!("全局数据库已初始化");
Ok(())
}
pub fn get() -> Result<&'static Database, BaseError> {
GLOBAL_DB.get().ok_or(BaseError::DatabaseNotInitialized)
}
pub fn table(table_name: &str) -> Result<QueryBuilder<'static>, BaseError> {
Ok(Self::get()?.table(table_name))
}
pub async fn query<T>(sql: &str) -> Result<Vec<T>, BaseError>
where
T: for<'r> sqlx::FromRow<'r, sqlx::mysql::MySqlRow> + Send + Unpin,
{
Self::get()?
.query(sql)
.await
.map_err(|e| BaseError::DatabaseQueryFailed(e.to_string()))
}
pub async fn execute(sql: &str) -> Result<u64, BaseError> {
Self::get()?
.execute(sql)
.await
.map_err(|e| BaseError::DatabaseExecuteFailed(e.to_string()))
}
pub async fn transaction() -> Result<Transaction, BaseError> {
Self::get()?
.transaction()
.await
.map_err(|e| BaseError::DatabaseTransactionFailed(e.to_string()))
}
}
#[cfg(test)]
mod tests {
use super::*;
#[test]
fn test_database_not_initialized() {
let result = GlobalDatabase::get();
assert!(result.is_err());
assert!(matches!(result, Err(BaseError::DatabaseNotInitialized)));
}
#[test]
fn test_table_not_initialized() {
let result = GlobalDatabase::table("users");
assert!(result.is_err());
assert!(matches!(result, Err(BaseError::DatabaseNotInitialized)));
}
}