Message Chaining

message_chaining.rb

[22] pry(main)> Connect::Room.find(1976).messages.pluck(:id, :prev_message_id)
  Connect::Room Load (2.0ms)  SELECT  `connect_rooms`.* FROM `connect_rooms` WHERE `connect_rooms`.`id` = 1976 LIMIT 1
   (4.7ms)  SELECT `connect_messages`.`id`, `connect_messages`.`prev_message_id` FROM `connect_messages` LEFT OUTER JOIN `connect_message_reactions` ON `connect_message_reactions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_shared_files` ON `connect_message_shared_files`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `connect_message_mentions` ON `connect_message_mentions`.`connect_message_id` = `connect_messages`.`id` LEFT OUTER JOIN `users` ON `users`.`id` = `connect_message_mentions`.`user_id` WHERE `connect_messages`.`to_id` = 1976 AND `connect_messages`.`to_type` = 'Connect::Room'
=> [[53250783, nil],
 [53250784, 53250783],
 [53250786, 53250784],
 [53252325, 53250786],
 [53252326, 53252325],
 [53252327, 53252326],
 [53252328, 53252327],
 [53252329, 53252328],
 [53252330, 53252329],
 [53252331, 53252330],
 [53252332, 53252331],
 [53252333, 53252332],
 [53252334, 53252333],
 [53252335, 53252334],
 [53252336, 53252335],
 [53252337, 53252336],
 [53252338, 53252337],
 [53252339, 53252338],
 [53252340, 53252339],
 [53252341, 53252340],
 [53252342, 53252341],
 [53252343, 53252342],
 [53252344, 53252343],
 [53252345, 53252344],
 [53252346, 53252345],
 [53252347, 53252346],
 [53252348, 53252347],
 [53252349, 53252348],
 [53252350, 53252349],
 [53252351, 53252350],
 [53252352, 53252351],
 [53252353, 53252352],
 [53252354, 53252353],
 [53252355, 53252354],
 [53252356, 53252355],
 [53252357, 53252356],
 [53252358, 53252357],
 [53252359, 53252358],
 [53252360, 53252359],
 [53252361, 53252360],
 [53252362, 53252361],
 [53252363, 53252362],
 [53252364, 53252363],
 [53252365, 53252364],
 [53252365, 53252364],
 [53252366, 53252365],
 [53252367, 53252366],
 [53252368, 53252367]]