1 use diesel::{result::Error, *};
3 aggregates::site_aggregates::SiteAggregates,
4 schema::{person, site, site_aggregates},
6 person::{Person, PersonSafe},
11 use serde::{Deserialize, Serialize};
13 #[derive(Debug, Serialize, Deserialize, Clone)]
16 pub creator: PersonSafe,
17 pub counts: SiteAggregates,
21 pub fn read(conn: &PgConnection) -> Result<Self, Error> {
22 let (site, creator, counts) = site::table
23 .inner_join(person::table)
24 .inner_join(site_aggregates::table)
27 Person::safe_columns_tuple(),
28 site_aggregates::all_columns,
30 .first::<(Site, PersonSafe, SiteAggregates)>(conn)?;