diff options
author | re4k <re4k@re4k.info> | 2013-03-23 22:07:25 +0900 |
---|---|---|
committer | re4k <re4k@re4k.info> | 2013-03-23 22:07:25 +0900 |
commit | c40c306bac93950ff83e65d05eede0e5cf54edc3 (patch) | |
tree | e3022aa78f0db7359258cd56eb23fb4b1f432263 /app/models | |
parent | 80eca202c9ae3b3a6098c1654a530b1cd46326cf (diff) | |
download | aclog-c40c306bac93950ff83e65d05eede0e5cf54edc3.tar.gz |
Implement JSON API
Diffstat (limited to 'app/models')
-rw-r--r-- | app/models/tweet.rb | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/app/models/tweet.rb b/app/models/tweet.rb index 6b6311d..d20377b 100644 --- a/app/models/tweet.rb +++ b/app/models/tweet.rb @@ -19,7 +19,15 @@ class Tweet < ActiveRecord::Base order("COALESCE(favorites_count, 0) + COALESCE(retweets_count, 0) DESC") end - scope :discovered, -> user do + scope :favorited_by, -> user do + where("id IN (SELECT tweet_id FROM favorites WHERE user_id = ?)", user.id) + end + + scope :retweeted_by, -> user do + where("id IN (SELECT tweet_id FROM retweets WHERE user_id = ?)", user.id) + end + + scope :discovered_by, -> user do where("id IN (" + "SELECT tweet_id FROM favorites WHERE user_id = ?" + " UNION ALL " + |