mehdi-farsi/heredoc.md

Last active April 23, 2018 12:46

Star 1 You must be signed in to star a gist
Fork 0 You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mehdi-farsi/2173db64fcad52e347e6a5972b9968e3.js"></script>
Save mehdi-farsi/2173db64fcad52e347e6a5972b9968e3 to your computer and use it in GitHub Desktop.

Download ZIP

HEREDOC: Method chaining

Raw

heredoc.md

In this example, we remove the trailing spaces and \n from our SQL query

sql = <<-SQL.gsub("\n", ' ').squish
SELECT MIN(u.popularity)
FROM users u
WHERE
  u.created_at <= #{Time.now} AND u.created_at >= #{Time.now - 7.days}
SQL

p sql

Produces

"SELECT MIN(u.popularity) FROM users u WHERE u.created_at <= 2018-04-23 21:42:00 +0200 AND u.created_at >= 2018-04-16 21:42:00 +0200"

NB: String#squish is a method provided by Ruby on Rails