Ruby 2.3 heredocs

example.rb

# frozen_string_literal: true
module Organization
  class Group
    # belongs_to :parent, class_name: 'Organization::Group'
    # has_many :children, class_name: 'Organization::Group',
    #                     foreign_key: :parent_id
    # has_many :group_memberships, dependent: :destroy
    # has_many :users, through: :group_memberships

    RECURSIVE_UP = <<SQL.freeze
WITH RECURSIVE group_tree AS (
      SELECT g.*
        FROM organization_groups g
       WHERE g.id IN (?)
    UNION
      SELECT g.*
        FROM organization_groups g
        JOIN group_tree t
          ON g.id = t.parent_id
  )

SELECT * FROM group_tree t;
SQL

    RECURSIVE_DOWN = <<~HEREDOC
      WITH RECURSIVE group_tree AS (
            SELECT g.*
              FROM organization_groups g
             WHERE g.id IN (?)
          UNION
            SELECT g.*
              FROM organization_groups g
              JOIN group_tree t
                ON g.id = t.parent_id
        )

      SELECT * FROM group_tree t;
    HEREDOC
  end
end

This helped me figure out how to freeze heredocs. Thanks!

Also thx for demo on how/where to freeze a heredoc!

👏 thanks!