+use crate::structs::SiteView;
use diesel::{result::Error, *};
-use lemmy_db_queries::{aggregates::site_aggregates::SiteAggregates, ToSafe};
use lemmy_db_schema::{
- schema::{site, site_aggregates, user_},
- source::{
- site::Site,
- user::{UserSafe, User_},
- },
+ aggregates::structs::SiteAggregates,
+ schema::{local_site, local_site_rate_limit, site, site_aggregates},
+ source::{local_site::LocalSite, local_site_rate_limit::LocalSiteRateLimit, site::Site},
};
-use serde::Serialize;
-
-#[derive(Debug, Serialize, Clone)]
-pub struct SiteView {
- pub site: Site,
- pub creator: UserSafe,
- pub counts: SiteAggregates,
-}
impl SiteView {
- pub fn read(conn: &PgConnection) -> Result<Self, Error> {
- let (site, creator, counts) = site::table
- .inner_join(user_::table)
+ pub fn read_local(conn: &mut PgConnection) -> Result<Self, Error> {
+ let (mut site, local_site, local_site_rate_limit, counts) = site::table
+ .inner_join(local_site::table)
+ .inner_join(
+ local_site_rate_limit::table.on(local_site::id.eq(local_site_rate_limit::local_site_id)),
+ )
.inner_join(site_aggregates::table)
.select((
site::all_columns,
- User_::safe_columns_tuple(),
+ local_site::all_columns,
+ local_site_rate_limit::all_columns,
site_aggregates::all_columns,
))
- .first::<(Site, UserSafe, SiteAggregates)>(conn)?;
+ .first::<(Site, LocalSite, LocalSiteRateLimit, SiteAggregates)>(conn)?;
+ site.private_key = None;
Ok(SiteView {
site,
- creator,
+ local_site,
+ local_site_rate_limit,
counts,
})
}