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
5 lines
No EOL
232 B
SQL
5 lines
No EOL
232 B
SQL
-- name: UpsertStylePosts :exec
|
|
INSERT INTO user_style_posts (user_id, platform, post_id, post_text)
|
|
VALUES ($1, $2, $3, $4)
|
|
ON CONFLICT (user_id, platform, post_id)
|
|
DO UPDATE SET post_text = EXCLUDED.post_text, created_at = now(); |