crates/db_views/src/site_view.rs

   1 use crate::structs::SiteView;
   2 use diesel::{result::Error, *};
   3 use lemmy_db_schema::{
   4   aggregates::structs::SiteAggregates,
   5   schema::{site, site_aggregates},
   6   source::site::Site,
   7 };
   8
   9 impl SiteView {
  10   pub fn read_local(conn: &mut PgConnection) -> Result<Self, Error> {
  11     let (mut site, counts) = site::table
  12       .inner_join(site_aggregates::table)
  13       .select((site::all_columns, site_aggregates::all_columns))
  14       .order_by(site::id)
  15       .first::<(Site, SiteAggregates)>(conn)?;
  16
  17     site.private_key = None;
  18     Ok(SiteView { site, counts })
  19   }
  20 }