1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
class Tweet < ActiveRecord::Base
belongs_to :user
has_many :favorites, :dependent => :delete_all
has_many :retweets, :dependent => :delete_all
scope :recent, -> do
where("tweeted_at > ?", Time.zone.now - 3.days)
end
scope :reacted, -> do
where("favorites_count > 0 OR retweets_count > 0")
end
scope :order_by_id, -> do
order("id DESC")
end
scope :order_by_reactions, -> do
order("COALESCE(favorites_count, 0) + COALESCE(retweets_count, 0) DESC")
end
scope :discovered, -> user do
where("id IN (" +
"SELECT tweet_id FROM favorites WHERE user_id = ?" +
" UNION ALL " +
"SELECT tweet_id FROM retweets WHERE user_id = ?" +
")", user.id, user.id)
end
scope :of, -> user do
where("user_id = ?", user.id)
end
def self.cached(id)
Rails.cache.fetch("tweet/#{id}", :expires_in => 3.hour) do
where(:id => id).first
end
end
def user
User.cached(user_id)
end
end
|