use crate::models::query_builder::core::QueryBuilder;
use crate::models::query_builder::dialects::{DatabaseBackend, QueryError};
use std::str::FromStr;
pub enum AnyDatabase {
#[cfg(feature = "db-postgres")]
Postgres(sqlx::PgPool),
#[cfg(feature = "db-mysql")]
MySQL(sqlx::MySqlPool),
#[cfg(feature = "db-sqlite")]
SQLite(sqlx::SqlitePool),
}
impl AnyDatabase {
pub async fn connect(database_url: &str) -> Result<Self, QueryError> {
#[cfg(feature = "db-postgres")]
if database_url.starts_with("postgresql://") || database_url.starts_with("postgres://") {
let pool = sqlx::PgPool::connect(database_url)
.await
.map_err(|e| QueryError::Database(e.to_string()))?;
return Ok(AnyDatabase::Postgres(pool));
}
#[cfg(feature = "db-mysql")]
if database_url.starts_with("mysql://") || database_url.starts_with("mariadb://") {
let pool = sqlx::MySqlPool::connect(database_url)
.await
.map_err(|e| QueryError::Database(e.to_string()))?;
return Ok(AnyDatabase::MySQL(pool));
}
#[cfg(feature = "db-sqlite")]
if database_url.starts_with("sqlite://") {
let options = sqlx::sqlite::SqliteConnectOptions::from_str(database_url)
.map_err(|e| QueryError::Database(e.to_string()))?
.create_if_missing(true);
let pool = sqlx::sqlite::SqlitePoolOptions::new()
.connect_with(options)
.await
.map_err(|e| QueryError::Database(e.to_string()))?;
return Ok(AnyDatabase::SQLite(pool));
}
Err(QueryError::Database(format!(
"Unsupported database URL scheme (or its driver feature is not enabled): {}",
database_url
)))
}
pub fn backend(&self) -> DatabaseBackend {
match self {
#[cfg(feature = "db-postgres")]
AnyDatabase::Postgres(_) => DatabaseBackend::Postgres,
#[cfg(feature = "db-mysql")]
AnyDatabase::MySQL(_) => DatabaseBackend::MySQL,
#[cfg(feature = "db-sqlite")]
AnyDatabase::SQLite(_) => DatabaseBackend::SQLite,
}
}
pub fn query(&self) -> QueryBuilder {
QueryBuilder::new(self.backend())
}
#[cfg(feature = "db-postgres")]
pub fn pg_pool(&self) -> Option<&sqlx::PgPool> {
match self {
AnyDatabase::Postgres(pool) => Some(pool),
#[allow(unreachable_patterns)]
_ => None,
}
}
#[cfg(feature = "db-mysql")]
pub fn mysql_pool(&self) -> Option<&sqlx::MySqlPool> {
match self {
AnyDatabase::MySQL(pool) => Some(pool),
#[allow(unreachable_patterns)]
_ => None,
}
}
#[cfg(feature = "db-sqlite")]
pub fn sqlite_pool(&self) -> Option<&sqlx::SqlitePool> {
match self {
AnyDatabase::SQLite(pool) => Some(pool),
#[allow(unreachable_patterns)]
_ => None,
}
}
}