From 7075cef8f99f715fbf77a67e45bbc1e7edcada42 Mon Sep 17 00:00:00 2001 From: Eugen Rochko Date: Sat, 15 Oct 2016 16:43:52 +0200 Subject: Adding sort by node rank to follow suggestions and fallback to most influential users --- app/models/follow_suggestion.rb | 43 ++++++++++++++++++++++++++++++++++++++--- 1 file changed, 40 insertions(+), 3 deletions(-) (limited to 'app/models') diff --git a/app/models/follow_suggestion.rb b/app/models/follow_suggestion.rb index 108a948a2..4f06db69c 100644 --- a/app/models/follow_suggestion.rb +++ b/app/models/follow_suggestion.rb @@ -1,10 +1,47 @@ class FollowSuggestion def self.get(for_account_id, limit = 6) neo = Neography::Rest.new - account_ids = neo.execute_query('START a=node:account_index(Account={id}) MATCH (a)-[:follows]->(b)-[:follows]->(c) WHERE a <> c AND NOT (a)-[:follows]->(c) RETURN DISTINCT c.account_id', id: for_account_id) - Account.where(id: account_ids['data'].map(&:first) - Block.where(account_id: for_account_id).pluck(:target_account_id)).limit(limit) unless account_ids.empty? + + query = <(b)-[:follows]->(c) +WHERE a <> c +AND NOT (a)-[:follows]->(c) +RETURN DISTINCT c.account_id +ORDER BY c.nodeRank +LIMIT {limit} +END + + results = neo.execute_query(query, id: for_account_id, limit: limit) + + return fallback(for_account_id, limit) if results.empty? + + map_to_accounts(for_account_id, results) rescue Neography::NeographyError, Excon::Error::Socket => e Rails.logger.error e - [] + return [] + end + + private + + def self.fallback(for_account_id, limit) + neo = Neography::Rest.new + query = 'MATCH (a) WHERE a.account_id <> {id} RETURN a.account_id ORDER BY a.nodeRank DESC LIMIT {limit}' + results = neo.execute_query(query, id: for_account_id, limit: limit) + + map_to_accounts(for_account_id, results) + rescue Neography::NeographyError, Excon::Error::Socket => e + Rails.logger.error e + return [] + end + + def self.map_to_accounts(for_account_id, results) + return [] if results.empty? + + account_ids = results['data'].map(&:first) + blocked_ids = Block.where(account_id: for_account_id).pluck(:target_account_id) + accounts_map = Account.where(id: account_ids - blocked_ids).map { |a| [a.id, a] }.to_h + + account_ids.map { |id| accounts_map[id] }.compact end end -- cgit