use crate::structs::CommunityPersonBanView;
-use diesel::{dsl::now, result::Error, BoolExpressionMethods, ExpressionMethods, QueryDsl};
+use diesel::{result::Error, ExpressionMethods, QueryDsl};
use diesel_async::RunQueryDsl;
use lemmy_db_schema::{
newtypes::{CommunityId, PersonId},
impl CommunityPersonBanView {
pub async fn get(
- pool: &DbPool,
+ pool: &mut DbPool<'_>,
from_person_id: PersonId,
from_community_id: CommunityId,
) -> Result<Self, Error> {
.select((community::all_columns, person::all_columns))
.filter(community_person_ban::community_id.eq(from_community_id))
.filter(community_person_ban::person_id.eq(from_person_id))
- .filter(
- community_person_ban::expires
- .is_null()
- .or(community_person_ban::expires.gt(now)),
- )
.order_by(community_person_ban::published)
.first::<(Community, Person)>(conn)
.await?;