1 use crate::{schema::activity, Crud};
2 use diesel::{dsl::*, result::Error, *};
8 io::{Error as IoError, ErrorKind},
11 #[derive(Queryable, Identifiable, PartialEq, Debug)]
12 #[table_name = "activity"]
19 pub published: chrono::NaiveDateTime,
20 pub updated: Option<chrono::NaiveDateTime>,
23 #[derive(Insertable, AsChangeset)]
24 #[table_name = "activity"]
25 pub struct ActivityForm {
30 pub updated: Option<chrono::NaiveDateTime>,
33 impl Crud<ActivityForm> for Activity {
34 fn read(conn: &PgConnection, activity_id: i32) -> Result<Self, Error> {
35 use crate::schema::activity::dsl::*;
36 activity.find(activity_id).first::<Self>(conn)
39 fn create(conn: &PgConnection, new_activity: &ActivityForm) -> Result<Self, Error> {
40 use crate::schema::activity::dsl::*;
43 .get_result::<Self>(conn)
49 new_activity: &ActivityForm,
50 ) -> Result<Self, Error> {
51 use crate::schema::activity::dsl::*;
52 diesel::update(activity.find(activity_id))
54 .get_result::<Self>(conn)
65 ) -> Result<Self, IoError>
69 debug!("{}", serde_json::to_string_pretty(&data)?);
70 let activity_form = ActivityForm {
72 data: serde_json::to_value(&data)?,
77 let result = Activity::create(&conn, &activity_form);
80 Err(e) => Err(IoError::new(
82 format!("Failed to insert activity into database: {}", e),
87 pub fn read_from_apub_id(conn: &PgConnection, object_id: &str) -> Result<Self, Error> {
88 use crate::schema::activity::dsl::*;
89 activity.filter(ap_id.eq(object_id)).first::<Self>(conn)
96 activity::{Activity, ActivityForm},
97 tests::establish_unpooled_connection,
98 user::{UserForm, User_},
103 use serde_json::Value;
107 let conn = establish_unpooled_connection();
109 let creator_form = UserForm {
110 name: "activity_creator_pm".into(),
111 preferred_username: None,
112 password_encrypted: "nope".into(),
114 matrix_user_id: None,
122 theme: "browser".into(),
123 default_sort_type: SortType::Hot as i16,
124 default_listing_type: ListingType::Subscribed as i16,
125 lang: "browser".into(),
127 send_notifications_to_email: false,
133 last_refreshed_at: None,
136 let inserted_creator = User_::create(&conn, &creator_form).unwrap();
139 "https://enterprise.lemmy.ml/activities/delete/f1b5d57c-80f8-4e03-a615-688d552e946c";
140 let test_json: Value = serde_json::from_str(
142 "@context": "https://www.w3.org/ns/activitystreams",
143 "id": "https://enterprise.lemmy.ml/activities/delete/f1b5d57c-80f8-4e03-a615-688d552e946c",
145 "actor": "https://enterprise.lemmy.ml/u/riker",
146 "to": "https://www.w3.org/ns/activitystreams#Public",
148 "https://enterprise.lemmy.ml/c/main/"
150 "object": "https://enterprise.lemmy.ml/post/32"
154 let activity_form = ActivityForm {
155 ap_id: ap_id.to_string(),
156 data: test_json.to_owned(),
162 let inserted_activity = Activity::create(&conn, &activity_form).unwrap();
164 let expected_activity = Activity {
165 ap_id: ap_id.to_string(),
166 id: inserted_activity.id,
170 published: inserted_activity.published,
174 let read_activity = Activity::read(&conn, inserted_activity.id).unwrap();
175 let read_activity_by_apub_id = Activity::read_from_apub_id(&conn, ap_id).unwrap();
176 User_::delete(&conn, inserted_creator.id).unwrap();
178 assert_eq!(expected_activity, read_activity);
179 assert_eq!(expected_activity, read_activity_by_apub_id);
180 assert_eq!(expected_activity, inserted_activity);