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 " +