1 use crate::structs::SiteView;
2 use diesel::{result::Error, ExpressionMethods, JoinOnDsl, QueryDsl};
3 use diesel_async::RunQueryDsl;
5 aggregates::structs::SiteAggregates,
6 schema::{local_site, local_site_rate_limit, site, site_aggregates},
7 source::{local_site::LocalSite, local_site_rate_limit::LocalSiteRateLimit, site::Site},
8 utils::{get_conn, DbPool},
12 pub async fn read_local(pool: &mut DbPool<'_>) -> Result<Self, Error> {
13 let conn = &mut get_conn(pool).await?;
14 let (mut site, local_site, local_site_rate_limit, counts) = site::table
15 .inner_join(local_site::table)
17 local_site_rate_limit::table.on(local_site::id.eq(local_site_rate_limit::local_site_id)),
19 .inner_join(site_aggregates::table)
22 local_site::all_columns,
23 local_site_rate_limit::all_columns,
24 site_aggregates::all_columns,
26 .first::<(Site, LocalSite, LocalSiteRateLimit, SiteAggregates)>(conn)
29 site.private_key = None;
33 local_site_rate_limit,