Nacorid
63f8756cc7
- migration 004: create user_style_posts with user_id, platform, post_id, post_text, created_at - queries: UpsertStylePosts, DeleteStylePosts (excludes Twitter), GetStylePosts, GetStylePostsByIDs, GetStylePostByID, PruneStylePosts - activitypub: add ID field to Post struct - server: fetchProfilePosts checks cache first, upserts on miss; buildStyleProfile deletes non-Twitter posts before rebuild; background pruner runs daily
3 lines
No EOL
149 B
SQL
3 lines
No EOL
149 B
SQL
-- name: GetStylePostsByIDs :many
|
|
SELECT post_id, post_text FROM user_style_posts
|
|
WHERE user_id = $1 AND platform = $2 AND post_id = ANY($3::text[]); |