does this increment comment count to 75 from 74 with trigger?

a 2nd comment today

comment activity 1

logs of the comment delete so far:

federation.2023-07-14:2023-07-14T17:52:44.073751Z DEBUG federation: apub.activities.delete.verify Url { scheme: "https", cannot_be_a_base: false, username: "", password: None, host: Some(Domain("lemmy.world")), port: None, path: "/comment/1266537", query: None, fragment: None }

federation.2023-07-14:2023-07-14T17:52:44.076617Z DEBUG federation: apub.lib.rs.insert_activity DbUrl(Url { scheme: "https", cannot_be_a_base: false, username: "", password: None, host: Some(Domain("lemmy.world")), port: None, path: "/activities/delete/5f60929a-72ad-47c6-a75c-1f258ad7556c", query: None, fragment: None }) Object {"actor": String("https://lemmy.world/u/BitOneZero"), "to": Array [String("https://www.w3.org/ns/activitystreams#Public")], "object": String("https://lemmy.world/comment/1266537"), "type": String("Delete"), "id": String("https://lemmy.world/activities/delete/5f60929a-72ad-47c6-a75c-1f258ad7556c"), "audience": String("https://bulletintree.com/c/lemmy_testing0000"), "cc": Array [String("https://bulletintree.com/c/lemmy_testing0000")]}

logs of the comment restore (undelete) so far:

federation.2023-07-14:2023-07-14T17:54:29.938688Z DEBUG federation: apub.activities.delete.verify Url { scheme: "https", cannot_be_a_base: false, username: "", password: None, host: Some(Domain("lemmy.world")), port: None, path: "/comment/1266537", query: None, fragment: None }

federation.2023-07-14:2023-07-14T17:54:29.942701Z DEBUG federation: apub.activities.delete.verify Url { scheme: "https", cannot_be_a_base: false, username: "", password: None, host: Some(Domain("lemmy.world")), port: None, path: "/comment/1266537", query: None, fragment: None }

federation.2023-07-14:2023-07-14T17:54:29.945402Z DEBUG federation: apub.lib.rs.insert_activity DbUrl(Url { scheme: "https", cannot_be_a_base: false, username: "", password: None, host: Some(Domain("lemmy.world")), port: None, path: "/activities/undo/2b03187b-8f46-4d12-b7d4-daa67b8e33c5", query: None, fragment: None }) Object {"actor": String("https://lemmy.world/u/BitOneZero"), "to": Array [String("https://www.w3.org/ns/activitystreams#Public")], "object": Object {"actor": String("https://lemmy.world/u/BitOneZero"), "to": Array [String("https://www.w3.org/ns/activitystreams#Public")], "object": String("https://lemmy.world/comment/1266537"), "type": String("Delete"), "id": String("https://lemmy.world/activities/delete/82570b01-605e-4b75-9276-eb30b7ad964d"), "audience": String("https://bulletintree.com/c/lemmy_testing0000"), "cc": Array [String("https://bulletintree.com/c/lemmy_testing0000")]}, "type": String("Undo"), "id": String("https://lemmy.world/activities/undo/2b03187b-8f46-4d12-b7d4-daa67b8e33c5"), "audience": String("https://bulletintree.com/c/lemmy_testing0000"), "cc": Array [String("https://bulletintree.com/c/lemmy_testing0000")]}

Community home database record id: https://bulletintree.com/comment/761193

Database record ID for comment on community home server: https://bulletintree.com/comment/759545

Adding even more logging now

I'm adding additional logging on home server

Takes about several minutes to recompile lemmy_server after making additions to the code, so waiting on that

Ok, the comment now shows "deleted by creator" on the community home server.

Shows up fine on home server

ok, I have heavy logging turned on now for my server bulletintree.com - so time to start testing comment delete activity.

Still not deleted here

Test comment 2023-07-13T16:17:29Z

Test comment shortly after 2023-07-13T16:02:33Z

test comment

comment on delete

test comment on test post

Commenting on this test post before I delete it

SQL: UPDATE "post" SET "featured_community" = $1 WHERE ("post"."id" = $2) RETURNING "post"."id", "post"."name", "post"."url", "post"."body", "post"."creator_id", "post"."community_id", "post"."removed", "post"."locked", "post"."published", "post"."updated", "post"."deleted", "post"."nsfw", "post"."embed_title", "post"."embed_description", "post"."thumbnail_url", "post"."ap_id", "post"."local", "post"."embed_video_url", "post"."language_id", "post"."featured_community", "post"."featured_local"