use url::Url;
impl Crud for Site {
- type Form = SiteForm;
+ type InsertForm = SiteInsertForm;
+ type UpdateForm = SiteUpdateForm;
type IdType = SiteId;
fn read(conn: &mut PgConnection, _site_id: SiteId) -> Result<Self, Error> {
use crate::schema::site::dsl::*;
site.first::<Self>(conn)
}
- fn create(conn: &mut PgConnection, new_site: &SiteForm) -> Result<Self, Error> {
+ fn create(conn: &mut PgConnection, form: &Self::InsertForm) -> Result<Self, Error> {
use crate::schema::site::dsl::*;
+
let site_ = insert_into(site)
- .values(new_site)
+ .values(form)
+ .on_conflict(actor_id)
+ .do_update()
+ .set(form)
.get_result::<Self>(conn)?;
// initialize with all languages
Ok(site_)
}
- fn update(conn: &mut PgConnection, site_id: SiteId, new_site: &SiteForm) -> Result<Self, Error> {
+ fn update(
+ conn: &mut PgConnection,
+ site_id: SiteId,
+ new_site: &Self::UpdateForm,
+ ) -> Result<Self, Error> {
use crate::schema::site::dsl::*;
diesel::update(site.find(site_id))
.set(new_site)
}
impl Site {
- pub fn read_local(conn: &mut PgConnection) -> Result<Self, Error> {
- use crate::schema::site::dsl::*;
- site.order_by(id).first::<Self>(conn)
- }
-
- pub fn upsert(conn: &mut PgConnection, site_form: &SiteForm) -> Result<Site, Error> {
- use crate::schema::site::dsl::*;
- insert_into(site)
- .values(site_form)
- .on_conflict(actor_id)
- .do_update()
- .set(site_form)
- .get_result::<Self>(conn)
- }
-
pub fn read_from_apub_id(conn: &mut PgConnection, object_id: Url) -> Result<Option<Self>, Error> {
use crate::schema::site::dsl::*;
let object_id: DbUrl = object_id.into();
)
}
+ // TODO this needs fixed
pub fn read_remote_sites(conn: &mut PgConnection) -> Result<Vec<Self>, Error> {
use crate::schema::site::dsl::*;
site.order_by(id).offset(1).get_results::<Self>(conn)