use super::PikeStoreOperations;
use crate::pike::store::diesel::{
schema::{pike_agent, pike_agent_role_assoc},
Agent, PikeStoreError,
};
use crate::commits::MAX_COMMIT_NUM;
use crate::error::InternalError;
use crate::pike::store::diesel::models::{AgentModel, RoleAssociationModel};
use diesel::{prelude::*, result::Error::NotFound};
pub(in crate::pike::store::diesel) trait PikeStoreGetAgentOperation {
fn get_agent(
&self,
pub_key: &str,
service_id: Option<&str>,
) -> Result<Option<Agent>, PikeStoreError>;
}
#[cfg(feature = "postgres")]
impl<'a> PikeStoreGetAgentOperation for PikeStoreOperations<'a, diesel::pg::PgConnection> {
fn get_agent(
&self,
pub_key: &str,
service_id: Option<&str>,
) -> Result<Option<Agent>, PikeStoreError> {
self.conn.transaction::<_, PikeStoreError, _>(|| {
let mut query = pike_agent::table
.into_boxed()
.select(pike_agent::all_columns)
.filter(
pike_agent::public_key
.eq(&pub_key)
.and(pike_agent::end_commit_num.eq(MAX_COMMIT_NUM)),
);
if let Some(service_id) = service_id {
query = query.filter(pike_agent::service_id.eq(service_id));
} else {
query = query.filter(pike_agent::service_id.is_null());
}
let agent = query
.first::<AgentModel>(self.conn)
.map(Some)
.or_else(|err| if err == NotFound { Ok(None) } else { Err(err) })
.map_err(|err| {
PikeStoreError::InternalError(InternalError::from_source(Box::new(err)))
})?;
match agent {
Some(agent) => {
let mut query = pike_agent_role_assoc::table
.into_boxed()
.select(pike_agent_role_assoc::all_columns)
.filter(
pike_agent_role_assoc::agent_public_key
.eq(&pub_key)
.and(pike_agent_role_assoc::org_id.eq(&agent.org_id))
.and(pike_agent_role_assoc::end_commit_num.eq(MAX_COMMIT_NUM)),
);
if let Some(service_id) = service_id {
query = query.filter(pike_agent_role_assoc::service_id.eq(service_id));
} else {
query = query.filter(pike_agent_role_assoc::service_id.is_null());
}
let roles = query
.load::<RoleAssociationModel>(self.conn)
.map_err(|err| {
PikeStoreError::InternalError(InternalError::from_source(Box::new(err)))
})?;
Ok(Some(Agent::from((agent, roles))))
}
None => Ok(None),
}
})
}
}
#[cfg(feature = "sqlite")]
impl<'a> PikeStoreGetAgentOperation for PikeStoreOperations<'a, diesel::sqlite::SqliteConnection> {
fn get_agent(
&self,
pub_key: &str,
service_id: Option<&str>,
) -> Result<Option<Agent>, PikeStoreError> {
self.conn.transaction::<_, PikeStoreError, _>(|| {
let mut query = pike_agent::table
.into_boxed()
.select(pike_agent::all_columns)
.filter(
pike_agent::public_key
.eq(&pub_key)
.and(pike_agent::end_commit_num.eq(MAX_COMMIT_NUM)),
);
if let Some(service_id) = service_id {
query = query.filter(pike_agent::service_id.eq(service_id));
} else {
query = query.filter(pike_agent::service_id.is_null());
}
let agent = query
.first::<AgentModel>(self.conn)
.map(Some)
.or_else(|err| if err == NotFound { Ok(None) } else { Err(err) })
.map_err(|err| {
PikeStoreError::InternalError(InternalError::from_source(Box::new(err)))
})?;
match agent {
Some(agent) => {
let mut query = pike_agent_role_assoc::table
.into_boxed()
.select(pike_agent_role_assoc::all_columns)
.filter(
pike_agent_role_assoc::agent_public_key
.eq(&pub_key)
.and(pike_agent_role_assoc::org_id.eq(&agent.org_id))
.and(pike_agent_role_assoc::end_commit_num.eq(MAX_COMMIT_NUM)),
);
if let Some(service_id) = service_id {
query = query.filter(pike_agent_role_assoc::service_id.eq(service_id));
} else {
query = query.filter(pike_agent_role_assoc::service_id.is_null());
}
let roles = query
.load::<RoleAssociationModel>(self.conn)
.map_err(|err| {
PikeStoreError::InternalError(InternalError::from_source(Box::new(err)))
})?;
Ok(Some(Agent::from((agent, roles))))
}
None => Ok(None),
}
})
}
}