القائمة
Fetch latest tweets from X API for all wards and optionally push to production. Use when asked to "refresh tweets", "update tweets", "fetch tweets", or "sync tweets".
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
Populate ward officer data using Parallel AI search and extract. Use when asked to "enrich ward", "populate ward data", "update officers", "refresh officer data", or "import ward officers".
Extract ward officer data from PDFs or URLs and import into the governance database. Use when asked to "import officers", "extract officers from PDF", "add officer data", or "update governance data from [source]".
Scrape tweets for all MCGM wards using bird-cli and POST them to the production ingestion API. Use when asked to "scrape tweets", "update tweets", "refresh tweets", or "sync tweets to prod".
[TODO: Complete and informative explanation of what the skill does and when to use it. Include WHEN to use this skill - specific scenarios, file types, or tasks that trigger it.]
| name | refresh-tweets |
| description | Fetch latest tweets from X API for all wards and optionally push to production. Use when asked to "refresh tweets", "update tweets", "fetch tweets", or "sync tweets". |
Fetches the latest tweets from all BMC ward Twitter accounts using the X API v2 and stores them locally. Can also push tweets to the production server at mcgm.svs.io via the ingestion API.
# Via rails runner
TweetService.refresh_all
This fetches 10 recent tweets per ward from the X API and upserts them into the local DB.
curl -s -H "Authorization: Bearer $(rails runner "puts Rails.application.credentials.dig(:x, :bearer_token)")" \
"https://api.x.com/2/usage/tweets" | python3 -m json.tool
Cap is 2M tweets/month. Each refresh_all uses ~270 tweets (27 wards × 10).
After refreshing locally, push tweets to prod via the ingestion API:
# For each ward, export tweets as JSON and POST to prod
rails runner "
Ward.where.not(twitter_handle: [nil, '']).find_each do |ward|
tweets = ward.tweets.recent.limit(20)
tweets_data = tweets.map do |t|
{
id: t.tweet_id,
text: t.body,
createdAt: t.tweeted_at&.iso8601,
author: { username: t.author_username, name: t.author_name },
likeCount: t.like_count,
retweetCount: t.retweet_count,
replyCount: t.reply_count,
inReplyToUserId: t.in_reply_to_status_id
}
end
uri = URI('https://mcgm.svs.io/wards/#{ward.to_param}/tweets')
http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = true
req = Net::HTTP::Post.new(uri)
req['Content-Type'] = 'application/json'
req['Authorization'] = 'Bearer ' + ENV.fetch('TWEETS_API_KEY')
req.body = { tweets: tweets_data }.to_json
resp = http.request(req)
puts \"#{ward.ward_code}: #{resp.code} - #{resp.body.truncate(100)}\"
end
"
Check the front page to confirm fresh tweets: