bdevel/erb_sql_templates

Ruby Gem to customize large SQL queries with ERB.

erb_sql_templates's Issues

Trailing newline is removed causing SQL errors

When the line ends with %> then it will not leave any white space between closing bracket and next line

Example:

INTO TABLE <%= dest_table %>
FROM

will output

INTO TABLE some_tableFROM

Resolution: Set proper trim mode with - passed to initializer

# https://ruby-doc.org/stdlib-2.4.0/libdoc/erb/rdoc/ERB.html
# https://stackoverflow.com/questions/4632879/erb-template-removing-the-trailing-line
ERB.new(File.read(filename), nil, '-')