crates/db_views_moderator/src/mod_ban_from_community_view.rs

   1 use diesel::{result::Error, *};
   2 use lemmy_db_queries::{limit_and_offset, ToSafe, ViewToVec};
   3 use lemmy_db_schema::{
   4   schema::{community, mod_ban_from_community, user_, user_alias_1},
   5   source::{
   6     community::{Community, CommunitySafe},
   7     moderator::ModBanFromCommunity,
   8     user::{UserAlias1, UserSafe, UserSafeAlias1, User_},
   9   },
  10 };
  11 use serde::Serialize;
  12
  13 #[derive(Debug, Serialize, Clone)]
  14 pub struct ModBanFromCommunityView {
  15   pub mod_ban_from_community: ModBanFromCommunity,
  16   pub moderator: UserSafe,
  17   pub community: CommunitySafe,
  18   pub banned_user: UserSafeAlias1,
  19 }
  20
  21 type ModBanFromCommunityViewTuple = (ModBanFromCommunity, UserSafe, CommunitySafe, UserSafeAlias1);
  22
  23 impl ModBanFromCommunityView {
  24   pub fn list(
  25     conn: &PgConnection,
  26     community_id: Option<i32>,
  27     mod_user_id: Option<i32>,
  28     page: Option<i64>,
  29     limit: Option<i64>,
  30   ) -> Result<Vec<Self>, Error> {
  31     let mut query = mod_ban_from_community::table
  32       .inner_join(user_::table.on(mod_ban_from_community::mod_user_id.eq(user_::id)))
  33       .inner_join(community::table)
  34       .inner_join(user_alias_1::table.on(mod_ban_from_community::other_user_id.eq(user_::id)))
  35       .select((
  36         mod_ban_from_community::all_columns,
  37         User_::safe_columns_tuple(),
  38         Community::safe_columns_tuple(),
  39         UserAlias1::safe_columns_tuple(),
  40       ))
  41       .into_boxed();
  42
  43     if let Some(mod_user_id) = mod_user_id {
  44       query = query.filter(mod_ban_from_community::mod_user_id.eq(mod_user_id));
  45     };
  46
  47     if let Some(community_id) = community_id {
  48       query = query.filter(mod_ban_from_community::community_id.eq(community_id));
  49     };
  50
  51     let (limit, offset) = limit_and_offset(page, limit);
  52
  53     let res = query
  54       .limit(limit)
  55       .offset(offset)
  56       .order_by(mod_ban_from_community::when_.desc())
  57       .load::<ModBanFromCommunityViewTuple>(conn)?;
  58
  59     Ok(Self::from_tuple_to_vec(res))
  60   }
  61 }
  62
  63 impl ViewToVec for ModBanFromCommunityView {
  64   type DbTuple = ModBanFromCommunityViewTuple;
  65   fn from_tuple_to_vec(items: Vec<Self::DbTuple>) -> Vec<Self> {
  66     items
  67       .iter()
  68       .map(|a| Self {
  69         mod_ban_from_community: a.0.to_owned(),
  70         moderator: a.1.to_owned(),
  71         community: a.2.to_owned(),
  72         banned_user: a.3.to_owned(),
  73       })
  74       .collect::<Vec<Self>>()
  75   }
  76 }