#[cfg(feature = "db-sqlite")]
use super::{SocialBindingService, SocialProvider, SocialUserInfo};
#[cfg(feature = "db-sqlite")]
pub(crate) fn provider_to_str(provider: &SocialProvider) -> &'static str {
match provider {
SocialProvider::Wechat => "wechat",
SocialProvider::Alipay => "alipay",
SocialProvider::WechatMiniApp => "wechat_mini_app",
}
}
#[cfg(feature = "db-sqlite")]
impl SocialBindingService {
pub fn new(pool: dbnexus::DbPool, dao: std::sync::Arc<dyn crate::dao::GarrisonDao>) -> Self {
Self { pool, dao }
}
pub async fn find_or_create(
&self,
user: &SocialUserInfo,
tenant_id: i64,
) -> crate::error::GarrisonResult<String> {
use sea_orm::{ConnectionTrait, DbBackend, Statement, Value};
let provider_str = provider_to_str(&user.provider);
let session = self.pool.get_session("admin").await.map_err(|e| {
crate::error::GarrisonError::Dao(format!("dao-social-binding-get-session::{}", e))
})?;
let conn = session.connection().map_err(|e| {
crate::error::GarrisonError::Dao(format!("dao-social-binding-get-conn::{}", e))
})?;
let stmt = Statement::from_sql_and_values(
DbBackend::Sqlite,
"SELECT login_id FROM social_bindings \
WHERE tenant_id = ? AND provider = ? AND provider_user_id = ?",
vec![
Value::BigInt(Some(tenant_id)),
Value::String(Some(provider_str.to_string())),
Value::String(Some(user.provider_user_id.clone())),
],
);
let rows = conn.query_all_raw(stmt).await.map_err(|e| {
crate::error::GarrisonError::Dao(format!("dao-social-binding-query::{}", e))
})?;
if let Some(row) = rows.into_iter().next() {
let login_id: String = row.try_get::<String>("", "login_id").map_err(|e| {
crate::error::GarrisonError::Dao(format!("dao-social-binding-login-id-read::{}", e))
})?;
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(0);
let new_login_id = uuid::Uuid::new_v4().to_string();
let stmt = Statement::from_sql_and_values(
DbBackend::Sqlite,
"INSERT INTO social_bindings \
(tenant_id, login_id, provider, provider_user_id, union_id, created_at) \
VALUES (?, ?, ?, ?, ?, ?)",
vec![
Value::BigInt(Some(tenant_id)),
Value::String(Some(new_login_id)),
Value::String(Some(provider_str.to_string())),
Value::String(Some(user.provider_user_id.clone())),
match user.union_id.clone() {
Some(s) => Value::String(Some(s)),
None => Value::String(None),
},
Value::BigInt(Some(created_at)),
],
);
match conn.execute_raw(stmt).await {
Ok(result) if result.rows_affected() == 1 => {
},
Ok(result) => {
return Err(crate::error::GarrisonError::Dao(format!(
"dao-social-binding-insert-select::{}",
result.rows_affected()
)));
},
Err(e) => {
let err_msg = e.to_string();
if err_msg.contains("UNIQUE constraint failed")
|| err_msg.contains("constraint failed")
{
} else {
return Err(crate::error::GarrisonError::Dao(format!(
"dao-social-binding-insert-select::{}",
e
)));
}
},
}
let stmt = Statement::from_sql_and_values(
DbBackend::Sqlite,
"SELECT login_id FROM social_bindings \
WHERE tenant_id = ? AND provider = ? AND provider_user_id = ?",
vec![
Value::BigInt(Some(tenant_id)),
Value::String(Some(provider_str.to_string())),
Value::String(Some(user.provider_user_id.clone())),
],
);
let rows = conn.query_all_raw(stmt).await.map_err(|e| {
crate::error::GarrisonError::Dao(format!("dao-social-binding-insert-select::{}", e))
})?;
let row = rows.into_iter().next().ok_or_else(|| {
crate::error::GarrisonError::Dao("dao-social-binding-insert-select".into())
})?;
let login_id: String = row.try_get::<String>("", "login_id").map_err(|e| {
crate::error::GarrisonError::Dao(format!("dao-social-binding-login-id-read::{}", e))
})?;
Ok(login_id)
}
}