diff options
author | Eugen Rochko <eugen@zeonfederated.com> | 2016-10-16 18:57:54 +0200 |
---|---|---|
committer | Eugen Rochko <eugen@zeonfederated.com> | 2016-10-16 19:10:16 +0200 |
commit | de1f3aab868f8d18198438c405d0852c58f34e10 (patch) | |
tree | 914ad2285da94197fccaee7b462f3d7013823707 /app/models/account.rb | |
parent | 1de2833f3045d48ab6d696a109a7a71f6a469135 (diff) |
Fix #16 - Optimize n+1 queries when checking reblogged/favourited values for status lists in API
Diffstat (limited to 'app/models/account.rb')
-rw-r--r-- | app/models/account.rb | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/app/models/account.rb b/app/models/account.rb index c1b52ea1b..8eba4da79 100644 --- a/app/models/account.rb +++ b/app/models/account.rb @@ -48,6 +48,8 @@ class Account < ApplicationRecord scope :with_followers, -> { where('(select count(f.id) from follows as f where f.target_account_id = accounts.id) > 0') } scope :expiring, -> (time) { where(subscription_expires_at: nil).or(where('subscription_expires_at < ?', time)).remote.with_followers } + scope :with_counters, -> { select('accounts.*, (select count(f.id) from follows as f where f.target_account_id = accounts.id) as followers_count, (select count(f.id) from follows as f where f.account_id = accounts.id) as following_count, (select count(s.id) from statuses as s where s.account_id = accounts.id) as statuses_count') } + def follow!(other_account) active_relationships.where(target_account: other_account).first_or_create!(target_account: other_account) end |