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
148 B
SQL
5 lines
No EOL
148 B
SQL
-- name: GetStylePosts :many
|
|
SELECT post_id, post_text FROM user_style_posts
|
|
WHERE user_id = $1 AND platform = $2
|
|
ORDER BY created_at DESC
|
|
LIMIT $3; |