From c40c306bac93950ff83e65d05eede0e5cf54edc3 Mon Sep 17 00:00:00 2001 From: re4k Date: Sat, 23 Mar 2013 22:07:25 +0900 Subject: Implement JSON API --- app/models/tweet.rb | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'app/models/tweet.rb') 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 " + -- cgit v1.2.3