crates/db_views/src/site_view.rs

   1 use diesel::{result::Error, *};
   2 use lemmy_db_queries::{aggregates::site_aggregates::SiteAggregates, ToSafe};
   3 use lemmy_db_schema::{
   4   schema::{person, site, site_aggregates},
   5   source::{
   6     person::{Person, PersonSafe},
   7     site::Site,
   8   },
   9 };
  10 use serde::Serialize;
  11
  12 #[derive(Debug, Serialize, Clone)]
  13 pub struct SiteView {
  14   pub site: Site,
  15   pub creator: PersonSafe,
  16   pub counts: SiteAggregates,
  17 }
  18
  19 impl SiteView {
  20   pub fn read(conn: &PgConnection) -> Result<Self, Error> {
  21     let (site, creator, counts) = site::table
  22       .inner_join(person::table)
  23       .inner_join(site_aggregates::table)
  24       .select((
  25         site::all_columns,
  26         Person::safe_columns_tuple(),
  27         site_aggregates::all_columns,
  28       ))
  29       .first::<(Site, PersonSafe, SiteAggregates)>(conn)?;
  30
  31     Ok(SiteView {
  32       site,
  33       creator,
  34       counts,
  35     })
  36   }
  37 }