Skip to content

Instantly share code, notes, and snippets.

View gist:6735106
# ,o888888o. 8 8888 88 8 8888 8888888888',8888'
# . 8888 `88. 8 8888 88 8 8888 ,8',8888'
# ,8 8888 `8b 8 8888 88 8 8888 ,8',8888'
# 88 8888 `8b 8 8888 88 8 8888 ,8',8888'
# 88 8888 88 8 8888 88 8 8888 ,8',8888'
# 88 8888 `8. 88 8 8888 88 8 8888 ,8',8888'
# 88 8888 `8,8P 8 8888 88 8 8888 ,8',8888'
# `8 8888 ;8P ` 8888 ,8P 8 8888 ,8',8888'
# ` 8888 ,88'8. 8888 ,d8P 8 8888 ,8',8888'
View match_message_query.rb
# All Dec 18th matches
Matches = Match.where("published_at >= ?", “12-18-2017).reject { |m| m.user.deleted? || m.friend.deleted? }
# Filtered by the matches who haven’t seen their match:
matches.where(seen_at: nil)
# Filtered by the matches who have seen their match but didn’t message
matches.where(“seen_at IS NOT NULL”).reject { |m| m.all_messages.exists? }