#[cfg(any(feature = "db-sqlite", feature = "db-postgres", feature = "db-mysql"))]
use super::{SocialBindingService, SocialUserInfo};
#[cfg(any(feature = "db-sqlite", feature = "db-postgres", feature = "db-mysql"))]
pub(crate) mod unique_conflict_markers {
pub const SQLITE: &str = "UNIQUE constraint failed";
pub const POSTGRES: &str = "duplicate key value violates unique constraint";
pub const MYSQL: &str = "Duplicate entry";
pub const SQLSTATE_UNIQUE: &str = "23505";
}
#[cfg(any(feature = "db-sqlite", feature = "db-postgres", feature = "db-mysql"))]
impl SocialBindingService {
pub fn new(dao: std::sync::Arc<dyn crate::dao::GarrisonDao>) -> Self {
Self { dao }
}
pub async fn find_or_create(
&self,
user: &SocialUserInfo,
tenant_id: i64,
) -> crate::error::GarrisonResult<String> {
let provider_str = user.provider.as_str();
if let Some(login_id) = self
.dao
.find_social_binding(tenant_id, provider_str, &user.provider_user_id)
.await?
{
return Ok(login_id);
}
let created_at = std::time::SystemTime::now()
.duration_since(std::time::UNIX_EPOCH)
.map(|d| d.as_secs() as i64)
.unwrap_or_else(|e| {
tracing::warn!(
"system clock before UNIX_EPOCH, created_at falls back to 0: {}",
e
);
0
});
let new_login_id = uuid::Uuid::new_v4().to_string();
match self
.dao
.insert_social_binding(
tenant_id,
&new_login_id,
provider_str,
&user.provider_user_id,
user.union_id.as_deref(),
created_at,
)
.await
{
Ok(()) => Ok(new_login_id),
Err(e) => {
use unique_conflict_markers as markers;
let err_msg = e.to_string();
if err_msg.contains(markers::SQLITE)
|| err_msg.contains(markers::POSTGRES)
|| err_msg.contains(markers::MYSQL)
|| err_msg.contains(markers::SQLSTATE_UNIQUE)
{
self.dao
.find_social_binding(tenant_id, provider_str, &user.provider_user_id)
.await?
.ok_or_else(|| {
crate::error::GarrisonError::Dao(
"dao-social-binding-insert-select::".into(),
)
})
} else {
Err(e)
}
},
}
}
}