Skip to content

Instantly share code, notes, and snippets.

@robertomiranda
Created December 2, 2011 16:24
Show Gist options
  • Save robertomiranda/1423831 to your computer and use it in GitHub Desktop.
Save robertomiranda/1423831 to your computer and use it in GitHub Desktop.
Finding activities Member's followers
#"SELECT "activities".* FROM "activities" WHERE "activities"."member_id" IN (SELECT "members"."id"
#FROM "members"
#INNER JOIN "member_followers" ON "member_followers"."following_member_id" = "members"."id"
#WHERE "member_followers"."follower_id" = 1491)"
def time_line
members = Member.arel_table
member_followers = MemberFollower.arel_table
condition=(member_followers[:follower_id].eq(self.id))
Activity.where(:member_id =>Member.select(members[:id]).joins(:member_followers).on(member_followers[:following_member_id].eq(members[:id])).where(condition))
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment