README.md

Syntax highlight SQL inside Ruby <<-SQL heredocs

Embeds SQL syntax highlighting inside Ruby heredocs labeled SQL. This will also work to embed other syntaxen, e.g., HTML.

Optional PGSQL enhanced syntax:

(requires https://github.com/exu/pgsql.vim)

    syntax include @SQL syntax/pgsql.vim

Credits:

• http://blogs.perl.org/users/ovid/2011/06/syntax-highlight-your-sql-heredocs-in-vim.html
• http://stackoverflow.com/questions/6864420/change-filetype-or-other-vim-settings-blockwise-in-a-file

ruby-embedded-sql-heredocs.vim

" ~/.vim/after/syntax/ruby.vim

" Save buffer's current syntax
let s:bcs = b:current_syntax
unlet b:current_syntax

" Magic happens here.
syntax include @SQL syntax/sql.vim

" Restore buffer's current syntax
let b:current_syntax = s:bcs

" Match Ruby heredoc format (`<<` or `<<-` start tag, whitespace before end tag)
syntax region rubyHereDocSQL matchgroup=Statement start=+<<-\?SQL+ end=+^\s*SQL$+ contains=@SQL