Something went wrong. Try again.
Rust AppView - highly experimental! forked from parakeet.at/parakeet
Something went wrong. Try again.
1234567891011121314151617-- Denormalized threadgate upsert: Update posts table directly-- Threadgates control reply permissions - now stored in posts table-- Parameters: $1=actor_id, $2=post_rkey, $3=allow[], $4=hidden_actor_ids[], $5=hidden_rkeys[]-- $6=allowed_list_actor_ids[], $7=allowed_list_rkeys[]-- Note: We update the post record ($1, $2) with threadgate data-- The threadgate's own (actor_id, rkey, cid) are no longer stored separately
UPDATE postsSET threadgate_allow = $3::text[]::threadgate_rule[], threadgate_hidden_actor_ids = $4::integer[], threadgate_hidden_rkeys = $5::bigint[], threadgate_allowed_list_actor_ids = $6::integer[], threadgate_allowed_list_rkeys = $7::text[]WHERE actor_id = $1 AND rkey = $2